protected function addNameColumnQuery(Doctrine_Query $query, $value) { if (!empty($value)) { if (is_array($value)) { foreach ($value as $v) { $query->andWhereLike('name', $v); } } else { if (!empty($value)) { $query->andWhereLike('name', $values); } } } }
protected function addNameColumnQuery(Doctrine_Query $query, $field, $values) { $fieldName = $this->getFieldName($field); if (is_array($values)) { foreach ($values as $value) { $query->andWhereLike('r.' . $fieldName, $value); } } }
public static function filterSearchQuery($q, $column, $value, $field) { $field = self::arrayKeyCamelize($field); if (!$q) { $q = new Doctrine_Query(); } if (empty($value)) { return $q; } switch ($field['FormType']) { // selection case 'checkbox': case 'select': case 'radio': $q->andWhere($column . ' = ?', $value); break; case 'date': $q->andWhere($column . ' LIKE ?', $value); break; // doesn't allow searching // doesn't allow searching case 'increased_input': case 'language_select': case 'password': break; case 'country_select': case 'region_select': $q->andWhere($column . ' = ?', $value); break; // text and something else // text and something else default: $q->andWhereLike($column, $value); break; } return $q; }