src/Controller/Vehicules/VehiculeClientController.php line 324

Open in your IDE?
  1. <?php
  3. namespace App\Controller\Vehicules;
  5. use App\Entity\Clients\Client;
  6. use App\Entity\FO\Societe;
  7. use App\Entity\GestionComerciale\Commande;
  8. use App\Entity\GestionComerciale\Facture;
  9. use App\Entity\GestionComerciale\OrdreRep;
  10. use App\Entity\Vehicules\Marque;
  11. use App\Entity\Vehicules\Modele;
  12. use App\Entity\Vehicules\VehiculeClient;
  13. use App\Form\Vehicules\SupprimerVehiculeClientType;
  14. use App\Form\Vehicules\VehiculeClientType;
  15. use App\Library\Datatable\Util\Datatable;
  16. use App\Model\GestionCommerciale\TypeDocumentCommercial;
  17. use App\Security\Voter\EntityVoter;
  18. use App\Service\FO\Logo;
  19. use App\Service\Utilisateur\ColonneTableauService;
  20. use App\Service\Vehicules\DocumentVehicule;
  21. use App\Service\Vehicules\ImageVehicule;
  22. use Doctrine\ORM\EntityManagerInterface;
  23. use Knp\Snappy\Pdf;
  24. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  25. use Symfony\Component\HttpFoundation\JsonResponse;
  26. use Symfony\Component\HttpFoundation\Request;
  27. use Symfony\Component\HttpFoundation\Response;
  28. use Symfony\Component\Routing\Annotation\Route;
  29. use Symfony\Component\Validator\Validator\ValidatorInterface;
  30. use Symfony\Contracts\Translation\TranslatorInterface;
  33. class VehiculeClientController extends AbstractController
  34. {
  36.     /**
  37.      * @Route("/vehicule/client/historique/pdf/{id}", name="dtc_vehicule_client_historique_pdf")
  38.      */
  39.     public function pdfHistoriqueAction(Request $request, VehiculeClient $vehiculeClient, $retour = true, EntityManagerInterface $em, Pdf $snappy)
  40.     {
  42.         $societe    = $em->getRepository(Societe::class)->find(1);
  43.         $date_Y     = date("Y");
  44.         $date_M     = date("m");
  45.         $date_D     = date("d");
  46.         $date       = $date_Y.'/'.$date_M.'/'.$date_D;
  47.         $chemin_pdf = 'PDF/VEHICULES/'.$date.'/V-'.$vehiculeClient->getId().'.pdf';
  49.         if (file_exists($chemin_pdf)) {
  50.             unlink($chemin_pdf);
  51.         }
  52.         //return $this->render('GestionComerciale/BonPreparation/template_pdf.html.twig',array('commande'  => $bonPreparation,'societe'  => $societe));
  53.         $footer = $this->renderView('FO/PDF/footer_pagination_pdf.html.twig', ['societe' => $societe]);
  54.         $header = $this->renderView('FO/PDF/header_vehicule_historique.html.twig', ['societe' => $societe, 'vehiculeClient' => $vehiculeClient]);
  55.         //$snappy->setOption('page-size', 'A4');
  56.         $snappy->setOption('header-html', $header);
  57.         $snappy->setOption('footer-html', $footer);
  58.         $snappy->setOption('orientation', "Landscape");
  59.         //$snappy->setOption('header-html',$footer);
  60.         $snappy->setOption('margin-bottom', "10");
  61.         //$snappy->setOption('margin-top',"5");
  62.         //$snappy->setOption('zoom', 1 );
  63.         //$snappy->setOption('dpi', 300 );
  65.         $ors = $em->getRepository(Commande::class)->getOrVehiculeClient($vehiculeClient);
  67.         $snappy->generateFromHtml(
  68.             $this->renderView(
  69.                 'Vehicules/VehiculeClient/historique_pdf.html.twig',
  70.                 [
  71.                     'vehiculeClient' => $vehiculeClient,
  72.                     'ors'            => $ors,
  73.                     'societe'        => $societe,
  74.                 ]
  75.             ),
  76.             $chemin_pdf
  77.         );
  79.         if ($retour == true) {
  80.             return $this->render('FO/PDF/conteneur_pdf.html.twig', ['chemin_pdf' => '/'.$chemin_pdf]);
  81.             //return new RedirectResponse("/".$chemin_pdf);
  82.         }
  84.     }
  87.     /**
  88.      * @Route("/vehicule/client/historique/{id}", name="dtc_vehicule_client_historique")
  89.      */
  90.     public function historiqueAction(Request $request, VehiculeClient $vehiculeClient)
  91.     {
  92.         $titre_modal = "Historique véhicule";
  93.         $errors      = "";
  94.         $rendu       = $this->renderView('Vehicules/VehiculeClient/historique.html.twig', ['vehiculeClient' => $vehiculeClient, 'type' => '', 'errors' => $errors]);
  96.         return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  97.     }
  100.     /**
  101.      * @Route("/vehicule/client/dupliquer/{id}", name="dtc_vehicule_client_dupliquer")
  102.      */
  103.     public function dupliquerAction(Request $request, VehiculeClient $vehiculeClient, EntityManagerInterface $em)
  104.     {
  105.         $vehiculeClient_duplique = clone $vehiculeClient;
  106.         $vehiculeClient_duplique->setLibelle("COPIE ".$vehiculeClient_duplique->getLibelle());
  107.         $em->persist($vehiculeClient_duplique);
  108.         $em->flush();
  109.         $this->addFlash(
  110.             'notice',
  111.             'Véhicule dupliqué avec succès !'
  112.         );
  114.         return $this->redirectToRoute('dtc_vehicule_client_liste');
  115.     }
  118.     /**
  119.      * @Route("/vehicule/client/nouveau", name="dtc_vehicule_client_ajouter")
  120.      */
  121.     public function ajouterAction(Request $request, EntityManagerInterface $em, ImageVehicule $imageService, DocumentVehicule $documentService, ValidatorInterface $validator)
  122.     {
  123.         $vehiculeClient = new VehiculeClient;
  124.         $user           = $this->getUser();
  125.         $vehiculeClient->setUtilisateur($user);
  126.         $form   = $this->createForm(VehiculeClientType::class, $vehiculeClient);
  127.         $errors = "";
  128.         $form->handleRequest($request);
  129.         if ($form->isSubmitted()) {
  130.             $tokenP = $request->request->get('tokenPicture');
  131.             $tokenD = $request->request->get('tokenDocument');
  132.             if ($form->isValid()) {
  133.                 $em->persist($vehiculeClient);
  134.                 $em->flush();
  137.                 $imageService->sauvegarder($vehiculeClient, 'images', $tokenP);
  139.                 $documentService->sauvegarder($vehiculeClient, 'documents', $tokenD);
  142.                 $this->addFlash(
  143.                     'notice',
  144.                     'Véhicule client ajouté avec succès !'
  145.                 );
  147.                 return $this->redirectToRoute('dtc_vehicule_client_liste');
  148.             } else {
  149.                 $errors = $validator->validate($vehiculeClient);
  150.             }
  151.         }
  153.         return $this->render('Vehicules/VehiculeClient/ajouter.html.twig', ['form' => $form->createView(), 'errors' => $errors]);
  154.     }
  156.     /**
  157.      * @Route("/vehicule/client/nouveau/{id}", name="dtc_vehicule_client_ajouter2")
  158.      */
  159.     public function ajouterAjaxAction(Request $request, $id, EntityManagerInterface $em, Logo $imageService, DocumentVehicule $documentService, ValidatorInterface $validator)
  160.     {
  161.         $vehiculeClient = new VehiculeClient;
  162.         $user           = $this->getUser();
  163.         $vehiculeClient->setUtilisateur($user);
  164.         $clients     = $request->get('id');
  165.         $redirection = $request->get('redirection');
  166.         $get         = $request->query->all();
  167.         if ($id != "") {
  168.             $repoclient = $em->getRepository(Client::class);
  169.             $client     = $repoclient->find($id);
  170.             $vehiculeClient->setClient($client);
  171.         }
  172.         $form        = $this->createForm(VehiculeClientType::class, $vehiculeClient);
  173.         $titre_modal = " Nouveau véhicule";
  174.         $errors      = "";
  175.         $form->handleRequest($request);
  176.         if ($form->isSubmitted()) {
  177.             $tokenP = $request->request->get('tokenPicture');
  178.             $tokenD = $request->request->get('tokenDocument');
  179.             if ($form->isValid()) {
  180.                 $em->persist($vehiculeClient);
  181.                 $em->flush();
  183.                 $imageService->sauvegarder($vehiculeClient, 'images', $tokenP);
  185.                 $documentService->sauvegarder($vehiculeClient, 'documents', $tokenD);
  187.                 if (array_key_exists('table', $get) && $get["table"] != "") {
  188.                     return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => '', 'type' => 'recharger_datatable', 'id_datatable' => $get["table"]]);
  189.                 } else {
  190.                     //$this->addFlash( 'notice','Véhicule client ajouté avec succès !');
  191.                     //$libelle = $vehiculeClient->getMarque()->getLibelle()." ".$vehiculeClient->getModele()->getLibelle()." ".$vehiculeClient->getNumSerie();
  192.                     $libelle = $vehiculeClient->getLibelle();
  194.                     return new JsonResponse(
  195.                         ['rendu' => '', 'valide' => '0', 'url' => "", 'type' => 'client', 'libelle' => $client->getNom(), 'id_client' => $client->getId()]
  196.                     );
  198.                 }
  199.             } else {
  201.                 $errors = $validator->validate($vehiculeClient);
  202.                 $rendu  = $this->renderView(
  203.                     'Vehicules/VehiculeClient/ajouterAjax.html.twig',
  204.                     ['form' => $form->createView(), 'errors' => $errors, 'client' => $id, 'vehiculeClient' => $vehiculeClient]
  205.                 );
  207.                 return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  208.             }
  209.         }
  211.         $rendu = $this->renderView('Vehicules/VehiculeClient/ajouterAjax.html.twig', ['form' => $form->createView(), 'errors' => $errors, 'client' => $id]);
  213.         return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  214.     }
  217.     /**
  218.      * @Route("/vehicule/client/modifier/{id}", name="dtc_vehicule_client_modifier")
  219.      */
  220.     public function modifierAction(Request            $request, VehiculeClient $vehiculeClient, EntityManagerInterface $em, ImageVehicule $imageService, DocumentVehicule $documentService,
  221.                                    ValidatorInterface $validator
  222.     ) {
  223.         $user = $this->getUser();
  224.         $vehiculeClient->setUtilisateur($user);
  225.         $clients     = $request->get('id');
  226.         $redirection = $request->get('redirection');
  227.         $get         = $request->query->all();
  228.         $id          = $vehiculeClient->getClient()->getId();
  229.         if ($id != "") {
  230.             $repoclient = $em->getRepository(Client::class);
  231.             $client     = $repoclient->find($id);
  232.             $vehiculeClient->setClient($client);
  233.         }
  234.         $form        = $this->createForm(VehiculeClientType::class, $vehiculeClient);
  235.         $titre_modal = " Modifier véhicule";
  236.         $errors      = "";
  237.         $form->handleRequest($request);
  238.         if ($form->isSubmitted()) {
  239.             $tokenP = $request->request->get('tokenPicture');
  240.             $tokenD = $request->request->get('tokenDocument');
  241.             if ($form->isValid()) {
  243.                 $em->persist($vehiculeClient);
  244.                 $em->flush();
  246.                 $imageService->sauvegarder($vehiculeClient, 'images', $tokenP);
  248.                 $documentService->sauvegarder($vehiculeClient, 'documents', $tokenD);
  250.                 if (array_key_exists('table', $get) && $get["table"] != "") {
  251.                     return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => '', 'type' => 'recharger_datatable', 'id_datatable' => $get["table"]]);
  252.                 } else {
  253.                     $this->addFlash('notice', 'Véhicule client ajouté avec succès !');
  255.                     return new JsonResponse(
  256.                         ['rendu' => '', 'valide' => '0', 'url' => "#", 'type' => 'client', 'libelle' => $client->getNom(), 'id_client' => $client->getId()]
  257.                     );
  259.                 }
  260.             } else {
  262.                 $errors = $validator->validate($vehiculeClient);
  263.                 $rendu  = $this->renderView(
  264.                     'Vehicules/VehiculeClient/ajouterAjax.html.twig',
  265.                     ['vehiculeClient' => $vehiculeClient, 'form' => $form->createView(), 'errors' => $errors, 'client' => $id]
  266.                 );
  268.                 return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  269.             }
  270.         }
  272.         $rendu = $this->renderView(
  273.             'Vehicules/VehiculeClient/ajouterAjax.html.twig',
  274.             ['vehiculeClient' => $vehiculeClient, 'form' => $form->createView(), 'errors' => $errors, 'client' => $id]
  275.         );
  277.         return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  278.     }
  281.     /**
  282.      * @Route("", name="")
  283.      */
  284.     public function ____modifierAction(Request          $request, VehiculeClient $vehiculeClient, EntityManagerInterface $em, ImageVehicule $imageService,
  285.                                        DocumentVehicule $documentService, TranslatorInterface $translator, ValidatorInterface $validator
  286.     ) {
  287.         $user = $this->getUser();
  288.         $vehiculeClient->setUtilisateur($user);
  289.         $form   = $this->createForm(VehiculeClientType::class, $vehiculeClient);
  290.         $errors = "";
  291.         $form->handleRequest($request);
  292.         if ($form->isSubmitted()) {
  293.             $droit = $this->isGranted(EntityVoter::UPDATE, VehiculeClient::class);
  295.             if ( ! $droit) {
  296.                 return $this->redirectToRoute('dtc_vehicule_client_modifier', ["id" => $vehiculeClient->getId()]);
  297.             }
  298.             if ($form->isValid()) {
  300.                 $imageService->sauvegarder($vehiculeClient, 'images');
  302.                 $documentService->sauvegarder($vehiculeClient, 'documents');
  304.                 $em->persist($vehiculeClient);
  305.                 $em->flush();
  307.                 $this->addFlash(
  308.                     'notice',
  309.                     'Véhicule client sauvegardé avec succès !'
  310.                 );
  312.                 return $this->redirectToRoute('dtc_vehicule_client_modifier', ["id" => $vehiculeClient->getId()]);
  313.             } else {
  314.                 $errors = $validator->validate($vehiculeClient);
  315.             }
  316.         }
  318.         return $this->render('Vehicules/VehiculeClient/ajouter.html.twig', ['form' => $form->createView(), 'errors' => $errors, 'vehiculeClient' => $vehiculeClient]);
  319.     }
  321.     /**
  322.      * @Route("", name="")
  323.      */
  324.     public function listerFactureAction(Request $request, VehiculeClient $vehiculesClient, $type = "", ColonneTableauService $serviceColonneTableau, Datatable $datatable)
  325.     {
  327.         $tableau_class_cellule[] = ["className" => "colonne_id", "targets" => [0], "visible" => false, "orderable" => false];
  328.         $tableau_class_cellule[] = [
  329.             "className" => "visible_export colonne_id",
  330.             "targets"   => [1],
  331.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(Facture::class, "vehicule_client__date"),
  332.         ];
  333.         $tableau_class_cellule[] = [
  334.             "className" => "visible_export colonne_id",
  335.             "targets"   => [2],
  336.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(Facture::class, "vehicule_client__reference"),
  337.         ];
  338.         $tableau_class_cellule[] = [
  339.             "className" => "visible_export colonne_id",
  340.             "targets"   => [3],
  341.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(Facture::class, "vehicule_client__ordre_reparation"),
  342.         ];
  343.         $tableau_class_cellule[] = [
  344.             "className" => "visible_export colonne_id",
  345.             "targets"   => [4],
  346.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(Facture::class, "vehicule_client__total_ht"),
  347.         ];
  349.         $tableau_class_cellule[] = ["orderable" => false, "className" => "colonne_id", "targets" => [5], "visible" => true];
  350.         $this->datatableFactures($datatable, $vehiculesClient);
  352.         return $this->render('GestionComerciale/Facture/listerVehicule.html.twig', ["vehiculesClientId" => $vehiculesClient->getId(), 'tableauClassColonne' => $tableau_class_cellule]);
  354.     }
  356.     private function datatableFactures(Datatable $datatable, $vehiculesClient)
  357.     {
  359.         $datatable->setDatatableId('dta-facture-vehicule')
  360.                   ->setEntity(Commande::class, "x")
  361.                   ->setFields(
  362.                       [
  363.                           "ID"           => 'x.id',
  364.                           "Date"         => 'x.date',
  365.                           "Réf"          => 'x.reference',
  366.                           //"Type" => 't.libelle',
  367.                           "OR"           => "c.reference",
  368.                           "Total HT"     => 'x.total',
  369.                           "Actions"      => 'x.id',
  370.                           "_identifier_" => 'x.id',
  371.                       ]
  372.                   )
  373.                   ->addJoin('x.statutCommande', 's', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  374.                   //->addJoin('x.typeDocumentCommercial', 't', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  375.                   ->addJoin('x.vehiculesClient', 'v', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  376.                   ->addJoin('x.commande', 'c', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  377.                   ->setRenderers(
  378.                       [
  379.                           1 => [
  380.                               'view'   => 'FO/DataTable/heure.html.twig',
  381.                               'params' => [],
  382.                           ],
  383.                           2 => [
  384.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  385.                               'params' => [
  386.                                   'edit_route'   => 'auto',
  387.                                   'typeDocument' => "",
  388.                               ],
  389.                           ],
  390.                           3 => [
  391.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  392.                               'params' => [
  393.                                   'edit_route'   => 'dtc_ordre_reparation_modifier',
  394.                                   'typeDocument' => "commande",
  395.                               ],
  396.                           ],
  397.                           4 => [
  398.                               'view' => 'FO/DataTable/prix.html.twig',
  400.                           ],
  401.                           5 => [
  402.                               'view'   => 'FO/DataTable/actions.html.twig',
  403.                               'params' => [
  405.                                   'edit_route' => 'auto',
  406.                                   'pdf_route'  => 'auto',
  407.                                   'objet'      => Commande::class,
  408.                                   'deplier'    => 'true',
  411.                               ],
  412.                           ],
  414.                       ]
  415.                   )
  416.                   ->setOrder("x.id", "desc")
  417.                   ->setSearch(true)
  418.                   ->setSearchFields([1, 2, 3]);
  421.         /*
  422.             13     Ordre de fabrication multiple
  423.             12     Facture fournisseur
  424.             11     Bon de préparation atelier
  425.             10     Devis OR
  426.             9     Ordre de fabrication
  427.             8     Commande fournisseur
  428.             7     Avoir
  429.             6     Facture
  430.             5     Bon de livraison
  431.             4     Bon de préparation
  432.             3     Ordre de réparation
  433.             2     Commande
  434.             1     Devis
  435.         */
  437.         $typeDoc    = ["6"];
  438.         $where      = "    v.id = :vehiculesClient
  439.                     AND
  440.                     x.dateSuppression IS NULL
  441.                     AND
  442.                     s.ordre != :ordreStatutDoc
  443.                     AND x.typeDocumentCommercial IN (:typeDocumentCommercial)
  444.                 ";
  445.         $parameters = ['vehiculesClient' => $vehiculesClient, "typeDocumentCommercial" => $typeDoc, 'ordreStatutDoc' => '0'];
  447.         $datatable->setWhere($where, $parameters);
  449.         return $datatable;
  450.     }
  452.     /**
  453.      * @Route("/vehicule/client/supprimer/multiple", name="dtc_vehicule_liste_client_supprimer")
  454.      */
  455.     public function supprimerMultipleAction(Request $request, EntityManagerInterface $em)
  456.     {
  458.         $url = $this->generateUrl('dtc_vehicule_client_liste', []);
  460.         return new JsonResponse(['url' => $url, 'valide' => '1']);
  462.         $data = $request->get('dataTables');
  463.         $ids  = $data['actions'];
  465.         $repo = $em->getRepository(VehiculeClient::class);
  467.         for ($i = 0; $i < count($ids); $i++) {
  468.             $v = $repo->find($ids[$i]);
  469.             if (is_object($v)) {
  470.                 $em->remove($v);
  471.             }
  472.         }
  473.         $em->flush();
  474.         $this->addFlash(
  475.             'notice',
  476.             'Véhicules client supprimé avec succès !'
  477.         );
  478.         $url = $this->generateUrl('dtc_vehicule_client_liste', []);
  480.         return new JsonResponse(['url' => $url, 'valide' => '1']);
  481.     }
  483.     /**
  484.      * @Route("/vehicule/client/supprimer/{id}", name="dtc_vehicule_client_supprimer")
  485.      */
  486.     public function supprimerAction(Request $request, VehiculeClient $vehiculeClient, EntityManagerInterface $em, ValidatorInterface $validator)
  487.     {
  489.         $titre_modal = "Demande de confirmation";
  490.         $user        = $this->getUser();
  493.         $repo_commande            = $em->getRepository(Commande::class);
  494.         $vehicule_commande_existe = $repo_commande->findOneBy(["vehiculesClient" => $vehiculeClient]);
  495.         $erreur                   = "";
  496.         //Verifier si un client a une civilité
  497.         if (is_object($vehicule_commande_existe)) {
  498.             $erreur .= 'Le véhicule n\'est pas supprimable car il est relié à une ou plusieurs commandes.';
  499.         }
  502.         if ($erreur != "") {
  503.             $rendu = $this->renderView('FO/Supprimer/supprimer_impossible.html.twig', ['errors' => $erreur]);
  505.             return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  506.         }
  509.         $form   = $this->createForm(SupprimerVehiculeClientType::class, $vehiculeClient);
  510.         $errors = "";
  511.         $form->handleRequest($request);
  512.         $get = $request->query->all();
  513.         if ($form->isSubmitted()) {
  515.             if ($form->isValid()) {
  516.                 $em->remove($vehiculeClient);
  517.                 $em->flush();
  520.                 if (array_key_exists('table', $get) && $get["table"] != "") {
  521.                     return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => '', 'type' => 'recharger_datatable', 'id_datatable' => $get["table"]]);
  522.                 } else {
  523.                     $this->addFlash('notice', 'Véhicule supprimé avec succès !');
  524.                     $url = $this->generateUrl('dtc_vehicule_client_liste', []);
  526.                     return new JsonResponse(['rendu' => '', 'valide' => '1', 'url' => $url]);
  528.                 }
  529.             } else {
  530.                 $errors = $validator->validate($vehiculeClient);
  531.                 $rendu  = $this->renderView('FO/Supprimer/supprimer.html.twig', ['form' => $form->createView(), 'errors' => $errors, 'id' => $vehiculeClient->getId(), 'type' => '']);
  533.                 return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  534.             }
  535.         }
  536.         $rendu = $this->renderView('FO/Supprimer/supprimer.html.twig', ['form' => $form->createView(), 'id' => $vehiculeClient->getId(), 'type' => '', 'errors' => $errors]);
  538.         return new JsonResponse(['rendu' => $rendu, 'valide' => '0', 'url' => '', 'titre' => $titre_modal]);
  539.     }
  542.     /**
  543.      * @Route("/vehicule/client", name="dtc_vehicule_client_liste")
  544.      */
  545.     public function listerAction(Request $request, $client, $id, EntityManagerInterface $em, ColonneTableauService $serviceColonneTableau, Datatable $datatable)
  546.     {
  547.         $tableau_class_cellule[] = ["className" => "colonne_id", "targets" => [0], "visible" => true, "orderable" => false];
  548.         $tableau_class_cellule[] = [
  549.             "className" => "visible_export colonne_id",
  550.             "targets"   => [1],
  551.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(VehiculeClient::class, "id"),
  552.         ];
  553.         $tableau_class_cellule[] = [
  554.             "className" => "visible_export colonne_id",
  555.             "targets"   => [2],
  556.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(VehiculeClient::class, "image"),
  557.         ];
  558.         $tableau_class_cellule[] = [
  559.             "className" => "visible_export colonne_id",
  560.             "targets"   => [3],
  561.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(VehiculeClient::class, "libelle"),
  562.         ];
  564.         $tableau_class_cellule[] = [
  565.             "className" => "visible_export colonne_id",
  566.             "targets"   => [4],
  567.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(VehiculeClient::class, "marque"),
  568.         ];
  569.         $tableau_class_cellule[] = [
  570.             "className" => "visible_export colonne_id",
  571.             "targets"   => [5],
  572.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(VehiculeClient::class, "modele"),
  573.         ];
  574.         $tableau_class_cellule[] = [
  575.             "className" => "visible_export colonne_id",
  576.             "targets"   => [6],
  577.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(VehiculeClient::class, "type"),
  578.         ];
  579.         $tableau_class_cellule[] = [
  580.             "className" => "visible_export colonne_id",
  581.             "targets"   => [7],
  582.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(VehiculeClient::class, "client"),
  583.         ];
  584.         $tableau_class_cellule[] = [
  585.             "className" => "visible_export colonne_id",
  586.             "targets"   => [8],
  587.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(VehiculeClient::class, "kilometrage"),
  588.         ];
  589.         $tableau_class_cellule[] = [
  590.             "className" => "visible_export colonne_id",
  591.             "targets"   => [9],
  592.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(VehiculeClient::class, "puissance"),
  593.         ];
  596.         $tableau_class_cellule[] = [
  597.             "className" => "visible_export colonne_id",
  598.             "targets"   => [10],
  599.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(VehiculeClient::class, "immatriculation"),
  600.         ];
  601.         $tableau_class_cellule[] = [
  602.             "className" => "visible_export colonne_id",
  603.             "targets"   => [11],
  604.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(VehiculeClient::class, "numSerie"),
  605.         ];
  606.         $tableau_class_cellule[] = [
  607.             "className" => "visible_export colonne_id",
  608.             "targets"   => [12],
  609.             "visible"   => $serviceColonneTableau->getColonneUtilisateur(VehiculeClient::class, "dateControleTechnique"),
  610.         ];
  611.         $tableau_class_cellule[] = ["orderable" => false, "className" => "colonne_id", "targets" => [13], "visible" => true];
  614.         $modele      = [];
  615.         $repo_marque = $em->getRepository(Marque::class);
  616.         $marque      = $repo_marque->findBy([], ["libelle" => "ASC"]);
  618.         $param = $request->query->all();
  620.         if (array_key_exists('marque', $param) and $param["marque"] > 0) {
  621.             $parent = $repo_marque->find($param["marque"]);
  622.             if (is_object($parent)) {
  623.                 $repo_modele = $em->getRepository(Modele::class);
  624.                 $modele      = $repo_modele->findBy(["marque" => $parent], ["libelle" => "ASC"]);
  625.             }
  627.         }
  628.         $this->datatable($request, $datatable, $client, $id);
  629.         $parametres = [];
  630.         //$parametres["parametres"] = $param;
  632.         if (is_object($client)) {
  633.             return $this->render('Vehicules/VehiculeClient/lister-client.html.twig', [
  634.                 'client'              => $client,
  635.                 'parametres'          => $param,
  636.                 "marque"              => $marque,
  637.                 "modele"              => $modele,
  638.                 'tableauClassColonne' => $tableau_class_cellule,
  639.             ]);
  640.         } else {
  641.             return $this->render('Vehicules/VehiculeClient/lister.html.twig', [
  642.                 'parametres'          => $param,
  643.                 "marque"              => $marque,
  644.                 "modele"              => $modele,
  645.                 'tableauClassColonne' => $tableau_class_cellule,
  646.             ]);
  647.         }
  650.     }
  652.     /**
  653.      * set datatable configs
  654.      *
  655.      * @return \App\Library\Datatable\Util\Datatable
  656.      */
  657.     private function datatable(Request $request, Datatable $datatable, $client = null)
  658.     {
  660.         $param = $request->query->all();
  661.         $datatable->setDatatableId('dta-vehicules')
  662.                   ->setEntity(VehiculeClient::class, "x")
  663.                   ->setFields(
  664.                       [
  665.                           "ID"           => 'x.id',
  666.                           "Img"          => 'x.id',
  667.                           "Libellé"      => 'x.libelle',
  668.                           "Marque"       => 'm.libelle',
  669.                           "Modèle"       => 'mod.libelle',
  670.                           "Type"         => 't.libelle',
  671.                           "Clt"          => 'c.nom',
  672.                           "Km"           => 'x.kilometrage',
  673.                           "Puissance"    => 'x.puissance',
  674.                           "Immat"        => 'x.immatriculation',
  675.                           "Num série"    => 'x.numSerie',
  676.                           "Date CT"      => 'x.dateControleTechnique',
  677.                           "Actions"      => 'x.id',
  678.                           "_identifier_" => 'x.id',
  679.                       ]
  680.                   )
  681.                   ->addJoin('x.marque', 'm', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  682.                   ->addJoin('x.modele', 'mod', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  683.                   ->addJoin('x.type', 't', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  684.                   ->addJoin('x.client', 'c', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  685.                   ->setRenderers(
  686.                       [
  687.                           0  => [
  688.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  689.                               'params' => [
  690.                                   'edit_route' => 'dtc_vehicule_client_modifier',
  691.                               ],
  693.                           ],
  694.                           1  => [
  695.                               'view'   => 'FO/DataTable/image.html.twig',
  696.                               'params' => [
  697.                                   'edit_route' => 'dtc_vehicule_client_modifier',
  698.                               ],
  700.                           ],
  701.                           2  => [
  702.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  703.                               'params' => [
  704.                                   'edit_route' => 'dtc_vehicule_client_modifier',
  705.                               ],
  707.                           ],
  708.                           3  => [
  709.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  710.                               'params' => [
  711.                                   'edit_route'   => 'dtc_vehicule_marque_modifier',
  712.                                   'typeDocument' => 'marqueVehicule',
  713.                               ],
  714.                           ],
  715.                           4  => [
  716.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  717.                               'params' => [
  718.                                   'edit_route'   => 'dtc_vehicule_modele_modifier',
  719.                                   'typeDocument' => 'modeleVehicule',
  720.                               ],
  721.                           ],
  722.                           5  => [
  723.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  724.                               'params' => [
  725.                                   'edit_route'   => 'dtc_vehicule_type_modifier',
  726.                                   'typeDocument' => 'typeVehicule',
  727.                               ],
  728.                           ],
  729.                           6  => [
  730.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  731.                               'params' => [
  732.                                   'edit_route'   => 'dtc_client_modifier',
  733.                                   'typeDocument' => 'client',
  734.                               ],
  735.                           ],
  736.                           11 => [
  737.                               'view' => 'FO/DataTable/date.html.twig',
  740.                           ],
  741.                           12 => [
  742.                               'view'   => 'FO/DataTable/actions_modal.html.twig',
  743.                               'params' => [
  744.                                   'pdf_route'       => 'dtc_vehicule_client_historique_pdf',
  745.                                   'edit_route'      => 'dtc_vehicule_client_modifier',
  746.                                   'type'            => '',
  747.                                   //'dupliquer_route'    => 'dtc_vehicule_client_dupliquer',
  748.                                   'supprimer_route' => 'dtc_vehicule_client_supprimer',
  749.                                   'objet'           => VehiculeClient::class,
  750.                                   'table'           => 'dta-vehicules',
  751.                               ],
  752.                           ],
  755.                           /*3=> array(
  756.       'view' => 'FO/DataTable/edit_texte.html.twig',
  757.       'params' => array(
  758.               'objet'    => 'DTCVehiculesBundle:VehiculeClient',
  759.               'champ'    => 'setImmatriculation',
  760.           ),
  762. ),
  763. 4=> array(
  764.       'view' => 'FO/DataTable/edit_texte.html.twig',
  765.       'params' => array(
  766.               'objet'    => 'DTCVehiculesBundle:VehiculeClient',
  767.               'champ'    => 'setNumSerie',
  768.           ),
  770. ),
  771. */
  773.                       ]
  774.                   )
  775.                   ->setMultiple(
  776.                       [
  777.                           'delete' => [
  778.                               'title' => 'Non disponible',
  779.                               'route' => 'dtc_vehicule_liste_client_supprimer' // path to multiple delete route action
  780.                           ],
  781.                       ]
  782.                   )
  783.                   ->setOrder("x.id", "desc")
  784.                   ->setSearch(true)
  785.                   ->setSearchFields([2, 3, 4, 5, 6]);
  786.         $where      = "";
  787.         $parameters = [];
  789.         if (is_object($client)) {
  790.             $where                .= "c.id = :client";
  791.             $parameters["client"] = $client->getId();
  792.         }
  794.         if (array_key_exists('parametres', $param)) {
  795.             if (array_key_exists('client', $param["parametres"]) and $param["parametres"]["client"] > 0) {
  796.                 //$datatable->addJoin('x.client', 'client', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN);
  797.                 $parameters["client"] = $param["parametres"]["client"];
  798.                 if ($where != "") {
  799.                     $where .= " AND ";
  800.                 }
  801.                 $where .= "c.id = :client";
  802.             }
  803.             if (array_key_exists('marque', $param["parametres"]) and $param["parametres"]["marque"] > 0) {
  804.                 //echo "AZERTYUI";
  805.                 //$datatable->addJoin('x.clientCategorie', 'cc', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN);
  806.                 //$datatable->addJoin('cc.categorie', 'catC', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN);
  807.                 $parameters["marque"] = $param["parametres"]["marque"];
  808.                 if ($where != "") {
  809.                     $where .= " AND ";
  810.                 }
  811.                 $where .= "x.marque = :marque";
  813.                 if (array_key_exists('modele', $param["parametres"]) and $param["parametres"]["modele"] > 0) {
  814.                     $parameters["modele"] = $param["parametres"]["modele"];
  815.                     $where                .= " AND x.modele = :modele";
  816.                 }
  818.             }
  820.         }
  821.         //echo $where;
  822.         if ($where != '') {
  823.             //echo $where;
  824.             $datatable->setWhere($where, $parameters);
  825.         }
  827.         return $datatable;
  828.     }
  830.     /**
  831.      * Grid action
  832.      * @return Response
  833.      */
  834.     /**
  835.      * @Route("/vehicule/client/grid/{id}", name="dtc_vehicule_client_liste_grid")
  836.      */
  837.     public function gridAction(Request $request, Client $client, Datatable $datatable)
  838.     {
  839.         return $this->datatable($request, $datatable, $client)->execute();
  840.     }
  843.     /**
  844.      * @Route("/vehicule/client/or", name="dtc_vehicule_client_liste_or")
  845.      */
  846.     public function listerOrdreRepAction(Request $request, VehiculeClient $vehiculesClient, $type = "", ColonneTableauService $serviceColonneTableau, Datatable $datatable)
  847.     {
  849.         $visible_col_1  = $serviceColonneTableau->getColonneUtilisateur(OrdreRep::class, "id");
  850.         $visible_col_2  = $serviceColonneTableau->getColonneUtilisateur(OrdreRep::class, "reference");
  851.         $visible_col_3  = $serviceColonneTableau->getColonneUtilisateur(OrdreRep::class, "date");
  852.         $visible_col_4  = $serviceColonneTableau->getColonneUtilisateur(OrdreRep::class, "statutCommande");
  853.         $visible_col_5  = $serviceColonneTableau->getColonneUtilisateur(OrdreRep::class, "refclient");
  854.         $visible_col_6  = $serviceColonneTableau->getColonneUtilisateur(OrdreRep::class, "client");
  855.         $visible_col_7  = $serviceColonneTableau->getColonneUtilisateur(OrdreRep::class, "rdv");
  856.         $visible_col_8  = $serviceColonneTableau->getColonneUtilisateur(OrdreRep::class, "equipier");
  857.         $visible_col_9  = $serviceColonneTableau->getColonneUtilisateur(OrdreRep::class, "immat");
  858.         $visible_col_10 = $serviceColonneTableau->getColonneUtilisateur(OrdreRep::class, "marque");
  859.         $visible_col_11 = $serviceColonneTableau->getColonneUtilisateur(OrdreRep::class, "modele");
  860.         $visible_col_12 = $serviceColonneTableau->getColonneUtilisateur(OrdreRep::class, "km");
  861.         $visible_col_13 = $serviceColonneTableau->getColonneUtilisateur(OrdreRep::class, "serie");
  862.         $visible_col_14 = $serviceColonneTableau->getColonneUtilisateur(OrdreRep::class, "commentaire");
  863.         $visible_col_15 = $serviceColonneTableau->getColonneUtilisateur(OrdreRep::class, "refCli");
  865.         if ($type == "modal") {
  866.             $visible_col_1  = false;
  867.             $visible_col_4  = false;
  868.             $visible_col_5  = false;
  869.             $visible_col_8  = true;
  870.             $visible_col_9  = false;
  871.             $visible_col_10 = false;
  872.             $visible_col_11 = false;
  873.             $visible_col_12 = true;
  874.             $visible_col_15 = false;
  875.         }
  878.         $tableau_class_cellule[] = ["className" => "colonne_id", "targets" => [0], "visible" => false, "orderable" => false];
  879.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [1], "visible" => $visible_col_1];
  880.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [2], "visible" => $visible_col_2];
  881.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [3], "visible" => $visible_col_3];
  882.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [4], "visible" => $visible_col_4];
  883.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [5], "visible" => $visible_col_5];
  884.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [6], "visible" => $visible_col_6];
  885.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [7], "visible" => $visible_col_7];
  886.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [8], "visible" => $visible_col_8];
  887.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [9], "visible" => $visible_col_9];
  888.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [10], "visible" => $visible_col_10];
  889.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [11], "visible" => $visible_col_11];
  890.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [12], "visible" => $visible_col_12];
  891.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [13], "visible" => $visible_col_13];
  892.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [14], "visible" => $visible_col_14];
  893.         $tableau_class_cellule[] = ["className" => "visible_export colonne_id", "targets" => [15], "visible" => $visible_col_15];
  894.         $tableau_class_cellule[] = ["orderable" => false, "className" => "colonne_id", "targets" => [16], "visible" => true];
  895.         $this->datatableOrdreRep( $datatable,$vehiculesClient);
  897.         return $this->render('GestionComerciale/OrdreRep/listerVehicule.html.twig', ["vehiculesClientId" => $vehiculesClient->getId(), 'tableauClassColonne' => $tableau_class_cellule]);
  900.     }
  903.     /**
  904.      * set datatable configs
  905.      *
  906.      * @return \App\Library\Datatable\Util\Datatable
  907.      */
  908.     private function datatableOrdreRep(Datatable $datatable, $vehiculesClient)
  909.     {
  911.         $datatable
  912.             ->setDatatableId('dta-or-vehicule')
  913.             ->setEntity(Commande::class, "x")
  914.             ->setFields(
  915.                 [
  916.                     "ID"           => 'x.id',
  917.                     "Réf"          => 'x.reference',
  918.                     "Date"         => 'x.date',
  919.                     "Statut"       => 'sc.id',
  920.                     "Réf client"   => 'c.reference',
  921.                     "Client"       => 'c.nom',
  922.                     "RDV "         => 'x.dateBon',
  923.                     "Équipier"     => 'u.reference',
  924.                     "Immat"        => 'v.immatriculation',
  925.                     "Marque"       => 'm.libelle',
  926.                     "Modèle"       => 'mo.libelle',
  927.                     "Km"           => 'x.kilometrage',
  928.                     "Num serie"    => 'v.numSerie',
  929.                     "Comm"         => 'x.commentaire',
  930.                     "Réf cmde cli" => 'x.referenceClient',
  931.                     "Actions"      => 'x.id',
  932.                     "_identifier_" => 'x.id',
  933.                 ]
  934.             )
  935.             ->addJoin('x.vehiculesClient', 'v', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  936.             ->addJoin('v.marque', 'm', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  937.             ->addJoin('x.statutCommande', 'sc', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  938.             ->addJoin('v.modele', 'mo', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  939.             ->addJoin('x.etatCommande', 'ec', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  940.             ->addJoin('x.client', 'c', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  941.             ->addJoin('x.utilisateur', 'u', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  942.             ->setWhere(
  943.                 'x.typeDocumentCommercial = :typeDocumentCommercial AND x.vehiculesClient = :vehiculesClient  ',
  944.                 ['vehiculesClient' => $vehiculesClient, 'typeDocumentCommercial' => TypeDocumentCommercial::COMMANDE]
  945.             )
  946.             ->setRenderers(
  947.                 [
  948.                     0 => [
  949.                         'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  950.                         'params' => [
  951.                             'edit_route' => 'dtc_ordre_reparation_modifier',
  952.                         ],
  954.                     ],
  955.                     1 => [
  956.                         'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  957.                         'params' => [
  958.                             'edit_route' => 'dtc_ordre_reparation_modifier',
  959.                         ],
  961.                     ],
  962.                     2 => [
  963.                         'view' => 'FO/DataTable/heure.html.twig',
  965.                     ],
  966.                     3 => [
  967.                         'view' => 'FO/DataTable/statut-commande-fournisseur.html.twig',
  969.                     ],
  970.                     4 => [
  971.                         'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  972.                         'params' => [
  973.                             'edit_route'   => 'dtc_client_modifier',
  974.                             'typeDocument' => 'client',
  975.                         ],
  976.                     ],
  978.                     5  => [
  979.                         'view'   => 'FO/DataTable/client.html.twig',
  980.                         'params' => [],
  981.                     ],
  982.                     6  => [
  983.                         'view' => 'FO/DataTable/heure.html.twig',
  985.                     ],
  986.                     7  => [
  987.                         'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  988.                         'params' => [
  989.                             'edit_route'   => 'dtc_utilisateur_modifier',
  990.                             'typeDocument' => 'equipier',
  991.                         ],
  992.                     ],
  993.                     9  => [
  994.                         'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  995.                         'params' => [
  996.                             'edit_route'   => 'dtc_vehicule_marque_modifier',
  997.                             'typeDocument' => 'marqueVehiculeOr',
  998.                         ],
  999.                     ],
  1000.                     10 => [
  1001.                         'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  1002.                         'params' => [
  1003.                             'edit_route'   => 'dtc_vehicule_modele_modifier',
  1004.                             'typeDocument' => 'modeleVehiculeOr',
  1005.                         ],
  1006.                     ],
  1007.                     13 => [
  1008.                         'view' => 'FO/DataTable/commentaire.html.twig',
  1010.                     ],
  1011.                     15 => [
  1012.                         'view'   => 'FO/DataTable/actions.html.twig',
  1013.                         'params' => [
  1014.                             'edit_route' => 'dtc_commande_modifier',
  1015.                             //'supprimer_route'    => 'dtc_commande_supprimer',
  1016.                             'objet'      => Commande::class,
  1017.                             'deplier'    => true,
  1018.                         ],
  1019.                     ],
  1021.                 ]
  1022.             )
  1023.             ->setMultiple(
  1024.                 [
  1025.                     'delete' => [
  1026.                         'title' => 'Non disponible',
  1027.                         'route' => 'dtc_commande_liste_supprimer',
  1028.                     ],
  1029.                 ]
  1030.             )
  1031.             ->setOrder("x.date", "desc")
  1032.             //->setOrder("ec.ordre", "desc")
  1033.             ->setSearch(true)
  1034.             ->setSearchFields([1, 3, 4, 5, 9, 10]);
  1036.         //$datatable->setSearchFields(array(0,2));
  1037.         return $datatable;
  1038.     }
  1040.     /**
  1041.      * set datatable configs
  1042.      *
  1043.      * @return \App\Library\Datatable\Util\Datatable
  1044.      */
  1045.     private function __datatableOrdreRep(Datatable $datatable,$vehiculesClient)
  1046.     {
  1048.         $datatable->setEntity(Commande::class, "x")
  1049.                   ->setFields(
  1050.                       [
  1051.                           "ID"           => 'x.id',
  1052.                           "Réf"          => 'x.reference',
  1053.                           "Date"         => 'x.date',
  1054.                           "Type"         => 'x.id',
  1055.                           "Réf client"   => 'c.reference',
  1056.                           "Client"       => 'c.nom',
  1057.                           "RDV"          => 'x.dateBon',
  1058.                           "Équipier"     => 'u.reference',
  1059.                           "Num serie"    => 'v.numSerie',
  1060.                           "Comm"         => 'x.commentaire',
  1061.                           "Réf cmde cli" => 'x.referenceClient',
  1062.                           "Actions"      => 'x.id',
  1063.                           "_identifier_" => 'x.id',
  1064.                       ]
  1065.                   )
  1066.                   ->addJoin('x.vehiculesClient', 'v', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1067.                   ->addJoin('v.marque', 'm', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1068.                   ->addJoin('v.modele', 'mo', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1069.                   ->addJoin('x.etatCommande', 'ec', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1070.                   ->addJoin('x.client', 'c', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1071.                   ->addJoin('x.utilisateur', 'u', \Doctrine\ORM\Query\Expr\Join::LEFT_JOIN)
  1072.                   ->setWhere(
  1073.                       'x.typeDocumentCommercial = :typeDocumentCommercial AND x.vehiculesClient = :vehiculesClient  ',
  1074.                       ['vehiculesClient' => $vehiculesClient, 'typeDocumentCommercial' => TypeDocumentCommercial::ORDREREPARATION]
  1075.                   )
  1076.                   ->setRenderers(
  1077.                       [
  1078.                           0  => [
  1079.                               'view'   => 'FO/DataTable/avec_lien_edit_route.html.twig',
  1080.                               'params' => [
  1081.                                   'edit_route' => 'dtc_ordre_reparation_modifier',
  1082.                               ],
  1084.                           ],
  1085.                           2  => [
  1086.                               'view' => 'FO/DataTable/heure.html.twig',
  1088.                           ],
  1089.                           3  => [
  1090.                               'view'   => 'FO/DataTable/type_or.html.twig',
  1091.                               'params' => [
  1092.                                   'edit_route' => 'dtc_ordre_reparation_modifier',
  1093.                               ],
  1094.                           ],
  1095.                           5  => [
  1096.                               'view'   => 'FO/DataTable/client.html.twig',
  1097.                               'params' => [],
  1098.                           ],
  1099.                           6  => [
  1100.                               'view' => 'FO/DataTable/heure.html.twig',
  1102.                           ],
  1103.                           11 => [
  1104.                               'view'   => 'FO/DataTable/actions.html.twig',
  1105.                               'params' => [
  1106.                                   'edit_route' => 'dtc_ordre_reparation_modifier',
  1107.                                   //'supprimer_route'    => 'dtc_commande_supprimer',
  1108.                                   'objet'      => Commande::class,
  1109.                               ],
  1110.                           ],
  1112.                       ]
  1113.                   )
  1114.                   ->setMultiple(
  1115.                       [
  1116.                           'delete' => [
  1117.                               'title' => 'Non disponible',
  1118.                               'route' => 'dtc_commande_liste_supprimer',
  1119.                           ],
  1120.                       ]
  1121.                   )
  1122.                   ->setOrder("x.date", "desc")
  1123.             //->setOrder("ec.ordre", "desc")
  1124.                   ->setSearch(true)
  1125.                   ->setSearchFields([1, 2, 3, 4, 5]);
  1127.         //$datatable->setSearchFields(array(0,2));
  1128.         return $datatable;
  1129.     }
  1132.     /**
  1133.      * @Route("/vehicule/client/grid/or/{id}", name="dtc_vehicule_client_liste_ordre_rep")
  1134.      */
  1135.     public function gridOrdreRepAction(Request $request, VehiculeClient $vehiculesClient,Datatable $datatable)
  1136.     {
  1137.         return $this->datatableOrdreRep($datatable,$vehiculesClient)->execute();
  1138.     }
  1140.     /**
  1141.      * @Route("/vehicule/client/grid/facture/{id}", name="dtc_vehicule_client_liste_facture_grid")
  1142.      */
  1143.     public function gridFactureAction(Request $request, VehiculeClient $vehiculesClient, Datatable $datatable)
  1144.     {
  1145.         return $this->datatableFactures($datatable, $vehiculesClient)->execute();
  1146.     }
  1149. }