<?php
    $query = 'SELECT * FROM permisos as p LEFT JOIN secciones_web as s ON p.id_seccion_web = s.id WHERE s.parent_id = 0 AND s.activo = 1 AND (p.seccion = "'.$_SESSION["user_section"].'" OR p.usuario="'.$_SESSION["user"].'") GROUP BY p.id_seccion_web ORDER BY s.orden ASC';
    mysql_query("SET NAMES 'utf8'");
    $results = mysql_query($query,$db_conn);

    $menu = "";

    while($rowp = mysql_fetch_assoc($results)){
        $menu.='<li class="submenu"><a href="#"><i class="icon '.$rowp["icon"].'"></i> <span>'.$rowp["nombre"].'</span></a><ul>';
        $q = 'SELECT * FROM permisos as p LEFT JOIN secciones_web as s ON p.id_seccion_web=s.id WHERE s.parent_id='.$rowp["id"].' AND s.activo=1 AND (p.seccion = "'.$_SESSION["user_section"].'" OR p.usuario="'.$_SESSION["user"].'") GROUP BY p.id_seccion_web ORDER BY s.orden ASC';
$resultado = mysql_query($q,$db_conn);
if (!$resultado) {
    die('Invalid query: ' . mysql_error());
}
        while($rowsubmennu = mysql_fetch_assoc($resultado)){
            if($_SESSION["user_section"] == "Almacén" && $rowsubmennu["url"] == "pedido-almacen.php"){
                $menu.='<li><a href="'.$rowsubmennu["url"].'" class="navi">'.$rowsubmennu["nombre"].'<span class="label label-pedidos">0</span></a></li>';
            }else{
                $menu.='<li><a href="'.$rowsubmennu["url"].'" class="navi">'.$rowsubmennu["nombre"].'</a></li>';
            }
        }
        $menu.= "</ul></li>";
    }
?>

        <div id="user-nav" class="navbar navbar-inverse">
            <ul class="nav btn-group">
                <li><a><?php echo $_SESSION["user_section"]; ?></a></li>
                <li><a><?php echo $_SESSION["user"]; ?></a></li>
                <li class="btn btn-inverse"><a class="navi" title="" href="config.php"><i class="icon icon-cog"></i> <span class="text">Ajustes</span></a></li>
                <li class="btn btn-inverse"><a title="" href="logout.php"><i class="icon icon-share-alt"></i> <span class="text">Salir</span></a></li>
            </ul>
        </div>

        <div id="sidebar">
            <ul>
                <li class="active"><a class="navi" href="index.html"><i class="icon icon-home"></i> <span>Inicio</span></a></li>
                    <?php echo $menu; ?>

            </ul>

        </div>