src/Service/CompanyEventInfosService.php line 34

Open in your IDE?
  1. <?php
  3. namespace App\Service;
  5. use App\Entity\AffiliatedEventApplication;
  6. use App\Entity\Company;
  7. use App\Entity\Event;
  8. use App\Entity\Specialist;
  9. use App\Entity\User;
  10. use App\Repository\EventRepository;
  11. use Doctrine\ORM\EntityManagerInterface;
  12. use Doctrine\ORM\NonUniqueResultException;
  13. use Doctrine\ORM\NoResultException;
  14. use Symfony\Component\Security\Core\Security;
  16. class CompanyEventInfosService
  17. {
  18.     /**
  19.      * @var Security
  20.      */
  21.     private $security;
  23.     /**
  24.      * @var EventRepository
  25.      */
  26.     private $eventRepository;
  29.     /**
  30.      * @var EntityManagerInterface
  31.      */
  32.     private $em;
  34.     public function __construct(Security $security, EntityManagerInterface $em)
  35.     {
  36.         $this->security = $security;
  37.         $this->em = $em;
  38.         $this->eventRepository = $this->em->getRepository(Event::class);
  39.         $this->affiliatedEventApplicationRepo = $this->em->getRepository(AffiliatedEventApplication::class);
  40.     }
  42.     /**
  43.      * Get the count for the current events for a specialist
  44.      * @return int
  45.      */
  46.     public function getCurrentEventsCount(): int
  47.     {
  48.         $result = 0;
  49.         $user = $this->security->getUser();
  50.         if ($user instanceof User && $this->security->isGranted(User::ROLE_COMPANY)){
  51.             try {
  52.                 $result = intval($this->eventRepository->getCompanyCurrentEventsQueryBuilder($user->getCompany())
  53.                     ->select('COUNT(event)')->getQuery()->getSingleScalarResult());
  54.             } catch (NoResultException|NonUniqueResultException $e) {
  55.                 $result = 0;
  56.             }
  57.         }
  58.         return $result;
  59.     }
  61.     /**
  62.      * Get the count for the postulated events for a specialist
  63.      * @return int
  64.      */
  65.     public function getAwaitSpecialist(): int
  66.     {
  67.         $result = 0;
  68.         $user = $this->security->getUser();
  69.         if ($user instanceof User && $this->security->isGranted(User::ROLE_COMPANY)){
  70.             try {
  71.                 $result = intval($this->eventRepository->getCompanyAwaitSpecialistEventsQueryBuilder($user->getCompany())
  72.                     ->select('COUNT(event)')->getQuery()->getSingleScalarResult());
  73.             } catch (NoResultException|NonUniqueResultException $e) {
  74.                 $result = 0;
  75.             }
  76.         }
  77.         return $result;
  78.     }
  80.     /**
  81.      * Get the count for the available events for a specialist
  82.      * @return int
  83.      */
  84.     public function getAvailableEventsCount(): int
  85.     {
  86.         $result = 0;
  87.         $user = $this->security->getUser();
  88.         if ($user instanceof User && $this->security->isGranted(User::ROLE_COMPANY)){
  89.             $company = $this->em->getRepository(Company::class)->find($user->getCompany()->getId());
  90.             try {
  91.                 $result = intval($this->eventRepository->getCompanySpecialistEventsQueryBuilder($company)
  92.                     ->select('COUNT(event)')->getQuery()->getSingleScalarResult());
  93.             } catch (NoResultException|NonUniqueResultException $e) {
  94.                 $result = 0;
  95.             }
  96.         }
  97.         return $result;
  98.     }
  100.      /**
  101.      * Get the count for the available affiliated event applications for a specialist
  102.      * @return int
  103.      */
  104.     public function getAffiliatedEventsApplicationCount(): int
  105.     {
  106.         $result = 0;
  107.         $user = $this->security->getUser();
  108.         if ($user instanceof User && $this->security->isGranted(User::ROLE_COMPANY)){
  109.             $company = $this->em->getRepository(Company::class)->find($user->getCompany()->getId());
  110.             try {
  111.                 $result = intval($this->affiliatedEventApplicationRepo->getAffiliatedEventsForCompanyQueryBuilder($company)
  112.                     ->select('COUNT(event)')->getQuery()->getSingleScalarResult());
  113.             } catch (NoResultException|NonUniqueResultException $e) {
  114.                 $result = 0;
  115.             }
  116.         }
  117.         return $result;
  118.     }
  119. }