@@ 273-280 (lines=8) @@ | ||
270 | ->setParameter('order_id_start', $searchData['order_id_start']); |
|
271 | } |
|
272 | // multi |
|
273 | if (isset( $searchData['multi']) && Str::isNotBlank($searchData['multi'])) { |
|
274 | $multi = preg_match('/^\d+$/', $searchData['multi']) ? $searchData['multi'] : null; |
|
275 | $qb |
|
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') |
|
278 | ->setParameter('multi', $multi) |
|
279 | ->setParameter('likemulti', '%' . $searchData['multi'] . '%'); |
|
280 | } |
|
281 | ||
282 | // order_id_end |
|
283 | if (isset($searchData['order_id_end']) && Str::isNotBlank($searchData['order_id_end'])) { |
@@ 174-180 (lines=7) @@ | ||
171 | ->innerJoin('p.ProductClasses', 'pc'); |
|
172 | ||
173 | // id |
|
174 | if (isset($searchData['id']) && Str::isNotBlank($searchData['id'])) { |
|
175 | $id = preg_match('/^\d+$/', $searchData['id']) ? $searchData['id'] : null; |
|
176 | $qb |
|
177 | ->andWhere('p.id = :id OR p.name LIKE :likeid OR pc.code LIKE :likeid') |
|
178 | ->setParameter('id', $id) |
|
179 | ->setParameter('likeid', '%' . $searchData['id'] . '%'); |
|
180 | } |
|
181 | ||
182 | // code |
|
183 | /* |