/**
* @param \Doctrine\ORM\QueryBuilder $qb
* @param TaskSearchCommand $command
* @return \Doctrine\ORM\QueryBuilder
*/
private function addFilters(\Doctrine\ORM\QueryBuilder $qb, TaskSearchCommand $command)
{
if ($command->showOnlyFuture()) {
$qb->andWhere($qb->expr()->gte('t.dateTime', "CURRENT_TIMESTAMP()"));
} else {
$qb = $this->addStartEndDateFilters($qb, $command);
}
if ($command->getTipCursa() != null) {
$qb->andWhere($qb->expr()->eq("t.cursa", ":tipCursa"));
$qb->setParameter(":tipCursa", $command->getTipCursa());
}
if ($command->getFilter() != null) {
if (is_numeric($command->getFilter())) {
$qb->andWhere($qb->expr()->eq("t.id", $command->getFilter()));
//it's nice to have a search by id
} else {
$filter = "%" . $command->getFilter() . "%";
$qb->setParameter(":filter", $filter);
$qb->andWhere($qb->expr()->like("t.fullTask", ":filter"));
}
}
return $qb;
}
