src/Controller/HomeController.php line 34

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  4. use PDO;
  5. use App\Entity\PArticles;
  6. use App\Entity\PFactures;
  7. use App\Entity\PReglements;
  8. use App\Entity\PNatureBenef;
  9. use App\Entity\PEtablissment;
  10. use App\Entity\PNatureCharge;
  11. use App\Entity\PBeneficiaires;
  12. use App\Entity\PChargeSociale;
  13. use App\Entity\PChargeSocialeLg;
  14. use App\Entity\Motivation;
  15. use App\Entity\POrganisme;
  17. use App\Entity\PChargeSocialeBenef;
  18. use Symfony\Component\HttpFoundation\Request;
  19. use Symfony\Component\HttpFoundation\Response;
  20. use Symfony\Component\Routing\Annotation\Route;
  21. use Symfony\Component\HttpFoundation\JsonResponse;
  22. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  24. use Symfony\Component\HttpFoundation\ResponseHeaderBag;
  25. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  26. use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
  27. use \ZipArchive;
  29. class HomeController extends AbstractController
  30. {
  31.     /**
  32.      * @Route("/", name="dossier")
  33.      */
  34.     public function dossier(): Response
  35.     {
  36.         $etablissment = $this->getDoctrine() ->getRepository(PEtablissment::class)->findBy(array('pec'=>'1'));
  37.         return $this->render('home/dossier.html.twig', 
  38.         [ 'etablissment'=>$etablissment  ]);
  39.     }
  41.     /**
  42.      * @Route("/list/{etablissment}/{statut}", name="list_pec_charge")
  43.      */
  44.     function list(PEtablissment $etablissment, $statut, Request $request): Response 
  45.     { 
  46.         $em = $this->getDoctrine()->getManager();
  47.         $data= [];
  48.         $idbenefeciaire  = "";
  49.         if(isset($_GET['idbenef'])){
  50.             $idbenefeciaire  = $_GET['idbenef'];
  51.         }
  52.         
  53.         // $id_benefeciaire = $request->query;
  54.         if ( $idbenefeciaire) {
  55.            
  56.             $pecSociales= $this->getDoctrine() ->getRepository(PChargeSociale::class)->findPecByBenef($idbenefeciaire,$etablissment->getId() );
  58.             foreach ($pecSociales as $pecSociale) {
  59.                 
  60.                 
  61.                 $nestedData = array();
  62.                 $MontantCharge = $this->getDoctrine()->getRepository(PChargeSocialeLg::class)->getTotalSocialC($pecSociale['id']);
  63.                 $MontantFact = $this->getDoctrine()->getRepository(PFactures::class)->getTotalFacture($pecSociale['id']);
  64.                 $MontantRegl = $this->getDoctrine()->getRepository(PReglements::class)->getTotalReglement($pecSociale['id']);
  66.                 $nestedData[] = "<a class='show-Pec' href='/show/Pec/".$etablissment->getId()."/".$pecSociale['id']."'>".$pecSociale['idChargeS']."</a>";
  67.                 $nestedData[] = date_format($pecSociale['dateCharge'], "d/m/Y");
  68.                 $nestedData[] = $pecSociale['etablissmentDemandeur'];
  69.                 $nestedData[] = $pecSociale['natureCharge'];
  70.                 $nestedData[] = $pecSociale['objet'];
  71.                 $nestedData[] = number_format($MontantCharge, 2, ',', '') ;
  72.                 $nestedData[] = number_format($MontantFact, 2, ',', '')  ;
  73.                 $nestedData[] = number_format($MontantRegl, 2, ',', '')  ;
  74.                 $buttons = "";
  75.                 
  76.                 if($MontantCharge > $MontantFact && $MontantFact>0) {
  77.                     $buttons = '<button type="button " class="dropdown-item btn-facture" name="'.$MontantCharge.'" id="'.$pecSociale['id'].'" data-toggle="modal" data-target="#ajouterModalFacture">FACTURER</button><button type="button " class="dropdown-item btn-reglement" id=""  name="'.$MontantFact.'" data-toggle="modal" data-target="#ajouterModalReglement">
  78.                     <input type="number" hidden class="MontantRegl" value="'.$MontantRegl.'">
  79.                     <input type="number" hidden class="IdCharge" value="'.$pecSociale['id'].'">
  80.                     AJOUTER REGLEMENT 
  81.                 </button>';
  82.                 
  83.                 }elseif($MontantCharge > $MontantFact) {
  84.                     $buttons = '<button type="button " class="dropdown-item btn-facture" name="'.$MontantCharge.'" id="'.$pecSociale['id'].'" data-toggle="modal" data-target="#ajouterModalFacture">FACTURER</button>';
  85.                 
  86.                 }elseif ($MontantFact>0 && $MontantRegl < $MontantFact){
  87.                     $buttons = '<button type="button " class="dropdown-item btn-reglement" id="" name="'.$MontantFact.'" data-toggle="modal" data-target="#ajouterModalReglement">
  88.                     <input type="number" hidden class="MontantRegl" value="'.$MontantRegl.'">
  89.                     <input type="number" hidden class="IdCharge" value="'.$pecSociale['id'].'">
  90.                     AJOUTER REGLEMENT 
  91.                 </button>';
  92.                 }
  94.                 $path = $this->generateUrl("pdf", ['etablissment' => $etablissment->getId(), 'id' => $pecSociale['id']]);
  95.                 
  96.                 if($pecSociale["statutPec"]=="annuler"){
  97.                     $nestedData[] = '<a class="a-href" href="'.$path.'" target="_blank" ><div class="cancel-symbol"></div></a>';
  98.                 }
  99.                 else{
  100.                     $nestedData[] = '<div class="btn-group dropdown-btn-action ">
  101.                                     <button type="button" class="btn btn-outline-info  btn-sm  dropdown-toggle btn-dropdown" id="dropdown_table" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
  102.                                     <i class="fa fa-ellipsis-h"></i>
  103.                                     </button>
  104.                                     <div class="dropdown-menu dropdown-menu-right">
  105.                                         '.$buttons.'
  106.                                         <button type="button" class="dropdown-item" id="annuler-pec" name="'.$pecSociale['id'].'">
  107.                                             ANNULER
  108.                                         </button> 
  109.                                         <button type="button" class="dropdown-item ">
  110.                                             <a class="a-href" href="'.$path.'" target="_blank" > PDF </a>
  111.                                         </button>  
  112.                                     </div>
  113.                                 </div>';
  114.                 }
  115.                 // $nestedData[]=$pecSociale["statutPec"];
  118.                 // $nestedData["DT_RowId"] = $pChargeSociale->getId();
  119.                 // $nestedData["DT_RowClass"] = $pChargeSociale->getId();
  120.                 
  121.                 $data[] = $nestedData;
  122.                 // break ;
  123.             }
  124.             $json_data = array(
  125.                 "data" => $data,
  126.             );
  128.             return new Response(json_encode($json_data));
  129.             
  130.         }
  131.         else{
  132.             $condition=array( 'supprime'=>'0', 'idTier' => $etablissment->getId(),'statut'=>$statut );
  133.             if($statut =='toute'){
  134.                 $condition= array( 'supprime'=>'0', 'idTier' => $etablissment->getId() );
  135.             }
  136.             
  137.             
  138.             $pChargeSociales   = $em->getRepository(PChargeSociale::class)->findBy($condition);
  139.             
  140.             
  141.             $data = array();
  142.             foreach ($pChargeSociales as $pChargeSociale) {
  143.                 $nestedData = array();
  144.                 $MontantCharge = $this->getDoctrine()->getRepository(PChargeSocialeLg::class)->getTotalSocialC($pChargeSociale);
  145.                 $MontantFact = $this->getDoctrine()->getRepository(PFactures::class)->getTotalFacture($pChargeSociale);
  146.                 $MontantRegl = $this->getDoctrine()->getRepository(PReglements::class)->getTotalReglement($pChargeSociale);
  148.                 $nestedData[] = "<a class='show-Pec' href='/show/Pec/".$etablissment->getId()."/".$pChargeSociale->getId()."'>".$pChargeSociale->getIdChargeS()."</a>";
  149.                 $nestedData[] = date_format($pChargeSociale->getDateCharge(), "d/m/Y");
  150.                 $nestedData[] = $pChargeSociale->getSite()->getEtablissment();
  151.                 $nestedData[] = $pChargeSociale->getNatureCharge()->getNatureCharge();
  152.                 $nestedData[] = $pChargeSociale->getObjet();
  153.                 $nestedData[] = "<span class='montant-td'>".number_format($MontantCharge, 2, ',', '') ."</span>";
  154.                 $nestedData[] = "<span class='montant-td'>".number_format($MontantFact, 2, ',', '')  ."</span>";
  155.                 $nestedData[] = "<span class='montant-td'>".number_format($MontantRegl, 2, ',', '')  ."</span>";
  156.                 $buttons = "";
  157.                 
  158.                 if($MontantCharge > $MontantFact && $MontantFact>0) {
  159.                     $buttons = '<button type="button " class="dropdown-item btn-facture" name="'.$MontantCharge.'" id="'.$pChargeSociale->getId().'" data-toggle="modal" data-target="#ajouterModalFacture">FACTURER</button><button type="button " class="dropdown-item btn-reglement" id="'.$pChargeSociale->getPFactures()[0]->getId().'" name="'.$MontantFact.'" data-toggle="modal" data-target="#ajouterModalReglement">
  160.                     <input type="number" hidden class="MontantRegl" value="'.$MontantRegl.'">
  161.                     <input type="number" hidden class="IdCharge" value="'.$pChargeSociale->getId().'">
  162.                     AJOUTER REGLEMENT 
  163.                 </button>';
  164.                 
  165.                 }elseif($MontantCharge > $MontantFact) {
  166.                     $buttons = '<button type="button " class="dropdown-item btn-facture" name="'.$MontantCharge.'" id="'.$pChargeSociale->getId().'" data-toggle="modal" data-target="#ajouterModalFacture">FACTURER</button>';
  167.                 
  168.                 }elseif ($MontantFact>0 && $MontantRegl < $MontantFact){
  169.                     $buttons = '<button type="button " class="dropdown-item btn-reglement" id="'.$pChargeSociale->getPFactures()[0]->getId().'" name="'.$MontantFact.'" data-toggle="modal" data-target="#ajouterModalReglement">
  170.                     <input type="number" hidden class="MontantRegl" value="'.$MontantRegl.'">
  171.                     <input type="number" hidden class="IdCharge" value="'.$pChargeSociale->getId().'">
  172.                     AJOUTER REGLEMENT 
  173.                 </button>';
  174.                 }
  176.                 $path = $this->generateUrl("pdf", ['etablissment' => $etablissment->getId(), 'id' => $pChargeSociale->getId()]);
  177.                 if($pChargeSociale->getStatut()=="annuler"){
  178.                     $nestedData[] = '<a class="a-href" href="'.$path.'" target="_blank" ><div class="cancel-symbol"></div></a>';
  179.                 }
  180.                 else{
  181.                     $nestedData[] = '<div class="btn-group dropdown-btn-action ">
  182.                     <button type="button" class="btn btn-outline-info  btn-sm  dropdown-toggle btn-dropdown" id="dropdown_table" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
  183.                     <i class="fa fa-ellipsis-h"></i>
  184.                     </button>
  185.                     <div class="dropdown-menu dropdown-menu-right">
  186.                         '.$buttons.'
  187.                         <button type="button" class="dropdown-item" id="annuler-pec" name="'.$pChargeSociale->getId().'">
  188.                         ANNULER
  189.                         </button> 
  190.                         <button type="button" class="dropdown-item ">
  191.                             <a class="a-href" href="'.$path.'" target="_blank" > PDF </a>
  192.                         </button>                                                                            
  193.                     </div>
  194.                 </div>';
  195.                 }
  196.                 
  197.                 // $nestedData[]=$pChargeSociale->getStatut();
  198.                 // $nestedData["DT_RowId"] = $pChargeSociale->getId();
  199.                 // $nestedData["DT_RowClass"] = $pChargeSociale->getId();
  200.                 
  201.                 $data[] = $nestedData;
  202.                 // break ;
  203.             }
  204.             // dd($data);
  205.             $json_data = array(
  206.                 "data" => $data,
  207.             );
  209.             return new Response(json_encode($json_data));
  210.         }
  211.     }
  213.     /**
  214.      * @Route("home/{etablissment}/{statut}", name="home")
  215.      */
  216.     public function index($etablissment, $statut): Response
  217.     {
  218.         
  219.         $etablissmentt = $this->getDoctrine() ->getRepository(PEtablissment::class)->findOneBy(array('id'=>$etablissment));
  220.         
  221.         
  222.         return $this->render('home/index.html.twig', 
  223.         [   
  224.             'statut' => $statut,
  225.             'etablissment'=>$etablissmentt
  226.         ]);
  227.     }
  228.     
  229.     /**
  230.      * @Route("/{action}/Pec/{etablissment}/{id}", name="ShowEdit")
  231.      */
  232.     public function showEdit($action ,$etablissment,$id): Response
  233.     {
  234.         
  235.         $pChargeSocia    = $this->getDoctrine() ->getRepository(PChargeSociale::class)->findOneBy(array('id'=>$id));
  236.         $details        = $this->getDoctrine() ->getRepository(PChargeSocialeLg::class)->findBy(array('chargeS'=>$id, 'supprime'=>0));
  237.  
  238.         $Benefeciaires  = $this->getDoctrine() ->getRepository(PChargeSocialeBenef::class)->findBy(array('chargeS'=>$id, 'supprime'=>0));
  239.         $etabl   = $this->getDoctrine() ->getRepository(PEtablissment::class)->findOneBy(array('id'=>$pChargeSocia->getSite()));
  240.         
  241.         $MontantCharge = $this->getDoctrine()->getRepository(PChargeSocialeLg::class)->getTotalSocialC($pChargeSocia);
  242.         $MontantFact = $this->getDoctrine()->getRepository(PFactures::class)->getTotalFacture($pChargeSocia);
  243.         $MontantRegl = $this->getDoctrine()->getRepository(PReglements::class)->getTotalReglement($pChargeSocia);
  244.         $etablissmentt = $this->getDoctrine() ->getRepository(PEtablissment::class)->findOneBy(array('id'=>$etablissment));
  245.         $organ;
  246.         $montantCharge= $this->getDoctrine()->getRepository(PChargeSocialeLg::class)->getTotalSocialC($pChargeSocia);
  247.         $MontantFact = $this->getDoctrine()->getRepository(PFactures::class)->getTotalFacture($pChargeSocia);
  248.      
  249.        
  250.         // dd($Benefeciaires);
  251.         if ($action=='show' || $pChargeSocia->getStatut()=="annuler"  || $montantCharge==$MontantFact && $montantCharge>0 ) {
  252.             return $this->render('modal/show.html.twig', 
  253.             [   'etablissment'      => $etablissmentt,
  254.                 'pChargeSocia'      => $pChargeSocia,
  255.                 'details'           => $details,
  256.                 'Benefeciaires'     => $Benefeciaires,
  257.                 'etabl'             => $etabl,
  258.                 'MontantCharge'     => $MontantCharge,
  259.                 'MontantFact'       => $MontantFact,
  260.                 'MontantRegl'       => $MontantRegl,
  261.                 'montantCharge'     => $montantCharge,
  262.                 'MontantFact'       => $MontantFact
  263.             ]);
  264.         }
  265.         else{
  266.             $all_etablissment = $this->getDoctrine() ->getRepository(PEtablissment::class)->findAll();
  267.             $all_naturecharge = $this->getDoctrine() ->getRepository(PEtablissment::class)->findOneBy(array('id'=>$etablissment));
  268.             $all_natureBenef = $this->getDoctrine() ->getRepository(PNatureBenef::class)->findAll();
  269.             $all_benefeciaire = $this->getDoctrine() ->getRepository(PBeneficiaires::class)->findAll();
  270.             $all_prestation = $this->getDoctrine() ->getRepository(PNatureCharge::class)->find($pChargeSocia->getNatureCharge()->getId()); 
  271.             $motivations = $this->getDoctrine() ->getRepository(Motivation::class)->findAll();
  272.             $organismes = $this->getDoctrine() ->getRepository(POrganisme::class)->findAll();
  274.             return $this->render('modal/edit.html.twig', 
  275.             [   'etablissment'      => $etablissmentt,
  276.                 'pChargeSocia'       => $pChargeSocia,
  277.                 'details'           => $details,
  278.                 'Benefeciaires'     => $Benefeciaires,
  279.                 'etabl'             => $etabl,
  280.                 'pChargeSocia'      => $pChargeSocia,
  281.                 'all_etablissment'  =>$all_etablissment,
  282.                 'all_naturecharge'  =>$all_naturecharge,
  283.                 'all_natureBenef'   =>$all_natureBenef,
  284.                 'all_benefeciaire'  =>$all_benefeciaire,
  285.                 'all_prestation'    =>$all_prestation,
  286.                 'motivations'       =>$motivations,
  287.                 'organismes'        =>$organismes
  288.             ]);
  289.         }
  291.     }
  292.     
  293.     
  294.     
  295.     /**
  296.      * @Route("{etablissment}/pec/new", name="interfaceNew")
  297.      */
  298.     public function newPec( $etablissment): Response
  299.     {
  300.         // $pChargeSociale   = $this->getDoctrine()->getRepository(PChargeSociale::class)->findOnePec($etablissment);
  301.         $all_etablissment = $this->getDoctrine() ->getRepository(PEtablissment::class)->findAll();
  302.         $etablissmentt = $this->getDoctrine() ->getRepository(PEtablissment::class)->findOneBy(array('id'=>$etablissment));
  303.         $all_natureBenef = $this->getDoctrine() ->getRepository(PNatureBenef::class)->findAll();
  304.         $all_benefeciaire = $this->getDoctrine() ->getRepository(PBeneficiaires::class)->findAll();
  305.         $motivations = $this->getDoctrine() ->getRepository(Motivation::class)->findAll();
  306.         $organismes = $this->getDoctrine() ->getRepository(POrganisme::class)->findAll();
  307.         
  309.         return $this->render('modal/add.html.twig', 
  310.         [   
  311.             // 'pChargeSociale'=>$pChargeSociale,
  312.             // 'etablissment'=>$etablissment,
  313.             'all_etablissment'=>$all_etablissment,
  314.             'etablissment'=>$etablissmentt,
  315.             'all_natureBenef'=>$all_natureBenef,
  316.             'all_benefeciaire'=>$all_benefeciaire,
  317.             'motivations'=>$motivations,
  318.             'organismes'=>$organismes
  319.         ]);
  321.     }
  323.     /**
  324.      * @Route("/delet", name="deletPec")
  325.      */
  326.     public function deletPec(Request $request)
  327.     {
  328.         $idPec= $_GET['id_pec'];
  329.         $etablissment= $_GET['etablissment'];
  331.         $entityManager = $this->getDoctrine()->getManager();
  332.         $pChargeSociale = $this->getDoctrine()->getRepository(PChargeSociale::class)->find(intval($idPec));
  333.         $pCFactures= $this->getDoctrine()->getRepository(PFactures::class)->findBy(array('chargeS'=>$idPec));
  335.         $pChargeSociale -> setSupprime(1)
  336.                         ->setUser($this->getUser()->getUsername())
  337.                         -> setAction("supprimer");
  338.         $entityManager ->persist($pChargeSociale);
  340.         foreach ($pCFactures as $pCFacture) {
  341.             $pCFacture -> setSupprime(1);
  342.             $entityManager ->persist($pCFacture);
  343.         }
  345.                         
  346.         $entityManager->flush(); 
  348.         $this->addFlash('notice','Pris en charge a été supprimé avec succès');
  349.         return  $this->redirectToRoute('home', array('etablissment'=> $etablissment,'statut'=> 'toute'));
  351.     }
  352.     /**
  353.      * @Route("{etablissment}/PecSociale/{action}", name="insertUpdate")
  354.      */
  355.     public function insertUpdate($etablissment,Request $request, $action): Response
  356.     {
  357.         $entityManager = $this->getDoctrine()->getManager();
  358.       
  359.         
  361.         $montant    =$request->request->get('_montant');
  362.         $mtPec  =$request->request->get('_montantPec');
  363.         $TableBenef =json_decode($request->request->get('TableBenef'));
  364.             
  365.             if($action=='new'){
  366.                 // PChargeSociale
  367.                 $pChargeS  = $this->getDoctrine()->getRepository(PChargeSociale::class)->findOneBy([], array('id'=>'DESC'));
  368.                 $numberPec='101001'+$pChargeS->getId();
  369.                 $idChargeS = 'CHR_'.$numberPec;
  370.                 $message ='Pris en charge a été ajouté avec succès';
  371.                 $pChargeSociale = new PChargeSociale();
  372.                 $operation = "ajouter";
  373.             }
  374.             else{
  375.                 $pChargeSociale = $this->getDoctrine()->getRepository(PChargeSociale::class)->find(intval($action));
  376.                 // PChargeSocialeLg
  377.                 $id_sosiale_lg =$request->request->get('_id_sosiale_lg');
  378.                 // PChargeSocialeBenef
  379.                 $id_sosiale_benef    =$request->request->get('_id_sosiale_benef');
  380.                 $message ='Pris en charge a été modifié avec succès';
  381.                 $operation = "modifier";
  382.             }
  384.             // *******************************
  385.             // ------ PChargeSociale --------
  386.             $etabl = $this->getDoctrine() ->getRepository(PEtablissment::class)->findOneBy(array('id'=>$etablissment));
  387.             $nature_charge = $this->getDoctrine()->getRepository(PNatureCharge::class)->find(intval($request->request->get('_nature_charge')));
  388.             $dateCharge = new \DateTime($request->request->get('_date_charge'));
  389.             $reference_doc = $request->request->get('_reference_doc');
  390.             $date_doc = new \DateTime($request->request->get('_date_doc'));
  391.             $object = $request->request->get('_object');
  392.             $detail_motivation = $request->request->get('_detail_motivation');
  393.             $dNow        = new \DateTime(date("Y/m/d"));
  394.             
  395.             $nature_beneficiaire = $this->getDoctrine()->getRepository(PNatureBenef::class)->find(intval($request->request->get('_nature_beneficiaire')));
  396.             $site_tier = $this->getDoctrine()->getRepository(PEtablissment::class)->find(intval($etabl->getId()));
  397.             $motivation = $this->getDoctrine()->getRepository(Motivation::class)->find(intval($request->request->get('_motivation')));
  398.             $site_demandeur = $this->getDoctrine()->getRepository(PEtablissment::class)->find(intval($request->request->get('_site_demandeur')));
  400.             // *******************************
  401.             // ------ PChargeSocialeLg --------
  402.             $prestation =$request->request->get('_prestation');
  403.             $quantite   =$request->request->get('_quantite');
  404.             $base       =$request->request->get('_base');
  405.             $taux       =$request->request->get('_taux');
  406.             
  408.             // *******************************
  409.             // ------ PChargeSocialeBenef --------
  410.             
  411.             // dd($benefeciair);
  412.             $niveau  =$request->request->get('_niveau');
  413.             $annee  =$request->request->get('_annee');
  414.             $cutisation  =$request->request->get('_cutisation');
  415.             $id_dossier       =$request->request->get('_id_dossier');
  416.             $id_inscription   =$request->request->get('_id_inscription');
  417.             $id_preinscription       =$request->request->get('_id_preinscription');
  418.             $id_formation    =$request->request->get('_id_formation');
  419.             // ----------------------------------------------------------------
  421.             // dd(floatval($cutisation[2])  );
  422.             if($action=='new'){ 
  423.                 $pChargeSociale -> setIdChargeS($idChargeS)
  424.                                 -> setStatut('encours') ;
  425.             }
  427.             $pChargeSociale -> setDateCharge($dateCharge)
  428.                             -> setNatureCharge($nature_charge)
  429.                             -> setRefDocAssocier($reference_doc)
  430.                             -> setDateDocAssocier($date_doc)
  431.                             -> setObjet($object)
  432.                             -> setDateSys($dNow)
  433.                             -> setSite($site_demandeur)
  434.                             -> setNatureBenef($nature_beneficiaire)
  435.                             -> setIdTier($site_tier)
  436.                             -> setSupprime(0)
  437.                             -> setMotivation($motivation)
  438.                             -> setDetailMotivation($detail_motivation)
  439.                             -> setUser($this->getUser()->getUsername())
  440.                             -> setAction($operation);
  441.             if($request->request->get('_organisme')){
  442.                 $organisme = $this->getDoctrine()->getRepository(POrganisme::class)->find(intval($request->request->get('_organisme')));
  443.                 $pChargeSociale -> setOrganisme($organisme);
  444.             }
  445.             $entityManager->persist($pChargeSociale);
  446.             // ----------------------------------------------------------------
  447.             if(trim($prestation != '')){
  448.                 for($i=0;$i<count($prestation);$i++){
  449.                     if(($prestation[$i])){
  450.                         if($action=='new'){ 
  451.                             $pChargeSocialeLg = new PChargeSocialeLg();
  452.                             $operation = "ajouter";
  453.                             
  454.                         }
  455.                         else{
  456.                             if($id_sosiale_lg[$i]){
  457.                                 $pChargeSocialeLg = $this->getDoctrine()->getRepository(PChargeSocialeLg::class)->find(intval($id_sosiale_lg[$i]));
  458.                             }
  459.                             else{
  460.                                 $pChargeSocialeLg = new PChargeSocialeLg();
  461.                                 $operation = "ajouter";
  462.                             }
  463.                         }
  464.                         $article=$this->getDoctrine()->getRepository(PArticles::class)->find(intval($prestation[$i]));
  465.                         // dd($article);
  466.                         $pChargeSocialeLg   ->setChargeS($pChargeSociale)
  467.                                             ->setArticle($article)
  468.                                             ->setQuantite($quantite[$i])
  469.                                             ->setBase($base[$i])
  470.                                             ->setTaux($taux[$i])
  471.                                             ->setMontantCharge(floatval($montant[$i]))
  472.                                             ->setDateSys($dNow)
  473.                                             ->setSupprime(0)
  474.                                             ->setUser($this->getUser()->getUsername())
  475.                                             -> setAction($operation);          
  476.                         $entityManager->persist($pChargeSocialeLg);
  477.                     }
  478.                 }
  479.             }
  480.             // ----------------------------------------------------------------
  481.            
  482.             if($TableBenef){
  483.                 foreach ($TableBenef as $tBenef) {
  485.                         if($action=='new'){ 
  486.                             $pChargeSocialeBenef = new PChargeSocialeBenef();
  487.                             $operation = "ajouter";
  488.                         }
  489.                         else{
  490.                             if($tBenef->id_sosiale_benef){
  491.                                 $pChargeSocialeBenef = $this->getDoctrine()->getRepository(PChargeSocialeBenef::class)->find(intval($tBenef->id_sosiale_benef));
  492.                                 $operation = "modifier";
  493.                                  
  494.                             }
  495.                             else{
  496.                                 $pChargeSocialeBenef = new PChargeSocialeBenef();
  497.                                 $operation = "ajouter";
  498.                             }
  499.                         }
  500.                         if($tBenef->NFacture){
  501.                             $numFacture = $this->getDoctrine() ->getRepository(PFactures::class)->findBy(array('refFacture'=>$tBenef->NFacture, 'supprime'=>0));
  502.                             if($numFacture){
  503.                                 $error = "le numéro de facture '".$tBenef->NFacture."' déjà existe ";
  504.                                 return new JsonResponse(array('Boolean' => 'false', 'error' =>$error));
  505.                             }
  506.                             $pFactures = new PFactures();
  507.                             $pFactures  ->setChargeS($pChargeSociale)
  508.                             ->setDateFacture(new \DateTime($tBenef->dateFacture))
  509.                             ->setMontantFact(floatval($tBenef->montantFactuer))
  510.                             ->setDateSys($dNow)
  511.                             ->setRefFacture($tBenef->NFacture)
  512.                             ->setIdTier($site_tier->getEtablissment())
  513.                             ->setObservation($tBenef->observation)
  514.                             ->setSupprime(0);
  515.                             $entityManager->persist($pFactures);
  516.                             $pChargeSocialeBenef ->setFacture($pFactures);
  517.                             
  518.                         }
  519.                         
  520.                         if($tBenef->benef==0){
  521.                             $pbenef  = $this->getDoctrine()->getRepository(PBeneficiaires::class)->findOneBy([], array('id'=>'DESC'));
  522.                             $numberBenef='101001'+$pbenef->getId();
  523.                             $idBenefeciaire = 'BEF_'.$numberBenef;
  525.                             $pBeneficiaires = new PBeneficiaires();
  526.                             $pBeneficiaires -> setBeneficiaire($tBenef->NAME)
  527.                                             ->setIdBeneficiaires($idBenefeciaire)
  528.                                             -> setDateSys($dNow);
  529.                             $entityManager->persist($pBeneficiaires);
  530.                         }else{
  531.                             $pBeneficiaires=$this->getDoctrine()->getRepository(PBeneficiaires::class)->find(intval($tBenef->benef));
  532.                         }
  534.                         
  535.                         $pChargeSocialeBenef    ->setChargeS($pChargeSociale)
  536.                                                 ->setBeneficiaire($pBeneficiaires)
  537.                                                 ->setNiveau($tBenef->NIVEAU)
  538.                                                 ->setAnneeUniv($tBenef->ANNEE)
  539.                                                 ->setCotisation(floatval($tBenef->CUTISATION))
  540.                                                 ->setDateSys($dNow)
  541.                                                 ->setIdDossier($tBenef->DOSSIER)
  542.                                                 ->setIdInscription($tBenef->INSCRIPTION)
  543.                                                 ->setIdPreinscription($tBenef->PREINSCRIPTION)
  544.                                                 ->setIdFormation($tBenef->FORMATION)
  545.                                                 -> setSupprime(0)
  546.                                                 -> setMontantPrest(floatval($tBenef->MTPEC))
  547.                                                 -> setUser($this->getUser()->getUsername())
  548.                                                 -> setAction($operation); 
  549.                                                 
  550.                         $entityManager->persist($pChargeSocialeBenef);
  551.                       
  552.                 }
  553.             }else{
  554.                 $error = " Veuillez remplir les informations sur le bénéficiaire ! ";
  555.                 return new JsonResponse(array('Boolean' => 'false', 'error' =>$error));
  556.             }
  557.             
  558.             $entityManager->flush();        
  559.             
  560.             // dd($TableBenef);
  561.             return new JsonResponse(array('Boolean' => 'true'));
  562.         
  563.     }
  565.     /**
  566.      * @Route("/annulerPec/{id}", name="annulerPec")
  567.      */
  568.     public function annulerPec(Request $request, $id)
  569.     {
  570.         if($request->isXmlHttpRequest()) {
  571.           
  572.             $entityManager = $this->getDoctrine()->getManager();
  573.         
  574.             $dNow = new \DateTime(date("Y/m/d"));
  576.                 $pChargeSociale = $this->getDoctrine()->getRepository(PChargeSociale::class)->find(intval($id));  
  577.                 $montantCharge= $this->getDoctrine()->getRepository(PChargeSocialeLg::class)->getTotalSocialC($pChargeSociale);
  578.                 $article=$this->getDoctrine()->getRepository(PArticles::class)->find(60);
  579.                     // dd($pChargeSociale) ;      
  580.                 $pChargeSocialeLg = new PChargeSocialeLg();
  581.                 $pChargeSocialeLg   ->setChargeS($pChargeSociale)
  582.                                     ->setArticle($article)
  583.                                     ->setQuantite(1)
  584.                                     ->setBase($montantCharge*(-1))
  585.                                     ->setTaux(100)
  586.                                     ->setMontantCharge(floatval($montantCharge*(-1)))
  587.                                     ->setDateSys($dNow)
  588.                                     ->setSupprime(0)
  589.                                     ->setUser($this->getUser()->getUsername())
  590.                                     -> setAction("annulation");          
  591.                 $entityManager->persist($pChargeSocialeLg);
  593.                 $pChargeSociale-> setStatut('annuler');
  594.                 $entityManager->persist($pChargeSociale);
  595.                 
  596.                     
  597.                 $entityManager->flush();
  598.             return new JsonResponse('ok');     
  599.         }
  600.     }
  601.         
  603.    
  604.     /**
  605.      * @Route("/pdf/{etablissment}/{id}", name="pdf")
  606.      */
  607.     public function pdf($etablissment,$id) : response
  608.     {
  609.         $information    = $this->getDoctrine() ->getRepository(PChargeSociale::class)->findOneBy(array('id'=>$id));
  610.         $details        = $this->getDoctrine() ->getRepository(PChargeSocialeLg::class)->findBy(array('chargeS'=>$id, 'supprime'=>0));
  611.         $Benefeciaires  = $this->getDoctrine() ->getRepository(PChargeSocialeBenef::class)->findBy(array('chargeS'=>$id, 'supprime'=>0));
  612.         $etabl   = $this->getDoctrine() ->getRepository(PEtablissment::class)->findOneBy(array('id'=>$information->getSite()));
  613.         $MontantCharge = $this->getDoctrine()->getRepository(PChargeSocialeLg::class)->getTotalSocialC($information);
  614.         $oneBenefeciaire= $this->getDoctrine() ->getRepository(PChargeSocialeBenef::class)->findOneBy(array('chargeS'=>$id));
  615.         $etablissmentt = $this->getDoctrine() ->getRepository(PEtablissment::class)->findOneBy(array('id'=>$etablissment));
  616.         $ListeBenefeciaires  = $this->getDoctrine() ->getRepository(PChargeSocialeBenef::class)->findByBenef($id);
  617.         // dd($Benefeciaires);
  618.         
  619.         $donneeInsc=null;
  620.         if($oneBenefeciaire->getIdInscription()){
  621.             $em = $this->getDoctrine()->getManager()->getConnection();
  622.             $statement = $em->prepare(' SELECT ins.code_inscription, ins.cin , pre.code_cab , pre.date_naissance, pre.lieu_naissance, pre.tel1, pre.adresse, prom.promotion, prom.formation   FROM x_inscription ins   INNER JOIN t_preinscription pre ON ins.code_etudiant=pre.code_etudiant
  623.             INNER JOIN v_promotion prom ON ins.promotion = prom.code_promotion
  624.             WHERE ins.code_inscription like"'.$oneBenefeciaire->getIdInscription().'" LIMIT 1');
  626.             $resultSet = $statement->executeQuery();
  627.             $data = $resultSet->fetchAll();
  628.                         
  629.                 // dd($all_natureCharge)  ;   
  630.             if($data){
  631.                 foreach($data as $dt){
  632.                     $donneeInsc=$dt;
  633.                     // dd($donneeInsc);
  634.                 }
  635.             }
  636.         }
  637.         if($etablissment==31){
  638.             $typePdf="CENTRE_SOCIAL_DACTIVITEES_AU_PROFIT_PERSONNEL_ET_AYANTS_DROIT.html.twig";
  639.         }
  640.         else if($etablissment==8){
  641.             $typePdf="CENTRE_SOCIAL_MOBILE_DES_SOINS_MEDICAUX_RABAT.html.twig";
  642.         }
  643.         else if($etablissment==49){
  644.             $typePdf="DEPARTEMENT_SOCIAL_PEC_MEDICALE_FCZ_RABAT.html.twig";
  645.         }
  646.         else if($etablissment==62){
  647.             $typePdf="HOPITAUX_PUBLICS_PARTENAIRES_RABAT.html.twig";
  648.         }
  649.         else if($etablissment==68){
  650.             $typePdf="DEPARTEMENT_SOCIAL_DE_BOURSES_DEXCELLENCE_FCZ_RABAT.html.twig";
  651.         }
  652.         else if($etablissment==69){
  653.             $typePdf="LA_MAROCAINE_DES_ŒUVRES_SOCIALES_FCZ.html.twig";
  654.         }
  655.         
  656.         $mpdf = new \Mpdf\Mpdf(['mode' => 'C','format' => 'A4','margin_header' => 5,'margin_footer' => 5,'margin_top' => 80,'margin_bottom' => 35]);
  657.         $html = $this->renderView('pdf/'.$typePdf, array(
  658.             'etablissment'  => $etablissmentt,
  659.             'information'   => $information,
  660.             'details'       => $details,
  661.             'Benefeciaires' => $Benefeciaires,
  662.             'etabl'         => $etabl,
  663.             'MontantCharge'  => $MontantCharge,
  664.             'oneBenefeciaire' => $oneBenefeciaire,
  665.             'donneeInsc' => $donneeInsc,
  666.             'ListeBenefeciaires' => $ListeBenefeciaires
  667.         ));
  668.         $mpdf->WriteHTML($html);
  669.         $mpdf->Output();
  671.         return 1;
  672.     }
  674.     /**
  675.      * @Route("/excel/{etablissment}/{statut}", name="ExporterExcel")
  676.      */
  677.     public function ExporterExcel(PEtablissment $etablissment, $statut)
  678.     {
  679.         array_map('unlink', glob( "*.zip"));     
  680.         $zip = new ZipArchive();
  681.         $zipname = 'ChargeSociales'.uniqid().'.zip';
  682.         $zip->open($zipname, ZipArchive::CREATE);
  683.         $spreadsheet = new Spreadsheet();
  685.         $condition=array( 'supprime'=>'0', 'idTier' => $etablissment->getId(),'statut'=>$statut );
  686.         if($statut =='toute'){
  687.             $condition= array( 'supprime'=>'0', 'idTier' => $etablissment->getId() );
  688.         }
  690.         $em = $this->getDoctrine()->getManager();
  691.         $pChargeSociales   = $em->getRepository(PChargeSociale::class)->findBy($condition);
  692.         // dd($pChargeSociales);
  693.         $sheet = $spreadsheet->getActiveSheet();
  694.         $sheet->setCellValue('A1', 'ID CHARGE');
  695.         $sheet->setCellValue('B1', 'DATE CHARGE');
  696.         $sheet->setCellValue('C1', 'ETABLISSEMENT DEMANDEUR');
  697.         $sheet->setCellValue('D1', 'NATURE CHARGE');
  698.         $sheet->setCellValue('E1', 'NATURE BENEFECIAIRE');
  699.         $sheet->setCellValue('F1', 'MOTIVATION');
  700.         $sheet->setCellValue('G1', 'DEDAIL MOTIVATION');
  701.         $sheet->setCellValue('H1', 'OBJET');
  702.         $sheet->setCellValue('I1', 'ORGANISME');
  703.         $sheet->setCellValue('J1', 'CHARGE'); 
  704.         $sheet->setCellValue('K1', 'FACTURE'); 
  705.         $sheet->setCellValue('L1', 'REGLEMENT'); 
  706.   
  707.        $i=2;
  708.       
  709.         foreach($pChargeSociales as $pChargeSociale){
  710.             $MontantCharge = $this->getDoctrine()->getRepository(PChargeSocialeLg::class)->getTotalSocialC($pChargeSociale);
  711.             $MontantFact = $this->getDoctrine()->getRepository(PFactures::class)->getTotalFacture($pChargeSociale);
  712.             $MontantRegl = $this->getDoctrine()->getRepository(PReglements::class)->getTotalReglement($pChargeSociale);
  714.             $sheet->setCellValue('A'.$i, $pChargeSociale->getIdChargeS());
  715.             $sheet->setCellValue('B'.$i, date_format($pChargeSociale->getDateCharge(), "d/m/Y"));
  716.             $sheet->setCellValue('C'.$i, $pChargeSociale->getSite()->getEtablissment());
  717.             $sheet->setCellValue('D'.$i, $pChargeSociale->getNatureCharge()->getNatureCharge());
  718.             $sheet->setCellValue('E'.$i, $pChargeSociale->getNatureBenef()->getNatureBenef());
  719.             if($pChargeSociale->getMotivation()){
  720.                 $sheet->setCellValue('F'.$i, $pChargeSociale->getMotivation()->getMotivation());
  721.             }else{
  722.                 $sheet->setCellValue('F'.$i, "  ");  
  723.             }
  724.             $sheet->setCellValue('G'.$i, $pChargeSociale->getDetailMotivation());
  725.             $sheet->setCellValue('H'.$i, $pChargeSociale->getObjet());
  726.             if($pChargeSociale->getOrganisme()){
  727.                 $sheet->setCellValue('I'.$i, $pChargeSociale->getOrganisme()->getOrganisme());
  728.             }else{
  729.                 $sheet->setCellValue('I'.$i, "  ");  
  730.             }
  731.             $sheet->setCellValue('J'.$i, number_format($MontantCharge, 2, ',', ''));
  732.             $sheet->setCellValue('K'.$i, number_format($MontantFact, 2, ',', '') );
  733.             $sheet->setCellValue('L'.$i, number_format($MontantRegl, 2, ',', '') );
  734.          
  735.            $i++;
  736.          }
  737.          foreach(range('A','Z') as $columnID)
  738.          {
  739.              $sheet->getColumnDimension($columnID)->setAutoSize(true);
  740.          }  
  742.         /* @var $sheet \PhpOffice\PhpSpreadsheet\Writer\Xlsx\Worksheet */
  743.             $sheet->setTitle("PecSociale");
  744.         // Create your Office 2007 Excel (XLSX Format)
  745.             $writer = new Xlsx($spreadsheet);
  746.         // Create a Temporary file in the system
  747.             $fileName = $etablissment->getEtablissment().'.xlsx';
  748.         // Create the excel file in the tmp directory of the system
  749.         $writer->save($fileName);
  750.         $zip->addFile($fileName);
  751.         
  752.     
  753.         // ________________________________________________________________
  754.         $spreadsheet = new Spreadsheet();
  756.         $sheet = $spreadsheet->getActiveSheet();
  757.         $sheet->setCellValue('A1', 'ID CHARGE');
  758.         $sheet->setCellValue('B1', 'BÉNÉFECIAIRE');
  759.         $sheet->setCellValue('C1', 'DOSSIER');
  760.         $sheet->setCellValue('D1', 'DEMANDEUR');
  761.         $sheet->setCellValue('E1', 'NATURE PEC');
  762.         $sheet->setCellValue('f1', 'DATE PEC');
  763.         $sheet->setCellValue('G1', 'REF FACTURE');
  764.         $sheet->setCellValue('H1', 'DATE FACTURE');
  765.         $sheet->setCellValue('I1', 'COTISATION');
  766.         $sheet->setCellValue('J1', 'MONTANT PREST');
  767.         $sheet->setCellValue('K1', 'NIVEAU');
  768.         $sheet->setCellValue('L1', 'ANNEE UNIV');
  769.         $i=2;
  770.       
  771.         foreach($pChargeSociales as $pChargeSociale){
  772.             $ListeBenefeciaires  = $this->getDoctrine() ->getRepository(PChargeSocialeBenef::class)->findByBenef($pChargeSociale->getId());
  773.             foreach($ListeBenefeciaires as $ListeBenefeciaire){
  775.                 $sheet->setCellValue('A'.$i, $ListeBenefeciaire['idChargeS']);
  776.                 $sheet->setCellValue('B'.$i, $ListeBenefeciaire['beneficiaire']);
  777.                 $sheet->setCellValue('C'.$i, $ListeBenefeciaire['idDossier']);
  778.                 $sheet->setCellValue('D'.$i, $ListeBenefeciaire['etablissment']);
  779.                 $sheet->setCellValue('E'.$i, $ListeBenefeciaire['natureCharge']);
  780.                 $sheet->setCellValue('F'.$i, $ListeBenefeciaire['dateCharge']);
  781.                 $sheet->setCellValue('G'.$i, $ListeBenefeciaire['refFacture']);
  782.                 if($ListeBenefeciaire['dateFacture']){
  783.                     $sheet->setCellValue('H'.$i, date_format($ListeBenefeciaire['dateFacture'], "d/m/Y"));
  784.                 }else{
  785.                     $sheet->setCellValue('H'.$i, "  "); 
  786.                 }
  787.                 $sheet->setCellValue('I'.$i, $ListeBenefeciaire['cotisation']);
  788.                 $sheet->setCellValue('J'.$i, $ListeBenefeciaire['montantPrest']);
  789.                 $sheet->setCellValue('K'.$i, $ListeBenefeciaire['niveau']);
  790.                 $sheet->setCellValue('L'.$i, $ListeBenefeciaire['anneeUniv']);
  792.                 $i++;
  793.             }
  794.          }
  795.          foreach(range('A','Z') as $columnID)
  796.          {
  797.              $sheet->getColumnDimension($columnID)->setAutoSize(true);
  798.          }  
  799.         /* @var $sheet \PhpOffice\PhpSpreadsheet\Writer\Xlsx\Worksheet */
  800.          $sheet->setTitle("Benefeciaire");
  801.         
  802.         // Create your Office 2007 Excel (XLSX Format)
  803.         $writer = new Xlsx($spreadsheet);
  804.         
  805.         // Create a Temporary file in the system
  806.         $fileName = 'benefeciaires.xlsx';
  807.         
  808.         // Create the excel file in the tmp directory of the system
  809.         $writer->save($fileName);
  810.         $zip->addFile($fileName);
  813.         
  814.         $zip->close();
  815.         // $temp_file = tempnam(sys_get_temp_dir(), $zipname);
  816.         array_map('unlink', glob( "*.xlsx"));
  817.         return new JsonResponse( $zipname);
  818.     }
  820.     /**
  821.      * @Route("/Pec/{etablissment}/{id}/dupliquer", name="dupliquerPec")
  822.      */
  823.     public function dupliquerPec($etablissment,$id): Response
  824.     {
  825.         
  826.         $pChargeSocia    = $this->getDoctrine() ->getRepository(PChargeSociale::class)->findOneBy(array('id'=>$id));
  827.         $details        = $this->getDoctrine() ->getRepository(PChargeSocialeLg::class)->findBy(array('chargeS'=>$id, 'supprime'=>0));
  828.  
  829.         $Benefeciaires  = $this->getDoctrine() ->getRepository(PChargeSocialeBenef::class)->findBy(array('chargeS'=>$id, 'supprime'=>0));
  830.         $etabl   = $this->getDoctrine() ->getRepository(PEtablissment::class)->findOneBy(array('id'=>$pChargeSocia->getSite()));
  831.         
  832.         $MontantCharge = $this->getDoctrine()->getRepository(PChargeSocialeLg::class)->getTotalSocialC($pChargeSocia);
  833.         $MontantFact = $this->getDoctrine()->getRepository(PFactures::class)->getTotalFacture($pChargeSocia);
  834.         $MontantRegl = $this->getDoctrine()->getRepository(PReglements::class)->getTotalReglement($pChargeSocia);
  835.         $etablissmentt = $this->getDoctrine() ->getRepository(PEtablissment::class)->findOneBy(array('id'=>$etablissment));
  836.         $organ;
  837.         $montantCharge= $this->getDoctrine()->getRepository(PChargeSocialeLg::class)->getTotalSocialC($pChargeSocia);
  838.         $MontantFact = $this->getDoctrine()->getRepository(PFactures::class)->getTotalFacture($pChargeSocia);
  839.      
  840.        
  841.             $all_etablissment = $this->getDoctrine() ->getRepository(PEtablissment::class)->findAll();
  842.             $all_naturecharge = $this->getDoctrine() ->getRepository(PEtablissment::class)->findOneBy(array('id'=>$etablissment));
  843.             $all_natureBenef = $this->getDoctrine() ->getRepository(PNatureBenef::class)->findAll();
  844.             $all_benefeciaire = $this->getDoctrine() ->getRepository(PBeneficiaires::class)->findAll();
  845.             $all_prestation = $this->getDoctrine() ->getRepository(PNatureCharge::class)->find($pChargeSocia->getNatureCharge()->getId()); 
  846.             $motivations = $this->getDoctrine() ->getRepository(Motivation::class)->findAll();
  847.             $organismes = $this->getDoctrine() ->getRepository(POrganisme::class)->findAll();
  849.         return $this->render('modal/DupliquerPec.html.twig', 
  850.         [   'etablissment'      => $etablissmentt,
  851.             'pChargeSocia'       => $pChargeSocia,
  852.             'details'           => $details,
  853.             'Benefeciaires'     => $Benefeciaires,
  854.             'etabl'             => $etabl,
  855.             'pChargeSocia'      => $pChargeSocia,
  856.             'all_etablissment'  =>$all_etablissment,
  857.             'all_naturecharge'  =>$all_naturecharge,
  858.             'all_natureBenef'   =>$all_natureBenef,
  859.             'all_benefeciaire'  =>$all_benefeciaire,
  860.             'all_prestation'    =>$all_prestation,
  861.             'motivations'       =>$motivations,
  862.             'organismes'        =>$organismes
  863.         ]);
  864.         
  866.     }
  868. }
  869.