src/Controller/ProductController.php line 863

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\CompanyAssociation;
  6. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  7. use Symfony\Component\Routing\Annotation\Route;
  8. use Symfony\Component\HttpFoundation\Request;
  9. use Symfony\Component\HttpFoundation\Response;
  10. use Symfony\Component\HttpFoundation\JsonResponse;
  11. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Template;
  12. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Security;
  13. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Entity;
  14. use Doctrine\ORM\EntityManagerInterface;
  15. use Symfony\Component\Routing\Generator\UrlGeneratorInterface;
  16. use Symfony\Component\HttpFoundation\RedirectResponse;
  18. use Doctrine\Common\Collections\ArrayCollection;
  19. use Symfony\Component\Form\Extension\Core\Type\CheckboxType;
  20. use Symfony\Component\Form\Extension\Core\Type\SubmitType;
  22. use Knp\Component\Pager\PaginatorInterface;
  24. use App\Entity\Category;
  25. use App\Entity\Cart;
  26. use App\Entity\Certification;
  27. use App\Entity\Company;
  28. use App\Entity\Conservation;
  29. use App\Entity\DeliveryMethod;
  30. use App\Entity\Ingredient;
  31. use App\Entity\Pricing;
  32. use App\Entity\Product;
  33. use App\Entity\ProductSponsored;
  34. use App\Entity\ProductSponsoredCategory;
  35. use App\Entity\ProductReplenishment;
  36. use App\Entity\Region;
  37. use App\Entity\Storage;
  38. use App\Entity\Tag;
  39. use App\Entity\UserSearch;
  40. use App\Entity\User;
  41. use App\Entity\ProductInBox;
  43. use App\Service\DistributorService;
  44. use App\Service\PaymentService;
  45. use App\Service\ProductService;
  46. use App\Service\UserService;
  47. use App\Service\ImageService;
  48. use App\Service\CompanyService;
  50. use App\Form\ProductType;
  51. use App\Form\ProductReplenishmentType;
  52. use App\Form\StorageType;
  54. use Symfony\Component\Form\Extension\Core\Type\CollectionType;
  57. class ProductController extends AbstractController
  58. {
  59.     private $entityMana;
  60.     private $productServ;
  61.     private $userServ;
  62.     private $companyServ;
  63.     private $request;
  65.     public function __construct(ProductService $prodServ, EntityManagerInterface $em, UserService $user, CompanyService $companyServ){
  66.         $this->entityMana = $em;
  67.         $this->productServ = $prodServ;
  68.         $this->userServ = $user;
  69.         $this->companyServ = $companyServ;
  70.     }
  72.     /**
  73.      * @route("/core/convert/productBoxes",
  74.      *      name="convertBoxesOfProduct")
  75.      */
  76.     public function convertCart(EntityManagerInterface $em){
  77.         return new Response('Disabled');
  79.         $products = $em->getRepository(Product::class)->findProductsWithOldBundles();
  81.         foreach($products as $box){
  82.             $box->setIsBoxOfProducts(true);
  83.             foreach($box->getProductsInBundle() as $p){
  84.                 $pb = new ProductInBox();
  85.                 $pb->setProductRepresentingBox($box);
  86.                 $pb->setProduct($p->getProduct());
  87.                 $pb->setQuantity(1);
  88.                 $pb->setPriceToCompany($p->getPriceToCompany());
  89.                 $em->persist($pb);
  91.                 $box->addProductInBox($pb);
  92.             }
  93.             $em->persist($box);
  94.         }
  95.         $em->flush();
  97.         return new Response();
  98.     }
  100.     /**
  101.      * @route({
  102.      *          "fr": "/soldes",
  103.      *          "en": "/sponsored/{url}"
  104.      *      },
  105.      *      options = { "expose" = true },
  106.      *      name="viewOnSalesProduct")
  107.      * @Template("frontend/category.html.twig")
  108.      */
  109.     public function viewOnSaleProducts(Request $request){
  110.         $twigData = array();
  111.         $twigData['link'] = $request->getPathInfo();
  112.         $twigData['category'] =  new Category();
  113.         $twigData['category']->setTitle('En solde');
  114.         $twigData['noLoader'] = true;
  115.         $twigData['noPagination'] = true;
  116.         $twigData['forcedBanner'] = '/assets/frontend/images/Banner-02-2021-commealaferme.png';
  118.         $order = 'Desc';
  119.         if ($request->get("order")) {
  120.           $order = $request->get("order");
  121.         }
  122.         $twigData['order']= $order;
  124.         $sorting = "date";
  125.         // $sorting = null;
  126.         if ($request->get("sorting")) {
  127.           $sorting = $request->get("sorting");
  128.         }
  129.         $twigData['sorting']= $sorting;
  131.         $sales = $this->entityMana->getRepository(Pricing::class)->findOnSale($sorting,$order);
  132.         // dd($sales);
  133.         $twigData['products'] = array();
  135.         foreach( $sales as $s ){
  136.         if($s->getDiscountProduct()->isSalable())
  137.             $twigData['products'][]= $s->getDiscountProduct();
  138.         }
  139.         $twigData['productsAmount'] = count($twigData['products']);
  140.         //$twigData['products']['getTotalItemCount'] = $category->getProductsSponsored()->count();
  141.         $twigData['regions'] = $this->entityMana->getRepository(Region::class)->findBy(['province'=>'Qc']);
  142.         $twigData['conservations'] = $this->entityMana->getRepository(Conservation::class)->findAll();
  144.         return $twigData;
  145.     }
  149.     /**
  150.      * @route({
  151.      *          "fr": "/vedette/{url}",
  152.      *          "en": "/sponsored/{url}"
  153.      *      },
  154.      *      defaults={
  155.      *          "url" = false
  156.      *      },
  157.      *      options = { "expose" = true },
  158.      *      name="viewSponsoredCategory")
  159.      * @Template("frontend/category.html.twig")
  160.      */
  161.     public function viewSponsoredCategory(ProductSponsoredCategory $category=null, Request $request){
  162.         $twigData = array();
  164.         if(empty($category) || $category->getUrl() == 'soldes'){
  165.             return $this->redirectToRoute('viewOnSalesProduct');
  166.         }
  168.         if($category->getCategory()){
  169.             $fullUrl = $category->getCategory()->getFullUrlPath();
  170.             return new RedirectResponse('/categorie'.$fullUrl);
  171.         }
  173.         $order = "desc";
  174.         if ($request->get("order")) {
  175.           $order = $request->get("order");
  176.         }
  177.         $twigData['order']= $order;
  179.         $sorting = "date";
  180.         if ($request->get("sorting")) {
  181.           $sorting = $request->get("sorting");
  182.         }
  183.         $twigData['sorting']= $sorting;
  185.         $twigData['category'] =  new Category();
  186.         $twigData['category']->setTitle($category->getTitle());
  187.         $twigData['noLoader'] = true;
  188.         $twigData['noPagination'] = true;
  189.         $twigData['forcedBanner'] = '/assets/frontend/images/Banner-02-2021-commealaferme.png';
  191.         $twigData['selected'] = array(
  192.             'main' => $twigData['category']->getId(),
  193.             'sub1' => false,
  194.             'sub2' => false,
  195.             'sub3' => false
  196.         );
  198.         $Products = $this->entityMana->getRepository(Product::class)->getProductsSponsored($category, $sorting, $order);
  200.         $twigData['products'] = $Products;
  201.         // $now = new \DateTime('now');
  202.         // foreach( $Products as $p ) {
  203.         //   if (
  204.         //     $now >= $p->getFromDate() &&
  205.         //     $now <= $p->getToDate() &&
  206.         //     $p->getActive()
  207.         //   ) {
  208.         //     $twigData['products'][]= $p->getProduct();
  209.         //   }
  210.         // }
  212.         $twigData['productsAmount'] = count($twigData['products']);
  214.         //$twigData['products']['getTotalItemCount'] = $category->getProductsSponsored()->count();
  215.         $twigData['regions'] = $this->entityMana->getRepository(Region::class)->findBy(['province'=>'Qc']);
  216.         $twigData['conservations'] = $this->entityMana->getRepository(Conservation::class)->findAll();
  218.         return $twigData;
  219.     }
  221.     /**
  222.      * @route({
  223.      *          "fr": "/solex/{id}",
  224.      *          "en": "/solex/{id}"
  225.      *      },
  226.      *      options = { "expose" = true },
  227.      *      name="testing")
  228.      */
  229.     public function testing(DistributorService $d, User $user){
  230.         //$form = $this->createForm(ProductReplenishmentType::class, $replenishment);
  231.         $twig = $this->get('twig')->render('emails/welcomeNewAccount.html.twig', [
  232.             'user' => $user,
  233.         ]);
  235.         var_dump($twig);
  236.         die();
  237.     }
  239.     /**
  240.      * @route({
  241.      *          "fr": "/vendeur/inventaire/{id}",
  242.      *          "en": "/seller/inventory/{id}"
  243.      *      },
  244.      *      defaults={
  245.      *          "id" = false
  246.      *      },
  247.      *      name="replenishment")
  248.      * @Security("has_role('ROLE_ADMIN')")
  249.      * @Template("admin/product/replenishmentCalendar.html.twig")
  250.      */
  251.     public function replenishment( Company $company=null, DistributorService $distributor,Request $request, UserService $userServ){
  252.         if(empty($company)){
  253.             $user = $userServ->getUser();
  254.             $companies = $user->getCompanies();
  256.             if(count($companies) > 1){
  257.                 $this->addFlash('error', "Vous avez plusieur boutiques, pour accéder a l'inventaire via le menu");
  258.                 return $this->redirectToRoute('dashboard');
  259.             }else{
  260.                 $company = $companies->get(0);
  261.             }
  262.         }
  264.         //@SECuritY
  265.         if(!$this->companyServ->allowedToModify($company) || empty($company)){
  266.             $this->addFlash('error', "Vous n'avez pas d'accès à cette boutique, veuillez utiliser le menu");
  267.             return $this->redirectToRoute('dashboard');
  268.         }
  270.         if($_ENV['APP_ENV'] != 'dev'){
  271.             if(!$company->hasPayment()){
  272.                 $this->addFlash('error', "Avant de planifier votre mise en inventaire, SVP veuillez compléter votre mode de paiement. Ce mode de paiement servira à payer vos frais mensuels tel l’abonnement de votre boutique et l’entreposage de vos produits.");
  273.                 return $this->redirectToRoute('companyPayment');
  274.             }
  275.         }
  277.         if(empty($company->getProducts()) || count($company->getProducts()) < 1){
  278.             $this->addFlash('error', "Vous devez avoir des produits pour prendre un rendez-vous.");
  279.             return $this->redirectToRoute('adminNewProduct', array('id' => $company->getId()));
  280.         }
  282.         $twigData = array();
  283.         $twigData['company'] = $company;
  285.         return $twigData;
  286.     }
  288.     /**
  289.      * @route({
  290.      *          "fr": "/vendeur/inventaire/dimensions/{id}",
  291.      *          "en": "/vendeur/inventory/dimensions/{id}"
  292.      *      },
  293.      *      options = { "expose" = true },
  294.      *      name="replenishmentDimensionsForm")
  295.      * @Security("has_role('ROLE_ADMIN')")
  296.      */
  297.     public function confirmDimensionStorage(Product $product, ProductService $productServ, Request $request){
  298.         if(!$productServ->allowedToModify($product)){
  299.             $this->addFlash('error', "Vous n'avez pas d'accès à ce produit.");
  300.             return $this->redirectToRoute('dashboard');
  301.         }
  303.         $response = new JsonResponse();
  304.         $twigData = array();
  305.         $twigData['product'] = $product;
  307.         $form = $this->createFormBuilder($product)
  308.             ->add('storages', CollectionType::class, array(
  309.                 'entry_type' => StorageType::class,
  310.                 'allow_delete' => false,
  311.                 'data' => $product->getStorages()
  312.             ))
  313.             ->add('confirm', CheckboxType::class, array(
  314.                 'label' => 'Je confirme les informations et la mise-en-inventaire de ce produit.',
  315.                 'required' => true,
  316.                 'mapped' => false,
  317.                 'attr' => array(
  318.                     'class' => 'checkbox-only confirm-checkbox'
  319.                 )
  320.             ))
  321.             ->getForm();
  322.             ;
  324.         $twigData['form'] = $form->createView();
  326.         $form->handleRequest($request);
  327.         if($request->isXmlHttpRequest() && $request->get('form') !== null ){
  328.             $minimum = $request->get('minimum');
  329.             if(!empty($minimum) && is_numeric($minimum))
  330.                 $product->setMinimumInStorage($minimum);
  332.             $em = $this->getDoctrine()->getManager();
  333.             $em->persist($product);
  334.             $em->flush();
  336.             $response->setData(array('success' => true));
  337.             return $response;
  338.         }else{
  339.             $response->setData(array(
  340.                 'html' => $this->get('twig')->render('admin/product/replenishmentConfirmDimensions.html.twig', $twigData),
  341.                 'minimum' => $product->getMinimumInStorage()
  342.             ));
  343.             return $response;
  344.         }
  345.     }
  347.     /**
  348.      * @route({
  349.      *          "fr": "/vendeur/inventaire/rendezvous/{replenishment}/{sendEmail}",
  350.      *          "en": "/seller/inventory/appointment/{replenishment}/{sendEmail}"
  351.      *      },
  352.      *      options = { "expose" = true },
  353.      *      defaults={
  354.      *          "sendEmail" = 1,
  355.      *      },
  356.      *      name="editReplenishmentAppointment")
  357.      * @Security("has_role('ROLE_ADMIN')")
  358.      * @Template("admin/product/replenishmentSchedule.html.twig")
  359.      */
  360.     public function editReplenishmentAppointment(ProductReplenishment $replenishment, Request $request, CompanyService $companyServ, DistributorService $distributor, UserService $userServ, $sendEmail=true){
  362.         $company = $replenishment->getCompany();
  364.         if(!$companyServ->allowedToModify($company)){
  365.             $this->addFlash('error', "Vous n'avez pas d'accès à cette boutique.");
  366.             return $this->redirectToRoute('dashboard');
  367.         }
  369.         $twigData = array();
  370.         $twigData['company'] = $company;
  371.         $twigData['editing'] = true;
  372.         $twigData['scheduleDate'] = $replenishment->getAppointmentDate();
  373.         $twigData['replenishment'] = $replenishment;
  375.         $form = $this->createForm(ProductReplenishmentType::class, $replenishment);
  376.         $form
  377.             ->add('erase', SubmitType::Class,
  378.                 array(
  379.                     'label' => 'Annuler le rendez-vous',
  380.                     'attr' => array(
  381.                         'class' => 'btn btn-warning'
  382.                     )
  383.                 )
  384.             );
  386.         $form->handleRequest($request);
  388.         if($form->isSubmitted() && $form->isValid()){
  389.             $em = $this->getDoctrine()->getManager();
  391.             //We erase
  392.             if($form->get('submit')->isClicked()){
  393.                 //We edit only
  394.                 $em->persist($replenishment);
  395.                 $em->flush();
  397.                 if($distributor->setStockingSchedule($replenishment)){
  398.                    $this->addFlash('success', "Votre rendez-vous à été modifié.");
  401.                    if($sendEmail){
  402.                         $email =  $this->get('twig')->render('emails/confirmReplenishment.html.twig', array('replenishment' => $replenishment, 'user' => $userServ->getUser()));
  403.                        //For now we send a email to some people to warn them
  404.                        if($replenishment->hasProductsNeedingRefrigeration()){
  405.                             $userServ->sendEmail('Maturin: Un rdv pour produits réfrigéré le '.$replenishment->getAppointmentDate()->format('d-m-Y').' à été pris', $email, false, 'support@maturin.ca');
  406.                             $userServ->sendEmail('Maturin: Un rdv pour produits réfrigéré le '.$replenishment->getAppointmentDate()->format('d-m-Y').' à été pris', $email, false, 'philippe.vandelac@solexdocument.com');
  407.                        }
  409.                        $userServ->sendEmail(' Confirmation de votre rendez-vous chez Maturin le '.$replenishment->getAppointmentDate()->format('d-m-Y'), $email, false, $userServ->getUser()->getEmail());
  410.                     }
  411.                 }else{
  412.                     $this->addFlash('error', "Nous n'avons pas réussi a confirmer votre rendez-vous.");
  413.                     $replenishment->setIsValid(false);
  414.                     $em->persist($replenishment);
  415.                     $em->flush();
  416.                 }
  417.             }else{
  418.                 if($distributor->cancelStockingSchedule($replenishment)){
  419.                     $this->addFlash('success', "Votre rendez-vous à été annulé.");
  421.                     $replenishment->setIsValid(false);
  422.                     //$em->remove($replenishment);
  423.                     $em->persist($replenishment);
  424.                 }
  425.             }
  426.             $em->flush();
  427.             return $this->redirectToRoute('replenishment', array('id' => $company->getId()));
  428.         }
  430.         $twigData['form'] = $form->createView();
  432.         return $twigData;
  433.     }
  435.     /**
  436.      * @route({
  437.      *          "fr": "/vendeur/inventaire/rendezvous/{year}/{month}/{day}/{hour}/{min}/{company}",
  438.      *          "en": "/seller/inventory/appointment/{year}/{month}/{day}/{hour}/{min}/{company}"
  439.      *      },
  440.      *      options = { "expose" = true },
  441.      *      name="replenishmentAppointment")
  442.      * @Security("has_role('ROLE_ADMIN')")
  443.      * @Template("admin/product/replenishmentSchedule.html.twig")
  444.      */
  445.     public function replenishementAppointment(Company $company=null, $year=null, $month=null, $day=null, $hour=null, $min=null, CompanyService $companyServ, Request $request, DistributorService $distributor, UserService $userServ){
  447.         if(!$companyServ->allowedToModify($company)){
  448.             $this->addFlash('error', "Vous n'avez pas d'accès à cette boutique.");
  449.             return $this->redirectToRoute('dashboard');
  450.         }
  453.         $twigData = array();
  454.         $twigData['scheduleDate'] = \DateTime::createFromFormat('d-m-Y H:i', $day.'-'.$month.'-'.$year.' '.$hour.':'.$min);
  455.         $twigData['company'] = $company;
  456.         $twigData['loader'] = true;
  458.         //If they already have a appointment at that time, let's edit that one instead of creating a new one
  459.         if($test = $company->hasReplenishmentOn($twigData['scheduleDate'])){
  460.             $this->addFlash('error', 'Utiliser le bouton "Ajouter un produit" pour ajouter un produit a votre commande');
  461.             $this->redirectToRoute('editReplenishmentAppointment', array('replenishment' => $test->getId()));
  462.         }
  464.         $replenishment = new ProductReplenishment();
  465.         $replenishment->setAppointmentDate($twigData['scheduleDate']);
  466.         $replenishment->setCompany($company);
  468.         $twigData['editing'] = false;
  469.         $twigData['replenishment'] = $replenishment;
  471.         $form = $this->createForm(ProductReplenishmentType::class, $replenishment);
  473.         $form->handleRequest($request);
  474.         if($form->isSubmitted() && $form->isValid()){
  475.             try {
  477.                 $em = $this->getDoctrine()->getManager();
  478.                 $em->persist($replenishment);
  479.                 $em->flush();
  481.                 if($distributor->setStockingSchedule($replenishment)){
  482.                    $email =  $this->get('twig')->render('emails/confirmReplenishment.html.twig', array('replenishment' => $replenishment, 'user' => $userServ->getUser()));
  483.                    $userServ->sendEmail(' Confirmation de votre rendez-vous chez Maturin le '.$replenishment->getAppointmentDate()->format('d-m-Y'), $email, false, $userServ->getUser()->getEmail());
  484.                     $this->addFlash('success', 'Votre rendez-vous été confirmé.');
  486.                    //For now we send a email to some people to warn them
  487.                    if($replenishment->hasProductsNeedingRefrigeration()){
  488.                         $userServ->sendEmail('Maturin: Un rdv pour produits réfrigéré le '.$replenishment->getAppointmentDate()->format('d-m-Y').' à été pris', $email, false, 'support@maturin.ca');
  489.                         $userServ->sendEmail('Maturin: Un rdv pour produits réfrigéré le '.$replenishment->getAppointmentDate()->format('d-m-Y').' à été pris', $email, false, 'philippe.vandelac@solexdocument.com');
  490.                    }
  493.                 }else{
  494.                     $this->addFlash('error', "Nous n'avons pas réussi a confirmer votre rendez-vous.");
  495.                     $replenishment->setIsValid(false);
  496.                     $em->persist($replenishment);
  497.                     $em->flush();
  498.                 }
  499.             } catch (\Exception $e ){
  500.                 $this->addFlash('error', 'Une erreur est survenu, veuillez contacter notre support.');
  501.                 $this->addFlash('error', $e);
  502.                 $em->remove($replenishment);
  503.                 $em->flush();
  504.                 return $this->redirectToRoute('replenishment', array('id' => $company->getId()));
  505.             }
  506.             return $this->redirectToRoute('replenishment', array('id' => $company->getId()));
  507.         }
  509.         $twigData['form'] = $form->createView();
  511.         return $twigData;
  512.     }
  514.     /**
  515.      * @route({
  516.      *          "fr": "/admin/inventaire/horraire/{id}/{action}",
  517.      *          "en": "/admin/inventory/schedule/{id}/{action}"
  518.      *      },
  519.      *      options = { "expose" = true },
  520.      *      name="replenishmentGetSchedule")
  521.      * @Security("has_role('ROLE_ADMIN')")
  522.      */
  523.     public function replenishmentGetSchedule(DistributorService $distributor, Company $company, $action){
  524.         $response = new JsonResponse();
  525.         $dateFrom = new \DateTime(urldecode($_GET['start']));
  526.         $dateTo = new \DateTime(urldecode($_GET['end']));
  528.         $data = array();
  530.         $now = new \DateTime();
  531.         foreach($company->getProductReplenishments() as $r){
  532.             $tmpDateFrom = $r->getAppointmentDate();
  533.             if($tmpDateFrom > $now){
  534.                 $data[]=array(
  535.                     'id' => $r->getId(),
  536.                     'title' => 'Votre rendez-vous',
  537.                     'allDay' => 'false',
  538.                     'className' => 'calendar-mine',
  539.                     'editable' => false,
  540.                     'start' => $tmpDateFrom->format('c'),
  541.                     'end' => $tmpDateFrom->modify('+59 minutes 60 seconds')->format('c')
  542.                 );
  543.             }
  544.         }
  546.         $minSchedule = new \DateTime();
  547.         $minSchedule->add(new \DateInterval('P1D'));
  548.         /*
  549.         if($minSchedule > $dateFrom){
  550.             $dateFrom = $minSchedule;
  551.         }
  552.          */
  554.         $schedules = $distributor->getStockingSchedule($dateFrom->format('c'), $dateTo->format('c'));
  555.         $cmtp = 0;
  556.         foreach($schedules as $s){
  557.             $dateFrom = new \DateTime($s->startTime);
  558.             $dateTo = new \DateTime($s->endTime);
  559.             $nbSpot = $s->nbSpotsLeft;
  561.             if($nbSpot > 0 && $dateFrom->format('Ymd') >= $minSchedule->format('Ymd') ){
  562.                 $data[]=array(
  563.                     'id' => $cmtp,
  564.                     'title' => '',
  565.                     'allDay' => 'false',
  566.                     'className' => 'calendar-available',
  567.                     'editable' => false,
  568.                     'start' => $dateFrom->format('c'),
  569.                     'end' => $dateTo->format('c')
  570.                 );
  571.                 $cmtp++;
  572.             }
  573.         }
  574.         $response->setData($data);
  575.         return $response;
  576.     }
  578.     /**
  579.      * @route({
  580.      *          "fr": "/groupe/{groupUrlName}/produit/{producerUrl}/{productName}/{id}/",
  581.      *          "en": "/groupe/{groupUrlName}/product/{producerUrl}/{productName}/{id}/"
  582.      *      },
  583.      *      options = { "expose" = true },
  584.      *      name="viewProductInAssociation")
  585.      * @Template("frontend/product.html.twig")
  586.      */
  587.     public function viewProductInAssociation( $groupUrlName, $producerUrl, $productName, $id,    UserService $UserService, ProductService $ProductService, EntityManagerInterface $em, Request $request, PaginatorInterface $paginator, UrlGeneratorInterface $router){
  589.         $product = $em->getRepository(Product::class)->find((int)$id);
  591.         $assocation=$em->getRepository(CompanyAssociation::class)
  592.             ->findOneBy([
  593.                 'urlName' => $groupUrlName
  594.             ]);
  596.         if ($assocation && $assocation != $UserService->getAssociationUserIsBrowsing()){
  597.             $UserService->setAssociationUserIsBrowsing($assocation->getId());
  598.         }
  600.         return $this->viewProduct($UserService, $ProductService, $em, $product, $request, $paginator, $router);
  601.     }
  603.     /**
  604.      * @route({
  605.      *          "fr": "/produit/{producerUrl}/{productName}/{id}/",
  606.      *          "en": "/product/{producerUrl}/{productName}/{id}/"
  607.      *      },
  608.      *      options = { "expose" = true },
  609.      *      name="viewProduct")
  610.      * @Template("frontend/product.html.twig")
  611.      */
  612.     public function viewProduct(UserService $UserService, ProductService $ProductService, EntityManagerInterface $em, Product $product, Request $request, PaginatorInterface $paginator, UrlGeneratorInterface $router){
  613.         $twigData = array();
  614.         $UserService->addViewedProduct($product);
  616.         if ($this->userServ->getAssociationUserIsBrowsing()){
  617.             if ($request->get('_route') == 'viewProduct'){
  618.                 return $this->redirectToRoute('viewProductInAssociation', [
  619.                     'groupUrlName' => $this->userServ->getAssociationUserIsBrowsing()->getUrlName(),
  620.                     'producerUrl' => $product->getCompany()->getUrlName(),
  621.                     'productName' => $product->getUrlName(),
  622.                     'id' => $product->getId(),
  623.                 ]);
  624.             }
  626.             $userAllowed = false;
  627.             foreach($product->getCompany()->getAssociations() as $assocation){
  628.                 if ($assocation->getId() == $this->userServ->getAssociationUserIsBrowsing()->getId()){
  629.                     $userAllowed  =true;
  630.                 }
  631.             }
  632.             if (!$userAllowed){
  633.                 $this->addFlash('error', 'The product you tried to see is not allowed in '.$this->userServ->getAssociationUserIsBrowsing()->getName());
  634.                 $referer = $request->headers->get('referer');
  635.                 return $this->redirect($referer != null ? $referer : '/', 307);
  636.             }
  638.         } else if ($product->getIsDisplayedInAssociationOnly() || !$product->getCompany()->getShowPublicly()
  639.             || !$product->getIsConsumer()){
  640.             $this->addFlash('error', 'The product you tried to see is not available.');
  641.             $referer = $request->headers->get('referer');
  642.             return $this->redirect($referer != null ? $referer : '/', 307);
  643.         }
  645.         $referer = $request->headers->get('referer');
  646.         if(stripos($referer, 'maturin.ca') !== false){
  647.             $baseUrl = $request->getSchemeAndHttpHost();
  648.             $lastPath = current(explode('?', substr($referer, strpos($referer, $baseUrl) + strlen($baseUrl))));
  650.             $params = $this->get('router')->getMatcher()->match($lastPath);
  651.             if(empty($params['sub1'])){
  652.                 $params['sub1']= false;
  653.                 $params['sub2']= false;
  654.                 $params['sub3']= false;
  655.             }
  658.             if($params['_route'] != 'allCategory' && strpos($referer, 'page') !== false){
  659.                 $raw = explode('?', $referer);
  660.                 $page = str_replace('page=', '', end($raw));
  661.                 if(is_numeric($page)){
  662.                     $request->attributes->set('page', $page);
  663.                 }
  664.             }
  665.         }else{
  666.             $params['sub1']= false;
  667.             $params['sub2']= false;
  668.             $params['sub3']= false;
  669.         }
  671.         /*
  672.          * Depending of how much results there is in this sub-Category
  673.          * We are either displaying the sub-Category if results are > 12 (Filling a least 3 rows in the Desktop UI)
  674.          */
  675.         if($product->getSubCategory() && $product->getSubCategory()->getProducts()->count() > 4 )
  676.             $categoryToUse = $product->getSubCategory();
  677.         else
  678.             $categoryToUse = $product->getCategory();
  681.         $twigData = $this->viewCategory($categoryToUse, $params['sub1'], $params['sub2'], $params['sub3'], $paginator, $request, true);
  683.         $twigData['categoryToUse'] = $categoryToUse;
  684.         $twigData['product'] = $product;
  685.         $twigData['showProductsRightAway']= true;
  686.         $twigData['productsToBuyToo'] = $ProductService->getSimilarProduct($product);
  687.         //Suggestion Algo Products 
  688.         $twigData['productsUserMayLike'] = false;
  689.         $produtSuggestion = $product->getComplementedByGroups();
  691.         if(count($produtSuggestion) > 0){
  692.             $twigData['productsUserMayLike'] = $product->getAllComplementaryProducts();
  693.             if(count($product->getAllComplementaryProducts())< 4){
  694.                 //return an array of 4 elements for suggestion
  695.                 $suggestedProductsLength=(4- count($product->getAllComplementaryProducts()));
  696.                 $suggestionArray = $ProductService->getProductsSuggestion($suggestedProductsLength,$product);
  697.                 foreach ($product->getAllComplementaryProducts()as $p) {
  698.                    array_push($suggestionArray,$p);
  699.                 }
  700.                 $twigData['productsUserMayLike'] = $suggestionArray;
  702.             }
  703.         }else{
  704.                 $suggestedProductsLength=4;
  705.                 $suggestionArray = $ProductService->getProductsSuggestion($suggestedProductsLength,$product);
  706.                 $twigData['productsUserMayLike'] = $suggestionArray;
  707.         }
  709.         // remove independante delivery for cartes-cadeauxCarte-cadeau
  710.         $twigData['independentDelivery'] = true;
  711.         if($categoryToUse->getId()== 341 && strpos($product->getName(), 'Carte-cadeau') !== false){
  712.             $twigData['independentDelivery'] = false;
  713.         };
  715.         return $twigData;
  716.     }
  718.     /**
  719.      * @route({
  720.      *          "fr": "/categorie",
  721.      *          "en": "/category"
  722.      *      },
  723.      *      options = { "expose" = true },
  724.      *      name="allCategory")
  725.      * @Template("frontend/category.html.twig")
  726.      */
  727.     public function allCategory(ProductService $ProductService, EntityManagerInterface $em, PaginatorInterface $paginator, Request $request){
  728.         $twigData = array();
  730.         $order = "desc";
  731.         if ($request->get("order")) {
  732.           $order = $request->get("order");
  733.         }
  734.         $twigData['order']= $order;
  736.         $sorting = "popularity";
  737.         if ($request->get("sorting")) {
  738.           $sorting = $request->get("sorting");
  739.         }
  740.         $twigData['sorting']= $sorting;
  742.         $productsQuery  = $this->entityMana->getRepository(Product::class)->getProductsForAllCategory($sorting, $order);
  744.         $page = 1;
  745.         if(!empty($request->get('page')))
  746.             $page = $request->get('page');
  748.         // Paginate the results of the query
  749.         $twigData['products'] = $paginator->paginate(
  750.             $productsQuery,
  751.             $request->query->getInt('page', $page),
  752.             24
  753.         );
  755.         $twigData['productsAmount'] = count($productsQuery);
  756.         $twigData['regions'] = $this->entityMana->getRepository(Region::class)->findBy(['province'=>'Qc']);
  757.         $twigData['conservations'] = $this->entityMana->getRepository(Conservation::class)->findAll();
  758.         $twigData['category'] = new Category();
  760.         $twigData['category']->setTitle('NOTRE RICHESSE…');
  761.         $twigData['forcedBanner'] = '/assets/frontend/images/categorie-banner.png';
  763.         $twigData['noLoader'] = true;
  764.         $twigData['filters']= array();
  766.         $twigData['selected'] = array(
  767.             'main' => false,
  768.             'sub1' => false,
  769.             'sub2' => false,
  770.             'sub3' => false
  771.         );
  773.         return $twigData;
  774.     }
  777.     /**
  778.      * @route({
  779.      *          "fr": "/produits/recherche/{token}",
  780.      *          "en": "/products/search/{token}}"
  781.      *      },
  782.      *      options = { "expose" = true },
  783.      *      name="searchProducts")
  784.      * @Template("frontend/category.html.twig")
  785.      */
  786.     public function searchProducts($token, Request $request, ProductService $productServ, PaginatorInterface $paginator, UserService $userServ, $forcedValues = false){
  787.         $twigData = array();
  788.         $search = $this->entityMana->getRepository(UserSearch::class)->findOneBy(['token' => $token]);
  790.         $page = 1;
  791.         if(!empty($request->get('page')))
  792.             $page = $request->query->getInt('page');
  794.         $forcedValues = array(
  795.             'filters' => $search->getRawFilters(),
  796.             'token' => $token,
  797.             'page' => $page,
  798.         );
  799.         $products = $this->getProductByActionFromAPI($search->getSearch(), $request, $productServ, $paginator, $userServ, $forcedValues, false);
  802.         //Template values
  804.         // Paginate the results of the query
  805.         $twigData['products'] = $paginator->paginate(
  806.             $products,
  807.             $page,
  808.             24
  809.         );
  811.         $rawFilters = json_decode($search->getRawFilters());
  812.         $filters = array();
  814.         foreach( $rawFilters as $f){
  815.             $filters[$f->type][] = $f->id;
  816.         }
  818.         if(!empty($filters['category'])){
  819.             $category = $this->entityMana->getRepository(Category::class)->findOneById(current($filters['category']));
  820.             $twigData['category'] = $category;
  822.             $twigData['selected'] = array(
  823.                 'main' => $category->getId(),
  824.                 'sub1' => false,
  825.                 'sub2' => false,
  826.                 'sub3' => false
  827.             );
  828.         }else{
  829.             $twigData['category'] = new Category();
  831.             $twigData['selected'] = array(
  832.                 'main' => false,
  833.                 'sub1' => false,
  834.                 'sub2' => false,
  835.                 'sub3' => false
  836.             );
  837.         }
  839.         $twigData['filters'] = $filters;
  840.         $twigData['productsAmount'] = $twigData['products']->getTotalItemCount();
  841.         $twigData['regions'] = $this->entityMana->getRepository(Region::class)->findBy(['province'=>'Qc']);
  842.         $twigData['conservations'] = $this->entityMana->getRepository(Conservation::class)->findAll();
  844.         return $twigData;
  845.     }
  848.     /**
  849.      * @route({
  850.      *          "fr": "/categorie/{name}/{sub1}/{sub2}/{sub3}",
  851.      *          "en": "/category/{name}/{sub1}/{sub2}/{sub3}"
  852.      *      },
  853.      *      options = { "expose" = true },
  854.      *      defaults={
  855.      *          "sub1" = false,
  856.      *          "sub2" = false,
  857.      *          "sub3" = false
  858.      *      },
  859.      *      name="viewCategory")
  860.      * @Entity("category", expr="repository.findByUrl(name)")
  861.      * @Template("frontend/category.html.twig")
  862.      */
  863.     public function viewCategory(Category $category, $sub1, $sub2, $sub3, PaginatorInterface $paginator, Request $request, $forceRoute=false){
  864.         $twigData = array();
  865.         $twigData['link'] = $request->getPathInfo();
  866.         // $order = "desc";
  867.         $order = null;
  868.         if ($request->get("order")) {
  869.           $order = $request->get("order");
  870.         }
  871.         $twigData['order']= $order;
  873.         // $sorting = "popularity";
  874.         $sorting = null;
  875.         if ($request->get("sorting")) {
  876.           $sorting = $request->get("sorting");
  877.         }
  878.         $twigData['sorting']= $sorting;
  880.         $twigData['selected'] = array(
  881.             'main' => $category->getId(),
  882.             'sub1' => $sub1,
  883.             'sub2' => $sub2,
  884.             'sub3' => $sub3
  885.         );
  887.         $twigData['noLoader'] = true;
  889.         $findCategory = false;
  891.         //Let's find the final category the product should be in
  892.         //We go 4 levels here
  893.         if($sub1){
  894.             foreach($category->getCategories() as $cat){
  895.                 if(strtolower($cat->getUrlName()) == strtolower(urldecode($sub1))){
  896.                     $twigData['selected']['sub1'] = $cat->getId();
  897.                     if($sub2){
  898.                         foreach($cat->getCategories() as $subCat){
  899.                             if(strtolower($subCat->getUrlName()) == strtolower(urldecode($sub2))){
  900.                                 $twigData['selected']['sub2'] = $subCat->getId();
  901.                                 if($sub3){
  902.                                     foreach($subCat->getCategories() as $subSubCat){
  903.                                         if(strtolower($subSubCat->getUrlName()) == strtolower(urldecode($sub3))){
  904.                                             $twigData['selected']['sub3'] = $subSubCat->getId();
  905.                                             $findCategory = $subSubCat;
  906.                                             break;
  907.                                         }
  908.                                     }
  909.                                 }else{
  910.                                     $findCategory = $subCat;
  911.                                     break;
  912.                                 }
  913.                             }
  914.                         }
  915.                     }else{
  916.                         $findCategory = $cat;
  917.                         break;
  918.                     }
  919.                 }
  920.             }
  921.         }
  922.         $filter = null;
  923.         if ($request->get('filter')){
  924.             $filter = $request->get('filter');
  925.         }
  926.        
  927.         //If all else fail let's go back to original cat
  928.         if(!$findCategory)
  929.             $findCategory = $category;
  930.        
  931.         $categoryPlacementQuery = $this->entityMana->getRepository(Category::class)->getMyCategoryforplacemnt($findCategory);
  932.         $productsQuery=[];
  933.         $allproductsSubSubcategories = [];
  934.         if (!$filter){
  935.         if ($sorting == null){
  936.             if (count($categoryPlacementQuery) > 0){
  937.                 $resproductsQueryultat = array();
  938.                     foreach ($categoryPlacementQuery as $orderPlacement) {
  939.                         $categories = $this->entityMana->getRepository(Category::class)->find($orderPlacement['cateId']);
  940.                         $findsubCategories = $categories->getSubCategory();
  941.                             $QueryTimeTwo = $this->entityMana->getRepository(Category::class)->getMyCategoryforplacemnt($categories);
  942.                             if(count($QueryTimeTwo) > 0){
  943.                                     foreach ($QueryTimeTwo as $findproduct) {
  944.                                         $catefindproduct = $this->entityMana->getRepository(Category::class)->find($findproduct['cateId']);
  945.                                         $prods = $this->entityMana->getRepository(Product::class)->getcategoriesByPlacement($catefindproduct, $sorting, $order);
  946.                                                 if(count($prods) > 0){
  947.                                                     foreach ($prods as $prod) {
  948.                                                         array_push($productsQuery, $prod);  
  949.                                                     }
  950.                                                 }else{
  951.                                                     $findsubsubCategories = $catefindproduct->getSubCategory();
  952.                                                     $allproductsSubSubcategories = $this->entityMana->getRepository(Product::class)->getcategoriesByPlacement($findsubsubCategories, $sorting, $order);
  953.                                                 }
  954.                                     }
  955.                             }
  956.                             // else{
  957.                             //     $allProductsifNoSubCategories = $this->entityMana->getRepository(Product::class)->getcategoriesByPlacement($findsubCategories, $sorting, $order);
  958.                                 // if($allProductsifNoSubCategories){
  959.                                 //     foreach ($allProductsifNoSubCategories as $allProductsifNoSubCategory) {
  960.                                 //         if (!in_array($allProductsifNoSubCategory,$productsQuery)){
  961.                                 //             array_push($productsQuery, $allProductsifNoSubCategory);
  962.                                 //         }   
  963.                                 //     }    
  964.                                 // }
  965.                             // }
  966.                             if($allproductsSubSubcategories){
  967.                                 foreach ($allproductsSubSubcategories as $allproductsSubSubcategory) {
  968.                                     
  969.                                     if (!in_array($allproductsSubSubcategory,$productsQuery)){
  970.                                         array_push($productsQuery, $allproductsSubSubcategory);
  971.                                     }   
  972.                                 }    
  973.                             }
  974.                     }
  975.             }else{
  976.                 $testcategories = $this->entityMana->getRepository(Product::class)->getcategoriesByPlacement($findCategory, $sorting, $order);
  977.                
  978.                 if($testcategories){
  979.                     foreach ($testcategories as $testcategorie) {
  980.                         array_push($productsQuery, $testcategorie);  
  981.                     }
  982.                 }
  983.             }
  984.             $categoryforPages = $this->entityMana->getRepository(Product::class)->getcategoriesByPlacement($findCategory, $sorting, $order);
  985.             if($categoryforPages){
  986.                 foreach ($categoryforPages as $categoryforPage) {
  987.                     
  988.                     if (!in_array($categoryforPage,$productsQuery)){
  989.                         array_push($productsQuery, $categoryforPage);
  990.                     }   
  991.                 }    
  992.             }
  993.         }else{
  994.             $productsQuery = $this->entityMana->getRepository(Product::class)->getcategoriesByPlacement($findCategory, $sorting, $order);
  995.         }
  996.     }else{
  997.         // $productsQuery = $this->entityMana->getRepository(Product::class)->getcategoriesByPlacement($findCategory, $sorting, $order);
  998.         
  999.             $region = explode('region_',$filter);
  1000.             if (count($region) > 1){
  1001.                 $regionName= $region[1];
  1002.                 $region = $this->entityMana->getRepository(Region::class)->findOneBy([ 'name' => $regionName ])->getId();
  1003.             }
  1005.             $productsQuery = $this->entityMana->getRepository(Product::class)->getcategoriesByPlacementWithFilter($findCategory, $sorting, $order, $filter, $region);
  1006.     }
  1008.         $page = 1;
  1009.         if(!empty($request->get('page')))
  1010.             $page = $request->get('page');
  1012.         if(is_numeric($page)){
  1013.             // Paginate the results of the query
  1014.             $twigData['products'] = $paginator->paginate(
  1015.             $productsQuery,
  1016.             $request->query->getInt('page', $page),
  1017.             24
  1018.         );
  1020.         if($forceRoute){
  1021.             $twigData['products']->setUsedRoute('viewCategory');
  1022.             $twigData['products']->setParam('name', $category->getUrlName());
  1023.             $twigData['products']->setParam('sub1', $sub1);
  1024.             $twigData['products']->setParam('sub2', $sub2);
  1025.             $twigData['products']->setParam('sub3', $sub3);
  1026.         }
  1028.         $twigData['productsAmount'] = $twigData['products']->getTotalItemCount();
  1030.         }else{
  1031.             $this->addFlash('error', "le numéro de la page n'est pas valide");
  1032.             return $this->redirectToRoute('viewCategory',[
  1033.                 'name' => $category->getUrlName(),
  1034.             ]);
  1035.         }
  1036.       
  1037.       
  1038.         $twigData['regions'] = $this->entityMana->getRepository(Region::class)->findBy(['province'=>'Qc']);
  1039.         $twigData['conservations'] = $this->entityMana->getRepository(Conservation::class)->findAll();
  1040.         $twigData['category'] = $findCategory;
  1041.         // dd($twigData);
  1042.         return $twigData;
  1043.     }
  1046.     /**
  1047.      * @route({
  1048.      *          "fr": "/vendeur/produit/editer/{id}",
  1049.      *          "en": "/seller/product/edit/{id}"
  1050.      *      },
  1051.      *      options = {
  1052.      *          "expose" = true
  1053.      *      },
  1054.      *      name="adminEditProduct")
  1055.      * @Template("admin/product/product.html.twig")
  1056.      * @Security("has_role('ROLE_ADMIN')")
  1057.      */
  1058.     public function editProduct(Request $request, UserService $userServ, ImageService $imageServ, ProductService $prodServ, Product $product=null, DistributorService $distributorServ){
  1059.         //Check if user is allowed to modify first
  1060.         if(!$prodServ->allowedToModify($product))
  1061.             die('Not allowed');
  1063.         if(empty($product)){
  1064.             $productId = $request->get('productId');
  1065.             $product = $prodServ->getProductById($productId);
  1066.             if(!$prodServ->allowedToModify($product))
  1067.                 die('Hummm.... No product access, hacking?');
  1068.         }
  1070.         if ($request->get("action") == "edit_product_variation") {
  1071.           return $this->redirect("/vendeur/produit/editer/".$request->get("product_id"));
  1072.         }
  1074.         if ($request->get("action") == "deactivate_product_variation") {
  1075.           $productVariation = $this->entityMana->getRepository(Product::class)->findOneBy([
  1076.             'id' => $request->get("product_id"),
  1077.           ]);
  1078.           if ($productVariation) {
  1079.             $productVariation->setAvailable(0);
  1080.             $this->entityMana->persist($productVariation);
  1081.             $this->entityMana->flush();
  1082.           }
  1083.           return $this->redirect("/vendeur/produit/editer/".$product->getId());
  1084.         }
  1086.         if ($request->get("action") == "deassign_variation") {
  1087.           $productVariation = $this->entityMana->getRepository(Product::class)->findOneBy([
  1088.             'id' => $request->get("product_id"),
  1089.           ]);
  1090.           if ($productVariation) {
  1091.             $productVariation->setParentProductId(null);
  1092.             $this->entityMana->persist($productVariation);
  1093.             $this->entityMana->flush();
  1094.           }
  1095.           return $this->redirect("/vendeur/produit/editer/".$product->getId());
  1096.         }
  1098.         if ($request->get("action") == "assign_this_product_to_parent") {
  1099.           $product->setParentProductId($request->get("product_id"));
  1100.           $this->entityMana->persist($product);
  1101.           $this->entityMana->flush();
  1102.           return $this->redirect("/vendeur/produit/editer/".$request->get("product_id"));
  1103.         }
  1105.         if ($request->get("action") == "generate_product_variation") {
  1106.           $company = $product->getCompany();
  1107.           $productVariation = new Product();
  1108.           $productVariation->setParentProductId($product->getId());
  1110.           $productVariation->setOrigName($product->getOrigName());
  1111.           $productVariation->setDeliveryType($product->getDeliveryType());
  1112.           $productVariation->setActionWhenExpired($product->getActionWhenExpired());
  1113.           $productVariation->setCategories($product->getCategories());
  1114.           $productVariation->setConservation($product->getConservation());
  1115.           $productVariation->setSubCategory($product->getSubCategory());
  1116.           $productVariation->setRegion($product->getRegion());
  1117.           $productVariation->setOrigBrandName($product->getOrigBrandName());
  1118.           $productVariation->setDescription($product->getDescription());
  1119.           $productVariation->setIngredients($product->getIngredients());
  1120.           $productVariation->setOrigin($product->getOrigin());
  1121.           $productVariation->setAvailable(1);
  1123.           $tags = $product->getTags();
  1124.           foreach($tags as $tag) {
  1125.             $productVariation->addTag($tag);
  1126.           }
  1128.           $sp = new Storage();
  1129.           $sp->addProduct($productVariation);
  1130.           $sp->setType("product");
  1131.           $this->entityMana->persist($sp);
  1133.           $sb = new Storage();
  1134.           $sb->addProduct($productVariation);
  1135.           $sb->setType("box");
  1136.           $this->entityMana->persist($sb);
  1138.           $ss = new Storage();
  1139.           $ss->addProduct($productVariation);
  1140.           $ss->setType("skid");
  1141.           $this->entityMana->persist($ss);
  1143.           $p = new Pricing();
  1144.           $p->setPrice("0.00");
  1145.           $p->setCurrency("CAD");
  1146.           $p->setStorage($sp);
  1147.           $p->setQuantity(1);
  1148.           $productVariation->addPricing($p);
  1150.           $productVariation->setCompany($company);
  1151.           $productVariation->setIsConsumer(true);
  1152.         //   $productVariation->setIsDisplayedInAssociationOnly(count($company->getAssociations())>0);
  1153.           $productVariation->setIsDisplayedInAssociationOnly(0);
  1155.           $this->entityMana->persist($productVariation);
  1156.           $this->entityMana->flush();
  1157.           return $this->redirect("/vendeur/produit/editer/".$product->getId());
  1158.         }
  1160.         $twigData = array();
  1161.         $twigData['productEntry']= true;
  1162.         $twigData['company'] = $product->getCompany();
  1163.         $twigData['product'] = $product;
  1164.         $companyProducts = $this->entityMana->getRepository(Product::class)->findBy([
  1165.           'company' => $product->getCompany(),
  1166.           'parentProductId' => null,
  1168.         ]);
  1169.         $twigData['companyProducts'] = $companyProducts;
  1170.         $twigData['parent'] = false;
  1171.         if ($product->getParentProductId()) {
  1172.           $productParent = $this->entityMana->getRepository(Product::class)->findOneBy([
  1173.             'id' => $product->getParentProductId(),
  1174.           ]);
  1175.           if ($productParent) {
  1176.             $twigData['parent'] = $productParent;
  1177.           }
  1178.         }
  1179.         $twigData['variations'] = [];
  1180.         $productVariations = $this->entityMana->getRepository(Product::class)->findBy([
  1181.           'parentProductId' => $product->getId(),
  1182.           'available' => 1
  1183.         ]);
  1184.         if ($productVariations) {
  1185.           $twigData['variations'] = $productVariations;
  1186.         }
  1188.         $twigData['editProduct'] = $product->getId();
  1190.         if(!$request->isXmlHttpRequest() && $product->getPricings()->count() < 1){
  1191.             $product->addPricing(new Pricing());
  1192.         }
  1194.         $twigData['pageTitle'] = 'Edition du produit '.$product->getName();
  1195.        
  1196.         $form = $this->createForm(ProductType::class, $product);
  1197.         $form->handleRequest($request);
  1198.         $twigData['addNewForm'] = $form->createView();
  1200.         if($request->isXmlHttpRequest()){
  1201.             //Ok let's save that new product
  1202.             $newProduct = $form->getData();
  1204.             // if ($newProduct->getAlimentsDuQuebec() == true){
  1205.             //     $findAlimentDuQuebec = $this->entityMana->getRepository(Certification::class)->findBy(['name' => 'Aliments du Québec']);
  1206.             //     $newProduct->setAlimentsDuQuebecCertification($findAlimentDuQuebec[0]->getId());
  1207.             // }
  1209.             $this->entityMana->persist($newProduct);
  1210.             $this->entityMana->flush();
  1212.             $this->saveDataFromForm($newProduct, $request, $imageServ, $userServ, true);
  1214.             //Let's update Solex if the product is already with them
  1215.             //if($_ENV['APP_ENV'] != 'dev'){
  1216.                 if($newProduct->isShippedByMaturin() && !empty($newProduct->getSolexId())){
  1217.                     $distributorServ->setProduct($newProduct);
  1218.                 }elseif($newProduct->isShippedByMaturin() && $newProduct->getIsJustInTime()){
  1219.                     $distributorServ->setProduct($newProduct);
  1220.                 }
  1221.             //}
  1223.             $response = new JsonResponse();
  1224.             $response->setData(array(
  1225.                 'success' => 1
  1226.             ));
  1228.             return $response;
  1229.         }
  1231.         return $twigData;
  1232.     }
  1234.     /**
  1235.      * @Route({
  1236.      *      "fr": "/livraison/priceDetail/ajax_search/{isFrozen}/{retailPrice}",
  1237.      *      "en": "/delivery/priceDetail/ajax_search/{isFrozen}/{retailPrice}"
  1238.      *      },
  1239.      *      name="priceDetailAJAXSearch"
  1240.      * )
  1241.      *@Security("has_role('ROLE_ADMIN')")
  1242.      */
  1243.     public function priceDetailAJAXSearch($isFrozen, $retailPrice,PaymentService $paymentService)
  1244.     {
  1245.         $result = [];
  1246.         $CommandPreparationfees = 1.10;
  1247.         $wrapingFees = 0.55;
  1248.         if ($isFrozen == 1) {
  1249.             $wrapingFees = 1.15;
  1250.         }
  1251.         $result['CommandPreparationfees'] = $CommandPreparationfees;
  1252.         $result['wrapingFees'] = $wrapingFees;
  1253.         if($retailPrice <= 6)
  1254.             $maturinPercentFees = round($retailPrice * 0.085, 2); //8.5%
  1255.         else
  1256.             $maturinPercentFees = round($retailPrice * 0.115, 2); //11.5%
  1257.         $result['maturinPercentFees'] = $maturinPercentFees;
  1258.         $creditPercentFees = round($retailPrice * 0.035, 2); //3.5%
  1259.         $result['creditPercentFees'] = $creditPercentFees;
  1260.         $fees = round($maturinPercentFees +  $creditPercentFees + $CommandPreparationfees + $wrapingFees, 2);
  1261.         $result['feesTotal'] = $fees;
  1262.         $totalTaxable = $fees;
  1263.         $totaltaxes = $paymentService->calculateTaxes($totalTaxable, "QC");
  1264.         $taxesToPay = round($totaltaxes['totalTax'], 2);
  1265.         $result['taxesToPay'] = $taxesToPay;
  1266.         $feesTotal = $fees + $taxesToPay;
  1267.         $amountReceived = round($retailPrice - $feesTotal, 2);
  1268.         $result['amountReceived'] = $amountReceived;
  1269.         $amountAfterTaxes = round($amountReceived +  $taxesToPay, 2);
  1270.         $result['amountAfterTaxes'] =  $retailPrice - $fees;
  1271.         $totalFees=($retailPrice - $amountAfterTaxes)/$retailPrice;
  1272.         $result['totalFees'] =$totalFees*100;
  1274.         $beneficeMarge = 1 - $totalFees;
  1275.         $result['beneficeMarge'] =  $beneficeMarge*100;
  1277.         $buyerCost = round($retailPrice / 0.92, 2); // 8% fees which the buyer see;
  1278.         $result['buyerCost'] = $buyerCost;
  1279.         die(json_encode(["results" => $result]));
  1280.     }
  1283.     /**
  1284.      * @route({
  1285.      *          "fr": "/vendeur/produit/nouveau/{id}/{cloneProductId}",
  1286.      *          "en": "/seller/product/new/{id}/{cloneProductId}"
  1287.      *      },
  1288.      *      options = {
  1289.      *          "expose" = true
  1290.      *      },
  1291.      *      defaults={
  1292.      *          "cloneProductId" = false,
  1293.      *          "id" = false
  1294.      *      },
  1295.      *      name="adminNewProduct")
  1296.      * @Security("has_role('ROLE_ADMIN')")
  1297.      * @Template("admin/product/product.html.twig")
  1298.      */
  1299.     public function newProduct(Request $request, UserService $userServ, ImageService $imageServ, Company $company=null, ProductService $ProductService, $cloneProductId, UrlGeneratorInterface $router, DistributorService $distributorServ){
  1300.         $twigData = array();
  1301.         $twigData['productEntry']= true;
  1303.         $user = $userServ->getUser();
  1304.         if(empty($company)){
  1305.             $companies = $user->getCompanies();
  1307.             if(count($companies) > 1){
  1308.                 $this->addFlash('error', "Vous avez plusieur boutiques, pour accéder au paiement utiliser le lien Info & Dépot dans le menu sous l'onglet 'Paramètre'");
  1309.                 return $this->redirectToRoute('dashboard');
  1310.             }else{
  1311.                 $company = $companies->get(0);
  1312.                 return $this->redirectToRoute('adminNewProduct', array('id' => $company->getId()));
  1313.             }
  1314.         }
  1316.         if(empty($company)){
  1317.             $this->addFlash('error', "Nous n'arrivons pas a trouver votre boutique, utiliser le lien Info & Dépot dans le menu sous l'onglet 'Paramètre'");
  1318.             return $this->redirectToRoute('dashboard');
  1319.         }
  1321.         if($cloneProductId){
  1322.             $cloneProduct = $ProductService->getProductById($cloneProductId);
  1323.             $cloneProduct->setMainImage(null);
  1324.             $product = clone $cloneProduct;
  1325.             //$product->purgeImages();
  1326.             //$product->purgeMainImage();
  1327.             $product->setNutritionFact(NULL);
  1328.             $product->setValidatedByDistributor(false);
  1329.             $product->setSolexId(null);
  1330.             $product->setQtyReadyToShip(0);
  1331.             $product->setId(NULL);
  1332.             // $product->setIsDisplayedInAssociationOnly($cloneProduct->getIsDisplayedInAssociationOnly());
  1333.             $product->setIsDisplayedInAssociationOnly(0);
  1334.             $product->purgeImages();
  1335.             //Clone subscriptions too
  1336.             if($cloneProduct->getIsSubscribable()){
  1337.                 $product->setIsSubscribable($cloneProduct->getIsSubscribable());
  1338.                 $product->setIsOnlySubscribable($cloneProduct->getIsOnlySubscribable());
  1339.                 $product->setIsOnlySubscribableToType($cloneProduct->getIsOnlySubscribableToType());
  1340.             }
  1341.         }else{
  1342.             $product = new Product();
  1343.             if(!$request->isXmlHttpRequest()){
  1344.                 $p = new Pricing();
  1345.                 $p->setQuantity(1);
  1346.                 $product->addPricing($p);
  1347.             }
  1348.             $product->setCompany($company);
  1349.             $product->setIsConsumer(true);
  1350.             // $product->setIsDisplayedInAssociationOnly(count($company->getAssociations())>0);
  1351.             $product->setIsDisplayedInAssociationOnly(0);
  1352.         }
  1354.         $twigData['product'] = $product;
  1356.         $form = $this->createForm(ProductType::class, $product);
  1358.         //Add the company if the user is part of that company
  1359.         if(!$userServ->getUser()->getCompanies()->contains($company) && !$userServ->isGod())
  1360.             die('Error, you arent suppose to see this. Reported');
  1362.         $twigData['company'] = $company;
  1364.         $form->handleRequest($request);
  1365.         $twigData['addNewForm'] = $form->createView();
  1367.         if($request->isXmlHttpRequest()){
  1368.             //Ok let's save that new product
  1369.             //$newProduct = $form->getData();
  1370.             $newProduct = $product;
  1372.             //Set the company
  1373.             $newProduct->setCompany($company);
  1375.             if(!empty($request->get('draft')))
  1376.                 $newProduct->setDraft(true);
  1378.             $this->entityMana->persist($newProduct);
  1379.             $this->entityMana->flush();
  1382.             $this->saveDataFromForm($newProduct, $request, $imageServ, $userServ);
  1384.             if(empty($request->get('draft'))){
  1385.                 if($newProduct->isShippedByMaturin() && !$newProduct->getIsJustInTime()){
  1386.                     //Product saved, let's send a notification
  1387.                     $urlInventory = $router->generate( 'replenishment', array ('_locale' => $userServ->getUser()->getLocale(), 'id' => $newProduct->getCompany()->getId()));
  1389.                     $userServ->addNotification('info', 'Mise en inventaire', 'Veuillez planifier un rendez-vous pour la mise en inventaire du produit '.$newProduct->getName().' <a href="'.$urlInventory.'">ici</a>');
  1390.                 }
  1391.                 if($newProduct->isShippedByMaturin() && $newProduct->getIsJustInTime()){
  1392.                     $distributorServ->setProduct($newProduct);
  1393.                 }
  1395.                 $response = new JsonResponse();
  1396.                 $response->setData(array(
  1397.                     'success' => 1
  1398.                 ));
  1400.                 return $response;
  1401.             }else{
  1402.                 //It's a draft
  1403.                 $response = new JsonResponse();
  1404.                 $response->setData(array(
  1405.                     'success' => 1,
  1406.                     'preview' => $this->generateUrl('viewProduct', array('producerUrl' => $newProduct->getCompany()->getUrlName(), 'productName' => $newProduct->getUrlName(), 'id' => $newProduct->getId()))
  1408.                 ));
  1410.                 return $response;
  1411.             }
  1412.         }
  1413.         return $twigData;
  1414.     }
  1416.     /*
  1417.      * @TODO move all this in the form instead
  1418.      */
  1419.     private function saveDataFromForm($newProduct, $request, $imageServ, $userServ, $edit=false){
  1421.         //Let's start by deleting the temporary images not needed
  1422.         $delImages = json_decode($request->get('imagesToDelete'));
  1423.         foreach($delImages as $delImage){
  1424.                 $imageServ->deleteImage($delImage, false, $newProduct);
  1425.         }
  1427.         //Let's build the Images for the new product
  1428.         $Images = json_decode($request->get('imagesAndDescriptions'));
  1429.         $order = 1;
  1430.         foreach($Images as $newImage){
  1431.             $image = $imageServ->getImage($newImage->id);
  1432.             if($image){
  1433.                 $image->setDescription($newImage->description);
  1434.                 $image->setDisplayOrder($order);
  1435.                 $image->setCategory('product');
  1436.                 $image->addProduct($newProduct);
  1438.                 $this->entityMana->persist($image);
  1440.                 if($order == 1)
  1441.                     $newProduct->setMainImage($image);
  1443.                 $order++;
  1444.             }
  1445.         }
  1446.         $this->entityMana->flush();
  1449.         //Erasing the pricing before saving them
  1450.         //Easier for editing right now
  1451.         if(!empty($request->get('prices'))){
  1453.             $pricings = $newProduct->getPricings();
  1454.             foreach($pricings as $pricing){
  1455.                 $newProduct->removePricing($pricing);
  1456.                 $this->entityMana->remove($pricing);
  1457.             }
  1458.             $this->entityMana->flush();
  1460.             //Building the pricing
  1461.             //Need to be incorporated in the Forms at some point
  1462.             $pricings = json_decode($request->get('prices'));
  1463.             foreach($pricings as $pricing){
  1464.                 $price = new Pricing();
  1466.                 $price->setCurrency('CAD');
  1467.                 $price->setPrice($pricing->price);
  1468.                 $price->addProduct($newProduct);
  1470.                 if(!empty($pricing->qty) && $this->userServ->isGod())
  1471.                     $price->setQuantity($pricing->qty);
  1472.                 else
  1473.                     $price->setQuantity(1);
  1475.                 /*
  1476.                  * Old code put at some point to bypass the code above
  1477.                  * forgot why it was removed or forced to 1
  1478.                  */
  1479.                 //$price->setQuantity(1);
  1480.                 $storage_found = false;
  1481.                 foreach($newProduct->getStorages() as $storage){
  1482.                     if($storage->getType() == $pricing->unit){
  1483.                         $storage_found = true;
  1484.                         $price->setStorage($storage);
  1485.                         break;
  1486.                     }
  1487.                 }
  1489.                 if (!$storage_found) {
  1490.                   $s = new Storage();
  1491.                   $s->setType($pricing->unit);
  1492.                   $s->setQuantityProduct(0);
  1493.                   $newProduct->addStorage($s);
  1494.                   $price->setStorage($s);
  1495.                 }
  1497.                 /*
  1498.                 if($pricing->unit == 'vrac' && !$vrac){
  1499.                     $s = new Storage();
  1500.                     $s->setType('vrac');
  1501.                     $s->setQuantityProduct(0);
  1502.                     $newProduct->addStorage($s);
  1504.                     $price->setStorage($s);
  1505.                 }
  1506.                  */
  1508.                 $this->entityMana->persist($price);
  1509.                 $newProduct->addPricing($price);
  1510.             }
  1511.         }
  1513.         //Building the tags
  1514.         $formTags = json_decode($request->get('tags'));
  1515.         $newTags = new ArrayCollection();
  1516.         foreach($formTags as $tag){
  1517.             $newTag = $this->entityMana->getRepository(Tag::class)->findOneByName($tag);
  1519.             //One with this name already exist in the database, let's link to that one
  1520.             if(empty($newTag)){
  1521.                 //This tag don't exist let's create
  1522.                 $newTag = new Tag();
  1523.                 $newTag->setName(trim($tag));
  1524.                 $newTag->setLocale($userServ->getUser()->getLocale());
  1525.                 $this->entityMana->persist($newTag);
  1526.             }
  1527.             $newProduct->addTag($newTag);
  1528.             $newTags[]=$newTag;
  1529.         }
  1531.         //For when editing we need to remove those not good too
  1532.         if(!empty($formTags)){
  1533.             foreach($newProduct->getTags() as $t){
  1534.                 if(!$newTags->contains($t))
  1535.                     $newProduct->removeTag($t);
  1536.             }
  1537.         }
  1539.         //Fix a weird bug with the Ajax category refresh
  1540.         if(!empty($_POST['product']['subCategory']) && is_numeric($_POST['product']['subCategory'])){
  1541.             $category = $this->entityMana->getRepository(category::class)->find($_POST['product']['subCategory']);
  1542.             $newProduct->setSubCategory($category);
  1543.         }
  1545.         //Fix a bug when switching from Independant shipping back to Maturin
  1546.         if($newProduct->isShippedByMaturin()){
  1547.             if($newProduct->getQtyReadyToShip() == 1)
  1548.                 $newProduct->setQtyReadyToShip(0);
  1549.         } else {
  1550.             $newProduct->setQtyReadyToShip(1);
  1551.         }
  1553.         // ugly fix
  1554.         if (!empty($_POST['product']['qtyReadyToShip']) && is_numeric($_POST['product']['qtyReadyToShip'])
  1555.             && ((int)$_POST['product']['qtyReadyToShip']) > 1){
  1556.             // product[qtyReadyToShip]
  1557.             $newProduct->setQtyReadyToShip((int)$_POST['product']['qtyReadyToShip']);
  1558.         }
  1560.         //End of saving the Ingredients
  1561.         $this->entityMana->persist($newProduct);
  1562.         $this->entityMana->flush();
  1563.     }
  1565.     /**
  1566.      * @route( "/vendeur/produits/update/{id}",
  1567.      *      name="adminUpdateProducts")
  1568.      */
  1569.     public function updateProducts(Company $company, DistributorService $distributorServ, Request $request){
  1571.         if($company->hasInventoryWithMaturin()){
  1572.             $distributorServ->updateProductsOf($company);
  1573.         }
  1575.         $this->addFlash('success', 'Mise a jour fait de '.$company->getName());
  1576.         $url = $_SERVER['HTTP_REFERER'];
  1577.         return $this->redirect($url, 301);
  1578.     }
  1580.     /**
  1581.      * @route({
  1582.      *          "fr": "/vendeur/produits/liste/{id}",
  1583.      *          "en": "/seller/product/list/{id}"
  1584.      *      },
  1585.      *      defaults = {
  1586.      *          "id" = false
  1587.      *      },
  1588.      *      options = { "expose" = true },
  1589.      *      name="adminListProducts")
  1590.      * @Template("admin/product/list.html.twig")
  1591.      */
  1592.     public function listProduct(ProductService $ProductService, EntityManagerInterface $em, Request $request, Company $company=null, DistributorService $distributorServ, UserService $userServ){
  1593.         $twigData = array();
  1595.         if(empty($company)){
  1596.             $user = $userServ->getUser();
  1597.             $companies = $user->getCompanies();
  1599.             if(count($companies) > 1){
  1600.                 $this->addFlash('error', "Vous avez plusieur boutiques, pour accéder a l'inventaire via le menu");
  1601.                 return $this->redirectToRoute('dashboard');
  1602.             }else{
  1603.                 $company = $companies->get(0);
  1604.             }
  1605.         }
  1607.         //@SECuritY
  1608.         if(!$this->companyServ->allowedToModify($company) || empty($company)){
  1609.             $this->addFlash('error', "Vous n'avez pas d'accès à cette boutique, veuillez utiliser le menu");
  1610.             return $this->redirectToRoute('dashboard');
  1611.         }
  1613.         /*
  1614.          * Conflict with the cart, when a sale occur the quantity change
  1615.          * If the producer check the list of product when a order was done but not shipped yet
  1616.          * The quantity will reset to the one in Inventory which can make a "sale" happen
  1617.          * as quantity is available again
  1618.          */
  1619.         if($company->hasInventoryWithMaturin()) 
  1620.             $distributorServ->updateProductsOf($company);
  1622.     $twigData['products'] = $em->getRepository(Product::class)
  1623.             ->findBy([
  1624.                 'company' => $company,
  1625.                 'draft' => false
  1626.             ] );
  1627.         $twigData['company']=$company;
  1629.                 // $dateExpirations = [];
  1630.                 // // dump($twigData['products']);
  1631.                 
  1632.                 //     for($i=0; $i < count($twigData['products']);$i++){
  1633.                 //         // dump($dateExpirations);
  1634.                 //         //if (in_array($twigData['products'][$i]->getOrigName(), $dateExpirations)){
  1635.                 //             // dump('nom existe');
  1636.                 //         //}else{
  1637.                 //             if(empty($dateExpirations)){
  1638.                 //                 $dateExpirations[] = [ 
  1639.                 //                     'id' => $twigData['products'][$i]->getId(),
  1640.                 //                     'origName' => $twigData['products'][$i]->getOrigName(),
  1641.                 //                     'expirationDate' =>$twigData['products'][$i]->getExpirationDate()
  1642.                 //                 ];
  1643.                 //             }else{
  1644.                 //                 if ($twigData['products'][$i]->getExpirationDate() < $twigData['products'][$i-1]->getExpirationDate()){
  1645.                 //                     $dateExpirations[] = [ 
  1646.                 //                         'id' => $twigData['products'][$i]->getId(),
  1647.                 //                         'origName' => $twigData['products'][$i]->getOrigName(),
  1648.                 //                         'expirationDate' =>$twigData['products'][$i]->getExpirationDate()
  1649.                 //                     ];
  1650.                 //                 }
  1651.                 //             //     dump($twigData['products'][$i]->getOrigName()) ;
  1652.                 //             //    dump($twigData['products'][$i]->getExpirationDate()) ;
  1653.                 //             }
  1654.                            
  1655.                 //         }
  1656.                 //     //}
  1657.                 //     $twigData['expirationDates'] = $dateExpirations;
  1658.          
  1659.                 
  1660.             
  1661.          
  1662.         return $twigData;
  1663.         
  1664.     }
  1669.     /**
  1670.      * @Route("/API/setProduct/{action}",
  1671.      *      options = { "expose" = true },
  1672.      *      name = "setProductByAction"
  1673.      * )
  1674.      *
  1675.      * @Security("has_role('ROLE_ADMIN')")
  1676.      *
  1677.      */
  1678.     public function setProductByActionFromAPI($action, Request $request, ProductService $productServ){
  1679.         $action = strtolower($action);
  1680.         $success = false;
  1682.         switch($action){
  1683.             case 'available':
  1684.                 $id = $request->get('id');
  1685.                 $available = $request->get('available');
  1686.                 $product = $productServ->getProductById($id);
  1687.                 if($productServ->allowedToModify($product)){
  1688.                     $product->setAvailable($available);
  1690.                     $this->entityMana->persist($product);
  1691.                     $this->entityMana->flush();
  1692.                     $success = true;
  1693.                 }
  1694.                 break;
  1695.             case 'delete':
  1696.                 $id = $request->get('id');
  1697.                 if($productServ->deleteProductById($id))
  1698.                     $success = true;
  1699.                 break;
  1700.         }
  1702.         $response = new jsonresponse();
  1703.         $response->setdata(array(
  1704.             'success' => $success
  1705.         ));
  1707.             return $response;
  1708.     }
  1710.     /**
  1711.      * @Route("/API/getProduct/{action}",
  1712.      *      options = { "expose" = true },
  1713.      *      name = "getProductByAction"
  1714.      * )
  1715.      *
  1716.      */
  1717.     public function getProductByActionFromAPI($action, Request $request, ProductService $productServ, PaginatorInterface $paginator, UserService $userServ, $forcedValues = false, $returnJSON = true){
  1719.         $action = strtolower($action);
  1720.         $success = false;
  1721.         $data = array();
  1723.         switch($action){
  1724.             case 'getcategories':
  1725.                 $id = $request->get('id');
  1726.                 $category = $this->entityMana->getRepository(Category::class)->findOneBy(['id' => $id]);
  1727.                 $subCategory = $this->entityMana->getRepository(Category::class)->getSubCategories($category, true);
  1729.                 if($subCategory){
  1730.                     $group = array();
  1731.                     foreach($subCategory as $sub){
  1732.                         $group[$sub->getSubcategory()->getName()][] = "<option value='".$sub->getId()."'>".$sub->getName()."</option>";
  1733.                     }
  1735.                     $data = '';
  1736.                     foreach($group as $key => $choice){
  1737.                         $data .= '<optgroup label="'.$key.'">'.implode('', $choice).'</optgroup>';
  1738.                     }
  1740.                     $success = true;
  1741.                 }
  1742.                 break;
  1743.             case 'getproductsbytokenpagination':
  1744.                 /*
  1745.                 $page = $request->get('page');
  1746.                 $token = $request->get('token');
  1747.                 $search = $this->entityMana->getRepository(UserSearch::class)->findOneBy(['token' => $token]);
  1748.                  */
  1749.                 if($search){
  1750.                     $forcedValues = array(
  1751.                         'page' => $page,
  1752.                         'filters' => $search->getRawFilters(),
  1753.                         'token' => $token
  1754.                     );
  1756.                     return $this->getProductByActionFromAPI($search->getSearch(), $request, $productServ, $paginator, $userServ, $forcedValues);
  1757.                 }
  1759.                 break;
  1760.             case 'getproductsbyfiltering':
  1761.                 $data = array(
  1762.                     'html' => '',
  1763.                     'amount' => '0'
  1764.                 );
  1765.                 $page = 1;
  1767.                 if($forcedValues){
  1768.                     $filters = json_decode($forcedValues['filters']);
  1769.                     $page = $forcedValues['page'];
  1770.                 }else
  1771.                     $filters = json_decode($request->get('filters'));
  1773.                 $filter['pricings']=array();
  1774.                 $filter['conservation']=array();
  1775.                 $filter['region']=array();
  1776.                 $filter['deliveryType']=array();
  1778.                 foreach($filters as $k => $f){
  1779.                     switch(strtolower($f->type)){
  1780.                         case 'aliment_quebec':
  1781.                             $filter['alimentsDuQuebec']=1;
  1782.                             break;
  1783.                         case 'prix_laureat':
  1784.                             $filter['isPrixLaureat']=1;
  1785.                             break;
  1786.                         case 'certification':
  1787.                             $filter['alimentsDuQuebecCertification']=$f->id;
  1788.                             break;
  1789.                         case "category":
  1790.                             $cat = $this->entityMana->getRepository(Category::class)->findOneBy(array('id' => $f->id));
  1791.                             if($cat){
  1792.                                 $products = $this->productServ->getProductsFromCategory($cat, false);
  1793.                             }
  1794.                             break;
  1795.                         case 'shipping':
  1796.                             $filter['DeliveryType'][] = $f->id;
  1797.                             break;
  1798.                         case "price":
  1799.                             $filter['pricings'][]=$f->id;
  1800.                             break;
  1801.                         case "region":
  1802.                             $filter['region'][]=$this->entityMana->getRepository(Region::class)->findOneBy(array('id' => $f->id));
  1803.                             break;
  1804.                         case "conservation":
  1805.                             $filter['conservation'][]=$this->entityMana->getRepository(Conservation::class)->findOneBy(array('id' => $f->id));
  1806.                             break;
  1807.                         case "page":
  1808.                             if(empty($forcedValues))
  1809.                                 $page = $f->id;
  1810.                             break;
  1811.                     }
  1812.                 }
  1814.                 //If no category and selecting at large
  1815.                 if(empty($products))
  1816.                     $products = $this->entityMana->getRepository(Product::class)->getBaseProductsForSearching();
  1819.                 $join = false;
  1820.                 foreach($filter as $k => $v){
  1821.                     if(!empty($v)){
  1822.                         if($k == 'pricings'){
  1823.                             $pricing = array();
  1825.                             foreach($v as $p){
  1826.                                 //Because of the multiple here, we need to do a query build
  1827.                                 //Let's not forget that Maturin has a 8% increase in price so this is why there is a double
  1828.                                 //query here
  1829.                                 switch($p){
  1830.                                     case '0';
  1831.                                         $now = new \DateTime();
  1832.                                         $products->setParameter('now', $now);
  1833.                                         $products->leftJoin('p.discountPricings', 'discount');
  1834.                                         $products->andWhere('discount.startDate <= :now');
  1835.                                         $products->andWhere('discount.endDate >= :now');
  1836.                                         $pricing[] = '(discount.isADiscount = 1)';
  1837.                                         break;
  1838.                                     case '10';
  1839.                                         $mPricing = 10 - (10 * 0.08);
  1840.                                         $pricing[] = '(pricing.price < 10 and p.DeliveryType = 1)';
  1841.                                         $pricing[] = '(pricing.price < '.$mPricing.' and p.DeliveryType = 0)';
  1842.                                         break;
  1843.                                     case '10-25';
  1844.                                         $minPricing = 10 - (10 * 0.08);
  1845.                                         $maxPricing = 25 - (25 * 0.08);
  1846.                                         $pricing[] = '(pricing.price >= 10 and pricing.price < 25 and p.DeliveryType=1)';
  1847.                                         $pricing[] = '(pricing.price >= '.$minPricing.' and pricing.price < '.$maxPricing.' and p.DeliveryType=0)';
  1848.                                         break;
  1849.                                     case '25-50';
  1850.                                         $minPricing = 25 - (25 * 0.08);
  1851.                                         $maxPricing = 50 - (50 * 0.08);
  1852.                                         $pricing[] = '(pricing.price >= 25 and pricing.price < 50 and p.DeliveryType=1)';
  1853.                                         $pricing[] = '(pricing.price >= '.$minPricing.' and pricing.price < '.$maxPricing.' and p.DeliveryType=0)';
  1854.                                         break;
  1855.                                     case '50';
  1856.                                         $maxPricing = 50 - (50 * 0.08);
  1857.                                         $pricing[] = '(pricing.price >= 50 and p.DeliveryType=1)';
  1858.                                         $pricing[] = '(pricing.price >= '.$maxPricing.' and p.DeliveryType=0)';
  1859.                                         break;
  1860.                                 }
  1861.                             }
  1862.                             if(!empty($pricing) && count($pricing) > 0){
  1863.                                 if(!$join){
  1864.                                     $products->leftJoin('p.pricings', 'pricing');
  1865.                                     $join = true;
  1866.                                 }
  1868.                                 if(count($pricing) == 1){
  1869.                                     $products->andWhere(current($pricing));
  1870.                                 }else{
  1871.                                     $query = implode(' OR ', $pricing);
  1872.                                     $products->andWhere($query);
  1873.                                 }
  1874.                             }
  1875.                         }else{
  1876.                             //If it's a array
  1877.                             if(is_array($v)){
  1878.                                 $products->andWhere("p.$k IN ( :filter_".$k.")");
  1879.                                 $products->setParameter('filter_'.$k, $v);
  1880.                             }else{
  1881.                                 $products->andWhere("p.$k = :filter_".$k);
  1882.                                 $products->setParameter('filter_'.$k, $v);
  1883.                             }
  1884.                         }
  1885.                     }
  1886.                 }
  1888.                 $paginatorProducts = false;
  1890.                 if(!empty($products)){
  1891.                     $products = $products->getQuery();
  1892.                     if(!$returnJSON)
  1893.                         return $products;
  1895.                     // Paginate the results of the query
  1896.                     $twigData['products'] = $paginator->paginate(
  1897.                         $products,
  1898.                         $request->query->getInt('page', $page),
  1899.                         24
  1900.                     );
  1901.                     $data['amount'] = $twigData['products']->getTotalItemCount();
  1903.                     $products = $products->getResult();
  1905.                     //Let's save the search for pagination and others
  1906.                     $twigData['ajax'] = true;
  1907.                     $twigData['masonryProducts'] = $products;
  1909.                     if(!$forcedValues){
  1910.                         $twigData['searchToken'] = uniqid();
  1911.                         $userServ->saveSearch($action, $data['amount'], 'adv', $twigData['searchToken'], $request->get('filters'));
  1912.                     }else{
  1913.                         $twigData['searchToken'] = $forcedValues['token'];
  1914.                     }
  1916.                     $data['html'] = $this
  1917.                         ->get('twig')
  1918.                         ->render('frontend/productMasonry.html.twig', $twigData);
  1920.                 }else{
  1921.                     $products = $this->entityMana->getRepository(Product::class)->getSalableProducts();
  1923.                     $data['html'] = $this
  1924.                         ->get('twig')
  1925.                         ->render('frontend/productMasonry.html.twig', array(
  1926.                             'masonryProducts' => $products,
  1927.                             'ajax' => true
  1928.                     ));
  1929.                 }
  1930.                 $success = true;
  1931.                 break;
  1932.         }
  1935.         $response = new jsonresponse();
  1937.         if($returnJSON){
  1938.             if(!empty($twigData['searchToken'])){
  1939.                 $response->setdata(array(
  1940.                     'success' => $success,
  1941.                     'data' => $data,
  1942.                     'token' => $twigData['searchToken']
  1943.                 ));
  1944.             }else{
  1945.                 $response->setdata(array(
  1946.                     'success' => $success,
  1947.                     'data' => $data,
  1948.                     'token' => ''
  1949.                 ));
  1950.             }
  1952.             return $response;
  1953.         }else{
  1954.             return $rawResults;
  1955.         }
  1956.     }
  1957. }