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); }