src/Controller/PaiementController.php line 913

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Service\SessionService;
  6. use App\Service\CartService;
  7. use App\Service\VoucherService;
  9. use App\Entity\Main\CartSession;
  10. use App\Entity\Main\History;
  11. use App\Entity\Main\Reservation;
  12. use App\Entity\Main\ReservationDetails;
  13. use App\Entity\Main\Activity;
  14. use App\Entity\Main\BookedActivity;
  15. use App\Entity\Main\BookedActivityOptions;
  16. use App\Entity\Customer\Customer;
  18. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  19. use Symfony\Component\HttpFoundation\RedirectResponse;
  20. use Symfony\Component\HttpFoundation\Request;
  21. use Symfony\Component\HttpFoundation\Response;
  22. use Symfony\Component\Routing\Annotation\Route;
  23. use Symfony\Component\Routing\Generator\UrlGeneratorInterface;
  24. use Symfony\Component\HttpFoundation\JsonResponse;
  25. use Symfony\Component\Mailer\MailerInterface;
  26. use Symfony\Component\Mime\Email;
  29. class PaiementController extends AbstractController
  30. {
  31.     private $ss;
  32.     private $cart_service;
  33.     private $vs;
  34.     private $user_id_boutique;
  36.     private $paiement_mode = 'prod';
  37.     private $secretkey = array(
  38.         'prod' => 'sk_live_BWyADRY2i1WkCeCFSdTPB',
  39.         'test' => 'sk_test_3WPuDRaCf7EkPpwK5kLvFq',
  40.     ); 
  42.     public function __construct(SessionService $ss, CartService $cart_service, VoucherService $vs)
  43.     {
  44.         $this->ss = $ss;
  45.         $this->cart_service = $cart_service;
  46.         $this->vs = $vs;
  47.         $this->user_id_boutique = '1367';
  48.     }
  50.     /**
  51.      * @Route("/paiement", name="payment")
  52.      */
  53.     public function showRecap(Request $request): Response
  54.     {
  55.         $em = $this->getDoctrine()->getManager();
  56.         $cart = $this->ss->get();
  57.         $cart_details = $this->cart_service->getCartDetails($cart);
  58.         
  59.         // TO-DO faire un service pour savoir le l'environement [dev OU prod]
  60.         // $this->paiement_mode = ($this->getParameter('kernel.environment') == "dev") ? 'test' : 'prod';
  62.         if(empty($cart_details)) {
  63.             return $this->redirectToRoute('home');
  64.         } elseif($this->container->get('security.token_storage')->getToken() != null) {
  65.             $user = $this->container->get('security.token_storage')->getToken()->getUser();
  66.         } else {
  67.             return $this->redirectToRoute('customer_login',array('back' => '/paiement'));
  68.         }
  70.         // dd($this->sanitize_cart_details($cart_details));
  72.         $now = new \DateTime('now');
  73.         $cartSession = $em->getRepository(CartSession::class)->findOneBy(['id_cart_session' => $user->getId().'_'.$now->format('Ymd')]);
  74.         if(!$cartSession) {
  75.             $cartSession = new CartSession();
  76.         }
  77.         $cartSession->setIdCartSession($user->getId().'_'.$now->format('Ymd'));
  78.         $cartSession->setIdCustomer($user->getId());
  79.         $cartSession->setCartRaw(serialize(array(
  80.             'cart' => $cart,
  81.             'cart_details' => $this->sanitize_cart_details($cart_details) 
  82.         )));
  83.         $cartSession->setUserAgent($_SERVER['HTTP_USER_AGENT']);
  84.         $cartSession->setDateAdd($now);
  85.         $em->persist($cartSession);
  86.         $em->flush();
  88.         return $this->render('etapes/paiement.html.twig', [
  89.             'temp' => $this->secretkey[$this->paiement_mode],
  90.             'cart' => $cart,
  91.             'cart_details' => $cart_details,
  92.             'controller_name' => 'PaiementController',
  93.             'page_name' => 'page_paiement',
  94.         ]);
  95.     }
  96.     
  98.     private function createReservation($action_paiement, $infos, $json_total_a_payer, $json_total_panier)
  99.     {
  100.         /* POST Method */
  101.         // $data = json_decode($request->request->get('data'));
  102.         $data = "";
  103.         $error = false;
  105.         // if(md5($this->pk) != $request->request->get('key')) exit();
  106.         
  107.         $customer = $this->container->get('security.token_storage')->getToken()->getUser();
  108.         $cart = $this->ss->get();
  109.         $cart_details = $this->cart_service->getCartDetails($cart);
  110.         $date_arrive = new \DateTime($this->cart_service->getDateArrive($cart));
  111.         $cm = $this->getDoctrine()->getManager('customer');
  112.         $em = $this->getDoctrine()->getManager();
  113.         $reservation = new Reservation();
  115.         // dd($cart_details);
  117.         // On récupère les infos du client
  118.         // $customer = $em->getRepository(Customer::Class)->findOneBy(['customerNumber' => $customer->getCustomerNumber()]);
  120.         if($customer instanceof Customer)
  121.         {
  122.             $reservation->setCustomerId($customer->getId());
  123.             $reservation->setCustomerNumber($customer->getCustomerNumber());
  124.             $reservation->setFirstname($customer->getFirstname());
  125.             $reservation->setLastname($customer->getLastname());
  126.             $reservation->setCompany($customer->getCompany());
  127.             $reservation->setEmail($customer->getEmail());
  128.             $reservation->setPhone($customer->getPhone());
  129.             $reservation->setPhoneMobile($customer->getPhoneMobile());
  130.             
  131.             $billingAddress = "";
  132.             if ($customer->getAddress1() != "" && $customer->getAddress1() != null) $billingAddress .= $customer->getAddress1() . "\n";
  133.             if ($customer->getAddress2() != "" && $customer->getAddress2() != null) $billingAddress .= $customer->getAddress2() . "\n";
  134.             if ($customer->getPostcode() != "" && $customer->getPostcode() != null) $billingAddress .= $customer->getPostcode() . " ";
  135.             if ($customer->getCity() != "" && $customer->getCity() != null) $billingAddress .= $customer->getCity();            
  136.             $reservation->setBillingAddress($billingAddress);
  137.         }
  139.         /************************************************/  
  140.         // Extraction des données du panier
  141.         /************************************************/  
  142.         $formulesArray = array();
  143.         $formulesString = '';
  144.         $forfaits = array();
  145.         // $forfaitsIdArray = array();
  146.         $tarifs = array();
  147.         $montant_total_ttc = 0;
  148.         $montant_total_tva = 0;
  149.         $temp_tva_ttcArray = array(); 
  150.         foreach ($cart_details as $key_a => $formule) {
  151.             if($formulesString != "") $formulesString .= ', ';
  152.             $formulesArray[] = $formule['obj_formule']->getCode();
  153.             $formulesString .= $formule['obj_formule']->getCode();
  155.             foreach ($formule['forfaits'] as $key_b => $forfait) {
  156.                 $montant_forfait_ttc = 0;
  157.                 $montant_forfait_tva = 0;
  158.                 $forfait_tva_ttcArray = array();
  159.                 $forfaits[] = $forfait['obj_forfait'];
  160.                 // $forfaitsIdArray[] = $forfait['obj_forfait']->getId();
  162.                 foreach ($forfait['tarifs'] as $key => $tarif) {
  163.                     $montant_total_ttc += $tarif['obj_tarif']->getPriceTtc() * (int) $tarif['qty'];
  164.                     if(!isset($temp_tva_ttcArray[(string) $tarif['obj_tarif']->getTauxTva()])) {
  165.                         $temp_tva_ttcArray[(string) $tarif['obj_tarif']->getTauxTva()] = 0;
  166.                     }
  167.                     $temp_tva_ttcArray[(string) $tarif['obj_tarif']->getTauxTva()] += $tarif['obj_tarif']->getPriceTtc() * (int) $tarif['qty'];
  169.                     $montant_forfait_ttc += $tarif['obj_tarif']->getPriceTtc() * (int) $tarif['qty'];
  170.                     if(!isset($forfait_tva_ttcArray[(string) $tarif['obj_tarif']->getTauxTva()])) {
  171.                         $forfait_tva_ttcArray[(string) $tarif['obj_tarif']->getTauxTva()] = 0;
  172.                     }
  173.                     $forfait_tva_ttcArray[(string) $tarif['obj_tarif']->getTauxTva()] += $tarif['obj_tarif']->getPriceTtc() * (int) $tarif['qty'];
  174.                 }
  176.                 foreach ($forfait['options'] as $key => $option) {
  177.                     $montant_total_ttc += $option['obj_option']->getPriceTtc() * (int) $option['qty'];
  178.                     if(!isset($temp_tva_ttcArray[(string) $option['obj_option']->getTauxTva()])) {
  179.                         $temp_tva_ttcArray[(string) $option['obj_option']->getTauxTva()] = 0;
  180.                     }
  181.                     $temp_tva_ttcArray[(string) $option['obj_option']->getTauxTva()] += $option['obj_option']->getPriceTtc() * (int) $option['qty'];
  182.                     
  183.                     $montant_forfait_ttc += $option['obj_option']->getPriceTtc() * (int) $option['qty'];
  184.                     if(!isset($forfait_tva_ttcArray[(string) $option['obj_option']->getTauxTva()])) {
  185.                         $forfait_tva_ttcArray[(string) $option['obj_option']->getTauxTva()] = 0;
  186.                     }
  187.                     $forfait_tva_ttcArray[(string) $option['obj_option']->getTauxTva()] += $option['obj_option']->getPriceTtc() * (int) $option['qty'];
  188.                 }
  190.                 foreach ($forfait_tva_ttcArray as $tva => $montant_ttc) {
  191.                     $taux = 1 + (float) $tva;
  192.                     $montant_forfait_tva += $montant_ttc - $montant_ttc/$taux;
  193.                 }
  195.                 $cart_details[$key_a]['forfaits'][$key_b]['total_ttc'] = $montant_forfait_ttc;
  196.                 $cart_details[$key_a]['forfaits'][$key_b]['total_tva'] = $montant_forfait_tva;
  197.             }
  198.         }
  200.         foreach ($temp_tva_ttcArray as $tva => $montant_ttc) {
  201.             $taux = 1 + (float) $tva;
  202.             $temp_montant_tva = $montant_ttc - $montant_ttc/$taux;
  203.             if(isset($cart['code_promo'])) {
  204.                 $temp_montant_tva = $temp_montant_tva - ($temp_montant_tva * $cart['code_promo']->getPercent());
  205.             }
  206.             $montant_total_tva += $temp_montant_tva;
  207.         }
  208.         // $cart['code_promo']->getPercent()
  209.         
  210.         if(isset($cart['bon_numerique'])) {
  211.             foreach ($cart['bon_numerique'] as $key => $bon) {
  212.                 // $bonDetails = new ReservationDetails();
  213.                 // $bonDetails->setDesignation('Bon numérique : '.$bon['bon'].' ('.$bon['total'].')');
  214.                 // $bonDetails->setDate($date_arrive);
  215.                 // $bonDetails->setReservation($reservation);
  216.                 // $bonDetails->setTotalTTC(round(0 - $bon['total']),2);
  217.                 // $em->persist($bonDetails);
  218.                 // $em->flush();
  219.                 $montant_total_ttc = $montant_total_ttc - $bon['total'];
  220.                 $montant_total_tva = $montant_total_ttc - ($montant_total_ttc / 1.2 );
  221.             }
  222.         }
  224.         if(isset($cart['code_promo'])) {
  225.             if($cart['code_promo']->getTypeReduction() == 'percentage') {
  226.                 // $montant_total_tva = $montant_total_tva - ($montant_total_tva * $cart['code_promo']->getPercent() );
  227.                 $montant_total_ttc = $montant_total_ttc - ($montant_total_ttc * $cart['code_promo']->getPercent() );
  229.             } elseif($cart['code_promo']->getTypeReduction() == 'montant') {
  230.                 
  231.                 $montant_total_ttc = $montant_total_ttc - $cart['code_promo']->getReduction();
  232.                 $montant_total_tva = $montant_total_ttc - ($montant_total_ttc / 1.2 );
  233.                 // $montantPromoPanier = $cart['code_promo']->getReduction();
  235.             }
  236.         }
  238.         if(in_array('anniversaire',$formulesArray)) {
  239.             $creneau_anniv = $cart_details['anniversaire']['forfaits'][0]['infos_anniv']['creneau_anniv'];
  240.             $creneauAnniversaire = $date_arrive;
  241.             $creneauAnniversaire->add(new \DateInterval('PT'.strtoupper($creneau_anniv).'M')); 
  242.             $reservation->setDateResa($creneauAnniversaire);
  244.             if(isset($cart['birthday_customer_comment']) && $cart['birthday_customer_comment']) {
  245.                 $reservation->setBirthdayCustomerComment($cart['birthday_customer_comment']);
  246.             }
  247.         } else {
  248.             $reservation->setDateResa($date_arrive);
  249.         }
  251.         /************************************************/  
  252.         /************************************************/  
  253.         
  254.         $reservation->setFormule($formulesString);
  255.         $request = Request::createFromGlobals();
  256.         $reservation->setIp($request->getClientIp());
  258.         $reservation->setSstotalHT(round($montant_total_ttc - $montant_total_tva, 2));
  259.         $reservation->setTVA(round($montant_total_tva, 2));
  260.         $reservation->setTotalTTC(round($montant_total_ttc, 2));
  262.         $reservation->setActive(0);
  263.         if($action_paiement == "carte_1055")  {
  264.             $reservation->setStatut('Paiement carte 1055');
  265.             $reservation->setActive(1);
  266.             $comment = "<b>Titulaire carte 1055</b> : ";
  267.             if(isset($infos['titulaire_carte_1055']) && !empty($infos['titulaire_carte_1055'])) $comment .= $infos['titulaire_carte_1055'];
  268.             if(isset($infos['numero_carte_1055']) && !empty($infos['numero_carte_1055'])) $comment .= " (Mail: ".$infos['numero_carte_1055'].")";
  269.             $reservation->setComment($comment);
  270.         } elseif($action_paiement == "panier_precommande" && round($montant_total_ttc,0) == 0)  {
  271.             $reservation->setStatut('Payé');
  272.             $reservation->setActive(1);
  273.         } else {
  274.             $reservation->setStatut('Attente de paiement');
  275.         }
  276.         $reservation->setDeleted(0);
  278.         if(in_array('anniversaire',$formulesArray)) {
  279.             $comment = "";
  280.             if($reservation->getComment()) {
  281.                 $comment .= $reservation->getComment();
  282.                 $comment .= "\n============================\n";
  283.             }
  284.             $comment .= $cart_details['anniversaire']['forfaits'][0]['infos_anniv']['commentaire'];
  285.             // TO-DO calculer l'acompte ===================
  286.             if ($json_total_a_payer != "" && $json_total_a_payer != null && $json_total_a_payer != $json_total_panier) 
  287.                 $comment .= "\nAcompte : " . ($json_total_a_payer / 100) . " € ";
  289.             $reservation->setComment($comment);
  291.             if($cart_details['anniversaire']['forfaits'][0]['infos_anniv']['anniversaire_obj']) {
  292.                 $reservation->setChildName($cart_details['anniversaire']['forfaits'][0]['infos_anniv']['anniversaire_obj']['name_child']);
  293.                 $reservation->setChildBirthday($cart_details['anniversaire']['forfaits'][0]['infos_anniv']['anniversaire_obj']['birthday_child']);
  294.                 $reservation->setChildAge($cart_details['anniversaire']['forfaits'][0]['infos_anniv']['anniversaire_obj']['age_child']);
  295.             }
  296.         }
  298.         $em->persist($reservation);
  299.         $em->flush();
  300.         
  301.         $reservation_id =  (int)$reservation->getId();
  302.         $reservation_number = $reservation->getNumeroResa();
  303.             
  304.         foreach($cart_details as $key => $formule) {
  306.             foreach($formule['forfaits'] as $forfaitArray) {
  307.             
  308.                 $forfait = $forfaitArray['obj_forfait'];
  310.                 $resaDetailsArgs = array(
  311.                     'Reservation' => $reservation,
  312.                     'Designation' => 'Forfait : ' . $forfait->getDesignation(),
  313.                     'CodeActivity' => null,
  314.                     'Date' => $date_arrive,
  315.                     'Creneau' => null,
  316.                     'Quantity' => null,
  317.                     'PuTTC' => null,
  318.                     'TauxTVA' => null,
  319.                     'TotalHt' => $forfaitArray['total_ttc'] - $forfaitArray['total_tva'],
  320.                     'MontantTva' => $forfaitArray['total_tva'],
  321.                     'TotalTTC' => $forfaitArray['total_ttc'],
  322.                     'Parent' => null,
  323.                 );
  324.                 $resaDetails = $this->addReservationDetail($resaDetailsArgs);
  325.                 
  326.                 foreach($forfaitArray['tarifs'] as $tarifArray) {
  328.                     $tarif = $tarifArray['obj_tarif'];
  330.                     if($tarif) {
  331.                         $tarifDetailsArgs = array(
  332.                             'Reservation' => $reservation,
  333.                             'Designation' => 'Tarif : '. $tarif->getDesignation(),
  334.                             'CodeActivity' => null,
  335.                             'Date' => $date_arrive,
  336.                             'Creneau' => null,
  337.                             'Quantity' => $tarifArray['qty'],
  338.                             'PuTTC' => $tarif->getPriceTtc(),
  339.                             'TauxTVA' => $tarif->getTauxTva(),
  340.                             'TotalHt' => null,
  341.                             'MontantTva' => null,
  342.                             'TotalTTC' => null,
  343.                             'Parent' => $resaDetails,
  344.                         );
  345.                         $tarifDetails = $this->addReservationDetail($tarifDetailsArgs);
  346.                     }
  348.                 }
  349.                 
  350.                 foreach($forfaitArray['options'] as $optionArray) {
  352.                     $option = $optionArray['obj_option'];
  354.                     if($option) {
  355.                         $optionDetailsArgs = array(
  356.                             'Reservation' => $reservation,
  357.                             'Designation' => 'Option : '. $option->getDesignation(),
  358.                             'CodeActivity' => null,
  359.                             'Date' => $date_arrive,
  360.                             'Creneau' => null,
  361.                             'Quantity' => $optionArray['qty'],
  362.                             'PuTTC' => $option->getPriceTtc(),
  363.                             'TauxTVA' => $option->getTauxTva(),
  364.                             'TotalHt' => null,
  365.                             'MontantTva' => null,
  366.                             'TotalTTC' => null,
  367.                             'Parent' => $resaDetails,
  368.                         );
  369.                         $optionDetails = $this->addReservationDetail($optionDetailsArgs);
  370.                     }
  372.                 }
  373.                 
  374.                 if(isset($forfaitArray['activity'])) {
  377.                     foreach($forfaitArray['activity'] as $activityArray) {
  378.                         $activity = $activityArray['obj_activity'];
  380.                         $bookedActivity = new BookedActivity();
  381.                         $bookedActivity->setFormule($formule['obj_formule']->getCode());
  382.                         $bookedActivity->setForfait($forfait->getDesignation());
  383.                         
  384.                         $activitySearch = $em->getRepository(Activity::class)->find($activity->getId());
  386.                         if($activitySearch)
  387.                         {
  388.                             $bookedActivity->setCodeActivity($activitySearch->getCode());
  389.                             $bookedActivity->setDesignation($activitySearch->getDesignation());
  390.                         } else {
  391.                             $bookedActivity->setCodeActivity(Tools::str2url($activity->getDesignation()));
  392.                             $bookedActivity->setDesignation($activity->getDesignation());
  393.                         }
  396.                             
  397.                         if(isset($activityArray['creneau'])) {
  399.                             $creneau_activity = $activityArray['creneau'];
  400.                             $creneauActivity = new \DateTime($date_arrive->format('Y-m-d'));
  401.                             $creneauActivity->add(new \DateInterval('PT'.strtoupper($creneau_activity).'M')); 
  402.                             
  403.                             $creneauActivity_Check = new \DateTime($date_arrive->format('Y-m-d'));
  404.                             $creneauActivity_Check->add(new \DateInterval('P1D')); 
  405.                             $creneauActivity_Check->add(new \DateInterval('PT'.strtoupper($creneau_activity).'M')); 
  407.                             $interval = $creneauActivity->diff($creneauActivity_Check);
  409.                             if($interval->format('%R%h') == '+1') {
  410.                                 $creneauActivity->add(new \DateInterval('PT1H')); 
  411.                             } elseif( $interval->format('%R%h') == '-1') {
  412.                                 $creneauActivity->sub(new \DateInterval('PT1H')); 
  413.                             }
  414.                             
  415.                             $bookedActivity->setDate($creneauActivity);
  416.                             $bookedActivity->setCreneau($creneauActivity);
  417.                         } else {
  418.                             $bookedActivity->setDate($date_arrive);
  419.                             //TO-DO : voir si on réserve toutes les activités au créneau de l'anniversaire ou non
  420.                             if(in_array('anniversaire',$formulesArray)) {
  421.                                 $bookedActivity->setCreneau($creneauAnniversaire);  
  422.                             }
  423.                             // =========================================================================
  424.                         }
  426.                         $bookedQty = (isset($activityArray['parties'])) ? $activityArray['qty'] : ($activityArray['qty'] / $activityArray['parties']);
  427.                         $bookedActivity->setQuantity($bookedQty);
  428.                         // $bookedActivity->setQuantity($activityArray['qty']);
  429.                         $bookedActivity->setNbreParties($activityArray['parties']);
  430.                         $bookedActivity->setReservation($reservation);
  431.                         $bookedActivity->setAdmin(0);
  432.                         $em->persist($bookedActivity);
  433.                         $em->flush();
  434.                     }
  436.                 }   
  437.             }
  438.         }
  439.         
  440.         if(isset($cart['bon_numerique'])) {
  441.             foreach ($cart['bon_numerique'] as $key => $bon) {
  442.                 $bonDetails = new ReservationDetails();
  443.                 $bonDetails->setDesignation('E-ticket : '.$bon['bon'].' ('.$bon['total'].')');
  444.                 $bonDetails->setDate($date_arrive);
  445.                 $bonDetails->setReservation($reservation);
  446.                 $bonDetails->setTotalTTC(round(0 - $bon['total'],2));
  447.                 $em->persist($bonDetails);
  448.                 $em->flush();
  449.             }
  450.         }
  451.         
  452.         if(isset($cart['code_promo'])) {
  453.             if($cart['code_promo']->getTypeReduction() == 'percentage') $montantPromoPanier = '-'.($cart['code_promo']->getPercent()*100).'%';
  454.             elseif($cart['code_promo']->getTypeReduction() == 'montant') $montantPromoPanier = '-'.$cart['code_promo']->getReduction().'€';
  456.             $promoPanierDetails = new ReservationDetails();
  457.             $promoPanierDetails->setDesignation('Code promo : '.$cart['code_promo']->getCode().' ('.$montantPromoPanier.')');
  458.             $promoPanierDetails->setDate($date_arrive);
  459.             $promoPanierDetails->setReservation($reservation);
  460.             if($cart['code_promo']->getTypeReduction() == 'percentage') {
  461.                 $montant_reduction = round(0 - ($reservation->getTotalTTC()*$cart['code_promo']->getPercent()),2);
  462.             } else if($cart['code_promo']->getTypeReduction() == 'montant') {
  463.                 $montant_reduction = round(0 - $cart['code_promo']->getReduction(),2);
  464.             }
  465.             $promoPanierDetails->setTotalTTC($montant_reduction);
  466.             $em->persist($promoPanierDetails);
  467.             $em->flush();
  468.         }
  469.         
  470.         $em->persist($reservation);
  471.         $em->flush();
  473.         //Historique de solde
  474.         $history_resa = new History();
  476.         if($customer instanceof Customer)
  477.         {
  478.             $history_resa->setCustomerId($customer->getId());
  479.             $history_resa->setInformation("Réservation " . $reservation_number . " (#" . $reservation_id . ")"); 
  480.             $resa_total_ttc = abs($reservation->getTotalTTC()) * -1;
  481.             $history_resa->setMouvement($resa_total_ttc);
  482.             $history_resa->setReservation($reservation);
  483.             $em->persist($history_resa);
  484.             $em->flush();
  485.         }
  486.         
  487.         // dd($forfaitArray['activity']);
  488.         return $reservation;
  489.     }   
  490.     
  491.      /**
  492.      * @Route("/createpaiement", methods={"POST"}, name="booking_createpaiement")
  493.      * Cette fonction permet de créer le formulaire de paiement
  494.      */
  495.     public function createPaiement(Request $request)
  496.     {
  497.         // action_paiement : - carte_payplug
  498.         //                   - carte_1055
  499.         // dd($this->secretkey[$this->paiement_mode]);
  500.         $data = json_decode($request->request->get('data'));
  501.         $error = false;
  502.         $action_paiement = $data->action_paiement;
  503.         $json_total_panier = $data->total_panier;
  504.         $json_total_a_payer = $data->total_a_payer;
  505.         $titulaire_carte_1055 = $data->titulaire_carte_1055;
  506.         $numero_carte_1055 = $data->numero_carte_1055;
  508.         $infos = array();
  509.         if($titulaire_carte_1055) $infos['titulaire_carte_1055'] = $titulaire_carte_1055;
  510.         if($numero_carte_1055) $infos['numero_carte_1055'] = $numero_carte_1055;
  512.         $reservation = $this->createReservation($action_paiement, $infos, $json_total_a_payer, $json_total_panier);
  514.         $reservation_id =  (int)$reservation->getId();
  515.         $reservation_number = $reservation->getNumeroResa();
  516.         $total_a_payer = $reservation->getTotalTTC();
  518.         $customer = $this->container->get('security.token_storage')->getToken()->getUser();
  519.         $customer_number = $customer->getCustomerNumber();
  520.         
  521.         $return_url = $this->generateUrl('success', array(), UrlGeneratorInterface::ABSOLUTE_URL);
  522.         $cancel_url = $this->generateUrl('cancel', array(), UrlGeneratorInterface::ABSOLUTE_URL);
  523.         $notification_url = $this->generateUrl('notification', array(), UrlGeneratorInterface::ABSOLUTE_URL);
  525.         if($action_paiement == "carte_1055") {
  526.             file_get_contents($notification_url . '?idresa='.$reservation_number."&p=1");
  527.             $data->return_url = $return_url . '?idresa='.$reservation_number."&p=1";
  528.         } else if($action_paiement == "panier_precommande") {
  529.             file_get_contents($notification_url . '?idresa='.$reservation_number."&pre=1");
  530.             $data->return_url = $return_url . '?idresa='.$reservation_number."&pre=1";
  531.         } else if($action_paiement == "carte_payplug") {
  532.             $vendor_dir = str_replace('src','vendor',dirname(__DIR__));
  533.             require_once($vendor_dir . '/payplug/payplug-php/lib/init.php');
  534.             // \Payplug\Payplug::setSecretKey($this->secretkey);
  535.             \Payplug\Payplug::init(array(
  536.               'secretKey' => $this->secretkey[$this->paiement_mode],
  537.             ));
  539.             if($customer->getEmail() != "")
  540.                 $email = $customer->getEmail();
  541.             else
  542.                 $error = 'no email';
  544.             if( $customer->getPhoneMobile() != "") {
  545.                 $phoneMobile = str_replace(' ','',$customer->getPhoneMobile());
  546.                 $phoneMobile = str_replace('.','',$phoneMobile);
  547.                 $phoneMobile = str_replace('-','',$phoneMobile);
  549.                 if(strlen($phoneMobile) == 10 && strpos($customer->getPhoneMobile(),'+') === false) {
  550.                     $phoneMobile = '+33'.substr($phoneMobile,1);
  551.                 } elseif(substr($phoneMobile, 0, 2) === "00" && strlen($phoneMobile) == 13) {
  552.                     $phoneMobile = '+'.substr($phoneMobile, 2);
  553.                 }
  554.             }   
  555.             else
  556.                 $error = 'no mobile phone';
  557.             
  558.             $firstname = $customer->getFirstname();
  559.             $lastname = $customer->getLastname();
  560.             $address1 = $customer->getAddress1();
  561.             $address2 = ($customer->getAddress2() != "") ? $customer->getAddress2() : null;
  562.             $postcode = $customer->getPostcode();
  563.             $city = $customer->getCity();
  564.             $country = $customer->getCountry();
  566.             // if (isset($reservation->acompte_paiement) && ($reservation->acompte_paiement) > 0) 
  567.             //     $amount = intval(number_format($reservation->acompte_paiement * 100, 0, '.', ''));
  568.             // elseif (isset($reservation->total_a_payer) && ($reservation->total_a_payer) > 0) 
  569.             //     $amount = intval(number_format($reservation->total_a_payer * 100, 0, '.', ''));
  570.             // else 
  571.             //     $error = 'no amount';
  572.             
  573.             if($total_a_payer != ($json_total_a_payer/100) && ((int) round($total_a_payer*100,0)) == $json_total_panier) {
  574.                 $amount = $json_total_a_payer;
  575.             } else {
  576.                 $amount = (int) round($total_a_payer*100,0);
  577.             }
  579.             $arg_payplug = array(
  580.                 'amount'         => $amount,
  581.                 'currency'       => 'EUR',
  582.                 // 'save_card'      => true, // TO-DO : change to true en mode PROD si 1055 OK
  583.                 'billing'       => array(
  584.                     'first_name' => $firstname,
  585.                     'last_name'  => $lastname,
  586.                     'email'      => $email,
  587.                     'address1'   => $address1,
  588.                     'address2'   => $address2,
  589.                     'mobile_phone_number'    => $phoneMobile,
  590.                     'city'       => $city,
  591.                     'postcode'   => $postcode,
  592.                     'country'    => $country,
  593.                     'language' => 'fr',
  594.                 ),
  595.                 'shipping'       => array(
  596.                     'email'      => $email,
  597.                     'first_name' => $firstname,
  598.                     'last_name'  => $lastname,
  599.                     'address1'   => $address1,
  600.                     'address2'   => $address2,
  601.                     'mobile_phone_number'    => $phoneMobile,
  602.                     'city'       => $city,
  603.                     'postcode'   => $postcode,
  604.                     'country'    => $country,
  605.                     'language' => 'fr',
  606.                     'delivery_type'  => 'TRAVEL_OR_EVENT', // OTHER ou BILLING
  607.                 ),
  608.                 'hosted_payment' => array(
  609.                     'return_url' => $return_url . '?idresa='.$reservation_number,
  610.                     'cancel_url' => $cancel_url . '?idresa='.$reservation_number,
  611.                 ),
  612.                 'notification_url' => $notification_url . '?idresa='.$reservation_number,
  613.                 'metadata'        => array(
  614.                     'customer_number'       => $customer_number,
  615.                     'reservation_id'        => $reservation_id,
  616.                     'reservation_number'    => $reservation_number
  617.                 )
  618.             );
  620.             // dd($arg_payplug);
  621.             
  622.             try{
  623.                 $payment = \Payplug\Payment::create($arg_payplug);
  624.             }
  625.             catch(\Exception $e){
  626.                 $error = serialize($arg_payplug);
  627.             }
  628.             if(!$error){
  629.                 $data->payment_url = $payment->hosted_payment->payment_url;
  630.                 $data->payment_id = $payment->id;
  632.                 $em = $this->getDoctrine()->getManager();
  633.                 $reservation->setPaymentId($payment->id);
  634.                 $today = new \DateTime('now');
  635.                 $history = $reservation->getHistory();    
  636.                 $request = Request::createFromGlobals();
  637.                 $history .= $request->headers->get('User-Agent')."\n".'--------------------------'."\n";             
  638.                 $history .= $today->format("d/m/Y H:i:s") . " : Transaction créée (" . $payment->id . ")\n";
  639.                 $reservation->setHistory($history);
  640.                 $em->persist($reservation);
  641.                 $em->flush();
  642.             }
  643.         }
  645.         if(!$error){
  646.             $today = new \DateTime('now');
  647.             $em = $this->getDoctrine()->getManager();
  648.             $cartSession = $em->getRepository(CartSession::class)->findOneBy(['id_cart_session' => $customer->getId().'_'.$today->format('Ymd')]);
  649.             if($cartSession instanceof CartSession) {
  650.                 $em->remove($cartSession);
  651.                 $em->flush();
  652.             }
  653.         }
  654.         
  655.         if ($error) {
  656.             return new JsonResponse(['error' => $error, 'data' => $arg_payplug], JsonResponse::HTTP_CREATED);
  657.         } else {
  658.             return new JsonResponse($data, JsonResponse::HTTP_CREATED);         
  659.         }
  660.     }
  663.     /**
  664.      * @Route("/success", methods={"GET", "POST"}, name="success")
  665.      * Cette fonction permet d'afficher la page de succès après paiement réussi
  666.      */
  667.     public function successAction(Request $request, MailerInterface $mailer)
  668.     {
  670.         $cart = $this->ss->get();
  671.         $this->ss->empty();
  673.         $vendor_dir = str_replace('src','vendor',dirname(__DIR__));
  674.         require_once($vendor_dir . '/payplug/payplug-php/lib/init.php');
  675.         \Payplug\Payplug::init(array(
  676.           'secretKey' => $this->secretkey[$this->paiement_mode],
  677.         ));
  679.         /* GET Method */
  680.         $reservation_number = $request->query->get('idresa');
  681.         $carte_1055 = ($request->query->get('p') != null && $request->query->get('p') == '1') ? true : false;
  682.         $panier_precommande = ($request->query->get('pre') != null && $request->query->get('pre') == '1') ? true : false;
  683.         $reservation_date = null;
  684.         $transaction_ok = null;
  685.         $failure_id = null;
  686.         $error = null;
  687.         $print_url = $this->generateUrl('print', array(), UrlGeneratorInterface::ABSOLUTE_URL);
  688.         $print_url .= '?idresa=';
  690.         if($reservation_number != null && $reservation_number != "") 
  691.         {
  692.             $em = $this->getDoctrine()->getManager();
  693.             $reservation = $em->getRepository(Reservation::class)->findOneBy(['numeroResa' => $reservation_number]);
  694.         
  695.             if (!$reservation) {
  696.                 $error = 'Aucune réservation trouvée. Veuillez nous contacter par téléphone.';
  697.             }
  699.             if($reservation instanceof Reservation)
  700.             {
  701.                 $payment_id = $reservation->getPaymentId();
  702.                 $reservation_number = $reservation->getNumeroResa();
  703.                 $reservation_date = $reservation->getDateResa();
  704.                 $reservation_montant_ht = $reservation->getSstotalHT();     
  705.                 $reservation_montant = $reservation->getTotalTTC();   
  706.                 $transaction_ok = false;
  707.                 $print_url .= $reservation_number;
  708.                             
  709.                 $reservation_regle = 0;
  710.                 if($payment_id != null && $payment_id != "" && $this->paiement_mode != "test")
  711.                 {
  712.                     $payment = \Payplug\Payment::retrieve($payment_id);
  713.                     
  714.                     if($payment->is_paid && $payment->failure == null) {
  715.                         $transaction_ok = true;
  716.                         $reservation_regle = $payment->amount / 100;
  717.                     } elseif(!$payment->is_paid && $payment->failure != null) {
  718.                         $failure_id = $payment->failure->message;
  719.                     }
  720.                 }
  722.                 if($carte_1055) {
  723.                     $print_url .= "&p=1";
  724.                 }
  726.                 // ##################
  727.                 // Compostage Voucher
  728.                 if(($carte_1055 || $transaction_ok || (float) $reservation_montant == 0) && isset($cart['bon_numerique'])) {
  729.                     foreach ($cart['bon_numerique'] as $key => $bon) {
  730.                         $data = $this->vs->getVoucher($bon['bon']);
  731.                         if ( $data['_remaining_value'] != 0 && $data['status'] == "wcpdf-active") {
  732.                             $target = $bon['bon'];
  733.                             $quantity = isset($bon['qty']) ? $bon['qty'] : '';
  734.                             $amount = isset($bon['bon_total']) ? $bon['bon_total'] : '';
  735.                             if($data['unlimited_voucher']) {
  736.                                 $amount = 1 * $bon['total'] / 1.1;
  737.                             }
  738.                             $param = 'action=set&target='.$target.'&quantity='.$quantity.'&amount='.$amount.'&user='.$this->user_id_boutique.'&demandeur=client';
  739.                             $result = $this->vs->getData($param);
  740.                         } 
  741.                     }
  742.                 
  743.                 }
  744.                 // FIN Compostage Voucher
  745.                 // ##################
  746.                 
  747.             }
  748.         } else $error = "Votre numéro de réservation n'est pas indiqué ou il est non valide.";
  749.     
  750.         $formules = explode(',',$reservation->getFormule());
  752.         return $this->render('paiement/success.html.twig', array(
  753.             'environnement' => $this->paiement_mode,
  754.             'date_resa' => ($reservation_date != null) ? $reservation_date->format("d/m/Y") : null ,
  755.             'creneau_resa' => ($reservation_date != null && in_array('anniversaire',$formules)) ? $reservation_date->format('H:i') : null ,
  756.             'reservation' => $reservation,
  757.             'carte_1055' => $carte_1055,
  758.             'panier_precommande' => $panier_precommande,
  759.             'transaction_ok' => $transaction_ok,
  760.             'reservation_regle' => number_format($reservation_regle, 2, ',', ' ') . ' €',
  761.             'reservation_montant' => number_format($reservation_montant, 2, ',', ' ') . ' €',
  762.             'reservation_montant_tva' => number_format(($reservation_montant - $reservation_montant_ht), 2, ',', ' ') . ' €',
  763.             'reservation_montant_ht' => number_format($reservation_montant_ht, 2, ',', ' ') . ' €',
  764.             'print_url' => $print_url,
  765.             'failure_id' => $failure_id,
  766.             'error' => $error
  767.         ));
  768.     }
  771.     /**
  772.      * @Route("/cancel", methods={"GET", "POST"}, name="cancel")
  773.      * Cette fonction permet d'afficher la page de paiement annulé
  774.      */
  775.     public function cancelAction(Request $request)
  776.     {
  778.         $vendor_dir = str_replace('src','vendor',dirname(__DIR__));
  779.         require_once($vendor_dir . '/payplug/payplug-php/lib/init.php');
  780.         \Payplug\Payplug::init(array(
  781.           'secretKey' => $this->secretkey[$this->paiement_mode],
  782.         ));
  784.         $reservation_number = $request->query->get('idresa');
  785.         if($reservation_number != null && $reservation_number != "") 
  786.         {
  787.             $em = $this->getDoctrine()->getManager();
  788.             $reservation = $em->getRepository(Reservation::class)->findOneBy(['numeroResa' => $reservation_number]);
  789.             $resource = \Payplug\Payment::retrieve($reservation->getPaymentId());
  790.             $payment_id = $resource->id;
  791.             $payment_amount = $resource->amount / 100;
  792.             $payment_amount_format = number_format($resource->amount / 100, 2, ',', ' ');
  794.             if($reservation instanceof Reservation && $reservation->getPaymentId() == $payment_id ) {
  796.                 $customer_number = $reservation->getCustomerNumber();
  797.                 $cm = $this->getDoctrine()->getManager("customer");
  798.                 $customer = $cm->getRepository(Customer::class)->findOneBy(['customerNumber' => $customer_number]);
  799.             
  800.                 if ($resource instanceof \Payplug\Resource\Payment && !$resource->is_paid)
  801.                 {
  802.                     $message_error = $this->getErrorMsgPayplug($resource->failure->code);
  803.                     // $reservation->setStatut('Payé');
  804.                     $failure_code = 'non disponible';
  805.                     if($resource->failure != null && ($resource->failure->code == 'aborted' || $resource->failure->code == 'timeout')){
  806.                         $failure_code = $resource->failure->code;
  807.                         $reservation->setStatut('Abandon');
  808.                     } else {
  809.                         $reservation->setStatut('Erreur paiement');
  810.                     }
  811.                     $dateTimeZone = new \DateTimeZone('Europe/Paris');
  812.                     $today = new \DateTime('now', $dateTimeZone);
  813.                     $history = $reservation->getHistory();  
  814.                     $history .= $today->format("d/m/Y H:i:s") . " : Transaction échoué de " . $payment_amount_format . " € (" . $payment_id . ")\n";
  815.                     $history .= "------------------- : Payplug #(".$message_error.")\n";
  816.                     $reservation->setHistory($history);
  818.                     $history_solde = new History();
  819.                     
  820.                     if($customer instanceof Customer)
  821.                     {
  822.                         $history_solde->setCustomerId($customer->getId());
  823.                         $history_solde->setInformation("Erreur PAYPLUG : " . $reservation_number . " (" . $payment_id . ") [".$failure_code."]");
  824.                         $history_solde->setMouvement($payment_amount);
  825.                         $history_solde->setReservation($reservation);
  826.                         $em->persist($history_solde);
  827.                     }
  828.                 }
  829.             }
  831.             $em->persist($reservation);
  832.             $em->flush();
  833.         }
  835.         return $this->redirectToRoute('payment');
  836.     }
  838.     private function getErrorMsgPayplug($error_code) 
  839.     {
  841.         switch ($error_code) {
  842.             case 'processing_error':
  843.                 $error_msg = "Erreur lors du traitement de la carte.";
  844.                 break;
  846.             case 'card_declined':
  847.                 $error_msg = "La banque du client a refusé la demande de paiement.";
  848.                 break;
  850.             case '3ds_declined':
  851.                 $error_msg = "La requête d'authentification 3D Secure a échoué";
  852.                 break;
  854.             case 'insufficient_funds':
  855.                 $error_msg = "La carte a atteint son plafond autorisé";
  856.                 break;
  858.             case 'incorrect_number':
  859.                 $error_msg = "Les informations de la carte sont incorrectes (numéro, date d’exp. ou le CVV)";
  860.                 break;
  862.             case 'fraud_suspected':
  863.                 $error_msg = "Paiement refusé car une fraude a été détectée.";
  864.                 break;
  866.             case 'method_unsupported':
  867.                 $error_msg = "Le moyen de paiement n'est pas supporté";
  868.                 break;
  870.             case 'card_scheme_mismatch':
  871.                 $error_msg = "Le numéro de carte ne correspond pas à la marque sélectionnée.";
  872.                 break;
  874.             case 'card_expiration_date_prior_to_last_installment_date':
  875.                 $error_msg = "La date d'expiration de la carte est antérieure à la date du dernier versement.";
  876.                 break;
  878.             case 'aborted':
  879.                 $error_msg = "Le paiement a été abandonné";
  880.                 break;
  882.             case 'timeout':
  883.                 $error_msg = "Le client n'a pas essayé de payer et a quitté la page de paiement.";
  884.                 break;
  885.             
  886.             default:
  887.                 $error_msg = "Erreur de paiement";
  888.                 break;
  889.         }
  891.         return $error_msg;
  892.     }
  894.     /**
  895.      * @Route("/notification", methods={"GET", "POST"}, name="notification")
  896.      * Cette fonction permet d'afficher la page de succès après paiement réussi
  897.      */
  898.     public function notificationAction(Request $request, MailerInterface $mailer)
  899.     {
  901.         $vendor_dir = str_replace('src','vendor',dirname(__DIR__));
  902.         require_once($vendor_dir . '/payplug/payplug-php/lib/init.php');
  903.         \Payplug\Payplug::init(array(
  904.           'secretKey' => $this->secretkey[$this->paiement_mode],
  905.         ));
  906.         $error = null;
  908.         // $input = file_get_contents('php://input');
  910.         $idresa = $request->query->get('idresa');
  911.         $carte_1055 = ($request->query->get('p') != null && $request->query->get('p') == '1') ? true : false;
  912.         $panier_precommande = ($request->query->get('pre') != null && $request->query->get('pre') == '1') ? true : false;
  913.         $em = $this->getDoctrine()->getManager();
  914.         $reservationVerif = $em->getRepository(Reservation::class)->findOneBy(['numeroResa' => $idresa]);
  915.         // $resource = \Payplug\Payment::retrieve($reservationVerif->getPaymentId());
  916.         // $input = file_get_contents('php://input');
  917.         
  918.         try {
  919.             // $resource = \Payplug\Notification::treat($input);
  920.             if($reservationVerif->getPaymentId() != "") {
  921.                 $resource = \Payplug\Payment::retrieve($reservationVerif->getPaymentId());
  922.                 // $payment_id = 'pay_1GJ2PMEWFPSIgfNbeWkv9a'; $resource = \Payplug\Payment::retrieve($payment_id); // POUR DEBUG
  924.                 if ($resource instanceof \Payplug\Resource\Payment)
  925.                 {
  926.                     $payment_id = $resource->id;
  927.                     $payment_state = $resource->is_paid;
  928.                     $payment_date = $resource->hosted_payment->paid_at;
  929.                     $payment_amount = $resource->amount / 100;
  930.                     $payment_amount_format = number_format($resource->amount / 100, 2, ',', ' ');
  931.                     if (isset($resource->metadata['customer_number'])) $customer_number = $resource->metadata['customer_number'];
  932.                     if (isset($resource->metadata['customer_id'])) $customer_number = $resource->metadata['customer_id'];
  933.                     $reservation_id = $resource->metadata['reservation_id'];
  934.                     $reservation_number = $resource->metadata['reservation_number'];
  935.                     $failure_id = $resource->failure;
  937.                     $reservation = $em->getRepository(Reservation::class)->findOneBy(['numeroResa' => $reservation_number]);
  938.                     
  939.                     if($reservation instanceof Reservation && $reservation->getPaymentId() == $payment_id && !$reservation->getActive())
  940.                     {
  941.                         $customer_number = $reservation->getCustomerNumber();
  942.                         $cm = $this->getDoctrine()->getManager("customer");
  943.                         $customer = $cm->getRepository(Customer::class)->findOneBy(['customerNumber' => $customer_number]);
  944.                         
  945.                         if($resource->is_paid && $resource->failure == null) 
  946.                         {
  947.                             $reservation->setStatut('Payé');
  948.                             $reservation->setActive(1);                     
  949.                             $dateTimeZone = new \DateTimeZone('Europe/Paris');
  950.                             $today = new \DateTime('now', $dateTimeZone);
  951.                             $history = $reservation->getHistory();  
  952.                             $history .= $today->format("d/m/Y H:i:s") . " : Transaction réussie de " . $payment_amount_format . " € (" . $payment_id . ")\n";
  953.                             $reservation->setHistory($history);
  955.                             $history_solde = new History();
  956.                             // $customer = $em->getRepository(Customer::Class)->findOneBy(['customerNumber' => $customer_number]);
  957.                             
  958.                             if($customer instanceof Customer)
  959.                             {
  960.                                 $history_solde->setCustomerId($customer->getId());
  961.                                 $history_solde->setInformation("Paiement PAYPLUG : " . $reservation_number . " (" . $payment_id . ")");
  962.                                 $history_solde->setMouvement($payment_amount);
  963.                                 $history_solde->setReservation($reservation);
  964.                                 $em->persist($history_solde);
  965.                             }
  966.                             //Envoi des emails
  967.                             $transaction_ok = true;
  968.                             $comment = $reservation->getComment();  
  969.                             // if(strpos($comment,'Titulaire carte 1055') !== false) {
  970.                             //     $transaction_ok = 'carte_1055';
  971.                             // }
  972.                             $reservation_date = $reservation->getDateResa();
  973.                             $reservation_montant_ht = $reservation->getSstotalHT();
  974.                             $reservation_montant = $reservation->getTotalTTC();
  975.                             $reservation_regle = $resource->amount / 100;
  976.                             $print_url = $this->generateUrl('print', array(), UrlGeneratorInterface::ABSOLUTE_URL);   
  977.                 
  978.                             $message = (new Email())
  979.                             ->subject('Votre réservation au 1055 : ' . $reservation_number)
  980.                             ->from('reservationbesancon@1055.fr')
  981.                             ->to($customer->getEmail())
  982.                             ->cc('reservationbesancon@1055.fr')
  983.                             ->replyTo('besancon@1055.fr')
  984.                             // ->addCc('dev@publigo.fr')
  985.                             ->html(
  986.                                 $this->renderView(
  987.                                     'email/confirmation.html.twig',
  988.                                     array(
  989.                                         'email' => strtolower($customer->getEmail()),
  990.                                         'firstname' => ucfirst($customer->getFirstname()),
  991.                                         'lastname' => strtoupper($customer->getLastname()),
  992.                                         'address1' => strtoupper($customer->getAddress1()),
  993.                                         'address2' => strtoupper($customer->getAddress2()),
  994.                                         'postcode' => $customer->getPostcode(),
  995.                                         'city' => strtoupper($customer->getCity()),
  996.                                         'phone' => $customer->getPhone(),
  997.                                         'phoneMobile' => $customer->getPhoneMobile(),
  998.                                         'reservation' => $reservation,
  999.                                         'infos_resa' => $reservation->getComment(),
  1000.                                         'date_resa' => ($reservation_date != null) ? $reservation_date->format("d/m/Y") : null,
  1001.                                         'creneau_resa' => ($reservation_date != null && $reservation->getFormule() == 'anniversaire') ? $reservation_date->format('H:i') : null ,
  1002.                                         'numero_resa' => $reservation_number,
  1003.                                         'carte_1055' => false,
  1004.                                         'panier_precommande' => false,
  1005.                                         'transaction_ok' => $transaction_ok,
  1006.                                         'reservation_regle' => number_format($reservation_regle, 2, ',', ' ') . ' €',
  1007.                                         'reservation_montant' => number_format($reservation_montant, 2, ',', ' ') . ' €',
  1008.                                         'reservation_montant_tva' => number_format(($reservation_montant - $reservation_montant_ht), 2, ',', ' ') . ' €',
  1009.                                         'reservation_montant_ht' => number_format($reservation_montant_ht, 2, ',', ' ') . ' €',
  1010.                                         'print_url' => $print_url . '?idresa='.$reservation_number,
  1011.                                         'failure_id' => $failure_id,
  1012.                                         'error' => $error
  1013.                                     )
  1014.                                 )
  1015.                             );
  1016.                             $mailer->send($message);
  1018.                         
  1019.                             $em->persist($reservation);
  1020.                             $em->flush();
  1021.                         } else {
  1022.                             $cancel_url = $this->generateUrl('cancel', array(), UrlGeneratorInterface::ABSOLUTE_URL);
  1023.                             // $cancel_url . '?idresa='.$reservation_number
  1024.                             return $this->redirectToRoute('cancel',array('idresa' => $reservation_number));
  1026.                         }
  1027.                         
  1028.                         $em->persist($reservation);
  1029.                         $em->flush();
  1030.                     }
  1031.                 } 
  1032.             } 
  1034.             if($carte_1055 || $panier_precommande) {
  1035.                 if($reservationVerif instanceof Reservation )
  1036.                 {
  1037.                     $customer_number = $reservationVerif->getCustomerNumber();
  1038.                     $cm = $this->getDoctrine()->getManager("customer");
  1039.                     $customer = $cm->getRepository(Customer::class)->findOneBy(['customerNumber' => $customer_number]);
  1041.                     $today = new \DateTime('now');
  1042.                     $history = $reservationVerif->getHistory();
  1043.                     $request = Request::createFromGlobals();
  1044.                     $history .= $request->headers->get('User-Agent')."\n".'--------------------------'."\n";   
  1045.                     if($carte_1055) $history .= $today->format("d/m/Y H:i:s") . " : Demande de paiement par Carte 10 55\n";
  1046.                     else if($panier_precommande) $history .= $today->format("d/m/Y H:i:s") . " : Paiement par bon numérique\n";
  1047.                     $reservationVerif->setHistory($history);
  1049.                     $failure_id = false;
  1050.                     $transaction_ok = $carte_1055 ? $carte_1055 : $panier_precommande;
  1051.                     $comment = $reservationVerif->getComment(); 
  1052.                     $reservation_date = $reservationVerif->getDateResa();
  1053.                     $reservation_montant_ht = $reservationVerif->getSstotalHT();
  1054.                     $reservation_montant = $reservationVerif->getTotalTTC();
  1055.                     $reservation_regle = 0;
  1056.                     $print_url = $this->generateUrl('print', array(), UrlGeneratorInterface::ABSOLUTE_URL);   
  1057.         
  1058.                     $message = (new Email())
  1059.                     ->subject('Votre réservation au 1055 : ' . $idresa)
  1060.                     ->from('reservationbesancon@1055.fr')
  1061.                     ->to($customer->getEmail())
  1062.                     ->cc('reservationbesancon@1055.fr')
  1063.                     ->replyTo('besancon@1055.fr')
  1064.                     // ->addCc('dev@publigo.fr')
  1065.                     ->html(
  1066.                         $this->renderView(
  1067.                             'email/confirmation.html.twig',
  1068.                             array(
  1069.                                 'email' => strtolower($customer->getEmail()),
  1070.                                 'firstname' => ucfirst($customer->getFirstname()),
  1071.                                 'lastname' => strtoupper($customer->getLastname()),
  1072.                                 'address1' => strtoupper($customer->getAddress1()),
  1073.                                 'address2' => strtoupper($customer->getAddress2()),
  1074.                                 'postcode' => $customer->getPostcode(),
  1075.                                 'city' => strtoupper($customer->getCity()),
  1076.                                 'phone' => $customer->getPhone(),
  1077.                                 'phoneMobile' => $customer->getPhoneMobile(),
  1078.                                 'reservation' => $reservationVerif,
  1079.                                 'infos_resa' => $reservationVerif->getComment(),
  1080.                                 'date_resa' => ($reservation_date != null) ? $reservation_date->format("d/m/Y") : null,
  1081.                                 'creneau_resa' => ($reservation_date != null && $reservationVerif->getFormule() == 'anniversaire') ? $reservation_date->format('H:i') : null ,
  1082.                                 'numero_resa' => $idresa,
  1083.                                 'carte_1055' => $carte_1055,
  1084.                                 'panier_precommande' => $panier_precommande,
  1085.                                 'transaction_ok' => false,
  1086.                                 'reservation_regle' => number_format($reservation_regle, 2, ',', ' ') . ' €',
  1087.                                 'reservation_montant' => number_format($reservation_montant, 2, ',', ' ') . ' €',
  1088.                                 'reservation_montant_tva' => number_format(($reservation_montant - $reservation_montant_ht), 2, ',', ' ') . ' €',
  1089.                                 'reservation_montant_ht' => number_format($reservation_montant_ht, 2, ',', ' ') . ' €',
  1090.                                 'print_url' => $print_url . '?idresa='.$idresa,
  1091.                                 'failure_id' => $failure_id,
  1092.                                 'error' => $error
  1093.                             )
  1094.                         )
  1095.                     );
  1096.                     $mailer->send($message);
  1098.                     $em->persist($reservationVerif);
  1099.                     $em->flush();
  1100.                 }
  1101.             }
  1102.         }
  1103.         catch (\Payplug\Exception\PayplugException $exception) {
  1104.           echo $exception;
  1105.         }
  1106.         
  1107.         return $this->render('paiement/notification.html.twig', array());
  1108.     }
  1111.     /**
  1112.      * @Route("/print", methods={"GET", "POST"}, name="print")
  1113.      * Cette fonction permet d'imprimer le PDF de réservation
  1114.      */
  1115.     public function printAction(Request $request)
  1116.     {   
  1117.         $vendor_dir = str_replace('src','vendor',dirname(__DIR__));
  1118.         require_once($vendor_dir . '/payplug/payplug-php/lib/init.php');
  1119.         \Payplug\Payplug::init(array(
  1120.           'secretKey' => $this->secretkey[$this->paiement_mode],
  1121.         ));
  1123.         /* GET Method */
  1124.         $reservation_number = $request->query->get('idresa');
  1125.         $carte_1055 = $request->query->get('p');
  1126.         $panier_precommande = $request->query->get('pre');
  1127.         $error = null;
  1128.         // $snappy = $this->get('knp_snappy.pdf');
  1129.         $pageUrl = $this->generateUrl('home', array(), false);
  1131.         if($reservation_number != null && $reservation_number != "") 
  1132.         {
  1133.             $em = $this->getDoctrine()->getManager();
  1134.             $reservation = $em->getRepository(Reservation::class)->findOneBy(['numeroResa' => $reservation_number]);
  1136.             $customer_id = $reservation->getCustomerId();
  1137.             $cm = $this->getDoctrine()->getManager("customer");
  1138.             $customer = $cm->getRepository(Customer::class)->findOneBy(['id' => $customer_id]);
  1140.             if (!$reservation) {
  1141.                 $error = 'Aucune réservation trouvée. Veuillez nous contacter par téléphone.';
  1142.             }
  1144.             if($reservation instanceof Reservation)
  1145.             {
  1146.                 $payment_id = $reservation->getPaymentId();
  1147.                 $reservation_number = $reservation->getNumeroResa();
  1148.                 $reservation_date = $reservation->getDateResa();
  1149.                 $reservation_montant_ht = $reservation->getSstotalHT();
  1150.                 $reservation_montant = $reservation->getTotalTTC();
  1151.                 $transaction_ok = false;
  1152.                 $failure_id = false;    
  1153.                 
  1154.                 $reservation_regle = 0;
  1155.                 if($payment_id != null && $payment_id != "")
  1156.                 {
  1157.                     $payment = \Payplug\Payment::retrieve($payment_id);
  1158.                     
  1159.                     if($payment->is_paid && $payment->failure == null) {
  1160.                         $transaction_ok = true;
  1161.                         $reservation_regle = $payment->amount / 100;
  1162.                     } elseif(!$payment->is_paid && $payment->failure != null) {
  1163.                         $transaction_ok = false;
  1164.                         $failure_id = $payment->failure->message;
  1165.                     }
  1166.                 }
  1168.                 if($carte_1055) {
  1169.                     $transaction_ok = 'carte_1055';
  1170.                 }
  1171.                 if($panier_precommande) {
  1172.                     $transaction_ok = 'panier_precommande';
  1173.                 }
  1174.             }
  1175.         } else $error = "Votre numéro de réservation n'est pas indiqué ou il est non valide.";
  1177.         return $this->render(
  1178.             'paiement/print.html.twig',
  1179.             array(
  1180.                 'environnement' => $this->paiement_mode,
  1181.                 'date_resa' => ($reservation_date != null) ? $reservation_date->format("d/m/Y") : null ,
  1182.                 'creneau_resa' => ($reservation_date != null && $reservation->getFormule() == 'anniversaire') ? $reservation_date->format('H:i') : null ,
  1183.                 'numero_resa' => $reservation_number,
  1184.                 'transaction_ok' => $transaction_ok,
  1185.                 'reservation' => $reservation,
  1186.                 'customer' => $customer,
  1187.                 'reservation_regle' => number_format($reservation_regle, 2, ',', ' ') . ' €',
  1188.                 'reservation_montant' => number_format($reservation_montant, 2, ',', ' ') . ' €',
  1189.                 'reservation_montant_tva' => number_format(($reservation_montant - $reservation_montant_ht), 2, ',', ' ') . ' €',
  1190.                 'reservation_montant_ht' => number_format($reservation_montant_ht, 2, ',', ' ') . ' €',
  1191.                 // 'print_url' => '?idresa='.$reservation_number,
  1192.                 'failure_id' => $failure_id,
  1193.                 'page_url' => $pageUrl,
  1194.                 'error' => $error
  1195.             )
  1196.         );
  1198.     }
  1201.     private function addReservationDetail(array $args) 
  1202.     {
  1203.         $em = $this->getDoctrine()->getManager();
  1205.         $reservationDetails = new ReservationDetails();
  1207.         $reservationDetails->setReservation($args['Reservation']);
  1208.         $reservationDetails->setDesignation($args['Designation']);
  1209.         $reservationDetails->setCodeActivity($args['CodeActivity']);
  1210.         $reservationDetails->setDate($args['Date']);
  1211.         $reservationDetails->setCreneau($args['Creneau']);
  1212.         $reservationDetails->setQuantity($args['Quantity']);
  1213.         $reservationDetails->setPuTTC($args['PuTTC']);
  1214.         $reservationDetails->setTauxTVA($args['TauxTVA']);
  1215.         $reservationDetails->setTotalHt($args['TotalHt']);
  1216.         $reservationDetails->setMontantTva($args['MontantTva']);
  1217.         $reservationDetails->setTotalTTC($args['TotalTTC']);
  1218.         $reservationDetails->setParent($args['Parent']);
  1220.         $em->persist($reservationDetails);
  1221.         $em->flush();
  1223.         return $reservationDetails;
  1224.     }
  1226.     private function sanitize_cart_details($cart_details) 
  1227.     {
  1228.         $return_cart_details = $cart_details;
  1229.         foreach ($cart_details as $code_formule => $value_formule) {
  1230.             $return_cart_details[$code_formule]['obj_formule'] = $value_formule['obj_formule']->getID();
  1232.             foreach ($value_formule['forfaits'] as $key_forfait => $value_forfait) {
  1234.                 $return_cart_details[$code_formule]['forfaits'][$key_forfait]['obj_forfait'] = $value_forfait['obj_forfait']->getDesignation();
  1236.                 foreach ($value_forfait['tarifs'] as $key_tarif => $value_tarif) {
  1237.                     $return_cart_details[$code_formule]['forfaits'][$key_forfait]['tarifs'][$key_tarif]['obj_tarif'] = $value_tarif['obj_tarif']->getDesignation();
  1238.                 }
  1239.                 if(isset($value_forfait['options']) && $value_forfait['options']) {
  1240.                     foreach ($value_forfait['options'] as $key_option => $value_option) {
  1241.                         $return_cart_details[$code_formule]['forfaits'][$key_forfait]['options'][$key_option]['obj_option'] = $value_option['obj_option']->getDesignation();
  1242.                     }
  1243.                 }
  1244.                 if(isset($value_forfait['activity']) && $value_forfait['activity']) {
  1245.                     foreach ($value_forfait['activity'] as $key_activity => $value_activity) {
  1246.                         $return_cart_details[$code_formule]['forfaits'][$key_forfait]['activity'][$key_activity]['obj_activity'] = $value_activity['obj_activity']->getDesignation();
  1247.                     }
  1248.                 }
  1249.             }
  1250.         }
  1251.         return $return_cart_details;
  1252.     }
  1253. }