function getTree()
{
$data = array();
$sql = 'SELECT * FROM {{reference}} WHERE visible=1 ORDER BY num ASC';
$list = DB::getAll($sql);
if (!empty($list)) {
foreach ($list as $item) {
$sql = 'SELECT * FROM {{reference_files}} WHERE reference=' . $item['id'] . ' ORDER BY name';
$item['files'] = DB::getAll($sql);
Reference::$treeArray[$item['parent']][$item['id']] = $item;
Reference::$all[$item['id']] = $item;
}
foreach (Reference::$treeArray[0] as $item) {
$item['sub'] = Reference::getBranch($item['id']);
$data[$item['path']] = $item;
$item['sub'] = Reference::getBranch($item['id'], true);
$lastId[$item['path']] = $item;
}
Reference::$smartTree = $lastId;
}
Reference::$tree = $data;
}
