src/WebBundle/Service/SphinxSearcherService.php line 1520

Open in your IDE?
  1. <?php
  3. namespace WebBundle\Service;
  5. use Doctrine\ORM\EntityManager;
  6. use Exception;
  7. use Symfony\Component\DependencyInjection\ContainerInterface;
  8. use Symfony\Component\Translation\Translator;
  9. use WebBundle\Entity\ListMaterial;
  10. use WebBundle\Entity\ListMeasure;
  11. use WebBundle\Helper\App;
  12. use WebBundle\Helper\CurrencyRateHelper;
  13. use WebBundle\Helper\HideFactoryCountriesHelper;
  14. use WebBundle\Helper\LocaleHelper;
  15. use WebBundle\Helper\StrHelper;
  16. use WebBundle\Repository\FilterRepository;
  17. use WebBundle\Repository\ListMaterialRepository;
  18. use WebBundle\Repository\ListMeasureRepository;
  20. class SphinxSearcherService
  21. {
  22.     private array $materials = [];
  24.     /** @required */
  25.     public ListMeasureRepository $listMeasureRepository;
  26.     /** @required */
  27.     public ListMaterialRepository $listMaterialRepository;
  29.     /** @var EntityManager */
  30.     private $em;
  32.     /** @var sphinxQLService $sphinxQL */
  33.     private $sphinxQL;
  35.     /** @var Translator $translator */
  36.     private $translator;
  38.     protected array $articlesId = [];
  40.     protected array $subFilters = [];
  41.     private FilterRepository $filterRepo;
  43.     /**
  44.      * @param ContainerInterface $container
  45.      * @param FilterRepository $filterRepository
  46.      * @throws Exception
  47.      */
  48.     public function __construct(ContainerInterface $container, FilterRepository $filterRepository)
  49.     {
  50.         $this->filterRepo = $filterRepository;
  51.         $this->em = $container->get('doctrine');
  52.         $this->sphinxQL = $container->get('sphinx_ql');
  53.         $this->translator = $container->get('translator');
  54.     }
  56.     /**
  57.      * @param ?array $data - данные для выборки
  58.      * @param ?int $limit - если 0 то вывести все
  59.      * @param ?bool $withSchema - если true, то в поиске подбирать артикулы со схематичным изображением
  60.      * @param ?bool $full
  61.      * @param ?bool $getCount
  62.      * @return array
  63.      * @throws Exception
  64.      */
  65.     public function searchSphinx(
  66.         ?array $data = [],
  67.         ?int $limit = 0,
  68.         ?bool $withSchema = false,
  69.         ?bool $full = false,
  70.         ?bool $getCount = false
  71.     ): array {
  72.         $this->sphinxQL->clear();
  73.         ini_set('memory_limit', '2048M');
  75.         $dataReview = [];
  77.         $fields = [
  78.             'c_id',
  79.             'coll',
  80.             'border_grey',
  81.             'a_id',
  82.             'type_filter',
  83.             'c_name',
  84.             'c_status',
  85.             'c_header',
  86.             'c_release_year',
  87.             'c_url',
  88.             'c_awards',
  89.             'c_exhibition',
  90.             'c_accessible',
  91.             'f_name',
  92.             'f_id',
  93.             'f_url',
  94.             'rating_month',
  95.             'publish_date',
  96.             'country',
  97.             'country_code',
  98.             'author',
  99.             'a_name',
  100. // Чистим от не нужных полей
  101.             'size_x',
  102.             'size_y',
  103.             'tolsch',
  104.             //для вывода возможных толщин
  105.             'sliding',
  106.             'a_style',
  107.             'measure',
  108.             'type',
  109.             'file',
  110.             'fs_x',
  111.             'fs_y',
  112.             'is_main',
  113.             'c_express_sample',
  114.             'price_sort',
  115.             //'square',
  116.             'c_material',
  117.             'process',
  118.             'express_sample',
  119.             'factory',
  120.             'u_id',
  121.             'thin_granite',
  122.             'attr_data',
  123.             //.i as interior || .i as i не получаем лишние данные если не будет facet еще быстрее получаем только a_id и дальше к бд (тест скорости провести)
  124.             'size_big',
  125.             'glazed_granite',
  126.             'thick_granite',
  127.             'publish_period',
  128.             'dyed_in_mass',
  129.             'color_body',
  130.             'c_designer_ids',
  131.             'monochrome',
  132.             'prc_count',
  133.             'prc_vote',
  134.             'reviews',
  135.             'a_texture',
  136.             'a_motive',
  137.             'surface',
  138.             'shape',
  139.             'color',
  140.             'material',
  141.             'a_stone_texture',
  142.             'a_motiv',
  143.             'typecoll',
  144.             'a_head',
  145.             'sid',
  146.             'styleid',
  147.             'styleida',
  148.             'sort',
  149.             'is_head',
  150.             'apply_id',
  151.             'c_apply',
  152.             'using',
  153.             'pr_status',
  154.             'edge_type',
  155.             'off_shade',
  156.         ];
  158.         if (isset($data['searchFilter']['getTopMonth'])) {
  159.             $fields[] = 'c_pop30';
  160.             $fields[] = 'c_last_pop30';
  161.         } elseif (isset($data['searchFilter']['getTopWeek'])) {
  162.             $fields[] = 'c_pop7';
  163.             $fields[] = 'c_last_pop7';
  164.         }
  165.         $buildingMixtureOff = false;
  167.         // тут костыль для скольжения https://te.remote.team/#/discus/7AF53097-7533-5034-0808-93CF8BDB1E75/
  168.         // Не бывает матовой поверхности с коэффициентом противоскольжения (если и бывает, то это просто ошибка в свойствах артикула)
  169.         // todo излишнее так как sliding= '999.a.sliding
  170.         if (
  171.             !empty($data['searchFilter']['getSurfaces'])
  172.             && !empty($data['searchFilter']['sliding'])
  173.             && count($data['searchFilter']['sliding']) == 4
  174.         ) {
  175.             $data['searchFilter']['getSurfaces'][] = 8;
  176.             unset($data['searchFilter']['sliding']);
  177.         }
  178.         // фильтр по антислипу sliding на самом деле getSurfaces
  179.         // todo лишнее
  180.         if (!empty($data['searchFilter']['sliding'])) {
  181.             foreach ($data['searchFilter']['sliding'] as $row) {
  182.                 $data['searchFilter']['getSurfaces'][] = (int)('999' . $row);
  183.             }
  184.             unset($data['searchFilter']['sliding']);
  185.         }
  187.         // На основании вот этой просьбы https://te.remote.team/#/discus/4B853CC1-9B65-BD60-F896-352327BC5F2C/
  188.         if (!empty($data['searchFilter']['factory']) && count($data['searchFilter']) == 1) {
  189.             $withSchema = true;
  190.         }
  192.         if (!App::isRole('ROLE_TEST')) {
  193.             $this->sphinxQL->addWhere('c_test_access != 1');
  194.             $this->sphinxQL->addWhere('f_test_access != 1');
  195.         }
  197.         if (!empty($data['HideFactory'])) {
  198.             $this->sphinxQL->addWhere('f_id NOT IN (?)', $data['HideFactory']);
  199.         } elseif (HideFactoryCountriesHelper::length() > 0) {
  200.             $this->sphinxQL->addWhere('f_id NOT IN (?)', HideFactoryCountriesHelper::codes());
  201.         }
  202.         $country = App::getCurCountry();
  203.         $measure = !empty($data['measure']) ? $data['measure'] : LocaleHelper::getUserMeasure();
  204.         $priceFields = $this->getPriceFields(LocaleHelper::getCur(), $country, $measure);
  206.         // для автоматической простановки фильтров
  207.         $dataArticles = [
  208.             'getPrstatus' => 'pr_status', // код акции
  209.             'getTypes' => 'type', // код вида изделия
  210.             'getTypeUsings' => 'using', // код назначения
  211.             'getCountry' => 'country', // код страны
  212.             'getPrcateg' => 'pr_status', // код акции
  213.             'getMaterials' => 'material', // код материала
  214.             'getCostCategory' => $priceFields[3],//'a_price_cat', // код категории цены
  215.             'getEdgeType' => 'edge_type', // тип края
  216.             'offShade' => 'off_shade', // разнотон (моноколор)
  217.             'getStyles' => 'sid', // код стиля
  218.             'getSurfaces' => 'surface', // код типа
  219.             'getFacturas' => 'a_texture', // код фактуры
  220.             'getStone' => 'a_stone_texture', // код фактуры камня
  221.             'getColors' => 'color', // код цветов
  222.             'shape' => 'shape', // код формы
  223.             'motive' => 'a_motive', // мотив рисунка
  224.             'motiv' => 'a_motiv', // мотив рисунка
  225.             'pei' => 'pei',
  226.         ];
  227. //        $fromCountArr = [
  228. //            //Filter => sphinx_filds
  229. //            'getStyles' => 'sid', // код стиля
  230. //            'getSurfaces' => 'surface', // код типа
  231. //            'getFacturas' => 'a_texture', // код фактуры
  232. //            'getStone' => 'a_stone_texture', // код фактуры камня
  233. //            'getColors' => 'color', // код цветов
  234. //            'shape' => 'shape', // код формы
  235. //            'motive' => 'a_motive', // мотив рисунка
  236. //            'motiv' => 'a_motiv', // мотив рисунка
  237. //            'inside' => $priceFields[0],
  238. //            'discontinued' => 'typecoll',
  239. //            'expressSample' => 'express_sample',
  240. //            'getAwards' => 'c_awards',
  241. //            'exhibition' => 'c_exhibition',
  242. //            'size_x' => 'size_x',
  243. //            'size_y' => 'size_y',
  244. //            'tolsch' => 'thick',
  245. //            'thick' => 'thick',
  246. //            'material' => 'material',
  247. //            'getTypeUsings' => 'using',
  248. //            'factory' => 'factory',
  249. //            'bm' => 'u_id',
  250. //            'c_id' => 'c_id',
  251. //            'getThinGranite' => 'thin_granite',
  252. //            'size_big' => 'size_big',
  253. //            'getGlazedGranit' => 'glazed_granite',
  254. //            'getThickGranite' => 'thick_granite',
  255. //            'searchPeriod' => 'publish_period',
  256. //            'releaseYear' => 'c_release_year',
  257. //            'reviews' => 'reviews',
  258. //            'dyedInMass' => 'dyed_in_mass',
  259. //            'colorBody' => 'color_body',
  260. //            'sliding' => 'sliding',
  261. //            'getUsings' => 'apply_id',
  262. //            'getDesigner' => 'c_designer_ids',
  263. //            'monochrome' => 'monochrome',
  264. //        ];
  266.         //Добавим поля интерьера первые найденный тогда сфинкс вернет сразу пустую строку и не нужно будет делать проверку и цикл
  267.         $interiorFilds = [
  268.             'attr_data.i[0].i_name as i_name',
  269.             'attr_data.i[0].i_id as i_id',
  270.             'attr_data.i[0].i_rating as i_rating',
  271.             'attr_data.i[0].i_monochrome as i_monochrome',
  272.             'attr_data.i[0].i_status as i_status',
  273.             'attr_data.i[0].i_file as i_file',
  274.             'attr_data.i[0].i_wall_and_floor as i_wall_and_floor',
  275.             'attr_data.i[0].i_style as i_style',
  276.             'attr_data.i[0].i_texture as i_texture',
  277.             'attr_data.i[0].fsi_x as fsi_x',
  278.             'attr_data.i[0].fsi_y as fsi_y',
  279.         ];
  280.         //поля которые перенесены в attr_data что позволило сократить таблицу до артикулов проверить
  282.         $mvaFields = [
  283.             'color',
  284.             'material',
  285.             'a_motive',
  286.             'a_texture',
  287.             'designer',
  288.             'edge_type',
  289.             'a_motiv',
  290.             'shape',
  291.             'a_stone_texture',
  292.             'style',
  293.             'surface',
  294.             'texture',
  295.             'a_head',
  296.             'sid',
  297.             'styleida',
  298.             'styleid',
  299.             'sort',
  300.             'i_style',
  301.             'c_apply',
  302.             'apply_id',
  303.             'typecoll',
  304.             'i_rating',
  305.             'i_id',
  306.             'is_head',
  307.             'fsi_x',
  308.             'fsi_y',
  309.             'i_name_hash',
  310.             'i_file_hash',
  311.             'i_type',
  312.             'i_status',
  313.             'i_texture',
  314.             'i_monochrome',
  315.             'i_wall_and_floor',
  316.             'using',
  317.             'type',
  318.         ];
  321.         //вычитаем поля если они attr_data добавляются через $dataAttrFields
  322.         // $plusFields = array_diff($plusFields, $attrData);
  323.         $fields = array_unique(array_merge($interiorFilds, $fields, $priceFields));
  324. //        App::debugExit($fields);
  325.         if (empty($data['total_found'])) {
  326.             $this->sphinxQL->setFrom('article', $fields);
  327.         } else {
  328.             $this->sphinxQL->setFrom('article', 'coll'); //todo тут должна появиться новая таблица
  329.         }
  330.         if (!empty($data['searchFilter']['inside'])) {
  331.             $this->sphinxQL->addWhere($priceFields[0] . ' > 0.0');
  332.             $this->sphinxQL->addWhere('delivery <> 6');
  333.         } elseif (!empty($data['searchFilter']['discontinued'])) {
  334.             $this->sphinxQL->addWhere('ANY(typeColl) in (2) ');
  335.         } else {
  336.             $this->sphinxQL->addWhere('ANY(typeColl) in (1)');
  338.             if (!(!empty($data['searchFilter']['factory']) && count($data['searchFilter']) == 1)) {
  339.                 $this->sphinxQL->addWhere($priceFields[0] . ' > 0.0');
  340.                 $this->sphinxQL->addWhere('c_status = 1');
  341.             } else {
  342.                 $this->sphinxQL->addWhere('c_status IN (1, 3)');
  343.             }
  344.         }
  346.         // принято решение, если выбран стиль, то отбираем сразу по фонам декорам панно
  347.         // https://te.remote.team/#/discus/85E0842C-BCDE-D6E6-7EA4-2DB50BB404EC/
  348.         if (
  349.             !empty($data['searchFilter']['getStyles']) &&
  350.             empty($data['searchFilter']['getTypes']) &&
  351.             empty($data['searchFilter']['inside'])
  352.         ) {
  353.             $data['searchFilter']['getTypes'] = [1, 113, 106, 24, 122, 128]; //todo нужно перенести в индекс
  354.         }
  355.         //TODO Удалить раз схемы навсегда улетают
  356.         //        if (
  357.         //            !$withSchema && (
  358.         //                empty($data['searchFilter']['getTypes']) ||
  359.         //                array_intersect($data['searchFilter']['getTypes'], [1, 24, 113, 122])
  360.         //            ) &&
  361.         //            empty($data['searchFilter']['size_x']) &&
  362.         //            empty($data['searchFilter']['size_y']) &&
  363.         //            empty($data['searchFilter']['size_z']) &&
  364.         //            empty($data['searchFilter']['motiv'])
  365.         //        ) {
  366.         //            $this->sphinxQL->addWhere('scheme = ?', 0);
  367.         //        }
  368.         $this->sphinxQL->addWhere('scheme = ?', 0);
  369.         // ставим фильтры
  370.         if (!empty($data['searchFilter'])) {
  371.             if (!empty($data['searchFilter']['expressSample'])) {
  372.                 if (
  373.                     !empty($data['searchFilter']['inside']) ||
  374.                     count($data['searchFilter']) > 1 && empty($data['searchFilter']['factory']) ||
  375.                     count($data['searchFilter']) > 2 && !empty($data['searchFilter']['factory'])
  376.                 ) {
  377.                     $this->sphinxQL->addWhere("express_sample = 1");
  378.                 } else {
  379.                     $this->sphinxQL->addWhere("c_express_sample = 1");
  380.                 }
  381.             }
  383.             // если getAwards, то просто проверяем наличие наград и все, без уточнений
  384.             if (!empty($data['searchFilter']['getAwards'])) {
  385.                 $this->sphinxQL->addWhere("c_awards is not null");
  386.             }
  388.             // Если exhibition, то просто проверяем наличие выставок и все,
  389.             // без уточнений. Их фильтруем потом дополнительно
  390.             if (!empty($data['searchFilter']['exhibition'])) {
  391.                 $this->sphinxQL->addWhere("c_exhibition <> ''");
  392.             }
  394.             // отдельно фильтр для дизайнеров, с заготовкой под ID
  395.             if (!empty($data['searchFilter']['getDesigner'])) {
  396.                 // 1 имя, 0 это Id
  397.                 $designerName = '';
  399.                 $designerId = $data['searchFilter']['getDesigner'][0];
  400.                 // поставил LIKE поиск по имени дизайнера + поиск по ID
  401.                 $this->sphinxQL->addWhere("MATCH('(@c_designer_ids $designerId) {$designerName}')");
  402.                 unset($data['searchFilter']['getDesigner']);
  403.             }
  405.             if (!empty($data['searchFilter']['size_x'])) {
  406.                 $this->sphinxQL->addWhere(
  407.                     'size_x >= ?',
  408.                     str_replace(',', '.', $data['searchFilter']['size_x'][0] * 100)
  409.                 );
  410.                 $buildingMixtureOff = true;
  411.             }
  412.             if (!empty($data['searchFilter']['size_y'])) {
  413.                 $this->sphinxQL->addWhere(
  414.                     'size_y >= ?',
  415.                     str_replace(',', '.', $data['searchFilter']['size_y'][0] * 100)
  416.                 );
  417.                 $buildingMixtureOff = true;
  418.             }
  419.             if (!empty($data['searchFilter']['tolsch'])) {
  420.                 $this->sphinxQL->addWhere(
  421.                     'tolsch >= ?',
  422.                     str_replace(',', '.', $data['searchFilter']['tolsch'][0] * 100)
  423.                 );
  424.                 $buildingMixtureOff = true;
  425.             }
  426.             if (!empty($data['searchFilter']['size_x2'])) {
  427.                 $this->sphinxQL->addWhere(
  428.                     'size_x <= ?',
  429.                     str_replace(',', '.', $data['searchFilter']['size_x2'][0] * 100)
  430.                 );
  431.                 if (empty($data['searchFilter']['size_x'])) {
  432.                     $this->sphinxQL->addWhere('size_x > ?', 0);
  433.                 }
  434.                 $buildingMixtureOff = true;
  435.             }
  436.             if (!empty($data['searchFilter']['size_y2'])) {
  437.                 $this->sphinxQL->addWhere(
  438.                     'size_y <= ?',
  439.                     str_replace(',', '.', $data['searchFilter']['size_y2'][0] * 100)
  440.                 );
  441.                 if (empty($data['searchFilter']['size_y'])) {
  442.                     $this->sphinxQL->addWhere('size_y > ?', 0);
  443.                 }
  444.                 $buildingMixtureOff = true;
  445.             }
  446.             if (!empty($data['searchFilter']['tolsch2'])) {
  447.                 $this->sphinxQL->addWhere(
  448.                     'tolsch <= ?',
  449.                     str_replace(',', '.', $data['searchFilter']['tolsch2'][0] * 100)
  450.                 );
  451.                 if (empty($data['searchFilter']['tolsch'])) {
  452.                     $this->sphinxQL->addWhere('tolsch > ?', 0);
  453.                 }
  454.                 $buildingMixtureOff = true;
  455.             }
  457.             // специально для приложений
  458.             if (!empty($data['searchFilter']['prMinFrom'])) {
  459.                 $this->sphinxQL->addWhere(
  460.                     'pr_min <= ?',
  461.                     str_replace(',', '.', $data['searchFilter']['prMinFrom'][0] * 100)
  462.                 );
  463.             }
  465.             if (!empty($data['searchFilter']['prMinTo'])) {
  466.                 $this->sphinxQL->addWhere(
  467.                     'pr_min >= ?',
  468.                     str_replace(',', '.', $data['searchFilter']['prMinTo'][0] * 100)
  469.                 );
  470.             }
  473. //todo удалить после тестов перенести логику наверх
  474.             if (!empty($data['searchFilter']['shape'])) {
  475. //                if (in_array(10, $data['searchFilter']['shape'])) {
  476. //                    unset($data['searchFilter']['shape'][array_search(10, $data['searchFilter']['shape'])]);
  477. //                    $this->sphinxQL->addWhere('module = ?', 1);
  478. //                }
  479.                 if (!count($data['searchFilter']['shape'])) {
  480.                     unset($data['searchFilter']['shape']);
  481.                 }
  482.             }
  485.             // фильтр окрашен по color body //нужно добавить в материал иначе идет только через AND
  486.             if (!empty($data['searchFilter']['colorBody'])) {
  487.                 $data['searchFilter']['getMaterials'][] = 999;
  488.                 //  $this->sphinxQL->addWhere("color_body = ?", $data['searchFilter']['colorBody']);
  489.             }
  490.             if (!empty($data['searchFilter']['getColors']) && in_array(99, $data['searchFilter']['getColors'])) {
  491.                 $this->sphinxQL->addWhere('ANY(color) in (?)', 99);
  492.                 unset($data['searchFilter']['getColors'][array_search(99, $data['searchFilter']['getColors'])]);
  493.                 if (empty($data['searchFilter']['getColors'])) {
  494.                     unset($data['searchFilter']['getColors']);
  495.                 }
  496.             }
  497.             // если есть фильтры, то добавляем их к запросу
  498.             foreach ($data['searchFilter'] as $key => $row) {
  499.                 if (!empty($dataArticles[$key])) {
  500.                     // отключаем фильтр getPrcateg и ориентируемся на баланс
  501.                     if (trim($key) == 'getPrcateg') {
  502.                         continue;
  503.                     }
  506.                     //тут проставим $mvaFields чтобы искать в MVA any|all
  507.                     if (in_array($dataArticles[$key], $mvaFields)) {
  508.                         $dataArticles[$key] = ' ANY(' . $dataArticles[$key] . ')';
  509.                     }
  510.                     $this->sphinxQL->addWhere($dataArticles[$key] . ' IN (?)', $row);
  511.                 }
  512.             }
  514.             // фильтр окрашен в массе
  515.             if (!empty($data['searchFilter']['dyedInMass'])) {
  516.                 $this->sphinxQL->addWhere('dyed_in_mass = 1');
  517.             }
  520.             // !!! теперь если выбран фильтр применения показываем только интерьеры
  521.             // для применения работает немного иначе если более одного признака то идёт наследование от коллекции,
  522.             // но при этом надо не показывать интерьеры, которые не соответствуют применению
  523.             if (!empty($data['searchFilter']['getUsings'])) {
  524.                 if (!empty($data['searchFilter']['getUsings'])) {
  525.                     // вернул выборку по ID иначе показывает все из "применения" без фильтрации.
  526.                     $this->sphinxQL->addWhere('ANY(apply_id) IN (?)', $data['searchFilter']['getUsings']);
  527.                 }
  528.                 $this->sphinxQL->addWhere('c_accessible <> 1');
  529.             }
  531.             // фильтр по фабрике
  532.             if (!empty($data['searchFilter']['factory'])) {
  533.                 $this->sphinxQL->addWhere('factory = \'' . $data['searchFilter']['factory'][0] . '\'');
  534.             }
  536.             // фильтр по фабрике
  537.             if (!empty($data['searchFilter']['bm'])) {
  538.                 $bmId = $data['searchFilter']['bm'];
  539.                 $bmId = is_array($bmId) ? $bmId[0] : $bmId;
  540.                 $this->sphinxQL->addWhere('u_id = ' . $bmId);
  541.             }
  543.             // фильтр по id коллекций
  544.             if (!empty($data['searchFilter']['c_id'])) {
  545.                 $this->sphinxQL->addWhere('c_id IN (?)', $data['searchFilter']['c_id']);
  546.             }
  547.         }
  549.         // тонкий керамогранит
  550.         if (!empty($data['searchFilter']['getThinGranite'])) {
  551.             $this->sphinxQL->addWhere('thin_granite = ?', 1);
  552.             $buildingMixtureOff = true;
  553.         }
  555.         // фильтр большого размера плитки
  556.         if (!empty($data['searchFilter']['size_big'])) {
  557.             $this->sphinxQL->addWhere('size_big = ?', 1);
  558.             $buildingMixtureOff = true;
  559.         }
  561.         // глазурированный/неглазурированный керамогранит
  562.         if (!empty($data['searchFilter']['getGlazedGranit'])) {
  563.             $this->sphinxQL->addWhere('glazed_granite = ?', $data['searchFilter']['getGlazedGranit']);
  564.         }
  566.         if ($country == 'ru' || $buildingMixtureOff) {
  567.             $this->sphinxQL->addWhere('c_id != ?', 3245628);
  568.         }
  570.         // утолщенный керамогранит
  571.         if (!empty($data['searchFilter']['getThickGranite'])) {
  572.             $this->sphinxQL->addWhere('thick_granite = ?', $data['searchFilter']['getThickGranite']);
  573.         }
  574.         // Если новинки, то выводим только коллекции за месяц
  575.         //Семраш пишет не может сканировать страницу новинок
  576.         //https://te2.remote.team/discus/35DEFA01-C136-0EA2-DB72-E8999812EBFC
  577.         if (isset($data['searchFilter']['getTop'])) {
  578.             $this->sphinxQL->addWhere('ANY(publish_period) = ?', 4);
  579.         }
  580.         // выборки за период
  581.         if (isset($data['searchPeriod'])) {
  582.             $this->sphinxQL->addWhere('ANY(publish_period) = ?', $data['searchPeriod']);
  583.         }
  585.         $dateSort = 'publish_date DESC';
  586.         // фильтрация по году выпуска
  587.         if (!empty($data['searchFilter']['releaseYear'])) {
  588.             $years = [];
  589.             foreach ($data['searchFilter']['releaseYear'] as $year) {
  590.                 if (strlen($year) > 4) {
  591.                     $y = substr($year, 0, 4);
  592.                     do {
  593.                         $y--;
  594.                         $years[] = $y;
  595.                     } while ($y > 2013);
  596.                 } elseif ($year == 999) {
  597.                     $years[] = date('Y');
  598.                 } else {
  599.                     $years[] = $year;
  600.                 }
  601.             }
  603.             if (count($years) > 0) {
  604.                 $this->sphinxQL->addWhere('c_release_year IN (?)', $years);
  605.             }
  606.         }
  608.         // фильтрация по средней оценке отзывов
  609.         if (!empty($data['searchFilter']['reviews'])) {
  610.             $this->sphinxQL->addWhere('reviews IN (?)', $data['searchFilter']['reviews']);
  611.             if ($this->getSearchSortId() == 0) {
  612.                 $data['searchSort'] = 6;
  613.             }
  614.         }
  615.         // учитываем сортировку в запросе
  616.         if (isset($data['searchFilter']['getTopMonth'])) {
  617.             $searchSort = 'c_pop30 DESC';
  618.         } elseif (isset($data['searchFilter']['getTopWeek'])) {
  619.             $searchSort = 'c_pop7 DESC';
  620.         } else {
  621.             $searchSort = 'rating DESC';
  622.         }
  623.         if (!empty($data['searchFilter']['getCostCategory']) && $this->getSearchSortId() == 0) {
  624.             $searchSort = 'price_sort ASC';
  625.         }
  627.         if (!empty($data['searchFilter'][''])) {
  628.             unset($data['searchFilter']['']);
  629.         }
  631.         // определяем тип минимальной цены
  632.         $minTypeAll = false;
  633.         if (
  634.             (count($data['searchFilter']) == 0 || !empty($data['searchFilter']['factory'])
  635.                 && count($data['searchFilter']) == 1) && !$getCount
  636.         ) {
  637.             $minTypeAll = true;
  638.             // Если нет фильтров ищем только по фонам мозаике декору
  639.             // Ага, а если ищем зеленный, то выводим красный :)
  640.             //   $this->sphinxQL->addWhere('ANY(type) IN (?)', [1, 24, 113, 122, 27, 106, 64, 128, 0]);
  641.         }
  643.         // https://te.remote.team/#/discus/BDBD8973-1F54-3B16-99ED-8656AEFC1105/
  644.         // убрал совсем сортировку по полю price_euro
  645.         if (
  646.             !empty($data['searchFilter']['getTypes']) && !array_intersect(
  647.                 (array)$data['searchFilter']['getTypes'],
  648.                 [1, 24, 113, 122, 106]
  649.             )
  650.         ) {
  651.             $sort = 'price_sort ASC';
  652.         } else {
  653.             $sort = $priceFields[4] . ' ASC';
  654.         }
  655.         $searchSortLimit = false;
  656.         if (!empty($data['searchSort'])) {
  657.             switch ($data['searchSort']) {
  658.                 case 2:
  659.                     // по цене
  660.                     $searchSort = false;
  661.                     break;
  662.                 case 3:
  663.                     // по дате
  664.                     $searchSort = 'publish_date DESC';
  665.                     break;
  666.                 case 4:
  667.                     // по алфавиту
  668.                     $searchSort = 'c_name ASC';
  669.                     break;
  670.                 case 5:
  671.                     // по популярности за месяц
  672.                     $searchSort = 'rating_month DESC';
  673.                     break;
  674.                 case 6:
  675.                     // по отзывам
  676.                     $searchSort = 'prc_star DESC';
  677.                     $searchSortLimit = 'prc_count DESC';
  678.                     break;
  679.             }
  680.         }
  681.         if (empty($data['total_found'])) {
  682.             if ($searchSort) {
  683.                 $this->sphinxQL->setOrder($searchSort);
  684.             }
  686.             $this->sphinxQL
  687.                 ->setOrder('sort DESC')
  688.                 ->setOrder(
  689.                     $searchSortLimit ? $searchSortLimit : $sort
  690.                 ) //цена в приоритете она создает коллекцию и минимальную ее цену
  691.                 ->setOrder('max_is_head DESC') //сортирует только по строкам max_is_head"
  692.                 ->setOrder($dateSort);
  693.         }
  694.         if (!empty($data['total_found'])) {
  695.             $this->sphinxQL->setLimit(1)
  696.                 ->setGroup('coll');
  697.             $rows = $this->sphinxQL->getQuery()->fetchAllAssociative();
  698.             $totalFound = $this->sphinxQL->getTotalFound();
  699.             return ['total_found' => $totalFound];
  700.         }
  701.         $this->subFilters = $this->filterRepo->getFiltersSubRelation(false);
  702.         if (empty($data['limit'])) {
  703.             $this->sphinxQL->setLimit(SphinxQLService::MAX_MATCHES);
  705.             if (empty($data['searchFilter']['inside'])) {
  706.                 $this->sphinxQL->setGroup('a_id');//, i_id, sid, styleid, styleida
  707.             }
  708.         } else {
  709.             $this->sphinxQL->setLimit($data['limit'])
  710.                 ->setGroup('coll');
  711.         }
  712.         if (!empty($data['real'])) {
  713.             $this->sphinxQL->setOption('max_matches=200000');
  714.             $this->sphinxQL->setLimit(200000);
  715.         }
  717.         $ed = [];
  718.         $listMeasure = $this->em->getRepository('WebBundle:ListMeasure')->findBy(['hide' => false]);
  720.         /** @var ListMeasure $row */
  721.         foreach ($listMeasure as $row) {
  722.             $ed[$row->getId()] = $row->getAlias() != null
  723.                 ? $this->translator->trans($row->getAlias())
  724.                 : $row->getName();
  725.         }
  727.         //дополнительные свойства
  728.         $collections = ['i_names' => [], 'a_names' => []];
  729.         $num = 0;
  731.         $rows = $this->sphinxQL->getQuery()->fetchAllAssociative();
  734.         if ($getCount) {
  735.             $calculate = [];
  736.             //Создаем привязку фильтра к нашим полям для подсчета
  737.             $aFiltersOnlyNoChilds = $this->filterRepo->getListForSynchCountFilters([]);
  738.             $realFilterProperty = [];
  739.             $newFiltersOnlyNoChild = [];
  740.             foreach ($aFiltersOnlyNoChilds as $fVal) {
  741.                 $fRealId = $fVal['oldCommand'] == 'getDesigner' ? $fVal['id'] : $fVal['oldId'];
  742.                 $realFilterProperty[$fVal['oldCommand']] [$fRealId] = $fVal;
  743.                 $realFilterProperty[$fVal['oldCommand']] [$fRealId] ['oldId'] = $fRealId;
  744.                 $realFilterProperty[$fVal['oldCommand']] [$fRealId] ['count'] = 0;
  745.                 $realFilterProperty[$fVal['oldCommand']] [$fRealId] ['coll_array'] = []; //добавляем массив колеккций дабы отсекать у родителей дубли
  746.                 $newFiltersOnlyNoChild[$fVal['id']] = $fVal;
  747.                 $newFiltersOnlyNoChild[$fVal['id']]['coll_array'] = [];
  748.             }
  749.         }
  750.         foreach ($rows as $row) {
  751.             if (!empty($row['attr_data']) && $attDate = json_decode($row['attr_data'], true)) {
  752.                 //               удаляем интерфейсы
  753.                 unset($attDate['i_name']);
  754.                 unset($attDate['i_id']);
  755.                 unset($attDate['i_rating']);
  756.                 unset($attDate['i_monochrome']);
  757.                 unset($attDate['i_status']);
  758.                 unset($attDate['i_file']);
  759.                 unset($attDate['i_wall_and_floor']);
  760.                 unset($attDate['i_style']);
  761.                 unset($attDate['i_texture']);
  762.                 unset($attDate['fsi_x']);
  763.                 unset($attDate['fsi_y']);
  764.                 $row = array_merge((array)$row, $attDate); //удалить главный интерьер из сфинкса
  765.             }
  766.             if (!empty($row['c_exhibition']) && $exhibitionDate = json_decode($row['c_exhibition'], true)) {
  767.                 $row['c_exhibition'] = $exhibitionDate;
  768.             } else {
  769.                 $row['c_exhibition'] = [];
  770.             }
  771.             if (!empty($row['c_awards']) && $c_awardsDate = json_decode($row['c_awards'], true)) {
  772.                 $row['c_awards'] = $c_awardsDate;
  773.             } else {
  774.                 $row['c_awards'] = [];
  775.             }
  776.             if (!empty($row['c_designer_ids']) && $c_designer_idsDate = json_decode($row['c_designer_ids'], true)) {
  777.                 $row['c_designer_ids'] = $c_designer_idsDate;
  778.             } else {
  779.                 $row['c_designer_ids'] = [];
  780.             }
  781.             // временно
  783.             if ($getCount) {
  784.                 if (empty($calculate[$row['coll']])) {
  785.                     //todo по факту эти поля нужно будет собрать из индекса который будет колеккцией пока у меня article2
  786.                     $calculate[$row['coll']] = [
  787.                         'getStyles' => [],
  788.                         'getSurfaces' => [],
  789.                         'getFacturas' => [],
  790.                         'getMaterials' => [],
  791.                         'getStone' => [],
  792.                         'getColors' => [],
  793.                         'shape' => [],
  794.                         'motive' => [],
  795.                         'motiv' => [],
  796. //                        'inside' => [],
  797.                         'discontinued' => [],
  798.                         'expressSample' => [],
  799.                         'getAwards' => [],
  800.                         'exhibition' => [],
  801.                         'size_x' => [],
  802.                         'size_y' => [],
  803.                         'tolsch' => [],
  804.                         'material' => [],
  805.                         'getTypeUsings' => [],
  806.                         'factory' => [],
  807.                         'bm' => [],
  808.                         'c_id' => [],
  809.                         'getThinGranite' => [],
  810.                         'size_big' => [],
  811.                         'getGlazedGranit' => [],
  812.                         'getThickGranite' => [],
  813.                         'searchPeriod' => [],
  814.                         'releaseYear' => [],
  815.                         'reviews' => [],
  816.                         'dyedInMass' => [],
  817.                         'colorBody' => [],
  818.                         'sliding' => [],
  819.                         'getUsings' => [],
  820.                         'getDesigner' => [],
  821.                         'monochrome' => [],
  822.                         'getPrcateg' => [],
  823.                         'getTypes' => [],
  824.                         'getCountry' => [],
  825.                         'a_price_cat_pln' => [],
  826.                         'getEdgeType' => [],
  827.                         'offShade' => [],
  828.                         'getCostCategory' => [],
  829.                     ];
  830.                 }
  831.                 //пробуем просто собрать данные;
  832.                 $calculate[$row['coll']]['getCostCategory'] = array_merge(
  833.                     $calculate[$row['coll']]['getCostCategory'],
  834.                     [$row[$priceFields[3]]]
  835.                 );
  836.                 $calculate[$row['coll']]['getStyles'] = array_merge(
  837.                     $calculate[$row['coll']]['getStyles'],
  838.                     explode(',', $row['sid'])
  839.                 );
  840.                 $calculate[$row['coll']]['getSurfaces'] = array_merge(
  841.                     $calculate[$row['coll']]['getSurfaces'],
  842.                     explode(',', $row['surface'])
  843.                 );
  845.                 $calculate[$row['coll']]['getMaterials'] = array_merge(
  846.                     $calculate[$row['coll']]['getMaterials'],
  847.                     explode(',', $row['material'])
  848.                 );
  850.                 $calculate[$row['coll']]['getFacturas'] = array_merge(
  851.                     $calculate[$row['coll']]['getFacturas'],
  852.                     explode(',', $row['a_texture'])
  853.                 );
  854.                 $calculate[$row['coll']]['getStone'] = array_merge(
  855.                     $calculate[$row['coll']]['getStone'],
  856.                     explode(',', $row['a_stone_texture'])
  857.                 );
  858.                 $calculate[$row['coll']]['getColors'] = array_merge(
  859.                     $calculate[$row['coll']]['getColors'],
  860.                     explode(',', $row['color'])
  861.                 );
  862.                 $calculate[$row['coll']]['shape'] = array_merge(
  863.                     $calculate[$row['coll']]['shape'],
  864.                     explode(',', $row['shape'])
  865.                 );
  866.                 $calculate[$row['coll']]['motive'] = array_merge(
  867.                     $calculate[$row['coll']]['motive'],
  868.                     explode(',', $row['a_motive'])
  869.                 );
  870.                 $calculate[$row['coll']]['motiv'] = array_merge(
  871.                     $calculate[$row['coll']]['motiv'],
  872.                     explode(',', $row['a_motiv'])
  873.                 );
  874. //                $calculate[$row['coll']]['inside'] = array_merge(
  875. //                    $calculate[$row['coll']]['inside'],
  876. //                    [$row[$priceFields[0]]]
  877. //                );
  878.                 $calculate[$row['coll']]['discontinued'] = array_merge(
  879.                     $calculate[$row['coll']]['discontinued'],
  880.                     explode(',', $row['typecoll'])
  881.                 );
  882.                 $calculate[$row['coll']]['expressSample'] = array_merge(
  883.                     $calculate[$row['coll']]['expressSample'],
  884.                     [$row['c_express_sample']]
  885.                 );
  886.                 $calculate[$row['coll']]['getAwards'] = array_merge(
  887.                     $calculate[$row['coll']]['getAwards'],
  888.                     [!empty($row['c_awards']) ? 1 : 2]
  889.                 );
  890.                 $calculate[$row['coll']]['exhibition'] = array_merge(
  891.                     $calculate[$row['coll']]['exhibition'],
  892.                     $row['c_exhibition']
  893.                 );
  894.                     $calculate[$row['coll']]['size_x'] = array_merge(
  895.                         $calculate[$row['coll']]['size_x'],
  896.                         [$row['size_x']]
  897.                     );
  899.                 $calculate[$row['coll']]['size_y'] = array_merge(
  900.                     $calculate[$row['coll']]['size_y'],
  901.                     [$row['size_y']]
  902.                 );
  903.                 $calculate[$row['coll']]['tolsch'] = array_merge(
  904.                     $calculate[$row['coll']]['tolsch'],
  905.                     [$row['tolsch']]
  906.                 );
  907.                 $calculate[$row['coll']]['material'] = array_merge(
  908.                     $calculate[$row['coll']]['material'],
  909.                     explode(',', $row['material'])
  910.                 );
  911.                 $calculate[$row['coll']]['getTypeUsings'] = array_merge(
  912.                     $calculate[$row['coll']]['getTypeUsings'],
  913.                     explode(',', $row['using'])
  914.                 );
  915.                 $calculate[$row['coll']]['factory'] = array_merge(
  916.                     $calculate[$row['coll']]['factory'],
  917.                     [$row['factory']]
  918.                 );
  919.                 $calculate[$row['coll']]['bm'] = array_merge($calculate[$row['coll']]['bm'], [$row['u_id']]);
  920.                 $calculate[$row['coll']]['c_id'] = array_merge($calculate[$row['coll']]['c_id'], [$row['c_id']]);
  921.                 $calculate[$row['coll']]['getThinGranite'] = array_merge(
  922.                     $calculate[$row['coll']]['getThinGranite'],
  923.                     [$row['thin_granite']]
  924.                 );
  925.                 $calculate[$row['coll']]['size_big'] = array_merge(
  926.                     $calculate[$row['coll']]['size_big'],
  927.                     [$row['size_big']]
  928.                 );
  929.                 $calculate[$row['coll']]['getGlazedGranit'] = array_merge(
  930.                     $calculate[$row['coll']]['getGlazedGranit'],
  931.                     [$row['glazed_granite']]
  932.                 );
  933.                 $calculate[$row['coll']]['getThickGranite'] = array_merge(
  934.                     $calculate[$row['coll']]['getThickGranite'],
  935.                     [$row['thick_granite']]
  936.                 );
  937.                 $calculate[$row['coll']]['searchPeriod'] = array_merge(
  938.                     $calculate[$row['coll']]['searchPeriod'],
  939.                     [$row['publish_period']]
  940.                 );
  941.                 $calculate[$row['coll']]['releaseYear'] = array_merge(
  942.                     $calculate[$row['coll']]['releaseYear'],
  943.                     [$row['c_release_year']]
  944.                 );
  945.                 $calculate[$row['coll']]['reviews'] = array_merge(
  946.                     $calculate[$row['coll']]['reviews'],
  947.                     explode(',', $row['reviews'])
  948.                 );
  949.                 $calculate[$row['coll']]['dyedInMass'] = array_merge(
  950.                     $calculate[$row['coll']]['dyedInMass'],
  951.                     [$row['dyed_in_mass']]
  952.                 );
  953.                 $calculate[$row['coll']]['sliding'] = array_merge(
  954.                     $calculate[$row['coll']]['sliding'],
  955.                     [$row['sliding']]
  956.                 );
  957.                 $calculate[$row['coll']]['getUsings'] = array_merge(
  958.                     $calculate[$row['coll']]['getUsings'],
  959.                     explode(',', $row['apply_id'])
  960.                 );
  961.                 $calculate[$row['coll']]['getDesigner'] = array_merge(
  962.                     $calculate[$row['coll']]['getDesigner'],
  963.                     $row['c_designer_ids']
  964.                 );
  965.                 $calculate[$row['coll']]['monochrome'] = array_merge(
  966.                     $calculate[$row['coll']]['monochrome'],
  967.                     explode(',', $row['monochrome'])
  968.                 );
  969.                 $calculate[$row['coll']]['getPrcateg'] = array_merge(
  970.                     $calculate[$row['coll']]['getPrcateg'],
  971.                     [$row['pr_status']]
  972.                 );
  973.                 $calculate[$row['coll']]['getTypes'] = array_merge(
  974.                     $calculate[$row['coll']]['getTypes'],
  975.                     explode(',', $row['type'])
  976.                 );
  977.                 $calculate[$row['coll']]['getCountry'] = array_merge(
  978.                     $calculate[$row['coll']]['getCountry'],
  979.                     [$row['country']]
  980.                 );
  981.                 $calculate[$row['coll']]['getEdgeType'] = array_merge(
  982.                     $calculate[$row['coll']]['getEdgeType'],
  983.                     explode(',', $row['edge_type'])
  984.                 );
  985.                 $calculate[$row['coll']]['offShade'] = array_merge(
  986.                     $calculate[$row['coll']]['offShade'],
  987.                     [$row['off_shade']]
  988.                 );
  989.                 //
  990.                 //включаем если запрашивали
  991.             }
  992.             $row['apply_id'] = explode(',', $row['apply_id']);
  993.             if (!empty($data['offset'])) {
  994.                 $num++;
  995.                 if ($data['offset'] > ($num - 1)) {
  996.                     continue;
  997.                 }
  998.             }
  1000.             if (!empty($row['c_accessible'])) {
  1001.                 $noInteriorFactory = true;
  1002.             } else {
  1003.                 $noInteriorFactory = false;
  1004.             }
  1006.             if ($row['c_id'] == 3245628) {
  1007.                 $row['c_name'] = App::trans('left_menu_glue');
  1008.             }
  1010.             //создаем клон из строки, но с данными из Коллекций для блатного удаления и фильтрации
  1011.             //обратить внимание при поиске по коллекциям возврщает полный результат и потом фильтрует возможно можно что-то перенести в sphinx или в where
  1012.             $iRows = [];
  1013.             if (!empty($row['i'])) {
  1014.                 // Заменяем значения $row значениями $row[i][n]
  1015.                 foreach ($row['i'] as $v) {
  1016.                     $iRows[] = array_merge($row, $v);
  1017.                 }
  1018.             } else {
  1019.                 //если нет, то для дальнейшей проверки оставим старое значение
  1020.                 $iRows[] = $row;
  1021.             }
  1024.             foreach ($iRows as $intRow) {
  1025.                 $row = $intRow;
  1026.                 if (
  1027.                     !empty($data['searchFilter']['getUsings']) && count($data['searchFilter']) > 1 &&
  1028.                     !(count(array_intersect([$row['apply_id']], $data['searchFilter']['getUsings'])) > 0)
  1029.                 ) {
  1030.                     $applyShow = false;
  1031.                 } else {
  1032.                     $applyShow = true;
  1033.                 }
  1034.                 if ($row['process'] == 1) {
  1035.                     $row['i_file'] = str_replace(['.jpeg', '.jpg'], '.webp', $row['i_file']);
  1036.                 }
  1037.                 $noRestriction = $this->getNoRestriction($data['searchFilter'], $row, $oldTypeUsings ?? null);
  1039.                 // есть ограничение на показ интерьером, но выбран фильтр применения, пропускаем такой элемент
  1040.                 if (
  1041.                     !empty($data['searchFilter']['getUsings'])
  1042.                     && !$noRestriction
  1043.                 ) {
  1044.                     continue;
  1045.                 }
  1048.                 // базовая информация о коллекции
  1049.                 if (empty($collections[$row['coll']])) {
  1050.                     if ($row['c_status'] == 1) {
  1051.                         $dataReview[$row['coll']] = [
  1052.                             'name' => App::trans(
  1053.                                 $row['c_header'] . '.short',
  1054.                                 App::getCurLocale(),
  1055.                                 [
  1056.                                     '%collection%' => $row['c_name'],
  1057.                                 ]
  1058.                             ),
  1059.                             'url' => App::generateUrl(
  1060.                                 'app_collection',
  1061.                                 [
  1062.                                     'factoryUrl' => $row['f_url'],
  1063.                                     'collectionUrl' => $row['c_url'],
  1064.                                 ]
  1065.                             ),
  1066.                         ];
  1067.                     }
  1068.                     if (isset($data['searchFilter']['getTopMonth'])) {
  1069.                         $arrow = $row['c_pop30'] > $row['c_last_pop30'] ? 'up' : 'down';
  1070.                     } elseif (isset($data['searchFilter']['getTopWeek'])) {
  1071.                         $arrow = $row['c_pop7'] > $row['c_last_pop7'] ? 'up' : 'down';
  1072.                     } else {
  1073.                         $arrow = false;
  1074.                     }
  1075.                     $collections[$row['coll']] = [
  1076.                         'c_id' => $row['c_id'],
  1077.                         'c_code' => $row['coll'],
  1078.                         'c_status' => $row['c_status'],
  1079.                         'c_name' => $row['c_name'],
  1080.                         'ratingMonth' => $row['rating_month'],
  1081.                         'arrow' => $arrow,
  1082.                         'c_header' => $row['c_header'],
  1083.                         'c_release_year' => $row['c_release_year'],
  1084.                         'c_url' => $row['c_url'],
  1085.                         'f_name' => $row['f_name'],
  1086.                         'f_url' => $row['f_id'] == 12 ? StrHelper::toLower($row['f_url']) : $row['f_url'],
  1087.                     ];
  1089.                     // если не пустое, то там массив с ID фильтров, иконки которых надо получить будет
  1090.                     $collections[$row['coll']]['c_awards'] = $row['c_awards'];
  1091.                     // если не пустое, то там массив с sub ID фильтров выставок
  1092.                     $collections[$row['coll']]['c_exhibition'] = $row['c_exhibition'];
  1093.                     $collections[$row['coll']]['date'] = date('d.m.Y', $row['publish_date']);
  1094.                     $collections[$row['coll']]['country'] = $row['country'];
  1095.                     $collections[$row['coll']]['country_code'] = $row['country_code'];
  1096.                     $collections[$row['coll']]['type'] = $row['type'];
  1098.                     $collections[$row['coll']]['material'] = $this->mapMaterial(
  1099.                         array_unique(explode(',', $row['c_material'] ?? ''))
  1100.                     );
  1102.                     // вывел признак экспресс образца
  1103.                     $collections[$row['coll']]['hasExpressSample'] = !empty($row['c_express_sample']) && $row['c_express_sample'] == 1;
  1105.                     // добавил вывод prc_middle, что бы можно было проверить точность фильтрации
  1106.                     $prcCount = empty($row['prc_count']) ? null : $row['prc_count'];
  1107.                     $prcVote = empty($row['prc_vote']) ? null : $row['prc_vote'];
  1109.                     $prcMiddle = 0;
  1110.                     if ($prcCount && $prcVote) {
  1111.                         $prcMiddle = ($prcVote / $prcCount + 0.01 * $prcCount) * 100;
  1112.                     }
  1114.                     $collections[$row['coll']]['prc_count'] = $prcCount;
  1115.                     $collections[$row['coll']]['prc_vote'] = $prcVote;
  1116.                     $collections[$row['coll']]['prc_middle'] = $prcMiddle;
  1118.                     $collections[$row['coll']]['process'] = $row['process'] ?? 0;
  1119.                     $collections[$row['coll']]['alt'] = str_replace(
  1120.                         ['\\', '"', '\''],
  1121.                         '',
  1122.                         join(', ', [$row['f_name'], $row['c_name'], $row['i_name']])
  1123.                     );
  1125.                     $collections[$row['coll']]['author'] = empty($row['author']) ? null : $row['author'];
  1126.                     $collections[$row['coll']]['sliding'] = empty($row['sliding']) ? [] : [$row['sliding']];
  1127.                     $collections[$row['coll']]['a_show'] = empty($data['searchFilter']['getUsings']) ? '1' : '0';
  1129.                     // цены по умолчанию
  1130.                     $collections[$row['coll']]['price'] = (float)(max($row[$priceFields[0]], 1));
  1131.                     $collections[$row['coll']]['pr_min'] = (float)(max($row[$priceFields[2]], 1));
  1132.                     $collections[$row['coll']]['price_mq'] = (float)(max($row[$priceFields[1]], 1));
  1133.                     $collections[$row['coll']][$priceFields[4]] = (float)(max($row[$priceFields[4]], 1));
  1134.                     $collections[$row['coll']]['measureId'] = $row['measure'];
  1135.                     if (!empty($collections[$row['coll']]['price_mq']) && $row[$priceFields[3]] > 0) {
  1136.                         $collections[$row['coll']]['price'] = $collections[$row['coll']]['price_mq'];
  1137.                         $collections[$row['coll']]['measureId'] = 1;
  1138.                         $row['measure'] = 1;
  1139.                     }
  1140.                     $collections[$row['coll']]['measureText'] = $ed[$row['measure']] == 'm²' && LocaleHelper::getUserMeasure(
  1141.                     ) == 'ft' ? 'ft²' : $ed[$row['measure']];
  1142.                     if (in_array($country, ['ch', 'no', 'hk', 'sg'])) {
  1143.                         $collections[$row['coll']]['price'] = round(
  1144.                             $collections[$row['coll']]['price'] - $collections[$row['coll']]['price'] * 18 / 118,
  1145.                             2
  1146.                         );
  1147.                         $collections[$row['coll']]['pr_min'] = round(
  1148.                             $collections[$row['coll']]['pr_min'] - $collections[$row['coll']]['pr_min'] * 18 / 118,
  1149.                             2
  1150.                         );
  1151.                         $collections[$row['coll']]['price_mq'] = round(
  1152.                             $collections[$row['coll']]['price_mq'] - $collections[$row['coll']]['price_mq'] * 18 / 118,
  1153.                             2
  1154.                         );
  1155.                     }
  1157.                     // для Гонконга конвертируем из мальтийских цен по курсу
  1158.                     if ($country == 'hk') {
  1159.                         $collections[$row['coll']]['price'] = CurrencyRateHelper::convertPrice(
  1160.                             'HKD',
  1161.                             $collections[$row['coll']]['price']
  1162.                         );
  1163.                         $collections[$row['coll']]['pr_min'] = CurrencyRateHelper::convertPrice(
  1164.                             'HKD',
  1165.                             $collections[$row['coll']]['pr_min']
  1166.                         );
  1167.                         $collections[$row['coll']]['price_mq'] = CurrencyRateHelper::convertPrice(
  1168.                             'HKD',
  1169.                             $collections[$row['coll']]['price_mq']
  1170.                         );
  1171.                         $collections[$row['coll']][$priceFields[4]] = CurrencyRateHelper::convertPrice(
  1172.                             'HKD',
  1173.                             $collections[$row['coll']][$priceFields[4]]
  1174.                         );
  1175.                     }
  1177.                     // для Сингапура конвертируем из мальтийских цен по курсу
  1178.                     if ($country == 'sg') {
  1179.                         $collections[$row['coll']]['price'] = CurrencyRateHelper::convertPrice(
  1180.                             'SGD',
  1181.                             $collections[$row['coll']]['price']
  1182.                         );
  1183.                         $collections[$row['coll']]['pr_min'] = CurrencyRateHelper::convertPrice(
  1184.                             'SGD',
  1185.                             $collections[$row['coll']]['pr_min']
  1186.                         );
  1187.                         $collections[$row['coll']]['price_mq'] = CurrencyRateHelper::convertPrice(
  1188.                             'SGD',
  1189.                             $collections[$row['coll']]['price_mq']
  1190.                         );
  1191.                         $collections[$row['coll']][$priceFields[4]] = CurrencyRateHelper::convertPrice(
  1192.                             'SGD',
  1193.                             $collections[$row['coll']][$priceFields[4]]
  1194.                         );
  1195.                     }
  1197.                     // убираем копейки
  1198.                     $collections[$row['coll']]['price'] = round($collections[$row['coll']]['price']);
  1199.                     $collections[$row['coll']]['pr_min'] = round($collections[$row['coll']]['pr_min']);
  1200.                     $collections[$row['coll']]['price_mq'] = round($collections[$row['coll']]['price_mq']);
  1202.                     // минимальная цена по коллекции если, не установлены дополнительные фильтры
  1203.                     if ($minTypeAll) {
  1204.                         $collections[$row['coll']]['pr_min'] = round($collections[$row['coll']][$priceFields[4]]);
  1205.                         $collections[$row['coll']]['price_mq'] = round($collections[$row['coll']]['pr_min']);
  1206.                         $collections[$row['coll']]['price'] = round($collections[$row['coll']]['pr_min']);
  1207.                     } elseif (empty($collections[$row['coll']]['price_mq'])) {
  1208.                         $collections[$row['coll']]['price_mq'] = round($collections[$row['coll']]['price']);
  1209.                     }
  1211.                     // собираем коды ед.изм.
  1212.                     $collections[$row['coll']]['measure'] = $ed[$row['measure']] ?? (App::trans(
  1213.                         $measure == 'm' ? 'measure_mq' : 'measure_ft'
  1214.                     ));
  1216.                     $collections['i_names'][$row['coll']] = [];
  1217.                     $collections[$row['coll']]['interiors'] = [];
  1218.                     $collections[$row['coll']]['articles'][] = $this->article($row);
  1220.                     $collections[$row['coll']]['slidingShow'] = 0;
  1221.                     if (
  1222.                         !empty($data['searchFilter']['getSurfaces'])
  1223.                         && in_array(8, $data['searchFilter']['getSurfaces'])
  1224.                     ) {
  1225.                         $collections[$row['coll']]['slidingShow'] = 1;
  1226.                     }
  1228.                     $collections['a_names'][$row['coll']][] = $row['a_name'];
  1230.                     if (
  1231.                         empty($data['searchFilter']['inside'])
  1232.                         && !$noInteriorFactory
  1233.                         && (empty($data['searchFilter'])
  1234.                             || count($data['searchFilter']) <= 2
  1235.                             && !empty($data['searchFilter']['getAlsoCollViewed'])
  1236.                             || count($data['searchFilter']) == 1
  1237.                             && (!empty($data['searchFilter']['factory'])
  1238.                                 || !empty($data['searchFilter'][''])
  1239.                             )
  1240.                         )
  1241.                         && !empty($row['is_main'])
  1242.                     ) {               // специальная заглушка для главной картинки коллекции на случай если не выбраны фильтры
  1243.                         [
  1244.                             $mainInteriorId,
  1245.                             $mainInteriorName,
  1246.                             $mainInteriorFile,
  1247.                             $fileSizeX,
  1248.                             $fileSizeY,
  1249.                             $iRating,
  1250.                         ] = explode('|', $row['is_main']);
  1252.                         if (!$fileSizeY == 0 && !empty($mainInteriorName)) {
  1253.                             $iName = $mainInteriorName;
  1254.                             $iFile = $mainInteriorFile;
  1256.                             if ($row['a_head'] || !empty($data['searchFilter']['factory'])) {
  1257.                                 $collections['i_names'][$row['coll']][] = $iName;
  1258.                                 $collections[$row['coll']]['interiors'][] = [
  1259.                                     'i_id' => $mainInteriorId,
  1260.                                     'i_name' => $iName,
  1261.                                     'i_file' => $iFile,
  1262.                                     'i_rating' => $iRating,
  1263.                                     'x' => $fileSizeX,
  1264.                                     'y' => $fileSizeY,
  1265.                                 ];
  1266.                             }
  1267.                         }
  1268.                     }
  1270.                     if (
  1271.                         !$noInteriorFactory
  1272.                         && !empty($row['i_name'])
  1273.                         && isset($row['i_id']) && $row['i_id'] !== null
  1274.                         && $noRestriction
  1275.                         && $applyShow
  1276.                         && !in_array($row['i_name'], $collections['i_names'][$row['coll']])
  1277.                         && (empty($data['searchFilter']['getUsings'])
  1278.                             || in_array(8, $data['searchFilter']['getUsings'])
  1279.                             && $row['apply_id'] == 8
  1280.                             || !in_array(8, $data['searchFilter']['getUsings'])
  1281.                         )
  1282.                     ) {
  1283.                         $iName = $row['i_name'];
  1284.                         $iFile = $row['i_file'];
  1286.                         if ($row['a_head']) {
  1287.                             $collections['i_names'][$row['coll']][] = $iName;
  1288.                             $collections[$row['coll']]['interiors'][] = [
  1289.                                 'i_id' => $row['i_id'],
  1290.                                 'i_name' => $iName,
  1291.                                 'i_file' => $iFile,
  1292.                                 'x' => $row['fsi_x'],
  1293.                                 'y' => $row['fsi_y'],
  1294.                                 'i_rating' => $row['i_rating'],
  1295.                             ];
  1296.                         }
  1297.                     }
  1298.                 } else {
  1299.                     // если запрошена фильтрация по коллекции, то выводим все артикулы
  1300.                     if (!empty($_GET['debug']) || !empty($data['searchFilter']['inside'])) {
  1301.                         $collections[$row['coll']]['articles'][] = $this->article($row);
  1302.                     }
  1304.                     if (
  1305.                         !empty($row['author']) &&
  1306.                         is_array($collections[$row['coll']]['author']) &&
  1307.                         !in_array($row['author'], $collections[$row['coll']]['author'])
  1308.                     ) {
  1309.                         $collections[$row['coll']]['author'] = $row['author'];
  1310.                     }
  1312.                     if (!empty($row['sliding']) && !in_array($row['sliding'], $collections[$row['coll']]['sliding'])) {
  1313.                         $collections[$row['coll']]['sliding'][] = $row['sliding'];
  1314.                     }
  1316.                     // собираем коды ед.изм.
  1317.                     $collections[$row['coll']]['measure'] = $ed[$row['measure']] ?? (App::trans(
  1318.                         $measure == 'm' ? 'measure_mq' : 'measure_ft'
  1319.                     ));
  1321.                     // если не установлен лимит или интерьера нет для вывода, то смотрим артикулы
  1322.                     if (
  1323.                         !empty($_GET['debug'])
  1324.                         || $limit == 0
  1325.                         || count($collections[$row['coll']]['interiors']) < $limit
  1326.                     ) {
  1327.                         if (
  1328.                             (!empty($data['searchFilter']['getPrcateg'])
  1329.                                 && (in_array(7, $data['searchFilter']['getPrcateg'])
  1330.                                     || in_array(6, $data['searchFilter']['getPrcateg'])
  1331.                                 )
  1332.                             )
  1333.                             || !empty($data['searchFilter']['coll']) || count(
  1334.                                 $collections[$row['coll']]['articles']
  1335.                             ) == 0
  1336.                         ) {
  1337.                             /** см. выше для первого вхождения артикула в коллекцию */
  1338.                             if (
  1339.                                 empty($data['searchFilter']['getStyles'])
  1340.                                 || (!empty($data['searchFilter']['getStyles'])
  1341.                                     && in_array($row['a_style'], $data['searchFilter']['getStyles'])
  1342.                                 )
  1343.                             ) {
  1344.                                 if (!in_array($row['a_name'], $collections['a_names'][$row['coll']])) {
  1345.                                     $collections[$row['coll']]['articles'][] = $this->article($row);
  1346.                                 }
  1347.                             }
  1348.                         }
  1350.                         if (
  1351.                             !$noInteriorFactory
  1352.                             && !empty($row['i_name'])
  1353.                             && isset($row['i_id']) && $row['i_id'] !== null
  1354.                             && $noRestriction
  1355.                             && $applyShow
  1356.                             && !in_array($row['i_name'], $collections['i_names'][$row['coll']])
  1357.                             && (
  1358.                                 empty($data['searchFilter']['getUsings'])
  1359.                                 || !in_array(8, $data['searchFilter']['getUsings'])
  1360.                                 || $row['apply_id'] == 8
  1361.                             )
  1362.                         ) {
  1363.                             if ($row['a_head']) {
  1364.                                 $collections['i_names'][$row['coll']][] = $row['i_name'];
  1365.                                 $collections[$row['coll']]['interiors'][] = [
  1366.                                     'i_id' => $row['i_id'],
  1367.                                     'i_name' => $row['i_name'],
  1368.                                     'i_file' => $row['i_file'],
  1369.                                     'x' => $row['fsi_x'],
  1370.                                     'y' => $row['fsi_y'],
  1371.                                     'i_rating' => $row['i_rating'],
  1372.                                 ];
  1373.                             }
  1374.                         }
  1375.                     }
  1377.                     $collections['a_names'][$row['coll']][] = $row['a_name'];
  1378.                 }
  1379.             }
  1380.         }
  1382.         unset($collections['i_names']);
  1383.         unset($collections['a_names']);
  1385.         // проверяем и фильтруем дополнительно выставки
  1386.         if (!empty($data['searchFilter']['exhibition'])) {
  1387.             $idExh = $data['searchFilter']['exhibition'];
  1388.             foreach ($collections as $i_ => $coll_) {
  1389.                 if (!array_intersect($idExh, $coll_['c_exhibition'])) {
  1390.                     unset($collections[$i_]);
  1391.                 }
  1392.             }
  1393.         }
  1395.         if (
  1396.             !empty($data['searchFilter']['getPrcateg'])
  1397.             && (in_array(6, $data['searchFilter']['getPrcateg'])
  1398.                 || in_array(7, $data['searchFilter']['getPrcateg'])
  1399.             )
  1400.         ) {
  1401.             $collections = $this->setIndexesForArticlesInCollections($collections);
  1402.         }
  1404.         if ($getCount) {
  1405.             //Отсекаем ненужные колекции
  1406.             foreach ($calculate as $i => $coll) {
  1407.                 if (!isset($collections[$i])) {
  1408.                     unset($calculate[$i]);
  1409.                 }
  1410.             }
  1411.         }
  1412.         $collections = array_values($collections);
  1414.         if ($getCount) {
  1415.             $fixfilter = $this->getCount($calculate, $realFilterProperty, $newFiltersOnlyNoChild);
  1416.             if (!empty($fixfilter)) {
  1417.                 $res_enabledSize = $fixfilter;
  1418.             } else {
  1419.                 $res_enabledSize = [];
  1420.             }
  1421.             $collections = [
  1422.                 'collections' => $collections,
  1423.                 'calculate' => $res_enabledSize,
  1424.             ];
  1425.         }
  1427.         if ($full) {
  1428.             return [
  1429.                 'res' => $collections,
  1430.                 'codes' => $dataReview,
  1431.             ];
  1432.         }
  1434.         return $collections;
  1435.     }
  1438.     /**
  1439.      * Подсчитывает Коллекции в свойстве
  1440.      * @param array $calculate - Собраные значения
  1441.      * @param array $realFilterProperty - фильтр связь ключей старые новые
  1442.      * @return array - подсчет коллекций
  1443.      * @throws Exception
  1444.      */
  1445.     private function getCount(array $calculate, array $realFilterProperty = [], $aFiltersOnlyNoChilds = []): array
  1446.     {
  1447.         $oldId = 'id';
  1448.         $res = [];
  1449.         //перебераем массив с коллекциями не товарами
  1450.         foreach ($calculate as $coll => $values) {
  1451.             //перебираем их свойства
  1452.             foreach ($values as $key => $value) {
  1453.                 //перебираем их значение
  1454.                 foreach (array_unique($value) as $v) {
  1455.                     //тут вся логика с фильтром
  1456.                     if (isset($realFilterProperty[$key][$v])) {
  1457.                         // $realFilterProperty[$key][$v]['count']++;
  1458.                         if (isset($res[$key][$realFilterProperty[$key][$v][$oldId]])) {
  1459.                             $res[$key][$realFilterProperty[$key][$v][$oldId]]++;
  1460.                         } else {
  1461.                             $res[$key][$realFilterProperty[$key][$v][$oldId]] = 1;
  1462.                         }
  1463.                     } else {
  1464.                         //если такого фильтра не существует нужно создать и присвоить его свойству первое вхождение
  1465.                         if (isset($res[$key][$v])) {
  1466.                             $res[$key][$v]++;
  1467.                         } else {
  1468.                             $res[$key][$v] = 1;
  1469.                         }
  1470.                     }
  1471.                 }
  1472.             }
  1473.         }
  1477.         return $res;
  1478.     }
  1480.     /**
  1481.      * @param $row
  1482.      * @return array
  1483.      * @throws Exception
  1484.      */
  1485.     private function article($row): array
  1486.     {
  1487.         // сохраняем id артикула для выборки подробных данных артикулов подходящих под отбор
  1488.         $this->articlesId[] = $row['a_id'];
  1490.         return [
  1491.             'a_id' => $row['a_id'],
  1492.             'a_name' => $row['a_name'],
  1493.             'file' => $row['process'] == 1 ? str_replace(['.jpeg', '.jpg'], '.webp', $row['file']) : $row['file'],
  1494.             'a_x' => $row['fs_x'],
  1495.             'a_y' => $row['fs_y'],
  1496.             'b_g' => $row['border_grey'],
  1497.             'alt' => str_replace(['\\', '"', '\''], '', join(', ', [$row['f_name'], $row['c_name'], $row['a_name']])),
  1498.         ];
  1499.     }
  1501.     /**
  1502.      * @throws Exception
  1503.      */
  1504.     private function mapMaterial(array $collectionMaterials = []): array
  1505.     {
  1506.         $listMaterialCollection = [];
  1507.         foreach ($collectionMaterials as $materialId) {
  1508.             if (!empty($this->getMaterials()[$materialId])) {
  1509.                 $listMaterialCollection[] = $this->getMaterials()[$materialId];
  1510.             }
  1511.         }
  1513.         return $listMaterialCollection;
  1514.     }
  1516.     /**
  1517.      * @return array
  1518.      * @throws Exception
  1519.      */
  1520.     private function getMaterials(): array
  1521.     {
  1522.         if (count($this->materials) == 0) {
  1523.             /** @var ListMaterialRepository $repoMaterialList */
  1524.             $repoMaterialList = App::getRepository(ListMaterial::class);
  1525.             $list = $repoMaterialList->getList(true);
  1526.             /** @var ListMaterial $r */
  1527.             foreach ($list as $r) {
  1528.                 $materials = App::trans('coll_preview_' . $r['alias']);
  1529.                 $position = strpos($materials, '_');
  1530.                 if ($position !== false) {
  1531.                     $materials = App::trans($r['alias']);
  1532.                 }
  1534.                 $this->materials[$r['id']] = $materials;
  1535.             }
  1536.         }
  1538.         return $this->materials;
  1539.     }
  1541.     private function getPriceFields(string $currency, string $country, string $measure): array
  1542.     {
  1543.         if ($currency === 'EUR') {
  1544.             switch ($country) {
  1545.                 case 'de':
  1546.                     return ['price_euro_de', 'price_mq_euro_de', 'pr_min_euro_de', 'a_price_cat_de', 'price_sort_de'];
  1547.                 case 'at':
  1548.                     return ['price_euro_at', 'price_mq_euro_at', 'pr_min_euro_at', 'a_price_cat_at', 'price_sort_at'];
  1549.                 case 'fi':
  1550.                     return ['price_euro_fi', 'price_mq_euro_fi', 'pr_min_euro_fi', 'a_price_cat_fi', 'price_sort_fi'];
  1551.                 case 'fr':
  1552.                     return ['price_euro_fr', 'price_mq_euro_fr', 'pr_min_euro_fr', 'a_price_cat_fr', 'price_sort_fr'];
  1553.                 case 'it':
  1554.                     return ['price_euro_it', 'price_mq_euro_it', 'pr_min_euro_it', 'a_price_cat_it', 'price_sort_it'];
  1555.                 case 'be':
  1556.                     return ['price_euro_be', 'price_mq_euro_be', 'pr_min_euro_be', 'a_price_cat_be', 'price_sort_be'];
  1557.                 case 'ie':
  1558.                     return ['price_euro_ie', 'price_mq_euro_ie', 'pr_min_euro_ie', 'a_price_cat_ie', 'price_sort_ie'];
  1559.                 case 'nl':
  1560.                     return ['price_euro_nl', 'price_mq_euro_nl', 'pr_min_euro_nl', 'a_price_cat_nl', 'price_sort_nl'];
  1561.                 case 'es':
  1562.                     return ['price_euro_es', 'price_mq_euro_es', 'pr_min_euro_es', 'a_price_cat_es', 'price_sort_es'];
  1563.                 case 'ru':
  1564.                     return ['price_rue', 'price_mq_rue', 'pr_min_rue', 'a_price_cat_rue', 'price_sort_rub'];
  1565.                 case 'gb':
  1566.                     return ['price_gbe', 'price_mq_gbe', 'pr_min_gbe', 'a_price_cat_gbe', 'price_sort_gbp'];
  1567.                 case 'ch':
  1568.                     return ['price_che', 'price_mq_che', 'pr_min_che', 'a_price_cat_che', 'price_sort_chf'];
  1569.                 case 'se':
  1570.                     return ['price_see', 'price_mq_see', 'pr_min_see', 'a_price_cat_see', 'price_sort_sek'];
  1571.                 case 'pl':
  1572.                     return ['price_ple', 'price_mq_ple', 'pr_min_ple', 'a_price_cat_ple', 'price_sort_pln'];
  1573.                 case 'us':
  1574.                     if ($measure === 'ft') {
  1575.                         return [
  1576.                             'price_fq_use',
  1577.                             'price_fq_use',
  1578.                             'pr_min_f_use',
  1579.                             'a_price_cat_fq_use',
  1580.                             'price_sort_fq_usd'
  1581.                         ];
  1582.                     }
  1583.                     return ['price_use', 'price_mq_use', 'pr_min_use', 'a_price_cat_use', 'price_sort_usd'];
  1584.                 case 'ca':
  1585.                     if ($measure === 'ft') {
  1586.                         return ['price_cae', 'price_fq_cae', 'pr_min_cae', 'a_price_cat_fq_cae', 'price_sort_fq_cad'];
  1587.                     }
  1588.                     return ['price_cae', 'price_mq_cae', 'pr_min_cae', 'a_price_cat_cae', 'price_sort_cad'];
  1589.             }
  1590.             return ['price_euro', 'price_mq_euro', 'pr_min_euro', 'a_price_cat', 'price_sort'];
  1591.         }
  1593.         if ($country === 'ru' && $currency === 'RUB') {
  1594.             return ['price_rub', 'price_mq_rub', 'pr_min_rub', 'a_price_cat_rub', 'price_sort_rub'];
  1595.         }
  1596.         if ($country === 'gb' && $currency === 'GBP') {
  1597.             return ['price_gbp', 'price_mq_gbp', 'pr_min_gbp', 'a_price_cat_gbp', 'price_sort_gbp'];
  1598.         }
  1599.         if ($country === 'ch' && $currency === 'CHF') {
  1600.             return ['price_chf', 'price_mq_chf', 'pr_min_chf', 'a_price_cat_chf', 'price_sort_chf'];
  1601.         }
  1602.         if ($country === 'se' && $currency === 'SEK') {
  1603.             return ['price_sek', 'price_mq_sek', 'pr_min_sek', 'a_price_cat_sek', 'price_sort_sek'];
  1604.         }
  1605.         if ($country === 'dk' && $currency === 'DKK') {
  1606.             return ['price_dkk', 'price_mq_dkk', 'pr_min_dkk', 'a_price_cat_dkk', 'price_sort_dkk'];
  1607.         }
  1608.         if ($country === 'no' && $currency === 'NOK') {
  1609.             return ['price_nok', 'price_mq_nok', 'pr_min_nok', 'a_price_cat_nok', 'price_sort_nok'];
  1610.         }
  1611.         if ($country === 'pl' && $currency === 'PLN') {
  1612.             return ['price_pln', 'price_mq_pln', 'pr_min_pln', 'a_price_cat_pln', 'price_sort_pln'];
  1613.         }
  1614.         if ($country === 'us' && $currency === 'USD') {
  1615.             if ($measure === 'ft') {
  1616.                 return ['price_fq_usd', 'price_fq_usd', 'pr_min_f_usd', 'a_price_cat_fq_usd', 'price_sort_fq_usd'];
  1617.             }
  1618.             return ['price_usd', 'price_mq_usd', 'pr_min_usd', 'a_price_cat_usd', 'price_sort_usd'];
  1619.         }
  1621.         if ($country === 'ca' && $currency === 'CAD') {
  1622.             if ($measure === 'ft') {
  1623.                 return ['price_cad', 'price_fq_cad', 'pr_min_cad', 'a_price_cat_fq_cad', 'price_sort_fq_cad'];
  1624.             }
  1625.             return ['price_cad', 'price_mq_cad', 'pr_min_cad', 'a_price_cat_cad', 'price_sort_cad'];
  1626.         }
  1628.         return ['price_euro', 'price_mq_euro', 'pr_min_euro', 'a_price_cat', 'price_sort'];
  1629.     }
  1631.     /**
  1632.      * Ограничение на показ интерьеров
  1633.      *
  1634.      * @param array $searchFilter
  1635.      * @param array $row
  1636.      * @param array|null $oldTypeUsings
  1637.      * @return bool
  1638.      */
  1639.     private function getNoRestriction(array $searchFilter, array $row, ?array $oldTypeUsings): bool
  1640.     {
  1641.         $iTexture = explode(',', $row['i_texture']);
  1642.         // В этой просьбе попросили исключить из ограничения фактуру по 17 кодом https://te.remote.team/#/discus/F4D2CA8B-BE66-7853-8FDC-2CFE011A151C/
  1643.         $iTexture[] = 17;
  1644.         //если поиск по группе и интерьер содержит текстуру подгруппы, то выведем как-бу-то это интерьер группы
  1645.         if (
  1646.             !empty($searchFilter['getFacturas'])
  1647.             && in_array(999, $searchFilter['getFacturas'])
  1648.             && in_array($iTexture, $this->subFilters)
  1649.         ) {
  1650.             $iTexture[] = 999;
  1651.         }
  1653.         //внутри коллекции для интерьеров надо проверить, что привязаны заглавный артикулы
  1654.         if (!empty($searchFilter['inside']) && empty($row['a_head'])) {
  1655.             return true;
  1656.         }
  1658.         // ограничение на показ интерьера по признаку назначение
  1659.         if (
  1660.             !empty($oldTypeUsings)
  1661.             && (array_search(4, $oldTypeUsings)
  1662.                 && !$row['i_wall_and_floor']
  1663.                 || !in_array($row['i_type'], $oldTypeUsings)
  1664.             )
  1665.         ) {
  1666.             return false;
  1667.         }
  1669.         // ограничение на показ интерьера по признаку стиль
  1670.         // внутри коллекции не используется это условие !!!!уже используется https://te2.remote.team/discus/C0B5DD6C-8487-9233-5238-08E2AF112A60?goto=true
  1671.         // так же это ограничение не должно работать если стиль "ручная работа"
  1672.         if (
  1673.             isset($row['i_style'])
  1674.             && $row['i_style'] == 0
  1675.             && !empty($searchFilter['getStyles'])
  1676.             && !in_array(14, $searchFilter['getStyles'])
  1677.             && !in_array(14, [$row['a_style'], $row['styleida']])
  1678.         ) {
  1679.             return false;
  1680.         }
  1682.         // если выбран фильтр монохром надо проверить, есть ли он у интерьера
  1683.         if (
  1684.             !empty($searchFilter['getColors'])
  1685.             && in_array(99, $searchFilter['getColors'])
  1686.             && !in_array(99, $iTexture)
  1687.         ) {
  1688.             return false;
  1689.         }
  1691.         // ограничение на показ интерьеров при поиске по фактуре
  1692.         if (
  1693.             (
  1694.                 (empty($searchFilter['getTypes'])
  1695.                     || !in_array($row['type'], $searchFilter['getTypes'])
  1696.                 )
  1697.                 && (empty($searchFilter['getMaterials'])
  1698.                     || !in_array(99, $searchFilter['getMaterials'])
  1699.                     || $row['material'] != 99
  1700.                 )
  1701.             )
  1702.             && empty($searchFilter['inside'])
  1703.         ) {
  1704.             if (
  1705.                 !empty($searchFilter['getFacturas'])
  1706.                 && count(array_intersect($iTexture, $searchFilter['getFacturas'])) == 0
  1707.             ) {
  1708.                 return true;
  1709.             }
  1711.             if (
  1712.                 !empty($searchFilter)
  1713.                 && (!empty($searchFilter['getColors'])
  1714.                     || !empty($searchFilter['getMaterials'])
  1715.                     || !empty($searchFilter['getSurfaces'])
  1716.                 )
  1717.                 && empty($row['type_filter'])
  1718.             ) { // ограничение подбора интерьеров по некоторым фильтрам
  1719.                 return false;
  1720.             }
  1722.             return true;
  1723.         }
  1725.         if (empty($searchFilter['getFacturas'])) {
  1726.             return true;
  1727.         }
  1729.         if (count(array_intersect($iTexture, $searchFilter['getFacturas'])) > 0) {
  1730.             return true;
  1731.         }
  1733.         return false;
  1734.     }
  1736.     /**
  1737.      * @param array $collections
  1738.      * @return array
  1739.      */
  1740.     private function setIndexesForArticlesInCollections(array $collections): array
  1741.     {
  1742.         $n = 0; // для простановки индексов артикулов
  1743.         foreach ($collections as &$collection) {
  1744.             unset($collection['interiors']);
  1745.             if (!empty($collection['articles'])) {
  1746.                 foreach ($collection['articles'] as &$item) {
  1747.                     $item['num'] = $n;
  1748.                     $n++;
  1749.                 }
  1750.             }
  1751.         }
  1753.         return $collections;
  1754.     }
  1755.     //нужно узнать не сортирует ли человек случайно чтобы отсортировать за него
  1757.     /**
  1758.      * @return int
  1759.      * @throws Exception
  1760.      */
  1761.     public function getSearchSortId()
  1762.     {
  1763.         $sort = App::getSession()->get('sort_catalog_tmp');
  1765.         if ($sort == null) {
  1766.             $sort = App::getRequest()->get('sort');
  1767.         }
  1769.         if ($sort == null) {
  1770.             $sort = App::getRequest()->cookies->get('sort_catalog');
  1771.         }
  1773.         if ($sort == null) {
  1774.             $sort = 0;
  1775.         }
  1778.         return $sort;
  1779.     }
  1780. }