src/AdminBundle/Controller/BookingController.php line 1171

Open in your IDE?
  1. <?php
  3. namespace AdminBundle\Controller;
  5. use AdminBundle\Entity\Account;
  6. use AdminBundle\Entity\Booking;
  7. use AdminBundle\Entity\BookingBookingExtra;
  8. use AdminBundle\Entity\BookingCancelReason;
  9. use AdminBundle\Entity\BookingExtra;
  10. use AdminBundle\Entity\BookingHistory;
  11. use AdminBundle\Entity\BookingRequest;
  12. use AdminBundle\Entity\BookingRequestHistory;
  13. use AdminBundle\Entity\BookingViasAddress;
  14. use AdminBundle\Entity\BroadcastedDriver;
  15. use AdminBundle\Entity\Car;
  16. use AdminBundle\Entity\Driver;
  17. use AdminBundle\Entity\DriverHistory;
  18. use AdminBundle\Entity\DriverHistoryLocations;
  19. use AdminBundle\Entity\Payment;
  20. use AdminBundle\Entity\Settings;
  21. use AdminBundle\Entity\User;
  22. use AdminBundle\Helpers\MandrillManager;
  23. use AdminBundle\WebSockets\NotificationPusher;
  24. use Doctrine\ORM\QueryBuilder;
  25. use Doctrine\ORM\Query\Expr\Join;
  26. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  27. use Symfony\Component\HttpFoundation\JsonResponse;
  28. use Symfony\Component\HttpFoundation\RedirectResponse;
  29. use Symfony\Component\HttpFoundation\Request;
  30. use Symfony\Component\HttpFoundation\Response;
  31. use Symfony\Component\Routing\RouterInterface;
  33. class BookingController extends BaseController
  34. {
  35. private static $mapDashboardStatusRequest = [
  36. 'incoming' => [Booking::STATUS_NEW_BOOKING],
  37. 'pending' => [Booking::STATUS_PENDING],
  38. 'deallocated' => [
  39. Booking::STATUS_DEALLOCATED_ON_DEMAND,
  40. Booking::STATUS_DEALLOCATED_LATE_PICKUP,
  41. Booking::STATUS_DEALLOCATED_NO_LONGER_AVAILABLE,
  42. Booking::STATUS_DEALLOCATED_CAR_BROKE_DOWN,
  43. Booking::STATUS_DEALLOCATED_OFFICE,
  44. ],
  45. 'live' => [
  46. Booking::STATUS_DRIVER_ACCEPT,
  47. Booking::STATUS_ON_THE_WAY,
  48. Booking::STATUS_ARRIVED_AND_WAITING,
  49. Booking::STATUS_PASSENGER_ON_BOARD,
  50. Booking::STATUS_ABOUT_TO_DROP,
  51. ],
  52. 'completed' => [Booking::STATUS_COMPLETED],
  53. 'cancelled' => [
  54. Booking::STATUS_CANCELLED_OTHER_REASON,
  55. Booking::STATUS_CLIENT_CANCELLATION,
  56. Booking::STATUS_CLIENT_NOT_SHOW_UP,
  57. Booking::STATUS_CAR_BROKE_DOWN,
  58. Booking::STATUS_OFFICE_CANCELLATION,
  59. ],
  60. 'pending-cancelled' => [Booking::STATUS_PENDING_CANCELLATION],
  61. ];
  63. /**
  64. * Display the booking request history for this booking.
  65. *
  66. * @param string $key - the Booking key
  67. *
  68. * @return Response
  69. */
  70. public function bookingRequestHistoryAction($key, $return = false) {
  71. $history = $this->get('request.service')->getBookingHistory($key);
  72. return $this->render('@Admin/BookingRequest/history_list.html.twig', [
  73. 'history' => $history,
  74. 'return' => $return
  75. ]);
  76. }
  78. /**
  79. * Display the booking request history.
  80. *
  81. * @param string $key - the Booking key
  82. *
  83. * @return Response
  84. */
  85. public function requestHistoryAction($key) {
  86. $history = $this->get('request.service')->getHistory($key);
  87. return $this->render('@Admin/BookingRequest/history.html.twig', [
  88. 'history' => $history,
  89. 'key' => $key,
  90. 'return' => false
  91. ]);
  92. }
  94. /**
  95. * @param Request $request
  96. * @return JsonResponse
  97. */
  98. public function sendEmailAction(Request $request)
  99. {
  100. $emailNumber = $request->request->get('emailNumber');
  101. $bookingId = $request->request->get('bookingId');
  103. $mandrillManager = $this->get('mandrill.manager');
  104. $distance_unit = $this->get('doctrine')->getRepository(Settings::class)->findOneBy([
  105. 'key' => 'distance_unit',
  106. ]);
  107. $distance_unit = $distance_unit ? $distance_unit->getValue() : 'Miles';
  108. $dateFormat = 'd/m/Y';
  110. $booking = $this->getDoctrine()->getRepository(Booking::class)->findOneBy(['id' => $bookingId]);
  111. if ($booking->isCancel()) {
  112. return new JsonResponse([
  113. 'success' => false,
  114. 'status' => 400,
  115. 'message' => 'The booking was canceled',
  116. ]);
  117. }
  119. $officeEmail = $this->get('settings_repo')->getOfficeEmail();
  120. switch ($emailNumber) {
  121. case 't1':
  122. $statusEmail = $mandrillManager->sendTemplate(
  123. MandrillManager::$TEMPLATE_NEW_BOOKING_CLIENT, [],
  124. [
  125. 'subject' => 'Twelve Transfers - Journey Confirmation',
  126. 'from_email' => $officeEmail,
  127. 'to' => $mandrillManager->getToListByBooking($booking, MandrillManager::$TEMPLATE_NEW_BOOKING_CLIENT),
  128. 'global_merge_vars' => [
  129. "passenger_name" => $booking->getClientFirstName() . ' ' . $booking->getClientLastName(),
  130. "passenger_phone" => $booking->getClientPhone(),
  131. "passenger_email" => $booking->getClientEmail(),
  132. "booking_key" => $booking->getKey(),
  133. "booking_pickup_date" => $booking->getPickUpDate()->format($dateFormat),
  134. "booking_pickup_time" => $booking->getPickUpTime(),
  135. "booking_pickup_location" => $booking->getPickUpAddress(),
  136. "booking_dropoff_location" => $booking->getDestinationAddress(),
  137. "booking_vias_content" => "<ul>" . implode("", array_map(function ($address) {
  138. return "<li>$address</li>";
  139. }, $booking->getViasAsArray())) . "</ul>",
  140. "booking_passengers" => $booking->getPassengersNumber(),
  141. "booking_luggage" => $booking->getCheckinLuggage(),
  142. "booking_notes" => $booking->getNotes(),
  143. "booking_cost" => $booking->getOverridePrice(),
  144. "currency_symbol" => $this->get('currency.service')->getSystemCurrency(),
  145. "booking_duration" => $booking->getEstimatedTimePrettyFormat(),
  146. "booking_distance" => $booking->getDistanceUnit() . ' ' . $distance_unit,
  147. "booking_hand_luggage" => $booking->getHandLuggage(),
  148. "booking_car_type" => $booking->getCarType()->getName(),
  149. "premium_mg" => (!empty($booking->getPmg()) and $booking->getPmg() > 0) ? true : false,
  150. "return_premium_mg" => (!empty($booking->getReturnPmg()) and $booking->getReturnPmg() > 0) ? true : false,
  151. "return_booking" => !empty($booking->getReturnBooking()) ? true : null,
  152. "return_booking_key" => $booking->getReturnBooking() ? $booking->getReturnBooking()->getKey() : null,
  153. "return_booking_pickup_date" => $booking->getReturnBooking() ? $booking->getReturnBooking()->getPickUpDate()->format($dateFormat) : null,
  154. "return_booking_pickup_time" => $booking->getReturnBooking() ? $booking->getReturnBooking()->getPickUpTime() : null,
  155. "return_booking_pickup_location" => $booking->getReturnBooking() ? $booking->getReturnBooking()->getPickUpAddress() : null,
  156. "return_booking_dropoff_location" => $booking->getReturnBooking() ? $booking->getReturnBooking()->getDestinationAddress() : null,
  157. "return_booking_vias_content" => $booking->getReturnBooking() ? "<ul>" . implode("", array_map(function ($address) {
  158. return "<li>$address</li>";
  159. }, $booking->getReturnBooking()->getViasAsArray())) . "</ul>" : null,
  160. "return_booking_notes" => $booking->getReturnBooking() ? $booking->getReturnBooking()->getNotes() : null,
  161. "return_booking_cost" => $booking->getReturnBooking() ? $booking->getReturnBooking()->getOverridePrice() : null,
  162. "return_booking_duration" => $booking->getReturnBooking() ? $booking->getReturnBooking()->getEstimatedTimePrettyFormat() : null,
  163. "return_booking_distance" => $booking->getReturnBooking() ? $booking->getReturnBooking()->getDistanceUnit() . ' ' . $distance_unit : null,
  164. "flight_number" => !empty($booking->getFlightNumber()) ? $booking->getFlightNumber() : null,
  165. "landing_time" => $booking->getFlightLandingTime(),
  166. "mg_timeframe" => $booking->getMeetAndGreetTimePrettyFormat(),
  167. "return_flight_number" => $booking->getReturnBooking() ? $booking->getReturnBooking()->getFlightNumber() : null,
  168. "return_landing_time" => $booking->getReturnBooking() ? $booking->getReturnBooking()->getFlightLandingTime() : null,
  169. "return_mg_timeframe" => $booking->getReturnBooking() ? $booking->getReturnBooking()->getMeetAndGreetTimePrettyFormat() : null,
  170. "booking_tour_content" => "<ul>" . implode("", array_map(function ($objective) {
  171. $name = $objective['name'];
  172. //$price = $objective['price'];
  173. return "<li>$name</li>";
  174. }, $booking->getObjectivesAsArray())) . "</ul>",
  175. "return_booking_tour_content" => "<ul>" . implode("", array_map(function ($objective) {
  176. $name = $objective['name'];
  177. //$price = $objective['price'];
  178. return "<li>$name</li>";
  179. }, $booking->getReturnObjectivesAsArray())) . "</ul>",
  180. ],
  181. 'merge_language' => 'mailchimp',
  183. ]
  184. );
  185. break;
  186. case 't2':
  187. $statusEmail = $mandrillManager->sendTemplate(
  188. MandrillManager::$TEMPLATE_NEW_BOOKING_OFFICE, [],
  189. [
  190. 'subject' => 'New Booking has been Created',
  191. 'from_email' => $officeEmail,
  192. 'to' => [
  193. 'email' => $officeEmail,
  194. 'name' => 'Twelve Transfers',
  195. 'type' => 'to',
  196. ],
  197. 'global_merge_vars' => [
  198. "passenger_name" => $booking->getClientFirstName() . ' ' . $booking->getClientLastName(),
  199. "passenger_phone" => $booking->getClientPhone(),
  200. "passenger_email" => $booking->getClientEmail(),
  201. "booking_key" => $booking->getKey(),
  202. "booking_creation_date" => $booking->getBookingDate()->format($dateFormat),
  203. "booking_creation_time" => $booking->getBookingDate()->format('H:i'),
  204. "booking_origin" => 'TBD:origin', //todo: update this
  205. "booking_pickup_date" => $booking->getPickUpDate()->format($dateFormat),
  206. "booking_pickup_time" => $booking->getPickUpTime(),
  207. "booking_pickup_location" => $booking->getPickUpAddress(),
  208. "booking_dropoff_location" => $booking->getDestinationAddress(),
  209. "booking_vias_content" => "<ul>" . implode("", array_map(function ($address) {
  210. return "<li>$address</li>";
  211. }, $booking->getViasAsArray())) . "</ul>",
  212. "booking_passengers" => $booking->getPassengersNumber(),
  213. "booking_luggage" => $booking->getCheckinLuggage(),
  214. "booking_notes" => $booking->getNotes(),
  215. "booking_cost" => $booking->getOverridePrice(),
  216. "currency_symbol" => $this->get('currency.service')->getSystemCurrency(),
  217. "booking_duration" => $booking->getEstimatedTimePrettyFormat(),
  218. "booking_distance" => $booking->getDistanceUnit() . ' ' . $distance_unit,
  219. "booking_hand_luggage" => $booking->getHandLuggage(),
  220. "booking_car_type" => $booking->getCarType()->getName(),
  221. "flight_number" => !empty($booking->getFlightNumber()) ? $booking->getFlightNumber() : null,
  222. "landing_time" => $booking->getFlightLandingTime(),
  223. "mg_timeframe" => $booking->getMeetAndGreetTimePrettyFormat(),
  224. "booking_tour_content" => "<ul>" . implode("", array_map(function ($objective) {
  225. $name = $objective['name'];
  226. //$price = $objective['price'];
  227. return "<li>$name</li>";
  228. }, $booking->getObjectivesAsArray())) . "</ul>",
  229. ],
  230. 'merge_language' => 'mailchimp',
  231. ]
  232. );
  233. break;
  234. case 't3':
  235. $statusEmail = $mandrillManager->sendTemplate(
  236. MandrillManager::$TEMPLATE_BOOKING_COMPLETED, [],
  237. [
  238. 'subject' => 'Twelve Transfers - Booking Completed',
  239. 'from_email' => $officeEmail,
  240. 'to' => $mandrillManager->getToListByBooking($booking, MandrillManager::$TEMPLATE_BOOKING_COMPLETED),
  241. 'global_merge_vars' => [
  242. "passenger_name" => $booking->getClientFirstName() . ' ' . $booking->getClientLastName(),
  243. "booking_review_link" => $this->getParameter('assets_base_url') . 'review/' . $booking->getKey(),
  244. ],
  245. 'merge_language' => 'mailchimp',
  246. ]
  247. );
  248. break;
  249. case 't4':
  250. $statusEmail = $mandrillManager->sendTemplate(
  251. MandrillManager::$TEMPLATE_BOOKING_CANCELLED, [],
  252. [
  253. 'subject' => 'Twelve Transfers - Booking Cancelled',
  254. 'from_email' => $officeEmail,
  255. 'to' => $mandrillManager->getToListByBooking($booking, MandrillManager::$TEMPLATE_BOOKING_CANCELLED),
  256. 'global_merge_vars' => [
  257. "passenger_name" => $booking->getClientFirstName() . ' ' . $booking->getClientLastName(),
  258. "booking_key" => $booking->getKey(),
  259. "passenger_phone" => $booking->getClientPhone(),
  260. "passenger_email" => $booking->getClientEmail(),
  261. "booking_pickup_date" => $booking->getPickUpDate()->format($dateFormat),
  262. "booking_pickup_time" => $booking->getPickUpTime(),
  263. "booking_pickup_location" => $booking->getPickUpAddress(),
  264. "booking_dropoff_location" => $booking->getDestinationAddress(),
  265. "booking_cancel_reason" => $booking->getCancelReason(),
  266. "booking_cancel_charge" => $booking->getCancelRefund(),
  267. ],
  268. 'merge_language' => 'mailchimp',
  269. ]
  270. );
  271. break;
  272. case 't5':
  273. /** @var Driver $driver */
  274. $driver = $booking->getDriver();
  275. if (empty($driver)) {
  276. return new JsonResponse([
  277. 'success' => false,
  278. 'status' => 404,
  279. 'message' => 'The booking haven\'t a driver',
  280. ]);
  281. }
  282. /** @var Car $car */
  283. $car = $driver->getCar();
  284. if (empty($car)) {
  285. return new JsonResponse([
  286. 'success' => false,
  287. 'status' => 404,
  288. 'message' => 'The driver haven\'t assigned a car. Check if the driver have a correct setup.',
  289. ]);
  290. }
  291. $statusEmail = $mandrillManager->sendTemplate(
  292. MandrillManager::$TEMPLATE_DRIVER_ALLOCATED, [], [
  293. 'subject' => 'Twelve Transfers - Your Driver\'s Details',
  294. 'from_email' => $officeEmail,
  295. 'to' => $mandrillManager->getToListByBooking($booking, MandrillManager::$TEMPLATE_DRIVER_ALLOCATED),
  296. 'global_merge_vars' => [
  297. "passenger_name" => $booking->getClientFirstName() . ' ' . $booking->getClientLastName(),
  298. "booking_key" => $booking->getKey(),
  299. "booking_pickup_date" => $booking->getPickUpDate()->format($dateFormat),
  300. "booking_pickup_time" => $booking->getPickUpTime(),
  301. "booking_pickup_location" => $booking->getPickUpAddress(),
  302. "premium_mg" => (!empty($booking->getPmg()) and $booking->getPmg() > 0) ? true : false,
  303. "return_premium_mg" => (!empty($booking->getReturnPmg()) and $booking->getReturnPmg() > 0) ? true : false,
  304. "driver_name" => $driver->getUser()->getFirstname() . ' ' . $driver->getUser()->getLastname(),
  305. "driver_PCO" => $driver->getPublicCarriageOfficeLicenceNumber(),
  306. "driver_HACK" => $driver->getHackLicenseNumber(),
  307. "driver_SSN" => $driver->getSocialSecurityNumber(),
  308. "driver_phone" => $driver->getPhone(),
  309. "driver_vehicle_name" => $car->getMaker() . ' ' . $car->getModel(),
  310. "driver_vehicle_plate" => $car->getPlateNumber(),
  311. "driver_vehicle_PHV" => $car->getPhvLicenseNumber(),
  312. "driver_vehicle_LIMO" => $car->getLimoLicenseNumber(),
  313. "driver_picture" => $this->getParameter('assets_base_url') . (!empty($driver->getPicture()) ? $driver->getPicturePath() : 'bundles/admin/img/driver/default_driver_image.png'),
  314. "driver_vehicle_color" => $car->getColor(),
  315. ],
  316. 'merge_language' => 'mailchimp',
  317. ]
  318. );
  319. break;
  320. case 't6':
  321. /** @var Driver $driver */
  322. $driver = $booking->getDriver();
  323. if (empty($driver)) {
  324. return new JsonResponse([
  325. 'success' => false,
  326. 'status' => 404,
  327. 'message' => 'The booking haven\'t a driver',
  328. ]);
  329. }
  330. /** @var Car $car */
  331. $car = $driver->getCar();
  332. if (empty($car)) {
  333. return new JsonResponse([
  334. 'success' => false,
  335. 'status' => 404,
  336. 'message' => 'The driver haven\'t assigned a car. Check if the driver have a correct setup.',
  337. ]);
  338. }
  339. $statusEmail = $mandrillManager->sendTemplate(
  340. MandrillManager::$TEMPLATE_DRIVER_REALLOCATED, [], [
  341. 'subject' => 'Twelve Transfers - Your Driver has Changed',
  342. 'from_email' => $officeEmail,
  343. 'to' => $mandrillManager->getToListByBooking($booking, MandrillManager::$TEMPLATE_DRIVER_REALLOCATED),
  344. 'global_merge_vars' => [
  345. "passenger_name" => $booking->getClientFirstName() . ' ' . $booking->getClientLastName(),
  346. "booking_key" => $booking->getKey(),
  347. "booking_pickup_date" => $booking->getPickUpDate()->format($dateFormat),
  348. "booking_pickup_time" => $booking->getPickUpTime(),
  349. "booking_pickup_location" => $booking->getPickUpAddress(),
  350. "premium_mg" => (!empty($booking->getPmg()) and $booking->getPmg() > 0) ? true : false,
  351. "return_premium_mg" => (!empty($booking->getReturnPmg()) and $booking->getReturnPmg() > 0) ? true : false,
  352. "driver_name" => $driver->getUser()->getFirstname() . ' ' . $driver->getUser()->getLastname(),
  353. "driver_PCO" => $driver->getPublicCarriageOfficeLicenceNumber(),
  354. "driver_HACK" => $driver->getHackLicenseNumber(),
  355. "driver_SSN" => $driver->getSocialSecurityNumber(),
  356. "driver_phone" => $driver->getPhone(),
  357. "driver_vehicle_name" => $car->getMaker() . ' ' . $car->getModel(),
  358. "driver_vehicle_plate" => $car->getPlateNumber(),
  359. "driver_vehicle_PHV" => $car->getPhvLicenseNumber(),
  360. "driver_vehicle_LIMO" => $car->getLimoLicenseNumber(),
  361. "driver_picture" => $this->getParameter('assets_base_url') . (!empty($driver->getPicture()) ? $driver->getPicturePath() : 'bundles/admin/img/driver/default_driver_image.png'),
  362. "driver_vehicle_color" => $car->getColor(),
  363. ],
  364. 'merge_language' => 'mailchimp',
  365. ]
  366. );
  367. break;
  368. case 't7':
  369. /** @var Driver $driver */
  370. $driver = $booking->getDriver();
  371. if (empty($driver)) {
  372. return new JsonResponse([
  373. 'success' => false,
  374. 'status' => 404,
  375. 'message' => 'The booking haven\'t a driver',
  376. ]);
  377. }
  378. /** @var Car $car */
  379. $car = $driver->getCar();
  380. if (empty($car)) {
  381. return new JsonResponse([
  382. 'success' => false,
  383. 'status' => 404,
  384. 'message' => 'The driver haven\'t assigned a car. Check if the driver have a correct setup.',
  385. ]);
  386. }
  387. $statusEmail = $mandrillManager->sendTemplate(
  388. MandrillManager::$TEMPLATE_DRIVER_ARRIVED, [], [
  389. 'subject' => 'Twelve Transfers - Your Driver has Arrived',
  390. 'from_email' => $officeEmail,
  391. 'to' => $mandrillManager->getToListByBooking($booking, MandrillManager::$TEMPLATE_DRIVER_ARRIVED),
  392. 'global_merge_vars' => [
  393. "passenger_name" => $booking->getClientFirstName() . ' ' . $booking->getClientLastName(),
  394. "booking_key" => $booking->getKey(),
  395. "booking_pickup_date" => $booking->getPickUpDate()->format($dateFormat),
  396. "booking_pickup_time" => $booking->getPickUpTime(),
  397. "booking_pickup_location" => $booking->getPickUpAddress(),
  398. "premium_mg" => (!empty($booking->getPmg()) and $booking->getPmg() > 0) ? true : false,
  399. "return_premium_mg" => (!empty($booking->getReturnPmg()) and $booking->getReturnPmg() > 0) ? true : false,
  400. "driver_name" => $driver->getUser()->getFirstname() . ' ' . $driver->getUser()->getLastname(),
  401. "driver_PCO" => $driver->getPublicCarriageOfficeLicenceNumber(),
  402. "driver_HACK" => $driver->getHackLicenseNumber(),
  403. "driver_SSN" => $driver->getSocialSecurityNumber(),
  404. "driver_phone" => $driver->getPhone(),
  405. "driver_vehicle_name" => $car->getMaker() . ' ' . $car->getModel(),
  406. "driver_vehicle_plate" => $car->getPlateNumber(),
  407. "driver_vehicle_PHV" => $car->getPhvLicenseNumber(),
  408. "driver_vehicle_LIMO" => $car->getLimoLicenseNumber(),
  409. "driver_picture" => $this->getParameter('assets_base_url') . (!empty($driver->getPicture()) ? $driver->getPicturePath() : 'bundles/admin/img/driver/default_driver_image.png'),
  410. "driver_vehicle_color" => $car->getColor(),
  411. ],
  412. 'merge_language' => 'mailchimp',
  413. ]
  414. );
  415. break;
  416. case 't7.5':
  417. /** @var Driver $driver */
  418. $driver = $booking->getDriver();
  419. if (empty($driver)) {
  420. return new JsonResponse([
  421. 'success' => false,
  422. 'status' => 404,
  423. 'message' => 'The booking haven\'t a driver',
  424. ]);
  425. }
  426. /** @var Car $car */
  427. $car = $driver->getCar();
  428. if (empty($car)) {
  429. return new JsonResponse([
  430. 'success' => false,
  431. 'status' => 404,
  432. 'message' => 'The driver haven\'t assigned a car. Check if the driver have a correct setup.',
  433. ]);
  434. }
  435. $statusEmail = $mandrillManager->sendTemplate(
  436. MandrillManager::$TEMPLATE_DRIVER_WAITING, [], [
  437. 'subject' => 'Twelve Transfers - Your Driver is Waiting',
  438. 'from_email' => $officeEmail,
  439. 'to' => $mandrillManager->getToListByBooking($booking, MandrillManager::$TEMPLATE_DRIVER_WAITING),
  440. 'global_merge_vars' => [
  441. "passenger_name" => $booking->getClientFirstName() . ' ' . $booking->getClientLastName(),
  442. "booking_key" => $booking->getKey(),
  443. "booking_pickup_date" => $booking->getPickUpDate()->format($dateFormat),
  444. "booking_pickup_time" => $booking->getPickUpTime(),
  445. "booking_pickup_location" => $booking->getPickUpAddress(),
  446. "premium_mg" => (!empty($booking->getPmg()) and $booking->getPmg() > 0) ? true : false,
  447. "return_premium_mg" => (!empty($booking->getReturnPmg()) and $booking->getReturnPmg() > 0) ? true : false,
  448. "driver_name" => $driver->getUser()->getFirstname() . ' ' . $driver->getUser()->getLastname(),
  449. "driver_PCO" => $driver->getPublicCarriageOfficeLicenceNumber(),
  450. "driver_HACK" => $driver->getHackLicenseNumber(),
  451. "driver_SSN" => $driver->getSocialSecurityNumber(),
  452. "driver_phone" => $driver->getPhone(),
  453. "driver_vehicle_name" => $car->getMaker() . ' ' . $car->getModel(),
  454. "driver_vehicle_plate" => $car->getPlateNumber(),
  455. "driver_vehicle_PHV" => $car->getPhvLicenseNumber(),
  456. "driver_vehicle_LIMO" => $car->getLimoLicenseNumber(),
  457. "driver_picture" => $this->getParameter('assets_base_url') . (!empty($driver->getPicture()) ? $driver->getPicturePath() : 'bundles/admin/img/driver/default_driver_image.png'),
  458. "driver_vehicle_color" => $booking->getDriver()->getCar()->getColor(),
  459. ],
  460. 'merge_language' => 'mailchimp',
  461. ]
  462. );
  463. break;
  464. case 't8':
  465. $statusEmail = $mandrillManager->sendTemplate(
  466. MandrillManager::$TEMPLATE_PAYMENT_INITIAL, [],
  467. [
  468. 'subject' => 'Twelve Transfers - Payment Link',
  469. 'from_email' => $officeEmail,
  470. 'to' => $mandrillManager->getToListByBooking($booking, MandrillManager::$TEMPLATE_PAYMENT_INITIAL),
  471. 'global_merge_vars' => [
  472. "passenger_name" => $booking->getClientFirstName() . ' ' . $booking->getClientLastName(),
  473. "payment_link" => $this->get('payment.helper')->generateUrl($this->get('payment.helper')->generateToken($booking->getPayment(), $booking->getPayment()->getAmountLeft())),
  474. "booking_key" => $booking->getKey(),
  475. "booking_pickup_date" => $booking->getPickUpDate()->format($dateFormat),
  476. "booking_pickup_time" => $booking->getPickUpTime(),
  477. "booking_pickup_location" => $booking->getPickUpAddress(),
  478. "booking_dropoff_location" => $booking->getDestinationAddress(),
  479. "booking_cost" => $booking->getPayment()->getAmountLeft(),
  480. "currency_symbol" => $this->get('currency.service')->getSystemCurrency(),
  481. ],
  482. 'merge_language' => 'mailchimp',
  483. ]
  484. );
  485. break;
  486. case 't9':
  487. $statusEmail = $mandrillManager->sendTemplate(
  488. MandrillManager::$TEMPLATE_PAYMENT_REMINDER, [],
  489. [
  490. 'subject' => 'Twelve Transfers - Payment Link Reminder',
  491. 'from_email' => $officeEmail,
  492. 'to' => $mandrillManager->getToListByBooking($booking, MandrillManager::$TEMPLATE_PAYMENT_REMINDER),
  493. 'global_merge_vars' => [
  494. "passenger_name" => $booking->getClientFirstName() . ' ' . $booking->getClientLastName(),
  495. "payment_link" => $this->get('payment.helper')->generateUrl($this->get('payment.helper')->generateToken($booking->getPayment(), $booking->getPayment()->getAmountLeft())),
  496. "booking_key" => $booking->getKey(),
  497. "booking_pickup_date" => $booking->getPickUpDate()->format($dateFormat),
  498. "booking_pickup_time" => $booking->getPickUpTime(),
  499. "booking_pickup_location" => $booking->getPickUpAddress(),
  500. "booking_dropoff_location" => $booking->getDestinationAddress(),
  501. "booking_cost" => $booking->getPayment()->getAmountLeft(),
  502. "currency_symbol" => $this->get('currency.service')->getSystemCurrency(),
  503. ],
  504. 'merge_language' => 'mailchimp',
  505. ]
  506. );
  507. break;
  508. case 't10':
  509. $statusEmail = $mandrillManager->sendTemplate(
  510. MandrillManager::$TEMPLATE_PAYMENT_WARNING, [],
  511. [
  512. 'subject' => 'Twelve Transfers - WARNING - Payment Link Reminder',
  513. 'from_email' => $officeEmail,
  514. 'to' => $mandrillManager->getToListByBooking($booking, MandrillManager::$TEMPLATE_PAYMENT_WARNING),
  515. 'global_merge_vars' => [
  516. "passenger_name" => $booking->getClientFirstName() . ' ' . $booking->getClientLastName(),
  517. "payment_link" => $this->get('payment.helper')->generateUrl($this->get('payment.helper')->generateToken($booking->getPayment(), $booking->getPayment()->getAmountLeft())),
  518. "booking_key" => $booking->getKey(),
  519. "booking_pickup_date" => $booking->getPickUpDate()->format($dateFormat),
  520. "booking_pickup_time" => $booking->getPickUpTime(),
  521. "booking_pickup_location" => $booking->getPickUpAddress(),
  522. "booking_dropoff_location" => $booking->getDestinationAddress(),
  523. "booking_cost" => $booking->getPayment()->getAmountLeft(),
  524. "currency_symbol" => $this->get('currency.service')->getSystemCurrency(),
  525. ],
  526. 'merge_language' => 'mailchimp',
  527. ]
  528. );
  529. break;
  530. case 't11':
  531. $statusEmail = $mandrillManager->sendTemplate(
  532. MandrillManager::$TEMPLATE_PENDING_CANCELLED, [],
  533. [
  534. 'subject' => 'Twelve Transfers - WARNING - Pending Cancellation',
  535. 'from_email' => $officeEmail,
  536. 'to' => $mandrillManager->getToListByBooking($booking, MandrillManager::$TEMPLATE_PENDING_CANCELLED),
  537. 'global_merge_vars' => [
  538. "passenger_name" => $booking->getClientFirstName() . ' ' . $booking->getClientLastName(),
  539. "booking_key" => $booking->getKey(),
  540. "booking_pickup_date" => $booking->getPickUpDate()->format($dateFormat),
  541. "booking_pickup_time" => $booking->getPickUpTime(),
  542. "booking_pickup_location" => $booking->getPickUpAddress(),
  543. "booking_dropoff_location" => $booking->getDestinationAddress(),
  544. "booking_cost" => $booking->getPayment()->getAmountLeft(),
  545. "currency_symbol" => $this->get('currency.service')->getSystemCurrency(),
  546. "payment_link" => $this->get('payment.helper')->generateUrl($this->get('payment.helper')->generateToken($booking->getPayment(), $booking->getPayment()->getAmountLeft())),
  547. ],
  548. 'merge_language' => 'mailchimp',
  549. ]
  550. );
  551. break;
  552. case 't12':
  553. $statusEmail = $mandrillManager->sendTemplate(
  554. MandrillManager::$TEMPLATE_BOOKING_UPDATE, [],
  555. [
  556. 'subject' => 'Twelve Transfers - Booking has been Updated',
  557. 'from_email' => $officeEmail,
  558. 'to' => $mandrillManager->getToListByBooking($booking, MandrillManager::$TEMPLATE_BOOKING_UPDATE),
  559. 'global_merge_vars' => [
  560. "passenger_name" => $booking->getClientFirstName() . ' ' . $booking->getClientLastName(),
  561. "booking_key" => $booking->getKey(),
  562. "passenger_phone" => $booking->getClientPhone(),
  563. "passenger_email" => $booking->getClientEmail(),
  564. "booking_pickup_date" => $booking->getPickUpDate()->format($dateFormat),
  565. "booking_pickup_time" => $booking->getPickUpTime(),
  566. "booking_pickup_location" => $booking->getPickUpAddress(),
  567. "booking_dropoff_location" => $booking->getDestinationAddress(),
  568. "booking_vias_content" => "<ul>" . implode("", array_map(function ($address) {
  569. return "<li>$address</li>";
  570. }, $booking->getViasAsArray())) . "</ul>",
  571. "booking_passengers" => $booking->getPassengersNumber(),
  572. "booking_luggage" => $booking->getCheckinLuggage(),
  573. "booking_notes" => $booking->getNotes(),
  574. "booking_cost" => $booking->getPayment()->getAmount(),
  575. "premium_mg" => (!empty($booking->getPmg()) and $booking->getPmg() > 0) ? true : false,
  576. "return_premium_mg" => (!empty($booking->getReturnPmg()) and $booking->getReturnPmg() > 0) ? true : false,
  577. "currency_symbol" => $this->get('currency.service')->getSystemCurrency(),
  578. "booking_duration" => $booking->getEstimatedTimePrettyFormat(),
  579. "booking_distance" => $booking->getDistanceUnit() . ' ' . $distance_unit,
  580. "booking_hand_luggage" => $booking->getHandLuggage(),
  581. "booking_car_type" => $booking->getCarType()->getName(),
  582. "flight_number" => !empty($booking->getFlightNumber()) ? $booking->getFlightNumber() : null,
  583. "landing_time" => $booking->getFlightLandingTime(),
  584. "mg_timeframe" => $booking->getMeetAndGreetTimePrettyFormat(),
  585. "booking_tour_content" => "<ul>" . implode("", array_map(function ($objective) {
  586. $name = $objective['name'];
  587. //$price = $objective['price'];
  588. return "<li>$name</li>";
  589. }, $booking->getObjectivesAsArray())) . "</ul>",
  590. ],
  591. 'merge_language' => 'mailchimp',
  592. ]
  593. );
  594. break;
  595. case 't13':
  596. $statusEmail = $mandrillManager->sendTemplate(
  597. MandrillManager::$TEMPLATE_BOOKING_RECONFIRM, [],
  598. [
  599. 'subject' => 'Twelve Transfers - IMPORTANT - Please Confirm your Booking',
  600. 'from_email' => $officeEmail,
  601. 'to' => $mandrillManager->getToListByBooking($booking, MandrillManager::$TEMPLATE_BOOKING_RECONFIRM),
  602. 'global_merge_vars' => [
  603. "passenger_name" => $booking->getClientFirstName() . ' ' . $booking->getClientLastName(),
  604. "booking_key" => $booking->getKey(),
  605. "passenger_phone" => $booking->getClientPhone(),
  606. "passenger_email" => $booking->getClientEmail(),
  607. "booking_pickup_date" => $booking->getPickUpDate()->format($dateFormat),
  608. "booking_pickup_time" => $booking->getPickUpTime(),
  609. "booking_pickup_location" => $booking->getPickUpAddress(),
  610. "booking_dropoff_location" => $booking->getDestinationAddress(),
  611. "booking_vias_content" => "<ul>" . implode("", array_map(function ($address) {
  612. return "<li>$address</li>";
  613. }, $booking->getViasAsArray())) . "</ul>",
  614. "booking_passengers" => $booking->getPassengersNumber(),
  615. "booking_luggage" => $booking->getCheckinLuggage(),
  616. "booking_notes" => $booking->getNotes(),
  617. "booking_cost" => $booking->getPayment()->getAmount(),
  618. "premium_mg" => (!empty($booking->getPmg()) and $booking->getPmg() > 0) ? true : false,
  619. "return_premium_mg" => (!empty($booking->getReturnPmg()) and $booking->getReturnPmg() > 0) ? true : false,
  620. "currency_symbol" => $this->get('currency.service')->getSystemCurrency(),
  621. "booking_duration" => $booking->getEstimatedTimePrettyFormat(),
  622. "booking_distance" => $booking->getDistanceUnit() . ' ' . $distance_unit,
  623. "booking_hand_luggage" => $booking->getHandLuggage(),
  624. "booking_car_type" => $booking->getCarType()->getName(),
  625. "flight_number" => !empty($booking->getFlightNumber()) ? $booking->getFlightNumber() : null,
  626. "landing_time" => $booking->getFlightLandingTime(),
  627. "mg_timeframe" => $booking->getMeetAndGreetTimePrettyFormat(),
  628. "booking_tour_content" => "<ul>" . implode("", array_map(function ($objective) {
  629. $name = $objective['name'];
  630. //$price = $objective['price'];
  631. return "<li>$name</li>";
  632. }, $booking->getObjectivesAsArray())) . "</ul>",
  633. ],
  634. 'merge_language' => 'mailchimp',
  635. ]
  636. );
  637. break;
  638. case 't14':
  639. $statusEmail = $mandrillManager->sendTemplate(
  640. MandrillManager::$TEMPLATE_BOOKING_APPROACHING, [],
  641. [
  642. 'subject' => 'Twelve Transfers - Journey Reminder',
  643. 'from_email' => $officeEmail,
  644. 'to' => $mandrillManager->getToListByBooking($booking, MandrillManager::$TEMPLATE_BOOKING_APPROACHING),
  645. 'global_merge_vars' => [
  646. "passenger_name" => $booking->getClientFirstName() . ' ' . $booking->getClientLastName(),
  647. "booking_key" => $booking->getKey(),
  648. "passenger_phone" => $booking->getClientPhone(),
  649. "passenger_email" => $booking->getClientEmail(),
  650. "booking_pickup_date" => $booking->getPickUpDate()->format($dateFormat),
  651. "booking_pickup_time" => $booking->getPickUpTime(),
  652. "booking_pickup_location" => $booking->getPickUpAddress(),
  653. "booking_dropoff_location" => $booking->getDestinationAddress(),
  654. "booking_vias_content" => "<ul>" . implode("", array_map(function ($address) {
  655. return "<li>$address</li>";
  656. }, $booking->getViasAsArray())) . "</ul>",
  657. "booking_passengers" => $booking->getPassengersNumber(),
  658. "booking_luggage" => $booking->getCheckinLuggage(),
  659. "booking_notes" => $booking->getNotes(),
  660. "booking_cost" => $booking->getPayment()->getAmount(),
  661. "premium_mg" => (!empty($booking->getPmg()) and $booking->getPmg() > 0) ? true : false,
  662. "return_premium_mg" => (!empty($booking->getReturnPmg()) and $booking->getReturnPmg() > 0) ? true : false,
  663. "currency_symbol" => $this->get('currency.service')->getSystemCurrency(),
  664. "booking_duration" => $booking->getEstimatedTimePrettyFormat(),
  665. "booking_distance" => $booking->getDistanceUnit() . ' ' . $distance_unit,
  666. "booking_hand_luggage" => $booking->getHandLuggage(),
  667. "booking_car_type" => $booking->getCarType()->getName(),
  668. "flight_number" => !empty($booking->getFlightNumber()) ? $booking->getFlightNumber() : null,
  669. "landing_time" => $booking->getFlightLandingTime(),
  670. "mg_timeframe" => $booking->getMeetAndGreetTimePrettyFormat(),
  671. "booking_tour_content" => "<ul>" . implode("", array_map(function ($objective) {
  672. $name = $objective['name'];
  673. //$price = $objective['price'];
  674. return "<li>$name</li>";
  675. }, $booking->getObjectivesAsArray())) . "</ul>",
  676. ],
  677. 'merge_language' => 'mailchimp',
  678. ]
  679. );
  680. break;
  681. case 't15':
  682. /** @var Driver $driver */
  683. $driver = $booking->getDriver();
  684. if (empty($driver)) {
  685. return new JsonResponse([
  686. 'success' => false,
  687. 'status' => 404,
  688. 'message' => 'The booking haven\'t a driver',
  689. ]);
  690. }
  691. $statusEmail = $mandrillManager->sendTemplate(
  692. MandrillManager::$TEMPLATE_DRIVER_REGISTERED, [],
  693. [
  694. 'subject' => 'Twelve Transfers - Welcome',
  695. 'from_email' => $officeEmail,
  696. 'to' => $mandrillManager->getToListByBooking($booking, MandrillManager::$TEMPLATE_PENDING_BOOKING),
  697. 'global_merge_vars' => [
  698. "driver_name" => $driver->getUser()->getFirstname() . ' ' . $driver->getUser()->getLastname(),
  699. "driver_ID" => $driver->getInternalName(),
  700. "driver_PCO" => $driver->getPublicCarriageOfficeLicenceNumber(),
  701. "driver_HACK" => $driver->getHackLicenseNumber(),
  702. "driver_SSN" => $driver->getSocialSecurityNumber(),
  703. "driver_phone" => $driver->getPhone(),
  704. "driver_email" => $driver->getUser()->getEmail(),
  705. "driver_vehicle_name" => $driver->getCar()->getMaker() . ' ' . $driver->getCar()->getModel(),
  706. "driver_vehicle_plate" => $driver->getCar()->getPlateNumber(),
  707. "driver_vehicle_PHV" => $driver->getCar()->getPhvLicenseNumber(),
  708. "driver_vehicle_LIMO" => $driver->getCar()->getLimoLicenseNumber(),
  709. "driver_vehicle_color" => $driver->getCar()->getColor(),
  710. ],
  711. 'merge_language' => 'mailchimp',
  712. ]
  713. );
  714. break;
  715. case 't16':
  716. $statusEmail = $mandrillManager->sendTemplate(
  717. MandrillManager::$TEMPLATE_PENDING_BOOKING, [],
  718. [
  719. 'subject' => 'Twelve Transfers - Booking Attempt',
  720. 'from_email' => $officeEmail,
  721. 'to' => $mandrillManager->getToListByBooking($booking, MandrillManager::$TEMPLATE_PENDING_BOOKING),
  722. 'global_merge_vars' => [
  723. "passenger_name" => $booking->getClientFirstName() . ' ' . $booking->getClientLastName(),
  724. "booking_key" => $booking->getKey(),
  725. "payment_link" => $this->get('payment.helper')->generateUrl($this->get('payment.helper')->generateToken($booking->getPayment(), $booking->getPayment()->getAmountLeft())),
  726. ],
  727. 'merge_language' => 'mailchimp',
  728. ]
  729. );
  730. break;
  732. case 't25':
  733. $statusEmail = $mandrillManager->sendTemplate(
  734. MandrillManager::$TEMPLATE_SHUTTLE_ENQUIRY, [],
  735. [
  736. 'subject' => 'Twelve Transfers - Lower Rates with our Shuttle Option',
  737. 'from_email' => $officeEmail,
  738. 'to' => $mandrillManager->getToListByBooking($booking, MandrillManager::$TEMPLATE_SHUTTLE_ENQUIRY),
  739. 'global_merge_vars' => [
  740. "passenger_name" => $booking->getClientFirstName() . ' ' . $booking->getClientLastName(),
  741. "passenger_phone" => $booking->getClientPhone(),
  742. "passenger_email" => $booking->getClientEmail(),
  743. "booking_key" => $booking->getKey(),
  744. "booking_pickup_date" => $booking->getPickUpDate()->format($dateFormat),
  745. "booking_pickup_time" => $booking->getPickUpTime(),
  746. "booking_pickup_location" => $booking->getPickUpAddress(),
  747. "booking_dropoff_location" => $booking->getDestinationAddress(),
  748. "booking_vias_content" => "<ul>" . implode("", array_map(function ($address) {
  749. return "<li>$address</li>";
  750. }, $booking->getViasAsArray())) . "</ul>",
  751. "booking_passengers" => $booking->getPassengersNumber(),
  752. "booking_luggage" => $booking->getCheckinLuggage(),
  753. "booking_notes" => $booking->getNotes(),
  754. "booking_cost" => $booking->getOverridePrice(),
  755. "currency_symbol" => $this->get('currency.service')->getSystemCurrency(),
  756. "booking_duration" => $booking->getEstimatedTimePrettyFormat(),
  757. "booking_distance" => $booking->getDistanceUnit() . ' ' . $distance_unit,
  758. "booking_hand_luggage" => $booking->getHandLuggage(),
  759. "booking_car_type" => $booking->getCarType()->getName(),
  760. "return_booking" => !empty($booking->getReturnBooking()) ? true : null,
  761. "return_booking_key" => $booking->getReturnBooking() ? $booking->getReturnBooking()->getKey() : null,
  762. "return_booking_pickup_date" => $booking->getReturnBooking() ? $booking->getReturnBooking()->getPickUpDate()->format($dateFormat) : null,
  763. "return_booking_pickup_time" => $booking->getReturnBooking() ? $booking->getReturnBooking()->getPickUpTime() : null,
  764. "return_booking_pickup_location" => $booking->getReturnBooking() ? $booking->getReturnBooking()->getPickUpAddress() : null,
  765. "return_booking_dropoff_location" => $booking->getReturnBooking() ? $booking->getReturnBooking()->getDestinationAddress() : null,
  766. "return_booking_vias_content" => $booking->getReturnBooking() ? "<ul>" . implode("", array_map(function ($address) {
  767. return "<li>$address</li>";
  768. }, $booking->getReturnBooking()->getViasAsArray())) . "</ul>" : null,
  769. "return_booking_notes" => $booking->getReturnBooking() ? $booking->getReturnBooking()->getNotes() : null,
  770. "return_booking_cost" => $booking->getReturnBooking() ? $booking->getReturnBooking()->getOverridePrice() : null,
  771. "return_booking_duration" => $booking->getReturnBooking() ? $booking->getReturnBooking()->getEstimatedTimePrettyFormat() : null,
  772. "return_booking_distance" => $booking->getReturnBooking() ? $booking->getReturnBooking()->getDistanceUnit() . ' ' . $distance_unit : null,
  773. "flight_number" => !empty($booking->getFlightNumber()) ? $booking->getFlightNumber() : null,
  774. "landing_time" => $booking->getFlightLandingTime(),
  775. "mg_timeframe" => $booking->getMeetAndGreetTimePrettyFormat(),
  776. "return_flight_number" => $booking->getReturnBooking() ? $booking->getReturnBooking()->getFlightNumber() : null,
  777. "return_landing_time" => $booking->getReturnBooking() ? $booking->getReturnBooking()->getFlightLandingTime() : null,
  778. "return_mg_timeframe" => $booking->getReturnBooking() ? $booking->getReturnBooking()->getMeetAndGreetTimePrettyFormat() : null,
  779. "booking_tour_content" => "<ul>" . implode("", array_map(function ($objective) {
  780. $name = $objective['name'];
  781. //$price = $objective['price'];
  782. return "<li>$name</li>";
  783. }, $booking->getObjectivesAsArray())) . "</ul>",
  784. "return_booking_tour_content" => "<ul>" . implode("", array_map(function ($objective) {
  785. $name = $objective['name'];
  786. //$price = $objective['price'];
  787. return "<li>$name</li>";
  788. }, $booking->getReturnObjectivesAsArray())) . "</ul>",
  789. ],
  790. 'merge_language' => 'mailchimp',
  792. ]
  793. );
  794. break;
  796. }
  798. foreach ($statusEmail as $status) {
  799. if ($status['status'] != 'sent') {
  800. return new JsonResponse([
  801. 'success' => false,
  802. 'status' => 500,
  803. 'message' => 'Reject Reason: ' . $status['reject_reason'],
  804. ]);
  805. }
  806. }
  807. return new JsonResponse([
  808. 'success' => true,
  809. 'status' => 200,
  810. 'message' => 'The mail has been sent successfully',
  811. ]);
  812. }
  814. public function bookingTakeoverAction(Request $request, $id) {
  815. $user = false;
  816. if ($token = $this->get('security.token_storage')->getToken()) {
  817. $user = $token->getUser();
  818. }
  819. if ($user) {
  820. $email = $user->getEmail();
  821. $pool = $this->get('sonata.admin.pool');
  822. $admin = $pool->getAdminByAdminCode('admin.booking');
  823. $url = $admin->generateUrl('edit', ['id' => $id]);
  824. $admin->setRequest($request);
  825. $booking = $admin->getObject($id);
  826. $admin->setSubject($booking);
  827. $booking->isOpen($email);
  828. $booking = $admin->update($booking);
  829. } else {
  830. $url = $this->generateUrl('sonata_admin_dashboard');
  831. }
  832. return new RedirectResponse(
  833. $url
  834. );
  835. }
  837. public function getBookingDriversAction($bookingId)
  838. {
  839. $booking = $this->get('doctrine')->getRepository(Booking::class)->find($bookingId);
  840. $drivers = $this->getDoctrine()->getRepository(Driver::class)->createQueryBuilder('d')
  841. ->join('d.car', 'c')
  842. ->join('c.type', 'ct', Join::WITH, 'ct.passengers >= :limit_passangers')
  843. ->where('d.status = :status_active')
  844. ->setParameter('limit_passangers', $booking->getPassengersNumber())
  845. ->setParameter('status_active', Driver::STATUS_ACTIVE)
  846. ->getQuery()->getResult();
  847. $broadcastedDrivers = $this->getDoctrine()->getRepository(BroadcastedDriver::class)->findBy([
  848. 'booking' => $bookingId,
  849. 'status' => BroadcastedDriver::STATUS_APPROVED,
  850. ]);
  852. $response = [
  853. 'manual_dispatch' => [],
  854. 'brodcasted' => [],
  855. ];
  857. $broadcastedDriversIds = [];
  858. /** @var BroadcastedDriver $broadcastedDriver */
  859. foreach ($broadcastedDrivers as $broadcastedDriver) {
  860. $driver = $broadcastedDriver->getDriver();
  861. $car = $driver->getCar();
  862. if ($car->getType()->getPassengers() >= $booking->getPassengersNumber()) {
  864. $broadcastedDriversIds[] = $driver->getId();
  865. $response['brodcasted'][] = [
  866. 'id' => $driver->getId(),
  867. 'name' => $driver->getUser()->getFirstname() . ' ' . $driver->getUser()->getLastname(),
  868. 'internalName' => $driver->getInternalName(),
  869. ];
  870. }
  871. }
  873. foreach ($drivers as $driver) {
  874. if (!in_array($driver->getId(), $broadcastedDriversIds)) {
  875. $maxNumberOfPassengers = $car = $driver->getCar()->getMaxNumberOfPassengers();
  876. if (isset($maxNumberOfPassengers) && ($maxNumberOfPassengers < $booking->getPassengersNumber())) {
  877. continue;
  878. }
  880. $response['manual_dispatch'][] = [
  881. 'id' => $driver->getId(),
  882. 'name' => $driver->getUser()->getFirstname() . ' ' . $driver->getUser()->getLastname(),
  883. 'internalName' => $driver->getInternalName(),
  884. ];
  885. }
  886. }
  888. return new JsonResponse($response);
  889. }
  891. public function preAssignBookingDriverAction(Request $request)
  892. {
  893. $driverId = $request->request->get('driverId');
  894. $bookingId = $request->request->get('bookingId');
  896. $driver = $this->getDoctrine()->getRepository(Driver::class)->findOneBy(['id' => $driverId]);
  897. $booking = $this->getDoctrine()->getRepository(Booking::class)->findOneBy(['id' => $bookingId]);
  898. if ($booking->isCancel()) {
  899. return new JsonResponse([
  900. 'success' => true,
  901. 'status' => 400,
  902. 'message' => 'The booking was canceled',
  903. ]);
  904. }
  906. $booking->setNeedSendToDriver(true);
  907. $booking->setDriver($driver);
  909. $this->getDoctrine()->getManager()->persist($booking);
  910. $this->getDoctrine()->getManager()->flush();
  912. return new JsonResponse([
  913. 'success' => true,
  914. 'status' => 200,
  915. 'message' => 'Driver has been successfully pre-assigned',
  916. ]);
  917. }
  919. public function selectBookingDriverAction(Request $request)
  920. {
  921. $driverId = $request->request->get('driverId');
  922. $bookingId = $request->request->get('bookingId');
  923. $em = $this->getDoctrine()->getManager();
  925. $driver = $em->getRepository(Driver::class)->findOneBy(['id' => $driverId]);
  926. $booking = $em->getRepository(Booking::class)->findOneBy(['id' => $bookingId]);
  928. if ($booking->isCancel()) {
  929. return new JsonResponse([
  930. 'success' => true,
  931. 'status' => 400,
  932. 'message' => 'The booking was canceled',
  933. ]);
  934. }
  936. $checkDriverShift = $this->get('driver.service')->getDriverShiftStatus($driver,$booking->getPickUpDateTime());
  938. if(!empty($checkDriverShift)) {
  939. $entityManager = $this->getDoctrine()->getManager();
  941. $bookingHistoryDriver = new BookingHistory();
  942. $bookingHistoryDriver->setBooking($booking);
  943. $bookingHistoryDriver->setActionType(BookingHistory::ACTION_DRIVER_SHIFT_TEST);
  944. $bookingHistoryDriver->setUser($driver->getUser());
  945. $bookingHistoryDriver->setPayload($checkDriverShift);
  946. $entityManager->persist($bookingHistoryDriver);
  947. $entityManager->flush();
  949. $blockTimeShiftBookings = $entityManager->getRepository(Settings::class)->findOneBy([
  950. 'key'=>'block_time_shift_bookings',
  951. 'type' => Settings::TYPE_API_DRIVER
  952. ]);
  954. if (!empty($blockTimeShiftBookings) and $blockTimeShiftBookings->getValue() and $checkDriverShift['status'] == JsonResponse::HTTP_FORBIDDEN) {
  955. return new JsonResponse($checkDriverShift);
  956. }
  958. }
  960. $currentDriverUser = $driver->getUser();
  961. $payload = [
  962. 'current_user_id' => $currentDriverUser->getId(),
  963. 'current_user_name' => $currentDriverUser->getFullname(),
  964. 'current_user_email' => $currentDriverUser->getEmail(),
  965. ];
  967. if ($booking->getDriver()) {
  968. $payload['old_user_id'] = $booking->getDriver()->getUser()->getId();
  969. $payload['old_user_name'] = $booking->getDriver()->getUser()->getFullName();
  970. $payload['old_user_email'] = $booking->getDriver()->getUser()->getEmail();
  971. }
  973. $booking->setNeedSendToDriver(false);
  974. $booking->setDriver($driver);
  975. $booking->setStatus(Booking::STATUS_DISPATCHED);
  977. $driverHistory = $this
  978. ->get('driver-history.service')
  979. ->create(
  980. $driver,
  981. $booking->getKey(),
  982. DriverHistory::VALUE_MANUALLY_DISPATCH,
  983. Driver::REPUTATION_POINTS_BOOKING_MANUALLY_DISPATCH,
  984. DriverHistory::TYPE_BOOKING
  985. );
  987. $driver->addReputationPoints(Driver::REPUTATION_POINTS_BOOKING_MANUALLY_DISPATCH);
  989. $em->persist($driverHistory);
  990. $em->persist($driver);
  991. $em->persist($booking);
  992. $em->flush();
  994. $driverUser = $driver->getUser();
  996. return new JsonResponse([
  997. 'success' => true,
  998. 'status' => 200,
  999. 'message' => 'Driver has been successfully selected',
  1000. 'driver' => [
  1001. 'firstName' => $driverUser->getFirstname(),
  1002. 'lastName' => $driverUser->getLastname(),
  1003. 'phone' => $driver->getPhone(),
  1004. ],
  1005. ]);
  1006. }
  1008. public function preAssignBookingsDriverAction(Request $request)
  1009. {
  1010. $driverId = $request->request->get('driverId');
  1011. $bookingIds = $request->request->get('bookingIds');
  1013. $bookingIdsArray = explode(',', $bookingIds);
  1015. $driver = $this->getDoctrine()->getRepository(Driver::class)->findOneBy(['id' => $driverId]);
  1016. foreach ($bookingIdsArray as $bookingId) {
  1017. $booking = $this->getDoctrine()->getRepository(Booking::class)->findOneBy(['id' => $bookingId]);
  1018. if ($booking->isCancel()) {
  1019. return new JsonResponse([
  1020. 'success' => true,
  1021. 'status' => 400,
  1022. 'message' => 'The booking was canceled',
  1023. ]);
  1024. }
  1026. $booking->setNeedSendToDriver(true);
  1027. $booking->setDriver($driver);
  1029. $this->getDoctrine()->getManager()->persist($booking);
  1030. }
  1032. $this->getDoctrine()->getManager()->flush();
  1034. return new JsonResponse([
  1035. 'success' => true,
  1036. 'status' => 200,
  1037. ]);
  1038. }
  1040. public function selectBookingsDriverAction(Request $request)
  1041. {
  1042. $driverId = $request->request->get('driverId');
  1043. $bookingIds = $request->request->get('bookingIds');
  1045. $bookingIdsArray = explode(',', $bookingIds);
  1047. $driver = $this->getDoctrine()->getRepository(Driver::class)->findOneBy(['id' => $driverId]);
  1049. $currentDriverUser = $driver->getUser();
  1050. $payload = [
  1051. 'current_user_id' => $currentDriverUser->getId(),
  1052. 'current_user_name' => $currentDriverUser->getFullname(),
  1053. 'current_user_email' => $currentDriverUser->getEmail(),
  1054. ];
  1056. foreach ($bookingIdsArray as $bookingId) {
  1057. $booking = $this->getDoctrine()->getRepository(Booking::class)->findOneBy(['id' => $bookingId]);
  1058. if (!$booking) {
  1059. return new JsonResponse([
  1060. 'success' => true,
  1061. 'status' => 400,
  1062. 'message' => 'Invalid booking id',
  1063. ]);
  1064. }
  1066. if ($booking->isCancel()) {
  1067. return new JsonResponse([
  1068. 'success' => true,
  1069. 'status' => 400,
  1070. 'message' => 'The booking was canceled',
  1071. ]);
  1072. }
  1074. if ($booking->getDriver()) {
  1075. $payload['old_user_id'] = $booking->getDriver()->getUser()->getId();
  1076. $payload['old_user_name'] = $booking->getDriver()->getUser()->getFullName();
  1077. $payload['old_user_email'] = $booking->getDriver()->getUser()->getEmail();
  1078. }
  1080. $booking->setNeedSendToDriver(false);
  1081. $booking->setDriver($driver);
  1082. $booking->setStatus(Booking::STATUS_DISPATCHED);
  1084. $this->getDoctrine()->getManager()->persist($booking);
  1085. }
  1087. $this->getDoctrine()->getManager()->flush();
  1089. $driverUser = $driver->getUser();
  1091. return new JsonResponse([
  1092. 'success' => true,
  1093. 'status' => 200,
  1094. 'message' => 'Driver has been successfully selected',
  1095. 'driver' => [
  1096. 'firstName' => $driverUser->getFirstname(),
  1097. 'lastName' => $driverUser->getLastname(),
  1098. 'phone' => $driver->getPhone(),
  1099. ],
  1100. ]);
  1101. }
  1103. public function broadcastAction(Request $request)
  1104. {
  1105. $em = $this->getDoctrine()->getManager();
  1106. $bookingId = $request->request->get('bookingId');
  1107. $carTypeIds = $request->request->get('carTypeIds');
  1109. $booking = $em->getRepository(Booking::class)->findOneBy(['id' => $bookingId]);
  1110. $driver = $booking->getDriver();
  1112. if ($booking->isExpireBroadcast() || $driver) {
  1113. return new JsonResponse([
  1114. 'success' => false,
  1115. 'status' => JsonResponse::HTTP_BAD_REQUEST,
  1116. ]);
  1117. }
  1119. if ($booking->isCancel()) {
  1120. return new JsonResponse([
  1121. 'success' => true,
  1122. 'status' => JsonResponse::HTTP_BAD_REQUEST,
  1123. 'message' => 'The booking was canceled',
  1124. ]);
  1125. }
  1127. $em->getRepository(BroadcastedDriver::class)->removeBroadcastedDrivers($bookingId);
  1128. $drivers = $em->getRepository(Driver::class)->getDriversByCarTypes($carTypeIds);
  1130. foreach ($drivers as $driver) {
  1131. $broadcast = new BroadcastedDriver();
  1132. $broadcast->setBooking($booking);
  1133. $broadcast->setDriver($driver);
  1135. $user = $driver->getUser();
  1137. if ($user && $user->getApiKey()) {
  1138. $now = new \DateTime();
  1139. $this->get('websocket_notification.service')->send([
  1140. 'apiKey' => $user->getApiKey(),
  1141. 'data' => [
  1142. 'event' => NotificationPusher::SEND_BOOKING_BROADCAST_EVENT,
  1143. 'booking' => $booking->getKey(),
  1144. 'message' => "You have a new broadcast booking request notification for booking #{$booking->getKey()} at {$now->format('Y-m-d H:i')}",
  1145. 'pickup_date_time' => $booking->getPickUpDateTime()->format('Y-m-d H:i:s')
  1146. ],
  1147. ], [
  1148. 'title' => "You have a new broadcast booking request notification for booking #{$booking->getKey()} at {$now->format('Y-m-d H:i')}",
  1149. 'body' => 'Please check details.'
  1150. ]);
  1151. }
  1153. $em->persist($broadcast);
  1154. }
  1156. $expireBroadcastDate = new \DateTime();
  1157. $expireBroadcastDate->modify("+1 hours");
  1158. $booking->setExpireBroadcastDate($expireBroadcastDate);
  1159. $booking->setStatus(Booking::STATUS_BROADCAST);
  1160. $booking->setDriversConfirmedNumber(0);
  1162. $em->persist($booking);
  1163. $em->flush();
  1165. return new JsonResponse([
  1166. 'success' => true,
  1167. 'status' => JsonResponse::HTTP_OK,
  1168. ]);
  1169. }
  1171. public function getDashboardBookingsAction(Request $request)
  1172. {
  1173. $doctrine = $this->get('doctrine');
  1175. $lastUpdate = $request->request->get('lastTime');
  1177. /** @var QueryBuilder $queryBuilderHistory */
  1178. $queryBuilderHistory = $doctrine
  1179. ->getRepository(BookingHistory::class)
  1180. ->createQueryBuilder('h')
  1181. ->select('b.id AS bookingId')
  1182. ->leftJoin(Booking::class, 'b', Join::WITH, 'h.booking=b.id')
  1183. ->groupBy('h.booking')
  1184. ->orderBy('h.date', 'DESC')
  1185. ;
  1187. if ($lastUpdate > 0) {
  1188. $queryBuilderHistory
  1189. ->andWhere('h.date > :fromDate')
  1190. ->setParameter('fromDate', (new \DateTime())->setTimestamp($lastUpdate))
  1191. ;
  1192. }
  1194. $bookingsIds = $queryBuilderHistory
  1195. ->setMaxResults(50)
  1196. ->getQuery()
  1197. ->getArrayResult()
  1198. ;
  1200. $inIds = array_column($bookingsIds, 'bookingId');
  1202. if (empty($inIds)) {
  1203. return new JsonResponse([
  1204. 'results' => [],
  1205. 'lastTime' => $lastUpdate,
  1206. ]);
  1207. }
  1209. $statuses = [];
  1211. foreach ($request->request->get('status', []) as $value) {
  1212. $statuses = array_merge($statuses, self::$mapDashboardStatusRequest[$value]);
  1213. }
  1215. if (empty($statuses)) {
  1216. $statuses[] = '-1';
  1217. }
  1219. /** @var QueryBuilder $queryBuilder */
  1220. $queryBuilder = $doctrine
  1221. ->getRepository(Booking::class)
  1222. ->createQueryBuilder('b')
  1223. ;
  1225. $queryBuilder
  1226. ->where($queryBuilder->expr()->in('b.status', $statuses))
  1227. ->andWhere($queryBuilder->expr()->in('b.id', $inIds))
  1228. ;
  1230. $queryBuilderPickUpAddress = null;
  1231. $queryBuilderDestinationAddress = null;
  1232. $queryBuilderDriver = null;
  1233. $queryBuildersClient = [
  1234. 'first_name' => null,
  1235. 'last_name' => null,
  1236. 'phone' => null,
  1237. 'email' => null,
  1238. ];
  1240. $searchKey = $request->request->get('key');
  1242. if (!empty($searchKey)) {
  1243. $queryBuilderPickUpAddress = clone $queryBuilder;
  1244. $queryBuilderDestinationAddress = clone $queryBuilder;
  1245. $queryBuilderDriver = clone $queryBuilder;
  1246. $queryBuildersClient = [
  1247. 'first_name' => clone $queryBuilder,
  1248. 'last_name' => clone $queryBuilder,
  1249. 'phone' => is_numeric(str_replace('+', '', $searchKey)) ? clone $queryBuilder : null,
  1250. 'email' => clone $queryBuilder,
  1251. ];
  1253. $queryBuilder->andWhere($queryBuilder->expr()->like('b.key', "'$searchKey%'"));
  1255. $queryBuilderPickUpAddress->andWhere($queryBuilderPickUpAddress->expr()->like('b.pickUpAddress', "'%$searchKey%'"));
  1256. $queryBuilderDestinationAddress->andWhere($queryBuilderDestinationAddress->expr()->like('b.destinationAddress', "'%$searchKey%'"));
  1257. $queryBuilderDriver
  1258. ->innerJoin('b.driver', 'd', Join::WITH, 'd.internalName like :search')
  1259. ->setParameter('search', "$searchKey%")
  1260. ;
  1262. $queryBuildersClient['first_name']->andWhere('b.clientFirstName like :search')->setParameter('search', "$searchKey%");
  1263. $queryBuildersClient['last_name']->andWhere('b.clientLastName like :search')->setParameter('search', "$searchKey%");
  1265. if ($queryBuildersClient['phone'] != null) {
  1266. $queryBuildersClient['phone']->andWhere('b.clientPhone like :search')->setParameter('search', "$searchKey%");
  1267. }
  1269. $queryBuildersClient['email']->andWhere('b.clientEmail like :search')->setParameter('search', "$searchKey%");
  1270. }
  1272. // $queryBuilder
  1273. // ->setFirstResult($request->request->get('startWith', 0))
  1274. // ->setMaxResults($request->request->get('limit', 5))
  1275. // ;
  1277. // $ignoreIds = $request->request->get('ignoreIds', []);
  1279. // if (!empty($ignoreIds)) {
  1280. // $queryBuilder->andWhere($queryBuilder->expr()->not($queryBuilder->expr()->in('b.id', $ignoreIds)));
  1281. // }
  1283. /** @var Booking[] $bookings */
  1284. $bookings = $queryBuilder
  1285. ->setMaxResults(50)
  1286. ->getQuery()
  1287. ->getResult()
  1288. ;
  1290. $limit = $request->request->get('limit', 5);
  1292. $ignoreIds = array_map(function (Booking $booking) {
  1293. return $booking->getId();
  1294. }, $bookings);
  1296. if (count($bookings) < $limit && $queryBuilderPickUpAddress != null) {
  1297. $queryBuilderPickUpAddress->setMaxResults($limit);
  1299. if (!empty($ignoreIds)) {
  1300. $queryBuilderPickUpAddress->andWhere($queryBuilderPickUpAddress->expr()->not($queryBuilderPickUpAddress->expr()->in('b.id', $ignoreIds)));
  1301. }
  1303. /** @var Booking $b */
  1304. foreach ($queryBuilderPickUpAddress->getQuery()->getResult() as $b) {
  1305. $ignoreIds[] = $b->getId();
  1307. if (count($bookings) < $limit) {
  1308. $bookings[] = $b;
  1309. } else {
  1310. break;
  1311. }
  1312. }
  1313. }
  1315. if (count($bookings) < $limit && $queryBuilderDestinationAddress != null) {
  1316. $queryBuilderDestinationAddress->setMaxResults($limit);
  1318. if (!empty($ignoreIds)) {
  1319. $queryBuilderDestinationAddress->andWhere($queryBuilderDestinationAddress->expr()->not($queryBuilderDestinationAddress->expr()->in('b.id', $ignoreIds)));
  1320. }
  1322. /** @var Booking $b */
  1323. foreach ($queryBuilderDestinationAddress->getQuery()->getResult() as $b) {
  1324. $ignoreIds[] = $b->getId();
  1326. if (count($bookings) < $limit) {
  1327. $bookings[] = $b;
  1328. } else {
  1329. break;
  1330. }
  1331. }
  1332. }
  1334. if (count($bookings) < $limit && $queryBuilderDriver != null) {
  1335. $queryBuilderDriver->setMaxResults($limit);
  1337. if (!empty($ignoreIds)) {
  1338. $queryBuilderDriver->andWhere($queryBuilderDriver->expr()->not($queryBuilderDriver->expr()->in('b.id', $ignoreIds)));
  1339. }
  1341. /** @var Booking $b */
  1342. foreach ($queryBuilderDriver->getQuery()->getResult() as $b) {
  1343. $ignoreIds[] = $b->getId();
  1345. if (count($bookings) < $limit) {
  1346. $bookings[] = $b;
  1347. } else {
  1348. break;
  1349. }
  1350. }
  1351. }
  1353. if (count($bookings) < $limit) {
  1354. /** @var QueryBuilder $qb */
  1355. foreach ($queryBuildersClient as $key => $qb) {
  1356. if ($qb != null) {
  1357. $qb->setMaxResults($limit);
  1359. if (!empty($ignoreIds)) {
  1360. $qb->andWhere($qb->expr()->not($qb->expr()->in('b.id', $ignoreIds)));
  1361. }
  1363. /** @var Booking $b */
  1364. foreach ($qb->getQuery()->getResult() as $b) {
  1365. $ignoreIds[] = $b->getId();
  1366. if (count($bookings) < $limit) {
  1367. $bookings[] = $b;
  1368. } else {
  1369. break 2;
  1370. }
  1371. }
  1372. }
  1373. }
  1374. }
  1376. $response = [];
  1378. /** @var RouterInterface $router */
  1379. $router = $this->get('router');
  1381. $cachedClassColors = [];
  1383. foreach (self::$mapDashboardStatusRequest as $key => $statuses) {
  1384. foreach ($statuses as $status) {
  1385. $cachedClassColors[$status] = $key;
  1386. }
  1387. }
  1389. $defaultCarType = Car::$carCtlfTypes[Car::CAR_TYPE_SALOON];
  1391. /** @var Booking $booking */
  1392. foreach ($bookings as $booking) {
  1393. /** @var \DateTime $lastBookingHistoryDate */
  1394. $lastBookingHistoryDate = $booking
  1395. ->getBookingHistory()
  1396. ->last()
  1397. ->getDate()
  1398. ;
  1399. $lastBookingHistoryTimestamp = $lastBookingHistoryDate->getTimestamp();
  1401. $response[] = [
  1402. 'id' => $booking->getId(),
  1403. 'key' => $booking->getKey(),
  1404. 'url' => $router->generate('admin_admin_booking_edit', ['id' => $booking->getId()]),
  1405. 'status' => Booking::$statusTypes[$booking->getStatus()],
  1406. 'classColor' => array_key_exists($booking->getStatus(), $cachedClassColors)
  1407. ? $cachedClassColors[$booking->getStatus()]
  1408. : '',
  1409. 'pickUpAddress' => $booking->getPickUpAddress(),
  1410. 'dropOfAddress' => $booking->getDestinationAddress(),
  1411. 'pickUpTime' => "{$booking->getPickUpDate()->format('F d')} {$booking->getPickUpTime()}",
  1412. 'price' => $booking->getOverridePrice(),
  1413. 'carType' => empty($booking->getCarType())
  1414. ? $defaultCarType
  1415. : $booking->getCarType()->getShortName(),
  1416. 'updateTime' => $lastBookingHistoryDate->format('H:i:s'),
  1417. 'updateDateTime' => $lastBookingHistoryTimestamp,
  1418. ];
  1420. $lastUpdate = $lastUpdate < $lastBookingHistoryTimestamp
  1421. ? $lastBookingHistoryTimestamp
  1422. : $lastUpdate
  1423. ;
  1424. }
  1426. usort($response, function ($a, $b) {
  1427. return $a['updateDateTime'] - $b['updateDateTime'];
  1428. });
  1430. return new JsonResponse([
  1431. 'results' => $lastUpdate == 1 ? array_reverse($response) : $response,
  1432. 'lastTime' => $lastUpdate,
  1433. 'dt' => (new \DateTime())
  1434. ->setTimestamp($lastUpdate)
  1435. ->format('d-m-Y H:i:s'),
  1436. ]);
  1437. }
  1439. public function updateDashboardBookingsAction(Request $request)
  1440. {
  1441. $ids = $request->request->get('ids');
  1442. if (!empty($ids)) {
  1444. /** @var QueryBuilder $queryBuilder */
  1445. $queryBuilder = $this->get('doctrine')->getRepository(Booking::class)->createQueryBuilder('b');
  1447. $queryBuilder->where($queryBuilder->expr()->in('b.id', $ids));
  1448. $bookings = $queryBuilder->getQuery()->getResult();
  1449. $response = [];
  1450. /** @var Booking $booking */
  1451. foreach ($bookings as $booking) {
  1452. $response[] = [
  1453. 'id' => $booking->getId(),
  1454. 'key' => $booking->getKey(),
  1455. 'url' => $this->get('router')->generate('admin_admin_booking_edit', ['id' => $booking->getId()]),
  1456. 'status' => Booking::$statusTypes[$booking->getStatus()],
  1457. 'classColor' => key(array_filter(self::$mapDashboardStatusRequest, function ($v, $k) use ($booking) {
  1458. return in_array($booking->getStatus(), $v);
  1459. }, ARRAY_FILTER_USE_BOTH)),
  1460. 'pickUpAddress' => $booking->getPickUpAddress(),
  1461. 'dropOfAddress' => $booking->getDestinationAddress(),
  1462. 'pickUpTime' => $booking->getPickUpDate()->format('F d') . ' ' . $booking->getPickUpTime(),
  1463. 'price' => $booking->getOverridePrice(),
  1464. 'carType' => empty($booking->getCarType()) ? Car::$carCtlfTypes[Car::CAR_TYPE_SALOON] : $booking->getCarType()->getName(),
  1465. 'updateTime' => count($booking->getBookingHistory()) ? $booking->getBookingHistory()->last()->getDate()->format('H:i:s') : $booking->getBookingDate()->format('H:i:s'),
  1466. 'updateDateTime' => count($booking->getBookingHistory()) ? $booking->getBookingHistory()->last()->getDate()->getTimestamp() : $booking->getBookingDate()->getTimestamp(),
  1467. ];
  1468. }
  1470. usort($response, function ($a, $b) {
  1471. return $a['updateDateTime'] - $b['updateDateTime'];
  1472. });
  1473. // $response = array_reverse($response);
  1474. $hash = md5(serialize($response) . $_SERVER['REMOTE_ADDR']);
  1475. if (isset($_SESSION['hash_list'])) {
  1477. if ($_SESSION['hash_list'] == $hash) {
  1478. $response = [];
  1479. }
  1480. }
  1481. $_SESSION['hash_list'] = $hash;
  1482. return new JsonResponse($response);
  1483. }
  1485. return new JsonResponse([]);
  1486. }
  1488. public function officeCancellationAction(Request $request)
  1489. {
  1490. $bookingId = $request->request->get('bookingId');
  1491. $cancelReason = $request->request->get('cancelReason');
  1492. $cancelRefund = $request->request->get('cancelRefund');
  1494. $booking = $this->getDoctrine()->getRepository(Booking::class)->findOneBy(['id' => $bookingId]);
  1496. $booking->setStatus(Booking::STATUS_OFFICE_CANCELLATION);
  1497. $booking->setCancelReason($cancelReason);
  1499. $cancelPercent = 0;
  1500. if ($cancelRefund) {
  1501. //$cancelPercent = $cancelRefund/100;
  1502. $cancelPercent = $cancelRefund; // to be checked as the value inserted is in percent
  1503. }
  1504. $booking->setCancelRefund($cancelPercent);
  1506. $this->getDoctrine()->getManager()->persist($booking);
  1507. $this->getDoctrine()->getManager()->flush();
  1509. return new JsonResponse([
  1510. 'success' => true,
  1511. 'status' => 200,
  1512. ]);
  1513. }
  1515. public function deleteAction(Request $request)
  1516. {
  1517. $bookingId = $request->request->get('bookingId');
  1519. $booking = $this->getDoctrine()->getRepository(Booking::class)->findOneBy(['id' => $bookingId]);
  1521. $booking->setStatus(Booking::STATUS_DELETED);
  1522. $this->getDoctrine()->getManager()->persist($booking);
  1524. $this->getDoctrine()->getManager()->flush();
  1526. return new JsonResponse([
  1527. 'success' => true,
  1528. 'status' => 200,
  1529. ]);
  1530. }
  1532. public function deleteASAPAction(Request $request)
  1533. {
  1534. $bookingId = $request->request->get('bookingId');
  1536. $booking_request = $this->getDoctrine()->getRepository(BookingRequest::class)->findOneBy(['id' => $bookingId]);
  1537. $booking_extras = $this->getDoctrine()->getRepository(BookingBookingExtra::class)->findOneBy(['bookingRequest' => $bookingId]);
  1539. $this->getDoctrine()->getManager()->remove($booking_request);
  1540. $this->getDoctrine()->getManager()->flush();
  1542. return new JsonResponse([
  1543. 'success' => true,
  1544. 'status' => 200,
  1545. ]);
  1546. }
  1548. public function completedAction(Request $request)
  1549. {
  1550. $em = $this->getDoctrine()->getManager();
  1551. $bookingId = $request->request->get('bookingId');
  1553. $booking = $em->getRepository(Booking::class)->findOneBy(['id' => $bookingId]);
  1555. $booking->setStatus(Booking::STATUS_COMPLETED);
  1557. $em->persist($booking);
  1558. $em->flush();
  1560. return new JsonResponse([
  1561. 'success' => true,
  1562. 'status' => JsonResponse::HTTP_OK,
  1563. ]);
  1564. }
  1566. public function isOpenAction(Request $request)
  1567. {
  1568. $bookingId = $request->request->get('bookingId');
  1569. $booking = $this->getDoctrine()->getRepository(Booking::class)->findOneBy(['id' => $bookingId]);
  1570. $booking->isOpen($this->get('security.token_storage')->getToken()->getUser()->getEmail());
  1572. $this->getDoctrine()->getManager()->persist($booking);
  1574. $this->getDoctrine()->getManager()->flush();
  1576. return new JsonResponse([
  1577. 'success' => true,
  1578. 'status' => 200,
  1579. ]);
  1580. }
  1582. /**
  1583. * @param Request $request
  1584. * @param $bookingKey
  1585. *
  1586. * @return JsonResponse
  1587. */
  1588. public function getJourneyLogsAction(Request $request, $bookingKey)
  1589. {
  1590. $show_history_log_map = $this->get('doctrine')->getRepository(Settings::class)->findOneBy([
  1591. 'key' => 'show_history_log_map',
  1592. ]);
  1594. if ($show_history_log_map->getValue() == 0) {
  1595. return new JsonResponse(array(
  1596. 'status' => Response::HTTP_FORBIDDEN,
  1597. 'message' => 'not enabled',
  1598. ));
  1599. }
  1600. try {
  1601. /** @var Booking $booking */
  1602. $booking = $this->get('doctrine')->getRepository(Booking::class)->findOneBy([
  1603. 'key' => $bookingKey,
  1604. ]);
  1606. if ($booking && $booking->getId()) {
  1608. $logs = $this->get('doctrine')->getRepository(DriverHistoryLocations::class)
  1609. ->getLocationsById($booking->getId());
  1611. if (count($logs) > 0) {
  1612. $stepTimeMarker = 120;
  1614. $initTime = ($logs[0]['date']);
  1615. $markers[] = reset($logs);
  1616. foreach ($logs as $log) {
  1617. $compareTime = ($log['date']);
  1618. $diff = $compareTime->getTimestamp() - $initTime->getTimestamp();
  1620. if ($diff > $stepTimeMarker) {
  1621. $markers[] = $log;
  1622. $initTime = $compareTime;
  1623. }
  1624. }
  1625. $markers[] = end($logs);
  1627. $logs = $this->get('jms_serializer')->toArray($logs);
  1628. $totals = count($logs);
  1630. if ($totals > 23) {
  1632. $step = $totals / 23;
  1633. $c = 0;
  1634. while ($c < $totals) {
  1636. if ($logs[ceil($c)]) {
  1637. $waypoints[] = $logs[ceil($c)];
  1638. }
  1639. $c += $step;
  1641. }
  1642. } else {
  1643. $waypoints = $logs;
  1644. if (count($waypoints) > 3) {
  1645. unset($waypoints[0]);
  1646. unset($waypoints[count($waypoints) - 1]);
  1647. }
  1648. }
  1650. $lat = 0.0;
  1651. $lng = 0.0;
  1652. foreach ($waypoints as $marker) {
  1653. if ($marker['lat'] != 0 && $marker['lng'] != 0) {
  1654. $lat += $marker['lat'];
  1655. $lng += $marker['lng'];
  1656. }
  1657. }
  1659. $centerlat = $lat / count($markers);
  1660. $centerlon = $lng / count($markers);
  1662. $start = $logs[0];
  1663. $end = end($logs);
  1665. return new JsonResponse([
  1666. 'success' => true,
  1667. 'status' => Response::HTTP_OK,
  1668. 'journey' => $logs,
  1669. 'waypoints' => $waypoints,
  1670. 'markers' => $markers,
  1671. 'start' => $start,
  1672. 'end' => $end,
  1673. 'center' => ['lat' => $centerlat, 'lng' => $centerlon],
  1674. 'returnBookingId' => $booking->getReturnBooking() ? $booking->getReturnBooking()->getKey() : null,
  1675. 'urlReturn' => $booking->getReturnBooking() ? $this->generateUrl('admin_bookings_get_journey_logs', ['bookingKey' => $booking->getReturnBooking()->getKey()]) : null,
  1676. ]);
  1677. } elseif (isset($booking) && $booking->getPickUpLat()) {
  1678. return new JsonResponse([
  1679. 'success' => true,
  1680. 'status' => Response::HTTP_OK,
  1681. 'start' => ['lat' => $booking->getPickUpLat(), 'lng' => $booking->getPickUpLng()],
  1682. 'end' => ['lat' => $booking->getDestinationLat(), 'lng' => $booking->getDestinationLng()],
  1683. 'center' => ['lat' => $booking->getDestinationLat(), 'lng' => $booking->getDestinationLng()],
  1684. 'returnBookingId' => $booking->getReturnBooking() ? $booking->getReturnBooking()->getId() : null,
  1685. ]);
  1686. }
  1687. } else {
  1688. return new JsonResponse(array(
  1689. 'status' => Response::HTTP_BAD_REQUEST,
  1690. 'message' => 'invalid details',
  1691. ));
  1692. }
  1693. } catch (\Exception $e) {
  1694. return new JsonResponse(array(
  1695. 'status' => Response::HTTP_BAD_REQUEST,
  1696. 'message' => $e->getMessage(),
  1697. ));
  1698. }
  1699. }
  1701. public function getBookingsStatusAction(Request $request)
  1702. {
  1703. $bookingIds = $request->request->get('bookingIds');
  1705. $queryBuilder = $this->get('doctrine')->getRepository(Booking::class)->createQueryBuilder('b');
  1706. $queryBuilder->select('b.id, b.status')
  1707. ->where("b.id IN(:bookingIds)")
  1708. ->setParameter('bookingIds', $bookingIds);
  1710. $bookingsStatus = $queryBuilder->getQuery()->getArrayResult();
  1712. foreach ($bookingsStatus as $key => $bookingStatus) {
  1713. $bookingsStatus[$key]['statusName'] = Booking::$statusTypes[$bookingStatus['status']];
  1714. }
  1716. return new JsonResponse($bookingsStatus);
  1717. }
  1719. public function getBookingCancelReasonsAction(Request $request)
  1720. {
  1721. $reasons = $this->get('doctrine')->getRepository(BookingCancelReason::class)->findAll();
  1722. $response = [];
  1724. /** @var BookingCancelReason $reason */
  1725. foreach ($reasons as $reason) {
  1726. $response[] = [
  1727. 'id' => $reason->getId(),
  1728. 'reason' => $reason->getReason(),
  1729. ];
  1730. }
  1732. return new JsonResponse($response);
  1733. }
  1735. public function removeDriverAction(Request $request)
  1736. {
  1737. $bookingId = $request->request->get('bookingId');
  1738. $booking = $this->getDoctrine()->getRepository(Booking::class)->findOneBy(['id' => $bookingId]);
  1739. $booking->setDriver(null);
  1741. $this->getDoctrine()->getManager()->persist($booking);
  1743. $this->getDoctrine()->getManager()->flush();
  1745. return new JsonResponse([
  1746. 'success' => true,
  1747. 'status' => 200,
  1748. ]);
  1749. }
  1750. public function notifiedDriversAction(Request $request)
  1751. {
  1752. $bookingId = $request->request->get('asap');
  1753. $allDrivers = array();
  1754. $bookingRequest = $this->get('doctrine')->getRepository(BookingRequest::class)->findOneBy(array('id' => $bookingId));
  1755. if (!empty($bookingRequest)) {
  1756. $notifiedDrivers = $bookingRequest->getNotifiedDrivers();
  1757. if (!empty($notifiedDrivers)) {
  1758. $decodedNotifiedDrivers = json_decode($notifiedDrivers, true);
  1759. foreach ($decodedNotifiedDrivers as $driver) {
  1760. $driverData = $this->get('doctrine')->getRepository(Driver::class)->findOneBy(array('id' => $driver['driverId']));
  1761. $driverCarType = $driverData->getCar()->getType();
  1762. $entry = [
  1763. 'id' => $driverData->getId(),
  1764. 'name' => $driverData->getUser()->getFirstname() . ' ' . $driverData->getUser()->getLastname(),
  1765. 'internalName' => $driverData->getInternalName(),
  1766. 'carType' => $driverCarType->getName(),
  1767. ];
  1768. array_push($allDrivers, $entry);
  1769. }
  1770. }
  1771. }
  1772. return new JsonResponse($allDrivers);
  1773. }
  1775. public function resendDriverNotificationsAction(Request $request)
  1776. {
  1777. $bookingRequestId = $request->request->get('bookingRequestId');
  1779. $bookingRequest = $this->getDoctrine()->getRepository(BookingRequest::class)->findOneBy(['id' => $bookingRequestId]);
  1781. if (!empty($bookingRequest)) {
  1783. $findDriversService = $this->get('find-matching-jobs.service');
  1784. $interval = $bookingRequest->getEstimatedTime();
  1785. $intervalComponents = explode(':', $interval);
  1786. $minutes = intval($intervalComponents[0]) * 60 + intval($intervalComponents[1]);
  1787. $pickUpFullDateTime = $bookingRequest->getPickUpDateTime();
  1788. $car_type_id = !empty($bookingRequest->getCarType()) ? $bookingRequest->getCarType()->getId() : null;
  1789. $all_drivers = $findDriversService->findDriversForLocations($bookingRequest->getPickUpLat(), $bookingRequest->getPickUpLng(), $minutes, $pickUpFullDateTime, $car_type_id);
  1791. if (!empty($all_drivers)) {
  1792. $bookingRequest->setNotifiedDrivers(json_encode($all_drivers));
  1793. } else {
  1794. return new JsonResponse([
  1795. 'success' => true,
  1796. 'status' => 200,
  1797. 'message' => 'Drivers not found for this location.',
  1798. ]);
  1799. }
  1801. $this->getDoctrine()->getManager()->flush();
  1803. return new JsonResponse([
  1804. 'success' => true,
  1805. 'status' => 200,
  1806. 'message' => 'Driver notifications refreshed.',
  1807. ]);
  1808. }
  1810. return new JsonResponse([
  1811. 'success' => true,
  1812. 'status' => 200,
  1813. 'message' => 'Booking request not found.',
  1814. ]);
  1816. }
  1818. public function createBookingFromASAPAction(Request $request)
  1819. {
  1820. $bookingId = $request->request->get('bookingId');
  1822. $booking_request = $this->getDoctrine()->getRepository(BookingRequest::class)->findOneBy(['id' => $bookingId]);
  1824. if (!empty($booking_request)) {
  1825. $paymentMethod = $request->request->get('payment_method', Payment::TYPE_CARD);
  1826. if (!in_array($paymentMethod, array_keys(Payment::TYPE))) {
  1827. return new JsonResponse([
  1828. 'status' => 400,
  1829. 'message' => 'Invalid paymentMethod. The method allowed are: ' . implode(" ", array_keys(Payment::TYPE)),
  1830. ]);
  1831. }
  1832. $clientEmail = $booking_request->getClientEmail();
  1833. $clientFirstName = $booking_request->getClientFirstName();
  1834. $clientLastName = $booking_request->getClientLastName();
  1835. $clientPhone = $booking_request->getClientPhone();
  1836. $notes = !empty($booking_request->getNotes()) ? $booking_request->getNotes() : '';
  1837. $user = null;
  1838. $sendEmailCheckBooking = false;
  1839. if (!empty($clientEmail)) {
  1840. $user = $this->get('doctrine')->getRepository(User::class)->findOneBy([
  1841. 'email' => $clientEmail,
  1842. ]);
  1843. if ($user) {
  1844. if ($user->getAccount()) {
  1845. if ($user->getFirstname() != $clientFirstName ||
  1846. $user->getLastname() != $clientLastName ||
  1847. $user->getPhone() != $clientPhone) {
  1848. $notes .= 'Alternative Passenger Travelling: ' . $clientFirstName . ' ' . $clientLastName . '/' . $clientPhone;
  1849. $sendEmailCheckBooking = true;
  1850. }
  1851. } else {
  1852. $user = null;
  1853. }
  1854. } else {
  1855. //if not user that is account then will create one
  1856. $user = new User();
  1857. $user->setUsernameCanonical($clientEmail);
  1858. $user->setUsername($clientEmail);
  1859. $user->addRole(User::ROLE_CLIENT);
  1860. $user->setEnabled(true);
  1861. $user->setPassword(substr(md5(microtime()), rand(0, 26), 10));
  1862. $user->setFirstname($clientFirstName);
  1863. $user->setLastname($clientLastName);
  1864. $user->setEmail($clientEmail);
  1865. $user->setPhone($clientPhone);
  1866. $this->get('doctrine')->getManager()->persist($user);
  1868. $account = new Account();
  1869. $account->setUser($user);
  1870. $account->setPhone($clientPhone);
  1871. $account->setEmail($clientEmail);
  1872. $account->setName($clientFirstName . ' ' . $clientLastName);
  1873. $account->setTitle('Mr');
  1874. $this->get('doctrine')->getManager()->persist($account);
  1876. $user->setAccount($account);
  1877. }
  1878. }
  1880. $distanceUnit = $booking_request->getDistanceUnit();
  1881. $price = $booking_request->getQuotePrice();
  1882. $estimateTime = $booking_request->getEstimatedTime();
  1883. $pmgValue = $booking_request->getPmg();
  1885. $booking = new Booking();
  1886. $booking->setPmg($pmgValue);
  1887. $booking->setStatus(Booking::STATUS_PENDING);
  1888. $booking->setPickUpAddress($booking_request->getPickupAddress());
  1889. $booking->setPickUpPostCode($booking_request->getPickUpPostCode());
  1890. $booking->setDestinationAddress($booking_request->getDestinationAddress());
  1891. $booking->setDestinationPostCode($booking_request->getDestinationPostCode());
  1892. $booking->setPickUpDate($booking_request->getPickUpDate());
  1893. $booking->setPickUpTime($booking_request->getPickUpTime());
  1894. $booking->setCarType($booking_request->getCarType());
  1895. $booking->setHandLuggage($booking_request->getHandLuggage());
  1896. $booking->setCheckinLuggage($booking_request->getCheckinLuggage());
  1897. $booking->setPassengersNumber($booking_request->getPassengersNumber());
  1898. $booking->setFlightLandingTime($booking_request->getFlightLandingTime());
  1899. $booking->setFlightNumber($booking_request->getFlightNumber());
  1900. $booking->setClientFirstName($clientFirstName);
  1901. $booking->setClientLastName($clientLastName);
  1902. $booking->setClientPhone($clientPhone);
  1903. $booking->setClientEmail($clientEmail);
  1904. $booking->setClientAlternativePhone($booking_request->getClientAlternativePhone());
  1905. $booking->setClientAlternativeEmail($booking_request->getClientAlternativeEmail());
  1906. $booking->setNotes($notes);
  1907. $booking->setQuotePrice($price);
  1908. $booking->setOverridePrice($price);
  1909. $booking->setDriverPrice($price - 1);
  1910. $booking->setDistanceUnit($distanceUnit);
  1911. $booking->setEstimatedTime($estimateTime);
  1912. $booking->setPaymentType($paymentMethod);
  1913. $booking->setCreateAccount(false);
  1914. $booking->setClientUser($user);
  1915. $booking->setPickUpLat($booking_request->getPickupLat());
  1916. $booking->setPickUpLng($booking_request->getPickupLng());
  1917. $booking->setDestinationLat($booking_request->getDestinationLat());
  1918. $booking->setDestinationLng($booking_request->getDestinationLng());
  1919. $booking->setDriver($booking_request->getDriver());
  1920. $booking->setBookingDataSerialized($booking_request->getBookingDataSerialized());
  1921. $vias_custom = $booking_request->getVias();
  1923. foreach ($vias_custom as $via) {
  1924. // Vias might already be BookingViasAddress objects.
  1925. if ($via instanceof BookingViasAddress) {
  1926. $new_via = $via;
  1927. } else {
  1928. $new_via = new BookingViasAddress();
  1929. $new_via->setAddress($via['address']);
  1930. $new_via->setMapAddress($via['value']);
  1931. $new_via->setPostCode($via['postcode']);
  1932. }
  1933. $new_via->setBooking($booking);
  1934. $booking->addVias($new_via);
  1935. $this->get('doctrine')->getManager()->persist($new_via);
  1936. }
  1937. $bookingExtras = $booking_request->getExtras();
  1939. /** @var BookingBookingExtra $bE */
  1940. foreach ($bookingExtras as $bE) {
  1941. $bE->setBooking($booking);
  1942. }
  1943. $booking->setExtras($bookingExtras);
  1944. if (!empty($booking_request->getReturnBooking()) and !empty($booking_request->getReturnBooking()->getId())) {
  1945. $returnBooking = $this->addReturnBooking($booking, $booking_request, $bookingExtras, $vias_custom);
  1946. $this->get('doctrine')->getManager()->persist($returnBooking);
  1947. }
  1949. $voucherCode = $booking_request->getVoucherCode();
  1950. try {
  1951. if (!empty($voucherCode)) {
  1952. $booking->setVoucherCode($voucherCode);
  1953. $this->get('voucher.service')->applyVoucher($booking);
  1954. }
  1955. } catch (\Exception $e) {
  1956. return new JsonResponse([
  1957. 'status' => 500,
  1958. 'message' => $e->getMessage(),
  1959. ]);
  1960. }
  1961. if (!empty($booking_request)) {
  1962. $booking_request->setBookingCreatedKey($booking->getKey());
  1963. }
  1965. $this->get('doctrine')->getManager()->persist($booking);
  1966. $this->get('doctrine')->getManager()->flush();
  1967. $this->get('admin.booking')->createObjectSecurity($booking);
  1969. // Record booking request history.
  1970. $requestService = $this->get('request.service');
  1971. $payload = [
  1972. 'details' => 'Booking created from this booking request',
  1973. 'method' => 'createBookingFromASAPAction'
  1974. ];
  1975. $action = BookingRequestHistory::SYSTEM_ACTION;
  1976. $requestService->addHistory($bookingRequest->getKey(), $action, $payload);
  1978. $this->sendEmailNewBooking($sendEmailCheckBooking, $booking);
  1980. return new JsonResponse([
  1981. 'status' => 200,
  1982. 'message' => "A new booking was created from this booking asap",
  1983. 'booking' => $this->get('jms_serializer')->toArray($booking),
  1984. ]);
  1985. } else {
  1986. return new JsonResponse([
  1987. 'status' => 400,
  1988. 'message' => "Could not find any booking asap",
  1989. ]);
  1990. }
  1991. }
  1993. public function addReturnBooking($booking, $booking_request, $bookingExtras, $vias_custom)
  1994. {
  1995. $returnPrice = $booking_request->getReturnDriverPrice();
  1996. $returnNotes = $booking_request->getReturnBookingNotes();
  1998. $pmgValueReturn = $booking_request->getReturnPmg();
  2000. $returnBooking = clone $booking;
  2001. $booking->setReturnPmg($pmgValueReturn);
  2002. $returnBooking->setPmg($pmgValueReturn);
  2003. $returnBooking->generateKey();
  2004. $returnBooking->setFlightLandingTime($booking_request->getReturnFlightLandingTime());
  2005. $returnBooking->setFlightNumber($booking_request->getReturnFlightNumber());
  2006. $returnBooking->setPickUpAddress($booking->getDestinationAddress());
  2007. $returnBooking->setPickUpMapAddress($booking->getDestinationMapAddress());
  2008. $returnBooking->setPickUpPostCode($booking->getDestinationPostCode());
  2009. $returnBooking->setPickUpDate($booking_request->getReturnPickUpDate());
  2010. $returnBooking->setPickUpTime($booking_request->getReturnPickUpTime());
  2011. $returnBooking->setDestinationAddress($booking->getPickUpAddress());
  2012. $returnBooking->setDestinationMapAddress($booking->getPickUpMapAddress());
  2013. $returnBooking->setDestinationPostCode($booking->getPickUpPostCode());
  2014. $returnBooking->setNotes($returnNotes);
  2015. $returnBooking->setQuotePrice($returnPrice);
  2016. $returnBooking->setOverridePrice($returnPrice);
  2017. $returnBooking->setDriverPrice($returnPrice - 1);
  2019. /** @var BookingBookingExtra $bE */
  2020. foreach ($bookingExtras as $bE) {
  2021. $bE->setBooking($returnBooking);
  2022. }
  2023. $returnBooking->setExtras($bookingExtras);
  2025. foreach ($vias_custom as $via) {
  2026. // Vias might already be BookingViasAddress objects.
  2027. if ($via instanceof BookingViasAddress) {
  2028. $new_via = $via;
  2029. } else {
  2030. $new_via = new BookingViasAddress();
  2031. $new_via->setAddress($via['address']);
  2032. $new_via->setMapAddress($via['value']);
  2033. $new_via->setPostCode($via['postcode']);
  2034. }
  2035. $new_via->setBooking($returnBooking);
  2036. $returnBooking->addVias($new_via);
  2037. $this->get('doctrine')->getManager()->persist($new_via);
  2038. }
  2040. $booking->setReturnFlightLandingTime($booking_request->getReturnFlightLandingTime());
  2041. $booking->setReturnFlightNumber($booking_request->getReturnFlightNumber());
  2042. $booking->setReturnPickUpDate($booking_request->getReturnPickUpDate());
  2043. $booking->setReturnPickUpTime($booking_request->getReturnPickUpTime());
  2044. $booking->setReturnBookingNotes($returnNotes);
  2045. $booking->setReturnDriverPrice($returnPrice - 1);
  2046. $booking->setReturnBooking($returnBooking);
  2047. $returnBooking->setParentBooking($booking);
  2049. return $returnBooking;
  2050. }
  2052. public function sendEmailNewBooking($sendEmailCheckBooking, $booking)
  2053. {
  2055. if ($sendEmailCheckBooking) {
  2056. $distance_unit = $this->get('doctrine')->getRepository(Settings::class)->findOneBy([
  2057. 'key' => 'distance_unit',
  2058. ]);
  2059. $distance_unit = $distance_unit ? $distance_unit->getValue() : 'Miles';
  2060. $officeEmail = $this->get('settings_repo')->getOfficeEmail();
  2061. $this->get('mandrill.manager')->sendTemplate(
  2062. MandrillManager::$TEMPLATE_OPERATOR_BOOKING_CHECK, [],
  2063. [
  2064. 'subject' => 'New Booking has been Created - Manual Check Details',
  2065. 'from_email' => $officeEmail,
  2066. 'to' => [
  2067. 'email' => $officeEmail,
  2068. 'name' => 'Twelve Transfers',
  2069. 'type' => 'to',
  2070. ],
  2071. 'global_merge_vars' => [
  2072. "passenger_name" => $booking->getClientFirstName() . ' ' . $booking->getClientLastName(),
  2073. "passenger_phone" => $booking->getClientPhone(),
  2074. "passenger_email" => $booking->getClientEmail(),
  2075. "booking_key" => $booking->getKey(),
  2076. "booking_creation_date" => $booking->getBookingDate()->format('d/m/Y'),
  2077. "booking_creation_time" => $booking->getBookingDate()->format('H:i'),
  2078. "booking_origin" => 'API',
  2079. "booking_pickup_date" => $booking->getPickUpDate()->format('d/m/Y'),
  2080. "booking_pickup_time" => $booking->getPickUpTime(),
  2081. "booking_pickup_location" => $booking->getPickUpAddress(),
  2082. "booking_dropoff_location" => $booking->getDestinationAddress(),
  2083. "booking_vias_content" => "<ul>" . implode("", array_map(function ($address) {
  2084. return "<li>$address</li>";
  2085. }, $booking->getViasAsArray())) . "</ul>",
  2086. "booking_passengers" => $booking->getPassengersNumber(),
  2087. "booking_luggage" => $booking->getCheckinLuggage(),
  2088. "booking_notes" => $booking->getNotes(),
  2089. "booking_cost" => $booking->getOverridePrice(),
  2090. "currency_symbol" => $this->get('currency.service')->getSystemCurrency(),
  2091. "booking_duration" => $booking->getEstimatedTimePrettyFormat(),
  2092. "booking_distance" => $booking->getDistanceUnit() . ' ' . $distance_unit,
  2093. "booking_hand_luggage" => $booking->getHandLuggage(),
  2094. "booking_car_type" => $booking->getCarType()->getName(),
  2095. "flight_number" => !empty($booking->getFlightNumber()) ? $booking->getFlightNumber() : null,
  2096. "landing_time" => $booking->getFlightLandingTime(),
  2097. "mg_timeframe" => $booking->getMeetAndGreetTimePrettyFormat(),
  2098. ],
  2099. 'merge_language' => 'mailchimp',
  2100. ]
  2101. );
  2102. }
  2103. }
  2105. public function getBookingsKeysAction(Request $request)
  2106. {
  2107. $em = $this->get('doctrine')->getManager();
  2108. $search = $request->query->get('search');
  2110. $bookingKeys = [];
  2112. $result = $em->getRepository(Booking::class)->searchByKey($search);
  2114. foreach ($result as $booking) {
  2115. $client = $booking['clientId']
  2116. ? [
  2117. 'id' => $booking['clientId'],
  2118. 'text' => "{$booking['clientFirstName']} {$booking['clientLastName']} - {$booking['phone']} - {$booking['clientEmail']}",
  2119. ]
  2120. : [];
  2122. $driver = $booking['driverId']
  2123. ? [
  2124. 'id' => $booking['driverId'],
  2125. 'text' => "{$booking['driverFirstName']} {$booking['driverLastName']} - {$booking['driverPhone']} - {$booking['driverEmail']}",
  2126. ]
  2127. : [];
  2129. $bookingKeys[] = [
  2130. 'id' => $booking['bookingKey'],
  2131. 'value' => $booking['bookingKey'],
  2132. 'client' => $client,
  2133. 'driver' => $driver,
  2134. ];
  2135. }
  2137. return new JsonResponse($bookingKeys);
  2138. }
  2140. public function adminManualPaymentAction(Request $request)
  2141. {
  2143. $response = [
  2144. 'status' => 400,
  2145. 'message' => 'Something went wrong.',
  2146. ];
  2148. $paymentId = $request->request->get('paymentId');
  2149. $paymentCard = $request->request->get('paymentCard');
  2151. if (!empty($paymentId) and !empty($paymentId)) {
  2152. $payment = $this->getDoctrine()->getRepository(Payment::class)->findOneBy(['id' => $paymentId]);
  2154. if (!empty($payment)) {
  2156. $typeExplode = explode('_', $paymentCard);
  2158. $type = $typeExplode[0];
  2159. $card = $typeExplode[1];
  2161. $response = $this->get('payment.service')->automaticPaymentForCustomer($payment, $type, $card);
  2163. return new JsonResponse($response);
  2165. } else {
  2167. $response = [
  2168. 'status' => 400,
  2169. 'message' => 'Payment not found for this booking.',
  2170. ];
  2172. return new JsonResponse($response);
  2173. }
  2175. } else {
  2176. $response = [
  2177. 'status' => 400,
  2178. 'message' => 'Missing parameters.',
  2179. ];
  2181. return new JsonResponse($response);
  2182. }
  2184. return new JsonResponse($response);
  2185. }
  2187. public function updateBookingExtraOrderAction(Request $request)
  2188. {
  2189. try {
  2191. $bookingExtraIdsSorted = $request->request->get('bookingExtraIdsSorted');
  2193. if(!empty($bookingExtraIdsSorted)) {
  2194. $em = $this->get('doctrine')->getManager();
  2196. $bookingExtras = $em->getRepository(BookingExtra::class)->findAll();
  2197. /** @var BookingExtra $extra */
  2198. foreach ($bookingExtras as $extra) {
  2199. $extra->setPriority(
  2200. intval($bookingExtraIdsSorted[$extra->getId()])
  2201. );
  2203. $em->persist($extra);
  2204. }
  2206. $em->flush();
  2207. }
  2209. return new JsonResponse('ok');
  2210. } catch (\Exception $e) {
  2211. return new JsonResponse('An error has occured!');
  2212. }
  2213. }
  2214. }