public function createdEventAction(Request $request)
{
$sesion = $this->getRequest()->getSession();
$em = $this->getDoctrine()->getManager();
$repositorio = $em->getRepository('meetmeBundle:User');
if ($request->getMethod() == 'POST') {
//$sesion->clear();
if ($sesion->has('login')) {
$login = $sesion->get('login');
$username = $login->getUsername();
$password = $login->getPassword();
$user = $repositorio->findOneBy(array('username' => $username, 'password' => $password));
$name = $user->getName();
$lastName = $user->getLastname();
$title = $request->get('title');
$eventDate = $request->get('date');
$eventHour = $request->get('hour');
$description = $request->get('description');
$place = $request->get('place');
$event = new Event();
$event->setCreatedBy($user);
$event->setType("I");
$type = $event->getType();
$event->setTitle($title);
$title = $event->getTitle();
$event->setEventDate(new \DateTime($eventDate));
$eventDate = $event->getEventDate();
$eventDateStr = date_format($eventDate, 'Y-m-d');
$event->setEventHour($eventHour);
//$eventHour = $event->getEventHour();
$event->setDescription($description);
$event->setPlace($place);
$event->setCreationDate(new \DateTime("now"));
$creationDate = $event->getCreationDate();
$searchCode = substr(md5(microtime()), rand(0, 21), 10);
$event->setSearchCode($searchCode);
$em->persist($event);
$em->flush();
/*
$limit=1;
$em = $this->getDoctrine()->getManager();
$query = $em->createQueryBuilder()
->select('e')
->from('meetmeBundle:Event', 'e')
->orderBy('e.creationDate', 'DESC')
->setMaxResults($limit)
->getQuery()
;
$events = $query->getResult();
foreach ($events as $event){
$idevent = $event->getId();
}
$user->getId();
*/
$userEvent = new UserEvent();
$userEvent->setIdevent($event);
$userEvent->setIduser($user);
$em->persist($userEvent);
$em->flush();
/*
$query = $em->createQueryBuilder()
->select('p')
->from('meetmeBundle\Entity\InvitedPerson', 'p')
->innerJoin('p.idevent','e')
->where('e.id = ?1')
->setParameter(1 , $event->getId())
->orderBy('p.invitationDate', 'DESC')
->getQuery();
*/
$query = $em->createQueryBuilder()->select('ip.id AS pid', 'ip.email')->from('meetmeBundle\\Entity\\InvitedEvent', 'ie')->innerJoin('ie.idevent', 'e')->innerJoin('ie.idinvited', 'ip')->where('e.id = ?1')->setParameter(1, $event->getId())->orderBy('ie.sendingInvitationDate', 'DESC')->getQuery();
//$repositorio = $em->getRepository('meetmeBundle:InvitedPerson');
//$invitedPersons = $repositorio->findAll();
$invitedPersons = $query->getResult();
/*
return new Response(
'Created user id: '.$user->getId()
.' and event id: '.$event->getId()
);
*/
return $this->render('meetmeBundle:twig_html:createdevent.html.twig', array('title' => $title, 'name' => $name, 'lastname' => $lastName, 'eventdate' => $eventDateStr, 'hour' => $eventHour, 'place' => $place, 'invitedPersons' => $invitedPersons, 'searchCode' => $searchCode));
}
return $this->render('meetmeBundle:twig_html:login.html.twig');
} else {
return $this->render('meetmeBundle:twig_html:login.html.twig');
}
}
