@@ -155,9 +155,9 @@ discard block |
||
| 155 | 155 | $qb |
| 156 | 156 | ->andWhere('c.id = :customer_id OR CONCAT(c.name01, c.name02) LIKE :name OR CONCAT(c.kana01, c.kana02) LIKE :kana OR c.email LIKE :email') |
| 157 | 157 | ->setParameter('customer_id', $id) |
| 158 | - ->setParameter('name', '%' . $clean_key_multi . '%') |
|
| 159 | - ->setParameter('kana', '%' . $clean_key_multi . '%') |
|
| 160 | - ->setParameter('email', '%' . $clean_key_multi . '%'); |
|
| 158 | + ->setParameter('name', '%'.$clean_key_multi.'%') |
|
| 159 | + ->setParameter('kana', '%'.$clean_key_multi.'%') |
|
| 160 | + ->setParameter('email', '%'.$clean_key_multi.'%'); |
|
| 161 | 161 | } |
| 162 | 162 | |
| 163 | 163 | // Pref |
@@ -207,7 +207,7 @@ discard block |
||
| 207 | 207 | if (isset($searchData['tel']) && Str::isNotBlank($searchData['tel'])) { |
| 208 | 208 | $qb |
| 209 | 209 | ->andWhere('CONCAT(c.tel01, c.tel02, c.tel03) LIKE :tel') |
| 210 | - ->setParameter('tel', '%' . $searchData['tel'] . '%'); |
|
| 210 | + ->setParameter('tel', '%'.$searchData['tel'].'%'); |
|
| 211 | 211 | } |
| 212 | 212 | |
| 213 | 213 | // buy_total |
@@ -301,7 +301,7 @@ discard block |
||
| 301 | 301 | ->leftJoin('c.Orders', 'o') |
| 302 | 302 | ->leftJoin('o.OrderDetails', 'od') |
| 303 | 303 | ->andWhere('od.product_name LIKE :buy_product_name OR od.product_code LIKE :buy_product_name') |
| 304 | - ->setParameter('buy_product_name', '%' . $searchData['buy_product_code'] . '%'); |
|
| 304 | + ->setParameter('buy_product_name', '%'.$searchData['buy_product_code'].'%'); |
|
| 305 | 305 | } |
| 306 | 306 | |
| 307 | 307 | // Order By |
@@ -464,7 +464,7 @@ discard block |
||
| 464 | 464 | $lastBuyDate = $Customer->getLastBuyDate(); |
| 465 | 465 | $Customer->setLastBuyDate($now); |
| 466 | 466 | foreach ($excludeOrderStatuses as $excludeOrderStatus) { |
| 467 | - if ((int)$orderStatusId === (int)$excludeOrderStatus) { |
|
| 467 | + if ((int) $orderStatusId === (int) $excludeOrderStatus) { |
|
| 468 | 468 | $Customer->setLastBuyDate($lastBuyDate); |
| 469 | 469 | } |
| 470 | 470 | } |