@@ -52,13 +52,13 @@ discard block |
||
52 | 52 | ->setParameter('shipping_id_start', $searchData['shipping_id_start']); |
53 | 53 | } |
54 | 54 | // multi |
55 | - if (isset( $searchData['multi']) && Str::isNotBlank($searchData['multi'])) { |
|
55 | + if (isset($searchData['multi']) && Str::isNotBlank($searchData['multi'])) { |
|
56 | 56 | $multi = preg_match('/^\d+$/', $searchData['multi']) ? $searchData['multi'] : null; |
57 | 57 | $qb |
58 | - ->andWhere('s.id = :multi OR s.name01 LIKE :likemulti OR s.name02 LIKE :likemulti OR ' . |
|
58 | + ->andWhere('s.id = :multi OR s.name01 LIKE :likemulti OR s.name02 LIKE :likemulti OR '. |
|
59 | 59 | 's.kana01 LIKE :likemulti OR s.kana02 LIKE :likemulti OR s.company_name LIKE :likemulti') |
60 | 60 | ->setParameter('multi', $multi) |
61 | - ->setParameter('likemulti', '%' . $searchData['multi'] . '%'); |
|
61 | + ->setParameter('likemulti', '%'.$searchData['multi'].'%'); |
|
62 | 62 | } |
63 | 63 | |
64 | 64 | // shipping_id_end |
@@ -91,42 +91,42 @@ discard block |
||
91 | 91 | if (isset($searchData['name']) && Str::isNotBlank($searchData['name'])) { |
92 | 92 | $qb |
93 | 93 | ->andWhere('CONCAT(s.name01, s.name02) LIKE :name') |
94 | - ->setParameter('name', '%' . $searchData['name'] . '%'); |
|
94 | + ->setParameter('name', '%'.$searchData['name'].'%'); |
|
95 | 95 | } |
96 | 96 | |
97 | 97 | // kana |
98 | 98 | if (isset($searchData['kana']) && Str::isNotBlank($searchData['kana'])) { |
99 | 99 | $qb |
100 | 100 | ->andWhere('CONCAT(s.kana01, s.kana02) LIKE :kana') |
101 | - ->setParameter('kana', '%' . $searchData['kana'] . '%'); |
|
101 | + ->setParameter('kana', '%'.$searchData['kana'].'%'); |
|
102 | 102 | } |
103 | 103 | |
104 | 104 | // order_name |
105 | 105 | if (isset($searchData['order_name']) && Str::isNotBlank($searchData['order_name'])) { |
106 | 106 | $qb |
107 | 107 | ->andWhere('CONCAT(o.name01, o.name02) LIKE :order_name') |
108 | - ->setParameter('order_name', '%' . $searchData['order_name'] . '%'); |
|
108 | + ->setParameter('order_name', '%'.$searchData['order_name'].'%'); |
|
109 | 109 | } |
110 | 110 | |
111 | 111 | // order_kana |
112 | 112 | if (isset($searchData['order_kana']) && Str::isNotBlank($searchData['order_kana'])) { |
113 | 113 | $qb |
114 | 114 | ->andWhere('CONCAT(o.kana01, s.kana02) LIKE :order_kana') |
115 | - ->setParameter('kana', '%' . $searchData['order_kana'] . '%'); |
|
115 | + ->setParameter('kana', '%'.$searchData['order_kana'].'%'); |
|
116 | 116 | } |
117 | 117 | |
118 | 118 | // order_email |
119 | 119 | if (isset($searchData['email']) && Str::isNotBlank($searchData['email'])) { |
120 | 120 | $qb |
121 | 121 | ->andWhere('o.email like :email') |
122 | - ->setParameter('email', '%' . $searchData['email'] . '%'); |
|
122 | + ->setParameter('email', '%'.$searchData['email'].'%'); |
|
123 | 123 | } |
124 | 124 | |
125 | 125 | // tel |
126 | 126 | if (isset($searchData['tel']) && Str::isNotBlank($searchData['tel'])) { |
127 | 127 | $qb |
128 | 128 | ->andWhere('CONCAT(s.tel01, s.tel02, s.tel03) LIKE :tel') |
129 | - ->setParameter('tel', '%' . $searchData['tel'] . '%'); |
|
129 | + ->setParameter('tel', '%'.$searchData['tel'].'%'); |
|
130 | 130 | } |
131 | 131 | |
132 | 132 | // payment |
@@ -222,7 +222,7 @@ discard block |
||
222 | 222 | if (isset($searchData['buy_product_name']) && Str::isNotBlank($searchData['buy_product_name'])) { |
223 | 223 | $qb |
224 | 224 | ->andWhere('si.product_name LIKE :buy_product_name') |
225 | - ->setParameter('buy_product_name', '%' . $searchData['buy_product_name'] . '%'); |
|
225 | + ->setParameter('buy_product_name', '%'.$searchData['buy_product_name'].'%'); |
|
226 | 226 | } |
227 | 227 | |
228 | 228 | // Order By |