private function getLastLocalisation($em, $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', $id);
- return $query->getResult()[0];
+ $result = $query->getResult();
+ if (!empty($result)) {
+ return $result[0];
+ }
}
/**