Add location repository with fetchTranslatedLocationByDatePeriod

[airbundle] / Repository / SessionRepository.php

diff --git a/Repository/SessionRepository.php b/Repository/SessionRepository.php
index 9ffaf023e36ba8307942d0364cc92b4bfad051f4..b7471eb94e3dc591c92cde7862b238845102d964 100644 (file)
--- a/Repository/SessionRepository.php
+++ b/Repository/SessionRepository.php
@@ -42,4 +42,23 @@ class SessionRepository extends \Doctrine\ORM\EntityRepository {
                //Send result
                return $ret;
        }
                //Send result
                return $ret;
        }

+
+       /**
+        * Find sessions by location and date period
+        *
+        * @param $location The location
+        * @param $period The date period
+        */
+       public function findAllByLocationDatePeriod($location, $period) {
+               //Fetch sessions
+               $ret = $this->getEntityManager()
+                       ->createQuery('SELECT s FROM RapsysAirBundle:Session s WHERE (s.location = :location AND s.date BETWEEN :begin AND :end)')
+                       ->setParameter('location', $location)
+                       ->setParameter('begin', $period->getStartDate())
+                       ->setParameter('end', $period->getEndDate())
+                       ->getResult();
+
+               //Send result
+               return $ret;
+       }

 }
 }