public function match(Travel $travel)
{
$em = $this->getEntityManager();
$query = $em->createQuery('Select IDENTITY(t.user)
From SubwayBuddyUserBundle:Travel t
WHERE t.name = ?1
AND t.time LIKE ?2
AND t.user != ?3');
$query->setParameter(1, $travel->getName());
$query->setParameter(2, $travel->getTime());
$query->setParameter(3, $travel->getUser());
return $query->getResult();
}
public function match(Travel $travel)
{
$em = $this->getEntityManager();
$query = $em->createQuery('Select IDENTITY(t.user)
From SubwayBuddyUserBundle:Travel t
WHERE t.name = ?1
AND t.user != ?2
AND YEAR(t.time) = ?3
AND MONTH(t.time) = ?4
AND DAY(t.time) = ?5');
$day = $travel->getTime()->format('d');
$year = $travel->getTime()->format('Y');
$month = $travel->getTime()->format('m');
// $hour = $travel->getTime()->format('h'); TODO
$query->setParameter(1, $travel->getName());
$query->setParameter(2, $travel->getUser());
$query->setParameter(3, $year);
$query->setParameter(4, $month);
$query->setParameter(5, $day);
// $query->setParameter(6,$hour); TODO
$result = $query->getResult();
$subjects = $travel->getUser()->getSubjects();
$array = array();
foreach ($result as $user) {
$user = $this->find($user[1]);
$userSubjects = $user->getSubjects();
$match = false;
foreach ($userSubjects as $subject) {
if ($subjects->contains($subject)) {
$match = true;
}
}
if ($match) {
$array[] = $user;
}
}
return $result;
}
