This project does not seem to handle request data directly as such no vulnerable execution paths were found.
include
, or for example
via PHP's auto-loading mechanism.
These results are based on our legacy PHP analysis, consider migrating to our new PHP analysis engine instead. Learn more
1 | <?php |
||
2 | /* |
||
3 | * This file is part of EC-CUBE |
||
4 | * |
||
5 | * Copyright(c) 2000-2015 LOCKON CO.,LTD. All Rights Reserved. |
||
6 | * |
||
7 | * http://www.lockon.co.jp/ |
||
8 | * |
||
9 | * This program is free software; you can redistribute it and/or |
||
10 | * modify it under the terms of the GNU General Public License |
||
11 | * as published by the Free Software Foundation; either version 2 |
||
12 | * of the License, or (at your option) any later version. |
||
13 | * |
||
14 | * This program is distributed in the hope that it will be useful, |
||
15 | * but WITHOUT ANY WARRANTY; without even the implied warranty of |
||
16 | * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
||
17 | * GNU General Public License for more details. |
||
18 | * |
||
19 | * You should have received a copy of the GNU General Public License |
||
20 | * along with this program; if not, write to the Free Software |
||
21 | * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. |
||
22 | */ |
||
23 | |||
24 | |||
25 | namespace Eccube\Repository; |
||
26 | |||
27 | use Eccube\Util\Str; |
||
28 | use Doctrine\ORM\EntityRepository; |
||
29 | use Doctrine\ORM\QueryBuilder; |
||
30 | |||
31 | /** |
||
32 | * OrderRepository |
||
33 | * |
||
34 | * This class was generated by the Doctrine ORM. Add your own custom |
||
35 | * repository methods below. |
||
36 | */ |
||
37 | class OrderRepository extends EntityRepository |
||
38 | { |
||
39 | protected $app; |
||
40 | |||
41 | 194 | public function setApplication($app) |
|
42 | { |
||
43 | 194 | $this->app = $app; |
|
44 | } |
||
45 | |||
46 | 7 | public function changeStatus($orderId, \Eccube\Entity\Master\OrderStatus $Status) |
|
47 | { |
||
48 | $Order = $this |
||
49 | 7 | ->find($orderId) |
|
50 | 7 | ->setOrderStatus($Status) |
|
51 | ; |
||
52 | |||
53 | 7 | switch ($Status->getId()) { |
|
54 | 7 | case '5': // 発送済へ |
|
55 | 3 | $Order->setCommitDate(new \DateTime()); |
|
56 | 3 | break; |
|
57 | 4 | case '6': // 入金済へ |
|
58 | 3 | $Order->setPaymentDate(new \DateTime()); |
|
59 | 7 | break; |
|
60 | } |
||
61 | |||
62 | 7 | $em = $this->getEntityManager(); |
|
63 | 7 | $em->persist($Order); |
|
64 | 7 | $em->flush(); |
|
65 | } |
||
66 | |||
67 | /** |
||
68 | * |
||
69 | * @param array $searchData |
||
0 ignored issues
–
show
introduced
by
Loading history...
|
|||
70 | * @return QueryBuilder |
||
71 | */ |
||
72 | 19 | public function getQueryBuilderBySearchData($searchData) |
|
73 | { |
||
74 | 19 | $qb = $this->createQueryBuilder('o'); |
|
75 | |||
76 | 19 | $joinedCustomer = false; |
|
77 | |||
78 | // order_id_start |
||
79 | 19 | View Code Duplication | if (isset($searchData['order_id_start']) && Str::isNotBlank($searchData['order_id_start'])) { |
80 | $qb |
||
81 | 1 | ->andWhere('o.id >= :order_id_start') |
|
82 | 1 | ->setParameter('order_id_start', $searchData['order_id_start']); |
|
83 | } |
||
84 | |||
85 | // order_id_end |
||
86 | 19 | View Code Duplication | if (isset($searchData['order_id_end']) && Str::isNotBlank($searchData['order_id_end'])) { |
87 | $qb |
||
88 | 1 | ->andWhere('o.id <= :order_id_end') |
|
89 | 1 | ->setParameter('order_id_end', $searchData['order_id_end']); |
|
90 | } |
||
91 | |||
92 | // status |
||
93 | 19 | if (!empty($searchData['status']) && $searchData['status']) { |
|
94 | $qb |
||
95 | 1 | ->andWhere('o.OrderStatus = :status') |
|
96 | 1 | ->setParameter('status', $searchData['status']); |
|
97 | } |
||
98 | |||
99 | // name |
||
100 | 19 | View Code Duplication | if (isset($searchData['name']) && Str::isNotBlank($searchData['name'])) { |
101 | $qb |
||
102 | 1 | ->andWhere('CONCAT(o.name01, o.name02) LIKE :name') |
|
103 | 1 | ->setParameter('name', '%' . $searchData['name'] . '%'); |
|
104 | } |
||
105 | |||
106 | // kana |
||
107 | 19 | View Code Duplication | if (isset($searchData['kana']) && Str::isNotBlank($searchData['kana'])) { |
108 | $qb |
||
109 | 1 | ->andWhere('CONCAT(o.kana01, o.kana02) LIKE :kana') |
|
110 | 1 | ->setParameter('kana', '%' . $searchData['kana'] . '%'); |
|
111 | } |
||
112 | |||
113 | |||
114 | 19 | View Code Duplication | if (isset($searchData['email']) && Str::isNotBlank($searchData['email'])) { |
115 | $qb |
||
116 | 1 | ->andWhere('o.email = :email') |
|
117 | 1 | ->setParameter('email', $searchData['email']); |
|
118 | } |
||
119 | |||
120 | // tel |
||
121 | 19 | View Code Duplication | if (isset($searchData['tel01']) && Str::isNotBlank($searchData['tel01'])) { |
122 | $qb |
||
123 | 1 | ->andWhere('o.tel01 = :tel01') |
|
124 | 1 | ->setParameter('tel01', $searchData['tel01']); |
|
125 | } |
||
126 | 19 | View Code Duplication | if (isset($searchData['tel02']) && Str::isNotBlank($searchData['tel02'])) { |
127 | $qb |
||
128 | 1 | ->andWhere('o.tel02 = :tel02') |
|
129 | 1 | ->setParameter('tel02', $searchData['tel02']); |
|
130 | } |
||
131 | 19 | View Code Duplication | if (isset($searchData['tel03']) && Str::isNotBlank($searchData['tel03'])) { |
132 | $qb |
||
133 | 1 | ->andWhere('o.tel03 = :tel03') |
|
134 | 1 | ->setParameter('tel03', $searchData['tel03']); |
|
135 | } |
||
136 | |||
137 | // birth |
||
138 | 19 | View Code Duplication | if (!empty($searchData['birth_start']) && $searchData['birth_start']) { |
139 | 1 | if (!$joinedCustomer) { |
|
140 | 1 | $qb->leftJoin('o.Customer', 'c'); |
|
141 | 1 | $joinedCustomer = true; |
|
142 | } |
||
143 | |||
144 | 1 | $date = $searchData['birth_start'] |
|
145 | 1 | ->format('Y-m-d H:i:s'); |
|
146 | $qb |
||
147 | 1 | ->andWhere('c.birth >= :birth_start') |
|
148 | 1 | ->setParameter('birth_start', $date); |
|
149 | } |
||
150 | 19 | View Code Duplication | if (!empty($searchData['birth_end']) && $searchData['birth_end']) { |
151 | 1 | if (!$joinedCustomer) { |
|
152 | 1 | $qb->leftJoin('o.Customer', 'c'); |
|
153 | 1 | $joinedCustomer = true; |
|
154 | } |
||
155 | |||
156 | 1 | $date = clone $searchData['birth_end']; |
|
157 | $date = $date |
||
158 | 1 | ->modify('+1 days') |
|
159 | 1 | ->format('Y-m-d H:i:s'); |
|
160 | $qb |
||
161 | 1 | ->andWhere('c.birth < :birth_end') |
|
162 | 1 | ->setParameter('birth_end', $date); |
|
163 | } |
||
164 | |||
165 | // sex |
||
166 | 19 | if (!empty($searchData['sex']) && count($searchData['sex']) > 0) { |
|
167 | 1 | if (!$joinedCustomer) { |
|
168 | 1 | $qb->leftJoin('o.Customer', 'c'); |
|
169 | 1 | $joinedCustomer = true; |
|
170 | } |
||
171 | |||
172 | 1 | $sexs = array(); |
|
173 | 1 | foreach ($searchData['sex'] as $sex) { |
|
174 | 1 | $sexs[] = $sex->getId(); |
|
175 | } |
||
176 | |||
177 | $qb |
||
178 | 1 | ->andWhere($qb->expr()->in('c.Sex', ':sexs')) |
|
179 | 1 | ->setParameter('sexs', $sexs); |
|
180 | } |
||
181 | |||
182 | // payment |
||
183 | 19 | View Code Duplication | if (!empty($searchData['payment']) && count($searchData['payment'])) { |
184 | $payments = array(); |
||
185 | foreach ($searchData['payment'] as $payment) { |
||
186 | $payments[] = $payment->getId(); |
||
187 | } |
||
188 | $qb |
||
189 | ->leftJoin('o.Payment', 'p') |
||
190 | ->andWhere($qb->expr()->in('p.id', ':payments')) |
||
191 | ->setParameter('payments', $payments); |
||
192 | } |
||
193 | |||
194 | // oreder_date |
||
195 | 19 | View Code Duplication | if (!empty($searchData['order_date_start']) && $searchData['order_date_start']) { |
196 | 1 | $date = $searchData['order_date_start'] |
|
197 | 1 | ->format('Y-m-d H:i:s'); |
|
198 | $qb |
||
199 | 1 | ->andWhere('o.create_date >= :order_date_start') |
|
200 | 1 | ->setParameter('order_date_start', $date); |
|
201 | } |
||
202 | 19 | View Code Duplication | if (!empty($searchData['order_date_end']) && $searchData['order_date_end']) { |
203 | 1 | $date = clone $searchData['order_date_end']; |
|
204 | $date = $date |
||
205 | 1 | ->modify('+1 days') |
|
206 | 1 | ->format('Y-m-d H:i:s'); |
|
207 | $qb |
||
208 | 1 | ->andWhere('o.create_date < :order_date_end') |
|
209 | 1 | ->setParameter('order_date_end', $date); |
|
210 | } |
||
211 | |||
212 | // create_date |
||
213 | 19 | View Code Duplication | if (!empty($searchData['update_date_start']) && $searchData['update_date_start']) { |
214 | 1 | $date = $searchData['update_date_start'] |
|
215 | 1 | ->format('Y-m-d H:i:s'); |
|
216 | $qb |
||
217 | 1 | ->andWhere('o.update_date >= :update_date_start') |
|
218 | 1 | ->setParameter('update_date_start', $date); |
|
219 | } |
||
220 | 19 | View Code Duplication | if (!empty($searchData['update_date_end']) && $searchData['update_date_end']) { |
221 | 1 | $date = clone $searchData['update_date_end']; |
|
222 | $date = $date |
||
223 | 1 | ->modify('+1 days') |
|
224 | 1 | ->format('Y-m-d H:i:s'); |
|
225 | $qb |
||
226 | 1 | ->andWhere('o.update_date < :update_date_end') |
|
227 | 1 | ->setParameter('update_date_end', $date); |
|
228 | } |
||
229 | |||
230 | // payment_total |
||
231 | 19 | View Code Duplication | if (isset($searchData['payment_total_start']) && Str::isNotBlank($searchData['payment_total_start'])) { |
232 | $qb |
||
233 | 1 | ->andWhere('o.payment_total >= :payment_total_start') |
|
234 | 1 | ->setParameter('payment_total_start', $searchData['payment_total_start']); |
|
235 | } |
||
236 | 19 | View Code Duplication | if (isset($searchData['payment_total_end']) && Str::isNotBlank($searchData['payment_total_end'])) { |
237 | $qb |
||
238 | 1 | ->andWhere('o.payment_total <= :payment_total_end') |
|
239 | 1 | ->setParameter('payment_total_end', $searchData['payment_total_end']); |
|
240 | } |
||
241 | |||
242 | // buy_product_name |
||
243 | 19 | View Code Duplication | if (isset($searchData['buy_product_name']) && Str::isNotBlank($searchData['buy_product_name'])) { |
244 | $qb |
||
245 | 1 | ->leftJoin('o.OrderDetails', 'od') |
|
246 | 1 | ->andWhere('od.product_name LIKE :buy_product_name') |
|
247 | 1 | ->setParameter('buy_product_name', '%' . $searchData['buy_product_name'] . '%'); |
|
248 | } |
||
249 | |||
250 | // Order By |
||
251 | 19 | $qb->addOrderBy('o.update_date', 'DESC'); |
|
252 | |||
253 | 19 | return $qb; |
|
254 | } |
||
255 | |||
256 | |||
257 | /** |
||
258 | * |
||
259 | * @param array $searchData |
||
0 ignored issues
–
show
|
|||
260 | * @return QueryBuilder |
||
261 | */ |
||
262 | 32 | public function getQueryBuilderBySearchDataForAdmin($searchData) |
|
263 | { |
||
264 | 32 | $qb = $this->createQueryBuilder('o'); |
|
265 | |||
266 | // order_id_start |
||
267 | 32 | View Code Duplication | if (isset($searchData['order_id_start']) && Str::isNotBlank($searchData['order_id_start'])) { |
268 | $qb |
||
269 | 1 | ->andWhere('o.id >= :order_id_start') |
|
270 | 1 | ->setParameter('order_id_start', $searchData['order_id_start']); |
|
271 | } |
||
272 | // multi |
||
273 | 32 | View Code Duplication | if (isset( $searchData['multi']) && Str::isNotBlank($searchData['multi'])) { |
274 | 5 | $multi = preg_match('/^\d+$/', $searchData['multi']) ? $searchData['multi'] : null; |
|
275 | $qb |
||
276 | 5 | ->andWhere('o.id = :multi OR o.name01 LIKE :likemulti OR o.name02 LIKE :likemulti OR ' . |
|
277 | 5 | 'o.kana01 LIKE :likemulti OR o.kana02 LIKE :likemulti OR o.company_name LIKE :likemulti') |
|
278 | 5 | ->setParameter('multi', $multi) |
|
279 | 5 | ->setParameter('likemulti', '%' . $searchData['multi'] . '%'); |
|
280 | } |
||
281 | |||
282 | // order_id_end |
||
283 | 32 | View Code Duplication | if (isset($searchData['order_id_end']) && Str::isNotBlank($searchData['order_id_end'])) { |
284 | $qb |
||
285 | 1 | ->andWhere('o.id <= :order_id_end') |
|
286 | 1 | ->setParameter('order_id_end', $searchData['order_id_end']); |
|
287 | } |
||
288 | |||
289 | // status |
||
290 | 32 | $filterStatus = false; |
|
291 | 32 | View Code Duplication | if (!empty($searchData['status']) && $searchData['status']) { |
292 | $qb |
||
293 | 3 | ->andWhere('o.OrderStatus = :status') |
|
294 | 3 | ->setParameter('status', $searchData['status']); |
|
295 | 3 | $filterStatus = true; |
|
296 | } |
||
297 | 32 | if (!empty($searchData['multi_status']) && count($searchData['multi_status'])) { |
|
298 | $qb |
||
299 | 1 | ->andWhere($qb->expr()->in('o.OrderStatus', ':multi_status')) |
|
300 | 1 | ->setParameter('multi_status', $searchData['multi_status']->toArray()); |
|
301 | 1 | $filterStatus = true; |
|
302 | } |
||
303 | 32 | if (!$filterStatus) { |
|
304 | // 購入処理中は検索対象から除外 |
||
305 | 28 | $OrderStatuses = $this->getEntityManager() |
|
306 | 28 | ->getRepository('Eccube\Entity\Master\OrderStatus') |
|
307 | 28 | ->findNotContainsBy(array('id' => $this->app['config']['order_processing'])); |
|
308 | 28 | $qb->andWhere($qb->expr()->in('o.OrderStatus', ':status')) |
|
309 | 28 | ->setParameter('status', $OrderStatuses); |
|
310 | } |
||
311 | |||
312 | // name |
||
313 | 32 | View Code Duplication | if (isset($searchData['name']) && Str::isNotBlank($searchData['name'])) { |
314 | $qb |
||
315 | 1 | ->andWhere('CONCAT(o.name01, o.name02) LIKE :name') |
|
316 | 1 | ->setParameter('name', '%' . $searchData['name'] . '%'); |
|
317 | } |
||
318 | |||
319 | // kana |
||
320 | 32 | View Code Duplication | if (isset($searchData['kana']) && Str::isNotBlank($searchData['kana'])) { |
321 | $qb |
||
322 | 1 | ->andWhere('CONCAT(o.kana01, o.kana02) LIKE :kana') |
|
323 | 1 | ->setParameter('kana', '%' . $searchData['kana'] . '%'); |
|
324 | } |
||
325 | |||
326 | |||
327 | 32 | View Code Duplication | if (isset($searchData['email']) && Str::isNotBlank($searchData['email'])) { |
328 | $qb |
||
329 | 2 | ->andWhere('o.email like :email') |
|
330 | 2 | ->setParameter('email', '%' . $searchData['email'] . '%'); |
|
331 | } |
||
332 | |||
333 | // tel |
||
334 | 32 | View Code Duplication | if (isset($searchData['tel']) && Str::isNotBlank($searchData['tel'])) { |
335 | $qb |
||
336 | 1 | ->andWhere('CONCAT(o.tel01, o.tel02, o.tel03) LIKE :tel') |
|
337 | 1 | ->setParameter('tel', '%' . $searchData['tel'] . '%'); |
|
0 ignored issues
–
show
|
|||
338 | } |
||
339 | |||
340 | // sex |
||
341 | 32 | if (!empty($searchData['sex']) && count($searchData['sex']) > 0) { |
|
342 | $qb |
||
343 | 3 | ->andWhere($qb->expr()->in('o.Sex', ':sex')) |
|
344 | 3 | ->setParameter('sex', $searchData['sex']->toArray()); |
|
345 | } |
||
346 | |||
347 | // payment |
||
348 | 32 | View Code Duplication | if (!empty($searchData['payment']) && count($searchData['payment'])) { |
349 | 2 | $payments = array(); |
|
350 | 2 | foreach ($searchData['payment'] as $payment) { |
|
351 | 2 | $payments[] = $payment->getId(); |
|
352 | } |
||
353 | $qb |
||
354 | 2 | ->leftJoin('o.Payment', 'p') |
|
355 | 2 | ->andWhere($qb->expr()->in('p.id', ':payments')) |
|
356 | 2 | ->setParameter('payments', $payments); |
|
357 | } |
||
358 | |||
359 | // oreder_date |
||
360 | 32 | View Code Duplication | if (!empty($searchData['order_date_start']) && $searchData['order_date_start']) { |
361 | 1 | $date = $searchData['order_date_start'] |
|
362 | 1 | ->format('Y-m-d H:i:s'); |
|
363 | $qb |
||
364 | 1 | ->andWhere('o.order_date >= :order_date_start') |
|
365 | 1 | ->setParameter('order_date_start', $date); |
|
366 | } |
||
367 | 32 | View Code Duplication | if (!empty($searchData['order_date_end']) && $searchData['order_date_end']) { |
368 | 1 | $date = clone $searchData['order_date_end']; |
|
369 | $date = $date |
||
370 | 1 | ->modify('+1 days') |
|
371 | 1 | ->format('Y-m-d H:i:s'); |
|
372 | $qb |
||
373 | 1 | ->andWhere('o.order_date < :order_date_end') |
|
374 | 1 | ->setParameter('order_date_end', $date); |
|
375 | } |
||
376 | |||
377 | // payment_date |
||
378 | 32 | View Code Duplication | if (!empty($searchData['payment_date_start']) && $searchData['payment_date_start']) { |
379 | 1 | $date = $searchData['payment_date_start'] |
|
380 | 1 | ->format('Y-m-d H:i:s'); |
|
381 | $qb |
||
382 | 1 | ->andWhere('o.payment_date >= :payment_date_start') |
|
383 | 1 | ->setParameter('payment_date_start', $date); |
|
384 | } |
||
385 | 32 | View Code Duplication | if (!empty($searchData['payment_date_end']) && $searchData['payment_date_end']) { |
386 | 1 | $date = clone $searchData['payment_date_end']; |
|
387 | $date = $date |
||
388 | 1 | ->modify('+1 days') |
|
389 | 1 | ->format('Y-m-d H:i:s'); |
|
390 | $qb |
||
391 | 1 | ->andWhere('o.payment_date < :payment_date_end') |
|
392 | 1 | ->setParameter('payment_date_end', $date); |
|
393 | } |
||
394 | |||
395 | // commit_date |
||
396 | 32 | View Code Duplication | if (!empty($searchData['commit_date_start']) && $searchData['commit_date_start']) { |
397 | 1 | $date = $searchData['commit_date_start'] |
|
398 | 1 | ->format('Y-m-d H:i:s'); |
|
399 | $qb |
||
400 | 1 | ->andWhere('o.commit_date >= :commit_date_start') |
|
401 | 1 | ->setParameter('commit_date_start', $date); |
|
402 | } |
||
403 | 32 | View Code Duplication | if (!empty($searchData['commit_date_end']) && $searchData['commit_date_end']) { |
404 | 1 | $date = clone $searchData['commit_date_end']; |
|
405 | $date = $date |
||
406 | 1 | ->modify('+1 days') |
|
407 | 1 | ->format('Y-m-d H:i:s'); |
|
408 | $qb |
||
409 | 1 | ->andWhere('o.commit_date < :commit_date_end') |
|
410 | 1 | ->setParameter('commit_date_end', $date); |
|
411 | } |
||
412 | |||
413 | |||
414 | // update_date |
||
415 | 32 | View Code Duplication | if (!empty($searchData['update_date_start']) && $searchData['update_date_start']) { |
416 | 1 | $date = $searchData['update_date_start'] |
|
417 | 1 | ->format('Y-m-d H:i:s'); |
|
418 | $qb |
||
419 | 1 | ->andWhere('o.update_date >= :update_date_start') |
|
420 | 1 | ->setParameter('update_date_start', $date); |
|
421 | } |
||
422 | 32 | View Code Duplication | if (!empty($searchData['update_date_end']) && $searchData['update_date_end']) { |
423 | 1 | $date = clone $searchData['update_date_end']; |
|
424 | $date = $date |
||
425 | 1 | ->modify('+1 days') |
|
426 | 1 | ->format('Y-m-d H:i:s'); |
|
427 | $qb |
||
428 | 1 | ->andWhere('o.update_date < :update_date_end') |
|
429 | 1 | ->setParameter('update_date_end', $date); |
|
430 | } |
||
431 | |||
432 | // payment_total |
||
433 | 32 | View Code Duplication | if (isset($searchData['payment_total_start']) && Str::isNotBlank($searchData['payment_total_start'])) { |
434 | $qb |
||
435 | 1 | ->andWhere('o.payment_total >= :payment_total_start') |
|
436 | 1 | ->setParameter('payment_total_start', $searchData['payment_total_start']); |
|
437 | } |
||
438 | 32 | View Code Duplication | if (isset($searchData['payment_total_end']) && Str::isNotBlank($searchData['payment_total_end'])) { |
439 | $qb |
||
440 | 1 | ->andWhere('o.payment_total <= :payment_total_end') |
|
441 | 1 | ->setParameter('payment_total_end', $searchData['payment_total_end']); |
|
442 | } |
||
443 | |||
444 | // buy_product_name |
||
445 | 32 | View Code Duplication | if (isset($searchData['buy_product_name']) && Str::isNotBlank($searchData['buy_product_name'])) { |
446 | $qb |
||
447 | 1 | ->leftJoin('o.OrderDetails', 'od') |
|
448 | 1 | ->andWhere('od.product_name LIKE :buy_product_name') |
|
449 | 1 | ->setParameter('buy_product_name', '%' . $searchData['buy_product_name'] . '%'); |
|
450 | } |
||
451 | |||
452 | // Order By |
||
453 | 32 | $qb->orderBy('o.update_date', 'DESC'); |
|
454 | 32 | $qb->addorderBy('o.id', 'DESC'); |
|
455 | |||
456 | 32 | return $qb; |
|
457 | } |
||
458 | |||
459 | |||
460 | /** |
||
461 | * @param \Eccube\Entity\Customer $Customer |
||
462 | * @return QueryBuilder |
||
463 | */ |
||
464 | 10 | public function getQueryBuilderByCustomer(\Eccube\Entity\Customer $Customer) |
|
465 | { |
||
466 | 10 | $qb = $this->createQueryBuilder('o') |
|
467 | 10 | ->where('o.Customer = :Customer') |
|
468 | 10 | ->setParameter('Customer', $Customer); |
|
469 | |||
470 | // Order By |
||
471 | 10 | $qb->addOrderBy('o.id', 'DESC'); |
|
472 | |||
473 | 10 | return $qb; |
|
474 | } |
||
475 | |||
476 | /** |
||
477 | * 新規受付一覧の取得 |
||
478 | * |
||
479 | * @return \Eccube\Entity\Order[] |
||
480 | */ |
||
481 | 1 | public function getNew() |
|
482 | { |
||
483 | 1 | $qb = $this->createQueryBuilder('o'); |
|
484 | $qb |
||
485 | 1 | ->where('o.OrderStatus <> :OrderStatus') |
|
486 | 1 | ->setParameter('OrderStatus', $this->app['config']['order_cancel']) |
|
487 | 1 | ->setMaxResults(10) |
|
488 | 1 | ->orderBy('o.create_date', 'DESC'); |
|
489 | |||
490 | return $qb |
||
491 | 1 | ->getQuery() |
|
492 | 1 | ->getResult(); |
|
493 | } |
||
494 | |||
495 | /** |
||
496 | * 会員の合計購入金額を取得、回数を取得 |
||
497 | * |
||
498 | * @param \Eccube\Entity\Customer $Customer |
||
499 | * @param array $OrderStatuses |
||
500 | * @return QueryBuilder |
||
501 | */ |
||
502 | 16 | public function getCustomerCount(\Eccube\Entity\Customer $Customer, array $OrderStatuses) |
|
503 | { |
||
504 | 16 | $result = $this->createQueryBuilder('o') |
|
505 | 16 | ->select('COUNT(o.id) AS buy_times, SUM(o.total) AS buy_total') |
|
506 | 16 | ->where('o.Customer = :Customer') |
|
507 | 16 | ->andWhere('o.OrderStatus in (:OrderStatuses)') |
|
508 | 16 | ->setParameter('Customer', $Customer) |
|
509 | 16 | ->setParameter('OrderStatuses', $OrderStatuses) |
|
510 | 16 | ->groupBy('o.id') |
|
511 | 16 | ->orderBy('o.id', 'ASC') |
|
512 | 16 | ->getQuery() |
|
513 | 16 | ->getResult(); |
|
514 | |||
515 | 16 | return $result; |
|
516 | } |
||
517 | } |
||
518 |