Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
attendancenew.php	3.75 KB	-rw-rw-r--
jwt.php	13.16 KB	-rw-rw-r--
login.php	3.44 KB	-rw-rw-r--
sendzohomail.php	1.47 KB	-rw-rw-r--
studentForgotPwd.php	9.53 KB	-rw-rw-r--
studentMasmenu.php	1.82 KB	-rw-rw-r--
studentNotificationstatus.php	1.38 KB	-rw-rw-r--
studentOnlineStudyMaterial.php	6.05 KB	-rw-rw-r--
studentRegistration.php	9.45 KB	-rw-rw-r--
subshort.php	8.97 KB	-rw-rw-r--

Code Editor : studentMasmenu.php

<?php
    function getStudentsMasmenu($aobj_context){

$query = "select trim(fmenuname)as fmenuname, trim(fpath) as fpath,
                  trim(fmainmenu)as fmainmenu, trim(fmenucode)as fmenucode  
                  from student_masmenu where ifnull(fismainmenu, '') = 'T'
                  and ifnull(factive, '') = 'T'";
        $res = $aobj_context->mobj_db->GetAll($query);

$array = [];
        foreach($res as $v){
            $arr['title'] = $v['fmenuname'];
            $arr['url'] = $v['fpath'];

$query1 = "select distinct fcategory from student_masmenu where 
                       ifnull(factive, '') = 'T' and fmainmenu='{$v['fmenucode']}'";
            $res1 = $aobj_context->mobj_db->GetAll($query1);

$items = [];
            foreach($res1 as $val){
                $item['category'] = $val['fcategory'];
                
                $query2 = "select trim(fmenuname)as fmenuname, trim(fpath) as fpath,
                       trim(fmainmenu)as fmainmenu, trim(fmenucode)as fmenucode,  
                       trim(fcategory)as fcategory from student_masmenu where
                       ifnull(factive, '') = 'T' and fmainmenu='{$v['fmenucode']}'
                       and fcategory='{$val['fcategory']}'";

$res2 = $aobj_context->mobj_db->GetAll($query2);

$options = [];
                foreach($res2 as $val){
                    $option['title'] = $val['fmenuname'];
                    $option['url'] = $val['fpath'];
                    array_push($options, $option);
                }
                $item['options']=$options;
                array_push($items, $item);
            }
            $arr['items'] = $items;
            array_push($array, $arr);
        }
        echo $aobj_context->mobj_output->ToJSONEnvelope($array, 0, "success"); 
    }
?>

${this.title}

Code Editor : studentMasmenu.php