protected function _buildQueryWhere(KDatabaseQuery $query)
{
if ($this->_state->source instanceof KDatabaseRowInterface) {
$source = $this->_state->source;
$query->where('tbl.files_container_id', '=', $source->container->id)->where('tbl.folder', '=', '/' . $source->relative_folder)->where('tbl.filename', '=', $source->name);
} else {
if ($this->_state->folder) {
$query->where('tbl.folder', '=', $this->_state->folder);
} else {
if ($this->_state->files) {
$query->where('tbl.filename', 'IN', $this->_state->files);
}
}
}
$states = $this->_state->getData(true);
/*
* This is here so that parent method won't try to use the source row object when creating the query
*/
if (!empty($states)) {
$states = $this->getTable()->mapColumns($states);
foreach ($states as $key => $value) {
if ($key != 'source' && isset($value)) {
$query->where('tbl.' . $key, 'IN', $value);
}
}
}
}
protected function _buildQueryWhere(KDatabaseQuery $query)
{
$state = $this->_state;
if($state->search) {
$query->where('tbl.title', 'LIKE', '%'.$state->search.'%');
}
//select overall section
if ($state->section)
{
if( $state->section == 'com_content' ) {
$query->where('tbl.section', 'NOT LIKE', 'com%');
} else {
$query->where('tbl.section', 'IN', $state->section);
}
}
//select parent section within com_content
if ($state->parent) {
$query->where('tbl.section', 'IN', $state->parent);
}
if (is_numeric($state->published)) {
$query->where('tbl.published', '=', $state->published);
}
parent::_buildQueryWhere($query);
}
protected function _buildQueryWhere(KDatabaseQuery $query)
{
if ($this->_state->source instanceof KDatabaseRowInterface) {
$source = $this->_state->source;
$query->where('tbl.files_container_id', '=', $source->container->id)
->where('tbl.folder', '=', '/'.$source->relative_folder)
->where('tbl.filename', '=', $source->name)
;
/*
* This is here so that parent method won't try to use the source row object when creating the query
*/
$this->_source = $source;
$this->_state->source = null;
}
else if ($this->_state->folder) {
$query->where('tbl.folder', '=', $this->_state->folder);
}
else if ($this->_state->files) {
$query->where('tbl.filename', 'IN', $this->_state->files);
}
parent::_buildQueryWhere($query);
}
protected function _buildQueryWhere(KDatabaseQuery $query)
{
if ($this->getState('tag_id')) {
$query->where('rel.duuka_tag_id', '=', $this->getState('tag_id'));
}
$query->where('tbl.enabled', '=', 1);
}
protected function _buildQueryWhere(KDatabaseQuery $query)
{
$state = $this->_state;
if($state->search) {
$query->where('tbl.title', 'LIKE', '%'.$state->search.'%');
}
if($state->position) {
$query->where('tbl.position', '=', $state->position);
}
if($state->type) {
$query->where('tbl.module', '=', $state->type);
}
if($state->enabled !== '' && $state->enabled !== null) {
$query->where('tbl.published', '=', $state->enabled);
}
if($state->application !== false)
{
$client = JApplicationHelper::getClientInfo($state->application, true);
$query->where('tbl.client_id', '=', $client->id);
}
parent::_buildQueryWhere($query);
}
protected function _buildQueryWhere(KDatabaseQuery $query)
{
$state = $this->_state;
if ($state->extman_extension_id) {
$query->where('tbl.extman_extension_id', '=', $state->extman_extension_id);
}
if ($state->dependent_id) {
$query->where('tbl.dependent_id', '=', $state->dependent_id);
}
}
protected function _buildQueryWhere(KDatabaseQuery $query)
{
if ($this->_state->task) {
$query->where('tbl.jedi_task_id', '=', (int) $this->_state->task);
}
if ($this->_state->member) {
$query->where('tbl.jedi_member_id', '=', (int) $this->_state->member);
}
parent::_buildQueryWhere($query);
}
protected function _buildQueryWhere(KDatabaseQuery $query)
{
$state = $this->getState();
if ($state->search) {
$search = '%' . $state->search . '%';
$query->where('tbl.title', 'LIKE', $search);
$query->where('tbl.text', 'LIKE', $search, 'OR');
}
parent::_buildQueryWhere($query);
}
protected function _buildQueryWhere(KDatabaseQuery $query)
{
if ($this->_state->search) {
$query->where('tbl.title', 'LIKE', '%' . $this->_state->search . '%');
}
if (is_numeric($this->_state->enabled)) {
$query->where('tbl.enabled', '=', $this->_state->enabled);
}
parent::_buildQueryWhere($query);
}
protected function _buildQueryWhere(KDatabaseQuery $query)
{
$state = $this->_state;
if ($state->business) {
$query->where('tbl.businesses_business_id', '=', $state->business);
}
if ($state->tag) {
$query->where('tbl.businesses_tag_id', '=', $state->tag);
}
parent::_buildQueryWhere($query);
}
protected function _buildQueryWhere(KDatabaseQuery $query)
{
$state = $this->_state;
if (!$state->isUnique()) {
if ($state->search) {
$query->where('title', 'LIKE', '%' . $state->search . '%');
$query->where('description', 'LIKE', '%' . $state->search . '%', 'OR');
}
}
parent::_buildQueryWhere($query);
}
protected function _buildQueryWhere(KDatabaseQuery $query)
{
if (!$this->_state->isUnique()) {
if ($this->_state->table) {
$query->where('relations.table', '=', $this->_state->table);
}
if ($this->_state->row) {
$query->where('relations.row', 'IN', $this->_state->row);
}
}
parent::_buildQueryWhere($query);
}
public function _buildQueryWhere(KDatabaseQuery $query)
{
if (is_array($this->_state->group_id)) {
foreach ($this->_state->group_id as $group) {
$query->where('FIND_IN_SET(' . $group . ', REPLACE(SUBSTRING_INDEX(SUBSTR(ANCESTORS,LOCATE(\'"GROUPS":[\',ANCESTORS)+CHAR_LENGTH(\'"GROUPS":[\')),\']\', 1),\'\', \'\'))', null, null, 'OR');
}
} else {
if (is_int($this->_state->group_id)) {
$query->where('FIND_IN_SET(' . $this->_state->group_id . ', REPLACE(SUBSTRING_INDEX(SUBSTR(ANCESTORS,LOCATE(\'"GROUPS":[\',ANCESTORS)+CHAR_LENGTH(\'"GROUPS":[\')),\']\', 1),\'\', \'\'))', null, null);
}
}
}
protected function _buildQueryWhere(KDatabaseQuery $query)
{
$state = $this->getState();
if ($state->search) {
$search = '%' . $state->search . '%';
$query->where('tbl.target_type', 'LIKE', $search);
$query->where('tbl.text', 'LIKE', $search, 'OR');
}
if ($state->controller) {
$query->where('tbl.controller', '=', $state->controller);
}
if ($state->browse) {
$query->where('tbl.browse', '=', 1);
}
if ($state->read) {
$query->where('tbl.read', '=', 1);
}
if ($state->edit) {
$query->where('tbl.edit', '=', 1);
}
if ($state->add) {
$query->where('tbl.add', '=', 1);
}
if ($state->delete) {
$query->where('tbl.delete', '=', 1);
}
parent::_buildQueryWhere($query);
}
protected function _buildQueryWhere(KDatabaseQuery $query)
{
$state = $this->_state;
if (!$state->isUnique()) {
if ($state->subscribed) {
$user = JFactory::getUser();
$query->where('subscription.user_id', '=', $user->id);
}
if ($state->category) {
$query->where('tbl.news_category_id', '=', $state->category);
}
}
parent::_buildQueryWhere($query);
}
protected function _buildQueryWhere(KDatabaseQuery $query)
{
$state = $this->_state;
if ($state->search) {
$query->where('tbl.title', 'LIKE', '%' . $state->search . '%');
}
if ($state->scope) {
$query->where('tbl.scope', 'LIKE', $state->scope);
}
if (is_numeric($state->published)) {
$query->where('tbl.published', '=', $state->published);
}
parent::_buildQueryWhere($query);
}
protected function _buildQueryWhere(KDatabaseQuery $query)
{
$state = $this->_state;
if ($state->search) {
$query->where('tbl.name', 'LIKE', '%' . $state->search . '%');
}
if (is_numeric($state->enabled)) {
$query->where('tbl.enabled', '=', $state->enabled);
}
if (is_numeric($state->jedi_rank_id)) {
$query->where('tbl.jedi_rank_id', '=', (int) $state->jedi_rank_id);
}
parent::_buildQueryWhere($query);
}
protected function _buildQueryWhere(KDatabaseQuery $query)
{
global $mainframe, $option;
$filter_state = $this->getState('filter_state');
if ($filter_state) {
if ($filter_state == 'P') {
$query->where('enabled', '=', 1);
} else {
if ($filter_state == 'U') {
$query->where('enabled', '=', 0);
}
}
}
}
protected function _buildQueryWhere(KDatabaseQuery $query)
{
$state = $this->_state;
if (is_bool($state->enabled)) {
$query->where('tbl.published', '=', (int) $state->enabled);
}
if (is_numeric($state->category) && !empty($state->category)) {
$query->where('tbl.catid', '=', $state->category);
}
if ($state->search) {
$query->where('tbl.name', 'LIKE', '%' . $state->search . '%');
}
parent::_buildQueryWhere($query);
}
public function _buildQueryWhere(KDatabaseQuery $query)
{
if ($this->_parent_column) {
$parent = $this->_parent ? $this->_parent : $this->{$this->_parent_column};
$query->where($this->_table->mapColumns($this->_parent_column), '=', $parent);
}
}
public function _buildQueryWhere(KDatabaseQuery $query)
{
if($this->getMixer()->getIdentifier()->name == 'article' && !isset($this->featured_order))
{
$query->where('catid', '=', $this->category_id)
->where('state', '>=', 0);
}
}
protected function _buildQueryWhere(KDatabaseQuery $query)
{
$state = $this->_state;
if ($state->search) {
$query->where('tbl.name', 'LIKE', '%' . $state->search . '%');
}
if ($state->type) {
$query->where('tbl.folder', '=', $state->type);
}
if (is_bool($state->enabled)) {
$query->where('tbl.published', '=', (int) $state->enabled);
}
if (is_bool($state->hidden)) {
$query->where('tbl.iscore', '=', (int) $state->hidden);
}
parent::_buildQueryWhere($query);
}
protected function _buildQueryJoins(KDatabaseQuery $query)
{
//Exclude joins if counting records
if (!$query->count) {
$query->join('', 'categories AS cc', array('cc.id = tbl.catid'));
$query->where('cc.section', 'LIKE', 'com_banner');
}
}
protected function _buildQueryWhere(KDatabaseQuery $query)
{
$state = $this->_state;
if ($state->event) {
$query->where('tbl.calendar_event_id', '=', $state->event);
}
if ($state->year) {
$query->where('tbl.year', '=', $state->year);
}
if ($state->month) {
$query->where('tbl.month', '=', $state->month);
}
if ($state->day) {
$query->where('tbl.day', '=', $state->day);
}
parent::_buildQueryWhere($query);
}
protected function _buildQueryWhere(KDatabaseQuery $query)
{
$state = $this->_state;
if($state->search) {
$query->where('tbl.name', 'LIKE', '%'.$state->search.'%');
}
if($state->type) {
$query->where('tbl.folder', '=', $state->type);
}
if($state->enabled !== '' && $state->enabled !== null) {
$query->where('tbl.published', '=', $state->enabled);
}
parent::_buildQueryWhere($query);
}
protected function _buildQueryWhere(KDatabaseQuery $query)
{
$state = $this->_state;
if ($state->search) {
$query->where('tbl.name', 'LIKE', '%' . $state->search . '%');
}
if ($state->component) {
$query->where('tbl.option', '=', $state->component);
}
if (is_integer($state->parent)) {
$query->where('tbl.parent', '=', $state->parent);
}
if (is_bool($state->enabled)) {
$query->where('tbl.enabled', '=', (int) $state->enabled);
}
if (is_bool($state->hidden)) {
$query->where('tbl.iscore', '=', (int) $state->hidden);
}
parent::_buildQueryWhere($query);
}
/**
* Filter list based on search keyword
*
* @author Stian Didriksen <*****@*****.**>
* @param KDatabaseQuery $query
* @return $this
*/
protected function _buildQueryWhere(KDatabaseQuery $query)
{
if ($search = trim($this->_state->search)) {
$parts = explode(' ', $search);
$states = array();
foreach ($parts as $i => $part) {
if (strpos($part, ':') === false) {
continue;
}
$keys = explode(':', $part);
$states[$keys[0]] = $keys[1];
unset($parts[$i]);
}
if ($states) {
$conditions = array();
foreach (array('username', 'email') as $key) {
if (isset($states[$key])) {
$query->where('tbl.' . $key, 'LIKE', '%' . $states[$key] . '%');
}
}
if ($parts) {
$query->where('tbl.name', 'LIKE', '%' . implode($parts) . '%');
}
} else {
//To avoid auto quoting, and also trim trailing whitespace
$search = $this->getTable()->getDatabase()->quoteValue('%' . strtoupper($search) . '%');
$query->where("(tbl.name LIKE {$search} OR tbl.username LIKE {$search} OR tbl.email LIKE {$search} OR person.alias LIKE {$search})");
}
}
$group = $this->_state->usergroup;
if ($group) {
$query->where('tbl.gid', '=', (int) $group);
}
if (!$this->_state->me) {
$me = KFactory::get('admin::com.ninjaboard.model.people')->getMe();
$query->where('tbl.id', '!=', $me->id);
}
//Don't show blocked users
$query->where('tbl.block', '=', 0);
parent::_buildQueryWhere($query);
}
protected function _buildQueryWhere(KDatabaseQuery $query)
{
$state = $this->_state;
if ($state->source instanceof KDatabaseRowInterface) {
$source = $state->source;
$query->where('tbl.files_container_id', '=', $source->container->id)->where('tbl.filename', '=', $source->name);
if ($source->folder) {
$query->where('tbl.folder', '=', $source->folder);
}
} else {
if ($state->container) {
$query->where('tbl.files_container_id', '=', $state->container->id);
}
if ($state->folder !== false) {
$query->where('tbl.folder', '=', ltrim($state->folder, '/'));
}
// Need this for BC
if (!empty($state->files)) {
$query->where('tbl.filename', 'IN', $state->files);
}
if ($state->filename) {
$query->where('tbl.filename', '=', $state->filename);
}
}
}
protected function _buildQueryWhere(KDatabaseQuery $query)
{
$state = $this->_state;
if (!$state->isUnique()) {
if ($state->subscribed) {
$user = JFactory::getUser();
$query->where('subscription.user_id', '=', $user->id);
}
if ($state->enabled) {
$query->where('tbl.enabled', '=', (int) $state->enabled);
}
if ($state->category) {
$query->where('tbl.news_category_id', '=', $state->category);
}
if ($state->search) {
$query->where('(', null, null, 'AND')->where('tbl.title', 'LIKE', '%' . $state->search . '%', '')->where('tbl.text', 'LIKE', '%' . $state->search . '%', 'OR')->where(')', null, null, '');
}
if ($this->_state->start_date && $this->_state->start_date != '0000-00-00') {
$start_date = $this->getService('koowa:date', array('date' => $this->_state->start_date));
$end_date = $this->getService('koowa:date', array('date' => $this->_state->end_date));
$start = $start_date->addDays(1)->addSeconds(-1)->getDate();
$end = $end_date->addDays(1)->addSeconds(-1)->getDate();
$query->where('tbl.created_on', '>', $start);
$query->where('tbl.created_on', '<', $end);
}
}
parent::_buildQueryWhere($query);
}
protected function _buildQueryWhere(KDatabaseQuery $query)
{
$state = $this->_state;
if($state->search) {
$query->where('tbl.name', 'LIKE', '%'.$state->search.'%');
}
if($state->option) {
$query->where('tbl.option', '=', $state->option);
}
if(is_integer($state->parent)) {
$query->where('tbl.parent', '=', $state->parent);
}
if($state->enabled !== '' && $state->enabled !== null) {
$query->where('tbl.enabled', '=', $state->enabled);
}
parent::_buildQueryWhere($query);
}
