Пример #1
0
 /**
  * @param Search $entity
  *
  * @return Builder
  */
 public function addName(Search $entity)
 {
     if ($entity->getName()) {
         $name = mb_strtolower($entity->getName(), 'UTF8');
         $this->add(function (QueryBuilder $query) use($name) {
             $query->innerJoin('i.names', 'n')->andWhere('LOWER(i.name) LIKE :name OR LOWER(n.name) LIKE :name')->setParameter('name', preg_replace('/%+/', '%%', $name) . '%');
         });
     }
     return $this;
 }