src/Repository/ShoppingMallRepository.php line 95

Open in your IDE?
  1. <?php
  3. namespace App\Repository;
  5. use App\Entity\PackageOrderItem;
  6. use App\Entity\PackageRecipe;
  7. use App\Entity\Shop;
  8. use App\Entity\ShopHasCategories;
  9. use App\Entity\Shoppingmall;
  10. use App\Entity\ShoppingmallCounts;
  11. use App\Entity\User;
  12. use App\Helpers\OutletTypesHelper;
  13. use App\Services\Package\PackageQueryBuilder;
  14. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  15. use Doctrine\Persistence\ManagerRegistry;
  16. use Symfony\Component\HttpFoundation\Session\Session;
  17. use Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorageInterface as TokenStorage;
  18. use function array_key_first;
  19. use function sprintf;
  20. use function Symfony\Component\String\u;
  22. class ShoppingMallRepository extends ServiceEntityRepository
  23. {
  25.     use BaseRepository;
  27.     /**
  28.      * @var User
  29.      */
  30.     protected $_user;
  32.     /**
  33.      * @var TokenStorage
  34.      */
  35.     protected $_tokenStorage;
  37.     /**
  38.      * @var PackageQueryBuilder
  39.      */
  40.     protected $_packageQueryBuilder;
  42.     public function __construct(ManagerRegistry $registry, $entityClass, TokenStorage $tokenStorage, PackageQueryBuilder $packageQueryBuilder)
  43.     {
  44.         $this->_tokenStorage = $tokenStorage;
  45.         $this->_packageQueryBuilder = $packageQueryBuilder;
  47.         parent::__construct($registry, $entityClass);
  48.     }
  50.     /**
  51.      * @param $id
  52.      * @return \App\Entity\Shoppingmall[]|\Doctrine\Common\Collections\Collection
  53.      */
  54.     public function getByCity($id)
  55.     {
  56.         $query = $this->_em->createQuery(
  57.             'SELECT DISTINCT s.shoppingMall
  58.                 FROM App\Entity\Shop s 
  59.              WHERE s.city = :city_id'
  60.         );
  61.         $query->setParameter('city_id', $id);
  63.         return $query->getResult();
  64.     }
  66.     public function totalShoppingMalls($historyFilter)
  67.     {
  68.         $qb = $this->createQueryBuilder('shopping_mall');
  69.         $qb->select("count(distinct(shopping_mall.id))");
  71. //        if (isset($historyFilter['type'])) {
  72. //            if ($historyFilter['type'] == HistoryStoresType::HISTORY_CLOSED) {
  73. //                // Vybere id storu, ktere byly vybrane v dany cas
  74. //                $historyFilter['dateFrom'] = null;
  75. //                $historyFilter['dateTo'] = null;
  76. //                $shopIds = $this->getIdsByHistoryFilter($historyFilter);
  77. //
  78. //                $qb->andWhere('shop._id IN (:shopIds)');
  79. //                $qb->setParameter(':shopIds', $shopIds);
  80. //
  81. //            } elseif ($historyFilter['type'] == HistoryStoresType::HISTORY_NEW) {
  82. //                $qb->andWhere('shop.isNew = true');
  83. //            }
  84. //        }
  87.         return (int)$qb->getQuery()->getSingleScalarResult();
  88.     }
  90.     /**
  91.      * @param array $params
  92.      * @param \Symfony\Component\HttpFoundation\Session\Session $session
  93.      * @return array
  94.      */
  95.     public function findByFilter(array $params = [], Session $session) {
  96.         $session->remove('activeCity');
  97.         $session->remove('activeCountry');
  98.         $session->remove('activeActive');
  100.         $start = $params['start'] ?? null;
  101.         $length = $params['length'] ?? null;
  102.         $orders = $params['orders'] ?? [];
  103.         $columns = $params['columns'] ?? [];
  104.         $otherConditions = $params['otherConditions'] ?? '';
  105.         $withPaginator = $params['paginator'] ?? false;
  106.         $historyFilter = $params['historyFilter'] ?? [];
  108.         // Create Main Query
  109.         //$query = $this->createQueryBuilder('shop');
  110.         $query = $this->createQueryBuilder('shopping_mall')
  111.             // However, add a "always true" condition to keep an uniform treatment in all cases
  112.             // Add condition
  113.             ->andwhere($otherConditions != '' ?  $otherConditions : "1=1");
  115.         // Create inner joins
  116.         $query->leftJoin('shopping_mall.city', 'city');
  117.         $query->leftJoin('shopping_mall.operator', 'operator');
  119.         foreach ($columns as $key => $column) {
  120.             $values = [];
  121.             $prohibitedCols = ['updatedAt', 'createdAt'];
  123.             if ($column['search']['value'] != '' && $column['search']['value'] != '[]' && in_array($column['name'], $prohibitedCols) == false) {
  124.                 $searchItem = $column['search']['value'];
  126.                 if($column['name'] == 'kinds'){
  127.                     continue;
  128.                 }
  130.                 $subquery = null;
  131.                 $searchQueryLikeOrEq = '';
  132.                 $searchValue = null;
  134.                 $searchQueryPatterns  = [
  135.                     'label' => 'shopping_mall.label',
  136.                     'brands' => 'shopping_mall.id IN ('. $subquery .')',
  137.                     'stores' => 'shopping_mall.id IN ('. $subquery .')',
  138.                     'kinds' => 'shopkinds.label',
  139.                     'city' => 'city.label',
  140.                     'country' => 'city.country',
  141.                     'zip' => 'shopping_mall.zip',
  142.                     'street' => 'shopping_mall.street',
  143.                     'shoppingmall' => 'shopping_mall.label',
  144.                     'extent_label' => 'shop.extentLabel',
  145.                     'shoppingarea' => 'shoppingarea.label',
  146.                     'categories' => 'category.label',
  147.                     'isActive' => 'shopping_mall.isActive',
  148.                     'isOutlet' => 'shopping_mall.isOutlet',
  149.                     'operator' => 'operator.name',
  150.                     'category_primary' => '(shophascategory.isPrimary = true AND category.label LIKE \'%'.$searchItem.'%\')',
  151.                 ];
  153.                 if(substr($searchItem,0,2) == '["' && $column['name'] == 'brands') {
  154.                     // json values
  155.                     $values = json_decode($column['search']['value'], true);
  157.                     $subquery = $this->_em->getRepository(Shop::class)->createQueryBuilder('s1');
  158.                     $subquery
  159.                         ->select('shoppingMall_s1.id')
  160.                         ->leftJoin('s1.brands', 'brands_s1')
  161.                         ->leftJoin('s1.shoppingMall', 'shoppingMall_s1')
  162.                         ->where('brands_s1.label IN (:values'.$key.') ');
  164.                     $subquery->setParameter('values'.$key, $values);
  165.                 } else if(substr($searchItem,0,2) == '["') {
  166.                     $values = json_decode($column['search']['value'], true);
  167.                     //$searchQueryLikeOrEq = ' IN (:values' . $key . ') ';
  168.                 } else if($column['name'] == 'stores'){
  169.                     $subquery = $this->_em->getRepository(Shop::class)->createQueryBuilder('s2');
  170.                     $subquery
  171.                         ->select('shoppingMall_s2.id')
  172.                         ->leftJoin('s2.shoppingMall', 'shoppingMall_s2');
  173.                     if(strpos($column['search']['value'], 'eq:') !== false) {
  174.                         $paramKey = uniqid('stores_');
  175.                         $subquery->where(
  176.                             $subquery
  177.                                 ->expr()
  178.                                 ->like('s2.name',
  179.                                     ':' . $paramKey
  180.                                 )
  181.                         );
  182.                         $subquery->setParameter($paramKey, '%' . str_replace('eq:', '', $searchItem) . '%');
  183.                     } else {
  184.                         $paramKey = uniqid('stores_');
  185.                         $subquery->where(
  186.                             $subquery
  187.                                 ->expr()
  188.                                 ->like('s2.name', ':' . $paramKey)
  189.                         );
  190.                         $subquery->setParameter($paramKey, $searchItem);
  191.                     }
  192.                 } else if(strpos($column['search']['value'], 'eql:') !== false){
  194.                     $searchValue = str_replace('eql:', '', $searchItem)."%";
  195.                     $paramKey = uniqid('eql_');
  196.                     $col1 = $searchQueryPatterns[$column['name']] ?? 'shopping_mall.' . $column['name'];
  197.                     $query->andWhere(
  198.                         $query->expr()->like($col1, ':' . $paramKey)
  199.                     );
  200.                     $query->setParameter($paramKey, $searchValue.'%');
  201.                 } else if(strpos($column['search']['value'], 'eq:') !== false){
  202.                     $searchValue = str_replace('eq:', '', $searchItem);
  203.                     $paramKey = uniqid('eq_');
  204.                     $col1 = $searchQueryPatterns[$column['name']] ?? 'shopping_mall.' . $column['name'];
  205.                     $query->andWhere(
  206.                         $query->expr()->eq($col1, ':' . $paramKey)
  207.                     );
  208.                     $query->setParameter($paramKey, $searchValue);
  209.                 } else {
  210.                     $paramKey = uniqid('standard_');
  211.                     $col1 = $searchQueryPatterns[$column['name']] ?? 'shopping_mall.' . $column['name'];
  212.                     $query->andWhere(
  213.                         $query->expr()->like($col1, ':' . $paramKey)
  214.                     );
  215.                     $query->setParameter($paramKey, '%'.$searchItem.'%');
  216.                 }
  218.                 if($column['name'] == 'city'){
  219.                     $session->set('activeCity', $searchItem);
  220.                 }
  221.                 if($column['name'] == 'operator'){
  222.                     $session->set('operator', $searchItem);
  223.                 }
  224.                 if($column['name'] == 'country'){
  225.                     $session->set('activeCountry', $searchItem);
  226.                 }
  227.                 if($column['name'] == 'isActive'){
  228.                     $session->set('activeActive', $searchItem);
  229.                 }
  231.                 if(isset($values) && !empty($values)) {
  233.                     if($column['name'] == "isOutlet") {
  234.                         $final = [];
  235.                         foreach($values as $value) {
  236.                             $final[] = OutletTypesHelper::getOutletIdByType($value);
  237.                         }
  238.                         $values = $final;
  239.                     }
  241.                     $paramKey = uniqid('values_');
  242.                     $col1 = $searchQueryPatterns[$column['name']] ?? 'shopping_mall.' . $column['name'];
  243.                     $query->andWhere(
  244.                         $query->expr()->in($col1, ':'.$paramKey)
  245.                     );
  246.                     $query->setParameter($paramKey, $values);
  248. //                    $query->andWhere(
  249. //                        $searchQueryPatterns[$column['name']] ?? 'shopping_mall.' . $column['name']
  250. //                    )->setParameter('values' . $key, $values);
  251.                 }
  252.             }
  253.             if($column['name'] == 'updatedAt'){
  254.                 $updatedAtDate = $column['search']['value'];
  255.             }
  256.             if($column['name'] == 'createdAt'){
  257.                 $createdAtDate = $column['search']['value'];
  258.             }
  259.         }
  261.         if (!is_null($updatedAtDate) && $updatedAtDate != '' && $updatedAtDate != '-') {
  263.             $explDate = explode('-', $updatedAtDate);
  264.             if(isset($explDate[0]) && $explDate[0] != ''){
  265.                 $dateFrom = \DateTime::createFromFormat('Y/m/d', $explDate[0]);
  266.                 $query->andWhere('shopping_mall.lastSyncTime >= (:updatedAtFrom)');
  267.                 $query->setParameter(':updatedAtFrom', $dateFrom);
  268.             }
  269.             if(isset($explDate[1]) && $explDate[1] != ''){
  270.                 $dateTo = \DateTime::createFromFormat('Y/m/d', $explDate[1]);
  271.                 $query->andWhere('shopping_mall.lastSyncTime <= (:updatedAtTo)');
  272.                 $query->setParameter(':updatedAtTo', $dateTo);
  273.             }
  274.         }
  277.         if (!is_null($createdAtDate) && $createdAtDate != '' && $createdAtDate != '-') {
  279.             $explDate = explode('-', $createdAtDate);
  280.             if(isset($explDate[0]) && $explDate[0] != ''){
  281.                 $dateFrom = \DateTime::createFromFormat('Y/m/d', $explDate[0]);
  282.                 $query->andWhere('shopping_mall.createdAt >= (:createdAtFrom)');
  283.                 $query->setParameter(':createdAtFrom', $dateFrom);
  284.             }
  285.             if(isset($explDate[1]) && $explDate[1] != ''){
  286.                 $dateTo = \DateTime::createFromFormat('Y/m/d', $explDate[1]);
  287.                 $query->andWhere('shopping_mall.createdAt <= (:createdAtTo)');
  288.                 $query->setParameter(':createdAtTo', $dateTo);
  289.             }
  290.         }
  292.         $countResult = $query->select('count(distinct(shopping_mall.id))')->getQuery()->getSingleScalarResult();
  294.         // Limit
  295.         if($length != "NaN")
  296.             $query->select('shopping_mall')->setFirstResult($start)->setMaxResults($length);
  298. //        $qbShops = $this->_em->getRepository(Shop::class)->createQueryBuilder('shop');
  299. //        // pocty brandu
  300. //        $qbShops->select('count(distinct(brands.id))')
  301. //            ->join('shop.shoppingMall', 'shoppingmall')
  302. //            ->leftJoin('shop.brands', 'brands')
  303. //            ->where('shoppingmall.id = shopping_mall.id')
  304. //            ->andWhere('shop.isActive = true')
  305. //            ->groupBy('shopping_mall.id');
  306. //
  307. //        // pocty stores
  308. //        $qbShops2 = $this->_em->getRepository(Shop::class)->createQueryBuilder('shop2');
  309. //        $qbShops2->select('count(distinct(shop2.id))')
  310. //            ->join('shop2.shoppingMall', 'shoppingmall2')
  311. //            ->where('shoppingmall2.id = shopping_mall.id')
  312. //            ->andWhere('shop2.isActive = true')
  313. //            ->groupBy('shopping_mall.id');
  315.         // pocty brandu a obchodu
  316.         $query->leftJoin(ShoppingmallCounts::class, 'smc', 'WITH', 'smc.shoppingmallId = shopping_mall.id');
  318.         $query->select('shopping_mall')
  319.             ->addSelect('smc.brandCount AS brandsCount')
  320.             ->addSelect('smc.shopCount AS storesCount')
  321.             ->addSelect('CAST(REPLACE(shopping_mall.specialOffer, \' \', \'\')) AS specialOfferSorting')
  322.             ->addSelect('CAST(REPLACE(shopping_mall.zip, \' \', \'\')) AS zipSorting')
  323.             ->addSelect('(CASE WHEN shopping_mall.specialOffer = \'\' THEN 1 ELSE 0 END) AS HIDDEN specialOfferSortingPre')
  324.         ;
  327.         // Ordering
  328.         $ordersPatterns = [
  329.             'type' => 'shoptype.label',
  330.             'brands' => 'brandsCount',
  331.             'stores' => 'storesCount',
  332.             'kinds' => 'shopkinds.label',
  333.             'city' => 'city.label',
  334.             'country' => 'city.country',
  335.             'zip' => 'zipSorting',
  336.             'shoppingmall' => 'shopping_mall.label',
  337.             'shoppingarea' => 'shoppingarea.label',
  338.             'categories' => 'category.label',
  339.             'category_primary' => 'category.label',
  340.             'extent_label' => 'shop.extentLabel',
  341.             'specialOffer' => 'specialOfferSorting'
  342.         ];
  343.         foreach ($orders as $key => $order) {
  344.             // $order['name'] is the name of the order column as sent by the JS
  345.             if($order['name'] != '') {
  346.                 if($order['name'] == 'specialOffer'){
  347.                     $query->orderBy('specialOfferSortingPre', 'ASC');
  348.                     $query->addOrderBy($ordersPatterns[$order['name']] ?? 'shopping_mall.' . $order['name'], $order['dir']);
  349.                 }else {
  350.                     $query->orderBy($ordersPatterns[$order['name']] ?? 'shopping_mall.' . $order['name'], $order['dir']);
  351.                 }
  352.             }
  353.         }
  354.         if(!isset($orders[0]['name'])){
  355.             $query->orderBy('shopping_mall.label', 'ASC');
  356.         }
  358.         $query->groupBy('shopping_mall.id');
  361. //        echo $query->getQuery()->getSQL();
  362. //        exit;
  364.         // Execute
  365.         //echo $query->getQuery()->getSQL();
  366.         $results = $query->getQuery()->getResult();
  367.         //if($withPaginator == false) {
  368.         //$countResult = count($countQuery->getQuery()->getResult());
  369. //        }else{
  370. //            $countResult = count($results);
  371. //        }
  373. //        if(isset($orders[0]['name']) && isset($orders[0]['name']) == 'specialOffer'){
  374. //            usort($results, function ($a, $b) {
  375. //                $numA = (int) str_replace(' ', '', $a[0]->getSpecialOffer());
  376. //                $numB = (int) str_replace(' ', '', $b[0]->getSpecialOffer());
  377. //                return $numA <=> $numB;
  378. //            });
  379. //        }
  381.         return array(
  382.             "results" => $results,
  383.             "countResult" => $countResult,
  384.         );
  385.     }
  387.     /**
  388.      * @param $selections
  389.      * @return array
  390.      * @throws \Doctrine\ORM\NonUniqueResultException
  391.      */
  392.     public function compareSelections(array $selections, Session $session, $sortByCount = true, $categoryFilter = null){
  393.         $result = [];
  394.         $resultCount = [];
  395.         $resultBrands = [];
  396.         $resultBrandsCount = [];
  397.         $repoShops = $this->_em->getRepository(Shop::class);
  398.         $repoCategory = $this->_em->getRepository(ShopHasCategories::class);
  399.         $firstSelectionCode = array_key_first($selections);
  401.         foreach($selections as $index => $selectionFilter){
  402.             // nactu mally dle vstupniho filtru, nasledne z nich vyberu obchody a vlozim pro rozdeleni
  403.             $resultSelectionFilter = ($this->findByFilter($selectionFilter, $session))['results'];
  405.             $mallsIds = [];
  406.             /** @var Shoppingmall $mall */
  407.             foreach($resultSelectionFilter as $mall) {
  408.                 $mallsIds[] = $mall[0]->getId();
  409.             }
  410.             $shops = $repoShops->findBy(['shoppingMall' => $mallsIds, 'isActive' => true]);
  411.             $shopHasCategories = $repoCategory->findBy(['shop' => $shops]);
  412.             $categories = [];
  413.             foreach ($shopHasCategories as $shopHasCategory) {
  414.                 if($shopHasCategory->getCategory() != null) {
  415.                     $categories[$shopHasCategory->getCategory()->getId()] = $shopHasCategory->getCategory()->getLabel();
  416.                 }
  417.             }
  418.             asort($categories);
  420.             foreach ($shops as $item) {
  422.                 // Category Filter
  423.                 if(isset($categoryFilter) && $categoryFilter != '') {
  424.                     $filteredCollectionCategories = $item->getShopHasCategories()->filter(function (ShopHasCategories $shopHasCategory) use ($categoryFilter) {
  425.                         return $shopHasCategory->getCategory() != null && $shopHasCategory->getCategory()->getId() == $categoryFilter;
  426.                     });
  427.                     // pokud po filtraci nic nezbyde - shop neobsahuje kategorii - preskocim obchod
  428.                     if (count($filteredCollectionCategories) == 0) {
  429.                         continue;
  430.                     }
  431.                 }
  434.                 // reseni shop in shop, vsechny obchody jsou v nazvu oddeleny pomlckou
  435.                 $nameExp = explode(' - ', $item->getName());
  436.                 $nameTrim = trim($nameExp[0]);
  438.                 if(!isset($resultCount[$nameTrim][$index]['count'])){
  439.                     $resultCount[$nameTrim][$index]['count'] = 0;
  440.                 }
  442.                 $result[$nameTrim][$index] = $item;
  443.                 $resultCount[$nameTrim][$index]['count']++;
  445.                 // pocitani brandů
  446.                 foreach ($item->getBrands() as $brand) {
  447.                     $brandLabel = $brand->getLabel();
  449.                     if(!isset($resultBrandsCount[$brandLabel][$index])){
  450.                         $resultBrandsCount[$brandLabel][$index]['count'] = 0;
  451.                     }
  453.                     $resultBrands[$brandLabel][$index] = $brand;
  454.                     $resultBrandsCount[$brandLabel][$index]['count']++;
  455.                 }
  457.             }
  458.         }
  460.         if($sortByCount) {
  461.             uasort($result, array(ShopRepository::class, "sortArrayByCountName"));
  462.             uasort($resultBrands, array(ShopRepository::class, "sortArrayByCountLabel"));
  463.         }else{
  464.             uasort($result, array(ShopRepository::class, "sortArrayByName"));
  465.             uasort($resultBrands, array(ShopRepository::class, "sortArrayByLabel"));
  466.         }
  468.         return [
  469.             'results' => $result,
  470.             'resultsCount' => $resultCount,
  471.             'resultsBrands' => $resultBrands,
  472.             'resultsBrandsCount' => $resultBrandsCount,
  473.             'firstSelectionCode' => $firstSelectionCode,
  474.             'categories' => $categories
  475.         ];
  476.     }
  480.     public function createQueryBuilder($alias, $indexBy = null)
  481.     {
  482.         $this->_packageQueryBuilder->resetTableAliases();
  483.         $qb = parent::createQueryBuilder($alias, $indexBy);
  484.         $this->_user = $this->_tokenStorage->getToken()->getUser();
  485.         if($this->_user instanceof User) {
  487.             $roles = $this->_user->getRoles();
  488.             if(in_array('ROLE_ADMIN', $roles)){
  489.                 return $qb;
  490.             }
  492.             $orXStat = $qb->expr()->orX();
  493.             $activePackages = $this->_user->getActivePackages();
  495.             $addOr = false;
  496.             if(count($activePackages) == 0) {
  497.                 $packageRecipeRepo = $this->_em->getRepository(PackageRecipe::class);
  498.                 $freePackage = $packageRecipeRepo->findOneBy(['defaultUserPackage' => true, 'active' => true])
  499.                     ?: $packageRecipeRepo->findOneBy(['class_name' => 'FreePackage']);
  500.                 if ($freePackage) {
  501.                     $exprFunc = $this->_packageQueryBuilder->createByPackage($freePackage, $qb, $alias, PackageQueryBuilder::BASE_ENTITY_MALL);
  502.                     if ($exprFunc != false) {
  503.                         $orXStat->add($exprFunc);
  504.                         $addOr = true;
  505.                     }
  506.                 }
  507.             }
  509.             /** @var PackageOrderItem $activePackage */
  510.             foreach ($activePackages as $activePackage) {
  511.                 // prida do query builderu potrebne podminky dle zaplacenych balicku
  512.                 $expr = $this->_packageQueryBuilder->createByPackage($activePackage->getPackageRecipe(), $qb, $alias, PackageQueryBuilder::BASE_ENTITY_MALL);
  513.                 if($expr != false) {
  514.                     $addOr = true;
  515.                     $orXStat->add($expr);
  516.                 }
  517.             }
  519.             if($addOr) {
  520.                 $qb->where($orXStat);
  521.             }
  522.         }
  524.         return $qb;
  525.     }
  527.     /**
  528.      * GAP analysis over an explicit list of mall IDs. One selection per mall.
  529.      * Builds the same shop/brand × selection matrix as compareSelections(), but
  530.      * skips the session/filter layer.
  531.      */
  532.     public function compareByMallIds(array $mallIds, bool $sortByCount = true, $categoryFilter = null): array
  533.     {
  534.         $mallIds = array_values(array_unique(array_filter(array_map('intval', $mallIds))));
  536.         $result = [];
  537.         $resultCount = [];
  538.         $resultBrands = [];
  539.         $resultBrandsCount = [];
  540.         $categories = [];
  542.         $repoShops = $this->_em->getRepository(Shop::class);
  543.         $repoCategory = $this->_em->getRepository(ShopHasCategories::class);
  545.         foreach ($mallIds as $mallId) {
  546.             $index = (string) $mallId;
  547.             $shops = $repoShops->findBy(['shoppingMall' => $mallId, 'isActive' => true]);
  549.             $shopHasCategories = $repoCategory->findBy(['shop' => $shops]);
  550.             foreach ($shopHasCategories as $shopHasCategory) {
  551.                 if ($shopHasCategory->getCategory() !== null) {
  552.                     $categories[$shopHasCategory->getCategory()->getId()] = $shopHasCategory->getCategory()->getLabel();
  553.                 }
  554.             }
  556.             foreach ($shops as $item) {
  557.                 if (isset($categoryFilter) && $categoryFilter !== '') {
  558.                     $matches = $item->getShopHasCategories()->filter(function (ShopHasCategories $shc) use ($categoryFilter) {
  559.                         return $shc->getCategory() !== null && $shc->getCategory()->getId() == $categoryFilter;
  560.                     });
  561.                     if (count($matches) === 0) {
  562.                         continue;
  563.                     }
  564.                 }
  566.                 $nameExp = explode(' - ', $item->getName());
  567.                 $nameTrim = trim($nameExp[0]);
  569.                 if (!isset($resultCount[$nameTrim][$index]['count'])) {
  570.                     $resultCount[$nameTrim][$index]['count'] = 0;
  571.                 }
  572.                 $result[$nameTrim][$index] = $item;
  573.                 $resultCount[$nameTrim][$index]['count']++;
  575.                 foreach ($item->getBrands() as $brand) {
  576.                     $brandLabel = $brand->getLabel();
  577.                     if (!isset($resultBrandsCount[$brandLabel][$index])) {
  578.                         $resultBrandsCount[$brandLabel][$index]['count'] = 0;
  579.                     }
  580.                     $resultBrands[$brandLabel][$index] = $brand;
  581.                     $resultBrandsCount[$brandLabel][$index]['count']++;
  582.                 }
  583.             }
  584.         }
  586.         asort($categories);
  588.         if ($sortByCount) {
  589.             uasort($result, [\App\Repository\ShopRepository::class, 'sortArrayByCountName']);
  590.             uasort($resultBrands, [\App\Repository\ShopRepository::class, 'sortArrayByCountLabel']);
  591.         } else {
  592.             uasort($result, [\App\Repository\ShopRepository::class, 'sortArrayByName']);
  593.             uasort($resultBrands, [\App\Repository\ShopRepository::class, 'sortArrayByLabel']);
  594.         }
  596.         return [
  597.             'results' => $result,
  598.             'resultsCount' => $resultCount,
  599.             'resultsBrands' => $resultBrands,
  600.             'resultsBrandsCount' => $resultBrandsCount,
  601.             'firstSelectionCode' => isset($mallIds[0]) ? (string) $mallIds[0] : null,
  602.             'categories' => $categories,
  603.         ];
  604.     }
  606. }