<?php

              $id_user_level1 = $this->session->userdata('akses');

              $sql_menu1 = "select menu.*, akses.id , user_level.nama_level from (akses inner join menu on akses.id_menu =menu.id) inner join user_level on akses.id_user_level=user_level.id where akses.id_user_level=$id_user_level1 and menu.is_main_menu='0' and menu.is_aktif='1' and akses.is_aktif='1' order by menu.urutan asc";

              $main_menu = $this->db->query($sql_menu1);


              foreach ($main_menu->result() as $main) {

                          $id_user_level2 = $this->session->userdata('akses');
                          $sql_menu2 = "select menu.*, akses.id , user_level.nama_level from (akses inner join menu on akses.id_menu =menu.id)
                          inner join user_level on akses.id_user_level=user_level.id where akses.id_user_level=$id_user_level2 and menu.is_main_menu=$main->id and menu.is_aktif='1' and akses.is_aktif='1'  order by menu.urutan asc";

                         $sub_menu = $this->db->query($sql_menu2);

                          if ($sub_menu->num_rows() > 0) {
                                // main menu dengan sub menu
                                echo "<li class='treeview'>" . anchor($main->link, '<i class="' . $main->icon . '"></i>' . $main->judul_menu .
                                        '<span class="pull-right-container">
                                                <i class="fa fa-angle-left pull-right"></i>
                                            </span>');
                                // sub menu nya disini
                                echo "<ul class='treeview-menu'>";
                                foreach ($sub_menu->result() as $sub) {
                                    echo "<li>" . anchor($sub->link, '<i class="' . $sub->icon . '"></i>' . $sub->judul_menu) . "</li>";
                                }
                                echo"</ul></li>";
                            } else {
                                // main menu tanpa sub menu
                                echo "<li>" . anchor($main->link, '<i class="' . $main->icon . '"></i>' . $main->judul_menu) . "</li>";
                            }

              }
         ?>