EC-CUBE /
ec-cube
| @@ 58-65 (lines=8) @@ | ||
| 55 | ->setParameter('shipping_id_start', $searchData['shipping_id_start']); |
|
| 56 | } |
|
| 57 | // multi |
|
| 58 | if (isset( $searchData['multi']) && StringUtil::isNotBlank($searchData['multi'])) { |
|
| 59 | $multi = preg_match('/^\d+$/', $searchData['multi']) ? $searchData['multi'] : null; |
|
| 60 | $qb |
|
| 61 | ->andWhere('s.id = :multi OR s.name01 LIKE :likemulti OR s.name02 LIKE :likemulti OR ' . |
|
| 62 | 's.kana01 LIKE :likemulti OR s.kana02 LIKE :likemulti OR s.company_name LIKE :likemulti') |
|
| 63 | ->setParameter('multi', $multi) |
|
| 64 | ->setParameter('likemulti', '%' . $searchData['multi'] . '%'); |
|
| 65 | } |
|
| 66 | ||
| 67 | // shipping_id_end |
|
| 68 | if (isset($searchData['shipping_id_end']) && StringUtil::isNotBlank($searchData['shipping_id_end'])) { |
|
| @@ 155-161 (lines=7) @@ | ||
| 152 | ->innerJoin('p.ProductClasses', 'pc'); |
|
| 153 | ||
| 154 | // id |
|
| 155 | if (isset($searchData['id']) && StringUtil::isNotBlank($searchData['id'])) { |
|
| 156 | $id = preg_match('/^\d+$/', $searchData['id']) ? $searchData['id'] : null; |
|
| 157 | $qb |
|
| 158 | ->andWhere('p.id = :id OR p.name LIKE :likeid OR pc.code LIKE :likeid') |
|
| 159 | ->setParameter('id', $id) |
|
| 160 | ->setParameter('likeid', '%' . $searchData['id'] . '%'); |
|
| 161 | } |
|
| 162 | ||
| 163 | // code |
|
| 164 | /* |
|
| @@ 276-284 (lines=9) @@ | ||
| 273 | ->setParameter('order_id_start', $searchData['order_id_start']); |
|
| 274 | } |
|
| 275 | // multi |
|
| 276 | if (isset( $searchData['multi']) && StringUtil::isNotBlank($searchData['multi'])) { |
|
| 277 | $multi = preg_match('/^\d+$/', $searchData['multi']) ? $searchData['multi'] : null; |
|
| 278 | $qb |
|
| 279 | ->andWhere('o.id = :multi OR o.name01 LIKE :likemulti OR o.name02 LIKE :likemulti OR ' . |
|
| 280 | 'o.kana01 LIKE :likemulti OR o.kana02 LIKE :likemulti OR o.company_name LIKE :likemulti OR ' . |
|
| 281 | 'o.code LIKE :likemulti') |
|
| 282 | ->setParameter('multi', $multi) |
|
| 283 | ->setParameter('likemulti', '%' . $searchData['multi'] . '%'); |
|
| 284 | } |
|
| 285 | ||
| 286 | // order_id_end |
|
| 287 | if (isset($searchData['order_id_end']) && StringUtil::isNotBlank($searchData['order_id_end'])) { |
|
