EC-CUBE /
ec-cube
| @@ 273-285 (lines=13) @@ | ||
| 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 | if ($multi === null) { |
|
| 276 | $qb |
|
| 277 | ->andWhere('o.name01 LIKE :likemulti OR o.name02 LIKE :likemulti OR ' . |
|
| 278 | 'o.kana01 LIKE :likemulti OR o.kana02 LIKE :likemulti OR o.company_name LIKE :likemulti') |
|
| 279 | ->setParameter('likemulti', '%' . $searchData['multi'] . '%'); |
|
| 280 | } else { |
|
| 281 | $qb |
|
| 282 | ->andWhere('o.id = :multi') |
|
| 283 | ->setParameter('multi', $multi); |
|
| 284 | } |
|
| 285 | } |
|
| 286 | ||
| 287 | // order_id_end |
|
| 288 | if (isset($searchData['order_id_end']) && Str::isNotBlank($searchData['order_id_end'])) { |
|
| @@ 174-183 (lines=10) @@ | ||
| 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 | if ($id === null) { |
|
| 177 | $qb->andWhere('p.name LIKE :likeid OR pc.code LIKE :likeid') |
|
| 178 | ->setParameter('likeid', '%' . $searchData['id'] . '%'); |
|
| 179 | } else { |
|
| 180 | $qb->andWhere('p.id = :id') |
|
| 181 | ->setParameter('id', $id); |
|
| 182 | } |
|
| 183 | } |
|
| 184 | ||
| 185 | // code |
|
| 186 | /* |
|
