src/Controller/GestionComerciale/FactureController.php line 877

Open in your IDE?
  1. <?php
  3. namespace App\Controller\GestionComerciale;
  5. use App\Entity\Clients\Client;
  6. use App\Entity\FO\Societe;
  7. use App\Entity\GestionComerciale\ArticleCommande;
  8. use App\Entity\GestionComerciale\Avoir;
  9. use App\Entity\GestionComerciale\Commande;
  10. use App\Entity\GestionComerciale\Facture;
  11. use App\Entity\GestionComerciale\StatutCommande;
  12. use App\Entity\GestionComerciale\StatutPaiement;
  13. use App\Form\GestionComerciale\CommandeType;
  14. use App\Form\GestionComerciale\FactureType;
  15. use App\Kernel;
  16. use App\Library\Datatable\Util\Datatable;
  17. use App\Model\GestionCommerciale\TypeDocumentCommercial;
  18. use App\Service\GestionComerciale\AcompteService;
  19. use App\Service\GestionComerciale\BonLivraisonService;
  20. use App\Service\GestionComerciale\CommandeService;
  21. use App\Service\GestionComerciale\FactureService;
  22. use App\Service\Utilisateur\ColonneTableauService;
  23. use Doctrine\ORM\EntityManagerInterface;
  24. use Knp\Snappy\Pdf;
  25. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  27. use Symfony\Component\HttpFoundation\Request;
  28. use Symfony\Component\HttpFoundation\JsonResponse;
  29. use Symfony\Component\HttpFoundation\Response;
  30. use Symfony\Component\Routing\Annotation\Route;
  31. use Symfony\Component\Security\Core\Exception\AccessDeniedException;
  32. use Symfony\Component\Validator\Validator\ValidatorInterface;
  33. use Symfony\Contracts\Translation\TranslatorInterface;
  35. class FactureController extends AbstractController
  36. {
  39.     /**
  40.      * @Route("/vente/facture/{id}", name="dtc_facture_afficher")
  41.      */
  42.     public function afficherAction(Request        $request, Commande $commande, EntityManagerInterface $em, TranslatorInterface $translator, FactureService $factureService,
  43.                                    AcompteService $serviceAcompte , Datatable $datatable
  44.     ) {
  46.         if ($commande->getTypeDocumentCommercial() == TypeDocumentCommercial::AVOIR) {
  47.             return $this->redirectToRoute('dtc_avoir_modifier', ["id" => $commande->getId()]);
  48.         }
  50.         $repo_objet = $em->getRepository(Commande::class)->find($commande);
  51.         $reglements = $repo_objet->getAcomptes();
  52.         $user       = $this->getUser();
  54.         $operation = $request->query->get('operation');
  55.         $errors    = "";
  56.         $annuler   = $request->request->get('annuler');
  57.         $form      = $this->createForm(CommandeType::class, $commande);
  58.         $form->handleRequest($request);
  59.         if ($form->isSubmitted()) {
  60.             if ($form->isValid()) {
  61.                 $em->persist($commande);
  63.                 //Modification du client sur les autres documents
  64.                 $repo_commande = $em->getRepository(Commande::class);
  65.                 $documents = $repo_commande->getDocumentClientAmodifier($commande)->getQuery()->getResult();
  66.                 if (count($documents) > 0) {
  67.                     foreach ($documents as $doc) {
  68.                         if ($commande->getClient()->getId() != $doc->getClient()->getId()) {
  69.                             $doc->setClient($commande->getClient());
  70.                             $doc->setAdresseLivraison($commande->getAdresseLivraison());
  71.                             $doc->setAdresseFacturation($commande->getAdresseFacturation());
  72.                             $em->persist($doc);
  73.                         }
  74.                     }
  75.                     $em->flush();
  76.                 }
  79.                 if (is_object($commande->getAdresseLivraison())) {
  80.                     $adrLiv = $commande->getAdresseLivraison();
  81.                     if (is_object($adrLiv->getCodePostal())) {
  82.                         $commande->setCodePostalLivraison($adrLiv->getCodePostal());
  83.                     }
  84.                     if (is_object($adrLiv->getCodePostal())) {
  85.                         $commande->setCodePostalLivraisonTxt($adrLiv->getCodePostal()->getCodePostal());
  86.                     }
  87.                     if (is_object($adrLiv->getVille())) {
  88.                         $commande->setVilleLivraison($adrLiv->getVille());
  89.                     }
  90.                     if (is_object($adrLiv->getVille())) {
  91.                         $commande->setVilleLivraisonTxt($adrLiv->getVille()->getTitre());
  92.                     }
  93.                     if (is_object($adrLiv->getPays())) {
  94.                         $commande->setPaysLivraison($adrLiv->getPays());
  95.                     }
  96.                     $commande->setLibelleLivraison($adrLiv->getSociete());
  97.                     $commande->setNumeroLivraison($adrLiv->getNumero());
  98.                     $commande->setRueLivraison($adrLiv->getRue());
  99.                     $commande->setComplementLivraison($adrLiv->getComplement());
  100.                     $commande->setComplementLivraison2($adrLiv->getComplement2());
  101.                 }
  104.                 if (is_object($commande->getAdresseFacturation())) {
  105.                     $adrFac = $commande->getAdresseFacturation();
  106.                     if (is_object($adrFac->getCodePostal())) {
  107.                         $commande->setCodePostalFacturation($adrFac->getCodePostal());
  108.                     }
  109.                     if (is_object($adrFac->getCodePostal())) {
  110.                         $commande->setCodePostalFacturationTxt($adrFac->getCodePostal()->getCodePostal());
  111.                     }
  112.                     if (is_object($adrFac->getVille())) {
  113.                         $commande->setVilleFacturation($adrFac->getVille());
  114.                     }
  115.                     if (is_object($adrFac->getVille())) {
  116.                         $commande->setVilleFacturationTxt($adrFac->getVille()->getTitre());
  117.                     }
  118.                     if (is_object($adrFac->getPays())) {
  119.                         $commande->setPaysFacturation($adrFac->getPays());
  120.                     }
  121.                     $commande->setLibelleFacturation($adrFac->getSociete());
  122.                     $commande->setNumeroFacturation($adrFac->getNumero());
  123.                     $commande->setRueFacturation($adrFac->getRue());
  124.                     $commande->setComplementFacturation($adrFac->getComplement());
  125.                     $commande->setComplementFacturation2($adrFac->getComplement2());
  126.                 }
  128.                 $em->flush();
  130.                 if ($annuler != "annuler" && $annuler != "annuler_devis" && $annuler != "annuler_bp") {
  131.                     $this->addFlash(
  132.                         'notice',
  133.                         $translator->trans('Facture modifiée avec succés  !')
  134.                     );
  137.                     return $this->redirectToRoute('dtc_facture_afficher', ["id" => $commande->getId()]);
  138.                 }
  140.             }
  141.         }
  144.         //echo "AA ".$annuler;
  145.         if ($annuler == "annuler" && is_object($commande->getBL()) == true && $commande->getMultiBL() == 0/*|| $annuler == "annuler_devis" || $annuler == "annuler_bp"*/) {
  147.             $factureService->annuler($commande, $annuler);
  150.             $remboursement = 0;
  151.             if ($annuler == "annuler" && $commande->getTypeDocumentCommercial() != TypeDocumentCommercial::ORDREREPARATION) {
  152.                 $remboursement = $serviceAcompte->proposerRemboursement($commande->getClient());
  153.             }
  156.             $this->addFlash(
  157.                 'notice',
  158.                 $translator->trans('Facture annulée avec succès !')
  159.             );
  161.             //exit;
  164.             return $this->redirectToRoute('dtc_bon_livraison_modifier', ["id" => $commande->getBL()->getId(), "r" => $remboursement, "c" => $commande->getClient()->getId()]);
  165.         } elseif ($annuler == "annuler" && $commande->getCommande()->getTypeDocumentCommercial() == TypeDocumentCommercial::ORDREREPARATION) {
  166.             //echo "okokokokokok";
  167.             //exit;
  168.             $factureService->annuler($commande, $annuler);
  171.             $remboursement = 0;
  172.             if ($annuler == "annuler" && $commande->getTypeDocumentCommercial() == TypeDocumentCommercial::ORDREREPARATION) {
  173.                 $remboursement = $serviceAcompte->proposerRemboursement($commande->getClient());
  174.             }
  177.             $this->addFlash(
  178.                 'notice',
  179.                 $translator->trans('Facture annulée avec succès !')
  180.             );
  182.             //exit;
  185.             return $this->redirectToRoute('dtc_ordre_reparation_modifier', ["id" => $commande->getCommande()->getId(), "r" => $remboursement, "c" => $commande->getClient()->getId()]);
  187.         } elseif ($annuler == "annuler" && is_object($commande->getBL()) == false) {
  188.             //echo "okokokokokok";
  189.             //exit;
  190.             $factureService->annuler($commande, $annuler);
  193.             $remboursement = 0;
  194.             if ($annuler == "annuler" && $commande->getTypeDocumentCommercial() != TypeDocumentCommercial::ORDREREPARATION) {
  195.                 $remboursement = $serviceAcompte->proposerRemboursement($commande->getClient());
  196.             }
  199.             $this->addFlash(
  200.                 'notice',
  201.                 $translator->trans('Facture annulée avec succès !')
  202.             );
  204.             //exit;
  207.             return $this->redirectToRoute('dtc_facture_liste', ["r" => $remboursement, "c" => $commande->getClient()->getId()]);
  209.         }
  210.         if ($annuler == "annuler_bp" && $commande->getBP() != null) {
  212.             $factureService->annuler($commande, $annuler);
  215.             $remboursement = 0;
  216.             if ($annuler == "annuler" && $commande->getTypeDocumentCommercial() != TypeDocumentCommercial::ORDREREPARATION) {
  217.                 $remboursement = $serviceAcompte->proposerRemboursement($commande->getClient());
  218.             }
  221.             $this->addFlash(
  222.                 'notice',
  223.                 $translator->trans('Facture annulée avec succès !')
  224.             );
  226.             //exit;
  229.             return $this->redirectToRoute('dtc_bon_preparation_modifier', ["id" => $commande->getBP()->getId(), "r" => $remboursement, "c" => $commande->getClient()->getId()]);
  230.         }
  231.         if ($annuler == "annuler_devis") {
  233.             $factureService->annuler($commande, $annuler);
  236.             $remboursement = 0;
  237.             if ($annuler == "annuler" && $commande->getTypeDocumentCommercial() != TypeDocumentCommercial::ORDREREPARATION) {
  238.                 $remboursement = $serviceAcompte->proposerRemboursement($commande->getClient());
  239.             }
  242.             $this->addFlash(
  243.                 'notice',
  244.                 $translator->trans('Facture annulée avec succès !')
  245.             );
  247.             //exit;
  250.             return $this->redirectToRoute('dtc_facture_liste', ["r" => $remboursement, "c" => $commande->getClient()->getId()]);
  251.         }
  254.         $this->datatableAvoir($commande, $datatable, $translator);
  256.         $modal = $request->query->get('modal');
  257.         if ($modal == 1) {
  258.             if ($commande->getMultiBL() == true) {
  259.                 $repo_commande = $em->getRepository(Commande::class);
  260.                 $bls           = $repo_commande->findByFacture($commande->getId());
  261.                 $rendu         = $this->renderView(
  262.                     'GestionComerciale/Facture/afficher-traite-modal.html.twig',
  263.                     ['form' => $form->createView(), 'commande' => $commande, 'errors' => $errors, 'bls' => $bls]
  264.                 );
  265.             } else {
  266.                 $rendu = $this->renderView(
  267.                     'GestionComerciale/Facture/afficher-modal.html.twig',
  268.                     ['form' => $form->createView(), 'commande' => $commande, 'errors' => $errors, 'reglements' => $reglements, 'operation' => $operation]
  269.                 );
  270.             }
  271.             $titre_modal = $commande->getReference();
  273.             return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  274.         } else {
  275.             if ($commande->getMultiBL() == true) {
  276.                 $repo_commande = $em->getRepository(Commande::class);
  277.                 $bls           = $repo_commande->findByFacture($commande->getId());
  279.                 return $this->render(
  280.                     'GestionComerciale/Facture/afficher-traite.html.twig',
  281.                     ['form' => $form->createView(), 'commande' => $commande, 'errors' => $errors, 'bls' => $bls, 'reliquats' => $request->query->get('reliquats')]
  282.                 );
  283.             } else {
  284.                 return $this->render(
  285.                     'GestionComerciale/Facture/afficher.html.twig',
  286.                     [
  287.                         'form'       => $form->createView(),
  288.                         'commande'   => $commande,
  289.                         'errors'     => $errors,
  290.                         'reglements' => $reglements,
  291.                         'operation'  => $operation,
  292.                         'reliquats'  => $request->query->get('reliquats'),
  293.                     ]
  294.                 );
  295.             }
  296.         }
  298.     }
  300.     /**
  301.      * @Route("/vente/facture/nouveau/{id}/{type}", name="dtc_facture_ajouter")
  302.      */
  303.     public function ajouterAction(Request $request, $id, $type = "", EntityManagerInterface $em, TranslatorInterface $translator, ValidatorInterface $validator, FactureService $factureService)
  304.     {
  305.         $titre_modal = $translator->trans("Nouvelle facture");
  306.         $repo_objet  = $em->getRepository(Commande::class);
  307.         $objet       = $repo_objet->find($id);
  309.         $bonPrepa = clone $objet;
  310.         $bonPrepa->setDateBon(new \DateTime());
  313.         $user = $this->getUser();
  314.         $bonPrepa->setUtilisateur($user);
  315.         if (is_object($bonPrepa->getUtilisateur()) && ! empty($this->getParameter('utilisateur_site_internet')) && $bonPrepa->getUtilisateur()->getId(
  316.             ) == $this->getParameter('utilisateur_site_internet')) {
  317.         } else {
  318.             //$bonPrepa->setUtilisateur($user);
  319.         }
  321.         $form      = $this->createForm(FactureType::class, $bonPrepa);
  322.         $errors    = "";
  323.         $form->handleRequest($request);
  325.         $idsArticleCommande = $request->query->get('choixArticles');
  326.         $repo_objet         = $em->getRepository(Commande::class);
  327.         $objet              = $repo_objet->find($id);
  328.         $bonPrepa->setCommande($objet);
  331.         $link            = $this->generateUrl('dtc_facture_ajouter', ['id' => $objet->getId(), 'type' => 'commande', 'operation' => $request->query->get('operation')]);
  332.         $articleCommande = $em->getRepository(ArticleCommande::class)->listeArticleCommandeSelectionne($idsArticleCommande);
  334.         if ($form->isSubmitted()) {
  335.             if ($form->isValid()) {
  337.                 if ($objet->getTypeDocumentCommercial() == TypeDocumentCommercial::COMMANDE) {
  338.                     $url = $this->generateUrl('dtc_bon_preparation_modifier', ['id' => $objet->getId(), 'tab' => 'factures']);
  339.                 } else {
  340.                     $url = $this->generateUrl('dtc_ordre_reparation_modifier', ['id' => $objet->getId(), 'tab' => 'factures']);
  341.                 }
  342.                 if ($request->query->get('operation') == "or") {
  343.                     $objet->setFacture($bonPrepa);
  344.                     $bonPrepa->setCommande($objet);
  346.                 }
  349.                 //print_r($request->request->get('emplacement'));
  350.                 //echo "<div>POPOPOPOPOPOP</div>";
  351.                 $articles = [
  352.                     'emplacement'       => $request->request->get('emplacement'),
  353.                     'idArticleCommande' => $request->request->get('idArticleCommande'),
  354.                     'quantiteInit'      => $request->request->get('quantiteInit'),
  355.                     'quantite'          => $request->request->get('quantite'),
  356.                     'position'          => $request->request->get('position'),
  357.                 ];
  358.                 $valeurs  = ["articles" => $articles, 'operation' => $request->query->get('operation')];
  361.                 $factureService->sauvegarder($bonPrepa, $valeurs);
  363.                 if ($request->query->get('operation') == "or") {
  364.                     //if($factureService->resteDesArticlesSansFacture($objet)) {
  365.                     if ($factureService->resteDesArticlesSansFactureOuAvoir($objet)) {
  366.                         //echo "<div>RESTE</div>";
  367.                         $statutCommande = $em->getRepository(StatutCommande::class)->findOneBy(
  368.                             ["documentCommercial" => $objet->getTypeDocumentCommercial(), "ordre" => "3"]
  369.                         );
  370.                     } else {
  371.                         // echo "<div>RESTE PAS</div>";
  372.                         $statutCommande = $em->getRepository(StatutCommande::class)->findOneBy(
  373.                             ["documentCommercial" => $objet->getTypeDocumentCommercial(), "ordre" => "4"]
  374.                         );
  375.                     }
  376.                     $objet->setStatutCommande($statutCommande);
  377.                     $em->persist($objet);
  378.                     $em->flush();
  380.                 }
  381.                 $url = $this->generateUrl('dtc_facture_afficher', ["id" => $bonPrepa->getId()]);
  383.                 $this->addFlash(
  384.                     'notice',
  385.                     $translator->trans('Facture ajoutée avec succès !')
  386.                 );
  388.                 return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url]);
  390.             } else {
  391.                 $errors = $validator->validate($bonPrepa);
  392.                 $rendu  = $this->renderView(
  393.                     'GestionComerciale/Facture/ajouter.html.twig',
  394.                     [
  395.                         'form'            => $form->createView(),
  396.                         'errors'          => $errors,
  397.                         'id'              => $id,
  398.                         'type'            => $type,
  399.                         'articleCommande' => $articleCommande,
  400.                         'commande'        => $objet,
  401.                     ]
  402.                 );
  404.                 return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  405.             }
  406.         }
  407.         $rendu = $this->renderView(
  408.             'GestionComerciale/Facture/ajouter.html.twig',
  409.             ['form' => $form->createView(), 'errors' => $errors, 'id' => $id, 'type' => $type, 'articleCommande' => $articleCommande, 'commande' => $objet]
  410.         );
  412.         return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'link' => $link, 'titre' => $titre_modal]);
  413.     }
  416.     /**
  417.      * @Route("/vente/factures", name="dtc_facture_liste")
  418.      */
  419.     public function listerAction(Request $request, $id = "0", $type = "a", EntityManagerInterface $em, ColonneTableauService $serviceColonneTableau, Datatable $datatable, TranslatorInterface $translator)
  420.     {
  422.         $repo_objet = $em->getRepository(Commande::class);
  423.         $objet      = $repo_objet->find($id);
  425.         $param   = $request->query->all();
  427.         if (is_object($objet)) {
  429.             $tableau_class_cellule   = [];
  430.             $tableau_class_cellule[] = ["className" => "visible_export colonne_id text-center", "targets" => [0], "visible" => true, "orderable" => true];
  431.             $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [1], "visible" => true, "orderable" => true];
  432.             $tableau_class_cellule[] = ["className" => "visible_export colonne_id text-right", "targets" => [2], "visible" => true, "orderable" => true];
  433.             $tableau_class_cellule[] = ["className" => "visible_export colonne_id text-right", "targets" => [3], "visible" => true, "orderable" => true];
  434.             $tableau_class_cellule[] = ["className" => "visible_export colonne_id text-right", "targets" => [4], "visible" => true, "orderable" => true];
  435.             $tableau_class_cellule[] = ["orderable" => false, "className" => "colonne_id", "targets" => [5], "visible" => true];
  437.             $this->datatableCommande($objet, $type, $em, $datatable, $translator);
  439.             return $this->render(
  440.                 'GestionComerciale/Facture/lister_commande.html.twig',
  441.                 ['tableauClassColonne' => $tableau_class_cellule, "id" => $id, "type" => $type, 'parametres' => $param]
  442.             );
  443.         } else {
  444.             $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [0], "visible" => false, "orderable" => false];
  445.             $tableau_class_cellule[] = [
  446.                 "className" => "visible_export colonne_id",
  447.                 "targets"   => [1],
  448.                 "visible"   => $serviceColonneTableau->getColonneUtilisateur(Facture::class, "id"),
  449.             ];
  450.             $tableau_class_cellule[] = [
  451.                 "className" => "visible_export colonne_id text-center",
  452.                 "targets"   => [2],
  453.                 "visible"   => $serviceColonneTableau->getColonneUtilisateur(Facture::class, "date"),
  454.             ];
  455.             $tableau_class_cellule[] = [
  456.                 "className" => "visible_export colonne_id",
  457.                 "targets"   => [3],
  458.                 "visible"   => $serviceColonneTableau->getColonneUtilisateur(Facture::class, "reference"),
  459.             ];
  460.             $tableau_class_cellule[] = [
  461.                 "className" => "visible_export colonne_id",
  462.                 "targets"   => [4],
  463.                 "visible"   => $serviceColonneTableau->getColonneUtilisateur(Facture::class, "refCli"),
  464.             ];
  465.             $tableau_class_cellule[] = [
  466.                 "className" => "visible_export colonne_id",
  467.                 "targets"   => [5],
  468.                 "visible"   => $serviceColonneTableau->getColonneUtilisateur(Facture::class, "client"),
  469.             ];
  470.             $tableau_class_cellule[] = [
  471.                 "className" => "visible_export colonne_id",
  472.                 "targets"   => [6],
  473.                 "visible"   => $serviceColonneTableau->getColonneUtilisateur(Facture::class, "libelleLivraison"),
  474.             ];
  475.             $tableau_class_cellule[] = [
  476.                 "className" => "visible_export totalHT colonne_id text-right",
  477.                 "targets"   => [7],
  478.                 "visible"   => $serviceColonneTableau->getColonneUtilisateur(Facture::class, "totalHT"),
  479.             ];
  480.             $tableau_class_cellule[] = [
  481.                 "className" => "visible_export tva colonne_id text-right",
  482.                 "targets"   => [8],
  483.                 "visible"   => $serviceColonneTableau->getColonneUtilisateur(Facture::class, "tva"),
  484.             ];
  485.             $tableau_class_cellule[] = [
  486.                 "className" => "visible_export TotalTTC colonne_id text-right",
  487.                 "targets"   => [9],
  488.                 "visible"   => $serviceColonneTableau->getColonneUtilisateur(Facture::class, "totalTTC"),
  489.             ];
  490.             $tableau_class_cellule[] = [
  491.                 "className" => "visible_export",
  492.                 "targets"   => [10],
  493.                 "visible"   => $serviceColonneTableau->getColonneUtilisateur(Facture::class, "paye"),
  494.             ];
  495.             $tableau_class_cellule[] = ["orderable" => false, "className" => "colonne_id", "targets" => [11], "visible" => true];
  496.             $this->datatable($request, $datatable, $translator);
  498.             return $this->render('GestionComerciale/Facture/lister.html.twig', [
  499.                 "id"                  => $id,
  500.                 "type"                => $type,
  501.                 'tableauClassColonne' => $tableau_class_cellule,
  502.                 'parametres'          => $param,
  503.                 'statutsPaiement'     => $em->getRepository(StatutPaiement::class)->findAll()//->findBy(array('id'=>array(1,2)))
  504.             ]);
  505.         }
  506.     }
  509.     /**
  510.      * set datatable configs
  511.      *
  512.      * @return \App\Library\Datatable\Util\Datatable
  513.      */
  514.     private function datatable(Request $request, Datatable $datatable, TranslatorInterface $translator)
  515.     {
  518.         $param     = $request->query->all();
  520.         $datatable->setDatatableId('dta-factures')
  521.                   ->setEntity(Commande::class, "x")
  522.                   ->setFields(
  523.                       [
  524.                           $translator->trans("ID")                 => 'x.id',
  525.                           $translator->trans("Date")               => 'x.date',
  526.                           $translator->trans("Réf")                => 'x.reference',
  527.                           $translator->trans("Réf client")         => 'cl.reference',
  528.                           $translator->trans("Client")             => 'cl.nom',
  529.                           $translator->trans("Société / Nom")      => 'x.libelleLivraison',
  530.                           $translator->trans("Total HT")           => 'x.total',
  531.                           $translator->trans("TVA")                => 'x.totalTva',
  532.                           $translator->trans("Total TTC")          => 'x.totalTtc',
  533.                           //$translator->trans("Payée") =>  'sp.id',
  534.                           $translator->trans("Statut de paiement") => 'sp.libelle',
  535.                           $translator->trans("Actions")            => 'x.id',
  536.                           "_identifier_"                           => 'x.id',
  537.                       ]
  538.                   )
  539.                   ->addJoin('x.statutCommande', 's', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  540.                   ->addJoin('x.commande', 'c', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  541.                   ->addJoin('x.client', 'cl', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  542.                   ->addJoin('x.utilisateur', 'u', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  543.                   ->addJoin('x.statutPaiement', 'sp', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  544.             /*->setWhere(
  545.                     $type_jointure.' = :objet',
  546.                     array('objet' => $objet)
  547.                )
  548.               */
  550.                   ->setRenderers(
  551.                 [
  552.                     0  => [
  553.                         'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  554.                         'params' => [
  555.                             'edit_route' => 'dtc_facture_afficher',
  556.                         ],
  558.                     ],
  559.                     1  => [
  560.                         'view'   => 'FO/DataTable/heure.html.twig',
  561.                         'params' => [],
  563.                     ],
  564.                     2  => [
  565.                         'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  566.                         'params' => [
  567.                             'edit_route' => 'dtc_facture_afficher',
  568.                         ],
  570.                     ],
  571.                     3  => [
  572.                         'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  573.                         'params' => [
  574.                             'edit_route'   => 'dtc_client_modifier',
  575.                             'typeDocument' => 'client',
  576.                         ],
  577.                     ],
  578.                     4  => [
  579.                         'view'   => 'FO/DataTable/client.html.twig',
  580.                         'params' => [],
  582.                     ],
  583.                     6  => [
  584.                         'view'   => 'FO/DataTable/prix_total_ht.html.twig',
  585.                         'params' => [],
  587.                     ],
  588.                     7  => [
  589.                         'view'   => 'FO/DataTable/tva-prix.html.twig',
  590.                         'params' => [],
  592.                     ],
  593.                     8  => [
  594.                         'view'   => 'FO/DataTable/prix.html.twig',
  595.                         'params' => [],
  597.                     ],
  598.                     /*
  599.                     9 => array(
  600.                         'view' => 'FO/DataTable/facture_est_paye_solde.html.twig'
  602.                     ),
  603.                     */
  604.                     10 => [
  605.                         'view'   => 'FO/DataTable/actions_facture_avoir.html.twig',
  606.                         'params' => [
  607.                             'afficher_route_facture' => 'dtc_facture_afficher',
  608.                             'pdf_route_facture'      => 'dtc_facture_pdf',
  609.                             'edit_route_avoir'       => 'dtc_avoir_modifier',
  610.                             'pdf_route_avoir'        => 'dtc_avoir_pdf',
  611.                             'objet_facture'          => Facture::class,
  612.                             'objet_avoir'            => Avoir::class,
  613.                             'deplier'                => true,
  615.                         ],
  616.                     ],
  619.                 ]
  620.             )
  621.                   ->setMultiple(
  622.                       [
  623.                           'print' => [
  624.                               'title' => 'Imprimer',
  625.                               'route' => 'dtc_bon_preparation_pdf_multiple',
  626.                           ],
  627.                       ]
  628.                   )
  629.                   ->setOrder("x.id", "desc")
  630.                   ->setSearch(true)
  631.                   ->setSearchFields([2, 3, 4, 5, 9]);
  633.         $where      = 'x.typeDocumentCommercial IN (:typeDocumentCommercial) and x.visible = :visible ';
  634.         $parameters = ['typeDocumentCommercial' => [TypeDocumentCommercial::FACTURE, TypeDocumentCommercial::AVOIR], 'visible' => '1'];
  637.         if (array_key_exists('parametres', $param)) {
  638.             if ( ! empty($param["parametres"]["statutPaiement"])) {
  639.                 //$datatable->addJoin('x.client', 'client', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN);
  640.                 $parameters["statutPaiement"] = $param["parametres"]["statutPaiement"];
  641.                 if ($where != "") {
  642.                     $where .= " AND ";
  643.                 }
  644.                 $where .= "sp.id = :statutPaiement";
  645.             }
  646.             if (array_key_exists('client', $param["parametres"]) and $param["parametres"]["client"] > 0) {
  647.                 //$datatable->addJoin('x.client', 'client', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN);
  648.                 $parameters["client"] = $param["parametres"]["client"];
  649.                 if ($where != "") {
  650.                     $where .= " AND ";
  651.                 }
  652.                 $where .= "cl.id = :client";
  653.             }
  654.             if (array_key_exists('date_debut', $param["parametres"]) and $param["parametres"]["date_debut"] != "") {
  655.                 $param["parametres"]["date_debut"] = \DateTime::createFromFormat('d/m/Y', $param["parametres"]["date_debut"]);
  656.                 $param["parametres"]["date_debut"]->setTime(00, 00, 00);
  657.                 $parameters["date_debut"] = $param["parametres"]["date_debut"];
  658.                 if ($where != "") {
  659.                     $where .= " AND ";
  660.                 }
  661.                 $where .= "x.date >= :date_debut";
  662.             }
  663.             if (array_key_exists('date_fin', $param["parametres"]) and $param["parametres"]["date_fin"] != "") {
  664.                 $param["parametres"]["date_fin"] = \DateTime::createFromFormat('d/m/Y', $param["parametres"]["date_fin"]);
  665.                 $param["parametres"]["date_fin"]->setTime(23, 59, 59);
  666.                 $parameters["date_fin"] = $param["parametres"]["date_fin"];
  667.                 if ($where != "") {
  668.                     $where .= " AND ";
  669.                 }
  670.                 $where .= "x.date <= :date_fin";
  671.             }
  672.             if (array_key_exists('categorie_client', $param["parametres"]) and $param["parametres"]["categorie_client"] > 0) {
  673.                 //echo "AZERTYUI";
  674.                 $datatable->addJoin('cl.clientCategorie', 'cc', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN);
  675.                 $datatable->addJoin('cc.categorie', 'catC', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN);
  676.                 $parameters["categorie"] = $param["parametres"]["categorie_client"];
  677.                 $where                   .= "and catC = :categorie";
  679.                 if (array_key_exists('sous_categorie_client', $param["parametres"]) and $param["parametres"]["sous_categorie_client"] > 0) {
  681.                     $datatable->addJoin('cl.clientCategorie', 'cc2', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN);
  682.                     $datatable->addJoin('cc2.categorie', 'catC2', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN);
  684.                     $parameters["sous_categorie"] = $param["parametres"]["sous_categorie_client"];
  685.                     $where                        .= " and catC2 = :sous_categorie";
  686.                 }
  688.             }
  689.         }
  690.         //echo $where;
  691.         if ($where != '') {
  692.             //echo $where;
  693.             $datatable->setWhere($where, $parameters);
  694.         }
  697.         return $datatable;
  699.         /*
  700.         $datatable  ->setDatatableId('dta-factures')
  701.                     ->setEntity("DTCGestionComercialeBundle:Commande", "x")
  702.                     ->setFields(
  703.                             array(
  704.                                $translator->trans("ID") =>  'x.id',
  705.                                $translator->trans("Client") =>  'cl.nom',
  706.                                $translator->trans("Réf") =>  'x.reference',
  707.                                $translator->trans("Date") =>  'x.dateBon',
  708.                                $translator->trans("Actions") =>  'x.id',
  709.                                    "_identifier_" => 'x.id'
  710.                                    )
  711.                             )
  712.                     ->addJoin('x.commande', 'c', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  713.                     ->addJoin('x.client', 'cl', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  714.                      ->setWhere(
  715.                              'x.typeDocumentCommercial IN (:typeDocumentCommercial)',
  716.                              array('typeDocumentCommercial' => array(TypeDocumentCommercial::FACTURE, TypeDocumentCommercial::AVOIR))
  717.                         )
  718.                     ->setRenderers(
  719.                             array(
  720.                                 0 => array(
  721.                                 'view' => 'FO/DataTable/avec_lien_edit_route.html.twig',
  722.                                  'params' => array(
  723.                                             'edit_route'    => 'dtc_facture_afficher'
  724.                                         ),
  726.                                 ),
  727.                                 2 => array(
  728.                                 'view' => 'FO/DataTable/avec_lien_edit_route.html.twig',
  729.                                  'params' => array(
  730.                                             'edit_route'    => 'dtc_facture_afficher'
  731.                                         ),
  733.                                 ),
  735.                                 3 => array(
  736.                                     'view' => 'FO/DataTable/date.html.twig',
  737.                                     'params' => array(
  739.                                         ),
  740.                                 ),
  741.                                 4 => array(
  742.                                     'view' => 'FO/DataTable/actions_facture_avoir.html.twig',
  743.                                     'params' => array(
  744.                                             'afficher_route_facture'  => 'dtc_facture_afficher',
  745.                                             'pdf_route_facture'  => 'dtc_facture_pdf',
  746.                                             'edit_route_avoir'  => 'dtc_avoir_modifier',
  747.                                             'pdf_route_avoir'  => 'dtc_avoir_pdf',
  748.                                             'objet_facture' => Facture::class,
  749.                                             'objet_avoir' => "DTCGestionComercialeBundle:Avoir"
  750.                                         ),
  751.                                 ),
  754.                             )
  755.                     )
  756.                      ->setMultiple(
  757.                         array(
  758.                             'print' => array(
  759.                                 'title' => 'Imprimer',
  760.                                 'route' => 'dtc_facture_pdf_multiple'                            ),
  761.                         )
  762.                     )
  763.                     ->setOrder("x.id", "desc")
  764.                     ->setSearch(true)
  765.                     //->setSearchFields(array(1,2))
  766.                     ;
  767.         return $datatable;
  768.         */
  769.     }
  772.     /**
  773.      * set datatable configs
  774.      *
  775.      * @return \App\Library\Datatable\Util\Datatable
  776.      */
  777.     private function datatableCommande($objet, $type = "", EntityManagerInterface $em, Datatable $datatable, TranslatorInterface $translator)
  778.     {
  779.         //$type_jointure = 'x.'.$type;
  780.         $datatable->setDatatableId('dta-factures')
  781.                   ->setEntity(Commande::class, "x");
  783.         $repo_statut_document = $em->getRepository(StatutCommande::class);
  784.         $liste_statut         = $repo_statut_document->findBy(["documentCommercial" => 6, "ordre" => [0]]);
  786.         $parameters = ['objet' => $objet, 'typeDocumentCommercial' => TypeDocumentCommercial::FACTURE, 'statutCommande' => $liste_statut];
  787.         $where      = "x.commande = :objet AND x.typeDocumentCommercial = :typeDocumentCommercial  AND x.statutCommande NOT IN (:statutCommande) OR x.commande = :objet AND x.typeDocumentCommercial = ".TypeDocumentCommercial::AVOIR."  AND x.statutCommande NOT IN (:statutCommande) ";
  789.         if ($type == "bp") {
  791.             $where = "x.bp = :objet AND x.typeDocumentCommercial = :typeDocumentCommercial AND x.statutCommande NOT IN (:statutCommande) OR x.bp = :objet AND x.typeDocumentCommercial = ".TypeDocumentCommercial::AVOIR." AND x.statutCommande NOT IN (:statutCommande)";
  792.         } elseif ($type == "bl") {
  793.             //echo "OK";
  794.             $datatable->addJoin('x.bls', 'bl', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN);
  795.             $where               = "bl.id = :objet AND x.typeDocumentCommercial = :typeDocumentCommercial AND x.statutCommande NOT IN (:statutCommande) OR bl.id = :objet AND x.typeDocumentCommercial = ".TypeDocumentCommercial::AVOIR." AND x.statutCommande NOT IN (:statutCommande)";
  796.             $parameters['objet'] = $objet->getId();
  797.             //$where = "x.bl = :objet AND x.typeDocumentCommercial = :typeDocumentCommercial AND x.statutCommande NOT IN (:statutCommande)";
  798.         }
  801.         $datatable
  802.             ->setFields(
  803.                 [
  804.                     //$translator->trans("ID") =>  'x.id',
  805.                     $translator->trans("Date")      => 'x.date',
  806.                     $translator->trans("Réf")       => 'x.reference',
  807.                     $translator->trans("Total HT")  => 'x.total',
  808.                     $translator->trans("TVA")       => 'x.totalTva',
  809.                     $translator->trans("Total TTC") => 'x.totalTtc',
  810.                     $translator->trans("Actions")   => 'x.id',
  811.                     "_identifier_"                  => 'x.id',
  812.                 ]
  813.             )
  814.             ->setWhere(
  815.                 $where,
  816.                 $parameters
  818.             )
  819.             ->setRenderers(
  820.                 [
  821.                     1 => [
  822.                         'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  823.                         'params' => [
  824.                             'edit_route' => 'dtc_facture_afficher',
  825.                         ],
  827.                     ],
  828.                     0 => [
  829.                         'view'   => 'FO/DataTable/heure.html.twig',
  830.                         'params' => [],
  831.                     ],
  832.                     2 => [
  833.                         'view'   => 'FO/DataTable/prix.html.twig',
  834.                         'params' => [],
  836.                     ],
  837.                     3 => [
  838.                         'view'   => 'FO/DataTable/tva-prix.html.twig',
  839.                         'params' => [],
  841.                     ],
  842.                     4 => [
  843.                         'view'   => 'FO/DataTable/prix.html.twig',
  844.                         'params' => [],
  846.                     ],
  847.                     5 => [
  848.                         //'view' => 'FO/DataTable/actions_modal.html.twig',
  849.                         'view'   => 'FO/DataTable/actions.html.twig',
  850.                         'params' => [
  851.                             //'edit_route'  => 'dtc_facture_modifier',
  852.                             //'supprimer_route'  => 'dtc_facture_supprimer',
  853.                             'pdf_route' => 'dtc_facture_pdf',
  854.                             'id'        => $objet->getId(),
  855.                             'type'      => $type,
  856.                             'entite'    => 'bonPreparation',
  857.                             'objet'     => Commande::class,
  858.                             'deplier'   => true,
  860.                         ],
  861.                     ],
  864.                 ]
  865.             )
  866.             ->setOrder("x.id", "desc")
  867.             ->setSearch(true)//->setSearchFields(array(1,2))
  868.         ;
  870.         return $datatable;
  871.     }
  874.     /**
  875.      * @Route("/vente/facture/grid/{id}/{type}", name="dtc_facture_liste_grid")
  876.      */
  877.     public function gridAction(Request $request, $id = "", $type = "", EntityManagerInterface $em, Datatable $datatable, TranslatorInterface $translator)
  878.     {
  879.         $repo_objet = $em->getRepository(Commande::class);
  880.         $objet      = $repo_objet->find($id);
  882.         if (is_object($objet)) {
  883.             return $this->datatableCommande($objet, $type, $em, $datatable, $translator)->execute();
  884.         } else {
  885.             return $this->datatable($request, $datatable, $translator)->execute();
  886.         }
  888.     }
  891.     /**
  892.      * @Route("/facture/pdf2/{id}", name="dtc_facture_prestashop_pdf")
  893.      */
  894.     public function pdfFacturePrestashopAction(Request $request, Commande $objet, EntityManagerInterface $em, Pdf $snappy, CommandeService $service)
  895.     {
  897.         $param   = $request->query->all();
  898.         $cle_xml = $this->getParameter('cle_xml');
  899.         //$id_client = $this->getParameter('id');
  901.         $md5Get = $param["id"];
  904.         if ( ! array_key_exists("cle", $param) or $param["cle"] != $cle_xml) {
  905.             //echo "erreur";
  906.             throw new AccessDeniedException('This user does not have access to this section.');
  907.         }
  909.         $facture_ok = false;
  910.         $md5        = md5($objet->getClient()->getId());
  912.         if ($md5 == $md5Get) {
  913.             //echo "<div>FACOKOKO </div>";
  915.         } else {
  916.             throw new AccessDeniedException('This user does not have access to this section.');
  917.         }
  919.         if ($objet->getTypeDocumentCommercial() == TypeDocumentCommercial::DEVIS) {
  920.             $societe    = $em->getRepository(Societe::class)->find(1);
  921.             $date_Y     = date("Y");
  922.             $date_M     = date("m");
  923.             $date_D     = date("d");
  924.             $date       = $date_Y.'/'.$date_M.'/'.$date_D;
  925.             $chemin_pdf = 'PDF/DEVIS/'.$date.'/DEVIS-'.$objet->getReference().'.pdf';
  927.             if (file_exists($chemin_pdf)) {
  928.                 unlink($chemin_pdf);
  929.             }
  931.             $footer = $this->renderView('FO/PDF/footer_facture_pagination_pdf.html.html.twig', ['societe' => $societe, 'commande' => $objet]);
  932.             $header = $this->renderView('FO/PDF/header_devis_pdf.html.twig', ['societe' => $societe, 'commande' => $objet]);
  933.             //$snappy->setOption('page-size', 'A4');
  934.             $snappy->setOption('footer-html', $footer);
  935.             $snappy->setOption('header-html', $header);
  938.             $snappy->setOption('header-spacing', "4");
  939.             $snappy->setOption('footer-spacing', "3");
  942.             $snappy->setOption('disable-smart-shrinking', true);
  943.             //$snappy->setOption('print-media-type', false );
  945.             $snappy->setOption('page-height', "297");
  946.             $snappy->setOption('page-width', "210");
  949.             $reference     = $request->query->get('reference');
  950.             $mode          = $request->query->get('mode');
  951.             $forceQteDispo = $request->query->get('forceQteDispo');
  953.             $snappy->generateFromHtml(
  954.                 $this->renderView(
  955.                     'GestionComerciale/Devis/template_pdf.html.twig',
  956.                     [
  957.                         'commande'      => $objet,
  958.                         'societe'       => $societe,
  959.                         'reference'     => $reference,
  960.                         'mode'          => $mode,
  961.                         'forceQteDispo' => $forceQteDispo,
  962.                     ]
  963.                 ),
  964.                 $chemin_pdf
  965.             );
  966.         } elseif ($objet->getTypeDocumentCommercial() == TypeDocumentCommercial::COMMANDE) {
  967.             $retour     = $service->pdf($objet, [], 'true');
  968.             $chemin_pdf = $retour['chemin'];
  969.         } elseif ($objet->getTypeDocumentCommercial() == TypeDocumentCommercial::BL) {
  971.             $societe    = $em->getRepository(Societe::class)->find(1);
  972.             $date_Y     = date("Y");
  973.             $date_M     = date("m");
  974.             $date_D     = date("d");
  975.             $date       = $date_Y.'/'.$date_M.'/'.$date_D;
  976.             $chemin_pdf = 'PDF/BONSLIV/'.$date.'/BONLIV-'.$objet->getReference().'.pdf';
  978.             if (file_exists($chemin_pdf)) {
  979.                 unlink($chemin_pdf);
  980.             }
  983.             $footer = $this->renderView('FO/PDF/footer_facture_pagination_pdf.html.twig', ['societe' => $societe, 'commande' => $objet]);
  984.             $header = $this->renderView('FO/PDF/header_bl_pdf.html.twig', ['societe' => $societe, 'commande' => $objet]);
  985.             $snappy->setOption('header-html', $header);
  986.             $snappy->setOption('footer-html', $footer);
  987.             $snappy->setOption('header-spacing', "4");
  988.             $snappy->setOption('footer-spacing', "3");
  991.             $snappy->setOption('disable-smart-shrinking', true);
  992.             //$snappy->setOption('print-media-type', false );
  994.             $snappy->setOption('page-height', "297");
  995.             $snappy->setOption('page-width', "210");
  997.             $snappy->generateFromHtml(
  998.                 $this->renderView(
  999.                 //'GestionComerciale/BonLivraison/template_pdf.html.twig',
  1000.                     'GestionComerciale/BonLivraison/template_pdf.html.twig',
  1001.                     [
  1002.                         'commande' => $objet,
  1003.                         'societe'  => $societe,
  1004.                     ]
  1005.                 ),
  1006.                 $chemin_pdf
  1007.             );
  1008.         } elseif ($objet->getTypeDocumentCommercial() == TypeDocumentCommercial::FACTURE) {
  1009.             $societe    = $em->getRepository(Societe::class)->find(1);
  1010.             $date_Y     = date("Y");
  1011.             $date_M     = date("m");
  1012.             $date_D     = date("d");
  1013.             $date       = $date_Y.'/'.$date_M.'/'.$date_D;
  1014.             $chemin_pdf = 'PDF/FACTURES/'.$date.'/FAC-'.$objet->getReference().'.pdf';
  1016.             if (file_exists($chemin_pdf)) {
  1017.                 unlink($chemin_pdf);
  1018.             }
  1021.             $restant = $request->query->get('restant');
  1023.             $footer = $this->renderView('FO/PDF/footer_facture_pagination_pdf.html.twig', ['societe' => $societe]);
  1024.             $header = $this->renderView('FO/PDF/header_facture_pdf.html.twig', ['societe' => $societe, 'commande' => $objet]);
  1025.             $snappy->setOption('header-html', $header);
  1026.             $snappy->setOption('footer-html', $footer);
  1027.             $snappy->setOption('header-spacing', "4");
  1028.             $snappy->setOption('footer-spacing', "3");
  1030.             $snappy->setOption('disable-smart-shrinking', true);
  1031.             //$snappy->setOption('print-media-type', false );
  1033.             $snappy->setOption('page-height', "297");
  1034.             $snappy->setOption('page-width', "210");
  1036.             $donnees = [
  1037.                 'commande' => $objet,
  1038.                 'societe'  => $societe,
  1039.             ];
  1040.             if ($objet->getMultiBL() == true) {
  1041.                 $template      = 'GestionComerciale/Facture/template_pdf_traite.html.twig';
  1042.                 $repo_commande = $em->getRepository(Commande::class);
  1044.                 $donnees['bls']              = $repo_commande->findByFacture($objet->getId());
  1045.                 $donnees['afficher_restant'] = 0;
  1046.             } else {
  1047.                 $template                    = 'GestionComerciale/Facture/template_pdf.html.twig';
  1048.                 $donnees['afficher_restant'] = $restant;
  1049.             }
  1050.             $snappy->generateFromHtml(
  1051.                 $this->renderView(
  1052.                     $template,
  1053.                     $donnees
  1054.                 ),
  1055.                 $chemin_pdf
  1056.             );
  1057.         }
  1060.         $xml      = "<chemin><pdf>".$chemin_pdf."</pdf></chemin>";
  1061.         $response = new Response($xml);
  1062.         $response->headers->add(['Content-Type' => 'application/xml']);
  1064.         return $response;
  1066.         return $this->render('FO/PDF/conteneur_pdf.html.twig', [
  1067.             'objet'      => $facture,
  1068.             'chemin_pdf' => '/'.$chemin_pdf,
  1069.             'visualiser' => $request->query->get('visualiser'),
  1070.         ]);
  1071.     }
  1074.     /**
  1075.      * @Route("/facture/pdf/{id}", name="dtc_facture_pdf")
  1076.      */
  1077.     public function pdfFactureAction(Request $request, Commande $facture, EntityManagerInterface $em, Pdf $snappy, Kernel $kernel)
  1078.     {
  1080.         $societe    = $em->getRepository(Societe::class)->find(1);
  1081.         $date_Y     = date("Y");
  1082.         $date_M     = date("m");
  1083.         $date_D     = date("d");
  1084.         $date       = $date_Y.'/'.$date_M.'/'.$date_D;
  1085.         $chemin_pdf = 'PDF/FACTURES/'.$date.'/FAC-'.$facture->getReference().'.pdf';
  1087.         if (file_exists($chemin_pdf)) {
  1088.             unlink($chemin_pdf);
  1089.         }
  1091.         //return $this->render('GestionComerciale/Facture/template_pdf.html.twig',array('commande'  => $facture,'societe'  => $societe));
  1092.         $restant = $request->query->get('restant');
  1094.         $footer = $this->renderView('FO/PDF/footer_facture_pagination_pdf.html.twig', array('societe'  => $societe,'commande'  => $facture));
  1095.         //$footer = '';
  1096.         $header = $this->renderView('FO/PDF/header_facture_pdf.html.twig', ['societe' => $societe, 'commande' => $facture, 'dev' => $kernel->isDebug()]);
  1097.         //$snappy->setOption('page-size', 'A4');
  1098.         //$snappy->setOption('header-html', $header);
  1099.         $snappy->setOption('footer-html', $footer);
  1100.         //$snappy->setOption('header-html',$footer);
  1103.         $snappy->setOption('margin-left', 0);
  1104.         $snappy->setOption('margin-right', 0);
  1106.         $snappy->setOption('header-spacing', "4");
  1107.         $snappy->setOption('footer-spacing', "5");
  1109.         //print_r($_SERVER);
  1111.         if ( ! empty($_SERVER["HTTP_HOST"]) && in_array($_SERVER["HTTP_HOST"], ["cazin.local.tl", "cazin.home.mww"])) {
  1112.             $snappy->setOption('disable-smart-shrinking', false);
  1113.         } else {
  1114.             $snappy->setOption('disable-smart-shrinking', true);
  1115.         }
  1116.         //$snappy->setOption('print-media-type', false );
  1118.         $snappy->setOption('page-height', "297");
  1119.         $snappy->setOption('page-width', "210");
  1120.         $snappy->setOption('enable-local-file-access', true);
  1123.         $donnees = [
  1124.             'commande' => $facture,
  1125.             'societe'  => $societe,
  1126.         ];
  1127.         if ($facture->getMultiBL() == true) {
  1128.             $template      = 'GestionComerciale/Facture/template_pdf_traite.html.twig';
  1129.             $repo_commande = $em->getRepository(Commande::class);
  1131.             $donnees['bls']              = $repo_commande->findByFacture($facture->getId());
  1132.             $donnees['afficher_restant'] = 0;
  1133.         } else {
  1134.             $template                    = 'GestionComerciale/Facture/template_pdf.html.twig';
  1135.             $donnees['afficher_restant'] = $restant;
  1136.         }
  1137.         $snappy->generateFromHtml(
  1138.             $this->renderView(
  1139.                 $template,
  1140.                 $donnees
  1141.             ),
  1142.             $chemin_pdf
  1143.         );
  1146.         return $this->render('FO/PDF/conteneur_pdf.html.twig', [
  1147.             'objet'      => $facture,
  1148.             'chemin_pdf' => '/'.$chemin_pdf,
  1149.             'visualiser' => $request->query->get('visualiser'),
  1150.         ]);
  1151.         //return new RedirectResponse("/".$chemin_pdf);
  1152.     }
  1154.     /**
  1155.      * @Route("/vente/facture/imprimer/multiple", name="dtc_facture_pdf_multiple")
  1156.      */
  1157.     public function imprimerMultipleAction(Request $request, EntityManagerInterface $em)
  1158.     {
  1159.         $data       = $request->get('dataTables');
  1160.         $ids        = $data['actions'];
  1161.         $tableauPdf = [];
  1162.         $pdfRelier  = 'PDF/FACTURES/FAC-'.date('d-m-Y').'.pdf';
  1164.         //$ids = array("118","101","93");
  1166.         for ($i = 0; $i < count($ids); $i++) {
  1167.             $repo = $em->getRepository(Commande::class);
  1168.             $bon  = $repo->find($ids[$i]);
  1169.             if (is_object($bon)) {
  1170.                 $this->pdfFactureAction($bon, false);
  1171.                 $tableauPdf[] = $chemin_pdf = 'PDF/FACTURES/FAC-'.$bon->getReference().'.pdf';
  1172.             }
  1173.         }
  1174.         $cmd = "gs -q -dNOPAUSE -dBATCH -sDEVICE=pdfwrite -sOutputFile=$pdfRelier ";
  1175.         foreach ($tableauPdf as $file) {
  1176.             $cmd .= $file." ";
  1177.         }
  1178.         $result = shell_exec($cmd);
  1180.         return new JsonResponse(['target' => '_blank', 'url' => '/'.$pdfRelier, 'valide' => '1'], 200, ['Content-Type' => 'application/json']);
  1181.     }
  1184.     private function datatableAvoir($facture, Datatable $datatable, TranslatorInterface $translator)
  1185.     {
  1186.         $datatable->setDatatableId('dta-avoirs')
  1187.                   ->setEntity(Commande::class, "x")
  1188.                   ->setFields(
  1189.                       [
  1190.                           $translator->trans("ID")       => 'x.id',
  1191.                           $translator->trans("Réf")      => 'x.reference',
  1192.                           $translator->trans("Client")   => 'clt.nom',
  1193.                           $translator->trans("Total HT") => 'x.total',
  1194.                           $translator->trans("Utilise")  => 'x.avoirUtilise',
  1195.                           $translator->trans("Date")     => 'x.date',
  1196.                           $translator->trans("Actions")  => 'x.id',
  1197.                           "_identifier_"                 => 'x.id',
  1198.                       ]
  1199.                   )
  1200.                   ->setWhere(
  1201.                       'x.facture = :facture AND x.typeDocumentCommercial = :typeDocumentCommercial',
  1202.                       ['facture' => $facture, 'typeDocumentCommercial' => TypeDocumentCommercial::AVOIR]
  1203.                   )
  1204.                   ->addJoin('x.commande', 'c', \Doctrine\ORM\Query\Expr\Join::INNER_JOIN)
  1205.                   ->addJoin('c.client', 'clt', \Doctrine\ORM\Query\Expr\Join::INNER_JOIN)
  1206.                   ->setRenderers(
  1207.                       [
  1208.                           3 => [
  1209.                               'view' => 'FO/DataTable/prix.html.twig',
  1211.                           ],
  1212.                           4 => [
  1213.                               'view'   => 'FO/DataTable/booleen.html.twig',
  1214.                               'params' => [],
  1215.                           ],
  1216.                           5 => [
  1217.                               'view'   => 'FO/DataTable/date.html.twig',
  1218.                               'params' => [],
  1219.                           ],
  1220.                           6 => [
  1221.                               'view'   => 'FO/DataTable/actions_modal.html.twig',
  1222.                               'params' => [
  1223.                                   'edit_route'  => 'dtc_avoir_modifier_modal',
  1224.                                   'width_modal' => '1200',
  1225.                                   //'supprimer_route'  => 'dtc_facture_supprimer',
  1226.                                   'pdf_route'   => 'dtc_avoir_pdf',
  1227.                                   'id'          => $facture->getId(),
  1228.                                   'type'        => 'avoir',
  1229.                                   'entite'      => 'avoir',
  1230.                                   'objet'       => Commande::class,
  1232.                               ],
  1233.                           ],
  1234.                           /*3 => array(
  1235.                               'view' => 'FO/DataTable/actions_modal.html.twig',
  1236.                               'params' => array(
  1237.                                       'supprimer_route'  => 'dtc_application_supprimer',
  1238.                                       'id'    => $article->getId(),
  1239.                                       'type'    => "article",
  1240.                                       'entite'    => 'application',
  1241.                                       'objet' => "DTCVehiculesBundle:Application"
  1243.                                   ),
  1244.                           )
  1245.                           */
  1246.                       ]
  1247.                   )
  1248.                   ->setOrder("x.id", "desc")
  1249.                   ->setSearch(true)
  1250.                   ->setSearchFields([0]);
  1252.         return $datatable;
  1253.     }
  1255.     /**
  1256.      * @Route("/vente/facture/avoirs/grid/{id}", name="dtc_facture_avoir_liste_grid")
  1257.      */
  1258.     public function gridAvoirsAction(Request $request, Commande $facture, Datatable $datatable, TranslatorInterface $translator)
  1259.     {
  1260.         return $this->datatableAvoir($facture, $datatable, $translator)->execute();
  1261.     }
  1263.     /**
  1264.      * @Route("/vente/facture-traite", name="dtc_facture_traite")
  1265.      */
  1266.     public function traiteAction(Request $request, EntityManagerInterface $em, Datatable $datatable, TranslatorInterface $translator)
  1267.     {
  1269.         $repo_commande = $em->getRepository(Commande::class);
  1270.         $errors        = '';
  1272.         $dateDebut = new \DateTime();
  1273.         $interval  = new \DateInterval('P7D');
  1274.         $dateDebut->sub($interval);
  1276.         $dateFin       = new \DateTime('yesterday');
  1277.         $dateFinPlusUn = new \DateTime();
  1279.         $dateFacturation = new \DateTime();
  1281.         if ($request->getMethod() == 'POST') {
  1282.             $dateDebutRequest = $request->request->get('dateDebut');
  1283.             $dateFinRequest   = $request->request->get('dateFin');
  1284.             $ids              = $request->request->get('ids');
  1286.             $dateDebut     = date_create_from_format('d/m/Y', $dateDebutRequest);
  1287.             $dateFin       = date_create_from_format('d/m/Y', $dateFinRequest);
  1288.             $dateFinPlusUn = date_create_from_format('d/m/Y', $dateFinRequest);
  1290.             $interval = new \DateInterval('P1D');
  1291.             $dateFinPlusUn->add($interval);
  1293.             if (count($ids) > 0) {
  1294.                 foreach ($ids as $id) {
  1295.                     $bl = $repo_commande->find($id);
  1296.                     if (is_object($bl)) {
  1297.                         $bl->setAFacturer(true);
  1298.                         $em->persist($bl);
  1299.                     }
  1300.                 }
  1301.                 $em->flush();
  1302.             }
  1303.         }
  1305.         $tableau_class_cellule[] = [];
  1308.         //$tableau_class_cellule[]=array("className"=>"colonne_id","targets"=>array(0),"visible"=>true,"orderable"=>false,"searchable"=> false);
  1310.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [0], "visible" => false, "orderable" => true];
  1311.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id colonnefacturer ", "targets" => [1], "visible" => true, "orderable" => false];
  1312.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id colonnefacturerseparement", "targets" => [2], "visible" => true, "orderable" => false];
  1313.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id colonneattente ", "targets" => [3], "visible" => true, "orderable" => false];
  1314.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id text-center", "targets" => [4], "visible" => true, "orderable" => true];
  1316.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id text-center", "targets" => [5], "visible" => true, "orderable" => true];
  1318.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [6], "visible" => true, "orderable" => true];
  1319.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [7], "visible" => true, "orderable" => true];
  1320.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [8], "visible" => true, "orderable" => true];
  1321.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [9], "visible" => true, "orderable" => true];
  1322.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id text-right", "targets" => [10], "visible" => true, "orderable" => true];
  1323.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id text-right", "targets" => [11], "visible" => true, "orderable" => true];
  1324.         $tableau_class_cellule[] = ["orderable" => false, "className" => "colonne_id", "targets" => [12], "visible" => true];
  1325.         /*
  1326.     $tableau_class_cellule[]=array("className"=>"colonne_id","targets"=>array(1),"visible"=>$serviceColonneTableau->getColonneUtilisateur("DTCClientsBundle:Client","id"));
  1327.     $tableau_class_cellule[]=array("className"=>"colonne_id","targets"=>array(2),"visible"=>$serviceColonneTableau->getColonneUtilisateur("DTCClientsBundle:Client","logo"));
  1328.     $tableau_class_cellule[]=array("className"=>"colonne_id","targets"=>array(3),"visible"=>$serviceColonneTableau->getColonneUtilisateur("DTCClientsBundle:Client","reference"));
  1329.     $tableau_class_cellule[]=array("className"=>"colonne_id","targets"=>array(4),"visible"=>$serviceColonneTableau->getColonneUtilisateur("DTCClientsBundle:Client","nom"));
  1330.     $tableau_class_cellule[]=array("className"=>"colonne_id","targets"=>array(5),"visible"=>$serviceColonneTableau->getColonneUtilisateur("DTCClientsBundle:Client","prenom"));
  1331.     $tableau_class_cellule[]=array("className"=>"colonne_id","targets"=>array(6),"visible"=>$serviceColonneTableau->getColonneUtilisateur("DTCClientsBundle:Client","ville"));
  1332.     $tableau_class_cellule[]=array("className"=>"colonne_id","targets"=>array(7),"visible"=>$serviceColonneTableau->getColonneUtilisateur("DTCClientsBundle:Client","codePostal"));
  1333.     $tableau_class_cellule[]=array("className"=>"colonne_id","targets"=>array(8),"visible"=>$serviceColonneTableau->getColonneUtilisateur("DTCClientsBundle:Client","pays"));
  1334.     $tableau_class_cellule[]=array("className"=>"colonne_id","targets"=>array(9),"visible"=>$serviceColonneTableau->getColonneUtilisateur("DTCClientsBundle:Client","telephone"));
  1335.     $tableau_class_cellule[]=array("className"=>"colonne_id","targets"=>array(10),"visible"=>$serviceColonneTableau->getColonneUtilisateur("DTCClientsBundle:Client","telephone2"));
  1336.     $tableau_class_cellule[]=array("className"=>"colonne_id","targets"=>array(11),"visible"=>$serviceColonneTableau->getColonneUtilisateur("DTCClientsBundle:Client","email"));
  1337.     $tableau_class_cellule[]=array("className"=>"colonne_id","targets"=>array(12),"visible"=>$serviceColonneTableau->getColonneUtilisateur("DTCClientsBundle:Client","tva"));
  1338.     */
  1339.         $this->datatableTraite($dateDebut->format('Y-m-d'), $dateFinPlusUn->format('Y-m-d'), $em, $datatable, $translator);
  1341.         return $this->render('GestionComerciale/Traite/lister.html.twig', [
  1342.             'tableauClassColonne' => $tableau_class_cellule,
  1343.             'dateDebut'           => $dateDebut,
  1344.             'dateFin'             => $dateFin,
  1345.             'dateFinPlusUn'       => $dateFinPlusUn,
  1346.             'errors'              => $errors,
  1347.             'dateFacturation'     => $dateFacturation,
  1348.         ]);
  1349.     }
  1351.     private function datatableTraite_old($dateDebut, $dateFin, Datatable $datatable, TranslatorInterface $translator)
  1352.     {
  1354.         $datatable->setEntity(Client::class, "x")
  1355.                   ->setFields(
  1356.                       [
  1357.                           $translator->trans("ID")          => 'x.id',
  1358.                           $translator->trans("Réf")         => 'x.reference',
  1359.                           $translator->trans("Nom")         => 'x.nom',
  1360.                           $translator->trans("Prénom")      => 'x.prenom',
  1361.                           $translator->trans("Téléphone")   => 'x.telephone',
  1362.                           $translator->trans("Téléphone 2") => 'x.telephone2',
  1363.                           $translator->trans("Email")       => 'x.email',
  1364.                           $translator->trans("TVA")         => 'x.numTva',
  1365.                           $translator->trans("Actions")     => 'x.id',
  1366.                           "_identifier_"                    => 'x.id',
  1367.                       ]
  1368.                   )
  1369.             //->addJoin('x.modereglement', 'mr', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1370.             //->addJoin('x.ville', 'v', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1371.             //->addJoin('x.pays', 'p', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1372.             //->addJoin('x.codePostal', 'cp', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1373.             //->addJoin('x.typeClient', 'tp', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1374.                   ->addJoin(Commande::class, 'c', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN, 'with', 'c.client = x.id')
  1375.             //->setWhere('mr.id = :modeReglement '
  1376.                   ->setWhere(
  1377.                 'x.facturationMultiBL = :facturationMultiBL '
  1378.                 .'and c.typeDocumentCommercial = :typeDocumentCommercial '
  1379.                 .'and c.visible = :visible '
  1380.                 .'AND c.date <= :dateFin '
  1381.                 .'AND c.date >= :dateDebut '
  1382.                 .'AND c.dejaFacture = false',
  1383.                 //array('modeReglement'=>6,'typeDocumentCommercial' => TypeDocumentCommercial::BL,'visible'=>1, 'dateFin'=>$dateFin, 'dateDebut'=>$dateDebut))
  1384.                 ['facturationMultiBL' => true, 'typeDocumentCommercial' => TypeDocumentCommercial::BL, 'visible' => 1, 'dateFin' => $dateFin, 'dateDebut' => $dateDebut]
  1385.             )
  1386.                   ->setRenderers(
  1387.                       [
  1388.                           0 => [
  1389.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  1390.                               'params' => [
  1391.                                   'edit_route' => 'dtc_client_modifier',
  1392.                               ],
  1394.                           ],
  1395.                           1 => [
  1396.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  1397.                               'params' => [
  1398.                                   'edit_route' => 'dtc_client_modifier',
  1399.                               ],
  1401.                           ],
  1403.                           8 => [
  1404.                               'view'   => 'FO/DataTable/traite_modal.html.twig',
  1405.                               'params' => [
  1406.                                   'edit_route' => 'dtc_bon_livraison_liste_by_client',
  1407.                                   'dateDebut'  => $dateDebut,
  1408.                                   'dateFin'    => $dateFin,
  1409.                               ],
  1410.                           ],
  1411.                           /*
  1412.                           12 => array(
  1413.                               'view' => 'FO/DataTable/actions.html.twig',
  1414.                               'params' => array(
  1415.                                       'edit_route'    => 'dtc_client_modifier',
  1416.                                       'dupliquer_route'    => 'dtc_client_dupliquer',
  1417.                                       //'supprimer_route'    => 'dtc_client_supprimer',
  1418.                                       'objet'    => 'DTCClientsBundle:Client'
  1419.                                   ),
  1420.                           ),
  1421.                            *
  1422.                            */
  1424.                       ]
  1425.                   )
  1426.                   ->setMultiple(
  1427.                       [
  1428.                           /*'delete' => array(
  1429.                               'title' => 'Non disponible',
  1430.                               'route' => 'dtc_client_liste_supprimer'     ),
  1431.                            *
  1432.                            */
  1433.                           'facturer' => [
  1434.                               'title' => 'Facturer',
  1435.                               'route' => 'dtc_client_multi_bl_facturer',
  1436.                           ],
  1438.                       ]
  1439.                   )
  1440.                   ->setOrder("x.id", "desc")
  1441.                   ->setGroupBy("x.id")
  1442.                   ->setSearch(true)
  1443.                   ->setSearchFields([1, 2, 3, 6]);
  1445.         //$datatable->setSearchFields(array(0,2));
  1446.         return $datatable;
  1447.     }
  1449.     private function datatableTraite($dateDebut, $dateFin, EntityManagerInterface $em, Datatable $datatable, TranslatorInterface $translator)
  1450.     {
  1452.         $repo_statut_document = $em->getRepository(StatutCommande::class);
  1453.         $liste_statut         = $repo_statut_document->findBy(["documentCommercial" => 5, "ordre" => [0]]);
  1455.         $datatable->setDatatableId('dta-bonlivraisons')
  1456.                   ->setEntity(Commande::class, "x")
  1457.                   ->setFields(
  1458.                       [
  1459.                           $translator->trans("ID")                    => 'x.id',
  1460.                           $translator->trans("A facturer")            => 'x.id',
  1461.                           $translator->trans("A facturer séparément") => 'x.id',
  1462.                           $translator->trans("En attente")            => 'x.id',
  1465.                           $translator->trans("Email") => 'cl.emailFactureAuto',
  1468.                           $translator->trans("Date")         => 'x.date',
  1469.                           $translator->trans("Réf")          => 'x.reference',
  1470.                           $translator->trans("Réf client")   => 'cl.reference',
  1471.                           $translator->trans("Client")       => 'cl.nom',
  1472.                           $translator->trans("Réf cmde cli") => 'x.referenceClient',
  1473.                           $translator->trans("Total HT")     => 'x.total',
  1474.                           $translator->trans("Total TTC")    => 'x.totalTtc',
  1475.                           $translator->trans("Actions")      => 'x.id',
  1476.                           "_identifier_"                     => 'x.id',
  1477.                       ]
  1478.                   )
  1479.             //->addJoin('x.pays', 'p', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1480.             /*->setWhere(
  1481.                     $type_jointure.' = :objet',
  1482.                     array('objet' => $objet)
  1483.                )
  1484.               */
  1485.                   ->addJoin('x.statutCommande', 's', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1486.                   ->addJoin('x.commande', 'c', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1487.                   ->addJoin('x.client', 'cl', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1488.                   ->addJoin('x.utilisateur', 'u', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1489.                   ->setWhere(
  1490.                   //'x.aFacturer = :aFacturer '
  1491.                   //'x.dejaFacture = :dejaFacture '
  1492.                       'x.facture is null '
  1493.                       .'AND cl.facturationMultiBL = :facturationMultiBL '
  1494.                       .'AND x.typeDocumentCommercial = :typeDocumentCommercial '
  1495.                       .'AND x.statutCommande NOT IN (:statutCommande) '
  1496.                       .'AND x.date <= :dateFin '
  1497.                       .'AND x.date >= :dateDebut',
  1498.                       [
  1499.                           'facturationMultiBL'     => true,
  1500.                           //'aFacturer'=>true,
  1501.                           //'dejaFacture' =>false,
  1502.                           'typeDocumentCommercial' => TypeDocumentCommercial::BL,
  1503.                           'statutCommande'         => $liste_statut,
  1504.                           'dateFin'                => $dateFin,
  1505.                           'dateDebut'              => $dateDebut,
  1506.                       ]
  1507.                   )
  1508.                   ->setRenderers(
  1509.                       [
  1510.                           0 => [
  1511.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  1512.                               'params' => [
  1513.                                   'edit_route' => 'dtc_bon_livraison_modifier',
  1514.                               ],
  1516.                           ],
  1517.                           1 => [
  1518.                               'view'   => 'FO/DataTable/choix-radio.html.twig',
  1519.                               'params' => [
  1520.                                   'name'  => 'facturation',
  1521.                                   'value' => 1,
  1522.                               ],
  1524.                           ],
  1525.                           2 => [
  1526.                               'view'   => 'FO/DataTable/choix-radio.html.twig',
  1527.                               'params' => [
  1528.                                   'name'  => 'facturation',
  1529.                                   'value' => 2,
  1530.                               ],
  1532.                           ],
  1533.                           3 => [
  1534.                               'view'   => 'FO/DataTable/choix-radio.html.twig',
  1535.                               'params' => [
  1536.                                   'name'  => 'facturation',
  1537.                                   'value' => 3,
  1538.                               ],
  1540.                           ],
  1541.                           4 => [
  1542.                               'view'   => 'FO/DataTable/booleen_mail_facture.html.twig',
  1543.                               'params' => [],
  1545.                           ],
  1548.                           5  => [
  1549.                               'view'   => 'FO/DataTable/heure.html.twig',
  1550.                               'params' => [],
  1552.                           ],
  1553.                           6  => [
  1554.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  1555.                               'params' => [
  1556.                                   'edit_route' => 'dtc_bon_livraison_modifier',
  1557.                               ],
  1559.                           ],
  1560.                           10 => [
  1561.                               'view'   => 'FO/DataTable/total_ht_commande.html.twig',
  1562.                               'params' => [],
  1564.                           ],
  1565.                           11 => [
  1566.                               'view'   => 'FO/DataTable/prix.html.twig',
  1567.                               'params' => [],
  1569.                           ],
  1572.                           12 => [
  1573.                               'view'   => 'FO/DataTable/actions.html.twig',
  1574.                               'params' => [
  1575.                                   'edit_route' => 'dtc_bon_livraison_modifier',
  1576.                                   //'supprimer_route'  => 'dtc_bon_livraison_supprimer',
  1577.                                   'pdf_route'  => 'dtc_bon_livraison_pdf',
  1578.                                   'entite'     => 'bonPreparation',
  1579.                                   'objet'      => Commande::class,
  1581.                               ],
  1582.                           ],
  1585.                       ]
  1586.                   )
  1587.                   ->setOrder("x.id", "desc")
  1588.                   ->setSearch(true)
  1589.                   ->setSearchFields([5, 6, 7, 8])/*
  1590.                     ->setMultiple(
  1591.                         array(
  1593.                             'facturer' => array(
  1594.                                 'title' => 'Facturer',
  1595.                                 'route' => 'dtc_client_multi_bl_facturer'
  1596.                             ),
  1598.                         )
  1599.                     )
  1600.                      *
  1601.                      */
  1602.         ;
  1604.         return $datatable;
  1605.     }
  1607.     /**
  1608.      * @Route("/vente/facture-traite/grid", name="dtc_traite_liste_grid")
  1609.      */
  1610.     public function gridTraiteAction(Request $request, EntityManagerInterface $em, Datatable $datatable, TranslatorInterface $translator)
  1611.     {
  1612.         if ( ! empty($request->query->get('dateDebut'))) {
  1613.             //var_dump($request->query->get('dateDebut'));
  1614.             //var_dump($request->query->get('dateFin'));
  1615.             //$dateDebut = $request->query->get('dateDebut');
  1616.             //$dateFin = $request->query->get('dateFin');
  1617.             $dateDebut = \DateTime::createFromFormat('Y-m-d', $request->query->get('dateDebut'))->setTime(0, 0, 0);
  1618.             $dateFin   = \DateTime::createFromFormat('Y-m-d', $request->query->get('dateFin'))->setTime(23, 59, 59);
  1619.         } else {
  1620.             $parametres = $request->query->get('parametres');
  1622.             $dateDebut = \DateTime::createFromFormat('d/m/Y', $parametres['dateDebut'])->setTime(0, 0, 0);
  1623.             $dateFin   = \DateTime::createFromFormat('d/m/Y', $parametres['dateFin'])->setTime(23, 59, 59);
  1624.         }
  1627.         //var_dump($dateDebut);
  1629.         return $this->datatableTraite($dateDebut, $dateFin, $em, $datatable, $translator)->execute();
  1630.     }
  1632.     /**
  1633.      * @Route("/vente/facture-multi-bl/facturer", name="dtc_client_multi_bl_facturer")
  1634.      */
  1635.     public function facturerMultiBLAction(Request $request, EntityManagerInterface $em, FactureService $factureService, BonLivraisonService $bonService)
  1636.     {
  1638.         set_time_limit(300);
  1640.         $repo_commande  = $em->getRepository(Commande::class);
  1642.         $clientsAFacturer       = [];
  1643.         $blsAFacturerSeparement = [];
  1644.         $blsEnAttente           = [];
  1645.         $compteur               = 0;
  1647.         $bls                    = $request->request->get('facturation');
  1648.         $dateFacturationRequest = $request->request->get('dateFacturation');
  1650.         $dateFacturation = date_create_from_format('d/m/Y', $dateFacturationRequest);
  1651.         //\Doctrine\Common\Util\Debug::dump($bls);
  1653.         if (count($bls) > 0) {
  1654.             foreach ($bls as $key => $action) {
  1655.                 //Recuperer le bl
  1656.                 $bl = $repo_commande->find($key);
  1657.                 if (is_object($bl)) {
  1658.                     if (is_object($bl->getFacture())) {
  1659.                         $this->addFlash('warning', 'le BL '.$bl->getReference().' est déjà facturé!');
  1660.                     } else {
  1661.                         switch ($action) {
  1662.                             case 1://Facturation multi-bl
  1663.                                 $clientId                    = $bl->getClient()->getId();
  1664.                                 $clientsAFacturer[$clientId] = $clientId;
  1665.                                 $bl->setAFacturer(true);
  1666.                                 $bl->setAttenteFacturation(false);
  1667.                                 $em->persist($bl);
  1668.                                 break;
  1670.                             case 2://Facturation separee
  1671.                                 $bonService->transformerBLenFacture($bl, $dateFacturation);
  1672.                                 $compteur++;
  1673.                                 break;
  1675.                             case 3://En attente
  1676.                                 $bl->setAttenteFacturation(true);
  1677.                                 $em->persist($bl);
  1678.                                 break;
  1679.                         }
  1680.                     }
  1681.                 }
  1682.             }
  1683.             $em->flush();
  1684.         }
  1686.         if (count($clientsAFacturer) > 0) {
  1687.             foreach ($clientsAFacturer as $clientId) {
  1688.                 $compteur++;
  1689.                 $facture = $factureService->creerFactureMultiBL($clientId, $dateFacturation);
  1691.             }
  1692.         }
  1694.         if ($compteur == 1) {
  1695.             $message = $compteur.' facture ajoutée avec succès !';
  1696.         } elseif ($compteur > 1) {
  1697.             $message = $compteur.' factures ajoutées avec succès !';
  1698.         } else {
  1700.             $message = 'Aucune facture ajoutée';
  1701.             $this->addFlash('notice', $message);
  1703.             return $this->redirectToRoute('dtc_facture_traite');
  1704.         }
  1706.         $this->addFlash('notice', $message);
  1708.         /*
  1709.     //$clientsIds = $request->request->get('dataTables[actions]');
  1710.     $data = $request->get('dataTables');
  1711. $clientsIds  = $data['actions'];
  1712.     $x = count($clientsIds);
  1714.     if ($x > 0)
  1715.         foreach($clientsIds as $clientId){
  1716.     $factureService->creerFactureMultiBL($clientId);
  1717.         }
  1719.     if($x == 1)
  1720.         $message = $x.' facture ajoutée avec succès !';
  1721.     else if ($x > 1)
  1722.         $message = $x.' factures ajoutées avec succès !';
  1723.     else
  1724.         $message = '';
  1726.     $this->addFlash(
  1727.                 'notice',
  1728.                 $message
  1729.           );
  1731.     $url = $this->generateUrl('dtc_facture_liste');
  1732. return new JsonResponse(array('url'=>$url,'valide'=>'1'), 200, array('Content-Type'=>'application/json'));
  1733.          *
  1734.          */
  1736.         return $this->redirectToRoute('dtc_facture_liste');
  1737.     }
  1739.     /**
  1740.      * @Route("/facture/charger-tableau/{id}/{type}", name="dtc_facture_charger_tableau")
  1741.      */
  1742.     public function chargerTableauAction(Request $request, Commande $commande, $type = "")
  1743.     {
  1744.         $rendu = $this->renderView('GestionComerciale/Facture/charger_tableau.html.twig', ["commande" => $commande, 'type' => $type]);
  1746.         return new JsonResponse(['rendu' => $rendu]);
  1748.     }
  1749. }