@@ 67-69 (lines=3) @@ | ||
64 | //The filters could also be done with a parametrised query |
|
65 | protected function initFilters($query) |
|
66 | { |
|
67 | if ($value = $this->getParamAdapter()->getValueOfFilter('name')) { |
|
68 | $query->where($query->expr()->like('q.name', '?1'))->setParameter('1', '%' . $value . '%'); |
|
69 | } |
|
70 | ||
71 | if ($value = $this->getParamAdapter()->getValueOfFilter('surname')) { |
|
72 | $query->where($query->expr()->like('q.surname', '?1'))->setParameter('1', '%' . $value . '%'); |
|
@@ 87-89 (lines=3) @@ | ||
84 | $query->where($query->expr()->like('q.street', '?1'))->setParameter('1', '%' . $value . '%'); |
|
85 | } |
|
86 | ||
87 | if ($value = $this->getParamAdapter()->getValueOfFilter('city')) { |
|
88 | $query->where($query->expr()->like('q.city', '?1'))->setParameter('1', '%' . $value . '%'); |
|
89 | } |
|
90 | ||
91 | if ($value = $this->getParamAdapter()->getValueOfFilter('product')) { |
|
92 | $query->where($query->expr()->like('q.product', '?1'))->setParameter('1', '%' . $value . '%'); |