src/Controller/GestionComerciale/BonPreparationController.php line 1104

Open in your IDE?
  1. <?php
  3. namespace App\Controller\GestionComerciale;
  5. use App\Entity\Articles\Article;
  6. use App\Entity\Clients\Client;
  7. use App\Entity\FO\Societe;
  8. use App\Entity\GestionComerciale\ArticleCommande;
  9. use App\Entity\GestionComerciale\BonPreparation;
  10. use App\Entity\GestionComerciale\Commande;
  11. use App\Entity\GestionComerciale\CommandeFournisseur;
  12. use App\Entity\GestionComerciale\StatutCommande;
  13. use App\Model\GestionCommerciale\TypeDocumentCommercial;
  14. use App\Form\GestionComerciale\BonPreparationType;
  15. use App\Form\GestionComerciale\CommandeType;
  16. use App\Library\Datatable\Util\Datatable;
  17. use App\Security\Voter\EntityVoter;
  18. use App\Service\GestionComerciale\AcompteService;
  19. use App\Service\GestionComerciale\BonLivraisonService;
  20. use App\Service\GestionComerciale\BonPreparationService;
  21. use App\Service\GestionComerciale\CommandeService;
  22. use App\Service\Utilisateur\ColonneTableauService;
  23. use Doctrine\ORM\EntityManagerInterface;
  24. use Knp\Snappy\Pdf;
  25. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  26. use Symfony\Component\HttpFoundation\Request;
  27. use Symfony\Component\HttpFoundation\JsonResponse;
  28. use Symfony\Component\HttpFoundation\Response;
  29. use Symfony\Component\Routing\Annotation\Route;
  30. use Symfony\Component\Validator\Validator\ValidatorInterface;
  31. use Symfony\Contracts\Translation\TranslatorInterface;
  33. class BonPreparationController extends AbstractController
  34. {
  37.     /**
  38.      * @Route("/vente/bons-preparations/nouveau/{id}/{type}", name="dtc_bon_preparation_ajouter")
  39.      */
  40.     public function ajouterAction(Request            $request, $id, $type = "", EntityManagerInterface $em, BonPreparationService $bonPreparationService, TranslatorInterface $translator,
  41.                                   ValidatorInterface $validator
  42.     ) {
  43.         $titre_modal   = $translator->trans("Nouveau bon de préparation");
  44.         $forceQteDispo = $request->query->get('forceQteDispo');
  45.         $repo_objet    = $em->getRepository(Commande::class);
  46.         $objet         = $repo_objet->find($id);
  48.         $bonPrepa = clone $objet;
  49.         $bonPrepa->setDateBon(new \Datetime);
  50.         $bonPrepa->setDate(new \Datetime);
  52.         $user = $this->getUser();
  53.         //$bonPrepa->setUtilisateur($user);
  54.         if (is_object($bonPrepa->getUtilisateur()) && ! empty($this->getParameter('utilisateur_site_internet')) && $bonPrepa->getUtilisateur()->getId(
  55.             ) == $this->getParameter('utilisateur_site_internet')) {
  56.         } else {
  57.             //$bonPrepa->setUtilisateur($user);
  58.         }
  60.         $bonPrepa->setModifiable(false);
  61.         $form   = $this->createForm(BonPreparationType::class, $bonPrepa);
  62.         $errors = "";
  63.         $form->handleRequest($request);
  65.         $idsArticleCommande = $request->query->get('choixArticles');
  66.         $repo_objet         = $em->getRepository(Commande::class);
  67.         $objet              = $repo_objet->find($id);
  68.         $bonPrepa->setCommande($objet);
  70.         $link = $this->generateUrl('dtc_bon_preparation_ajouter', ['id' => $objet->getId(), 'type' => 'commande']);
  71.         //$articleCommande = $em->getRepository(ArticleCommande::class)->listeArticleCommandeSelectionne($idsArticleCommande);
  72.         $articleCommande = $objet->getArticleCommande();
  74.         if ($form->isSubmitted()) {
  75.             if ($form->isValid()) {
  78.                 /*$articles = array('idArticleCommande'=>$request->request->get('idArticleCommande'),'quantiteInit'=>$request->request->get('quantiteInit'),'quantite'=>$request->request->get('quantite'));
  79.                 $valeurs = array("articles"=>$articles);
  80.                 $bonPreparationService->sauvegarder($bonPrepa,$valeurs);
  81.                 */
  83.                 $em->persist($bonPrepa);
  84.                 $em->flush();
  85.                 $em->refresh($bonPrepa);
  87.                 $operation = $request->request->get('operation');
  88.                 $articles  = [
  89.                     'valider'                  => $request->request->get('valider'),
  90.                     'ids'                      => $request->request->get('ids'),
  91.                     'idArticleCommande'        => $request->request->get('idArticleCommande'),
  92.                     'idArticleCommandeOrigine' => $request->request->get('idArticleCommandeOrigine'),
  93.                     'montantRemise'            => $request->request->get('montantRemise'),
  94.                     'remiseCalcule'            => $request->request->get('remiseCalcule'),
  95.                     'remise'                   => $request->request->get('remise'),
  96.                     'commentaire'              => $request->request->get('commentaire'),
  97.                     'commentairePrive'         => $request->request->get('commentairePrive'),
  98.                     'remiseSuppl'              => $request->request->get('remiseSuppl'),
  99.                     'ecocontribution'          => $request->request->get('ecocontribution'),
  100.                     'prix'                     => $request->request->get('prix'),
  101.                     //'fraisPortLigne'=>$request->request->get('fraisPortLigne'),
  102.                     'libellesSecondaires'      => $request->request->get('libellesSecondaires'),
  103.                     'libelles'                 => $request->request->get('libelles'),
  104.                     'tva'                      => $request->request->get('tva'),
  105.                     'qte'                      => $request->request->get('qte'),
  106.                     'force'                    => $request->request->get('force'),
  107.                     'commentaireSuppl'         => $request->request->get('commentaireSuppl'),
  108.                     'emplacement'              => $request->request->get('emplacement'),
  109.                     'nbEmplacement'            => $request->request->get('nbEmplacement'),
  110.                     'position'                 => $request->request->get('position'),
  111.                     'articlesCommandeRepris'   => $request->request->get('articlesCommandeRepris'),
  112.                     'qteDispo'                 => $request->request->get('qteDispo'),
  113.                     'transporteurs'            => $request->request->get('transporteurs'),
  114.                     'articlesCommandeAssocies' => $request->request->get('articlesCommandeAssocies'),
  115.                 ];
  117.                 $valeurs = ["articles" => $articles, 'typeDocument' => 'commande', 'operation' => 'commande', 'action' => 'nouveau'];
  120.                 $bonPreparationService->sauvegarderBon($bonPrepa, $valeurs);
  122.                 //print_r($valeurs);
  125.                 $url = $this->generateUrl('dtc_bon_preparation_modifier', ['id' => $bonPrepa->getId(), 'tab' => '', 'forceQteDispo' => true]);
  126.                 $this->addFlash(
  127.                     'notice',
  128.                     $translator->trans('Bon de préparation ajouté avec succès !')
  129.                 );
  131.                 return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url]);
  133.             } else {
  134.                 $errors = $validator->validate($bonPrepa);
  135.                 $rendu  = $this->renderView(
  136.                     'GestionComerciale/BonPreparation/ajouter.html.twig',
  137.                     [
  138.                         'form'               => $form->createView(),
  139.                         'errors'             => $errors,
  140.                         'id'                 => $id,
  141.                         'type'               => $type,
  142.                         'articleCommande'    => $articleCommande,
  143.                         'commande'           => $objet,
  144.                         'idsArticleCommande' => $idsArticleCommande,
  145.                     ]
  146.                 );
  148.                 return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  149.             }
  150.         }
  151.         $rendu = $this->renderView(
  152.             'GestionComerciale/BonPreparation/ajouter.html.twig',
  153.             [
  154.                 'form'               => $form->createView(),
  155.                 'errors'             => $errors,
  156.                 'id'                 => $id,
  157.                 'type'               => $type,
  158.                 'articleCommande'    => $articleCommande,
  159.                 'commande'           => $objet,
  160.                 'idsArticleCommande' => $idsArticleCommande,
  161.                 'forceQteDispo'      => $forceQteDispo,
  162.             ]
  163.         );
  165.         return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'link' => $link, 'titre' => $titre_modal]);
  166.     }
  169.     /**
  170.      * @Route("/vente/bons-preparations/modifier/{id}", name="dtc_bon_preparation_modifier")
  171.      */
  172.     public function modifierAction(Request         $request, Commande $bon, EntityManagerInterface $em, BonPreparationService $bonService,
  173.                                    CommandeService $commandeService, AcompteService $serviceAcompte, TranslatorInterface $translator, ValidatorInterface $validator
  174.     ) {
  177.         $user = $this->getUser();
  178.         //$bon->setUtilisateur($user);
  179.         if (is_object($bon->getUtilisateur()) && ! empty($this->getParameter('utilisateur_site_internet')) && $bon->getUtilisateur()->getId() == $this->getParameter(
  180.                 'utilisateur_site_internet'
  181.             )) {
  182.         } else {
  183.             $bon->setUtilisateur($user);
  184.         }
  185.         $forceQteDispo = $request->query->get('forceQteDispo');
  186.         //print_r($request->request->get('ids'));
  187.         $annuler     = $request->request->get('annuler');
  188.         $sauvegarder = true;
  190.         $statutCommande = $bon->getStatutCommande();
  191.         if (is_object($statutCommande) && ! in_array($statutCommande->getOrdre(), [1])) {
  192.             //à préparer
  193.             $annuler     = '';
  194.             $sauvegarder = false;
  195.         }
  197.         if ($annuler == "annuler" /*|| $annuler == "annuler_devis" || $annuler == "annuler_cmde"*/) {
  198.             $remboursement = 0;
  199.             $bonService->annuler($bon, $annuler);
  201.             if ($bon->getCommande()->getStatutCommande()->getOrdre() == "0") {
  202.                 $remboursement = $serviceAcompte->proposerRemboursement($bon->getClient());
  203.             }
  204.             $this->addFlash('notice', $translator->trans('Bon de préparation annulé avec succès !'));
  206.             return $this->redirectToRoute('dtc_commande_modifier', ["id" => $bon->getCommande()->getId(), "r" => $remboursement, "c" => $bon->getClient()->getId()]);
  207.             //return $this->redirectToRoute('dtc_bon_preparation_liste',array("r"=>$remboursement,"c"=>$bon->getClient()->getId()));
  208.             exit;
  209.         }
  210.         //if($annuler == "annuler_devis" && $bon->getdevis() != NULL) {
  211.         if ($annuler == "annuler_devis") {
  213.             $remboursement = 0;
  214.             $bonService->annuler($bon, $annuler);
  216.             if ($bon->getCommande()->getStatutCommande()->getOrdre() == "0") {
  217.                 $remboursement = $serviceAcompte->proposerRemboursement($bon->getClient());
  218.             }
  220.             $this->addFlash('notice', $translator->trans('Bon de préparation annulé avec succès !'));
  223.             if (count($bon->getCommande()->getArticleCommande()) > 0) {
  224.                 return $this->redirectToRoute('dtc_commande_modifier', ["id" => $bon->getCommande()->getId(), "r" => $remboursement, "c" => $bon->getClient()->getId()]);
  225.             } else {
  226.                 //return $this->redirectToRoute('dtc_devis_modifier',array("id"=>$bon->getdevis()->getId(),"r"=>$remboursement,"c"=>$bon->getClient()->getId()));
  227.                 return $this->redirectToRoute('dtc_commande_liste', ["r" => $remboursement, "c" => $bon->getClient()->getId()]);
  228.             }
  230.         }
  232.         if ($annuler == "annuler_cmde") {
  233.             $remboursement = 0;
  234.             $bonService->annuler($bon, $annuler);
  236.             if ($bon->getCommande()->getStatutCommande()->getOrdre() == "0") {
  237.                 $remboursement = $serviceAcompte->proposerRemboursement($bon->getClient());
  238.             }
  240.             $this->addFlash('notice', $translator->trans('Bon de préparation annulé avec succès !'));
  242.             $donnees = ["id" => $bon->getCommande()->getId(), "r" => $remboursement];
  243.             if (is_object($bon->getClient())) {
  244.                 $donnees['c'] = $bon->getClient()->getId();
  245.             }
  247.             return $this->redirectToRoute('dtc_commande_modifier', $donnees);
  248.         }
  250.         $form = $this->createForm(CommandeType::class, $bon);
  252.         $articles = ['ids' => $request->request->get('ids'), 'prix' => $request->request->get('prix'), 'qte' => $request->request->get('qte')];
  253.         $valeurs  = ["articles" => $articles];
  256.         $errors = "";
  257.         $form->handleRequest($request);
  258.         if ($form->isSubmitted() and $annuler != "annuler" and $annuler != "annuler_devis" and $annuler != "annuler_cmde") {
  260.             if ( ! $sauvegarder) {
  261.                 $this->addFlash('warning', $translator->trans('Le statut de commande actuel ne permet pas cette action!'));
  263.                 return $this->redirectToRoute('dtc_commande_modifier', ["id" => $bon->getId()]);
  264.             } elseif ($commandeService->estEditable($bon)) {
  266.                 // TODO CHANGE THIS
  267.                 $droit = $this->isGranted(EntityVoter::UPDATE, BonPreparation::class);
  269.                 if ( ! $droit) {
  270.                     return $this->redirectToRoute('dtc_bon_preparation_modifier', ["id" => $bon->getId()]);
  271.                 }
  273.                 if ($form->isValid()) {
  275.                     /*
  276.                     if($request->request->get('annuler') != '') {
  277.                         $bonService->annulerCommande($bon);
  278.                         $this->addFlash(
  279.                              'notice',
  280.                             $translator->trans('Bon de préparation annulée avec succès !')
  281.                          );
  282.                         return $this->redirectToRoute('dtc_bon_preparation_liste',array());
  283.                     }
  284.                     */
  286.                     //echo "<div>CC ".$bon->getClient()->getNom()."</div>";
  288.                     $em->persist($bon);
  289.                     $em->flush();
  291.                     $operation = $request->request->get('operation');
  292.                     $articles  = [
  293.                         'valider'                  => $request->request->get('valider'),
  294.                         'ids'                      => $request->request->get('ids'),
  295.                         'idArticleCommande'        => $request->request->get('idArticleCommande'),
  296.                         'idArticleCommandeOrigine' => $request->request->get('idArticleCommandeOrigine'),
  297.                         'montantRemise'            => $request->request->get('montantRemise'),
  298.                         'remiseCalcule'            => $request->request->get('remiseCalcule'),
  299.                         'remise'                   => $request->request->get('remise'),
  300.                         'commentaire'              => $request->request->get('commentaire'),
  301.                         'commentairePrive'         => $request->request->get('commentairePrive'),
  302.                         'remiseSuppl'              => $request->request->get('remiseSuppl'),
  303.                         'ecocontribution'          => $request->request->get('ecocontribution'),
  304.                         'prix'                     => $request->request->get('prix'),
  305.                         //'fraisPortLigne'=>$request->request->get('fraisPortLigne'),
  306.                         'libellesSecondaires'      => $request->request->get('libellesSecondaires'),
  307.                         'libelles'                 => $request->request->get('libelles'),
  308.                         'tva'                      => $request->request->get('tva'),
  309.                         'qte'                      => $request->request->get('qte'),
  310.                         'force'                    => $request->request->get('force'),
  311.                         'commentaireSuppl'         => $request->request->get('commentaireSuppl'),
  312.                         'emplacement'              => $request->request->get('emplacement'),
  313.                         'emplacement_nouveau'      => $request->request->get('emplacement_nouveau'),
  314.                         'nbEmplacement'            => $request->request->get('nbEmplacement'),
  315.                         'numero_serie'             => $request->request->get('numero_serie'),
  316.                         'duree_garantie'           => $request->request->get('duree_garantie'),
  317.                         'position'                 => $request->request->get('position'),
  318.                         'articlesCommandeRepris'   => $request->request->get('articlesCommandeRepris'),
  319.                         'qteDispo'                 => $request->request->get('qteDispo'),
  320.                         'transporteurs'            => $request->request->get('transporteurs'),
  321.                         'articlesCommandeAssocies' => $request->request->get('articlesCommandeAssocies'),
  323.                         'societe_livraison_txt'     => $request->request->get('societe_livraison_txt'),
  324.                         'numero_livraison_txt'      => $request->request->get('numero_livraison_txt'),
  325.                         'rue_livraison_txt'         => $request->request->get('rue_livraison_txt'),
  326.                         'complement_livraison_txt'  => $request->request->get('complement_livraison_txt'),
  327.                         'complement2_livraison_txt' => $request->request->get('complement2_livraison_txt'),
  328.                         'cp_livraison_txt'          => $request->request->get('cp_livraison_txt'),
  329.                         'ville_livraison_txt'       => $request->request->get('ville_livraison_txt'),
  330.                         'pays_livraison_txt'        => $request->request->get('pays_livraison_txt'),
  333.                         'societe_facturation_txt'     => $request->request->get('societe_facturation_txt'),
  334.                         'numero_facturation_txt'      => $request->request->get('numero_facturation_txt'),
  335.                         'rue_facturation_txt'         => $request->request->get('rue_facturation_txt'),
  336.                         'complement_facturation_txt'  => $request->request->get('complement_facturation_txt'),
  337.                         'complement2_facturation_txt' => $request->request->get('complement2_facturation_txt'),
  338.                         'cp_facturation_txt'          => $request->request->get('cp_facturation_txt'),
  339.                         'ville_facturation_txt'       => $request->request->get('ville_facturation_txt'),
  340.                         'pays_facturation_txt'        => $request->request->get('pays_facturation_txt'),
  343.                     ];
  345.                     $valeurs = ["articles" => $articles, 'typeDocument' => 'commande', 'operation' => $operation, 'action' => 'modifier'];
  346.                     $bonService->sauvegarderBon($bon, $valeurs);
  349.                     //$donnees = array("numeros"=>$request->request->get('numero_serie'),"duree"=>$request->request->get('duree_garantie'));
  350.                     //$bonService->sauvegarderNumeroSerie($bon,$donnees);
  352.                     if ($operation == "facture") {
  354.                         $this->addFlash('notice', $translator->trans('Facture sauvegardée avec succès !'));
  355.                         $repo_statut_document = $em->getRepository(StatutCommande::class);
  356.                         //$liste_statut = $repo_statut_document->findOneBy(array("documentCommercial"=>6,"ordre"=>array(1)));
  357.                         $liste_statut = $repo_statut_document->findById([19, 21, 22]);
  359.                         //$typesFac = $em->getRepository(TypeDocumentCommercial::class)->findById([6, 7]);
  361.                         $typesFac = [TypeDocumentCommercial::FACTURE,TypeDocumentCommercial::AVOIR];
  363.                         $repo_fac = $em->getRepository(Commande::class);
  365.                         $facture = $repo_fac->findBy(["bp" => $bon, "typeDocumentCommercial" => $typesFac, "visible" => 1], ['id' => 'DESC'], 1, 0);
  367.                         $temp_type_document_commercial = "";
  368.                         foreach ($facture as $f) {
  369.                             $temp_id_fac                   = $f->getId();
  370.                             $temp_type_document_commercial = $f->getTypeDocumentCommercial();
  371.                         }
  373.                         if (is_object($temp_type_document_commercial) && $temp_type_document_commercial->getId() == 6) {
  374.                             return $this->redirectToRoute('dtc_facture_afficher', ["id" => $temp_id_fac]);
  375.                         } else {
  376.                             return $this->redirectToRoute('dtc_avoir_modifier', ["id" => $temp_id_fac]);
  377.                         }
  379.                     } else {
  380.                         $this->addFlash('notice', $translator->trans('Bon de préparation sauvegardé avec succès !'));
  381.                         $commandeService->creerHistorique($bon, 2);
  383.                         return $this->redirectToRoute('dtc_bon_preparation_modifier', ["id" => $bon->getId(), 'forceQteDispo' => true]);
  384.                     }
  385.                 } else {
  386.                     $errors = $validator->validate($bon);
  387.                     //\Doctrine\Common\Util\Debug::dump($errors);
  388.                 }
  389.             } else {
  390.                 $paiement = $bon->getStatutPaiement();
  391.                 $em->refresh($bon);
  392.                 $bon->setStatutPaiement($paiement);
  393.                 $em->persist($bon);
  394.                 $em->flush();
  395.                 $this->addFlash('notice', $translator->trans('Statut du paiement de la commande modifié avec succès !'));
  397.                 /*
  398.                 $this->addFlash(
  399.                     'warning',
  400.                     "La commande n'est plus éditable ! "
  401.                 );
  402.                 */
  404.                 return $this->redirectToRoute('dtc_commande_modifier', ["id" => $bon->getId()]);
  406.             }
  407.         }
  409.         return $this->render(
  410.             'GestionComerciale/BonPreparation/modifier2.html.twig',
  411.             ['form' => $form->createView(), 'errors' => $errors, 'commande' => $bon, 'forceQteDispo' => $forceQteDispo]
  412.         );
  414.     }
  418.     /*
  419.     public function modifierAction(Request $request, Commande $bon, EntityManagerInterface $em, TranslatorInterface $translator, ValidatorInterface $validator) {
  422.         $request = $request;
  423.         $bon->setDateExpedition(new \Datetime);
  424.         $form = $this->createForm(new BonPreparationModifierType($em), $bon);
  425.         $validator = $validator;
  426.         $errors = "";
  427.         $form->handleRequest($request);
  429.         if ($form->isSubmitted()) {
  430.             if ($form->isValid()) {
  432.                 $bonPreparationService = $this->container->get('dtc.bonpreparation');
  433.                 $donnees = array("numeros"=>$request->request->get('numero_serie'),"duree"=>$request->request->get('duree_garantie'));
  434.                 $bonPreparationService->sauvegarderNumeroSerie($bon,$donnees);
  436.                 $statutService = $this->container->get('dtc.statutcommande');
  437.                 $mvmtStockService = $this->container->get('dtc.mvtstock');
  438.                 $statutService->actionSurCommande($bon,$bon->getStatutCommande());
  439.                 $mvmtStockService->destockerArticleExpedie($bon,$bon->getStatutCommande());
  441.                 $this->addFlash(
  442.                         'notice',
  443.                        $translator->trans('Bon de préparation modifié avec succès !')
  444.                 );
  445.             }
  446.             else {
  447.                 $this->addFlash(
  448.                     'warning',
  449.                    $translator->trans("Une erreur est survenue !")
  450.                 );
  451.             }
  452.         }
  455.         return $this->render('GestionComerciale/BonPreparation/modifier2.html.twig', array('form' => $form->createView(),'errors'=>$errors,'bon'=>$bon));
  456.     }
  457.     */
  460.     /**
  461.      * @Route("/vente/bons-preparations", name="dtc_bon_preparation_liste")
  462.      */
  463.     public function listerAction(Request               $request, $id = "0", $type = "a", EntityManagerInterface $em, Datatable $datatable, TranslatorInterface $translator,
  464.                                  ColonneTableauService $serviceColonneTableau
  465.     ) {
  466.         $param = $request->query->all();
  468.         $repo_objet = $em->getRepository(Commande::class);
  469.         $objet      = $repo_objet->find($id);
  472.         if ($type == "commandeFournisseurBp") {
  473.             $repo_objet = $em->getRepository(CommandeFournisseur::class);
  474.             $objet      = $repo_objet->find($id);
  475.             $this->datatableCommandeFournisseurBp($objet, "", $em, $datatable, $translator);
  477.             return $this->render('GestionComerciale/BonPreparation/lister_commande_fournisseur_bp.html.twig', ["id" => $id]);
  478.         } elseif ($type == "commandeFournisseur") {
  479.             $repo_objet = $em->getRepository(CommandeFournisseur::class);
  480.             $objet      = $repo_objet->find($id);
  481.             $this->datatableCommandeFournisseur($objet, "", $em, $datatable, $translator);
  483.             return $this->render('GestionComerciale/BonPreparation/lister_commande_fournisseur.html.twig', ["id" => $id]);
  484.         } elseif (is_object($objet)) {
  487.             $tableau_class_cellule[] = ["className" => "visible_export colonne_id text-center", "targets" => [0], "visible" => true];
  488.             $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [1], "visible" => true];
  489.             $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [2], "visible" => true];
  490.             $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [3], "visible" => true];
  491.             $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [4], "visible" => true];
  492.             $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [5], "visible" => true];
  493.             $tableau_class_cellule[] = ["className" => "visible_export colonne_id ", "targets" => [6], "visible" => true];
  494.             $tableau_class_cellule[] = ["className" => "visible_export colonne_id text-center", "targets" => [7], "visible" => true];
  495.             $tableau_class_cellule[] = ["orderable" => false, "className" => "colonne_id", "targets" => [8], "visible" => true];
  497.             $repo_objet = $em->getRepository(Commande::class);
  498.             $objet      = $repo_objet->find($id);
  500.             $this->datatableCommande($objet, $type, $em, $datatable, $translator);
  502.             return $this->render(
  503.                 'GestionComerciale/BonPreparation/lister_commande.html.twig',
  504.                 ['tableauClassColonne' => $tableau_class_cellule, "id" => $id, "type" => $type, 'parametres' => $param,]
  505.             );
  506.         } else {
  507.             $tableau_class_cellule[] = ["className" => "colonne_id", "targets" => [0], "visible" => false, "orderable" => false];
  509.             $tableau_class_cellule[] = [
  510.                 "className" => "visible_export colonne_id",
  511.                 "targets"   => [1],
  512.                 "visible"   => $serviceColonneTableau->getColonneUtilisateur(BonPreparation::class, "id"),
  513.             ];
  514.             $tableau_class_cellule[] = [
  515.                 "className" => "visible_export colonne_id text-center",
  516.                 "targets"   => [2],
  517.                 "visible"   => $serviceColonneTableau->getColonneUtilisateur(BonPreparation::class, "date"),
  518.             ];
  519.             $tableau_class_cellule[] = [
  520.                 "className" => "visible_export colonne_id",
  521.                 "targets"   => [3],
  522.                 "visible"   => $serviceColonneTableau->getColonneUtilisateur(BonPreparation::class, "reference"),
  523.             ];
  524.             $tableau_class_cellule[] = [
  525.                 "className" => "visible_export colonne_id",
  526.                 "targets"   => [4],
  527.                 "visible"   => $serviceColonneTableau->getColonneUtilisateur(BonPreparation::class, "refclient"),
  528.             ];
  529.             $tableau_class_cellule[] = [
  530.                 "className" => "visible_export colonne_id",
  531.                 "targets"   => [5],
  532.                 "visible"   => $serviceColonneTableau->getColonneUtilisateur(BonPreparation::class, "client"),
  533.             ];
  534.             $tableau_class_cellule[] = [
  535.                 "className" => "visible_export colonne_id",
  536.                 "targets"   => [6],
  537.                 "visible"   => $serviceColonneTableau->getColonneUtilisateur(BonPreparation::class, "equipier"),
  538.             ];
  539.             $tableau_class_cellule[] = [
  540.                 "className" => "visible_export colonne_id",
  541.                 "targets"   => [7],
  542.                 "visible"   => $serviceColonneTableau->getColonneUtilisateur(BonPreparation::class, "commentaire"),
  543.             ];
  545.             $tableau_class_cellule[] = [
  546.                 "className" => "visible_export colonne_id",
  547.                 "targets"   => [8],
  548.                 "visible"   => $serviceColonneTableau->getColonneUtilisateur(BonPreparation::class, "refCli"),
  549.             ];
  550.             $tableau_class_cellule[] = [
  551.                 "className" => "visible_export colonne_id text-center",
  552.                 "targets"   => [9],
  553.                 "visible"   => $serviceColonneTableau->getColonneUtilisateur(BonPreparation::class, "dateBon"),
  554.             ];
  556.             $tableau_class_cellule[] = ["orderable" => false, "className" => "colonne_id", "targets" => [10], "visible" => true];
  557.             $this->datatable($request, $em, $datatable, $translator);
  559.             return $this->render(
  560.                 'GestionComerciale/BonPreparation/lister.html.twig',
  561.                 ["id" => $id, "type" => $type, 'tableauClassColonne' => $tableau_class_cellule, 'parametres' => $param]
  562.             );
  563.         }
  566.     }
  569.     /**
  570.      * set datatable configs
  571.      *
  572.      * @return \App\Library\Datatable\Util\Datatable
  573.      */
  574.     private function datatable(Request $request, EntityManagerInterface $em, Datatable $datatable, TranslatorInterface $translator)
  575.     {
  576.         $param = $request->query->all();
  578.         $repo_statut_document = $em->getRepository(StatutCommande::class);
  579.         $liste_statut         = $repo_statut_document->findBy(["documentCommercial" => 4, "ordre" => [0]]);
  581.         $date = new \Datetime();
  582.         $datatable->setDatatableId('dta-bonpreparations')
  583.                   ->setEntity(Commande::class, "x")
  584.                   ->setFields(
  585.                       [
  586.                           $translator->trans("ID")              => 'x.id',
  587.                           $translator->trans("Date")            => 'x.date',
  588.                           $translator->trans("Réf")             => 'x.reference',
  589.                           $translator->trans("Réf client")      => 'cl.reference',
  590.                           $translator->trans("Client")          => 'cl.nom',
  591.                           $translator->trans("Équipier")        => 'u.reference',
  592.                           $translator->trans("Comm")            => 'x.commentaire',
  593.                           $translator->trans("Réf cmde cli")    => 'x.referenceClient',
  594.                           $translator->trans("A réaliser pour") => 'x.dateBon',
  595.                           $translator->trans("Statut")          => 's.libelle',
  596.                           $translator->trans("Actions")         => 'x.id',
  597.                           "_identifier_"                        => 'x.id',
  598.                       ]
  599.                   )
  600.                   ->addJoin('x.statutCommande', 's', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  601.                   ->addJoin('x.commande', 'c', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  602.                   ->addJoin('x.client', 'cl', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  603.                   ->addJoin('x.utilisateur', 'u', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  604.             /*->setWhere(
  605.                     $type_jointure.' = :objet',
  606.                     array('objet' => $objet)
  607.                )
  608.               */
  610.                   ->setRenderers(
  611.                 [
  612.                     0  => [
  613.                         'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  614.                         'params' => [
  615.                             'edit_route' => 'dtc_bon_preparation_modifier',
  616.                         ],
  618.                     ],
  619.                     1  => [
  620.                         'view'   => 'FO/DataTable/heure.html.twig',
  621.                         'params' => [],
  623.                     ],
  624.                     2  => [
  625.                         'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  626.                         'params' => [
  627.                             'edit_route' => 'dtc_bon_preparation_modifier',
  628.                         ],
  630.                     ],
  631.                     3  => [
  632.                         'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  633.                         'params' => [
  634.                             'edit_route'   => 'dtc_client_modifier',
  635.                             'typeDocument' => 'client',
  636.                         ],
  637.                     ],
  638.                     4  => [
  639.                         'view'   => 'FO/DataTable/client.html.twig',
  640.                         'params' => [],
  642.                     ],
  643.                     5  => [
  644.                         'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  645.                         'params' => [
  646.                             'edit_route'   => 'dtc_utilisateur_modifier',
  647.                             'typeDocument' => 'equipier',
  648.                         ],
  649.                     ],
  650.                     8  => [
  651.                         'view'   => 'FO/DataTable/heure.html.twig',
  652.                         'params' => [],
  653.                     ],
  654.                     10 => [
  655.                         'view'   => 'FO/DataTable/actions.html.twig',
  656.                         'params' => [
  657.                             'edit_route' => 'dtc_bon_preparation_modifier',
  658.                             //'supprimer_route'  => 'dtc_bon_preparation_supprimer',
  659.                             'pdf_route'  => 'dtc_bon_preparation_pdf',
  660.                             'entite'     => 'bonPreparation',
  661.                             'objet'      => Commande::class,
  662.                             'deplier'    => true,
  664.                         ],
  665.                     ],
  668.                 ]
  669.             )
  670.                   ->setMultiple(
  671.                       [
  672.                           'print' => [
  673.                               'title' => 'Imprimer',
  674.                               'route' => 'dtc_bon_preparation_pdf_multiple',
  675.                           ],
  676.                       ]
  677.                   )
  678.                   ->setOrder("x.id", "desc")
  679.                   ->setSearch(true)
  680.                   ->setSearchFields([2, 3, 4, 5, 7]);
  683.         $where      = 'x.typeDocumentCommercial = :typeDocumentCommercial AND (x.dateBon IS NULL or x.dateBon <= :dateBon) AND x.visible = :visible AND x.statutCommande NOT IN (:statutCommande)';
  684.         $parameters = ['typeDocumentCommercial' => TypeDocumentCommercial::BP, 'dateBon' => $date->format("Y-m-d H:i:s"), 'visible' => true, 'statutCommande' => $liste_statut];
  686.         if (array_key_exists('parametres', $param)) {
  687.             if (array_key_exists('client', $param["parametres"]) and $param["parametres"]["client"] > 0) {
  688.                 //$datatable->addJoin('x.client', 'client', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN);
  689.                 $parameters["client"] = $param["parametres"]["client"];
  690.                 if ($where != "") {
  691.                     $where .= " AND ";
  692.                 }
  693.                 $where .= "cl.id = :client";
  694.             }
  695.             if (array_key_exists('client', $param["parametres"]) and $param["parametres"]["date_debut"] != "") {
  696.                 $param["parametres"]["date_debut"] = \DateTime::createFromFormat('d/m/Y', $param["parametres"]["date_debut"]);
  697.                 $param["parametres"]["date_debut"]->setTime(00, 00, 00);
  698.                 $parameters["date_debut"] = $param["parametres"]["date_debut"];
  699.                 if ($where != "") {
  700.                     $where .= " AND ";
  701.                 }
  702.                 $where .= "x.date >= :date_debut";
  703.             }
  704.             if (array_key_exists('client', $param["parametres"]) and $param["parametres"]["date_fin"] != "") {
  705.                 $param["parametres"]["date_fin"] = \DateTime::createFromFormat('d/m/Y', $param["parametres"]["date_fin"]);
  706.                 $param["parametres"]["date_fin"]->setTime(23, 59, 59);
  707.                 $parameters["date_fin"] = $param["parametres"]["date_fin"];
  708.                 if ($where != "") {
  709.                     $where .= " AND ";
  710.                 }
  711.                 $where .= "x.date <= :date_fin";
  712.             }
  713.         }
  714.         if ($where != '') {
  715.             $datatable->setWhere($where, $parameters);
  716.         }
  718.         // echo $where;
  719.         return $datatable;
  720.     }
  723.     /**
  724.      * set datatable configs
  725.      *
  726.      * @return \App\Library\Datatable\Util\Datatable
  727.      */
  728.     private function datatableCommande($objet, $type = "", EntityManagerInterface $em, Datatable $datatable, TranslatorInterface $translator)
  729.     {
  730.         $repo_statut_document = $em->getRepository(StatutCommande::class);
  731.         $liste_statut         = $repo_statut_document->findBy(["documentCommercial" => 4, "ordre" => [0]]);
  733.         $type_jointure = 'x.'.$type;
  734.         $datatable->setDatatableId('dta-bonpreparations')
  735.                   ->setEntity(Commande::class, "x")
  736.                   ->setFields(
  737.                       [
  739.                           $translator->trans("Date")            => 'x.date',
  740.                           $translator->trans("Réf")             => 'x.reference',
  741.                           $translator->trans("Ref client")      => 'cl.reference',
  742.                           $translator->trans("Client")          => 'cl.nom',
  743.                           $translator->trans("Équipier")        => 'u.reference',
  744.                           $translator->trans("Comm")            => 'x.commentaire',
  745.                           $translator->trans("Ref cmde cli")    => 'x.referenceClient',
  746.                           $translator->trans("A réaliser pour") => 'x.dateBon',
  747.                           $translator->trans("Actions")         => 'x.id',
  748.                           "_identifier_"                        => 'x.id',
  749.                       ]
  750.                   )
  751.             //->addJoin('x.pays', 'p', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  752.             /*->setWhere(
  753.                     $type_jointure.' = :objet',
  754.                     array('objet' => $objet)
  755.                )
  756.               */
  758.                   ->addJoin('x.statutCommande', 's', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  759.                   ->addJoin('x.commande', 'c', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  760.                   ->addJoin('x.client', 'cl', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  761.                   ->addJoin('x.utilisateur', 'u', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  762.                   ->setWhere(
  763.                       'x.commande = :objet AND x.typeDocumentCommercial = :typeDocumentCommercial AND x.statutCommande NOT IN (:statutCommande)',
  764.                       ['objet' => $objet, 'typeDocumentCommercial' => TypeDocumentCommercial::BP, 'statutCommande' => $liste_statut]
  765.                   )
  766.                   ->setRenderers(
  767.                       [
  769.                           0 => [
  770.                               'view'   => 'FO/DataTable/heure.html.twig',
  771.                               'params' => [],
  773.                           ],
  774.                           1 => [
  775.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  776.                               'params' => [
  777.                                   'edit_route' => 'dtc_bon_preparation_modifier',
  778.                               ],
  780.                           ],
  782.                           7 => [
  783.                               'view'   => 'FO/DataTable/heure.html.twig',
  784.                               'params' => [],
  785.                           ],
  786.                           8 => [
  787.                               'view'   => 'FO/DataTable/actions.html.twig',
  788.                               'params' => [
  789.                                   'edit_route' => 'dtc_bon_preparation_modifier',
  790.                                   //'supprimer_route'  => 'dtc_bon_preparation_supprimer',
  791.                                   'pdf_route'  => 'dtc_bon_preparation_pdf',
  792.                                   'entite'     => 'bonPreparation',
  793.                                   'objet'      => Commande::class,
  794.                                   'deplier'    => true,
  796.                               ],
  797.                           ],
  800.                       ]
  801.                   )
  802.                   ->setOrder("x.date", "desc")
  803.                   ->setSearch(true)//->setSearchFields(array(1,2))
  804.         ;
  806.         return $datatable;
  807.     }
  810.     /**
  811.      * @Route("/vente/bons-preparations/grid/{id}/{type}", name="dtc_bon_preparation_liste_grid")
  812.      */
  813.     public function gridAction(Request $request, $id = "", $type = "", EntityManagerInterface $em, Datatable $datatable, TranslatorInterface $translator)
  814.     {
  815.         $repo_objet = $em->getRepository(Commande::class);
  816.         $objet      = $repo_objet->find($id);
  818.         if (is_object($objet)) {
  819.             return $this->datatableCommande($objet, $type, $em, $datatable, $translator)->execute();
  820.         } else {
  821.             return $this->datatable($request, $em, $datatable, $translator)->execute();
  822.         }
  824.     }
  827.     /**
  828.      * @Route("", name="")
  829.      */
  830.     public function listerCommandeClientAction(Request $request, Client $client)
  831.     {
  832.         $options = '';
  833.         $cpt     = 0;
  834.         foreach ($client->getCommandes() as $bonPrepa) {
  835.             $selected = "";
  836.             //if($cpt == 0) $selected = 'selected="selected"';
  837.             $options .= '<option '.$selected.' value="'.$bonPrepa->getId().'">'.$bonPrepa->getLibelle().'</option>';
  838.             $cpt++;
  839.         }
  840.         $referenceCommandeClientObligatoire = $client->getReferenceClientObligatoire();
  842.         return new JsonResponse(
  843.             ['options' => $options, 'valide' => '0', 'referenceClientObligatoire' => $referenceCommandeClientObligatoire]
  844.         );
  845.     }
  847.     /**
  848.      * @Route("/bons-preparations-or/pdf/{id}", name="dtc_bon_preparation_or_pdf")
  849.      */
  850.     public function pdfBonPreparationOrAction(Request $request, Commande $bonPreparation, $retour = true, EntityManagerInterface $em, Pdf $snappy)
  851.     {
  853.         $societe    = $em->getRepository(Societe::class)->find(1);
  854.         $date_Y     = date("Y");
  855.         $date_M     = date("m");
  856.         $date_D     = date("d");
  857.         $date       = $date_Y.'/'.$date_M.'/'.$date_D;
  858.         $chemin_pdf = 'PDF/BONSPREPA/'.$date.'/BONPREPA-'.$bonPreparation->getReference().'.pdf';
  860.         if (file_exists($chemin_pdf)) {
  861.             unlink($chemin_pdf);
  862.         }
  864.         $footer = $this->renderView('FO/PDF/footer_pagination_bp_pdf.html.twig', ['societe' => $societe, 'commande' => $bonPreparation]);
  865.         $header = $this->renderView('FO/PDF/header_bpa_pdf.html.twig', ['societe' => $societe, 'commande' => $bonPreparation]);
  866.         $snappy->setOption('header-html', $header);
  867.         $snappy->setOption('footer-html', $footer);
  870.         $snappy->setOption('header-spacing', "4");
  871.         $snappy->setOption('footer-spacing', "3");
  873.         $snappy->setOption('disable-smart-shrinking', true);
  874.         //$snappy->setOption('print-media-type', false );
  876.         $snappy->setOption('page-height', "297");
  877.         $snappy->setOption('page-width', "210");
  880.         $snappy->generateFromHtml(
  881.             $this->renderView(
  882.                 'GestionComerciale/BonPreparationAtelier/template_pdf_2.html.twig',
  883.                 [
  884.                     'commande' => $bonPreparation,
  885.                     'societe'  => $societe,
  886.                 ]
  887.             ),
  888.             $chemin_pdf
  889.         );
  891.         if ($retour == true) {
  892.             return $this->render('FO/PDF/conteneur_pdf.html.twig', ['objet' => $bonPreparation, 'chemin_pdf' => '/'.$chemin_pdf]);
  893.         }
  895.     }
  898.     /**
  899.      * @Route("/bons-preparations/pdf/{id}", name="dtc_bon_preparation_pdf")
  900.      */
  901.     public function pdfBonPreparationAction(Request $request, Commande $bonPreparation, $retour = true, EntityManagerInterface $em, Pdf $snappy)
  902.     {
  904.         $societe = $em->getRepository(Societe::class)->find(1);
  905.         $date_Y  = date("Y");
  906.         $date_M  = date("m");
  907.         $date_D  = date("d");
  908.         $date    = $date_Y.'/'.$date_M.'/'.$date_D;
  910.         $chemin_pdf = 'PDF/BONSPREPA/'.$date.'/BONPREPA-'.$bonPreparation->getReference().'.pdf';
  912.         if (file_exists($chemin_pdf)) {
  913.             unlink($chemin_pdf);
  914.         }
  916.         //return $this->render('GestionComerciale/BonPreparation/template_pdf.html.twig',array('commande'  => $bonPreparation,'societe'  => $societe));
  919.         $footer = $this->renderView('FO/PDF/footer_bp_pagination_pdf.html.twig', ['societe' => $societe, 'commande' => $bonPreparation]);
  920.         $header = $this->renderView('FO/PDF/header_bp_pdf.html.twig', ['societe' => $societe, 'commande' => $bonPreparation]);
  921.         //$snappy->setOption('page-size', 'A4');
  922.         $snappy->setOption('header-html', $header);
  923.         $snappy->setOption('footer-html', $footer);
  924.         //$snappy->setOption('header-html',$footer);
  926.         $snappy->setOption('header-spacing', "4");
  927.         $snappy->setOption('footer-spacing', "3");
  929.         $snappy->setOption('disable-smart-shrinking', true);
  930.         //$snappy->setOption('print-media-type', false );
  932.         $snappy->setOption('page-height', "297");
  933.         $snappy->setOption('page-width', "210");
  936.         $snappy->generateFromHtml(
  937.             $this->renderView(
  938.                 'GestionComerciale/BonPreparation/template_pdf.html.twig',
  939.                 [
  940.                     'commande' => $bonPreparation,
  941.                     'societe'  => $societe,
  942.                 ]
  943.             ),
  944.             $chemin_pdf
  945.         );
  947.         if ($retour == true) {
  948.             return $this->render('FO/PDF/conteneur_pdf.html.twig', [
  949.                 'objet'      => $bonPreparation,
  950.                 'chemin_pdf' => '/'.$chemin_pdf,
  951.                 'visualiser' => $request->query->get('visualiser'),
  952.             ]);
  953.             //return new RedirectResponse("/".$chemin_pdf);
  954.         }
  956.     }
  958.     /**
  959.      * @Route("/vente/bons-preparations/imprimer/multiple", name="dtc_bon_preparation_pdf_multiple")
  960.      */
  961.     public function imprimerMultipleAction(Request $request, EntityManagerInterface $em)
  962.     {
  963.         $data       = $request->get('dataTables');
  964.         $ids        = $data['actions'];
  965.         $tableauPdf = [];
  966.         $pdfRelier  = 'PDF/BONSPREPA/BONPREPA-'.date('d-m-Y').'.pdf';
  967.         $date_Y     = date("Y");
  968.         $date_M     = date("m");
  969.         $date_D     = date("d");
  970.         $date       = $date_Y.'/'.$date_M.'/'.$date_D;
  971.         //$ids = array("118","101","93");
  973.         for ($i = 0; $i < count($ids); $i++) {
  974.             $repo = $em->getRepository(Commande::class);
  975.             $bon  = $repo->find($ids[$i]);
  976.             if (is_object($bon)) {
  977.                 $this->pdfBonPreparationAction($bon, false);
  978.                 $tableauPdf[] = $chemin_pdf = 'PDF/BONSPREPA/'.$date.'/BONPREPA-'.$bon->getReference().'.pdf';
  979.             }
  980.         }
  981.         $cmd = "gs -q -dNOPAUSE -dBATCH -sDEVICE=pdfwrite -sOutputFile=$pdfRelier ";
  982.         foreach ($tableauPdf as $file) {
  983.             $cmd .= $file." ";
  984.         }
  985.         $result = shell_exec($cmd);
  987.         return new JsonResponse(['target' => '_blank', 'url' => '/'.$pdfRelier, 'valide' => '1']);
  988.     }
  990.     /**
  991.      * set datatable configs
  992.      *
  993.      * @return \App\Library\Datatable\Util\Datatable
  994.      */
  995.     private function datatableCommandeFournisseurBp($objet, $type = "", EntityManagerInterface $em, Datatable $datatable, TranslatorInterface $translator)
  996.     {
  998.         $articlesCommande = $objet->getArticleCommande();
  999.         $articles         = [];
  1000.         if (count($articlesCommande) > 0) {
  1001.             foreach ($articlesCommande as $articleCommande) {
  1002.                 $articles[] = $articleCommande->getArticle();
  1003.             }
  1004.         }
  1006.         $repo_article = $em->getRepository(Article::class);
  1008.         //$commandesId = $repo_article->getBpPourCommandeFournisseur($articles,$this->getParameter('article_commentaire'));
  1009.         $commandesId = $em->getRepository(ArticleCommande::class)->getBpPourCommandeFournisseur($articles, $this->getParameter('article_commentaire'));
  1010.         $commandes   = [];
  1012.         foreach ($commandesId as $commandeId) {
  1013.             $commandes[] = $commandeId['id'];
  1014.         }
  1015.         //$commandes = array(1668, 1670);
  1018.         //$commandes=array();
  1020.         $repo_statut_document = $em->getRepository(StatutCommande::class);
  1021.         $liste_statut         = $repo_statut_document->findBy(["documentCommercial" => 4, "ordre" => [0]]);
  1023.         $type_jointure = 'x.'.$type;
  1024.         $datatable->setDatatableId('dta-bonpreparations')
  1025.                   ->setEntity(Commande::class, "x")
  1026.                   ->setFields(
  1027.                       [
  1028.                           //$translator->trans("ID") =>  'x.id',
  1029.                           $translator->trans("Date")            => 'x.date',
  1030.                           $translator->trans("Réf")             => 'x.reference',
  1031.                           $translator->trans("Ref client")      => 'cl.reference',
  1032.                           $translator->trans("Client")          => 'cl.nom',
  1033.                           $translator->trans("Équipier")        => 'u.reference',
  1034.                           $translator->trans("Comm")            => 'x.commentaire',
  1035.                           $translator->trans("Ref cmde cli")    => 'x.referenceClient',
  1036.                           $translator->trans("A réaliser pour") => 'x.dateBon',
  1037.                           $translator->trans("Actions")         => 'x.id',
  1038.                           "_identifier_"                        => 'x.id',
  1039.                       ]
  1040.                   )
  1041.             //->addJoin('x.pays', 'p', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1042.             /*->setWhere(
  1043.                     $type_jointure.' = :objet',
  1044.                     array('objet' => $objet)
  1045.                )
  1046.               */
  1048.                   ->addJoin('x.statutCommande', 's', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1049.                   ->addJoin('x.commande', 'c', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1050.                   ->addJoin('x.client', 'cl', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1051.                   ->addJoin('x.utilisateur', 'u', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1052.                   ->setWhere(
  1053.                       'x.id IN (:commandes) AND x.typeDocumentCommercial = :typeDocumentCommercial AND x.statutCommande NOT IN (:statutCommande)',
  1054.                       ['commandes' => $commandes, 'typeDocumentCommercial' => TypeDocumentCommercial::BP, 'statutCommande' => $liste_statut]
  1055.                   )
  1056.                   ->setRenderers(
  1057.                       [
  1059.                           0 => [
  1060.                               'view'   => 'FO/DataTable/heure.html.twig',
  1061.                               'params' => [],
  1063.                           ],
  1064.                           1 => [
  1065.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  1066.                               'params' => [
  1067.                                   'edit_route' => 'dtc_bon_preparation_modifier',
  1068.                               ],
  1070.                           ],
  1072.                           7 => [
  1073.                               'view'   => 'FO/DataTable/heure.html.twig',
  1074.                               'params' => [],
  1075.                           ],
  1076.                           8 => [
  1077.                               'view'   => 'FO/DataTable/actions.html.twig',
  1078.                               'params' => [
  1079.                                   'edit_route' => 'dtc_bon_preparation_modifier',
  1080.                                   //'supprimer_route'  => 'dtc_bon_preparation_supprimer',
  1081.                                   'pdf_route'  => 'dtc_bon_preparation_pdf',
  1082.                                   'entite'     => 'bonPreparation',
  1083.                                   'objet'      => Commande::class,
  1084.                                   'deplier'    => true,
  1086.                               ],
  1087.                           ],
  1090.                       ]
  1091.                   )
  1092.                   ->setOrder("x.date", "desc")
  1093.                   ->setSearch(true)//->setSearchFields(array(1,2))
  1094.         ;
  1096.         return $datatable;
  1097.     }
  1099.     /**
  1100.      * set datatable configs
  1101.      *
  1102.      * @return \App\Library\Datatable\Util\Datatable
  1103.      */
  1104.     private function datatableCommandeFournisseur($objet, $type = "", EntityManagerInterface $em, Datatable $datatable, TranslatorInterface $translator)
  1105.     {
  1107.         $articlesCommande = $objet->getArticleCommande();
  1108.         $articles         = [];
  1109.         if (count($articlesCommande) > 0) {
  1110.             foreach ($articlesCommande as $articleCommande) {
  1111.                 if ($articleCommande->getArticle()->getEstCommentaire() != 1) {
  1112.                     $articles[] = $articleCommande->getArticle();
  1113.                 }
  1114.             }
  1115.         }
  1117.         $repo_article = $em->getRepository(Article::class);
  1119.         $commandesId = $repo_article->getCommandes($articles);
  1121.         $commandes   = [];
  1123.         foreach ($commandesId as $commandeId) {
  1124.             $commandes[] = $commandeId['id'];
  1125.         }
  1126.         //$commandes = array(1668, 1670);
  1128.         $repo_statut_document = $em->getRepository(StatutCommande::class);
  1129.         $liste_statut         = $repo_statut_document->findBy(["documentCommercial" => 4, "ordre" => [0]]);
  1131.         $type_jointure = 'x.'.$type;
  1132.         $datatable->setDatatableId('dta-bonpreparations')
  1133.                   ->setEntity(Commande::class, "x")
  1134.                   ->setFields(
  1135.                       [
  1136.                           //$translator->trans("ID") =>  'x.id',
  1137.                           $translator->trans("Date")            => 'x.date',
  1138.                           $translator->trans("Réf")             => 'x.reference',
  1139.                           $translator->trans("Ref client")      => 'cl.reference',
  1140.                           $translator->trans("Client")          => 'cl.nom',
  1141.                           $translator->trans("Équipier")        => 'u.reference',
  1142.                           $translator->trans("Comm")            => 'x.commentaire',
  1143.                           $translator->trans("Ref cmde cli")    => 'x.referenceClient',
  1144.                           $translator->trans("A réaliser pour") => 'x.dateBon',
  1145.                           $translator->trans("Actions")         => 'x.id',
  1146.                           "_identifier_"                        => 'x.id',
  1147.                       ]
  1148.                   )
  1149.             //->addJoin('x.pays', 'p', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1150.             /*->setWhere(
  1151.                     $type_jointure.' = :objet',
  1152.                     array('objet' => $objet)
  1153.                )
  1154.               */
  1156.                   ->addJoin('x.statutCommande', 's', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1157.                   ->addJoin('x.commande', 'c', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1158.                   ->addJoin('x.client', 'cl', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1159.                   ->addJoin('x.utilisateur', 'u', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1160.                   ->setWhere(
  1161.                       'x.commande IN (:commandes) AND x.typeDocumentCommercial = :typeDocumentCommercial AND x.statutCommande NOT IN (:statutCommande)',
  1162.                       ['commandes' => $commandes, 'typeDocumentCommercial' => TypeDocumentCommercial::BP, 'statutCommande' => $liste_statut]
  1163.                   )
  1164.                   ->setRenderers(
  1165.                       [
  1167.                           0 => [
  1168.                               'view'   => 'FO/DataTable/heure.html.twig',
  1169.                               'params' => [],
  1171.                           ],
  1172.                           1 => [
  1173.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  1174.                               'params' => [
  1175.                                   'edit_route' => 'dtc_bon_preparation_modifier',
  1176.                               ],
  1178.                           ],
  1180.                           7 => [
  1181.                               'view'   => 'FO/DataTable/heure.html.twig',
  1182.                               'params' => [],
  1183.                           ],
  1184.                           8 => [
  1185.                               'view'   => 'FO/DataTable/actions.html.twig',
  1186.                               'params' => [
  1187.                                   'edit_route' => 'dtc_bon_preparation_modifier',
  1188.                                   //'supprimer_route'  => 'dtc_bon_preparation_supprimer',
  1189.                                   'pdf_route'  => 'dtc_bon_preparation_pdf',
  1190.                                   'entite'     => 'bonPreparation',
  1191.                                   'objet'      => Commande::class,
  1193.                               ],
  1194.                           ],
  1197.                       ]
  1198.                   )
  1199.                   ->setOrder("x.date", "desc")
  1200.                   ->setSearch(true)//->setSearchFields(array(1,2))
  1201.         ;
  1203.         return $datatable;
  1204.     }
  1207.     /**
  1208.      * Grid action
  1209.      * @return Response
  1210.      */
  1211.     /**
  1212.      * @Route("/vente/bons-preparations/commande-fournisseur/grid/{id}", name="dtc_bon_preparation_commande_fournisseur_liste_grid")
  1213.      */
  1214.     public function gridCommandeFournisseurAction(Request $request, $id = "", EntityManagerInterface $em, Datatable $datatable, TranslatorInterface $translator)
  1215.     {
  1216.         $repo_objet = $em->getRepository(CommandeFournisseur::class);
  1217.         $objet      = $repo_objet->find($id);
  1219.         if (is_object($objet)) {
  1220.             return $this->datatableCommandeFournisseur($objet, "", $em, $datatable, $translator)->execute();
  1221.         }
  1223.     }
  1225.     /**
  1226.      * Grid action
  1227.      * @return Response
  1228.      */
  1229.     /**
  1230.      * @Route("/vente/bons-preparations/commande-fournisseur/bp/grid/{id}", name="dtc_bon_preparation_commande_fournisseur_bp_liste_grid")
  1231.      */
  1232.     public function gridCommandeFournisseurBpAction(Request $request, $id = "", EntityManagerInterface $em, Datatable $datatable, TranslatorInterface $translator)
  1233.     {
  1234.         $repo_objet = $em->getRepository(CommandeFournisseur::class);
  1235.         $objet      = $repo_objet->find($id);
  1237.         if (is_object($objet)) {
  1238.             return $this->datatableCommandeFournisseurBp($objet, '', $em, $datatable, $translator)->execute();
  1239.         }
  1241.     }
  1243.     /**
  1244.      * @Route("/vente/bons-preparation/retour-commande/{id}", name="dtc_bon_preparation_retour_commande")
  1245.      */
  1246.     public function retourCommandeAction(Request             $request, Commande $bon, EntityManagerInterface $em, BonPreparationService $bonPreparationService,
  1247.                                          TranslatorInterface $translator
  1248.     ) {
  1249.         $titre_modal = $translator->trans("Retour en commande");
  1251.         $user   = $this->getUser();
  1252.         $errors = "";
  1254.         $idsArticleCommande = $request->query->get('choixArticles');
  1256.         $link            = $this->generateUrl('dtc_bon_preparation_retour_commande', ['id' => $bon->getId()]);
  1257.         $articleCommande = $em->getRepository(ArticleCommande::class)->listeArticleCommandeSelectionne($idsArticleCommande);
  1259.         if ($request->isMethod('POST')) {
  1261.             $articles = [
  1262.                 'idArticleCommande' => $request->request->get('idArticleCommande'),
  1263.                 'qte'               => $request->request->get('qte'),
  1264.             ];
  1265.             $bonPreparationService->retourCommande($articles, $bon);
  1267.             $url = $this->generateUrl('dtc_commande_modifier', ['id' => $bon->getCommande()->getId()]);
  1269.             $this->addFlash(
  1270.                 'notice',
  1271.                 $translator->trans('Retour des articles sur la commande réalisé avec succès !')
  1272.             );
  1274.             return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url]);
  1275.         }
  1277.         $rendu = $this->renderView('GestionComerciale/BonPreparation/retour-commande.html.twig', ['errors' => $errors, 'articleCommande' => $articleCommande, 'commande' => $bon]);
  1279.         return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'link' => $link, 'titre' => $titre_modal]);
  1281.     }
  1283.     /**
  1284.      * @Route("/vente/bons-preparations/nouveau-v2/{id}/{type}", name="dtc_bon_preparation_ajouter_v2")
  1285.      */
  1286.     public function ajouterV2Action(Request             $request, $id, $type = "", EntityManagerInterface $em, BonPreparationService $bonPreparationService, CommandeService $commandeService,
  1287.                                     TranslatorInterface $translator
  1288.     ) {
  1289.         $user               = $this->getUser();
  1290.         $idsArticleCommande = $request->request->get('choixArticles');
  1291.         //$idsArticleCommande = $request->request->all();
  1292.         //$qtesArticleCommande = $request->request->get('qteDispo');
  1294.         if (count($idsArticleCommande) > 0) {
  1297.             $repo_objet = $em->getRepository(Commande::class);
  1300.             $errors = "";
  1301.             //$articleCommande = $em->getRepository(ArticleCommande::class)->listeArticleCommandeSelectionne($idsArticleCommande);
  1303.             $objet = $repo_objet->find($id);
  1305.             //date de préparation ultérieure
  1306.             $now = new \Datetime;
  1307.             if (is_object($objet->getDateBon()) && $objet->getDateBon() > $now) {
  1308.                 $url = $this->generateUrl('dtc_commande_modifier', ['id' => $id, 'forceQteDispo' => false]);
  1310.                 $this->addFlash('warning', 'Cette commande ne peut être passée en BP/BL/Facture/Avoir car elle a une date de préparation au '.$objet->getDateBon()->format('d/m/Y').' !');
  1313.                 return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url]);
  1314.             }
  1316.             if ($objet->getOrigine() == 'prestashop' && $objet->getValideManuellement() != 1) {
  1317.                 $url = $this->generateUrl('dtc_commande_modifier', ['id' => $id, 'forceQteDispo' => false]);
  1319.                 $this->addFlash(
  1320.                     'warning',
  1321.                     $translator->trans('Cette commande internet doit être validée avant le passage en BP !')
  1322.                 );
  1324.                 return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url]);
  1325.             }
  1328.             if ($commandeService->estPreparable($objet)) {
  1330.                 $bon = clone $objet;
  1331.                 $bon->setCreateur($user);
  1332.                 $bon->setDateBon(new \DateTime());
  1333.                 $bon->setDate(new \DateTime());
  1334.                 $bon->setCommande($objet);
  1335.                 //$bon->setUtilisateur($user);
  1336.                 if (is_object($bon->getUtilisateur()) && ! empty($this->getParameter('utilisateur_site_internet')) && $bon->getUtilisateur()->getId(
  1337.                     ) == $this->getParameter('utilisateur_site_internet')) {
  1338.                 } else {
  1339.                     $bon->setUtilisateur($user);
  1340.                 }
  1342.                 $bon->setModifiable(false);
  1344.                 $em->persist($bon);
  1345.                 $em->flush();
  1346.                 $em->refresh($bon);
  1348.                 //$operation = "commande";
  1349.                 $operation = "";
  1350.                 //$operation = $request->request->get('operation');
  1351.                 $articles = [
  1352.                     'valider'                  => $request->request->get('valider'),
  1353.                     'ids'                      => $request->request->get('ids'),
  1354.                     'idArticleCommande'        => $request->request->get('idArticleCommande'),
  1355.                     //'idArticleCommandeOrigine'=>$request->request->get('idArticleCommandeOrigine'),
  1356.                     'idArticleCommandeOrigine' => [],
  1357.                     'idArticleCommandeParent'  => $request->request->get('idArticleCommandeOrigine'),
  1358.                     'montantRemise'            => $request->request->get('montantRemise'),
  1359.                     'remiseCalcule'            => $request->request->get('remiseCalcule'),
  1360.                     'remise'                   => $request->request->get('remise'),
  1361.                     'commentaire'              => $request->request->get('commentaire'),
  1362.                     'commentairePrive'         => $request->request->get('commentairePrive'),
  1363.                     'remiseSuppl'              => $request->request->get('remiseSuppl'),
  1364.                     'ecocontribution'          => $request->request->get('ecocontribution'),
  1365.                     'prix'                     => $request->request->get('prix'),
  1366.                     //'fraisPortLigne'=>$request->request->get('fraisPortLigne'),
  1367.                     'libellesSecondaires'      => $request->request->get('libellesSecondaires'),
  1368.                     'libelles'                 => $request->request->get('libelles'),
  1369.                     'tva'                      => $request->request->get('tva'),
  1370.                     'qte'                      => $request->request->get('qte'),
  1371.                     //'qte'=>$request->request->get('qteDispo'),
  1372.                     'commentaireSuppl'         => $request->request->get('commentaireSuppl'),
  1373.                     'emplacement'              => $request->request->get('emplacement'),
  1374.                     'nbEmplacement'            => $request->request->get('nbEmplacement'),
  1375.                     'position'                 => $request->request->get('position'),
  1376.                     'articlesCommandeRepris'   => $request->request->get('articlesCommandeRepris'),
  1377.                     'qteDispo'                 => $request->request->get('qteDispo'),
  1378.                     'transporteurs'            => $request->request->get('transporteurs'),
  1379.                     'articlesCommandeAssocies' => $request->request->get('articlesCommandeAssocies'),
  1380.                     'tabPrixAchatNetEuros'     => $request->request->get('tabPrixAchatNetEuros'),
  1382.                     'societe_livraison_txt'     => $request->request->get('societe_livraison_txt'),
  1383.                     'numero_livraison_txt'      => $request->request->get('numero_livraison_txt'),
  1384.                     'rue_livraison_txt'         => $request->request->get('rue_livraison_txt'),
  1385.                     'complement_livraison_txt'  => $request->request->get('complement_livraison_txt'),
  1386.                     'complement2_livraison_txt' => $request->request->get('complement2_livraison_txt'),
  1387.                     'cp_livraison_txt'          => $request->request->get('cp_livraison_txt'),
  1388.                     'ville_livraison_txt'       => $request->request->get('ville_livraison_txt'),
  1391.                     'societe_facturation_txt'     => $request->request->get('societe_facturation_txt'),
  1392.                     'numero_facturation_txt'      => $request->request->get('numero_facturation_txt'),
  1393.                     'rue_facturation_txt'         => $request->request->get('rue_facturation_txt'),
  1394.                     'complement_facturation_txt'  => $request->request->get('complement_facturation_txt'),
  1395.                     'complement2_facturation_txt' => $request->request->get('complement2_facturation_txt'),
  1396.                     'cp_facturation_txt'          => $request->request->get('cp_facturation_txt'),
  1397.                     'ville_facturation_txt'       => $request->request->get('ville_facturation_txt'),
  1399.                 ];
  1401.                 $valeurs = ["articles" => $articles, 'typeDocument' => 'commande', 'operation' => 'commande', 'action' => 'nouveau'];
  1402.                 $bonPreparationService->sauvegarderBon($bon, $valeurs);
  1404.                 $url = $this->generateUrl('dtc_bon_preparation_modifier', ['id' => $bon->getId(), 'forceQteDispo' => true]);
  1406.                 $this->addFlash(
  1407.                     'notice',
  1408.                     $translator->trans('Bon de préparation ajouté avec succès !')
  1409.                 );
  1410.                 $commandeService->creerHistorique($bon, 1);
  1412.                 return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url]);
  1413.             } else {
  1414.                 $url = $this->generateUrl('dtc_commande_modifier', ['id' => $id, 'forceQteDispo' => false]);
  1416.                 $this->addFlash(
  1417.                     'warning',
  1418.                     $translator->trans('Cette commande est déjà préparée !')
  1419.                 );
  1421.                 return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url]);
  1422.             }
  1424.         } else {
  1425.             return new JsonResponse(
  1426.                 [
  1427.                     'rendu'              => '',
  1428.                     'valide'             => '0',
  1429.                     'url'                => '',
  1430.                     'idsArticleCommande' => $idsArticleCommande,
  1431.                 ]
  1432.             );
  1433.         }
  1434.     }
  1436.     /**
  1437.      * @Route("/bp/charger-tableau/{id}/{type}", name="dtc_bp_charger_tableau")
  1438.      */
  1439.     public function chargerTableauAction(Request $request, $id, $type = 'commande')
  1440.     {
  1441.         $rendu = $this->renderView('GestionComerciale/BonPreparation/charger_tableau.html.twig', ["id" => $id, "type" => $type]);
  1443.         return new JsonResponse(['rendu' => $rendu]);
  1445.     }
  1447. }