src/EventSubscriber/CalendarSubscriber.php line 43

  1. <?php
  3. namespace App\EventSubscriber;
  5. use CalendarBundle\CalendarEvents;
  6. use CalendarBundle\Entity\Event;
  7. use CalendarBundle\Event\CalendarEvent;
  8. use Symfony\Bundle\SecurityBundle\Security;
  9. use Symfony\Component\EventDispatcher\EventSubscriberInterface;
  10. //use Symfony\Component\Routing\Generator\UrlGeneratorInterface;
  11. use Nzo\UrlEncryptorBundle\Encryptor\Encryptor;
  15. use App\Repository\TheCaseActionsRepository;
  17. class CalendarSubscriber implements EventSubscriberInterface
  18. {
  20.     // private UrlGeneratorInterface $router;
  21.     private TheCaseActionsRepository $TheCaseActionsRepository;
  22.     private Encryptor $encryptor;
  23.     private Security $security;
  25.     public function __construct(
  26.         TheCaseActionsRepository $TheCaseActionsRepository,
  27.         /*  UrlGeneratorInterface $router,*/
  28.         Encryptor $encryptor,
  29.         Security $security
  30.     ) {
  31.         $this->TheCaseActionsRepository = $TheCaseActionsRepository;
  32.         // $this->router = $router;
  33.         $this->encryptor = $encryptor;
  34.         $this->security = $security;
  35.     }
  36.     public static function getSubscribedEvents(): array
  37.     {
  38.         return [
  39.             CalendarEvents::SET_DATA => 'onCalendarSetData',
  40.         ];
  41.     }
  43.     public function onCalendarSetData(CalendarEvent $calendar): void
  44.     {
  45.         $LawOffice = $this->security->getUser()->getLawOffice();
  46.         $start = $calendar->getStart();
  47.         $end = $calendar->getEnd();
  48.         $filters = $calendar->getFilters();
  49.         //dd($calendar);
  53.         //Get CaseAction by LawOffice Repository
  54.         $CaseActionsAt = $this->TheCaseActionsRepository->
  55.         createQueryBuilder('TheCaseActions')
  56.             ->where('TheCaseActions.ActionAt BETWEEN :StartAt and :EndAt')
  57.             ->innerJoin('TheCaseActions.theCase', 'theCase', 'WITH', 'TheCaseActions.theCase = theCase.id')
  58.             ->andWhere('theCase.LawOffice = :LawOffice')
  59.             ->andWhere('theCase.FileStatus not in (:FileStatus)')
  60.             ->andWhere('TheCaseActions.IsDeleted <> :IsDeleted')
  61.             ->Select('COUNT(TheCaseActions.id) NbreActions','TheCaseActions.ActionAt')
  62.             ->setParameter('StartAt', $start->format('Y-m-d H:i:s'))
  63.             ->setParameter('EndAt', $end->format('Y-m-d H:i:s'))
  64.             ->setParameter('LawOffice', $LawOffice)
  65.             ->setParameter('IsDeleted', true)
  66.             ->setParameter('FileStatus',['2000'])
  67.             ->groupBy('TheCaseActions.ActionAt')
  68.             ->orderBy('TheCaseActions.ActionAt', 'DESC');
  69.         $CaseActionsAt = $CaseActionsAt->getQuery()->getResult();
  70.         //dd($CaseActionsAt);
  72.         foreach ($CaseActionsAt as $CaseAction) {
  73.             //dd($CaseAction['NbreActions']);
  74.             //case $CaseAction['NbreActions'] case 1,2,3
  75.             $Title = $this->TitleCalendar($CaseAction['NbreActions']);
  77.             $CaseActionAtEvent = new Event(
  78.                 $Title,
  79.                 $CaseAction['ActionAt'],
  80.                 null // If the end date is null or not defined, an all day event is created.
  81.             );
  83.             /*
  84.              * Add custom options to events
  85.              *
  86.              * For more information see: https://fullcalendar.io/docs/event-object
  87.              * and: https://github.com/fullcalendar/fullcalendar/blob/master/src/core/options.ts
  88.              */
  90.             $CaseActionAtEvent->setOptions([
  91.                 'backgroundColor' => 'red',
  92.                 'borderColor' => 'red',
  93.             ]);
  94.             $CaseActionAtEvent->addOption('id', $this->encryptor->encrypt($CaseAction['ActionAt']->format('Y-m-d H:i:s')));
  96.             // finally, add the event to the CalendarEvent to fill the calendar
  97.             $calendar->addEvent($CaseActionAtEvent);
  98.         }
  99.         $CaseActionsNext = $this->TheCaseActionsRepository->
  100.         createQueryBuilder('TheCaseActions')
  101.             ->where('TheCaseActions.ActionNextAt >= :DateNow')
  102.             ->innerJoin('TheCaseActions.theCase', 'theCase', 'WITH', 'TheCaseActions.theCase = theCase.id')
  103.             ->andWhere('theCase.LawOffice = :LawOffice')
  104.             ->andWhere('TheCaseActions.IsDeleted <> :IsDeleted')
  105.             ->select('COUNT(TheCaseActions.id) NbreActions','TheCaseActions.ActionNextAt')
  106.             ->andWhere('TheCaseActions.ActionNextAt BETWEEN :StartAt and :EndAt')
  107.             ->setParameter('StartAt', $start->format('Y-m-d H:i:s'))
  108.             ->setParameter('EndAt', $end->format('Y-m-d H:i:s'))
  109.             ->setParameter('DateNow', new \DateTime('now'))
  110.             ->setParameter('LawOffice', $LawOffice)
  111.             ->setParameter('IsDeleted', true)
  112.             ->groupBy('TheCaseActions.ActionNextAt')
  113.             ->orderBy('TheCaseActions.ActionNextAt', 'DESC')
  114.             ->getQuery()
  115.             ->getResult();
  117.         foreach ($CaseActionsNext as $CaseAction) {
  118.             $Title = $this->TitleCalendar($CaseAction['NbreActions']);
  119.             $CaseActionNextAtEvent = new Event(
  120.                 $Title,
  121.                 $CaseAction['ActionNextAt'],
  122.                 null // If the end date is null or not defined, an all day event is created.
  123.             );
  124.             $CaseActionNextAtEvent->setOptions([
  125.                 'backgroundColor' => 'green',
  126.                 'borderColor' => 'green',
  127.             ]);
  128.             $CaseActionNextAtEvent->addOption('id', $this->encryptor->encrypt($CaseAction['ActionNextAt']->format('Y-m-d H:i:s')));
  130.             $calendar->addEvent($CaseActionNextAtEvent);
  131.         }
  132.     }
  134.     public function TitleCalendar($Number): string
  135.     {
  136.         $Title = $Number;
  137.         if ($Number == 1) {
  138.             $Title .= 'جلسة';
  139.         }
  140.         elseif ($Number == 2) {
  141.             $Title = 'جلستين';
  142.         }elseif ($Number <= 10) {
  143.             $Title .= ' جلسات';
  144.         }elseif ($Number >= 11) {
  145.             $Title .= ' جلسة';
  146.         }
  147.         return $Title;
  148.     }
  149. }