src/Service/Entry/FreeWordSearchService.php line 38

Open in your IDE?
  1. <?php
  3. namespace App\Service\Entry;
  5. use App\Form\FreeWordType;
  6. use App\Repository\Entry\EntryRepository;
  7. use App\Utils\PaginationUtil;
  8. use App\Utils\QbShortcutTrait;
  9. use App\Utils\TargetChoiceUtil;
  10. use Doctrine\ORM\QueryBuilder;
  11. use Psr\Container\ContainerInterface;
  12. use Symfony\Component\Form\FormInterface;
  13. use Symfony\Component\HttpFoundation\Request;
  14. use Symfony\Component\Routing\Generator\UrlGeneratorInterface;
  16. class FreeWordSearchService
  17. {
  18.     use QbShortcutTrait;
  20.     private const MAX_RESULTS = 4;
  22.     private ContainerInterface $container;
  23.     private UrlGeneratorInterface $urlGenerator;
  24.     private EntryRepository $entryRepository;
  26.     public function __construct(
  27.         ContainerInterface $container,
  28.         UrlGeneratorInterface $urlGenerator,
  29.         EntryRepository $entryRepository
  30.     ) {
  31.         $this->container = $container;
  32.         $this->urlGenerator = $urlGenerator;
  33.         $this->entryRepository = $entryRepository;
  34.     }
  36.     public function getForm(): FormInterface
  37.     {
  38.         return $this->container->get('form.factory')->create(FreeWordType::class, null, [
  39.             "action" => $this->urlGenerator->generate('search_index'),
  40.             "method" => "GET",
  41.             "csrf_protection" => false
  42.         ]);
  43.     }
  45.     public function getQueryBuilder(int $category, string $alias = "a"): QueryBuilder
  46.     {
  47.         $qb = $this->entryRepository->getListQuery([]);
  48.         $qb
  49.             ->andWhere($qb->expr()->eq('e.category', ':category'))
  50.             ->setParameter('category', $category)
  51.             ;
  52.         $this->entryRepository->setDefaultOrder($qb);
  53.         $this->entryRepository->addPublishWhere($qb);
  54.         return $qb;
  55.     }
  57.     public function addWordSearch(QueryBuilder $qb, FormInterface $form): self
  58.     {
  59.         $this->qbsWord(
  60.             $qb,
  61.             [
  62.                 "word" => $form->get('word')->getData()
  63.             ],
  64.             "word",
  65.             [
  66.                 "e.title",
  67.                 "e.title_en",
  68.                 "e.title_cn",
  69.                 "e.title_tw",
  70.                 "e.summaryTitle",
  71.                 "e.summaryTitle_en",
  72.                 "e.summaryTitle_cn",
  73.                 "e.summaryTitle_tw",
  74.                 "e.summaryContent",
  75.                 "e.summaryContent_en",
  76.                 "e.summaryContent_cn",
  77.                 "e.summaryContent_tw",
  78.             ]
  79.         );
  80.         return $this;
  81.     }
  83.     public function search(Request $request, int $currentPage = 1): array
  84.     {
  85.         $form = $this->getForm();
  86.         $form->handleRequest($request);
  87.         return [
  88.             "form" => $form,
  89.             "modelPlan" => $this->getResult($form, TargetChoiceUtil::MODELPLAN, $currentPage),
  90.             "workSpace" => $this->getResult($form, TargetChoiceUtil::WORKSPACE, $currentPage),
  91.             "hotel" => $this->getResult($form, TargetChoiceUtil::HOTEL, $currentPage),
  92.             "activity" => $this->getResult($form, TargetChoiceUtil::ACTIVITY, $currentPage),
  93.             "mobility" => $this->getResult($form, TargetChoiceUtil::MOBILITY, $currentPage)
  94.         ];
  95.     }
  97.     public function getSingleResult(Request $request, int $category): array
  98.     {
  99.         $form = $this->getForm();
  100.         $form->handleRequest($request);
  101.         $page = $request->query->has('page')? $request->query->get('page'): 1;
  102.         return $this->getResult($form, $category, $page);
  103.     }
  105.     public function getResult(FormInterface $form, int $category, int $currentPage): array
  106.     {
  107.         $qb = $this->getQueryBuilder($category);
  108.         $this->addWordSearch($qb, $form);
  109.         if($category === TargetChoiceUtil::MODELPLAN) {
  110.             $qb->orderBy("RAND()");
  111.         } else {
  112.             $qb->orderBy("e.id", "desc");
  113.         }
  115.         $pagination = new PaginationUtil($qb, $currentPage, self::MAX_RESULTS);
  117.         return [
  118.             "iterator" => $pagination->getPaginator()->getIterator(),
  119.             "nextPage" => $pagination->getNextPage(),
  120.             "isLast" => $pagination->isLastPage(),
  121.             "itemCount" => $pagination->getPaginator()->count(),
  122.             "category" => $category
  123.         ];
  124.     }
  125. }