protected function _buildQueryWhere(KDatabaseQuery $query)
{
parent::_buildQueryWhere($query);
if ($this->_state->id) {
$query->where('tbl.joomla_user_id', 'in', $this->_state->id);
}
}
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 _buildQueryJoins(KDatabaseQuery $query)
{
parent::_buildQueryJoins($query);
if ($this->_state->source instanceof KDatabaseRowInterface || $this->_state->container) {
$query->join('LEFT', 'files_containers AS c', 'c.files_container_id = tbl.files_container_id');
}
}
protected function _buildQueryWhere(KDatabaseQuery $query)
{
parent::_buildQueryWhere($query);
$state = $this->_state;
if (is_numeric($state->enabled)) {
$query->where('tbl.showbanner', '=', $state->enabled);
}
if ($state->category) {
$query->where('tbl.catid', '=', $state->category);
}
if (is_numeric($state->sticky)) {
$query->where('tbl.sticky', '=', $state->sticky);
}
if (!empty($state->search)) {
$query->where('LOWER(tbl.name)', 'LIKE', '%'.strtolower($state->search).'%');
}
if (!empty($state->tags)) {
$where = array();
foreach ($state->tags as $tag) {
$where[] = 'UPPER(tags) REGEXP \'[[:<:]]'.strtoupper(trim($tag)).'[[:>:]]\'';
}
$query->where('( '.implode(' OR ', $where).' )');
}
}
protected function _buildQueryWhere(KDatabaseQuery $query)
{
parent::_buildQueryWhere($query);
if (is_numeric($this->_state->enabled)) {
$query->where('tbl.enabled', '=', $this->_state->enabled);
}
}
protected function _buildQueryWhere(KDatabaseQuery $query)
{
parent::_buildQueryWhere($query);
if ($this->_state->search) {
$query->where('tbl.title', 'LIKE', '%' . $this->_state->search . '%');
}
}
/**
* Build where query
*
* @param KDatabaseQuery $query
*/
public function _buildQueryWhere(KDatabaseQuery $query)
{
parent::_buildQueryWhere($query);
if ($this->_state->search) {
$query->where('name', 'LIKE', '%' . $this->_state->search . '%');
}
}
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);
}
public function getList()
{
$state = $this->_state;
$filter = $this->getService('koowa:filter.slug');
// $this->redis->flushall();
//
// $this->_state->limit = 100;
//
// parent::getList();
//
//
// foreach($this->_list as $key => $row) {
// $this->redis->set('event:'.$key, serialize($row->toArray()));
// $this->redis->rpush('events', $key);
// $this->redis->sadd('ctas_involvement:'. $filter->sanitize($row->ctas_involvement), $key);
// }
if ($state->search) {
parent::getList();
} else {
if ($state->ctas_involvement) {
$list = $this->redis->smembers('ctas_involvement:' . $filter->sanitize($state->ctas_involvement));
} else {
$list = $this->redis->lrange('events', 0, 19);
}
foreach ($list as $item) {
$rows[] = array_merge(unserialize($this->redis->get('event:' . $item)), array('cached' => 1));
}
$this->_list = $this->getTable()->getRowset()->addData($rows, false);
}
return $this->_list;
}
protected function _buildQueryWhere(KDatabaseQuery $query)
{
parent::_buildQueryWhere($query);
$state = $this->_state;
if (is_numeric($state->state)) {
$query->where('tbl.state', '=', $state->state);
} else {
$query->where('tbl.state', '<>', -2);
}
if ($state->search) {
$query->where('tbl.title', 'LIKE', '%' . $state->search . '%');
}
if (is_numeric($state->section)) {
$query->where('tbl.sectionid', '=', $state->section);
}
if (is_numeric($state->category)) {
$query->where('tbl.catid', '=', $state->category);
}
if ($state->created_by) {
$query->where('tbl.created_by', '=', $state->created_by);
}
if (is_numeric($state->access)) {
$query->where('tbl.access', '=', $state->access);
}
if ($this->getTable()->isRevisable() && $state->deleted) {
$query->where('tbl.deleted', '=', 1);
}
}
protected function _buildQueryWhere(KDatabaseQuery $query)
{
parent::_buildQueryWhere($query);
$state = $this->_state;
if ($state->search) {
$query->where('tbl.name', 'LIKE', '%' . $state->search . '%')->where('tbl.email', 'LIKE', '%' . $state->search . '%', 'OR');
}
}
protected function _buildQueryOrder(KDatabaseQuery $query)
{
if ($this->_state->distinct && !empty($this->_state->column)) {
$query->order('package', 'asc');
} else {
parent::_buildQueryOrder($query);
}
}
protected function _buildQueryJoins(KDatabaseQuery $query)
{
$state = $this->_state;
parent::_buildQueryJoins($query);
if ($state->sort) {
$query->join('INNER', '#__cck_values AS cck', 'cck.cck_fieldset_id = tbl.cck_fieldset_id AND cck.row = tbl.tenders_tender_id AND cck.table = LOWER(\'' . strtoupper($this->getTable()->getName()) . '\')');
}
}
/**
* @param KDatabaseQuery $query
*/
protected function _buildQueryWhere(KDatabaseQuery $query)
{
$state = $this->_state;
parent::_buildQueryWhere($query);
if (is_array($state->taxonomy_taxonomy_id)) {
$query->where('taxonomy_taxonomy_id', 'IN', $state->taxonomy_taxonomy_id);
}
}
protected function _buildQueryWhere(KDatabaseQuery $query)
{
parent::_buildQueryWhere($query);
if (is_numeric($this->_state->enabled)) {
$query->where('tbl.enabled', '=', $this->_state->enabled);
}
$query->where('(', null, null, 'AND')->where('tbl.date_start', '>=', date("Y-m-d"), '')->where('tbl.date_end', '>=', date("Y-m-d"), 'OR')->where(')', null, null, '');
}
public function getItem()
{
$item = parent::getItem();
if ($item) {
$item->source = $this->_state->source;
}
return $item;
}
/**
* @param KDatabaseQuery $query
*/
protected function _buildQueryWhere(KDatabaseQuery $query)
{
$state = $this->_state;
parent::_buildQueryWhere($query);
if ($state->row && $state->table) {
$query->where('tbl.row', '=', $state->row);
$query->where('tbl.table', '=', $state->table);
}
}
protected function _buildQueryWhere(KDatabaseQuery $query)
{
parent::_buildQueryWhere($query);
$query->where('tbl.section', '=', 'com_weblinks')
->where('tbl.published', '=', '1')
->where('weblinks.published', '=', '1')
->where('tbl.access', '<=', KFactory::get('joomla:user')->get('aid', '0'));
}
/**
* Query WHERE clause
*/
protected function _buildQueryWhere(KDatabaseQuery $query)
{
parent::_buildQueryWhere($query);
if ($search = $this->_state->search) {
$query->where('tbl.title', 'LIKE', '%' . $search . '%');
}
if ($this->_state->enabled !== false && $this->_state->enabled !== '') {
$query->where('tbl.enabled', '=', $this->_state->enabled);
}
}
public function getItem()
{
if (!isset($this->_item)) {
$this->_item = $this->getService('com://admin/files.database.row.config');
$container = $this->getService('com://admin/files.model.containers')->slug((string) $this->_state->container)->getItem();
$this->_item->setData(json_decode($container->parameters, true));
$this->_item->container = $container;
}
return parent::getItem();
}
protected function _buildQueryWhere(KDatabaseQuery $query)
{
parent::_buildQueryWhere($query);
if ($this->_state->top_level) {
$query->where('tbl.parent_id = 0');
}
if ($this->_state->parent_id) {
$query->where('tbl.parent_id', '=', $this->_state->parent_id);
}
}
protected function _buildQueryColumns(KDatabaseQuery $query)
{
parent::_buildQueryColumns($query);
$query->select('user.usertype')->select('person.posts AS person_posts')->select('tbl.ninjaboard_post_id AS id')->select("IFNULL(person.avatar, '/media/com_ninjaboard/images/avatar.png') AS avatar")->select("IF(topic.first_post_id = tbl.ninjaboard_post_id, tbl.subject, CONCAT('RE: ', first_post.subject)) AS subject")->select('person.signature')->select('(SELECT rank_file FROM #__ninjaboard_ranks WHERE person.posts >= min AND enabled = 1 ORDER BY min DESC LIMIT 1) AS rank_icon')->select('(SELECT title FROM #__ninjaboard_ranks WHERE person.posts >= min AND enabled = 1 ORDER BY min DESC LIMIT 1) AS rank_title');
//Build query for the screen names
KFactory::get('admin::com.ninjaboard.model.people')->buildScreenNameQuery($query, 'person', 'user', 'display_name', 'IFNULL(tbl.guest_name, \'' . JText::_('Anonymous') . '\')');
if ($search = $this->_state->search) {
$query->select(array('forum.title AS forum', 'topic.ninjaboard_topic_id AS topic', 'topic.hits'));
}
}
/**
* @param KDatabaseQuery $query
*/
protected function _buildQueryWhere(KDatabaseQuery $query)
{
$state = $this->_state;
parent::_buildQueryWhere($query);
if (is_numeric($state->enabled)) {
$query->where('tbl.enabled', '=', $state->enabled);
}
if ($state->carousel_category_id) {
$query->where('tbl.carousel_category_id', '=', $state->carousel_category_id);
}
}
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);
}
/**
* Get a topic row object
*
* @return KDatabaseRowset
*/
public function getItem()
{
if (!isset($this->_item)) {
parent::getItem();
//@TODO acl workaround
if (!$this->_item->forum_id && $this->_state->forum) {
$this->_item->forum_id = $this->_state->forum;
}
}
return $this->_item;
}
protected function _buildQueryWhere(KDatabaseQuery $query)
{
parent::_buildQueryWhere($query);
$state = $this->_state;
if ($state->mimetype) {
$query->where('mimetype', 'IN', $state->mimetype);
}
if ($state->extension) {
$query->where('extension', 'IN', $state->extension);
}
}
/**
* @param KDatabaseQuery $query
*/
protected function _buildQueryWhere(KDatabaseQuery $query)
{
$state = $this->_state;
parent::_buildQueryWhere($query);
if (is_numeric($state->enabled)) {
$query->where('tbl.enabled', '=', $state->enabled);
}
if ($state->search) {
$query->where('tbl.title', 'LIKE', '%' . $state->search . '%');
}
}
protected function _buildQueryWhere(KDatabaseQuery $query)
{
parent::_buildQueryWhere($query);
if (!$this->_state->isUnique()) {
if ($this->_state->table) {
$query->where('tbl.table', '=', $this->_state->table);
}
if ($this->_state->row) {
$query->where('tbl.row', '=', $this->_state->row);
}
}
}
protected function _buildQueryWhere(KDatabaseQuery $query)
{
parent::_buildQueryWhere($query);
//Build query for the screen names
$me = KFactory::get('admin::com.ninjaboard.model.people')->getMe();
$id = (int) $me->id;
//Get sent messages by me
$where[] = '(tbl.created_by = ' . $id . ' AND recipient.user_id != ' . $id . ')';
//Get sent messages to me
$where[] = '(tbl.created_by != ' . $id . ' AND recipient.user_id = ' . $id . ')';
$query->where('(' . implode(' OR ', $where) . ')');
}
