Add location repository with fetchTranslatedLocationByDatePeriod

[airbundle] / Repository / SessionRepository.php

diff --git a/Repository/SessionRepository.php b/Repository/SessionRepository.php
index e295bfded1b385eed056d28c74c63b8f2a053447..b7471eb94e3dc591c92cde7862b238845102d964 100644 (file)
--- a/Repository/SessionRepository.php
+++ b/Repository/SessionRepository.php
@@ -31,7 +31,7 @@ class SessionRepository extends \Doctrine\ORM\EntityRepository {
         *
         * @param $period The date period
         */
-       public function findByDatePeriod($period) {
+       public function findAllByDatePeriod($period) {
                //Fetch sessions
                $ret = $this->getEntityManager()
                        ->createQuery('SELECT s FROM RapsysAirBundle:Session s WHERE s.date BETWEEN :begin AND :end')
@@ -42,4 +42,23 @@ class SessionRepository extends \Doctrine\ORM\EntityRepository {
                //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;
+       }
 }