Code Duplication    Length = 7-9 lines in 24 locations

src/Eccube/Repository/OrderRepository.php 12 locations

@@ 195-201 (lines=7) @@
192
        }
193
194
        // oreder_date
195
        if (!empty($searchData['order_date_start']) && $searchData['order_date_start']) {
196
            $date = $searchData['order_date_start']
197
                ->format('Y-m-d H:i:s');
198
            $qb
199
                ->andWhere('o.create_date >= :order_date_start')
200
                ->setParameter('order_date_start', $date);
201
        }
202
        if (!empty($searchData['order_date_end']) && $searchData['order_date_end']) {
203
            $date = clone $searchData['order_date_end'];
204
            $date = $date
@@ 202-210 (lines=9) @@
199
                ->andWhere('o.create_date >= :order_date_start')
200
                ->setParameter('order_date_start', $date);
201
        }
202
        if (!empty($searchData['order_date_end']) && $searchData['order_date_end']) {
203
            $date = clone $searchData['order_date_end'];
204
            $date = $date
205
                ->modify('+1 days')
206
                ->format('Y-m-d H:i:s');
207
            $qb
208
                ->andWhere('o.create_date < :order_date_end')
209
                ->setParameter('order_date_end', $date);
210
        }
211
212
        // create_date
213
        if (!empty($searchData['update_date_start']) && $searchData['update_date_start']) {
@@ 213-219 (lines=7) @@
210
        }
211
212
        // create_date
213
        if (!empty($searchData['update_date_start']) && $searchData['update_date_start']) {
214
            $date = $searchData['update_date_start']
215
                ->format('Y-m-d H:i:s');
216
            $qb
217
                ->andWhere('o.update_date >= :update_date_start')
218
                ->setParameter('update_date_start', $date);
219
        }
220
        if (!empty($searchData['update_date_end']) && $searchData['update_date_end']) {
221
            $date = clone $searchData['update_date_end'];
222
            $date = $date
@@ 220-228 (lines=9) @@
217
                ->andWhere('o.update_date >= :update_date_start')
218
                ->setParameter('update_date_start', $date);
219
        }
220
        if (!empty($searchData['update_date_end']) && $searchData['update_date_end']) {
221
            $date = clone $searchData['update_date_end'];
222
            $date = $date
223
                ->modify('+1 days')
224
                ->format('Y-m-d H:i:s');
225
            $qb
226
                ->andWhere('o.update_date < :update_date_end')
227
                ->setParameter('update_date_end', $date);
228
        }
229
230
        // payment_total
231
        if (isset($searchData['payment_total_start']) && Str::isNotBlank($searchData['payment_total_start'])) {
@@ 351-357 (lines=7) @@
348
        }
349
350
        // oreder_date
351
        if (!empty($searchData['order_date_start']) && $searchData['order_date_start']) {
352
            $date = $searchData['order_date_start']
353
                ->format('Y-m-d H:i:s');
354
            $qb
355
                ->andWhere('o.order_date >= :order_date_start')
356
                ->setParameter('order_date_start', $date);
357
        }
358
        if (!empty($searchData['order_date_end']) && $searchData['order_date_end']) {
359
            $date = clone $searchData['order_date_end'];
360
            $date = $date
@@ 358-366 (lines=9) @@
355
                ->andWhere('o.order_date >= :order_date_start')
356
                ->setParameter('order_date_start', $date);
357
        }
358
        if (!empty($searchData['order_date_end']) && $searchData['order_date_end']) {
359
            $date = clone $searchData['order_date_end'];
360
            $date = $date
361
                ->modify('+1 days')
362
                ->format('Y-m-d H:i:s');
363
            $qb
364
                ->andWhere('o.order_date < :order_date_end')
365
                ->setParameter('order_date_end', $date);
366
        }
367
368
        // payment_date
369
        if (!empty($searchData['payment_date_start']) && $searchData['payment_date_start']) {
@@ 369-375 (lines=7) @@
366
        }
367
368
        // payment_date
369
        if (!empty($searchData['payment_date_start']) && $searchData['payment_date_start']) {
370
            $date = $searchData['payment_date_start']
371
                ->format('Y-m-d H:i:s');
372
            $qb
373
                ->andWhere('o.payment_date >= :payment_date_start')
374
                ->setParameter('payment_date_start', $date);
375
        }
376
        if (!empty($searchData['payment_date_end']) && $searchData['payment_date_end']) {
377
            $date = clone $searchData['payment_date_end'];
378
            $date = $date
@@ 376-384 (lines=9) @@
373
                ->andWhere('o.payment_date >= :payment_date_start')
374
                ->setParameter('payment_date_start', $date);
375
        }
376
        if (!empty($searchData['payment_date_end']) && $searchData['payment_date_end']) {
377
            $date = clone $searchData['payment_date_end'];
378
            $date = $date
379
                ->modify('+1 days')
380
                ->format('Y-m-d H:i:s');
381
            $qb
382
                ->andWhere('o.payment_date < :payment_date_end')
383
                ->setParameter('payment_date_end', $date);
384
        }
