@@ -59,7 +59,7 @@ |
||
59 | 59 | $multi = preg_match('/^\d{0,10}$/', $searchData['multi']) ? $searchData['multi'] : null; |
60 | 60 | $qb |
61 | 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') |
|
62 | + 's.kana01 LIKE :likemulti OR s.kana02 LIKE :likemulti OR s.company_name LIKE :likemulti') |
|
63 | 63 | ->setParameter('multi', $multi) |
64 | 64 | ->setParameter('likemulti', '%' . $searchData['multi'] . '%'); |
65 | 65 | } |
@@ -277,8 +277,8 @@ |
||
277 | 277 | $multi = preg_match('/^\d{0,10}$/', $searchData['multi']) ? $searchData['multi'] : null; |
278 | 278 | $qb |
279 | 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') |
|
280 | + 'o.kana01 LIKE :likemulti OR o.kana02 LIKE :likemulti OR o.company_name LIKE :likemulti OR ' . |
|
281 | + 'o.code LIKE :likemulti') |
|
282 | 282 | ->setParameter('multi', $multi) |
283 | 283 | ->setParameter('likemulti', '%' . $searchData['multi'] . '%'); |
284 | 284 | } |