/**
* This event runs after we have built the query used to fetch a record
* list in a model. It is used to apply automatic query filters.
*
* @param FOFModel &$model The model which calls this event
* @param JDatabaseQuery &$query The model which calls this event
*
* @return void
*/
public function onAfterBuildQuery(&$model, &$query)
{
$table = $model->getTable();
$tableName = $table->getTableName();
$tableKey = $table->getKeyName();
$db = $model->getDBO();
$filterzero = $model->getState('_emptynonzero', null);
$fields = $model->getTableFields();
$backlist = $model->blacklistFilters();
foreach ($fields as $fieldname => $fieldtype) {
if (in_array($fieldname, $backlist)) {
continue;
}
$field = new stdClass();
$field->name = $fieldname;
$field->type = $fieldtype;
$field->filterzero = $filterzero;
$filterName = $field->name == $tableKey ? 'id' : $field->name;
$filterState = $model->getState($filterName, null);
$field = FOFModelField::getField($field, array('dbo' => $db, 'table_alias' => $model->getTableAlias()));
if (is_array($filterState) && (array_key_exists('value', $filterState) || array_key_exists('from', $filterState) || array_key_exists('to', $filterState)) || is_object($filterState)) {
$options = new JRegistry($filterState);
} else {
$options = new JRegistry();
$options->set('value', $filterState);
}
$methods = $field->getSearchMethods();
$method = $options->get('method', $field->getDefaultSearchMethod());
if (!in_array($method, $methods)) {
$method = 'exact';
}
switch ($method) {
case 'between':
case 'outside':
case 'range':
$sql = $field->{$method}($options->get('from', null), $options->get('to'));
break;
case 'interval':
case 'modulo':
$sql = $field->{$method}($options->get('value', null), $options->get('interval'));
break;
case 'exact':
case 'partial':
case 'search':
default:
$sql = $field->{$method}($options->get('value', null));
break;
}
if ($sql) {
$query->where($sql);
}
}
}
/**
* Constructor
*
* @param JDatabaseDriver $db The database object
* @param object $field The field informations as taken from the db
*/
public function __construct($db, $field, $table_alias = false)
{
parent::__construct($db, $field, $table_alias);
$this->null_value = '';
}