Completed
Pull Request — master (#2124)
by
unknown
71:11
created
src/Eccube/Repository/OrderRepository.php 1 patch
Spacing   +11 added lines, -11 removed lines patch added patch discarded remove patch
@@ -100,14 +100,14 @@  discard block
 block discarded – undo
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
         // email
@@ -244,7 +244,7 @@  discard block
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
         // email
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
 block discarded – undo
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
Please login to merge, or discard this patch.
src/Eccube/Repository/ProductRepository.php 1 patch
Spacing   +2 added lines, -2 removed lines patch added patch discarded remove patch
@@ -113,7 +113,7 @@  discard block
 block discarded – undo
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
 block discarded – undo
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
Please login to merge, or discard this patch.