src/Controller/DepotDossierController.php line 803

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\DepotDossier;
  6. use App\Entity\Notifications;
  7. use App\Entity\CommentairesControlle;
  8. use App\Entity\Planning;
  9. use App\Form\DepotDossierType;
  10. use App\Repository\DepotDossierRepository;
  11. use App\Repository\DealRepository;
  12. use App\Repository\PlanningRepository;
  13. use App\Repository\OperationStandardRepository;
  14. use App\Repository\ChampsDepotDossierRepository;
  15. use App\Repository\ChampsDeaufDepotDossierRepository;
  16. use App\Repository\EquipeRepository;
  17. use App\Repository\InstallateurRepository;
  18. use App\Repository\ObligesRepository;
  19. use App\Repository\NotificationsRepository;
  20. use App\Repository\CommentairesControlleRepository;
  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 App\Entity\ChampsDepotDossier;
  26. use App\Entity\Filtre;
  27. use App\Entity\FactureAaf;
  28. use App\Repository\FiltreRepository;
  29. use App\Repository\FactureAafRepository;
  30. use Datetime;
  31. use Symfony\Component\Security\Csrf\CsrfTokenManagerInterface;
  32. use Symfony\Component\Security\Csrf\CsrfToken;
  33. use Symfony\Component\HttpFoundation\BinaryFileResponse;
  34. use Symfony\Component\HttpFoundation\ResponseHeaderBag;
  35. use Symfony\Component\Process\Process;
  36. use Symfony\Component\Filesystem\Filesystem;
  37. use Symfony\Component\Finder\Finder;
  38. use Doctrine\Common\Collections\Collection;
  39. use Symfony\Component\HttpFoundation\JsonResponse;
  40. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  41. use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
  42. use App\Repository\SoustraitantRepository;
  43. use App\Repository\AppelqualiteRepository;
  44. use App\Entity\Appelqualite;
  45. use App\Repository\CommentaireAppelqualiteRepository;
  46. use App\Entity\CommentaireAppelqualite;
  49. /**
  50.  * @Route("/depot")
  51.  */
  52. class DepotDossierController extends AbstractController
  53. {
  54.     /**
  55.      * @Route("/", name="app_depot_dossier_index", methods={"GET", "POST"})
  56.      */
  57.     public function index(Request $request,DepotDossierRepository $depotDossierRepository,EquipeRepository $equipeRepository,InstallateurRepository $installateurRepository,
  58.     OperationStandardRepository $operationStandardRepository,ObligesRepository $obligesRepository,FiltreRepository $filtreRepository,FactureAafRepository $factureAafRepository): Response
  59.     {
  61.         if ($request->getMethod() == "POST") {
  63.             $form = $request->request; 
  64.            // 
  65.            if ($form->get("chk_dossier") != null) {
  66.                 $idexporte=0;
  67.                 $exporte ="non";
  68.                 //dd($form->get("controller1"));
  69.                 if ($form->get("aaf") != null) {
  70.                  $factureAaf = new FactureAaf();
  71.                  $factureAaf->setDate(new Datetime());
  72.                  
  73.                  $factureAaf->setDepotaaf($form->get("depotaaf"));
  74.                  $factureAaf->setNumero($form->get("aaf"));
  75.                  $factureAafRepository->add($factureAaf, true);
  76.                 }
  77.                 foreach ($form->get("chk_dossier") as $key => $value) {
  78.                     $dossier = $depotDossierRepository->findOneBy(["id"=>intval($value)]);
  79.                     if ($form->get("controller1") != '-') {
  80.                         $controller1 = $equipeRepository->findOneBy(["id"=>intval($form->get("controller1"))]);
  81.                         $dossier->setControler1($controller1);
  82.                     }
  83.                     if ($form->get("controller2") != '-') {
  84.                         $controller2 = $equipeRepository->findOneBy(["id"=>intval($form->get("controller2"))]);
  85.                         $dossier->setControler2($controller2);
  86.                     }
  87.                     if ($form->get("aaf") != null) {
  88.                         $dossier->setFactureAaf($factureAaf);
  89.                         $dossier->setStatus("En attente de paiement");
  90.                         
  91.                     }
  92.                     
  93.                     $depotDossierRepository->add($dossier, true);
  94.                     
  95.                     if ($form->get("aaf") != null) {
  96.                         if ($dossier->getId() != null) {
  97.                             $factureAaf->addDossier($dossier);
  98.                         }
  99.                         
  100.                         
  101.                     }
  102.                     
  103.                 }
  104.                 // if ($form->get("aaf") != null) {
  105.                 //     dd($factureAaf);
  106.                     
  107.                 // }
  108.            }
  109.             
  110.             
  111.             
  112.         }
  114.         $equipes=[];
  116.         
  117.         foreach ($equipeRepository->findBy(["role"=>"ROLE_CONTROLER"]) as $key => $value) {
  118.             $equipes[]=$value;
  119.         }
  120.        
  121.         // dd($equipes);
  122.         $idexporte=0;
  123.         $exporte ="non";
  124.         if ($this->isGranted('ROLE_INSTALLATEUR')) {
  125.             $dossier=[];
  126.             $deals=$this->getUser()->getInstallateur()->getDeals();
  127.         
  128.             foreach ($deals as  $deal) {
  129.                
  130.                 foreach ($depotDossierRepository->findBy(["deal"=>$deal]) as $dls) {
  131.                     foreach ($depotDossierRepository->findAll() as  $value) {
  132.                         
  133.                         
  134.                         if ($value->getId() == $dls->getId()) {
  135.                             $dossier[]=$value;
  136.                         }
  137.                      }
  138.                 }
  139.                  
  140.                 
  141.             }
  142.          //dd($dossier);
  144.         }else{
  145.             $dossier=[];
  146.             $idexporte=0;
  147.             if ($request->getMethod() == "POST") {
  149.                 $form = $request->request; 
  150.                 // 
  151.                 $filtre = new Filtre();
  152.                 $filtre->setService("Depot Dossier");
  153.                 $descrtionfiltre="";
  154.                 if($form->get("filtreinstallateur") != null ){
  155.                     $descrtionfiltre.=" Installateur : ";
  156.                     foreach ($form->get("filtreinstallateur") as $value) {
  157.                         $descrtionfiltre.=$installateurRepository->findOneBy(["id"=>intval($value)])->getSociete().";";
  158.                     }
  159.                 }
  160.                 if ($form->get("filtreoblige") != null) {
  161.                     $descrtionfiltre.=" Oblige : ";
  162.                     foreach ($form->get("filtreoblige") as $value) {
  163.                         $descrtionfiltre.=$obligesRepository->findOneBy(["id"=>intval($value)])->getSociete().";";
  164.                     }
  165.                 }
  166.                 if ($form->get("filtreequipe") != null) {
  167.                     $descrtionfiltre.=" Equipe : ";
  168.                     foreach ($form->get("filtreequipe") as $value) {
  169.                         $descrtionfiltre.=$equipeRepository->findOneBy(["id"=>intval($value)])->getPrenom().";";
  170.                     }
  171.                 }
  172.                 if ($form->get("filtreoperation") != null) {
  173.                     $descrtionfiltre.=" Operation : ";
  174.                     foreach ($form->get("filtreoperation") as $value) {
  175.                         
  176.                         $descrtionfiltre.=explode(':',$operationStandardRepository->findOneBy(["id"=>intval($value)])->getNom())[0].";";
  177.                     }
  178.                 }
  180.                 if ($form->get("filtrestatus") != null) {
  181.                     $descrtionfiltre.=" Status : ";
  182.                     foreach ($form->get("filtrestatus") as $value) {
  183.                         
  184.                         $descrtionfiltre.=$value.";";
  185.                     }
  186.                 }
  187.                 $filtre->setDescription($descrtionfiltre);
  188.                 $filtre->setDate(new Datetime());
  189.                 $filtre->setUser($this->getUser());
  190.                 $filtreRepository->add($filtre, true);
  191.                 $idexporte=$filtre->getId();
  193.                 if($form->get("filtreinstallateur") != null ){
  194.                     
  195.                     foreach ($form->get("filtreinstallateur") as $value) {
  196.                         foreach ($depotDossierRepository->findBy([], ['id' => 'DESC']) as $depotds) {
  197.                             if ($depotds->getDeal()->getInstallateur()->getId() == $value) {
  198.                                 
  199.                                 if ($form->get("filtreoblige") != null) {
  200.                                     
  201.                                    foreach ($form->get("filtreoblige") as  $obg) {
  202.                                         if ($depotds->getDeal()->getDealoblige()->getOblige()->getId() == $obg) {
  203.                                             //dd($form->get("filtrestatus"));
  204.                                             if ($form->get("filtrestatus") != null) {
  205.                                                 foreach ($form->get("filtrestatus") as $status) {
  206.                                                     if ($depotds->getStatus() == $status ) {
  207.                                                         if ($form->get("filtreequipe") != null) {
  208.                                                             foreach ($form->get("filtreequipe") as $controller) {
  209.                                                                 if ($depotds->getControler1()->getId() == $controller || $depotds->getControler2()->getId() == $controller ) {
  210.                                                                     if ($form->get("filtreoperation") != null) {
  211.                                                                         foreach ($form->get("filtreoperation") as $operation) {
  212.                                                                             
  213.                                                                             foreach ($depotds->getOperation() as $ops) {
  214.                                                                                 if ($ops->getId()==$operation) {
  215.                                                                                     $dossier[]=$depotds;
  216.                                                                                 }
  217.                                                                             }
  218.                                                                         }
  219.                 
  220.                                                                     }else{
  221.                                                                     
  222.                                                                         $dossier[]=$depotds;
  223.                                                                     }
  224.                                                                 }
  225.                                                             } 
  226.                                                         } else {
  227.                                                             $dossier[]=$depotds;
  228.                                                         }
  229.                                                     }
  230.                                                 }
  231.                                             }else{
  232.                                                 $dossier[]=$depotds;
  233.                                             }
  234.                                         }
  235.                                     }
  236.                                 } else {
  237.                                     if ($form->get("filtrestatus") != null) {
  238.                                         foreach ($form->get("filtrestatus") as $status) {
  239.                                             if ($depotds->getStatus() == $status ) {
  240.                                                 if ($form->get("filtreequipe") != null) {
  241.                                                     foreach ($form->get("filtreequipe") as $controller) {
  242.                                                         if ($depotds->getControler1()->getId() == $controller || $depotds->getControler2()->getId() == $controller ) {
  243.                                                             if ($form->get("filtreoperation") != null) {
  244.                                                                 foreach ($form->get("filtreoperation") as $operation) {
  245.                                                                     
  246.                                                                     foreach ($depotds->getOperation() as $ops) {
  247.                                                                         if ($ops->getId()==$operation) {
  248.                                                                             $dossier[]=$depotds;
  249.                                                                         }
  250.                                                                     }
  251.                                                                 }
  252.         
  253.                                                             }else{
  254.                                                             
  255.                                                                 $dossier[]=$depotds;
  256.                                                             }
  257.                                                         }
  258.                                                     } 
  259.                                                 } else {
  260.                                                     $dossier[]=$depotds;
  261.                                                 }
  262.                                             }
  263.                                         }
  264.                                     } else {
  265.                                         $dossier[]=$depotds;
  266.                                     }
  267.                                     
  268.                                    
  269.                                 }
  270.                                 
  271.                             }
  272.                         }
  273.                     }
  274.                 }else{
  275.                     if ($form->get("filtreoblige") != null) {
  276.                         foreach ($depotDossierRepository->findBy([], ['id' => 'DESC']) as $depotds) {
  277.                             foreach ($form->get("filtreoblige") as  $obg) {
  278.                                 if ($depotds->getDeal()->getDealoblige()->getOblige()->getId() == $obg) {
  279.                                     //dd($form->get("filtrestatus"));
  280.                                     if ($form->get("filtrestatus") != null) {
  281.                                         foreach ($form->get("filtrestatus") as $status) {
  282.                                             if ($depotds->getStatus() == $status ) {
  283.                                                 if ($form->get("filtreequipe") != null) {
  284.                                                     foreach ($form->get("filtreequipe") as $controller) {
  285.                                                         if ($depotds->getControler1()->getId() == $controller || $depotds->getControler2()->getId() == $controller ) {
  286.                                                             if ($form->get("filtreoperation") != null) {
  287.                                                                 foreach ($form->get("filtreoperation") as $operation) {
  288.                                                                     
  289.                                                                     foreach ($depotds->getOperation() as $ops) {
  290.                                                                         if ($ops->getId()==$operation) {
  291.                                                                             $dossier[]=$depotds;
  292.                                                                         }
  293.                                                                     }
  294.                                                                 }
  295.         
  296.                                                             }else{
  297.                                                             
  298.                                                                 $dossier[]=$depotds;
  299.                                                             }
  300.                                                         }
  301.                                                     } 
  302.                                                 } else {
  303.                                                     $dossier[]=$depotds;
  304.                                                 }
  306.                                             }
  307.                                         }
  308.                                     }else{
  309.                                         $dossier[]=$depotds;
  310.                                     }
  311.                                 }
  312.                             }
  313.                         }
  314.                     }else{
  315.                         if ($form->get("filtrestatus") != null) {
  316.                             foreach ($depotDossierRepository->findBy([], ['id' => 'DESC']) as $depotds) {
  317.                                 foreach ($form->get("filtrestatus") as $status) {
  318.                                     if ($depotds->getStatus() == $status ) {
  319.                                         
  320.                                         if ($form->get("filtreequipe") != null) {
  321.                                             foreach ($form->get("filtreequipe") as $controller) {
  322.                                                 if ($depotds->getControler1()->getId() == $controller || $depotds->getControler2()->getId() == $controller ) {
  323.                                                     if ($form->get("filtreoperation") != null) {
  324.                                                         foreach ($form->get("filtreoperation") as $operation) {
  325.                                                             
  326.                                                             foreach ($depotds->getOperation() as $ops) {
  327.                                                                 if ($ops->getId()==$operation) {
  328.                                                                     $dossier[]=$depotds;
  329.                                                                 }
  330.                                                             }
  331.                                                         }
  333.                                                     }else{
  334.                                                     
  335.                                                         $dossier[]=$depotds;
  336.                                                     }
  337.                                                 }
  338.                                             } 
  339.                                         }else 
  340.                                         {
  341.                                             $dossier[]=$depotds;
  342.                                         }
  343.                                         
  344.                                     }
  345.                                 }
  346.                             }
  347.                         }else{
  348.                             if ($form->get("filtreequipe") != null) {
  349.                                 foreach ($depotDossierRepository->findBy([], ['id' => 'DESC']) as $depotds) {
  350.                                     foreach ($form->get("filtreequipe") as $controller) {
  351.                                         if ($depotds->getControler1()) {
  352.                                             if ($depotds->getControler1()->getId() == $controller || $depotds->getControler2()->getId() == $controller ) {
  353.                                                 if ($form->get("filtreoperation") != null) {
  354.                                                     foreach ($form->get("filtreoperation") as $operation) {
  355.                                                         
  356.                                                         foreach ($depotds->getOperation() as $ops) {
  357.                                                             if ($ops->getId()==$operation) {
  358.                                                                 $dossier[]=$depotds;
  359.                                                             }
  360.                                                         }
  361.                                                     }
  362.     
  363.                                                 }else{
  364.                                                 
  365.                                                     $dossier[]=$depotds;
  366.                                                 }
  367.                                             }
  368.                                         }
  369.                                         
  371.                                     } 
  372.                                 }
  373.                             }else{
  374.                                 if ($form->get("filtreoperation") != null) {
  375.                                     foreach ($depotDossierRepository->findBy([], ['id' => 'DESC']) as $depotds) {
  376.                                         foreach ($form->get("filtreoperation") as $operation) {
  377.                                             
  378.                                             foreach ($depotds->getOperation() as $ops) {
  379.                                                 if ($ops->getId()==$operation) {
  380.                                                     $dossier[]=$depotds;
  381.                                                 }
  382.                                             }
  383.                                         }
  384.                                     }
  386.                                 }else{
  387.                                 
  388.                                     $dossier= $depotDossierRepository->findBy([], ['id' => 'DESC']);
  389.                                 }
  391.                                
  392.                             }
  393.                             
  394.                         }
  396.                     }
  397.                 }
  399.                 $exporte ="oui";
  400.                 if ($form->get("chk_dossier") != null) {
  401.                     $idexporte=0;
  402.                     $exporte ="non";
  403.                 }
  404.                 
  405.             }else{
  406.                 $exporte ="non";
  407.                 if ($this->isGranted('ROLE_CONTROLER') ) {
  408.                     foreach ($depotDossierRepository->findBy(["controler1"=>$this->getUser()->getEquipe()]) as $key => $value) {
  409.                         $dossier[]=$value;
  410.                     }
  411.                     foreach ($depotDossierRepository->findBy(["controler2"=>$this->getUser()->getEquipe()]) as $key => $value) {
  412.                         $dossier[]=$value;
  413.                     }
  414.                    
  415.                 }elseif($this->isGranted('ROLE_CONTROLER')){
  416.                     
  417.                     foreach ($depotDossierRepository->findBy(["controler1"=>$this->getUser()->getEquipe()]) as $key => $value) {
  418.                         $dossier[]=$value;
  419.                     }
  420.                     
  421.                     foreach ($depotDossierRepository->findBy(["controler2"=>$this->getUser()->getEquipe()]) as $key => $value) {
  422.                         $dossier[]=$value;
  423.                     }
  424.                     //dd($dossier);
  425.                 } elseif($this->isGranted('ROLE_OBLIGE')){
  426.                     foreach ($this->getUser()->getObliges()->getDeals() as  $deal) {
  427.                         foreach ($deal->getDepotDossiers() as  $value) {
  428.                             $dossier[]=$value;
  429.                         }
  430.                        
  431.                     }
  432.                 }
  433.                 else{
  434.                     $dossier= $depotDossierRepository->findAll();
  435.                 }
  436.                
  437.             }
  438.             
  439.         }
  440.         
  442.         $tab=[];
  443.         $dossiers=[];
  445.         // id,type as owner,client as name ,date,file ,batiment
  446.         foreach ($dossier as  $value) {
  447.            if ($value->getStatus() != "archive") {
  448.                 # code...
  449.             
  450.                 $tab['id']=$value->getId();
  451.                 $tab['name']=$value->getNumero();  
  452.                 $tab['owner']=$value->getDeal()->getNumero();
  453.                 $tab['owner_id']=$value->getDeal()->getId();
  454.                 $tab['icone']="ri-archive-line";
  455.                 if ($value->getControler1()) {
  456.                     $tab['controller1']=$value->getControler1()->getPrenom();
  457.                 }
  458.                 if ($value->getControler2()) {
  459.                     $tab['controller2']=$value->getControler2()->getPrenom();
  460.                 }
  461.                 
  462.             
  463.                 $ops="";
  464.                 $opi=0;
  465.                 foreach ($value->getOperation() as $key => $op) {
  466.                     if ($opi>0) {
  467.                         $ops.=";"; 
  468.                     }
  469.                     $ops.=explode(':',$op->getNom())[0];
  470.                 
  471.                     $opi=$opi + 1;
  472.                 }
  473.                 $tab['industry_type']=$ops;
  474.                 $tab['cumac']=$value->getCumac();
  475.                 $tab['location']=$value->getNomclient().' '.$value->getPrenomclient();
  476.                 $tab['contact_email']=$value->getDeal()->getInstallateur()->getEmail();
  477.                 $tab['employee']="depot";
  478.                 if ($value->getStatus()=='Validé' || $value->getStatus()=='Payé sur AAF' || $value->getStatus()=='Déposé / AAF en cours' || $value->getStatus()=='En attente de paiement' ) {
  479.                     $tab['star_value']='<span class="badge progress-green p-2 border-0" >'.$value->getStatus().'</span>';
  480.                     $tab['row_tr']='row-green';
  481.                 } elseif($value->getStatus()=="Bloqué" || $value->getStatus()=="Non validé" ) {
  482.                     $tab['star_value']='<span class="badge progress-red p-2 border-0" >'.$value->getStatus().'</span>';
  483.                     $tab['row_tr']='row-red';
  484.                 }elseif($value->getStatus()=="Urgent") {
  485.                 $tab['star_value']='<span class="badge progress-red p-2 border-0" >'.$value->getStatus().'</span>';
  486.                 $tab['row_tr']='row-red';
  487.                 }
  488.                 elseif($value->getStatus()=="En Attente" || $value->getStatus()=="Prêt pour dépôt"){
  489.                     $tab['star_value']='<span class="badge progress-yellow p-2 border-0" >'.$value->getStatus().'</span>';
  490.                     $tab['row_tr']='row-yellow';
  491.                 }else{
  492.                     $tab['star_value']='<span class="badge progress-grey p-2 border-0" >Nouveau</span>';
  493.                     $tab['row_tr']='row-grey';
  494.                 }
  495.                 
  496.                 $tab['image_src']="#";
  497.                 $dossiers[]=$tab;
  498.            }
  500.         }
  502.         //dd($dossiers);
  503.         $dossiersjson = json_encode($dossiers);
  505.         // var_dump(json_encode($clientjson ));
  506.         file_put_contents('assets/json/dossier-list.json', $dossiersjson);
  508.         return $this->render('depot_dossier/index.html.twig', [
  509.             'depot_dossiers' => $depotDossierRepository->findAll(),
  510.             'equipes'=>$equipes,
  511.             'listobliges' => $obligesRepository->findAll(),
  512.             'allInstallateurs' => $installateurRepository->findAll(),
  513.             'operationsStandard' => $operationStandardRepository->findAll(),
  514.             'exporte' => $exporte,
  515.             'idexporte' => $idexporte
  516.         ]);
  517.     }
  519.     /**
  520.      * @Route("/dossierarchives", name="app_depot_dossier_archives", methods={"GET", "POST"})
  521.      */
  522.     public function dossierarchives(Request $request,DepotDossierRepository $depotDossierRepository,EquipeRepository $equipeRepository,InstallateurRepository $installateurRepository,
  523.     OperationStandardRepository $operationStandardRepository,ObligesRepository $obligesRepository,FiltreRepository $filtreRepository,FactureAafRepository $factureAafRepository): Response
  524.     {
  526.        
  527.         if ($request->getMethod() == "POST") {
  529.             $form = $request->request; 
  530.            
  531.            if ($form->get("chk_dossier") != null) {
  532.                 foreach ($form->get("chk_dossier") as $key => $value) {
  533.                     $dossier = $depotDossierRepository->findOneBy(["id"=>intval($value)]);
  534.                     $dossier->setArchive($dossier->getStatus());
  535.                     $dossier->setStatus("archive");
  536.                     $depotDossierRepository->add($dossier, true);
  537.                 }
  539.            }
  540.         }
  541.         
  542.        
  543.        
  544.         $dossier=$depotDossierRepository->findBy(['status' => 'archive'], ['id' => 'DESC']);;
  545.  
  547.         $tab=[];
  548.         $dossiers=[];
  550.         // id,type as owner,client as name ,date,file ,batiment
  551.         foreach ($dossier as  $value) {
  552.            if ($value->getStatus() == "archive") {
  553.                 # code...
  554.             
  555.                 $tab['id']=$value->getId();
  556.                 $tab['name']=$value->getNumero();  
  557.                 $tab['owner']=$value->getDeal()->getNumero();
  558.                 $tab['owner_id']=$value->getDeal()->getId();
  559.                 $tab['icone']="ri-delete-bin-fill";
  560.                 if ($value->getControler1()) {
  561.                     $tab['controller1']=$value->getControler1()->getPrenom();
  562.                 }
  563.                 if ($value->getControler2()) {
  564.                     $tab['controller2']=$value->getControler2()->getPrenom();
  565.                 }
  566.                 
  567.             
  568.                 $ops="";
  569.                 $opi=0;
  570.                 foreach ($value->getOperation() as $key => $op) {
  571.                     if ($opi>0) {
  572.                         $ops.=";"; 
  573.                     }
  574.                     $ops.=explode(':',$op->getNom())[0];
  575.                 
  576.                     $opi=$opi + 1;
  577.                 }
  578.                 $tab['industry_type']=$ops;
  579.                 $tab['cumac']=$value->getCumac();
  580.                 $tab['location']=$value->getNomclient().' '.$value->getPrenomclient();
  581.                 $tab['contact_email']=$value->getDeal()->getInstallateur()->getEmail();
  582.                 $tab['employee']="depot";
  583.                if($value->getStatus()=="archive") {
  584.                 $tab['star_value']='<span class="badge progress-red p-2 border-0" >'.$value->getStatus().'</span>';
  585.                 $tab['row_tr']='row-red';
  586.                 }
  587.                 $tab['image_src']="#";
  588.                 $dossiers[]=$tab;
  589.            }
  591.         }
  593.         //dd($dossiers);
  594.         $dossiersjson = json_encode($dossiers);
  596.         // var_dump(json_encode($clientjson ));
  597.         file_put_contents('assets/json/dossier-list.json', $dossiersjson);
  599.         return $this->render('depot_dossier/archives.html.twig', [
  600.             'depot_dossiers' => $depotDossierRepository->findAll()
  601.         ]);
  602.     }
  604.      /**
  605.      * @Route("/dossierdesarchives", name="app_depot_dossier_desarchives", methods={"GET", "POST"})
  606.      */
  607.     public function dossierdesarchives(Request $request,DepotDossierRepository $depotDossierRepository,EquipeRepository $equipeRepository,InstallateurRepository $installateurRepository,
  608.     OperationStandardRepository $operationStandardRepository,ObligesRepository $obligesRepository,FiltreRepository $filtreRepository,FactureAafRepository $factureAafRepository): Response
  609.     {
  610.         if ($request->getMethod() == "POST") {
  612.             $form = $request->request; 
  613.            
  614.            if ($form->get("chk_dossier") != null) {
  615.                 foreach ($form->get("chk_dossier") as $key => $value) {
  616.                     $dossier = $depotDossierRepository->findOneBy(["id"=>intval($value)]);
  617.                    
  618.                     $dossier->setStatus($dossier->getArchive());
  619.                     $depotDossierRepository->add($dossier, true);
  620.                 }
  622.            }
  623.         }
  624.         return $this->redirectToRoute('app_depot_dossier_index', [], Response::HTTP_SEE_OTHER);
  625.     }
  626.     /**
  627.      * @Route("/historiquefiltre", name="app_filtre_index", methods={"GET", "POST"})
  628.      */
  629.     public function historiquefiltre(Request $request,FiltreRepository $filtreRepository): Response
  630.     {
  632.         $filtre= $filtreRepository->findAll();
  633.         $tab=[];
  634.         $filtres=[];
  635.   
  636.         // id,type as owner,client as name ,date,file ,batiment
  637.         foreach ($filtre as  $value) {
  638.             if ($value->getExporte() != null) {
  639.                 $tab['id']=$value->getId();
  640.                 $tab['name']=$value->getDate()->format('d-m-Y');
  641.                 $tab['owner']=$value->getDescription();
  642.                 $tab['industry_type']=$value->getExporte();
  643.                 if ($value->getUser()) {
  644.                     $tab['contact_email']=$value->getUser()->getEquipe()->getPrenom();
  645.                 }
  646.                
  647.                 $filtres[]=$tab;
  648.             }
  649.             
  651.         }
  653.         //dd($filtres);
  654.         $clientjson = json_encode($filtres);
  656.         // var_dump(json_encode($clientjson ));
  657.         file_put_contents('assets/json/filtre-list.json', $clientjson);
  659.         return $this->render('depot_dossier/filtre.html.twig', [
  660.             'filtres' => $filtreRepository->findAll(),
  661.         ]);
  663.     }
  664.     
  666.     /**
  667.      * @Route("/new", name="app_depot_dossier_new", methods={"GET", "POST"})
  668.      */
  669.     public function new(Request $request,DealRepository $dealRepository,DepotDossierRepository $depotDossierRepository,OperationStandardRepository $operationsStandardRepository,
  670.     ChampsDeaufDepotDossierRepository $champsDeaufDepotDossierRepository,ChampsDepotDossierRepository $champsDepotDossierRepository,FactureAafRepository $factureAafRepository): Response
  671.     {
  672.         $depotDossier = new DepotDossier();
  673.         // $form = $this->createForm(DepotDossierType::class, $depotDossier);
  674.         // $form->handleRequest($request);
  676.         if ($request->getMethod() == "POST") {
  678.             $form = $request->request; 
  679.            //dd($form->get('operations'));
  680.             // $depotDossier->setClientfiscale($form->get('fiscale'));
  681.             $depotDossier->setCivilite($form->get('civilite'));
  682.             $depotDossier->setNomclient($form->get('nomclient'));
  683.             $depotDossier->setPrenomclient($form->get('prenomclient'));
  684.             $depotDossier->setPhone($form->get('phone'));
  685.             $depotDossier->setEmail($form->get('email'));
  686.             $depotDossier->setAdresse($form->get('adresse'));
  687.             $depotDossier->setVille($form->get('ville'));
  688.             $depotDossier->setCodepostale($form->get('postale'));
  689.             $depotDossier->setNumero($form->get('numero'));
  690.             $depotDossier->setCumac($form->get('cumac'));
  691.             // $depotDossier->setNatureoccupation($form->get('occupation'));
  692.             // $depotDossier->setTypelogement($form->get('typelogement'));
  693.             // $depotDossier->setEnergiechauffage($form->get('energiechauffage'));
  694.             // $depotDossier->setAnciennete($form->get('anciennetechauffage'));
  695.             // $depotDossier->setSystemechauffage($form->get('anciennetechauffage'));
  696.             // $depotDossier->setSurfacehabitable($form->get('surfacehabite'));
  697.             // $depotDossier->setSuperficiesol($form->get('Superficiesol'));
  698.             // $depotDossier->setParcellecadastrale($form->get('Parcelle'));
  699.             // $depotDossier->setTypemaison($form->get('Parcelle')); 
  700.             // $depotDossier->setSoussol($form->get('soussol'));
  701.             // $depotDossier->setAnciennetelogement($form->get('ancienneteloge'));
  702.             $depotDossier->setStatus("nouveau");
  703.            
  704.             $depotDossier->setDate(new Datetime());
  705.            
  706.             
  707.             
  709.             $deal= $dealRepository->findOneBy(["id"=>intval($form->get('deal'))]);
  710.             $depotDossier->setDeal($deal);
  712.             // $alphas = range('A', 'Z');
  714.             // $key = substr($deal->getNumero(), 0, 2).''. random_int(001, 999).''.$alphas[random_int(0, 25)] . '' . $alphas[random_int(0, 25)] ;
  715.             // $depotDossier->setNumero($key);
  718.             if ($form->get('operations') !=null ) {
  719.                 foreach ($form->get('operations') as  $value) {
  720.                     $ops= $operationsStandardRepository->findOneBy(["id"=>intval($value)]);
  721.                     $depotDossier->addOperation($ops);
  722.                 }
  723.             }
  724.             $depotDossierRepository->add($depotDossier, true);
  727.             foreach ($champsDeaufDepotDossierRepository->findAll() as  $chmps) {
  728.                 $champsDepotDossier = new ChampsDepotDossier();
  729.                
  730.                 $champsDepotDossier->setNom($chmps->getNom());
  731.                 $champsDepotDossier->setType($chmps->getType());
  732.                 if ($chmps->getType()== 'file') {
  733.                  $champsDepotDossier->setStatus('Non Transmis');
  734.                 }
  735.                 $champsDepotDossier->setDepotdossier($depotDossier);
  736.                 
  737.                 $champsDepotDossierRepository->add($champsDepotDossier, true);
  738.             }
  740.             // $factureAaf = new FactureAaf();
  741.             // $factureAaf->setDossier($depotDossier);
  742.             // $factureAaf->setStatus("Non Transmis");
  743.             // $factureAafRepository->add($factureAaf, true);
  744.             
  745.             return $this->redirectToRoute('app_depot_dossier_edit', ['id' =>$depotDossier->getId()], Response::HTTP_SEE_OTHER);
  746.         }
  748.         if ($this->isGranted('ROLE_INSTALLATEUR')) {
  749.             $datejr= new Datetime();
  750.             $deal=[];
  751.            foreach ($this->getUser()->getInstallateur()->getDeals() as $key => $value) {
  752.                if ($value->getStatus()=="Validé" && $value->getDatefin() > $datejr) {
  753.                 $deal[]=$value;
  754.                }
  755.            }
  756.         }else{
  757.             $deal=[];
  758.             $datejr= new Datetime();
  759.             foreach ( $dealRepository->findBy(['status'=>'Validé']) as $key => $value) {
  760.                if ($value->getDatefin() > $datejr) {
  761.                 $deal[]=$value;
  762.                }
  763.             }
  764.         }
  766.         if ($this->isGranted('ROLE_INSTALLATEUR')) {
  767.             $operations=$this->getUser()->getInstallateur()->getOperationStandards();
  768.         }else{
  769.             $operations= $operationsStandardRepository->findAll();
  770.         }
  771.         
  772.         if ($request->query->get('ideal') != null ) {
  773.             $idealGet = $request->query->get('ideal');
  774.         } else {
  775.             $idealGet = 0;
  776.         }
  777.         
  778.         
  779.         
  781.         return $this->renderForm('depot_dossier/new.html.twig', [
  782.             'depot_dossier' => $depotDossier,
  783.             'depot' => "depot",
  784.             'operations' =>$operations,
  785.             'dealAll' => $deal,
  786.             "idealGet" => $idealGet
  787.         ]);
  788.     }
  790.     /**
  791.      * @Route("/{id}", name="app_depot_dossier_show", methods={"GET"})
  792.      */
  793.     public function show(DepotDossier $depotDossier): Response
  794.     {
  795.         return $this->render('depot_dossier/show.html.twig', [
  796.             'depot_dossier' => $depotDossier,
  797.         ]);
  798.     }
  800.     /**
  801.      * @Route("/{id}/edit", name="app_depot_dossier_edit", methods={"GET", "POST"})
  802.      */
  803.     public function edit(Request $request, DepotDossier $depotDossier, DepotDossierRepository $depotDossierRepository,CsrfTokenManagerInterface $csrfTokenManager,
  804.     EquipeRepository $equipeRepository,NotificationsRepository $notificationsRepository,OperationStandardRepository $operationsStandardRepository,
  805.     PlanningRepository $planningRepository,SoustraitantRepository $soustraitantRepository,ChampsDeaufDepotDossierRepository $champsDeaufDepotDossierRepository): Response
  806.     {
  807.         // $form = $this->createForm(DepotDossierType::class, $depotDossier);
  808.         // $form->handleRequest($request);
  810.         // if ($form->isSubmitted() && $form->isValid()) {
  811.         //     $depotDossierRepository->add($depotDossier, true);
  813.         //     return $this->redirectToRoute('app_depot_dossier_index', [], Response::HTTP_SEE_OTHER);
  814.         // }
  815.         if ($this->isGranted('ROLE_INSTALLATEUR')) {
  816.             if ($this->getUser()->getInstallateur()->getId() != $depotDossier->getDeal()->getInstallateur()->getId()) {
  817.                 return $this->redirectToRoute('app_depot_dossier_index', [], Response::HTTP_SEE_OTHER);
  818.             }
  819.          }
  820.         $csrfToken = $csrfTokenManager->getToken('depot_dossier_edit');
  821.         if ($request->getMethod() == "POST") {
  822.             $token = $request->request->get('_token');
  823.             $id = explode("A@",explode("12OU#@R",$token)[1])[0];
  824.             if ($id!=$depotDossier->getId()) {
  825.                 return $this->redirectToRoute('app_depot_dossier_edit', ['id' => $id], Response::HTTP_SEE_OTHER);
  826.             }
  827.             $form = $request->request; 
  828.            
  829.            
  830.             if ($form->get('controler2') != null ) {
  831.                 $depotDossier->setControler2($equipeRepository->findOneBy(["id"=>intval($form->get('controler2'))]));
  832.                
  834.             }
  835.             if ($form->get('controler1') != null ) {
  836.                 $depotDossier->setControler1($equipeRepository->findOneBy(["id"=>intval($form->get('controler1'))]));
  837.                
  839.             }
  840.             //dd($form->get('dateprevisite'));
  841.             
  842.                 if ($depotDossier->getPlanning()) {
  843.                     $planning = $depotDossier->getPlanning();
  844.                     
  845.                 }else{
  846.                     $planning = new Planning();
  847.                 }
  848.                     $dateprevisite = date('d-m-Y', strtotime($form->get('dateprevisite'))) ;
  849.                     $datetimeprevisite = new Datetime($dateprevisite);
  852.                     $datedevis = date('d-m-Y', strtotime($form->get('datedevis'))) ;
  853.                     $datetimedevis = new Datetime($datedevis);
  855.                     $dateengagement = date('d-m-Y', strtotime($form->get('dateengagement'))) ;
  856.                     $datetimeengagement = new Datetime($dateengagement);
  858.                     $datetravaux = date('d-m-Y', strtotime($form->get('datetravaux'))) ;
  859.                     $datetimetravaux = new Datetime($datetravaux);
  861.                     $datefacture = date('d-m-Y', strtotime($form->get('datefacture'))) ;
  862.                     $datetimefacture = new Datetime($datefacture);
  865.                     
  866.                     $planning->setDateprevisite($datetimeprevisite);
  867.                     $planning->setIntervenant($form->get('intervation'));
  868.                     $planning->setDatedevis($datetimedevis);
  869.                     $planning->setSourcedevis($form->get('sourcedevis'));
  870.                     $planning->setDateengagement($datetimeengagement);
  871.                     $planning->setDatetravaux($datetimetravaux);
  872.                     $planning->setPoseur($form->get('poseur'));
  873.                     $planning->setConsigne($form->get('consigne'));
  874.                     $planning->setDatefacture($datetimefacture);
  875.                     $planning->setSourcefacture($form->get('sourcefacture'));
  876.                     $planning->setNumerofacture($form->get('numerofacture'));
  877.                     $planning->setDossier($depotDossier);
  878.                     $planningRepository->add($planning, true);
  879.                 
  880.                 
  881.             
  883.             // $depotDossier->setClientfiscale($form->get('fiscale'));
  884.             $depotDossier->setCivilite($form->get('civilite'));
  885.             $depotDossier->setNomclient($form->get('nomclient'));
  886.             $depotDossier->setPrenomclient($form->get('prenomclient'));
  887.             $depotDossier->setPhone($form->get('phone'));
  888.             $depotDossier->setEmail($form->get('email'));
  889.             $depotDossier->setNumero($form->get('numero'));
  890.             $depotDossier->setCumac($form->get('cumac'));
  891.             if ($depotDossier->getBlocage()!="oui") {
  892.                 $depotDossier->setAdresse($form->get('adresse'));
  893.                 $depotDossier->setVille($form->get('ville'));
  894.                 $depotDossier->setCodepostale($form->get('postale'));
  895.             }
  896.            
  897.             // $depotDossier->setNatureoccupation($form->get('occupation'));
  898.             // $depotDossier->setTypelogement($form->get('typelogement'));
  899.             // $depotDossier->setEnergiechauffage($form->get('energiechauffage'));
  900.             // $depotDossier->setAnciennete($form->get('anciennetechauffage'));
  901.             // $depotDossier->setSystemechauffage($form->get('anciennetechauffage'));
  902.             // $depotDossier->setSurfacehabitable($form->get('surfacehabite'));
  903.             // $depotDossier->setSuperficiesol($form->get('Superficiesol'));
  904.             // $depotDossier->setParcellecadastrale($form->get('Parcelle'));
  905.             // $depotDossier->setTypemaison($form->get('Parcelle'));
  906.             // $depotDossier->setAnciennetelogement($form->get('ancienneteloge'));
  907.             // $depotDossier->setSoussol($form->get('soussol'));
  908.             $depotDossier->setStatus($form->get('status'));
  909.            
  910.             $depotDossier->setCommentaire($form->get('commentaire'));
  911.         
  912.                if ($form->get('operations') != null) {
  913.                 foreach ($depotDossier->getOperation() as  $value) {
  914.                     if (!in_array($value->getId(),$form->get('operations'))) {
  915.                         $depotDossier->removeOperation($value);
  916.                     }
  917.                  }
  918.                  foreach ($form->get('operations') as  $value) {
  919.                     $ops= $operationsStandardRepository->findOneBy(["id"=>intval($value)]);
  920.                     $depotDossier->addOperation($ops);
  921.                 }
  922.                }else{
  923.                 foreach ($depotDossier->getOperation() as  $value) {
  924.                    
  925.                     $depotDossier->removeOperation($value);
  926.                     
  927.                  }
  928.                }
  930.                if ($form->get('soustraitants') != null) {
  931.                 foreach ($depotDossier->getSoustraitants() as  $value) {
  932.                     if (!in_array($value->getId(),$form->get('soustraitants'))) {
  933.                      $depotDossier->removeSoustraitant($value);
  934.                     }
  935.                  }
  936.                  foreach ($form->get('soustraitants') as  $value) {
  937.                     $soustraitant= $soustraitantRepository->findOneBy(["id"=>intval($value)]);
  938.                     
  939.                     $depotDossier->addSoustraitant($soustraitant);
  940.                 }
  941.                }else{
  942.                 foreach ($depotDossier->getSoustraitants() as  $value) {
  943.                    
  944.                      $depotDossier->removeSoustraitant($value);
  945.                     
  946.                  }
  947.                }
  949.             $depotDossierRepository->add($depotDossier, true);
  950.             return $this->redirectToRoute('app_depot_dossier_edit', ['id' =>$depotDossier->getId()], Response::HTTP_SEE_OTHER);
  951.         }
  953.         $notif = $notificationsRepository->findOneBy(["user_id" => $this->getUser(),"statuts"=> "non lu","action" => "app_depot_dossier_edit","action_id"=>$depotDossier->getId()]);
  954.         if ($notif) {
  955.             $notif->setStatuts("lu");
  956.             $notificationsRepository->add($notif, true);
  957.         }
  959.         $dealAll = $depotDossier->getDeal()->getInstallateur()->getDeals();
  960.         $operationsStandars = $depotDossier->getDeal()->getInstallateur()->getOperationStandards();
  961.         // $controles1=$equipeRepository->findBy(["role"=>'ROLE_CONTROLER']);
  962.         // $controles2=$equipeRepository->findBy(["role"=>'ROLE_CONTROLER']);
  963.         $equipes=[];
  965.         
  966.         foreach ($equipeRepository->findBy(["role"=>"ROLE_CONTROLER"]) as $key => $value) {
  967.             $equipes[]=$value;
  968.         }
  969.        
  970.         //dd($csrfToken->getValue().'12OU#@R'.$depotDossier->getId()."A@T9");
  971.         // dd($champsDeaufDepotDossierRepository->findAll());
  972.         return $this->renderForm('depot_dossier/edit.html.twig', [
  973.             "depot" =>"depot",
  974.             'depot_dossier' => $depotDossier,
  975.             'dealAll' => $dealAll,
  976.             'controles1' => $equipes,
  977.             'controles2' => $equipes,
  978.             'operationsStandars' => $operationsStandars,
  979.             "dateday"=>new Datetime(),
  980.             'csrf_token' => $csrfToken->getValue().'12OU#@R'.$depotDossier->getId()."A@T9",
  981.             'champsDeaufs' => $champsDeaufDepotDossierRepository->findAll()
  982.             
  983.         ]);
  984.     }
  986.     /**
  987.      * @Route("/{id}", name="app_depot_dossier_delete", methods={"POST"})
  988.      */
  989.     public function delete(Request $request, DepotDossier $depotDossier, DepotDossierRepository $depotDossierRepository,CommentairesControlleRepository $commentairesControlleRepository
  990.     , NotificationsRepository $notificationsRepository,ChampsDepotDossierRepository $champsDepotDossierRepository,FactureAafRepository $factureAafRepository,AppelqualiteRepository $appelqualiteRepository,
  991.     SoustraitantRepository $soustraitantRepository): Response
  992.     {
  993.         if ($this->isCsrfTokenValid('delete'.$depotDossier->getId(), $request->request->get('_token'))) {
  995.             foreach ($notificationsRepository->findBy(["action_id"=>$depotDossier->getId()]) as  $value) {
  996.                 $notificationsRepository->remove($value, true);
  997.              }
  998.             foreach ($depotDossier->getCommentairesControlles() as $commentaire) {
  999.                 $commentairesControlleRepository->remove($commentaire, true);
  1000.             }
  1001.             foreach ($depotDossier->getChampsDepotDossiers() as  $value) {
  1002.            
  1003.                 $depotDossier->removeChampsDepotDossier($value);
  1005.                 $champsDepotDossierRepository->remove($value, true);
  1006.                
  1007.             }
  1008.             foreach ($depotDossier->getSoustraitants() as  $value) {
  1009.            
  1010.                 $depotDossier->removeSoustraitant($value);
  1012.                 // $soustraitantRepository->remove($value, true);
  1013.                
  1014.             }
  1015.             
  1016.             // foreach ($depotDossier->getFactureAafs() as  $value) {
  1017.             //     foreach ($value->getCommentaireFactureaafs() as  $commentaire) {
  1019.             //         $value->removeCommentaireFactureaaf($commentaire);
  1020.     
  1021.                   
  1022.                 
  1023.             //     }
  1024.                 
  1025.                
  1026.             // }
  1028.             foreach ($depotDossier->getAppelqualites() as  $value) {
  1029.                 foreach ($value->getCommentaireAppelqualites() as  $commentaire) {
  1031.                     $value->removeCommentaireAppelqualite($commentaire);
  1032.     
  1033.                     // $activiteDealRepository->remove($commentaire, true);
  1034.                 
  1035.                 }
  1036.                 $depotDossier->removeAppelqualite($value);
  1038.                 $appelqualiteRepository->remove($value, true);
  1039.                
  1040.             }
  1041.             
  1042.             $depotDossierRepository->remove($depotDossier, true);
  1043.         }
  1045.         return $this->redirectToRoute('app_depot_dossier_index', [], Response::HTTP_SEE_OTHER);
  1046.     }
  1050.      /**
  1051.      * @Route("/zip/{id}", name="app_depot_dossier_zip", methods={"GET"})
  1052.      */
  1053.     public function zip(DepotDossier $depotDossier): Response
  1054.     {
  1055.         
  1057.         
  1058.           
  1059.         $zipFileName = 'depotdossier_'.$depotDossier->getDeal()->getInstallateur()->getSociete().'_' . date('d-m-Y-His') . '.zip';
  1060.     
  1061.         // Créez le chemin absolu vers le fichier ZIP
  1062.         $zipFilePath = $this->getParameter('installateur_directory') . '/archiver/' . $zipFileName;
  1063.     
  1064.         // Utilisez la classe ZipArchive pour créer le fichier ZIP
  1065.         $zip = new \ZipArchive();
  1066.         $zip->open($zipFilePath, \ZipArchive::CREATE | \ZipArchive::OVERWRITE);
  1067.     
  1068.     
  1069.             foreach ($depotDossier->getChampsDepotDossiers() as $value) {
  1070.                 if ($value->getType()=="file") {
  1071.                     if ($value->getValeur()!=null) {
  1073.                      
  1074.                      $filePath = $this->getParameter('installateur_directory').'/'.$value->getValeur();
  1075.                      $relativePath = 'depotdossier_'.$depotDossier->getDeal()->getInstallateur()->getSociete()."/".$value->getValeur();
  1076.                      $zip->addFile($filePath, $relativePath);
  1077.                     }
  1078.                 }
  1079.        
  1080.             }
  1082.             // Fermer le fichier ZIP
  1083.             $zip->close();
  1085.             // Envoyer le fichier ZIP en tant que réponse de téléchargement
  1086.             $response = new BinaryFileResponse($zipFilePath);
  1087.             $response->headers->set('Content-Type', 'application/zip');
  1088.             $response->setContentDisposition(ResponseHeaderBag::DISPOSITION_ATTACHMENT, $zipFileName);
  1091.            
  1092.             return $response;
  1094.         
  1095.     }
  1099.       /**
  1100.      * @Route("/commentaire/{id}", methods={"POST"})
  1101.      */
  1102.     public function commentaire(Request $request,CommentairesControlleRepository $commentairesControlleRepository,
  1103.      NotificationsRepository $notificationsRepository,DepotDossier $depotDossier): JsonResponse
  1104.     { 
  1105.         
  1106.         
  1107.   
  1108.         if ($request->getMethod() == "POST") {
  1109.             
  1110.             // $file=$request->files->get('validedocument');
  1111.             $commentaire = $request->request->get('commentaire');
  1112.             $status= $request->request->get('status');
  1113.             $assigne= $request->request->get('assigne');
  1114.             
  1115.              if ($commentaire) {
  1116.                
  1117.                     $commentairesControlle = new CommentairesControlle();
  1118.                     
  1119.                     $commentairesControlle->setCommentaire($commentaire);
  1120.                     $commentairesControlle->setDate(new DateTime());
  1121.                     $commentairesControlle->setDossier($depotDossier);
  1122.                     $commentairesControlle->setStatus($status);
  1123.                     $commentairesControlle->setAssigne($assigne);
  1124.                     $commentairesControlle->setControleur($this->getUser()->getEquipe());
  1126.                     $commentairesControlleRepository->add($commentairesControlle, true);
  1128.                     // if ($this->isGranted('ROLE_CONTROLER')) {
  1129.                     //     $user = $depotDossier->getControler2()->getUser();
  1131.                     //     $notifications = new Notifications();
  1132.                     //     $notifications->setUserId($user);
  1133.                     //     $notifications->setMessage("Le contrôle n°1 du dossier ".$depotDossier->getNumero()." a été validé.");
  1134.                     //     $notifications->setAction("app_depot_dossier_edit");
  1135.                     //     $notifications->setActionId($depotDossier->getId());
  1136.                     //     $notifications->setSender($this->getUser());
  1137.                     //     $notifications->setStatuts("non lu");
  1138.                     //     $notifications->setDate(new DateTime());
  1139.             
  1140.                     //     $notificationsRepository->add($notifications, true);
  1142.                     //     $admins = $equipeRepository->findAll();
  1144.                     //     foreach ($admins as $key => $value) {
  1146.                     //         $listPermissions = $value->getPermissions();
  1148.                     //         foreach ($listPermissions as $v) {
  1149.                     //             if($v == "NOTIFICATION" ){
  1150.                     //                 $notificationsAdmin = new Notifications();
  1151.                     //                 $notificationsAdmin->setUserId($value->getUser());
  1152.                     //                 $notificationsAdmin->setMessage("Le contrôle n°1 du dossier ".$depotDossier->getNumero()." a été validé.");
  1153.                     //                 $notificationsAdmin->setAction("app_depot_dossier_edit");
  1154.                     //                 $notificationsAdmin->setActionId($depotDossier->getId());
  1155.                     //                 $notificationsAdmin->setSender($this->getUser());
  1156.                     //                 $notificationsAdmin->setStatuts("non lu");
  1157.                     //                 $notificationsAdmin->setDate(new DateTime());
  1158.                         
  1159.                     //                 $notificationsRepository->add($notificationsAdmin, true);
  1160.                     //             }
  1161.                     //         }
  1162.                     //     }
  1164.                         
  1165.                     // }else{
  1167.                     // }
  1168.                     
  1170.                         
  1171.                         
  1172.                     
  1173.                    
  1175.                     return $this->json(['success' => true, 'message' => 'commentaire ajouter ']);
  1176.              }
  1177.         }
  1179.         return $this->json(['success' => false, 'error' => 'Erreur ']);
  1180.     }
  1182.        /**
  1183.      * @Route("/commentaireedite/{id}", methods={"POST"})
  1184.      */
  1185.     public function commentaireedite(Request $request,CommentairesControlleRepository $commentairesControlleRepository,CommentairesControlle $commentairesControlle ): JsonResponse
  1186.     { 
  1187.         
  1188.         
  1189.   
  1190.         if ($request->getMethod() == "POST") {
  1191.             
  1192.             // $file=$request->files->get('validedocument');
  1193.             $commentaire = $request->request->get('commentaire');
  1194.        
  1195.             
  1196.              if ($commentaire) {
  1197.             
  1198.                     $commentairesControlle->setCommentaire($commentaire);
  1199.                     $commentairesControlle->setDate(new DateTime());
  1200.                     $commentairesControlleRepository->add($commentairesControlle, true);
  1203.                         
  1204.                         
  1205.                     
  1206.                    
  1208.                     return $this->json(['success' => true, 'message' => 'commentaire ajouter ']);
  1209.              }
  1210.         }
  1212.         return $this->json(['success' => false, 'error' => 'Erreur ']);
  1213.     }
  1215.     
  1216.     /**
  1217.      * @Route("/suprimercommentaire/{id}", methods={"POST"})
  1218.      */
  1219.     public function suprimercommentaire(Request $request ,CommentairesControlleRepository $commentairesControlleRepository,CommentairesControlle $commentairesControlle): JsonResponse
  1220.     { 
  1221.         
  1222.         
  1223.   
  1224.         if ($request->getMethod() == "POST") {
  1225.             
  1226.             // $file=$request->files->get('validedocument');
  1227.             $id = $request->request->get('id');
  1228.              if ($id) {
  1230.                     
  1231.                 $commentairesControlleRepository->remove($commentairesControlle, true);
  1232.                     return $this->json(['success' => true, 'message' => 'supprimer succès']);
  1233.              }
  1234.         }
  1236.         return $this->json(['success' => false, 'error' => 'Erreur ']);
  1237.     }
  1239.        /**
  1240.      * @Route("/blocage/{id}", methods={"POST"})
  1241.      */
  1242.     public function blocage(Request $request,
  1243.      NotificationsRepository $notificationsRepository,DepotDossier $depotDossier,DepotDossierRepository $depotDossierRepository): JsonResponse
  1244.     { 
  1245.         
  1246.         
  1247.   
  1248.         if ($request->getMethod() == "POST") {
  1249.             
  1250.             // $file=$request->files->get('validedocument');
  1251.             $lock = $request->request->get('lock');
  1252.           
  1253.              if ($lock) {
  1254.                
  1255.                   if ($depotDossier->getBlocage()==null || $depotDossier->getBlocage()=='non') {
  1256.                     $depotDossier->setBlocage("oui");
  1257.                   }else{
  1258.                     $depotDossier->setBlocage("non");
  1259.                   }
  1261.                     $depotDossierRepository->add($depotDossier, true);
  1263.                     // if ($this->isGranted('ROLE_CONTROLER')) {
  1264.                     //     $user = $depotDossier->getControler2()->getUser();
  1266.                     //     $notifications = new Notifications();
  1267.                     //     $notifications->setUserId($user);
  1268.                     //     $notifications->setMessage("Le contrôle n°1 du dossier ".$depotDossier->getNumero()." a été validé.");
  1269.                     //     $notifications->setAction("app_depot_dossier_edit");
  1270.                     //     $notifications->setActionId($depotDossier->getId());
  1271.                     //     $notifications->setSender($this->getUser());
  1272.                     //     $notifications->setStatuts("non lu");
  1273.                     //     $notifications->setDate(new DateTime());
  1274.             
  1275.                     //     $notificationsRepository->add($notifications, true);
  1277.                     //     $admins = $equipeRepository->findAll();
  1279.                     //     foreach ($admins as $key => $value) {
  1281.                     //         $listPermissions = $value->getPermissions();
  1283.                     //         foreach ($listPermissions as $v) {
  1284.                     //             if($v == "NOTIFICATION" ){
  1285.                     //                 $notificationsAdmin = new Notifications();
  1286.                     //                 $notificationsAdmin->setUserId($value->getUser());
  1287.                     //                 $notificationsAdmin->setMessage("Le contrôle n°1 du dossier ".$depotDossier->getNumero()." a été validé.");
  1288.                     //                 $notificationsAdmin->setAction("app_depot_dossier_edit");
  1289.                     //                 $notificationsAdmin->setActionId($depotDossier->getId());
  1290.                     //                 $notificationsAdmin->setSender($this->getUser());
  1291.                     //                 $notificationsAdmin->setStatuts("non lu");
  1292.                     //                 $notificationsAdmin->setDate(new DateTime());
  1293.                         
  1294.                     //                 $notificationsRepository->add($notificationsAdmin, true);
  1295.                     //             }
  1296.                     //         }
  1297.                     //     }
  1299.                         
  1300.                     // }else{
  1302.                     // }
  1303.                     
  1305.                         
  1306.                         
  1307.                     
  1308.                    
  1310.                     return $this->json(['success' => true, 'message' => 'blocage adresse']);
  1311.              }
  1312.         }
  1314.         return $this->json(['success' => false, 'error' => 'Erreur ']);
  1315.     }
  1317.     /**
  1318.      * @Route("/exportedepot/{id}", name="app_exporte_depot",  methods={"GET"})
  1319.      */
  1320.     public function exporte(Filtre $filtre,DepotDossierRepository $depotDossierRepository,FiltreRepository $filtreRepository): Response
  1321.     {
  1322.         
  1323.         
  1324.         $jsonFilePath = 'assets/json/dossier-list.json';
  1326.         // Étape 1 : Récupérer le contenu JSON depuis le fichier
  1327.         $jsonContent = file_get_contents($jsonFilePath);
  1329.         // Étape 2 : Décoder le contenu JSON en tableau PHP
  1330.         $phpArray = json_decode($jsonContent, true);
  1332.       
  1333.         // Créer un nouveau classeur Excel
  1334.         $spreadsheet = new Spreadsheet();
  1335.                 
  1336.         // Obtenir la feuille active
  1337.         $sheet = $spreadsheet->getActiveSheet();
  1339.         // Écrire des données dans la feuille
  1340.         $sheet->setCellValue('A1', 'Numéro dossier');
  1341.         $sheet->setCellValue('B1', 'Operation');
  1342.         $sheet->setCellValue('C1', 'Nom du Beneficiaire');
  1343.         $sheet->setCellValue('D1', 'Deal associé');
  1344.         $sheet->setCellValue('E1', 'Controller');
  1345.         $sheet->setCellValue('F1', 'Controller');
  1346.         $sheet->setCellValue('G1', 'Cumac');
  1347.         $sheet->setCellValue('H1', 'Status');
  1348.         $i=2;
  1349.         
  1350.         if ($phpArray === null) {
  1351.             echo "Erreur lors du décodage JSON : " . json_last_error_msg();
  1352.         } else {
  1353.             // Utilisez le tableau PHP $phpArray comme bon vous semble
  1354.             foreach ($phpArray as $value) {
  1355.                 $dl=$depotDossierRepository->findOneBy(["id"=>intval($value["id"])]);
  1356.                 $sheet->setCellValue('A'.$i, $dl->getNumero());
  1357.                 $ops="";
  1358.                 $opi=0;
  1359.                 foreach ($dl->getOperation() as $key => $op) {
  1360.                     if ($opi>0) {
  1361.                         $ops.=";"; 
  1362.                     }
  1363.                     $ops.=explode(':',$op->getNom())[0];
  1364.                 
  1365.                     $opi=$opi + 1;
  1366.                 }
  1368.                 $sheet->setCellValue('B'.$i, $ops);
  1369.                 $sheet->setCellValue('C'.$i, $dl->getNomclient().' '.$dl->getPrenomclient());
  1370.                 $sheet->setCellValue('D'.$i,  $dl->getDeal()->getNumero());
  1371.                 if ($dl->getControler1() != null) {
  1372.                     $sheet->setCellValue('E'.$i, $dl->getControler1()->getPrenom());
  1373.                 }
  1374.                 if ($dl->getControler2() != null) {
  1375.                     $sheet->setCellValue('F'.$i, $dl->getControler2()->getPrenom());
  1376.                 }
  1377.                
  1378.                 
  1379.                 $sheet->setCellValue('G'.$i, $dl->getCumac());
  1380.                 $sheet->setCellValue('H'.$i, $dl->getStatus());
  1381.                 $i=$i+1;
  1382.             }
  1383.         }
  1385.        
  1386.         // Créer un objet Writer pour enregistrer le fichier
  1387.         $writer = new Xlsx($spreadsheet);
  1389.         // Enregistrer le fichier à un emplacement
  1390.         $now = new DateTime();
  1392.                 $date = $now->format('d-m-Y H-i-s');
  1393.         $nomexecel = "deal-".$this->getUser()->getEquipe()->getPrenom()."-".$date;
  1394.         $cheminFichier =$this->getParameter('installateur_directory') . "/export/export".$nomexecel.".xlsx";
  1395.         $writer->save($cheminFichier);
  1396.         $filtre->setExporte("export".$nomexecel.".xlsx");
  1397.         $filtreRepository->add($filtre, true);
  1398.         // Renvoyer la réponse avec le fichier Excel en pièce jointe
  1399.         return $this->file($cheminFichier);
  1401.     }
  1403.     
  1404.        /**
  1405.      * @Route("/{id}/archives", name="app_depot_archives", methods={"GET", "POST"})
  1406.      */
  1407.     public function archives(Request $request,DepotDossier $depotDossier): Response
  1408.     {
  1409.         
  1411.         if ($request->getMethod() == "POST") {
  1413.             $form = $request->request;
  1414.         
  1415.        
  1416.         // Créez un nom de fichier unique pour le fichier ZIP
  1417.         $zipFileName = 'DepotDossier_'.$depotDossier->getDeal()->getInstallateur()->getSociete().'_' . date('d-m-Y-His') . '.zip';
  1418.     
  1419.         // Créez le chemin absolu vers le fichier ZIP
  1420.         $zipFilePath = $this->getParameter('installateur_directory') . '/archiver/' . $zipFileName;
  1421.     
  1422.         // Utilisez la classe ZipArchive pour créer le fichier ZIP
  1423.         $zip = new \ZipArchive();
  1424.         $zip->open($zipFilePath, \ZipArchive::CREATE | \ZipArchive::OVERWRITE);
  1425.     
  1426.       
  1427.             
  1428.             if ($form->get("chk_archiverdepot") != null ) {
  1429.                 foreach ($form->get("chk_archiverdepot") as $key => $champs) {
  1430.                     foreach ($depotDossier->getChampsDepotDossiers() as $value) {
  1431.                         if ($value->getType()=="file") {
  1432.                             if ($value->getId() == $champs) {
  1433.                                 if ($value->getValeur()!=null) {
  1434.                                     foreach ($value->getValeur() as $val) {
  1435.                                         $filePath = $this->getParameter('installateur_directory').'/'.$val;
  1436.                                         $relativePath = $depotDossier->getDeal()->getInstallateur()->getSociete()."/".$val;
  1437.                                         $zip->addFile($filePath, $relativePath);
  1438.                                     }
  1439.                                     
  1440.                                 }
  1441.                             }
  1442.                         }
  1443.                         
  1444.                          
  1445.                     }
  1446.                 }
  1447.             }
  1449.            
  1451.            
  1452.             
  1455.             // Fermer le fichier ZIP
  1456.             $zip->close();
  1458.             // Envoyer le fichier ZIP en tant que réponse de téléchargement
  1459.             $response = new BinaryFileResponse($zipFilePath);
  1460.             $response->headers->set('Content-Type', 'application/zip');
  1461.             $response->setContentDisposition(ResponseHeaderBag::DISPOSITION_ATTACHMENT, $zipFileName);
  1464.             // if ($filesystem->exists($sourceFolder)) {
  1465.             //     // Supprimez tous les fichiers et dossiers à l'intérieur du dossier
  1466.             //     $filesystem->remove(glob($sourceFolder . '/*'));
  1467.             // }
  1468.             return $response;
  1469.             }
  1470.             return $this->redirectToRoute('app_depot_dossier_edit', ['id' =>$depotDossier->getId()], Response::HTTP_SEE_OTHER);
  1471.       
  1473.        
  1474.         
  1475.     }
  1476.     
  1477.      /**
  1478.      * @Route("/{id}/appel", name="app_depot_appel", methods={"GET", "POST"})
  1479.      */
  1480.     public function appel(Request $request,DepotDossier $depotDossier,AppelqualiteRepository $appelqualiteRepository,CommentaireAppelqualiteRepository $commentaireAppelqualiteRepository): Response
  1481.     {
  1482.         
  1484.         if ($request->getMethod() == "POST") {
  1486.             $form = $request->request;
  1487.             $appelqualite = new Appelqualite();
  1488.             $appelqualite->setClient($form ->get('questionclient'));
  1489.             $appelqualite->setAdresse($form ->get('questionadresse'));
  1490.             $appelqualite->setInstallation($form ->get('questioninstallation'));
  1491.             $appelqualite->setTerminer($form ->get('questionterminer'));
  1492.             $appelqualite->setQualite($form ->get('questionqualite'));
  1493.             $appelqualite->setComplet($form ->get('questioncomplet'));
  1494.             $appelqualite->setSpecifique($form ->get('questionspecifique'));
  1495.             $appelqualite->setDossier($depotDossier);
  1496.             $appelqualite->setStatus($form ->get('statusappel'));
  1497.             if ($form ->get('nonclient')) {
  1498.                 $appelqualite->setNonclient($form ->get('nonclient'));
  1499.             }
  1500.             if ($form ->get('nonadresse')) {
  1501.                 $appelqualite->setNonclient($form ->get('nonadresse'));
  1502.             }
  1503.             if ($form ->get('noninstallation')) {
  1504.                 $appelqualite->setNoninstallation($form ->get('noninstallation'));
  1505.             }
  1506.             if ($form ->get('nonterminer')) {
  1507.                 $appelqualite->setNontermier($form ->get('nonterminer'));
  1508.             }
  1509.             if ($form ->get('noncomplete')) {
  1510.                 $appelqualite->setNoncomplete($form ->get('noncomplete'));
  1511.             }
  1512.             if ($form ->get('nonspecifique')) {
  1513.                 $appelqualite->setNonspecifique($form ->get('nonspecifique'));
  1514.             }
  1515.             
  1516.             if ($form ->get('ouiqualite')) {
  1517.                 $appelqualite->setOuiqualite($form ->get('ouiqualite'));
  1518.             }
  1519.             
  1520.             if ($this->getUser()->getEquipe()) {
  1521.                 $appelqualite->setEquipe($this->getUser()->getEquipe());
  1522.             }
  1523.             $appelqualiteRepository->add($appelqualite, true);
  1524.             if ($form ->get('commentaire') != null) {
  1525.                 $commentaireAppelqualite = new CommentaireAppelqualite();
  1526.                     
  1527.                 $commentaireAppelqualite->setCommentaire($form ->get('commentaire'));
  1528.                 $commentaireAppelqualite->setDate(new DateTime());
  1529.                 $commentaireAppelqualite->setAppelqualite($appelqualite);
  1530.                 $commentaireAppelqualite->setUser($this->getUser());
  1531.     
  1532.                 $commentaireAppelqualiteRepository->add($commentaireAppelqualite, true);
  1533.             }
  1534.             
  1536.       
  1537.            
  1538.         }
  1539.         return $this->redirectToRoute('app_depot_dossier_edit', ['id' =>$depotDossier->getId()], Response::HTTP_SEE_OTHER);
  1540.       
  1542.        
  1543.         
  1544.     }
  1546.      /**
  1547.      * @Route("/appel/{id}/edit", name="app_depot_appel_edit", methods={"GET", "POST"})
  1548.      */
  1549.     public function editappel(Request $request,Appelqualite $appelqualite,AppelqualiteRepository $appelqualiteRepository): Response
  1550.     {
  1551.         
  1553.         if ($request->getMethod() == "POST") {
  1555.             $form = $request->request;
  1556.             $appelqualite->setClient($form ->get('questionclient'));
  1557.             $appelqualite->setAdresse($form ->get('questionadresse'));
  1558.             $appelqualite->setInstallation($form ->get('questioninstallation'));
  1559.             $appelqualite->setTerminer($form ->get('questionterminer'));
  1560.             $appelqualite->setQualite($form ->get('questionqualite'));
  1561.             $appelqualite->setComplet($form ->get('questioncomplet'));
  1562.             $appelqualite->setSpecifique($form ->get('questionspecifique'));
  1563.             $appelqualite->setStatus($form ->get('statusappel'));
  1564.             if ($this->getUser()->getEquipe()) {
  1565.                 $appelqualite->setEquipe($this->getUser()->getEquipe());
  1566.             }
  1567.             if ($form ->get('nonclient')) {
  1568.                 $appelqualite->setNonclient($form ->get('nonclient'));
  1569.             }
  1570.             if ($form ->get('nonadresse')) {
  1571.                 $appelqualite->setNonclient($form ->get('nonadresse'));
  1572.             }
  1573.             if ($form ->get('noninstallation')) {
  1574.                 $appelqualite->setNoninstallation($form ->get('noninstallation'));
  1575.             }
  1576.             if ($form ->get('nonterminer')) {
  1577.                 $appelqualite->setNontermier($form ->get('nonterminer'));
  1578.             }
  1579.             if ($form ->get('noncomplete')) {
  1580.                 $appelqualite->setNoncomplete($form ->get('noncomplete'));
  1581.             }
  1582.             if ($form ->get('nonspecifique')) {
  1583.                 $appelqualite->setNonspecifique($form ->get('nonspecifique'));
  1584.             }
  1585.             
  1586.             if ($form ->get('ouiqualite')) {
  1587.                 $appelqualite->setOuiqualite($form ->get('ouiqualite'));
  1588.             }
  1589.             
  1590.             
  1591.             if ($this->getUser()->getEquipe()) {
  1592.                 $appelqualite->setEquipe($this->getUser()->getEquipe());
  1593.             }
  1594.             
  1595.             $appelqualiteRepository->add($appelqualite, true);
  1596.       
  1597.            
  1598.         }
  1599.         return $this->redirectToRoute('app_depot_dossier_edit', ['id' =>$appelqualite->getDossier()->getId()], Response::HTTP_SEE_OTHER);
  1600.       
  1602.        
  1603.         
  1604.     }
  1605.     
  1607.     /**
  1608.      * @Route("/archiverdossier/{id}", methods={"POST"})
  1609.      */
  1610.     public function archiverdossier(Request $request,DepotDossier $depotDossier,DepotDossierRepository $depotDossierRepository): JsonResponse
  1611.     { 
  1612.         
  1613.         
  1614.   
  1615.         if ($request->getMethod() == "POST") {
  1616.             
  1617.             // $file=$request->files->get('validedocument');
  1618.             $id = $request->request->get('id');
  1619.           
  1620.              if ($id) {
  1621.                 $depotDossier->setArchive($depotDossier->getStatus());
  1622.                 $depotDossier->setStatus("archive"); 
  1623.                 $depotDossierRepository->add($depotDossier, true);
  1624.             
  1625.         
  1626.                 return $this->json(['success' => true, 'message' => 'deal archive']);
  1627.              }
  1628.         }
  1630.         return $this->json(['success' => false, 'error' => 'Erreur ']);
  1631.     }
  1633.     
  1635. }