chamilo /
chamilo-lms
| @@ 181-206 (lines=26) @@ | ||
| 178 | * @param \Chamilo\UserBundle\Entity\User $user The user |
|
| 179 | * @return array |
|
| 180 | */ |
|
| 181 | public function getSessionAdmins($user) |
|
| 182 | { |
|
| 183 | $queryBuilder = $this->createQueryBuilder('u'); |
|
| 184 | $queryBuilder |
|
| 185 | ->distinct() |
|
| 186 | ->innerJoin( |
|
| 187 | 'ChamiloCoreBundle:SessionRelUser', |
|
| 188 | 'su', |
|
| 189 | Join::WITH, |
|
| 190 | $queryBuilder->expr()->eq('u', 'su.user') |
|
| 191 | ) |
|
| 192 | ->innerJoin( |
|
| 193 | 'ChamiloCoreBundle:SessionRelCourseRelUser', |
|
| 194 | 'scu', |
|
| 195 | Join::WITH, |
|
| 196 | $queryBuilder->expr()->eq('su.session', 'scu.session') |
|
| 197 | ) |
|
| 198 | ->where( |
|
| 199 | $queryBuilder->expr()->eq('scu.user', $user->getId()) |
|
| 200 | ) |
|
| 201 | ->andWhere( |
|
| 202 | $queryBuilder->expr()->eq('su.relationType', SESSION_RELATION_TYPE_RRHH) |
|
| 203 | ); |
|
| 204 | ||
| 205 | return $queryBuilder->getQuery()->getResult(); |
|
| 206 | } |
|
| 207 | ||
| 208 | /** |
|
| 209 | * Get the student bosses for a user |
|
| @@ 263-289 (lines=27) @@ | ||
| 260 | * @param User $user The user |
|
| 261 | * @return array |
|
| 262 | */ |
|
| 263 | public function getSessionAdmins(User $user) |
|
| 264 | { |
|
| 265 | $queryBuilder = $this->createQueryBuilder('u'); |
|
| 266 | $queryBuilder |
|
| 267 | ->distinct() |
|
| 268 | ->innerJoin( |
|
| 269 | 'ChamiloCoreBundle:SessionRelUser', |
|
| 270 | 'su', |
|
| 271 | Join::WITH, |
|
| 272 | $queryBuilder->expr()->eq('u', 'su.user') |
|
| 273 | ) |
|
| 274 | ->innerJoin( |
|
| 275 | 'ChamiloCoreBundle:SessionRelCourseRelUser', |
|
| 276 | 'scu', |
|
| 277 | Join::WITH, |
|
| 278 | $queryBuilder->expr()->eq('su.session', 'scu.session') |
|
| 279 | ) |
|
| 280 | ->where( |
|
| 281 | $queryBuilder->expr()->eq('scu.user', $user->getId()) |
|
| 282 | ) |
|
| 283 | ->andWhere( |
|
| 284 | $queryBuilder->expr()->eq('su.relationType', SESSION_RELATION_TYPE_RRHH) |
|
| 285 | ) |
|
| 286 | ; |
|
| 287 | ||
| 288 | return $queryBuilder->getQuery()->getResult(); |
|
| 289 | } |
|
| 290 | ||
| 291 | /** |
|
| 292 | * Get the student bosses for a user |
|