385
386
        // commit_date
387
        if (!empty($searchData['commit_date_start']) && $searchData['commit_date_start']) {
@@ 387-393 (lines=7) @@
384
        }
385
386
        // commit_date
387
        if (!empty($searchData['commit_date_start']) && $searchData['commit_date_start']) {
388
            $date = $searchData['commit_date_start']
389
                ->format('Y-m-d H:i:s');
390
            $qb
391
                ->andWhere('o.commit_date >= :commit_date_start')
392
                ->setParameter('commit_date_start', $date);
393
        }
394
        if (!empty($searchData['commit_date_end']) && $searchData['commit_date_end']) {
395
            $date = clone $searchData['commit_date_end'];
396
            $date = $date
@@ 394-402 (lines=9) @@
391
                ->andWhere('o.commit_date >= :commit_date_start')
392
                ->setParameter('commit_date_start', $date);
393
        }
394
        if (!empty($searchData['commit_date_end']) && $searchData['commit_date_end']) {
395
            $date = clone $searchData['commit_date_end'];
396
            $date = $date
397
                ->modify('+1 days')
398
                ->format('Y-m-d H:i:s');
399
            $qb
400
                ->andWhere('o.commit_date < :commit_date_end')
401
                ->setParameter('commit_date_end', $date);
402
        }
403
404
405
        // update_date
@@ 406-412 (lines=7) @@
403
404
405
        // update_date
406
        if (!empty($searchData['update_date_start']) && $searchData['update_date_start']) {
407
            $date = $searchData['update_date_start']
408
                ->format('Y-m-d H:i:s');
409
            $qb
410
                ->andWhere('o.update_date >= :update_date_start')
411
                ->setParameter('update_date_start', $date);
412
        }
413
        if (!empty($searchData['update_date_end']) && $searchData['update_date_end']) {
414
            $date = clone $searchData['update_date_end'];
415
            $date = $date
@@ 413-421 (lines=9) @@
410
                ->andWhere('o.update_date >= :update_date_start')
411
                ->setParameter('update_date_start', $date);
412
        }
413
        if (!empty($searchData['update_date_end']) && $searchData['update_date_end']) {
414
            $date = clone $searchData['update_date_end'];
415
            $date = $date
416
                ->modify('+1 days')
417
                ->format('Y-m-d H:i:s');
418
            $qb
419
                ->andWhere('o.update_date < :update_date_end')
420
                ->setParameter('update_date_end', $date);
421
        }
422
423
        // payment_total
424
        if (isset($searchData['payment_total_start']) && Str::isNotBlank($searchData['payment_total_start'])) {

src/Eccube/Repository/CustomerRepository.php 8 locations

@@ 191-197 (lines=7) @@
188
        }
189
190
        // birth
191
        if (!empty($searchData['birth_start']) && $searchData['birth_start']) {
192
            $date = $searchData['birth_start']
193
                ->format('Y-m-d H:i:s');
194
            $qb
195
                ->andWhere('c.birth >= :birth_start')
196
                ->setParameter('birth_start', $date);
197
        }
198
        if (!empty($searchData['birth_end']) && $searchData['birth_end']) {
199
            $date = clone $searchData['birth_end'];
200
            $date = $date
@@ 198-206 (lines=9) @@
195
                ->andWhere('c.birth >= :birth_start')
196
                ->setParameter('birth_start', $date);
197
        }
198
        if (!empty($searchData['birth_end']) && $searchData['birth_end']) {
199
            $date = clone $searchData['birth_end'];
200
            $date = $date
201
                ->modify('+1 days')
202
                ->format('Y-m-d H:i:s');
203
            $qb
204
                ->andWhere('c.birth < :birth_end')
205
                ->setParameter('birth_end', $date);
206
        }
207
208
        // tel
209
        if (isset($searchData['tel']) && Str::isNotBlank($searchData['tel'])) {
@@ 240-246 (lines=7) @@
237
        }
238
239
        // create_date
240
        if (!empty($searchData['create_date_start']) && $searchData['create_date_start']) {
241
            $date = $searchData['create_date_start']
242
                ->format('Y-m-d H:i:s');
243
            $qb
244
                ->andWhere('c.create_date >= :create_date_start')
245
                ->setParameter('create_date_start', $date);
246
        }
247
        if (!empty($searchData['create_date_end']) && $searchData['create_date_end']) {
248
            $date = clone $searchData['create_date_end'];
249
            $date = $date
@@ 247-255 (lines=9) @@
244
                ->andWhere('c.create_date >= :create_date_start')
245
                ->setParameter('create_date_start', $date);
246
        }
247
        if (!empty($searchData['create_date_end']) && $searchData['create_date_end']) {
248
            $date = clone $searchData['create_date_end'];
249
            $date = $date
250
                ->modify('+1 days')
251
                ->format('Y-m-d H:i:s');
252
            $qb
253
                ->andWhere('c.create_date < :create_date_end')
254
                ->setParameter('create_date_end', $date);
255
        }
256
257
        // update_date
