public function NewsMenu()
{
$data = array();
$sql = 'SELECT id FROM {{tree}} WHERE parent=1 AND path=\'' . Funcs::$uri[0] . '\' ORDER BY num';
$parent = DB::getOne($sql);
$sql = 'SELECT * FROM {{tree}} WHERE parent=' . $parent . ' AND menu=1 ORDER BY num';
$list = DB::getAll($sql);
foreach ($list as $item) {
$selected = '';
$path = '/' . Funcs::$uri[0] . '/' . $item['path'] . '/';
if ($item['path'] == Funcs::$uri[1]) {
$selected = 'inner';
}
if ($path == '/' . implode('/', Funcs::$uri) . '/') {
$selected = 'selected';
}
$data[] = array('name' => $item['name'], 'path' => $path, 'selected' => $selected, 'years' => MenuWidget::NewsDateMenu($item['id'], $path));
}
if (isset($_GET['d'])) {
$date = explode('-', $_GET['d']);
} else {
$date[] = date('Y');
//$date[]=date('m');
}
if (is_numeric(Funcs::$uri[count(Funcs::$uri) - 1])) {
$date = array();
$element = Tree::getTreeById(Funcs::$uri[count(Funcs::$uri) - 1]);
$date[] = date('Y', strtotime($element['udate']));
$date[] = date('m', strtotime($element['udate']));
}
View::widget('menu/news', array('list' => $data, 'date' => $date));
}
