@@ -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 |