sidebar

function sidebar_menu()
{
    $ci = get_instance();

    $role_id   = $ci->session->userdata('role_id');
    $queryMenu = "SELECT `user_menu`.`id`, `menu`
                    FROM `user_menu` JOIN `user_access_menu`
                      ON `user_menu`.`id` = `user_access_menu`.`menu_id`
                   WHERE `user_access_menu`.`role_id` = $role_id
                ORDER BY `user_access_menu`.`menu_id` ASC";

    $menu      = $ci->db->query($queryMenu)->result_array();

    foreach ($menu as $m)
    {
        echo '<div class="sidebar-heading">';
                $m['menu'];
        echo '</div>';

        $menuId = $m['id'];
        $querySubMenu = "SELECT *
                           FROM `user_sub_menu` JOIN `user_menu`
                             ON `user_sub_menu`.`menu_id` = `user_menu`.`id`
                          WHERE `user_sub_menu`.`menu_id` = $menuId
                            AND `user_sub_menu`.`is_active` = 1";
        $subMenu = $ci->db->query($querySubMenu)->result_array();

        foreach ($subMenu as $sm)
        {
            if ($title == $sm['title']) {
               echo '<li class="nav-item active">';
            } else {
                echo '<li class="nav-item">';
            }
                echo '<a href="'. base_url($sm['url']).'" class="nav-link pb-0">';
                echo '<i class="'. $sm['icon']. '"></i>';
                echo '<span>'.$sm['title'].'</span>';
                echo '</a>';
                echo '</li>';
            }

        }

        echo '<hr class="sidebar-divider mt-3">';
    }
}