-
Notifications
You must be signed in to change notification settings - Fork 0
/
ProductSearchRepository.php
71 lines (62 loc) · 2.33 KB
/
ProductSearchRepository.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
<?php
/**
* Copyright © 2016-present Spryker Systems GmbH. All rights reserved.
* Use of this software requires acceptance of the Evaluation License Agreement. See LICENSE file.
*/
namespace Spryker\Zed\ProductSearch\Persistence;
use Orm\Zed\Product\Persistence\Map\SpyProductAttributeKeyTableMap;
use Orm\Zed\ProductSearch\Persistence\Map\SpyProductSearchTableMap;
use Spryker\Zed\Kernel\Persistence\AbstractRepository;
use Spryker\Zed\PropelOrm\Business\Model\Formatter\PropelArraySetFormatter;
/**
* @method \Spryker\Zed\ProductSearch\Persistence\ProductSearchPersistenceFactory getFactory()
*/
class ProductSearchRepository extends AbstractRepository implements ProductSearchRepositoryInterface
{
/**
* @var string
*/
protected const COL_COUNT = 'count';
/**
* Result format:
* [
* $idProduct => [$idLocale => $count],
* ...,
* ]
*
* @param array<int> $productIds
* @param array<int> $localeIds
*
* @return array<int, array<int, int>>
*/
public function getProductSearchEntitiesCountGroupedByIdProductAndIdLocale(array $productIds, array $localeIds): array
{
$productSearchQuery = $this->getFactory()->createProductSearchQuery()
->select('COUNT(*)')
->filterByFkProduct_In($productIds)
->filterByIsSearchable(true)
->filterByFkLocale_In($localeIds)
->groupByFkProduct()
->groupByFkLocale()
->select([SpyProductSearchTableMap::COL_FK_PRODUCT, SpyProductSearchTableMap::COL_FK_LOCALE])
->withColumn('COUNT(*)', static::COL_COUNT);
$result = [];
foreach ($productSearchQuery->find() as $productSearchData) {
$idProduct = (int)$productSearchData[SpyProductSearchTableMap::COL_FK_PRODUCT];
$idLocale = (int)$productSearchData[SpyProductSearchTableMap::COL_FK_LOCALE];
$result[$idProduct][$idLocale] = $productSearchData[static::COL_COUNT];
}
return $result;
}
/**
* @return array<string>
*/
public function getAllProductAttributeKeys(): array
{
return $this->getFactory()
->createProductAttributeKeyQuery()
->addSelectColumn(SpyProductAttributeKeyTableMap::COL_KEY)
->setFormatter(new PropelArraySetFormatter())
->find();
}
}