chamilo /
chamilo-lms
| @@ 213-232 (lines=20) @@ | ||
| 210 | * @param User $user The user |
|
| 211 | * @return array |
|
| 212 | */ |
|
| 213 | public function getStudentBosses($user) |
|
| 214 | { |
|
| 215 | $queryBuilder = $this->createQueryBuilder('u'); |
|
| 216 | $queryBuilder |
|
| 217 | ->distinct() |
|
| 218 | ->innerJoin( |
|
| 219 | 'ChamiloCoreBundle:UserRelUser', |
|
| 220 | 'uu', |
|
| 221 | Join::WITH, |
|
| 222 | $queryBuilder->expr()->eq('u.id', 'uu.friendUserId') |
|
| 223 | ) |
|
| 224 | ->where( |
|
| 225 | $queryBuilder->expr()->eq('uu.relationType', USER_RELATION_TYPE_BOSS) |
|
| 226 | ) |
|
| 227 | ->andWhere( |
|
| 228 | $queryBuilder->expr()->eq('uu.userId', $user->getId()) |
|
| 229 | ); |
|
| 230 | ||
| 231 | return $queryBuilder->getQuery()->getResult(); |
|
| 232 | } |
|
| 233 | } |
|
| 234 | ||
| @@ 296-315 (lines=20) @@ | ||
| 293 | * @param User $user The user |
|
| 294 | * @return array |
|
| 295 | */ |
|
| 296 | public function getStudentBosses(User $user) |
|
| 297 | { |
|
| 298 | $queryBuilder = $this->createQueryBuilder('u'); |
|
| 299 | $queryBuilder |
|
| 300 | ->distinct() |
|
| 301 | ->innerJoin( |
|
| 302 | 'ChamiloCoreBundle:UserRelUser', |
|
| 303 | 'uu', |
|
| 304 | Join::WITH, |
|
| 305 | $queryBuilder->expr()->eq('u.id', 'uu.friendUserId') |
|
| 306 | ) |
|
| 307 | ->where( |
|
| 308 | $queryBuilder->expr()->eq('uu.relationType', USER_RELATION_TYPE_BOSS) |
|
| 309 | ) |
|
| 310 | ->andWhere( |
|
| 311 | $queryBuilder->expr()->eq('uu.userId', $user->getId()) |
|
| 312 | ); |
|
| 313 | ||
| 314 | return $queryBuilder->getQuery()->getResult(); |
|
| 315 | } |
|
| 316 | ||
| 317 | /** |
|
| 318 | * Get number of users in URL |
|
