@@ -113,7 +113,7 @@ discard block |
||
113 | 113 | $key = sprintf('keyword%s', $index); |
114 | 114 | $qb |
115 | 115 | ->andWhere(sprintf('NORMALIZE(p.name) LIKE NORMALIZE(:%s) OR NORMALIZE(p.search_word) LIKE NORMALIZE(:%s)', $key, $key)) |
116 | - ->setParameter($key, '%' . $keyword . '%'); |
|
116 | + ->setParameter($key, '%'.$keyword.'%'); |
|
117 | 117 | } |
118 | 118 | } |
119 | 119 | |
@@ -175,7 +175,7 @@ discard block |
||
175 | 175 | $id = preg_match('/^\d+$/', $searchData['id']) ? $searchData['id'] : null; |
176 | 176 | if ($id === null) { |
177 | 177 | $qb->andWhere('p.name LIKE :likeid OR pc.code LIKE :likeid') |
178 | - ->setParameter('likeid', '%' . $searchData['id'] . '%'); |
|
178 | + ->setParameter('likeid', '%'.$searchData['id'].'%'); |
|
179 | 179 | } else { |
180 | 180 | $qb->andWhere('p.id = :id') |
181 | 181 | ->setParameter('id', $id); |