protected function _buildQueryColumns(Library\DatabaseQuerySelect $query)
{
if (!$this->getState()->isUnique()) {
$query->columns(array('count' => 'COUNT(relations.attachments_attachment_id)'))->columns('table')->columns('row');
}
return parent::_buildQueryColumns($query);
}
protected function _buildQueryColumns(Library\DatabaseQuerySelect $query)
{
parent::_buildQueryColumns($query);
if (!$query->isCountQuery()) {
$query->columns(array('page_count' => 'COUNT(pages.pages_page_id)'));
}
}
protected function _buildQueryColumns(Library\DatabaseQuerySelect $query)
{
parent::_buildQueryColumns($query);
if (!$query->isCountQuery()) {
$query->columns(array('extension_name' => 'extensions.name'));
}
}
protected function _buildQueryColumns(Library\DatabaseQuerySelect $query)
{
parent::_buildQueryColumns($query);
$state = $this->getState();
if ($state->container) {
$query->columns(array('container' => 'containers.slug'));
}
}
/**
* Builds SELECT columns list for the query.
*
* @param Library\DatabaseQuerySelect A query object.
* @return void
*/
protected function _buildQueryColumns(Library\DatabaseQuerySelect $query)
{
parent::_buildQueryColumns($query);
$state = $this->getState();
$query->columns(array('loggedin' => 'IF(session.users_session_id IS NOT NULL, 1, 0)', 'role_name' => 'role.name'));
if ($state->loggedin) {
$query->columns(array('loggedin_application' => 'session.application', 'loggedin_on' => 'session.time', 'loggedin_session_id' => 'session.users_session_id'));
}
}
protected function _buildQueryColumns(Library\DatabaseQuerySelect $query)
{
$state = $this->getState();
if ($state->distinct && !empty($state->column)) {
$query->distinct()->columns($state->column)->columns(array('activities_activity_id' => $state->column));
} else {
parent::_buildQueryColumns($query);
$query->columns(array('created_by_name' => 'users.name'));
}
}
protected function _buildQueryColumns(Library\DatabaseQuerySelect $query)
{
parent::_buildQueryColumns($query);
$query->columns(array('group_name' => 'group.name'));
}
protected function _buildQueryColumns(Library\DatabaseQuerySelect $query)
{
parent::_buildQueryColumns($query);
$query->columns(array('category_title' => 'categories.title', 'last_activity_on' => 'IF(tbl.modified_on, tbl.modified_on, tbl.created_on)', 'last_activity_by_name' => 'IF(tbl.modified_on, modifier.name, creator.name)', 'ordering_date' => 'IF(tbl.publish_on, tbl.publish_on, tbl.created_on)'));
}
protected function _buildQueryColumns(Library\DatabaseQuerySelect $query)
{
parent::_buildQueryColumns($query);
$query->columns(array('listbox' => "CONCAT(section.title, ' - ', tbl.title)", 'section' => 'section.title'));
}
protected function _buildQueryColumns(Library\DatabaseQuerySelect $query)
{
parent::_buildQueryColumns($query);
$query->columns(array('count' => 'COUNT( relations.tags_tag_id )'));
}
protected function _buildQueryColumns(Library\DatabaseQuerySelect $query)
{
parent::_buildQueryColumns($query);
$query->columns(array('title' => 'tags.title', 'slug' => 'tags.slug'));
}
protected function _buildQueryColumns(Library\DatabaseQuerySelect $query)
{
parent::_buildQueryColumns($query);
$query->columns(array('thumbnail' => 'thumbnails.thumbnail'));
}
protected function _buildQueryColumns(Library\DatabaseQuerySelect $query)
{
parent::_buildQueryColumns($query);
$query->columns(array('category_title' => 'categories.title'));
}
protected function _buildQueryColumns(Library\DatabaseQuerySelect $query)
{
$query->columns[] = 'u.name AS user_name';
parent::_buildQueryColumns($query);
}
protected function _buildQueryColumns(Library\DatabaseQuerySelect $query)
{
parent::_buildQueryColumns($query);
$query->columns(array('group' => 'group.title', 'section' => 'section.title', 'category' => 'category.title', 'condition' => 'condition.title', 'brand' => 'brand.title'));
}
