src/Controller/DealController.php line 483

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\Deal;
  6. use App\Entity\HistoriqueDeal;
  7. use App\Entity\ChampsDeal;
  8. use App\Entity\ChampsDefautDeal;
  9. use App\Entity\CommentaireDeal;
  10. use App\Form\DealType;
  11. use App\Repository\DealRepository;
  12. use App\Repository\ChampsDealRepository;
  13. use App\Repository\EquipeRepository;
  14. use App\Repository\ChampsDefautRepository;
  15. use App\Repository\ChampsDefautDealRepository;
  16. use App\Repository\ChampsInstallateurRepository;
  17. use App\Repository\HistoriqueDealRepository;
  18. use App\Repository\OperationStandardRepository;
  19. use App\Repository\UserRepository;
  20. use App\Repository\CommentaireDealRepository;
  21. use App\Repository\NotificationsRepository;
  22. use App\Repository\SoustraitantRepository;
  23. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  24. use Symfony\Component\HttpFoundation\Request;
  25. use Symfony\Component\HttpFoundation\Response;
  26. use Symfony\Component\Routing\Annotation\Route;
  27. use App\Entity\Champs;
  28. use App\Entity\Notifications;
  29. use App\Repository\InstallateurRepository;
  30. use App\Repository\ObligesRepository;
  31. use Datetime;
  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 App\Repository\ApporteurAffaireRepository;
  39. use App\Repository\ActiviteDealRepository;
  40. use App\Repository\ContratRepository;
  41. use App\Repository\FactureAafRepository;
  42. use App\Repository\AppelqualiteRepository;
  43. use App\Entity\ActiviteDeal;
  44. use App\Repository\ChampsSoustraitantRepository;
  45. use App\Repository\DepotDossierRepository;
  46. use App\Repository\ChampsDepotDossierRepository;
  47. use App\Repository\CommentairesControlleRepository;
  48. use App\Repository\DealobligeRepository;
  49. use Symfony\Component\HttpFoundation\JsonResponse;
  50. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  51. use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
  53. /**
  54.  * @Route("/deal")
  55.  */
  56. class DealController extends AbstractController
  57. {
  58.     /**
  59.      * @Route("/", name="app_deal_index", methods={"GET", "POST"})
  60.      */
  61.     public function index(Request $request,DealRepository $dealRepository,InstallateurRepository $installateurRepository,ObligesRepository $obligesRepository,
  62.     ChampsDefautRepository $champsDefautRepository, ChampsInstallateurRepository $champsInstallateurRepository, UserRepository $userRepository, 
  63.     HistoriqueDealRepository $historiqueDealRepository, OperationStandardRepository $operationStandardRepository): Response
  64.     {
  66.        
  67.         $idexporte=0;
  68.         $exporte ="non";
  69.         if ($this->isGranted('ROLE_INSTALLATEUR')) {
  70.             $deal=$this->getUser()->getInstallateur()->getDeals();
  71.         }elseif($this->isGranted('ROLE_OBLIGE')){
  72.             $deal=$this->getUser()->getObliges()->getDeals();
  73.         }else{
  74.             $deal=[];
  75.             
  76.             if ($request->getMethod() == "POST") {
  78.                 $form = $request->request;
  79.                 if($form->get("filtreinstallateur") != null ){
  80.                     foreach ($form->get("filtreinstallateur") as $value) {
  81.                         foreach ($dealRepository->findBy([], ['id' => 'DESC']) as $dl) {
  82.                             if ($dl->getInstallateur()->getId() == $value) {
  83.                                 
  84.                                 if ($form->get("filtreoblige") != null) {
  85.                                     
  86.                                    foreach ($form->get("filtreoblige") as  $obg) {
  87.                                         if ($dl->getDealoblige()->getOblige()->getId() == $obg) {
  88.                                             //dd($form->get("filtrestatus"));
  89.                                             if ($form->get("filtrestatus") != null) {
  90.                                                 foreach ($form->get("filtrestatus") as $status) {
  91.                                                     if ($dl->getStatus() == $status ) {
  92.                                                         $deal[]=$dl;
  93.                                                     }
  94.                                                 }
  95.                                             }else{
  96.                                                 $deal[]=$dl;
  97.                                             }
  98.                                         }
  99.                                     }
  100.                                 } else {
  101.                                     if ($form->get("filtrestatus") != null) {
  102.                                         foreach ($form->get("filtrestatus") as $status) {
  103.                                             if ($dl->getStatus() == $status ) {
  104.                                                 $deal[]=$dl;
  105.                                             }
  106.                                         }
  107.                                     } else {
  108.                                         $deal[]=$dl;
  109.                                     }
  110.                                     
  111.                                    
  112.                                 }
  113.                                 
  114.                             }
  115.                         }
  116.                     }
  117.                 }else{
  118.                     if ($form->get("filtreoblige") != null) {
  119.                         foreach ($dealRepository->findBy([], ['id' => 'DESC']) as $dl) {
  120.                             foreach ($form->get("filtreoblige") as  $obg) {
  121.                                 if ($dl->getDealoblige()->getOblige()->getId() == $obg) {
  122.                                     //dd($form->get("filtrestatus"));
  123.                                     if ($form->get("filtrestatus") != null) {
  124.                                         foreach ($form->get("filtrestatus") as $status) {
  125.                                             if ($dl->getStatus() == $status ) {
  126.                                                 $deal[]=$dl;
  128.                                             }
  129.                                         }
  130.                                     }else{
  131.                                         $deal[]=$dl;
  132.                                     }
  133.                                 }
  134.                             }
  135.                         }
  136.                     }else{
  137.                         if ($form->get("filtrestatus") != null) {
  138.                             foreach ($dealRepository->findBy([], ['id' => 'DESC']) as $dl) {
  139.                                 foreach ($form->get("filtrestatus") as $status) {
  140.                                     if ($dl->getStatus() == $status ) {
  141.                                         $deal[]=$dl;
  142.                                     }
  143.                                 }
  144.                             }
  145.                         }else{
  146.                             $deal= $dealRepository->findBy([], ['id' => 'DESC']);
  147.                         }
  149.                     }
  150.                 }
  151.              $exporte ="oui";
  152.             }else{
  153.                 
  154.                 $deal= $dealRepository->findBy([], ['id' => 'DESC']);
  155.             }
  156.         }
  158.         $tab=[];
  159.         $deals=[];
  161.         $statuts = ["Contrat généré","Annulé","Bloqué","Contrat Signé","Validé", "En Attente","Nouveau"];
  163.         
  164.         // id,type as owner,client as name ,date,file ,batiment
  165.         $i = 1;
  166.         foreach ($statuts as $statut) {
  167.             foreach ($deal as  $value) {
  168.             
  169.                 if($statut == $value->getStatus()){
  170.                   if ($idexporte == 0) {
  171.                     $idexporte=$value->getId();
  172.                   }
  173.                     $tab['id']=$i;
  174.                     $tab['id_deal']=$value->getId();
  175.                     $tab['name']=$value->getNumero();  
  176.                     $tab['owner']=$value->getInstallateur()->getSociete();
  177.                     $tab['owner_id']=$value->getInstallateur()->getId();
  178.                     if($value->getDate()){
  179.                         $tab['industry_type']=$value->getDate()->format('d-m-Y');
  180.                     }
  181.                     if($value->getTaux()){
  182.                      $tab['location']=$value->getTaux();
  183.                     }
  184.                     if($value->getDealoblige()){
  185.                         $tab['contact_email']=$value->getDealoblige()->getOblige()->getSociete();
  186.                         $tab['contact_email_id']=$value->getDealoblige()->getOblige()->getId();
  187.                     }
  188.                    
  189.                     $tab['icone']="ri-archive-line";
  190.                     if($value->getDatefin()){
  191.                         $dateTime2 = $value->getDatefin();
  192.                         $formattedDate2 = $dateTime2->format('d/m/Y');
  193.                         $tab['datefin']=$formattedDate2; 
  194.                     }
  195.                     
  196.                     
  198.                     $tab['action_deal']=[];
  199.                     $historique = null;
  200.                    if ($historiqueDealRepository->findBy(["deal" => $value->getId()])) {
  201.                         foreach ($historiqueDealRepository->findBy(["deal" => $value->getId()]) as $hist) {
  202.                             $historique = $hist;
  203.                         }
  204.                    }
  205.                    
  206.                     if($historique != null) {
  207.                         $userModif = $userRepository->findOneBy(["id" => $historique->getUser()]);
  209.                         if($userModif->getInstallateur() != null){
  210.                             $tab['action_deal']['action_id']=$userModif->getInstallateur()->getId();  
  211.                             $tab['action_deal']['action_nom']=$userModif->getInstallateur()->getNom();  
  212.                             $tab['action_deal']['action_prenom']=$userModif->getInstallateur()->getPrenom();  
  213.                             $tab['action_deal']['action_photo']= $userModif->getInstallateur()->getPhoto() != null ? "https://kaje-cee.net/assets/uplaod-installateur/".$userModif->getInstallateur()->getPhoto() : "https://kaje-cee.net/assets/images/user.png";
  214.                             $tab['action_deal']['action_role']="Installateur";  
  215.                         } else{
  216.                             $tab['action_deal']['action_id']=$userModif->getEquipe()->getId();  
  217.                             $tab['action_deal']['action_nom']=$userModif->getEquipe()->getNom();  
  218.                             $tab['action_deal']['action_prenom']=$userModif->getEquipe()->getPrenom();   
  219.                             $tab['action_deal']['action_photo']=$userModif->getEquipe()->getPhoto() != null ? "https://kaje-cee.net/assets/uplaod-equipe/".$userModif->getEquipe()->getPhoto() : "https://kaje-cee.net/assets/images/user.png";
  220.                             $tab['action_deal']['action_role']="Administrateur"; 
  221.                         }
  223.                         $dateTime = $historique->getDate();
  224.                         $formattedDate = $dateTime->format('d/m/Y');
  225.                         $tab['action_deal']['action_date']=$formattedDate; 
  226.                         $tab['action_deal']['action_commentaire']=$historique->getAction(); 
  227.                     }
  229.                     
  231.                     $tab['employee']="deal";
  232.                     if ($value->getStatus()=='Validé') {
  233.                         $tab['star_value']='<span class="badge progress-green p-2 border-0" >'.$value->getStatus().'</span>';
  234.                         $tab['row_tr']='row-green';
  235.                     } elseif($value->getStatus()=="Annulé") {
  236.                         $tab['star_value']='<span class="badge progress-red p-2 border-0" >'.$value->getStatus().'</span>';
  237.                         $tab['row_tr']='row-red';
  238.                     }elseif($value->getStatus()=="Bloqué") {
  239.                         $tab['star_value']='<span class="badge progress-red p-2 border-0" >'.$value->getStatus().'</span>';
  240.                         $tab['row_tr']='row-red';
  241.                     }
  242.                     elseif($value->getStatus()=="Contrat Déposé"){
  243.                         $tab['star_value']='<span class="badge progress-yellow p-2 border-0" >'.$value->getStatus().'</span>';
  244.                         $tab['row_tr']='row-yellow';
  245.                     }elseif($value->getStatus()=="Contrat Signé"){
  246.                         $tab['star_value']='<span class="badge progress-blue p-2 border-0" >'.$value->getStatus().'</span>';
  247.                         $tab['row_tr']='row-blue';
  248.                     }elseif($value->getStatus()=="Contrat généré"){
  249.                         $tab['star_value']='<span class="badge progress-yellow p-2 border-0" >'.$value->getStatus().'</span>';
  250.                         $tab['row_tr']='row-blue';
  251.                     }elseif($value->getStatus()=="En Attente"){
  252.                         $tab['star_value']='<span class="badge progress-yellow p-2 border-0" >'.$value->getStatus().'</span>';
  253.                         $tab['row_tr']='row-yellow';
  254.                     }else{
  255.                         $tab['star_value']='<span class="badge progress-grey p-2 border-0" >Nouveau</span>';
  256.                         $tab['row_tr']='row-grey';
  257.                     }
  259.                     $champsInstallateur = $value->getInstallateur()->getChampsinstallateur();
  261.                     if(count($champsInstallateur) > 0){
  262.                         foreach ( $champsInstallateur as $champ) {
  263.                             if($champ->getNom() == "KBIS"){
  264.                             
  265.             
  266.                                 if ($champ->getStatus()=='Validé') {
  267.                                     $tab['kbis']='<button class="badge progress-green p-2 border-0" >'.$champ->getStatus().'</button>';
  268.                                 } elseif($champ->getStatus()=="Non Valide") {
  269.                                     $tab['kbis']='<button class="badge progress-red p-2 border-0" >'.$champ->getStatus().'</button>';
  270.                                 }elseif($champ->getStatus()=="Transmis"){
  271.                                     $tab['kbis']='<button class="badge progress-yellow p-2 border-0" >'.$champ->getStatus().'</button>';
  272.                                 }else{
  273.                                     $tab['kbis']='<button class="badge progress-grey p-2 border-0" >Non Transmis</button>';
  274.                                 }
  275.                                 
  276.                             }
  277.                         }
  278.                     } else {
  279.                         
  280.                         $tab['kbis']='<button class="badge progress-grey p-2 border-0" >Non Transmis</button>';
  281.                     }
  282.                 
  284.                     // logo, nom, prenom, role de la personne
  285.                     // date
  286.                     
  287.                     
  288.                     $tab['image_src']="https://kaje-cee.net/#";
  289.                     $deals[]=$tab;
  290.                     $i=$i + 1;
  291.                 }
  292.             }
  293.             
  294.         }
  295.         // dd($deals);
  296.         // die();
  299.         $clientjson = json_encode($deals);
  300.         file_put_contents('assets/json/deal-list.json', $clientjson);
  302.         return $this->render('deal/index.html.twig', [
  303.             'deals' => $dealRepository->findAll(),
  304.             'listinstallateurs' => $installateurRepository->findBy(["status"=>'Validé']),
  305.             'listobliges' => $obligesRepository->findAll(),
  306.             'champs' => $champsDefautRepository->findAll(),
  307.             'allInstallateurs' => $installateurRepository->findAll(),
  308.             'operationsStandard' => $operationStandardRepository->findAll(),
  309.             'exporte' => $exporte,
  310.             'idexporte' => $idexporte
  312.         ]);
  313.     }
  315.     /**
  316.      * @Route("/archivesdeal", name="app_deal_archivesdeal", methods={"GET", "POST"})
  317.      */
  318.     public function archivesdeal(Request $request,DealRepository $dealRepository,InstallateurRepository $installateurRepository,ObligesRepository $obligesRepository,
  319.     ChampsDefautRepository $champsDefautRepository, ChampsInstallateurRepository $champsInstallateurRepository, UserRepository $userRepository, 
  320.     HistoriqueDealRepository $historiqueDealRepository, OperationStandardRepository $operationStandardRepository): Response
  321.     {
  323.  
  324.         $deal= $dealRepository->findBy(['status' => 'archive'], ['id' => 'DESC']);
  325.         $tab=[];
  326.         $deals=[];
  328.         $statuts = ["archive"];
  330.         
  331.         // id,type as owner,client as name ,date,file ,batiment
  332.         $i = 1;
  333.         foreach ($statuts as $statut) {
  334.             foreach ($deal as  $value) {
  335.             
  336.                 if($statut == $value->getStatus()){
  337.                 
  338.                     $tab['id']=$i;
  339.                     $tab['id_deal']=$value->getId();
  340.                     $tab['name']=$value->getNumero();  
  341.                     $tab['owner']=$value->getInstallateur()->getSociete();
  342.                     $tab['owner_id']=$value->getInstallateur()->getId();
  343.                     if ($value->getDate()) {
  344.                     $tab['industry_type']=$value->getDate()->format('d-m-Y');
  345.                     }
  346.                     $tab['location']=$value->getTaux();
  347.                     if ($value->getDealoblige()->getOblige()) {
  348.                         $tab['contact_email']=$value->getDealoblige()->getOblige()->getSociete();
  349.                         $tab['contact_email_id']=$value->getDealoblige()->getOblige()->getId();
  350.                     }
  351.                     
  352.                     $tab['icone']="ri-delete-bin-fill";
  353.                     if ($value->getDatefin()) {
  354.                     $dateTime2 = $value->getDatefin();
  355.                     $formattedDate2 = $dateTime2->format('d/m/Y');
  356.                     $tab['datefin']=$formattedDate2; 
  357.                       }
  358.                     $tab['action_deal']=[];
  359.                     $historique = null;
  360.                    if ($historiqueDealRepository->findBy(["deal" => $value->getId()])) {
  361.                         foreach ($historiqueDealRepository->findBy(["deal" => $value->getId()]) as $hist) {
  362.                             $historique = $hist;
  363.                         }
  364.                    }
  365.                    
  366.                     if($historique != null) {
  367.                         $userModif = $userRepository->findOneBy(["id" => $historique->getUser()]);
  369.                         if($userModif->getInstallateur() != null){
  370.                             $tab['action_deal']['action_id']=$userModif->getInstallateur()->getId();  
  371.                             $tab['action_deal']['action_nom']=$userModif->getInstallateur()->getNom();  
  372.                             $tab['action_deal']['action_prenom']=$userModif->getInstallateur()->getPrenom();  
  373.                             $tab['action_deal']['action_photo']= $userModif->getInstallateur()->getPhoto() != null ? "https://kaje-cee.net/assets/uplaod-installateur/".$userModif->getInstallateur()->getPhoto() : "https://kaje-cee.net/assets/images/user.png";
  374.                             $tab['action_deal']['action_role']="Installateur";  
  375.                         } else{
  376.                             $tab['action_deal']['action_id']=$userModif->getEquipe()->getId();  
  377.                             $tab['action_deal']['action_nom']=$userModif->getEquipe()->getNom();  
  378.                             $tab['action_deal']['action_prenom']=$userModif->getEquipe()->getPrenom();   
  379.                             $tab['action_deal']['action_photo']=$userModif->getEquipe()->getPhoto() != null ? "https://kaje-cee.net/assets/uplaod-equipe/".$userModif->getEquipe()->getPhoto() : "https://kaje-cee.net/assets/images/user.png";
  380.                             $tab['action_deal']['action_role']="Administrateur"; 
  381.                         }
  383.                         $dateTime = $historique->getDate();
  384.                         $formattedDate = $dateTime->format('d/m/Y');
  385.                         $tab['action_deal']['action_date']=$formattedDate; 
  386.                         $tab['action_deal']['action_commentaire']=$historique->getAction(); 
  387.                     }
  389.                     
  391.                     $tab['employee']="deal";
  392.                     if($value->getStatus()=="archive") {
  393.                         $tab['star_value']='<span class="badge progress-red p-2 border-0" >'.$value->getStatus().'</span>';
  394.                         $tab['row_tr']='row-red';
  395.                     }
  396.                    
  398.                     $champsInstallateur = $value->getInstallateur()->getChampsinstallateur();
  400.                     if(count($champsInstallateur) > 0){
  401.                         foreach ( $champsInstallateur as $champ) {
  402.                             if($champ->getNom() == "KBIS"){
  403.                             
  404.             
  405.                                 if ($champ->getStatus()=='Validé') {
  406.                                     $tab['kbis']='<button class="badge progress-green p-2 border-0" >'.$champ->getStatus().'</button>';
  407.                                 } elseif($champ->getStatus()=="Non Valide") {
  408.                                     $tab['kbis']='<button class="badge progress-red p-2 border-0" >'.$champ->getStatus().'</button>';
  409.                                 }elseif($champ->getStatus()=="Transmis"){
  410.                                     $tab['kbis']='<button class="badge progress-yellow p-2 border-0" >'.$champ->getStatus().'</button>';
  411.                                 }else{
  412.                                     $tab['kbis']='<button class="badge progress-grey p-2 border-0" >Non Transmis</button>';
  413.                                 }
  414.                                 
  415.                             }
  416.                         }
  417.                     } else {
  418.                         
  419.                         $tab['kbis']='<button class="badge progress-grey p-2 border-0" >Non Transmis</button>';
  420.                     }
  421.                 
  423.                     // logo, nom, prenom, role de la personne
  424.                     // date
  425.                     
  426.                     
  427.                     $tab['image_src']="https://kaje-cee.net/#";
  428.                     $deals[]=$tab;
  429.                     $i=$i + 1;
  430.                 }
  431.             }
  432.             
  433.         }
  434.         // dd($deals);
  435.         // die();
  438.         $clientjson = json_encode($deals);
  439.         file_put_contents('assets/json/deal-list.json', $clientjson);
  441.         return $this->render('deal/archivesdeal.html.twig', [
  442.             'deals' => $dealRepository->findAll(),
  443.             'allInstallateurs' => $installateurRepository->findAll()
  444.         ]);
  445.     }
  446.     
  447.     
  448.      /**
  449.      * @Route("/dealdesarchives", name="app_deal_desarchives", methods={"GET", "POST"})
  450.      */
  451.     public function dealdesarchives(Request $request,DepotDossierRepository $depotDossierRepository,DealRepository $dealRepository): Response
  452.     {
  453.         if ($request->getMethod() == "POST") {
  455.             $form = $request->request; 
  456.            //dd($form);
  457.            if ($form->get("chk_deal") != null) {
  458.                 foreach ($form->get("chk_deal") as $key => $value) {
  459.                     $deal = $dealRepository->findOneBy(["id"=>intval($value)]);
  460.                    
  461.                    if ($deal->getDepotDossiers() != null) {
  462.                         foreach ($deal->getDepotDossiers() as $key => $dossier) {
  463.                             $dossier->setStatus($dossier->getArchive());
  464.                             $depotDossierRepository->add($dossier, true);
  465.                         }
  467.                    }
  468.                    
  469.                     $deal->setStatus($deal->getArchive());
  470.                     $dealRepository->add($deal, true);
  471.                    
  472.                     
  473.                 }
  475.            }
  476.         }
  477.         return $this->redirectToRoute('app_deal_index', [], Response::HTTP_SEE_OTHER);
  478.     }
  480.     /**
  481.      * @Route("/new", name="app_deal_new", methods={"GET", "POST"})
  482.      */
  483.     public function new(Request $request, DealRepository $dealRepository,InstallateurRepository $installateurRepository,
  484.     ObligesRepository $obligesRepository,ChampsDealRepository $champsDealRepository,ChampsDefautDealRepository $champsDefautDealRepository,
  485.     ChampsDefautRepository $champsDefautRepository,OperationStandardRepository $operationStandardRepository,
  486.     ApporteurAffaireRepository $apporteurAffaireRepository,ActiviteDealRepository $activiteDealRepository,
  487.     NotificationsRepository $notificationsRepository, HistoriqueDealRepository $historiqueDealRepository,DealobligeRepository $dealobligeRepository): Response
  488.     {
  489.         $deal = new Deal();
  490.         if ($request->getMethod() == "POST") {
  492.                 $form = $request->request;
  493.                 $dealoblige= $dealobligeRepository->findOneBy(["id"=>intval($form->get('oblige'))]);
  494.                 $installateur= $installateurRepository->findOneBy(["id"=>intval($form->get('installateur'))]);
  495.                 $deal->setNumero($dealoblige->getNom().'-'.$installateur->getSociete());
  496.                 $deal->setType($form->get('parties'));
  497.                 $deal->setTaux($form->get('taux'));
  498.                 $cible='';
  499.                 // dd($form->get('cible'));
  500.                  if ($form->get('cible')) {
  501.                      foreach ($form->get('cible') as $key => $value) {
  502.                         
  503.                              $cible.=$value."-";
  504.                          
  505.                          
  506.                      }
  507.                  }
  508.                 
  509.                  $deal->setCible($cible); 
  510.                 $date = date('d-m-Y', strtotime($form->get('date'))) ;
  511.                 
  512.                 $datetime = new Datetime($date);
  513.                 $deal->setDatefin($datetime); 
  514.                 $deal->setDate(new Datetime()); 
  515.                 $deal->setStatus("Nouveau"); 
  516.                 
  518.                 
  519.                 
  520.                 
  521.                 $deal->setInstallateur($installateur);
  523.                 
  524.                 $deal->setOblige($dealoblige->getOblige());
  525.                 $deal->setDealoblige($dealoblige);
  526.                 $oblige=$dealoblige->getOblige();
  527.                 if ($form->get('apporteur')!=null) {
  528.                     
  529.                     $apporteur= $apporteurAffaireRepository->findOneBy(["id"=>intval($form->get('apporteur'))]);
  530.                     $deal->setApporteurAffaire($apporteur);
  532.                 }
  534.                 $dealRepository->add($deal, true);
  535.                 
  537.                 foreach ($oblige->getChampsobliges() as  $chmps) {
  538.                        $champsDeal = new ChampsDeal();
  539.                       
  540.                        $champsDeal->setNom($chmps->getNom());
  541.                        $champsDeal->setType($chmps->getType());
  542.                        if ($chmps->getType()== 'file') {
  543.                         $champsDeal->setStatus('Non Transmis');
  544.                        }
  545.                        $champsDeal->setDurevalidite($chmps->getDurevalidite());
  546.                        $champsDeal->setDeal($deal);
  547.                        
  548.                        $champsDealRepository->add($champsDeal, true);
  549.                 }
  550.                 foreach ($form as $key => $value) {
  551.                     
  552.                     if (count(explode("_",$key)) >2 && explode("_",$key)[1]=="old"){
  553.                         
  554.                         $champsDeal = new ChampsDeal();
  555.                        $chmps= $champsDefautDealRepository->find(["id"=>intval($value)]);
  556.                        $champsDeal->setNom($chmps->getNom());
  557.                        $champsDeal->setType($chmps->getType());
  558.                        if ($chmps->getType()== 'file') {
  559.                         $champsDeal->setStatus('Non Transmis');
  560.                        }
  561.                        $champsDeal->setDurevalidite($chmps->getDurevalidite());
  562.                        $champsDeal->setDeal($deal);
  563.                        
  564.                        $champsDealRepository->add($champsDeal, true);
  565.     
  566.                     }
  567.                     
  568.                     if ( count(explode("_",$key)) >2 && explode("_",$key)[2]=="type") {
  569.     
  570.                         if (explode("_",$key)[3]=="nom") {
  571.                             $champs->setNom($value);
  572.                            
  573.                         }elseif(explode("_",$key)[3]=="dure"){
  574.                             
  575.                             if($value!=null){
  576.                                 $champs->setDurevalidite($value);
  577.                             }
  578.                             
  579.                             $champsDefautDealRepository->add($champs, true);
  580.     
  581.                             $champsDeal = new ChampsDeal();
  582.     
  583.                             $champsDeal->setNom($champs->getNom());
  584.                             $champsDeal->setType($champs->getType());
  585.                             if ($champs->getType()== 'file') {
  586.                                 $champsDeal->setStatus('Non Transmis');
  587.                                }
  588.                             $champsDeal->setDurevalidite($champs->getDurevalidite());
  589.                             $champsDeal->setDeal($deal);
  590.                             $champsDealRepository->add($champsDeal, true);
  592.                         }
  593.                         else{
  594.                             
  595.                             $champs = new ChampsDefautDeal();
  596.                             $champs->setType($value);
  597.                         }
  598.                    
  599.                     }
  601.                 }
  602.                // Notif Installateur
  603.                $notifications = new Notifications();
  604.                $notifications->setUserId($installateur->getUser());
  605.                $notifications->setMessage("Vous avez un nouveau deal. Veuillez remplir les informations.");
  606.                $notifications->setAction("app_deal_edit");
  607.                $notifications->setActionId($deal->getId());
  608.                $notifications->setSender($this->getUser());
  609.                $notifications->setStatuts("non lu");
  610.                $notifications->setDate(new DateTime());
  611.                
  612.                $notificationsRepository->add($notifications, true);
  613.                
  614.                // Notif Obligé
  615.                $notificationsOblige = new Notifications();
  616.                $notificationsOblige->setUserId($oblige->getUser());
  617.                $notificationsOblige->setMessage("Un nouveau deal a été créé.");
  618.                $notificationsOblige->setAction("app_deal_edit");
  619.                $notificationsOblige->setActionId($deal->getId());
  620.                $notificationsOblige->setSender($this->getUser());
  621.                $notificationsOblige->setStatuts("non lu");
  622.                $notificationsOblige->setDate(new DateTime());
  623.                
  624.                $notificationsRepository->add($notificationsOblige, true);
  626.                 $activiteDeal = new ActiviteDeal();
  627.                 $activiteDeal->setFonction('equipe');
  628.                 $activiteDeal->setEquipe($this->getUser()->getEquipe());
  629.                 $activiteDeal->setCommentaire("Création du Deal entre l'installateur ".$deal->getInstallateur()->getSociete()." et l'obligé ".$deal->getDealoblige()->getOblige()->getSociete());
  630.                 $activiteDeal->setDate(new Datetime());
  631.                 $activiteDeal->setDeal($deal);
  632.                 $activiteDealRepository->add($activiteDeal, true);
  634.                 // Historique
  635.                $historiqueDeal = new HistoriqueDeal();
  636.                $historiqueDeal->setUser($this->getUser());
  637.                $historiqueDeal->setDeal($deal);
  638.                $historiqueDeal->setDate(new DateTime());
  639.                $historiqueDeal->setAction("Création du Deal ".$deal->getNumero());
  640.                $historiqueDealRepository->add($historiqueDeal, true);
  642.                 return $this->redirectToRoute('app_deal_edit', ['id' =>$deal->getId()], Response::HTTP_SEE_OTHER);
  643.         }
  644.         // $form = $this->createForm(DealType::class, $deal);
  645.         // $form->handleRequest($request);
  647.         // if ($form->isSubmitted() && $form->isValid()) {
  648.         //     $dealRepository->add($deal, true);
  650.         //     return $this->redirectToRoute('app_deal_index', [], Response::HTTP_SEE_OTHER);
  651.         // }
  652.         // 'listinstallateurs' => $installateurRepository->findBy(["status"=>'Validé']),
  653.         if ($request->query->get('insparam') != null ) {
  654.             $idinstallateurGet = $request->query->get('insparam');
  655.         } else {
  656.             $idinstallateurGet = 0;
  657.         }
  659.         return $this->renderForm('deal/new.html.twig', [
  660.             'deal' => $deal,
  661.             'listinstallateurs' => $installateurRepository->findAll(),
  662.             'listobliges' => $obligesRepository->findAll(),
  663.             'listdealobliges' => $dealobligeRepository->findAll(),
  664.             'champs' => $champsDefautRepository->findAll(),
  665.             'dealoperations' => $operationStandardRepository->findAll(),
  666.             'listapporteurs' => $apporteurAffaireRepository->findAll(),
  667.             'idinstallateurGet' => $idinstallateurGet
  668.         ]);
  669.     }
  672.     /**
  673.      * @Route("/{id}", name="app_deal_show", methods={"GET"})
  674.      */
  675.     public function show(Deal $deal): Response
  676.     {
  677.         if ($this->isGranted('ROLE_INSTALLATEUR')) {
  678.             $deals=$this->getUser()->getInstallateur()->getDeals();
  679.             foreach ($deals as  $value) {
  680.                 if ($value->getId() == $deal->getId()) {
  681.                     return $this->redirectToRoute('app_deal_edit', ['id' =>$deal->getId()], Response::HTTP_SEE_OTHER);
  682.                 }
  683.             }
  684.             return $this->redirectToRoute('app_deal_index', [], Response::HTTP_SEE_OTHER);
  685.          
  686.         }else{
  687.             return $this->redirectToRoute('app_deal_edit', ['id' =>$deal->getId()], Response::HTTP_SEE_OTHER);
  688.         }
  689.        
  690.     }
  693.      /**
  694.      * @Route("/{id}/edit", name="app_deal_edit", methods={"GET", "POST"})
  695.      */
  696.     public function edit(Request $request, Deal $deal, DealRepository $dealRepository,ChampsDealRepository $champsDealRepository,
  697.     ChampsDefautDealRepository $champsDefautDealRepository,ActiviteDealRepository $activiteDealRepository,NotificationsRepository $notificationsRepository, 
  698.     EquipeRepository $equipeRepository, HistoriqueDealRepository $historiqueDealRepository,SoustraitantRepository $soustraitantRepository,
  699.     OperationStandardRepository $operationStandardRepository): Response
  700.     {
  703.         $dealCommentaire = $deal->getCommentaire();
  705.         
  706.         $isCompleted = "oui";
  708.         if ($this->isGranted('ROLE_INSTALLATEUR')) {
  709.             
  710.             if ($this->getUser()->getInstallateur()->getId() != $deal->getInstallateur()->getId()) {
  711.                 return $this->redirectToRoute('app_deal_index', [], Response::HTTP_SEE_OTHER);
  712.             }
  713.             if($deal->getInstallateur()->getNom() == null || $deal->getInstallateur()->getPrenom() == null || $deal->getInstallateur()->getSociete() == null || 
  714.                 $deal->getInstallateur()->getPhone() == null || $deal->getInstallateur()->getEmail() == null || $deal->getInstallateur()->getAdresse() == null ){
  715.                     $isCompleted = "non";
  716.             }
  718.             foreach($deal->getInstallateur()->getChampsinstallateur() as $key => $value){
  719.                 if($value->getType() !="file" && $value->getValeur() == null){
  720.                     $isCompleted = "non";
  721.                 }
  723.                 if($value->getType() =="file" && $value->getStatus() == "Non Transmis"){
  724.                     $isCompleted = "non";
  725.                 }
  728.             }
  730.             if(count($deal->getInstallateur()->getOperationStandards()) < 1){
  731.                 $isCompleted = "non";
  732.             }
  733.         }
  734.         
  735.         if ($request->getMethod() == "POST") {
  736.             
  737.             $form = $request->request;
  738.            
  739.             // $deal->setNumero($form->get('nom'));
  740.             if (!$this->isGranted('ROLE_INSTALLATEUR')) {
  742.                 $deal->setNumero($form->get('nom'));
  743.                 if($form->get('parties')){
  744.                     $deal->setType($form->get('parties'));
  745.                 }
  746.                 if($form->get('taux')){
  747.                     $deal->setTaux($form->get('taux'));
  748.                 }
  749.                
  750.                 $cible='';
  751.                // dd($form->get('cible'));
  752.                 if ($form->get('cible')) {
  753.                     foreach ($form->get('cible') as $key => $value) {
  754.                        
  755.                             $cible.=$value."-";
  756.                         
  757.                         
  758.                     }
  759.                     $deal->setCible($cible); 
  760.                 }
  761.                
  762.                 
  763.                     $date = date('d-m-Y', strtotime($form->get('date'))) ;
  764.                 
  765.                     $datetime = new Datetime($date);
  766.                     // var_dump($form->get('date'));
  767.                     // var_dump($date);
  768.                     //  var_dump($datetime);die('test');
  769.                 $deal->setDatefin($datetime); 
  770.                 $deal->setDate(new Datetime()); 
  773.                 
  774.                 
  775.                 $deal->setCommentaire($form->get('commentaire')); 
  776.                
  777.                 
  779.             }
  780.             if ($form->get('soustraitants') != null) {
  781.                 foreach ($deal->getSoustraitants() as  $value) {
  782.                     if (!in_array($value->getId(),$form->get('soustraitants'))) {
  783.                      $deal->removeSoustraitant($value);
  784.                     }
  785.                  }
  786.                  foreach ($form->get('soustraitants') as  $value) {
  787.                     $soustraitant= $soustraitantRepository->findOneBy(["id"=>intval($value)]);
  788.                     
  789.                     $deal->addSoustraitant($soustraitant);
  790.                 }
  791.                }else{
  792.                 foreach ($deal->getSoustraitants() as  $value) {
  793.                    
  794.                      $deal->removeSoustraitant($value);
  795.                     
  796.                  }
  797.                }
  799.             if ($form->get('operations') != null) {
  800.                 foreach ($deal->getOperation() as  $value) {
  801.                     if (!in_array($value->getId(),$form->get('operations'))) {
  802.                         $deal->removeOperation($value);
  803.                     }
  804.                  }
  805.                  foreach ($form->get('operations') as  $value) {
  806.                     $ops= $operationStandardRepository->findOneBy(["id"=>intval($value)]);
  807.                     $deal->addOperation($ops);
  808.                 }
  809.                }else{
  810.                 foreach ($deal->getOperation() as  $value) {
  811.                    
  812.                     $deal->removeOperation($value);
  813.                     
  814.                  }
  815.                }
  817.                 $activiteDeal = new ActiviteDeal();
  818.                 $historiqueDeal = new HistoriqueDeal();
  819.                 if ($this->isGranted('ROLE_INSTALLATEUR')) {
  820.                     $activiteDeal->setFonction('installateur');
  821.                     $activiteDeal->setInstallateur($this->getUser()->getInstallateur());
  822.                     $activiteDeal->setCommentaire("Modification des éléments ");
  823.                     $historiqueDeal->setAction("Modification du Deal ".$deal->getNumero());
  824.                 }else{
  825.                     $activiteDeal->setFonction('equipe');
  826.                     $activiteDeal->setEquipe($this->getUser()->getEquipe());
  827.                     if($deal->getStatus() != $form->get('status')){
  828.                         $activiteDeal->setCommentaire($this->getUser()->getEquipe()->getPrenom()." a modifié le statut en : ".$form->get('status'));
  829.                         $historiqueDeal->setAction($this->getUser()->getEquipe()->getPrenom()." a modifié le statut en : ".$form->get('status'));
  830.                      }else{
  831.                         $activiteDeal->setCommentaire("Modification des éléments ");
  832.                         $historiqueDeal->setAction("Modification du Deal ".$deal->getNumero());
  833.                      }
  834.                      $deal->setStatus($form->get('status')); 
  835.                 }
  836.                 
  837.                 
  838.                 $activiteDeal->setDate(new Datetime());
  839.                 $activiteDeal->setDeal($deal);
  840.                 $activiteDealRepository->add($activiteDeal, true);
  842.                 // Historique
  843.                
  844.                $historiqueDeal->setUser($this->getUser());
  845.                $historiqueDeal->setDeal($deal);
  846.                $historiqueDeal->setDate(new DateTime());
  847.                
  848.                $historiqueDealRepository->add($historiqueDeal, true);
  852.            
  853.            
  855.             $dealRepository->add($deal, true);
  856.             if ($form->get('status') == "Validé") {
  857.                 // Notif Installateur
  858.                $notifications = new Notifications();
  859.                $notifications->setUserId($deal->getInstallateur()->getUser());
  860.                $notifications->setMessage("Deal ".$deal->getNumero()." est Validé !!!");
  861.                $notifications->setAction("app_deal_edit");
  862.                $notifications->setActionId($deal->getId());
  863.                $notifications->setSender($this->getUser());
  864.                $notifications->setStatuts("non lu");
  865.                $notifications->setDate(new DateTime());
  866.                
  867.                $notificationsRepository->add($notifications, true);
  868.     
  869.     
  870.                $activiteDeal = new ActiviteDeal();
  871.                $activiteDeal->setFonction('equipe');
  872.                $activiteDeal->setEquipe($this->getUser()->getEquipe());
  873.                $activiteDeal->setCommentaire("Deal ".$deal->getNumero()." est Validé !!!");
  874.                $activiteDeal->setDate(new Datetime());
  875.                $activiteDeal->setDeal($deal);
  876.                $activiteDealRepository->add($activiteDeal, true);
  877.             }
  878.           
  881.        
  884.             foreach ($form as $key => $value) {
  885.                     if (count(explode("-",$key)) ==2 && explode("-",$key)[0]=="champsinstallateur") {
  886.                         $id=$form->get('champsinstvaleur-'.explode("-",$key)[1]);
  887.                         $champsinst= $champsDealRepository->findOneBy(["id" => $id]);
  888.                         $valeur=[];
  889.                         $valeur[]=$value;
  890.                         if ($champsinst->getValeur() != null ) {
  891.                             foreach ($champsinst->getValeur() as $key => $val) {
  892.                                 $valeur[]=$val;
  893.                             }
  894.                         }
  895.                         
  896.                         $champsinst->setValeur($valeur);
  898.                         // $champsinst->setValeur($value);
  899.                         if ($champsinst->getStatus()==null) {
  900.                             $champsinst->setStatus('Non Transmis');
  901.                          }else{
  902.                             $champsinst->setStatus('Transmis');
  903.                          }
  904.                         $date = new Datetime();
  905.                         $champsinst->setDate($date);
  906.                         $champsDealRepository->add($champsinst, true);
  907.                       
  908.                     }
  909.     
  910.                     if (count(explode("_",$key)) >2 && explode("_",$key)[1]=="old"){
  911.                         
  912.                         $champsDeal = new ChampsDeal();
  913.                        $chmps= $champsDefautDealRepository->find(["id"=>intval($value)]);
  914.                        $champsDeal->setNom($chmps->getNom());
  915.                        $champsDeal->setType($chmps->getType());
  916.                        if($chmps->getDurevalidite()!=null){
  917.                            $champsDeal->setDurevalidite($chmps->getDurevalidite());
  918.                          }
  919.                        if ($champsDeal->getStatus()==null) {
  920.                                 $champsDeal->setStatus('Non Transmis');
  921.                             }else{
  922.                                 $champsDeal->setStatus('Transmis');
  923.                             }
  924.                        $champsDeal->setDeal($deal);
  925.                        
  926.                        $champsDealRepository->add($champsDeal, true);
  927.     
  928.                     }
  929.                     
  930.                     if ( count(explode("_",$key)) >2 && explode("_",$key)[2]=="type") {
  931.     
  932.                         if (explode("_",$key)[3]=="nom") {
  933.                             $champs->setNom($value);
  935.                             if($champs->getType() != "file"){
  936.                                 $champsDefautDealRepository->add($champs, true);
  937.                                 $champsDeal = new ChampsDeal();
  938.                                 $champsDeal->setNom($champs->getNom());
  939.                                 $champsDeal->setType($champs->getType());
  940.                                 $champsDeal->setDeal($deal);
  941.                                 $champsDealRepository->add($champsDeal, true);
  942.                             }
  943.                             
  944.     
  945.                         }elseif(explode("_",$key)[3]=="dure"){
  946.                             if($champs->getType() == "file"){
  947.                             $champsDeal = new ChampsDeal();
  948.     
  949.                             if($value!=null){
  950.                                 $champsDeal->setDurevalidite($value);
  951.                             }
  952.                             $champsDeal->setNom($champs->getNom());
  953.                             $champsDeal->setType($champs->getType());
  954.                             $champsDeal->setDeal($deal);
  955.                             if ($champsDeal->getStatus()==null) {
  956.                                 $champsDeal->setStatus('Non Transmis');
  957.                             }else{
  958.                                 $champsDeal->setStatus('Transmis');
  959.                             }
  960.                             $champsDealRepository->add($champsDeal, true);
  961.                             }
  962.                         }
  963.                         else{
  964.                             
  965.                             $champs = new ChampsDefautDeal();
  966.                             $champs->setType($value);
  967.                         }
  968.                    
  969.                     }
  970.             }
  971.                 
  973.             return $this->redirectToRoute('app_deal_edit', ['id' =>$deal->getId()], Response::HTTP_SEE_OTHER);
  974.         }
  976.         // $form = $this->createForm(DealType::class, $deal);
  977.         // $form->handleRequest($request);
  979.         // if ($form->isSubmitted() && $form->isValid()) {
  980.         //     $dealRepository->add($deal, true);
  982.         //     return $this->redirectToRoute('app_deal_index', [], Response::HTTP_SEE_OTHER);
  983.         // }
  984.        
  985.         if ($this->isGranted('ROLE_INSTALLATEUR')) {
  986.             $notif = $notificationsRepository->findAll(["user_id" => $deal->getInstallateur()->getUser(),"statuts"=> "non lu", "action" => "app_deal_edit", "action_id" => $deal->getId()]);
  988.             if ($notif) {
  990.                 foreach ($notif as $key => $value) {
  991.                     $datefinnotif = $value->getDate();
  992.                     $dateday2 = new DateTime();
  993.                     // Ajouter 2 jours
  994.                     $datefinnotif->modify('+2 days');
  995.                    // dd($datefinnotif);
  996.                         $value->setStatuts("lu");
  997.                         $notificationsRepository->add($value, true);
  998.                     // if ($dateday2 > $datefinnotif) {
  999.                         
  1000.                     // }
  1001.                    
  1002.                 }
  1003.                 
  1004.             }
  1005.            
  1006.         }
  1008.         
  1009.         
  1010.         $champsdefaut=[];
  1011.         $champsvalide=0;
  1012.         foreach ($deal->getChampsdeal() as $champs) {
  1013.                 foreach ($champsDefautDealRepository->findAll()  as  $value) {
  1014.                     if ($value->getNom() == $champs->getNom()) {
  1015.                         $champsdefaut[]=$value;
  1016.                     }
  1017.                 }
  1018.                 if ($champs->getStatus() != "Validé" and $champs->getType() == "file" ) {
  1019.                     $champsvalide=$champsvalide + 1;
  1020.                 }
  1021.                
  1022.         }
  1023.         foreach ($deal->getInstallateur()->getChampsinstallateur() as $champs) {
  1024.             if ($champs->getStatus() != "Validé" and $champs->getType() == "file" ) {
  1025.                 $champsvalide=$champsvalide + 1;
  1026.             }
  1027.         }
  1028.         //dd($champsvalide);
  1029.         return $this->renderForm('deal/edit.html.twig', [
  1030.             'deal' => $deal,
  1031.             'champsdefaut' => $champsdefaut,
  1032.             "dateday"=>new Datetime(),
  1033.             'isCompleted' => $isCompleted,
  1034.             'champsvalide' => $champsvalide,
  1035.             'operationsStandars' => $operationStandardRepository->findAll(),
  1036.         ]);
  1037.     }
  1038.     
  1040.     /**
  1041.      * @Route("/{id}", name="app_deal_delete", methods={"POST"})
  1042.      */
  1043.     public function delete(Request $request, Deal $deal, DealRepository $dealRepository,ChampsDealRepository $champsDealRepository,ActiviteDealRepository $activiteDealRepository
  1044.     , NotificationsRepository $notificationsRepository,HistoriqueDealRepository $historiqueDealRepository,FactureAafRepository $factureAafRepository,AppelqualiteRepository $appelqualiteRepository,
  1045.     SoustraitantRepository $soustraitantRepositor,ContratRepository $contratRepository,
  1046.     DepotDossierRepository $depotDossierRepository,ChampsDepotDossierRepository $champsDepotDossierRepository,CommentairesControlleRepository $commentairesControlleRepository): Response
  1047.     {
  1048.         if ($this->isCsrfTokenValid('delete'.$deal->getId(), $request->request->get('_token'))) {
  1050.             foreach ($deal->getChampsDeal() as  $value) {
  1051.            
  1052.                 $deal->removeChampsDeal($value);
  1054.                 $champsDealRepository->remove($value, true);
  1055.                
  1056.             }
  1057.             foreach ($notificationsRepository->findBy(["action_id"=>$deal->getId()]) as  $value) {
  1058.                 $notificationsRepository->remove($value, true);
  1059.              }
  1061.             foreach ($deal->getActiviteDeals() as  $value) {
  1062.            
  1063.                 $deal->removeActiviteDeal($value);
  1065.                 $activiteDealRepository->remove($value, true);
  1066.                
  1067.             }
  1068.             foreach ($deal->getHistoriqueDeals() as  $value) {
  1069.            
  1070.                 $deal->removeHistoriqueDeal($value);
  1072.                 $historiqueDealRepository->remove($value, true);
  1073.                
  1074.             }
  1075.             foreach ($deal->getOperation() as  $value) {
  1076.            
  1077.                 $deal->removeOperation($value);
  1079.                 
  1080.                
  1081.             }
  1082.             if($deal->getApporteurAffaire()){
  1083.                 $deal->setApporteurAffaire(NULL);
  1084.             }
  1085.             
  1086.             
  1087.             foreach ($deal->getDepotDossiers() as $dossier) {
  1088.            
  1089.                 foreach ($dossier->getChampsDepotDossiers() as $champdossier) {
  1090.                     $champsDepotDossierRepository->remove($champdossier, true);
  1091.                 }
  1093.                 foreach ($dossier->getCommentairesControlles() as $commentaire) {
  1094.                     $commentairesControlleRepository->remove($commentaire, true);
  1095.                 }
  1096.                 foreach ($dossier->getSoustraitants() as  $value) {
  1097.            
  1098.                     $dossier->removeSoustraitant($value);
  1099.     
  1100.                    // $soustraitantRepository->remove($value, true);
  1101.                    
  1102.                 }
  1104.                 foreach ($dossier->getFactureAafs() as  $value) {
  1105.        
  1106.                     // $depotDossier->removeFactureAaf($value);
  1107.                     foreach ($value->getCommentaireFactureaafs() as  $commentaire) {
  1109.                         $value->removeCommentaireFactureaaf($commentaire);
  1110.         
  1111.                         // $activiteDealRepository->remove($commentaire, true);
  1112.                     
  1113.                     }
  1114.                     $factureAafRepository->remove($value, true);
  1115.                    
  1116.                 }
  1117.     
  1118.                 foreach ($dossier->getAppelqualites() as  $value) {
  1119.                     foreach ($value->getCommentaireAppelqualites() as  $commentaire) {
  1121.                         $value->removeCommentaireAppelqualite($commentaire);
  1122.         
  1123.                         // $activiteDealRepository->remove($commentaire, true);
  1124.                     
  1125.                     }
  1126.                     // $depotDossier->removeAppelqualite($value);
  1127.     
  1128.                     $appelqualiteRepository->remove($value, true);
  1129.                    
  1130.                 }
  1134.                 $depotDossierRepository->remove($dossier, true);
  1135.         
  1136.             }
  1137.             foreach ($deal->getCommentaireDeals() as  $commentaire) {
  1138.                     
  1139.                 $deal->removeCommentaireDeal($commentaire);
  1141.                 // $activiteDealRepository->remove($commentaire, true);
  1142.             
  1143.             }
  1144.             
  1145.             foreach ($deal->getSoustraitants() as  $soustritant) {
  1147.                 $deal->removeSoustraitant($soustritant);
  1149.                 // $activiteDealRepository->remove($commentaire, true);
  1150.             
  1151.             }
  1152.             if($deal->getContrat()){
  1153.                 foreach ($deal->getContrat()->getCommentaireContrats() as  $commentaire) {
  1155.                     $deal->getContrat()->removeCommentaireContrat($commentaire);
  1156.     
  1157.                     // $activiteDealRepository->remove($commentaire, true);
  1158.                 
  1159.                 }
  1160.                 $contratRepository->remove($deal->getContrat(), true);
  1161.             }
  1162.             
  1163.             
  1164.             
  1165.             $dealRepository->remove($deal, true);
  1166.         }
  1168.         return $this->redirectToRoute('app_deal_index', [], Response::HTTP_SEE_OTHER);
  1169.     }
  1172.     /**
  1173.      * @Route("/zip/{id}", name="app_deal_zip",  methods={"GET", "POST"})
  1174.      */
  1175.     public function zip(Deal $deal,Request $request): Response
  1176.     {
  1177.         
  1179.        
  1180.         // Créez un nom de fichier unique pour le fichier ZIP
  1181.         $zipFileName = 'Archiver_Deal_'.$deal->getInstallateur()->getSociete().'_' . date('d-m-Y-His') . '.zip';
  1182.     
  1183.         // Créez le chemin absolu vers le fichier ZIP
  1184.         $zipFilePath = $this->getParameter('installateur_directory') . '/archiver/' . $zipFileName;
  1185.     
  1186.         // Utilisez la classe ZipArchive pour créer le fichier ZIP
  1187.         $zip = new \ZipArchive();
  1188.         $zip->open($zipFilePath, \ZipArchive::CREATE | \ZipArchive::OVERWRITE);
  1189.     
  1190.         
  1191.             
  1192.        
  1193.             foreach ($deal->getInstallateur()->getChampsinstallateur() as $value) {
  1194.                 if ($value->getType()=="file") {
  1195.                     if ($value->getValeur()!=null) {
  1197.                         
  1198.                      $filePath = $this->getParameter('installateur_directory')."/".$value->getValeur()[0];
  1199.                      $relativePath = $deal->getInstallateur()->getSociete()."/".$value->getValeur()[0];
  1200.                      if (file_exists($filePath)) {
  1201.                         $zip->addFile($filePath, $relativePath);
  1202.                     }
  1203.                     // $zip->addFile($filePath, $relativePath);
  1204.                     }
  1205.                  }
  1206.                 
  1207.                  
  1208.             }
  1211.             foreach ($deal->getChampsDeal() as $value) {
  1212.                 if ($value->getType()=="file") {
  1213.                     if ($value->getValeur()!=null) {
  1215.                      //dd($value->getValeur()[0]);
  1216.                      $filePath = $this->getParameter('installateur_directory')."/".$value->getValeur()[0];
  1217.                      $relativePath = $deal->getInstallateur()->getSociete()."/".$value->getValeur()[0];
  1218.                      if (file_exists($filePath)) {
  1219.                         $zip->addFile($filePath, $relativePath);
  1220.                     }
  1221.                     // $zip->addFile($filePath, $relativePath);
  1222.                     }
  1223.                  }
  1224.                 
  1225.                  
  1226.             }
  1229.             // Fermer le fichier ZIP
  1230.             $zip->close();
  1232.             // Envoyer le fichier ZIP en tant que réponse de téléchargement
  1233.             $response = new BinaryFileResponse($zipFilePath);
  1234.             $response->headers->set('Content-Type', 'application/zip');
  1235.             $response->setContentDisposition(ResponseHeaderBag::DISPOSITION_ATTACHMENT, $zipFileName);
  1238.             // if ($filesystem->exists($sourceFolder)) {
  1239.             //     // Supprimez tous les fichiers et dossiers à l'intérieur du dossier
  1240.             //     $filesystem->remove(glob($sourceFolder . '/*'));
  1241.             // }
  1242.             return $response;
  1244.                 // return $this->redirectToRoute('app_installateur_sow', ['id' => $this->getUser()->getInstallateur()->getId()], Response::HTTP_SEE_OTHER);
  1245.       
  1247.        
  1248.         
  1249.     }
  1251.         /**
  1252.      * @Route("/{id}/archives", name="app_deal_archives", methods={"GET", "POST"})
  1253.      */
  1254.     public function archives(Request $request,Deal $deal): Response
  1255.     {
  1256.         
  1258.         if ($request->getMethod() == "POST") {
  1260.             $form = $request->request;
  1261.         
  1262.        
  1263.         // Créez un nom de fichier unique pour le fichier ZIP
  1264.         $zipFileName = 'Deal_'.$deal->getInstallateur()->getSociete().'_' . date('d-m-Y-His') . '.zip';
  1265.     
  1266.         // Créez le chemin absolu vers le fichier ZIP
  1267.         $zipFilePath = $this->getParameter('installateur_directory') . '/archiver/' . $zipFileName;
  1268.     
  1269.         // Utilisez la classe ZipArchive pour créer le fichier ZIP
  1270.         $zip = new \ZipArchive();
  1271.         $zip->open($zipFilePath, \ZipArchive::CREATE | \ZipArchive::OVERWRITE);
  1272.     
  1273.       
  1274.             
  1276.             // foreach ($deal->getInstallateur()->getChampsinstallateur() as $value) {
  1277.             //     if ($value->getType()=="file") {
  1278.             //         if ($value->getValeur()!=null) {
  1280.                      
  1281.             //          $filePath = $this->getParameter('installateur_directory').'/'.$value->getValeur();
  1282.             //          $relativePath = $deal->getInstallateur()->getSociete()."/".$value->getValeur();
  1283.             //          $zip->addFile($filePath, $relativePath);
  1284.             //         }
  1285.             //      }
  1286.                 
  1287.                  
  1288.             // }
  1289.             if ($form->get("chk_archiverdeal") != null ) {
  1290.                 foreach ($form->get("chk_archiverdeal") as $key => $champs) {
  1291.                     foreach ($deal->getChampsDeal() as $value) {
  1292.                         if ($value->getType()=="file") {
  1293.                             if ($value->getId() == $champs) {
  1294.                                 if ($value->getValeur()!=null) {
  1295.                                     foreach ($value->getValeur() as $val) {
  1296.                                         $filePath = $this->getParameter('installateur_directory').'/'.$val;
  1297.                                         $relativePath = $deal->getInstallateur()->getSociete()."/".$val;
  1298.                                         $zip->addFile($filePath, $relativePath);
  1299.                                     }
  1300.                                     
  1301.                                 }
  1302.                             }
  1303.                         }
  1304.                         
  1305.                          
  1306.                     }
  1307.                 }
  1308.             }
  1310.             if ($form->get("chk_archiverinstallateur") != null ) {
  1311.                 foreach ($form->get("chk_archiverinstallateur") as $key => $champs) {
  1312.                     foreach ($deal->getInstallateur()->getChampsinstallateur() as $value) {
  1313.                         if ($value->getType()=="file") {
  1314.                             if ($value->getId() == $champs) {
  1315.                                 if ($value->getValeur()!=null) {
  1316.                                     foreach ($value->getValeur() as $val) {
  1317.                                         $filePath = $this->getParameter('installateur_directory').'/'.$val;
  1318.                                         $relativePath = $deal->getInstallateur()->getSociete()."/".$val;
  1319.                                         $zip->addFile($filePath, $relativePath);
  1320.                                     }
  1321.                                     
  1322.                                 }
  1323.                             }
  1324.                         }
  1325.                         
  1326.                          
  1327.                     }
  1328.                 }
  1329.             }
  1331.            
  1332.             
  1335.             // Fermer le fichier ZIP
  1336.             $zip->close();
  1338.             // Envoyer le fichier ZIP en tant que réponse de téléchargement
  1339.             $response = new BinaryFileResponse($zipFilePath);
  1340.             $response->headers->set('Content-Type', 'application/zip');
  1341.             $response->setContentDisposition(ResponseHeaderBag::DISPOSITION_ATTACHMENT, $zipFileName);
  1344.             // if ($filesystem->exists($sourceFolder)) {
  1345.             //     // Supprimez tous les fichiers et dossiers à l'intérieur du dossier
  1346.             //     $filesystem->remove(glob($sourceFolder . '/*'));
  1347.             // }
  1348.             return $response;
  1349.             }
  1350.             return $this->redirectToRoute('app_deal_edit', ['id' =>$deal->getId()], Response::HTTP_SEE_OTHER);
  1351.       
  1353.        
  1354.         
  1355.     }
  1357.   /**
  1358.      * @Route("/commentaire/{id}", methods={"POST"})
  1359.      */
  1360.     public function commentaire(Request $request,CommentaireDealRepository $commentaireDealRepository,Deal $deal): JsonResponse
  1361.     { 
  1362.         
  1363.         
  1364.   
  1365.         if ($request->getMethod() == "POST") {
  1366.             
  1367.             // $file=$request->files->get('validedocument');
  1368.             $commentaire = $request->request->get('commentaire');
  1369.           
  1370.              if ($commentaire) {
  1371.                
  1372.                     $commentaireDeal = new CommentaireDeal();
  1373.                     
  1374.                     $commentaireDeal->setCommentaire($commentaire);
  1375.                     $commentaireDeal->setDate(new DateTime());
  1376.                     $commentaireDeal->setDeal($deal);
  1377.                     $commentaireDeal->setUser($this->getUser());
  1379.                     $commentaireDealRepository->add($commentaireDeal, true);
  1381.                    
  1382.                         
  1383.                         
  1384.                     
  1385.                    
  1387.                     return $this->json(['success' => true, 'message' => 'commentaire ajouter ']);
  1388.              }
  1389.         }
  1391.         return $this->json(['success' => false, 'error' => 'Erreur ']);
  1392.     }
  1393.     
  1394.      /**
  1395.      * @Route("/archiverdeal/{id}", methods={"POST"})
  1396.      */
  1397.     public function archiverdeal(Request $request,Deal $deal,DealRepository $dealRepository,
  1398.     DepotDossierRepository $depotDossierRepository): JsonResponse
  1399.     { 
  1400.         
  1401.         
  1402.   
  1403.         if ($request->getMethod() == "POST") {
  1404.             
  1405.             // $file=$request->files->get('validedocument');
  1406.             $id = $request->request->get('id');
  1407.           
  1408.              if ($id) {
  1409.                
  1410.                     foreach ($deal->getDepotDossiers() as $key => $dossier) {
  1412.                         $dossier->setArchive($dossier->getStatus());
  1413.                         $dossier->setStatus("archive"); 
  1414.                         $depotDossierRepository->add($dossier, true);
  1415.                     }
  1416.                     $deal->setArchive($deal->getStatus());
  1417.                     $deal->setStatus("archive");
  1418.                     $dealRepository->add($deal, true);
  1419.                       
  1420.                     return $this->json(['success' => true, 'message' => 'deal archive']);
  1421.              }
  1422.         }
  1424.         return $this->json(['success' => false, 'error' => 'Erreur ']);
  1425.     }
  1428.     /**
  1429.      * @Route("/suprimercommentaire/{id}", methods={"POST"})
  1430.      */
  1431.     public function suprimercommentaire(Request $request ,CommentaireDealRepository $commentaireDealRepository,CommentaireDeal $commentaireDeal): JsonResponse
  1432.     { 
  1433.         
  1434.         
  1435.   
  1436.         if ($request->getMethod() == "POST") {
  1437.             
  1438.             // $file=$request->files->get('validedocument');
  1439.             $id = $request->request->get('id');
  1440.             
  1441.              if ($id) {
  1443.                     
  1444.                 $commentaireDealRepository->remove($commentaireDeal, true);
  1446.                    
  1447.                     
  1448.                     return $this->json(['success' => true, 'message' => 'champs supprimer succès']);
  1449.              }
  1450.         }
  1452.         return $this->json(['success' => false, 'error' => 'Erreur ']);
  1453.     }
  1454.   
  1455.     /**
  1456.      * @Route("/exporte/{id}", name="app_exporte",  methods={"GET"})
  1457.      */
  1458.     public function exporte(Deal $deal,DealRepository $dealRepository): Response
  1459.     {
  1460.         
  1461.         
  1462.         $jsonFilePath = 'assets/json/deal-list.json';
  1464.         // Étape 1 : Récupérer le contenu JSON depuis le fichier
  1465.         $jsonContent = file_get_contents($jsonFilePath);
  1467.         // Étape 2 : Décoder le contenu JSON en tableau PHP
  1468.         $phpArray = json_decode($jsonContent, true);
  1470.       
  1471.         // Créer un nouveau classeur Excel
  1472.         $spreadsheet = new Spreadsheet();
  1473.                 
  1474.         // Obtenir la feuille active
  1475.         $sheet = $spreadsheet->getActiveSheet();
  1477.         // Écrire des données dans la feuille
  1478.         $sheet->setCellValue('A1', 'Deal');
  1479.         $sheet->setCellValue('B1', 'Installateur');
  1480.         $sheet->setCellValue('C1', 'Oblige');
  1481.         $sheet->setCellValue('D1', 'Date de Fin');
  1482.         $sheet->setCellValue('E1', 'Status');
  1483.         $i=2;
  1484.         
  1485.         if ($phpArray === null) {
  1486.             echo "Erreur lors du décodage JSON : " . json_last_error_msg();
  1487.         } else {
  1488.             // Utilisez le tableau PHP $phpArray comme bon vous semble
  1489.             foreach ($phpArray as $value) {
  1490.                 $dl=$dealRepository->findOneBy(["id"=>intval($value["id_deal"])]);
  1491.                 $sheet->setCellValue('A'.$i, $dl->getNumero());
  1492.                 $sheet->setCellValue('B'.$i, $dl->getInstallateur()->getSociete());
  1493.                 $sheet->setCellValue('C'.$i, $dl->getDealoblige()->getOblige()->getSociete());
  1494.                 $sheet->setCellValue('D'.$i,  $dl->getDatefin());
  1495.                 $sheet->setCellValue('E'.$i, $dl->getStatus());
  1496.                 $i=$i+1;
  1497.             }
  1498.         }
  1500.        
  1501.         // Créer un objet Writer pour enregistrer le fichier
  1502.         $writer = new Xlsx($spreadsheet);
  1504.         // Enregistrer le fichier à un emplacement
  1505.         $now = new DateTime();
  1507.                 $date = $now->format('d-m-Y H-i-s');
  1508.         $nomexecel = "deal-".$this->getUser()->getEquipe()->getPrenom()."-".$date;
  1509.         $cheminFichier =$this->getParameter('installateur_directory') . "/export/export".$nomexecel.".xlsx";
  1510.         $writer->save($cheminFichier);
  1512.         // Renvoyer la réponse avec le fichier Excel en pièce jointe
  1513.         return $this->file($cheminFichier);
  1515.     }
  1517.     /**
  1518.      * @Route("/commentaireedite/{id}", methods={"POST"})
  1519.      */
  1520.     public function commentaireedite(Request $request,CommentaireDealRepository $commentaireDealRepository,CommentaireDeal $commentaireDeal ): JsonResponse
  1521.     { 
  1522.         
  1523.         
  1524.   
  1525.         if ($request->getMethod() == "POST") {
  1526.             
  1527.             // $file=$request->files->get('validedocument');
  1528.             $commentaire = $request->request->get('commentaire');
  1529.        
  1530.             
  1531.              if ($commentaire) {
  1532.             
  1533.                     $commentaireDeal->setCommentaire($commentaire);
  1534.                     $commentaireDeal->setDate(new DateTime());
  1535.                     $commentaireDealRepository->add($commentaireDeal, true);
  1538.                         
  1539.                         
  1540.                     
  1541.                    
  1543.                     return $this->json(['success' => true, 'message' => 'commentaire ajouter ']);
  1544.              }
  1545.         }
  1547.         return $this->json(['success' => false, 'error' => 'Erreur ']);
  1548.     }
  1550. }