src/Controller/Marches/DevisController.php line 227

Open in your IDE?
  1. <?php
  3. namespace App\Controller\Marches;
  5. use App\Entity\BureauMarche;
  6. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  7. use Symfony\Component\HttpFoundation\Response;
  8. use Symfony\Component\Routing\Annotation\Route;
  9. use Symfony\Component\HttpFoundation\Request;
  10. use Doctrine\ORM\EntityManagerInterface;
  11. use App\Entity\Client;
  12. use App\Entity\Bordereau;
  13. use App\Service\ValidateService;
  14. use App\Service\BaseService;
  15. use App\Entity\Devis; 
  16. use App\Entity\DetailDevis; 
  17. use App\Entity\ModelBordereau; 
  18. use App\Entity\InfosModalBordereau; 
  19. use Symfony\Component\HttpFoundation\JsonResponse;
  20. use Symfony\Component\Serializer\SerializerInterface;
  21. use App\Entity\Marche; 
  22. use Symfony\Component\HttpFoundation\Session\Session;
  23. use App\Repository\DevisRepository;
  24. use App\Entity\Bureau;
  25. use App\Entity\DetailBord;
  26. use App\Entity\InfosDetailBord;
  27. use Spipu\Html2Pdf\Html2Pdf;
  28. use App\Entity\LogUser; 
  29. use App\Repository\serviceRepo\archivesRepo;
  30. use App\Repository\BordereauRepository;
  31. use DateTime;
  34. class DevisController extends AbstractController
  35. {
  36.     public $baseService;
  38.     public function __construct(BaseService $baseService
  39.         )
  40.     {
  41.         $this->baseService = $baseService;
  42.     }
  43.     #[Route('/addDevis', name: 'addDevis')]
  44.     public function addDevis(Request $request, EntityManagerInterface $entityManager,ValidateService $validateService,
  45.     BaseService $baseService,DevisRepository $devisRepository): Response
  46.     {
  47.         $chckAccess = $this->baseService->Role(53);
  48.         if($chckAccess == 0){
  49.             return $this->redirectToRoute('login');
  50.         }else if ($chckAccess == 2){
  51.             return $this->redirectToRoute('infoUtilisateur');
  52.         }
  53.         $response = "";
  54.         $num = $devisRepository->getNumero();
  56.         $client = "";
  57.         $numero = "DE-".$num."/".date('Y'); 
  58.         $objet = "";
  59.         $date = "";
  60.         $clients = $entityManager->getRepository(Client::class)->findAll();
  61.         $bureaux = $entityManager->getRepository(Bureau::class)->findAll();
  64.         return $this->render('devis/addDevis.html.twig', [
  65.             'controller_name' => 'DevisController',
  66.             'response' => $response,
  67.             'clients' => $clients,
  68.             'client' => $client,
  69.             'numero' => $numero,
  70.             'objet' => $objet,
  71.             'date' => $date,
  72.             'bureaux' => $bureaux
  74.         ]);
  75.     }
  77.     #[Route('/listDevis', name: 'listDevis')]
  78.     public function listDevis(Request $request, EntityManagerInterface $entityManager,BaseService $baseService): Response
  79.     {
  80.         $chckAccess = $this->baseService->Role(52);
  81.         if($chckAccess == 0){
  82.             return $this->redirectToRoute('login');
  83.         }else if ($chckAccess == 2){
  84.             return $this->redirectToRoute('infoUtilisateur');
  85.         }
  86.         $session = new Session;
  87.         $bureauSelected = $session->get('bureauSelected');
  89.         $devis = $entityManager->getRepository(Devis::class)->findAll();
  90.   
  91.         $clients = $entityManager->getRepository(Client::class)->findAll();
  93.         $years = $baseService->getYears()["years"];
  94.         $months = $baseService->getYears()["months"];
  95.         $yearsFin =  (new DateTime())->format('Y');
  96.         $yearSelect = $yearsFin;
  97.         $bureaux = $entityManager->getRepository(Bureau::class)->findAll();
  98.         return $this->render('devis/listDevis.html.twig', [
  99.             'controller_name' => 'DevisController',
  100.             'devis' => $devis,
  101.             'clients' => $clients,
  102.             'years'=>$years,
  103.             'months'=> $months,
  104.             'yearSelect'=> $yearSelect,
  105.             'bureaux' => $bureaux
  106.         ]);
  107.     }
  109.     #[Route('/listeDevisArchivees', name: 'listeDevisArchivees')]
  110.     public function listeDevisArchivees(Request $request, archivesRepo $archivesRepo ,EntityManagerInterface $entityManager,BaseService $baseService): Response
  111.     {
  112.         $chckAccess = $this->baseService->Role(56);
  113.         if($chckAccess == 0){
  114.             return $this->redirectToRoute('login');
  115.         }else if ($chckAccess == 2){
  116.             return $this->redirectToRoute('infoUtilisateur');
  117.         }
  118.         $session = new Session;
  119.         $bureauSelected = $session->get('bureauSelected');
  120.        
  122.         $devis = $entityManager->getRepository(Devis::class)->findAll();
  124.         
  125.         $clients = $entityManager->getRepository(Client::class)->findAll();
  127.         $years = $baseService->getYears()["years"];
  128.         $months = $baseService->getYears()["months"];
  129.         $yearsFin =  (new DateTime())->format('Y');
  130.         $yearSelect = $yearsFin;
  132.         $year = $request->get("year");
  133.         $month = $request->get("month");
  135.         // Create a DateTime object for the first day of the specified month and year
  136.         $firstDay = new \DateTime("$year-$month-01");
  138.         // Get the last day of the month by modifying the first day
  139.         $lastDay = clone $firstDay;
  140.         $lastDay->modify('last day of this month');
  142.         // Format the dates as strings in 'Y-m-d' format
  143.         $date_debut = $firstDay->format('Y-m-d') ;
  144.         $date_fin = $lastDay->format('Y-m-d');
  145.         $devis = $archivesRepo->getDevis(2 , $date_debut , $date_fin  ,$bureauSelected);
  146.         
  147.         return $this->render('devis/listDevisArchivees.html.twig', [
  148.             'controller_name' => 'DevisController',
  149.             'devis' => $devis,
  150.             'clients' => $clients,
  151.             'years'=>$years,
  152.             'buro'=>$bureauSelected,
  153.             'months'=> $months,
  154.             'yearSelect'=> $yearSelect
  155.         ]);
  156.     }
  158.     #[Route('/updateDevis', name: 'updateDevis')]
  159.     public function updateDevis(Request $request, EntityManagerInterface $entityManager,ValidateService $validateService,BaseService $baseService): Response
  160.     {
  161.         $chckAccess = $this->baseService->Role(54);
  162.         if($chckAccess == 0){
  163.             return $this->redirectToRoute('login');
  164.         }else if ($chckAccess == 2){
  165.             return $this->redirectToRoute('infoUtilisateur');
  166.         }
  167.         $response = "";
  168.         $id=$request->get('id');
  169.         $devis = $entityManager->getRepository(Devis::class)->find($id);
  171.         $details = $entityManager->getRepository(DetailDevis::class)->findByIdDevis($id);
  172.         $clients = $entityManager->getRepository(Client::class)->findAll();
  173.         $bureaux = $entityManager->getRepository(Bureau::class)->findAll();
  175.         return $this->render('devis/updateDevis.html.twig', [
  176.             'controller_name' => 'DevisController',
  177.             'response' => $response,
  178.             'devis' => $devis,
  179.             'details' => $details,
  180.             'clients' => $clients,
  181.             'bureaux' => $bureaux
  182.         ]);
  183.     }
  185.     #[Route('/deleteDevis/{id}/', name: 'deleteDevis')]
  186.     public function deleteDevis(Request $request, EntityManagerInterface $entityManager,$id,BaseService $baseService): Response
  187.     {
  188.         $session = new Session;
  189.         $user = $session->get('user');
  190.         $bureauSelected = $session->get('bureauSelected');
  191.         
  192.         $response = "";
  193.         $chckAccess = $this->baseService->Role(55);
  194.         if($chckAccess == 0){
  195.             $response = "Vous n'avez pas accès à cette opération";
  196.         }else if ($chckAccess == 2){
  197.             $response = "Vous n'avez pas accès à cette opération";
  198.         }
  199.         if( $response == ""){
  200.             $devis = $entityManager->getRepository(Devis::class)->find($id);
  201.     
  202.             if (!$devis) 
  203.             {
  204.                 $response = 'Desolé, ce devis est introuvable !';
  205.             } 
  206.             else 
  207.             {
  208.                 // Remove the utilisateur
  209.                 $details = $entityManager->getRepository(DetailDevis::class)->findByIdDevis($id);
  210.                 foreach ($details as $detail) {
  211.                     $entityManager->remove($detail);
  212.                 }
  213.                 
  214.                 $entityManager->remove($devis);
  215.                 $entityManager->flush();
  216.                 $baseService->addLogAction($user->getId(),'Supprimer un devis',$bureauSelected);
  217.                 $response = "ok";
  218.             }
  219.         }
  222.         return new Response($response);
  224.     }
  226.     #[Route('/addBordereau', name: 'addBordereau')]
  227.     public function addBordereau(Request $request, EntityManagerInterface $entityManager,ValidateService $validateService,
  228.     BaseService $baseService, BordereauRepository $bordereauRepository): Response
  229.     {
  230.         $chckAccess = $this->baseService->Role(59);
  231.         if($chckAccess == 0){
  232.             return $this->redirectToRoute('login');
  233.         }else if ($chckAccess == 2){
  234.             return $this->redirectToRoute('infoUtilisateur');
  235.         }
  236.         $session = new Session;
  237.         $user = $session->get('user');
  238.         $bureauSelected = $session->get('bureauSelected');
  240.         $response = "";
  241.         $clients = $entityManager->getRepository(Client::class)->findAll();
  242.         $modeles = $entityManager->getRepository(ModelBordereau::class)->findAll();
  243.         $bureaux = $entityManager->getRepository(Bureau::class)->findAll();
  245.         $num = $bordereauRepository->getNumero();
  246.         $numero = "Bord-".$num;
  249.         return $this->render('devis/addBordereau.html.twig', [
  250.             'controller_name' => 'DevisController',
  251.             'response' => $response,
  252.             'clients' => $clients,
  253.             'modeles' => $modeles,
  254.             'numero' => $numero,
  255.             'bureaux' => $bureaux
  257.         ]);
  258.     }
  260.     #[Route('/addModelBordereau', name: 'addModelBordereau')]
  261.     public function addModelBordereau(Request $request, EntityManagerInterface $entityManager,ValidateService $validateService,BaseService $baseService): Response
  262.     {
  263.         $chckAccess = $this->baseService->Role(64);
  264.         if($chckAccess == 0){
  265.             return $this->redirectToRoute('login');
  266.         }else if ($chckAccess == 2){
  267.             return $this->redirectToRoute('infoUtilisateur');
  268.         }
  269.         $response = "";
  270.         $modeles = $entityManager->getRepository(ModelBordereau::class)->findAll();
  272.         return $this->render('devis/addModelBordereau.html.twig', [
  273.             'controller_name' => 'DevisController',
  274.             'response' => $response,
  275.             'modeles' => $modeles,
  276.         ]);
  277.     }
  279.     #[Route('/addModalB', name: 'addModalB')]
  280.     public function addModalB(Request $request, EntityManagerInterface $entityManager,BaseService $baseService): Response
  281.     {
  283.         $session = new Session;
  284.         $user = $session->get('user');
  285.         $bureauSelected = $session->get('bureauSelected');
  287.         $response = "";
  288.         $columns=$request->get('columns');
  289.         $relations=$request->get('relations');
  290.         $modalTitle=$request->get('modalTitle');
  291.         $designation=$request->get('designation');
  292.         $des=$request->get('des');
  294.         $quantite=$request->get('quantite');
  295.         
  296.         $qte=$request->get('qte');
  297.         $ttl=$request->get('ttl');
  298.         $ttlTTC=$request->get('ttlttc');
  300.         $response=json_encode($des);
  302.         if($modalTitle == "" || $modalTitle == null || trim($modalTitle) == "")
  303.         {
  304.             $response = "Le champs titre est vide";
  305.         } 
  306.         else if ($des) 
  307.         {
  308.             if (($des) && $quantite){
  310.                 $ttlTTC = $ttlTTC != '' ? $ttlTTC : 'TOTAL TTC'  ;
  312.                 $modal = new ModelBordereau();
  313.                 $modal->setTitrModel($modalTitle);
  314.                 $modal->setDateCreation(new \DateTime());
  315.                 $modal->setDesignation($des);
  316.                 $modal->setTotalInPdf($ttlTTC);
  317.                 $entityManager->persist($modal);
  318.                 $entityManager->flush();
  319.         
  320.                 for($i = 0;$i < count($columns); $i++)
  321.                 {
  322.                     $infos = new InfosModalBordereau();
  323.                     $infos->setIdModal($modal->getId());
  324.                     $infos->setNomColMo($columns[$i]);
  326.                     if (isset($relations[$i])) 
  327.                     {
  328.                         $infos->setResSumCo($relations[$i]);
  329.                     }
  330.                     else
  331.                     {
  332.                         $infos->setResSumCo("");
  333.                     }
  334.                     
  335.                     if (isset($quantite) && ($quantite == $columns[$i])) 
  336.                     {
  337.                         $infos->setIsQte(1);
  338.                     }
  339.                     else
  340.                     {
  341.                         $infos->setIsQte(0);
  342.                     }
  343.                     if (isset($des) && ($des == $columns[$i])) 
  344.                     {
  345.                         $infos->setIsDes(1);
  346.                     }
  347.                     else
  348.                     {
  349.                         $infos->setIsDes(0);
  350.                     }
  352.                     // if($columns[$i] == "Quantité" && $qte!="" && $qte != null)
  353.                     // {
  354.                     //     $infos->setInPdf($qte); 
  355.                     // }
  356.                     if($columns[$i] == "Total" && $ttl!="" && $ttl != null)
  357.                     {
  358.                         $infos->setInPdf($ttl); 
  359.                     }
  360.     
  361.                     $entityManager->persist($infos);
  362.                     // Persist the Client entity and flush it to the database
  363.                     $entityManager->flush();
  364.                     $baseService->addLogAction($user->getId(),'Ajouter un modele de bordereau',$bureauSelected);
  365.     
  366.                 }
  367.     
  368.                 $response = "OK";
  369.             }
  370.             else
  371.             {
  372.                 $response = "Veuillez choisir la quantité";
  373.             }
  374.         }
  375.         else
  376.         {
  377.             $response = "Veuillez choisir la designation dans le modele";
  378.         }
  380.         return new Response($response);
  382.     }
  384.     #[Route('/getModalInfos', name: 'getModalInfos')]
  385.     public function getModalInfos(Request $request, EntityManagerInterface $entityManager,BaseService $baseService,
  386.     SerializerInterface $serializer): Response
  387.     {
  388.         $response = "";
  389.         $modeleId=$request->get('modeleId');
  390.         $modeles = $entityManager->getRepository(InfosModalBordereau::class)->findByIdModal($modeleId);
  392.         
  394.         $resultmodeles = array_values($modeles);
  396.         $modelesJson = $serializer->serialize($resultmodeles, 'json');
  398.         return new JsonResponse($modelesJson, 200, [], true);
  400.     }
  402.     #[Route('/listBordereaux', name: 'listBordereaux')]
  403.     public function listBordereaux(Request $request, EntityManagerInterface $entityManager,BaseService $baseService,): Response
  404.     {
  405.         $chckAccess = $this->baseService->Role(58);
  406.         if($chckAccess == 0){
  407.             return $this->redirectToRoute('login');
  408.         }else if ($chckAccess == 2){
  409.             return $this->redirectToRoute('infoUtilisateur');
  410.         }
  411.         $session = new Session;
  412.         $bureauSelected = $session->get('bureauSelected');
  413.        
  414.             
  415.         $borderaux = $entityManager->getRepository(Bordereau::class)->findAll();
  416.     
  417.       
  418.         $clients = $entityManager->getRepository(Client::class)->findAll();
  420.         $years = $baseService->getYears()["years"];
  421.         $months = $baseService->getYears()["months"];
  422.         $yearsFin =  (new DateTime())->format('Y');
  423.         $yearSelect = $yearsFin;
  424.         $bureaux = $entityManager->getRepository(Bureau::class)->findAll();
  426.         return $this->render('devis/listBorderaux.html.twig', [
  427.             'controller_name' => 'DevisController',
  428.             'borderaux' => $borderaux,
  429.             'clients' => $clients,
  430.             'years'=>$years,
  431.             'months'=> $months,
  432.             'yearSelect'=> $yearSelect,
  433.             'bureaux' => $bureaux
  434.         ]);
  435.     }
  437.     #[Route('/listeBorderauxArchivees', name: 'listeBordereauxArchivees')]
  438.     public function listeBordereauxArchivees(Request $request, archivesRepo $archivesRepo ,EntityManagerInterface $entityManager,BaseService $baseService): Response
  439.     {
  440.         $chckAccess = $this->baseService->Role(62);
  441.         if($chckAccess == 0){
  442.             return $this->redirectToRoute('login');
  443.         }else if ($chckAccess == 2){
  444.             return $this->redirectToRoute('infoUtilisateur');
  445.         }
  446.         $session = new Session;
  447.         $bureauSelected = $session->get('bureauSelected');
  448.       
  450.         $clients = $entityManager->getRepository(Client::class)->findAll();
  451.         
  453.         $clients = $entityManager->getRepository(Client::class)->findAll();
  455.         $years = $baseService->getYears()["years"];
  456.         $months = $baseService->getYears()["months"];
  457.         $yearsFin =  (new DateTime())->format('Y');
  458.         $yearSelect = $yearsFin;
  460.         $year = $request->get("year");
  461.         $month = $request->get("month");
  462.         // Create a DateTime object for the first day of the specified month and year
  463.         $firstDay = new \DateTime("$year-$month-01");
  464.         // Get the last day of the month by modifying the first day
  465.         $lastDay = clone $firstDay;
  466.         $lastDay->modify('last day of this month');
  467.         // Format the dates as strings in 'Y-m-d' format
  468.         $date_debut = $firstDay->format('Y-m-d') ;
  469.         $date_fin = $lastDay->format('Y-m-d');
  470.         $bordereau = $archivesRepo->getBordereau(2 , $date_debut , $date_fin  ,$bureauSelected);
  471.         return $this->render('devis/listeBorderauxArchivees.html.twig', [
  472.             'controller_name' => 'DevisController',
  473.             'Bordereau' => $bordereau,
  474.             'clients' => $clients,
  475.             'years'=>$years,
  476.             'buro'=>$bureauSelected,
  477.             'months'=> $months,
  478.             'yearSelect'=> $yearSelect
  479.         ]);
  480.     }
  482.     #[Route('/updateBordereau', name: 'updateBordereau')]
  483.     public function updateBordereau(Request $request, EntityManagerInterface $entityManager,ValidateService $validateService,BaseService $baseService): Response
  484.     {
  485.         $chckAccess = $this->baseService->Role(60);
  486.         if($chckAccess == 0){
  487.             return $this->redirectToRoute('login');
  488.         }else if ($chckAccess == 2){
  489.             return $this->redirectToRoute('infoUtilisateur');
  490.         }
  492.         $response = "";
  493.         $id=$request->get('id');
  494.         $bordereau = $entityManager->getRepository(Bordereau::class)->find($id);
  496.         $clients = $entityManager->getRepository(Client::class)->findAll();
  497.         $modeles = $entityManager->getRepository(ModelBordereau::class)->findAll();
  498.         $bureaux = $entityManager->getRepository(Bureau::class)->findAll();
  499.         $details = $entityManager->getRepository(DetailBord::class)->findByIdBord($id);
  501.         $infoLines = [];
  503.         foreach ($details as $detail) {
  504.             $idDetail = $detail->getId();
  506.             // Retrieve info details for the current detail
  507.             $infosDetailBord = $entityManager->getRepository(InfosDetailBord::class)->findByIdDeta($idDetail);
  509.             foreach ($infosDetailBord as $infoDetail) {
  510.                 $idInfo = $infoDetail->getIdInfo();
  511.                 $value = $infoDetail->getValuInfo();
  513.                 if (!isset($infoLines[$idInfo])) {
  514.                     $infoLines[$idInfo] = [];
  515.                 }
  517.                 $infoLines[$idInfo][] = [
  518.                     'idInfo' => $idInfo,
  519.                     'value' => $value,
  520.                 ];
  522.                 
  523.             }
  524.         }
  526.         return $this->render('devis/updateBordereau.html.twig', [
  527.             'controller_name' => 'DevisController',
  528.             'response' => $response,
  529.             'bordereau' => $bordereau,
  530.             'clients' => $clients,
  531.             'modeles' => $modeles,
  532.             'details' => $details,
  533.             'infoCounts' => count($details),
  534.             'infoLines' => $infoLines,
  535.             'bureaux' => $bureaux
  536.         ]);
  537.     }
  539.     #[Route('/deleteBordereau/{id}/', name: 'deleteBordereau')]
  540.     public function deleteBordereau(Request $request, EntityManagerInterface $entityManager,$id,BaseService $baseService): Response
  541.     {
  542.         $response = "";
  544.         $chckAccess = $this->baseService->Role(61);
  545.         if($chckAccess == 0){
  546.             $response = "Vous n'avez pas accès à cette opération";
  547.         }else if ($chckAccess == 2){
  548.             $response = "Vous n'avez pas accès à cette opération";
  549.         }
  550.         if( $response == ""){
  551.             $session = new Session;
  552.             $user = $session->get('user');
  553.             $bureauSelected = $session->get('bureauSelected');
  554.     
  555.             // $check =  $baseService->checkAcces('SUPPPROF');
  556.             // if($check == 1)
  557.             // {
  558.             //     $session->remove('user');
  559.             //     $session->set('isConnected',false);
  560.         
  561.             //     return $this->redirectToRoute('login'); // Redirect to 'listBureaux' route
  562.             // }
  563.             // else if ( $check == 2 )
  564.             // {
  565.             //     return $this->redirectToRoute('listBureaux'); // Redirect to 'listBureaux' route
  566.             // }
  567.             $Bordereau = $entityManager->getRepository(Bordereau::class)->find($id);
  568.     
  569.             if (!$Bordereau) 
  570.             {
  571.                 $response = 'Desolé, cette bordereau est introuvable !';
  572.             } 
  573.             else 
  574.             {
  575.                 $details = $entityManager->getRepository(DetailBord::class)->findByIdBord($id);
  576.                 foreach ($details as $detail) {
  577.                     $infosDetails = $entityManager->getRepository(InfosDetailBord::class)->findByIdDeta($detail->getId());
  578.                     foreach ($infosDetails as $info) {
  579.                         $entityManager->remove($info);
  580.                     }
  581.                     $entityManager->remove($detail);
  582.                 }
  583.                 // Remove the utilisateur
  584.                 $entityManager->remove($Bordereau);
  585.                 $entityManager->flush();
  586.                 $baseService->addLogAction($user->getId(),'Supprimer une bordereau',$bureauSelected);
  587.                 $response = "ok";
  588.             }
  589.         }
  590.         return new Response($response);
  591.     }
  593.     #[Route('/deleteModal/{id}/', name: 'deleteModal')]
  594.     public function deleteModal(Request $request, EntityManagerInterface $entityManager,$id,BaseService $baseService): Response
  595.     {
  596.         $response="";
  597.         $chckAccess = $this->baseService->Role(66);
  598.         if($chckAccess == 0){
  599.             $response = "Vous n'avez pas accès à cette opération";
  600.         }else if ($chckAccess == 2){
  601.             $response = "Vous n'avez pas accès à cette opération";
  602.         }
  603.         if( $response == ""){
  604.             $session = new Session;
  605.             $user = $session->get('user');
  606.             $bureauSelected = $session->get('bureauSelected');
  607.     
  608.             $response = "";
  609.             $modal = $entityManager->getRepository(ModelBordereau::class)->find($id);
  610.             $borderaux = $entityManager->getRepository(Bordereau::class)->findByIdModal($id);
  611.     
  612.             if(!$modal) 
  613.             {
  614.                
  615.                 $response = 'Desolé, cette modele est introuvable !';
  616.     
  617.             } 
  618.             else if($borderaux)
  619.             {
  620.                 $response = 'Desolé, cette modele est utilisé dans votre marches !';
  621.             }
  622.             else 
  623.             {
  624.                 $details = $entityManager->getRepository(InfosModalBordereau::class)->findByIdModal($id);
  625.                 foreach ($details as $detail) {
  626.                     $entityManager->remove($detail);
  627.                 }
  628.     
  629.                 // Remove the utilisateur
  630.                 $entityManager->remove($modal);
  631.                 $entityManager->flush();
  632.                 $baseService->addLogAction($user->getId(),'Supprimer un modele de borderau',$bureauSelected);
  633.     
  634.                 $response = "ok";
  635.                 
  636.             }
  637.         }
  639.         return new Response($response);
  641.     }
  643.     #[Route('/valideDevis/{id}/', name: 'valideDevis')]
  644.     public function valideDevis(Request $request, EntityManagerInterface $entityManager,$id,BaseService $baseService): Response
  645.     {
  646.         $response='';
  647.         $chckAccess = $this->baseService->Role(119);
  648.         if($chckAccess == 0){
  649.             $response = "Vous n'avez pas accès à cette opération";
  650.         }else if ($chckAccess == 2){
  651.             $response = "Vous n'avez pas accès à cette opération";
  652.         }
  654.         if( $response == ""){
  655.             $session = new Session;
  656.             $user = $session->get('user');
  657.             $bureauSelected = $session->get('bureauSelected');
  658.     
  659.             $response = "";
  660.             $devis = $entityManager->getRepository(Devis::class)->find($id);
  661.     
  662.             if (!$devis) 
  663.             {
  664.                 $response = 'Desolé, cette devis est introuvable !';
  665.             } 
  666.             else 
  667.             {
  668.                 $devis->setEtatDevis(1);
  669.     
  670.                 $marche = new Marche();
  671.                 $marche->setNumeMarc($devis->getNumeDevi());
  672.                 $marche->setDateCreation(new \DateTime());
  673.                 $marche->setObjeMarc($devis->getObjeDevi());
  674.                 $marche->setTotalHt($devis->getTotalTh());
  675.                 $marche->setTotalTtc($devis->getTotalTtc());
  676.                 $marche->setTva($devis->getTva());
  677.                 $marche->setEtatMarc(0);
  678.                 $marche->setIdClient($devis->getIdClient());
  679.                 $marche->setTypeMarc(1);
  680.                 $marche->setIdDevis($devis->getId());
  681.                 $marche->setdescMarc("");
  682.                 $marche->setModePaie(0);
  683.                 $marche->setDateDebut(new \DateTime());
  684.                 $marche->setDateFin(new \DateTime());
  685.                 $entityManager->persist($marche);
  686.     
  687.                 $entityManager->flush();
  688.     
  689.                 $marche_bureau = new BureauMarche();
  690.                 $marche_bureau->setIdMarche($marche->getId());
  691.                 $marche_bureau->setIdBureau($bureauSelected);
  692.                 $entityManager->persist($marche_bureau);
  693.                 $entityManager->flush();
  694.                 $baseService->addLogAction($user->getId(),'Valider un devis',$bureauSelected);
  695.     
  696.                 $response = "ok";
  697.      
  698.             }
  699.         }
  701.         return new Response($response);
  703.     }
  705.     #[Route('/valideBordereau/{id}/', name: 'valideBordereau')]
  706.     public function valideBordereau(Request $request, EntityManagerInterface $entityManager,$id,BaseService $baseService): Response
  707.     {
  708.         $response='';
  709.         $chckAccess = $this->baseService->Role(120);
  710.         if($chckAccess == 0){
  711.             $response = "Vous n'avez pas accès à cette opération";
  712.         }else if ($chckAccess == 2){
  713.             $response = "Vous n'avez pas accès à cette opération";
  714.         }
  715.         if($response == ""){
  716.             $session = new Session;
  717.             $user = $session->get('user');
  718.             $bureauSelected = $session->get('bureauSelected');
  719.     
  720.             $response = "";
  721.             $bordereau = $entityManager->getRepository(Bordereau::class)->find($id);
  722.     
  723.             if (!$bordereau) 
  724.             {
  725.                
  726.                 $response = 'Desolé, cette bordereau est introuvable !';
  727.     
  728.             } 
  729.             else 
  730.             {
  731.     
  732.                 $bordereau->setEtatBord(1);
  733.     
  734.                 $marche = new Marche();
  735.                 $marche->setNumeMarc($bordereau->getNumeAo());
  736.                 $marche->setDateCreation(new \DateTime());
  737.                 $marche->setObjeMarc($bordereau->getObjeBord());
  738.                 $marche->setTotalHt($bordereau->getTotalHt());
  739.                 $marche->setTotalTtc($bordereau->getTotalTtc());
  740.                 $marche->setTva($bordereau->getTva());
  741.                 $marche->setEtatMarc(0);
  742.                 $marche->setIdClient($bordereau->getIdClient());
  743.                 $marche->setTypeMarc(2);
  744.                 $marche->setIdDevis($bordereau->getId());
  745.                 $marche->setdescMarc("");
  746.                 $marche->setModePaie(0);
  747.                 $marche->setDateDebut(new \DateTime());
  748.                 $marche->setDateFin(new \DateTime());
  749.                 $entityManager->persist($marche);
  750.                 $entityManager->flush();
  751.     
  752.                 $marche_bureau = new BureauMarche();
  753.                 $marche_bureau->setIdMarche($marche->getId());
  754.                 $marche_bureau->setIdBureau($bureauSelected);
  755.                 $entityManager->persist($marche_bureau);
  756.                 $entityManager->flush();
  757.                 $baseService->addLogAction($user->getId(),'Valider une bordereau de prix',$bureauSelected);
  758.                 $response = "ok";
  759.       
  760.             }
  761.         }
  763.         return new Response($response);
  765.     }
  767.     #[Route('/archiverDevis/{id}/', name: 'archiverDevis')]
  768.     public function archiverDevis(Request $request, EntityManagerInterface $entityManager,
  769.     BaseService $baseService,$id): Response
  770.     {
  771.         $response='';
  772.         $chckAccess = $this->baseService->Role(57);
  773.         if($chckAccess == 0){
  774.             $response = "Vous n'avez pas accès à cette opération";
  775.         }else if ($chckAccess == 2){
  776.             $response = "Vous n'avez pas accès à cette opération";
  777.         }
  778.         if( $response == ""){
  779.             $session = new Session;
  780.             $user = $session->get('user');
  781.             $bureauSelected = $session->get('bureauSelected');
  782.             $devis = $entityManager->getRepository(Devis::class)->find($id);
  783.     
  784.             if (!$devis) 
  785.             {
  786.                
  787.                 $response = 'Desolé, ce devis est introuvable !';
  788.             } 
  789.             else 
  790.             {
  791.     
  792.                 // Toggle the etatBure (change status)
  793.                 $devis->setEtatDevis(2);
  794.                 $baseService->addLogAction($user->getId(),'Archiver un devis',$bureauSelected);
  795.     
  796.                 // Persist the changes
  797.                 $entityManager->flush();
  798.     
  799.                 $response = "ok";
  800.             }
  801.         }
  803.         return new Response($response);
  805.     }
  807.     #[Route('/archiverBord/{id}/', name: 'archiverBord')]
  808.     public function archiverBord(Request $request, EntityManagerInterface $entityManager,
  809.     BaseService $baseService,$id): Response
  810.     {
  811.         $response='';
  812.         $chckAccess = $this->baseService->Role(67);
  813.         if($chckAccess == 0){
  814.             $response = "Vous n'avez pas accès à cette opération";
  815.         }else if ($chckAccess == 2){
  816.             $response = "Vous n'avez pas accès à cette opération";
  817.         }
  818.         if( $response == ""){
  819.             $session = new Session;
  820.             $user = $session->get('user');
  821.             $bureauSelected = $session->get('bureauSelected');
  822.             $bord = $entityManager->getRepository(Bordereau::class)->find($id);
  823.     
  824.             if (!$bord) 
  825.             {
  826.                
  827.                 $response = 'Desolé, cette bordereau de prix est introuvable !';
  828.             } 
  829.             else 
  830.             {
  831.     
  832.                 // Toggle the etatBure (change status)
  833.                 $bord->setEtatBord(2);
  834.     
  835.                 // Persist the changes
  836.                 $entityManager->flush();
  837.                 $baseService->addLogAction($user->getId(),'Archiver une bordereau',$bureauSelected);
  838.     
  839.                 $response = "ok";
  840.                 
  841.             }
  842.         }
  844.         return new Response($response);
  846.     }
  848.     #[Route('/pdfDevis/{id}/', name: 'pdfDevis')]
  849.     public function pdfDevis(Request $request, EntityManagerInterface $entityManager,$id)
  850.     {
  851.         $chckAccess = $this->baseService->Role(121);
  852.         if($chckAccess == 0){
  853.             return $this->redirectToRoute('login');
  854.         }else if ($chckAccess == 2){
  855.             return $this->redirectToRoute('infoUtilisateur');
  856.         }
  857.         $devis =  $entityManager->getRepository(Devis::class)->find($id);
  858.         $detailsBonCommande =  $entityManager->getRepository(DetailDevis::class)->findByIdDevis($id);
  859.         $client = $entityManager->getRepository(Client::class)->find($devis->getIdClient());
  861.         if(!$client || !$detailsBonCommande || !$devis){
  862.             return $this->redirectToRoute('listDevis');
  863.         }
  864.         
  865.         $totalHt = 0;
  866.         $totalTva = 0;
  867.         $tauxTva = $devis->getTva(); 
  868.         foreach ($detailsBonCommande as $detail) {
  869.             $qte = $detail->getQte(); 
  870.             $prixUnitaire = $detail->getTotalHt(); 
  871.             $totalDetailHt = $qte * $prixUnitaire;
  872.             $totalHt += $totalDetailHt;
  873.             $totalTva += $prixUnitaire * ($tauxTva / 100);
  874.         }
  876.         // Render the view
  877.         $htmlContent = $this->renderView('devis/devisPDF.html.twig', [
  878.             'd' => $devis,
  879.             'details' => $detailsBonCommande,
  880.             'client' => $client,
  881.             'totalTva' => number_format($totalTva, 2, '.', '')
  882.         ]);
  883.         $html2pdf = new Html2Pdf();
  884.         $html2pdf->writeHTML($htmlContent);
  885.         $pdfOutput = $html2pdf->output();
  886.         $response = new Response($pdfOutput);
  887.         $response->headers->set('Content-Type', 'application/pdf');
  888.         $response->headers->set('Content-Disposition', 'inline; filename=bon_commande.pdf');
  890.         return $response;
  892.      
  894.     }
  896.     #[Route('/pdfBordereau/{id}/', name: 'pdfBordereau')]
  897.     public function pdfBordereau(Request $request, EntityManagerInterface $entityManager, BordereauRepository $repo,$id)
  898.     {
  899.         $session = new Session();
  900.         $chckAccess = $this->baseService->Role(122);
  901.         if($chckAccess == 0){
  902.             return $this->redirectToRoute('login');
  903.         }else if ($chckAccess == 2){
  904.             return $this->redirectToRoute('infoUtilisateur');
  905.         }
  906.         $bordereau = $entityManager->getRepository(Bordereau::class)->find($id);
  907.         $model = $entityManager->getRepository(ModelBordereau::class)->find($bordereau->getIdModal());
  908.         $client = $entityManager->getRepository(Client::class)->find($bordereau->getIdClient());
  909.         $infos = $entityManager->getRepository(InfosModalBordereau::class)->findByIdModal($bordereau->getIdModal());
  910.         $details = $entityManager->getRepository(DetailBord::class)->findByIdBord($id);
  911.         $idBureau = $session->get('bureauSelected');
  912.         $bureau = $entityManager->getRepository(Bureau::class)->find($idBureau); 
  913.         $infoLines = [];
  915.         foreach ($details as $detail) {
  916.             $idDetail = $detail->getId();
  918.             // Retrieve info details for the current detail
  919.             $infosDetailBord = $entityManager->getRepository(InfosDetailBord::class)->findByIdDeta($idDetail);
  921.             foreach ($infosDetailBord as $infoDetail) {
  922.                 $idInfo = $infoDetail->getIdInfo();
  923.                 $value = $infoDetail->getValuInfo();
  925.                 if (!isset($infoLines[$idInfo])) {
  926.                     $infoLines[$idInfo] = [];
  927.                 }
  929.                 $infoLines[$idInfo][] = [
  930.                     'idInfo' => $idInfo,
  931.                     'value' => $value,
  932.                 ];
  934.                 
  935.             }
  936.         }
  938.         // Merge $infos with $infoLines based on 'id' property
  939.         $mergedInfo = [];
  940.         foreach ($infos as $info) {
  941.             $idInfo = $info->getId();
  942.             $mergedInfo[$idInfo] = [
  943.                 'idInfo' => $idInfo,
  944.                 'nomColMo' => $info->getNomColMo(),
  945.                 'resSumCo' => $info->getResSumCo(),
  946.                 'inPdf' => $info->getInPdf(),
  947.                 'isDes' => $info->getIsDes(),
  948.                 'isQte' => $info->getIsQte(),
  949.                 'values' => isset($infoLines[$idInfo]) ? $infoLines[$idInfo] : [],
  950.             ];
  951.         }
  953.         $htmlContent = $this->renderView('devis/bordereauPDF.html.twig', [
  954.             'd' => $bordereau,
  955.             'mergedInfo' => $mergedInfo,
  956.             'client' => $client,
  957.             'model' => $model,
  958.             'bureau'=>$bureau
  959.         ]);
  960.         
  961.         $html2pdf = new Html2Pdf();
  962.         $html2pdf->writeHTML($htmlContent);
  963.         $pdfOutput = $html2pdf->output();
  964.         $response = new Response($pdfOutput);
  965.         $response->headers->set('Content-Type', 'application/pdf');
  966.         $response->headers->set('Content-Disposition', 'inline; filename=bon_commande.pdf');
  968.         return $response;
  969.     }
  972.     #[Route('/ajaxUpdateDevis', name: 'ajaxUpdateDevis')]
  973.     public function ajaxUpdateBonCommande(Request $request, EntityManagerInterface $entityManager, SerializerInterface $serializer,
  974.     ValidateService $validateService,DevisRepository $devisRepository,BaseService $baseService): Response
  975.     {
  976.         $response = "";
  977.         $chckAccess = $this->baseService->Role(54);
  978.         if($chckAccess == 0){
  979.             $response = "Vous n'avez pas accès à cette opération";
  980.         }else if ($chckAccess == 2){
  981.             $response = "Vous n'avez pas accès à cette opération";
  982.         }
  983.         if( $response == ""){
  984.             $session = new Session;
  985.             $user = $session->get('user');
  986.             $bureauSelected = $session->get('bureauSelected');
  988.             $response = "";
  989.             $num = $devisRepository->getNumero();
  991.             $id=$request->get('id');
  992.             $devis = $entityManager->getRepository(Devis::class)->find($id);
  993.             $details = $entityManager->getRepository(DetailDevis::class)->findByIdDevis($id);
  994.     
  995.             $client=$request->get('client');
  996.             $numero=$request->get('numero');
  997.             $objet=$request->get('objet');
  998.             $tva=$request->get('tva');
  999.             $date=$request->get('date');
  1000.             $objetDetail=$request->get('objetDetail');
  1001.             $qteDetail=$request->get('qteDetail');
  1002.             $totalThDetail=$request->get('totalThDetail');
  1003.             $hht=$request->get('hht');
  1004.             $httc=$request->get('httc');
  1005.             if($bureauSelected == 0)
  1006.             {
  1007.                 $bureau=$request->get('bureau');
  1008.             }
  1010.             $contraintes = array(
  1011.                 "numero" => array("val" => $numero, "length" => 255, "type" => "string", "isBlank" => true),
  1012.                 "objet" => array("val" => $objet, "length" => 255, "type" => "string", "isBlank" => true),
  1013.                 "totalThDetail" => array("val" => $hht, "type" => "float", "isBlank" => true),
  1014.             );
  1016.             $valideDevis = $validateService->validateur($contraintes);
  1017.             if($valideDevis === true)
  1018.             {
  1020.                 $dv = $entityManager->getRepository(Devis::class)->findBy(array("refeDevi" => $numero));
  1021.                 if($numero!=  $devis->getRefeDevi() && $dv)
  1022.                 {
  1023.                     $response = 'Cette référence de devis est déjà exist, Veuillez vérifier s\'il vous plaît.';
  1024.                 }
  1025.                 else
  1026.                 {
  1027.                     $checkDetail = 0;
  1028.                     for ($k=0; $k < count($objetDetail); $k++) { 
  1029.                         if(empty(trim($objetDetail[$k])) == " "){
  1030.                             $checkDetail = 1;
  1031.                             // break;
  1032.                         }
  1033.                     }
  1034.                     if($checkDetail == 0){
  1035.                         for ($k=0; $k < count($totalThDetail); $k++) { 
  1036.                             if(empty(trim($totalThDetail[$k])) == " "){
  1037.                                 if(!is_numeric($totalThDetail[$k])){
  1038.                                     $checkDetail = 1;
  1039.                                 }
  1040.                                 // break;
  1041.                             }
  1042.                         }
  1043.                         for ($k=0; $k < count($qteDetail); $k++) { 
  1044.                             if(empty(trim($qteDetail[$k])) == " "){
  1045.                                 $checkDetail = 1;
  1046.                                 // break;
  1047.                             }
  1048.                         }
  1049.                     }
  1050.                     
  1051.                     if($checkDetail == 0){
  1052.                         
  1053.                         $devis->setRefeDevi($numero);
  1054.                         $devis->setIdClient($client);
  1055.                         $devis->setObjeDevi($objet);
  1056.                         $devis->setTotalTh($hht);
  1057.                         $devis->setTotalTtc($httc);
  1058.                         $devis->setTva($tva);
  1059.                         $devis->setDateEcheance( new \DateTime($date));
  1060.         
  1061.                         foreach($details as $detail)
  1062.                         {
  1063.                             $entityManager->remove($detail);
  1064.         
  1065.                         }
  1066.         
  1067.                         for($i=0;$i<count($objetDetail);$i++)
  1068.                         {
  1069.         
  1070.                             $detail = new DetailDevis();
  1071.                             $detail->setIdDevis($devis->getId());
  1072.                             $detail->setTotalHt($totalThDetail[$i]);
  1073.                             $detail->setdescDetDev($objetDetail[$i]);
  1074.                             $detail->setQte($qteDetail[$i]);
  1075.                             $entityManager->persist($detail);
  1076.                             // Persist the Client entity and flush it to the database
  1077.             
  1078.                         }
  1079.         
  1080.         
  1081.                         $entityManager->flush();
  1082.                         $baseService->addLogAction($user->getId(),'Modifier un devis',$bureauSelected);
  1083.         
  1084.                         $response = 'ok';
  1085.                     }else{
  1086.                         $response = 'Veuillez vérifier vos details devis !';
  1087.                     }    
  1089.                 }
  1091.             }
  1092.             else
  1093.             {
  1095.                 $response = 'Veuillez vérifier vos informations, un des champs est incorrect !';
  1096.             }
  1098.             
  1099.         }
  1100.         return new Response($response);
  1102.     }
  1104.     #[Route('/ajaxAddDevis', name: 'ajaxAddDevis')]
  1105.     public function ajaxAddBonCommande(Request $request, EntityManagerInterface $entityManager, SerializerInterface $serializer,
  1106.     ValidateService $validateService,DevisRepository $devisRepository,BaseService $baseService): Response
  1107.     {
  1108.             $response = "";
  1109.             $chckAccess = $this->baseService->Role(53);
  1110.             if($chckAccess == 0){
  1111.                 $response = "Vous n'avez pas accès à cette opération";
  1112.             }else if ($chckAccess == 2){
  1113.                 $response = "Vous n'avez pas accès à cette opération";
  1114.             }
  1115.             if( $response == ""){
  1116.     
  1117.                 $session = new Session;
  1118.                 $user = $session->get('user');
  1119.                 $bureauSelected = $session->get('bureauSelected');
  1120.     
  1121.                 $num = $devisRepository->getNumero();
  1122.     
  1123.         
  1124.                 $client=$request->get('client');
  1125.                 $numero=$request->get('numero');
  1126.                 $objet=$request->get('objet');
  1127.                 $tva=$request->get('tva');
  1128.                 $date=$request->get('date');
  1129.                 $objetDetail=$request->get('objetDetail');
  1130.                 $qteDetail=$request->get('qteDetail');
  1131.                 $totalThDetail=$request->get('totalThDetail');
  1132.                 $hht=$request->get('hht');
  1133.                 $httc=$request->get('httc');
  1134.                 if($bureauSelected == 0)
  1135.                 {
  1136.                     $bureau=$request->get('bureau');
  1137.                 }
  1138.                 
  1139.                 $contraintes = array(
  1140.                     "numero" => array("val" => $numero, "length" => 255, "type" => "string", "isBlank" => true),
  1141.                     "objet" => array("val" => $objet, "length" => 255, "type" => "string", "isBlank" => true),
  1142.                     "totalThDetail" => array("val" => $hht, "type" => "float", "isBlank" => true),
  1143.                 );
  1144.     
  1145.                 $valideDevis = $validateService->validateur($contraintes);
  1146.                 if($valideDevis === true)
  1147.                 {
  1148.                     $dv = $entityManager->getRepository(Devis::class)->findBy(array("refeDevi" => $numero));
  1149.                     if($dv)
  1150.                     {
  1151.                         $response = 'Cette référence de devis est déjà exist, Veuillez vérifier s\'il vous plaît.';
  1152.                     }
  1153.                     else
  1154.                     {
  1155.                         $checkDetail = 0;
  1156.                         for ($k=0; $k < count($objetDetail); $k++) { 
  1157.                             if(empty(trim($objetDetail[$k])) == " "){
  1158.                                 $checkDetail = 1;
  1159.                                 // break;
  1160.                             }
  1161.                         }
  1162.                         if($checkDetail == 0){
  1163.                             for ($k=0; $k < count($totalThDetail); $k++) { 
  1164.                                 if(empty(trim($totalThDetail[$k])) == " "){
  1165.                                     $checkDetail = 1;
  1166.                                     // break;
  1167.                                 }
  1168.                             }
  1169.                             for ($k=0; $k < count($qteDetail); $k++) { 
  1170.                                 if(empty(trim($qteDetail[$k])) == " "){
  1171.                                     $checkDetail = 1;
  1172.                                     // break;
  1173.                                 }
  1174.                             }
  1175.                         }
  1177.                         if($checkDetail == 0){
  1178.                             $checkHT = true;
  1179.                             foreach ($totalThDetail as $value) {
  1180.                                 if(!is_numeric($value)){
  1181.                                     $checkHT = false;
  1182.                                     break;
  1183.                                 }
  1184.                             }
  1185.                             if($checkHT){
  1187.                                 $devis = new Devis();
  1188.                                 $devis->setNumeDevi($num);
  1189.                                 $devis->setDateCreation(new \DateTime());
  1190.                                 $devis->setIdClient($client);
  1191.                                 $devis->setObjeDevi($objet);
  1192.                                 $devis->setTotalTh($hht);
  1193.                                 $devis->setTotalTtc($httc);
  1194.                                 $devis->setTva($tva);
  1195.                                 $devis->setEtatDevis(0);
  1196.                                 $devis->setRefeDevi($numero);
  1197.                                 $devis->setYear(date('Y'));
  1198.         
  1199.                                 $devis->setDateEcheance( new \DateTime($date));
  1200.                                 $entityManager->persist($devis);
  1201.                                 // Persist the Client entity and flush it to the database
  1202.                                 $entityManager->flush();
  1203.                                 $baseService->addLogAction($user->getId(),'Ajouter un devis',$bureauSelected);
  1204.                 
  1205.                                 for($i=0;$i<count($objetDetail);$i++)
  1206.                                 {
  1207.                                     $detail = new DetailDevis();
  1208.                                     $detail->setIdDevis($devis->getId());
  1209.                                     $detail->setTotalHt($totalThDetail[$i]);
  1210.                                     $detail->setdescDetDev($objetDetail[$i]);
  1211.                                     $detail->setQte($qteDetail[$i]);
  1212.                                     
  1213.                                     $entityManager->persist($detail);
  1214.                                     // Persist the Client entity and flush it to the database
  1215.                                     $entityManager->flush();
  1216.                                 }
  1217.                 
  1218.                                 $response = 'ok';
  1219.                             }
  1220.                             else
  1221.                             {
  1222.                                 $response = 'Veuillez vérifier vos details devis !';
  1223.                             }
  1224.                         }else{
  1225.                             $response = 'Veuillez vérifier vos details devis !';
  1226.                         }
  1227.                     }
  1228.                 }
  1229.                 else
  1230.                 {
  1231.                     $response = 'Veuillez vérifier vos informations, un des champs est incorrect !';
  1232.                 }
  1233.             }
  1234.         
  1235.         return new Response($response);
  1236.     }
  1238.     #[Route('/ajaxAddBord', name: 'ajaxAddBord')]
  1239.     public function ajaxAddBord(Request $request, EntityManagerInterface $entityManager, SerializerInterface $serializer,
  1240.     ValidateService $validateService, BordereauRepository $bordereauRepository,BaseService $baseService): Response
  1241.     {
  1242.         $session = new Session;
  1243.         $user = $session->get('user');
  1244.         $bureauSelected = $session->get('bureauSelected');
  1246.         $response = "";
  1247.         $num = $bordereauRepository->getNumero();
  1249.         $client= $request->get('client');
  1250.         $numero= $request->get('numerobord');
  1251.         $objet= $request->get('objet');
  1252.         $tva= $request->get('tva');
  1253.         $date= $request->get('date');
  1254.         $htt= $request->get('hht');
  1255.         $httc= $request->get('httc');
  1256.         $modele= $request->get('modele');
  1258.         if($bureauSelected == 0)
  1259.         {
  1260.             $bureau=$request->get('bureau');
  1261.         }
  1262.         $modal = $entityManager->getRepository(ModelBordereau::class)->find($modele);
  1263.         
  1264.         if(!$modal)
  1265.         {
  1266.             $response = 'Merci de choisir un modèle de bordereau.';
  1267.         }
  1268.         else
  1269.         {
  1270.             $qteName = $entityManager->getRepository(InfosModalBordereau::class)->findOneBy(['idModal'=>$modele ,'isQte'=>1]);
  1272.             // $response = json_encode($qteName->getNomColMo());
  1273.             $contraintes = array(
  1274.                 "numero" => array("val" => $numero, "length" => 255, "type" => "string", "isBlank" => true),
  1275.                 "objet" => array("val" => $objet, "length" => 255, "type" => "string", "isBlank" => true),
  1276.                 "htt" => array("val" =>  $htt, "type" => "float", "isBlank" => true),
  1277.                 "httc" => array("val" => $httc, "type" => "float", "isBlank" => true),
  1278.             );
  1280.             $valideBordereau = $validateService->validateur($contraintes);
  1282.             if($valideBordereau === true)
  1283.             {
  1285.                 $br = $entityManager->getRepository(Bordereau::class)->findBy(array("refeBord" => $numero));
  1286.                 if($br)
  1287.                 {
  1288.                     $response = 'Cette référence de bordereau est déjà exist, Veuillez vérifier s\'il vous plaît.';
  1289.                 }
  1290.                 else
  1291.                 {
  1292.                     $total = $request->get('total');
  1293.                     $des = $modal->getDesignation();
  1294.                     $designation = $request->get(strtolower(str_replace(' ','_',$des)));
  1295.                     $count = count($total);
  1296.                     $checkDetail = true;
  1298.                     for ($i = 0; $i < $count; $i++) {
  1299.                         if(empty(trim($total[$i])) or  ($total[$i] < 0) or empty(trim($designation[$i]))  ) 
  1300.                         {
  1301.                             $checkDetail = false;
  1302.                             break;
  1303.                         }
  1304.                     }
  1306.                     if($checkDetail == true){
  1307.                         $bordereau = new Bordereau();
  1308.                         $bordereau->setNumeAo($num);
  1309.                         $bordereau->setDateCreation(new \DateTime());
  1310.                         $bordereau->setIdClient($client);
  1311.                         $bordereau->setObjeBord($objet);
  1312.                         $bordereau->setTotalHt($htt);
  1313.                         $bordereau->setTotalTtc($httc);
  1314.                         $bordereau->setTva($tva);
  1315.                         $bordereau->setEtatBord(0);
  1316.                         $bordereau->setIdModal($modele);
  1317.                         $bordereau->setDateEcheance(new \DateTime($date));
  1318.                         $bordereau->setRefeBord($numero);
  1319.         
  1320.                         $entityManager->persist($bordereau);
  1321.                         // Persist the Client entity and flush it to the database
  1322.                         $entityManager->flush();
  1323.             
  1324.                         $infosModalBordereau = $entityManager->getRepository(InfosModalBordereau::class)->findByIdModal($modele);
  1325.     
  1326.                         $des = $modal->getDesignation();
  1327.                         $total = $request->get('total');
  1328.                         $qte = $request->get(strtolower($qteName->getNomColMo()));
  1329.                         $designation = $request->get(strtolower(str_replace(' ','_',$des)));
  1330.     
  1331.                         $count = count($total);
  1332.     
  1333.                         for ($i = 0; $i < $count; $i++) {
  1334.                             $detail = new DetailBord();
  1335.                             $detail->setIdBord($bordereau->getId());
  1336.                             $detail->setTotal($total[$i]);
  1337.                             $detail->setQte($qte[$i]);
  1338.                             $detail->setObjet($designation[$i]);
  1339.                             $entityManager->persist($detail);
  1340.                             $entityManager->flush();
  1341.                             
  1342.                             foreach ($infosModalBordereau as $info) {
  1343.                                 $name =strtolower($info->getNomColMo());
  1344.                                 $idInfo = $info->getId();
  1345.                                 $modeleValues = $request->get(str_replace(' ','_',$name));
  1346.     
  1347.                                 $infosDetailBord = new InfosDetailBord();
  1348.                                 $infosDetailBord->setIdDeta($detail->getId());
  1349.                                 $infosDetailBord->setIdInfo($idInfo);
  1350.                                 $infosDetailBord->setValuInfo($modeleValues[$i]);
  1351.                                 $entityManager->persist($infosDetailBord);
  1352.                                 $entityManager->flush();
  1353.                             }
  1354.                         }
  1355.                         $entityManager->flush();
  1356.                         $baseService->addLogAction($user->getId(),'Ajouter un bordereau',$bureauSelected);
  1357.                         $response= 'ok';
  1358.                     }else{
  1359.                         $response = 'Veuillez vérifier votre details saisie !';
  1360.                     }
  1361.                 }
  1362.             }
  1363.             else
  1364.             {
  1366.                 $response = 'Veuillez vérifier vos informations, un des champs est incorrect !';
  1367.             }
  1368.             
  1370.         }
  1371.         return new Response($response);
  1372.     }
  1374.     #[Route('/ajaxUpdateBord', name: 'ajaxUpdateBord')]
  1375.     public function ajaxUpdateBord(Request $request, EntityManagerInterface $entityManager, SerializerInterface $serializer,
  1376.     ValidateService $validateService,BaseService $baseService): Response
  1377.     {
  1379.             $session = new Session;
  1380.             $user = $session->get('user');
  1381.             $bureauSelected = $session->get('bureauSelected');
  1383.             $response = "";
  1385.             $id=$request->get('id');
  1386.             $bordereau = $entityManager->getRepository(Bordereau::class)->find($id);
  1387.             $details = $entityManager->getRepository(DetailBord::class)->findByIdBord($id);
  1388.         
  1389.             $client= $request->get('client');
  1390.             $numero= $request->get('numerobord');
  1391.             $objet= $request->get('objet');
  1392.             $tva= $request->get('tva');
  1393.             $date= $request->get('date');
  1394.             $htt= $request->get('hht');
  1395.             $httc= $request->get('httc');
  1396.             $modele= $request->get('modele');
  1398.             if($bureauSelected == 0)
  1399.             {
  1400.                 $bureau=$request->get('bureau');
  1401.             }
  1403.             $modal = $entityManager->getRepository(ModelBordereau::class)->find($modele);
  1404.             $qteName = $entityManager->getRepository(InfosModalBordereau::class)->findOneBy(['idModal'=>$modele , 'isQte'=>1]);
  1406.             if(!$modal)
  1407.             {
  1409.                 $response = 'Merci de choisir un modèle de bordereau.';
  1411.             }
  1412.             else
  1413.             {
  1414.                 $contraintes = array(
  1415.                     "numero" => array("val" => $numero, "length" => 255, "type" => "string", "isBlank" => true),
  1416.                     "objet" => array("val" => $objet, "length" => 255, "type" => "string", "isBlank" => true),
  1417.                     "htt" => array("val" =>  $htt, "type" => "float", "isBlank" => true),
  1418.                     "httc" => array("val" =>  $httc, "type" => "float", "isBlank" => true),
  1419.                 );
  1421.                 $valideBordereau = $validateService->validateur($contraintes);
  1422.                 if($valideBordereau === true)
  1423.                 {
  1425.                     $br = $entityManager->getRepository(Bordereau::class)->findBy(array("refeBord" => $numero));
  1426.                     if($numero!=  $bordereau->getRefeBord() && $br)
  1427.                     {
  1428.                         $response = 'Cette référence de bordereau est déjà exist, Veuillez vérifier s\'il vous plaît.';
  1429.                     }
  1430.                     else
  1431.                     {
  1433.                         $bordereau->setRefeBord($numero);
  1434.                         $bordereau->setDateCreation(new \DateTime());
  1435.                         $bordereau->setIdClient($client);
  1436.                         $bordereau->setObjeBord($objet);
  1437.                         $bordereau->setTotalHt($htt);
  1438.                         $bordereau->setTotalTtc($httc);
  1439.                         $bordereau->setTva($tva);
  1440.                         $bordereau->setEtatBord(0);
  1441.                         $bordereau->setDateEcheance(new \DateTime($date));
  1442.     
  1443.             
  1444.                         foreach ($details as $detail) {
  1446.                             $infosDetails = $entityManager->getRepository(InfosDetailBord::class)->findByIdDeta($detail->getId());
  1447.                             foreach ($infosDetails as $info) {
  1448.                                 $entityManager->remove($info);
  1449.                             }
  1450.                             $entityManager->remove($detail);
  1452.                         }
  1453.                         
  1454.                         $infosModalBordereau = $entityManager->getRepository(InfosModalBordereau::class)->findByIdModal($modele);
  1455.                         $des = $modal->getDesignation();
  1456.                         $total = $request->get('total');
  1457.                         $qte = $request->get(strtolower($qteName->getNomColMo()));
  1458.                         $designation = strtolower($des); //$request->get(strtolower($des));
  1459.                         $count = count($total);
  1460.                         
  1461.                         for ($i = 0; $i < $count; $i++) {
  1462.                             
  1463.                             if (empty(trim($qte[$i]))) {
  1464.                                 return new Response('La quantité ne peut pas être vide ou contenir uniquement des espaces.');
  1465.                             }
  1467.                             $detail = new DetailBord();
  1468.                             $detail->setIdBord($bordereau->getId());
  1469.                             $detail->setTotal($total[$i]);
  1470.                             $detail->setObjet(utf8_encode($designation));
  1471.                             $detail->setQte($qte[$i]);
  1472.                             $entityManager->persist($detail);
  1473.                             $entityManager->flush();
  1474.     
  1475.                             foreach ($infosModalBordereau as $info) {
  1476.                                 $name = strtolower(trim(str_replace(" ","_",$info->getNomColMo())));
  1477.                                 $idInfo = $info->getId();
  1478.                                 $modeleValues = $request->get($name);
  1479.     
  1480.                                 $infosDetailBord = new InfosDetailBord();
  1481.                                 $infosDetailBord->setIdDeta($detail->getId());
  1482.                                 $infosDetailBord->setIdInfo($idInfo);
  1483.                                 $infosDetailBord->setValuInfo($modeleValues[$i]);
  1484.                                 $entityManager->persist($infosDetailBord);
  1485.                                 $entityManager->flush();
  1486.                             }
  1487.                         }
  1488.                         
  1489.                         $entityManager->flush();
  1490.                         $baseService->addLogAction($user->getId(),'Modifier un bordereau',$bureauSelected);
  1491.     
  1492.                         $response = "ok";
  1494.                     }
  1496.                 }
  1497.                 else
  1498.                 {
  1500.                     $response = 'Veuillez vérifier vos informations, un des champs est incorrect !';
  1501.                 }
  1503.             }
  1505.         return new Response($response);
  1506.     }
  1508. }