src/Controller/GestionComerciale/DevisOrController.php line 680

Open in your IDE?
  1. <?php
  3. namespace App\Controller\GestionComerciale;
  5. use App\Entity\FO\Societe;
  6. use App\Entity\GestionComerciale\Activite;
  7. use App\Entity\GestionComerciale\Alerte;
  8. use App\Entity\GestionComerciale\Commande;
  9. use App\Entity\GestionComerciale\DevisOR;
  10. use App\Model\GestionCommerciale\TypeDocumentCommercial;
  11. use App\Form\GestionComerciale\OrdreReparationType;
  12. use App\Form\GestionComerciale\SupprimerDevisType;
  13. use App\Library\Datatable\Util\Datatable;
  14. use App\Security\Voter\EntityVoter;
  15. use App\Service\GestionComerciale\CommandeService;
  16. use App\Service\Utilisateur\ColonneTableauService;
  17. use Doctrine\ORM\EntityManagerInterface;
  18. use Knp\Snappy\Pdf;
  19. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  20. use Symfony\Component\HttpFoundation\Request;
  21. use Symfony\Component\HttpFoundation\JsonResponse;
  22. use Symfony\Component\HttpFoundation\Response;
  24. use Symfony\Component\Routing\Annotation\Route;
  25. use Symfony\Component\Validator\Validator\ValidatorInterface;
  26. use Symfony\Contracts\Translation\TranslatorInterface;
  28. class DevisOrController extends AbstractController
  29. {
  32.     /**
  33.      * @Route("/ordre-reparation/devis-or/modifier/{id}", name="dtc_devis_or_modifier")
  34.      */
  35.     public function modifierAction(Request            $request, Commande $commande, CommandeService $commandeService, TranslatorInterface $translator,
  36.                                    ValidatorInterface $validator
  37.     ) {
  38.         return $this->redirectToRoute('dtc_ordre_reparation_modifier', ["id" => $commande->getId(), "operation" => "devis"]);
  39.         $user = $this->getUser();
  40.         $commande->setUtilisateur($user);
  42.         $form = $this->createForm(OrdreReparationType::class, $commande);
  45.         $articles = [
  46.             'ids'    => $request->request->get('ids'),
  47.             'tva'    => $request->request->get('tva'),
  48.             'qte'    => $request->request->get('qte'),
  49.             'remise' => $request->request->get('remise'),
  50.             'force'  => $request->request->get('force'),
  51.         ];
  52.         $valeurs  = ["articles" => $articles, 'typeDocument' => 'devis', 'operation' => 'devis'];
  54.         $errors = "";
  55.         $form->handleRequest($request);
  56.         if ($form->isSubmitted()) {
  57.             $droit = $this->isGranted(EntityVoter::UPDATE, Commande::class);
  59.             if ( ! $droit) {
  60.                 return $this->redirectToRoute('dtc_devis_modifier', ["id" => $commande->getId()]);
  61.             }
  63.             if ($form->isValid()) {
  64.                 $em->persist($commande);
  65.                 $em->flush();
  67.                 //$articles = array('ids'=>$request->request->get('ids'),'commentaire'=>$request->request->get('commentaire'),'prix'=>$request->request->get('prix'),'libelles'=>$request->request->get('libelles'),'tva'=>$request->request->get('tva'),'prix'=>$request->request->get('prix'),'qte'=>$request->request->get('qte'),'remiseSuppl'=>$request->request->get('remiseSuppl'));
  68.                 //$articles = array('ids'=>$request->request->get('ids'),'remise'=>$request->request->get('remise'),'montantRemise'=>$request->request->get('montantRemise'),'commentaire'=>$request->request->get('commentaire'),'libelles'=>$request->request->get('libelles'),'tva'=>$request->request->get('tva'),'remiseSuppl'=>$request->request->get('remiseSuppl'),'prix'=>$request->request->get('prix'),'qte'=>$request->request->get('qte'));
  69.                 $articles = [
  70.                     'ids'                    => $request->request->get('ids'),
  71.                     'remise'                 => $request->request->get('remise'),
  72.                     'remiseCalcule'          => $request->request->get('remiseCalcule'),
  73.                     'montantRemise'          => $request->request->get('montantRemise'),
  74.                     'commentaire'            => $request->request->get('commentaire'),
  75.                     'libellesSecondaires'    => $request->request->get('libellesSecondaires'),
  76.                     'libelles'               => $request->request->get('libelles'),
  77.                     'tva'                    => $request->request->get('tva'),
  78.                     'remiseSuppl'            => $request->request->get('remiseSuppl'),
  79.                     'prix'                   => $request->request->get('prix'),
  80.                     'qte'                    => $request->request->get('qte'),
  81.                     'force'                  => $request->request->get('force'),
  82.                     'commentaireSuppl'       => $request->request->get('commentaireSuppl'),
  83.                     'emplacement'            => $request->request->get('emplacement'),
  84.                     'nbEmplacement'          => $request->request->get('nbEmplacement'),
  85.                     'articlesCommandeRepris' => $request->request->get('articlesCommandeRepris'),
  86.                 ];
  88.                 $valeurs = ["articles" => $articles, 'typeDocument' => 'devis', 'operation' => 'devis'];
  91.                 if ($request->request->get('annuler') == 'annuler') {
  92.                     $commande->setVisible(false);
  94.                     $this->addFlash(
  95.                         'notice',
  96.                         $translator->trans('Devis OR supprimé avec succès!')
  97.                     );
  99.                     $em->persist($commande);
  100.                     $em->flush();
  102.                     return $this->redirectToRoute('dtc_devis_or_liste');
  104.                 }
  105.                 if ($request->request->get('commander') != '') {
  106.                     $idCommande = $commandeService->transformerCommandeEnDevis($commande, $valeurs);
  107.                     $this->addFlash(
  108.                         'notice',
  109.                         $translator->trans('Commande créée avec succès!')
  110.                     );
  112.                     return $this->redirectToRoute('dtc_commande_modifier', ["id" => $idCommande]);
  113.                 } else {
  114.                     $commandeService->sauvegarder($commande, $valeurs);
  115.                     $this->addFlash(
  116.                         'notice',
  117.                         $translator->trans('Devis sauvegardé avec succès!')
  118.                     );
  120.                     return $this->redirectToRoute('dtc_devis_modifier', ["id" => $commande->getId()]);
  121.                 }
  122.             } else {
  123.                 $errors = $validator->validate($commande);
  124.                 //\Doctrine\Common\Util\Debug::dump($errors);
  125.             }
  126.         }
  128.         return $this->render('GestionComerciale/OrdreRep/ajouter.html.twig', ['form' => $form->createView(), 'errors' => $errors, 'commande' => $commande]);
  129.     }
  131.     /**
  132.      * @Route("", name="")
  133.      */
  134.     public function alerteAction(Request $request, EntityManagerInterface $em, TranslatorInterface $translator, ValidatorInterface $validator)
  135.     {
  136.         $user          = $this->getUser();
  137.         $currentRoute  = dirname($_SERVER['SERVER_PROTOCOL'])."://".$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'];
  138.         $repo_activite = $em->getRepository(Activite::class);
  139.         $acti          = $repo_activite->findOneBy([
  140.                                                        'url' => $currentRoute,
  141.                                                    ]);
  142.         $repo_alerte   = $em->getRepository(Alerte::class);
  143.         $aler          = $repo_alerte->findOneBy([
  144.                                                      'url' => $currentRoute,
  145.                                                  ]);
  147.         if (is_object($aler)) {
  148.             $lu = $aler->getLu();
  149.         } else {
  150.             $lu = true;
  151.         }
  153.         if (is_object($acti)) {
  155.             $timestampactivite = $acti->getTimestamp();
  156.             $timestampactuelle = new \DateTime();
  157.             $time              = $timestampactuelle->diff($timestampactivite);
  160.             if ($time->format('%s') >= 4 && $acti->getUtilisateur() == $user) {
  163.                 $acti->setTimestamp(new \DateTime());
  164.                 $em->persist($acti);
  165.                 $em->flush();
  167.                 if ($lu == false) {
  169.                     $aler->setLu(true);
  170.                     $em->persist($aler);
  171.                     $em->flush();
  172.                     $lock = 3;
  174.                     return new JsonResponse(['valide' => '0', 'url' => $currentRoute, 'lu' => $lu, 'lock' => $lock]);
  176.                 } else {
  177.                     $lock = 3;
  179.                     return new JsonResponse(['valide' => '0', 'url' => $currentRoute, 'lu' => $lu, 'lock' => $lock]);
  181.                 }
  182.             }
  183.             if ($time->format('%s') >= 8 && $acti->getUtilisateur() != $user) {
  185.                 $acti->setTimestamp(new \DateTime());
  186.                 $acti->setUtilisateur($user);
  187.                 $em->persist($acti);
  188.                 $em->flush();
  191.                 if (is_object($aler)) {
  193.                     if ($aler->getEmetteur() == $user) {
  195.                         $em->remove($aler);
  196.                         $em->flush();
  197.                         $lock = 2;
  199.                         return new JsonResponse(['valide' => '0', 'url' => $currentRoute, 'lock' => $lock, 'titre' => 'Un utilisateur est dejà sur cette page ']);
  200.                     } else {
  201.                         $lock = 3;
  203.                         return new JsonResponse(['valide' => '0', 'url' => $currentRoute, 'lu' => $lu, 'lock' => $lock]);
  204.                     }
  205.                 } else {
  206.                     $lock = 3;
  208.                     return new JsonResponse(['valide' => '0', 'url' => $currentRoute, 'lu' => $lu, 'lock' => $lock]);
  210.                 }
  213.             } else {
  214.                 if ($acti->getUtilisateur() != $user) {
  215.                     if (is_object($aler)) {
  217.                         $aler->setTimestamp(new \DateTime());
  218.                         $aler->setEmetteur($user);
  219.                         $aler->setRecepteur($acti->getUtilisateur());
  220.                         $aler->setURL($currentRoute);
  221.                         $em->persist($aler);
  222.                         $em->flush();
  223.                         $lock = 1;
  225.                         return new JsonResponse(['valide' => '0', 'url' => $currentRoute, 'lock' => $lock]);
  228.                     } else {
  229.                         $aler = new Alerte;
  230.                         $aler->setEmetteur($user);
  231.                         $aler->setRecepteur($acti->getUtilisateur());
  232.                         $aler->setLu(false);
  233.                         $aler->setURL($currentRoute);
  234.                         $em->persist($aler);
  235.                         $em->flush();
  236.                         $lock = 1;
  238.                         return new JsonResponse(['valide' => '0', 'url' => $currentRoute, 'lock' => $lock]);
  241.                     }
  243.                 } else {
  244.                     $lock = 3;
  246.                     return new JsonResponse(['valide' => '0', 'url' => $currentRoute, 'lock' => $lock]);
  249.                 }
  250.             }
  251.         } else {
  254.             $acti = new Activite;
  255.             $acti->setUtilisateur($user);
  256.             $acti->setURL($currentRoute);
  257.             $em->persist($acti);
  258.             $em->flush();
  259.             $lock = 3;
  261.             return new JsonResponse(['valide' => '0', 'url' => $currentRoute, 'lu' => $lu, 'lock' => $lock]);
  264.         }
  266.     }
  269.     /**
  270.      * @Route("/ordre-reparation/devis-or/supprimer/multiple", name="dtc_devis_or_liste_supprimer")
  271.      */
  272.     public function supprimerMultipleAction(Request $request, EntityManagerInterface $em, TranslatorInterface $translator, ValidatorInterface $validator)
  273.     {
  275.         $url = $this->generateUrl('dtc_devis_liste', []);
  277.         return new JsonResponse(['url' => $url, 'valide' => '1']);
  279.         $data = $request->get('dataTables');
  280.         $ids  = $data['actions'];
  282.         $repo = $em->getRepository(Commande::class);
  284.         for ($i = 0; $i < count($ids); $i++) {
  285.             $v = $repo->find($ids[$i]);
  286.             if (is_object($v)) {
  287.                 $em->remove($v);
  288.             }
  289.         }
  290.         $em->flush();
  291.         $this->addFlash(
  292.             'notice',
  293.             $translator->trans('Devis supprimé avec succès !')
  294.         );
  295.         $url = $this->generateUrl('dtc_devis_liste', []);
  297.         return new JsonResponse(['url' => $url, 'valide' => '1']);
  298.     }
  301.     /**
  302.      * @Route("/ordre-reparation/devis-or/supprimer/{id}", name="dtc_devis_or_supprimer")
  303.      */
  304.     public function supprimerAction(Request $request, Commande $commande, EntityManagerInterface $em, TranslatorInterface $translator, ValidatorInterface $validator)
  305.     {
  307.         $titre_modal = $translator->trans("Demande de confirmation");
  308.         $user        = $this->getUser();
  310.         $form   = $this->createForm(SupprimerDevisType::class, $commande);
  311.         $errors = "";
  312.         $form->handleRequest($request);
  313.         if ($form->isSubmitted()) {
  315.             if ($form->isValid()) {
  316.                 $em->remove($commande);
  317.                 $em->flush();
  319.                 $this->addFlash(
  320.                     'notice',
  321.                     $translator->trans('Devis supprimé avec succès !')
  322.                 );
  323.                 $url = $this->generateUrl('dtc_devis_liste', []);
  325.                 return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url]);
  326.             } else {
  327.                 $errors = $validator->validate($commande);
  328.                 $rendu  = $this->renderView('FO/Supprimer/supprimer.html.twig', ['form' => $form->createView(), 'errors' => $errors, 'id' => $commande->getId(), 'type' => '']);
  330.                 return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  331.             }
  332.         }
  333.         $rendu = $this->renderView('FO/Supprimer/supprimer.html.twig', ['form' => $form->createView(), 'id' => $commande->getId(), 'type' => '', 'errors' => $errors]);
  335.         return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  336.     }
  339.     /**
  340.      * @Route("/ordre-reparation/devis-or", name="dtc_devis_or_liste")
  341.      */
  342.     public function listerAction(Request $request, ColonneTableauService $serviceColonneTableau, Datatable $datatable, TranslatorInterface $translator)
  343.     {
  344.         $param                   = $request->query->all();
  345.         $tableau_class_cellule[] = ["className" => "colonne_id", "targets" => [0], "visible" => true, "orderable" => false];
  346.         $tableau_class_cellule[] = [
  347.             "className" => "visible_export colonne_id",
  348.             "targets"   => [1],
  349.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(DevisOR::class, "id"),
  350.         ];
  351.         $tableau_class_cellule[] = [
  352.             "className" => "visible_export colonne_id",
  353.             "targets"   => [2],
  354.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(DevisOR::class, "reference"),
  355.         ];
  356.         $tableau_class_cellule[] = [
  357.             "className" => "visible_export colonne_id",
  358.             "targets"   => [3],
  359.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(DevisOR::class, "date"),
  360.         ];
  361.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [4], "visible" => false];
  362.         $tableau_class_cellule[] = [
  363.             "className" => "visible_export colonne_id",
  364.             "targets"   => [5],
  365.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(DevisOR::class, "refclient"),
  366.         ];
  367.         $tableau_class_cellule[] = [
  368.             "className" => "visible_export colonne_id",
  369.             "targets"   => [6],
  370.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(DevisOR::class, "client"),
  371.         ];
  372.         $tableau_class_cellule[] = [
  373.             "className" => "visible_export colonne_id",
  374.             "targets"   => [7],
  375.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(DevisOR::class, "rdv"),
  376.         ];
  377.         $tableau_class_cellule[] = [
  378.             "className" => "visible_export colonne_id",
  379.             "targets"   => [8],
  380.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(DevisOR::class, "equipier"),
  381.         ];
  382.         $tableau_class_cellule[] = [
  383.             "className" => "visible_export colonne_id",
  384.             "targets"   => [9],
  385.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(DevisOR::class, "immat"),
  386.         ];
  387.         $tableau_class_cellule[] = [
  388.             "className" => "visible_export colonne_id",
  389.             "targets"   => [10],
  390.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(DevisOR::class, "marque"),
  391.         ];
  392.         $tableau_class_cellule[] = [
  393.             "className" => "visible_export colonne_id",
  394.             "targets"   => [11],
  395.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(DevisOR::class, "modele"),
  396.         ];
  397.         $tableau_class_cellule[] = [
  398.             "className" => "visible_export colonne_id",
  399.             "targets"   => [12],
  400.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(DevisOR::class, "km"),
  401.         ];
  402.         $tableau_class_cellule[] = [
  403.             "className" => "visible_export colonne_id",
  404.             "targets"   => [13],
  405.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(DevisOR::class, "serie"),
  406.         ];
  407.         $tableau_class_cellule[] = [
  408.             "className" => "visible_export colonne_id",
  409.             "targets"   => [14],
  410.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(DevisOR::class, "commentaire"),
  411.         ];
  412.         $tableau_class_cellule[] = [
  413.             "className" => "visible_export colonne_id",
  414.             "targets"   => [15],
  415.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(DevisOR::class, "refCli"),
  416.         ];
  417.         $tableau_class_cellule[] = ["orderable" => false, "className" => "colonne_id", "targets" => [16], "visible" => true];
  418.         $this->datatable($request, $datatable, $translator);
  420.         return $this->render('GestionComerciale/DevisOr/lister.html.twig', ['tableauClassColonne' => $tableau_class_cellule, 'parametres' => $param]);
  423.     }
  425.     /**
  426.      * set datatable configs
  427.      *
  428.      * @return \App\Library\Datatable\Util\Datatable
  429.      */
  430.     private function datatable(Request $request, Datatable $datatable, TranslatorInterface $translator)
  431.     {
  433.         $param = $request->query->all();
  434.         $datatable->setEntity(Commande::class, "x")
  435.                   ->setFields(
  436.                       [
  437.                           $translator->trans("ID")           => 'x.id',
  438.                           $translator->trans("Réf")          => 'x.reference',
  439.                           $translator->trans("Date")         => 'x.date',
  440.                           $translator->trans("Statut")       => 'sc.id',
  441.                           $translator->trans("Réf client")   => 'c.reference',
  442.                           $translator->trans("Client")       => 'c.nom',
  443.                           $translator->trans("RDV ")         => 'x.dateBon',
  444.                           $translator->trans("Équipier")     => 'u.reference',
  445.                           $translator->trans("Immat")        => 'v.immatriculation',
  446.                           $translator->trans("Marque")       => 'm.libelle',
  447.                           $translator->trans("Modèle")       => 'mo.libelle',
  448.                           $translator->trans("Km")           => 'v.kilometrage',
  449.                           $translator->trans("Num serie")    => 'v.numSerie',
  450.                           $translator->trans("Comm")         => 'x.commentaire',
  451.                           $translator->trans("Réf cmde cli") => 'x.referenceClient',
  452.                           $translator->trans("Actions")      => 'x.id',
  453.                           "_identifier_"                     => 'x.id',
  454.                       ]
  455.                   )
  456.                   ->addJoin('x.vehiculesClient', 'v', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  457.                   ->addJoin('v.marque', 'm', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  458.                   ->addJoin('x.statutCommande', 'sc', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  459.                   ->addJoin('v.modele', 'mo', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  460.                   ->addJoin('x.etatCommande', 'ec', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  461.                   ->addJoin('x.client', 'c', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  462.                   ->addJoin('x.utilisateur', 'u', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  463.                   ->setRenderers(
  464.                       [
  465.                           0 => [
  466.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  467.                               'params' => [
  468.                                   'edit_route' => 'dtc_devis_or_modifier',
  469.                               ],
  471.                           ],
  472.                           1 => [
  473.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  474.                               'params' => [
  475.                                   'edit_route' => 'dtc_devis_or_modifier',
  476.                               ],
  478.                           ],
  479.                           2 => [
  480.                               'view' => 'FO/DataTable/heure.html.twig',
  482.                           ],
  483.                           3 => [
  484.                               'view' => 'FO/DataTable/statut-commande-fournisseur.html.twig',
  486.                           ],
  487.                           4 => [
  488.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  489.                               'params' => [
  490.                                   'edit_route'   => 'dtc_client_modifier',
  491.                                   'typeDocument' => 'client',
  492.                               ],
  493.                           ],
  495.                           5  => [
  496.                               'view'   => 'FO/DataTable/client.html.twig',
  497.                               'params' => [],
  498.                           ],
  499.                           6  => [
  500.                               'view' => 'FO/DataTable/heure.html.twig',
  502.                           ],
  503.                           7  => [
  504.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  505.                               'params' => [
  506.                                   'edit_route'   => 'dtc_utilisateur_modifier',
  507.                                   'typeDocument' => 'equipier',
  508.                               ],
  509.                           ],
  510.                           9  => [
  511.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  512.                               'params' => [
  513.                                   'edit_route'   => 'dtc_vehicule_marque_modifier',
  514.                                   'typeDocument' => 'marqueVehiculeOr',
  515.                               ],
  516.                           ],
  517.                           10 => [
  518.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  519.                               'params' => [
  520.                                   'edit_route'   => 'dtc_vehicule_modele_modifier',
  521.                                   'typeDocument' => 'modeleVehiculeOr',
  522.                               ],
  523.                           ],
  524.                           13 => [
  525.                               'view' => 'FO/DataTable/commentaire.html.twig',
  527.                           ],
  528.                           15 => [
  529.                               'view'   => 'FO/DataTable/actions.html.twig',
  530.                               'params' => [
  531.                                   'edit_route' => 'dtc_devis_or_modifier',
  532.                                   //'supprimer_route'    => 'dtc_commande_supprimer',
  533.                                   'objet'      => Commande::class,
  534.                                   'deplier'    => true,
  535.                               ],
  536.                           ],
  538.                       ]
  539.                   )->setMultiple(
  540.                 [
  541.                     'delete' => [
  542.                         'title' => 'Non disponible',
  543.                         'route' => 'dtc_devis_liste_supprimer',
  544.                     ],
  545.                 ]
  546.             )
  548.             //->setOrder("ec.ordre", "desc")
  549.                   ->setOrder("x.date", "desc")
  550.                   ->setSearch(true)
  551.                   ->setSearchFields([1, 3, 4, 5, 9, 10]);
  553.         $where      = 'x.typeDocumentCommercial = :typeDocumentCommercial and x.visible= :visible';
  554.         $parameters = ['typeDocumentCommercial' => TypeDocumentCommercial::DEVISOR, 'visible' => 1];
  557.         if (array_key_exists('parametres', $param)) {
  558.             if (array_key_exists('client', $param["parametres"]) and $param["parametres"]["client"] > 0) {
  559.                 //$datatable->addJoin('x.client', 'client', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN);
  560.                 $parameters["client"] = $param["parametres"]["client"];
  561.                 if ($where != "") {
  562.                     $where .= " AND ";
  563.                 }
  564.                 $where .= "c.id = :client";
  565.             }
  566.             if (array_key_exists('client', $param["parametres"]) and $param["parametres"]["date_debut"] != "") {
  567.                 $param["parametres"]["date_debut"] = \DateTime::createFromFormat('d/m/Y', $param["parametres"]["date_debut"]);
  568.                 $param["parametres"]["date_debut"]->setTime(00, 00, 00);
  569.                 $parameters["date_debut"] = $param["parametres"]["date_debut"];
  570.                 if ($where != "") {
  571.                     $where .= " AND ";
  572.                 }
  573.                 $where .= "x.date >= :date_debut";
  574.             }
  575.             if (array_key_exists('client', $param["parametres"]) and $param["parametres"]["date_fin"] != "") {
  576.                 $param["parametres"]["date_fin"] = \DateTime::createFromFormat('d/m/Y', $param["parametres"]["date_fin"]);
  577.                 $param["parametres"]["date_fin"]->setTime(23, 59, 59);
  578.                 $parameters["date_fin"] = $param["parametres"]["date_fin"];
  579.                 if ($where != "") {
  580.                     $where .= " AND ";
  581.                 }
  582.                 $where .= "x.date <= :date_fin";
  583.             }
  584.         }
  585.         //echo $where;           
  586.         if ($where != '') {
  587.             //echo $where;
  588.             $datatable->setWhere($where, $parameters);
  589.         }
  591.         return $datatable;
  592.     }
  595.     /**
  596.      * @Route("/ordre-reparation/devis-or/recuperer/{id}", name="dtc_devis_or_recuperer")
  597.      */
  598.     public function recupererDevisAction(Request $request, Commande $or, EntityManagerInterface $em, Datatable $datatable, TranslatorInterface $translator)
  599.     {
  601.         $client = $or->getClient();
  602.         if ($request->getMethod() == 'POST') {
  603.             $devis = $request->request->get('devis');
  605.             $em         = $em;
  606.             $repo_devis = $em->getRepository(Commande::class);
  607.             if ($devis != '') {
  608.                 $devis = $repo_devis->find($devis);
  609.             }
  610.             if (is_object($devis) and 1 != 1) {
  611.                 $repo_articleCommande = $em->getRepository(ArticleCommande::class);
  612.                 foreach ($devis->getArticleCommande() as $ac) {
  613.                     //echo $ac->getId().' / ';
  614.                     $articleCommandeOr = $repo_articleCommande->findOneBy(['commande' => $or->getId(), 'article' => $ac->getArticle()->getId()]);
  615.                     if (is_object($articleCommandeOr)) {
  616.                         $quantite = $ac->getQuantite() + $articleCommandeOr->getQuantite();
  617.                         $articleCommandeOr->setQuantite($quantite);
  618.                         $ralClient = $ac->getRalClient() + $articleCommandeOr->getQuantite();
  619.                         $articleCommandeOr->setRalClient($ralClient);
  620.                         if (floatval($ac->getQuantite()) > 0) {
  621.                             $ac->getArticle()->setStockReserve(floatval($ac->getArticle()->getStockReserve()) + floatval($ac->getQuantite()));
  622.                         }
  623.                         $em->persist($ac->getArticle());
  624.                         //echo 'q:'.$quantite.' / ';
  625.                     } else {
  626.                         $articleCommandeOr = clone $ac;
  627.                         $articleCommandeOr->setCommande($or);
  628.                         $articleCommandeOr->setRalClient(floatval($ac->getQuantite()));
  629.                         if (floatval($ac->getQuantite()) > 0) {
  630.                             $ac->getArticle()->setStockReserve(floatval($ac->getArticle()->getStockReserve()) + floatval($ac->getQuantite()));
  631.                         }
  632.                     }
  633.                     $em->persist($articleCommandeOr);
  636.                 }
  637.                 $em->flush();
  638.                 $this->addFlash(
  639.                     'notice',
  640.                     $translator->trans('Devis ajouté avec succès !')
  641.                 );
  642.             }
  644.             $url = $this->generateUrl('dtc_ordre_reparation_modifier', ['id' => $or->getId(), 'operation' => '']);
  646.             return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url]);
  648.         } else {
  649.             $titre_modal = "Liste des devis de ".$client->getPrenom()." ".$client->getNom();
  650.             $this->datatableDevis($or, $datatable, $translator);
  651.             $rendu = $this->renderView('GestionComerciale/DevisOr/recuperer.html.twig', ['commande' => $or]);
  653.             return new JsonResponse(['rendu' => $rendu, 'valide' => '1', 'url' => '', 'titre' => $titre_modal]);
  654.         }
  655.     }
  657.     /**
  658.      * @Route("/ordre-reparation/devis-or/recuperer/grid/{id}", name="dtc_client_devis_or_liste_grid")
  659.      */
  660.     public function gridDevisAction(Request $request, Commande $commande, Datatable $datatable, TranslatorInterface $translator)
  661.     {
  662.         return $this->datatableDevis($commande, $datatable, $translator)->execute();
  663.     }
  666.     /**
  667.      * @Route("/ordre-reparation/devis-or/grid", name="dtc_devis_or_liste_grid")
  668.      */
  669.     public function gridAction(Request $request, Datatable $datatable, TranslatorInterface $translator)
  670.     {
  671.         return $this->datatable($request, $datatable, $translator)->execute();
  672.     }
  675.     /**
  676.      * set datatable configs
  677.      *
  678.      * @return \App\Library\Datatable\Util\Datatable
  679.      */
  680.     private function datatableDevis($commande = "", Datatable $datatable, TranslatorInterface $translator)
  681.     {
  682.         $datatable  //->setDatatableId('dta-devis')
  683.         ->setEntity(Commande::class, "x")
  684.         ->setFields(
  685.             [
  686.                 //$translator->trans("ID") =>  'x.id',
  687.                 $translator->trans("Réf")      => 'x.reference',
  688.                 //$translator->trans("Statut") =>  's.libelle',
  689.                 //$translator->trans("Type") =>  't.libelle',
  690.                 $translator->trans("Total HT") => 'x.total',
  691.                 $translator->trans("Actions")  => 'x.id',
  692.                 "_identifier_"                 => 'x.id',
  693.             ]
  694.         )
  695.         ->setWhere(
  696.             'x.client = :client and t.id IN (:typeDocumentCommercial)',
  697.             ['client' => $commande->getClient(), 'typeDocumentCommercial' => [TypeDocumentCommercial::DEVIS, TypeDocumentCommercial::DEVISOR]]
  698.         )
  699.         ->addJoin('x.statutCommande', 's', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  700.         //->addJoin('x.typeDocumentCommercial', 't', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  701.         ->setRenderers(
  702.             [
  703.                 0 => [
  704.                     'view'   => 'FO/DataTable/lien.html.twig',
  705.                     'params' => [
  706.                         'edit_route' => 'dtc_commande_modifier',
  707.                         'objet'      => Commande::class,
  708.                     ],
  709.                 ],
  710.                 1 => [
  711.                     'view' => 'FO/DataTable/prix.html.twig',
  713.                 ],
  714.                 2 => [
  715.                     'view'   => 'FO/DataTable/action_ajouter.html.twig',
  716.                     'params' => [
  717.                         'edit_route' => 'dtc_devis_or_recuperer',
  718.                         'id'         => $commande->getId(),
  720.                     ],
  721.                 ],
  723.             ]
  724.         )
  725.         ->setOrder("x.id", "desc")
  726.         ->setSearch(true)
  727.         ->setSearchFields([0]);
  729.         return $datatable;
  730.     }
  733.     /**
  734.      * @Route("/ordre-reparation/devis-or/pdf/{id}", name="dtc_devis_or_pdf")
  735.      */
  736.     public function pdfDevisAction(Request $request, Commande $commande, EntityManagerInterface $em, Pdf $snappy)
  737.     {
  739.         $societe    = $em->getRepository(Societe::class)->find(1);
  740.         $date_Y     = date("Y");
  741.         $date_M     = date("m");
  742.         $date_D     = date("d");
  743.         $date       = $date_Y.'/'.$date_M.'/'.$date_D;
  744.         $chemin_pdf = 'PDF/DEVIS/'.$date.'/DEVIS-'.$commande->getReference().'.pdf';
  746.         if (file_exists($chemin_pdf)) {
  747.             unlink($chemin_pdf);
  748.         }
  750.         //return $this->render('GestionComerciale/Facture/template_pdf.html.twig',array('commande'  => $commande,'societe'  => $societe));
  751.         $footer = $this->renderView('FO/PDF/footer_pagination_pdf.html.twig', ['societe' => $societe]);
  752.         $header = $this->renderView('FO/PDF/header_devis_pdf.html.twig', ['societe' => $societe, 'commande' => $commande]);
  753.         //$snappy->setOption('page-size', 'A4');
  754.         $snappy->setOption('footer-html', $footer);
  755.         $snappy->setOption('header-html', $header);
  756.         $snappy->setOption('margin-bottom', "10");
  757.         //$snappy->setOption('margin-top',"10");
  758.         //$snappy->setOption('zoom', 1 );
  759.         //$snappy->setOption('dpi', 300 );
  761.         $reference = $request->query->get('reference');
  762.         $prix      = $request->query->get('prix');
  764.         $snappy->generateFromHtml(
  765.             $this->renderView(
  766.                 'GestionComerciale/DevisOr/template_pdf.html.twig',
  767.                 [
  768.                     'commande'  => $commande,
  769.                     'societe'   => $societe,
  770.                     'reference' => $reference,
  771.                     'prix'      => $prix,
  772.                 ]
  773.             ),
  774.             $chemin_pdf
  775.         );
  778.         return $this->render('FO/PDF/conteneur_pdf.html.twig', ['chemin_pdf' => '/'.$chemin_pdf]);
  779.         //return new RedirectResponse("/".$chemin_pdf);
  781.     }
  783.     /**
  784.      * @Route("/vente/devis/toggle-devis-or/{id}", name="dtc_devis_toggle_devis_or")
  785.      */
  786.     public function toggleDevisDevisOrAction(Request $request, Commande $commande, EntityManagerInterface $em)
  787.     {
  788.         if ($commande->getTypeDocumentCommercial() == TypeDocumentCommercial::DEVIS) {
  789.             $idTypeDocumentCommercial = 10;
  790.         }  //Devis -> Devis Or
  791.         else {
  792.             $idTypeDocumentCommercial = 1;
  793.         } //Devis Or -> Devis
  794.         $typeDocumentCommercial = $em->getRepository(TypeDocumentCommercial::class)->find($idTypeDocumentCommercial);//devis
  795.         $commande->setTypeDocumentCommercial($typeDocumentCommercial);
  796.         $em->persist($commande);
  797.         $em->flush();
  799.         return $this->redirectToRoute('dtc_devis_modifier', ["id" => $commande->getId()]);
  800.     }
  802. }