src/Controller/GestionComerciale/OrdreRepController.php line 326

Open in your IDE?
  1. <?php
  3. namespace App\Controller\GestionComerciale;
  5. use App\Entity\Clients\Client;
  6. use App\Entity\FO\Societe;
  7. use App\Entity\GestionComerciale\ArticleCommande;
  8. use App\Entity\GestionComerciale\Commande;
  9. use App\Entity\GestionComerciale\OrdreRep;
  10. use App\Entity\GestionComerciale\StatutCommande;
  11. use App\Model\GestionCommerciale\TypeDocumentCommercial;
  12. use App\Entity\Projets\Intervention;
  13. use App\Entity\Utilisateur\Utilisateur;
  14. use App\Form\GestionComerciale\OrdreReparationType;
  15. use App\Form\GestionComerciale\OrdreRepType;
  16. use App\Library\Datatable\Util\Datatable;
  17. use App\Security\Voter\EntityVoter;
  18. use App\Service\GestionComerciale\AcompteService;
  19. use App\Service\GestionComerciale\OrdreRepService;
  20. use App\Service\Utilisateur\ColonneTableauService;
  21. use Doctrine\ORM\EntityManagerInterface;
  22. use Knp\Snappy\Pdf;
  23. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  24. use Symfony\Component\HttpFoundation\Request;
  25. use Symfony\Component\HttpFoundation\JsonResponse;
  26. use Symfony\Component\HttpFoundation\Response;
  27. use Symfony\Component\Routing\Annotation\Route;
  28. use Symfony\Component\Validator\Validator\ValidatorInterface;
  29. use Symfony\Contracts\Translation\TranslatorInterface;
  31. class OrdreRepController extends AbstractController
  32. {
  34.     /**
  35.      * @Route("/vente/or/nouveau", name="dtc_ordre_reparation_ajouter")
  36.      * @Route("/ordre-reparation/nouveau", name="dtc_ordre_reparation_ajouter")
  37.      */
  38.     public function ajouterAction(Request $request, EntityManagerInterface $em, OrdreRepService $ordreRepService, TranslatorInterface $translator, ValidatorInterface $validator)
  39.     {
  40.         set_time_limit(300);
  41.         $commande = new Commande();
  42.         $commande->setDateBon(null);
  43.         $user = $this->getUser();
  44.         $commande->setUtilisateur($user);
  46.         $bpa       = 0;
  47.         $clie      = "";
  48.         $operation = $request->request->get('operation');
  49.         $client    = $request->get('client');
  51.         if ($client != "") {
  52.             $repoClient = $em->getRepository(Client::class);
  53.             $clie       = $repoClient->find($client);
  54.             if (is_object($clie)) {
  55.                 $commande->setClient($clie);
  56.             }
  57.         }
  58.         $form   = $this->createForm(OrdreReparationType::class, $commande);
  59.         $errors = "";
  60.         $form->handleRequest($request);
  61.         if ($form->isSubmitted()) {
  62.             if ($form->isValid()) {
  64.                 $em->persist($commande);
  65.                 $em->flush();
  67.                 //echo "BBBB ".$request->request->get('operation');              
  69.                 //$articles = array('ids'=>$request->request->get('ids'),'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'));
  70.                 $articles = [
  71.                     'ids'                      => $request->request->get('ids'),
  72.                     'idArticleCommande'        => $request->request->get('idArticleCommande'),
  73.                     'idArticleCommandeOrigine' => $request->request->get('idArticleCommandeOrigine'),
  74.                     'remise'                   => $request->request->get('remise'),
  75.                     'remiseCalcule'            => $request->request->get('remiseCalcule'),
  76.                     'montantRemise'            => $request->request->get('montantRemise'),
  77.                     'commentaire'              => $request->request->get('commentaire'),
  78.                     'libellesSecondaires'      => $request->request->get('libellesSecondaires'),
  79.                     'libelles'                 => $request->request->get('libelles'),
  80.                     'tva'                      => $request->request->get('tva'),
  81.                     'remiseSuppl'              => $request->request->get('remiseSuppl'),
  82.                     'prix'                     => $request->request->get('prix'),
  83.                     'qte'                      => $request->request->get('qte'),
  84.                     'qtePrepa'                 => $request->request->get('qtePrepa'),
  85.                     'qteDispo'                 => $request->request->get('qteDispo'),
  86.                     'force'                    => $request->request->get('force'),
  87.                     'dateCT'                   => $request->request->get('dateCT'),
  88.                     'kilometrage'              => $request->request->get('kilometrage'),
  89.                     'commentaireSuppl'         => $request->request->get('commentaireSuppl'),
  90.                     'emplacement'              => $request->request->get('emplacement'),
  91.                     'nbEmplacement'            => $request->request->get('nbEmplacement'),
  92.                     'articlesCommandeRepris'   => $request->request->get('articlesCommandeRepris'),
  93.                 ];
  95.                 if ($operation == 'facture') {
  96.                     $operation = 'factureDirecte';
  97.                 }
  98.                 $valeurs = ["articles" => $articles, 'typeDocument' => 'commande', 'operation' => $operation, 'toggle-devis-devis-or' => ''];
  99.                 $retour  = $ordreRepService->sauvegarderOrdre($commande, $valeurs);
  100.                 if ($retour['bpa'] == 1) {
  101.                     $bpa = 1;
  102.                 }
  104.                 if ($operation == 'factureDirecte') {
  105.                     $this->addFlash(
  106.                         'notice',
  107.                         $translator->trans('Facture et Ordre de réparation ajoutés avec succès !')
  108.                     );
  110.                     return $this->redirectToRoute('dtc_facture_afficher', ["id" => $commande->getFacture()->getId(), 'operation' => $operation]);
  111.                 }
  113.                 $this->addFlash(
  114.                     'notice',
  115.                     $translator->trans('Ordre de réparation ajouté avec succès !')
  116.                 );
  118.                 return $this->redirectToRoute('dtc_ordre_reparation_modifier', ["id" => $commande->getId(), 'operation' => $operation, "bpa" => $bpa, 'forceQteDispo' => true]);
  119.             } else {
  120.                 $errors = $validator->validate($commande);
  121.                 //echo "PAS VALIDE";
  122.             }
  123.         }
  125.         return $this->render(
  126.             'GestionComerciale/OrdreRep/ajouter.html.twig',
  127.             ['form' => $form->createView(), 'errors' => $errors, 'operation' => $operation, 'client' => $clie, 'forceQteDispo' => true]
  128.         );
  129.     }
  132.     /**
  133.      * @Route("/ordre-reparation/modifier/{id}", name="dtc_ordre_reparation_modifier")
  134.      */
  135.     public function modifierAction(Request            $request, Commande $commande, EntityManagerInterface $em, OrdreRepService $ordreRepService,
  136.                                    AcompteService     $serviceAcompte, TranslatorInterface $translator,
  137.                                    ValidatorInterface $validator
  138.     ) {
  139.         set_time_limit(300);
  140.         $user = $this->getUser();
  141.         $commande->setUtilisateur($user);
  142.         $annuler       = $request->request->get('annuler');
  143.         $forceQteDispo = $request->query->get('forceQteDispo');
  145.         if ($annuler == "annuler" || $annuler == "annuler_devis" || $annuler == "annuler_cmde") {
  148.             if (is_int($commande->getTypeDocumentCommercial()) and $commande->getTypeDocumentCommercial() == TypeDocumentCommercial::DEVIS0) {
  149.                 //$commande->setVisible(false);
  151.                 $this->addFlash(
  152.                     'notice',
  153.                     $translator->trans('Devis OR supprimé avec succès!')
  154.                 );
  156.                 $em->persist($commande);
  157.                 $em->flush();
  159.                 return $this->redirectToRoute('dtc_devis_or_liste');
  160.             } else {
  161.                 $ordreRepService->annuler($commande, $annuler);
  163.                 $remboursement = $serviceAcompte->proposerRemboursement($commande->getClient());
  165.                 $this->addFlash(
  166.                     'notice',
  167.                     $translator->trans('Ordre de réparation annulé avec succès !')
  168.                 );
  170.                 return $this->redirectToRoute('dtc_ordre_reparation_liste', ["r" => $remboursement, "c" => $commande->getClient()->getId()]);
  171.             }
  174.         }
  177.         $form = $this->createForm(OrdreReparationType::class, $commande);
  179.         $operation = $request->request->get('operation');
  180.         $bpa       = $request->query->get('bpa');
  182.         if ($operation == "") {
  183.             $operation = $request->query->get('operation');
  184.         }
  187.         //$articles = array('ids'=>$request->request->get('ids'),'qte'=>$request->request->get('qte'),'remise'=>$request->request->get('remise'));
  188.         $articles = [
  189.             'ids'                      => $request->request->get('ids'),
  190.             'idArticleCommande'        => $request->request->get('idArticleCommande'),
  191.             'idArticleCommandeOrigine' => $request->request->get('idArticleCommandeOrigine'),
  192.             'remise'                   => $request->request->get('remise'),
  193.             'remiseCalcule'            => $request->request->get('remiseCalcule'),
  194.             'montantRemise'            => $request->request->get('montantRemise'),
  195.             'commentaire'              => $request->request->get('commentaire'),
  196.             'libellesSecondaires'      => $request->request->get('libellesSecondaires'),
  197.             'libelles'                 => $request->request->get('libelles'),
  198.             'tva'                      => $request->request->get('tva'),
  199.             'remiseSuppl'              => $request->request->get('remiseSuppl'),
  200.             'prix'                     => $request->request->get('prix'),
  201.             'qte'                      => $request->request->get('qte'),
  202.             'qtePrepa'                 => $request->request->get('qtePrepa'),
  203.             'force'                    => $request->request->get('force'),
  204.             'dateCT'                   => $request->request->get('dateCT'),
  205.             'kilometrage'              => $request->request->get('kilometrage'),
  206.             'commentaireSuppl'         => $request->request->get('commentaireSuppl'),
  207.             'emplacement'              => $request->request->get('emplacement'),
  208.             'nbEmplacement'            => $request->request->get('nbEmplacement'),
  209.             'articlesCommandeRepris'   => $request->request->get('articlesCommandeRepris'),
  210.             'qteDispo'                 => $request->request->get('qteDispo'),
  211.         ];
  212.         $valeurs  = ["articles" => $articles, 'operation' => $operation, 'toggle-devis-devis-or' => ''];
  215.         $errors = "";
  216.         $form->handleRequest($request);
  217.         if ($form->isSubmitted()) {
  219.             if ($ordreRepService->estEditable($commande)) {
  221.                 $droit = $this->isGranted(EntityVoter::UPDATE, OrdreRep::class);
  223.                 if ( ! $droit) {
  224.                     return $this->redirectToRoute('dtc_ordre_reparation_modifier', ["id" => $commande->getId()]);
  225.                 }
  227.                 if ($form->isValid()) {
  229.                     if ($request->request->get('annuler') != '') {
  230.                         $ordreRepService->annulerOrdre($commande);
  231.                         $this->addFlash(
  232.                             'notice',
  233.                             $translator->trans('Ordre de réparation annulé avec succès !')
  234.                         );
  236.                         return $this->redirectToRoute('dtc_ordre_reparation_liste', ['operation' => $operation]);
  237.                     }
  239.                     if ($request->request->get('toggle-devis-devis-or') != '') {
  240.                         $valeurs['toggle-devis-devis-or'] = 'toggle-devis-devis-or';
  241.                     }
  243.                     $em->persist($commande);
  244.                     $em->flush();
  247.                     $retour = $ordreRepService->sauvegarderOrdre($commande, $valeurs);
  248.                     if ($retour['bpa'] == 1) {
  249.                         $bpa = 1;
  250.                     } else {
  251.                         $bpa = 0;
  252.                     }
  255.                     if ($operation == "facture") {
  256.                         $this->addFlash(
  257.                             'notice',
  258.                             $translator->trans('Facture sauvegardée avec succès !')
  259.                         );
  262.                         $repo_statut_document = $em->getRepository(StatutCommande::class);
  263.                         $liste_statut         = $repo_statut_document->findOneBy(["documentCommercial" => 6, "ordre" => [1]]);
  265.                         $typeFac  = TypeDocumentCommercial::FACTURE;
  266.                         $repo_fac = $em->getRepository(Commande::class);
  267.                         $facture  = $repo_fac->findOneBy(["commande" => $commande, "typeDocumentCommercial" => $typeFac, "visible" => 1, "statutCommande" => $liste_statut]);
  269.                         return $this->redirectToRoute('dtc_facture_afficher', ["id" => $facture->getId()]);
  270.                     } else {
  271.                         $this->addFlash(
  272.                             'notice',
  273.                             $translator->trans('Ordre de réparation sauvegardé avec succès !')
  274.                         );
  275.                         //return $this->redirectToRoute('dtc_ordre_reparation_modifier',array("id"=>$commande->getId(),'operation'=>$operation));
  278.                         if ($request->request->get('toggle-devis-devis-or') != '') {
  279.                             return $this->redirectToRoute('dtc_devis_modifier', ["id" => $commande->getId(), 'forceQteDispo' => true]);
  280.                         } else {
  281.                             return $this->redirectToRoute(
  282.                                 'dtc_ordre_reparation_modifier',
  283.                                 ["id" => $commande->getId(), 'operation' => $operation, "bpa" => $bpa, 'forceQteDispo' => true]
  284.                             );
  285.                         }
  287.                     }
  290.                 } else {
  291.                     //echo "ERREUR";
  292.                     $errors = $validator->validate($commande);
  293.                     //\Doctrine\Common\Util\Debug::dump($errors);
  294.                 }
  295.             } else {
  297.                 $this->addFlash(
  298.                     'warning',
  299.                     "L'ordre de réparation n'est plus éditable !"
  300.                 );
  302.                 //return $this->redirectToRoute('dtc_ordre_reparation_modifier',array("id"=>$commande->getId(),'operation'=>$operation));
  303.                 //echo "<div>PAS EDIT OK</div>";
  304.             }
  305.         }
  307.         if ($bpa == 1) {
  309.             $repo_bp    = $em->getRepository(Commande::class);
  310.             $dernierBpa = $repo_bp->getDernierBonPrepaAtelier($commande);
  311.             if (count($dernierBpa) > 0) {
  312.                 $bpa = $dernierBpa["id"];
  313.             }
  314.         }
  316.         return $this->render(
  317.             'GestionComerciale/OrdreRep/ajouter.html.twig',
  318.             ['form' => $form->createView(), 'errors' => $errors, 'commande' => $commande, 'operation' => $operation, "bpa" => $bpa, 'forceQteDispo' => $forceQteDispo]
  319.         );
  320.     }
  323.     /**
  324.      * @Route("/vente/or/nouveau/modal/{id}/{type}", name="dtc_ordre_reparation_ajouter_modal")
  325.      */
  326.     public function ajouterModalAction(Request            $request, $id, $type = "", EntityManagerInterface $em, OrdreRepService $ordreReprationService, TranslatorInterface $translator,
  327.                                        ValidatorInterface $validator
  328.     ) {
  329.         $titre_modal = $translator->trans("Nouveau OR");
  330.         $repo_objet  = $em->getRepository(Commande::class);
  331.         $objet       = $repo_objet->find($id);
  333.         $ordreRep = clone $objet;
  334.         $ordreRep->setDateBon(new \DateTime());
  337.         $user = $this->getUser();
  338.         $ordreRep->setUtilisateur($user);
  339.         $form   = $this->createForm(OrdreRepType::class, $ordreRep);
  340.         $errors = "";
  341.         $form->handleRequest($request);
  343.         $idsArticleCommande = $request->query->get('choixArticles');
  344.         $repo_objet         = $em->getRepository(Commande::class);
  345.         $objet              = $repo_objet->find($id);
  346.         $ordreRep->setCommande($objet);
  348.         $link            = $this->generateUrl('dtc_ordre_reparation_ajouter', ['id' => $objet->getId(), 'type' => 'commande']);
  349.         $articleCommande = $em->getRepository(ArticleCommande::class)->listeArticleCommandeSelectionne($idsArticleCommande);
  351.         if ($form->isSubmitted()) {
  352.             if ($form->isValid()) {
  354.                 $url = $this->generateUrl('dtc_commande_modifier', ['id' => $objet->getId(), 'tab' => 'or']);
  356.                 $articles = [
  357.                     'idArticleCommande' => $request->request->get('idArticleCommande'),
  358.                     'quantiteInit'      => $request->request->get('quantiteInit'),
  359.                     'quantite'          => $request->request->get('quantite'),
  360.                 ];
  361.                 $valeurs  = ["articles" => $articles];
  362.                 $ordreReprationService->sauvegarder($ordreRep, $valeurs);
  364.                 $this->addFlash(
  365.                     'notice',
  366.                     $translator->trans('Ordre de réparation ajouté avec succès !')
  367.                 );
  369.                 return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url]);
  371.             } else {
  372.                 $errors = $validator->validate($ordreRep);
  373.                 $rendu  = $this->renderView(
  374.                     'GestionComerciale/OrdreRep/ajouter_modal.html.twig',
  375.                     ['form' => $form->createView(), 'errors' => $errors, 'id' => $id, 'type' => $type, 'articleCommande' => $articleCommande]
  376.                 );
  378.                 return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  379.             }
  380.         }
  381.         $rendu = $this->renderView(
  382.             'GestionComerciale/OrdreRep/ajouter_modal.html.twig',
  383.             ['form' => $form->createView(), 'errors' => $errors, 'id' => $id, 'type' => $type, 'articleCommande' => $articleCommande]
  384.         );
  386.         return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'link' => $link, 'titre' => $titre_modal]);
  387.     }
  390.     /**
  391.      * @Route("/vente/or", name="dtc_ordre_reparation_liste")
  392.      * @Route("/ordre-reparation", name="dtc_ordre_reparation_liste")
  393.      */
  394.     public function listerAction(Request             $request, $id = "0", $type = "a", EntityManagerInterface $em, ColonneTableauService $serviceColonneTableau, Datatable $datatable,
  395.                                  TranslatorInterface $translator
  396.     ) {
  397.         $repo_objet = $em->getRepository(Commande::class);
  398.         $objet      = $repo_objet->find($id);
  400.         $param = $request->query->all();
  402.         if (is_object($objet)) {
  403.             $this->datatableCommande($datatable, $translator,$objet, $type);
  405.             return $this->render('GestionComerciale/OrdreRep/lister_commande.html.twig', ["id" => $id, "type" => $type, 'parametres' => $param]);
  406.         } else {
  408.             $statutCommande          = $request->query->get('statutCommande');
  409.             $tableau_class_cellule[] = ["className" => "colonne_id", "targets" => [0], "visible" => true, "orderable" => false];
  410.             $tableau_class_cellule[] = [
  411.                 "className" => "visible_export colonne_id",
  412.                 "targets"   => [1],
  413.                 "visible"   => $serviceColonneTableau->getColonneUtilisateur(OrdreRep::class, "id"),
  414.             ];
  415.             $tableau_class_cellule[] = [
  416.                 "className" => "visible_export colonne_id",
  417.                 "targets"   => [2],
  418.                 "visible"   => $serviceColonneTableau->getColonneUtilisateur(OrdreRep::class, "reference"),
  419.             ];
  420.             $tableau_class_cellule[] = [
  421.                 "className" => "visible_export colonne_id",
  422.                 "targets"   => [3],
  423.                 "visible"   => $serviceColonneTableau->getColonneUtilisateur(OrdreRep::class, "date"),
  424.             ];
  425.             $tableau_class_cellule[] = [
  426.                 "className" => "visible_export colonne_id",
  427.                 "targets"   => [4],
  428.                 "visible"   => $serviceColonneTableau->getColonneUtilisateur(OrdreRep::class, "statutCommande"),
  429.             ];
  430.             $tableau_class_cellule[] = [
  431.                 "className" => "visible_export colonne_id",
  432.                 "targets"   => [5],
  433.                 "visible"   => $serviceColonneTableau->getColonneUtilisateur(OrdreRep::class, "refclient"),
  434.             ];
  435.             $tableau_class_cellule[] = [
  436.                 "className" => "visible_export colonne_id",
  437.                 "targets"   => [6],
  438.                 "visible"   => $serviceColonneTableau->getColonneUtilisateur(OrdreRep::class, "client"),
  439.             ];
  440.             $tableau_class_cellule[] = [
  441.                 "className" => "visible_export colonne_id",
  442.                 "targets"   => [7],
  443.                 "visible"   => $serviceColonneTableau->getColonneUtilisateur(OrdreRep::class, "rdv"),
  444.             ];
  445.             $tableau_class_cellule[] = [
  446.                 "className" => "visible_export colonne_id",
  447.                 "targets"   => [8],
  448.                 "visible"   => $serviceColonneTableau->getColonneUtilisateur(OrdreRep::class, "equipier"),
  449.             ];
  450.             $tableau_class_cellule[] = [
  451.                 "className" => "visible_export colonne_id",
  452.                 "targets"   => [9],
  453.                 "visible"   => $serviceColonneTableau->getColonneUtilisateur(OrdreRep::class, "immat"),
  454.             ];
  455.             $tableau_class_cellule[] = [
  456.                 "className" => "visible_export colonne_id",
  457.                 "targets"   => [10],
  458.                 "visible"   => $serviceColonneTableau->getColonneUtilisateur(OrdreRep::class, "marque"),
  459.             ];
  460.             $tableau_class_cellule[] = [
  461.                 "className" => "visible_export colonne_id",
  462.                 "targets"   => [11],
  463.                 "visible"   => $serviceColonneTableau->getColonneUtilisateur(OrdreRep::class, "modele"),
  464.             ];
  465.             $tableau_class_cellule[] = [
  466.                 "className" => "visible_export colonne_id",
  467.                 "targets"   => [12],
  468.                 "visible"   => $serviceColonneTableau->getColonneUtilisateur(OrdreRep::class, "km"),
  469.             ];
  470.             $tableau_class_cellule[] = [
  471.                 "className" => "visible_export colonne_id",
  472.                 "targets"   => [13],
  473.                 "visible"   => $serviceColonneTableau->getColonneUtilisateur(OrdreRep::class, "serie"),
  474.             ];
  475.             $tableau_class_cellule[] = [
  476.                 "className" => "visible_export colonne_id",
  477.                 "targets"   => [14],
  478.                 "visible"   => $serviceColonneTableau->getColonneUtilisateur(OrdreRep::class, "commentaire"),
  479.             ];
  480.             $tableau_class_cellule[] = [
  481.                 "className" => "visible_export colonne_id",
  482.                 "targets"   => [15],
  483.                 "visible"   => $serviceColonneTableau->getColonneUtilisateur(OrdreRep::class, "refCli"),
  484.             ];
  485.             $tableau_class_cellule[] = ["orderable" => false, "className" => "colonne_id", "targets" => [16], "visible" => true];
  486.             $this->datatable($request, $datatable, $translator);
  489.             return $this->render(
  490.                 'GestionComerciale/OrdreRep/lister.html.twig',
  491.                 ["id" => $id, "type" => $type, 'tableauClassColonne' => $tableau_class_cellule, 'statutCommande' => $statutCommande, 'parametres' => $param]
  492.             );
  494.         }
  495.     }
  498.     /**
  499.      * set datatable configs
  500.      *
  501.      * @return \App\Library\Datatable\Util\Datatable
  502.      */
  503.     private function datatable(Request $request, Datatable $datatable, TranslatorInterface $translator)
  504.     {
  505.         $param = $request->query->all();
  506.         $datatable->setEntity(Commande::class, "x")
  507.                   ->setFields(
  508.                       [
  509.                           $translator->trans("ID")           => 'x.id',
  510.                           $translator->trans("Réf")          => 'x.reference',
  511.                           $translator->trans("Date")         => 'x.date',
  512.                           $translator->trans("Statut")       => 'sc.id',
  513.                           $translator->trans("Réf client")   => 'c.reference',
  514.                           $translator->trans("Client")       => 'c.nom',
  515.                           $translator->trans("RDV ")         => 'x.dateBon',
  516.                           $translator->trans("Équipier")     => 'u.reference',
  517.                           $translator->trans("Immat")        => 'v.immatriculation',
  518.                           $translator->trans("Marque")       => 'm.libelle',
  519.                           $translator->trans("Modèle")       => 'mo.libelle',
  520.                           $translator->trans("Km")           => 'v.kilometrage',
  521.                           $translator->trans("Num serie")    => 'v.numSerie',
  522.                           $translator->trans("Comm")         => 'x.commentaire',
  523.                           $translator->trans("Réf cmde cli") => 'x.referenceClient',
  524.                           $translator->trans("Actions")      => 'x.id',
  525.                           "_identifier_"                     => 'x.id',
  526.                       ]
  527.                   )
  528.                   ->addJoin('x.vehiculesClient', 'v', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  529.                   ->addJoin('v.marque', 'm', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  530.                   ->addJoin('x.statutCommande', 'sc', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  531.                   ->addJoin('v.modele', 'mo', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  532.                   ->addJoin('x.etatCommande', 'ec', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  533.                   ->addJoin('x.client', 'c', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  534.                   ->addJoin('x.utilisateur', 'u', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  535.                   ->addJoin('x.facture', 'f', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  536.                   ->setRenderers(
  537.                       [
  538.                           0 => [
  539.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  540.                               'params' => [
  541.                                   'edit_route' => 'dtc_ordre_reparation_modifier',
  542.                               ],
  544.                           ],
  545.                           1 => [
  546.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  547.                               'params' => [
  548.                                   'edit_route' => 'dtc_ordre_reparation_modifier',
  549.                               ],
  551.                           ],
  552.                           2 => [
  553.                               'view' => 'FO/DataTable/heure.html.twig',
  555.                           ],
  556.                           3 => [
  557.                               'view' => 'FO/DataTable/statut-commande-fournisseur.html.twig',
  559.                           ],
  560.                           4 => [
  561.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  562.                               'params' => [
  563.                                   'edit_route'   => 'dtc_client_modifier',
  564.                                   'typeDocument' => 'client',
  565.                               ],
  566.                           ],
  568.                           5  => [
  569.                               'view'   => 'FO/DataTable/client.html.twig',
  570.                               'params' => [],
  571.                           ],
  572.                           6  => [
  573.                               'view' => 'FO/DataTable/heure.html.twig',
  575.                           ],
  576.                           7  => [
  577.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  578.                               'params' => [
  579.                                   'edit_route'   => 'dtc_utilisateur_modifier',
  580.                                   'typeDocument' => 'equipier',
  581.                               ],
  582.                           ],
  583.                           9  => [
  584.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  585.                               'params' => [
  586.                                   'edit_route'   => 'dtc_vehicule_marque_modifier',
  587.                                   'typeDocument' => 'marqueVehiculeOr',
  588.                               ],
  589.                           ],
  590.                           10 => [
  591.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  592.                               'params' => [
  593.                                   'edit_route'   => 'dtc_vehicule_modele_modifier',
  594.                                   'typeDocument' => 'modeleVehiculeOr',
  595.                               ],
  596.                           ],
  597.                           13 => [
  598.                               'view' => 'FO/DataTable/commentaire.html.twig',
  600.                           ],
  601.                           15 => [
  602.                               'view'   => 'FO/DataTable/actions.html.twig',
  603.                               'params' => [
  604.                                   'edit_route' => 'dtc_ordre_reparation_modifier',
  605.                                   //'supprimer_route'    => 'dtc_commande_supprimer', 
  606.                                   'objet'      => Commande::class,
  607.                                   'deplier'    => true,
  608.                               ],
  609.                           ],
  611.                       ]
  612.                   )
  613.                   ->setMultiple(
  614.                       [
  615.                           'delete' => [
  616.                               'title' => 'Non disponible',
  617.                               'route' => 'dtc_commande_liste_supprimer',
  618.                           ],
  619.                       ]
  620.                   )
  621.                   ->setOrder("x.date", "desc")
  623.             //->setOrder("ec.ordre", "desc")
  624.                   ->setSearch(true)
  625.                   ->setSearchFields([1, 3, 4, 5, 8, 9, 10, 12]);
  626.         $where      = '';
  627.         $parameters = [];
  629.         if (is_object($request)) {
  631.             $statutCommande = $request->query->get('statutCommande');
  633.             if ($statutCommande == '' || $statutCommande == '19') {
  634.                 if ($where != '') {
  635.                     $where .= ' AND ';
  636.                 }
  637.                 $where                                .= 'sc.id IN (:statutCommande) AND x.typeDocumentCommercial = :typeDocumentCommercial';//AND f.id IS NULL
  638.                 $parameters['statutCommande']         = [14, 15];
  639.                 $parameters['typeDocumentCommercial'] = 3;
  641.             } else {
  642.                 if ($where != '') {
  643.                     $where .= ' AND ';
  644.                 }
  645.                 $where                                .= 'sc.id = :statutCommande AND x.typeDocumentCommercial = :typeDocumentCommercial';
  646.                 $parameters['statutCommande']         = $statutCommande;
  647.                 $parameters['typeDocumentCommercial'] = 3;
  649.             }
  651.         } else {
  653.             $where                                .= 'sc.id IN (:statutCommande) AND x.typeDocumentCommercial = :typeDocumentCommercial AND f.id IS NULL';
  654.             $parameters['statutCommande']         = [14, 15];
  655.             $parameters['typeDocumentCommercial'] = 3;
  658.         }
  661.         if (array_key_exists('parametres', $param)) {
  662.             if (array_key_exists('client', $param["parametres"]) and $param["parametres"]["client"] > 0) {
  663.                 //$datatable->addJoin('x.client', 'client', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN);
  664.                 $parameters["client"] = $param["parametres"]["client"];
  665.                 if ($where != "") {
  666.                     $where .= " AND ";
  667.                 }
  668.                 $where .= "c.id = :client";
  669.             }
  670.             if (array_key_exists('client', $param["parametres"]) and $param["parametres"]["date_debut"] != "") {
  671.                 $param["parametres"]["date_debut"] = \DateTime::createFromFormat('d/m/Y', $param["parametres"]["date_debut"]);
  672.                 $param["parametres"]["date_debut"]->setTime(00, 00, 00);
  673.                 $parameters["date_debut"] = $param["parametres"]["date_debut"];
  674.                 if ($where != "") {
  675.                     $where .= " AND ";
  676.                 }
  677.                 $where .= "x.date >= :date_debut";
  678.             }
  679.             if (array_key_exists('client', $param["parametres"]) and $param["parametres"]["date_fin"] != "") {
  680.                 $param["parametres"]["date_fin"] = \DateTime::createFromFormat('d/m/Y', $param["parametres"]["date_fin"]);
  681.                 $param["parametres"]["date_fin"]->setTime(23, 59, 59);
  682.                 $parameters["date_fin"] = $param["parametres"]["date_fin"];
  683.                 if ($where != "") {
  684.                     $where .= " AND ";
  685.                 }
  686.                 $where .= "x.date <= :date_fin";
  687.             }
  688.         }
  689.         //echo $where;           
  690.         if ($where != '') {
  691.             //echo $where;
  692.             $datatable->setWhere($where, $parameters);
  693.         }
  696.         //$datatable->setSearchFields(array(0,2));
  697.         return $datatable;
  698.     }
  701.     /**
  702.      * set datatable configs
  703.      *
  704.      * @return \App\Library\Datatable\Util\Datatable
  705.      */
  706.     private function datatableCommande(Datatable $datatable, TranslatorInterface $translator, $objet, $type = "")
  707.     {
  708.         $type_jointure = 'x.'.$type;
  709.         $datatable->setDatatableId('dta-or')
  710.                   ->setEntity(Commande::class, "x")
  711.                   ->setFields(
  712.                       [
  713.                           $translator->trans("ID")       => 'x.id',
  714.                           $translator->trans("Réf")      => 'x.reference',
  715.                           $translator->trans("Véhicule") => 'vc.id',
  716.                           $translator->trans("Date")     => 'x.dateBon',
  717.                           $translator->trans("Actions")  => 'x.id',
  718.                           "_identifier_"                 => 'x.id',
  719.                       ]
  720.                   )
  721.             //->addJoin('x.client', 'c', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)      
  722.                   ->addJoin('x.vehiculesClient', 'vc', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  723.             //->addJoin('vc.marque', 'ma', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)      
  724.             //->addJoin('vc.modele', 'm', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)      
  725.             /*->setWhere(                                                     
  726.                     $type_jointure.' = :objet',
  727.                     array('objet' => $objet)
  728.                )
  729.               */
  730.                   ->setWhere(
  731.                 'x.commande = :objet AND x.typeDocumentCommercial = :typeDocumentCommercial',
  732.                 ['objet' => $objet, 'typeDocumentCommercial' => TypeDocumentCommercial::ORDREREPARATION]
  733.             )
  734.                   ->setRenderers(
  735.                       [
  737.                           2 => [
  738.                               'view'   => 'FO/DataTable/vehicule_client.html.twig',
  739.                               'params' => [
  740.                                   'objet' => $objet,
  741.                               ],
  742.                           ],
  743.                           3 => [
  744.                               'view'   => 'FO/DataTable/date.html.twig',
  745.                               'params' => [],
  746.                           ],
  747.                           4 => [
  748.                               'view'   => 'FO/DataTable/actions_modal.html.twig',
  749.                               'params' => [
  750.                                   //'edit_route'  => 'dtc_ordre_reparation_modifier', 
  751.                                   //'supprimer_route'  => 'dtc_ordre_reparation_supprimer', 
  752.                                   'pdf_route' => 'dtc_ordre_reparation_pdf',
  753.                                   'id'        => $objet->getId(),
  754.                                   'type'      => $type,
  755.                                   'entite'    => 'ordreRep',
  756.                                   'objet'     => Commande::class,
  758.                               ],
  759.                           ],
  762.                       ]
  763.                   )
  764.                   ->setOrder("x.id", "desc")
  765.                   ->setSearch(true)//->setSearchFields(array(1,2))
  766.         ;
  768.         return $datatable;
  769.     }
  772.     /**
  773.      * Grid action
  774.      * @return Response
  775.      */
  776.     /**
  777.      * @Route("/vente/or/grid/{id}/{type}", name="dtc_ordre_reparation_liste_grid")
  778.      * @Route("/ordre-reparation/grid", name="dtc_ordre_reparation_liste_grid")
  779.      */
  780.     public function gridAction(Request $request, $id = "", $type = "", EntityManagerInterface $em, Datatable $datatable, TranslatorInterface $translator)
  781.     {
  782.         $repo_objet = $em->getRepository(Commande::class);
  783.         $objet      = $repo_objet->find($id);
  785.         if (is_object($objet)) {
  786.             return $this->datatableCommande($datatable, $translator,$objet, $type)->execute();
  787.         } else {
  788.             return $this->datatable($request, $datatable, $translator)->execute();
  789.         }
  791.     }
  793.     /**
  794.      * Grid action
  795.      * @return Response
  796.      */
  798.     /**
  799.      * @Route("/or/pdf/{id}", name="dtc_ordre_reparation_pdf")
  800.      */
  801.     public function pdfOrdreReparationAction(Request $request, Commande $ordreRepration, EntityManagerInterface $em, Pdf $snappy)
  802.     {
  804.         $prix       = $request->query->get('prix');
  805.         $societe    = $em->getRepository(Societe::class)->find(1);
  806.         $date_Y     = date("Y");
  807.         $date_M     = date("m");
  808.         $date_D     = date("d");
  809.         $date       = $date_Y.'/'.$date_M.'/'.$date_D;
  810.         $chemin_pdf = 'PDF/OR/'.$date.'/OR-'.$ordreRepration->getReference().'.pdf';
  812.         if (file_exists($chemin_pdf)) {
  813.             unlink($chemin_pdf);
  814.         }
  816.         //return $this->render('GestionComerciale/OrdreRep/template_pdf.html.twig',array('commande'  => $ordreRepration,'societe'  => $societe));
  819.         $footer = $this->renderView('FO/PDF/footer_pagination_pdf.html.twig', ['societe' => $societe]);
  820.         $header = $this->renderView('FO/PDF/header_or_pdf.html.twig', ['societe' => $societe, 'commande' => $ordreRepration]);
  822.         //return $header;
  823.         //$snappy->setOption('page-size', 'A4');
  824.         $snappy->setOption('header-html', $header);
  825.         $snappy->setOption('footer-html', $footer);
  826.         //$snappy->setOption('header-html',$footer);
  827.         $snappy->setOption('margin-bottom', "10");
  828.         //$snappy->setOption('margin-top',"2");
  829.         //$snappy->setOption('zoom', 1 );
  830.         //$snappy->setOption('dpi', 300 );
  832.         $reference = $request->query->get('reference');
  834.         $snappy->generateFromHtml(
  835.             $this->renderView(
  836.                 'GestionComerciale/OrdreRep/template_pdf.html.twig',
  837.                 [
  838.                     'commande'  => $ordreRepration,
  839.                     'societe'   => $societe,
  840.                     'prix'      => $prix,
  841.                     'reference' => $reference,
  842.                 ]
  843.             ),
  844.             $chemin_pdf
  845.         );
  848.         return $this->render('FO/PDF/conteneur_pdf.html.twig', ['objet' => $ordreRepration, 'chemin_pdf' => '/'.$chemin_pdf]);
  849.         //return new RedirectResponse("/".$chemin_pdf);
  850.     }
  852.     /**
  853.      * @Route("/vente/or/imprimer/multiple", name="dtc_ordre_reparation_pdf_multiple")
  854.      */
  855.     public function imprimerMultipleAction(Request $request, EntityManagerInterface $em,  Pdf $snappy)
  856.     {
  857.         $data       = $request->get('dataTables');
  858.         $ids        = $data['actions'];
  859.         $tableauPdf = [];
  860.         $pdfRelier  = 'PDF/OR/OR-'.date('d-m-Y').'.pdf';
  862.         //$ids = array("118","101","93");
  864.         for ($i = 0; $i < count($ids); $i++) {
  865.             $repo = $em->getRepository(Commande::class);
  866.             $bon  = $repo->find($ids[$i]);
  867.             if (is_object($bon)) {
  868.                 $this->pdfOrdreReparationAction($request, $bon,  $em, $snappy);
  869.                 $tableauPdf[] = $chemin_pdf = 'PDF/OR/OR-'.$bon->getReference().'.pdf';
  870.             }
  871.         }
  872.         $cmd = "gs -q -dNOPAUSE -dBATCH -sDEVICE=pdfwrite -sOutputFile=$pdfRelier ";
  873.         foreach ($tableauPdf as $file) {
  874.             $cmd .= $file." ";
  875.         }
  876.         //echo "<div>".$cmd."</div>";
  877.         $result = shell_exec($cmd);
  879.         return new JsonResponse(['target' => '_blank', 'url' => '/'.$pdfRelier, 'valide' => '1']);
  880.     }
  883.     /**
  884.      * @Route("/ordre-reparation/suivi-main-oeuvre", name="dtc_ordre_reparation_suivi_mo_liste")
  885.      */
  886.     public function suiviMainOeuvreAction(Request $request, EntityManagerInterface $em, ColonneTableauService $serviceColonneTableau, Datatable $datatable, TranslatorInterface $translator)
  887.     {
  888.         $repo_utilisateur   = $em->getRepository(Utilisateur::class);
  889.         $repo_interventions = $em->getRepository(Intervention::class);
  890.         $repo_commande      = $em->getRepository(Commande::class);
  892.         $mecanicien    = 0;
  893.         $mecanicienId  = 0;
  894.         $dateDebut     = new \DateTime('first day of');
  895.         $dateFin       = new \DateTime();
  896.         $dateFinPlusUn = new \DateTime();
  898.         if ($request->getMethod() == 'POST') {
  899.             $dateDebutRequest = $request->request->get('dateDebut');
  900.             $dateFinRequest   = $request->request->get('dateFin');
  901.             $mecanicien       = $request->request->get('mecanicien');
  903.             $dateDebut     = date_create_from_format('d/m/Y', $dateDebutRequest);
  904.             $dateFin       = date_create_from_format('d/m/Y', $dateFinRequest);
  905.             $dateFinPlusUn = date_create_from_format('d/m/Y', $dateFinRequest);
  907.             $dateDebut->setTime(00, 00, 00);
  908.             $dateFin->setTime(23, 59, 59);
  909.             $dateFinPlusUn->setTime(23, 59, 59);
  912.         }
  914.         $interval = new \DateInterval('P1D');
  915.         $dateFinPlusUn->add($interval);
  917.         $mecanos = $repo_utilisateur->findByType(4);
  918.         if ($mecanicien != 0 && $mecanicien != '') {
  919.             $mecanicien = $repo_utilisateur->find($mecanicien);
  920.             if (is_object($mecanicien)) {
  921.                 $nbMecanos    = 1;
  922.                 $mecanicienId = $mecanicien->getId();
  923.             }
  924.         } else {
  925.             $nbMecanos = count($mecanos);
  926.         }
  928.         //Nbre de jours ouvrables sur la période * 7h * nombre de mécanos
  929.         $nbHFacturables = $this->get_nb_open_days(strtotime($dateDebut->format('Y-m-d')), strtotime($dateFin->format('Y-m-d'))) * 7 * $nbMecanos;
  931.         //Nombre heures travaillees sur la période = somme des des durees interventions dont la date d'intervention est dans la période
  932.         $nbHPassees = max(0, $repo_interventions->getTotalTempsInterventionDsPeriode($dateDebut, $dateFin, $mecanicien));
  934.         //Nombre d'heures de mo sur les factures de la période
  935.         $nbHFacturees = max(0, $repo_commande->getTotalHeuresFactureesDsPeriode($dateDebut, $dateFin, $mecanicienId));
  937.         if (is_numeric($nbHFacturees) && $nbHPassees != 0) {
  938.             $taux = $nbHFacturees / $nbHPassees;
  939.         } else {
  940.             $taux = '';
  941.         }
  943.         $tableau_class_cellule = [];
  944.         //    $tableau_class_cellule[]=array("className"=>"visible_export colonne_id","targets"=>array(0),"visible"=>true,"orderable"=>false);
  945.         $tableau_class_cellule[] = [
  946.             "className" => "visible_export colonne_id",
  947.             "targets"   => [0],
  948.             // TODO CHANGE THIS
  949.             "visible"   => $serviceColonneTableau->getColonneUtilisateur("DTCGestionComercialeBundle:Suivi", "date"),
  950.         ];
  951.         $tableau_class_cellule[] = [
  952.             "className" => "visible_export colonne_id",
  953.             "targets"   => [1],
  954.             "visible"   => $serviceColonneTableau->getColonneUtilisateur("DTCGestionComercialeBundle:Suivi", "numero"),
  955.         ];
  956.         $tableau_class_cellule[] = [
  957.             "className" => "visible_export colonne_id",
  958.             "targets"   => [2],
  959.             "visible"   => $serviceColonneTableau->getColonneUtilisateur("DTCGestionComercialeBundle:Suivi", "nom"),
  960.         ];
  961.         $tableau_class_cellule[] = [
  962.             "className" => "visible_export colonne_id",
  963.             "targets"   => [3],
  964.             "visible"   => $serviceColonneTableau->getColonneUtilisateur("DTCGestionComercialeBundle:Suivi", "heure"),
  965.         ];
  966.         $tableau_class_cellule[] = [
  967.             "className" => "visible_export colonne_id",
  968.             "targets"   => [4],
  969.             "visible"   => $serviceColonneTableau->getColonneUtilisateur("DTCGestionComercialeBundle:Suivi", "heurefac"),
  970.         ];
  971.         $tableau_class_cellule[] = ["orderable" => false, "className" => "colonne_id", "targets" => [5], "visible" => true];
  972.         //$tableau_class_cellule[]=array("className"=>"colonne_id","targets"=>array(4),"visible"=>$serviceColonneTableau->getColonneUtilisateur(OrdreRep::class,"client"));
  973.         //$tableau_class_cellule[]=array("className"=>"colonne_id","targets"=>array(5),"visible"=>$serviceColonneTableau->getColonneUtilisateur(OrdreRep::class,"heuresPassees"));
  974.         //$tableau_class_cellule[]=array("className"=>"colonne_id","targets"=>array(6),"visible"=>$serviceColonneTableau->getColonneUtilisateur(OrdreRep::class,"heuresFacturees"));
  976.         $this->datatableSuiviMainOeuvre($datatable, $translator, $mecanicienId, $dateDebut->format('Y-m-d'), $dateFinPlusUn->format('Y-m-d'));
  978.         return $this->render('GestionComerciale/OrdreRep/lister-suivi-main-oeuvre.html.twig', [
  979.             'tableauClassColonne' => $tableau_class_cellule,
  980.             'nbHFacturables'      => $nbHFacturables,
  981.             'nbHPassees'          => $nbHPassees,
  982.             'nbHFacturees'        => $nbHFacturees,
  983.             'taux'                => $taux,
  984.             'dateDebut'           => $dateDebut,
  985.             'dateFin'             => $dateFin,
  986.             'dateFinPlusUn'       => $dateFinPlusUn,
  987.             'mecanos'             => $mecanos,
  988.             'mecanicien'          => $mecanicien,
  989.             'mecanicienId'        => $mecanicienId,
  991.         ]);
  992.     }
  994.     private function datatableSuiviMainOeuvre(Datatable $datatable, TranslatorInterface $translator, $mecanicien = null, $dateDebut = null, $dateFin = null)
  995.     {
  996.         $where      = "x.typeDocumentCommercial = :typeDocumentCommercial";
  997.         $parameters = ['typeDocumentCommercial' => TypeDocumentCommercial::ORDREREPARATION];
  999.         if ($dateDebut != null && $dateFin != null) {
  1000.             $where                   .= " and x.dateBon >= :dateDebut and x.dateBon < :dateFin";
  1001.             $parameters['dateDebut'] = $dateDebut;
  1002.             $parameters['dateFin']   = $dateFin;
  1003.         }
  1006.         $datatable->setDatatableId('dta-or')
  1007.                   ->setEntity(Commande::class, "x")
  1008.                   ->setFields(
  1009.                       [
  1010.                           //$translator->trans("ID") =>  'x.id',   
  1011.                           $translator->trans("Date OR")                 => 'x.dateBon',
  1012.                           $translator->trans("Numéro OR")               => 'x.reference',
  1013.                           $translator->trans("Nom client")              => 'c.id',
  1014.                           $translator->trans("Nombre heures passées")   => 'x.tempsPasse',
  1015.                           $translator->trans("Nombre heures facturées") => 'x.id',
  1016.                           $translator->trans("Actions")                 => 'x.id',
  1017.                           "_identifier_"                                => 'x.id',
  1018.                       ]
  1019.                   )
  1020.                   ->addJoin('x.client', 'c', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1022.             //->addJoin('vc.marque', 'ma', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)      
  1023.             //->addJoin('vc.modele', 'm', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)      
  1024.             /*->setWhere(                                                     
  1025.                     $type_jointure.' = :objet',
  1026.                     array('objet' => $objet)
  1027.                )
  1028.               */
  1029.         ;
  1031.         if ($mecanicien != null && $mecanicien != 0) {
  1032.             $where                    .= ' and m.id = :mecanicien';
  1033.             $parameters['mecanicien'] = $mecanicien;
  1034.             $datatable->addJoin('x.interventions', 'i', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1035.                       ->addJoin('i.mecanicien', 'm', \Doctrine\ORM\Query\Expr\Join::INNER_JOIN);
  1036.         }
  1038.         $datatable->setWhere($where, $parameters)
  1039.                   ->setRenderers(
  1040.                       [
  1041.                           0 => [
  1042.                               'view' => 'FO/DataTable/heure.html.twig',
  1043.                           ],
  1044.                           1 => [
  1045.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  1046.                               'params' => [
  1047.                                   'edit_route' => 'dtc_ordre_reparation_modifier',
  1048.                               ],
  1049.                           ],
  1050.                           2 => [
  1051.                               'view'   => 'FO/DataTable/prenom_nom.html.twig',
  1052.                               'params' => [
  1053.                                   'typeUtilisateur' => 'client',
  1054.                               ],
  1055.                           ],
  1056.                           3 => [
  1057.                               'view' => 'FO/DataTable/num2chiffres.html.twig',
  1058.                           ],
  1059.                           4 => [
  1060.                               'view' => 'FO/DataTable/heures_facturees.html.twig',
  1061.                           ],
  1063.                           5 => [
  1064.                               'view'   => 'FO/DataTable/actions_modal.html.twig',
  1065.                               'params' => [
  1066.                                   //'edit_route'  => 'dtc_ordre_reparation_modifier', 
  1067.                                   //'supprimer_route'  => 'dtc_ordre_reparation_supprimer', 
  1068.                                   'pdf_route' => 'dtc_ordre_reparation_pdf',
  1069.                                   'entite'    => 'ordreRep',
  1070.                                   'objet'     => Commande::class,
  1072.                               ],
  1073.                           ],
  1075.                       ]
  1076.                   )
  1077.                   ->setOrder("x.id", "desc")
  1078.                   ->setSearch(true)
  1079.                   ->setGroupBy('x.id')
  1080.                   ->setSearchFields([1, 2, 3, 4]);
  1082.         return $datatable;
  1083.     }
  1086.     /**
  1087.      * @Route("/ordre-reparation/suivi-main-oeuvre/grid", name="dtc_ordre_reparation_suivi_mo_liste_grid")
  1088.      */
  1089.     public function suiviMainOeuvreGridAction(Request $request, Datatable $datatable, TranslatorInterface $translator)
  1090.     {
  1091.         $mecanicien = $request->query->get('mecanicien');
  1092.         $dateDebut  = $request->query->get('dateDebut');
  1093.         $dateFin    = $request->query->get('dateFin');
  1095.         return $this->datatableSuiviMainOeuvre($datatable, $translator, $mecanicien, $dateDebut, $dateFin)->execute();
  1097.     }
  1099.     // Fonction permettant de compter le nombre de jours ouvrés entre deux dates
  1100.     public function get_nb_open_days($date_start, $date_stop)
  1101.     {
  1102.         $arr_bank_holidays = []; // Tableau des jours feriés
  1104.         // On boucle dans le cas où l'année de départ serait différente de l'année d'arrivée
  1105.         $diff_year = date('Y', $date_stop) - date('Y', $date_start);
  1106.         for ($i = 0; $i <= $diff_year; $i++) {
  1107.             $year = (int)date('Y', $date_start) + $i;
  1108.             // Liste des jours feriés
  1109.             $arr_bank_holidays[] = '1_1_'.$year; // Jour de l'an
  1110.             $arr_bank_holidays[] = '1_5_'.$year; // Fete du travail
  1111.             $arr_bank_holidays[] = '8_5_'.$year; // Victoire 1945
  1112.             $arr_bank_holidays[] = '14_7_'.$year; // Fete nationale
  1113.             $arr_bank_holidays[] = '15_8_'.$year; // Assomption
  1114.             $arr_bank_holidays[] = '1_11_'.$year; // Toussaint
  1115.             $arr_bank_holidays[] = '11_11_'.$year; // Armistice 1918
  1116.             $arr_bank_holidays[] = '25_12_'.$year; // Noel
  1118.             // Récupération de paques. Permet ensuite d'obtenir le jour de l'ascension et celui de la pentecote    
  1119.             $easter              = easter_date($year);
  1120.             $arr_bank_holidays[] = date('j_n_'.$year, $easter + 86400); // Paques
  1121.             $arr_bank_holidays[] = date('j_n_'.$year, $easter + (86400 * 39)); // Ascension
  1122.             $arr_bank_holidays[] = date('j_n_'.$year, $easter + (86400 * 50)); // Pentecote    
  1123.         }
  1124.         //print_r($arr_bank_holidays);
  1125.         $nb_days_open = 0;
  1126.         // Mettre <= si on souhaite prendre en compte le dernier jour dans le décompte    
  1127.         while ($date_start < $date_stop) {
  1128.             // Si le jour suivant n'est ni un dimanche (0) ou un samedi (6), ni un jour férié, on incrémente les jours ouvrés    
  1129.             if ( ! in_array(date('w', $date_start), [0, 6])
  1130.                  && ! in_array(date('j_n_'.date('Y', $date_start), $date_start), $arr_bank_holidays)) {
  1131.                 $nb_days_open++;
  1132.             }
  1133.             $date_start = mktime(date('H', $date_start), date('i', $date_start), date('s', $date_start), date('m', $date_start), date('d', $date_start) + 1, date('Y', $date_start));
  1134.         }
  1136.         return $nb_days_open;
  1137.     }
  1139. }