src/Controller/DefaultController.php line 35

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use DateTime;
  6. use App\Entity\Log;
  8. use App\Entity\Opco;
  9. use App\Entity\Tuteur;
  11. use App\Entity\LogOpco;
  12. use App\Entity\Echeance;
  13. use App\Entity\Apprenant;
  14. use App\Utils\AjaxContent;
  15. use App\Entity\StatutAccord;
  16. use App\Entity\StatutEcheance;
  17. use App\Entity\CentreFacturation;
  18. use App\Entity\DossierFinancement;
  19. use App\Utils\InfosAdvProGenerator;
  20. use App\Entity\InscriptionFormation;
  21. use App\Utils\InfosAdvPartGenerator;
  22. use App\Form\ReportingInfosAdvProType;
  23. use App\Form\ReportingInfosAdvPartType;
  24. use App\Entity\StatutDossierFinancement;
  25. use Symfony\Component\HttpFoundation\Request;
  26. use Symfony\Component\HttpFoundation\Response;
  27. use Symfony\Component\Routing\Annotation\Route;
  28. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  30. class DefaultController extends AbstractController
  31. {
  32.     /**
  33.      * @Route("/", name="homepage")
  34.      */
  35.     public function indexAction(Request $request)
  36.     {
  37.         // $content = $this->renderView("homepage.html.twig");
  39.         $dateEche = new \DateTime();
  40.         $dateEche1 = new \DateTime();
  41.         $dateEche2 = new \DateTime();
  43.         // Sauvegarde
  44.         $save = $this->getUser()->getSettings('filters');
  45.         $listSave = array();
  46.         $tab = null;
  48.         if(isset($save['dashboard'])) {
  49.             $save = $save['dashboard'];
  51.             // Tableau des sauvegardes en format json
  52.             $tab = json_encode($save);
  54.             // Liste des sauvegardes de l'utilisateur
  55.             $listSave = array_keys($save);
  56.         }
  58.         $tabDefault = [];
  60.         $tabDefault = json_encode($tabDefault);
  62.         // ------------- PEDAGOGIE -------------
  63.         $listApprenants = $this->getDoctrine()->getRepository(Apprenant::class)->getApprenantsInactifs($this->getUser()->getId());
  65.         $nombreApprenants = sizeof($this->getDoctrine()->getRepository(Apprenant::class)->getApprenantsInactifs($this->getUser()->getId(), true));
  67.         // Recupere les inscriptions de l'apprenant
  68.         $listInscriptionFormation = array();
  70.         foreach($listApprenants as $apprenant) {
  71.             $parameters["apprenant"] = $apprenant;
  72.             $listInscriptionFormation[$apprenant->getId()] = $this->getDoctrine()->getRepository(InscriptionFormation::class)->sortListInscriptions($parameters);
  73.         }
  75.         // ------------- TUTORAT -------------
  76.         $listTuteurs = $this->getDoctrine()->getRepository(Tuteur::class)->getTuteursInactifs($this->getUser()->getId());
  78.         $nombreTuteurs = sizeof($listTuteurs);
  80.         // Dossier Financement sans accord
  81.         $listDossierFiSa = $this->getDoctrine()->getRepository(DossierFinancement::class)->getSansAccordDashboard();
  83.         $nombreDossierFiSa = sizeof($listDossierFiSa);
  85.         $actions                = array();
  86.         $entity                 = array();
  87.         $opco                   = array();
  88.         $status                 = array();
  89.         $centreFacturation      = array();
  90.         $keyword                = "";
  91.         $page                   = 1;
  93.         if($this->getUser()->getRole()->getId() == 1){
  94.             $logOpco = $this->getDoctrine()->getRepository(LogOpco::class)->listLogsOpco($actions, $entity, $opco, $status, $centreFacturation, $keyword, null, $page);
  95.         }else{
  96.             $logOpco = $this->getDoctrine()->getRepository(LogOpco::class)->listLogsOpco($actions, $entity, $opco, $status, $centreFacturation, $keyword, $this->getUser(), $page);
  97.         }
  99.         if($this->getUser()->hasAccessTo("dashboard_adv")){
  100.             // ------------- ADV -------------
  102.             // PART
  103.             $partDossierEnCours = [];
  104.             $partDossierTermines = [];
  105.             $partAnomalieDossierMontant = [];
  106.             $partAnomalieDossierMontantEgal0 = [];
  107.             $partAnomalieDossierEcheanceEnRetard = [];
  108.             $partDossierEcheanceRefusee = [];
  109.             $partDossierEcheanceDepasseeSansFacture = [];
  110.             $partCaDuMois = 0;
  111.             $partCaEnAttente = 0;
  112.             $partCaEnRetard = 0;
  114.             // PRO
  115.             $proDossierEnCours = [];
  116.             $proDossierTermines = [];
  117.             $proDossierSansAccord = [];
  118.             $proDossierSansAccord2Mois = [];
  119.             $proCaDuMois = [];
  120.             $proCaEcheanceRetard = [];
  121.             $proCaEcheanceEnAttenteEncaissement = [];
  122.             $proCaSansAccord = [];
  123.             $proDossierEcheancePasseeSansFacture = [];
  124.             $proDossierPbMontantTotal = [];
  125.             $proDossierMontantTotal0 = [];
  126.             $proDossierEcheanceAttenteDepassee14 = [];
  127.             $proDossierEcheanceTransmiseDepassee30 = [];
  129.             foreach ($this->getDoctrine()->getRepository(DossierFinancement::class)->findExercice() as $dossier) {
  130.                 // PART
  131.                 if($dossier->getFinancement()->getId() == 1){
  132.                     $montantRegle = 0;
  133.                     $montantTotal = 0;
  135.                     foreach ($dossier->getEcheances() as $echeance) {
  136.                         if($echeance->getDate()->format("Y-m-d") >= date("2023-09-01")){
  137.                             // Montant total des échéances
  138.                             $montantTotal += $echeance->getMontant();
  140.                             // Si échéance est validée ou en perte
  141.                             if($echeance->getStatut()->getId() == 1 || $echeance->getStatut()->getId() == 7){
  142.                                 $montantRegle += $echeance->getMontant();
  143.                             }
  145.                             // Si échéance est en attente ou refusée
  146.                             if($echeance->getStatut()->getId() == 3 || $echeance->getStatut()->getId() == 6){
  147.                                 $partDossierEnCours[] = $dossier;
  148.                             }
  150.                             // Si échéance en retard de facturation
  151.                             if($echeance->getStatut()->getId() == 3 && $echeance->getDate()->modify("+5 jours")->format("Y-m-d") < date("Y-m-d")){
  152.                                 $partAnomalieDossierEcheanceEnRetard[] = $dossier;
  153.                             }
  155.                             // Si échéance dépassée sans facture
  156.                             if($echeance->getDate()->format("Y-m-d") < date("Y-m-d") && $echeance->hasFacture() == false){
  157.                                 $partDossierEcheanceDepasseeSansFacture[] = $dossier;
  159.                                 $partCaEnRetard += $echeance->getMontant();
  160.                             }
  162.                             // Si échéance est refusée
  163.                             if($echeance->getStatut()->getId() == 6){
  164.                                 $partDossierEcheanceRefusee[] = $dossier;
  165.                             }
  167.                             // CA du mois
  168.                             if($echeance->hasFacture() && $echeance->getDate()->format("m/Y") == date("m/Y")){
  169.                                 $partCaDuMois += $echeance->getMontant();
  170.                             }
  172.                             // CA en attente
  173.                             if($echeance->getDate()->format("Y-m-d") < date("Y-m-d") && ($echeance->getStatut()->getId() == 3 || $echeance->getStatut()->getId() == 6)){
  174.                                 $partCaEnAttente += $echeance->getMontant();
  175.                             }
  176.                         }
  177.                     }
  179.                     // Si montant du dossier est égal au montant réglé
  180.                     if($dossier->getMontant() == $montantRegle){
  181.                         $partDossierTermines[] = $dossier;
  182.                     }
  184.                     // Si montant du dossier est égal au montant réglé
  185.                     if($dossier->getDateAdminDebut() >= "2023-09-01" && $dossier->getMontant() != $montantTotal){
  186.                         $partAnomalieDossierMontant[] = $dossier;
  187.                     }
  189.                     // Si montant du dossier est égal au montant réglé
  190.                     if($dossier->getMontant() == 0 || $montantTotal == 0){
  191.                         $partAnomalieDossierMontantEgal0[] = $dossier;
  192.                     }
  193.                 }
  194.                 // PRO
  195.                 else{
  196.                     $montantRegle = 0;
  197.                     $montantTotal = 0;
  199.                     $boolEcheancePasseeSansFacture = false;
  200.                     $boolEcheanceAttenteDepassee14 = false;
  201.                     $boolEcheanceTransmiseDepassee30 = false;
  203.                     foreach ($dossier->getEcheances() as $echeance) {
  204.                         // Montant total des échéances
  205.                         $montantTotal += $echeance->getMontant();
  207.                         // Si échéance est validée ou en perte
  208.                         if($echeance->getStatut()->getId() == 1 || $echeance->getStatut()->getId() == 7){
  209.                             $montantRegle += $echeance->getMontant();
  210.                         }
  212.                         if($echeance->getDate()->format("Y-m-d") >= date("2023-09-01")){
  213.                             // Si échéance est en attente ou refusée
  214.                             if($echeance->getStatut()->getId() == 3){
  215.                                 $proDossierEnCours[] = $dossier;
  216.                             }
  217.                             
  218.                             // 
  219.                             if($echeance->hasFacture() && $echeance->getDate()->format("m/Y") == date("m/Y")){
  220.                                 if(isset($proCaDuMois[$echeance->getDossierFinancement()->getFinancement()->getNom()][$echeance->getDossierFinancement()->getInscriptionFormation()->getCentreFacturation()->getNom()])){
  221.                                     $proCaDuMois[$echeance->getDossierFinancement()->getFinancement()->getNom()][$echeance->getDossierFinancement()->getInscriptionFormation()->getCentreFacturation()->getNom()] += $echeance->getMontant();
  222.                                 }else{
  223.                                     $proCaDuMois[$echeance->getDossierFinancement()->getFinancement()->getNom()][$echeance->getDossierFinancement()->getInscriptionFormation()->getCentreFacturation()->getNom()] = $echeance->getMontant();
  224.                                 }
  225.                             }
  227.                             // Si échéance en retard de facturation
  228.                             if($echeance->getStatut()->getId() == 3 && $echeance->getDate()->format("Y-m-d") < date("Y-m-d")){
  229.                                 if(isset($proCaEcheanceRetard[$echeance->getDossierFinancement()->getFinancement()->getNom()][$echeance->getDossierFinancement()->getInscriptionFormation()->getCentreFacturation()->getNom()])){
  230.                                     $proCaEcheanceRetard[$echeance->getDossierFinancement()->getFinancement()->getNom()][$echeance->getDossierFinancement()->getInscriptionFormation()->getCentreFacturation()->getNom()] += $echeance->getMontant();
  231.                                 }else{
  232.                                     $proCaEcheanceRetard[$echeance->getDossierFinancement()->getFinancement()->getNom()][$echeance->getDossierFinancement()->getInscriptionFormation()->getCentreFacturation()->getNom()] = $echeance->getMontant();
  233.                                 }
  234.                             }
  236.                             // Si échéance en retard de facturation
  237.                             if($echeance->getStatut()->getId() == 5){
  238.                                 if(isset($proCaEcheanceEnAttenteEncaissement[$echeance->getDossierFinancement()->getFinancement()->getNom()][$echeance->getDossierFinancement()->getInscriptionFormation()->getCentreFacturation()->getNom()])){
  239.                                     $proCaEcheanceEnAttenteEncaissement[$echeance->getDossierFinancement()->getFinancement()->getNom()][$echeance->getDossierFinancement()->getInscriptionFormation()->getCentreFacturation()->getNom()] += $echeance->getMontant();
  240.                                 }else{
  241.                                     $proCaEcheanceEnAttenteEncaissement[$echeance->getDossierFinancement()->getFinancement()->getNom()][$echeance->getDossierFinancement()->getInscriptionFormation()->getCentreFacturation()->getNom()] = $echeance->getMontant();
  242.                                 }
  243.                                 
  244.                             }
  246.                             // Si échéance passée sans facture
  247.                             if($echeance->hasFacture() == false && $echeance->getStatut()->getId() == 3 && $echeance->getDate()->format("Y-m-d") < date("Y-m-d") && $boolEcheancePasseeSansFacture == false){
  248.                                 if(isset($proDossierEcheancePasseeSansFacture[$echeance->getDossierFinancement()->getFinancement()->getNom()][$echeance->getDossierFinancement()->getInscriptionFormation()->getCentreFacturation()->getNom()])){
  249.                                     $proDossierEcheancePasseeSansFacture[$echeance->getDossierFinancement()->getFinancement()->getNom()][$echeance->getDossierFinancement()->getInscriptionFormation()->getCentreFacturation()->getNom()] += 1;
  250.                                 }else{
  251.                                     $proDossierEcheancePasseeSansFacture[$echeance->getDossierFinancement()->getFinancement()->getNom()][$echeance->getDossierFinancement()->getInscriptionFormation()->getCentreFacturation()->getNom()] = 1;
  252.                                 }
  253.                                 
  254.                                 $boolEcheancePasseeSansFacture = true;
  255.                             }
  257.                             // Si échéance en attente dépassée de +14 jours
  258.                             if($echeance->getStatut()->getId() == 3 && $echeance->getDate()->modify("+14 jours")->format("Y-m-d") < date("Y-m-d") && $boolEcheanceAttenteDepassee14 == false){
  259.                                 if(isset($proDossierEcheanceAttenteDepassee14[$echeance->getDossierFinancement()->getFinancement()->getNom()][$echeance->getDossierFinancement()->getInscriptionFormation()->getCentreFacturation()->getNom()])){
  260.                                     $proDossierEcheanceAttenteDepassee14[$echeance->getDossierFinancement()->getFinancement()->getNom()][$echeance->getDossierFinancement()->getInscriptionFormation()->getCentreFacturation()->getNom()] += 1;
  261.                                 }else{
  262.                                     $proDossierEcheanceAttenteDepassee14[$echeance->getDossierFinancement()->getFinancement()->getNom()][$echeance->getDossierFinancement()->getInscriptionFormation()->getCentreFacturation()->getNom()] = 1;
  263.                                 }
  264.                                 $boolEcheanceAttenteDepassee14 = true;
  265.                             }
  267.                             // Si échéance en attente dépassée de +14 jours
  268.                             if($echeance->getStatut()->getId() == 5 && $echeance->getDate()->modify("+30 jours")->format("Y-m-d") < date("Y-m-d") && $boolEcheanceTransmiseDepassee30 == false){
  269.                                 if(isset($proDossierEcheanceTransmiseDepassee30[$echeance->getDossierFinancement()->getFinancement()->getNom()][$echeance->getDossierFinancement()->getInscriptionFormation()->getCentreFacturation()->getNom()])){
  270.                                     $proDossierEcheanceTransmiseDepassee30[$echeance->getDossierFinancement()->getFinancement()->getNom()][$echeance->getDossierFinancement()->getInscriptionFormation()->getCentreFacturation()->getNom()] += 1;
  271.                                 }else{
  272.                                     $proDossierEcheanceTransmiseDepassee30[$echeance->getDossierFinancement()->getFinancement()->getNom()][$echeance->getDossierFinancement()->getInscriptionFormation()->getCentreFacturation()->getNom()] = 1;
  273.                                 }
  274.                                 $boolEcheanceTransmiseDepassee30 = true;
  275.                             }
  276.                         }
  277.                     }
  279.                     // Si montant du dossier est égal au montant réglé
  280.                     if($dossier->getMontant() == $montantRegle){
  281.                         $proDossierTermines[] = $dossier;
  282.                     }
  284.                     // Si montant du dossier est pas égal au montant total
  285.                     if($dossier->getMontant() != $montantTotal){
  286.                         if(isset($proDossierPbMontantTotal[$dossier->getFinancement()->getNom()][$dossier->getInscriptionFormation()->getCentreFacturation()->getNom()])){
  287.                             $proDossierPbMontantTotal[$dossier->getFinancement()->getNom()][$dossier->getInscriptionFormation()->getCentreFacturation()->getNom()] += 1;
  288.                         }else{
  289.                             $proDossierPbMontantTotal[$dossier->getFinancement()->getNom()][$dossier->getInscriptionFormation()->getCentreFacturation()->getNom()] = 1;
  290.                         }
  291.                     }
  293.                     // Si montant du dossier est pas égal au montant total
  294.                     if($montantTotal == 0 && ($dossier->getStatutAccord() == null or $dossier->getStatutAccord()->getId() == 1)){
  295.                         if(isset($proDossierMontantTotal0[$dossier->getFinancement()->getNom()][$dossier->getInscriptionFormation()->getCentreFacturation()->getNom()])){
  296.                             $proDossierMontantTotal0[$dossier->getFinancement()->getNom()][$dossier->getInscriptionFormation()->getCentreFacturation()->getNom()] += 1;
  297.                         }else{
  298.                             $proDossierMontantTotal0[$dossier->getFinancement()->getNom()][$dossier->getInscriptionFormation()->getCentreFacturation()->getNom()] = 1;
  299.                         }
  300.                     }
  302.                     // Si montant du dossier est égal au montant réglé
  303.                     if($dossier->getStatutAccord() != null && $dossier->getStatutAccord()->getId() == 3){
  304.                         if(isset($proCaSansAccord[$dossier->getFinancement()->getNom()][$dossier->getInscriptionFormation()->getCentreFacturation()->getNom()])){
  305.                             $proCaSansAccord[$dossier->getFinancement()->getNom()][$dossier->getInscriptionFormation()->getCentreFacturation()->getNom()] += $dossier->getmontant();
  306.                         }else{
  307.                             $proCaSansAccord[$dossier->getFinancement()->getNom()][$dossier->getInscriptionFormation()->getCentreFacturation()->getNom()] = $dossier->getmontant();
  308.                         }
  309.                         
  310.                         
  311.                         // Si créé depuis plus de 2 mois
  312.                         if($dossier->getCreatedAt()->modify("+2 months")->format("Y-m-d") < date("Y-m-d")){
  313.                             $proDossierSansAccord2Mois[] = $dossier;
  314.                             $proDossierSansAccord[] = $dossier;
  315.                         }else{
  316.                             $proDossierSansAccord[] = $dossier;
  317.                         }
  318.                     }
  319.                 }
  320.             }
  322.             $listCentreFacturation = $this->getDoctrine()->getRepository(CentreFacturation::class)->findBy(["hidden" => 0], []);
  323.         
  325.             $content = $this->renderView("dashboard/dashboard.html.twig",[
  326.                 "logsOpco" => $logOpco,
  327.                 "opcos" => $this->getDoctrine()->getRepository(Opco::class)->findAll(),
  328.                 "centreFacturations" => $this->getDoctrine()->getRepository(CentreFacturation::class)->findBy(["hidden" => 0], []),
  329.                 "echeances" => $this->getDoctrine()->getRepository(Echeance::class)->findByRefAdmin($dateEche->format("Y-m-d"), $dateEche1->modify("+1days")->format("Y-m-d"), $dateEche2->modify("+2days")->format("Y-m-d"), $this->getDoctrine()->getRepository(StatutEcheance::class)->findOneBy(["id" => 3], []), $this->getUser()),
  330.                 "echeancesTransmise" => $this->getDoctrine()->getRepository(Echeance::class)->findByRefAdminStatut($this->getDoctrine()->getRepository(StatutEcheance::class)->findOneBy(["id" => 5]), $this->getUser()),
  331.                 "facture" => false,
  332.                 "listSave" => $listSave,
  333.                 "tab" => $tab,
  334.                 "tabDefault" => $tabDefault,
  335.                 "listApprenants" => $listApprenants,
  336.                 "listInscriptionFormation" => $listInscriptionFormation,
  337.                 "nombreApprenants" => $nombreApprenants,
  338.                 "listTuteurs" => $listTuteurs,
  339.                 "nombreTuteurs" => $nombreTuteurs,
  340.                 "listDossierFiSa" => $listDossierFiSa,
  341.                 "nombreDossierFiSa" => $nombreDossierFiSa,
  342.                 "listCentreFacturation" => $listCentreFacturation,
  343.                 // PART
  344.                 "nombreDossiersEnCoursPart" => count(array_unique($partDossierEnCours)),
  345.                 "nombreDossiersTerminesPart" => count(array_unique($partDossierTermines)),
  346.                 "nombreDossierEcheanceRefuseePart" => count(array_unique($partDossierEcheanceRefusee)),
  347.                 "nombreDossierEcheanceDepasseeSansFacturePart" => count(array_unique($partDossierEcheanceDepasseeSansFacture)),
  348.                 "partAnomalieDossierMontant" => count(array_unique($partAnomalieDossierMontant)),
  349.                 "partAnomalieDossierMontantEgal0" => count(array_unique($partAnomalieDossierMontantEgal0)),
  350.                 "partAnomalieDossierEcheanceEnRetard" => count(array_unique($partAnomalieDossierEcheanceEnRetard)),
  351.                 "partCaDuMois" => $partCaDuMois,
  352.                 "partCaEnAttente" => $partCaEnAttente,
  353.                 "partCaEnRetard" => $partCaEnRetard,
  354.                 // PRO
  355.                 "nombreDossiersEnCoursPro" => count(array_unique($proDossierEnCours)),
  356.                 "nombreDossiersTerminesPro" => count(array_unique($proDossierTermines)),
  357.                 "nombreDossiersSansAccordPro" => count(array_unique($proDossierSansAccord)),
  358.                 "nombreDossiersSansAccord2MoisPro" => count(array_unique($proDossierSansAccord2Mois)),
  359.                 "proCaDuMois" => $proCaDuMois,
  360.                 "proCaEcheanceRetard" => $proCaEcheanceRetard,
  361.                 "proCaEcheanceEnAttenteEncaissement" => $proCaEcheanceEnAttenteEncaissement,
  362.                 "proCaSansAccord" => $proCaSansAccord,
  363.                 "proDossierEcheancePasseeSansFacture" => $proDossierEcheancePasseeSansFacture,
  364.                 "proDossierPbMontantTotal" => $proDossierPbMontantTotal,
  365.                 "proDossierMontantTotal0" => $proDossierMontantTotal0,
  366.                 "proDossierEcheanceAttenteDepassee14" => $proDossierEcheanceAttenteDepassee14,
  367.                 "proDossierEcheanceTransmiseDepassee30" => $proDossierEcheanceTransmiseDepassee30
  368.             ]);
  369.         }else{
  370.             $content = $this->renderView("dashboard/dashboard.html.twig",[
  371.                 "logsOpco" => $logOpco,
  372.                 "opcos" => $this->getDoctrine()->getRepository(Opco::class)->findAll(),
  373.                 "centreFacturations" => $this->getDoctrine()->getRepository(CentreFacturation::class)->findBy(["hidden" => 0], []),
  374.                 "echeances" => $this->getDoctrine()->getRepository(Echeance::class)->findByRefAdmin($dateEche->format("Y-m-d"), $dateEche1->modify("+1days")->format("Y-m-d"), $dateEche2->modify("+2days")->format("Y-m-d"), $this->getDoctrine()->getRepository(StatutEcheance::class)->findOneBy(["id" => 3], []), $this->getUser()),
  375.                 "echeancesTransmise" => $this->getDoctrine()->getRepository(Echeance::class)->findByRefAdminStatut($this->getDoctrine()->getRepository(StatutEcheance::class)->findOneBy(["id" => 5]), $this->getUser()),
  376.                 "facture" => false,
  377.                 "listSave" => $listSave,
  378.                 "tab" => $tab,
  379.                 "tabDefault" => $tabDefault,
  380.                 "listApprenants" => $listApprenants,
  381.                 "listInscriptionFormation" => $listInscriptionFormation,
  382.                 "nombreApprenants" => $nombreApprenants,
  383.                 "listTuteurs" => $listTuteurs,
  384.                 "nombreTuteurs" => $nombreTuteurs,
  385.                 "listDossierFiSa" => $listDossierFiSa,
  386.                 "nombreDossierFiSa" => $nombreDossierFiSa
  387.             ]);
  388.         }
  390.         $response = new Response($content, 200);
  392.         $contentLength = strlen($content);
  394.         $response->headers->set("Content-Length", $contentLength);
  395.         $response->headers->set("Cache-Control", "no-cache");
  397.         return $response;
  398.     }
  400.     /**
  401.      * Liste des logs
  402.      * @Route("/list/logs/opco", name="list_log_opco")
  403.      */
  404.     public function listLogOpco(Request $request)
  405.     {
  406.         $ajaxContent = new AjaxContent($request);
  408.         $formSorting = $ajaxContent->getForm("logOpco_sorting");
  410.         $actions                = array();
  411.         $entity                 = array();
  412.         $opco                   = array();
  413.         $status                 = array();
  414.         $centreFacturation      = array();
  415.         $dossierFinancement     = array();
  416.         $keyword                = "";
  417.         $page                   = null;
  418.         $date1                  = null;
  419.         $date2                  = null;
  421.         if(!empty($formSorting)) {
  423.             // Actions
  424.             if(isset($formSorting["keyword"])) {
  425.                 $keyword = $formSorting["keyword"];
  426.             }
  428.             // Actions
  429.             if(isset($formSorting["action"])) {
  430.                 $actions = $formSorting["action"];
  431.             }
  433.             // Actions
  434.             if(isset($formSorting["entity"])) {
  435.                 $entity = $formSorting["entity"];
  436.             }
  438.             // Opco
  439.             if(isset($formSorting["opco"])) {
  440.                 $opco = $formSorting["opco"];
  441.             }
  443.             // Opco
  444.             if(isset($formSorting["status"])) {
  445.                 $status = $formSorting["status"];
  446.             }
  448.             // Centre facturation
  449.             if(isset($formSorting["centreFacturation"])) {
  450.                 $centreFacturation = $formSorting["centreFacturation"];
  451.             }
  453.             // Date 1 - Début du créneau
  454.             if(isset($formSorting["date1"]) && $formSorting["date1"] !== "") {
  455.                 $date1 = date_create_immutable_from_format("d/m/Y", $formSorting["date1"]);
  456.             }
  458.             // Date 2 - Début du créneau
  459.             if(isset($formSorting["date2"]) && $formSorting["date2"] !== "") {
  460.                 $date2 = date_create_immutable_from_format("d/m/Y", $formSorting["date2"]);
  461.             }
  463.             // Page
  464.             if(isset($formSorting["page"])) {
  465.                 $page = $formSorting["page"];
  466.             }
  467.         }else {
  468.             // Tri par defaut - Page 1
  469.             $page = 1;
  470.         }
  472.         if($this->getUser()->getRole()->getId() == 1){
  473.             $logsOpco = $this->getDoctrine()->getRepository(LogOpco::class)->listLogsOpco($actions, $entity, $opco, $status, $centreFacturation, $keyword, null, $page, $date1, $date2);
  474.         }else{
  475.             $logsOpco = $this->getDoctrine()->getRepository(LogOpco::class)->listLogsOpco($actions, $entity, $opco, $status, $centreFacturation, $keyword, $this->getUser(), $page, $date1, $date2);
  476.         }
  478.         $opcos = $this->getDoctrine()->getRepository(Opco::class)->findAll();
  479.         $centreFacturations = $this->getDoctrine()->getRepository(CentreFacturation::class)->findBy(["hidden" => 0], []);
  481.         // Render
  482.         return $this->render("dashboard/dashboard.html.twig", array(
  483.             "logsOpco" => $logsOpco,
  484.             "opcos" => $opcos,
  485.             "centreFacturations" => $centreFacturations,
  486.             "echeances" => "",
  487.             "echeancesTransmise" => "",
  488.             "facture" => false,
  489.             "listSave" => "",
  490.             "tab" => "",
  491.             "tabDefault" => "",
  492.             "listApprenants" => "",
  493.             "listInscriptionFormation" => "",
  494.             "listCentreFacturation" => "",
  495.             "nombreApprenants" => "",
  496.             "listTuteurs" => "",
  497.             "nombreTuteurs" => "",
  498.             "listDossierFiSa" => "",
  499.             "nombreDossierFiSa" => "",
  500.             // PART
  501.             "nombreDossiersEnCoursPart" => "",
  502.             "nombreDossiersTerminesPart" => "",
  503.             "nombreDossierEcheanceRefuseePart" => "",
  504.             "nombreDossierEcheanceDepasseeSansFacturePart" => "",
  505.             "partAnomalieDossierMontant" => "",
  506.             "partAnomalieDossierMontantEgal0" => "",
  507.             "partAnomalieDossierEcheanceEnRetard" => "",
  508.             "partCaDuMois" => "",
  509.             "partCaEnAttente" => "",
  510.             "partCaEnRetard" => "",
  511.             // PRO
  512.             "nombreDossiersEnCoursPro" => "",
  513.             "nombreDossiersTerminesPro" => "",
  514.             "nombreDossiersSansAccordPro" => "",
  515.             "nombreDossiersSansAccord2MoisPro" => "",
  516.             "proCaDuMois" => "",
  517.             "proCaEcheanceRetard" => "",
  518.             "proCaEcheanceEnAttenteEncaissement" => "",
  519.             "proDossierEcheancePasseeSansFacture" => "",
  520.             "proCaSansAccord" => "",
  521.             "proDossierPbMontantTotal" => "",
  522.             "proDossierMontantTotal0" => "",
  523.             "proDossierEcheanceAttenteDepassee14" => "",
  524.             "proDossierEcheanceTransmiseDepassee30" => "",
  525.         ));
  526.     }
  528.     /**
  529.      * Liste des logs
  530.      * @Route("/reportin/infos-adv/part", name="reporting_infos_adv_part")
  531.      */
  532.     public function reportingInfoAdvPart(Request $request, InfosAdvPartGenerator $documentGenerator){
  533.         $ajaxContent = new AjaxContent($request);
  535.         $additionalData = $ajaxContent->getAdditionalData();
  537.         if($ajaxContent->isMethodGet()) {
  539.             $form = $this->createForm(ReportingInfosAdvPartType::class, null, array(
  540.                 "attr" => [
  541.                     "class"                 => "ajax-submit",
  542.                     "novalidate"            => "novalidate",
  543.                     "data-route"            => $this->generateUrl("reporting_infos_adv_part"),
  544.                     "data-id-container"     => "#modal",
  545.                     "data-container-type"   => "modal-file-download",
  546.                 ]
  547.             ));
  549.             // Render form
  550.             return $this->render("formulaire-reporting-infos-adv-part-modal.html.twig", [
  551.                 "form" => $form->createView(),
  552.                 "title" => "Créer un reporting des infos ADV des parts"
  553.             ]);
  554.         }
  555.         else if($ajaxContent->isMethodPost()) {
  556.             $form = $this->createForm(ReportingInfosAdvPartType::class, null);
  557.             $form->submit($ajaxContent->getForm($form->getName()));
  559.             if($form->isSubmitted() && $form->isValid()) {
  561.                 $em = $this->getDoctrine()->getManager();
  563.                 $log = new Log(Log::ACTIONS["DOWNLOAD"], Log::ENTITIES["EXPORT_REPORTING"], null, null, null, $this->getUser());
  564.                 $em->persist($log);
  565.                 $em->flush();
  567.                 $dossiers = $this->getDoctrine()->getRepository(DossierFinancement::class)->findExercice();
  569.                 return $documentGenerator->exportDocument($dossiers);
  570.             }
  571.         }
  572.         else {
  573.             // ERROR - Mauvaise methode HTTP
  574.             return new Response("Method Not Allowed", 405);
  575.         }
  576.     }
  578.     /**
  579.      * Liste des logs
  580.      * @Route("/reportin/infos-adv/pro", name="reporting_infos_adv_pro")
  581.      */
  582.     public function reportingInfoAdvPro(Request $request, InfosAdvProGenerator $documentGenerator){
  583.         $ajaxContent = new AjaxContent($request);
  585.         $additionalData = $ajaxContent->getAdditionalData();
  587.         if($ajaxContent->isMethodGet()) {
  589.             $form = $this->createForm(ReportingInfosAdvProType::class, null, array(
  590.                 "attr" => [
  591.                     "class"                 => "ajax-submit",
  592.                     "novalidate"            => "novalidate",
  593.                     "data-route"            => $this->generateUrl("reporting_infos_adv_pro"),
  594.                     "data-id-container"     => "#modal",
  595.                     "data-container-type"   => "modal-file-download",
  596.                 ]
  597.             ));
  599.             // Render form
  600.             return $this->render("formulaire-reporting-infos-adv-pro-modal.html.twig", [
  601.                 "form" => $form->createView(),
  602.                 "title" => "Créer un reporting des infos ADV des pros"
  603.             ]);
  604.         }
  605.         else if($ajaxContent->isMethodPost()) {
  606.             $form = $this->createForm(ReportingInfosAdvProType::class, null);
  607.             $form->submit($ajaxContent->getForm($form->getName()));
  609.             if($form->isSubmitted() && $form->isValid()) {
  611.                 $em = $this->getDoctrine()->getManager();
  613.                 $log = new Log(Log::ACTIONS["DOWNLOAD"], Log::ENTITIES["EXPORT_REPORTING"], null, null, null, $this->getUser());
  614.                 $em->persist($log);
  615.                 $em->flush();
  617.                 $dossiers = $this->getDoctrine()->getRepository(DossierFinancement::class)->findExercice();
  619.                 $listCentreFacturation = $this->getDoctrine()->getRepository(CentreFacturation::class)->findBy(["hidden" => 0], []);
  621.                 return $documentGenerator->exportDocument($dossiers, $listCentreFacturation);
  622.             }
  623.         }
  624.         else {
  625.             // ERROR - Mauvaise methode HTTP
  626.             return new Response("Method Not Allowed", 405);
  627.         }
  628.     }
  629. }