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