src/Service/Entry/ReportService.php line 41

Open in your IDE?
  1. <?php
  3. namespace App\Service\Entry;
  5. use App\Entity\Entry\Entry;
  6. use App\Repository\Entry\EntryRepository;
  7. use App\Repository\Entry\Report\PostRepository;
  8. use App\Utils\GetQueryUtilTrait;
  9. use App\Utils\PaginationUtil;
  10. use Doctrine\ORM\QueryBuilder;
  11. use Symfony\Component\HttpFoundation\Request;
  13. class ReportService
  14. {
  15.     use GetQueryUtilTrait;
  17.     public const RESUME_SESSION_NAME = "entry_report_index_resume";
  19.     private PostRepository $postRepository;
  20.     private EntryRepository $entryRepository;
  22.     public function __construct(
  23.         PostRepository $postRepository,
  24.         EntryRepository $entryRepository
  25.     ) {
  26.         $this->postRepository = $postRepository;
  27.         $this->entryRepository = $entryRepository;
  28.     }
  30.     public function getCriteriaFromRequest(Request $request): array {
  31.         $criteria = [];
  32.         if($entryCategory = $this->getSingleQuery($request, "category")) {
  33.             $criteria['category'] = $entryCategory;
  34.         }
  36.         if($page = $this->getSingleQuery($request, "page")) {
  37.             $criteria['page'] = $page;
  38.         } else {
  39.             $criteria['page'] = 1;
  40.         }
  41.         $request->getSession()->set(self::RESUME_SESSION_NAME, $criteria);
  43.         return $criteria;
  44.     }
  46.     public function getQueryBuilder(array $criteria): QueryBuilder
  47.     {
  48.         $qb = $this->postRepository->getListQuery([]);
  49.         $qb
  50.             ->leftJoin(Entry::class, "e", "with", "a.Entry = e.id")
  51.             ;
  52.         if(isset($criteria['id'])) {
  53.             $qb
  54.                 ->andWhere($qb->expr()->eq('a.id', ':id'))
  55.                 ->setParameter("id" , $criteria['id'])
  56.                 ;
  57.         }
  58.         if(isset($criteria['category'])) {
  59.             $qb
  60.                 ->andWhere($qb->expr()->eq('e.category', ":category"))
  61.                 ->setParameter("category", $criteria['category'])
  62.             ;
  63.         }
  65.         $this->entryRepository->joinOwner($qb);
  66.         $this->entryRepository->addPublishWhere($qb);
  68.         return $qb;
  69.     }
  71.     public function handleList(QueryBuilder $qb, array $criteria): PaginationUtil
  72.     {
  73.         if(!isset($criteria['page'])) {
  74.             $criteria['page'] = 1;
  75.         }
  76.         if(!isset($criteria['liimit'])) {
  77.             $criteria['limit'] = 12;
  78.         }
  79.         return new PaginationUtil($qb, $criteria['page'], $criteria['limit']);
  80.     }
  81. }