public function getReport($user, EventRepository $eventRepo)
{
$date = new \DateTime('7 days ago');
$results = $this->getEntityManager()->createQuery("SELECT h\n FROM AppBundle:History h\n WHERE h.date >= '" . $date->format("Y-m-d H:i:s") . "'\n AND h.user = '******'\n ORDER BY h.date DESC")->getResult();
$events = array();
foreach ($results as $result) {
$events = $eventRepo->fineNear($result->getLat(), $result->getLon(), false) + $events;
}
return $events;
}
