| private buildWhere ( array $cols, $params ) : Doctrine\ORM\Query\Expr | ||
| $cols | array | |
| Результат | Doctrine\ORM\Query\Expr | |
private function buildWhere(array $cols, $params)
{
$qb = $this->repository->createQueryBuilder('e');
$or = $qb->expr()->orx();
$reflection = new \ReflectionObject(new $this->entityName());
$search = $params['sSearch'];
foreach (array_keys($cols) as $id => $property) {
//column is searchable
if ($reflection->hasProperty($property) && $params["bSearchable_{$id}"]) {
$or->add($qb->expr()->like("e.{$property}", $qb->expr()->literal("%{$search}%")));
}
}
return $or;
}