X-Git-Url: https://git.piment-noir.org/?p=Project_proches_de_moi-server.git;a=blobdiff_plain;f=src%2FController%2FPersonController.php;fp=src%2FController%2FPersonController.php;h=b037f5367faffa87ec7f2435f808f241526231eb;hp=0430370f17f0b4380d0c03ed62fdffdf97e23be3;hb=787fc3b74e498cb78f516e372827790ba78920ac;hpb=8629835e06e50277f8868c19ea93f41313c16586

diff --git a/src/Controller/PersonController.php b/src/Controller/PersonController.php
index 0430370..b037f53 100644
--- a/src/Controller/PersonController.php
+++ b/src/Controller/PersonController.php
@@ -132,7 +132,10 @@ class PersonController extends FOSRestController
     {
         //TODO: Check that the authenticated user is allowed to see the localisation
         $em = $this->getDoctrine()->getManager();
-        $localisation = $em->getRepository('App:Localisation')->findOneBy(['person' => $request->get('id')]);
+
+        $query = $em->createQuery("SELECT l1 FROM App\Entity\Localisation l1 WHERE l1.person = :person and l1.timestamp = (SELECT MAX(l2.timestamp) FROM App\Entity\Localisation l2 WHERE l2.person = l1.person)");
+        $query->setParameter('person', $request->get('id'));
+        $localisation = $query->getResult();
 
         if (empty($localisation)) {
             return $this->PersonLocalisationNotFound();