src/Controller/Shop/CartController.php line 788

Open in your IDE?
  1. <?php
  3. namespace App\Controller\Shop;
  5. use App\Component\Discount\Model\Discount;
  6. use App\Component\Order\Model\Order;
  7. use App\Component\Order\Model\OrderItem;
  8. use App\Component\Order\OrderFactory;
  9. use App\Component\Payment\Model\Payment;
  10. use App\Component\Product\Model\Product;
  11. use App\Component\Product\Repository\ProductRepository;
  12. use App\Component\Shipment\Model\Shipment;
  13. use App\Constants\Emails;
  14. use App\Entity\CustomerContact;
  15. use App\Entity\Invoice;
  16. use App\Entity\OrderPayment;
  17. use App\Entity\User;
  18. use App\Entity\WishList;
  19. use App\Form\AddItemType;
  20. use App\Form\AddProductType;
  21. use App\Form\ClearCartType;
  22. use App\Form\CustomerContactType;
  23. use App\Form\RemoveItemType;
  25. use App\Form\SetDiscountType;
  26. use App\Form\SetItemQuantityType;
  27. use App\Form\SetPaymentType;
  28. use App\Form\SetShipmentType;
  29. use App\Repository\WishListRepository;
  30. use App\Service\CurrencyService;
  31. use App\Service\EmailService;
  32. use App\Service\paypalExpress;
  33. use App\Service\SmsService;
  34. //use Stripe\Checkout\Session;
  35. use App\Service\StripeService;
  36. use Dompdf\Dompdf;
  37. use Dompdf\Options;
  38. use Stripe\Stripe;
  39. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  40. use Symfony\Component\HttpFoundation\JsonResponse;
  41. use Symfony\Component\HttpFoundation\Request;
  42. use Symfony\Component\HttpFoundation\Response;
  43. use Symfony\Component\HttpFoundation\Session\Session;
  44. use Symfony\Component\HttpFoundation\Session\SessionInterface;
  45. use Symfony\Component\Routing\Annotation\Route;
  46. use Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorageInterface;
  47. use Symfony\Component\Security\Http\Authentication\AuthenticationUtils;
  49. // Include Dompdf required namespaces
  50. use Symfony\Component\Translation\TranslatorInterface;
  52. class CartController extends AbstractController
  53. {
  54.     /**
  55.      * @var TranslatorInterface
  56.      */
  57.     private $translator;
  59.     /**
  60.      * @var OrderFactory
  61.      */
  62.     private $orderFactory;
  64.     /** @var TokenStorageInterface */
  65.     private $tokenStorage;
  67.     public function __construct(TranslatorInterface $translator, OrderFactory $orderFactory, TokenStorageInterface $tokenStorage)
  68.     {
  69.         $this->translator = $translator;
  70.         $this->orderFactory = $orderFactory;
  71.         $this->tokenStorage = $tokenStorage;
  73.     }
  75.     /**
  76.      * @Route({
  77.      *     "fr": "/cart",
  78.      *     "en": "/cart/en"
  79.      * }, name="cart")
  80.      *  @param Request $request
  81.      *  @param CurrencyService $currency
  82.      *
  83.      */
  84.     public function index(Request $request,
  85.         CurrencyService $currency,
  86.         OrderFactory $order,
  87.         SmsService $sms,
  88.         SessionInterface $session,
  89.         WishListRepository $wishrepo,
  90.         AuthenticationUtils $authenticationUtils) {
  91.         $clearForm = $this->createForm(ClearCartType::class, $order->getCurrent());
  92.         $setPaymentForm = $this->createForm(SetPaymentType::class, $order->getCurrent());
  93.         $setShipmentForm = $this->createForm(SetShipmentType::class, $order->getCurrent());
  94.         $setDiscountForm = $this->createForm(SetDiscountType::class, $order->getCurrent());
  96.         $ville = [1 => "Douala", 2 => "Yaoundé", 3 => "Bafoussam", 4 => "Mbouda", 10 => ""];
  97.         // get the login error if there is one
  98.         $error = $authenticationUtils->getLastAuthenticationError();
  99.         // last username entered by the user
  100.         $lastUsername = $authenticationUtils->getLastUsername();
  102.         //$cookie = new Cookie('foo', 'bar', strtotime('now + 10 minutes'));
  104.         /*
  105.         $cookie = new Cookie( 'my_cookie',"56",time() + ( 2 * 365));
  107.         $res = new Response();
  108.         $res->headers->setCookie( $cookie );
  109.         $res->send();
  111.         $id = $request->cookies->get('my_cookie');
  112.         dump($id); exit;
  113.          */
  116.         $repository = $this->getDoctrine()->getRepository(Product::class);
  118.         /**
  119.          * @var User $user
  120.          */
  121.         $user = $this->getUser();
  123.         //   $wishrepo = $this->getDoctrine()->getRepository(WishListRepository::class);
  124.     
  125.         $user_wish = (!is_null($user))?$wishrepo->countUserWishList($user->getId())["cnt"]:""; 
  126.         $user_bookingValue = (!is_null($user))?((float)(base64_decode($user->getBookingValue()))):"0,00"; 
  127.       
  128.         //   $locale = $request->getLocale();
  130.         //   dump($locale); exit;
  131.         /*
  132.         $repository = $this->getDoctrine()->getRepository(Product::class);
  133.         $mitarbeiter = array("0131a2a3-eeb7-11ea-ba4b-1063c84cee2c"=>4,"06d6a110-33fe-11eb-aa2e-ca02b436025f"=>2,"137eb0e6-eeb6-11ea-ba4b-1063c84cee2c"=>5);
  134.         foreach($mitarbeiter AS $vorname => $nachname){
  136.         $this->orderFactory->addItem($repository->findOneBy(['id'=>$vorname]),$nachname);
  137.         }
  138.          */
  140.         return $this->render('cart/index.html.twig', [
  141.             'last_username' => $lastUsername,
  142.             'error' => $error,
  143.             'userWish' => $user_wish,
  144.             'bookingValue'=>$user_bookingValue,
  145.             'order' => $order,
  146.             'ville' => array_key_exists($order->getCurrent()->getCart_cat(), $ville) ? $ville[$order->getCurrent()->getCart_cat()] : "Aucune",
  147.             'locale' => $request->getLocale(),
  148.             'clearForm' => $clearForm->createView(),
  149.             'setPaymentForm' => $setPaymentForm->createView(),
  150.             'currencie_convert' => $currency->getRate($session->get('converter')),
  151.             "converter" => (!empty($session->get('converter'))) ? $session->get('converter') : "EUR",
  152.             'setShipmentForm' => $setShipmentForm->createView(),
  153.             'setDiscountForm' => $setDiscountForm->createView(),
  154.             'itemsInCart' => $order->getCurrent()->getItemsTotal(),
  155.             'order_cat' => $order->getCurrent()->getCart_cat(),
  156.             'cart_cat_order' => $order->getCurrent()->getCart_cat(),
  157.             
  158.         ]);
  159.     }
  162.     /**
  163.      * @Route("/cart/payment/{orderId}/{contactId}", name="premium_payment")
  164.      * @param Request $request
  165.      * @return Response
  166.      */
  167.     public function paymentAction(Request $request,
  168.         StripeService $stripe,
  169.         OrderFactory $order,
  170.         $contactId,
  171.         AuthenticationUtils $authenticationUtils,
  172.         $orderId,
  173.         SessionInterface $session,
  174.         EmailService $emailService,
  175.         ProductRepository $productRepository,
  176.         CurrencyService $currency) {
  178.         /** @var User $user */
  179.         $user = $this->getUser();
  180.         $userData = ["name" => $user->getName(), "forname" => $user->getForeName()];
  182.         $first_name = $request->request->get('first_name');
  184.         $email = $request->request->get('email');
  185.         $stripeToken = $request->request->get('stripeToken');
  187.         // get the login error if there is one
  188.         $error = $authenticationUtils->getLastAuthenticationError();
  189.         // last username entered by the user
  190.         $lastUsername = $authenticationUtils->getLastUsername();
  192.         if ($request->isMethod('POST')) {
  194.             if ($first_name) {
  196.                 try {
  198.                     $entity = $this->getDoctrine()->getManager();
  200.                     // Configure Dompdf according to your needs
  201.                     $pdfOptions = new Options();
  202.                     $pdfOptions->set('defaultFont', 'Arial');
  204.                     // Instantiate Dompdf with our options
  205.                     $dompdf = new Dompdf($pdfOptions);
  207.                     // Retrieve the HTML generated in our twig file
  208.                     $html = $this->renderView('pdf/rechnungsmuster.html.twig', [
  209.                         'error' => $error,
  210.                         'last_username' => $lastUsername,
  211.                         'order' => $order,
  212.                         'userData' => $userData,
  213.                         'locale' => $request->getLocale(),
  214.                         'currencie_convert' => $currency->getRate($session->get('converter')),
  215.                         "converter" => (!empty($session->get('converter'))) ? $session->get('converter') : "EUR",
  216.                         'itemsInCart' => $order->getCurrent()->getItemsTotal(),
  217.                     ]);
  219.                     // Load HTML to Dompdf
  220.                     $dompdf->loadHtml($html);
  222.                     // (Optional) Setup the paper size and orientation 'portrait' or 'portrait'
  223.                     $dompdf->setPaper('A4', 'portrait');
  225.                     // Render the HTML as PDF
  226.                     $dompdf->render();
  228.                     // Store PDF Binary Data
  229.                     $output = $dompdf->output();
  231.                     $publicDirectory = $this->getParameter('kernel.project_dir') . '/public/invoices/';
  232.                     // e.g /var/www/project/public/mypdf.pdf
  233.                     $pdfFilepath = $publicDirectory . 'invoice_' . $order->getCurrent()->getId() . '.pdf';
  235.                     // Write file to the desired path
  236.                     file_put_contents($pdfFilepath, $output);
  238.                     $invoice_pdf = new invoice();
  239.                     $invoice_pdf->setInvoiceUrl('invoice_' . $order->getCurrent()->getId() . '.pdf');
  240.                     $invoice_pdf->setInvoiceId($contactId);
  241.                     $invoice_pdf->setPaymentInfo("Visa Card");
  242.                     $invoice_pdf->setUser($user);
  243.                     $invoice_pdf->setInvoiceNumber($order->getCurrent()->getId());
  244.                     $entity->persist($invoice_pdf);
  245.                     $entity->flush();
  247.                     $orderPay = new OrderPayment();
  248.                     //  $date = (new \DateTime('now'))->format("Y-m-d H:i:s");jij
  249.                     $orderPay->setContactId($contactId);
  250.                     $orderPay->setTransactionId($stripeToken);
  251.                     $orderPay->setInvoiceId($invoice_pdf->getInvoiceId());
  252.                     $orderPay->setUser($user);
  253.                     $orderPay->setPaymentAmount($order->getCurrent()->getPriceTotal() + 2.99*$currency->getRate($session->get('converter')));
  254.                     $orderPay->setCurrencyCode((!empty($session->get('converter'))) ? $session->get('converter') : "EUR");
  255.                     $orderPay->setPaymentStatus(0);
  256.                     $orderPay->setOrderId($order->getCurrent()->getId());
  258.                     $entity->persist($orderPay);
  260.                     $entity->flush();
  262.                     $emailService->sendMail($user->getEmail(), Emails::PAYMENT_SUCCESS, ["name" => $user->getForeName()]);
  264.                     $stripe->createCharge($this->getUser(), $stripeToken, $order->getCurrent()->getPriceTotal() * 100);
  266.                     $session->clear();
  268.                     return $this->redirectToRoute('home1');
  270.                 } catch (\Stripe\Error\Base $e) {
  272.                     $this->addFlash('warning', sprintf('Unable to take payment, %s', $e instanceof \Stripe\Error\Card ? lcfirst($e->getMessage()) : 'please try again.'));
  274.                     return $this->redirectToRoute('premium_payment');
  276.                 }
  278.             }
  279.         }
  281.         return $this->render('cart/paymentStripe.html.twig', [
  283.             'amount' => $order->getCurrent()->getPriceTotal(),
  284.             'contactId' => $contactId,
  285.             'orderId' => $orderId,
  286.             'stripe_public_key' => $this->getParameter('stripe_public_key'),
  287.             'order_cat' => $order->getCurrent()->getCart_cat(),
  288.         ]);
  289.     }
  293.     /**
  294.      *  @Route("/cart/Payment-Customer", name="cart-payment-customer")
  295.      *  @param Request $request
  296.      */
  297.     public function PaymentCustomer(Request $request,
  298.         SessionInterface $session,
  299.         OrderFactory $order,
  300.         EmailService $emailService,
  301.         ProductRepository $productRepository,
  302.         \Swift_Mailer $mailer,
  303.         CurrencyService $currency
  304.     ) {
  306.         /**
  307.          * @var User $user
  308.          */
  309.         $user = $this->getUser();
  310.         $userData = ["name" => $user->getName(), "forname" => $user->getForeName()];
  311.         //  $orderPay->setCreatedAt($date);
  313.         if ($request->isXmlHttpRequest()) {
  315.             $arr_cus =
  316.                 ["friend_name" => $request->request->get('friend_name'),
  317.                 "friend_tel" => !empty($request->request->get('friend_tel')) ? $request->request->get('friend_tel') : "",
  318.                 "id_friend" => $request->request->get('friend_id'),
  319.                 "friend_note" => $request->request->get('friend_note'),
  320.                 "summe" => $request->request->get('summe'),
  321.                 "order_id" => $order->getCurrent()->getId(),
  322.                 "payment_type" => $request->request->get('payment_type'),
  323.                 "delivery_type" => $request->request->get('delivery_type') ,
  324.                 "currencie" => (!empty($session->get('converter'))) ? $session->get('converter') : "EUR",
  325.                 'order_cat' => !is_null($order->getCurrent()->getCart_cat())?$order->getCurrent()->getCart_cat():1,
  326.             ];
  328.             $payment = $this->getDoctrine()->getRepository('App\Component\Payment\Model:Payment')->findOneBy(['id' => $request->request->get('payment_type')]);
  329.                
  330.             if($payment){
  332.                 $this->orderFactory->setPayment($payment);           
  333.             } 
  334.             
  336.             if ($payment->getName() == "Bank Transfert") {
  338.                 if ($request->request->get('friend_id') == 0 || $request->request->get('friend_id') == 10000000 ) {
  340.                     $customerContact = new CustomerContact();
  341.                     $customerContact->addUser($user);
  342.                     $customerContact->SetName($request->request->get('friend_name'));
  343.                     $customerContact->setMsg($request->request->get('friend_note'));
  344.                     $customerContact->setStatus(10);
  345.                     $customerContact->setMobile(!empty($request->request->get('friend_tel')) ? $request->request->get('friend_tel') : "");
  346.                     $customerContact->setAddress(!empty($request->request->get('delivery_type')) ? $request->request->get('delivery_type') : "");
  347.                     // Save
  348.                     $entity = $this->getDoctrine()->getManager();
  349.                     $entity->persist($customerContact);
  350.                     $entity->flush();
  351.                     $lastContactId = $customerContact->getId();
  353.                 } else {
  355.                     $customerContact = $this->getDoctrine()->getRepository(CustomerContact::class)->find($request->request->get('friend_id'));
  356.                     $customerContact->SetName($request->request->get('friend_name'));
  357.                     $customerContact->setMsg($request->request->get('friend_note'));
  358.                     $customerContact->setMobile($request->request->get('friend_tel'));
  359.                     $customerContact->setAddress($request->request->get('delivery_type'));
  360.                     // Save
  361.                     $em = $this->getDoctrine()->getManager();
  362.                     $em->flush();
  363.                     $lastContactId = $request->request->get('friend_id');
  365.                 }
  367.                     array_push($arr_cus, $lastContactId);
  369.                     $entity = $this->getDoctrine()->getManager();
  371.                 $invoice_pdf = new invoice();
  372.                 $invoice_pdf->setInvoiceUrl('invoice_' . $order->getCurrent()->getId() . '.pdf');
  373.                 $invoice_pdf->setInvoiceId($lastContactId);
  374.                 $invoice_pdf->setPaymentInfo($request->request->get('friend_note'));
  375.                 $invoice_pdf->setUser($user);
  376.                 $invoice_pdf->setInvoiceNumber($order->getCurrent()->getId());
  377.                 $entity->persist($invoice_pdf);
  378.                 $entity->flush();
  380.                 $orderPay = new OrderPayment();
  381.                 //  $date = (new \DateTime('now'))->format("Y-m-d H:i:s");jij
  382.                 $orderPay->setContactId($lastContactId);
  383.                 $orderPay->setTransactionId("BT-" . $orderPay->getId());
  384.                 $orderPay->setOrderId($order->getCurrent()->getId());
  385.                 $orderPay->setInvoiceId($invoice_pdf->getInvoiceId());
  386.                 $orderPay->setUser($user);
  387.                 // $orderPay->setPaymentAmount((int) $request->request->get('summe'));
  388.                 $amountTotal = $order->getCurrent()->getPriceTotal() + (2.99*$currency->getRate($session->get('converter')));
  389.                 $orderPay->setPaymentAmount($amountTotal);
  390.                 $orderPay->setCurrencyCode((!empty($session->get('converter'))) ? $session->get('converter') : "EUR");
  391.                 $orderPay->setPaymentStatus(0);
  393.                 $entity->persist($orderPay);
  394.                 $entity->flush();
  396.                 if($user->getCodePromoStatus() == 2){
  397.                     $em = $this->getDoctrine()->getManager();
  399.                     $discount = $this->getDoctrine()->getRepository('App\Component\Discount\Model:Discount')->findOneBy(['userId'=>$user->getId()]);
  400.           
  401.                     if(!is_null($discount)) {
  402.              
  403.                         $discount->setUserId(0);                        
  404.                         $user->setCodePromoName("");
  405.                         $user->setCodePromoStatus(0);
  406.                         $user->setCodePromoValue("");
  407.                         $em->persist($discount);
  408.                         $em->persist($user);
  409.                         $em->flush();
  410.             
  411.                       }else{
  412.             
  413.                       }
  414.                    
  415.                 }
  416.           
  418.                 $date = (new \DateTime('now'))->format("d-m-Y");
  420.                 // Configure Dompdf according to your needs
  421.                 $pdfOptions = new Options();
  422.                 $pdfOptions->set('defaultFont', 'Arial');
  424.                 // Instantiate Dompdf with our options
  425.                 $dompdf = new Dompdf($pdfOptions);
  427.                 $path = 'img/logo/logo.png';
  428.                 $type = pathinfo($path, PATHINFO_EXTENSION);
  429.                 $data = file_get_contents($path);
  430.                 $base64 = 'data:image/' . $type . ';base64,' . base64_encode($data);
  432.                     // Retrieve the HTML generated in our twig file
  433.                 $html = $this->renderView('pdf/rechnungsmuster.html.twig', [
  434.                     'logo'=>$base64,
  435.                     'order' => $order,
  436.                     'user_id'=>$user->getId(),
  437.                     'telephone_user' => $user->getMobile(),
  438.                     'invoiceID'=>$invoice_pdf->getInvoiceId(),
  439.                     'methode_payment'=>"Bank Transfert",
  440.                     'destinataire'=>$request->request->get('friend_name'),
  441.                     'telephone_destinataire'=>$request->request->get('friend_tel'),
  442.                     'message_destinataire'=> !empty($request->request->get('friend_note')) ? $request->request->get('friend_note') : "",
  443.                     'mode_livraison'=>$request->request->get('delivery_type'),
  444.                     'date_invoice'=>$date,
  445.                     'userData' => $userData,
  446.                     'locale' => $request->getLocale(),
  447.                     'currencie_convert' => $currency->getRate($session->get('converter')),
  448.                     "converter" => (!empty($session->get('converter'))) ? $session->get('converter') : "EUR",
  449.                     'itemsInCart' => $order->getCurrent()->getItemsTotal(),
  450.                 ]);
  452.                 // Load HTML to Dompdf
  453.                 $dompdf->loadHtml($html);
  454.                 // (Optional) Setup the paper size and orientation 'portrait' or 'portrait'
  455.                 $dompdf->setPaper('A4', 'portrait');
  456.                 // Render the HTML as PDF
  457.                 $dompdf->render();
  458.                 // Store PDF Binary Data
  459.                 $output = $dompdf->output();
  461.                 $publicDirectory = $this->getParameter('kernel.project_dir') . '/public/invoices/';
  462.                 // e.g /var/www/project/public/mypdf.pdf
  463.                 $pdfFilepath = $publicDirectory . 'invoice_' . $order->getCurrent()->getId() . '.pdf';
  465.                 // Write file to the desired path
  466.                 file_put_contents($pdfFilepath, $output);
  469.                 //$emailService->sendMail($user->getEmail(), Emails::PAYMENT_SUCCESS, ["name" => $user->getForeName()]);
  470.                 $villeName = [1 => "Douala", 2 => "Yaoundé", 3 => "Bafoussam", 4 => "Mbouda", 10 => ""];
  471.                 $numberVille = !is_null($order->getCurrent()->getCart_cat())?$order->getCurrent()->getCart_cat():1;
  472.                 $message = (new \Swift_Message('Attente de Confirmation du paiement pour la commande n°'.$invoice_pdf->getInvoiceId().' sur YeYeTo.Com dans la ville de '. $villeName[$numberVille].' '))
  473.                 ->setFrom('info@yeyeto.com')
  474.                 ->setTo($user->getEmail())
  475.                 ->setBody(
  476.                     $this->renderView(
  477.                         'email/bankTransfert.html.twig', [         
  478.                           "code" => $orderPay->getId(),
  479.                           "custoData" => $customerContact->getName(),
  480.                           "amount" => $amountTotal,            
  481.                           'logo'=>$base64,
  482.                           'order' => $order,
  483.                           'user_id'=>$user->getId(),
  484.                           'telephone_user' => $user->getMobile(),
  485.                           'invoiceID'=>$invoice_pdf->getInvoiceId(),
  486.                           'methode_payment'=> "Bank Transfert",
  487.                           'destinataire'=>$request->request->get('friend_name'),
  488.                           'telephone_destinataire'=>$request->request->get('friend_tel'),
  489.                           'message_destinataire'=> $request->request->get('friend_tel'),
  490.                           'mode_livraison'=>$request->request->get('delivery_type'),
  491.                           'date_invoice'=>$date,
  492.                           'userData' => $userData,
  493.                           'locale' => $request->getLocale(),
  494.                           'currencie_convert' => $currency->getRate($session->get('converter')),
  495.                           "converter" => (!empty($session->get('converter'))) ? $session->get('converter') : "EUR",
  496.                           'itemsInCart' => $order->getCurrent()->getItemsTotal(),
  497.                         ]
  498.                       ),
  499.                     'text/html'
  500.                 )->attach(\Swift_Attachment::fromPath($pdfFilepath,"application/pdf"));
  501.         
  502.                 $mailer->send($message);
  504.                 $json=[];
  505.                 $json[] = $arr_cus;
  507.                 $session->clear();
  508.                 return new JsonResponse($json);
  510.             }
  511.             if ($payment->getName() == "visa card" || $payment->getName() == "Paypal" || $payment->getName() == "Pay Yeyeto" ) {
  512.                 $session->set('customer_data', $arr_cus);
  513.                 // $session->get('cat_c1');
  514.                 $json=[];
  515.                 $json[] = $arr_cus;
  517.                 return new JsonResponse($json);
  519.             } else {
  521.                 return new JsonResponse($json);
  522.             }
  524.         } else {
  526.             $json['error'] = "Error";
  528.         }
  530.         return new JsonResponse($json);
  532.     }
  535.     /**
  536.      *  @Route("/cart/bank-transfer/{orderId}/{contactId}", name="cart-bank-transfer")
  537.      *  @param Request $request
  538.      */
  539.     public function BankCustomer(OrderFactory $order,
  540.         $orderId,
  541.         $contactId,
  542.         AuthenticationUtils $authenticationUtils,
  543.         paypalExpress $paymentService,
  544.         SessionInterface $session,
  545.         Request $request,
  546.         WishListRepository $wishrepo) {
  547.         $clearForm = $this->createForm(ClearCartType::class, $order->getCurrent());
  548.         $setPaymentForm = $this->createForm(SetPaymentType::class, $order->getCurrent());
  549.         $setShipmentForm = $this->createForm(SetShipmentType::class, $order->getCurrent());
  550.         $setDiscountForm = $this->createForm(SetDiscountType::class, $order->getCurrent());
  552.         $custoCon = $this->getDoctrine()->getRepository(CustomerContact::class)->findOneBy(['id' => $contactId]);
  553.         $custoOrd = $this->getDoctrine()->getRepository(OrderPayment::class)->findOneBy(['order_id' => $orderId]);
  554.         //  dd($custoOrd);exit;
  556.         /**
  557.          * @var User $user
  558.          */
  559.         $user = $this->getUser();
  561.         $userData = ["name" => $user->getName(),
  562.             "forname" => $user->getForeName(),
  563.         ];
  565.         // get the login error if there is one
  566.         $error = $authenticationUtils->getLastAuthenticationError();
  567.         // last username entered by the user
  568.         $lastUsername = $authenticationUtils->getLastUsername();
  569.    
  570.         $user_wish = (!is_null($user))?$wishrepo->countUserWishList($user->getId())["cnt"]:""; 
  571.         $user_bookingValue = (!is_null($user))?((float)(base64_decode($user->getBookingValue()))):"0,00"; 
  573.         $null_1 = "000000";
  575.         $em = $this->getDoctrine()->getManager();
  577.         $sql_query = ' UPDATE cart_order_item SET session_id = "' . $null_1 . '" WHERE order_id = "' . $orderId . '" ; ';
  579.         $statement1 = $em->getConnection()->prepare($sql_query);
  581.         $statement1->execute();
  583.         return $this->render('cart/banktransfer.html.twig', [
  584.             'error' => $error,
  585.             'last_username' => $lastUsername,
  586.             'userWish' => $user_wish,
  587.             'bookingValue'=>$user_bookingValue,
  588.             'userData' => $userData,
  589.             "code" => $custoOrd->getId(),
  590.             "custoData" => $custoCon->getName(),
  591.             "amount" => $custoOrd->getPaymentAmount(),
  592.             'order' => $order,
  593.             "converter" => (!empty($session->get('converter'))) ? $session->get('converter') : "EUR",
  594.             'id_order' => $order->getCurrent()->getId(),
  595.             'clearForm' => $clearForm->createView(),
  596.             'setPaymentForm' => $setPaymentForm->createView(),
  597.             'setShipmentForm' => $setShipmentForm->createView(),
  598.             'setDiscountForm' => $setDiscountForm->createView(),
  599.             'itemsInCart' => $order->getCurrent()->getItemsTotal(),
  600.             'order_cat' => $order->getCurrent()->getCart_cat(),
  601.         ]);
  602.     }
  604.     /**
  605.      *  @Route("/cart/otherfriend/{id}/{status}", name="cart-otherfriend")
  606.      *  @param Request $request
  607.      */
  608.     public function OtherCustomer($id, $status, ProductRepository $productRepository, OrderFactory $order)
  609.     {
  611.         $custoCon = $this->getDoctrine()->getRepository(CustomerContact::class)->findOneBy(['id' => $id,'status'=>$status]);
  613.         return $this->render('cart/otherfriend.html.twig', [
  614.             'order' => $order,
  615.             'id' => $custoCon->getId(), 
  616.             'name' => $custoCon->getName(),
  617.             'mobile' => $custoCon->getMobile(),
  618.         ]);
  619.     }
  621.     /**
  622.      *  @Route("/cart/action/{cat_sp}", name="cart-action")
  623.      *  @param Request $request
  624.      *  @param CurrencyService $currency
  625.      */
  626.     public function buyAction(CurrencyService $currency, OrderFactory $order, SessionInterface $session, $cat_sp, ProductRepository $productRepository)
  627.     {
  629.         $repository = $this->getDoctrine()->getRepository(Product::class);
  631.         $action = $productRepository->findAllProductByAction($cat_sp);
  633.         for ($i = 0; $i < count($action); $i++) {
  635.           $this->orderFactory->addItemRecharge($repository->findOneBy(['id' => $action[$i]["prod_id"]]), $action[$i]["qty"]);
  636.         }
  638. //69494 51 89  Nazer
  639.         return $this->redirectToRoute('home1');
  640.     }
  643.     /**
  644.      *@Route({
  645.      *     "fr": "/cart/checkout",
  646.      *     "en": "/cart/checkout/en"
  647.      *     }, name="cart-checkout")
  648.      *@param paypalExpress $paymentService
  649.      *@param Request $request
  650.      */
  651.     public function checkoutCart(OrderFactory $order,
  652.         paypalExpress $paymentService,
  653.         SessionInterface $session,
  654.         Request $request,
  655.         CurrencyService $currency,
  656.         AuthenticationUtils $authenticationUtils,
  657.         WishListRepository $wishrepo) {
  658.         $clearForm = $this->createForm(ClearCartType::class, $order->getCurrent());
  659.         $setPaymentForm = $this->createForm(SetPaymentType::class, $order->getCurrent());
  660.         $setShipmentForm = $this->createForm(SetShipmentType::class, $order->getCurrent());
  661.         $setDiscountForm = $this->createForm(SetDiscountType::class, $order->getCurrent());
  663.         $ville = [1 => "Douala", 2 => "Yaoundé", 3 => "Bafoussam", 4 => "Mbouda", 10 => ""];
  665.         /**
  666.          * @var User $user
  667.          */
  668.         $user = $this->getUser();
  670.         if (!is_null($user)) {
  672.             $user_wish = $wishrepo->countUserWishList($user->getId())["cnt"];
  674.         } else {
  676.             return $this->redirectToRoute('cart');
  677.         }
  679.         $user_bookingValue = (!is_null($user))?((float)(base64_decode($user->getBookingValue()))):"0,00"; 
  680.         
  681.          
  682.          //  dd( $currency->getRate($session->get('converter')));  exit;
  684.         // get the login error if there is one
  685.         $error = $authenticationUtils->getLastAuthenticationError();
  686.         // last username entered by the user
  687.         $lastUsername = $authenticationUtils->getLastUsername();
  689.         //    dd($this->getDoctrine()->getRepository(Payment::class)->findAll()); exit;
  691.         foreach ($this->getDoctrine()->getRepository(Payment::class)->findAll() as $pay_data) {
  693.             $payData[] = ['id' => $pay_data->getId(), 'name' => $pay_data->getName(), 'price' => $pay_data->getPrice()];
  695.         }
  697.         $customerContact = new CustomerContact();
  699.         $formCust = $this->createForm(CustomerContactType::class, $customerContact);
  701.         if ($shipment = $this->getDoctrine()->getRepository('App\Component\Shipment\Model:Shipment')->findOneBy(['id' => $order->getCurrent()->getShipment()])) {
  703.             $shipment_info = ["id" => $shipment->getId(), "name" => $shipment->getName(), "price" => $shipment->getPrice(), "image" => $shipment->getImage()];
  705.         } else {
  707.             $shipment_info = ["id" => "0", "name" => "Retrait au magasin", "price" => 0, "image" => "<span class='fa fa-home fa-3x'></span>"];
  709.         }
  711.         $formCust->handleRequest($request);
  713.         if ($formCust->isSubmitted() && $formCust->isValid()) {
  715.             $customerContact->addUser($user);
  716.             // Save
  717.             $em = $this->getDoctrine()->getManager();
  718.             $em->persist($customerContact);
  719.             $em->flush();
  721.             return $this->redirectToRoute('cart-checkout');
  722.         }
  724.         $custoConts = $this->getDoctrine()->getRepository(CustomerContact::class)->findBy(['user' => $user->getId(),'status'=>10]);
  725.         
  727.         //  $payment = $this->getDoctrine()->getRepository(Payment::class)->findAll();
  729.         //  $shipment = $this->getDoctrine()->getRepository(Shipment::class)->findAll();
  731.         $order->getCurrent()->setUserId($user->getId());
  733.         $em = $this->getDoctrine()->getManager();
  735.         $em->flush();
  737.         if (count($custoConts) > 0) {
  739.             foreach ($custoConts as $custoCon) {
  741.                 $arr_cust[] = ['id' => $custoCon->getId(), 'name' => $custoCon->getName(), 'mobile' => $custoCon->getMobile()];
  742.             }
  744.         } else {
  746.             $arr_cust[] = ['id' => "", 'name' => "", 'mobile' => ""];
  748.         }
  750.         return $this->render('cart/checkout.html.twig', [
  751.             'error' => $error,
  752.             'ville' => array_key_exists($order->getCurrent()->getCart_cat(), $ville) ? $ville[$order->getCurrent()->getCart_cat()] : "Aucune",
  753.             'last_username' => $lastUsername,
  754.             'payData' => $payData,
  755.             "shipment_info" => $shipment_info,
  756.             'arr_custs' => $arr_cust,
  757.             "arr_custs_length" => count($custoConts),
  758.             'paypal_client_id' => $paymentService::PayPal_CLIENT_ID,
  759.             'paypal_secret' => $paymentService::PayPal_SECRET,
  760.             'paypal_base_url' => $paymentService::PayPal_BASE_URL,
  761.             'base_url' => $paymentService::BASE_URL,
  762.             'userWish' => $user_wish,
  763.             'bookingValue'=>$user_bookingValue,
  764.             'order' => $order,
  765.             "converter" => (!empty($session->get('converter'))) ? $session->get('converter') : "EUR",
  766.             'currencie_convert' => $currency->getRate($session->get('converter')),
  767.             'id_order' => $order->getCurrent()->getId(),
  768.             'cart_cat_order' => $order->getCurrent()->getCart_cat(),
  769.             'clearForm' => $clearForm->createView(),
  770.             'setPaymentForm' => $setPaymentForm->createView(),
  771.             'setShipmentForm' => $setShipmentForm->createView(),
  772.             'setDiscountForm' => $setDiscountForm->createView(),
  773.             'formCust' => $formCust->createView(),
  774.             'itemsInCart' => $order->getCurrent()->getItemsTotal(),
  775.             'order_cat' => $order->getCurrent()->getCart_cat(),
  776.         ]);
  777.     }
  779.     public function addItemForm(Product $product): Response
  780.     {
  781.         $form = $this->createForm(AddItemType::class, $product);
  783.         return $this->render('cart/_addItem_form.html.twig', [
  784.             'form' => $form->createView(),
  785.         ]);
  786.     }
  788.     public function addItemForm1(Product $product): Response
  789.     {
  790.         $form = $this->createForm(AddProductType::class, $product);
  792.         return $this->render('cart/_addproduct.html.twig', [
  793.             'form' => $form->createView(),
  794.         ]);
  795.     }
  798.     /**
  799.      * @Route({
  800.      *     "fr": "/cart/addWishlist/{id}",
  801.      *     "en": "/cart/addWishlist/{id}/en"
  802.      *     }, name="cart.addWishlist", methods={"POST"})
  803.      *  @param Request $request
  804.      *
  805.      */
  806.     public function AddWishlist(Request $request, SessionInterface $session, ProductRepository $prodrepo, WishListRepository $wishrepo): Response
  807.     {
  808.         $productId = $request->request->get('product_wish');
  810.         $product = $prodrepo->find($productId);
  812.         if (!is_null($this->tokenStorage->getToken()) && $this->tokenStorage->getToken() == 'anon.') {
  814.             $session->getFlashBag()->add('error', 'You have to be logged to add to the wishlist');
  816.             return new RedirectResponse('home1');
  817.         }
  819.         if ($this->tokenStorage->getToken()) {
  821.             $user = $this->tokenStorage->getToken()->getUser();
  823.             //  $tokenUser->getUser()
  824.             // $delay = new \DateTime ();
  825.             // $delay
  826.             // ->setTimestamp (strtotime ('2 minutes ago'));
  827.             // We are checking the Admin class in order to be certain we can
  828.             // call "getLastActivity".
  829.             // && $user->getLastActivity() < $delay) {
  831.             if ($user == "anon.") {
  832.                 $this->addFlash('error', 'Vous devez vous connecter à votre compte ou en créer un!');
  833.                 // redirect
  834.                 return $this->redirectToRoute('app_login1');
  835.             }
  837.             $wishlist = $wishrepo->findOneBy(array('user' => $user->getId()));
  839.             if (is_null($wishlist)) {
  841.                 $wishlist = new WishList();
  843.                 $wishlist->setUser($user);
  844.             }
  846.             $wishlist->addProduct($product);
  848.             $em = $this->getDoctrine()->getManager();
  850.             $em->persist($wishlist);
  852.             $em->flush();
  854.             $session->getFlashBag()->add('success', 'Product added to the wishlist');
  856.             return $this->redirect($request->server->get('HTTP_REFERER'));
  858.         }
  860.         return $this->redirectToRoute('home1');
  861.     }
  864.     public function removeItemForm(OrderItem $item): Response
  865.     {
  866.         $form = $this->createForm(RemoveItemType::class, $item);
  868.         return $this->render('cart/_removeItem_form.html.twig', [
  869.             'form' => $form->createView(),
  870.         ]);
  871.     }
  874.     public function setItemQuantityForm(OrderItem $item): Response
  875.     {
  876.         $form = $this->createForm(SetItemQuantityType::class, $item);
  878.         return $this->render('cart/_setItemQuantity_form.html.twig', [
  879.             'form' => $form->createView(),
  880.         ]);
  881.     }
  884.     public function setCartItemQuantityForm(OrderItem $item): Response
  885.     {
  886.         $form = $this->createForm(SetItemQuantityType::class, $item);
  888.         return $this->render('cart/_setCartItemQuantity_form.html.twig', [
  889.             'form' => $form->createView(),
  890.         ]);
  891.     }
  894.     /**
  895.      * @Route({
  896.      *     "fr": "/cart/addProduct/{id}",
  897.      *     "en": "/cart/addProduct/{id}/en"
  898.      *     }, name="cart.addProduct", methods={"POST"})
  899.      *  @param Request $request
  900.      *
  901.      */
  902.     public function addProduct(Request $request, Product $product): Response
  903.     {
  905.         /*
  906.         $form = $this->createForm(AddProductType::class, $product);
  907.         $form->handleRequest($request);
  909.         if ($form->isSubmitted() && $form->isValid()) {
  911.             $this->orderFactory->addItem($product, $request->request->get('quantity'));
  912.             $this->addFlash('success', $this->translator->trans('app.cart.addProduct.message.success'));
  913.         }
  915.         return $this->redirectToRoute('home1');
  917.         */
  919.         $session = new Session();
  921.         $em = $this->getDoctrine()->getManager();
  923.         $form = $this->createForm(AddProductType::class, $product);
  924.         $form->handleRequest($request);
  926.         $id = $form->get("id")->getData();
  928.         $QUERY = 'SELECT * FROM cart_order_item where session_id = "' . $session->getId() . '" ORDER BY DATE(created_at) DESC  LIMIT 1 ;';
  930.         $statement = $em->getConnection()->prepare($QUERY);
  932.         $statement->execute();
  934.         $result = $statement->fetch();
  936.         if ($result == false) {
  938.             if ($form->isSubmitted() && $form->isValid()) {
  940.                 $this->orderFactory->addItem($product, $request->request->get('quantity'));
  942.                 $this->addFlash('success', $this->translator->trans('app.cart.addItem.message.success'));
  944.                 $QUERY1 = 'SELECT * FROM cart_order_item where session_id = "' . $session->getId() . '" AND product_id = "' . $id . '"  LIMIT 1 ;';
  946.                 $statement1 = $em->getConnection()->prepare($QUERY1);
  948.                 $statement1->execute();
  950.                 $result1 = $statement1->fetch();
  952.                 $sql_query = ' UPDATE cart_order SET cart_cat = ' . $product->getCart_cat() . ' WHERE id = "' . $result1["order_id"] . '" ; ';
  954.                 $statement2 = $em->getConnection()->prepare($sql_query);
  956.                 $statement2->execute();
  957.             }
  958.             
  959.             return $this->redirectToRoute('home1');
  961.         } else if (($result != false) && $result["cart_cat"] != $product->getCart_cat() && $result["cart_cat"] != 10) {
  963.             $ville = [1 => "Douala", 2 => "Yaoundé", 3 => "Bafoussam", 4 => "Mbouda", 10 => ""];
  965.             $message = "Impossible! Vous avez au depart choisit un magasin dans la ville de " . $ville[$result["cart_cat"]] . " et maintenant vous changez par celui de " . $ville[$product->getCart_cat()] . ". Vous ne pouvez que faire vos achats dans les magasins d'une même ville: ";
  967.             $this->addFlash('error', $message);
  969.             return $this->redirectToRoute('cart');
  971.         }if (($result != false && $result["cart_cat"] == $product->getCart_cat()) || ($result["cart_cat"] != $product->getCart_cat() && $result["cart_cat"] == 10)) {
  973.             if ($form->isSubmitted() && $form->isValid()) {
  975.                 $this->orderFactory->addItem($product, $request->request->get('quantity'));
  977.                 $this->addFlash('success', $this->translator->trans('app.cart.addItem.message.success'));
  979.                 $QUERY1 = 'SELECT * FROM cart_order_item where session_id = "' . $session->getId() . '" AND product_id = "' . $id . '" ORDER BY DATE(created_at) DESC LIMIT 1 ;';
  981.                 $statement1 = $em->getConnection()->prepare($QUERY1);
  983.                 $statement1->execute();
  985.                 $result1 = $statement1->fetch();
  987.                 $sql_query = ' UPDATE cart_order SET cart_cat = ' . $product->getCart_cat() . ' WHERE id = "' . $result1["order_id"] . '" ; ';
  989.                 $statement2 = $em->getConnection()->prepare($sql_query);
  991.                 $statement2->execute();
  993.             }
  995.             return $this->redirectToRoute('home1');
  997.         } else {
  999.             $ville = [1 => "Douala", 2 => "Yaoundé", 3 => "Bafoussam", 4 => "Mbouda", 10 => ""];
  1001.             $message = "Impossible! Vous avez au depart choisit un magasin dans la ville de " . $ville[$result["cart_cat"]] . " et maintenant vous changer par celui de " . $ville[$product->getCart_cat()] . ". Vous ne pouvez que faire vos achats dans les magasins d'une même ville: ";
  1003.             $this->addFlash('error', $message);
  1005.             return $this->redirectToRoute('cart');
  1006.         }
  1008.     }
  1012.     /**
  1013.      * @Route({
  1014.      *     "fr": "/cart/addItem/{id}",
  1015.      *     "en": "/cart/addItem/{id}/en"
  1016.      *     }, name="cart.addItem", methods={"POST"})
  1017.      *  @param Request $request
  1018.      *
  1019.      */
  1020.     public function addItem(Request $request, Product $product, $id): Response
  1021.     {
  1022.         $session = new Session();
  1024.         $em = $this->getDoctrine()->getManager();
  1026.         $form = $this->createForm(AddItemType::class, $product);
  1027.         $form->handleRequest($request);
  1029.         $QUERY = 'SELECT * FROM cart_order_item where session_id = "' . $session->getId() . '" ORDER BY DATE(created_at) DESC  LIMIT 1 ;';
  1031.         $statement = $em->getConnection()->prepare($QUERY);
  1033.         $statement->execute();
  1035.         $result = $statement->fetch();
  1037.         if ($result == false) {
  1039.             if ($form->isSubmitted() && $form->isValid()) {
  1041.                 $this->orderFactory->addItem($product,  $request->request->get('quantity'));
  1043.                 $this->addFlash('success', $this->translator->trans('app.cart.addItem.message.success'));
  1045.                 $QUERY1 = 'SELECT * FROM cart_order_item where session_id = "' . $session->getId() . '" AND product_id = "' . $id . '"  LIMIT 1 ;';
  1047.                 $statement1 = $em->getConnection()->prepare($QUERY1);
  1049.                 $statement1->execute();
  1051.                 $result1 = $statement1->fetch();
  1053.                 $sql_query = ' UPDATE cart_order SET cart_cat = ' . $product->getCart_cat() . ' WHERE id = "' . $result1["order_id"] . '" ; ';
  1055.                 $statement2 = $em->getConnection()->prepare($sql_query);
  1057.                 $statement2->execute();
  1058.             }
  1059.             return $this->redirectToRoute('home1');
  1061.         } else if (($result != false) && $result["cart_cat"] != $product->getCart_cat() && $result["cart_cat"] != 10) {
  1063.             $ville = [1 => "Douala", 2 => "Yaoundé", 3 => "Bafoussam", 4 => "Mbouda", 10 => ""];
  1065.             $message = "Impossible! Vous avez au depart choisit un magasin dans la ville de " . $ville[$result["cart_cat"]] . " et maintenant vous changer par celui de " . $ville[$product->getCart_cat()] . ". Vous ne pouvez que faire vos achats dans les magasins d'une même ville: ";
  1067.             $this->addFlash('error', $message);
  1069.             return $this->redirectToRoute('cart');
  1071.         }if (($result != false && $result["cart_cat"] == $product->getCart_cat()) || ($result["cart_cat"] != $product->getCart_cat() && $result["cart_cat"] == 10)) {
  1073.             if ($form->isSubmitted() && $form->isValid()) {
  1075.                 $this->orderFactory->addItem($product, $request->request->get('quantity'));
  1077.                 $this->addFlash('success', $this->translator->trans('app.cart.addItem.message.success'));
  1079.                 $QUERY1 = 'SELECT * FROM cart_order_item where session_id = "' . $session->getId() . '" AND product_id = "' . $id . '" ORDER BY DATE(created_at) DESC LIMIT 1 ;';
  1081.                 $statement1 = $em->getConnection()->prepare($QUERY1);
  1083.                 $statement1->execute();
  1085.                 $result1 = $statement1->fetch();
  1087.                 $sql_query = ' UPDATE cart_order SET cart_cat = ' . $product->getCart_cat() . ' WHERE id = "' . $result1["order_id"] . '" ; ';
  1089.                 $statement2 = $em->getConnection()->prepare($sql_query);
  1091.                 $statement2->execute();
  1093.             }
  1095.             return $this->redirectToRoute('home1');
  1097.         } else {
  1098.             $ville = [1 => "Douala", 2 => "Yaoundé", 3 => "Bafoussam", 4 => "Mbouda", 10 => ""];
  1100.             $message = "Impossible! Vous avez au depart choisit un magasin dans la ville de " . $ville[$result["cart_cat"]] . " et maintenant vous changer par celui de " . $ville[$product->getCart_cat()] . ". Vous ne pouvez que faire vos achats dans les magasins d'une même ville: ";
  1102.             $this->addFlash('error', $message);
  1104.             return $this->redirectToRoute('cart');
  1105.         }
  1107.     }
  1110.     /**
  1111.      * @Route({
  1112.      *     "fr": "/cart/addsearch/{id}",
  1113.      *     "en": "/cart/addsearch/{id}/en"
  1114.      *     }, name="cart_search", methods={"POST"})
  1115.      *  @param Request $request
  1116.      *
  1117.      */
  1118.     public function addSearchProduct(Request $request, Product $product): Response
  1119.     {
  1121.         if ($request->request->get('product_id')) {
  1123.             $session = new Session();
  1124.             $em = $this->getDoctrine()->getManager();
  1126.             $repository = $this->getDoctrine()->getRepository(Product::class);
  1128.             $QUERY = 'SELECT * FROM cart_order_item where session_id = "' . $session->getId() . '"  ORDER BY DATE(created_at) DESC LIMIT 1 ;';
  1130.             $statement = $em->getConnection()->prepare($QUERY);
  1132.             $statement->execute();
  1134.             $result = $statement->fetch();
  1136.             if ($result == false) {
  1138.                 $this->orderFactory->addItem($repository->findOneBy(['id' => $request->request->get('product_id')]), $request->request->get('quantity'));
  1140.                 $this->addFlash('success', $this->translator->trans('app.cart.addItem.message.success'));
  1142.                 $QUERY1 = 'SELECT * FROM cart_order_item where session_id = "' . $session->getId() . '" AND product_id = "' . $request->request->get('product_id') . '"  LIMIT 1 ;';
  1144.                 $statement1 = $em->getConnection()->prepare($QUERY1);
  1146.                 $statement1->execute();
  1148.                 $result1 = $statement1->fetch();
  1150.                 $sql_query = ' UPDATE cart_order SET cart_cat = ' . $product->getCart_cat() . '  WHERE id = "' . $result1["order_id"] . '" ; ';
  1152.                 $statement1 = $em->getConnection()->prepare($sql_query);
  1154.                 $statement1->execute();
  1156.                 return $this->redirectToRoute('shop_detail_ville', ['ville' => $request->request->get('cat'), 'magasin' => $request->request->get('magasin'), 'categorie'=>$request->request->get('categorie'), 'type'=>$request->request->get('type')]);
  1158.             } // elseif (($result != false) && $result["cart_cat"] != $product->getCart_cat()) {
  1159.             else if (($result != false) && $result["cart_cat"] != $product->getCart_cat() && $result["cart_cat"] != 10) {
  1161.                 $ville = [1 => "Douala", 2 => "Yaoundé", 3 => "Bafoussam", 4 => "Mbouda", 10 => ""];
  1163.                 $message = "Impossible! Vous avez au depart choisit un magasin dans la ville de " . $ville[$result["cart_cat"]] . " et maintenant vous changer par celui de " . $ville[$product->getCart_cat()] . "  vous ne pouvez que faire vos achats dans les magasins d'une même ville: ";
  1165.                 $this->addFlash('error', $message);
  1167.                 return $this->redirectToRoute('cart');
  1169.             } //elseif (($result != false) && $result["cart_cat"] == $product->getCart_cat()) {
  1170.             if (($result != false && $result["cart_cat"] == $product->getCart_cat()) || ($result["cart_cat"] != $product->getCart_cat() && $result["cart_cat"] == 10)) {
  1172.                 $this->orderFactory->addItem($repository->findOneBy(['id' => $request->request->get('product_id')]),  $request->request->get('quantity'));
  1174.                 $this->addFlash('success', $this->translator->trans('app.cart.addItem.message.success'));
  1176.                 $QUERY1 = 'SELECT * FROM cart_order_item where session_id = "' . $session->getId() . '" AND product_id = "' . $request->request->get('product_id') . '" ORDER BY DATE(created_at) DESC LIMIT 1 ;';
  1178.                 $statement1 = $em->getConnection()->prepare($QUERY1);
  1180.                 $statement1->execute();
  1182.                 $result1 = $statement1->fetch();
  1184.                 $sql_query = ' UPDATE cart_order SET cart_cat = ' . $product->getCart_cat() . ' WHERE id = "' . $result1["order_id"] . '" ; ';
  1186.                 $statement2 = $em->getConnection()->prepare($sql_query);
  1188.                 $statement2->execute();
  1190.                 // return $this->redirectToRoute('home1');
  1191.                 return $this->redirectToRoute('shop_detail_ville', ['ville' => $request->request->get('cat'), 'magasin' => $request->request->get('magasin'), 'categorie'=>$request->request->get('categorie'), 'type'=>$request->request->get('type')]);
  1193.             } else {
  1195.                 $ville = [1 => "Douala", 2 => "Yaoundé", 3 => "Bafoussam", 4 => "Mbouda", 10 => ""];
  1197.                 $message = "Impossible! Vous avez au depart choisit un magasin dans la ville de " . $ville[$result["cart_cat"]] . " et maintenant vous changer par celui de " . $ville[$product->getCart_cat()] . ". Vous ne pouvez que faire vos achats dans les magasins d'une même ville: ";
  1199.                 $this->addFlash('error', $message);
  1201.                 return $this->redirectToRoute('cart');
  1202.             }
  1203.         }
  1205.     }
  1208.     /**
  1209.      * @Route({
  1210.      *     "fr": "/cart/addsearch2/{id}",
  1211.      *     "en": "/cart/addsearch2/{id}/en"
  1212.      *     }, name="cart_search2", methods={"POST"})
  1213.      *  @param Request $request
  1214.      *
  1215.      */
  1216.     public function addSearchProducts(Request $request, Product $product): Response
  1217.     {
  1219.         if ($request->request->get('product_id')) {
  1221.             $session = new Session();
  1222.             $em = $this->getDoctrine()->getManager();
  1224.             $repository = $this->getDoctrine()->getRepository(Product::class);
  1226.             $QUERY = 'SELECT * FROM cart_order_item where session_id = "' . $session->getId() . '"  ORDER BY DATE(created_at) DESC LIMIT 1 ;';
  1228.             $statement = $em->getConnection()->prepare($QUERY);
  1230.             $statement->execute();
  1232.             $result = $statement->fetch();
  1234.             if ($result == false) {
  1236.                 $this->orderFactory->addItem($repository->findOneBy(['id' => $request->request->get('product_id')]),  $request->request->get('quantity'));
  1238.                 $this->addFlash('success', $this->translator->trans('app.cart.addItem.message.success'));
  1240.                 $QUERY1 = 'SELECT * FROM cart_order_item where session_id = "' . $session->getId() . '" AND product_id = "' . $request->request->get('product_id') . '"  LIMIT 1 ;';
  1242.                 $statement1 = $em->getConnection()->prepare($QUERY1);
  1244.                 $statement1->execute();
  1246.                 $result1 = $statement1->fetch();
  1248.                 $sql_query = ' UPDATE cart_order SET cart_cat = ' . $product->getCart_cat() . '  WHERE id = "' . $result1["order_id"] . '" ; ';
  1250.                 $statement1 = $em->getConnection()->prepare($sql_query);
  1252.                 $statement1->execute();
  1254.                 // return $this->redirectToRoute('home1');
  1255.                 return $this->redirect($request->server->get('HTTP_REFERER'));
  1257.             } // elseif (($result != false) && $result["cart_cat"] != $product->getCart_cat()) {
  1258.             else if (($result != false) && $result["cart_cat"] != $product->getCart_cat() && $result["cart_cat"] != 10) {
  1260.                 $ville = [1 => "Douala", 2 => "Yaoundé", 3 => "Bafoussam", 4 => "Mbouda", 10 => ""];
  1262.                 $message = "Impossible! Vous avez au depart choisit un magasin dans la ville de " . $ville[$result["cart_cat"]] . " et maintenant vous changer par celui de " . $ville[$product->getCart_cat()] . "  vous ne pouvez que faire vos achats dans les magasins d'une même ville: ";
  1264.                 $this->addFlash('error', $message);
  1266.                 return $this->redirectToRoute('cart');
  1268.             } //elseif (($result != false) && $result["cart_cat"] == $product->getCart_cat()) {
  1269.             if (($result != false && $result["cart_cat"] == $product->getCart_cat()) || ($result["cart_cat"] != $product->getCart_cat() && $result["cart_cat"] == 10)) {
  1271.                 $this->orderFactory->addItem($repository->findOneBy(['id' => $request->request->get('product_id')]),  $request->request->get('quantity'));
  1273.                 $this->addFlash('success', $this->translator->trans('app.cart.addItem.message.success'));
  1275.                 $QUERY1 = 'SELECT * FROM cart_order_item where session_id = "' . $session->getId() . '" AND product_id = "' . $request->request->get('product_id') . '" ORDER BY DATE(created_at) DESC LIMIT 1 ;';
  1277.                 $statement1 = $em->getConnection()->prepare($QUERY1);
  1279.                 $statement1->execute();
  1281.                 $result1 = $statement1->fetch();
  1283.                 $sql_query = ' UPDATE cart_order SET cart_cat = ' . $product->getCart_cat() . ' WHERE id = "' . $result1["order_id"] . '" ; ';
  1285.                 $statement2 = $em->getConnection()->prepare($sql_query);
  1287.                 $statement2->execute();
  1289.                 //  return $this->redirectToRoute('home1');
  1290.                 return $this->redirect($request->server->get('HTTP_REFERER'));
  1292.             } else {
  1294.                 $ville = [1 => "Douala", 2 => "Yaoundé", 3 => "Bafoussam", 4 => "Mbouda", 10 => ""];
  1296.                 $message = "Impossible! Vous avez au depart choisit un magasin dans la ville de " . $ville[$result["cart_cat"]] . " et maintenant vous changer par celui de " . $ville[$product->getCart_cat()] . ". Vous ne pouvez que faire vos achats dans les magasins d'une même ville: ";
  1298.                 $this->addFlash('error', $message);
  1300.                 return $this->redirectToRoute('cart');
  1301.             }
  1302.         }
  1304.     }
  1307.     /**
  1308.      * @Route({
  1309.      *     "fr": "/cart/removeItem/{id}",
  1310.      *     "en": "/cart/removeItem/{id}/en"
  1311.      *     }, name="cart.removeItem", methods={"POST"})
  1312.      *  @param Request $request
  1313.      *
  1314.      */
  1315.     public function removeItem(Request $request, OrderItem $item): Response
  1316.     {
  1317.         $form = $this->createForm(RemoveItemType::class, $item);
  1318.         $form->handleRequest($request);
  1319.        
  1320.         if ($form->isSubmitted() && $form->isValid()) {
  1321.            
  1322.             $this->orderFactory->removeItem($item);
  1323.             $this->addFlash('success', $this->translator->trans('app.cart.removeItem.message.success'));
  1324.         }
  1325.         return $this->redirectToRoute('cart');
  1326.     }
  1329.       /**
  1330.      * @Route({
  1331.      *     "fr": "/cart/getremoveItem/{id}",
  1332.      *     "en": "/cart/getremoveItem/{id}/en"
  1333.      *     }, name="getremoveItem", methods={"GET"})
  1334.      *  @param Request $request
  1335.      *
  1336.      */
  1337.     public function getRemoveItem(Request $request, $id): Response
  1338.     {
  1339.        
  1340.             $orderItem = $this->getDoctrine()->getRepository('App\Component\Order\Model:OrderItem')->findOneBy(array('id'=>$id));
  1341.            
  1342.             if ($orderItem != null){
  1344.                 $this->orderFactory->removeItem($orderItem);
  1345.               
  1346.                 $this->addFlash('success', $this->translator->trans('app.cart.removeItem.message.success'));
  1347.             }
  1348.           
  1349.         return $this->redirectToRoute('cart');
  1350.     }
  1353.     /**
  1354.      * @Route({
  1355.      *     "fr": "/cart/setItemQuantity/{id}",
  1356.      *     "en": "/cart/setItemQuantity/{id}/en"
  1357.      *     }, name="cart.setItemQuantity", methods={"POST"})
  1358.      *  @param Request $request
  1359.      *
  1360.      */
  1361.     public function setQuantity(Request $request, OrderItem $item): Response
  1362.     {
  1363.         $form = $this->createForm(SetItemQuantityType::class, $item);
  1364.         $form->handleRequest($request);
  1366.         if ($form->isSubmitted() && $form->isValid()) {
  1367.             $this->orderFactory->setItemQuantity($item, $form->getData()->getQuantity());
  1369.             $this->addFlash('success', $this->translator->trans('app.cart.setItemQuantity.message.success'));
  1370.         }
  1372.         return $this->redirectToRoute('cart');
  1373.     }
  1376.     /**
  1377.      * @Route({
  1378.      *     "fr": "/cart/clear",
  1379.      *     "en": "/cart/clear/en"
  1380.      *     }, name="cart.clear", methods={"POST"})
  1381.      *  @param Request $request
  1382.      *
  1383.      */
  1384.     public function clear(Request $request): Response
  1385.     {
  1386.         $form = $this->createForm(ClearCartType::class, $this->orderFactory->getCurrent());
  1387.         $form->handleRequest($request);
  1389.         if ($form->isSubmitted() && $form->isValid()) {
  1390.             $this->orderFactory->clear();
  1391.             $this->addFlash('success', $this->translator->trans('app.cart.clear.message.success'));
  1392.         }
  1394.         return $this->redirectToRoute('home1');
  1395.     }
  1398.     /**
  1399.      * @Route({
  1400.      *     "fr": "/cart/setPayment",
  1401.      *     "en": "/cart/setPayment/en"
  1402.      *     }, name="cart.setPayment", methods={"POST"})
  1403.      *  @param Request $request
  1404.      *
  1405.      */
  1406.     public function setPayment(Request $request, OrderFactory $order): Response
  1407.     {
  1408.         $form = $this->createForm(SetPaymentType::class, $order->getCurrent());
  1409.         $form->handleRequest($request);
  1411.         if ($form->isSubmitted() && $form->isValid()) {
  1412.             $this->orderFactory->setPayment($form->getData()->getPayment());
  1413.             $this->addFlash('success', $this->translator->trans('app.cart.setPayment.message.success'));
  1414.         }
  1416.         return $this->redirectToRoute('cart');
  1417.     }
  1420.     /**
  1421.      * @Route({
  1422.      *     "fr": "/cart/setShipment",
  1423.      *     "en": "/cart/setShipment/en"
  1424.      *     }, name="cart.setShipment", methods={"POST"})
  1425.      *  @param Request $request
  1426.      *
  1427.      */
  1428.     public function setShipment(Request $request): Response
  1429.     {
  1430.         $form = $this->createForm(SetShipmentType::class, $this->orderFactory->getCurrent());
  1431.         $form->handleRequest($request);
  1433.         if ($form->isSubmitted() && $form->isValid()) {
  1434.             $this->orderFactory->setShipment($form->getData()->getShipment());
  1435.             $this->addFlash('success', $this->translator->trans('app.cart.setShipment.message.success'));
  1436.         }
  1438.         //return $this->redirectToRoute('cart');
  1439.         return $this->redirect($request->server->get('HTTP_REFERER'));
  1440.     }
  1442.     /**
  1443.      * @Route({
  1444.      *     "fr": "/cart/setDiscount",
  1445.      *     "en": "/cart/setDiscount/en"
  1446.      *     }, name="cart.setDiscount", methods={"POST"})
  1447.      *  @param Request $request
  1448.      *
  1449.      */
  1450.     public function setDiscount(Request $request): Response
  1451.     {
  1453.         /**
  1454.          * @var User $user
  1455.          */
  1456.         $user = $this->getUser();  
  1458.             $form = $this->createForm(SetDiscountType::class, $this->orderFactory->getCurrent());
  1459.             $form->handleRequest($request);
  1460.              $em = $this->getDoctrine()->getManager();
  1462.             if ($form->isSubmitted() && $form->isValid()) {
  1464.                 if(!is_null($user)){
  1466.                     $discount = $this->getDoctrine()->getRepository('App\Component\Discount\Model:Discount')->findOneBy([
  1467.                         'code' => $form->get('discountCode')->getData(),'userId'=>$user->getId()
  1468.                     ]);
  1470.                     if ($discount !== null) {
  1472.                         $this->orderFactory->setDiscount($discount);
  1474.                            // $discount->setUserId(0);
  1475.                           
  1476.                             //$user->setCodePromoName("");
  1477.                             $user->setCodePromoStatus(2);
  1478.                          //   $user->setCodePromoValue("");
  1479.                           //  $em->persist($discount);
  1480.                             $em->persist($user);
  1481.                             $em->flush();
  1483.                         $this->addFlash('success', $this->translator->trans('app.cart.setDiscount.message.success'));
  1485.                     } else {
  1487.                         $this->addFlash('error', $this->translator->trans('app.cart.setDiscount.message.codeNotFound'));
  1488.                         
  1489.                     }
  1491.                 }else{
  1492.               
  1493.                     $this->addFlash('error', $this->translator->trans('app.cart.setDiscount.message.codeNotFound'));
  1494.     
  1495.                }
  1496.     
  1497.             }
  1499.         return $this->redirectToRoute('cart');
  1500.     }
  1502. }