src/Framework/AdminBundle/Controller/ResaController.php line 2279

Open in your IDE?
  1. <?php
  3. namespace App\Framework\AdminBundle\Controller;
  5. use Symfony\Component\HttpFoundation\Request;
  6. use Symfony\Component\HttpFoundation\Response;
  7. use Symfony\Component\Routing\Annotation\Route;
  9. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  11. use App\Framework\AppBundle\Entity\Venue;
  12. use App\Framework\AppBundle\Entity\Export;
  13. use App\Framework\AppBundle\Entity\Mail;
  15. use Symfony\Component\Mailer\MailerInterface;
  16. use Symfony\Component\Mime\Email;
  18. class ResaController extends AbstractController
  19. {
  21.     /**
  22.      * @Route("/resa_old", name="palace_manager_resa_old_index")
  23.      */
  25.     public function indexOldAction(Request $request)
  26.     {
  28.         $em = $this->getDoctrine()->getManager();
  30.         $bookings = $em->getRepository('FrameworkAppBundle:Booking')->findBy([], ['id' => 'DESC']);
  32.         $future = strtotime('+4 day');
  34.         return $this->render('AdminBundle/Booking/index.html.twig', [
  35.             'bookings' => $bookings,
  36.             'future' => $future,
  37.         ]);
  38.     }
  41.     /**
  42.      * @Route("/resa", name="palace_manager_resa_index")
  43.      */
  45.     public function indexAction(Request $request)
  46.     {
  48.         $em = $this->getDoctrine()->getManager();
  50.         $future = strtotime('+4 day');
  52.         return $this->render('AdminBundle/Booking/index2.html.twig', [
  53.             'future' => $future,
  54.         ]);
  55.     }
  58.     /**
  59.      * @Route("/resa/{id}", name="palace_manager_resa_edit", requirements={"id" = "([a-z\-0-9]+)"})
  60.      */
  62.     public function editAction(Request $request, $id = NULL)
  63.     {
  65.         $em = $this->getDoctrine()->getManager();
  67.         $booking = $em->getRepository('FrameworkAppBundle:Booking')->findOneById($id);
  68.         $mails = $em->getRepository('FrameworkAppBundle:Mail')->findBy(['booking' => $booking->getId()], ['createdAt' => 'DESC']);
  69.         $venues = $em->getRepository('FrameworkAppBundle:Venue')->getNextVenues();
  71.         return $this->render('AdminBundle/Booking/edit.html.twig', [
  72.             'booking' => $booking,
  73.             'mails' => $mails,
  74.             'locale' => 'fr',
  75.             'venues' => $venues,
  76.             'iframe' => $request->get('iframe')
  77.         ]);
  78.     }
  80.     /**
  81.      * @Route("/resa/mailsingle/{id}", name="palace_manager_resa_mailsingle", requirements={"id" = "([a-z\-0-9]+)"})
  82.      */
  84.     public function mailsingleAction(Request $request, $id = NULL, MailerInterface $mailer)
  85.     {
  87.         $em = $this->getDoctrine()->getManager();
  88.         $globals = $this->get("twig")->getGlobals();
  90.         $success = true;
  91.         $error = $slug = '';
  93.         $booking = $em->getRepository('FrameworkAppBundle:Booking')->findOneById($id);
  95.         // ENREGISTREMENT LOG MAIL
  96.         $mail = New Mail();
  97.         $mail->setBooking($booking);
  98.         $mail->setEmailTitle($request->get('emailTitle'));
  99.         $mail->setEmailContent($request->get('emailContent'));
  100.         $em->persist($mail);
  101.         $em->flush();
  102.         // FIN ENREGISTREMENT LOG MAIL
  104.         $title = $request->get('emailTitle');
  105.         $content =  str_replace("\n\r", '<br>', $request->get('emailContent'));
  106.         $content =  str_replace("\n", '<br>', $content);
  109.         //ENVOI EMAIL
  110.         $from = $globals['app_email_noreply'];
  111.         $to = $booking->getUser()->getEmail();
  112.         $contact = $globals['app_email_contact'];
  114.         $email = (new Email())
  115.             ->from($from)
  116.             ->to($to)
  117.             //->cc('cc@example.com')
  118.             //->bcc('bcc@example.com')
  119.             ->replyTo($contact)
  120.             //->priority(Email::PRIORITY_HIGH)
  121.             ->subject($title)
  122.             // ->text($content)
  123.             ->html($this->renderView(
  124.                 'FrontBundle/Emails/general.html.twig', array(
  125.                     'title'   => $title,
  126.                     'content' => $content,
  127.                 )
  128.             ));
  131.         $mailer->send($email);
  132.         //FIN ENVOI EMAIL
  134.         $data = [
  135.             'error' => $error,
  136.             'success' => $success
  137.         ];
  139.         $response = new Response(json_encode($data));
  140.         $response->headers->set('Content-Type', 'application/json');
  141.         return $response;
  143.     }
  145.     /**
  146.      * @Route("/resa/mailload/{id}", name="palace_manager_resa_mailload", requirements={"id" = "([a-z\-0-9]+)"})
  147.      */
  149.     public function mailloadAction(Request $request, $id = NULL)
  150.     {
  152.         $em = $this->getDoctrine()->getManager();
  154.         $booking = $em->getRepository('FrameworkAppBundle:Booking')->findOneById($id);
  155.         $mails = $em->getRepository('FrameworkAppBundle:Mail')->findBy(['booking' => $booking->getId()], ['createdAt' => 'DESC']);
  156.         $mailsArr = [];
  159.         foreach ($mails as $key => $value) {
  160.             $content =  str_replace("\n\r", '<br>', $value->getEmailContent());
  161.             $content =  str_replace("\n", '<br>', $content);
  163.             $title = $value->getEmailTitle();
  164.             if($title == null){
  165.                 $title = '';
  166.             }
  168.             $mailsArr[] = [
  169.                 'title' => $title,
  170.                 'content' => $content,
  171.                 // 'date' => date("Y-m-d H:i", strtotime($value->getCreatedAt()->format('Y-m-d H:i').' + 2 hours')),
  172.                 'date' => date("Y-m-d H:i", strtotime($value->getCreatedAt()->format('Y-m-d H:i'))),
  173.             ];
  174.         }
  176.         $data = [
  177.             'mails' => $mailsArr
  178.         ];
  180.         $response = new Response(json_encode($data));
  181.         $response->headers->set('Content-Type', 'application/json');
  182.         return $response;
  184.     }
  187.     /**
  188.      * @Route("/resa/save/{id}", name="palace_manager_resa_save", requirements={"id" = "([a-z\-0-9]+)"})
  189.      */
  191.     public function saveAction(Request $request, $id = NULL)
  192.     {
  194.         $em = $this->getDoctrine()->getManager();
  196.         $success = true;
  197.         $error = $slug = '';
  199.         $booking = $em->getRepository('FrameworkAppBundle:Booking')->findOneById($id);
  201.         $booking->setOptions($request->get('options'));
  202.         $booking->setAmount(floatval(str_replace(',', '.', $request->get('amount'))));
  203.         $booking->setAmountShow(floatval(str_replace(',', '.', $request->get('amountShow'))));
  204.         $booking->setState(intval($request->get('state')));
  205.         $booking->setAction(NULL);
  206.         $booking->setVenueTitle($request->get('venueTitle'));
  207.         $booking->setEmailContent($request->get('emailContent'));
  209.         if( $request->get('venueId') != $booking->getVenue()->getId() ){
  210.             $venue = $em->getRepository('FrameworkAppBundle:Venue')->findOneById($request->get('venueId'));
  211.             if($venue){
  212.                 $booking->setVenue($venue);
  213.             }
  214.         }
  217. //FIX EXPORT ERROR CARD -> MANUAL VALIDATION
  218.         $state = intval($request->get('state'));
  219.         if( $booking->getPaymentType() == 'card' || $booking->getPaymentType() == 'klarna' || $booking->getPaymentType() == 'paypal' ){
  220.             if( $state == 2 || $state == 6 ){
  221.                 $booking->setStatus('succeeded');
  222.             }
  223.         }
  224. //END FIX
  226.         $booking->setAlerting(NULL);
  228.         $em->persist($booking);
  229.         $em->flush();
  232.         $data = [
  233.             'error' => $error,
  234.             'success' => $success
  235.         ];
  237.         $response = new Response(json_encode($data));
  238.         $response->headers->set('Content-Type', 'application/json');
  239.         return $response;
  240.     }
  246.     /**
  247.      * @Route("/export-download/{id}", name="palace_manager_export_download", requirements={"id" = "([a-z\-0-9]+)"})
  248.      */
  250.     public function exportDownloadAction(Request $request, $id = NULL)
  251.     {
  253.         $em = $this->getDoctrine()->getManager();
  254.         $globals = $this->get("twig")->getGlobals();
  256.         $export = $em->getRepository('FrameworkAppBundle:Export')->findOneById($id);
  258.         header('Content-Description: File Transfer');
  259.         header('Content-Type: application/octet-stream');
  260.         header('Content-Disposition: attachment; filename="'.$export->getName().'"');
  261.         header('Content-Transfer-Encoding: binary');
  262.         header('Expires: 0');
  263.         header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
  264.         header('Pragma: public');
  265.         header('Content-Length: ' . filesize($export->getFile())); //Absolute URL
  266.         ob_clean();
  267.         flush();
  268.         readfile($export->getFile()); //Absolute URL
  269.         exit();
  272.     }
  276.     /**
  277.      * @Route("/export-download-full/{id}", name="palace_manager_export_download_full", requirements={"id" = "([a-z\-0-9]+)"})
  278.      */
  280.     public function exportDownloadFullAction(Request $request, $id = NULL)
  281.     {
  283.         $em = $this->getDoctrine()->getManager();
  284.         $globals = $this->get("twig")->getGlobals();
  286.         $export = $em->getRepository('FrameworkAppBundle:Export')->findOneById($id);
  288.         $csvFile = file($export->getFile());
  289.         $data = $ids = [];
  290.         foreach ($csvFile as $line) {
  291.             $data[] = str_getcsv($line);
  292.         }
  293.         array_shift($data);
  294.         array_pop($data);
  297.         foreach ($data as $key => $value) {
  298.             $tmp = explode(';', $value[0]);
  299.             $ids[] = $tmp[0];
  300.         }
  305.         $total = $total_rs = $total_am = 0;
  307.         $date = date('Y-m-d_H-i-s');
  309.         $rows = [];
  311.         $rows[] = [
  312.             'ID',
  313.             'Date de paiement',
  314.             // 'Type',
  315.             'Client',
  316.             'Adresse',
  317.             'Envoi',
  318.             'Commande',
  319.             'Total',
  320.             'AM',
  321.             'RS',
  322.             'Manuel'
  323.             // 'ID Stripe'
  324.         ];
  326.         foreach ($ids as $key => $id) {
  327.             $order = $em->getRepository('FrameworkAppBundle:Order')->findOneByBaseId($id);
  329.             $envoi = 'E-Billet';
  330.             foreach ($order->getCartArr2() as $item_key => $item) {
  332.                 if( $item['gift'] == 'true' ){
  333.                     $envoi = 'Courrier';
  334.                 }
  335.             }
  336.             if($envoi == 'Courrier'){
  337.                 $client = ucwords(strtolower($order->getInfo('firstname'))).' '.strtoupper($order->getInfo('lastname'))."\n";
  339.                 if($order->getInfo('company') != ''){
  340.                     $client .= ucwords(strtolower($order->getInfo('company')))."\n";
  341.                 }
  343.                 $client .= $order->getUser()->getEmail()."\n".$order->getInfo('phone');
  344.                 $address = $order->getInfo('address')."\n".$order->getInfo('zipcode').' '.$order->getInfo('city')."\n".$order->getInfo('country');
  346.                 $cart = '';
  347.                 $index = 1;
  348.                 foreach ($order->getCart() as $key => $item) {
  351.                     if($index > 1){
  352.                         $cart .= "\n";
  353.                     }
  354.                     $cart .= $order->getBaseId().'-'.$index.' | '.$item->name->fr.' x'.$item->quantity;
  355.                     if($item->for != ''){
  356.                         $cart .= ' pour : '.$item->for;
  357.                     }
  358.                     if(isset($item->options) && $item->options != ''){
  359.                         foreach ($item->options as $key2 => $option) {
  360.                             $cart .= "\n".'+ '.$option->name.' x'.$option->qty;
  361.                         }
  362.                     }
  364.                     $index++;
  365.                 }
  368.                 $rows[] = [
  369.                     $order->getBaseId(),
  370.                     date('d/m/Y', $order->getResult()->created),
  371.                     // 'BON C.',
  372.                     $client,
  373.                     $address,
  374.                     $envoi,
  375.                     // $order->getRecap(true),
  376.                     $cart,
  377.                     ($order->getAmount() + $order->getAmountShow()),
  378.                     $order->getAmount(),
  379.                     $order->getAmountShow(),
  380.                     ($order->getManual()) ? 'M' : '',
  381.                     // $order->getResult()->id
  382.                 ];
  384.                 $total = $total + ($order->getAmount() + $order->getAmountShow());
  385.                 $total_am = $total_am + $order->getAmount();
  386.                 $total_rs = $total_rs + $order->getAmountShow();
  387.             }
  389.         }
  392.         //2D ROUND
  393.         foreach ($ids as $key => $id) {
  394.             $order = $em->getRepository('FrameworkAppBundle:Order')->findOneByBaseId($id);
  396.             $envoi = 'E-Billet';
  397.             foreach ($order->getCartArr2() as $item_key => $item) {
  399.                 if( $item['gift'] == 'true' ){
  400.                     $envoi = 'Courrier';
  401.                 }
  402.             }
  403.             if($envoi == 'E-Billet'){
  404.                 $client = ucwords(strtolower($order->getInfo('firstname'))).' '.strtoupper($order->getInfo('lastname'))."\n";
  406.                 if($order->getInfo('company') != ''){
  407.                     $client .= ucwords(strtolower($order->getInfo('company')))."\n";
  408.                 }
  410.                 $client .= $order->getUser()->getEmail()."\n".$order->getInfo('phone');
  411.                 $address = $order->getInfo('address')."\n".$order->getInfo('zipcode').' '.$order->getInfo('city')."\n".$order->getInfo('country');
  413.                 $cart = '';
  414.                 $index = 1;
  415.                 foreach ($order->getCart() as $key => $item) {
  418.                     if($index > 1){
  419.                         $cart .= "\n";
  420.                     }
  421.                     $cart .= $order->getBaseId().'-'.$index.' | '.$item->name->fr.' x'.$item->quantity;
  422.                     if($item->for != ''){
  423.                         $cart .= ' pour : '.$item->for;
  424.                     }
  425.                     if(isset($item->options) && $item->options != ''){
  426.                         foreach ($item->options as $key2 => $option) {
  427.                             $cart .= "\n".'+ '.$option->name.' x'.$option->qty;
  428.                         }
  429.                     }
  431.                     $index++;
  432.                 }
  435.                 $rows[] = [
  436.                     $order->getBaseId(),
  437.                     date('d/m/Y', $order->getResult()->created),
  438.                     // 'BON C.',
  439.                     $client,
  440.                     $address,
  441.                     $envoi,
  442.                     // $order->getRecap(true),
  443.                     $cart,
  444.                     ($order->getAmount() + $order->getAmountShow()),
  445.                     $order->getAmount(),
  446.                     $order->getAmountShow(),
  447.                     ($order->getManual()) ? 'M' : '',
  448.                     // $order->getResult()->id
  449.                 ];
  451.                 $total = $total + ($order->getAmount() + $order->getAmountShow());
  452.                 $total_am = $total_am + $order->getAmount();
  453.                 $total_rs = $total_rs + $order->getAmountShow();
  454.             }
  456.         }
  459.         $rows[] = [
  460.             '',
  461.             '',
  462.             '',
  463.             '',
  464.             '',
  465.             'Export détaillé : '.$date,
  466.             $total,
  467.             $total_am,
  468.             $total_rs,
  469.             ''
  470.         ];
  473.         //ENREGISTREMENT DU CSV
  474.         $path = str_replace('.csv', '_full.csv', $export->getFile());
  475.         $name = str_replace('.csv', '_full.csv', $export->getName());
  476.         $fp = fopen($path, 'w'); // open in write only mode (write at the start of the file)
  477.         fprintf($fp, chr(0xEF).chr(0xBB).chr(0xBF));
  479.         foreach ($rows as $row) {
  480.             fputcsv($fp, $row, ";");
  481.         }
  482.         fclose($fp);
  487.         header('Content-Description: File Transfer');
  488.         header('Content-Type: application/octet-stream');
  489.         header('Content-Disposition: attachment; filename="'.$name.'"');
  490.         header('Content-Transfer-Encoding: binary');
  491.         header('Expires: 0');
  492.         header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
  493.         header('Pragma: public');
  494.         header('Content-Length: ' . filesize($path)); //Absolute URL
  495.         ob_clean();
  496.         flush();
  497.         readfile($path); //Absolute URL
  498.         exit();
  501.     }
  504.     /**
  505.      * @Route("/resa-exports", name="palace_manager_resa_exports", requirements={"id" = "([a-z\-0-9]+)"})
  506.      */
  508.     public function exportsResaAction(Request $request, $id = NULL, MailerInterface $mailer)
  509.     {
  511.         $em = $this->getDoctrine()->getManager();
  512.         $globals = $this->get("twig")->getGlobals();
  514.         $exports = $em->getRepository('FrameworkAppBundle:Export')->findBy(['type' => 'resa'], ['createdAt' => 'DESC']);
  516.         return $this->render('AdminBundle/Booking/exports.html.twig', [
  517.             'exports' => $exports,
  518.             'locale' => 'fr',
  519.         ]);
  520.     }
  523.     /**
  524.      * @Route("/resa-exports-ticketing", name="palace_manager_resa_exports_ticketing", requirements={"id" = "([a-z\-0-9]+)"})
  525.      */
  527.     public function exportsTicketingResaAction(Request $request, $id = NULL, MailerInterface $mailer)
  528.     {
  530.         $em = $this->getDoctrine()->getManager();
  531.         $globals = $this->get("twig")->getGlobals();
  533.         $exports = $em->getRepository('FrameworkAppBundle:Export')->findBy(['type' => 'ticketing'], ['createdAt' => 'DESC']);
  535.         return $this->render('AdminBundle/Booking/exports_ticketing.html.twig', [
  536.             'exports' => $exports,
  537.             'locale' => 'fr',
  538.         ]);
  539.     }
  542.     /**
  543.      * @Route("/resa-exports-generate", name="palace_manager_resa_exports_generate", requirements={"id" = "([a-z\-0-9]+)"})
  544.      */
  546.     public function exportResaGenerateAction(Request $request, $id = NULL, MailerInterface $mailer)
  547.     {
  550.         $success = false;
  551.         $error = $slug = '';
  554.         $em = $this->getDoctrine()->getManager();
  555.         $globals = $this->get("twig")->getGlobals();
  557.         $total = $total_rs = $total_am = 0;
  559.         $date = date('Y-m-d_H-i-s');
  561.         $rows = [];
  563.         $rows[] = [
  564.             'ID',
  565.             'Date de paiement',
  566.             'Type',
  567.             'Paiement',
  568.             'Client',
  569.             'Date',
  570.             'Total',
  571.             'AM',
  572.             'RS',
  573.             'ID Stripe'
  574.         ];
  576.         $bookings = $em->getRepository('FrameworkAppBundle:Booking')->findBy(['exported' => NULL, 'isflash' => NULL, 'status' => 'succeeded', 'paymentType' => ['card','klarna','paypal'] ], ['paymentType' => 'DESC', 'createdAt' => 'ASC']);
  578.         if( sizeof($bookings) > 0 ){
  581.             foreach ($bookings as $key => $booking) {
  583.                 if($booking->getInfo('gift') == 'true'){
  584.                     if( $booking->getResult() == null ){
  585.                         $created = $booking->getCreatedAt()->format('d/m/Y');
  586.                         $result_id = '';
  587.                     } else {
  588.                         $created = date('d/m/Y', $booking->getResult()->created);
  589.                         $result_id = $booking->getResult()->id;
  590.                     }
  592.                     $rows[] = [
  593.                         $booking->getBaseId(),
  594.                         $created,
  595.                         'RESA',
  596.                         $booking->getPaymentType(),
  597.                         ucwords(strtolower($booking->getInfo('firstname'))).' '.strtoupper($booking->getInfo('lastname')),
  598.                         $booking->getVenueTitle(),
  599.                         ($booking->getAmount() + $booking->getAmountShow()),
  600.                         $booking->getAmount(),
  601.                         $booking->getAmountShow(),
  602.                         $result_id
  603.                     ];
  605.                     $total = $total + ($booking->getAmount() + $booking->getAmountShow());
  606.                     $total_am = $total_am + $booking->getAmount();
  607.                     $total_rs = $total_rs + $booking->getAmountShow();
  609.                     $booking->setState(6);
  610.                     $booking->setExported(1);
  611.                     $em->persist($booking);
  612.                     $em->flush();
  614.                 }
  616.             }
  619.             //2D ROUND
  621.             foreach ($bookings as $key => $booking) {
  623.                 if($booking->getInfo('gift') != 'true'){
  624.                     if( $booking->getResult() == null ){
  625.                         $created = $booking->getCreatedAt()->format('d/m/Y');
  626.                         $result_id = '';
  627.                     } else {
  628.                         $created = date('d/m/Y', $booking->getResult()->created);
  629.                         $result_id = $booking->getResult()->id;
  630.                     }
  632.                     $rows[] = [
  633.                         $booking->getBaseId(),
  634.                         $created,
  635.                         'RESA',
  636.                         $booking->getPaymentType(),
  637.                         ucwords(strtolower($booking->getInfo('firstname'))).' '.strtoupper($booking->getInfo('lastname')),
  638.                         $booking->getVenueTitle(),
  639.                         ($booking->getAmount() + $booking->getAmountShow()),
  640.                         $booking->getAmount(),
  641.                         $booking->getAmountShow(),
  642.                         $result_id
  643.                     ];
  645.                     $total = $total + ($booking->getAmount() + $booking->getAmountShow());
  646.                     $total_am = $total_am + $booking->getAmount();
  647.                     $total_rs = $total_rs + $booking->getAmountShow();
  649.                     $booking->setState(6);
  650.                     $booking->setExported(1);
  651.                     $em->persist($booking);
  652.                     $em->flush();
  654.                 }
  656.             }
  659.             $rows[] = [
  660.                 '',
  661.                 '',
  662.                 '',
  663.                 '',
  664.                 'Export : '.$date,
  665.                 $total,
  666.                 $total_am,
  667.                 $total_rs,
  668.                 ''
  669.             ];
  671.             //ENREGISTREMENT DU CSV
  672.             $path = $globals['export_folder'].'exports_booking/R_'.$date.'.csv';
  673.             $fp = fopen($path, 'w'); // open in write only mode (write at the start of the file)
  674.             fprintf($fp, chr(0xEF).chr(0xBB).chr(0xBF));
  676.             foreach ($rows as $row) {
  677.                 fputcsv($fp, $row, ";");
  678.             }
  679.             fclose($fp);
  682.             //ENREGISTREMENT BASE
  683.             $export = new Export();
  684.             $export->setType('resa');
  685.             $export->setFile($path);
  686.             $export->setName('R_'.$date.'.csv');
  687.             $em->persist($export);
  688.             $em->flush();
  691.             //ENVOI EMAIL COMPTA
  692.             $from = $globals['app_email_noreply'];
  693.             $to = $globals['app_email_compta'];
  694.             $contact = $globals['app_email_contact'];
  697.             $email = (new Email())
  698.                 ->from($from)
  699.                 ->to($to)
  700.                 ->cc($globals['app_email_contact'])
  701.                 //->bcc('bcc@example.com')
  702.                 ->replyTo($contact)
  703.                 //->priority(Email::PRIORITY_HIGH)
  705.                 ->attachFromPath($path)
  707.                 ->subject('Nouvel export RESERVATIONS CB Stripe '.$date)
  708.                 ->text(nl2br('Nouvel export RESERVATIONS CB Stripe généré le '.$date));
  712.             $mailer->send($email);
  713.             //FIN ENVOI EMAIL COMPTA
  714.             $success = true;
  716.         } else {
  717.             $error = 'Aucun nouveau paiement à exporter';
  718.         }
  724.         $data = [
  725.             'error' => $error,
  726.             'success' => $success
  727.         ];
  729.         $response = new Response(json_encode($data));
  730.         $response->headers->set('Content-Type', 'application/json');
  731.         return $response;
  735.     }
  758.     /**
  759.      * @Route("/resa-exports-generate-preview", name="palace_manager_resa_exports_generate_preview", requirements={"id" = "([a-z\-0-9]+)"})
  760.      */
  762.     public function exportResaGeneratePreviewAction(Request $request, $id = NULL, MailerInterface $mailer)
  763.     {
  766.         $success = false;
  767.         $error = $slug = $html = '';
  770.         $em = $this->getDoctrine()->getManager();
  771.         $globals = $this->get("twig")->getGlobals();
  773.         $total = $total_rs = $total_am = 0;
  775.         $date = date('Y-m-d_H-i-s');
  777.         $rows = [];
  779.         $rows[] = [
  780.             'ID',
  781.             'Date de paiement',
  782.             'Type',
  783.             'Paiement',
  784.             'Client',
  785.             'Date',
  786.             'Total',
  787.             'AM',
  788.             'RS',
  789.             'ID Stripe'
  790.         ];
  792.         $bookings = $em->getRepository('FrameworkAppBundle:Booking')->findBy(['exported' => NULL, 'isflash' => NULL, 'status' => 'succeeded', 'paymentType' => ['card','klarna','paypal'] ], ['paymentType' => 'DESC', 'createdAt' => 'ASC']);
  794.         if( sizeof($bookings) > 0 ){
  797.             foreach ($bookings as $key => $booking) {
  799.                 if($booking->getInfo('gift') == 'true'){
  800.                     if( $booking->getResult() == null ){
  801.                         $created = $booking->getCreatedAt()->format('d/m/Y');
  802.                         $result_id = '';
  803.                     } else {
  804.                         $created = date('d/m/Y', $booking->getResult()->created);
  805.                         $result_id = $booking->getResult()->id;
  806.                     }
  808.                     $rows[] = [
  809.                         $booking->getBaseId(),
  810.                         $created,
  811.                         'RESA',
  812.                         $booking->getPaymentType(),
  813.                         ucwords(strtolower($booking->getInfo('firstname'))).' '.strtoupper($booking->getInfo('lastname')),
  814.                         $booking->getVenueTitle(),
  815.                         ($booking->getAmount() + $booking->getAmountShow()),
  816.                         $booking->getAmount(),
  817.                         $booking->getAmountShow(),
  818.                         $result_id
  819.                     ];
  821.                     $total = $total + ($booking->getAmount() + $booking->getAmountShow());
  822.                     $total_am = $total_am + $booking->getAmount();
  823.                     $total_rs = $total_rs + $booking->getAmountShow();
  826.                 }
  828.             }
  831.             //2D ROUND
  833.             foreach ($bookings as $key => $booking) {
  835.                 if($booking->getInfo('gift') != 'true'){
  836.                     if( $booking->getResult() == null ){
  837.                         $created = $booking->getCreatedAt()->format('d/m/Y');
  838.                         $result_id = '';
  839.                     } else {
  840.                         $created = date('d/m/Y', $booking->getResult()->created);
  841.                         $result_id = $booking->getResult()->id;
  842.                     }
  844.                     $rows[] = [
  845.                         $booking->getBaseId(),
  846.                         $created,
  847.                         'RESA',
  848.                         $booking->getPaymentType(),
  849.                         ucwords(strtolower($booking->getInfo('firstname'))).' '.strtoupper($booking->getInfo('lastname')),
  850.                         $booking->getVenueTitle(),
  851.                         ($booking->getAmount() + $booking->getAmountShow()),
  852.                         $booking->getAmount(),
  853.                         $booking->getAmountShow(),
  854.                         $result_id
  855.                     ];
  857.                     $total = $total + ($booking->getAmount() + $booking->getAmountShow());
  858.                     $total_am = $total_am + $booking->getAmount();
  859.                     $total_rs = $total_rs + $booking->getAmountShow();
  862.                 }
  864.             }
  867.             $rows[] = [
  868.                 '',
  869.                 '',
  870.                 '',
  871.                 '',
  872.                 'Export : '.$date,
  873.                 $total,
  874.                 $total_am,
  875.                 $total_rs,
  876.                 ''
  877.             ];
  879.             $html = '<table class="exporting"><tbody>';
  880.             foreach ($rows as $key => $row) {
  881.                 $html .= '<tr>';
  882.                 foreach ($row as $key2 => $column) {
  883.                     $html .= '<td>'.$column.'</td>';
  884.                 }
  885.                 $html .= '</tr>';
  886.             }
  887.             $html .= '</tbody></table>';
  890.             $success = true;
  892.         } else {
  893.             $error = 'Aucun nouveau paiement à exporter';
  894.         }
  897.         $data = [
  898.             'error' => $error,
  899.             'success' => $success,
  900.             'html' => $html
  901.         ];
  903.         $response = new Response(json_encode($data));
  904.         $response->headers->set('Content-Type', 'application/json');
  905.         return $response;
  908.     }
  930.     /**
  931.      * @Route("/resa-exports-generate-ticketing", name="palace_manager_resa_exports_generate_ticketing", requirements={"id" = "([a-z\-0-9]+)"})
  932.      */
  934.     public function exportResaGenerateTicketingAction(Request $request, $id = NULL, MailerInterface $mailer)
  935.     {
  938.         $success = false;
  939.         $error = $slug = '';
  942.         $em = $this->getDoctrine()->getManager();
  943.         $globals = $this->get("twig")->getGlobals();
  945.         $total = $total_rs = $total_am = 0;
  947.         $date = date('Y-m-d_H-i-s');
  949.         $rows = [];
  951.         $rows[] = [
  952.             'ID',
  953.             'Date de paiement',
  954.             'Type',
  955.             'Paiement',
  956.             'Client',
  957.             'Date',
  958.             'Total',
  959.             'AM',
  960.             'RS',
  961.             'ID Stripe'
  962.         ];
  964.         $bookings = $em->getRepository('FrameworkAppBundle:Booking')->findBy(['exported' => NULL, 'isflash' => 1, 'status' => 'succeeded', 'paymentType' => ['card','klarna','paypal'] ], ['paymentType' => 'DESC', 'createdAt' => 'ASC']);
  966.         if( sizeof($bookings) > 0 ){
  969.             foreach ($bookings as $key => $booking) {
  971.                 if($booking->getInfo('gift') == 'true'){
  972.                     if( $booking->getResult() == null ){
  973.                         $created = $booking->getCreatedAt()->format('d/m/Y');
  974.                         $result_id = '';
  975.                     } else {
  976.                         $created = date('d/m/Y', $booking->getResult()->created);
  977.                         $result_id = $booking->getResult()->id;
  978.                     }
  980.                     $rows[] = [
  981.                         $booking->getBaseId(),
  982.                         $created,
  983.                         'RESA (T)',
  984.                         $booking->getPaymentType(),
  985.                         ucwords(strtolower($booking->getInfo('firstname'))).' '.strtoupper($booking->getInfo('lastname')),
  986.                         $booking->getVenueTitle(),
  987.                         ($booking->getAmount() + $booking->getAmountShow()),
  988.                         $booking->getAmount(),
  989.                         $booking->getAmountShow(),
  990.                         $result_id
  991.                     ];
  993.                     $total = $total + ($booking->getAmount() + $booking->getAmountShow());
  994.                     $total_am = $total_am + $booking->getAmount();
  995.                     $total_rs = $total_rs + $booking->getAmountShow();
  997.                     $booking->setState(6);
  998.                     $booking->setExported(1);
  999.                     $em->persist($booking);
  1000.                     $em->flush();
  1002.                 }
  1004.             }
  1007.             //2D ROUND
  1009.             foreach ($bookings as $key => $booking) {
  1011.                 if($booking->getInfo('gift') != 'true'){
  1012.                     if( $booking->getResult() == null ){
  1013.                         $created = $booking->getCreatedAt()->format('d/m/Y');
  1014.                         $result_id = '';
  1015.                     } else {
  1016.                         $created = date('d/m/Y', $booking->getResult()->created);
  1017.                         $result_id = $booking->getResult()->id;
  1018.                     }
  1020.                     $rows[] = [
  1021.                         $booking->getBaseId(),
  1022.                         $created,
  1023.                         'RESA (T)',
  1024.                         $booking->getPaymentType(),
  1025.                         ucwords(strtolower($booking->getInfo('firstname'))).' '.strtoupper($booking->getInfo('lastname')),
  1026.                         $booking->getVenueTitle(),
  1027.                         ($booking->getAmount() + $booking->getAmountShow()),
  1028.                         $booking->getAmount(),
  1029.                         $booking->getAmountShow(),
  1030.                         $result_id
  1031.                     ];
  1033.                     $total = $total + ($booking->getAmount() + $booking->getAmountShow());
  1034.                     $total_am = $total_am + $booking->getAmount();
  1035.                     $total_rs = $total_rs + $booking->getAmountShow();
  1037.                     $booking->setState(6);
  1038.                     $booking->setExported(1);
  1039.                     $em->persist($booking);
  1040.                     $em->flush();
  1042.                 }
  1044.             }
  1047.             $rows[] = [
  1048.                 '',
  1049.                 '',
  1050.                 '',
  1051.                 '',
  1052.                 'Export : '.$date,
  1053.                 $total,
  1054.                 $total_am,
  1055.                 $total_rs,
  1056.                 ''
  1057.             ];
  1059.             //ENREGISTREMENT DU CSV
  1060.             $path = $globals['export_folder'].'exports_booking/T_'.$date.'.csv';
  1061.             $fp = fopen($path, 'w'); // open in write only mode (write at the start of the file)
  1062.             fprintf($fp, chr(0xEF).chr(0xBB).chr(0xBF));
  1064.             foreach ($rows as $row) {
  1065.                 fputcsv($fp, $row, ";");
  1066.             }
  1067.             fclose($fp);
  1070.             //ENREGISTREMENT BASE
  1071.             $export = new Export();
  1072.             $export->setType('ticketing');
  1073.             $export->setFile($path);
  1074.             $export->setName('T_'.$date.'.csv');
  1075.             $em->persist($export);
  1076.             $em->flush();
  1079.             //ENVOI EMAIL COMPTA
  1080.             $from = $globals['app_email_noreply'];
  1081.             $to = $globals['app_email_compta'];
  1082.             $contact = $globals['app_email_contact'];
  1085.             $email = (new Email())
  1086.                 ->from($from)
  1087.                 ->to($to)
  1088.                 ->cc($globals['app_email_contact'])
  1089.                 //->bcc('bcc@example.com')
  1090.                 ->replyTo($contact)
  1091.                 //->priority(Email::PRIORITY_HIGH)
  1093.                 ->attachFromPath($path)
  1095.                 ->subject('Nouvel export RESERVATIONS CB Stripe '.$date)
  1096.                 ->text(nl2br('Nouvel export RESERVATIONS CB Stripe généré le '.$date));
  1100.             $mailer->send($email);
  1101.             //FIN ENVOI EMAIL COMPTA
  1102.             $success = true;
  1104.         } else {
  1105.             $error = 'Aucun nouveau paiement à exporter';
  1106.         }
  1112.         $data = [
  1113.             'error' => $error,
  1114.             'success' => $success
  1115.         ];
  1117.         $response = new Response(json_encode($data));
  1118.         $response->headers->set('Content-Type', 'application/json');
  1119.         return $response;
  1123.     }
  1156.     /**
  1157.      * @Route("/resa-exports-generate-ticketing-preview", name="palace_manager_resa_exports_generate_ticketing_preview", requirements={"id" = "([a-z\-0-9]+)"})
  1158.      */
  1160.     public function exportResaGenerateTicketingPreviewAction(Request $request, $id = NULL, MailerInterface $mailer)
  1161.     {
  1164.         $success = false;
  1165.         $error = $slug = $html = '';
  1168.         $em = $this->getDoctrine()->getManager();
  1169.         $globals = $this->get("twig")->getGlobals();
  1171.         $total = $total_rs = $total_am = 0;
  1173.         $date = date('Y-m-d_H-i-s');
  1175.         $rows = [];
  1177.         $rows[] = [
  1178.             'ID',
  1179.             'Date de paiement',
  1180.             'Type',
  1181.             'Paiement',
  1182.             'Client',
  1183.             'Date',
  1184.             'Total',
  1185.             'AM',
  1186.             'RS',
  1187.             'ID Stripe'
  1188.         ];
  1190.         $bookings = $em->getRepository('FrameworkAppBundle:Booking')->findBy(['exported' => NULL, 'isflash' => 1, 'status' => 'succeeded', 'paymentType' => ['card','klarna','paypal'] ], ['paymentType' => 'DESC', 'createdAt' => 'ASC']);
  1192.         if( sizeof($bookings) > 0 ){
  1195.             foreach ($bookings as $key => $booking) {
  1197.                 if($booking->getInfo('gift') == 'true'){
  1198.                     if( $booking->getResult() == null ){
  1199.                         $created = $booking->getCreatedAt()->format('d/m/Y');
  1200.                         $result_id = '';
  1201.                     } else {
  1202.                         $created = date('d/m/Y', $booking->getResult()->created);
  1203.                         $result_id = $booking->getResult()->id;
  1204.                     }
  1206.                     $rows[] = [
  1207.                         $booking->getBaseId(),
  1208.                         $created,
  1209.                         'RESA (T)',
  1210.                         $booking->getPaymentType(),
  1211.                         ucwords(strtolower($booking->getInfo('firstname'))).' '.strtoupper($booking->getInfo('lastname')),
  1212.                         $booking->getVenueTitle(),
  1213.                         ($booking->getAmount() + $booking->getAmountShow()),
  1214.                         $booking->getAmount(),
  1215.                         $booking->getAmountShow(),
  1216.                         $result_id
  1217.                     ];
  1219.                     $total = $total + ($booking->getAmount() + $booking->getAmountShow());
  1220.                     $total_am = $total_am + $booking->getAmount();
  1221.                     $total_rs = $total_rs + $booking->getAmountShow();
  1224.                 }
  1226.             }
  1229.             //2D ROUND
  1231.             foreach ($bookings as $key => $booking) {
  1233.                 if($booking->getInfo('gift') != 'true'){
  1234.                     if( $booking->getResult() == null ){
  1235.                         $created = $booking->getCreatedAt()->format('d/m/Y');
  1236.                         $result_id = '';
  1237.                     } else {
  1238.                         $created = date('d/m/Y', $booking->getResult()->created);
  1239.                         $result_id = $booking->getResult()->id;
  1240.                     }
  1242.                     $rows[] = [
  1243.                         $booking->getBaseId(),
  1244.                         $created,
  1245.                         'RESA (T)',
  1246.                         $booking->getPaymentType(),
  1247.                         ucwords(strtolower($booking->getInfo('firstname'))).' '.strtoupper($booking->getInfo('lastname')),
  1248.                         $booking->getVenueTitle(),
  1249.                         ($booking->getAmount() + $booking->getAmountShow()),
  1250.                         $booking->getAmount(),
  1251.                         $booking->getAmountShow(),
  1252.                         $result_id
  1253.                     ];
  1255.                     $total = $total + ($booking->getAmount() + $booking->getAmountShow());
  1256.                     $total_am = $total_am + $booking->getAmount();
  1257.                     $total_rs = $total_rs + $booking->getAmountShow();
  1260.                 }
  1262.             }
  1265.             $rows[] = [
  1266.                 '',
  1267.                 '',
  1268.                 '',
  1269.                 '',
  1270.                 'Export : '.$date,
  1271.                 $total,
  1272.                 $total_am,
  1273.                 $total_rs,
  1274.                 ''
  1275.             ];
  1278.             $html = '<table class="exporting"><tbody>';
  1279.             foreach ($rows as $key => $row) {
  1280.                 $html .= '<tr>';
  1281.                 foreach ($row as $key2 => $column) {
  1282.                     $html .= '<td>'.$column.'</td>';
  1283.                 }
  1284.                 $html .= '</tr>';
  1285.             }
  1286.             $html .= '</tbody></table>';
  1289.             $success = true;
  1291.         } else {
  1292.             $error = 'Aucun nouveau paiement à exporter';
  1293.         }
  1299.         $data = [
  1300.             'error' => $error,
  1301.             'success' => $success,
  1302.             'html' => $html
  1303.         ];
  1305.         $response = new Response(json_encode($data));
  1306.         $response->headers->set('Content-Type', 'application/json');
  1307.         return $response;
  1311.     }
  1352.     /**
  1353.      * @Route("/order-exports", name="palace_manager_order_exports", requirements={"id" = "([a-z\-0-9]+)"})
  1354.      */
  1356.     public function exportsOrderAction(Request $request, $id = NULL, MailerInterface $mailer)
  1357.     {
  1359.         $em = $this->getDoctrine()->getManager();
  1360.         $globals = $this->get("twig")->getGlobals();
  1362.         $exports = $em->getRepository('FrameworkAppBundle:Export')->findBy(['type' => 'order'], ['createdAt' => 'DESC']);
  1364.         return $this->render('AdminBundle/Order/exports.html.twig', [
  1365.             'exports' => $exports,
  1366.             'locale' => 'fr',
  1367.         ]);
  1368.     }
  1372.     /**
  1373.      * @Route("/order-exports-generate", name="palace_manager_order_exports_generate", requirements={"id" = "([a-z\-0-9]+)"})
  1374.      */
  1376.     public function exportOrderGenerateAction(Request $request, $id = NULL, MailerInterface $mailer)
  1377.     {
  1380.         $success = false;
  1381.         $error = $slug = '';
  1384.         $em = $this->getDoctrine()->getManager();
  1385.         $globals = $this->get("twig")->getGlobals();
  1387.         $total = $total_rs = $total_am = 0;
  1389.         $date = date('Y-m-d_H-i-s');
  1391.         $rows = [];
  1393.         $rows[] = [
  1394.             'ID',
  1395.             'Date de paiement',
  1396.             'Type',
  1397.             'Paiement',
  1398.             'Client',
  1399.             'Envoi',
  1400.             'Commande',
  1401.             'Total',
  1402.             'AM',
  1403.             'RS',
  1404.             'ID Stripe',
  1405.             'Manuel'
  1406.         ];
  1408.         $orders = $em->getRepository('FrameworkAppBundle:Order')->findBy(['exported' => NULL, 'status' => 'succeeded', 'paymentType' => ['card','klarna','paypal'] ], ['manual' => 'DESC', 'paymentType' => 'DESC', 'createdAt' => 'ASC']);
  1410.         if( sizeof($orders) > 0 ){
  1412.             foreach ($orders as $key => $order) {
  1414.                 $envoi = 'E-Billet';
  1415.                 foreach ($order->getCartArr2() as $item_key => $item) {
  1417.                     if( $item['gift'] == 'true' ){
  1418.                         $envoi = 'Courrier';
  1419.                     }
  1420.                 }
  1421.                 if($envoi == 'Courrier'){
  1422.                     $rows[] = [
  1423.                         $order->getBaseId(),
  1424.                         date('d/m/Y', $order->getResult()->created),
  1425.                         'BON C.',
  1426.                         $order->getPaymentType(),
  1427.                         ucwords(strtolower($order->getInfo('firstname'))).' '.strtoupper($order->getInfo('lastname')),
  1428.                         $envoi,
  1429.                         $order->getRecap(true),
  1430.                         ($order->getAmount() + $order->getAmountShow()),
  1431.                         $order->getAmount(),
  1432.                         $order->getAmountShow(),
  1433.                         $order->getResult()->id,
  1434.                         ($order->getManual()) ? 'M' : '',
  1435.                     ];
  1437.                     $total = $total + ($order->getAmount() + $order->getAmountShow());
  1438.                     $total_am = $total_am + $order->getAmount();
  1439.                     $total_rs = $total_rs + $order->getAmountShow();
  1441.                     $order->setState(6);
  1442.                     $order->setExported(1);
  1443.                     $em->persist($order);
  1444.                     $em->flush();
  1445.                 }
  1446.             }
  1448.             //2d ROUND
  1449.             foreach ($orders as $key => $order) {
  1451.                 $envoi = 'E-Billet';
  1452.                 foreach ($order->getCartArr2() as $item_key => $item) {
  1454.                     if( $item['gift'] == 'true' ){
  1455.                         $envoi = 'Courrier';
  1456.                     }
  1457.                 }
  1458.                 if($envoi == 'E-Billet'){
  1459.                     $rows[] = [
  1460.                         $order->getBaseId(),
  1461.                         date('d/m/Y', $order->getResult()->created),
  1462.                         'BON C.',
  1463.                         $order->getPaymentType(),
  1464.                         ucwords(strtolower($order->getInfo('firstname'))).' '.strtoupper($order->getInfo('lastname')),
  1465.                         $envoi,
  1466.                         $order->getRecap(true),
  1467.                         ($order->getAmount() + $order->getAmountShow()),
  1468.                         $order->getAmount(),
  1469.                         $order->getAmountShow(),
  1470.                         $order->getResult()->id,
  1471.                         ($order->getManual()) ? 'M' : '',
  1472.                     ];
  1474.                     $total = $total + ($order->getAmount() + $order->getAmountShow());
  1475.                     $total_am = $total_am + $order->getAmount();
  1476.                     $total_rs = $total_rs + $order->getAmountShow();
  1478.                     $order->setState(6);
  1479.                     $order->setExported(1);
  1480.                     $em->persist($order);
  1481.                     $em->flush();
  1482.                 }
  1483.             }
  1486.             $rows[] = [
  1487.                 '',
  1488.                 '',
  1489.                 '',
  1490.                 '',
  1491.                 '',
  1492.                 'Export : '.$date,
  1493.                 $total,
  1494.                 $total_am,
  1495.                 $total_rs,
  1496.                 '',
  1497.                 ''
  1498.             ];
  1501.             //ENREGISTREMENT DU CSV
  1502.             $path = $globals['export_folder'].'exports_order/B_'.$date.'.csv';
  1503.             $fp = fopen($path, 'w'); // open in write only mode (write at the start of the file)
  1504.             fprintf($fp, chr(0xEF).chr(0xBB).chr(0xBF));
  1506.             foreach ($rows as $row) {
  1507.                 fputcsv($fp, $row, ";");
  1508.             }
  1509.             fclose($fp);
  1512.             //ENREGISTREMENT BASE
  1513.             $export = new Export();
  1514.             $export->setType('order');
  1515.             $export->setFile($path);
  1516.             $export->setName('B_'.$date.'.csv');
  1517.             $em->persist($export);
  1518.             $em->flush();
  1521.             //ENVOI EMAIL COMPTA
  1522.             $from = $globals['app_email_noreply'];
  1523.             $to = $globals['app_email_compta'];
  1524.             $contact = $globals['app_email_contact'];
  1527.             $email = (new Email())
  1528.                 ->from($from)
  1529.                 ->to($to)
  1530.                 ->cc($globals['app_email_contact'])
  1531.                 //->bcc('bcc@example.com')
  1532.                 ->replyTo($contact)
  1533.                 //->priority(Email::PRIORITY_HIGH)
  1535.                 ->attachFromPath($path)
  1537.                 ->subject('Nouvel export BONS CADEAUX CB Stripe '.$date)
  1538.                 ->text(nl2br('Nouvel export BONS CADEAUX CB Stripe généré le '.$date));
  1542.             $mailer->send($email);
  1543.             //FIN ENVOI EMAIL COMPTA
  1544.             $success = true;
  1546.         } else {
  1547.             $error = 'Aucun nouveau paiement à exporter';
  1548.         }
  1554.         $data = [
  1555.             'error' => $error,
  1556.             'success' => $success
  1557.         ];
  1559.         $response = new Response(json_encode($data));
  1560.         $response->headers->set('Content-Type', 'application/json');
  1561.         return $response;
  1565.     }
  1594.     /**
  1595.      * @Route("/order-exports-generate-preview", name="palace_manager_order_exports_generate_preview", requirements={"id" = "([a-z\-0-9]+)"})
  1596.      */
  1598.     public function exportOrderGeneratePreviewAction(Request $request, $id = NULL, MailerInterface $mailer)
  1599.     {
  1602.         $success = false;
  1603.         $error = $slug = $html = '';
  1606.         $em = $this->getDoctrine()->getManager();
  1607.         $globals = $this->get("twig")->getGlobals();
  1609.         $total = $total_rs = $total_am = 0;
  1611.         $date = date('Y-m-d_H-i-s');
  1613.         $rows = [];
  1615.         $rows[] = [
  1616.             'ID',
  1617.             'Date de paiement',
  1618.             'Type',
  1619.             'Paiement',
  1620.             'Client',
  1621.             'Envoi',
  1622.             'Commande',
  1623.             'Total',
  1624.             'AM',
  1625.             'RS',
  1626.             'ID Stripe',
  1627.             'Manuel'
  1628.         ];
  1630.         $orders = $em->getRepository('FrameworkAppBundle:Order')->findBy(['exported' => NULL, 'status' => 'succeeded', 'paymentType' => ['card','klarna','paypal'] ], ['manual' => 'DESC', 'paymentType' => 'DESC', 'createdAt' => 'ASC']);
  1632.         if( sizeof($orders) > 0 ){
  1634.             foreach ($orders as $key => $order) {
  1636.                 $envoi = 'E-Billet';
  1637.                 foreach ($order->getCartArr2() as $item_key => $item) {
  1639.                     if( $item['gift'] == 'true' ){
  1640.                         $envoi = 'Courrier';
  1641.                     }
  1642.                 }
  1643.                 if($envoi == 'Courrier'){
  1644.                     $rows[] = [
  1645.                         $order->getBaseId(),
  1646.                         date('d/m/Y', $order->getResult()->created),
  1647.                         'BON C.',
  1648.                         $order->getPaymentType(),
  1649.                         ucwords(strtolower($order->getInfo('firstname'))).' '.strtoupper($order->getInfo('lastname')),
  1650.                         $envoi,
  1651.                         $order->getRecap(true),
  1652.                         ($order->getAmount() + $order->getAmountShow()),
  1653.                         $order->getAmount(),
  1654.                         $order->getAmountShow(),
  1655.                         $order->getResult()->id,
  1656.                         ($order->getManual()) ? 'M' : '',
  1657.                     ];
  1659.                     $total = $total + ($order->getAmount() + $order->getAmountShow());
  1660.                     $total_am = $total_am + $order->getAmount();
  1661.                     $total_rs = $total_rs + $order->getAmountShow();
  1663.                 }
  1664.             }
  1666.             //2d ROUND
  1667.             foreach ($orders as $key => $order) {
  1669.                 $envoi = 'E-Billet';
  1670.                 foreach ($order->getCartArr2() as $item_key => $item) {
  1672.                     if( $item['gift'] == 'true' ){
  1673.                         $envoi = 'Courrier';
  1674.                     }
  1675.                 }
  1676.                 if($envoi == 'E-Billet'){
  1677.                     $rows[] = [
  1678.                         $order->getBaseId(),
  1679.                         date('d/m/Y', $order->getResult()->created),
  1680.                         'BON C.',
  1681.                         $order->getPaymentType(),
  1682.                         ucwords(strtolower($order->getInfo('firstname'))).' '.strtoupper($order->getInfo('lastname')),
  1683.                         $envoi,
  1684.                         $order->getRecap(true),
  1685.                         ($order->getAmount() + $order->getAmountShow()),
  1686.                         $order->getAmount(),
  1687.                         $order->getAmountShow(),
  1688.                         $order->getResult()->id,
  1689.                         ($order->getManual()) ? 'M' : '',
  1690.                     ];
  1692.                     $total = $total + ($order->getAmount() + $order->getAmountShow());
  1693.                     $total_am = $total_am + $order->getAmount();
  1694.                     $total_rs = $total_rs + $order->getAmountShow();
  1697.                 }
  1698.             }
  1701.             $rows[] = [
  1702.                 '',
  1703.                 '',
  1704.                 '',
  1705.                 '',
  1706.                 '',
  1707.                 'Export : '.$date,
  1708.                 $total,
  1709.                 $total_am,
  1710.                 $total_rs,
  1711.                 '',
  1712.                 ''
  1713.             ];
  1717.             $html = '<table class="exporting"><tbody>';
  1718.             foreach ($rows as $key => $row) {
  1719.                 $html .= '<tr>';
  1720.                 foreach ($row as $key2 => $column) {
  1721.                     $html .= '<td>'.$column.'</td>';
  1722.                 }
  1723.                 $html .= '</tr>';
  1724.             }
  1725.             $html .= '</tbody></table>';
  1728.             $success = true;
  1730.         } else {
  1731.             $error = 'Aucun nouveau paiement à exporter';
  1732.         }
  1738.         $data = [
  1739.             'error' => $error,
  1740.             'success' => $success,
  1741.             'html' => $html
  1742.         ];
  1744.         $response = new Response(json_encode($data));
  1745.         $response->headers->set('Content-Type', 'application/json');
  1746.         return $response;
  1750.     }
  1772.     /**
  1773.      * @Route("/resa/sendPayment/{id}", name="palace_manager_resa_sendPayment", requirements={"id" = "([a-z\-0-9]+)"})
  1774.      */
  1776.     public function sendPaymentAction(Request $request, $id = NULL, MailerInterface $mailer)
  1777.     {
  1779.         $em = $this->getDoctrine()->getManager();
  1780.         $globals = $this->get("twig")->getGlobals();
  1782.         $success = true;
  1783.         $error = $slug = '';
  1785.         $booking = $em->getRepository('FrameworkAppBundle:Booking')->findOneById($id);
  1787.         $booking->setOptions($request->get('options'));
  1788.         $booking->setAmount(floatval(str_replace(',', '.', $request->get('amount'))));
  1789.         $booking->setAmountShow(floatval(str_replace(',', '.', $request->get('amountShow'))));
  1790.         $booking->setState(1);
  1791.         $booking->setVenueTitle($request->get('venueTitle'));
  1792.         $booking->setEmailContent($request->get('emailContent'));
  1793.         if($request->get('reminder') == 'reminder'){
  1794.             $booking->setMailedCount( $booking->getMailedCount() + 1 );
  1795.         }
  1796.         $em->persist($booking);
  1797.         $em->flush();
  1801.         $subject = 'Votre réservation Royal Palace : Instructions de règlement';
  1802.         $title = 'Votre réservation Royal Palace : Instructions de règlement';
  1803.         $content = str_replace("\n", '<br>', $booking->getEmailContent()).'</p><br><a href="'.$globals['app_email_domain'].'fr/mon-compte/paiement/'.$booking->getToken().'" style="text-align:center; width:100%; font-size: 18px; display:block;"><strong>Procéder au paiement</strong></a>';
  1805.         if($request->get('reminder') == 'reminder'){
  1806.             $subject = 'Relance commande #'.$booking->getBaseId().' | Votre réservation Royal Palace : Instructions de règlement';
  1807.             $title = 'Relance commande #'.$booking->getBaseId().' | Votre réservation Royal Palace : Instructions de règlement';
  1808.         }
  1811.         if($booking->getLang() == 'de'){
  1812.             $subject = 'Ihre Royal Palace Reservierung: Hinweise zur Zahlung';
  1813.             $title = 'Ihre Royal Palace Reservierung: Hinweise zur Zahlung';
  1814.             $content = str_replace("\n", '<br>', $booking->getEmailContent()).'</p><br><a href="'.$globals['app_email_domain'].'de/mon-compte/paiement/'.$booking->getToken().'" style="text-align:center; width:100%; font-size: 18px; display:block;"><strong>Mit der Zahlung fortfahren</strong></a>';
  1816.             if($request->get('reminder') == 'reminder'){
  1817.                 $subject = 'Zahlungserinnerung Bestellung #'.$booking->getBaseId().' | Ihre Royal Palace Reservierung: Hinweise zur Zahlung';
  1818.                 $title = 'Zahlungserinnerung Bestellung #'.$booking->getBaseId().' | Ihre Royal Palace Reservierung: Hinweise zur Zahlung';
  1819.             }
  1820.         }
  1822.         if($booking->getLang() == 'en'){
  1823.             $subject = 'Your Royal Palace reservation: Payment instructions';
  1824.             $title = 'Your Royal Palace reservation: Payment instructions';
  1825.             $content = str_replace("\n", '<br>', $booking->getEmailContent()).'</p><br><a href="'.$globals['app_email_domain'].'en/mon-compte/paiement/'.$booking->getToken().'" style="text-align:center; width:100%; font-size: 18px; display:block;"><strong>Proceed to payment</strong></a>';
  1827.             if($request->get('reminder') == 'reminder'){
  1828.                 $subject = 'Reminder order #'.$booking->getBaseId().' | Your Royal Palace reservation: Payment instructions';
  1829.                 $title = 'Reminder order #'.$booking->getBaseId().' | Your Royal Palace reservation: Payment instructions';
  1830.             }
  1831.         }
  1836.         //ENVOI EMAIL
  1837.         $from = $globals['app_email_noreply'];
  1838.         $to = $booking->getUser()->getEmail();
  1839.         $contact = $globals['app_email_contact'];
  1841.         $email = (new Email())
  1842.             ->from($from)
  1843.             ->to($to)
  1844.             //->cc('cc@example.com')
  1845.             //->bcc('bcc@example.com')
  1846.             ->replyTo($contact)
  1847.             //->priority(Email::PRIORITY_HIGH)
  1848.             ->subject($subject)
  1849.             ->text($booking->getEmailContent())
  1850.             ->html($this->renderView(
  1851.                 'FrontBundle/Emails/general.html.twig', array(
  1852.                     'title'   => $title,
  1853.                     'content' => $content,
  1854.                 )
  1855.             ));
  1857.         try{
  1858.             $mailer->send($email);
  1859.         }
  1860.         catch(\Exception $e){
  1862.             $data = [
  1863.                 'error' => 'Une erreur est survenue. Veuillez vérifier l\'adresse email. : '.$e->getMessage(),
  1864.                 'success' => false
  1865.             ];
  1867.             $response = new Response(json_encode($data));
  1868.             $response->headers->set('Content-Type', 'application/json');
  1869.             return $response;
  1871.         }
  1874.         //FIN ENVOI EMAIL
  1876.         $booking->setMailedPay(1);
  1877.         $em->persist($booking);
  1878.         $em->flush();
  1882.         // ENREGISTREMENT LOG MAIL
  1883.         $mail = New Mail();
  1884.         $mail->setBooking($booking);
  1885.         $mail->setEmailTitle($title);
  1886.         $mail->setEmailContent($content);
  1887.         $em->persist($mail);
  1888.         $em->flush();
  1889.         // FIN ENREGISTREMENT LOG MAIL
  1893.         $data = [
  1894.             'error' => $error,
  1895.             'success' => $success
  1896.         ];
  1898.         $response = new Response(json_encode($data));
  1899.         $response->headers->set('Content-Type', 'application/json');
  1900.         return $response;
  1901.     }
  1905.     /**
  1906.      * @Route("/order2", name="palace_manager_order2_index")
  1907.      */
  1909.     public function indexOrderAction(Request $request)
  1910.     {
  1912.         $em = $this->getDoctrine()->getManager();
  1914.         $orders = $em->getRepository('FrameworkAppBundle:Order')->findBy(['status' => ['manual', 'succeeded']], ['id' => 'DESC']);
  1915.         return $this->render('AdminBundle/Order/index.html.twig', [
  1916.             'orders' => $orders,
  1917.         ]);
  1918.     }
  1922.     /**
  1923.      * @Route("/order", name="palace_manager_order_index")
  1924.      */
  1926.     public function indexOrder2Action(Request $request)
  1927.     {
  1929.         $em = $this->getDoctrine()->getManager();
  1931.         // $orders = $em->getRepository('FrameworkAppBundle:Order')->findBy(['status' => ['manual', 'succeeded']], ['id' => 'DESC']);
  1932.         $orders = [];
  1933.         return $this->render('AdminBundle/Order/index2.html.twig', [
  1934.             'orders' => $orders,
  1935.         ]);
  1936.     }
  1940.     /**
  1941.      * @Route("/order/load", name="palace_manager_order_load")
  1942.      */
  1944.     public function orderLoadAction(Request $request, $id = null)
  1945.     {
  1947.         $em = $this->getDoctrine()->getManager();
  1948.         $success = true;
  1949.         $error = '';
  1951.         $isAjax = $request->isXMLHttpRequest();
  1952.         if (!$isAjax) {
  1953.             return $this->redirectToRoute('palace_manager_resa_index');
  1954.         }
  1957.         $currentPage = intval( $request->get('page') );
  1958.         if($currentPage == null){
  1959.             $currentPage = 1;
  1960.         }
  1962.         $limit = 50;
  1965.         if($request->get('search') == ''){
  1966.             if($request->get('filter') != 'all' && $request->get('filter') != NULL){
  1967.                 $orders = $em->getRepository('FrameworkAppBundle:Order')->findBy(['state' => $request->get('filter')], ['id' => 'DESC'], $limit, ($currentPage-1) * $limit);
  1968.                 $ordersNbr = $em->getRepository('FrameworkAppBundle:Order')->count(['state' => $request->get('filter')]);
  1969.             } else {
  1970.                 $orders = $em->getRepository('FrameworkAppBundle:Order')->findBy([], ['id' => 'DESC'], $limit, ($currentPage-1) * $limit);
  1971.                 $ordersNbr = $em->getRepository('FrameworkAppBundle:Order')->count([]);
  1972.             }
  1974.         } else {
  1975.             $orders = $em->getRepository('FrameworkAppBundle:Order')->search($request->get('search'));
  1976.             $ordersNbr = sizeof($orders);
  1977.         }
  1980.         $pagesNbr = ceil($ordersNbr / $limit);
  1981.         $start = ($currentPage-1) * $limit + 1;
  1982.         $end = ($currentPage) * $limit;
  1983.         if($end > $ordersNbr){
  1984.             $end = $ordersNbr;
  1985.         }
  1988.         $orderArr = [];
  1989.         foreach ($orders as $key => $order) {
  1991.             // $createdAt = new \DateTime(date('Y-m-d H:i:s', strtotime($order->getCreatedAt()->format('Y-m-d H:i:s'). ' +2 hours')));
  1992.             // $updatedAt = new \DateTime(date('Y-m-d H:i:s', strtotime($order->getUpdatedAt()->format('Y-m-d H:i:s'). ' +2 hours')));
  1994.             $createdAt = new \DateTime(date('Y-m-d H:i:s', strtotime($order->getCreatedAt()->format('Y-m-d H:i:s'))));
  1995.             $updatedAt = new \DateTime(date('Y-m-d H:i:s', strtotime($order->getUpdatedAt()->format('Y-m-d H:i:s'))));
  1997.             $sending = '<span class="badge badge-secondary">E-Billet</span>';
  1998.             if($order->getCart()){
  1999.                 foreach ($order->getCart() as $key => $item) {
  2000.                     if($item->gift == 'true'){
  2001.                         $sending = '<span class="badge badge-primary">Courrier</span>';
  2002.                     }
  2003.                 }
  2004.             }
  2006.             $orderArr[] = [
  2007.                 'id' =>  $order->getId(),
  2008.                 'email' =>  $order->getUser()->getEmail(),
  2009.                 'old_id' =>  $order->getOldId(),
  2010.                 'base_id' =>  $order->getBaseId(),
  2011.                 'infos' =>  $order->getInfos(),
  2012.                 'cart' =>  $order->getCart(),
  2013.                 'state' =>  $order->getState(),
  2014.                 'status' =>  $order->getStatus(),
  2015.                 'paymentType' =>  $order->getPaymentType(),
  2016.                 'amountTotal' =>  $order->getAmountTotal(),
  2017.                 'stateStrAdmin' =>  $order->getStateStrAdmin(),
  2018.                 'manual' =>  intval($order->getManual()),
  2019.                 'sending' =>  $sending,
  2020.                 'createdAt' =>  $createdAt,
  2021.                 'updatedAt' =>  $updatedAt,
  2022.             ];
  2023.         }
  2025.         $data = [
  2026.             'error'   => $error,
  2027.             'success' => $success,
  2028.             'currentPage' => $currentPage,
  2029.             'ordersNbr' => $ordersNbr,
  2030.             'pagesNbr' => $pagesNbr,
  2031.             'orders' => $orderArr,
  2032.             'start' => $start,
  2033.             'end' => $end,
  2034.         ];
  2036.         $response = new Response(json_encode($data));
  2037.         $response->headers->set('Content-Type', 'application/json');
  2038.         return $response;
  2040.     }
  2044.     /**
  2045.      * @Route("/order/{id}", name="palace_manager_order_edit", requirements={"id" = "([a-z\-0-9]+)"})
  2046.      */
  2048.     public function editOrderAction(Request $request, $id = NULL)
  2049.     {
  2051.         $em = $this->getDoctrine()->getManager();
  2053.         $order = $em->getRepository('FrameworkAppBundle:Order')->findOneById($id);
  2055.         $cartTest = json_decode('{"11_1685090430143":{"id":"11_1685090430143","image":"image_main.jpg","name":{"de":"Formule Étincelle","en":"Formule Étincelle","fr":"Formule Étincelle"},"slug":"bon-cadeau-4","price":100,"quantity":1,"gift":true,"for":"","attribute":null,"options":[{"id":7,"name":"Bon d’achat boutique 10€ ","qty":2,"sub_total":20},{"id":8,"name":"Bon d’achat boutique 20€ ","qty":1,"sub_total":20}]}}', true);
  2057.         return $this->render('AdminBundle/Order/edit.html.twig', [
  2058.             'cartTest' => $cartTest,
  2059.             'order' => $order,
  2060.         ]);
  2061.     }
  2066.     /**
  2067.      * @Route("/order/save/{id}", name="palace_manager_order_save", requirements={"id" = "([a-z\-0-9]+)"})
  2068.      */
  2070.     public function saveOrderAction(Request $request, $id = NULL)
  2071.     {
  2073.         $em = $this->getDoctrine()->getManager();
  2075.         $success = true;
  2076.         $error = $slug = '';
  2078.         $order = $em->getRepository('FrameworkAppBundle:Order')->findOneById($id);
  2081.         $order->setState(intval($request->get('state')));
  2083.         $em->persist($order);
  2084.         $em->flush();
  2087.         $data = [
  2088.             'error' => $error,
  2089.             'success' => $success
  2090.         ];
  2092.         $response = new Response(json_encode($data));
  2093.         $response->headers->set('Content-Type', 'application/json');
  2094.         return $response;
  2095.     }
  2101.     /**
  2102.      * @Route("/routine", name="palace_manager_routine_index")
  2103.      */
  2105.     public function routineAction(Request $request)
  2106.     {
  2108.         $em = $this->getDoctrine()->getManager();
  2110.         $bookings = $em->getRepository('FrameworkAppBundle:Booking')->findBy([], ['id' => 'ASC']);
  2112.         // foreach ($bookings as $key => $booking) {
  2113.         //     $booking->setOldId($booking->getBaseId());
  2114.         //     $em->persist($booking);
  2115.         //     $em->flush();
  2116.         // }
  2118.         // $id=0;
  2119.         // foreach ($bookings as $key => $booking) {
  2120.         //   $id++;
  2121.         //     $booking->setBaseId($id);
  2122.         //     $em->persist($booking);
  2123.         //     $em->flush();
  2124.         // }
  2126.         // dump($bookings);
  2127.         echo 'DONE';
  2128.         exit;
  2131.     }
  2148.     /**
  2149.      * @Route("/resa_load", name="framework_admin_resa_load")
  2150.      */
  2151.     public function loadAction(Request $request, $id = null)
  2152.     {
  2154.         $em = $this->getDoctrine()->getManager();
  2155.         $success = true;
  2156.         $error = '';
  2158.         $isAjax = $request->isXMLHttpRequest();
  2159.         if (!$isAjax) {
  2160.             return $this->redirectToRoute('palace_manager_resa_index');
  2161.         }
  2164.         $future = strtotime('+4 day');
  2169.         $currentPage = intval( $request->get('page') );
  2170.         if($currentPage == null){
  2171.             $currentPage = 1;
  2172.         }
  2174.         $limit = 50;
  2177.         if($request->get('search') == ''){
  2178.             if($request->get('filter') != 'all' && $request->get('filter') != NULL){
  2179.                 $bookings = $em->getRepository('FrameworkAppBundle:Booking')->findBy(['state' => $request->get('filter')], ['alerting' => 'DESC', 'id' => 'DESC'], $limit, ($currentPage-1) * $limit);
  2180.                 $bookingsNbr = $em->getRepository('FrameworkAppBundle:Booking')->count(['state' => $request->get('filter')]);
  2181.             } else {
  2182.                 $bookings = $em->getRepository('FrameworkAppBundle:Booking')->findBy([], ['alerting' => 'DESC', 'id' => 'DESC'], $limit, ($currentPage-1) * $limit);
  2183.                 $bookingsNbr = $em->getRepository('FrameworkAppBundle:Booking')->count([]);
  2184.             }
  2186.         } else {
  2187.             $bookings = $em->getRepository('FrameworkAppBundle:Booking')->search($request->get('search'));
  2188.             $bookingsNbr = sizeof($bookings);
  2189.         }
  2192.         $pagesNbr = ceil($bookingsNbr / $limit);
  2193.         $start = ($currentPage-1) * $limit + 1;
  2194.         $end = ($currentPage) * $limit;
  2195.         if($end > $bookingsNbr){
  2196.             $end = $bookingsNbr;
  2197.         }
  2200.         $bookingArr = [];
  2201.         foreach ($bookings as $key => $booking) {
  2203.             // $createdAt = new \DateTime(date('Y-m-d H:i:s', strtotime($booking->getCreatedAt()->format('Y-m-d H:i:s'). ' +2 hours')));
  2204.             // $updatedAt = new \DateTime(date('Y-m-d H:i:s', strtotime($booking->getUpdatedAt()->format('Y-m-d H:i:s'). ' +2 hours')));
  2206.             $createdAt = new \DateTime(date('Y-m-d H:i:s', strtotime($booking->getCreatedAt()->format('Y-m-d H:i:s'))));
  2207.             $updatedAt = new \DateTime(date('Y-m-d H:i:s', strtotime($booking->getUpdatedAt()->format('Y-m-d H:i:s'))));
  2209.             $bg = '';
  2210.             if($booking->getVenue()->getStart()->format('U') < $future){
  2211.                 if(in_array($booking->getState(), [0,1,5])){
  2212.                     $bg = 'bg-danger';
  2213.                 }
  2214.             }
  2216.             if($booking->getAlerting()){
  2217.                 $bg = 'bg-warning';
  2218.             }
  2220.             if($booking->getIsflash()){
  2221.                 $isflash = '<br> (Ticketing)';
  2222.             } else {
  2223.                 $isflash = '';
  2224.             }
  2226.             $exporting = '';
  2227.             if($booking->getExported() == NULL && $booking->getIsflash() == NULL && $booking->getStatus() == 'succeeded'){
  2228.                 if($booking->getPaymentType() == 'card' || $booking->getPaymentType() == 'klarna' || $booking->getPaymentType() == 'paypal'){
  2229.                     $exporting = 'yes';
  2230.                 }
  2231.             }
  2233.             $bookingArr[] = [
  2234.                 'id' =>  $booking->getId(),
  2235.                 'email' =>  $booking->getUser()->getEmail(),
  2236.                 'old_id' =>  $booking->getOldId(),
  2237.                 'base_id' =>  $booking->getBaseId(),
  2238.                 'infos' =>  $booking->getInfos(),
  2239.                 'cart' =>  $booking->getCart(),
  2240.                 'state' =>  $booking->getState(),
  2241.                 'action' =>  $booking->getAction(),
  2242.                 'venueTitle' =>  $booking->getVenuetitle(),
  2243.                 'paymentType' =>  $booking->getPaymentType(),
  2244.                 'amountTotal' =>  $booking->getAmountTotal(),
  2245.                 'stateStrAdmin' =>  $booking->getStateStrAdmin(),
  2246.                 'isflash' => $isflash,
  2247.                 'createdAt' =>  $createdAt,
  2248.                 'updatedAt' =>  $updatedAt,
  2249.                 'exporting' =>  $exporting,
  2250.                 'bg' =>  $bg
  2251.             ];
  2252.         }
  2254.         $data = [
  2255.             'error'   => $error,
  2256.             'success' => $success,
  2257.             'currentPage' => $currentPage,
  2258.             'bookingsNbr' => $bookingsNbr,
  2259.             'pagesNbr' => $pagesNbr,
  2260.             'bookings' => $bookingArr,
  2261.             'start' => $start,
  2262.             'end' => $end,
  2263.         ];
  2265.         $response = new Response(json_encode($data));
  2266.         $response->headers->set('Content-Type', 'application/json');
  2267.         return $response;
  2269.     }
  2273.     /**
  2274.      * @Route("/resa_refresh", name="framework_admin_resa_refresh")
  2275.      */
  2276.     public function refreshAction(Request $request, $id = null)
  2277.     {
  2279.         $em = $this->getDoctrine()->getManager();
  2280.         $success = true;
  2281.         $error = '';
  2283.         $isAjax = $request->isXMLHttpRequest();
  2284.         if (!$isAjax) {
  2285.             return $this->redirectToRoute('palace_manager_resa_index');
  2286.         }
  2288.         $bookings = $em->getRepository('FrameworkAppBundle:Booking')->findBy(['id' => $request->get('stateArr')]);
  2290.         $refreshArr = [];
  2292.         foreach ($bookings as $key => $booking) {
  2293.             $refreshArr[$booking->getId()]['state'] = $booking->getState();
  2294.             $refreshArr[$booking->getId()]['reminder'] = $booking->getMailedCount();
  2296.             $future = strtotime('+4 day');
  2297.             $bg = '';
  2298.             if($booking->getVenue()->getStart()->format('U') < $future){
  2299.                 if(in_array($booking->getState(), [0,1,5])){
  2300.                     $bg = 'bg-danger';
  2301.                 }
  2302.             }
  2304.             if($booking->getAlerting()){
  2305.                 $bg = 'bg-warning';
  2306.             }
  2309.             $refreshArr[$booking->getId()]['bg'] = $bg;
  2310.         }
  2312.         $data = [
  2313.             'refreshArr' => $refreshArr,
  2314.         ];
  2316.         $response = new Response(json_encode($data));
  2317.         $response->headers->set('Content-Type', 'application/json');
  2318.         return $response;
  2320.     }
  2328.     /**
  2329.      * @Route("/export-download-full-resa/{id}", name="palace_manager_export_download_full_resa", requirements={"id" = "([a-z\-0-9]+)"})
  2330.      */
  2332.     public function exportDownloadFullResaAction(Request $request, $id = NULL)
  2333.     {
  2335.         $em = $this->getDoctrine()->getManager();
  2336.         $globals = $this->get("twig")->getGlobals();
  2338.         $export = $em->getRepository('FrameworkAppBundle:Export')->findOneById($id);
  2340.         $csvFile = file($export->getFile());
  2341.         $data = $ids = [];
  2342.         foreach ($csvFile as $line) {
  2343.             $data[] = str_getcsv($line);
  2344.         }
  2345.         array_shift($data);
  2346.         array_pop($data);
  2349.         foreach ($data as $key => $value) {
  2350.             $tmp = explode(';', $value[0]);
  2351.             $ids[] = $tmp[0];
  2352.         }
  2355.         $total = $total_rs = $total_am = 0;
  2357.         $date = date('Y-m-d_H-i-s');
  2359.         $rows = [];
  2361.         $rows[] = [
  2362.             'ID',
  2363.             'Date de paiement',
  2364.             'KDO',
  2365.             'Type',
  2366.             'Client',
  2367.             'Date',
  2368.             'Total',
  2369.             'AM',
  2370.             'RS',
  2371.             // 'ID Stripe'
  2372.         ];
  2375.         foreach ($ids as $key => $id) {
  2376.             $booking = $em->getRepository('FrameworkAppBundle:Booking')->findOneBy(['genId' => $id]);
  2378.             $gift = '';
  2379.             if($booking->getInfo('gift') == 'true'){
  2380.                 $gift = 'KDO : '.$booking->getInfo('gift_user');
  2381.             }
  2383.             if($booking->getInfo('gift') == 'true'){
  2384.                 if( $booking->getResult() == null ){
  2385.                     $created = $booking->getCreatedAt()->format('d/m/Y');
  2386.                     $result_id = '';
  2387.                 } else {
  2388.                     $created = date('d/m/Y', $booking->getResult()->created);
  2389.                     $result_id = $booking->getResult()->id;
  2390.                 }
  2392.                 $rows[] = [
  2393.                     $booking->getBaseId(),
  2394.                     $created,
  2395.                     $gift,
  2396.                     'RESA',
  2397.                     ucwords(strtolower($booking->getInfo('firstname'))).' '.strtoupper($booking->getInfo('lastname')),
  2398.                     $booking->getVenueTitle(),
  2399.                     ($booking->getAmount() + $booking->getAmountShow()),
  2400.                     $booking->getAmount(),
  2401.                     $booking->getAmountShow(),
  2402.                     // $result_id
  2403.                 ];
  2405.                 $total = $total + ($booking->getAmount() + $booking->getAmountShow());
  2406.                 $total_am = $total_am + $booking->getAmount();
  2407.                 $total_rs = $total_rs + $booking->getAmountShow();
  2408.             }
  2410.         }
  2412.         //2D ROUND
  2413.         foreach ($ids as $key => $id) {
  2414.             $booking = $em->getRepository('FrameworkAppBundle:Booking')->findOneBy(['genId' => $id]);
  2416.             $gift = '';
  2417.             if($booking->getInfo('gift') == 'true'){
  2418.                 $gift = 'KDO : '.$booking->getInfo('gift_user');
  2419.             }
  2421.             if($booking->getInfo('gift') != 'true'){
  2422.                 if( $booking->getResult() == null ){
  2423.                     $created = $booking->getCreatedAt()->format('d/m/Y');
  2424.                     $result_id = '';
  2425.                 } else {
  2426.                     $created = date('d/m/Y', $booking->getResult()->created);
  2427.                     $result_id = $booking->getResult()->id;
  2428.                 }
  2430.                 $rows[] = [
  2431.                     $booking->getBaseId(),
  2432.                     $created,
  2433.                     $gift,
  2434.                     'RESA',
  2435.                     ucwords(strtolower($booking->getInfo('firstname'))).' '.strtoupper($booking->getInfo('lastname')),
  2436.                     $booking->getVenueTitle(),
  2437.                     ($booking->getAmount() + $booking->getAmountShow()),
  2438.                     $booking->getAmount(),
  2439.                     $booking->getAmountShow(),
  2440.                     // $result_id
  2441.                 ];
  2443.                 $total = $total + ($booking->getAmount() + $booking->getAmountShow());
  2444.                 $total_am = $total_am + $booking->getAmount();
  2445.                 $total_rs = $total_rs + $booking->getAmountShow();
  2446.             }
  2448.         }
  2451.         $rows[] = [
  2452.             '',
  2453.             '',
  2454.             '',
  2455.             '',
  2456.             'Export détaillé : '.$date,
  2457.             $total,
  2458.             $total_am,
  2459.             $total_rs,
  2460.             ''
  2461.         ];
  2463.         //ENREGISTREMENT DU CSV
  2464.         $path = str_replace('.csv', '_full.csv', $export->getFile());
  2465.         $name = str_replace('.csv', '_full.csv', $export->getName());
  2466.         $fp = fopen($path, 'w'); // open in write only mode (write at the start of the file)
  2467.         fprintf($fp, chr(0xEF).chr(0xBB).chr(0xBF));
  2469.         foreach ($rows as $row) {
  2470.             fputcsv($fp, $row, ";");
  2471.         }
  2472.         fclose($fp);
  2477.         header('Content-Description: File Transfer');
  2478.         header('Content-Type: application/octet-stream');
  2479.         header('Content-Disposition: attachment; filename="'.$name.'"');
  2480.         header('Content-Transfer-Encoding: binary');
  2481.         header('Expires: 0');
  2482.         header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
  2483.         header('Pragma: public');
  2484.         header('Content-Length: ' . filesize($path)); //Absolute URL
  2485.         ob_clean();
  2486.         flush();
  2487.         readfile($path); //Absolute URL
  2488.         exit();
  2490.     }
  2538.     /**
  2539.      * @Route("/resa-exports-generate-manual", name="palace_manager_resa_exports_generate_manual", requirements={"id" = "([a-z\-0-9]+)"})
  2540.      */
  2542.     public function exportResaGenerateManualAction(Request $request, $id = NULL, MailerInterface $mailer)
  2543.     {
  2546.         $success = false;
  2547.         $error = $slug = '';
  2549.         $ids = $request->get('manualExport');
  2551.         $em = $this->getDoctrine()->getManager();
  2552.         $globals = $this->get("twig")->getGlobals();
  2554.         $total = $total_rs = $total_am = 0;
  2556.         $date = date('Y-m-d_H-i-s');
  2558.         $rows = [];
  2560.         $rows[] = [
  2561.             'ID',
  2562.             'Date de paiement',
  2563.             'Type',
  2564.             'Paiement',
  2565.             'Client',
  2566.             'Date',
  2567.             'Total',
  2568.             'AM',
  2569.             'RS',
  2570.             'ID Stripe'
  2571.         ];
  2573.         // $bookings = $em->getRepository('FrameworkAppBundle:Booking')->findBy(['exported' => NULL, 'isflash' => 1, 'status' => 'succeeded', 'paymentType' => ['card','klarna'] ], ['paymentType' => 'DESC', 'createdAt' => 'ASC']);
  2574.         $bookings = $em->getRepository('FrameworkAppBundle:Booking')->findBy(['id' => $ids], ['paymentType' => 'DESC', 'createdAt' => 'ASC']);
  2576.         if( sizeof($bookings) > 0 ){
  2579.             foreach ($bookings as $key => $booking) {
  2581.                 if($booking->getInfo('gift') == 'true'){
  2582.                     if( $booking->getResult() == null ){
  2583.                         $created = $booking->getCreatedAt()->format('d/m/Y');
  2584.                         $result_id = '';
  2585.                     } else {
  2586.                         $created = date('d/m/Y', $booking->getResult()->created);
  2587.                         $result_id = $booking->getResult()->id;
  2588.                     }
  2590.                     $rows[] = [
  2591.                         $booking->getBaseId(),
  2592.                         $created,
  2593.                         'RESA (T)',
  2594.                         $booking->getPaymentType(),
  2595.                         ucwords(strtolower($booking->getInfo('firstname'))).' '.strtoupper($booking->getInfo('lastname')),
  2596.                         $booking->getVenueTitle(),
  2597.                         ($booking->getAmount() + $booking->getAmountShow()),
  2598.                         $booking->getAmount(),
  2599.                         $booking->getAmountShow(),
  2600.                         $result_id
  2601.                     ];
  2603.                     $total = $total + ($booking->getAmount() + $booking->getAmountShow());
  2604.                     $total_am = $total_am + $booking->getAmount();
  2605.                     $total_rs = $total_rs + $booking->getAmountShow();
  2607.                     $booking->setState(6);
  2608.                     $booking->setExported(1);
  2609.                     $em->persist($booking);
  2610.                     $em->flush();
  2612.                 }
  2614.             }
  2617.             //2D ROUND
  2619.             foreach ($bookings as $key => $booking) {
  2621.                 if($booking->getInfo('gift') != 'true'){
  2622.                     if( $booking->getResult() == null ){
  2623.                         $created = $booking->getCreatedAt()->format('d/m/Y');
  2624.                         $result_id = '';
  2625.                     } else {
  2626.                         $created = date('d/m/Y', $booking->getResult()->created);
  2627.                         $result_id = $booking->getResult()->id;
  2628.                     }
  2630.                     $rows[] = [
  2631.                         $booking->getBaseId(),
  2632.                         $created,
  2633.                         'RESA (T)',
  2634.                         $booking->getPaymentType(),
  2635.                         ucwords(strtolower($booking->getInfo('firstname'))).' '.strtoupper($booking->getInfo('lastname')),
  2636.                         $booking->getVenueTitle(),
  2637.                         ($booking->getAmount() + $booking->getAmountShow()),
  2638.                         $booking->getAmount(),
  2639.                         $booking->getAmountShow(),
  2640.                         $result_id
  2641.                     ];
  2643.                     $total = $total + ($booking->getAmount() + $booking->getAmountShow());
  2644.                     $total_am = $total_am + $booking->getAmount();
  2645.                     $total_rs = $total_rs + $booking->getAmountShow();
  2647.                     $booking->setState(6);
  2648.                     $booking->setExported(1);
  2649.                     $em->persist($booking);
  2650.                     $em->flush();
  2652.                 }
  2654.             }
  2657.             $rows[] = [
  2658.                 '',
  2659.                 '',
  2660.                 '',
  2661.                 '',
  2662.                 'Export : '.$date,
  2663.                 $total,
  2664.                 $total_am,
  2665.                 $total_rs,
  2666.                 ''
  2667.             ];
  2670.             //ENREGISTREMENT DU CSV
  2671.             $path = $globals['export_folder'].'exports_booking/R_'.$date.'.csv';
  2672.             $fp = fopen($path, 'w'); // open in write only mode (write at the start of the file)
  2673.             fprintf($fp, chr(0xEF).chr(0xBB).chr(0xBF));
  2675.             foreach ($rows as $row) {
  2676.                 fputcsv($fp, $row, ";");
  2677.             }
  2678.             fclose($fp);
  2681.             //ENREGISTREMENT BASE
  2682.             $export = new Export();
  2683.             $export->setType('resa');
  2684.             $export->setFile($path);
  2685.             $export->setName('R_'.$date.'.csv');
  2686.             $em->persist($export);
  2687.             $em->flush();
  2689.             //ENVOI EMAIL COMPTA
  2690.             $from = $globals['app_email_noreply'];
  2691.             $to = $globals['app_email_compta'];
  2692.             $contact = $globals['app_email_contact'];
  2695.             $email = (new Email())
  2696.                 ->from($from)
  2697.                 ->to($to)
  2698.                 ->cc($globals['app_email_contact'])
  2699.                 //->bcc('bcc@example.com')
  2700.                 ->replyTo($contact)
  2701.                 //->priority(Email::PRIORITY_HIGH)
  2703.                 ->attachFromPath($path)
  2705.                 ->subject('Nouvel export RESERVATIONS CB Stripe '.$date)
  2706.                 ->text(nl2br('Nouvel export RESERVATIONS CB Stripe généré le '.$date));
  2710.             $mailer->send($email);
  2711.             //FIN ENVOI EMAIL COMPTA
  2712.             $success = true;
  2714.         } else {
  2715.             $error = 'Aucun nouveau paiement à exporter';
  2716.         }
  2722.         $data = [
  2723.             'error' => $error,
  2724.             'success' => $success
  2725.         ];
  2727.         $response = new Response(json_encode($data));
  2728.         $response->headers->set('Content-Type', 'application/json');
  2729.         return $response;
  2733.     }
  2738.     /**
  2739.      * @Route("/resa-exports-generate-manual-preview", name="palace_manager_resa_exports_generate_manual_preview", requirements={"id" = "([a-z\-0-9]+)"})
  2740.      */
  2742.     public function exportResaGenerateManualPreviewAction(Request $request, $id = NULL, MailerInterface $mailer)
  2743.     {
  2746.         $success = false;
  2747.         $error = $slug = $html = '';
  2750.         $ids = $request->get('manualExport');
  2752.         $em = $this->getDoctrine()->getManager();
  2753.         $globals = $this->get("twig")->getGlobals();
  2755.         $total = $total_rs = $total_am = 0;
  2757.         $date = date('Y-m-d_H-i-s');
  2759.         $rows = [];
  2761.         $rows[] = [
  2762.             'ID',
  2763.             'Date de paiement',
  2764.             'Type',
  2765.             'Paiement',
  2766.             'Client',
  2767.             'Date',
  2768.             'Total',
  2769.             'AM',
  2770.             'RS',
  2771.             'ID Stripe'
  2772.         ];
  2774.         // $bookings = $em->getRepository('FrameworkAppBundle:Booking')->findBy(['exported' => NULL, 'isflash' => 1, 'status' => 'succeeded', 'paymentType' => ['card','klarna'] ], ['paymentType' => 'DESC', 'createdAt' => 'ASC']);
  2775.         $bookings = $em->getRepository('FrameworkAppBundle:Booking')->findBy(['id' => $ids], ['paymentType' => 'DESC', 'createdAt' => 'ASC']);
  2777.         if( sizeof($bookings) > 0 ){
  2780.             foreach ($bookings as $key => $booking) {
  2782.                 if($booking->getInfo('gift') == 'true'){
  2783.                     if( $booking->getResult() == null ){
  2784.                         $created = $booking->getCreatedAt()->format('d/m/Y');
  2785.                         $result_id = '';
  2786.                     } else {
  2787.                         $created = date('d/m/Y', $booking->getResult()->created);
  2788.                         $result_id = $booking->getResult()->id;
  2789.                     }
  2791.                     $rows[] = [
  2792.                         $booking->getBaseId(),
  2793.                         $created,
  2794.                         'RESA (T)',
  2795.                         $booking->getPaymentType(),
  2796.                         ucwords(strtolower($booking->getInfo('firstname'))).' '.strtoupper($booking->getInfo('lastname')),
  2797.                         $booking->getVenueTitle(),
  2798.                         ($booking->getAmount() + $booking->getAmountShow()),
  2799.                         $booking->getAmount(),
  2800.                         $booking->getAmountShow(),
  2801.                         $result_id
  2802.                     ];
  2804.                     $total = $total + ($booking->getAmount() + $booking->getAmountShow());
  2805.                     $total_am = $total_am + $booking->getAmount();
  2806.                     $total_rs = $total_rs + $booking->getAmountShow();
  2809.                 }
  2811.             }
  2814.             //2D ROUND
  2816.             foreach ($bookings as $key => $booking) {
  2818.                 if($booking->getInfo('gift') != 'true'){
  2819.                     if( $booking->getResult() == null ){
  2820.                         $created = $booking->getCreatedAt()->format('d/m/Y');
  2821.                         $result_id = '';
  2822.                     } else {
  2823.                         $created = date('d/m/Y', $booking->getResult()->created);
  2824.                         $result_id = $booking->getResult()->id;
  2825.                     }
  2827.                     $rows[] = [
  2828.                         $booking->getBaseId(),
  2829.                         $created,
  2830.                         'RESA (T)',
  2831.                         $booking->getPaymentType(),
  2832.                         ucwords(strtolower($booking->getInfo('firstname'))).' '.strtoupper($booking->getInfo('lastname')),
  2833.                         $booking->getVenueTitle(),
  2834.                         ($booking->getAmount() + $booking->getAmountShow()),
  2835.                         $booking->getAmount(),
  2836.                         $booking->getAmountShow(),
  2837.                         $result_id
  2838.                     ];
  2840.                     $total = $total + ($booking->getAmount() + $booking->getAmountShow());
  2841.                     $total_am = $total_am + $booking->getAmount();
  2842.                     $total_rs = $total_rs + $booking->getAmountShow();
  2845.                 }
  2847.             }
  2850.             $rows[] = [
  2851.                 '',
  2852.                 '',
  2853.                 '',
  2854.                 '',
  2855.                 'Export : '.$date,
  2856.                 $total,
  2857.                 $total_am,
  2858.                 $total_rs,
  2859.                 ''
  2860.             ];
  2863.             $html = '<table class="exporting"><tbody>';
  2864.             foreach ($rows as $key => $row) {
  2865.                 $html .= '<tr>';
  2866.                 foreach ($row as $key2 => $column) {
  2867.                     $html .= '<td>'.$column.'</td>';
  2868.                 }
  2869.                 $html .= '</tr>';
  2870.             }
  2871.             $html .= '</tbody></table>';
  2874.             $success = true;
  2876.         } else {
  2877.             $error = 'Aucun nouveau paiement à exporter';
  2878.         }
  2884.         $data = [
  2885.             'error' => $error,
  2886.             'success' => $success,
  2887.             'html' => $html
  2888.         ];
  2890.         $response = new Response(json_encode($data));
  2891.         $response->headers->set('Content-Type', 'application/json');
  2892.         return $response;
  2896.     }
  2907. }