query("SELECT role_menu.*,m_menu.link,m_menu.description,m_menu.additional_href from role_menu
left join m_menu on role_menu.menu_id = m_menu.menu_id
where role_id = ".$_SESSION['ROLES']." ORDER BY role_menu_id");
echo '
';
$html_menu = '
';
$arr_child_level = $arr_navigation = [];
foreach($db_menu->fetchAll() as $rowmenu) {
if($rowmenu['menu_parent'] != 0) {
$arr_child_level[$rowmenu['menu_parent']][] = $rowmenu;
}
else {
$arr_navigation[] = $rowmenu;
}
}
foreach ($arr_navigation as $key => $value) {
$additional_href = ($value['additional_href'] != '') ? '&'.$value['additional_href'] : '';
$nav_link = ($value['link'] != null || $value['link'] != '') ? 'index.php?link='.$value['link'].$additional_href : 'javascript:void(0)';
$hidden_this = ($value['hidden'] == 1) ? ' style="display:none" ' : '';
if($value['menu_class'] == 'dir') {
$html_menu .= '- ';
if(array_key_exists($value['role_menu_id'], $arr_child_level)) {
$html_menu .= '
';
foreach($arr_child_level[$value['role_menu_id']] as $submenu) {
$sub_additional_href = ($submenu['additional_href'] != '') ? '&'.$submenu['additional_href'] : '';
$link_submenu = ($submenu['link'] != null || $submenu['link'] != '') ? 'index.php?link='.$submenu['link'].$sub_additional_href : 'javascript:void(0)';
$sub_hidden = ($submenu['hidden'] == 1) ? ' style="display:none" ' : '';
$html_menu .= '- '.$submenu['description'].'
';
}
$html_menu .= '
';
}
$html_menu .= ' ';
}
else {
$html_menu .= '- '.$value['description'].'
';
}
}
$html_menu .= '
';
echo $html_menu;
echo '
';
?>