protected function _buildQueryJoins(KDatabaseQuery $query)
{
if ($this->_state->task) {
$query->join('left', 'jedi_tasks AS tasks', 'tasks.jedi_task_id = tbl.jedi_task_id');
}
if ($this->_state->member) {
$query->join('left', 'jedi_members AS members', 'members.jedi_member_id = tbl.jedi_member_id');
}
parent::_buildQueryJoins($query);
}
/**
* Builds LEFT JOINS clauses for the query.
*
* @param KDatabaseQuery A query object.
* @return void
*/
protected function _buildQueryJoins(KDatabaseQuery $query)
{
$state = $this->_state;
if($state->loggedin) {
$query->join('RIGHT', 'session AS session', 'tbl.id = session.userid');
} else {
$query->join('LEFT', 'session AS session', 'tbl.id = session.userid');
}
}
protected function _buildQueryJoins(KDatabaseQuery $query)
{
$query->join('left', 'users AS user', 'user.id = tbl.ninjaboard_person_id');
//->join('left', 'ninjaboard_ranks AS rank', 'IFNULL(person.posts, 0) >= rank.min')
//->order('rank.min', 'DESC');
if (JVersion::isCompatible('1.6.0')) {
$query->join('left', 'user_usergroup_map AS joomla_usergroup', 'joomla_usergroup.user_id = user.id')->select('GROUP_CONCAT(joomla_usergroup.group_id SEPARATOR \'|\') AS ninjaboard_usergroup_id');
} else {
$query->join('left', 'ninjaboard_joomla_user_group_maps AS joomla_map', 'joomla_map.joomla_gid = user.gid')->select("IFNULL((SELECT GROUP_CONCAT(ninjaboard_map.ninjaboard_user_group_id SEPARATOR '|') FROM #__ninjaboard_user_group_maps AS ninjaboard_map WHERE ninjaboard_map.joomla_user_id = user.id), joomla_map.ninjaboard_gid) AS ninjaboard_usergroup_id");
}
parent::_buildQueryJoins($query);
}
protected function _buildQueryJoins(KDatabaseQuery $query)
{
//Exclude joins if counting records
if (!$query->count) {
if ($this->_state->section) {
if ($this->_state->section == 'com_content' || is_numeric($this->_state->section)) {
$query->join('LEFT', 'content AS content', 'content.catid = tbl.id');
$query->join('LEFT', 'sections AS sections', 'sections.id = tbl.section');
} else {
$query->join('LEFT', substr($this->_state->section, 4) . ' AS child', 'child.catid = tbl.id');
}
}
}
parent::_buildQueryJoins($query);
}
protected function _buildQueryJoins(KDatabaseQuery $query)
{
// Exclude joins if counting records.
if(!$query->count) {
$query->join('LEFT', 'categories AS category', 'category.id = tbl.catid');
}
}
protected function _buildQueryJoins(KDatabaseQuery $query)
{
if (!$this->_state->isUnique()) {
$query->join('LEFT', 'attachments_relations AS relations', 'relations.attachments_attachment_id = tbl.attachments_attachment_id');
}
return parent::_buildQueryJoins($query);
}
protected function _buildQueryJoins(KDatabaseQuery $query)
{
if (!$this->_state->isUnique()) {
$name = $this->getTable()->getName();
$query->join('LEFT', $name . ' AS parent', 'tbl.lft BETWEEN parent.lft AND parent.rgt');
}
}
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 _buildQueryJoin(KDatabaseQuery $query)
{
$query
->join('left', 'users AS user', 'user.id = tbl.checked_out')
->join('left', 'groups AS group', 'group.id = tbl.access')
->join('left', 'modules_menu AS module_menu', 'module_menu.moduleid = tbl.id');
parent::_buildQueryJoin($query);
}
protected function _buildQueryJoins(KDatabaseQuery $query)
{
$query->join('left', 'ninjaboard_people AS person', 'person.ninjaboard_person_id = tbl.id');
/*
$query
->join('left', 'ninjaboard_joomla_user_group_maps AS joomla_map', 'joomla_map.joomla_gid = tbl.gid')
->select("IFNULL((SELECT GROUP_CONCAT(ninjaboard_map.ninjaboard_user_group_id SEPARATOR '|') FROM #__ninjaboard_user_group_maps AS ninjaboard_map WHERE ninjaboard_map.joomla_user_id = tbl.id), joomla_map.ninjaboard_gid) AS ninjaboard_usergroup_id");
//*/
//Get the default gid for users that's not mapped
$gid = (int) KFactory::get('admin::com.ninjaboard.model.joomlausergroupmaps')->getGuest()->gid;
if (JVersion::isCompatible('1.6.0')) {
//$query
//->join('left', 'user_usergroup_map AS joomla_usergroup', 'joomla_usergroup.user_id = tbl.id')
//->select('GROUP_CONCAT(joomla_usergroup.group_id SEPARATOR \'|\') AS ninjaboard_usergroup_id');
} else {
$query->join('left', 'ninjaboard_joomla_user_group_maps AS joomla_map', 'joomla_map.joomla_gid = tbl.gid')->select("IFNULL(IFNULL((SELECT GROUP_CONCAT(ninjaboard_map.ninjaboard_user_group_id SEPARATOR '|') FROM #__ninjaboard_user_group_maps AS ninjaboard_map WHERE ninjaboard_map.joomla_user_id = tbl.id), joomla_map.ninjaboard_gid), {$gid}) AS ninjaboard_usergroup_id");
}
parent::_buildQueryJoins($query);
}
protected function _buildQueryJoins(KDatabaseQuery $query)
{
//Exclude joins if counting records
if (!$query->count) {
$query->join[] = array('type' => 'LEFT', 'table' => '(SELECT section, COUNT(section) categorycount FROM #__categories
WHERE published <> -2 GROUP BY section) AS cat', 'condition' => array('cat.section = tbl.id'));
$query->join('LEFT', 'content AS active', 'active.sectionid = tbl.id');
}
parent::_buildQueryJoins($query);
}
/**
* @param KDatabaseQuery $query
*/
protected function _buildQueryJoins(KDatabaseQuery $query)
{
$relation = $this->getTable()->getRelationTable();
$id_column = $this->getTable()->getIdentityColumn();
$query->join('inner', '#__' . $relation . ' AS crumbs', 'crumbs.descendant_id = tbl.' . $id_column);
if ($this->getTable()->hasBehavior('orderable')) {
// This one is to have a breadcrumbs style order like 1/3/4
if (in_array($this->_state->sort, array('title', 'created_on', 'custom'))) {
$query->join('inner', '#__makundi_category_orderings AS o', 'crumbs.ancestor_id = o.' . $id_column);
}
// This one is to display the custom ordering in backend
if (!$query->count) {
$query->join('left', '#__makundi_category_orderings AS o2', 'tbl.' . $id_column . ' = o2.' . $id_column);
}
}
if ($this->_state->parent_id) {
$query->join('inner', '#__' . $relation . ' AS r', 'r.descendant_id = tbl.' . $id_column);
}
parent::_buildQueryJoins($query);
}
protected function _buildQueryJoins(KDatabaseQuery $query)
{
$query->join('LEFT', 'users AS u1', 'u1.id = tbl.modified_by');
$query->join('LEFT', 'users AS u2', 'u2.id = tbl.created_by');
}
protected function _buildQueryJoin(KDatabaseQuery $query)
{
$query->join('left', 'groups AS group', 'group.id = tbl.access');
parent::_buildQueryJoin($query);
}
protected function _buildQueryJoins(KDatabaseQuery $query)
{
$query->join('RIGHT', 'users AS t', 't.id = tbl.user_id');
}
protected function _buildQueryJoins(KDatabaseQuery $query)
{
$query->join('RIGHT', 'users u', 'tbl.created_by = u.id');
}
protected function _buildQueryJoins(KDatabaseQuery $query)
{
$query->join('LEFT', 'docman_categories AS c', 'tbl.docman_category_id = c.docman_category_id')->join('LEFT', 'users AS creator', 'tbl.created_by = creator.id')->join('LEFT', 'users AS modifier', 'tbl.modified_by = modifier.id')->join('LEFT', 'viewlevels AS viewlevel', '(CASE tbl.access WHEN -1 THEN COALESCE(c.access, 1) ELSE tbl.access END) = viewlevel.id');
parent::_buildQueryJoins($query);
}
protected function _buildQueryJoins(KDatabaseQuery $query)
{
$query->join('LEFT', 'picman_rel_tags_albums AS rel', 'rel.picman_album_id = tbl.picman_album_id');
}
protected function _buildQueryJoins(KDatabaseQuery $query)
{
$query->join('LEFT', 'duuka_rel_tags_items AS rel', 'rel.duuka_item_id = tbl.duuka_item_id');
}
protected function _buildQueryJoins(KDatabaseQuery $query)
{
$query->join('left', 'ninjaboard_posts AS last_post', 'last_post.ninjaboard_post_id = tbl.last_post_id')->join('left', 'ninjaboard_topics AS topic', 'last_post.ninjaboard_topic_id = topic.ninjaboard_topic_id')->join('left', 'ninjaboard_posts AS first_post', 'first_post.ninjaboard_post_id = topic.first_post_id')->join('left', 'users AS usr', 'usr.id = last_post.created_user_id')->join('left', 'ninjaboard_people AS person', 'person.ninjaboard_person_id = last_post.created_user_id');
}
/**
* Builds LEFT JOINS clauses for the query
*/
protected function _buildQueryJoins(KDatabaseQuery $query)
{
$query->join('LEFT', 'sections AS s', 's.id = tbl.section');
}
protected function _buildQueryJoins(KDatabaseQuery $query)
{
$query->join('left', 'immotoa_projects AS project', 'project.immotoa_project_id = tbl.immotoa_project_id');
$query->join('left', 'immotoa_purposes AS purpose', 'purpose.immotoa_purpose_id = tbl.immotoa_purpose_id');
}
protected function _buildQueryJoins(KDatabaseQuery $query)
{
$query->join('left', 'picman_categories AS category', 'category.picman_category_id = tbl.picman_category_id');
$query->join('left', 'picman_rel_tags_albums AS rel', 'rel.picman_album_id = tbl.picman_album_id');
}
protected function _buildQueryJoins(KDatabaseQuery $query)
{
$query->join('LEFT', 'viewlevels AS viewlevel', 'tbl.access = viewlevel.id')->join('LEFT', 'users AS creator', 'tbl.created_by = creator.id');
parent::_buildQueryJoins($query);
}
protected function _buildQueryJoins(KDatabaseQuery $query)
{
$query->join('LEFT', 'users AS users', 'users.id = tbl.created_by');
}
protected function _buildQueryJoins(KDatabaseQuery $query)
{
$query->join('LEFT', 'jedi_ranks AS r', 'tbl.jedi_rank_id = r.jedi_rank_id');
parent::_buildQueryJoins($query);
}
