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;
}
