From 6cb97165422a7e44378c82621a799c011e3a38b1 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Rapha=C3=ABl=20Gertz?= Date: Mon, 23 Aug 2021 09:48:49 +0200 Subject: [PATCH] Add short to allow time detection after application form submit --- Repository/LocationRepository.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/Repository/LocationRepository.php b/Repository/LocationRepository.php index 129a176..f5efbc6 100644 --- a/Repository/LocationRepository.php +++ b/Repository/LocationRepository.php @@ -148,7 +148,7 @@ ORDER BY '.(!empty($userId)?'COUNT(a.id) DESC, ':'').'COUNT(s.id) DESC, l.id' ]; //Set the request - $req = 'SELECT l.id, l.title + $req = 'SELECT l.id, l.title, l.short FROM RapsysAirBundle:UserLocation AS ul JOIN RapsysAirBundle:Location AS l ON (l.id = ul.location_id) WHERE ul.user_id = :uid'; @@ -164,6 +164,7 @@ WHERE ul.user_id = :uid'; $rsm->addEntityResult('RapsysAirBundle:Location', 'l'); $rsm->addFieldResult('l', 'id', 'id'); $rsm->addFieldResult('l', 'title', 'title'); + $rsm->addFieldResult('l', 'short', 'short'); //Send result return $em -- 2.41.1