Wolframcheg /
symfotest
| @@ 17-29 (lines=13) @@ | ||
| 14 | ||
| 15 | class ModuleUserRepository extends EntityRepository |
|
| 16 | { |
|
| 17 | public function findModuleUserFailed($user) |
|
| 18 | { |
|
| 19 | return $this->createQueryBuilder('mu') |
|
| 20 | ->select('mu, m, p') |
|
| 21 | ->join('mu.passModules', 'p') |
|
| 22 | ->join('mu.module', 'm') |
|
| 23 | ->where('mu.user = :user') |
|
| 24 | ->andWhere('mu.status = :failed') |
|
| 25 | ->setParameter('user', $user) |
|
| 26 | ->setParameter('failed', ModuleUser::STATUS_FAILED) |
|
| 27 | ->getQuery() |
|
| 28 | ->getResult(); |
|
| 29 | } |
|
| 30 | ||
| 31 | public function findModuleUserSuccess($user) |
|
| 32 | { |
|
| @@ 31-43 (lines=13) @@ | ||
| 28 | ->getResult(); |
|
| 29 | } |
|
| 30 | ||
| 31 | public function findModuleUserSuccess($user) |
|
| 32 | { |
|
| 33 | return $this->createQueryBuilder('mu') |
|
| 34 | ->select('mu, m, p') |
|
| 35 | ->join('mu.passModules', 'p') |
|
| 36 | ->join('mu.module', 'm') |
|
| 37 | ->where('mu.user = :user') |
|
| 38 | ->andWhere('mu.status = :success') |
|
| 39 | ->setParameter('user', $user) |
|
| 40 | ->setParameter('success', ModuleUser::STATUS_SUCCESS) |
|
| 41 | ->getQuery() |
|
| 42 | ->getResult(); |
|
| 43 | } |
|
| 44 | ||
| 45 | public function findModuleUserActive($user) |
|
| 46 | { |
|
| @@ 45-56 (lines=12) @@ | ||
| 42 | ->getResult(); |
|
| 43 | } |
|
| 44 | ||
| 45 | public function findModuleUserActive($user) |
|
| 46 | { |
|
| 47 | return $this->createQueryBuilder('mu') |
|
| 48 | ->select('mu, m') |
|
| 49 | ->join('mu.module', 'm') |
|
| 50 | ->where('mu.user = :user') |
|
| 51 | ->andWhere('mu.status = :active') |
|
| 52 | ->setParameter('user', $user) |
|
| 53 | ->setParameter('active', ModuleUser::STATUS_ACTIVE) |
|
| 54 | ->getQuery() |
|
| 55 | ->getResult(); |
|
| 56 | } |
|
| 57 | ||
| 58 | public function findInfoPassModules($module) |
|
| 59 | { |
|
