@@ -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 |