public function postReservationsAction(Request $request)
{
$em = $this->getDoctrine()->getManager();
$entity = new Reservation();
$entity->setDatetime(new \Datetime('now'));
$entity->setCourt($em->getRepository('AppBundle:Court')->find($request->query->get('courtid')));
$entity->setUser($em->getRepository('AppBundle:User')->find($request->query->get('userid')));
$em->persist($entity);
$em->flush();
}
/**
* Displays a form to create a new Reservation entity.
*
* @Route("/new", name="reservation_new")
* @Method("GET")
* @Template()
*/
public function newAction()
{
$reservation = new Reservation();
$reservation->setDepartureDate(new \DateTime());
$reservation->setArrivalDate(new \DateTime());
$client = new Client();
$reservation->setClient($client);
$form = $this->createCreateForm($reservation);
return $this->render(':Reservation:new.html.twig', array('entity' => $reservation, 'form' => $form->createView(), 'prices' => json_encode($this->getDoctrine()->getRepository('AppBundle:Transfer')->getActivePrices())));
}
/**
* @param ObjectManager $manager
* @throws \Doctrine\DBAL\DBALException
*/
protected function loadReservations(ObjectManager $manager)
{
echo "\nReservations ... ";
$stmt = $this->connection->executeQuery('SELECT * FROM reservation');
foreach ($stmt->fetchAll() as $record) {
$reservation = new Reservation();
$reservation->setClient($this->getReference('client-' . $record['client_id']));
$reservation->setDestination($this->getReference('destination-' . $record['destination_id']));
$reservation->setUniqid($record['uniqid']);
$reservation->setRoundTrip($record['round_trip']);
$reservation->setNoPax($record['no_pax']);
$reservation->setHotel($record['hotel']);
if ($record['arrival_date']) {
$reservation->setArrivalDate(\DateTime::createFromFormat('Y-m-d H:i:s', preg_replace('/\\.[0-9]+$/', '', $record['arrival_date'])));
}
$reservation->setArrivalFlightNo($record['arrival_flight_no']);
if ($record['departure_date']) {
$reservation->setDepartureDate(\DateTime::createFromFormat('Y-m-d H:i:s', preg_replace('/\\.[0-9]+$/', '', $record['departure_date'])));
}
$reservation->setDepartureFlightNo($record['departure_flight_no']);
$reservation->setPrice($record['price']);
$reservation->setComment($record['comment']);
$reservation->setStatus($record['status']);
$reservation->setPaymentDate($record['payment_date']);
$reservation->setCreated(\DateTime::createFromFormat('Y-m-d H:i:s', preg_replace('/\\.[0-9]+$/', '', $record['created_at'])));
$reservation->setUpdated(\DateTime::createFromFormat('Y-m-d H:i:s', preg_replace('/\\.[0-9]+$/', '', $record['updated_at'])));
$manager->persist($reservation);
$this->addReference("reservation-" . $record['id'], $reservation);
}
}
public function createAction($format)
{
try {
$em = $this->getDoctrine()->getManager();
$reservation = new Reservation();
$params = array();
$content = $this->get("request")->getContent();
if (!empty($content)) {
$params = json_decode($content, true);
var_dump($params);
$reservation->setCourt($params['court']);
$reservation->setDatetime(new \DateTime($params['datetime']));
$reservation->setUser($params['user']);
}
$em->persist($reservation);
$em->flush();
return $this->formatResponse("ok", $format);
} catch (Exception $ex) {
return $this->formatResponse("error", $format);
}
}
public function confirmAction(Request $request, $slug)
{
$session = $this->get('session');
$reservation = new Reservation();
$reservation->setSlug($slug);
$reservation->setPickupCity($session->get('pickupCity'));
$reservation->setReturnCity($session->get('returnCity'));
$reservation->setPickupDateTime($session->get('pickupDateTime'));
$reservation->setReturnDateTime($session->get('returnDateTime'));
$reservation->setCarId(1);
$reservation->setClientName($session->get('clientName'));
$reservation->setClientSurname($session->get('clientSurname'));
$reservation->setClientEmail($session->get('clientEmail'));
$reservation->setClientTelephone($session->get('clientPhoneNumber'));
$pickupDateTime = $reservation->getPickupDateTime()->format('d-m-Y H:i');
$returnDateTime = $reservation->getReturnDateTime()->format('d-m-Y H:i');
return $this->render('AppBundle:default:confirmation.html.twig', array('reservation' => $reservation, 'pickupDateTime' => $pickupDateTime, 'returnDateTime' => $returnDateTime));
}
<?php
require_once __DIR__ . '/../../config/bootstrap.php';
use AppBundle\Entity\Reservation;
$datetime = $_POST['datetime'];
$pistaID = $_POST['pistaID'];
$usuarioID = $_POST['usuarioID'];
//Create reservation
$reservation = new Reservation(new DateTime($datetime));
//Get court (object)
$entityManager = GetEntityManager();
$courtsRepository = $entityManager->getRepository('AppBundle\\Entity\\Court');
$court = $courtsRepository->find($pistaID);
//Add court to reservation (many to one)
$reservation->setCourt($court);
//Get user (object)
$usersRepository = $entityManager->getRepository('AppBundle\\Entity\\User');
$user = $usersRepository->find(intval($usuarioID));
//Add user to reservation (many to one)
$reservation->setUser($user);
//Add reservation to BBDD
$entityManager->persist($reservation);
$entityManager->flush();
//Redirect
header('Location: ../templates/admin/reservations.php');
/**
* @Route("/reservation/{tourDateId}", name="reservation")
*/
public function reservationAction($tourDateId, Request $request)
{
$r = new Reservation();
$r->setTourDate($this->getDoctrine()->getRepository('AppBundle:TourDate')->find($tourDateId));
$form = $this->createFormBuilder($r)->add('name')->add('email', 'email')->add('country', 'country')->add('submit', 'submit')->getForm();
$form->handleRequest($request);
if ($form->isValid()) {
$r->setStatus('pending');
$this->getDoctrine()->getEntityManager()->persist($r);
$this->getDoctrine()->getEntityManager()->flush();
$message = \Swift_Message::newInstance()->setSubject('New reservation')->setFrom('*****@*****.**')->setTo('*****@*****.**')->setBody($this->renderView('email/notification.html.twig', array('r' => $r)), 'text/html');
$this->get('mailer')->send($message);
return $this->render('default/reservation_success.html.twig', array('r' => $r));
}
return $this->render('default/reservation.html.twig', array('form' => $form->createView()));
}
/**
* Creates a form to delete a Reservation entity.
*
* @param Reservation $reservation The Reservation entity
*
* @return \Symfony\Component\Form\Form The form
*/
private function createDeleteForm(Reservation $reservation)
{
return $this->createFormBuilder()->setAction($this->generateUrl('reservation_delete', array('id' => $reservation->getId())))->setMethod('DELETE')->getForm();
}
