/** * Взять категории документов * * @return array Данные выборки */ public static function getSections() { global $DB; $sql = 'SELECT DISTINCT A.id, A."name", A.date_create, A.date_update, A.sort, COUNT(B.id) FROM docs_sections A LEFT JOIN docs B ON (A.id = B.docs_sections_id) GROUP BY A.id, A."name", A.date_create, A.date_update, A.sort ORDER BY A.sort'; $data = $DB->rows($sql); if ($data) { docs_files::SelectMinMax($data); } return $data; }