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)
{
parent::_buildQueryWhere($query);
$state = $this->_state;
if(is_numeric($state->home)) {
$query->where('tbl.home','=', $state->home);
}
if(is_numeric($state->menu)) {
$query->where('menu.id','=', $state->menu);
}
if(is_numeric($state->enabled)) {
$query->where('tbl.published','=', $state->enabled);
}
//if(is_numeric($state->trashed)) {
// $query->where('tbl.trashed','=', $state->trashed);
//}
if(is_numeric($state->group_id)) {
$query->where('tbl.group_id','=', $state->group_id);
}
if ($state->search)
{
$search = '%'.$state->search.'%';
$query->where('tbl.title', 'LIKE', $search);
}
}
/**
* Builds a WHERE clause for the query.
*
* @param KDatabaseQuery A query object.
* @return void
*/
protected function _buildQueryWhere(KDatabaseQuery $query)
{
parent::_buildQueryWhere($query);
if ($this->_state->username) {
$query->where('username', 'IN', $this->_state->username);
}
}
protected function _buildQueryWhere(KDatabaseQuery $query)
{
parent::_buildQueryWhere($query);
$state = $this->getState();
if ($state->service) {
$query->where('service', '=', $state->service);
}
if ($state->oauth_token) {
$query->where('oauth_token', '=', $state->oauth_token);
}
if ($state->oauth_token_secret) {
$query->where('oauth_token_secret', '=', $state->oauth_token_secret);
}
if ($state->service_username) {
$query->where('service_username', '=', $state->service_username);
}
if ($state->service_id) {
$query->where('service_id', '=', $state->service_id);
}
if ($state->service_avatar) {
$query->where('service_avatar', '=', $state->service_avatar);
}
if ($state->userid) {
$query->where('userid', '=', $state->userid);
}
if ($state->created_by) {
$query->where('created_by', '=', $state->created_by);
}
}
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)
{
parent::_buildQueryWhere($query);
$state = $this->getState();
if ($state->target_type) {
$query->where('target_type', '=', $state->target_type);
}
if ($state->target_id) {
$query->where('target_id', '=', $state->target_id);
}
}
protected function _buildQueryWhere(KDatabaseQuery $query)
{
parent::_buildQueryWhere($query);
$state = $this->getState();
if ($state->blog_blog_id) {
$query->where('blog_blog_id', '=', $state->blog_blog_id);
}
if ($state->enabled) {
$query->where('enabled', '=', $state->enabled);
}
}
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);
}
/**
* Order the activities in reverse cronological order
*/
protected function _buildQueryWhere(KDatabaseQuery $query)
{
parent::_buildQueryWhere($query);
$query->select('controllers.controller, targets.title AS stream_target');
$query->join('LEFT', 'stream_controllers AS controllers', 'controllers.stream_controller_id = tbl.stream_controller_id');
$query->join('LEFT', 'stream_targets AS targets', 'targets.stream_target_id = controllers.stream_target_id');
$query->order('created_on', 'DESC');
$state = $this->getState();
if ($state->parent_target_id) {
$query->where('tbl.parent_target_id', '=', $state->parent_target_id);
}
if ($state->userid) {
}
}
protected function _buildQueryWhere(KDatabaseQuery $query)
{
parent::_buildQueryWhere($query);
$query->where('enabled', '=', 1);
}
