protected function _buildQueryColumns(KDatabaseQuery $query)
{
if ($this->_state->task) {
$query->select('tasks.*');
}
if ($this->_state->member) {
$query->select('members.*');
}
parent::_buildQueryColumns($query);
}
/**
* @param KDatabaseQuery $query
*/
protected function _buildQueryColumns(KDatabaseQuery $query)
{
$query->select('COUNT(crumbs.ancestor_id) AS level')->select('GROUP_CONCAT(crumbs.ancestor_id ORDER BY crumbs.level DESC SEPARATOR \'/\') AS path');
if ($this->getTable()->hasBehavior('orderable')) {
if (!$query->count) {
$query->select('o2.custom AS ordering');
}
if (in_array($this->_state->sort, array('title', 'created_on', 'custom'))) {
$column = sprintf('GROUP_CONCAT(LPAD(`o`.`%s`, 5, \'0\') ORDER BY crumbs.level DESC SEPARATOR \'/\') AS order_path', $this->_state->sort);
$query->select($column);
}
}
parent::_buildQueryColumns($query);
}
protected function _buildQueryColumns(KDatabaseQuery $query)
{
if (!$this->_state->isUnique()) {
$query->select('COUNT(relations.attachments_attachment_id) AS count')->select('table')->select('row');
}
return parent::_buildQueryColumns($query);
}
protected function _buildQueryColumns(KDatabaseQuery $query)
{
$query->select(array('person.*', 'tbl.*'))->select(array('IFNULL(person.posts, 0) AS posts', 'IFNULL(person.avatar, CONCAT(LOWER(\'/MEDIA/COM_NINJABOARD/IMAGES/AVATAR\'), LOWER(\'.PNG\'))) AS avatar', 'person.signature AS signature'))->select(array('(SELECT rank_file FROM #__ninjaboard_ranks WHERE IFNULL(person.posts, 0) >= min AND enabled = 1 ORDER BY min DESC LIMIT 0, 1) AS rank_icon', '(SELECT title FROM #__ninjaboard_ranks WHERE IFNULL(person.posts, 0) >= min AND enabled = 1 ORDER BY min DESC LIMIT 0, 1) AS rank_title'));
parent::_buildQueryColumns($query);
//Build query for the screen names
KFactory::get('admin::com.ninjaboard.model.people')->buildScreenNameQuery($query, 'person', 'tbl', 'display_name');
}
protected function _buildQueryFields(KDatabaseQuery $query)
{
$query->select('tbl.*')->select('tbl.duuka_item_id AS slug');
}
protected function _buildQueryFields(KDatabaseQuery $query)
{
$query->select('tbl.*')->select('tbl.picman_album_id AS slug')->select('rel.picman_tag_id AS tag');
}
/**
* Builds SELECT fields list for the query
*/
protected function _buildQueryColumns(KDatabaseQuery $query)
{
$query->select('tbl.id');
$query->columns[] = 'CONCAT_WS( " / ",s.title, tbl.title ) AS title';
parent::_buildQueryColumns($query);
}
protected function _buildQueryFields(KDatabaseQuery $query)
{
$query->select(array('tbl.*', 'category.name AS category'));
}
protected function _buildQueryColumns(KDatabaseQuery $query)
{
$query->select('viewlevel.title AS access_title')->select('creator.name AS created_by_name');
parent::_buildQueryColumns($query);
}
protected function _buildQueryFields(KDatabaseQuery $query)
{
$query->select(array('tbl.*', 'project.name AS project', 'purpose.name AS purpose'));
}
/**
* Builds SELECT columns list for the query
*/
protected function _buildQueryColumns(KDatabaseQuery $query)
{
$query->select(array('tbl.*'));
}
/**
* Builds SELECT fields list for the query
*/
protected function _buildQueryColumns(KDatabaseQuery $query)
{
$query->select('tbl.element AS value')->select('tbl.name AS title');
parent::_buildQueryColumns($query);
}
protected function _buildQueryFields(KDatabaseQuery $query)
{
$query->select('tbl.*')->select('purpose.name AS purpose')->select('purpose.sale AS sale')->select('purpose.rent AS rent')->select('purpose.show_price AS show_price')->select('purpose.show_details AS show_details');
}
/**
* Function for creating screen name query IF block to get the screen name of a person
*
* LOWER() is used in order to avoid KDatabaseQuery from quoting the string values
*
* @param KDatabaseQuery $query The database query instance we're adding these statements to
* @param string $person_alias This is for defining the key for the alias for the jos_ninjaboard_people table
* @param string $user_alias This is for defining the key for the alias for the jos_users table
* @param string $column Column name you want it to alias to, default is display_name
* @param string $fallback The fallback if no name could be found in the database
* @return $this
*/
public function buildScreenNameQuery(KDatabaseQuery $query, $person_alias = 'tbl', $user_alias = 'user', $column = 'display_name', $fallback = '')
{
if (!$fallback) {
$fallback = '\'' . JText::_('Anonymous') . '\'';
}
//Decide wether to display realname or username
$params = KFactory::get('admin::com.ninjaboard.model.settings')->getParams();
$display_name = $params['view_settings']['display_name'];
if (!in_array($display_name, array('name', 'username'))) {
$display_name = 'username';
}
$permissions = $params['view_settings']['change_display_name'];
//User is allowed to change screen name, and set an alias
if ($permissions == 'custom') {
$query->select("IF({$person_alias}.which_name = LOWER('USERNAME'), {$user_alias}.username, " . "IF({$person_alias}.which_name = LOWER('NAME'), {$user_alias}.name, " . "IF({$person_alias}.which_name = LOWER('ALIAS') AND {$person_alias}.alias != '', {$person_alias}.alias, " . 'IFNULL(' . $user_alias . '.' . $display_name . ', ' . $fallback . ')' . ')' . ')' . ') AS ' . $column);
} elseif ($permissions == 'yes') {
$query->select("IF({$person_alias}.which_name = LOWER('USERNAME'), {$user_alias}.username, " . "IF({$person_alias}.which_name = LOWER('NAME'), {$user_alias}.name, " . 'IFNULL(' . $user_alias . '.' . $display_name . ', ' . $fallback . ')' . ')' . ') AS ' . $column);
} else {
$query->select('IFNULL(' . $user_alias . '.' . $display_name . ', ' . $fallback . ') AS ' . $column);
}
return $this;
}
protected function _buildQueryFields(KDatabaseQuery $query)
{
$query->select(array('tbl.*', 't.id AS user_id', 't.username', 't.gid', 't.name'));
}
protected function _buildQueryColumns(KDatabaseQuery $query)
{
$query->select('c.title AS category_title')->select('c.slug AS category_slug')->select('CONCAT_WS(\'-\', tbl.docman_document_id, tbl.slug) AS alias')->select('tbl.access AS access_raw')->select('(CASE tbl.access WHEN -1 THEN COALESCE(c.access, 1) ELSE tbl.access END) AS access')->select('creator.name AS created_by_name')->select('viewlevel.title AS access_title')->select('IF(tbl.publish_on = 0, tbl.created_on, tbl.publish_on) AS publish_date');
parent::_buildQueryColumns($query);
}
protected function _buildQueryFields(KDatabaseQuery $query)
{
$query->select(array('u1.name AS modified_by_name', 'u2.name AS created_by_name'));
}
protected function _buildQueryColumns(KDatabaseQuery $query)
{
$query->select('r.title AS rank');
parent::_buildQueryColumns($query);
}
