| @@ 262-265 (lines=4) @@ | ||
| 259 | $qb->setParameter('contains', '%' . $data['search'] . '%'); |
|
| 260 | } |
|
| 261 | ||
| 262 | if (isset($data['from']) && $data['from'] !== null) { |
|
| 263 | $qb->andWhere('p.created >= :from'); |
|
| 264 | $qb->setParameter('from', $data['from']); |
|
| 265 | } |
|
| 266 | ||
| 267 | if (isset($data['to']) && $data['to'] !== null) { |
|
| 268 | $qb->andWhere('p.created <= :to'); |
|
| @@ 267-270 (lines=4) @@ | ||
| 264 | $qb->setParameter('from', $data['from']); |
|
| 265 | } |
|
| 266 | ||
| 267 | if (isset($data['to']) && $data['to'] !== null) { |
|
| 268 | $qb->andWhere('p.created <= :to'); |
|
| 269 | $qb->setParameter('to', $data['to']); |
|
| 270 | } |
|
| 271 | ||
| 272 | return $qb->getQuery(); |
|
| 273 | } |
|