ShippingRepository::findShippingsProduct() - Code Metrics - Inspection of "出荷管理機能の実装" - EC-CUBE/ec-cube - Measure and Improve Code Quality continuously with Scrutinizer

Failed Conditions

Pull Request — experimental/3.1 (#2322)

by Kentaro

created 2017-05-17 10:17 UTC

ShippingRepository::findShippingsProduct() A

↳ Parent: ShippingRepository

Complexity

Conditions	1
Paths	1

Size

Total Lines	14
Code Lines	10

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	2

Importance

Changes

Metric	Value
cc	1
eloc	10
nc	1
nop	2
dl	0
loc	14
ccs	0
cts	0
cp	0
crap	2
rs	9.4285
c	0
b	0
f	0

<?php
/*
 * This file is part of EC-CUBE
 *
 * Copyright(c) 2000-2015 LOCKON CO.,LTD. All Rights Reserved.
 *
 * http://www.lockon.co.jp/
 *
 * This program is free software; you can redistribute it and/or
 * modify it under the terms of the GNU General Public License
 * as published by the Free Software Foundation; either version 2
 * of the License, or (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program; if not, write to the Free Software
 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
 */


namespace Eccube\Repository;

use Eccube\Util\Str;

/**
 * ShippingRepository
 *
 * This class was generated by the Doctrine ORM. Add your own custom
 * repository methods below.
 */
class ShippingRepository extends AbstractRepository
{
    /**
     *
     * @param  array        $searchData

     * @return QueryBuilder
     */
    public function getQueryBuilderBySearchDataForAdmin($searchData)
    {
        $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;
            $qb
                ->andWhere('o.id = :multi OR o.name01 LIKE :likemulti OR o.name02 LIKE :likemulti OR ' .

                           'o.kana01 LIKE :likemulti OR o.kana02 LIKE :likemulti OR o.company_name LIKE :likemulti')

                ->setParameter('multi', $multi)
                ->setParameter('likemulti', '%' . $searchData['multi'] . '%');

        }

        // 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']);
        }

        // 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'])) {
            $qb
                ->andWhere('CONCAT(o.kana01, o.kana02) LIKE :kana')
                ->setParameter('kana', '%' . $searchData['kana'] . '%');

        }

        // 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'])) {
            $qb
                ->andWhere('CONCAT(o.tel01, o.tel02, o.tel03) LIKE :tel')
                ->setParameter('tel', '%' . $searchData['tel'] . '%');

        }

        // sex
        if (!empty($searchData['sex']) && count($searchData['sex']) > 0) {
            $qb
                ->andWhere($qb->expr()->in('o.Sex', ':sex'))
                ->setParameter('sex', $searchData['sex']->toArray());
        }

        // payment
        if (!empty($searchData['payment']) && count($searchData['payment'])) {
            $payments = array();
            foreach ($searchData['payment'] as $payment) {
                $payments[] = $payment->getId();
            }
            $qb
                ->leftJoin('o.Payment', 'p')
                ->andWhere($qb->expr()->in('p.id', ':payments'))
                ->setParameter('payments', $payments);
        }

        // oreder_date
        if (!empty($searchData['order_date_start']) && $searchData['order_date_start']) {
            $date = $searchData['order_date_start'];
            $qb
                ->andWhere('o.order_date >= :order_date_start')
                ->setParameter('order_date_start', $date);
        }
        if (!empty($searchData['order_date_end']) && $searchData['order_date_end']) {
            $date = clone $searchData['order_date_end'];
            $date = $date
                ->modify('+1 days');
            $qb
                ->andWhere('o.order_date < :order_date_end')
                ->setParameter('order_date_end', $date);
        }

        // payment_date
        if (!empty($searchData['payment_date_start']) && $searchData['payment_date_start']) {
            $date = $searchData['payment_date_start'];
            $qb
                ->andWhere('o.payment_date >= :payment_date_start')
                ->setParameter('payment_date_start', $date);
        }
        if (!empty($searchData['payment_date_end']) && $searchData['payment_date_end']) {
            $date = clone $searchData['payment_date_end'];
            $date = $date
                ->modify('+1 days');
            $qb
                ->andWhere('o.payment_date < :payment_date_end')
                ->setParameter('payment_date_end', $date);
        }

        // commit_date
        if (!empty($searchData['commit_date_start']) && $searchData['commit_date_start']) {
            $date = $searchData['commit_date_start'];
            $qb
                ->andWhere('o.commit_date >= :commit_date_start')
                ->setParameter('commit_date_start', $date);
        }
        if (!empty($searchData['commit_date_end']) && $searchData['commit_date_end']) {
            $date = clone $searchData['commit_date_end'];
            $date = $date
                ->modify('+1 days');
            $qb
                ->andWhere('o.commit_date < :commit_date_end')
                ->setParameter('commit_date_end', $date);
        }


        // update_date
        if (!empty($searchData['update_date_start']) && $searchData['update_date_start']) {
            $date = $searchData['update_date_start'];
            $qb
                ->andWhere('o.update_date >= :update_date_start')
                ->setParameter('update_date_start', $date);
        }
        if (!empty($searchData['update_date_end']) && $searchData['update_date_end']) {
            $date = clone $searchData['update_date_end'];
            $date = $date
                ->modify('+1 days');
            $qb
                ->andWhere('o.update_date < :update_date_end')
                ->setParameter('update_date_end', $date);
        }

        // 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')
                ->setParameter('payment_total_end', $searchData['payment_total_end']);
        }

        // buy_product_name
        if (isset($searchData['buy_product_name']) && Str::isNotBlank($searchData['buy_product_name'])) {
            $qb
                ->leftJoin('o.OrderDetails', 'od')
                ->andWhere('od.product_name LIKE :buy_product_name')
                ->setParameter('buy_product_name', '%' . $searchData['buy_product_name'] . '%');

        }

        // Order By
        $qb->orderBy('o.update_date', 'DESC');
        $qb->addorderBy('o.id', 'DESC');

        return $qb;
    }

    /**

     * 同一商品のお届け先情報を取得
     *
     * @param $Order

     * @return array
     */
    public function findShippingsProduct($Order, $productClass)
    {
        $shippings = $this->createQueryBuilder('s')
            ->innerJoin('Eccube\Entity\ShipmentItem', 'si', 'WITH', 'si.Shipping = s.id')
            ->where('si.Order = (:order)')
            ->andWhere('si.ProductClass = (:productClass)')
            ->setParameter('order', $Order)
            ->setParameter('productClass', $productClass)
            ->getQuery()
            ->getResult();

        return $shippings;

    }

}


