app/Plugin/CustomerGroup42/Repository/CategoryRepository.php line 28

Open in your IDE?
  1. <?php
  3. /*
  4.  * This file is part of CustomerGroup
  5.  *
  6.  * Copyright(c) Akira Kurozumi <info@a-zumi.net>
  7.  *
  8.  * https://a-zumi.net
  9.  *
  10.  * For the full copyright and license information, please view the LICENSE
  11.  * file that was distributed with this source code.
  12.  */
  14. namespace Plugin\CustomerGroup42\Repository;
  16. use Doctrine\ORM\QueryBuilder;
  17. use Doctrine\Persistence\ManagerRegistry as RegistryInterface;
  18. use Eccube\Common\EccubeConfig;
  19. use Eccube\Doctrine\Query\Queries;
  21. class CategoryRepository extends \Eccube\Repository\CategoryRepository
  22. {
  23.     /**
  24.      * @var Queries
  25.      */
  26.     private Queries $queries;
  28.     public function __construct(
  29.         RegistryInterface $registry,
  30.         EccubeConfig $eccubeConfig,
  31.         Queries $queries
  32.     ) {
  33.         parent::__construct($registry, $eccubeConfig);
  35.         $this->queries = $queries;
  36.     }
  38.     /**
  39.      * @param array $searchData
  40.      *
  41.      * @return QueryBuilder
  42.      */
  43.     public function getQueryBuilderBySearchData(array $searchData): QueryBuilder
  44.     {
  45.         $qb = $this->createQueryBuilder('c1')
  46.             ->select('c1, c2, c3, c4, c5')
  47.             ->leftJoin('c1.Children', 'c2')
  48.             ->leftJoin('c2.Children', 'c3')
  49.             ->leftJoin('c3.Children', 'c4')
  50.             ->leftJoin('c4.Children', 'c5')
  51.             ->orderBy('c1.sort_no', 'DESC')
  52.             ->addOrderBy('c2.sort_no', 'DESC')
  53.             ->addOrderBy('c3.sort_no', 'DESC')
  54.             ->addOrderBy('c4.sort_no', 'DESC')
  55.             ->addOrderBy('c5.sort_no', 'DESC');
  57.         if (isset($searchData['parent']) && $searchData['parent']) {
  58.             $qb->where('c1.Parent = :Parent')->setParameter('Parent', $searchData['parent']);
  59.         } else {
  60.             $qb->where('c1.Parent IS NULL');
  61.         }
  63.         return $this->queries->customize(QueryKey::CATEGORY_SEARCH, $qb, $searchData);
  64.     }
  65. }