Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
financeDepartment.php	1.78 KB	-rw-rw-r--
financeDesignation.php	1.78 KB	-rw-rw-r--
financeMenuItems.php	3.15 KB	-rw-rw-r--
financeTeacherDetails.php	6.38 KB	-rw-rw-r--
flogin.php	1.71 KB	-rw-rw-r--
fprofile.php	1.79 KB	-rw-rw-r--
getBankDetails.php	15.04 KB	-rw-r--r--

Code Editor : financeMenuItems.php

<?php
    function getMenuItemsFinance($aobj_context){
        $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);  
        $univcode = $aobj_context->mobj_data["univcode"];
        $usertype = $aobj_context->mobj_data["usertype"];
        
        $query="select fmenucode, fmenuname as title, ifnull(ffunction, '') as url, 
                fmainmenu from fms_masmenu where factive ='T' and fismainmenu='T'
                and instr(ftype, '{$usertype}') > 0";

$result = $aobj_context->pobj_db->GetAll($query);

$arr=[];

foreach($result as $val){
            $menuItems=[];
            $menucode = $val['fmenucode'];
            $obj['title'] = $val['title'];
            $obj['url'] = $val['url'];  
            $submenu = array();

$qry = "select fmenucode, fmenuname as title, ifnull(ffunction, '') as url, factive, fmainmenu from fms_masmenu 
                    where factive ='T' and fissubmenu='T' and fmainmenu='{$menucode}'
                    and instr(ftype, '{$usertype}') > 0";

$res = $aobj_context->pobj_db->GetAll($qry);

foreach($res as $value){
                $innerSubmenu = array();
                if($menucode == $value['fmainmenu']){
                    $sub['title']=$value['title'];
                    $sub['url']=$value['url'];
                    
                }

$query1 = "select fmenucode, fmenuname as title, ifnull(ffunction, '') as url, factive, fmainmenu from fms_masmenu 
                           where factive ='T' and fissubmenu='T' and fmainmenu='{$value['fmenucode']}'
                           and instr(ftype, '{$usertype}') > 0";
                $result1 = $aobj_context->pobj_db->GetAll($query1);
                
                    foreach($result1 as $v){
                        if($v['fmainmenu'] === $value['fmenucode']){
                            $subm['title']=$v['title'];
                            $subm['url']=$v['url'];
                            array_push($innerSubmenu, $subm);
                        }  
                    } 
                    $sub['submenu'] = $innerSubmenu;
                    array_push($submenu, $sub);
            }
            $obj['submenu'] = $submenu;
            array_push($arr, $obj);
        }

if($result){
            $menu['menu'] = $arr;
            echo $aobj_context->mobj_output->ToJSONEnvelope($menu,0,"success");  
        }else{
            $arr['msg'] = 'Failed to load';
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure");
        }
    }

function getFinanceHeaderName($aobj_context){
        $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);  
        $univcode = $aobj_context->mobj_data["univcode"];
        $pathname = substr($aobj_context->mobj_data['pathname'], 1);

$query = "select ifnull(fmenuname, '')as fmenuname from fms_masmenu 
                  where ffunction='{$pathname}'";
        $result = $aobj_context->pobj_db->GetRow($query);
        if($result){
            echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success");
        }else{
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure");
        }
    }
?>

${this.title}

Code Editor : financeMenuItems.php