EC-CUBE /
ec-cube
Duplicate code is one of the most pungent code smells. A rule that is often used is to re-structure code once it is duplicated in three or more places.
Common duplication problems, and corresponding solutions are:
Complex classes like OrderRepository often do a lot of different things. To break such a class down, we need to identify a cohesive component within that class. A common approach to find such a component is to look for fields/methods that share the same prefixes, or suffixes. You can also have a look at the cohesion graph to spot any un-connected, or weakly-connected components.
Once you have determined the fields that belong together, you can apply the Extract Class refactoring. If the component makes sense as a sub-class, Extract Subclass is also a candidate, and is often faster.
While breaking up the class, it is a good idea to analyze how other classes use OrderRepository, and based on these observations, apply Extract Interface, too.
| 1 | <?php |
||
| 37 | class OrderRepository extends EntityRepository |
||
| 38 | { |
||
| 39 | protected $app; |
||
| 40 | |||
| 41 | 194 | public function setApplication($app) |
|
| 45 | |||
| 46 | 7 | public function changeStatus($orderId, \Eccube\Entity\Master\OrderStatus $Status) |
|
| 66 | |||
| 67 | /** |
||
| 68 | * |
||
| 69 | * @param array $searchData |
||
| 70 | * @return QueryBuilder |
||
| 71 | */ |
||
| 72 | 19 | public function getQueryBuilderBySearchData($searchData) |
|
| 255 | |||
| 256 | |||
| 257 | /** |
||
| 258 | * |
||
| 259 | * @param array $searchData |
||
| 260 | * @return QueryBuilder |
||
| 261 | */ |
||
| 262 | 32 | public function getQueryBuilderBySearchDataForAdmin($searchData) |
|
| 263 | { |
||
| 264 | 32 | $qb = $this->createQueryBuilder('o'); |
|
| 265 | |||
| 266 | // order_id_start |
||
| 267 | 32 | View Code Duplication | if (isset($searchData['order_id_start']) && Str::isNotBlank($searchData['order_id_start'])) { |
| 268 | $qb |
||
| 269 | 1 | ->andWhere('o.id >= :order_id_start') |
|
| 270 | 1 | ->setParameter('order_id_start', $searchData['order_id_start']); |
|
| 271 | } |
||
| 272 | // multi |
||
| 273 | 32 | View Code Duplication | if (isset( $searchData['multi']) && Str::isNotBlank($searchData['multi'])) { |
| 274 | 5 | $multi = preg_match('/^\d+$/', $searchData['multi']) ? $searchData['multi'] : null; |
|
| 275 | $qb |
||
| 276 | 5 | ->andWhere('o.id = :multi OR o.name01 LIKE :likemulti OR o.name02 LIKE :likemulti OR ' . |
|
| 277 | 5 | 'o.kana01 LIKE :likemulti OR o.kana02 LIKE :likemulti OR o.company_name LIKE :likemulti') |
|
| 278 | 5 | ->setParameter('multi', $multi) |
|
| 279 | 5 | ->setParameter('likemulti', '%' . $searchData['multi'] . '%'); |
|
| 280 | } |
||
| 281 | |||
| 282 | // order_id_end |
||
| 283 | 32 | View Code Duplication | if (isset($searchData['order_id_end']) && Str::isNotBlank($searchData['order_id_end'])) { |
| 284 | $qb |
||
| 285 | 1 | ->andWhere('o.id <= :order_id_end') |
|
| 286 | 1 | ->setParameter('order_id_end', $searchData['order_id_end']); |
|
| 287 | } |
||
| 288 | |||
| 289 | // status |
||
| 290 | 32 | $filterStatus = false; |
|
| 291 | 32 | View Code Duplication | if (!empty($searchData['status']) && $searchData['status']) { |
| 292 | $qb |
||
| 293 | 3 | ->andWhere('o.OrderStatus = :status') |
|
| 294 | 3 | ->setParameter('status', $searchData['status']); |
|
| 295 | 3 | $filterStatus = true; |
|
| 296 | } |
||
| 297 | 32 | if (!empty($searchData['multi_status']) && count($searchData['multi_status'])) { |
|
| 298 | $qb |
||
| 299 | 1 | ->andWhere($qb->expr()->in('o.OrderStatus', ':multi_status')) |
|
| 300 | 1 | ->setParameter('multi_status', $searchData['multi_status']->toArray()); |
|
| 301 | 1 | $filterStatus = true; |
|
| 302 | } |
||
| 303 | 32 | if (!$filterStatus) { |
|
| 304 | // 購入処理中は検索対象から除外 |
||
| 305 | 28 | $OrderStatuses = $this->getEntityManager() |
|
| 306 | 28 | ->getRepository('Eccube\Entity\Master\OrderStatus') |
|
| 307 | 28 | ->findNotContainsBy(array('id' => $this->app['config']['order_processing'])); |
|
| 308 | 28 | $qb->andWhere($qb->expr()->in('o.OrderStatus', ':status')) |
|
| 309 | 28 | ->setParameter('status', $OrderStatuses); |
|
| 310 | } |
||
| 311 | |||
| 312 | // name |
||
| 313 | 32 | View Code Duplication | if (isset($searchData['name']) && Str::isNotBlank($searchData['name'])) { |
| 314 | $qb |
||
| 315 | 1 | ->andWhere('CONCAT(o.name01, o.name02) LIKE :name') |
|
| 316 | 1 | ->setParameter('name', '%' . $searchData['name'] . '%'); |
|
| 317 | } |
||
| 318 | |||
| 319 | // kana |
||
| 320 | 32 | View Code Duplication | if (isset($searchData['kana']) && Str::isNotBlank($searchData['kana'])) { |
| 321 | $qb |
||
| 322 | 1 | ->andWhere('CONCAT(o.kana01, o.kana02) LIKE :kana') |
|
| 323 | 1 | ->setParameter('kana', '%' . $searchData['kana'] . '%'); |
|
| 324 | } |
||
| 325 | |||
| 326 | |||
| 327 | 32 | View Code Duplication | if (isset($searchData['email']) && Str::isNotBlank($searchData['email'])) { |
| 328 | $qb |
||
| 329 | 2 | ->andWhere('o.email like :email') |
|
| 330 | 2 | ->setParameter('email', '%' . $searchData['email'] . '%'); |
|
| 331 | } |
||
| 332 | |||
| 333 | // tel |
||
| 334 | 32 | View Code Duplication | if (isset($searchData['tel']) && Str::isNotBlank($searchData['tel'])) { |
| 335 | $qb |
||
| 336 | 1 | ->andWhere('CONCAT(o.tel01, o.tel02, o.tel03) LIKE :tel') |
|
| 337 | 1 | ->setParameter('tel', '%' . $searchData['tel'] . '%'); |
|
| 338 | } |
||
| 339 | |||
| 340 | // sex |
||
| 341 | 32 | if (!empty($searchData['sex']) && count($searchData['sex']) > 0) { |
|
| 342 | $qb |
||
| 343 | 3 | ->andWhere($qb->expr()->in('o.Sex', ':sex')) |
|
| 344 | 3 | ->setParameter('sex', $searchData['sex']->toArray()); |
|
| 345 | } |
||
| 346 | |||
| 347 | // payment |
||
| 348 | 32 | View Code Duplication | if (!empty($searchData['payment']) && count($searchData['payment'])) { |
| 349 | 2 | $payments = array(); |
|
| 350 | 2 | foreach ($searchData['payment'] as $payment) { |
|
| 351 | 2 | $payments[] = $payment->getId(); |
|
| 352 | } |
||
| 353 | $qb |
||
| 354 | 2 | ->leftJoin('o.Payment', 'p') |
|
| 355 | 2 | ->andWhere($qb->expr()->in('p.id', ':payments')) |
|
| 356 | 2 | ->setParameter('payments', $payments); |
|
| 357 | } |
||
| 358 | |||
| 359 | // oreder_date |
||
| 360 | 32 | View Code Duplication | if (!empty($searchData['order_date_start']) && $searchData['order_date_start']) { |
| 361 | 1 | $date = $searchData['order_date_start'] |
|
| 362 | 1 | ->format('Y-m-d H:i:s'); |
|
| 363 | $qb |
||
| 364 | 1 | ->andWhere('o.order_date >= :order_date_start') |
|
| 365 | 1 | ->setParameter('order_date_start', $date); |
|
| 366 | } |
||
| 367 | 32 | View Code Duplication | if (!empty($searchData['order_date_end']) && $searchData['order_date_end']) { |
| 368 | 1 | $date = clone $searchData['order_date_end']; |
|
| 369 | $date = $date |
||
| 370 | 1 | ->modify('+1 days') |
|
| 371 | 1 | ->format('Y-m-d H:i:s'); |
|
| 372 | $qb |
||
| 373 | 1 | ->andWhere('o.order_date < :order_date_end') |
|
| 374 | 1 | ->setParameter('order_date_end', $date); |
|
| 375 | } |
||
| 376 | |||
| 377 | // payment_date |
||
| 378 | 32 | View Code Duplication | if (!empty($searchData['payment_date_start']) && $searchData['payment_date_start']) { |
| 379 | 1 | $date = $searchData['payment_date_start'] |
|
| 380 | 1 | ->format('Y-m-d H:i:s'); |
|
| 381 | $qb |
||
| 382 | 1 | ->andWhere('o.payment_date >= :payment_date_start') |
|
| 383 | 1 | ->setParameter('payment_date_start', $date); |
|
| 384 | } |
||
| 385 | 32 | View Code Duplication | if (!empty($searchData['payment_date_end']) && $searchData['payment_date_end']) { |
| 386 | 1 | $date = clone $searchData['payment_date_end']; |
|
| 387 | $date = $date |
||
| 388 | 1 | ->modify('+1 days') |
|
| 389 | 1 | ->format('Y-m-d H:i:s'); |
|
| 390 | $qb |
||
| 391 | 1 | ->andWhere('o.payment_date < :payment_date_end') |
|
| 392 | 1 | ->setParameter('payment_date_end', $date); |
|
| 393 | } |
||
| 394 | |||
| 395 | // commit_date |
||
| 396 | 32 | View Code Duplication | if (!empty($searchData['commit_date_start']) && $searchData['commit_date_start']) { |
| 397 | 1 | $date = $searchData['commit_date_start'] |
|
| 398 | 1 | ->format('Y-m-d H:i:s'); |
|
| 399 | $qb |
||
| 400 | 1 | ->andWhere('o.commit_date >= :commit_date_start') |
|
| 401 | 1 | ->setParameter('commit_date_start', $date); |
|
| 402 | } |
||
| 403 | 32 | View Code Duplication | if (!empty($searchData['commit_date_end']) && $searchData['commit_date_end']) { |
| 404 | 1 | $date = clone $searchData['commit_date_end']; |
|
| 405 | $date = $date |
||
| 406 | 1 | ->modify('+1 days') |
|
| 407 | 1 | ->format('Y-m-d H:i:s'); |
|
| 408 | $qb |
||
| 409 | 1 | ->andWhere('o.commit_date < :commit_date_end') |
|
| 410 | 1 | ->setParameter('commit_date_end', $date); |
|
| 411 | } |
||
| 412 | |||
| 413 | |||
| 414 | // update_date |
||
| 415 | 32 | View Code Duplication | if (!empty($searchData['update_date_start']) && $searchData['update_date_start']) { |
| 416 | 1 | $date = $searchData['update_date_start'] |
|
| 417 | 1 | ->format('Y-m-d H:i:s'); |
|
| 418 | $qb |
||
| 419 | 1 | ->andWhere('o.update_date >= :update_date_start') |
|
| 420 | 1 | ->setParameter('update_date_start', $date); |
|
| 421 | } |
||
| 422 | 32 | View Code Duplication | if (!empty($searchData['update_date_end']) && $searchData['update_date_end']) { |
| 423 | 1 | $date = clone $searchData['update_date_end']; |
|
| 424 | $date = $date |
||
| 425 | 1 | ->modify('+1 days') |
|
| 426 | 1 | ->format('Y-m-d H:i:s'); |
|
| 427 | $qb |
||
| 428 | 1 | ->andWhere('o.update_date < :update_date_end') |
|
| 429 | 1 | ->setParameter('update_date_end', $date); |
|
| 430 | } |
||
| 431 | |||
| 432 | // payment_total |
||
| 433 | 32 | View Code Duplication | if (isset($searchData['payment_total_start']) && Str::isNotBlank($searchData['payment_total_start'])) { |
| 434 | $qb |
||
| 435 | 1 | ->andWhere('o.payment_total >= :payment_total_start') |
|
| 436 | 1 | ->setParameter('payment_total_start', $searchData['payment_total_start']); |
|
| 437 | } |
||
| 438 | 32 | View Code Duplication | if (isset($searchData['payment_total_end']) && Str::isNotBlank($searchData['payment_total_end'])) { |
| 439 | $qb |
||
| 440 | 1 | ->andWhere('o.payment_total <= :payment_total_end') |
|
| 441 | 1 | ->setParameter('payment_total_end', $searchData['payment_total_end']); |
|
| 442 | } |
||
| 443 | |||
| 444 | // buy_product_name |
||
| 445 | 32 | View Code Duplication | if (isset($searchData['buy_product_name']) && Str::isNotBlank($searchData['buy_product_name'])) { |
| 446 | $qb |
||
| 447 | 1 | ->leftJoin('o.OrderDetails', 'od') |
|
| 448 | 1 | ->andWhere('od.product_name LIKE :buy_product_name') |
|
| 449 | 1 | ->setParameter('buy_product_name', '%' . $searchData['buy_product_name'] . '%'); |
|
| 450 | } |
||
| 451 | |||
| 452 | // Order By |
||
| 453 | 32 | $qb->orderBy('o.update_date', 'DESC'); |
|
| 454 | 32 | $qb->addorderBy('o.id', 'DESC'); |
|
| 455 | |||
| 456 | 32 | return $qb; |
|
| 457 | } |
||
| 458 | |||
| 459 | |||
| 460 | /** |
||
| 461 | * @param \Eccube\Entity\Customer $Customer |
||
| 462 | * @return QueryBuilder |
||
| 463 | */ |
||
| 464 | 10 | public function getQueryBuilderByCustomer(\Eccube\Entity\Customer $Customer) |
|
| 475 | |||
| 476 | /** |
||
| 477 | * 新規受付一覧の取得 |
||
| 478 | * |
||
| 479 | * @return \Eccube\Entity\Order[] |
||
| 480 | */ |
||
| 481 | 1 | public function getNew() |
|
| 494 | |||
| 495 | /** |
||
| 496 | * 会員の合計購入金額を取得、回数を取得 |
||
| 497 | * |
||
| 498 | * @param \Eccube\Entity\Customer $Customer |
||
| 499 | * @param array $OrderStatuses |
||
| 500 | * @return QueryBuilder |
||
| 501 | */ |
||
| 502 | 16 | public function getCustomerCount(\Eccube\Entity\Customer $Customer, array $OrderStatuses) |
|
| 517 | } |
||
| 518 |
Loading history...
