session->userdata("logged_in") == TRUE){
$otoritas = $this->session->userdata("level_id");
$sql = "select id_mtagr, kd_mtagr, no_mtagr, nama_mtagr, parent_mtagr
from mata_anggaran_2020
where parent_mtagr = 0 and aktif = 't'
order by kd_mtagr ASC";
$query_top = $this->db->query($sql);
foreach($query_top->result() as $topmenu){
echo "
";
$sql_det = "select id_mtagr, kd_mtagr, no_mtagr, nama_mtagr, parent_mtagr
from mata_anggaran_2020
where parent_mtagr = $topmenu->id_mtagr and aktif = 't'
order by kd_mtagr ASC";
$query_det = $this->db->query($sql_det);
$total = $query_det->num_rows();
if ($total > 0){
echo "$topmenu->no_mtagr $topmenu->nama_mtagr";
echo "";
foreach($query_det->result() as $detailmenu){
echo "- ";
$sql_det2 = "select id_mtagr, kd_mtagr, no_mtagr, nama_mtagr, parent_mtagr
from mata_anggaran_2020
where parent_mtagr = $detailmenu->id_mtagr and aktif = 't'
order by kd_mtagr ASC";
$query_det2 = $this->db->query($sql_det2);
$total2 = $query_det2->num_rows();
if ($total2 > 0){
echo "$detailmenu->no_mtagr $detailmenu->nama_mtagr";
echo "
";
foreach($query_det2->result() as $detailmenu2){
echo "- $detailmenu2->no_mtagr $detailmenu2->nama_mtagr
";
$sql_det3 = "select id_mtagr, kd_mtagr, no_mtagr, nama_mtagr, parent_mtagr
from mata_anggaran_2020
where parent_mtagr = $detailmenu2->id_mtagr and aktif = 't'
order by kd_mtagr ASC";
$query_det3 = $this->db->query($sql_det3);
$total3 = $query_det3->num_rows();
if ($total3 > 0){
echo "";
foreach($query_det3->result() as $detailmenu3){
echo "- $detailmenu3->no_mtagr $detailmenu3->nama_mtagr
";
}
echo "
";
}else{
echo "";
}
echo "
";
}
echo "
";
}else{
echo "";
}
echo "";
}
echo "";
}else{
echo "";
}
echo "";
}
}
?>