src/Service/AdminEventInfosService.php line 52

Open in your IDE?
  1. <?php
  3. namespace App\Service;
  5. use App\Entity\AffiliatedEventApplication;
  6. use App\Entity\Event;
  7. use App\Entity\MarketplaceReservation;
  8. use App\Entity\User;
  9. use App\Repository\EventRepository;
  10. use App\Repository\MarketplaceReservationRepository;
  11. use DateTime;
  12. use Doctrine\ORM\EntityManagerInterface;
  13. use Doctrine\ORM\NonUniqueResultException;
  14. use Doctrine\ORM\NoResultException;
  15. use Symfony\Component\DependencyInjection\ParameterBag\ParameterBagInterface;
  16. use Symfony\Component\Security\Core\Security;
  18. class AdminEventInfosService
  19. {
  20.     /**
  21.      * @var Security
  22.      */
  23.     private $security;
  25.     /**
  26.      * @var EventRepository
  27.      */
  28.     private $eventRepository;
  30.     /**
  31.      * @var MarketplaceReservationRepository
  32.      */
  33.     private $marketplaceReservationRepository;
  35.     /**
  36.      * @var ParameterBagInterface
  37.      */
  38.     private $parameterBagInterface;
  40.     /**
  41.      * @var EntityManagerInterface
  42.      */
  43.     private $em;
  45.     public function __construct(Security $security, EntityManagerInterface $em, ParameterBagInterface $parameterBagInterface)
  46.     {
  47.         $this->security = $security;
  48.         $this->em = $em;
  49.         $this->parameterBagInterface = $parameterBagInterface;
  50.         $this->eventRepository = $this->em->getRepository(Event::class);
  51.         $this->marketplaceReservationRepository = $this->em->getRepository(MarketplaceReservation::class);
  52.         $this->affiliatedEventApplicationRepo = $this->em->getRepository(AffiliatedEventApplication::class);
  53.     }
  55.     /**
  56.      * Get the count for the current events for admin
  57.      * @return int
  58.      */
  59.     public function getCurrentEventsCount(): int
  60.     {
  61.         $result = 0;
  62.         $user = $this->security->getUser();
  63.         if ($user instanceof User && $this->security->isGranted(User::ROLE_ADMIN)){
  64.             try {
  65.                 $result = intval($this->eventRepository->getAdminCurrentEventsQueryBuilder()
  66.                           ->select('COUNT(event)')->getQuery()->getSingleScalarResult());
  67.             } catch (NoResultException|NonUniqueResultException $e) {
  68.                 $result = 0;
  69.             }
  70.         }
  71.         return $result;
  72.     }
  74.     /**
  75.      * Get the count for events that will be cancelled in 96 hours
  76.      * @return int
  77.      */
  78.     public function getEventsWarningCount(): int
  79.     {
  80.         $result = 0;
  81.         $user = $this->security->getUser();
  82.         if ($user instanceof User && $this->security->isGranted(User::ROLE_ADMIN)){
  83.             $startLimit = (new DateTime())->modify('+'. $this->parameterBagInterface->get('alert_expert_event') .'hours')->setTime(0,0,1);
  84.             $endLimit = (new DateTime())->modify('+'. $this->parameterBagInterface->get('alert_expert_event') .'hours')->setTime(23,59,59);
  85.             try {
  86.                 $result = intval( $this->eventRepository->queryFindByDatesIntervalle(
  87.                     [
  88.                         'startLimit' => $startLimit,
  89.                         'endLimit' => $endLimit,
  90.                         'regCount' => true
  91.                     ])
  92.                     ->select('COUNT(DISTINCT e)')->getQuery()->getSingleScalarResult());
  93.             } catch (NoResultException|NonUniqueResultException $e) {
  94.                 $result = 0;
  95.             }
  96.         }
  97.         return $result;
  98.     }
  100.     /**
  101.      * Get the count for events that will be cancelled in 96 hours
  102.      * @return int
  103.      */
  104.     public function getEventsAlertCount(): int
  105.     {
  106.         $result = 0;
  107.         $user = $this->security->getUser();
  108.         if ($user instanceof User && $this->security->isGranted(User::ROLE_ADMIN)){
  109.             $startLimit = (new DateTime())->modify('+'. $this->parameterBagInterface->get('before_send_warning_event_mail')['limit_hours'] .'hours')->setTime(0,0,1);
  110.             $endLimit = (new DateTime())->modify('+'. $this->parameterBagInterface->get('before_send_warning_event_mail')['limit_hours'] .'hours')->setTime(23,59,59);
  111.             try {
  112.                 $result = intval( $this->eventRepository->queryFindByDatesIntervalle(
  113.                     [
  114.                         'startLimit' => $startLimit,
  115.                         'endLimit' => $endLimit,
  116.                         'regCount' => true
  117.                     ])
  118.                     ->select('COUNT(e)')->getQuery()->getSingleScalarResult());
  119.             } catch (NoResultException|NonUniqueResultException $e) {
  120.                 $result = 0;
  121.             }
  122.         }
  123.         return $result;
  124.     }
  126.     /**
  127.      * Get the count for pending marketplaceReservations
  128.      * @return int
  129.      */
  130.     public function getPendingMarketplaceReservations(): int
  131.     {
  132.         $result = 0;
  133.         $user = $this->security->getUser();
  134.         if ($user instanceof User && $this->security->isGranted(User::ROLE_ADMIN)){
  135.             try {
  136.                 $result = $result = intval($this->marketplaceReservationRepository->createQueryBuilder('marketplaceRes')
  137.                 ->andWhere('marketplaceRes.paymentStatus = :success')
  138.                 ->andWhere('marketplaceRes.status = :pending')
  139.                 ->setParameter('pending', MarketplaceReservation::STATUS_PENDING)
  140.                 ->setParameter('success', MarketplaceReservation::PAYMENT_STATUS_SUCCESS)
  141.                 ->select('COUNT(marketplaceRes)')->getQuery()->getSingleScalarResult());;
  142.             } catch (NoResultException|NonUniqueResultException $e) {
  143.                 $result = 0;
  144.             }
  145.         }
  146.         return $result;
  147.     }
  149.     /**
  150.      * Get the count for special marketplace requests
  151.      * @return int
  152.      */
  153.     public function getSpecialMarketplaceRequests(): int
  154.     {
  155.         $result = 0;
  156.         $user = $this->security->getUser();
  157.         if ($user instanceof User && $this->security->isGranted(User::ROLE_ADMIN)){
  158.             try {
  159.                 $result = $result = intval($this->marketplaceReservationRepository->createQueryBuilder('marketplaceRes')
  160.                 ->andWhere('marketplaceRes.paymentStatus = :free')
  161.                 ->andWhere('marketplaceRes.status = :pending')
  162.                 ->setParameter('pending', MarketplaceReservation::STATUS_PENDING)
  163.                 ->setParameter('free', MarketplaceReservation::PAYMENT_STATUS_FREE)
  164.                 ->select('COUNT(marketplaceRes)')->getQuery()->getSingleScalarResult());;
  165.             } catch (NoResultException|NonUniqueResultException $e) {
  166.                 $result = 0;
  167.             }
  168.         }
  169.         return $result;
  170.     }
  172.     /**
  173.      * Get the count for accepted marketplaceReservations
  174.      * @return int
  175.      */
  176.     public function getAcceptedMarketplaceReservations(): int
  177.     {
  178.         $result = 0;
  179.         $user = $this->security->getUser();
  180.         if ($user instanceof User && $this->security->isGranted(User::ROLE_ADMIN)){
  181.             try {
  182.                 $result = $result = intval($this->marketplaceReservationRepository->createQueryBuilder('marketplaceRes')
  183.                 ->andWhere('marketplaceRes.paymentStatus IN (:success, :refund)')
  184.                 ->andWhere('marketplaceRes.status IN (:accepted, :canceled)')
  185.                 ->setParameter('accepted', MarketplaceReservation::STATUS_ACCEPTED)
  186.                 ->setParameter('canceled', MarketplaceReservation::STATUS_CANCELED)
  187.                 ->setParameter('success', MarketplaceReservation::PAYMENT_STATUS_SUCCESS)
  188.                 ->setParameter('refund', MarketplaceReservation::PAYMENT_STATUS_REFUND)
  189.                 ->select('COUNT(marketplaceRes)')->getQuery()->getSingleScalarResult());;
  190.             } catch (NoResultException|NonUniqueResultException $e) {
  191.                 $result = 0;
  192.             }
  193.         }
  194.         return $result;
  195.     }
  197.     // /**
  198.     //  * Get the count for the available events for a specialist
  199.     //  * @return int
  200.     //  */
  201.     // public function getAvailableEventsCount(): int
  202.     // {
  203.     //     $result = 0;
  204.     //     $user = $this->security->getUser();
  205.     //     if ($user instanceof User && $this->security->isGranted(User::ROLE_COMPANY)){
  206.     //         $company = $this->em->getRepository(Company::class)->find($user->getCompany()->getId());
  207.     //         try {
  208.     //             $result = intval($this->eventRepository->getCompanySpecialistEventsQueryBuilder($company)
  209.     //                 ->select('COUNT(event)')->getQuery()->getSingleScalarResult());
  210.     //         } catch (NoResultException|NonUniqueResultException $e) {
  211.     //             $result = 0;
  212.     //         }
  213.     //     }
  214.     //     return $result;
  215.     // }
  217.     //  /**
  218.     //  * Get the count for the available affiliated event applications for a specialist
  219.     //  * @return int
  220.     //  */
  221.     // public function getAffiliatedEventsApplicationCount(): int
  222.     // {
  223.     //     $result = 0;
  224.     //     $user = $this->security->getUser();
  225.     //     if ($user instanceof User && $this->security->isGranted(User::ROLE_COMPANY)){
  226.     //         $company = $this->em->getRepository(Company::class)->find($user->getCompany()->getId());
  227.     //         try {
  228.     //             $result = intval($this->affiliatedEventApplicationRepo->getAffiliatedEventsForCompanyQueryBuilder($company)
  229.     //                 ->select('COUNT(event)')->getQuery()->getSingleScalarResult());
  230.     //         } catch (NoResultException|NonUniqueResultException $e) {
  231.     //             $result = 0;
  232.     //         }
  233.     //     }
  234.     //     return $result;
  235.     // }
  236. }