src/Controller/FactureController.php line 36

  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\Facture;
  6. use App\Entity\Camion;
  7. use App\Entity\FactureDocument;
  8. use App\Entity\User;
  9. use App\Entity\FactureMaintenance;
  10. use App\Entity\Remorque;
  11. use App\Entity\Maintenance;
  12. use App\Entity\Divers;
  13. use App\Form\FactureType;
  14. use App\Form\AnneeType;
  15. use App\Repository\FactureDocumentRepository;
  16. use App\Repository\FactureMaintenanceRepository;
  17. use App\Repository\FactureRepository;
  18. use App\Repository\MaintenanceRepository;
  19. use App\Repository\MaintenanceTypeRepository;
  20. use PhpParser\Node\Expr\AssignOp\Div;
  21. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  22. use Symfony\Component\HttpFoundation\Request;
  23. use Symfony\Component\HttpFoundation\Response;
  24. use Symfony\Component\Routing\Annotation\Route;
  25. use Doctrine\Persistence\ManagerRegistry;
  26. use Symfony\Component\HttpFoundation\JsonResponse;
  27. use App\Repository\DocumentationRepository;
  28. use App\Service\FactureService;
  29. use App\Service\FunctionService;
  30. use App\Service\CarteCamionUserService;
  32. #[Route('/facture')]
  33. class FactureController extends AbstractController
  34. {
  35.     #[Route('/{vehicule}', name: 'app_facture_index', methods: ['GET'])]
  36.     public function index(FactureRepository $factureRepository,$vehicule,ManagerRegistry $doctrine,DocumentationRepository $documentationRepository, MaintenanceTypeRepository $maintenanceTypeRepository,FactureDocumentRepository $factureDocumentRepository): Response
  37.     {
  38.         $em = $doctrine->getManager();
  41.         /*
  42.                 $path = "../public/upload/facture/";
  43.                 if (file_exists( $path)) {
  44.                     $dossier = Opendir( $path); //Ouverture du dossier.
  45.                     while ($fichier = readdir($dossier)) //On affiche les fichiers les uns après les autres.
  46.                     {
  47.                         if (($fichier != '.') && ($fichier != '..') && ($fichier != '@eaDir'))
  48.                         {
  49.                             $exp = explode('.',$fichier);
  50.                             $idFact = $exp[0];
  51.                             $facture = $factureRepository->find($idFact);
  52.                             if(is_object($facture)) {
  53.                                 echo $fichier . " " . $facture->getId() . "<br />";
  55.                                 if (!file_exists("../public/upload/facture/" . $facture->getDate()->format('Y'))) {
  56.                                     mkdir("../public/upload/facture/" . $facture->getDate()->format('Y'), 0777, true);
  57.                                 }
  58.                                 if (!file_exists("../public/upload/facture/" . $facture->getDate()->format('Y') . '/' . $facture->getDate()->format('m'))) {
  59.                                     mkdir("../public/upload/facture/" . $facture->getDate()->format('Y') . '/' . $facture->getDate()->format('m'), 0777, true);
  60.                                 }
  61.                                 if (!file_exists("../public/upload/facture/" . $facture->getDate()->format('Y') . '/' . $facture->getDate()->format('m') . '/' . $facture->getDate()->format('d'))) {
  62.                                     mkdir("../public/upload/facture/" . $facture->getDate()->format('Y') . '/' . $facture->getDate()->format('m') . '/' . $facture->getDate()->format('d'), 0777, true);
  63.                                 }
  64.                                 if (!file_exists("../public/upload/facture/" . $facture->getDate()->format('Y') . '/' . $facture->getDate()->format('m') . '/' . $facture->getDate()->format('d') . '/' . $facture->getId())) {
  65.                                     mkdir("../public/upload/facture/" . $facture->getDate()->format('Y') . '/' . $facture->getDate()->format('m') . '/' . $facture->getDate()->format('d') . '/' . $facture->getId(), 0777, true);
  66.                                 }
  67.                                 //echo "../public/upload/facture/".$fichier.'<br />';
  68.                                 //echo "../public/upload/facture/".$facture->getDate()->format('Y') . '/' . $facture->getDate()->format('m') . '/' . $facture->getDate()->format('d') . '/' . $facture->getId()."/".$facture->getNameFile()."<br />";
  69.                                 //var_dump(move_uploaded_file("upload/facture/".$fichier, "upload/facture/".$facture->getDate()->format('Y') . '/' . $facture->getDate()->format('m') . '/' . $facture->getDate()->format('d') . '/' . $facture->getId()."/".$facture->getNameFile()));
  70.                                 var_dump(rename("upload/facture/" . $fichier, "upload/facture/" . $facture->getDate()->format('Y') . '/' . $facture->getDate()->format('m') . '/' . $facture->getDate()->format('d') . '/' . $facture->getId() . "/" . $facture->getNameFile()));
  71.                                 //$file = $file->move("../public/upload/facture/",$facture->getDate()->format('Y') . '/' . $facture->getDate()->format('m') . '/' . $facture->getDate()->format('d') . '/' . $facture->getId()."/".$facture->getNameFile());
  72.                                 //break;
  73.                                 $factDoc = new FactureDocument();
  74.                                 $factDoc->setNameFile($facture->getNameFile());
  75.                                 $factDoc->setFacture($facture);
  76.                                 $factureDocumentRepository->save($factDoc, true);
  78.                                 $facture->setCreatedAt($facture->getDate());
  79.                                 $factureRepository->save($facture, true);
  80.                             }
  81.                         }
  82.                     }
  83.                 }*/
  85.         $listVehicule = array();
  86.         $listMaintenanceType = array();
  87.         $em = $doctrine->getManager();
  88.         if($vehicule==1)
  89.         {
  90.             $camionRepo = $em->getRepository(Camion::class);
  91.             $listVehicule = $camionRepo->findAllCamion($this->getUser()->getSystemeClient())->getQuery()->getResult();
  92.             $listMaintenanceType = $maintenanceTypeRepository->findBy(array('typeVehicule'=>1));
  93.         }
  94.         else if($vehicule == 2)
  95.         {
  96.             $remorqueRepo = $em->getRepository(Remorque::class);
  97.             $listVehicule = $remorqueRepo->findAllRemorque($this->getUser()->getSystemeClient())->getQuery()->getResult();
  98.             $listMaintenanceType = $maintenanceTypeRepository->findBy(array('typeVehicule'=>2));
  99.         }
  100.         else if($vehicule == 3)
  101.         {
  102.             $camionRepo = $em->getRepository(Camion::class);
  103.             $listVehicule = $camionRepo->findAllVoiture($this->getUser()->getSystemeClient())->getQuery()->getResult();
  104.             $listMaintenanceType = $maintenanceTypeRepository->findBy(array('typeVehicule'=>3));
  105.         }
  106.         else if($vehicule == 4)
  107.         {
  108.             $diversRepo = $em->getRepository(Divers::class);
  109.             $listVehicule = $diversRepo->findAllDivers($this->getUser()->getSystemeClient());
  110.         }
  112.         $listChauffeur = $em->getRepository(User::class)->findAllChauffeur(1);
  114.         $docu = $documentationRepository->find(22);
  116.         return $this->render('facture/index.html.twig', [
  117.             'docu' => $docu->getText(),
  118.             'listChauffeur'=>$listChauffeur,
  119.             'listVehicule'=>$listVehicule,
  120.             'vehicule' => $vehicule,
  121.             'listMaintenanceType' => $listMaintenanceType,
  122.         ]);
  123.     }
  125.     #[Route('/uploadFile', name: 'app_facture_upload_file', methods: ['POST'])]
  126.     public function uploadFileAction(Request $request, ManagerRegistry $doctrine, FactureRepository $factureRepository, FactureDocumentRepository $factureDocumentRepository, FactureService $factureService): Response
  127.     {
  129.         $em = $doctrine->getManager();
  130.         $return = array("valide"=>0,'file'=>array('name'=>null),"idFacture"=>null);
  131.         $file = $request->files->get('file');
  132.         $typeVehicule = $request->request->get('typeVehicule');
  133.         $idVehicule = $request->request->get('idVehicule');
  134.         $idFacture = $request->request->get('idFacture');
  137.         if($file->isValid())
  138.         {
  139.             $listExt = array('pdf','txt','jpg','png','xls','csv','xlsx');
  140.             if(in_array($file->getClientOriginalExtension(),$listExt))
  141.             {
  142.                 $filename = str_replace("%", "", $file->getClientOriginalName());//supprime les % car il pse problème à l'affichage
  143.                 if(is_numeric($idFacture)) {//si facture existante
  144.                     $facture = $factureRepository->find($idFacture);
  145.                 }
  146.                 else
  147.                 {//si pas de facture existante, on la créé
  148.                     $facture = new Facture();
  149.                     if ($typeVehicule == 1 || $typeVehicule == 3) {
  150.                         $camionRepo = $em->getRepository(Camion::class);
  151.                         $cam = $camionRepo->find($idVehicule);
  152.                         $facture->setCamion($cam);
  153.                     } else if($typeVehicule == 2) {
  154.                         $remorqueRepo = $em->getRepository(Remorque::class);
  155.                         $rem = $remorqueRepo->find($idVehicule);
  156.                         $facture->setRemorque($rem);
  157.                     } else if($typeVehicule == 4) {
  158.                         $diversRepo = $em->getRepository(Divers::class);
  159.                         $div = $diversRepo->find($idVehicule);
  160.                         $facture->setDivers($div);
  161.                     }
  162.                     $facture->setNameFile($filename);
  163.                     $facture->setDate(new \DateTime());
  164.                     $facture->setCreatedAt(new \DateTime());
  165.                     $facture->setValide(0);
  166.                     $facture->setCourroie(0);
  167.                     $facture->setFiltreAir(0);
  168.                     $facture->setFiltreGO(0);
  169.                     $facture->setFiltreHuile(0);
  170.                     $facture->setVidange(0);
  171.                     $facture->setPrix(0);
  172.                     $facture->setHeureMoteur(0);
  173.                     $factureRepository->save($facture, true);
  174.                 }
  176.                 $idFacture = $facture->getId();
  177.                 $returnData = $factureService->addFacture($file,$idFacture);
  178.                 $return['valide'] = $returnData['valide'];
  179.                 $return['idFacture'] = $returnData['idFacture'];
  180.                 //on test le nom et on rajoute un chiffre si besoin
  181.                 /*$exp = explode('.',$filename);
  182.                 $ext = end($exp);
  183.                 $fileNameSansExt = $exp[0];
  185.                 $filepath = "../public/upload/facture/" . $facture->getCreatedAt()->format('Y') . '/' . $facture->getCreatedAt()->format('m') . '/' . $facture->getCreatedAt()->format('d') . '/' . $facture->getId() . '/';
  186.                 if (file_exists($filepath . $filename)) {
  187.                     $i = 1;
  188.                     while (file_exists($filepath . $filename)) {
  189.                         $filename = $fileNameSansExt . $i . '.' . $ext;
  190.                         $i++;
  191.                     }
  192.                 }
  196.                 //on créé les dossiers si besoin
  197.                 if (!file_exists("../public/upload/facture/" . $facture->getCreatedAt()->format('Y'))) {
  198.                     mkdir("../public/upload/facture/" . $facture->getCreatedAt()->format('Y'), 0777, true);
  199.                 }
  200.                 if (!file_exists("../public/upload/facture/" . $facture->getCreatedAt()->format('Y') . '/' . $facture->getCreatedAt()->format('m'))) {
  201.                     mkdir("../public/upload/facture/" . $facture->getCreatedAt()->format('Y') . '/' . $facture->getCreatedAt()->format('m'), 0777, true);
  202.                 }
  203.                 if (!file_exists("../public/upload/facture/" . $facture->getCreatedAt()->format('Y') . '/' . $facture->getCreatedAt()->format('m') . '/' . $facture->getCreatedAt()->format('d'))) {
  204.                     mkdir("../public/upload/facture/" . $facture->getCreatedAt()->format('Y') . '/' . $facture->getCreatedAt()->format('m') . '/' . $facture->getCreatedAt()->format('d'), 0777, true);
  205.                 }
  206.                 if (!file_exists("../public/upload/facture/" . $facture->getCreatedAt()->format('Y') . '/' . $facture->getCreatedAt()->format('m') . '/' . $facture->getCreatedAt()->format('d') . '/' . $facture->getId())) {
  207.                     mkdir("../public/upload/facture/" . $facture->getCreatedAt()->format('Y') . '/' . $facture->getCreatedAt()->format('m') . '/' . $facture->getCreatedAt()->format('d') . '/' . $facture->getId(), 0777, true);
  208.                 }
  209.                 $file = $file->move("../public/upload/facture/".$facture->getCreatedAt()->format('Y') . '/' . $facture->getCreatedAt()->format('m') . '/' . $facture->getCreatedAt()->format('d') . '/' . $facture->getId().'/',$filename);
  212.                 $factDoc = new FactureDocument();
  213.                 $factDoc->setNameFile($filename);
  214.                 $factDoc->setFacture($facture);
  215.                 $factureDocumentRepository->save($factDoc, true);
  217.                 if(is_object($file))
  218.                 {
  219.                     $return['valide'] = 1;
  220.                     $return['idFacture'] = $facture->getId();
  221.                 }*/
  223.             }
  224.         }
  226.         return new JsonResponse($return);
  227.     }
  229.     #[Route('/uploadDataFacture', name: 'app_facture_upload_data_facture', methods: ['POST'])]
  230.     public function uploadDataFactureAction(Request $request, ManagerRegistry $doctrine, FactureRepository $factureRepository, MaintenanceTypeRepository $maintenanceTypeRepository, MaintenanceRepository $maintenanceRepository, FactureMaintenanceRepository $factureMaintenanceRepository, FactureService $factureService): Response
  231.     {
  233.         $em = $doctrine->getManager();
  234.         $return = array("valide"=>0,"msg"=>"");
  236.         $idFacture = $request->request->get('idFacture');
  237.         $typeVehicule = $request->request->get('typeVehicule');
  238.         $idVehicule = $request->request->get('idVehicule');
  239.         $fileFacture = $request->files->get('fileFacture');
  241.         if($idFacture=='')
  242.         {
  243.             $facture = new Facture();
  244.             $facture->setNameFile("");
  245.             $facture->setDate(new \DateTime());
  246.             $facture->setValide(1);
  247.             $facture->setCreatedAt(new \DateTime());
  248.             $factureRepository->save($facture, true);
  249.             $idFacture = $facture->getId();
  250.         }
  251.         $textFacture = $request->request->get('textFacture');
  252.         $vidangeFT = $request->request->get('vidange');
  253.         $heureMoteur = $request->request->get('heureMoteur');
  254.         $prix = $request->request->get('prix');
  255.         if($vidangeFT=="true")
  256.         {
  257.             $vidange = 1;
  258.         }
  259.         else
  260.         {
  261.             $vidange = 0;
  262.         }
  263.         $filtrehuileFT = $request->request->get('filtrehuile');
  264.         if($filtrehuileFT=="true")
  265.         {
  266.             $filtrehuile = 1;
  267.         }
  268.         else
  269.         {
  270.             $filtrehuile = 0;
  271.         }
  272.         $filtreairFT = $request->request->get('filtreair');
  273.         if($filtreairFT=="true")
  274.         {
  275.             $filtreair = 1;
  276.         }
  277.         else
  278.         {
  279.             $filtreair = 0;
  280.         }
  281.         $filtregoFT = $request->request->get('filtrego');
  282.         if($filtregoFT=="true")
  283.         {
  284.             $filtrego = 1;
  285.         }
  286.         else
  287.         {
  288.             $filtrego = 0;
  289.         }
  290.         $courroieFT = $request->request->get('courroie');
  291.         if($courroieFT=="true")
  292.         {
  293.             $courroie = 1;
  294.         }
  295.         else
  296.         {
  297.             $courroie = 0;
  298.         }
  299.         $sinistre = $request->request->get('sinistre');
  301.         $date = $request->request->get('date');
  302.         $maintenanceType = array();
  303.         $data = $request->request->all();
  304.         if(!empty($data['maintenanceType']))
  305.         {
  306.             $maintenanceType = $data['maintenanceType'];
  307.         }
  309.         if($idFacture>0)
  310.         {
  311.             $factureRepo = $em->getRepository(Facture::class);
  312.             $facture = $factureRepo->find($idFacture);
  313.             if(is_object($facture))
  314.             {
  315.                 if($date!='' && $textFacture!='')
  316.                 {
  317.                     if($typeVehicule==1 || $typeVehicule==3)
  318.                     {
  319.                         $camionRepo = $em->getRepository(Camion::class);
  320.                         $cam = $camionRepo->find($idVehicule);
  321.                         $facture->setCamion($cam);
  322.                     }
  323.                     else if($typeVehicule==2)
  324.                     {
  325.                         $remorqueRepo = $em->getRepository(Remorque::class);
  326.                         $rem = $remorqueRepo->find($idVehicule);
  327.                         $facture->setRemorque($rem);
  328.                     }
  329.                     else if($typeVehicule==4)
  330.                     {
  331.                         $diversRepo = $em->getRepository(Divers::class);
  332.                         $div = $diversRepo->find($idVehicule);
  333.                         $facture->setDivers($div);
  334.                     }
  335.                     $dateT = new \DateTime($date);
  337.                     /*if($fileFacture!=null)
  338.                     {
  339.                         if($fileFacture->isValid()) {
  340.                             $listExt = array('pdf', 'txt', 'jpg', 'png', 'xls', 'csv', 'xlsx');
  341.                             if (in_array($fileFacture->getClientOriginalExtension(), $listExt)) {
  342.                                 $filename = $fileFacture->getClientOriginalName();
  343.                                 $facture->setNameFile($filename);
  344.                                 $fileFacture->move("../public/upload/facture/",$facture->getId().".".$fileFacture->getClientOriginalExtension());
  345.                             }
  346.                             else
  347.                             {
  348.                                 $return['msg'] = "Le type de fichier n'est pas correct, seuls les fichiers pdf, txt, jpg, png, xls, csv ou xlsx sont pris en compte.";
  349.                             }
  350.                         }
  351.                         else
  352.                         {
  353.                             $return['msg'] = "Votre fichier n'est pas valide.";
  354.                         }
  355.                     }*/
  357.                     $facture->setText($textFacture);
  358.                     $facture->setDate($dateT);
  359.                     $facture->setVidange($vidange);
  360.                     $facture->setFiltreHuile($filtrehuile);
  361.                     $facture->setFiltreAir($filtreair);
  362.                     $facture->setFiltreGO($filtrego);
  363.                     $facture->setCourroie($courroie);
  364.                     $facture->setSinistre($sinistre);
  365.                     if($prix=='')
  366.                     {
  367.                         $facture->setPrix(0);
  368.                     }
  369.                     else
  370.                     {
  371.                         $facture->setPrix($prix);
  372.                     }
  373.                     if($heureMoteur=='')
  374.                     {
  375.                         $facture->setHeureMoteur(0);
  376.                     }
  377.                     else
  378.                     {
  379.                         $facture->setHeureMoteur($heureMoteur);
  380.                     }
  381.                     $facture->setValide(1);
  382.                     $factureRepository->save($facture, true);
  384.                     if(!empty($maintenanceType))
  385.                     {//si c'est une maintenance on rajoute la date dans la maintenance
  386.                         foreach($maintenanceType as $idMT) {
  387.                             $maintenanceType = $maintenanceTypeRepository->find($idMT);
  389.                             $maintenance = new Maintenance();
  390.                             $maintenance->setDate($dateT);
  391.                             $maintenance->setCommentaire($textFacture);
  392.                             $maintenance->setType($maintenanceType);
  393.                             $maintenance->setSystemeClient($this->getUser()->getSystemeClient());
  394.                             $maintenance->setActif(1);
  395.                             if ($facture->getRemorque() != null) {
  396.                                 $maintenance->setRemorque($facture->getRemorque());
  397.                                 $maintenance->setCamion(null);
  398.                             } else {
  399.                                 $maintenance->setRemorque(null);
  400.                                 $maintenance->setCamion($facture->getCamion());
  401.                             }
  402.                             $maintenanceRepository->save($maintenance, true);
  404.                             $factureMaintenance = new FactureMaintenance();
  405.                             $factureMaintenance->setFacture($facture);
  406.                             $factureMaintenance->setMaintenanceType($maintenanceType);
  407.                             $factureMaintenanceRepository->save($factureMaintenance, true);
  408.                         }
  409.                     }
  411.                     $return['valide'] = 1;
  412.                 }
  413.                 else
  414.                 {
  415.                     $return['msg'] = "Les données saisie ne semblent pas corrects";
  416.                 }
  418.                 if($fileFacture!=null)
  419.                 {
  420.                     if($fileFacture->isValid()) {
  421.                         $listExt = array('pdf', 'txt', 'jpg', 'png', 'xls', 'csv', 'xlsx');
  422.                         if (in_array($fileFacture->getClientOriginalExtension(), $listExt)) {
  423.                             $factureService->addFacture($fileFacture, $idFacture);
  424.                         }
  425.                         else
  426.                         {
  427.                             $return['msg'] = "Le type de fichier n'est pas correct, seuls les fichiers pdf, txt, jpg, png, xls, csv ou xlsx sont pris en compte.";
  428.                         }
  429.                     }
  430.                     else
  431.                     {
  432.                         $return['msg'] = "Votre fichier n'est pas valide.";
  433.                     }
  434.                 }
  435.             }
  436.             else
  437.             {
  438.                 $return['msg'] = "Aucun document n'a été trouvé";
  439.             }
  440.         }
  441.         else
  442.         {
  443.             $return['msg'] = "Aucun document n'a été trouvé";
  444.         }
  446.         return new JsonResponse($return);
  447.     }
  449.     #[Route('/getListFacture/{idVehicule}/{typeVehicule}', name: 'app_facture_get_list', methods: ['GET'])]
  450.     public function getListFactureAction(Request $request, $idVehicule, $typeVehicule, ManagerRegistry $doctrine, FactureRepository $factureRepository, FactureDocumentRepository $factureDocumentRepository): Response
  451.     {
  453.         $em = $doctrine->getManager();
  454.         $return = array("valide"=>0,'listeFacture'=>array(),'nomVehicule'=>"",'listChauffeur'=>array());
  456.         $listChauffeur = array();
  457.         $listChauffeurBDD = $em->getRepository(User::class)->findAllChauffeur(1);
  458.         if(!empty($listChauffeurBDD))
  459.         {
  460.             foreach($listChauffeurBDD as $chauff)
  461.             {
  462.                 $listChauffeur[] = array('id'=>$chauff->getId(),'nom'=>$chauff->getPrenom().' '.$chauff->getNom());
  463.             }
  464.         }
  466.         //suppression des lignes non terminées
  467.         $factureRepo = $em->getRepository(Facture::class);
  468.         $listFac = $factureRepo->findBy(array("valide"=>0));
  469.         if(!empty($listFac))
  470.         {
  471.             foreach($listFac as $fact)
  472.             {
  473.                 $listFactDoc = $factureDocumentRepository->findBy(array('facture'=>$fact));
  474.                 if(!empty($listFactDoc))
  475.                 {
  476.                     foreach($listFactDoc as $factDoc)
  477.                     {
  478.                         if(file_exists("../public/upload/facture/".$fact->getCreatedAt()->format('Y') . '/' . $fact->getCreatedAt()->format('m') . '/' . $fact->getCreatedAt()->format('d') . '/' . $fact->getId().'/'.$factDoc->getNameFile())) {
  479.                             unlink("../public/upload/facture/".$fact->getCreatedAt()->format('Y') . '/' . $fact->getCreatedAt()->format('m') . '/' . $fact->getCreatedAt()->format('d') . '/' . $fact->getId().'/'.$factDoc->getNameFile());
  480.                             $factureDocumentRepository->remove($factDoc, true);
  481.                             $factureRepository->remove($fact, true);
  482.                         }
  483.                     }
  484.                 }
  485.             }
  486.         }
  488.         $listFacture = array();
  489.         if($typeVehicule==1 || $typeVehicule==3)
  490.         {
  491.             $camionRepo = $em->getRepository(Camion::class);
  492.             $cam = $camionRepo->find($idVehicule);
  493.             $listFacture = $factureRepo->findBy(array("camion"=>$cam),array('date'=>'DESC'));
  494.             $return['nomVehicule'] = $cam->getNom();
  495.         }
  496.         else if($typeVehicule==2)
  497.         {
  498.             $remorqueRepo = $em->getRepository(Remorque::class);
  499.             $rem = $remorqueRepo->find($idVehicule);
  500.             $listFacture = $factureRepo->findBy(array("remorque"=>$rem),array('date'=>'DESC'));
  501.             $return['nomVehicule'] = $rem->getNumero().' / '.$rem->getNom().' / '.$rem->getMarque().' / '.$rem->getCat().' / '.$rem->getReferenceMoteur();
  502.         }
  503.         else if($typeVehicule==4)
  504.         {
  505.             $diversRepo = $em->getRepository(Divers::class);
  506.             $divers = $diversRepo->find($idVehicule);
  507.             $listFacture = $factureRepo->findBy(array("divers"=>$divers),array('date'=>'DESC'));
  508.             $return['nomVehicule'] = $divers->getNom();
  509.         }
  511.         if(!empty($listFacture))
  512.         {
  513.             foreach($listFacture as $facture)
  514.             {
  515.                 $listFactDoc = $factureDocumentRepository->findBy(array('facture'=>$facture));
  516.                 $listFile = array();
  517.                 if(!empty($listFactDoc))
  518.                 {
  519.                     foreach($listFactDoc as $factDoc)
  520.                     {
  521.                         $exp = explode('.',$factDoc->getNameFile());
  522.                         $ext = end($exp);
  524.                         $icon = "<i class=\"fa-regular fa-file fa-2x btn btn-default\"></i>";
  525.                         if($ext=='pdf')
  526.                         {
  527.                             $icon = "<i class=\"fa-solid fa-file-pdf fa-2x btn btn-danger\"></i>";
  528.                         }
  529.                         if($ext=='xls' || $ext=='xlsx')
  530.                         {
  531.                             $icon = "<i class=\"fa-regular fa-file-excel fa-2x btn btn-success\"></i>";
  532.                         }
  533.                         if($ext=='csv')
  534.                         {
  535.                             $icon = "<i class=\"fa-solid fa-file-csv fa-2x btn btn-success\" ></i>";
  536.                         }
  537.                         if($ext=='png' || $ext=='jpg')
  538.                         {
  539.                             $icon = "<i class=\"fa-solid fa-image fa-2x btn btn-info\"></i>";
  540.                         }
  541.                         $listFile[] = array('name'=>$factDoc->getNameFile(), "icon"=>$icon,'ext'=>$ext,
  542.                             'id'=>$factDoc->getId(),
  543.                             'url'=>$facture->getCreatedAt()->format('Y') . '/' . $facture->getCreatedAt()->format('m') . '/' . $facture->getCreatedAt()->format('d') . '/' . $facture->getId().'/'.$factDoc->getNameFile());
  544.                     }
  545.                 }
  547.                 $chauffeurNom = "";
  548.                 $chauffeurId = 0;
  549.                 if($facture->getSinistre()>0) {
  550.                     $chauffeur = $em->getRepository(User::class)->find($facture->getSinistre());
  552.                     if (is_object($chauffeur)) {
  553.                         $chauffeurNom = $chauffeur->getPrenom() . ' ' . $chauffeur->getNom();
  554.                         $chauffeurId = $chauffeur->getId();
  555.                     }
  556.                 }
  557.                 $return['listeFacture'][] = array('id'=>$facture->getId(),'file'=>$listFile,'text'=>$facture->getText(),'date'=>$facture->getDate()->format("d/m/Y"),
  558.                     'dateUS'=>$facture->getDate()->format("Y-m-d"),'vidange'=>$facture->getVidange(),
  559.                     'filtreHuile'=>$facture->getFiltreHuile(),'filtreAir'=>$facture->getFiltreAir(),
  560.                     'filtreGO'=>$facture->getFiltreGO(),'courroie'=>$facture->getCourroie(),
  561.                     'sinistre'=>$chauffeurId,'sinistreNom'=>$chauffeurNom,
  562.                     'prix'=>$facture->getPrix(),'heureMoteur'=>$facture->getHeureMoteur()
  563.                 );
  564.                 $return['listChauffeur'] = $listChauffeur;
  565.                 $return['valide'] = 1;
  566.             }
  567.         }
  570.         return new JsonResponse($return);
  571.     }
  573.     #[Route('/getDateImmatByTypeVehicule/{idVehicule}/{typeVehicule}', name: 'app_facture_get_date_immat_by_type_vehicule', methods: ['GET'])]
  574.     public function getDateImmatByTypeVehicule(Request $request, $idVehicule, $typeVehicule, ManagerRegistry $doctrine, FactureRepository $factureRepository): Response
  575.     {
  577.         $em = $doctrine->getManager();
  578.         $return = array("valide"=>0,'dateImmat'=>"",'dateImmatUS'=>"");
  580.         if($typeVehicule==1 || $typeVehicule==3)
  581.         {
  582.             $camionRepo = $em->getRepository(Camion::class);
  583.             $cam = $camionRepo->find($idVehicule);
  584.             if($cam->getDateImmat()!=null)
  585.             {
  586.                 $return['valide'] = 1;
  587.                 $return['dateImmat'] = $cam->getDateImmat()->format('d/m/Y');
  588.                 $return['dateImmatUS'] = $cam->getDateImmat()->format('Y-m-d');
  589.             }
  591.         }
  592.         else if($typeVehicule==2)
  593.         {
  594.             $remorqueRepo = $em->getRepository(Remorque::class);
  595.             $rem = $remorqueRepo->find($idVehicule);
  596.             if($rem->getDateImmat()!=null)
  597.             {
  598.                 $return['valide'] = 1;
  599.                 $return['dateImmat'] = $rem->getDateImmat()->format('d/m/Y');
  600.                 $return['dateImmatUS'] = $rem->getDateImmat()->format('Y-m-d');
  601.             }
  602.         }
  603.         else if($typeVehicule==4)
  604.         {
  605.             $return['valide'] = 1;
  606.         }
  609.         return new JsonResponse($return);
  610.     }
  613.     #[Route('/cout/annuelParChauffeur/', name: 'app_facture_cout_annuel_par_chauffeur', methods: ['GET', 'POST'])]
  614.     public function coutAnnuelParChauffeur(Request $request,ManagerRegistry $doctrine, DocumentationRepository $documentationRepository,FunctionService $functionService, CarteCamionUserService $carteCamionUserService): Response
  615.     {
  616.         $form = $this->createForm(AnneeType::class);
  617.         $form->handleRequest($request);
  619.         $em = $doctrine->getManager();
  620.         $listMois = $functionService->getListMoisString();
  621.         $tri = "chauffeur";
  622.         $data = array();
  624.         $affChauffeur = null;
  625.         $listCoutRem = array();
  626.         $listCoutVoit = array();
  627.         $listCoutChauffeur = array();
  628.         $listChauffeur = $em->getRepository(User::class)->findAllChauffeur($this->getUser()->getSystemeClient());
  629.         $annee = date('Y');
  630.         if ($form->isSubmitted() && $form->isValid()) {
  633.             $mois_annee = $request->request->all();
  634.             $annee = $mois_annee['annee']['annee'];
  635.             $affChauffeur = $mois_annee['affChauffeur'];
  636.             $tri = $mois_annee['tri'];
  638.             $factureRepository = $em->getRepository(Facture::class);
  639.             $list = $factureRepository->findSinistreByYear($annee);
  641.             if(!empty($listChauffeur))
  642.             {//on rempli à vide la liste des chauffeurs
  643.                 foreach($listChauffeur as $chauffeur)
  644.                 {
  645.                     $listCoutChauffeur[$chauffeur->getId()]['chauffeur'] = $chauffeur->getPrenom().' '.$chauffeur->getNom();
  646.                     $listCoutChauffeur[$chauffeur->getId()]['matricule'] = $chauffeur->getMatricule();
  647.                     $listCoutChauffeur[$chauffeur->getId()]['cout'] = 0;
  648.                 }
  649.             }
  651.             if(!empty($list))
  652.             {//on boucle sur la liste des factures avec sinistre
  653.                 foreach($list as $facture)
  654.                 {
  655.                     if(isset($listCoutChauffeur[$facture->getSinistre()]))
  656.                     {//et on ajoute les prix à chaque chauffeur
  657.                         $listCoutChauffeur[$facture->getSinistre()]['cout'] += $facture->getPrix();
  658.                     }
  659.                 }
  661.                 if($tri=='chauffeur')
  662.                 {
  663.                     $listCoutChauffeur = $functionService->array_msort($listCoutChauffeur, array($tri => SORT_ASC));
  664.                 }
  665.                 else
  666.                 {
  667.                     $listCoutChauffeur = $functionService->array_msort($listCoutChauffeur, array($tri => SORT_DESC));
  668.                 }
  669.             }
  670.         }
  672.         $docu = $documentationRepository->find(53);
  674.         return $this->render('facture/coutAnnuelParChauffeur.html.twig', [
  675.             'listMois' => $listMois,
  676.             'docu' => $docu->getText(),
  677.             'form' => $form,
  678.             'data' => $data,
  679.             'annee' => $annee,
  680.             'listChauffeur' => $listChauffeur,
  681.             'listCoutRem' => $listCoutRem,
  682.             'listCoutVoit' => $listCoutVoit,
  683.             'listCoutChauffeur' => $listCoutChauffeur,
  684.             'tri' => $tri,
  685.             'affChauffeur' => $affChauffeur,
  686.         ]);
  687.     }
  689.     #[Route('/new', name: 'app_facture_new', methods: ['GET', 'POST'])]
  690.     public function new(Request $request, FactureRepository $factureRepository): Response
  691.     {
  692.         $facture = new Facture();
  693.         $form = $this->createForm(FactureType::class, $facture);
  694.         $form->handleRequest($request);
  696.         if ($form->isSubmitted() && $form->isValid()) {
  697.             $facture->setCreatedAt(new \DateTime());
  698.             $factureRepository->save($facture, true);
  700.             return $this->redirectToRoute('app_facture_index', [], Response::HTTP_SEE_OTHER);
  701.         }
  703.         return $this->renderForm('facture/new.html.twig', [
  704.             'facture' => $facture,
  705.             'form' => $form,
  706.         ]);
  707.     }
  711.     #[Route('/{id}/edit', name: 'app_facture_edit', methods: ['GET', 'POST'])]
  712.     public function edit(Request $request, Facture $facture, FactureRepository $factureRepository): Response
  713.     {
  714.         $form = $this->createForm(FactureType::class, $facture);
  715.         $form->handleRequest($request);
  717.         if ($form->isSubmitted() && $form->isValid()) {
  718.             $factureRepository->save($facture, true);
  720.             return $this->redirectToRoute('app_facture_index', [], Response::HTTP_SEE_OTHER);
  721.         }
  723.         return $this->renderForm('facture/edit.html.twig', [
  724.             'facture' => $facture,
  725.             'form' => $form,
  726.         ]);
  727.     }
  729.     #[Route('/{id}', name: 'app_facture_delete', methods: ['POST'])]
  730.     public function delete(Request $request, Facture $facture, FactureRepository $factureRepository): Response
  731.     {
  732.         if ($this->isCsrfTokenValid('delete'.$facture->getId(), $request->request->get('_token'))) {
  733.             $factureRepository->remove($facture, true);
  734.         }
  736.         return $this->redirectToRoute('app_facture_index', [], Response::HTTP_SEE_OTHER);
  737.     }
  739.     #[Route('/delete/{id}', name: 'app_facture_delete_facture', methods: ['POST'])]
  740.     public function deleteFacture(Request $request, Facture $facture, FactureRepository $factureRepository, ManagerRegistry $doctrine, FactureDocumentRepository $factureDocumentRepository): Response
  741.     {
  742.         $return = array("valide"=>0);
  743.         $listDocFacture = $factureDocumentRepository->findBy(array('facture'=>$facture));
  744.         if(!empty($listDocFacture))
  745.         {
  746.             foreach($listDocFacture as $doc)
  747.             {
  748.                 if(file_exists("../public/upload/facture/". $facture->getCreatedAt()->format('Y') . '/' . $facture->getCreatedAt()->format('m') . '/' . $facture->getCreatedAt()->format('d') . '/' . $facture->getId() .'/'.$doc->getNameFile())) {
  749.                     unlink("../public/upload/facture/".$facture->getCreatedAt()->format('Y') . '/' . $facture->getCreatedAt()->format('m') . '/' . $facture->getCreatedAt()->format('d') . '/' . $facture->getId() .'/'.$doc->getNameFile());
  750.                     $factureDocumentRepository->remove($doc, true);
  751.                 }
  752.             }
  753.         }
  755.         $factureRepository->remove($facture, true);
  756.         $return['valide'] = 1;
  759.         return new JsonResponse($return);
  760.     }
  762.     #[Route('/deleteFactureDoc/{factureDoc}', name: 'app_facture_delete_facture_doc', methods: ['GET'])]
  763.     public function deleteFactureDoc(Request $request, FactureDocument $factureDoc, FactureRepository $factureRepository, ManagerRegistry $doctrine, FactureDocumentRepository $factureDocumentRepository): Response
  764.     {
  765.         $return = array("valide"=>0);
  766.         $facture = $factureDoc->getFacture();
  768.         if(is_object($facture)) {
  769.             $url = $facture->getCreatedAt()->format('Y') . '/' . $facture->getCreatedAt()->format('m') . '/' . $facture->getCreatedAt()->format('d') . '/' . $facture->getId() . '/' . $factureDoc->getNameFile();
  770.             if ($url != '') {
  771.                 if (file_exists("../public/upload/facture/" . $url)) {
  772.                     unlink("../public/upload/facture/" . $url);
  773.                     $factureDocumentRepository->remove($factureDoc, true);
  774.                     $return['valide'] = 1;
  775.                 }
  776.             }
  777.         }
  779.         return new JsonResponse($return);
  780.     }
  781. }