@@ -24,7 +24,7 @@ |
||
| 24 | 24 | } |
| 25 | 25 | |
| 26 | 26 | /** @var ShipmentItem $ShipmentItem */ |
| 27 | - foreach($this->ShipmentItems as $ShipmentItem) { |
|
| 27 | + foreach ($this->ShipmentItems as $ShipmentItem) { |
|
| 28 | 28 | if (!$this->Order->getShipmentItems()->contains($ShipmentItem)) { |
| 29 | 29 | $ShipmentItem->setOrder($this->Order); |
| 30 | 30 | $this->Order->addShipmentItem($ShipmentItem); |
@@ -274,7 +274,7 @@ |
||
| 274 | 274 | $multi = preg_match('/^\d+$/', $searchData['multi']) ? $searchData['multi'] : null; |
| 275 | 275 | $qb |
| 276 | 276 | ->andWhere('o.id = :multi OR o.name01 LIKE :likemulti OR o.name02 LIKE :likemulti OR ' . |
| 277 | - 'o.kana01 LIKE :likemulti OR o.kana02 LIKE :likemulti OR o.company_name LIKE :likemulti') |
|
| 277 | + 'o.kana01 LIKE :likemulti OR o.kana02 LIKE :likemulti OR o.company_name LIKE :likemulti') |
|
| 278 | 278 | ->setParameter('multi', $multi) |
| 279 | 279 | ->setParameter('likemulti', '%' . $searchData['multi'] . '%'); |
| 280 | 280 | } |
@@ -50,13 +50,13 @@ discard block |
||
| 50 | 50 | ->setParameter('order_id_start', $searchData['order_id_start']); |
| 51 | 51 | } |
| 52 | 52 | // multi |
| 53 | - if (isset( $searchData['multi']) && Str::isNotBlank($searchData['multi'])) { |
|
| 53 | + if (isset($searchData['multi']) && Str::isNotBlank($searchData['multi'])) { |
|
| 54 | 54 | $multi = preg_match('/^\d+$/', $searchData['multi']) ? $searchData['multi'] : null; |
| 55 | 55 | $qb |
| 56 | - ->andWhere('o.id = :multi OR o.name01 LIKE :likemulti OR o.name02 LIKE :likemulti OR ' . |
|
| 56 | + ->andWhere('o.id = :multi OR o.name01 LIKE :likemulti OR o.name02 LIKE :likemulti OR '. |
|
| 57 | 57 | 'o.kana01 LIKE :likemulti OR o.kana02 LIKE :likemulti OR o.company_name LIKE :likemulti') |
| 58 | 58 | ->setParameter('multi', $multi) |
| 59 | - ->setParameter('likemulti', '%' . $searchData['multi'] . '%'); |
|
| 59 | + ->setParameter('likemulti', '%'.$searchData['multi'].'%'); |
|
| 60 | 60 | } |
| 61 | 61 | |
| 62 | 62 | // order_id_end |
@@ -70,28 +70,28 @@ discard block |
||
| 70 | 70 | if (isset($searchData['name']) && Str::isNotBlank($searchData['name'])) { |
| 71 | 71 | $qb |
| 72 | 72 | ->andWhere('CONCAT(o.name01, o.name02) LIKE :name') |
| 73 | - ->setParameter('name', '%' . $searchData['name'] . '%'); |
|
| 73 | + ->setParameter('name', '%'.$searchData['name'].'%'); |
|
| 74 | 74 | } |
| 75 | 75 | |
| 76 | 76 | // kana |
| 77 | 77 | if (isset($searchData['kana']) && Str::isNotBlank($searchData['kana'])) { |
| 78 | 78 | $qb |
| 79 | 79 | ->andWhere('CONCAT(o.kana01, o.kana02) LIKE :kana') |
| 80 | - ->setParameter('kana', '%' . $searchData['kana'] . '%'); |
|
| 80 | + ->setParameter('kana', '%'.$searchData['kana'].'%'); |
|
| 81 | 81 | } |
| 82 | 82 | |
| 83 | 83 | |
| 84 | 84 | if (isset($searchData['email']) && Str::isNotBlank($searchData['email'])) { |
| 85 | 85 | $qb |
| 86 | 86 | ->andWhere('o.email like :email') |
| 87 | - ->setParameter('email', '%' . $searchData['email'] . '%'); |
|
| 87 | + ->setParameter('email', '%'.$searchData['email'].'%'); |
|
| 88 | 88 | } |
| 89 | 89 | |
| 90 | 90 | // tel |
| 91 | 91 | if (isset($searchData['tel']) && Str::isNotBlank($searchData['tel'])) { |
| 92 | 92 | $qb |
| 93 | 93 | ->andWhere('CONCAT(o.tel01, o.tel02, o.tel03) LIKE :tel') |
| 94 | - ->setParameter('tel', '%' . $searchData['tel'] . '%'); |
|
| 94 | + ->setParameter('tel', '%'.$searchData['tel'].'%'); |
|
| 95 | 95 | } |
| 96 | 96 | |
| 97 | 97 | // sex |
@@ -195,7 +195,7 @@ discard block |
||
| 195 | 195 | $qb |
| 196 | 196 | ->leftJoin('o.OrderDetails', 'od') |
| 197 | 197 | ->andWhere('od.product_name LIKE :buy_product_name') |
| 198 | - ->setParameter('buy_product_name', '%' . $searchData['buy_product_name'] . '%'); |
|
| 198 | + ->setParameter('buy_product_name', '%'.$searchData['buy_product_name'].'%'); |
|
| 199 | 199 | } |
| 200 | 200 | |
| 201 | 201 | // Order By |