@@ -153,9 +153,9 @@ discard block |
||
| 153 | 153 | $qb |
| 154 | 154 | ->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') |
| 155 | 155 | ->setParameter('customer_id', $id) |
| 156 | - ->setParameter('name', '%' . $clean_key_multi . '%') |
|
| 157 | - ->setParameter('kana', '%' . $clean_key_multi . '%') |
|
| 158 | - ->setParameter('email', '%' . $clean_key_multi . '%'); |
|
| 156 | + ->setParameter('name', '%'.$clean_key_multi.'%') |
|
| 157 | + ->setParameter('kana', '%'.$clean_key_multi.'%') |
|
| 158 | + ->setParameter('email', '%'.$clean_key_multi.'%'); |
|
| 159 | 159 | } |
| 160 | 160 | |
| 161 | 161 | // Pref |
@@ -205,7 +205,7 @@ discard block |
||
| 205 | 205 | if (isset($searchData['tel']) && Str::isNotBlank($searchData['tel'])) { |
| 206 | 206 | $qb |
| 207 | 207 | ->andWhere('CONCAT(c.tel01, c.tel02, c.tel03) LIKE :tel') |
| 208 | - ->setParameter('tel', '%' . $searchData['tel'] . '%'); |
|
| 208 | + ->setParameter('tel', '%'.$searchData['tel'].'%'); |
|
| 209 | 209 | } |
| 210 | 210 | |
| 211 | 211 | // buy_total |
@@ -299,7 +299,7 @@ discard block |
||
| 299 | 299 | ->leftJoin('c.Orders', 'o') |
| 300 | 300 | ->leftJoin('o.OrderDetails', 'od') |
| 301 | 301 | ->andWhere('od.product_name LIKE :buy_product_name OR od.product_code LIKE :buy_product_name') |
| 302 | - ->setParameter('buy_product_name', '%' . $searchData['buy_product_code'] . '%'); |
|
| 302 | + ->setParameter('buy_product_name', '%'.$searchData['buy_product_code'].'%'); |
|
| 303 | 303 | } |
| 304 | 304 | |
| 305 | 305 | // Order By |