From: Raphaël Gertz <git@rapsys.eu>
Date: Wed, 9 Dec 2020 20:38:13 +0000 (+0100)
Subject: Add findComplementBySessionId function
X-Git-Url: https://git.rapsys.eu/airbundle/commitdiff_plain/8ccedd347062ba40a104d153643cec67b9d2dc60

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
 	 *