@@ 71-73 (lines=3) @@ | ||
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 . '%'); |
|
73 | } |
|
74 | ||
75 | if ($value = $this->getParamAdapter()->getValueOfFilter('doctrine')) { |
|
76 | $query->where("q.name like '%".$value."%' OR q.surname like '%".$value."%' "); |
|
@@ 83-85 (lines=3) @@ | ||
80 | ->setParameter('2', '%' . $value . '%'); |
|
81 | } |
|
82 | ||
83 | if ($value = $this->getParamAdapter()->getValueOfFilter('street')) { |
|
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 . '%'); |
|
@@ 91-93 (lines=3) @@ | ||
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 . '%'); |
|
93 | } |
|
94 | } |
|
95 | } |
|
96 |