1			<?php
2			/*
3			* This file is part of EC-CUBE
4			*
5			* Copyright(c) 2000-2015 LOCKON CO.,LTD. All Rights Reserved.
6			*
7			* http://www.lockon.co.jp/
8			*
9			* This program is free software; you can redistribute it and/or
10			* modify it under the terms of the GNU General Public License
11			* as published by the Free Software Foundation; either version 2
12			* of the License, or (at your option) any later version.
13			*
14			* This program is distributed in the hope that it will be useful,
15			* but WITHOUT ANY WARRANTY; without even the implied warranty of
16			* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
17			* GNU General Public License for more details.
18			*
19			* You should have received a copy of the GNU General Public License
20			* along with this program; if not, write to the Free Software
21			* Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
22			*/
23
24
25			namespace Eccube\Repository;
26
27			use Eccube\Util\Str;
28
29			/**
30			* ShippingRepository
31			*
32			* This class was generated by the Doctrine ORM. Add your own custom
33			* repository methods below.
34			*/
35			class ShippingRepository extends AbstractRepository
36			{
37			/**
38			*
39			* @param array $searchData
			0 ignored issues – show introduced 2015-11-21 02:41 UTC by Report Bug Copy Issue Report Expected 1 spaces after parameter type; 8 found Loading history...
40			* @return QueryBuilder
41			*/
42			public function getQueryBuilderBySearchDataForAdmin($searchData)
43			{
44	1		$qb = $this->createQueryBuilder('o');
45
46	1		// order_id_start
47	1	View Code Duplication	if (isset($searchData['order_id_start']) && Str::isNotBlank($searchData['order_id_start'])) {
48	1		$qb
49	1		->andWhere('o.id >= :order_id_start')
50	1		->setParameter('order_id_start', $searchData['order_id_start']);
51	1		}
52	1		// multi
53	1	View Code Duplication	if (isset( $searchData['multi']) && Str::isNotBlank($searchData['multi'])) {
54	1		$multi = preg_match('/^\d+$/', $searchData['multi']) ? $searchData['multi'] : null;
55			$qb
56	1		->andWhere('o.id = :multi OR o.name01 LIKE :likemulti OR o.name02 LIKE :likemulti OR ' .
			0 ignored issues – show Coding Style introduced 2015-11-21 02:41 UTC by Report Bug Copy Issue Report Concat operator must not be surrounded by spaces Loading history...
57			'o.kana01 LIKE :likemulti OR o.kana02 LIKE :likemulti OR o.company_name LIKE :likemulti')
			0 ignored issues – show Coding Style introduced 2016-02-05 00:57 UTC by Report Bug Copy Issue Report This line of the multi-line function call does not seem to be indented correctly. Expected `16` spaces, but found `27`. Loading history...
58			->setParameter('multi', $multi)
59			->setParameter('likemulti', '%' . $searchData['multi'] . '%');
			0 ignored issues – show Coding Style introduced 2015-11-21 02:41 UTC by Report Bug Copy Issue Report Concat operator must not be surrounded by spaces Loading history...
60			}
61
62			// order_id_end
63		View Code Duplication	if (isset($searchData['order_id_end']) && Str::isNotBlank($searchData['order_id_end'])) {
64			$qb
65			->andWhere('o.id <= :order_id_end')
66			->setParameter('order_id_end', $searchData['order_id_end']);
67			}
68
69			// name
70		View Code Duplication	if (isset($searchData['name']) && Str::isNotBlank($searchData['name'])) {
71			$qb
72			->andWhere('CONCAT(o.name01, o.name02) LIKE :name')
73			->setParameter('name', '%' . $searchData['name'] . '%');
			0 ignored issues – show Coding Style introduced 2015-11-21 02:41 UTC by Report Bug Copy Issue Report Concat operator must not be surrounded by spaces Loading history...
74			}
75
76			// kana
77		View Code Duplication	if (isset($searchData['kana']) && Str::isNotBlank($searchData['kana'])) {
78			$qb
79			->andWhere('CONCAT(o.kana01, o.kana02) LIKE :kana')
80			->setParameter('kana', '%' . $searchData['kana'] . '%');
			0 ignored issues – show Coding Style introduced 2015-11-21 02:41 UTC by Report Bug Copy Issue Report Concat operator must not be surrounded by spaces Loading history...
81			}
82
83			// email
84		View Code Duplication	if (isset($searchData['email']) && Str::isNotBlank($searchData['email'])) {
85			$qb
86			->andWhere('o.email like :email')
87			->setParameter('email', '%' . $searchData['email'] . '%');
			0 ignored issues – show Coding Style introduced 2015-11-21 02:41 UTC by Report Bug Copy Issue Report Concat operator must not be surrounded by spaces Loading history...
88			}
89
90			// tel
91		View Code Duplication	if (isset($searchData['tel']) && Str::isNotBlank($searchData['tel'])) {
92			$qb
93			->andWhere('CONCAT(o.tel01, o.tel02, o.tel03) LIKE :tel')
94			->setParameter('tel', '%' . $searchData['tel'] . '%');
			0 ignored issues – show Coding Style introduced 2015-11-21 02:41 UTC by Report Bug Copy Issue Report Concat operator must not be surrounded by spaces Loading history...
95			}
96
97			// sex
98		View Code Duplication	if (!empty($searchData['sex']) && count($searchData['sex']) > 0) {
99			$qb
100			->andWhere($qb->expr()->in('o.Sex', ':sex'))
101			->setParameter('sex', $searchData['sex']->toArray());
102			}
103
104			// payment
105		View Code Duplication	if (!empty($searchData['payment']) && count($searchData['payment'])) {
106			$payments = array();
107			foreach ($searchData['payment'] as $payment) {
108			$payments[] = $payment->getId();
109			}
110			$qb
111			->leftJoin('o.Payment', 'p')
112			->andWhere($qb->expr()->in('p.id', ':payments'))
113			->setParameter('payments', $payments);
114			}
115
116			// oreder_date
117		View Code Duplication	if (!empty($searchData['order_date_start']) && $searchData['order_date_start']) {
118			$date = $searchData['order_date_start'];
119			$qb
120			->andWhere('o.order_date >= :order_date_start')
121			->setParameter('order_date_start', $date);
122			}
123		View Code Duplication	if (!empty($searchData['order_date_end']) && $searchData['order_date_end']) {
124			$date = clone $searchData['order_date_end'];
125			$date = $date
126			->modify('+1 days');
127			$qb
128			->andWhere('o.order_date < :order_date_end')
129			->setParameter('order_date_end', $date);
130			}
131
132			// payment_date
133		View Code Duplication	if (!empty($searchData['payment_date_start']) && $searchData['payment_date_start']) {
134			$date = $searchData['payment_date_start'];
135			$qb
136			->andWhere('o.payment_date >= :payment_date_start')
137			->setParameter('payment_date_start', $date);
138			}
139		View Code Duplication	if (!empty($searchData['payment_date_end']) && $searchData['payment_date_end']) {
140			$date = clone $searchData['payment_date_end'];
141			$date = $date
142			->modify('+1 days');
143			$qb
144			->andWhere('o.payment_date < :payment_date_end')
145			->setParameter('payment_date_end', $date);
146			}
147
148			// commit_date
149		View Code Duplication	if (!empty($searchData['commit_date_start']) && $searchData['commit_date_start']) {
150			$date = $searchData['commit_date_start'];
151			$qb
152			->andWhere('o.commit_date >= :commit_date_start')
153			->setParameter('commit_date_start', $date);
154			}
155		View Code Duplication	if (!empty($searchData['commit_date_end']) && $searchData['commit_date_end']) {
156			$date = clone $searchData['commit_date_end'];
157			$date = $date
158			->modify('+1 days');
159			$qb
160			->andWhere('o.commit_date < :commit_date_end')
161			->setParameter('commit_date_end', $date);
162			}
163
164
165			// update_date
166		View Code Duplication	if (!empty($searchData['update_date_start']) && $searchData['update_date_start']) {
167			$date = $searchData['update_date_start'];
168			$qb
169			->andWhere('o.update_date >= :update_date_start')
170			->setParameter('update_date_start', $date);
171			}
172		View Code Duplication	if (!empty($searchData['update_date_end']) && $searchData['update_date_end']) {
173			$date = clone $searchData['update_date_end'];
174			$date = $date
175			->modify('+1 days');
176			$qb
177			->andWhere('o.update_date < :update_date_end')
178			->setParameter('update_date_end', $date);
179			}
180
181			// payment_total
182		View Code Duplication	if (isset($searchData['payment_total_start']) && Str::isNotBlank($searchData['payment_total_start'])) {
183			$qb
184			->andWhere('o.payment_total >= :payment_total_start')
185			->setParameter('payment_total_start', $searchData['payment_total_start']);
186			}
187		View Code Duplication	if (isset($searchData['payment_total_end']) && Str::isNotBlank($searchData['payment_total_end'])) {
188			$qb
189			->andWhere('o.payment_total <= :payment_total_end')
190			->setParameter('payment_total_end', $searchData['payment_total_end']);
191			}
192
193			// buy_product_name
194		View Code Duplication	if (isset($searchData['buy_product_name']) && Str::isNotBlank($searchData['buy_product_name'])) {
195			$qb
196			->leftJoin('o.OrderDetails', 'od')
197			->andWhere('od.product_name LIKE :buy_product_name')
198			->setParameter('buy_product_name', '%' . $searchData['buy_product_name'] . '%');
			0 ignored issues – show Coding Style introduced 2015-11-21 02:41 UTC by Report Bug Copy Issue Report Concat operator must not be surrounded by spaces Loading history...
199			}
200
201			// Order By
202			$qb->orderBy('o.update_date', 'DESC');
203			$qb->addorderBy('o.id', 'DESC');
204
205			return $qb;
206			}
207
208			/**
			0 ignored issues – show introduced 2017-05-17 11:06 UTC by Report Bug Copy Issue Report Doc comment for parameter "$Order" missing Loading history... introduced 2017-05-17 11:06 UTC by Report Bug Copy Issue Report Doc comment for parameter "$productClass" missing Loading history...
209			* 同一商品のお届け先情報を取得
210			*
211			* @param $Order
			0 ignored issues – show introduced 2015-11-21 02:41 UTC by Report Bug Copy Issue Report Missing parameter name Loading history...
212			* @return array
213			*/
214			public function findShippingsProduct($Order, $productClass)
215			{
216			$shippings = $this->createQueryBuilder('s')
217			->innerJoin('Eccube\Entity\ShipmentItem', 'si', 'WITH', 'si.Shipping = s.id')
218			->where('si.Order = (:order)')
219			->andWhere('si.ProductClass = (:productClass)')
220			->setParameter('order', $Order)
221			->setParameter('productClass', $productClass)
222			->getQuery()
223			->getResult();
224
225			return $shippings;
226
227			}
228
229			}
230

EC-CUBE / ec-cube

Pull Request — experimental/3.1 (#2322)

ShippingRepository::findShippingsProduct() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like