From: Raphaël Gertz <git@rapsys.eu>
Date: Mon, 23 Aug 2021 07:48:49 +0000 (+0200)
Subject: Add short to allow time detection after application form submit
X-Git-Tag: 0.2.0~69
X-Git-Url: https://git.rapsys.eu/.gitweb.cgi/airbundle/commitdiff_plain/6cb97165422a7e44378c82621a799c011e3a38b1

Add short to allow time detection after application form submit
---

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