From: Raphaƫl Gertz Date: Wed, 9 Dec 2020 20:38:13 +0000 (+0100) Subject: Add findComplementBySessionId function X-Git-Tag: 0.1.6~13 X-Git-Url: https://git.rapsys.eu/airbundle/commitdiff_plain/b27f01bf7d1af9cd1bdd4b39ed1718b434b136db?hp=ec635127291810bf020cbbe32898c23c2c52189b Add findComplementBySessionId function --- diff --git a/Repository/LocationRepository.php b/Repository/LocationRepository.php index 7a29981..234d0e2 100644 --- a/Repository/LocationRepository.php +++ b/Repository/LocationRepository.php @@ -8,6 +8,25 @@ use Symfony\Component\Translation\TranslatorInterface; * LocationRepository */ class LocationRepository extends \Doctrine\ORM\EntityRepository { + /** + * Find complementary locations by session id + * + * @param $id The session id + * @return array The other locations + */ + public function findComplementBySessionId($id) { + //Fetch complement locations + $ret = $this->getEntityManager() + ->createQuery('SELECT l.id, l.title FROM RapsysAirBundle:Session s LEFT JOIN RapsysAirBundle:Session s2 WITH s2.id != s.id AND s2.slot = s.slot AND s2.date = s.date LEFT JOIN RapsysAirBundle:Location l WITH l.id != s.location AND (l.id != s2.location OR s2.location IS NULL) WHERE s.id = :sid GROUP BY l.id ORDER BY l.id') + ->setParameter('sid', $id) + ->getArrayResult(); + + //Rekey array + $ret = array_column($ret, 'id', 'title'); + + return $ret; + } + /** * Fetch translated location with session by date period *