From: Raphaƫl Gertz Date: Sun, 29 Nov 2020 06:02:16 +0000 (+0100) Subject: Add translated user location fetch by date period function X-Git-Tag: 0.1.4~19 X-Git-Url: https://git.rapsys.eu/airbundle/commitdiff_plain/5be05a787b5f5a2b660ceb9f68500f6c478f7b84?hp=a369baf6ea1fd299a5477a462a8cf4e5957cd982 Add translated user location fetch by date period function --- diff --git a/Repository/LocationRepository.php b/Repository/LocationRepository.php index 80e0996..7a29981 100644 --- a/Repository/LocationRepository.php +++ b/Repository/LocationRepository.php @@ -34,4 +34,33 @@ class LocationRepository extends \Doctrine\ORM\EntityRepository { //Send result return $ret; } + + /** + * Fetch translated user location with session by date period + * + * @param $translator The TranslatorInterface instance + * @param $period The date period + * @param $userId The user uid + */ + public function fetchTranslatedUserLocationByDatePeriod(TranslatorInterface $translator, $period, $userId) { + //Fetch sessions + $ret = $this->getEntityManager() + ->createQuery('SELECT l.id, l.title FROM RapsysAirBundle:Application a JOIN RapsysAirBundle:Session s JOIN RapsysAirBundle:Location l WHERE a.user = :uid AND a.session = s.id AND s.date BETWEEN :begin AND :end AND s.location = l.id GROUP BY l.id ORDER BY l.id') +#SELECT l.id, l.title FROM RapsysAirBundle:Session s JOIN RapsysAirBundle:Application a JOIN RapsysAirBundle:Location l WHERE s.date BETWEEN :begin AND :end AND s.id = a.session AND l.id = s.location GROUP BY l.id ORDER BY l.id + ->setParameter('begin', $period->getStartDate()) + ->setParameter('end', $period->getEndDate()) + ->setParameter('uid', $userId) + ->getResult(); + + //Rekey array + $ret = array_column($ret, 'title', 'id'); + + //Filter array + foreach($ret as $k => $v) { + $ret[$k] = $translator->trans($v); + } + + //Send result + return $ret; + } }