258
        if (!empty($searchData['update_date_start']) && $searchData['update_date_start']) {
@@ 258-264 (lines=7) @@
255
        }
256
257
        // update_date
258
        if (!empty($searchData['update_date_start']) && $searchData['update_date_start']) {
259
            $date = $searchData['update_date_start']
260
                ->format('Y-m-d H:i:s');
261
            $qb
262
                ->andWhere('c.update_date >= :update_date_start')
263
                ->setParameter('update_date_start', $date);
264
        }
265
        if (!empty($searchData['update_date_end']) && $searchData['update_date_end']) {
266
            $date = clone $searchData['update_date_end'];
267
            $date = $date
@@ 265-273 (lines=9) @@
262
                ->andWhere('c.update_date >= :update_date_start')
263
                ->setParameter('update_date_start', $date);
264
        }
265
        if (!empty($searchData['update_date_end']) && $searchData['update_date_end']) {
266
            $date = clone $searchData['update_date_end'];
267
            $date = $date
268
                ->modify('+1 days')
269
                ->format('Y-m-d H:i:s');
270
            $qb
271
                ->andWhere('c.update_date < :update_date_end')
272
                ->setParameter('update_date_end', $date);
273
        }
274
275
        // last_buy
276
        if (!empty($searchData['last_buy_start']) && $searchData['last_buy_start']) {
@@ 276-282 (lines=7) @@
273
        }
274
275
        // last_buy
276
        if (!empty($searchData['last_buy_start']) && $searchData['last_buy_start']) {
277
            $date = $searchData['last_buy_start']
278
                ->format('Y-m-d H:i:s');
279
            $qb
280
                ->andWhere('c.last_buy_date >= :last_buy_start')
281
                ->setParameter('last_buy_start', $date);
282
        }
283
        if (!empty($searchData['last_buy_end']) && $searchData['last_buy_end']) {
284
            $date = clone $searchData['last_buy_end'];
285
            $date = $date
@@ 283-291 (lines=9) @@
280
                ->andWhere('c.last_buy_date >= :last_buy_start')
281
                ->setParameter('last_buy_start', $date);
282
        }
283
        if (!empty($searchData['last_buy_end']) && $searchData['last_buy_end']) {
284
            $date = clone $searchData['last_buy_end'];
285
            $date = $date
286
                ->modify('+1 days')
287
                ->format('Y-m-d H:i:s');
288
            $qb
289
                ->andWhere('c.last_buy_date < :last_buy_end')
290
                ->setParameter('last_buy_end', $date);
291
        }
292
293
        // status
294
        if (!empty($searchData['customer_status']) && count($searchData['customer_status']) > 0) {

src/Eccube/Repository/ProductRepository.php 4 locations

@@ 216-222 (lines=7) @@
213
        }
214
215
        // crate_date
216
        if (!empty($searchData['create_date_start']) && $searchData['create_date_start']) {
217
            $date = $searchData['create_date_start']
218
                ->format('Y-m-d H:i:s');
219
            $qb
220
                ->andWhere('p.create_date >= :create_date_start')
221
                ->setParameter('create_date_start', $date);
222
        }
223
224
        if (!empty($searchData['create_date_end']) && $searchData['create_date_end']) {
225
            $date = clone $searchData['create_date_end'];
@@ 224-232 (lines=9) @@
221
                ->setParameter('create_date_start', $date);
222
        }
223
224
        if (!empty($searchData['create_date_end']) && $searchData['create_date_end']) {
225
            $date = clone $searchData['create_date_end'];
226
            $date = $date
227
                ->modify('+1 days')
228
                ->format('Y-m-d H:i:s');
229
            $qb
230
                ->andWhere('p.create_date < :create_date_end')
231
                ->setParameter('create_date_end', $date);
232
        }
233
234
        // update_date
235
        if (!empty($searchData['update_date_start']) && $searchData['update_date_start']) {
@@ 235-241 (lines=7) @@
232
        }
233
234
        // update_date
235
        if (!empty($searchData['update_date_start']) && $searchData['update_date_start']) {
236
            $date = $searchData['update_date_start']
237
                ->format('Y-m-d H:i:s');
238
            $qb
239
                ->andWhere('p.update_date >= :update_date_start')
240
                ->setParameter('update_date_start', $date);
241
        }
242
        if (!empty($searchData['update_date_end']) && $searchData['update_date_end']) {
243
            $date = clone $searchData['update_date_end'];
244
            $date = $date
@@ 242-250 (lines=9) @@
239
                ->andWhere('p.update_date >= :update_date_start')
240
                ->setParameter('update_date_start', $date);
241
        }
242
        if (!empty($searchData['update_date_end']) && $searchData['update_date_end']) {
243
            $date = clone $searchData['update_date_end'];
244
            $date = $date
245
                ->modify('+1 days')
246
                ->format('Y-m-d H:i:s');
247
            $qb
248
                ->andWhere('p.update_date < :update_date_end')
249
                ->setParameter('update_date_end', $date);
250
        }
251
252
253
        // Order By