Failed Conditions
Push — experimental/3.1 ( ea436b...26b8cd )
by chihiro
244:59 queued 239:01
created
src/Eccube/Repository/OrderRepository.php 1 patch
Spacing   +11 added lines, -11 removed lines patch added patch discarded remove patch
@@ -109,14 +109,14 @@  discard block
 block discarded – undo
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
         // email
@@ -247,7 +247,7 @@  discard block
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
         // email
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
 block discarded – undo
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
 block discarded – undo
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
Please login to merge, or discard this patch.
src/Eccube/Repository/ShippingRepository.php 1 patch
Spacing   +10 added lines, -10 removed lines patch added patch discarded remove patch
@@ -55,13 +55,13 @@  discard block
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
Please login to merge, or discard this patch.