src/Controller/Admin/Filter/RecapHoraireFilter.php line 41

Open in your IDE?
  1. <?php
  3. namespace App\Controller\Admin\Filter;
  5. use App\Entity\Admin;
  6. use App\Entity\User;
  7. use App\Entity\Mission;
  8. use App\Entity\Service;
  9. use App\Entity\Laboratoire;
  10. use Doctrine\ORM\QueryBuilder;
  11. use Doctrine\ORM\Query\Expr\Join;
  12. use phpDocumentor\Reflection\Types\Integer;
  13. use Symfony\Component\Security\Core\Security;
  14. use App\Form\Type\Admin\DateCalendarFilterType;
  15. use EasyCorp\Bundle\EasyAdminBundle\Dto\FieldDto;
  16. use EasyCorp\Bundle\EasyAdminBundle\Dto\EntityDto;
  17. use Symfony\Component\HttpFoundation\Session\Session;
  18. use EasyCorp\Bundle\EasyAdminBundle\Dto\FilterDataDto;
  19. use EasyCorp\Bundle\EasyAdminBundle\Filter\FilterTrait;
  20. use Symfony\Component\Security\Core\User\UserInterface;
  21. use EasyCorp\Bundle\EasyAdminBundle\Contracts\Filter\FilterInterface;
  22. use EasyCorp\Bundle\EasyAdminBundle\Form\Filter\Type\BooleanFilterType;
  24. class RecapHoraireFilter implements FilterInterface
  25. {
  26.     use FilterTrait;
  28.     private $userId;
  30.     public function setUserId($userId)
  31.     {
  32.         $this->userId = $userId;
  33.         return $this;
  34.     }
  36.     public function getUserId()
  37.     {
  38.         return $this->userId;
  39.     }
  41.     public static function new(string $propertyName, $label = null, $userId): self
  42.     {
  43.         return (new self())
  44.             ->setUserId($userId)
  45.             ->setFilterFqcn(__CLASS__)
  46.             ->setProperty($propertyName)
  47.             ->setLabel($label)
  48.             ->setFormType(BooleanFilterType::class);
  49.     }
  51.     public function apply(QueryBuilder $queryBuilder, FilterDataDto $filterDataDto, ?FieldDto $fieldDto, EntityDto $entityDto): void
  52.     {
  53.         // dd(sprintf('%s. = :userId', $filterDataDto->getEntityAlias(), $filterDataDto->getProperty()));
  54.         if (true === $filterDataDto->getValue()) {
  55.             $queryBuilder
  56.                 ->innerJoin(Mission::class, 'mi', Join::WITH, $filterDataDto->getEntityAlias() . '.mission = mi')
  57.                 ->innerJoin(Service::class, 'se', Join::WITH, 'mi.service = se')
  58.                 ->innerJoin(Laboratoire::class, 'la', Join::WITH, 'se.laboratoire = la')
  59.                 ->innerJoin(Admin::class, 'a', Join::WITH, 'la.admin = a')
  60.                 ->andWhere('a.id = :userId')
  61.                 ->setParameter('userId', $this->getUserId());
  62.         } else {
  63.             $queryBuilder
  64.                 ->innerJoin(Mission::class, 'mi', Join::WITH, $filterDataDto->getEntityAlias() . '.mission = mi')
  65.                 ->innerJoin(Service::class, 'se', Join::WITH, 'mi.service = se')
  66.                 ->innerJoin(Laboratoire::class, 'la', Join::WITH, 'se.laboratoire = la')
  67.                 ->innerJoin(Admin::class, 'a', Join::WITH, 'la.admin = a')
  68.                 ->andWhere('a.id <> :userId')
  69.                 ->setParameter('userId', $this->getUserId());
  70.         }
  72.         // ...
  73.     }
  74. }