src/Controller/MasterController.php line 107

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\Document;
  6. use App\Entity\DocumentCategory;
  7. use App\Entity\Folder;
  8. use App\Entity\Identite;
  9. use App\Entity\Users;
  10. use App\Form\InitiateRequestSurferType;
  11. use App\Form\InitiateRequestType;
  12. use App\Form\SearchDocumentCategoryType;
  13. use Doctrine\Persistence\ManagerRegistry;
  14. use Symfony\Component\HttpFoundation\Request;
  15. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  16. use Psr\Log\LoggerInterface;
  17. use Symfony\Component\Mailer\MailerInterface;
  18. use Symfony\Contracts\Cache\CacheInterface;
  19. use Symfony\Contracts\Cache\ItemInterface;
  21. class MasterController extends AbstractController
  22. {
  23.     private ManagerRegistry $managerRegistry;
  24.     private LoggerInterface $logger;
  26.     private MailerInterface $mailer;
  28.     private CacheInterface $cache;
  30.     /**
  31.      * @param ManagerRegistry $managerRegistry
  32.      * @param LoggerInterface $logger
  33.      * @param MailerInterface $mailer
  34.      * @param CacheInterface $cache
  35.      */
  36.     public function __construct(ManagerRegistry $managerRegistry, LoggerInterface $logger, MailerInterface $mailer, CacheInterface $cache)
  37.     {
  38.         $this->managerRegistry = $managerRegistry;
  39.         $this->logger = $logger;
  40.         $this->mailer = $mailer;
  41.         $this->cache = $cache;
  42.     }
  45.     public function homepage()
  46.     {
  47.         $this->logger->info('Homepage visited');
  49.         // retreive all documentCategory with isPublished = true
  50.         $documentCategories = $this->managerRegistry->getRepository(DocumentCategory::class)->findBy([
  51.             'isPublished' => true,
  52.         ]);
  54.         $documentArray = [];
  55.         // adding documentCategory to an array
  56.         foreach ($documentCategories as $documentCategory) {
  57.             $documentArray[] = [
  58.                 'id' => $documentCategory->getId(),
  59.                 'name' => $documentCategory->getLabel(),
  60.                 'iconClass' => $documentCategory->getIconClass(),
  61.                 'service' => [
  62.                     'id' => $documentCategory->getService()->getId(),
  63.                     'name' => $documentCategory->getService()->getLabel(),
  64.                 ]
  65.             ];
  66.         }
  69.         if (!is_null($this->getUser())) {
  70.             $user = $this->getUser();
  71.             $lastDateUpdate = $this->getUser()->getUpdatePasswordDate();
  73.             if (!is_null($lastDateUpdate)) {
  74.                 $dateSys = new \DateTime();
  75.                 $diff = date_diff($dateSys, $lastDateUpdate);
  77.                 if ($diff->days >= 10 | $this->getUser()->getFirstLogin() == true) {
  78.                     $userUpdate = $user->getMail();
  79.                     $this->addFlash('password_expire', 'Bonjour ' .$userUpdate. ' votre mot de passe a expiré, prière le mettre à jour!');
  81.                     return $this->redirectToRoute('app_user_update_password', ['user_id' => $this->getUser()->getId()]);
  82.                 }
  83.             } else {
  84.                 return $this->render('master/home.html.twig',[
  85.                     'documentCategories' => $documentArray,
  86.                 ]);
  87.             }
  89.             if ($this->getUser()->getFirstLogin() == true) {
  90.                 $userUpdate = $user->getMail();
  92.                 $this->addFlash('first_connexion', 'Bonjour ' .$userUpdate. ' Ceci est votre première connexion, prière de mettre à jour votre mot de passe!');
  93.                 return $this->redirectToRoute('app_user_update_password', ['user_id' => $this->getUser()->getId()]);
  94.             } else {
  95.                 return $this->render('master/home.html.twig',[
  96.                     'documentCategories' => $documentArray,
  97.                 ]);
  98.             }
  99.         } else {
  100.             return $this->render('master/home.html.twig',[
  101.                 'documentCategories' => $documentArray,
  102.             ]);
  103.         }
  104.     }
  107.     public function homepageBis(Request $request)
  108.     {
  109.         $this->logger->info('Homepage visited');
  110.         $docForm = $this->createForm(SearchDocumentCategoryType::class);
  112.         // retrieve all documentCategory with isPublished = true
  113. //        $documentCategories = $this->managerRegistry->getRepository(Document::class)->getMostPrintedDocument();
  115.         if (!is_null($this->getUser())) {
  116.             $user = $this->getUser();
  117.             $lastDateUpdate = $this->getUser()->getUpdatePasswordDate();
  119.             if (!is_null($lastDateUpdate)) {
  120.                 $dateSys = new \DateTime();
  121.                 $diff = date_diff($dateSys, $lastDateUpdate);
  123.                 if ($diff->days >= 10 | $this->getUser()->getFirstLogin() == true) {
  124.                     $userUpdate = $user->getMail();
  125.                     $this->addFlash('password_expire', 'Bonjour ' .$userUpdate. ' votre mot de passe a expiré, prière le mettre à jour!');
  127.                     return $this->redirectToRoute('app_user_update_password', ['user_id' => $this->getUser()->getId()]);
  128.                 }
  129.             } else {
  130.                 return $this->render('master/home_new.html.twig',[
  131. //                    'documentCategories' => $documentCategories,
  132.                     'docForm' => $docForm->createView(),
  133.                 ]);
  134.             }
  136.             if ($this->getUser()->getFirstLogin() == true) {
  137.                 $userUpdate = $user->getMail();
  139.                 $this->addFlash('first_connexion', 'Bonjour ' .$userUpdate. ' Ceci est votre première connexion, prière de mettre à jour votre mot de passe!');
  140.                 return $this->redirectToRoute('app_user_update_password', ['user_id' => $this->getUser()->getId()]);
  141.             } else {
  142.                 return $this->render('master/home_new.html.twig',[
  143. //                    'documentCategories' => $documentCategories,
  144.                     'docForm' => $docForm->createView(),
  145.                 ]);
  146.             }
  147.         } else {
  148.             return $this->render('master/home_new.html.twig',[
  149. //                'documentCategories' => $documentCategories,
  150.                 'docForm' => $docForm->createView(),
  151.             ]);
  152.         }
  153.     }
  155.     public function configPanel()
  156.     {
  157.         return $this->render('master/configpanel.html.twig', []);
  158.     }
  160.     public function notFoundPage()
  161.     {
  162.         return $this->render('404/404.html.twig', []);
  163.     }
  165.     public function accessDeniedPage()
  166.     {
  167.         return $this->render('403/403.html.twig');
  168.     }
  170.     public function workspace()
  171.     {
  172.         $em = $this->managerRegistry;
  173.         $totalIdentite = 0;
  174.         $totalHomme = 0;
  175.         $totalFemme = 0;
  176.         $totalEnfant = 0;
  177.         $totalDemande = 0;
  178.         $totalDemandeValidee = 0;
  179.         $totalDemandeRejetee = 0;
  180.         $totalDocument = 0;
  181.         $totalEnAttentePaiement = 0;
  182.         $totalEnAttenteValidation = 0;
  183.         $totalEnAttenteSignature = 0;
  184.         $totalEnAttenteImpression = 0;
  186.         $site = $this->getUser()->getSite();
  187.         $userType = $this->getUser()->getUserType();
  188.         $currentUser = $this->getUser();
  189.         $siteId = "";
  191.         if ($site != null) {
  192.             $siteId = $site->getId();
  193.         }
  195.         $connectedUser = $this->managerRegistry->getRepository(Users::class)->findOneBy([
  196.             'id' => $this->getUser()->getId(),
  197.         ]);
  199.         if (!$connectedUser->getStatus()) {
  200.             return $this->redirect('/logout');
  201.         }
  203.         switch ($userType) {
  204.             //Administrateur du Site
  205.             case 6:
  206.             case 7:
  207.             case 8:
  208.             case 1:
  209.                 $stats = $this->cache->get('workspace_dashboard_stats_admin', function (ItemInterface $item) {
  210.                     $item->expiresAfter(300);
  212.                     $totalIdentite = $this->managerRegistry->getRepository(Identite::class)->createQueryBuilder('i')
  213.                         ->select('count(i.id)')
  214.                         ->getQuery()
  215.                         ->getSingleScalarResult();
  217.                     $sexeCounts = $this->managerRegistry->getRepository(Identite::class)->createQueryBuilder('i')
  218.                         ->select(
  219.                             'SUM(CASE WHEN i.sexe = :sexeMasculin THEN 1 ELSE 0 END) AS totalHomme',
  220.                             'SUM(CASE WHEN i.sexe = :sexeFeminin THEN 1 ELSE 0 END) AS totalFemme'
  221.                         )
  222.                         ->setParameter('sexeMasculin', 'Masculin')
  223.                         ->setParameter('sexeFeminin', 'Feminin')
  224.                         ->getQuery()
  225.                         ->getSingleResult();
  227.                     $totalHomme = (int) $sexeCounts['totalHomme'];
  228.                     $totalFemme = (int) $sexeCounts['totalFemme'];
  230.                     $totalEnfant = $this->managerRegistry->getRepository(Identite::class)->createQueryBuilder('i')
  231.                         ->select('count(i.id)')
  232.                         ->where('i.birthDate > :adultCutoff')
  233.                         ->setParameter('adultCutoff', (new \DateTime())->modify('-18 years'))
  234.                         ->getQuery()
  235.                         ->getSingleScalarResult();
  237.                     $totalDemande = $this->managerRegistry->getRepository(Folder::class)->createQueryBuilder('f')
  238.                         ->select('count(f.id)')
  239.                         ->getQuery()
  240.                         ->getSingleScalarResult();
  242.                     $folderStatusCounts = $this->managerRegistry->getRepository(Folder::class)->createQueryBuilder('f')
  243.                         ->select('f.status AS status, count(f.id) AS total')
  244.                         ->groupBy('f.status')
  245.                         ->getQuery()
  246.                         ->getResult();
  248.                     $countByStatus = [];
  249.                     foreach ($folderStatusCounts as $row) {
  250.                         $countByStatus[(int) $row['status']] = (int) $row['total'];
  251.                     }
  253.                     $totalDocument = $this->managerRegistry->getRepository(Document::class)->createQueryBuilder('d')
  254.                         ->select('count(d.folder)')
  255.                         ->getQuery()
  256.                         ->getSingleScalarResult();
  258.                     return [
  259.                         'totalIdentite' => $totalIdentite,
  260.                         'totalHomme' => $totalHomme,
  261.                         'totalFemme' => $totalFemme,
  262.                         'totalEnfant' => $totalEnfant,
  263.                         'totalDemande' => $totalDemande,
  264.                         'totalDemandeValidee' => $countByStatus[4] ?? 0,
  265.                         'totalDemandeRejetee' => $countByStatus[3] ?? 0,
  266.                         'totalEnAttentePaiement' => $countByStatus[1] ?? 0,
  267.                         'totalEnAttenteValidation' => $countByStatus[2] ?? 0,
  268.                         'totalEnAttenteSignature' => $countByStatus[4] ?? 0,
  269.                         'totalEnAttenteImpression' => $countByStatus[5] ?? 0,
  270.                         'totalDocument' => $totalDocument,
  271.                     ];
  272.                 });
  274.                 $totalIdentite = $stats['totalIdentite'];
  275.                 $totalHomme = $stats['totalHomme'];
  276.                 $totalFemme = $stats['totalFemme'];
  277.                 $totalEnfant = $stats['totalEnfant'];
  278.                 $totalDemande = $stats['totalDemande'];
  279.                 $totalDemandeValidee = $stats['totalDemandeValidee'];
  280.                 $totalDemandeRejetee = $stats['totalDemandeRejetee'];
  281.                 $totalEnAttentePaiement = $stats['totalEnAttentePaiement'];
  282.                 $totalEnAttenteValidation = $stats['totalEnAttenteValidation'];
  283.                 $totalEnAttenteSignature = $stats['totalEnAttenteSignature'];
  284.                 $totalEnAttenteImpression = $stats['totalEnAttenteImpression'];
  285.                 $totalDocument = $stats['totalDocument'];
  286.                 break;
  288.             //Autorité du Site
  289.             case 2:
  290.                 $totalIdentite = $this->managerRegistry->getRepository(Identite::class)->createQueryBuilder('i')
  291.                     ->select('count(i.id)')
  292.                     ->where('i.registrationSite=:p1')
  293.                     ->setParameter('p1', $siteId)
  294.                     ->getQuery()
  295.                     ->getSingleScalarResult();
  297.                 $totalHomme = $this->managerRegistry->getRepository(Identite::class)->createQueryBuilder('i')
  298.                     ->select('count(i.id)')
  299.                     ->where('i.registrationSite=:p1')
  300.                     ->setParameter('p1', $siteId)
  301.                     ->andWhere('i.sexe = :p2')
  302.                     ->setParameter('p2', 'Masculin')
  303.                     ->getQuery()
  304.                     ->getSingleScalarResult();
  306.                 $totalFemme = $this->managerRegistry->getRepository(Identite::class)->createQueryBuilder('i')
  307.                     ->select('count(i.id)')
  308.                     ->where('i.registrationSite=:p1')
  309.                     ->setParameter('p1', $siteId)
  310.                     ->andWhere('i.sexe = :p2')
  311.                     ->setParameter('p2', 'Feminin')
  312.                     ->getQuery()
  313.                     ->getSingleScalarResult();
  315.                 $totalEnfant = $this->managerRegistry->getRepository(Identite::class)->createQueryBuilder('i')
  316.                     ->select('count(i.id)')
  317.                     ->where('(YEAR(current_date()) - YEAR(i.birthDate)) < 18')
  318.                     ->andWhere('i.registrationSite=:p1')
  319.                     ->setParameter('p1', $siteId)
  320.                     ->getQuery()
  321.                     ->getSingleScalarResult();
  323.                 $totalDemande = $this->managerRegistry->getRepository(Folder::class)->createQueryBuilder('f')
  324.                     ->select('count(f.id)')
  325.                     ->where('f.site=:p1')
  326.                     ->setParameter('p1', $siteId)
  327.                     ->getQuery()
  328.                     ->getSingleScalarResult();
  330.                 $totalDemandeValidee = $this->managerRegistry->getRepository(Folder::class)->createQueryBuilder('f')
  331.                     ->select('count(f.id)')
  332.                     ->where('f.site=:p1')
  333.                     ->setParameter('p1', $siteId)
  334.                     ->andWhere('f.status=4')
  335.                     ->getQuery()
  336.                     ->getSingleScalarResult();
  338.                 $totalDemandeRejetee = $this->managerRegistry->getRepository(Folder::class)->createQueryBuilder('f')
  339.                     ->select('count(f.id)')
  340.                     ->where('f.site=:p1')
  341.                     ->setParameter('p1', $siteId)
  342.                     ->andWhere('f.status=3')
  343.                     ->getQuery()
  344.                     ->getSingleScalarResult();
  346.                 $totalEnAttentePaiement = $this->managerRegistry->getRepository(Folder::class)->createQueryBuilder('f')
  347.                     ->select('count(f.id)')
  348.                     ->where('f.site=:p1')
  349.                     ->setParameter('p1', $siteId)
  350.                     ->andWhere('f.status=1')
  351.                     ->getQuery()
  352.                     ->getSingleScalarResult();
  354.                 $totalEnAttenteValidation = $this->managerRegistry->getRepository(Folder::class)->createQueryBuilder('f')
  355.                     ->select('count(f.id)')
  356.                     ->where('f.site=:p1')
  357.                     ->setParameter('p1', $siteId)
  358.                     ->andWhere('f.status=2')
  359.                     ->getQuery()
  360.                     ->getSingleScalarResult();
  362.                 $totalEnAttenteSignature = $this->managerRegistry->getRepository(Folder::class)->createQueryBuilder('f')
  363.                     ->select('count(f.id)')
  364.                     ->where('f.site=:p1')
  365.                     ->setParameter('p1', $siteId)
  366.                     ->andWhere('f.status=4')
  367.                     ->getQuery()
  368.                     ->getSingleScalarResult();
  370.                 $totalEnAttenteImpression = $this->managerRegistry->getRepository(Folder::class)->createQueryBuilder('f')
  371.                     ->select('count(f.id)')
  372.                     ->where('f.site=:p1')
  373.                     ->setParameter('p1', $siteId)
  374.                     ->andWhere('f.status=5')
  375.                     ->getQuery()
  376.                     ->getSingleScalarResult();
  379.                 // $documentFolderSubquery = $this->managerRegistry->getRepository(Folder::class)->createQueryBuilder('f')
  380.                 //     ->select('f.id')
  381.                 //     ->where('f.site = :p1')
  382.                 //     ->setParameter('p1', $siteId)
  383.                 //     ->getDQL();
  385.                 // $documentQuery = $this->managerRegistry->getRepository(Document::class)->createQueryBuilder('d');
  386.                 // $totalDocument = $documentQuery->select('count(d.id)')
  387.                 // ->from('')
  388.                 //     ->where($documentQuery->expr()->in('d.folder', $documentFolderSubquery))
  389.                 //     ->getQuery()
  390.                 //     ->getSingleScalarResult();
  392.                 $query = $this->managerRegistry->getManager()->createQuery("SELECT count(d.id) FROM App\Entity\Document d
  393.                                                  WHERE d.folder in 
  394.                                                 (SELECT f.id FROM App\Entity\Folder f 
  395.                                                 WHERE f.site =" . $siteId . ")");
  396.                 break;
  398.             //OPS
  399.             case 3:
  400.                 $totalIdentite = $this->managerRegistry->getRepository(Identite::class)->createQueryBuilder('i')
  401.                     ->select('count(i.id)')
  402.                     ->where('i.registrationSite=:p1')
  403.                     ->setParameter('p1', $siteId)
  404.                     ->andwhere('i.userCreate=:p2')
  405.                     ->setParameter('p2', $currentUser)
  406.                     ->getQuery()
  407.                     ->getSingleScalarResult();
  409.                 $totalHomme = $this->managerRegistry->getRepository(Identite::class)->createQueryBuilder('i')
  410.                     ->select('count(i.id)')
  411.                     ->where('i.registrationSite=:p1')
  412.                     ->setParameter('p1', $siteId)
  413.                     ->andWhere('i.sexe = :p2')
  414.                     ->setParameter('p2', 'Masculin')
  415.                     ->andwhere('i.userCreate=:p3')
  416.                     ->setParameter('p3', $currentUser)
  417.                     ->getQuery()
  418.                     ->getSingleScalarResult();
  420.                 $totalFemme = $this->managerRegistry->getRepository(Identite::class)->createQueryBuilder('i')
  421.                     ->select('count(i.id)')
  422.                     ->where('i.registrationSite=:site')
  423.                     ->setParameter('site', $siteId)
  424.                     ->andWhere('i.sexe = :p1')
  425.                     ->setParameter('p1', 'Feminin')
  426.                     ->andwhere('i.userCreate=:p2')
  427.                     ->setParameter('p2', $currentUser)
  428.                     ->getQuery()
  429.                     ->getSingleScalarResult();
  431.                 $totalEnfant = $this->managerRegistry->getRepository(Identite::class)->createQueryBuilder('i')
  432.                     ->select('count(i.id)')
  433.                     ->where('(YEAR(current_date()) - YEAR(i.birthDate)) < 18')
  434.                     ->andWhere('i.registrationSite=:site')
  435.                     ->setParameter('site', $siteId)
  436.                     ->andwhere('i.userCreate=:user')
  437.                     ->setParameter('user', $currentUser)
  438.                     ->getQuery()
  439.                     ->getSingleScalarResult();
  441.                 $totalDemande = $this->managerRegistry->getRepository(Folder::class)->createQueryBuilder('f')
  442.                     ->select('count(f.id)')
  443.                     ->where('f.site=:p1')
  444.                     ->setParameter('p1', $siteId)
  445.                     ->andwhere('f.userCreate=:user')
  446.                     ->setParameter('user', $currentUser)
  447.                     ->getQuery()
  448.                     ->getSingleScalarResult();
  450.                 $totalDemandeValidee = $this->managerRegistry->getRepository(Folder::class)->createQueryBuilder('f')
  451.                     ->select('count(f.id)')
  452.                     ->where('f.site=:p1')
  453.                     ->setParameter('p1', $siteId)
  454.                     ->andwhere('f.userCreate=:user')
  455.                     ->setParameter('user', $currentUser)
  456.                     ->andwhere('f.status=4')
  457.                     ->getQuery()
  458.                     ->getSingleScalarResult();
  460.                 $totalDemandeRejetee = $this->managerRegistry->getRepository(Folder::class)->createQueryBuilder('f')
  461.                     ->select('count(f.id)')
  462.                     ->where('f.site=:p1')
  463.                     ->setParameter('p1', $siteId)
  464.                     ->andwhere('f.userCreate=:user')
  465.                     ->setParameter('user', $currentUser)
  466.                     ->andwhere('f.status=3')
  467.                     ->getQuery()
  468.                     ->getSingleScalarResult();
  470.                 $totalEnAttentePaiement = $this->managerRegistry->getRepository(Folder::class)->createQueryBuilder('f')
  471.                     ->select('count(f.id)')
  472.                     ->where('f.site=:p1')
  473.                     ->setParameter('p1', $siteId)
  474.                     ->andwhere('f.userCreate=:user')
  475.                     ->setParameter('user', $currentUser)
  476.                     ->andWhere('f.status=1')
  477.                     ->getQuery()
  478.                     ->getSingleScalarResult();
  480.                 $totalEnAttenteValidation = $this->managerRegistry->getRepository(Folder::class)->createQueryBuilder('f')
  481.                     ->select('count(f.id)')
  482.                     ->where('f.site=:p1')
  483.                     ->setParameter('p1', $siteId)
  484.                     ->andwhere('f.userCreate=:user')
  485.                     ->setParameter('user', $currentUser)
  486.                     ->andWhere('f.status=2')
  487.                     ->getQuery()
  488.                     ->getSingleScalarResult();
  490.                 $totalEnAttenteSignature = $this->managerRegistry->getRepository(Folder::class)->createQueryBuilder('f')
  491.                     ->select('count(f.id)')
  492.                     ->where('f.site=:p1')
  493.                     ->setParameter('p1', $siteId)
  494.                     ->andwhere('f.userCreate=:user')
  495.                     ->setParameter('user', $currentUser)
  496.                     ->andWhere('f.status=4')
  497.                     ->getQuery()
  498.                     ->getSingleScalarResult();
  500.                 $totalEnAttenteImpression = $this->managerRegistry->getRepository(Folder::class)->createQueryBuilder('f')
  501.                     ->select('count(f.id)')
  502.                     ->where('f.site=:p1')
  503.                     ->setParameter('p1', $siteId)
  504.                     ->andWhere('f.status=5')
  505.                     ->getQuery()
  506.                     ->getSingleScalarResult();
  509.                 // $documentFolderSubquery = $this->managerRegistry->getRepository(Folder::class)->createQueryBuilder('f')
  510.                 //     ->select('f.id')
  511.                 //     ->where('f.site = :p1')
  512.                 //     ->setParameter('p1', $siteId)
  513.                 //     ->getDQL();
  515.                 // $documentQuery = $this->managerRegistry->getRepository(Document::class)->createQueryBuilder('d');
  516.                 // $totalDocument = $documentQuery->select('count(d.id)')
  517.                 //     ->where($documentQuery->expr()->in('d.folder', $documentFolderSubquery))
  518.                 //     ->andwhere('d.userCreate=:user')
  519.                 //     ->setParameter('user', $currentUser)
  520.                 //     ->getQuery()
  521.                 //     ->getSingleScalarResult();
  522.                 $query = $this->managerRegistry->getManager()->createQuery("SELECT count(d.id) FROM App\Entity\Document d
  523.                                                  WHERE d.userCreate=" . $currentUser->getId() . " AND d.folder in 
  524.                                                 (SELECT f.id FROM App\Entity\Folder f 
  525.                                                 WHERE f.site =" . $siteId . ")");
  528.                 $totalDocument = $query->getSingleScalarResult();
  529.                 break;
  531.             // Internaute
  532.             case 4:
  533.                 $totalIdentite = $this->managerRegistry->getRepository(Identite::class)->createQueryBuilder('i')
  534.                     ->select('count(i.id)')
  535.                     ->where('i.registrationSite=:p1')
  536.                     ->setParameter('p1', $siteId)
  537.                     ->andwhere('i.userCreate=:p2')
  538.                     ->setParameter('p2', $currentUser)
  539.                     ->getQuery()
  540.                     ->getSingleScalarResult();
  542.                 $totalHomme = $this->managerRegistry->getRepository(Identite::class)->createQueryBuilder('i')
  543.                     ->select('count(i.id)')
  544.                     ->where('i.registrationSite=:p1')
  545.                     ->setParameter('p1', $siteId)
  546.                     ->andWhere('i.sexe = :p2')
  547.                     ->setParameter('p2', 'Masculin')
  548.                     ->andwhere('i.userCreate=:p3')
  549.                     ->setParameter('p3', $currentUser)
  550.                     ->getQuery()
  551.                     ->getSingleScalarResult();
  554.                 $totalFemme = $this->managerRegistry->getRepository(Identite::class)->createQueryBuilder('i')
  555.                     ->select('count(i.id)')
  556.                     ->where('i.registrationSite=:p1')
  557.                     ->setParameter('p1', $siteId)
  558.                     ->andWhere('i.sexe = :p2')
  559.                     ->setParameter('p2', 'Feminin')
  560.                     ->andwhere('i.userCreate=:p3')
  561.                     ->setParameter('p3', $currentUser)
  562.                     ->getQuery()
  563.                     ->getSingleScalarResult();
  565.                 $totalEnfant = $this->managerRegistry->getRepository(Identite::class)->createQueryBuilder('i')
  566.                     ->select('count(i.id)')
  567.                     ->where('(YEAR(current_date()) - YEAR(i.birthDate)) < 18')
  568.                     ->andWhere('i.registrationSite=:site')
  569.                     ->setParameter('site', $siteId)
  570.                     ->andwhere('i.userCreate=:user')
  571.                     ->setParameter('user', $currentUser)
  572.                     ->getQuery()
  573.                     ->getSingleScalarResult();
  575.                 $totalDemande = $this->managerRegistry->getRepository(Folder::class)->createQueryBuilder('f')
  576.                     ->select('count(f.id)')
  577.                     ->where('f.site=:p1')
  578.                     ->setParameter('p1', $siteId)
  579.                     ->andwhere('f.userCreate=:user')
  580.                     ->setParameter('user', $currentUser)
  581.                     ->getQuery()
  582.                     ->getSingleScalarResult();
  584.                 $totalDemandeValidee = $this->managerRegistry->getRepository(Folder::class)->createQueryBuilder('f')
  585.                     ->select('count(f.id)')
  586.                     ->where('f.site=:p1')
  587.                     ->setParameter('p1', $siteId)
  588.                     ->andwhere('f.userCreate=:user')
  589.                     ->setParameter('user', $currentUser)
  590.                     ->andWhere('f.status=4')
  591.                     ->getQuery()
  592.                     ->getSingleScalarResult();
  594.                 $totalDemandeRejetee = $this->managerRegistry->getRepository(Folder::class)->createQueryBuilder('f')
  595.                     ->select('count(f.id)')
  596.                     ->where('f.site=:p1')
  597.                     ->setParameter('p1', $siteId)
  598.                     ->andwhere('f.userCreate=:user')
  599.                     ->setParameter('user', $currentUser)
  600.                     ->andWhere('f.status=3')
  601.                     ->getQuery()
  602.                     ->getSingleScalarResult();
  604.                 $totalEnAttentePaiement = $this->managerRegistry->getRepository(Folder::class)->createQueryBuilder('f')
  605.                     ->select('count(f.id)')
  606.                     ->where('f.site=:p1')
  607.                     ->setParameter('p1', $siteId)
  608.                     ->andwhere('f.userCreate=:user')
  609.                     ->setParameter('user', $currentUser)
  610.                     ->andWhere('f.status=1')
  611.                     ->getQuery()
  612.                     ->getSingleScalarResult();
  614.                 $totalEnAttenteValidation = $this->managerRegistry->getRepository(Folder::class)->createQueryBuilder('f')
  615.                     ->select('count(f.id)')
  616.                     ->where('f.site=:p1')
  617.                     ->setParameter('p1', $siteId)
  618.                     ->andwhere('f.userCreate=:user')
  619.                     ->setParameter('user', $currentUser)
  620.                     ->andWhere('f.status=2')
  621.                     ->getQuery()
  622.                     ->getSingleScalarResult();
  624.                 $totalEnAttenteSignature = $this->managerRegistry->getRepository(Folder::class)->createQueryBuilder('f')
  625.                     ->select('count(f.id)')
  626.                     ->where('f.site=:p1')
  627.                     ->setParameter('p1', $siteId)
  628.                     ->andwhere('f.userCreate=:user')
  629.                     ->setParameter('user', $currentUser)
  630.                     ->andWhere('f.status=4')
  631.                     ->getQuery()
  632.                     ->getSingleScalarResult();
  634.                 $totalEnAttenteImpression = $this->managerRegistry->getRepository(Folder::class)->createQueryBuilder('f')
  635.                     ->select('count(f.id)')
  636.                     ->where('f.site=:p1')
  637.                     ->setParameter('p1', $siteId)
  638.                     ->andwhere('f.userCreate=:user')
  639.                     ->setParameter('user', $currentUser)
  640.                     ->andWhere('f.status=5')
  641.                     ->getQuery()
  642.                     ->getSingleScalarResult();
  645.                 $query = $this->managerRegistry->getManager()->createQuery("SELECT count(d.id) FROM App\Entity\Document d WHERE d.folder in  
  646.                                                 (SELECT f.id FROM App\Entity\Folder f WHERE f.site =" . $siteId . " 
  647.                                                  AND f.userCreate=" . $currentUser->getId() . ")");
  648.                 break;
  650.             //Validateur
  651.             case 5:
  652.                 $totalIdentite = $this->managerRegistry->getRepository(Identite::class)->createQueryBuilder('i')
  653.                     ->select('count(i.id)')
  654.                     ->where('i.registrationSite=:p1')
  655.                     ->setParameter('p1', $siteId)
  656.                     ->getQuery()
  657.                     ->getSingleScalarResult();
  659.                 $totalHomme = $this->managerRegistry->getRepository(Identite::class)->createQueryBuilder('i')
  660.                     ->select('count(i.id)')
  661.                     ->where('i.registrationSite=:p1')
  662.                     ->setParameter('p1', $siteId)
  663.                     ->andWhere('i.sexe = :p2')
  664.                     ->setParameter('p2', 'Masculin')
  665.                     ->getQuery()
  666.                     ->getSingleScalarResult();
  668.                 $totalFemme = $this->managerRegistry->getRepository(Identite::class)->createQueryBuilder('i')
  669.                     ->select('count(i.id)')
  670.                     ->where('i.registrationSite=:p1')
  671.                     ->setParameter('p1', $siteId)
  672.                     ->andWhere('i.sexe = :p2')
  673.                     ->setParameter('p2', 'Feminin')
  674.                     ->getQuery()
  675.                     ->getSingleScalarResult();
  677.                 $totalEnfant = $this->managerRegistry->getRepository(Identite::class)->createQueryBuilder('i')
  678.                     ->select('count(i.id)')
  679.                     ->where('(YEAR(current_date()) - YEAR(i.birthDate)) < 18')
  680.                     ->andWhere('i.registrationSite=:site')
  681.                     ->setParameter('site', $siteId)
  682.                     ->getQuery()
  683.                     ->getSingleScalarResult();
  685.                 $totalDemande = $this->managerRegistry->getRepository(Folder::class)->createQueryBuilder('f')
  686.                     ->select('count(f.id)')
  687.                     ->where('f.site=:site')
  688.                     ->setParameter('site', $siteId)
  689.                     ->getQuery()
  690.                     ->getSingleScalarResult();
  692.                 $totalDemandeValidee = $this->managerRegistry->getRepository(Folder::class)->createQueryBuilder('f')
  693.                     ->select('count(f.id)')
  694.                     ->where('f.site=:site')
  695.                     ->setParameter('site', $siteId)
  696.                     ->andWhere('f.status=4')
  697.                     ->getQuery()
  698.                     ->getSingleScalarResult();
  700.                 $totalDemandeRejetee = $this->managerRegistry->getRepository(Folder::class)->createQueryBuilder('f')
  701.                     ->select('count(f.id)')
  702.                     ->where('f.site=:site')
  703.                     ->setParameter('site', $siteId)
  704.                     ->andWhere('f.status=3')
  705.                     ->getQuery()
  706.                     ->getSingleScalarResult();
  708.                 $totalEnAttentePaiement = $this->managerRegistry->getRepository(Folder::class)->createQueryBuilder('f')
  709.                     ->select('count(f.id)')
  710.                     ->where('f.site=:p1')
  711.                     ->setParameter('p1', $siteId)
  712.                     ->andWhere('f.status=1')
  713.                     ->getQuery()
  714.                     ->getSingleScalarResult();
  716.                 $totalEnAttenteValidation = $this->managerRegistry->getRepository(Folder::class)->createQueryBuilder('f')
  717.                     ->select('count(f.id)')
  718.                     ->where('f.site=:p1')
  719.                     ->setParameter('p1', $siteId)
  720.                     ->andWhere('f.status=2')
  721.                     ->getQuery()
  722.                     ->getSingleScalarResult();
  724.                 $totalEnAttenteSignature = $this->managerRegistry->getRepository(Folder::class)->createQueryBuilder('f')
  725.                     ->select('count(f.id)')
  726.                     ->where('f.site=:p1')
  727.                     ->setParameter('p1', $siteId)
  728.                     ->andWhere('f.status=4')
  729.                     ->getQuery()
  730.                     ->getSingleScalarResult();
  732.                 $totalEnAttenteImpression = $this->managerRegistry->getRepository(Folder::class)->createQueryBuilder('f')
  733.                     ->select('count(f.id)')
  734.                     ->where('f.site=:p1')
  735.                     ->setParameter('p1', $siteId)
  736.                     ->andWhere('f.status=5')
  737.                     ->getQuery()
  738.                     ->getSingleScalarResult();
  741.                 $query = $this->managerRegistry->getManager()->createQuery("SELECT count(d.id) FROM App\Entity\Document d
  742.                                                  WHERE d.folder in 
  743.                                                 (SELECT f.id FROM App\Entity\Folder f 
  744.                                                 WHERE f.site =" . $siteId . ")");
  745.                 break;
  746.         }
  748.         $this->logger->info('>>>>>>>>>', ["-----------------------COUNT DOCUMENT-------------------------"]);
  749.         $this->logger->info('Nombre de document', [$totalDocument]);
  751.         return $this->render('master/workspace.html.twig', [
  752.             'totalIdentite' => $totalIdentite,
  753.             'totalHomme' => $totalHomme,
  754.             'totalFemme' => $totalFemme,
  755.             'totalEnfant' => $totalEnfant,
  756.             'totalDemande' => $totalDemande,
  757.             'totalDocument' => $totalDocument,
  758.             'totalDemandeValidee' => $totalDemandeValidee,
  759.             'totalDemandeRejetee' => $totalDemandeRejetee,
  760.             'totalEnAttentePaiement' => $totalEnAttentePaiement,
  761.             'totalEnAttenteValidation' => $totalEnAttenteValidation,
  762.             'totalEnAttenteSignature' => $totalEnAttenteSignature,
  763.             'totalEnAttenteImpression' => $totalEnAttenteImpression,
  764.         ]);
  765.     }
  767.     public function workspaceSurfer()
  768.     {
  769.         $em = $this->managerRegistry;
  770.         $drafRequest = 0;
  771.         $signedRequest = 0;
  772.         $rejectedRequest = 0;
  773.         $awaitingValidationRequest = 0;
  774.         $awaitingSignatureRequest = 0;
  777.         $drafRequest = $this->managerRegistry->getRepository(Folder::class)->createQueryBuilder('f')
  778.             ->select('count(f.id)')
  779.             ->where('f.userCreate =:p1')
  780.             ->setParameter('p1', $this->getUser())
  781.             ->andWhere('f.status = :p2')
  782.             ->setParameter('p2', 1)
  783.             ->getQuery()
  784.             ->getSingleScalarResult();
  786.         $awaitingValidationRequest = $this->managerRegistry->getRepository(Folder::class)->createQueryBuilder('f')
  787.             ->select('count(f.id)')
  788.             ->where('f.userCreate =:p1')
  789.             ->setParameter('p1', $this->getUser())
  790.             ->andWhere('f.status = :p2')
  791.             ->setParameter('p2', 2)
  792.             ->getQuery()
  793.             ->getSingleScalarResult();
  795.         $awaitingSignatureRequest = $this->managerRegistry->getRepository(Folder::class)->createQueryBuilder('f')
  796.             ->select('count(f.id)')
  797.             ->where('f.userCreate =:p1')
  798.             ->setParameter('p1', $this->getUser())
  799.             ->andWhere('f.status = :p2')
  800.             ->setParameter('p2', 4)
  801.             ->getQuery()
  802.             ->getSingleScalarResult();
  804.         $folders = $this->managerRegistry->getRepository(Folder::class)->findBy([
  805.             'userCreate' => $this->getUser(),
  806.             'isDeleted' => false,
  807.         ]);
  809.         return $this->render('master/workspace_surfer.html.twig', [
  810.             'drafRequest' => $drafRequest,
  811.             'awaitingSignatureRequest' => $awaitingSignatureRequest,
  812.             'awaitingValidationRequest' => $awaitingValidationRequest,
  813.             'rejectedRequest' => $rejectedRequest,
  814.             'signedRequest' => $signedRequest,
  815.             'folders' => $folders,
  816.         ]);
  817.     }
  819.     public function dashboardUser(Request $request)
  820.     {
  821.         if ($this->getUser()->getUserType() == 2) {
  822.             return $this->render('master/dashboard_agent.html.twig', [
  823.                 // 'depositSlips'=> $depositSlips,
  824.             ]);
  825.         } else {
  826.         }
  827.     }
  829.     public function initiateRequest(Request $request)
  830.     {
  831.         $connectedUser = $this->managerRegistry->getRepository(Users::class)->findOneBy([
  832.             'id' => $this->getUser()->getId(),
  833.         ]);
  835.         if (!$connectedUser->getStatus()) {
  836.             return $this->redirect('/logout');
  837.         }
  839.         if ($this->getUser()->getUserType() == 3) {
  840.             //Type user Agent
  843.             $form = $this->createForm(InitiateRequestType::class, array('site_id' => $connectedUser->getSite()->getId()));
  844.             $form->handleRequest($request);
  846.             if ($form->isSubmitted() && $form->isValid()) {
  847.                 $criters = $form->getData();
  849.                 if (!is_null($criters['documentId'])) {
  850.                     $documentId = $criters['documentId'];
  851.                     $site = $this->getUser()->getSite();
  852.                     $documentCategory = $this->managerRegistry->getRepository(DocumentCategory::class)->findOneBy([
  853.                         'id' => $documentId,
  854.                         'isDeleted' => false,
  855.                     ]);
  857.                     if (is_null($documentCategory)) {
  858.                         $this->addFlash(
  859.                             'document_category_not_config',
  860.                             "Document non trouvé, impossible de continuer"
  861.                         );
  862.                     }
  864.                     $documentNumber = $documentCategory->getNumber();
  866.                     if (is_null($documentNumber) || $documentNumber === '') {
  867.                         $this->addFlash(
  868.                             'document_category_not_config',
  869.                             "Désolé, le document sélectionné n'est pas encore activé"
  870.                         );
  871.                     }
  873.                     if (is_null($site)) {
  874.                         $this->addFlash(
  875.                             'document_category_not_config',
  876.                             "Site non trouvé, impossible de continuer"
  877.                         );
  878.                     }
  880.                     return $this->redirectToRoute('app_core_application_form', [
  881.                         'id' => $documentId,
  882.                         'site_id' => $site->getId()
  883.                     ]);
  884.                 }
  885.             }
  887.             return $this->render('master/initiate_request.html.twig', [
  888.                 // 'depositSlips'=> $depositSlips,
  889.                 'form' => $form->createView()
  890.             ]);
  891.         } else {
  892.             $form = $this->createForm(InitiateRequestSurferType::class);
  893.             $form->handleRequest($request);
  895.             if ($form->isSubmitted() && $form->isValid()) {
  896.                 $criters = $form->getData();
  898.                 if (!is_null($criters['documentId'])) {
  899.                     $documentId = $criters['documentId'];
  900.                     $site = $criters['site'];
  902.                     $documentCategory = $this->managerRegistry->getRepository(DocumentCategory::class)->findOneBy([
  903.                         'id' => $documentId,
  904.                         'isDeleted' => false,
  905.                     ]);
  907.                     if (is_null($documentCategory)) {
  908.                         $this->addFlash(
  909.                             'document_category_not_config',
  910.                             "Document non trouvé, impossible de continuer"
  911.                         );
  912.                     }
  914.                     if (is_null($site)) {
  915.                         $this->addFlash(
  916.                             'document_category_not_config',
  917.                             "Site non trouvé, impossible de continuer"
  918.                         );
  919.                     }
  921.                     $documentNumber = $documentCategory->getNumber();
  923.                     if (is_null($documentNumber) || $documentNumber === '') {
  924.                         $this->addFlash(
  925.                             'document_category_not_config',
  926.                             "Désolé, le document sélectionné n'est pas encore activé"
  927.                         );
  928.                     }
  930.                     return $this->redirectToRoute('app_core_application_form', [
  931.                         'id' => $documentId,
  932.                         'site_id' => $site->getId()
  933.                     ]);
  934.                 }
  935.             }
  937.             return $this->render('master/initiate_request_surfer.html.twig', [
  938.                 // 'depositSlips'=> $depositSlips,
  939.                 'form' => $form->createView()
  940.             ]);
  941.         }
  942.     }
  944. }