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)
{
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 _buildQueryJoins(KDatabaseQuery $query)
{
parent::_buildQueryJoins($query);
$query->join('LEFT', 'categories AS categories', 'categories.id = tbl.catid')
->join('LEFT', 'users AS users', 'users.id = tbl.checked_out');
}
/**
* @param KDatabaseQuery $query
*/
protected function _buildQueryJoins(KDatabaseQuery $query)
{
$state = $this->_state;
parent::_buildQueryJoins($query);
$iso_code = substr(JFactory::getLanguage()->getTag(), 0, 2);
if ($iso_code != 'en') {
$prefix = $iso_code . '_';
}
if (is_array($state->type)) {
$subquery = '(';
$i = 1;
foreach ($state->type as $type) {
$subquery .= 'SELECT ' . KInflector::pluralize($type) . '_' . KInflector::singularize($type) . '_id AS id, LOWER("' . strtoupper(KInflector::pluralize($type)) . '_' . strtoupper(KInflector::pluralize($type)) . '") AS test FROM #__' . $prefix . KInflector::pluralize($type) . '_' . KInflector::pluralize($type) . ' AS ' . KInflector::pluralize($type) . '
WHERE enabled = 1 AND frontpage = 1';
if (KInflector::singularize($type) == 'event') {
$subquery .= ' AND start_date >= CURDATE()';
}
if ($i < count($state->type)) {
$subquery .= ' UNION ALL ';
}
$i++;
}
$subquery .= ')';
$query->join[] = array('type' => 'INNER', 'table' => $subquery . 'AS b', 'condition' => array('tbl.row = b.id AND tbl.table = b.test'));
}
}
protected function _buildQueryJoins(KDatabaseQuery $query)
{
parent::_buildQueryJoins($query);
// Optionally join the articles if the article link is used.
$query->select('articles.title AS article_title');
$query->join('left outer', '#__articles_articles AS articles', 'tbl.articles_article_id = articles.articles_article_id');
}
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 _buildQueryJoins(KDatabaseQuery $query)
{
parent::_buildQueryJoins($query);
$query->select('users.name AS name');
$query->select('users.username AS username');
$query->select('users.email AS email');
$query->join('LEFT', 'users AS users', 'users.id = tbl.profile_user_id');
}
protected function _buildQueryJoins(KDatabaseQuery $query)
{
parent::_buildQueryJoins($query);
if ($this->_state->connect) {
$query->join('cross', '#__translations_translations AS trans', '1 = 1');
$query->join('left outer', '#__translations_translations_relations AS rel', 'trans.translations_translation_id = rel.translations_translation_id AND rel.lang = tbl.lang_code');
}
}
protected function _buildQueryJoins(KDatabaseQuery $query)
{
parent::_buildQueryJoins($query);
if (!$this->_state->user_id) {
///*
$query->join('left', 'ninjaboard_message_recipients AS recipient', 'recipient.ninjaboard_message_id = tbl.ninjaboard_message_id')->join('left', 'users AS user', 'user.id = tbl.created_by OR user.id = recipient.user_id')->join('left', 'ninjaboard_people AS person', 'person.ninjaboard_person_id = tbl.created_by');
//*/
}
}
protected function _buildQueryJoins(KDatabaseQuery $query)
{
parent::_buildQueryJoins($query);
$query->join('LEFT', 'ninjaboard_forums AS forum', 'forum.ninjaboard_forum_id = tbl.forum_id')->join('LEFT', 'ninjaboard_topic_symlinks AS symlink', '(symlink.ninjaboard_topic_id = tbl.ninjaboard_topic_id AND symlink.ninjaboard_forum_id != tbl.forum_id)');
if (!KFactory::get('lib.joomla.user')->guest) {
$me = KFactory::get('admin::com.ninjaboard.model.people')->getMe();
$query->join('left', 'ninjaboard_log_topic_reads AS log', 'log.created_by = ' . $me->id . ' AND ' . 'log.ninjaboard_forum_id = tbl.forum_id AND ' . 'log.ninjaboard_topic_id = tbl.ninjaboard_topic_id');
}
}
protected function _buildQueryJoins(KDatabaseQuery $query)
{
parent::_buildQueryJoins($query);
if (!$this->_state->isUnique()) {
if ($this->_state->subscribed) {
$query->join('RIGHT', 'news_subscriptions AS subscription', 'subscription.news_article_id = tbl.news_article_id');
}
}
}
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);
}
protected function _buildQueryJoins(KDatabaseQuery $query)
{
parent::_buildQueryJoins($query);
$state = $this->_state;
$query->join('LEFT', 'sections AS section', 'section.id = tbl.sectionid')->join('LEFT', 'categories AS category', 'category.id = tbl.catid')->join('LEFT', 'users AS user', 'user.id = tbl.created_by')->join('LEFT', 'groups AS group', 'group.id = tbl.access');
if (is_bool($state->featured) && $state->featured == true) {
$query->join('RIGHT', 'content_frontpage AS frontpage', 'frontpage.content_id = tbl.id');
} else {
$query->join('LEFT', 'content_frontpage AS frontpage', 'frontpage.content_id = tbl.id');
}
}
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)
{
$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);
}
/**
* @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)
{
parent::_buildQueryJoins($query);
$query->join('LEFT', 'weblinks AS weblinks', 'weblinks.catid = tbl.id');
}
protected function _buildQueryJoins(KDatabaseQuery $query)
{
parent::_buildQueryJoins($query);
$query->join('left', 'users AS user', 'user.id = tbl.created_user_id')->join('left', 'ninjaboard_people AS person', 'person.ninjaboard_person_id = tbl.created_user_id')->join('left', 'ninjaboard_topics AS topic', 'topic.ninjaboard_topic_id = tbl.ninjaboard_topic_id')->join('left', 'ninjaboard_posts AS first_post', 'first_post.ninjaboard_post_id = topic.first_post_id')->join('left', 'ninjaboard_forums AS forum', 'forum.ninjaboard_forum_id = topic.forum_id');
}
