| @@ 54-61 (lines=8) @@ | ||
| 51 | ->setParameter('shipping_id_start', $searchData['shipping_id_start']); |
|
| 52 | } |
|
| 53 | // multi |
|
| 54 | if (isset($searchData['multi']) && StringUtil::isNotBlank($searchData['multi'])) { |
|
| 55 | $multi = preg_match('/^\d{0,10}$/', $searchData['multi']) ? $searchData['multi'] : null; |
|
| 56 | $qb |
|
| 57 | ->andWhere('s.id = :multi OR s.name01 LIKE :likemulti OR s.name02 LIKE :likemulti OR '. |
|
| 58 | 's.kana01 LIKE :likemulti OR s.kana02 LIKE :likemulti OR s.company_name LIKE :likemulti') |
|
| 59 | ->setParameter('multi', $multi) |
|
| 60 | ->setParameter('likemulti', '%'.$searchData['multi'].'%'); |
|
| 61 | } |
|
| 62 | ||
| 63 | // shipping_id_end |
|
| 64 | if (isset($searchData['shipping_id_end']) && StringUtil::isNotBlank($searchData['shipping_id_end'])) { |
|
| @@ 108-116 (lines=9) @@ | ||
| 105 | ->setParameter('order_id_start', $searchData['order_id_start']); |
|
| 106 | } |
|
| 107 | // multi |
|
| 108 | if (isset($searchData['multi']) && StringUtil::isNotBlank($searchData['multi'])) { |
|
| 109 | $multi = preg_match('/^\d{0,10}$/', $searchData['multi']) ? $searchData['multi'] : null; |
|
| 110 | $qb |
|
| 111 | ->andWhere('o.id = :multi OR o.name01 LIKE :likemulti OR o.name02 LIKE :likemulti OR '. |
|
| 112 | 'o.kana01 LIKE :likemulti OR o.kana02 LIKE :likemulti OR o.company_name LIKE :likemulti OR '. |
|
| 113 | 'o.order_no LIKE :likemulti') |
|
| 114 | ->setParameter('multi', $multi) |
|
| 115 | ->setParameter('likemulti', '%'.$searchData['multi'].'%'); |
|
| 116 | } |
|
| 117 | ||
| 118 | // order_id_end |
|
| 119 | if (isset($searchData['order_id_end']) && StringUtil::isNotBlank($searchData['order_id_end'])) { |
|