]> Raphaël G. Git Repositories - airbundle/commitdiff
Add short to allow time detection after application form submit
authorRaphaël Gertz <git@rapsys.eu>
Mon, 23 Aug 2021 07:48:49 +0000 (09:48 +0200)
committerRaphaël Gertz <git@rapsys.eu>
Mon, 23 Aug 2021 07:48:49 +0000 (09:48 +0200)
Repository/LocationRepository.php

index 129a1763ee497dafc6b64bc339fbe20ab878fcc0..f5efbc6cdc4c0b57194827b3edbb1c468a057e11 100644 (file)
@@ -148,7 +148,7 @@ ORDER BY '.(!empty($userId)?'COUNT(a.id) DESC, ':'').'COUNT(s.id) DESC, l.id'
                ];
 
                //Set the request
                ];
 
                //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';
 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->addEntityResult('RapsysAirBundle:Location', 'l');
                $rsm->addFieldResult('l', 'id', 'id');
                $rsm->addFieldResult('l', 'title', 'title');
+               $rsm->addFieldResult('l', 'short', 'short');
 
                //Send result
                return $em
 
                //Send result
                return $em