@@ -100,14 +100,14 @@ discard block |
||
100 | 100 | if (isset($searchData['name']) && Str::isNotBlank($searchData['name'])) { |
101 | 101 | $qb |
102 | 102 | ->andWhere('CONCAT(o.name01, o.name02) LIKE :name') |
103 | - ->setParameter('name', '%' . $searchData['name'] . '%'); |
|
103 | + ->setParameter('name', '%'.$searchData['name'].'%'); |
|
104 | 104 | } |
105 | 105 | |
106 | 106 | // kana |
107 | 107 | if (isset($searchData['kana']) && Str::isNotBlank($searchData['kana'])) { |
108 | 108 | $qb |
109 | 109 | ->andWhere('CONCAT(o.kana01, o.kana02) LIKE :kana') |
110 | - ->setParameter('kana', '%' . $searchData['kana'] . '%'); |
|
110 | + ->setParameter('kana', '%'.$searchData['kana'].'%'); |
|
111 | 111 | } |
112 | 112 | |
113 | 113 | |
@@ -244,7 +244,7 @@ discard block |
||
244 | 244 | $qb |
245 | 245 | ->leftJoin('o.OrderDetails', 'od') |
246 | 246 | ->andWhere('od.product_name LIKE :buy_product_name') |
247 | - ->setParameter('buy_product_name', '%' . $searchData['buy_product_name'] . '%'); |
|
247 | + ->setParameter('buy_product_name', '%'.$searchData['buy_product_name'].'%'); |
|
248 | 248 | } |
249 | 249 | |
250 | 250 | // Order By |
@@ -270,13 +270,13 @@ discard block |
||
270 | 270 | ->setParameter('order_id_start', $searchData['order_id_start']); |
271 | 271 | } |
272 | 272 | // multi |
273 | - if (isset( $searchData['multi']) && Str::isNotBlank($searchData['multi'])) { |
|
273 | + if (isset($searchData['multi']) && Str::isNotBlank($searchData['multi'])) { |
|
274 | 274 | $multi = preg_match('/^\d+$/', $searchData['multi']) ? $searchData['multi'] : null; |
275 | 275 | $qb |
276 | - ->andWhere('o.id = :multi OR o.name01 LIKE :likemulti OR o.name02 LIKE :likemulti OR ' . |
|
276 | + ->andWhere('o.id = :multi OR o.name01 LIKE :likemulti OR o.name02 LIKE :likemulti OR '. |
|
277 | 277 | 'o.kana01 LIKE :likemulti OR o.kana02 LIKE :likemulti OR o.company_name LIKE :likemulti') |
278 | 278 | ->setParameter('multi', $multi) |
279 | - ->setParameter('likemulti', '%' . $searchData['multi'] . '%'); |
|
279 | + ->setParameter('likemulti', '%'.$searchData['multi'].'%'); |
|
280 | 280 | } |
281 | 281 | |
282 | 282 | // order_id_end |
@@ -313,28 +313,28 @@ discard block |
||
313 | 313 | if (isset($searchData['name']) && Str::isNotBlank($searchData['name'])) { |
314 | 314 | $qb |
315 | 315 | ->andWhere('CONCAT(o.name01, o.name02) LIKE :name') |
316 | - ->setParameter('name', '%' . $searchData['name'] . '%'); |
|
316 | + ->setParameter('name', '%'.$searchData['name'].'%'); |
|
317 | 317 | } |
318 | 318 | |
319 | 319 | // kana |
320 | 320 | if (isset($searchData['kana']) && Str::isNotBlank($searchData['kana'])) { |
321 | 321 | $qb |
322 | 322 | ->andWhere('CONCAT(o.kana01, o.kana02) LIKE :kana') |
323 | - ->setParameter('kana', '%' . $searchData['kana'] . '%'); |
|
323 | + ->setParameter('kana', '%'.$searchData['kana'].'%'); |
|
324 | 324 | } |
325 | 325 | |
326 | 326 | |
327 | 327 | if (isset($searchData['email']) && Str::isNotBlank($searchData['email'])) { |
328 | 328 | $qb |
329 | 329 | ->andWhere('o.email like :email') |
330 | - ->setParameter('email', '%' . $searchData['email'] . '%'); |
|
330 | + ->setParameter('email', '%'.$searchData['email'].'%'); |
|
331 | 331 | } |
332 | 332 | |
333 | 333 | // tel |
334 | 334 | if (isset($searchData['tel']) && Str::isNotBlank($searchData['tel'])) { |
335 | 335 | $qb |
336 | 336 | ->andWhere('CONCAT(o.tel01, o.tel02, o.tel03) LIKE :tel') |
337 | - ->setParameter('tel', '%' . $searchData['tel'] . '%'); |
|
337 | + ->setParameter('tel', '%'.$searchData['tel'].'%'); |
|
338 | 338 | } |
339 | 339 | |
340 | 340 | // sex |
@@ -446,7 +446,7 @@ discard block |
||
446 | 446 | $qb |
447 | 447 | ->leftJoin('o.OrderDetails', 'od') |
448 | 448 | ->andWhere('od.product_name LIKE :buy_product_name') |
449 | - ->setParameter('buy_product_name', '%' . $searchData['buy_product_name'] . '%'); |
|
449 | + ->setParameter('buy_product_name', '%'.$searchData['buy_product_name'].'%'); |
|
450 | 450 | } |
451 | 451 | |
452 | 452 | // Order By |
@@ -113,7 +113,7 @@ discard block |
||
113 | 113 | $key = sprintf('keyword%s', $index); |
114 | 114 | $qb |
115 | 115 | ->andWhere(sprintf('NORMALIZE(p.name) LIKE NORMALIZE(:%s) OR NORMALIZE(p.search_word) LIKE NORMALIZE(:%s)', $key, $key)) |
116 | - ->setParameter($key, '%' . $keyword . '%'); |
|
116 | + ->setParameter($key, '%'.$keyword.'%'); |
|
117 | 117 | } |
118 | 118 | } |
119 | 119 | |
@@ -176,7 +176,7 @@ discard block |
||
176 | 176 | $qb |
177 | 177 | ->andWhere('p.id = :id OR p.name LIKE :likeid OR pc.code LIKE :likeid') |
178 | 178 | ->setParameter('id', $id) |
179 | - ->setParameter('likeid', '%' . $searchData['id'] . '%'); |
|
179 | + ->setParameter('likeid', '%'.$searchData['id'].'%'); |
|
180 | 180 | } |
181 | 181 | |
182 | 182 | // code |