src/Controller/GestionComerciale/DevisController.php line 823

Open in your IDE?
  1. <?php
  3. namespace App\Controller\GestionComerciale;
  5. use App\Entity\Clients\Client;
  6. use App\Entity\FO\MessagePredefini;
  7. use App\Entity\FO\Societe;
  8. use App\Entity\Ged\Fichier;
  9. use App\Entity\GestionComerciale\Commande;
  10. use App\Entity\GestionComerciale\Devis;
  11. use App\Model\GestionCommerciale\TypeDocumentCommercial;
  12. use App\Entity\Notes\Categorie;
  13. use App\Entity\Notes\Note;
  14. use App\Entity\Notes\Statut;
  15. use App\Entity\Utilisateur\Droit;
  16. use App\Form\GestionComerciale\DevisType;
  17. use App\Form\GestionComerciale\PerduDevisType;
  18. use App\Form\GestionComerciale\ReouvrirDevisType;
  19. use App\Form\GestionComerciale\SupprimerDevisType;
  20. use App\Library\Datatable\Util\Datatable;
  21. use App\Security\Voter\EntityVoter;
  22. use App\Service\GestionComerciale\CommandeService;
  23. use App\Service\Notes\NoteService;
  24. use App\Service\Utilisateur\ColonneTableauService;
  25. use Doctrine\ORM\EntityManagerInterface;
  26. use Knp\Snappy\Pdf;
  27. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  28. use Symfony\Component\HttpFoundation\Request;
  29. use Symfony\Component\HttpFoundation\JsonResponse;
  30. use Symfony\Component\HttpFoundation\Response;
  32. use Symfony\Component\Routing\Annotation\Route;
  33. use Symfony\Component\Validator\Validator\ValidatorInterface;
  34. use Symfony\Contracts\Translation\TranslatorInterface;
  35. use Twig\Environment;
  37. class DevisController extends AbstractController
  38. {
  40.     /**
  41.      * @Route("/vente/devis/nouveau", name="dtc_devis_ajouter")
  42.      */
  43.     public function ajouterAction(Request $request, EntityManagerInterface $em, CommandeService $commandeService, TranslatorInterface $translator, ValidatorInterface $validator)
  44.     {
  45.         $commande = new Commande;
  46.         $user     = $this->getUser();
  47.         $commande->setUtilisateur($user);
  48.         $form   = $this->createForm(DevisType::class, $commande);
  49.         $errors = "";
  50.         $form->handleRequest($request);
  51.         if ($form->isSubmitted()) {
  52.             if ($form->isValid()) {
  54.                 $articles = [
  55.                     'ids'                      => $request->request->get('ids'),
  56.                     'remise'                   => $request->request->get('remise'),
  57.                     'montantRemise'            => $request->request->get('montantRemise'),
  58.                     'commentaire'              => $request->request->get('commentaire'),
  59.                     'libellesSecondaires'      => $request->request->get('libellesSecondaires'),
  60.                     'libelles'                 => $request->request->get('libelles'),
  61.                     'tva'                      => $request->request->get('tva'),
  62.                     'idsTva'                   => $request->request->get('idsTva'),
  63.                     'remiseSuppl'              => $request->request->get('remiseSuppl'),
  64.                     'ecocontribution'          => $request->request->get('ecocontribution'),
  65.                     'prix'                     => $request->request->get('prix'),
  66.                     //'fraisPortLigne'=>$request->request->get('fraisPortLigne'),
  67.                     'qte'                      => $request->request->get('qte'),
  68.                     'force'                    => $request->request->get('force'),
  69.                     'transporteurs'            => $request->request->get('transporteurs'),
  70.                     'articlesCommandeAssocies' => $request->request->get('articlesCommandeAssocies'),
  71.                     'tabPrixAchatNetEuros'     => $request->request->get('tabPrixAchatNetEuros'),
  72.                 ];
  73.                 $valeurs  = ["articles" => $articles, 'typeDocument' => 'devis', 'operation' => 'devis'];
  75.                 $em->persist($commande);
  76.                 $em->flush();
  78.                 $this->addFlash('notice', $translator->trans('Devis ajouté avec succès !'));
  79.                 $commandeService->sauvegarder($commande, $valeurs);
  80.                 $commandeService->changeDateLivraisonTheoriqueCommandeProcess($commande);
  82.                 //\Doctrine\Common\Util\Debug::dump($idsArticle);
  83.                 return $this->redirectToRoute('dtc_devis_liste');
  84.             } else {
  85.                 $errors = $validator->validate($commande);
  86.             }
  87.         }
  89.         return $this->render('GestionComerciale/Devis/ajouter.html.twig', ['form' => $form->createView(), 'errors' => $errors]);
  90.     }
  93.     /**
  94.      * @Route("/vente/devis/modifier/{id}", name="dtc_devis_modifier")
  95.      */
  96.     public function modifierAction(Request     $request, Commande $commande, EntityManagerInterface $em, CommandeService $commandeService,
  97.                                    NoteService $noteService, TranslatorInterface $translator, ValidatorInterface $validator
  98.     ) {
  99.         //$etatCommandeService = $this->container->get('dtc.etatcommande');
  100.         //$etatCommande = $etatCommandeService->calculerEtatCommande($commande, false, true);
  102.         //echo $etatCommande->getLibelle();
  104.         $user = $this->getUser();
  105.         //$commande->setUtilisateur($user);
  106.         $forceQteDispo = $request->query->get('forceQteDispo');
  107.         $form          = $this->createForm(DevisType::class, $commande);
  108.         $articles      = [
  109.             'ids'    => $request->request->get('ids'),
  110.             'tva'    => $request->request->get('tva'),
  111.             'qte'    => $request->request->get('qte'),
  112.             'remise' => $request->request->get('remise'),
  113.             'force'  => $request->request->get('force'),
  114.         ];
  115.         $valeurs       = ["articles" => $articles, 'typeDocument' => 'devis', 'operation' => 'devis'];
  118.         $repoDossier = $em->getRepository(Fichier::class);
  119.         $parent      = $repoDossier->find(4);
  122.         if (is_object($commande->getCommande())) {
  123.             $fichier = $repoDossier->findOneBy(["commande" => $commande->getCommande(), "type" => "dossier", "parent" => $parent]);
  124.         } else {
  125.             $fichier = $repoDossier->findOneBy(["commande" => $commande, "type" => "dossier", "parent" => $parent]);
  126.         }
  129.         if ( ! is_object($fichier)) {
  131.             $fichier = new Fichier();
  132.             $fichier->setUtilisateur($user);
  133.             $fichier->setType("dossier");
  134.             $fichier->setRenomme(true);
  135.             $fichier->setSupprimable(false);
  136.             $fichier->setModifiable(false);
  137.             $fichier->setCommande($commande);
  138.             $fichier->setParent($parent);
  140.             $libelle_ged = trim($commande->getReference());
  141.             $fichier->setLIbelle($libelle_ged);
  142.             $em->persist($fichier);
  145.             $enfant2 = new Fichier();
  146.             $enfant2->setUtilisateur($user);
  147.             $enfant2->setType("dossier");
  148.             $enfant2->setRenomme(true);
  149.             $enfant2->setSupprimable(false);
  150.             $enfant2->setModifiable(false);
  151.             $enfant2->setCommande($commande);
  152.             $enfant2->setParent($fichier);
  153.             $enfant2->setLibelle("BAT");
  155.             $em->persist($enfant2);
  158.             $em->flush();
  159.         }
  162.         $errors = "";
  163.         $form->handleRequest($request);
  164.         if ($form->isSubmitted()) {
  167.             $droit = $this->isGranted(EntityVoter::UPDATE, Commande::class);
  169.             if ( ! $droit) {
  170.                 return $this->redirectToRoute('dtc_devis_modifier', ["id" => $commande->getId()]);
  171.             }
  173.             if ($form->isValid()) {
  174.                 $em->persist($commande);
  175.                 $em->flush();
  178.                 $articles = [
  179.                     'ids'                      => $request->request->get('ids'),
  180.                     'remise'                   => $request->request->get('remise'),
  181.                     'remiseCalcule'            => $request->request->get('remiseCalcule'),
  182.                     'montantRemise'            => $request->request->get('montantRemise'),
  183.                     'commentaire'              => $request->request->get('commentaire'),
  184.                     'commentairePrive'         => $request->request->get('commentairePrive'),
  185.                     'libellesSecondaires'      => $request->request->get('libellesSecondaires'),
  186.                     'libelles'                 => $request->request->get('libelles'),
  187.                     'tva'                      => $request->request->get('tva'),
  188.                     'idsTva'                   => $request->request->get('idsTva'),
  189.                     'remiseSuppl'              => $request->request->get('remiseSuppl'),
  190.                     'ecocontribution'          => $request->request->get('ecocontribution'),
  191.                     'prix'                     => $request->request->get('prix'),
  192.                     //'fraisPortLigne'=>$request->request->get('fraisPortLigne'),
  193.                     'qte'                      => $request->request->get('qte'),
  194.                     'force'                    => $request->request->get('force'),
  195.                     'commentaireSuppl'         => $request->request->get('commentaireSuppl'),
  196.                     'emplacement'              => $request->request->get('emplacement'),
  197.                     'nbEmplacement'            => $request->request->get('nbEmplacement'),
  198.                     'articlesCommandeRepris'   => $request->request->get('articlesCommandeRepris'),
  199.                     'qteDispo'                 => $request->request->get('qteDispo'),
  200.                     'transporteurs'            => $request->request->get('transporteurs'),
  201.                     'articlesCommandeAssocies' => $request->request->get('articlesCommandeAssocies'),
  202.                     'articlesCommandeIds'      => $request->request->get('articlesCommandeIds'),
  203.                     'tabPrixAchatNetEuros'     => $request->request->get('tabPrixAchatNetEuros'),
  205.                     'societe_livraison_txt'     => $request->request->get('societe_livraison_txt'),
  206.                     'numero_livraison_txt'      => $request->request->get('numero_livraison_txt'),
  207.                     'rue_livraison_txt'         => $request->request->get('rue_livraison_txt'),
  208.                     'complement_livraison_txt'  => $request->request->get('complement_livraison_txt'),
  209.                     'complement2_livraison_txt' => $request->request->get('complement2_livraison_txt'),
  210.                     'cp_livraison_txt'          => $request->request->get('cp_livraison_txt'),
  211.                     'ville_livraison_txt'       => $request->request->get('ville_livraison_txt'),
  212.                     'pays_livraison_txt'        => $request->request->get('pays_livraison_txt'),
  215.                     'societe_facturation_txt'     => $request->request->get('societe_facturation_txt'),
  216.                     'numero_facturation_txt'      => $request->request->get('numero_facturation_txt'),
  217.                     'rue_facturation_txt'         => $request->request->get('rue_facturation_txt'),
  218.                     'complement_facturation_txt'  => $request->request->get('complement_facturation_txt'),
  219.                     'complement2_facturation_txt' => $request->request->get('complement2_facturation_txt'),
  220.                     'cp_facturation_txt'          => $request->request->get('cp_facturation_txt'),
  221.                     'ville_facturation_txt'       => $request->request->get('ville_facturation_txt'),
  222.                     'pays_facturation_txt'        => $request->request->get('pays_facturation_txt'),
  223.                     'kilometrage'                 => $request->request->get('kilometrage'),
  224.                     'dateCT'                      => $request->request->get('dateCT'),
  225.                 ];
  226.                 if ($request->request->get('toggle-devis-devis-or') != '') {
  227.                     $typeDocument = $request->request->get('toggle-devis-devis-or');
  228.                 } else {
  229.                     $typeDocument = 'devis';
  230.                 }
  232.                 $valeurs = ["articles" => $articles, 'typeDocument' => $typeDocument, 'operation' => 'devis'];
  234.                 //print_r($valeurs);
  235.                 //exit;
  237.                 if ($request->request->get('annuler') == 'annuler') {
  238.                     $commande->setVisible(false);
  240.                     $this->addFlash('notice', $translator->trans('Devis supprimé avec succès!'));
  241.                     $em->persist($commande);
  242.                     $em->flush();
  243.                     $commandeService->creerHistorique($commande, 6);
  245.                     //return $this->redirectToRoute('dtc_devis_modifier',array('id'=>$commande->getId()));
  246.                     return $this->redirectToRoute('dtc_devis_liste');
  248.                 }
  249.                 if ($request->request->get('facturer') != '') {
  251.                     //on vérifie que le devis n'a pas deja une commande
  252.                     if (is_object($commande->getCommande())) {
  254.                         $commandeUrl = $this->generateUrl('dtc_commande_modifier', ['id' => $commande->getCommande()->getId()]);
  255.                         $trans       = $translator->trans('Vous devez facturer depuis la commande existante ! <a href="'.$commandeUrl.'">Voir ici</a>');
  256.                         //$this->addFlash('warning',$translator->trans('Vous devez facturer depuis la commande existante !'));
  257.                         $this->addFlash('warning', $trans);
  259.                         return $this->redirectToRoute('dtc_commande_modifier', ["id" => $commande->getId(), 'forceQteDispo' => true]);
  261.                     } else {
  263.                         $valeurs["facturer"] = "1";
  264.                         $idCommande          = $commandeService->transformerCommandeEnDevis($commande, $valeurs);
  265.                         $this->addFlash('notice', $translator->trans('Facture créée avec succès!'));
  267.                         return $this->redirectToRoute('dtc_facture_afficher', ["id" => $idCommande]);
  268.                     }
  270.                 } elseif ($request->request->get('commander') != '') {
  271.                     //on vérifie que le devis n'a pas deja une commande
  272.                     if (is_object($commande->getCommande())) {
  274.                         $commandeUrl = $this->generateUrl('dtc_commande_modifier', ['id' => $commande->getCommande()->getId()]);
  275.                         $trans       = $translator->trans('La commande existe dejà pour ce devis ! <a href="'.$commandeUrl.'">Voir ici</a>');
  276.                         //$this->addFlash('warning',$translator->trans('La Commande existe dejà pour ce devis !'));
  277.                         $this->addFlash('warning', $trans);
  279.                         return $this->redirectToRoute('dtc_commande_modifier', ["id" => $commande->getId(), 'forceQteDispo' => true]);
  282.                     } else {
  284.                         $idCommande = $commandeService->transformerCommandeEnDevis($commande, $valeurs);
  285.                         $this->addFlash('notice', $translator->trans('Commande créée avec succès!'));
  287.                         //dump($valeurs);
  288.                         return $this->redirectToRoute('dtc_commande_modifier', ["id" => $idCommande, 'forceQteDispo' => true]);
  289.                     }
  291.                 } else {
  292.                     $commandeService->sauvegarder($commande, $valeurs);
  293.                     //$commandeService->changeDateLivraisonTheoriqueCommandeProcess($commande);
  294.                     $commandeService->changeDateExpeditionTheoriqueCommandeProcess($commande);
  296.                     $categ_relance = $em->getRepository(Categorie::class)->find(9);
  297.                     $statutAfaire  = $em->getRepository(Statut::class)->find(1);
  299.                     $notes      = $em->getRepository(Note::class)->findBy(
  300.                         [
  301.                             'commande'  => $commande,
  302.                             'statut'    => $statutAfaire,
  303.                             'categorie' => $categ_relance,
  304.                         ]
  305.                     );
  306.                     $datatables = [];
  307.                     if (count($commande->getArticleCommande())) {
  308.                         $datatables[] = 'dta-article-devis';
  309.                     }
  310.                     if (is_object($commande->getClient()) && count($notes) == 0) {
  311.                         $noteService->creerRelance($commande);
  312.                         $datatables[] = 'dta-notes-objet';
  313.                     }
  315.                     if ($request->isXmlHttpRequest()) {
  316.                         //dump($request->request->get('declencheur'));
  317.                         if ( ! in_array($request->request->get('declencheur'), ['supprimer-row-article'])) {
  318.                             $commandeService->creerHistorique($commande, $request->request->get('declencheur'));
  319.                         }
  321.                         return new JsonResponse(['data' => 1, 'date' => (new \Datetime)->format('d/m/Y à H:i'), 'datatables' => $datatables]);
  322.                     }
  323.                     $this->addFlash('notice', $translator->trans('Devis sauvegardé avec succès!'));
  324.                     $commandeService->creerHistorique($commande, 2);
  326.                     if ($request->request->get('toggle-devis-devis-or') != '') {
  327.                         return $this->redirectToRoute('dtc_ordre_reparation_modifier', ["id" => $commande->getId(), 'operation' => 'devis', 'forceQteDispo' => true]);
  328.                     } else {
  329.                         return $this->redirectToRoute('dtc_devis_modifier', ["id" => $commande->getId(), 'forceQteDispo' => true]);
  330.                     }
  331.                 }
  332.             } else {
  333.                 $errors = $validator->validate($commande);
  334.                 //\Doctrine\Common\Util\Debug::dump($errors);
  335.             }
  336.         }
  338.         return $this->render(
  339.             'GestionComerciale/Devis/ajouter.html.twig',
  340.             ['form' => $form->createView(), 'errors' => $errors, 'commande' => $commande, 'forceQteDispo' => $forceQteDispo]
  341.         );
  342.     }
  345.     /**
  346.      * @Route("/vente/devis/supprimer/multiple", name="dtc_devis_liste_supprimer")
  347.      */
  348.     public function supprimerMultipleAction(Request $request, EntityManagerInterface $em, TranslatorInterface $translator, ValidatorInterface $validator)
  349.     {
  351.         $url = $this->generateUrl('dtc_devis_liste', []);
  353.         return new JsonResponse(['url' => $url, 'valide' => '1']);
  355.         $data = $request->get('dataTables');
  356.         $ids  = $data['actions'];
  358.         $repo = $em->getRepository(Commande::class);
  360.         for ($i = 0; $i < count($ids); $i++) {
  361.             $v = $repo->find($ids[$i]);
  362.             if (is_object($v)) {
  363.                 $em->remove($v);
  364.             }
  365.         }
  366.         $em->flush();
  367.         $this->addFlash(
  368.             'notice',
  369.             $translator->trans('Devis supprimé avec succès !')
  370.         );
  371.         $url = $this->generateUrl('dtc_devis_liste', []);
  373.         return new JsonResponse(['url' => $url, 'valide' => '1']);
  374.     }
  377.     /**
  378.      * @Route("/vente/devis/supprimer/{id}", name="dtc_devis_supprimer")
  379.      */
  380.     public function supprimerAction(Request $request, Commande $commande, EntityManagerInterface $em, TranslatorInterface $translator, ValidatorInterface $validator)
  381.     {
  383.         $titre_modal = $translator->trans("Demande de confirmation");
  384.         $user        = $this->getUser();
  386.         $form   = $this->createForm(SupprimerDevisType::class, $commande);
  387.         $errors = "";
  388.         $form->handleRequest($request);
  389.         if ($form->isSubmitted()) {
  391.             if ($form->isValid()) {
  392.                 $em->remove($commande);
  393.                 $em->flush();
  395.                 $this->addFlash(
  396.                     'notice',
  397.                     $translator->trans('Devis supprimé avec succès !')
  398.                 );
  399.                 $url = $this->generateUrl('dtc_devis_liste', []);
  401.                 return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url]);
  402.             } else {
  403.                 $errors = $validator->validate($commande);
  404.                 $rendu  = $this->renderView('FO/Supprimer/supprimer.html.twig', ['form' => $form->createView(), 'errors' => $errors, 'id' => $commande->getId(), 'type' => '']);
  406.                 return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  407.             }
  408.         }
  409.         $rendu = $this->renderView('FO/Supprimer/supprimer.html.twig', ['form' => $form->createView(), 'id' => $commande->getId(), 'type' => '', 'errors' => $errors]);
  411.         return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  412.     }
  415.     /**
  416.      * @Route("/vente/devis", name="dtc_devis_liste")
  417.      */
  418.     public function listerAction(Request                $request, ColonneTableauService $serviceColonneTableau, Datatable $datatable, TranslatorInterface $translator,
  419.                                  EntityManagerInterface $em
  420.     ) {
  422.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [0], "visible" => false, "orderable" => false];
  423.         $tableau_class_cellule[] = [
  424.             "className" => "visible_export colonne_id",
  425.             "targets"   => [1],
  426.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(Devis::class, "id"),
  427.         ];
  428.         $tableau_class_cellule[] = [
  429.             "className" => "visible_export colonne_id text-center",
  430.             "targets"   => [2],
  431.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(Devis::class, "date"),
  432.         ];
  433.         $tableau_class_cellule[] = [
  434.             "className" => "visible_export colonne_id",
  435.             "targets"   => [3],
  436.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(Devis::class, "reference"),
  437.         ];
  438.         $tableau_class_cellule[] = [
  439.             "className" => "visible_export colonne_id",
  440.             "targets"   => [4],
  441.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(Devis::class, "refclient"),
  442.         ];
  443.         $tableau_class_cellule[] = [
  444.             "className" => "visible_export colonne_id",
  445.             "targets"   => [5],
  446.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(Devis::class, "client"),
  447.         ];
  448.         $tableau_class_cellule[] = [
  449.             "className" => "visible_export colonne_id",
  450.             "targets"   => [6],
  451.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(Devis::class, "libelleLivraison"),
  452.         ];
  453.         $tableau_class_cellule[] = [
  454.             "className" => "visible_export colonne_id w200 text-right",
  455.             "targets"   => [7],
  456.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(Devis::class, "totalHT"),
  457.         ];
  458.         $tableau_class_cellule[] = [
  459.             "className" => "visible_export colonne_id",
  460.             "targets"   => [8],
  461.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(Devis::class, "commercial"),
  462.         ];
  463.         $tableau_class_cellule[] = [
  464.             "className" => "visible_export colonne_id",
  465.             "targets"   => [9],
  466.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(Devis::class, "assistanteCommerciale"),
  467.         ];
  468.         $tableau_class_cellule[] = [
  469.             "className" => "visible_export colonne_id",
  470.             "targets"   => [10],
  471.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(Devis::class, "commentaire"),
  472.         ];
  473.         //$tableau_class_cellule[]=array("className"=>"visible_export colonne_id text-center","targets"=>array(10),"visible"=>$serviceColonneTableau->getColonneUtilisateur(Devis::class,"dateBon"));
  474.         //$tableau_class_cellule[]=array("className"=>"visible_export colonne_id text-center","targets"=>array(11),"visible"=>true);
  475.         //$tableau_class_cellule[]=array("className"=>"visible_export colonne_id","targets"=>array(12),"visible"=>$serviceColonneTableau->getColonneUtilisateur(Devis::class,"refCli"));
  476.         $tableau_class_cellule[] = [
  477.             "className" => "visible_export colonne_id text-center",
  478.             "targets"   => [11],
  479.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(Devis::class, "dateRelance"),
  480.         ];
  481.         $tableau_class_cellule[] = [
  482.             "className" => "visible_export colonne_id text-center",
  483.             "targets"   => [12],
  484.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(Devis::class, "dateReceptionFournisseur"),
  485.         ];
  486.         $tableau_class_cellule[] = [
  487.             "className" => "visible_export colonne_id text-center ",
  488.             "targets"   => [13],
  489.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(Devis::class, "dateLivraisonSouhaitee"),
  490.         ];
  491.         //$tableau_class_cellule[]=array("className"=>"visible_export colonne_id text-center","targets"=>array(13),"visible"=>$serviceColonneTableau->getColonneUtilisateur(Devis::class,"dateLivraisonTheorique"));
  492.         $tableau_class_cellule[] = [
  493.             "className" => "visible_export colonne_id text-center",
  494.             "targets"   => [14],
  495.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(Devis::class, "dateExpeditionTheorique"),
  496.         ];
  497.         //$tableau_class_cellule[]=array("className"=>"visible_export colonne_id","targets"=>array(14),"visible"=>$serviceColonneTableau->getColonneUtilisateur(Devis::class,"colis"));
  498.         $tableau_class_cellule[] = ["orderable" => false, "className" => "colonne_id w60", "targets" => [15], "visible" => true];
  499.         $this->datatable($request, $datatable, $translator);
  502.         $param             = $request->query->all();
  503.         $param["en_cours"] = "on";
  505.         return $this->render('GestionComerciale/Devis/lister.html.twig', [
  506.             'parametres'          => $param,
  507.             'tableauClassColonne' => $tableau_class_cellule,
  508.         ]);
  510.     }
  512.     /**
  513.      * set datatable configs
  514.      *
  515.      * @return \App\Library\Datatable\Util\Datatable
  516.      */
  517.     private function datatable(Request $request, Datatable $datatable, TranslatorInterface $translator)
  518.     {
  519.         $param = $request->query->all();
  520.         $datatable->setEntity(Commande::class, "x")
  521.                   ->setFields(
  522.                       [
  523.                           $translator->trans("ID")                       => 'x.id',
  524.                           $translator->trans("Date")                     => 'x.date',
  525.                           $translator->trans("Réf")                      => 'x.reference',
  526.                           $translator->trans("Réf client")               => 'c.reference',
  527.                           $translator->trans("Client")                   => 'c.nom',
  528.                           $translator->trans("Société / Nom")            => 'x.libelleLivraison',
  529.                           //$translator->trans("Statut") =>  's.libelle',
  530.                           $translator->trans("Total HT")                 => 'x.total',
  531.                           $translator->trans("Commercial")               => 'co.reference',
  532.                           $translator->trans("Assistante commercial")    => 'ac.reference',
  533.                           $translator->trans("Comm")                     => 'x.commentaire',
  534.                           //$translator->trans("Date Prep") =>  'x.dateBon',
  535.                           $translator->trans("Date de relance")          => 'x.dateRelance',
  536.                           $translator->trans("Date de réception fourn.") => 'x.dateReceptionFournisseur',
  537.                           $translator->trans("Date liv. souhaitée")      => 'x.dateLivraisonSouhaitee',
  538.                           //$translator->trans("Date liv. théorique") =>  'x.dateLivraisonTheorique',
  539.                           $translator->trans("Date exp. théorique")      => 'x.dateExpeditionTheorique',
  540.                           //$translator->trans("Réf Cmd Cli") =>  'x.referenceClient',
  541.                           //$translator->trans("Nb colis") =>  'x.nbColis',
  542.                           $translator->trans("Actions")                  => 'x.id',
  543.                           "_identifier_"                                 => 'x.id',
  544.                       ]
  545.                   )
  546.                   ->addJoin('x.etatCommande', 'ec', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  547.                   ->addJoin('x.statutCommande', 's', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  548.                   ->addJoin('x.client', 'c', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  549.                   //->addJoin('x.typeDocumentCommercial', 'td', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  550.                   ->addJoin('x.assistanteCommercial', 'ac', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  551.                   ->addJoin('x.commercial', 'co', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  552.                   ->setRenderers(
  553.                       [
  554.                           0 => [
  555.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  556.                               'params' => [
  557.                                   'edit_route' => 'dtc_devis_modifier',
  558.                               ],
  560.                           ],
  561.                           1 => [
  562.                               'view' => 'FO/DataTable/heure.html.twig',
  564.                           ],
  565.                           2 => [
  566.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  567.                               'params' => [
  568.                                   'edit_route' => 'dtc_devis_modifier',
  569.                               ],
  571.                           ],
  572.                           3 => [
  573.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  574.                               'params' => [
  575.                                   'edit_route'   => 'dtc_client_modifier',
  576.                                   'typeDocument' => 'client',
  577.                               ],
  578.                           ],
  580.                           4  => [
  581.                               'view'   => 'FO/DataTable/client.html.twig',
  582.                               'params' => [],
  584.                           ],
  585.                           /*3 => array(
  586.                           'view' => 'FO/DataTable/etat_commande.html.twig',
  587.                            'params' => array(
  589.                                   ),
  591.                           ),
  592.                           */
  593.                           6  => [
  594.                               'view'   => 'FO/DataTable/prix.html.twig',
  595.                               'params' => ['avecPort' => 1],
  597.                           ],
  598.                           7  => [
  599.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  600.                               'params' => [
  601.                                   'edit_route'   => 'dtc_utilisateur_modifier',
  602.                                   'typeDocument' => 'equipier',
  603.                               ],
  604.                           ],
  605.                           8  => [
  606.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  607.                               'params' => [
  608.                                   'edit_route'   => 'dtc_utilisateur_modifier',
  609.                                   'typeDocument' => 'equipier',
  610.                               ],
  611.                           ],
  612.                           /*
  613.                           7 => array(
  614.                               'view' => 'FO/DataTable/prenom_nom.html.twig'
  616.                           ),
  617.                           */
  618.                           10 => [
  619.                               'view' => 'FO/DataTable/heure.html.twig',
  621.                           ],
  622.                           11 => [
  623.                               'view' => 'FO/DataTable/date.html.twig',
  625.                           ],
  626.                           12 => [
  627.                               'view' => 'FO/DataTable/date.html.twig',
  629.                           ],
  630.                           13 => [
  631.                               'view' => 'FO/DataTable/date.html.twig',
  633.                           ],
  635.                           14 => [
  636.                               'view'   => 'FO/DataTable/actions.html.twig',
  637.                               'params' => [
  638.                                   'edit_route' => 'dtc_devis_modifier',
  639.                                   //'supprimer_route'    => 'dtc_devis_supprimer',
  640.                                   'pdf_route'  => 'dtc_devis_pdf',
  641.                                   'objet'      => Commande::class,
  642.                                   'deplier'    => true,
  643.                               ],
  645.                           ],
  647.                       ]
  648.                   )
  649.                   ->setMultiple(
  650.                       [
  651.                           'delete' => [
  652.                               'title' => 'Non disponible',
  653.                               'route' => 'dtc_devis_liste_supprimer',
  654.                           ],
  655.                       ]
  656.                   )
  658.             //->setOrder("ec.ordre", "desc")
  659.                   ->setOrder("x.date", "desc")
  660.                   ->setSearch(true)
  661.                   ->setSearchFields([2, 3, 4, 5, 6, 9]);
  662.         //$datatable->setSearchFields(array(0,2));
  664.         //$where = "x.typeDocumentCommercial = :typeDocumentCommercial AND x.dateSuppression IS NULL AND x.commande IS NULL and x.visible= :visible";
  665.         $where      = "x.typeDocumentCommercial = :typeDocumentCommercial AND x.dateSuppression IS NULL and x.visible= :visible";
  666.         $parameters = ['typeDocumentCommercial' => TypeDocumentCommercial::DEVIS, 'visible' => 1];
  668.         $where_statut = "";
  670.         if (array_key_exists('parametres', $param)) {
  671.             if (array_key_exists('client', $param["parametres"]) and $param["parametres"]["client"] > 0) {
  672.                 //$datatable->addJoin('x.client', 'client', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN);
  673.                 $parameters["client"] = $param["parametres"]["client"];
  674.                 if ($where != "") {
  675.                     $where .= " AND ";
  676.                 }
  677.                 $where .= "c.id = :client";
  678.             }
  680.             if (array_key_exists('client', $param["parametres"]) and $param["parametres"]["date_debut"] != "") {
  681.                 $param["parametres"]["date_debut"] = \DateTime::createFromFormat('d/m/Y', $param["parametres"]["date_debut"]);
  682.                 $param["parametres"]["date_debut"]->setTime(00, 00, 00);
  683.                 $parameters["date_debut"] = $param["parametres"]["date_debut"];
  684.                 if ($where != "") {
  685.                     $where .= " AND ";
  686.                 }
  687.                 $where .= "x.date >= :date_debut";
  688.             }
  689.             if (array_key_exists('client', $param["parametres"]) and $param["parametres"]["date_fin"] != "") {
  690.                 $param["parametres"]["date_fin"] = \DateTime::createFromFormat('d/m/Y', $param["parametres"]["date_fin"]);
  691.                 $param["parametres"]["date_fin"]->setTime(23, 59, 59);
  692.                 $parameters["date_fin"] = $param["parametres"]["date_fin"];
  693.                 if ($where != "") {
  694.                     $where .= " AND ";
  695.                 }
  696.                 $where .= "x.date <= :date_fin";
  697.             }
  699.             if (array_key_exists('en_cours', $param["parametres"]) and $param["parametres"]["en_cours"] != "") {
  700.                 //$parameters["perdu"]="1";
  701.                 if ($where_statut != "") {
  702.                     $where_statut .= " OR ";
  703.                 }
  704.                 $where_statut .= "x.commande IS NULL";
  706.                 if (array_key_exists('perdu', $param["parametres"]) and $param["parametres"]["perdu"] != "") {
  707.                     $parameters["perdu"] = "1";
  708.                     if ($where_statut != "") {
  709.                         $where_statut .= " OR ";
  710.                     }
  711.                     $where_statut .= "x.perdu = :perdu";
  712.                 } else {
  713.                     $parameters["perdu"] = "0";
  714.                     if ($where_statut != "") {
  715.                         $where_statut .= " AND ";
  716.                     }
  717.                     $where_statut .= "(x.perdu = :perdu OR x.perdu IS NULL)";
  718.                 }
  720.                 if (array_key_exists('gagne', $param["parametres"]) and $param["parametres"]["gagne"] != "") {
  721.                     if ($where_statut != "") {
  722.                         $where_statut .= " OR ";
  723.                     }
  724.                     $where_statut .= "x.commande IS NOT NULL";
  725.                 } else {
  726.                     if ($where_statut != "") {
  727.                         $where_statut .= " AND ";
  728.                     }
  729.                     $where_statut .= "x.commande IS NULL";
  730.                 }
  733.             } elseif (array_key_exists('perdu', $param["parametres"]) and $param["parametres"]["perdu"] != "") {
  734.                 $parameters["perdu"] = "1";
  735.                 if ($where_statut != "") {
  736.                     $where_statut .= " OR ";
  737.                 }
  738.                 $where_statut .= "x.perdu = :perdu";
  740.                 if (array_key_exists('gagne', $param["parametres"]) and $param["parametres"]["gagne"] != "") {
  741.                     if ($where_statut != "") {
  742.                         $where_statut .= " OR ";
  743.                     }
  744.                     $where_statut .= "x.commande IS NOT NULL";
  745.                 } else {
  746.                     if ($where_statut != "") {
  747.                         $where_statut .= " AND ";
  748.                     }
  749.                     $where_statut .= "x.commande IS NULL";
  750.                 }
  752.             } elseif (array_key_exists('gagne', $param["parametres"]) and $param["parametres"]["gagne"] != "") {
  753.                 if ($where_statut != "") {
  754.                     $where_statut .= " OR ";
  755.                 }
  756.                 $where_statut .= "x.commande IS NOT NULL";
  758.                 $parameters["perdu"] = "0";
  759.                 if ($where_statut != "") {
  760.                     $where_statut .= " AND ";
  761.                 }
  762.                 $where_statut .= "(x.perdu = :perdu OR x.perdu IS NULL)";
  765.             }
  768.             if ($where_statut != "") {
  769.                 if ($where != "") {
  770.                     $where .= " AND ";
  771.                 }
  772.                 $where .= '('.$where_statut.')';
  773.             }
  775.         }
  776.         //echo $where;
  777.         //exit;
  778.         if ($where != '') {
  780.             $datatable->setWhere($where, $parameters);
  781.         }
  783.         return $datatable;
  784.     }
  787.     /**
  788.      * @Route("/devis/recuperer/{id}", name="dtc_devis_recuperer")
  789.      */
  790.     public function recupererDevisAction(Request $request, Client $client, Datatable $datatable, TranslatorInterface $translator)
  791.     {
  792.         $titre_modal = "Liste des devis de ".$client->getPrenom()." ".$client->getNom();
  793.         $this->datatableDevis($client, $datatable, $translator);
  794.         $rendu = $this->renderView('GestionComerciale/Devis/recuperer.html.twig', ['client' => $client]);
  796.         return new JsonResponse(['rendu' => $rendu, 'valide' => '1', 'url' => '', 'titre' => $titre_modal]);
  797.     }
  799.     /**
  800.      * @Route("/devis/recuperer/grid/{id}", name="dtc_client_devis_liste_grid")
  801.      */
  802.     public function gridDevisAction(Request $request, Client $client, Datatable $datatable, TranslatorInterface $translator)
  803.     {
  804.         return $this->datatableDevis($client, $datatable, $translator)->execute();
  805.     }
  808.     /**
  809.      * @Route("/vente/devis/grid", name="dtc_devis_liste_grid")
  810.      */
  811.     public function gridAction(Request            $request, Datatable $datatable, TranslatorInterface $translator, EntityManagerInterface $em,
  812.                                ValidatorInterface $validator
  813.     ) {
  814.         return $this->datatable($request, $datatable, $translator)->execute();
  815.     }
  818.     /**
  819.      * set datatable configs
  820.      *
  821.      * @return \App\Library\Datatable\Util\Datatable
  822.      */
  823.     private function datatableDevis($client = "", Datatable $datatable, TranslatorInterface $translator)
  824.     {
  825.         $datatable->setDatatableId('dta-devis')
  826.                   ->setEntity(Commande::class, "x")
  827.                   ->setFields(
  828.                       [
  829.                           $translator->trans("ID")        => 'x.id',
  830.                           $translator->trans("Réference") => 'x.reference',
  831.                           $translator->trans("Statut")    => 's.libelle',
  832.                           $translator->trans("Type")      => 't.libelle',
  833.                           $translator->trans("Total HT")  => 'x.total',
  834.                           $translator->trans("Actions")   => 'x.id',
  835.                           "_identifier_"                  => 'x.id',
  836.                       ]
  837.                   )
  838.                   ->setWhere(
  839.                       'x.client = :client',
  840.                       ['client' => $client]
  841.                   )
  842.                   ->addJoin('x.statutCommande', 's', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  843.                   //->addJoin('x.typeDocumentCommercial', 't', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  844.                   ->setRenderers(
  845.                       [
  846.                           1 => [
  847.                               'view'   => 'FO/DataTable/lien.html.twig',
  848.                               'params' => [
  849.                                   'edit_route' => 'dtc_commande_modifier',
  850.                                   'objet'      => Commande::class,
  851.                               ],
  852.                           ],
  853.                           4 => [
  854.                               'view' => 'FO/DataTable/prix.html.twig',
  856.                           ],
  857.                           5 => [
  858.                               'view'   => 'FO/DataTable/actions.html.twig',
  859.                               'params' => [
  860.                                   'edit_route' => 'dtc_commande_modifier',
  861.                                   'objet'      => Commande::class,
  863.                               ],
  864.                           ],
  866.                       ]
  867.                   )
  868.                   ->setOrder("x.id", "desc")
  869.                   ->setSearch(true)
  870.                   ->setSearchFields([1, 2, 3, 4]);
  872.         return $datatable;
  873.     }
  876.     /**
  877.      * @Route("/devis/pdf/{id}", name="dtc_devis_pdf")
  878.      */
  879.     public function pdfDevisAction(Request $request, Commande $commande, EntityManagerInterface $entityManager, Environment $environment, Pdf $pdf)
  880.     {
  883.         $societe    = $entityManager->getRepository(Societe::class)->find(1);
  884.         $date_Y     = date("Y");
  885.         $date_M     = date("m");
  886.         $date_D     = date("d");
  887.         $date       = $date_Y.'/'.$date_M.'/'.$date_D;
  888.         $chemin_pdf = 'PDF/DEVIS/'.$date.'/DEVIS-'.$commande->getReference().'.pdf';
  890.         if (file_exists($chemin_pdf)) {
  891.             unlink($chemin_pdf);
  892.         }
  894.         //return $this->render('GestionComerciale/Facture/template_pdf.html.twig',array('commande'  => $commande,'societe'  => $societe));
  895.         $footer = $this->renderView('FO/PDF/footer_pagination_pdf.html.twig', ['societe' => $societe]);
  896.         $footer = $environment->render('FO/PDF/footer_devis_pagination_pdf.html.twig', ['societe' => $societe, 'commande' => $commande]);
  897.         $header = $this->renderView('FO/PDF/header_devis_pdf.html.twig', ['societe' => $societe, 'commande' => $commande]);
  898.         //$snappy->setOption('page-size', 'A4');
  899.         $pdf->setOption('footer-html', $footer);
  900.         //$pdf->setOption('header-html', $header);
  903.         $pdf->setOption('header-spacing', "4");
  904.         $pdf->setOption('footer-spacing', "3");
  906.         $pdf->setOption('disable-smart-shrinking', true);
  907.         //$snappy->setOption('print-media-type', false );
  909.         $pdf->setOption('margin-left', 0);
  910.         $pdf->setOption('margin-right', 0);
  911.         $pdf->setOption('page-height', "297");
  912.         $pdf->setOption('page-width', "210");
  915.         $reference     = $request->query->get('reference');
  916.         $mode          = $request->query->get('mode');
  917.         $forceQteDispo = $request->query->get('forceQteDispo');
  919.         $pdf->generateFromHtml(
  920.             $this->renderView(
  921.                 'GestionComerciale/Devis/template_pdf.html.twig',
  922.                 [
  923.                     'commande'      => $commande,
  924.                     'societe'       => $societe,
  925.                     'reference'     => $reference,
  926.                     'mode'          => $mode,
  927.                     'forceQteDispo' => $forceQteDispo,
  929.                 ]
  930.             ),
  931.             $chemin_pdf
  932.         );
  935.         return $this->render('FO/PDF/conteneur_pdf.html.twig', [
  936.             'objet'      => $commande,
  937.             'chemin_pdf' => '/'.$chemin_pdf,
  938.             'visualiser' => $request->query->get('visualiser'),
  939.         ]);
  940.         //return new RedirectResponse("/".$chemin_pdf);
  942.     }
  944.     /**
  945.      * @Route("", name="")
  946.      */
  947.     public function toggleDevisDevisOrAction(Request $request, Commande $commande, EntityManagerInterface $em, TranslatorInterface $translator, ValidatorInterface $validator)
  948.     {
  949.         if ($commande->getTypeDocumentCommercial() == TypeDocumentCommercial::DEVIS) {
  950.             $idTypeDocumentCommercial = 10;  //Devis -> Devis Or
  951.             $typeDocumentCommercial = TypeDocumentCommercial::DEVISOR;
  952.             $message                  = 'Devis transformé avec succès en devis OR!';
  953.         } else {
  954.             $idTypeDocumentCommercial = 1; //Devis Or -> Devis
  955.             $typeDocumentCommercial = TypeDocumentCommercial::DEVIS;
  956.             $message                  = 'Devis OR transformé avec succès en devis!';
  957.         }
  958.         //$typeDocumentCommercial = $em->getRepository(TypeDocumentCommercial::class)->find($idTypeDocumentCommercial);//devis
  959.         $commande->setTypeDocumentCommercial($typeDocumentCommercial);
  960.         $em->persist($commande);
  961.         $em->flush();
  963.         return $message;
  964.         //return $this->redirectToRoute('dtc_devis_modifier',array("id"=>$commande->getId()));
  965.     }
  967.     /**
  968.      * @Route("/vente/devis/perdu/{id}", name="dtc_devis_perdu")
  969.      */
  970.     public function perduAction(Request $request, Commande $commande, EntityManagerInterface $em, TranslatorInterface $translator, ValidatorInterface $validator)
  971.     {
  973.         $titre_modal = $translator->trans("Marquer le devis comme perdu");
  974.         $user        = $this->getUser();
  976.         $form   = $this->createForm(PerduDevisType::class, $commande);
  977.         $errors = "";
  978.         $form->handleRequest($request);
  980.         $repo_message_predefini = $em->getRepository(MessagePredefini::class);
  981.         $message_predefini      = $repo_message_predefini->findAll();
  983.         if ($form->isSubmitted()) {
  985.             if ($form->isValid()) {
  986.                 $commande->setPerdu(true);
  987.                 $em->persist($commande);
  988.                 $em->flush();
  990.                 $this->addFlash('notice', $translator->trans('Devis marqué comme perdu avec succès !'));
  992.                 $url = $this->generateUrl('dtc_devis_liste', []);
  994.                 return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url]);
  995.             } else {
  996.                 $errors = $validator->validate($commande);
  997.                 $rendu  = $this->renderView(
  998.                     'GestionComerciale/Devis/perdu.html.twig',
  999.                     ['form' => $form->createView(), 'errors' => $errors, 'id' => $commande->getId(), 'message_predefini' => $message_predefini]
  1000.                 );
  1002.                 return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  1003.             }
  1004.         }
  1005.         $rendu = $this->renderView(
  1006.             'GestionComerciale/Devis/perdu.html.twig',
  1007.             ['form' => $form->createView(), 'id' => $commande->getId(), 'message_predefini' => $message_predefini, 'errors' => $errors]
  1008.         );
  1010.         return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  1011.     }
  1014.     /**
  1015.      * @Route("/vente/devis/reouverture/{id}", name="dtc_devis_reouverture")
  1016.      */
  1017.     public function reouvertureAction(Request $request, Commande $commande, EntityManagerInterface $em, TranslatorInterface $translator, ValidatorInterface $validator)
  1018.     {
  1020.         $titre_modal = $translator->trans("Ré-ouvrir le devis");
  1021.         $user        = $this->getUser();
  1023.         $form   = $this->createForm(ReouvrirDevisType::class, $commande);
  1024.         $errors = "";
  1025.         $form->handleRequest($request);
  1027.         $repo_message_predefini = $em->getRepository(MessagePredefini::class);
  1028.         $message_predefini      = $repo_message_predefini->findAll();
  1030.         if ($form->isSubmitted()) {
  1032.             if ($form->isValid()) {
  1033.                 $commande->setPerdu(false);
  1034.                 $commande->setCommentaireAnnulation(null);
  1035.                 $em->persist($commande);
  1036.                 $em->flush();
  1038.                 $this->addFlash('notice', $translator->trans('Devis ré-ouvert avec succès !'));
  1040.                 $url = $this->generateUrl('dtc_devis_liste', []);
  1042.                 return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url]);
  1043.             } else {
  1044.                 $errors = $validator->validate($commande);
  1045.                 $rendu  = $this->renderView(
  1046.                     'GestionComerciale/Devis/reouvrir.html.twig',
  1047.                     ['form' => $form->createView(), 'errors' => $errors, 'id' => $commande->getId(), 'message_predefini' => $message_predefini]
  1048.                 );
  1050.                 return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  1051.             }
  1052.         }
  1053.         $rendu = $this->renderView(
  1054.             'GestionComerciale/Devis/reouvrir.html.twig',
  1055.             ['form' => $form->createView(), 'id' => $commande->getId(), 'message_predefini' => $message_predefini, 'errors' => $errors]
  1056.         );
  1058.         return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  1059.     }
  1061.     /**
  1062.      * @Route("/vente/devis/purger", name="dtc_devis_purger")
  1063.      */
  1064.     public function purgerAction(Request $request, CommandeService $commandeService)
  1065.     {
  1067.         $commandeService->purgerDevis();
  1069.         return new JsonResponse(['valide' => '1', 'url' => '']);
  1070.     }
  1071. }