chamilo /
chamilo-lms
| @@ 175-195 (lines=21) @@ | ||
| 172 | * @param Course $course The course |
|
| 173 | * @return \Doctrine\ORM\QueryBuilder |
|
| 174 | */ |
|
| 175 | public function getCoachesForSessionCourse(Session $session, Course $course) |
|
| 176 | { |
|
| 177 | $queryBuilder = $this->createQueryBuilder('u'); |
|
| 178 | ||
| 179 | $queryBuilder->select('u') |
|
| 180 | ->innerJoin( |
|
| 181 | 'ChamiloCoreBundle:SessionRelCourseRelUser', |
|
| 182 | 'scu', |
|
| 183 | Join::WITH, |
|
| 184 | 'scu.user = u' |
|
| 185 | ) |
|
| 186 | ->where( |
|
| 187 | $queryBuilder->expr()->andX( |
|
| 188 | $queryBuilder->expr()->eq('scu.session', $session->getId()), |
|
| 189 | $queryBuilder->expr()->eq('scu.course', $course->getId()), |
|
| 190 | $queryBuilder->expr()->eq('scu.status', SessionRelCourseRelUser::STATUS_COURSE_COACH) |
|
| 191 | ) |
|
| 192 | ); |
|
| 193 | ||
| 194 | return $queryBuilder->getQuery()->getResult(); |
|
| 195 | } |
|
| 196 | ||
| 197 | /** |
|
| 198 | * Get course user relationship based in the course_rel_user table. |
|
| @@ 154-174 (lines=21) @@ | ||
| 151 | * @param Course $course The course |
|
| 152 | * @return \Doctrine\ORM\QueryBuilder |
|
| 153 | */ |
|
| 154 | public function getCoachesForSessionCourse(Session $session, Course $course) |
|
| 155 | { |
|
| 156 | $queryBuilder = $this->createQueryBuilder('u'); |
|
| 157 | ||
| 158 | $queryBuilder->select('u') |
|
| 159 | ->innerJoin( |
|
| 160 | 'ChamiloCoreBundle:SessionRelCourseRelUser', |
|
| 161 | 'scu', |
|
| 162 | Join::WITH, |
|
| 163 | 'scu.user = u' |
|
| 164 | ) |
|
| 165 | ->where( |
|
| 166 | $queryBuilder->expr()->andX( |
|
| 167 | $queryBuilder->expr()->eq('scu.session', $session->getId()), |
|
| 168 | $queryBuilder->expr()->eq('scu.course', $course->getId()), |
|
| 169 | $queryBuilder->expr()->eq('scu.status', SessionRelCourseRelUser::STATUS_COURSE_COACH) |
|
| 170 | ) |
|
| 171 | ); |
|
| 172 | ||
| 173 | return $queryBuilder->getQuery()->getResult(); |
|
| 174 | } |
|
| 175 | ||
| 176 | /** |
|
| 177 | * Get the sessions admins for a user |
|
