@@ -109,14 +109,14 @@ discard block |
||
109 | 109 | if (isset($searchData['name']) && StringUtil::isNotBlank($searchData['name'])) { |
110 | 110 | $qb |
111 | 111 | ->andWhere('CONCAT(o.name01, o.name02) LIKE :name') |
112 | - ->setParameter('name', '%' . $searchData['name'] . '%'); |
|
112 | + ->setParameter('name', '%'.$searchData['name'].'%'); |
|
113 | 113 | } |
114 | 114 | |
115 | 115 | // kana |
116 | 116 | if (isset($searchData['kana']) && StringUtil::isNotBlank($searchData['kana'])) { |
117 | 117 | $qb |
118 | 118 | ->andWhere('CONCAT(o.kana01, o.kana02) LIKE :kana') |
119 | - ->setParameter('kana', '%' . $searchData['kana'] . '%'); |
|
119 | + ->setParameter('kana', '%'.$searchData['kana'].'%'); |
|
120 | 120 | } |
121 | 121 | |
122 | 122 | |
@@ -247,7 +247,7 @@ discard block |
||
247 | 247 | $qb |
248 | 248 | ->leftJoin('o.OrderItems', 'oi') |
249 | 249 | ->andWhere('oi.product_name LIKE :buy_product_name') |
250 | - ->setParameter('buy_product_name', '%' . $searchData['buy_product_name'] . '%'); |
|
250 | + ->setParameter('buy_product_name', '%'.$searchData['buy_product_name'].'%'); |
|
251 | 251 | } |
252 | 252 | |
253 | 253 | // Order By |
@@ -273,13 +273,13 @@ discard block |
||
273 | 273 | ->setParameter('order_id_start', $searchData['order_id_start']); |
274 | 274 | } |
275 | 275 | // multi |
276 | - if (isset( $searchData['multi']) && StringUtil::isNotBlank($searchData['multi'])) { |
|
276 | + if (isset($searchData['multi']) && StringUtil::isNotBlank($searchData['multi'])) { |
|
277 | 277 | $multi = preg_match('/^\d+$/', $searchData['multi']) ? $searchData['multi'] : null; |
278 | 278 | $qb |
279 | - ->andWhere('o.id = :multi OR o.name01 LIKE :likemulti OR o.name02 LIKE :likemulti OR ' . |
|
279 | + ->andWhere('o.id = :multi OR o.name01 LIKE :likemulti OR o.name02 LIKE :likemulti OR '. |
|
280 | 280 | 'o.kana01 LIKE :likemulti OR o.kana02 LIKE :likemulti OR o.company_name LIKE :likemulti') |
281 | 281 | ->setParameter('multi', $multi) |
282 | - ->setParameter('likemulti', '%' . $searchData['multi'] . '%'); |
|
282 | + ->setParameter('likemulti', '%'.$searchData['multi'].'%'); |
|
283 | 283 | } |
284 | 284 | |
285 | 285 | // order_id_end |
@@ -316,21 +316,21 @@ discard block |
||
316 | 316 | if (isset($searchData['name']) && StringUtil::isNotBlank($searchData['name'])) { |
317 | 317 | $qb |
318 | 318 | ->andWhere('CONCAT(o.name01, o.name02) LIKE :name') |
319 | - ->setParameter('name', '%' . $searchData['name'] . '%'); |
|
319 | + ->setParameter('name', '%'.$searchData['name'].'%'); |
|
320 | 320 | } |
321 | 321 | |
322 | 322 | // kana |
323 | 323 | if (isset($searchData['kana']) && StringUtil::isNotBlank($searchData['kana'])) { |
324 | 324 | $qb |
325 | 325 | ->andWhere('CONCAT(o.kana01, o.kana02) LIKE :kana') |
326 | - ->setParameter('kana', '%' . $searchData['kana'] . '%'); |
|
326 | + ->setParameter('kana', '%'.$searchData['kana'].'%'); |
|
327 | 327 | } |
328 | 328 | |
329 | 329 | |
330 | 330 | if (isset($searchData['email']) && StringUtil::isNotBlank($searchData['email'])) { |
331 | 331 | $qb |
332 | 332 | ->andWhere('o.email like :email') |
333 | - ->setParameter('email', '%' . $searchData['email'] . '%'); |
|
333 | + ->setParameter('email', '%'.$searchData['email'].'%'); |
|
334 | 334 | } |
335 | 335 | |
336 | 336 | // tel |
@@ -338,7 +338,7 @@ discard block |
||
338 | 338 | $tel = preg_replace('/[^0-9]/ ', '', $searchData['tel']); |
339 | 339 | $qb |
340 | 340 | ->andWhere('CONCAT(o.tel01, o.tel02, o.tel03) LIKE :tel') |
341 | - ->setParameter('tel', '%' . $tel . '%'); |
|
341 | + ->setParameter('tel', '%'.$tel.'%'); |
|
342 | 342 | } |
343 | 343 | |
344 | 344 | // sex |
@@ -442,7 +442,7 @@ discard block |
||
442 | 442 | $qb |
443 | 443 | ->leftJoin('o.OrderItems', 'oi') |
444 | 444 | ->andWhere('oi.product_name LIKE :buy_product_name') |
445 | - ->setParameter('buy_product_name', '%' . $searchData['buy_product_name'] . '%'); |
|
445 | + ->setParameter('buy_product_name', '%'.$searchData['buy_product_name'].'%'); |
|
446 | 446 | } |
447 | 447 | |
448 | 448 | // Order By |
@@ -55,13 +55,13 @@ discard block |
||
55 | 55 | ->setParameter('shipping_id_start', $searchData['shipping_id_start']); |
56 | 56 | } |
57 | 57 | // multi |
58 | - if (isset( $searchData['multi']) && StringUtil::isNotBlank($searchData['multi'])) { |
|
58 | + if (isset($searchData['multi']) && StringUtil::isNotBlank($searchData['multi'])) { |
|
59 | 59 | $multi = preg_match('/^\d+$/', $searchData['multi']) ? $searchData['multi'] : null; |
60 | 60 | $qb |
61 | - ->andWhere('s.id = :multi OR s.name01 LIKE :likemulti OR s.name02 LIKE :likemulti OR ' . |
|
61 | + ->andWhere('s.id = :multi OR s.name01 LIKE :likemulti OR s.name02 LIKE :likemulti OR '. |
|
62 | 62 | 's.kana01 LIKE :likemulti OR s.kana02 LIKE :likemulti OR s.company_name LIKE :likemulti') |
63 | 63 | ->setParameter('multi', $multi) |
64 | - ->setParameter('likemulti', '%' . $searchData['multi'] . '%'); |
|
64 | + ->setParameter('likemulti', '%'.$searchData['multi'].'%'); |
|
65 | 65 | } |
66 | 66 | |
67 | 67 | // shipping_id_end |
@@ -95,35 +95,35 @@ discard block |
||
95 | 95 | if (isset($searchData['name']) && StringUtil::isNotBlank($searchData['name'])) { |
96 | 96 | $qb |
97 | 97 | ->andWhere('CONCAT(s.name01, s.name02) LIKE :name') |
98 | - ->setParameter('name', '%' . $searchData['name'] . '%'); |
|
98 | + ->setParameter('name', '%'.$searchData['name'].'%'); |
|
99 | 99 | } |
100 | 100 | |
101 | 101 | // kana |
102 | 102 | if (isset($searchData['kana']) && StringUtil::isNotBlank($searchData['kana'])) { |
103 | 103 | $qb |
104 | 104 | ->andWhere('CONCAT(s.kana01, s.kana02) LIKE :kana') |
105 | - ->setParameter('kana', '%' . $searchData['kana'] . '%'); |
|
105 | + ->setParameter('kana', '%'.$searchData['kana'].'%'); |
|
106 | 106 | } |
107 | 107 | |
108 | 108 | // order_name |
109 | 109 | if (isset($searchData['order_name']) && StringUtil::isNotBlank($searchData['order_name'])) { |
110 | 110 | $qb |
111 | 111 | ->andWhere('CONCAT(o.name01, o.name02) LIKE :order_name') |
112 | - ->setParameter('order_name', '%' . $searchData['order_name'] . '%'); |
|
112 | + ->setParameter('order_name', '%'.$searchData['order_name'].'%'); |
|
113 | 113 | } |
114 | 114 | |
115 | 115 | // order_kana |
116 | 116 | if (isset($searchData['order_kana']) && StringUtil::isNotBlank($searchData['order_kana'])) { |
117 | 117 | $qb |
118 | 118 | ->andWhere('CONCAT(o.kana01, s.kana02) LIKE :order_kana') |
119 | - ->setParameter('kana', '%' . $searchData['order_kana'] . '%'); |
|
119 | + ->setParameter('kana', '%'.$searchData['order_kana'].'%'); |
|
120 | 120 | } |
121 | 121 | |
122 | 122 | // order_email |
123 | 123 | if (isset($searchData['email']) && StringUtil::isNotBlank($searchData['email'])) { |
124 | 124 | $qb |
125 | 125 | ->andWhere('o.email like :email') |
126 | - ->setParameter('email', '%' . $searchData['email'] . '%'); |
|
126 | + ->setParameter('email', '%'.$searchData['email'].'%'); |
|
127 | 127 | } |
128 | 128 | |
129 | 129 | // tel |
@@ -131,7 +131,7 @@ discard block |
||
131 | 131 | $tel = preg_replace('/[^0-9]/ ', '', $searchData['tel']); |
132 | 132 | $qb |
133 | 133 | ->andWhere('CONCAT(s.tel01, s.tel02, s.tel03) LIKE :tel') |
134 | - ->setParameter('tel', '%' . $tel . '%'); |
|
134 | + ->setParameter('tel', '%'.$tel.'%'); |
|
135 | 135 | } |
136 | 136 | |
137 | 137 | // payment |
@@ -227,7 +227,7 @@ discard block |
||
227 | 227 | if (isset($searchData['buy_product_name']) && StringUtil::isNotBlank($searchData['buy_product_name'])) { |
228 | 228 | $qb |
229 | 229 | ->andWhere('si.product_name LIKE :buy_product_name') |
230 | - ->setParameter('buy_product_name', '%' . $searchData['buy_product_name'] . '%'); |
|
230 | + ->setParameter('buy_product_name', '%'.$searchData['buy_product_name'].'%'); |
|
231 | 231 | } |
232 | 232 | |
233 | 233 | // Order By |