summary |
shortlog |
log |
commit | commitdiff |
tree
raw |
patch |
inline | side by side (from parent 1:
c4fba94)
Signed-off-by: Jérôme Benoit <jerome.benoit@piment-noir.org>
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);
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];
+ }