chamilo /
chamilo-lms
| @@ 141-167 (lines=27) @@ | ||
| 138 | * @param int $accessUrlId The access URL ID |
|
| 139 | * @return array |
|
| 140 | */ |
|
| 141 | public function searchUsersByStatus($query, $status, $accessUrlId = null) |
|
| 142 | { |
|
| 143 | $accessUrlId = intval($accessUrlId); |
|
| 144 | ||
| 145 | $queryBuilder = $this->createQueryBuilder('u'); |
|
| 146 | ||
| 147 | if ($accessUrlId > 0) { |
|
| 148 | $queryBuilder->innerJoin( |
|
| 149 | 'ChamiloCoreBundle:AccessUrlRelUser', |
|
| 150 | 'auru', |
|
| 151 | \Doctrine\ORM\Query\Expr\Join::WITH, |
|
| 152 | 'u.id = auru.userId' |
|
| 153 | ); |
|
| 154 | } |
|
| 155 | ||
| 156 | $queryBuilder->where('u.status = :status') |
|
| 157 | ->andWhere('u.username LIKE :query OR u.firstname LIKE :query OR u.lastname LIKE :query') |
|
| 158 | ->setParameter('status', $status) |
|
| 159 | ->setParameter('query', "$query%"); |
|
| 160 | ||
| 161 | if ($accessUrlId > 0) { |
|
| 162 | $queryBuilder->andWhere('auru.accessUrlId = :url') |
|
| 163 | ->setParameter(':url', $accessUrlId); |
|
| 164 | } |
|
| 165 | ||
| 166 | return $queryBuilder->getQuery()->getResult(); |
|
| 167 | } |
|
| 168 | ||
| 169 | /** |
|
| 170 | * Get the coaches for a course within a session |
|
| @@ 120-146 (lines=27) @@ | ||
| 117 | * @param int $accessUrlId The access URL ID |
|
| 118 | * @return array |
|
| 119 | */ |
|
| 120 | public function searchUsersByStatus($query, $status, $accessUrlId = null) |
|
| 121 | { |
|
| 122 | $accessUrlId = intval($accessUrlId); |
|
| 123 | ||
| 124 | $queryBuilder = $this->createQueryBuilder('u'); |
|
| 125 | ||
| 126 | if ($accessUrlId > 0) { |
|
| 127 | $queryBuilder->innerJoin( |
|
| 128 | 'ChamiloCoreBundle:AccessUrlRelUser', |
|
| 129 | 'auru', |
|
| 130 | \Doctrine\ORM\Query\Expr\Join::WITH, |
|
| 131 | 'u.id = auru.userId' |
|
| 132 | ); |
|
| 133 | } |
|
| 134 | ||
| 135 | $queryBuilder->where('u.status = :status') |
|
| 136 | ->andWhere('u.username LIKE :query OR u.firstname LIKE :query OR u.lastname LIKE :query') |
|
| 137 | ->setParameter('status', $status) |
|
| 138 | ->setParameter('query', "$query%"); |
|
| 139 | ||
| 140 | if ($accessUrlId > 0) { |
|
| 141 | $queryBuilder->andWhere('auru.accessUrlId = :url') |
|
| 142 | ->setParameter(':url', $accessUrlId); |
|
| 143 | } |
|
| 144 | ||
| 145 | return $queryBuilder->getQuery()->getResult(); |
|
| 146 | } |
|
| 147 | ||
| 148 | /** |
|
| 149 | * Get the coaches for a course within a session |
|
