Code Duplication - EC-CUBE/ec-cube - Measure and Improve Code Quality continuously with Scrutinizer

Code Duplication Length = 5-5 lines in 21 locations

src/Eccube/Repository/OrderRepository.php 18 locations


        $joinedCustomer = false;

        // order_id_start
        if (isset($searchData['order_id_start']) && Str::isNotBlank($searchData['order_id_start'])) {
            $qb
                ->andWhere('o.id >= :order_id_start')
                ->setParameter('order_id_start', $searchData['order_id_start']);
        }

        // order_id_end
        if (isset($searchData['order_id_end']) && Str::isNotBlank($searchData['order_id_end'])) {

        }

        // order_id_end
        if (isset($searchData['order_id_end']) && Str::isNotBlank($searchData['order_id_end'])) {
            $qb
                ->andWhere('o.id <= :order_id_end')
                ->setParameter('order_id_end', $searchData['order_id_end']);
        }

        // status
        if (!empty($searchData['status']) && $searchData['status']) {

        }

        // name
        if (isset($searchData['name']) && Str::isNotBlank($searchData['name'])) {
            $qb
                ->andWhere('CONCAT(o.name01, o.name02) LIKE :name')
                ->setParameter('name', '%' . $searchData['name'] . '%');
        }

        // kana
        if (isset($searchData['kana']) && Str::isNotBlank($searchData['kana'])) {

        }

        // kana
        if (isset($searchData['kana']) && Str::isNotBlank($searchData['kana'])) {
            $qb
                ->andWhere('CONCAT(o.kana01, o.kana02) LIKE :kana')
                ->setParameter('kana', '%' . $searchData['kana'] . '%');
        }

        // email
        if (isset($searchData['email']) && Str::isNotBlank($searchData['email'])) {

        }

        // email
        if (isset($searchData['email']) && Str::isNotBlank($searchData['email'])) {
            $qb
                ->andWhere('o.email = :email')
                ->setParameter('email', $searchData['email']);
        }

        // tel
        if (isset($searchData['tel01']) && Str::isNotBlank($searchData['tel01'])) {

        }

        // tel
        if (isset($searchData['tel01']) && Str::isNotBlank($searchData['tel01'])) {
            $qb
                ->andWhere('o.tel01 = :tel01')
                ->setParameter('tel01', $searchData['tel01']);
        }
        if (isset($searchData['tel02']) && Str::isNotBlank($searchData['tel02'])) {
            $qb
                ->andWhere('o.tel02 = :tel02')

                ->andWhere('o.tel01 = :tel01')
                ->setParameter('tel01', $searchData['tel01']);
        }
        if (isset($searchData['tel02']) && Str::isNotBlank($searchData['tel02'])) {
            $qb
                ->andWhere('o.tel02 = :tel02')
                ->setParameter('tel02', $searchData['tel02']);
        }
        if (isset($searchData['tel03']) && Str::isNotBlank($searchData['tel03'])) {
            $qb
                ->andWhere('o.tel03 = :tel03')

                ->andWhere('o.tel02 = :tel02')
                ->setParameter('tel02', $searchData['tel02']);
        }
        if (isset($searchData['tel03']) && Str::isNotBlank($searchData['tel03'])) {
            $qb
                ->andWhere('o.tel03 = :tel03')
                ->setParameter('tel03', $searchData['tel03']);
        }

        // birth
        if (!empty($searchData['birth_start']) && $searchData['birth_start']) {

        }

        // payment_total
        if (isset($searchData['payment_total_start']) && Str::isNotBlank($searchData['payment_total_start'])) {
            $qb
                ->andWhere('o.payment_total >= :payment_total_start')
                ->setParameter('payment_total_start', $searchData['payment_total_start']);
        }
        if (isset($searchData['payment_total_end']) && Str::isNotBlank($searchData['payment_total_end'])) {
            $qb
                ->andWhere('o.payment_total <= :payment_total_end')

                ->andWhere('o.payment_total >= :payment_total_start')
                ->setParameter('payment_total_start', $searchData['payment_total_start']);
        }
        if (isset($searchData['payment_total_end']) && Str::isNotBlank($searchData['payment_total_end'])) {
            $qb
                ->andWhere('o.payment_total <= :payment_total_end')
                ->setParameter('payment_total_end', $searchData['payment_total_end']);
        }

        // buy_product_name
        if (isset($searchData['buy_product_name']) && Str::isNotBlank($searchData['buy_product_name'])) {

        $qb = $this->createQueryBuilder('o');

        // order_id_start
        if (isset($searchData['order_id_start']) && Str::isNotBlank($searchData['order_id_start'])) {
            $qb
                ->andWhere('o.id >= :order_id_start')
                ->setParameter('order_id_start', $searchData['order_id_start']);
        }
        // multi
        if (isset($searchData['multi']) && Str::isNotBlank($searchData['multi'])) {
            $multi = preg_match('/^\d+$/', $searchData['multi']) ? $searchData['multi'] : null;

        }

        // order_id_end
        if (isset($searchData['order_id_end']) && Str::isNotBlank($searchData['order_id_end'])) {
            $qb
                ->andWhere('o.id <= :order_id_end')
                ->setParameter('order_id_end', $searchData['order_id_end']);
        }

        // status
        $filterStatus = false;

        }

        // name
        if (isset($searchData['name']) && Str::isNotBlank($searchData['name'])) {
            $qb
                ->andWhere('CONCAT(o.name01, o.name02) LIKE :name')
                ->setParameter('name', '%' . $searchData['name'] . '%');
        }

        // kana
        if (isset($searchData['kana']) && Str::isNotBlank($searchData['kana'])) {

        }

        // kana
        if (isset($searchData['kana']) && Str::isNotBlank($searchData['kana'])) {
            $qb
                ->andWhere('CONCAT(o.kana01, o.kana02) LIKE :kana')
                ->setParameter('kana', '%' . $searchData['kana'] . '%');
        }

        // email
        if (isset($searchData['email']) && Str::isNotBlank($searchData['email'])) {

        }

        // email
        if (isset($searchData['email']) && Str::isNotBlank($searchData['email'])) {
            $qb
                ->andWhere('o.email like :email')
                ->setParameter('email', '%' . $searchData['email'] . '%');
        }

        // tel
        if (isset($searchData['tel']) && Str::isNotBlank($searchData['tel'])) {

        }

        // tel
        if (isset($searchData['tel']) && Str::isNotBlank($searchData['tel'])) {
            $qb
                ->andWhere('CONCAT(o.tel01, o.tel02, o.tel03) LIKE :tel')
                ->setParameter('tel', '%' . $searchData['tel'] . '%');
        }

        // sex
        if (!empty($searchData['sex']) && count($searchData['sex']) > 0) {

        }

        // payment_total
        if (isset($searchData['payment_total_start']) && Str::isNotBlank($searchData['payment_total_start'])) {
            $qb
                ->andWhere('o.payment_total >= :payment_total_start')
                ->setParameter('payment_total_start', $searchData['payment_total_start']);
        }
        if (isset($searchData['payment_total_end']) && Str::isNotBlank($searchData['payment_total_end'])) {
            $qb
                ->andWhere('o.payment_total <= :payment_total_end')

                ->andWhere('o.payment_total >= :payment_total_start')
                ->setParameter('payment_total_start', $searchData['payment_total_start']);
        }
        if (isset($searchData['payment_total_end']) && Str::isNotBlank($searchData['payment_total_end'])) {
            $qb
                ->andWhere('o.payment_total <= :payment_total_end')
                ->setParameter('payment_total_end', $searchData['payment_total_end']);
        }

        // buy_product_name
        if (isset($searchData['buy_product_name']) && Str::isNotBlank($searchData['buy_product_name'])) {

src/Eccube/Repository/CustomerRepository.php 3 locations


        }

        // tel
        if (isset($searchData['tel']) && Str::isNotBlank($searchData['tel'])) {
            $qb
                ->andWhere('CONCAT(c.tel01, c.tel02, c.tel03) LIKE :tel')
                ->setParameter('tel', '%' . $searchData['tel'] . '%');
        }

        // buy_total
        if (isset($searchData['buy_total_start']) && Str::isNotBlank($searchData['buy_total_start'])) {

        }

        // buy_total
        if (isset($searchData['buy_total_start']) && Str::isNotBlank($searchData['buy_total_start'])) {
            $qb
                ->andWhere('c.buy_total >= :buy_total_start')
                ->setParameter('buy_total_start', $searchData['buy_total_start']);
        }
        if (isset($searchData['buy_total_end']) && Str::isNotBlank($searchData['buy_total_end'])) {
            $qb
                ->andWhere('c.buy_total <= :buy_total_end')

                ->andWhere('c.buy_total >= :buy_total_start')
                ->setParameter('buy_total_start', $searchData['buy_total_start']);
        }
        if (isset($searchData['buy_total_end']) && Str::isNotBlank($searchData['buy_total_end'])) {
            $qb
                ->andWhere('c.buy_total <= :buy_total_end')
                ->setParameter('buy_total_end', $searchData['buy_total_end']);
        }

        // buy_times
        if (!empty($searchData['buy_times_start']) && $searchData['buy_times_start']) {

		@@ 209-213 (lines=5) @@
206		}
207
208		// tel
209		if (isset($searchData['tel']) && Str::isNotBlank($searchData['tel'])) {
210		$qb
211		->andWhere('CONCAT(c.tel01, c.tel02, c.tel03) LIKE :tel')
212		->setParameter('tel', '%' . $searchData['tel'] . '%');
213		}
214
215		// buy_total
216		if (isset($searchData['buy_total_start']) && Str::isNotBlank($searchData['buy_total_start'])) {
		@@ 216-220 (lines=5) @@
213		}
214
215		// buy_total
216		if (isset($searchData['buy_total_start']) && Str::isNotBlank($searchData['buy_total_start'])) {
217		$qb
218		->andWhere('c.buy_total >= :buy_total_start')
219		->setParameter('buy_total_start', $searchData['buy_total_start']);
220		}
221		if (isset($searchData['buy_total_end']) && Str::isNotBlank($searchData['buy_total_end'])) {
222		$qb
223		->andWhere('c.buy_total <= :buy_total_end')
		@@ 221-225 (lines=5) @@
218		->andWhere('c.buy_total >= :buy_total_start')
219		->setParameter('buy_total_start', $searchData['buy_total_start']);
220		}
221		if (isset($searchData['buy_total_end']) && Str::isNotBlank($searchData['buy_total_end'])) {
222		$qb
223		->andWhere('c.buy_total <= :buy_total_end')
224		->setParameter('buy_total_end', $searchData['buy_total_end']);
225		}
226
227		// buy_times
228		if (!empty($searchData['buy_times_start']) && $searchData['buy_times_start']) {

		@@ 79-83 (lines=5) @@
76		$joinedCustomer = false;
77
78		// order_id_start
79		if (isset($searchData['order_id_start']) && Str::isNotBlank($searchData['order_id_start'])) {
80		$qb
81		->andWhere('o.id >= :order_id_start')
82		->setParameter('order_id_start', $searchData['order_id_start']);
83		}
84
85		// order_id_end
86		if (isset($searchData['order_id_end']) && Str::isNotBlank($searchData['order_id_end'])) {
		@@ 86-90 (lines=5) @@
83		}
84
85		// order_id_end
86		if (isset($searchData['order_id_end']) && Str::isNotBlank($searchData['order_id_end'])) {
87		$qb
88		->andWhere('o.id <= :order_id_end')
89		->setParameter('order_id_end', $searchData['order_id_end']);
90		}
91
92		// status
93		if (!empty($searchData['status']) && $searchData['status']) {
		@@ 100-104 (lines=5) @@
97		}
98
99		// name
100		if (isset($searchData['name']) && Str::isNotBlank($searchData['name'])) {
101		$qb
102		->andWhere('CONCAT(o.name01, o.name02) LIKE :name')
103		->setParameter('name', '%' . $searchData['name'] . '%');
104		}
105
106		// kana
107		if (isset($searchData['kana']) && Str::isNotBlank($searchData['kana'])) {
		@@ 107-111 (lines=5) @@
104		}
105
106		// kana
107		if (isset($searchData['kana']) && Str::isNotBlank($searchData['kana'])) {
108		$qb
109		->andWhere('CONCAT(o.kana01, o.kana02) LIKE :kana')
110		->setParameter('kana', '%' . $searchData['kana'] . '%');
111		}
112
113		// email
114		if (isset($searchData['email']) && Str::isNotBlank($searchData['email'])) {
		@@ 114-118 (lines=5) @@
111		}
112
113		// email
114		if (isset($searchData['email']) && Str::isNotBlank($searchData['email'])) {
115		$qb
116		->andWhere('o.email = :email')
117		->setParameter('email', $searchData['email']);
118		}
119
120		// tel
121		if (isset($searchData['tel01']) && Str::isNotBlank($searchData['tel01'])) {
		@@ 121-125 (lines=5) @@
118		}
119
120		// tel
121		if (isset($searchData['tel01']) && Str::isNotBlank($searchData['tel01'])) {
122		$qb
123		->andWhere('o.tel01 = :tel01')
124		->setParameter('tel01', $searchData['tel01']);
125		}
126		if (isset($searchData['tel02']) && Str::isNotBlank($searchData['tel02'])) {
127		$qb
128		->andWhere('o.tel02 = :tel02')
		@@ 126-130 (lines=5) @@
123		->andWhere('o.tel01 = :tel01')
124		->setParameter('tel01', $searchData['tel01']);
125		}
126		if (isset($searchData['tel02']) && Str::isNotBlank($searchData['tel02'])) {
127		$qb
128		->andWhere('o.tel02 = :tel02')
129		->setParameter('tel02', $searchData['tel02']);
130		}
131		if (isset($searchData['tel03']) && Str::isNotBlank($searchData['tel03'])) {
132		$qb
133		->andWhere('o.tel03 = :tel03')
		@@ 131-135 (lines=5) @@
128		->andWhere('o.tel02 = :tel02')
129		->setParameter('tel02', $searchData['tel02']);
130		}
131		if (isset($searchData['tel03']) && Str::isNotBlank($searchData['tel03'])) {
132		$qb
133		->andWhere('o.tel03 = :tel03')
134		->setParameter('tel03', $searchData['tel03']);
135		}
136
137		// birth
138		if (!empty($searchData['birth_start']) && $searchData['birth_start']) {
		@@ 231-235 (lines=5) @@
228		}
229
230		// payment_total
231		if (isset($searchData['payment_total_start']) && Str::isNotBlank($searchData['payment_total_start'])) {
232		$qb
233		->andWhere('o.payment_total >= :payment_total_start')
234		->setParameter('payment_total_start', $searchData['payment_total_start']);
235		}
236		if (isset($searchData['payment_total_end']) && Str::isNotBlank($searchData['payment_total_end'])) {
237		$qb
238		->andWhere('o.payment_total <= :payment_total_end')
		@@ 236-240 (lines=5) @@
233		->andWhere('o.payment_total >= :payment_total_start')
234		->setParameter('payment_total_start', $searchData['payment_total_start']);
235		}
236		if (isset($searchData['payment_total_end']) && Str::isNotBlank($searchData['payment_total_end'])) {
237		$qb
238		->andWhere('o.payment_total <= :payment_total_end')
239		->setParameter('payment_total_end', $searchData['payment_total_end']);
240		}
241
242		// buy_product_name
243		if (isset($searchData['buy_product_name']) && Str::isNotBlank($searchData['buy_product_name'])) {
		@@ 267-271 (lines=5) @@
264		$qb = $this->createQueryBuilder('o');
265
266		// order_id_start
267		if (isset($searchData['order_id_start']) && Str::isNotBlank($searchData['order_id_start'])) {
268		$qb
269		->andWhere('o.id >= :order_id_start')
270		->setParameter('order_id_start', $searchData['order_id_start']);
271		}
272		// multi
273		if (isset($searchData['multi']) && Str::isNotBlank($searchData['multi'])) {
274		$multi = preg_match('/^\d+$/', $searchData['multi']) ? $searchData['multi'] : null;
		@@ 288-292 (lines=5) @@
285		}
286
287		// order_id_end
288		if (isset($searchData['order_id_end']) && Str::isNotBlank($searchData['order_id_end'])) {
289		$qb
290		->andWhere('o.id <= :order_id_end')
291		->setParameter('order_id_end', $searchData['order_id_end']);
292		}
293
294		// status
295		$filterStatus = false;
		@@ 318-322 (lines=5) @@
315		}
316
317		// name
318		if (isset($searchData['name']) && Str::isNotBlank($searchData['name'])) {
319		$qb
320		->andWhere('CONCAT(o.name01, o.name02) LIKE :name')
321		->setParameter('name', '%' . $searchData['name'] . '%');
322		}
323
324		// kana
325		if (isset($searchData['kana']) && Str::isNotBlank($searchData['kana'])) {
		@@ 325-329 (lines=5) @@
322		}
323
324		// kana
325		if (isset($searchData['kana']) && Str::isNotBlank($searchData['kana'])) {
326		$qb
327		->andWhere('CONCAT(o.kana01, o.kana02) LIKE :kana')
328		->setParameter('kana', '%' . $searchData['kana'] . '%');
329		}
330
331		// email
332		if (isset($searchData['email']) && Str::isNotBlank($searchData['email'])) {
		@@ 332-336 (lines=5) @@
329		}
330
331		// email
332		if (isset($searchData['email']) && Str::isNotBlank($searchData['email'])) {
333		$qb
334		->andWhere('o.email like :email')
335		->setParameter('email', '%' . $searchData['email'] . '%');
336		}
337
338		// tel
339		if (isset($searchData['tel']) && Str::isNotBlank($searchData['tel'])) {
		@@ 339-343 (lines=5) @@
336		}
337
338		// tel
339		if (isset($searchData['tel']) && Str::isNotBlank($searchData['tel'])) {
340		$qb
341		->andWhere('CONCAT(o.tel01, o.tel02, o.tel03) LIKE :tel')
342		->setParameter('tel', '%' . $searchData['tel'] . '%');
343		}
344
345		// sex
346		if (!empty($searchData['sex']) && count($searchData['sex']) > 0) {
		@@ 438-442 (lines=5) @@
435		}
436
437		// payment_total
438		if (isset($searchData['payment_total_start']) && Str::isNotBlank($searchData['payment_total_start'])) {
439		$qb
440		->andWhere('o.payment_total >= :payment_total_start')
441		->setParameter('payment_total_start', $searchData['payment_total_start']);
442		}
443		if (isset($searchData['payment_total_end']) && Str::isNotBlank($searchData['payment_total_end'])) {
444		$qb
445		->andWhere('o.payment_total <= :payment_total_end')
		@@ 443-447 (lines=5) @@
440		->andWhere('o.payment_total >= :payment_total_start')
441		->setParameter('payment_total_start', $searchData['payment_total_start']);
442		}
443		if (isset($searchData['payment_total_end']) && Str::isNotBlank($searchData['payment_total_end'])) {
444		$qb
445		->andWhere('o.payment_total <= :payment_total_end')
446		->setParameter('payment_total_end', $searchData['payment_total_end']);
447		}
448
449		// buy_product_name
450		if (isset($searchData['buy_product_name']) && Str::isNotBlank($searchData['buy_product_name'])) {

EC-CUBE / ec-cube

Code Duplication Length = 5-5 lines in 21 locations

src/Eccube/Repository/OrderRepository.php 18 locations

src/Eccube/Repository/CustomerRepository.php 3 locations