1
|
|
|
<?php |
2
|
|
|
|
3
|
|
|
/* |
4
|
|
|
* This file is part of EC-CUBE |
5
|
|
|
* |
6
|
|
|
* Copyright(c) EC-CUBE CO.,LTD. All Rights Reserved. |
7
|
|
|
* |
8
|
|
|
* http://www.ec-cube.co.jp/ |
9
|
|
|
* |
10
|
|
|
* For the full copyright and license information, please view the LICENSE |
11
|
|
|
* file that was distributed with this source code. |
12
|
|
|
*/ |
13
|
|
|
|
14
|
|
|
namespace Eccube\Repository; |
15
|
|
|
|
16
|
|
|
use Doctrine\Common\Collections\ArrayCollection; |
17
|
|
|
use Eccube\Common\EccubeConfig; |
18
|
|
|
use Eccube\Doctrine\Query\Queries; |
19
|
|
|
use Eccube\Entity\Product; |
20
|
|
|
use Eccube\Entity\ProductStock; |
21
|
|
|
use Eccube\Util\StringUtil; |
22
|
|
|
use Symfony\Bridge\Doctrine\RegistryInterface; |
23
|
|
|
|
24
|
|
|
/** |
25
|
|
|
* ProductRepository |
26
|
|
|
* |
27
|
|
|
* This class was generated by the Doctrine ORM. Add your own custom |
28
|
|
|
* repository methods below. |
29
|
|
|
*/ |
30
|
|
|
class ProductRepository extends AbstractRepository |
31
|
|
|
{ |
32
|
|
|
/** |
33
|
|
|
* @var Queries |
34
|
|
|
*/ |
35
|
|
|
protected $queries; |
36
|
|
|
|
37
|
|
|
/** |
38
|
|
|
* @var EccubeConfig |
39
|
|
|
*/ |
40
|
|
|
protected $eccubeConfig; |
41
|
|
|
|
42
|
|
|
/** |
43
|
|
|
* ProductRepository constructor. |
44
|
|
|
* |
45
|
|
|
* @param RegistryInterface $registry |
46
|
|
|
* @param Queries $queries |
47
|
|
|
* @param EccubeConfig $eccubeConfig |
48
|
204 |
|
*/ |
49
|
|
|
public function __construct( |
50
|
|
|
RegistryInterface $registry, |
51
|
|
|
Queries $queries, |
52
|
|
|
EccubeConfig $eccubeConfig |
53
|
204 |
|
) { |
54
|
204 |
|
parent::__construct($registry, Product::class); |
55
|
204 |
|
$this->queries = $queries; |
56
|
|
|
$this->eccubeConfig = $eccubeConfig; |
57
|
|
|
} |
58
|
|
|
|
59
|
|
|
/** |
60
|
|
|
* Find the Product with sorted ClassCategories. |
61
|
|
|
* |
62
|
|
|
* @param integer $productId |
63
|
|
|
* |
64
|
|
|
* @return Product |
65
|
15 |
|
*/ |
66
|
|
|
public function findWithSortedClassCategories($productId) |
67
|
15 |
|
{ |
68
|
15 |
|
$qb = $this->createQueryBuilder('p'); |
69
|
15 |
|
$qb->addSelect(['pc', 'cc1', 'cc2', 'pi', 'pt']) |
70
|
15 |
|
->innerJoin('p.ProductClasses', 'pc') |
71
|
15 |
|
->leftJoin('pc.ClassCategory1', 'cc1') |
72
|
15 |
|
->leftJoin('pc.ClassCategory2', 'cc2') |
73
|
15 |
|
->leftJoin('p.ProductImage', 'pi') |
74
|
15 |
|
->leftJoin('p.ProductTag', 'pt') |
75
|
15 |
|
->where('p.id = :id') |
76
|
15 |
|
->andWhere('pc.visible = :visible') |
77
|
|
|
->setParameter('id', $productId) |
78
|
15 |
|
->setParameter('visible', true) |
79
|
15 |
|
->orderBy('cc1.sort_no', 'DESC') |
80
|
|
|
->addOrderBy('cc2.sort_no', 'DESC'); |
81
|
15 |
|
|
82
|
15 |
|
$product = $qb |
83
|
|
|
->getQuery() |
84
|
15 |
|
->getSingleResult(); |
85
|
|
|
|
86
|
|
|
return $product; |
87
|
|
|
} |
88
|
|
|
|
89
|
|
|
/** |
90
|
|
|
* Find the Products with sorted ClassCategories. |
91
|
|
|
* |
92
|
|
|
* @param array $ids Product in ids |
93
|
|
|
* @param string $indexBy The index for the from. |
94
|
17 |
|
* |
95
|
|
|
* @return ArrayCollection|array |
96
|
17 |
|
*/ |
97
|
17 |
|
public function findProductsWithSortedClassCategories(array $ids, $indexBy = null) |
98
|
|
|
{ |
99
|
|
|
if (count($ids) < 1) { |
100
|
17 |
|
return []; |
101
|
17 |
|
} |
102
|
3 |
|
$qb = $this->createQueryBuilder('p', $indexBy); |
103
|
3 |
|
$qb->addSelect(['pc', 'cc1', 'cc2', 'pi', 'pt', 'tr', 'ps']) |
104
|
|
|
->innerJoin('p.ProductClasses', 'pc') |
105
|
3 |
|
// XXX Joined 'TaxRule' and 'ProductStock' to prevent lazy loading |
106
|
3 |
|
->leftJoin('pc.TaxRule', 'tr') |
107
|
3 |
|
->innerJoin('pc.ProductStock', 'ps') |
108
|
3 |
|
->leftJoin('pc.ClassCategory1', 'cc1') |
109
|
3 |
|
->leftJoin('pc.ClassCategory2', 'cc2') |
110
|
|
|
->leftJoin('p.ProductImage', 'pi') |
111
|
|
|
->leftJoin('p.ProductTag', 'pt') |
112
|
|
|
->where($qb->expr()->in('p.id', $ids)) |
113
|
|
|
->andWhere('pc.visible = :visible') |
114
|
17 |
|
->setParameter('visible', true) |
115
|
2 |
|
->orderBy('cc1.sort_no', 'DESC') |
116
|
|
|
->addOrderBy('cc2.sort_no', 'DESC'); |
117
|
2 |
|
|
118
|
2 |
|
$products = $qb |
119
|
|
|
->getQuery() |
120
|
2 |
|
->useResultCache(true, $this->eccubeConfig['eccube_result_cache_lifetime_short']) |
121
|
|
|
->getResult(); |
122
|
|
|
|
123
|
2 |
|
return $products; |
124
|
2 |
|
} |
125
|
|
|
|
126
|
|
|
/** |
127
|
|
|
* get query builder. |
128
|
|
|
* |
129
|
|
|
* @param array $searchData |
130
|
17 |
|
* |
131
|
17 |
|
* @return \Doctrine\ORM\QueryBuilder |
132
|
|
|
*/ |
133
|
5 |
|
public function getQueryBuilderBySearchData($searchData) |
134
|
5 |
|
{ |
135
|
5 |
|
$qb = $this->createQueryBuilder('p') |
136
|
5 |
|
->andWhere('p.Status = 1'); |
137
|
5 |
|
|
138
|
5 |
|
// category |
139
|
|
|
$categoryJoin = false; |
140
|
12 |
View Code Duplication |
if (!empty($searchData['category_id']) && $searchData['category_id']) { |
141
|
1 |
|
$Categories = $searchData['category_id']->getSelfAndDescendants(); |
142
|
1 |
|
if ($Categories) { |
143
|
1 |
|
$qb |
144
|
1 |
|
->innerJoin('p.ProductCategories', 'pct') |
145
|
1 |
|
->innerJoin('pct.Category', 'c') |
146
|
1 |
|
->andWhere($qb->expr()->in('pct.Category', ':Categories')) |
147
|
|
|
->setParameter('Categories', $Categories); |
148
|
11 |
|
$categoryJoin = true; |
149
|
|
|
} |
150
|
|
|
} |
151
|
4 |
|
|
152
|
|
|
// name |
153
|
|
|
if (isset($searchData['name']) && StringUtil::isNotBlank($searchData['name'])) { |
154
|
|
|
$keywords = preg_split('/[\s ]+/u', str_replace(['%', '_'], ['\\%', '\\_'], $searchData['name']), -1, PREG_SPLIT_NO_EMPTY); |
155
|
4 |
|
|
156
|
4 |
|
foreach ($keywords as $index => $keyword) { |
157
|
|
|
$key = sprintf('keyword%s', $index); |
158
|
7 |
|
$qb |
159
|
|
|
->andWhere(sprintf('NORMALIZE(p.name) LIKE NORMALIZE(:%s) OR |
160
|
5 |
|
NORMALIZE(p.search_word) LIKE NORMALIZE(:%s) OR |
161
|
5 |
|
EXISTS (SELECT wpc%d FROM \Eccube\Entity\ProductClass wpc%d WHERE p = wpc%d.Product AND NORMALIZE(wpc%d.code) LIKE NORMALIZE(:%s))', |
162
|
|
|
$key, $key, $index, $index, $index, $index, $key)) |
163
|
|
|
->setParameter($key, '%'.$keyword.'%'); |
164
|
7 |
|
} |
165
|
|
|
} |
166
|
|
|
|
167
|
17 |
|
// Order By |
168
|
|
|
// 価格低い順 |
169
|
|
|
$config = $this->eccubeConfig; |
170
|
|
|
if (!empty($searchData['orderby']) && $searchData['orderby']->getId() == $config['eccube_product_order_price_lower']) { |
171
|
|
|
//@see http://doctrine-orm.readthedocs.org/en/latest/reference/dql-doctrine-query-language.html |
172
|
|
|
$qb->addSelect('MIN(pc.price02) as HIDDEN price02_min'); |
173
|
|
|
$qb->innerJoin('p.ProductClasses', 'pc'); |
174
|
|
|
$qb->andWhere('pc.visible = true'); |
175
|
|
|
$qb->groupBy('p.id'); |
176
|
|
|
$qb->orderBy('price02_min', 'ASC'); |
177
|
20 |
|
$qb->addOrderBy('p.id', 'DESC'); |
178
|
|
|
// 価格高い順 |
179
|
20 |
|
} elseif (!empty($searchData['orderby']) && $searchData['orderby']->getId() == $config['eccube_product_order_price_higher']) { |
180
|
20 |
|
$qb->addSelect('MAX(pc.price02) as HIDDEN price02_max'); |
181
|
|
|
$qb->innerJoin('p.ProductClasses', 'pc'); |
182
|
|
|
$qb->andWhere('pc.visible = true'); |
183
|
20 |
|
$qb->groupBy('p.id'); |
184
|
6 |
|
$qb->orderBy('price02_max', 'DESC'); |
185
|
|
|
$qb->addOrderBy('p.id', 'DESC'); |
186
|
6 |
|
// 新着順 |
187
|
6 |
|
} elseif (!empty($searchData['orderby']) && $searchData['orderby']->getId() == $config['eccube_product_order_newer']) { |
188
|
6 |
|
// 在庫切れ商品非表示の設定が有効時対応 |
189
|
|
|
// @see https://github.com/EC-CUBE/ec-cube/issues/1998 |
190
|
|
|
if ($this->getEntityManager()->getFilters()->isEnabled('option_nostock_hidden') == true) { |
|
|
|
|
191
|
|
|
$qb->innerJoin('p.ProductClasses', 'pc'); |
192
|
|
|
$qb->andWhere('pc.visible = true'); |
193
|
|
|
} |
194
|
|
|
$qb->orderBy('p.create_date', 'DESC'); |
195
|
|
|
$qb->addOrderBy('p.id', 'DESC'); |
196
|
|
|
} else { |
197
|
|
|
if ($categoryJoin === false) { |
198
|
|
|
$qb |
199
|
|
|
->leftJoin('p.ProductCategories', 'pct') |
200
|
|
|
->leftJoin('pct.Category', 'c'); |
201
|
|
|
} |
202
|
|
|
$qb |
203
|
|
|
->addOrderBy('p.id', 'DESC'); |
204
|
|
|
} |
205
|
|
|
|
206
|
|
|
return $this->queries->customize(QueryKey::PRODUCT_SEARCH, $qb, $searchData); |
207
|
|
|
} |
208
|
|
|
|
209
|
|
|
/** |
210
|
|
|
* get query builder. |
211
|
|
|
* |
212
|
20 |
|
* @param array $searchData |
213
|
2 |
|
* |
214
|
2 |
|
* @return \Doctrine\ORM\QueryBuilder |
215
|
|
|
*/ |
216
|
2 |
|
public function getQueryBuilderBySearchDataForAdmin($searchData) |
217
|
2 |
|
{ |
218
|
2 |
|
$qb = $this->createQueryBuilder('p') |
219
|
2 |
|
->addSelect('pc', 'pi', 'tr', 'ps') |
220
|
|
|
->innerJoin('p.ProductClasses', 'pc') |
221
|
|
|
->leftJoin('p.ProductImage', 'pi') |
222
|
|
|
->leftJoin('pc.TaxRule', 'tr') |
223
|
|
|
->leftJoin('pc.ProductStock', 'ps'); |
224
|
20 |
|
|
225
|
|
|
// id |
226
|
2 |
|
if (isset($searchData['id']) && StringUtil::isNotBlank($searchData['id'])) { |
227
|
2 |
|
$id = preg_match('/^\d{0,10}$/', $searchData['id']) ? $searchData['id'] : null; |
228
|
|
|
$qb |
229
|
|
|
->andWhere('p.id = :id OR p.name LIKE :likeid OR pc.code LIKE :likeid') |
230
|
|
|
->setParameter('id', $id) |
231
|
20 |
|
->setParameter('likeid', '%'.str_replace(['%', '_'], ['\\%', '\\_'], $searchData['id']).'%'); |
232
|
|
|
} |
233
|
1 |
|
|
234
|
1 |
|
// code |
235
|
|
|
/* |
236
|
|
|
if (!empty($searchData['code']) && $searchData['code']) { |
237
|
|
|
$qb |
238
|
20 |
|
->innerJoin('p.ProductClasses', 'pc') |
239
|
|
|
->andWhere('pc.code LIKE :code') |
240
|
|
|
->setParameter('code', '%' . $searchData['code'] . '%'); |
241
|
|
|
} |
242
|
|
|
|
243
|
|
|
// name |
244
|
|
|
if (!empty($searchData['name']) && $searchData['name']) { |
245
|
20 |
|
$keywords = preg_split('/[\s ]+/u', $searchData['name'], -1, PREG_SPLIT_NO_EMPTY); |
246
|
3 |
|
foreach ($keywords as $keyword) { |
247
|
3 |
|
$qb |
248
|
1 |
|
->andWhere('p.name LIKE :name') |
249
|
1 |
|
->setParameter('name', '%' . $keyword . '%'); |
250
|
2 |
|
} |
251
|
2 |
|
} |
252
|
2 |
|
*/ |
253
|
|
|
|
254
|
|
|
// category |
255
|
|
View Code Duplication |
if (!empty($searchData['category_id']) && $searchData['category_id']) { |
256
|
|
|
$Categories = $searchData['category_id']->getSelfAndDescendants(); |
257
|
|
|
if ($Categories) { |
258
|
|
|
$qb |
259
|
20 |
|
->innerJoin('p.ProductCategories', 'pct') |
260
|
1 |
|
->innerJoin('pct.Category', 'c') |
261
|
|
|
->andWhere($qb->expr()->in('pct.Category', ':Categories')) |
262
|
1 |
|
->setParameter('Categories', $Categories); |
263
|
1 |
|
} |
264
|
|
|
} |
265
|
|
|
|
266
|
20 |
|
// status |
267
|
1 |
View Code Duplication |
if (!empty($searchData['status']) && $searchData['status']) { |
268
|
|
|
$qb |
269
|
1 |
|
->andWhere($qb->expr()->in('p.Status', ':Status')) |
270
|
|
|
->setParameter('Status', $searchData['status']); |
271
|
1 |
|
} |
272
|
1 |
|
|
273
|
|
|
// link_status |
274
|
|
View Code Duplication |
if (isset($searchData['link_status']) && !empty($searchData['link_status'])) { |
275
|
|
|
$qb |
276
|
20 |
|
->andWhere($qb->expr()->in('p.Status', ':Status')) |
277
|
1 |
|
->setParameter('Status', $searchData['link_status']); |
278
|
|
|
} |
279
|
1 |
|
|
280
|
1 |
|
// stock status |
281
|
|
|
if (isset($searchData['stock_status'])) { |
282
|
20 |
|
$qb |
283
|
1 |
|
->andWhere('pc.stock_unlimited = :StockUnlimited AND pc.stock = 0') |
284
|
|
|
->setParameter('StockUnlimited', $searchData['stock_status']); |
285
|
1 |
|
} |
286
|
|
|
|
287
|
1 |
|
// stock status |
288
|
1 |
|
if (isset($searchData['stock']) && !empty($searchData['stock'])) { |
289
|
|
|
switch ($searchData['stock']) { |
290
|
|
|
case [ProductStock::IN_STOCK]: |
291
|
|
|
$qb->andWhere('pc.stock_unlimited = true OR pc.stock > 0'); |
292
|
|
|
break; |
293
|
20 |
|
case [ProductStock::OUT_OF_STOCK]: |
294
|
|
|
$qb->andWhere('pc.stock_unlimited = false AND pc.stock <= 0'); |
295
|
20 |
|
break; |
296
|
|
|
default: |
297
|
|
|
// 共に選択された場合は全権該当するので検索条件に含めない |
298
|
|
|
} |
299
|
|
|
} |
300
|
|
|
|
301
|
|
|
// crate_date |
302
|
|
View Code Duplication |
if (!empty($searchData['create_date_start']) && $searchData['create_date_start']) { |
303
|
|
|
$date = $searchData['create_date_start']; |
304
|
|
|
$qb |
305
|
|
|
->andWhere('p.create_date >= :create_date_start') |
306
|
|
|
->setParameter('create_date_start', $date); |
307
|
|
|
} |
308
|
|
|
|
309
|
|
View Code Duplication |
if (!empty($searchData['create_date_end']) && $searchData['create_date_end']) { |
310
|
|
|
$date = clone $searchData['create_date_end']; |
311
|
|
|
$date = $date |
312
|
|
|
->modify('+1 days'); |
313
|
|
|
$qb |
314
|
|
|
->andWhere('p.create_date < :create_date_end') |
315
|
|
|
->setParameter('create_date_end', $date); |
316
|
|
|
} |
317
|
|
|
|
318
|
|
|
// update_date |
319
|
|
View Code Duplication |
if (!empty($searchData['update_date_start']) && $searchData['update_date_start']) { |
320
|
|
|
$date = $searchData['update_date_start']; |
321
|
|
|
$qb |
322
|
|
|
->andWhere('p.update_date >= :update_date_start') |
323
|
|
|
->setParameter('update_date_start', $date); |
324
|
|
|
} |
325
|
|
View Code Duplication |
if (!empty($searchData['update_date_end']) && $searchData['update_date_end']) { |
326
|
|
|
$date = clone $searchData['update_date_end']; |
327
|
|
|
$date = $date |
328
|
|
|
->modify('+1 days'); |
329
|
|
|
$qb |
330
|
|
|
->andWhere('p.update_date < :update_date_end') |
331
|
|
|
->setParameter('update_date_end', $date); |
332
|
|
|
} |
333
|
|
|
|
334
|
|
|
// Order By |
335
|
|
|
$qb |
336
|
|
|
->orderBy('p.update_date', 'DESC'); |
337
|
|
|
|
338
|
|
|
return $this->queries->customize(QueryKey::PRODUCT_SEARCH_ADMIN, $qb, $searchData); |
339
|
|
|
} |
340
|
|
|
} |
341
|
|
|
|
When comparing two booleans, it is generally considered safer to use the strict comparison operator.