|
@@ 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 . '%'); |