[Assignment]Training session assignment tool shoud show base course assignements and session course assignment #3403
Description
Describe
Course assignments cannot be viewed when they are displayed as a training session.
Students can complete assignments on the learning path, however in the Assignments option they are not listed
SELECT count(w.id) as count
FROM c_student_publication w
LEFT JOIN c_student_publication_assignment a
ON (a.publication_id = w.id AND a.c_id = w.c_id)
WHERE
w.c_id = 2
AND session_id = 5 AND
active IN (0, 1) AND
parent_id = 0 AND
post_group_id = 0
ORDER BY 1 asc
LIMIT 0, 20
SELECT w.*, a.expires_on, expires_on, ends_on, enable_qualification
FROM c_student_publication w
LEFT JOIN c_student_publication_assignment a
ON (a.publication_id = w.id AND a.c_id = w.c_id)
WHERE
w.c_id = 2
AND session_id = 5 AND
active IN (0, 1) AND
parent_id = 0 AND
post_group_id = 0
ORDER BY 1 asc
LIMIT 0, 20
In the same way when the teacher goes to the assignment option nothing appears, not even the assignments created for the course.
To Reproduce
Steps to reproduce the behavior:
- Go to the Assignment area
- Create a Assignment
- Go to a Learning Path
- Create a Learning Path
- In the Learning Path associate the Assignment you've created
- Create a Training Session
- Complete the process using the course you've created
- See thats there is no Assignment in the Assignment Area.
Expected behavior
Assignments created for courses should appear when a training session is created so that teachers can evaluate students.
Desktop (please complete the following information):
- OS: Windows 10
- Browser chrome 84
**Server
- OS: Linux Ubuntu 18.04
- Version of Chamilo: 1.11.10
- Version of PHP: 7.2
Additional context
function getWorkListTeacher should have a bad query