src/Controller/FactureAafController.php line 126

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\FactureAaf;
  6. use App\Entity\Installateur;
  7. use App\Entity\Docfacture;
  8. use App\Form\FactureAafType;
  9. use App\Repository\FactureAafRepository;
  10. use App\Repository\DocfactureRepository;
  11. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  12. use Symfony\Component\HttpFoundation\Request;
  13. use Symfony\Component\HttpFoundation\Response;
  14. use Symfony\Component\Routing\Annotation\Route;
  15. use App\Service\FileUploader;
  16. use Symfony\Component\HttpFoundation\Session\SessionInterface;
  17. use Symfony\Component\String\Slugger\SluggerInterface;
  18. use Symfony\Component\HttpFoundation\File\UploadedFile;
  19. use Datetime;
  20. use Doctrine\Common\Collections\Collection;
  21. use Symfony\Component\HttpFoundation\JsonResponse;
  22. use App\Repository\NotificationsRepository;
  23. use App\Repository\InstallateurRepository;
  24. use App\Repository\EquipeRepository;
  25. use Symfony\Component\Process\Process;
  26. use Symfony\Component\Filesystem\Filesystem;
  27. use Symfony\Component\Finder\Finder;
  28. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  29. use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
  30. use PhpOffice\PhpSpreadsheet\Style\Fill;
  32.  /**
  33.  * @Route("/facture")
  34.  */
  35. class FactureAafController extends AbstractController
  36. {
  37.     
  38.     /**
  39.      * @Route("/", name="app_facture_aaf_index", methods={"GET", "POST"})
  40.      */
  41.     public function index(FactureAafRepository $factureAafRepository): Response
  42.     {
  43.         if ($this->isGranted('ROLE_INSTALLATEUR')){
  44.             $factureAaf=[];
  45.             foreach ($factureAafRepository->findAll() as $key => $aaf) {
  46.                 foreach ($aaf->getDossier() as $key => $doss) {
  47.                    if ($doss->getDeal()->getInstallateur()->getId() == $this->getUser()->getInstallateur()->getId() ) {
  48.                     $factureAaf[]=$aaf;
  49.                    }
  50.                 }
  51.                 
  52.             }
  53.         }else{
  54.             $factureAaf= $factureAafRepository->findAll();
  55.         }
  56.         
  57.         $tab=[];
  58.         $factureAafs=[];
  60.         // id,type as owner,client as name ,date,file ,batiment
  61.         foreach ($factureAaf as  $value) {
  62.             $j = 0;
  63.             $dossi = "";
  64.             if ($value->getNumero() != null) {
  65.                 $tab['id']=$value->getId();
  66.                  //$tab['id_dossier']=$value->getDossier()->getId();
  67.                 $tab['name']=$value->getNumero();
  68.                  $tab['owner']=$value->getDepotaaf();
  69.                 
  70.                 $tab['count']=count($value->getDossier());
  71.                 foreach ($value->getDossier() as $key => $doss) {
  72.                     
  73.                     if ($j==0) {
  74.                         $dossi= $doss->getDeal()->getDealoblige()->getNom();
  75.                         
  76.                        
  77.                         $j=$j+1;
  78.                     }
  79.                    
  80.                 }
  81.                 $tab['industry_type']=$dossi;
  82.                 $factureAafs[]=$tab;
  83.             }
  84.            
  86.         }
  87.        //dd($factureAafs);
  89.         $clientjson = json_encode($factureAafs);
  91.         // var_dump(json_encode($clientjson ));
  92.         file_put_contents('assets/json/factureaaf-list.json', $clientjson);
  94.         return $this->render('facture_aaf/index.html.twig', [
  95.             'facture_aafs' => $factureAafRepository->findAll(),
  96.         ]);
  97.     }
  99.     
  100.     /**
  101.      * @Route("/new", name="app_facture_aaf_new", methods={"GET", "POST"})
  102.      */
  103.     public function new(Request $request, EntityManagerInterface $entityManager): Response
  104.     {
  105.         $factureAaf = new FactureAaf();
  106.         $form = $this->createForm(FactureAafType::class, $factureAaf);
  107.         $form->handleRequest($request);
  109.         if ($form->isSubmitted() && $form->isValid()) {
  110.             $entityManager->persist($factureAaf);
  111.             $entityManager->flush();
  113.             return $this->redirectToRoute('app_facture_aaf_index', [], Response::HTTP_SEE_OTHER);
  114.         }
  116.         return $this->renderForm('facture_aaf/new.html.twig', [
  117.             'facture_aaf' => $factureAaf,
  118.             'form' => $form,
  119.         ]);
  120.     }
  122.    
  123.     /**
  124.      * @Route("/{id}", name="app_facture_aaf_show", methods={"GET"})
  125.      */
  126.     public function show(FactureAaf $factureAaf): Response
  127.     {
  128.         // $factureAaf= $factureAafRepository->findAll();
  129.         if ($this->isGranted('ROLE_INSTALLATEUR')){
  130.             $parameters = ['facture' => $factureAaf->getNumero()];
  131.             return $this->redirectToRoute('app_facture_aaf_installateur_show',  ['id' => $this->getUser()->getInstallateur()->getId()]+$parameters, Response::HTTP_SEE_OTHER);
  132.         }
  133.         $tab=[];
  134.         $factureAafs=[];
  135.         $cumacTotal=0;
  136.         $installateur=[];
  137.         $instid=[];
  138.         $oblige ="";
  139.         foreach ($factureAaf->getDossier() as  $value) {
  140.             
  141.             if ($value->getNumero() != null) {
  142.                 $tab['id']=$value->getDeal()->getInstallateur()->getId();
  143.                 $tab['id_dossier']=$value->getId();
  144.                 $tab['owner']=$value->getNumero();
  145.                 $tab['name']=$value->getDeal()->getInstallateur()->getSociete();
  146.                 if (!in_array($value->getDeal()->getInstallateur()->getId(), $instid)) {
  147.                     $installateur[]=$value->getDeal()->getInstallateur();
  148.                     $instid[]=$value->getDeal()->getInstallateur()->getId();
  149.                 }
  150.                
  151.                 $tab['industry_type']=$value->getCumac();
  152.                 $tab['location']=$factureAaf->getNumero();
  153.                 $factureAafs[]=$tab;
  154.                 $cumacTotal =$cumacTotal+$value->getCumac();
  155.                 $oblige = $value->getDeal()->getDealoblige()->getNom();
  156.             }
  157.            
  159.         }
  160.        //dd($installateur);
  162.         $clientjson = json_encode($factureAafs);
  164.         // var_dump(json_encode($clientjson ));
  165.         file_put_contents('assets/json/showaaf-list.json', $clientjson);
  166.         return $this->render('facture_aaf/show.html.twig', [
  167.             'facture_aaf' => $factureAaf,
  168.             'TotalCumac' => $cumacTotal,
  169.             'installateur' => $installateur,
  170.             'oblige' =>$oblige
  171.         ]);
  172.     }
  174.      /**
  175.      * @Route("/installateur/{id}", name="app_facture_aaf_installateur_show", methods={"GET"})
  176.      */
  177.     public function showinst(Request $request,Installateur $installateur,FactureAafRepository $factureAafRepository,DocfactureRepository $docfactureRepository): Response
  178.     {
  179.         // $factureAaf= $factureAafRepository->findAll();
  180.         $form = $request->request; 
  181.         
  182.         $factureAaf = $factureAafRepository->findOneBy(["numero" => $request->get("facture")]);
  183.         
  184.         $tab=[];
  185.         $factureAafs=[];
  186.         $cumacTotal=0;
  187.        
  188.         $oblige ="";
  189.         $taux =0;
  190.         $docfacture=[];
  191.         foreach ($factureAaf->getDossier() as  $value) {
  192.             
  193.             if ($value->getNumero() != null) {
  194.                 if ($value->getDeal()->getInstallateur()->getId() == $installateur->getId()) {
  195.                   
  196.                     $factureAafs[]=$value;
  197.                     $cumacTotal =$cumacTotal+$value->getCumac();
  198.                     $oblige = $value->getDeal()->getDealoblige()->getNom();
  199.                     $taux  =$value->getDeal()->getTaux();
  200.                 }
  201.               
  202.             }
  203.            
  205.         }
  206.         foreach ($factureAaf->getDocfactures() as $key => $doc) {
  207.             if ($doc->getInstallateur()->getId() == $installateur->getId()) {
  208.                 $docfacture= $doc;
  209.             }
  210.         }
  211.         
  212.        // dd($factureAafs);
  214.         // $clientjson = json_encode($factureAafs);
  216.         // var_dump(json_encode($clientjson ));
  217.         // file_put_contents('assets/json/showaaf-list.json', $clientjson);
  218.         return $this->render('facture_aaf/showinst.html.twig', [
  219.             'installateur_aaf' => $installateur,
  220.             'TotalCumac' => $cumacTotal,
  221.             'oblige' =>$oblige,
  222.             'facture_aafs' => $factureAafs,
  223.             'factureAaf' => $factureAaf,
  224.             'taux' =>$taux,
  225.             'docfacture' => $docfacture
  226.         ]);
  227.     }
  230.       /**
  231.      * @Route("/installateur/exportedepot/{id}", name="app_facture_aaf_installateur_exporte",  methods={"GET"})
  232.      */
  233.     public function exporte(Request $request,Installateur $installateur,FactureAafRepository $factureAafRepository,DocfactureRepository $docfactureRepository): Response
  234.     {
  235.         
  236.         
  237.       //  $jsonFilePath = 'assets/json/dossier-list.json';
  239.         // Étape 1 : Récupérer le contenu JSON depuis le fichier
  240.        // $jsonContent = file_get_contents($jsonFilePath);
  242.         // Étape 2 : Décoder le contenu JSON en tableau PHP
  243.         $factureAaf = $factureAafRepository->findOneBy(["numero" => $request->get("facture")]);
  244.         $numeroaaf=$factureAaf->getNumero();
  245.         $tab=[];
  246.         $factureAafs=[];
  247.         $cumacTotal=0;
  248.        
  249.         $oblige ="";
  250.         $taux =0;
  251.         $docfacture=[];
  252.         foreach ($factureAaf->getDossier() as  $value) {
  253.             
  254.             if ($value->getNumero() != null) {
  255.                 if ($value->getDeal()->getInstallateur()->getId() == $installateur->getId()) {
  256.                   
  257.                     $factureAafs[]=$value;
  258.                     $cumacTotal =$cumacTotal+$value->getCumac();
  259.                     $oblige = $value->getDeal()->getDealoblige()->getNom();
  260.                     $taux  =$value->getDeal()->getTaux();
  261.                 }
  262.               
  263.             }
  264.            
  266.         }
  267.         foreach ($factureAaf->getDocfactures() as $key => $doc) {
  268.             if ($doc->getInstallateur()->getId() == $installateur->getId()) {
  269.                 $docfacture= $doc;
  270.             }
  271.         }
  273.         $phpArray = $factureAafs;
  275.       
  276.         // Créer un nouveau classeur Excel
  277.         $spreadsheet = new Spreadsheet();
  278.                 
  279.         // Obtenir la feuille active
  280.         $sheet = $spreadsheet->getActiveSheet();
  282.         // Écrire des données dans la feuille
  283.        
  284.        $totalcumac = 0;
  285.         $taux = 0;
  286.         $sheet->setCellValue('A1', 'Numéro dossier');
  287.         $sheet->getStyle('A1')->getFill()->setFillType(Fill::FILL_SOLID)->getStartColor()->setRGB('BAE1FF'); 
  288.         $sheet->getStyle('A1')->getFont()->setBold(true);
  289.         $sheet->setCellValue('B1', 'Nom du Beneficiaire');
  290.         $sheet->getStyle('B1')->getFill()->setFillType(Fill::FILL_SOLID)->getStartColor()->setRGB('BAE1FF'); 
  291.         $sheet->getStyle('B1')->getFont()->setBold(true);
  292.         $sheet->setCellValue('C1', 'Deal associé');
  293.         $sheet->getStyle('C1')->getFill()->setFillType(Fill::FILL_SOLID)->getStartColor()->setRGB('BAE1FF'); 
  294.         $sheet->getStyle('C1')->getFont()->setBold(true);
  295.         $sheet->setCellValue('D1', 'KWh Cumac');
  296.         $sheet->getStyle('D1')->getFill()->setFillType(Fill::FILL_SOLID)->getStartColor()->setRGB('BAE1FF'); 
  297.         $sheet->getStyle('D1')->getFont()->setBold(true);
  298.         $sheet->setCellValue('E1', 'Taux');
  299.         $sheet->getStyle('E1')->getFill()->setFillType(Fill::FILL_SOLID)->getStartColor()->setRGB('BAE1FF'); 
  300.         $sheet->getStyle('E1')->getFont()->setBold(true);
  301.         $sheet->setCellValue('F1', 'Prime');
  302.         $sheet->getStyle('F1')->getFill()->setFillType(Fill::FILL_SOLID)->getStartColor()->setRGB('BAE1FF'); 
  303.         $sheet->getStyle('F1')->getFont()->setBold(true);
  305.         $sheet->getColumnDimension('A')->setWidth(15);
  306.         $sheet->getColumnDimension('B')->setWidth(18);
  307.         $sheet->getColumnDimension('C')->setWidth(15);
  308.         $sheet->getColumnDimension('D')->setWidth(15);
  309.         $sheet->getColumnDimension('E')->setWidth(15);
  310.         $sheet->getColumnDimension('F')->setWidth(15);
  311.         
  312.     
  313.     
  314.         $i=2;
  315.         
  316.         if ($phpArray === null) {
  317.             echo "Erreur Tableau vide: ";
  318.         } else {
  319.             // Utilisez le tableau PHP $phpArray comme bon vous semble
  320.             
  321.             foreach ($phpArray as $dl) {
  322.                 // $dl=$depotDossierRepository->findOneBy(["id"=>intval($value["id"])]);
  323.                 $sheet->setCellValue('A'.$i, $dl->getNumero());
  324.               
  325.                 $sheet->setCellValue('B'.$i, $dl->getPrenomclient().' '.$dl->getNomclient() );
  326.                 $sheet->setCellValue('C'.$i, $dl->getDeal()->getDealoblige()->getNom());
  327.                 $sheet->setCellValue('D'.$i,  $dl->getCumac());
  328.                 $sheet->setCellValue('E'.$i, $dl->getDeal()->getTaux());
  329.                 $sheet->setCellValue('F'.$i, $dl->getCumac() * ($dl->getDeal()->getTaux() / 1000));
  330.                 $totalcumac = $totalcumac + $dl->getCumac();
  331.                 $taux = $dl->getDeal()->getTaux() / 1000;
  332.                
  333.                 $i=$i+1;
  334.             }
  335.         }
  336.         $sheet->setCellValue('A'.$i+2, 'Total Cumac');
  337.         $sheet->getStyle('A'.$i+2)->getFill()->setFillType(Fill::FILL_SOLID)->getStartColor()->setRGB('96CEB4'); 
  338.         $sheet->getStyle('A'.$i+2)->getFont()->setBold(true);
  339.         $sheet->setCellValue('B'.$i+2, $totalcumac);
  340.         $sheet->getStyle('B'.$i+2)->getFill()->setFillType(Fill::FILL_SOLID)->getStartColor()->setRGB('96CEB4'); 
  341.         $sheet->getStyle('B'.$i+2)->getFont()->setBold(true);
  342.         $sheet->setCellValue('A'.$i+3, 'Total Prime');
  343.         $sheet->getStyle('A'.$i+3)->getFill()->setFillType(Fill::FILL_SOLID)->getStartColor()->setRGB('96CEB4'); 
  344.         $sheet->getStyle('A'.$i+3)->getFont()->setBold(true);
  345.         $sheet->setCellValue('B'.$i+3, $totalcumac * $taux);
  346.         $sheet->getStyle('B'.$i+3)->getFill()->setFillType(Fill::FILL_SOLID)->getStartColor()->setRGB('96CEB4'); 
  347.         $sheet->getStyle('B'.$i+3)->getFont()->setBold(true);
  348.         
  349.        
  350.         // Créer un objet Writer pour enregistrer le fichier
  351.         $writer = new Xlsx($spreadsheet);
  353.         // Enregistrer le fichier à un emplacement
  354.         $now = new DateTime();
  356.                 $date = $now->format('d-m-Y H-i-s');
  357.         $nomexecel = "factureAAf-".$numeroaaf."-".$installateur->getSociete()."-".$date;
  358.         $cheminFichier =$this->getParameter('installateur_directory') . "/export/export".$nomexecel.".xlsx";
  359.         $writer->save($cheminFichier);
  360.         // $filtre->setExporte("export".$nomexecel.".xlsx");
  361.         // $filtreRepository->add($filtre, true);
  362.         // Renvoyer la réponse avec le fichier Excel en pièce jointe
  363.         return $this->file($cheminFichier);
  365.     }
  367.     
  369.     /**
  370.      * @Route("/{id}/edit", name="app_facture_aaf_edit", methods={"GET", "POST"})
  371.      */
  372.     public function edit(Request $request, FactureAaf $factureAaf, EntityManagerInterface $entityManager): Response
  373.     {
  374.         $form = $this->createForm(FactureAafType::class, $factureAaf);
  375.         $form->handleRequest($request);
  377.         if ($form->isSubmitted() && $form->isValid()) {
  378.             $entityManager->flush();
  380.             return $this->redirectToRoute('app_facture_aaf_index', [], Response::HTTP_SEE_OTHER);
  381.         }
  383.         return $this->renderForm('facture_aaf/edit.html.twig', [
  384.             'facture_aaf' => $factureAaf,
  385.             'form' => $form,
  386.         ]);
  387.     }
  389.    
  390.     /**
  391.      * @Route("/{id}", name="app_facture_aaf_delete", methods={"POST"})
  392.      */
  393.     public function delete(Request $request, FactureAaf $factureAaf, EntityManagerInterface $entityManager): Response
  394.     {
  395.         if ($this->isCsrfTokenValid('delete'.$factureAaf->getId(), $request->request->get('_token'))) {
  396.             $entityManager->remove($factureAaf);
  397.             $entityManager->flush();
  398.         }
  400.         return $this->redirectToRoute('app_facture_aaf_index', [], Response::HTTP_SEE_OTHER);
  401.     }
  402.        /**
  403.      * @Route("/upload/{id}", methods={"POST"})
  404.      */
  405.     public function upload(Request $request ,FactureAaf $factureAaf,InstallateurRepository $installateurRepository,
  406.     FileUploader $uploader,EquipeRepository $equipeRepository,NotificationsRepository $notificationsRepository,DocfactureRepository $docfactureRepository): JsonResponse
  407.     { 
  408.         
  409.        
  410.         if ($request->getMethod() == "POST") {
  411.             
  412.             $file=$request->files->get('file');
  413.              if ($file) {
  414.                 $installateur = $installateurRepository->findOneBy(["id" => $request->get("idinstallateur")]);
  415.                 if ($request->get("iddocfacture")) {
  416.                     $docfacture = $docfactureRepository->findOneBy(["id" => $request->get("iddocfacture")]);
  417.                 }else{
  418.                     $docfacture = new Docfacture();
  419.                     $docfacture->setAaf($factureAaf);
  420.                     $docfacture->setInstallateur($installateur);
  421.                 }
  422.                 $now = new DateTime();
  423.                 $date = $now->format('d-m-Y');
  424.                    
  425.                     $destination = $this->getParameter('installateur_directory');
  426.                     $fileName = explode('.',$file->getClientOriginalName())[0].'.'.$file->getClientOriginalExtension();
  427.                     $fileName = $request->get("donne")."-".$factureAaf->getNumero()."-".$installateur->getSociete().'-'.$date.'.'.$file->getClientOriginalExtension();
  428.                    
  429.                     $file->move($destination, $fileName);
  430.                     if ($request->get("donne")=='model') {
  431.                         $docfacture->setModel($fileName);
  432.                     }
  433.                     if ($request->get("donne")=='facture') {
  434.                         $docfacture->setFacture($fileName);
  435.                     }
  436.                     $docfactureRepository->add($docfacture, true);
  437.                   
  438.                     // $activiteDeal = new ActiviteDeal();
  439.                     if ($this->isGranted('ROLE_INSTALLATEUR')) {
  440.                        
  441.                         $admins = $equipeRepository->findAll();
  442.                                 
  443.                                 foreach ($admins as $key => $value) {
  445.                                     $listrole = $value->getRole();
  446.                                   
  447.                                        
  448.                                         if($listrole == "ROLE_MANAGER" || $listrole == "ROLE_ADMIN" ){
  449.                                             $notifications = new Notifications();
  450.                                             $notifications->setUserId($value->getUser());
  451.                                             $notifications->setAction("app_facture_aaf_show");
  452.                                             $notifications->setMessage($installateur->getSociete()."à ajoutés sa facture AAf : ".$factureAaf->getNumero());
  453.                                             $notifications->setActionId($factureAaf->getId());
  454.                                             $notifications->setSender($this->getUser());
  455.                                             $notifications->setStatuts("non lu");
  456.                                             $notifications->setDate(new DateTime());
  457.         
  458.                                             $notificationsRepository->add($notifications, true);
  459.                                         }
  460.                                     
  461.                                     
  462.                                     
  463.                                 }
  464.                         // $admins = $equipeRepository->findAll();
  466.                         // foreach ($admins as $key => $value) {
  468.                         //     $listPermissions = $value->getPermissions();
  470.                         //     foreach ($listPermissions as $v) {
  471.                         //         if($v == "NOTIFICATION" ){
  472.                         //             $notifications = new Notifications();
  473.                         //             $notifications->setUserId($value->getUser());
  474.                         //             $notifications->setAction("app_deal_edit");
  475.                         //             $notifications->setMessage("Des documents ont été ajoutés pour le deal ".$champsDeal->getNumero());
  476.                         //             $notifications->setActionId($champsDeal->getId());
  477.                         //             $notifications->setSender($this->getUser());
  478.                         //             $notifications->setStatuts("non lu");
  479.                         //             $notifications->setDate(new DateTime());
  481.                         //             $notificationsRepository->add($notifications, true);
  482.                         //         }
  483.                         //     }
  484.                         // }
  486.                         // $activiteDeal->setFonction('installateur');
  487.                         // $activiteDeal->setInstallateur($this->getUser()->getInstallateur());
  488.                     }else{
  489.                        
  490.                         // $activiteDeal->setFonction('equipe');
  491.                         // $activiteDeal->setEquipe($this->getUser()->getEquipe());
  492.                     }
  493.                    
  494.                     // $activiteDeal->setCommentaire("À déposé le document ".$champsDeal->getNom());
  495.                     // $activiteDeal->setDate(new Datetime());
  496.                     // $activiteDeal->setDeal($champsDeal->getDeal());
  497.                     // $activiteDealRepository->add($activiteDeal, true);
  499.                     // Historique
  500.                     // $historiqueDeal = new HistoriqueDeal();
  501.                     // $historiqueDeal->setUser($this->getUser());
  502.                     // $historiqueDeal->setDeal($champsDeal->getDeal());
  503.                     // $historiqueDeal->setDate(new DateTime());
  504.                     // $historiqueDeal->setAction("Importation du document ".$champsDeal->getNom()." dans le Deal ".$champsDeal->getDeal()->getNumero());
  505.                     // $historiqueDealRepository->add($historiqueDeal, true);
  508.                     return $this->json(['success' => true, 'message' => 'Fichier téléchargé et ajouté en base de données avec succès']);
  509.              }
  510.         }
  512.         return $this->json(['success' => false, 'error' => 'Erreur lors du téléchargement du fichier']);
  513.     }
  514. }