peternijssen /
packy
| @@ 60-70 (lines=11) @@ | ||
| 57 | * |
|
| 58 | * @return array |
|
| 59 | */ |
|
| 60 | public function findAllByProject(Project $project, $sortField = 'pa.name', $sortOrder = 'ASC') |
|
| 61 | { |
|
| 62 | return $this->getQueryBuilder() |
|
| 63 | ->leftJoin(self::ENTITY_ALIAS . '.project', 'p') |
|
| 64 | ->leftJoin(self::ENTITY_ALIAS . '.package', 'pa') |
|
| 65 | ->where('p = :project') |
|
| 66 | ->setParameter('project', $project) |
|
| 67 | ->orderBy($sortField, $sortOrder) |
|
| 68 | ->getQuery() |
|
| 69 | ->getResult(); |
|
| 70 | } |
|
| 71 | ||
| 72 | /** |
|
| 73 | * Find all dependencies for a certain project and manager. |
|
| @@ 82-94 (lines=13) @@ | ||
| 79 | * |
|
| 80 | * @return array |
|
| 81 | */ |
|
| 82 | public function findAllByManager(Project $project, $manager, $sortField = 'pa.name', $sortOrder = 'ASC') |
|
| 83 | { |
|
| 84 | return $this->getQueryBuilder() |
|
| 85 | ->leftJoin(self::ENTITY_ALIAS . '.project', 'p') |
|
| 86 | ->leftJoin(self::ENTITY_ALIAS . '.package', 'pa') |
|
| 87 | ->where('p = :project') |
|
| 88 | ->andWhere('pa.manager = :manager') |
|
| 89 | ->setParameter('project', $project) |
|
| 90 | ->setParameter('manager', $manager) |
|
| 91 | ->orderBy($sortField, $sortOrder) |
|
| 92 | ->getQuery() |
|
| 93 | ->getResult(); |
|
| 94 | } |
|
| 95 | ||
| 96 | /** |
|
| 97 | * get QueryBuilder. |
|
