From b27f01bf7d1af9cd1bdd4b39ed1718b434b136db Mon Sep 17 00:00:00 2001
From: =?utf8?q?Rapha=C3=ABl=20Gertz?= <git@rapsys.eu>
Date: Wed, 9 Dec 2020 21:38:13 +0100
Subject: [PATCH] Add findComplementBySessionId function

---
 Repository/LocationRepository.php | 19 +++++++++++++++++++
 1 file changed, 19 insertions(+)

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
 	 *
-- 
2.41.1