@@ -96,7 +96,7 @@ discard block |
||
| 96 | 96 | NORMALIZE(p.search_word) LIKE NORMALIZE(:%s) OR |
| 97 | 97 | EXISTS (SELECT wpc%d FROM \Eccube\Entity\ProductClass wpc%d WHERE p = wpc%d.Product AND NORMALIZE(wpc%d.code) LIKE NORMALIZE(:%s))', |
| 98 | 98 | $key, $key, $index, $index, $index, $index, $key)) |
| 99 | - ->setParameter($key, '%' . $keyword . '%'); |
|
| 99 | + ->setParameter($key, '%'.$keyword.'%'); |
|
| 100 | 100 | } |
| 101 | 101 | } |
| 102 | 102 | |
@@ -159,7 +159,7 @@ discard block |
||
| 159 | 159 | $qb |
| 160 | 160 | ->andWhere('p.id = :id OR p.name LIKE :likeid OR pc.code LIKE :likeid') |
| 161 | 161 | ->setParameter('id', $id) |
| 162 | - ->setParameter('likeid', '%' . $searchData['id'] . '%'); |
|
| 162 | + ->setParameter('likeid', '%'.$searchData['id'].'%'); |
|
| 163 | 163 | } |
| 164 | 164 | |
| 165 | 165 | // code |