Exemplo n.º 1
0
 protected function criteriaToQuery(CriteriaInterface $criteria, &$queryParams)
 {
     $where = '';
     $query = 'SELECT ' . implode(',', $criteria->getFields()) . ' FROM ' . $this->table;
     $filters = $criteria->getFilters();
     foreach ($filters as $type => $filter) {
         foreach ($filter as $field => $values) {
             $where .= $this->conditionToWhere($field, $type, $values, $queryParams) . ' AND ';
         }
     }
     if (!empty($where)) {
         $where = substr($where, 0, -5);
         $query .= strlen($where) ? ' WHERE ' . $where : '';
     }
     return $query;
 }