/**
* @param KDatabaseQuery $query
*/
protected function _buildQueryWhere(KDatabaseQuery $query)
{
parent::_buildQueryWhere($query);
$state = $this->_state;
//TODO: Filter on array;
if ($state->type) {
$query->where('tbl.type', '=', $state->type);
}
if (is_numeric($state->featured)) {
$query->where('tbl.featured', '=', $state->featured);
}
if (!$state->isUnique()) {
$query->where('tbl.enabled', '=', 1);
}
}
/**
* @param KDatabaseQuery $query
*/
protected function _buildQueryWhere(KDatabaseQuery $query)
{
parent::_buildQueryWhere($query);
$state = $this->_state;
//TODO: Filter on array;
if ($state->type) {
$query->where('tbl.type', '=', $state->type);
}
if (is_numeric($state->enabled)) {
$query->where('tbl.enabled', '=', $state->enabled);
}
if (is_numeric($state->featured)) {
$query->where('tbl.featured', '=', $state->featured);
}
if ($state->search) {
$query->where('tbl.title', 'LIKE', '%' . $state->search . '%');
}
}