Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
AdmLogin.php	714 B	-rw-r--r--
AttEntMonthwise.php	14.7 KB	-rw-rw-r--
SubjectForAttSummary.php	1.16 KB	-rw-rw-r--
addStudToCls.php	19.76 KB	-rw-rw-r--
admdet.php	1.06 KB	-rw-r--r--
assignUserMenu.php	14.95 KB	-rw-rw-r--
attEntryDaywise.php	10.82 KB	-rw-rw-r--
attendance.php	17.09 KB	-rw-rw-r--
caccesscontext.php	1.33 KB	-rwxr-xr-x
cappcontext.php	3.83 KB	-rw-rw-r--
cdegree.php	4.54 KB	-rw-rw-r--
cgetclsdepts.php	1.65 KB	-rw-rw-r--
clogin.php	4.31 KB	-rw-rw-r--
cmarksList.php	2.87 KB	-rw-rw-r--
cmenus.php	2.46 KB	-rw-rw-r--
constants.php	818 B	-rw-rw-r--
coutput.php	1.84 KB	-rw-rw-r--
crequestbroker.php	2.49 KB	-rw-rw-r--
csessions.php	548 B	-rw-rw-r--
csubject.php	5.76 KB	-rw-rw-r--
cuser.php	3.53 KB	-rw-rw-r--
cuserType.php	1.83 KB	-rw-rw-r--
degreeResultSheet.php	3.82 KB	-rw-rw-r--
degreeWise_IA_Report.php	4.79 KB	-rw-rw-r--
deletecreatedclass.php	779 B	-rw-rw-r--
duringExam.php	5.99 KB	-rw-r--r--
editclass.php	1.06 KB	-rw-rw-r--
error_log.php	749 B	-rw-rw-r--
getDegSemSubDetnew.php	8.93 KB	-rw-rw-r--
getnumword.php	7.45 KB	-rwxr-xr-x
guidelines.php	578 B	-rw-rw-r--
iamarksentry.php	7.01 KB	-rw-rw-r--
invigilatorDairy.php	8.43 KB	-rw-rw-r--
json.php	34.52 KB	-rw-rw-r--
jwt.php	13.16 KB	-rw-rw-r--
login.php	8.01 KB	-rw-rw-r--
marks_entry_qnWise.php	14.01 KB	-rw-rw-r--
mregistry.php	32.95 KB	-rw-rw-r--
practicalMark.php	28.14 KB	-rw-r--r--
preparethqp.php	23.79 KB	-rw-rw-r--
protected.php	661 B	-rw-rw-r--
qpWiseStudCount.php	8.08 KB	-rw-rw-r--
roomAllotment.php	25.7 KB	-rw-rw-r--
roomDeclaration.php	6.81 KB	-rw-rw-r--
room_allotment_datewise_stph_n...	28.42 KB	-rw-rw-r--
roomallotmentqpwisenew.php	11.44 KB	-rw-rw-r--
roomsAllotmentOnQpcodeWise.php	10.14 KB	-rw-rw-r--
savePassword.php	1.14 KB	-rw-rw-r--
saveUserSetup.php	7.45 KB	-rw-rw-r--
saveclsdets.php	2.27 KB	-rw-rw-r--
sendGridMail.php	1.72 KB	-rw-rw-r--
sendsmsapi_onex_new.php	4.19 KB	-rw-rw-r--
student.php	61.41 KB	-rw-rw-r--
studentForgotPwd.php	5.71 KB	-rw-rw-r--
studentsem.php	3.79 KB	-rw-rw-r--
subject_Details.php	8.74 KB	-rw-rw-r--
updateclass.php	583 B	-rw-rw-r--
uploadStudentPhoto.php	2.15 KB	-rw-rw-r--
uploadphotoofstud.php	1.84 KB	-rw-rw-r--
userRightDetails.php	1.39 KB	-rw-rw-r--

Code Editor : assignUserMenu.php

<?php
   
    function cAssignUserMenu($aobj_context){
        $univcode = $aobj_context->mobj_data["univcode"];
        $usertype = $aobj_context->mobj_data["usertype"];
        $user = $aobj_context->mobj_data["user"];

if ($user == ""){
            $cnd=" ";
        }else{
            $cnd=$user;
        }
        
       
        // 1) $query="select fmenucode, fmenucode as `key`, fmenuname as title, ifnull(ffunction, '') as url, 
        // fmainmenu from col_masmenu where factive ='T' and fismainmenu='T'
        // and instr(ftype, '{$cnd}') > 0";
        // 2) $query = "select fmenucode, fmenucode as `key`, fmenuname as title, ifnull(ffunction, '') as url, 
        //           fmainmenu from col_masmenu where factive ='T' and fismainmenu='T'";
        $query="SELECT INSTR(ftype,'{$user}')AS ftype, fmenucode, fmenucode AS `key`, fmenuname AS title, IFNULL(ffunction, '') AS url, 
                fmainmenu FROM col_masmenu WHERE factive ='T' AND fismainmenu='T'";
             
 
        $result = $aobj_context->mobj_db->GetAll($query);

$arr=[];

foreach($result as $val){
            $menuItems=[];
            if($val['ftype'] != 0){
              $val['ftype']="T";
              $obj['fstatus']=$val['ftype'];
            }else if($val['ftype'] == 0){
                $obj['fstatus']="F";
            }

$menucode = $val['fmenucode'];
            $obj['title'] = $val['title'];
            $obj['url'] = $val['url'];  
            $obj['key']=$val['key'];
            $submenu = array();

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

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

foreach($res as $value){
                $innerSubmenu = array();
                if($menucode == $value['fmainmenu']){
                    if($value['ftype'] != 0){
                        $value['ftype']="T";
                        $sub['fstatus']=$value['ftype'];
                      }else if($value['ftype'] == 0){
                        $sub['fstatus']="F";
                      }
                    $sub['title']=$value['title'];
                    $sub['url']=$value['url'];
                    $sub['key']=$value['key'];
                    
                    // $query1 = "select fmenucode,fmenucode as `key`, fmenuname as title, ifnull(ffunction, '') as url, factive, fmainmenu from col_masmenu 
                    // where factive ='T' and fissubmenu='T' and fmainmenu='{$value['fmenucode']}'
                    // and instr(ftype, '{$usertype}') > 0";

$query1 = "select INSTR(ftype,'{$user}')AS ftype, fmenucode,fmenucode as `key`, fmenuname as title, ifnull(ffunction, '') as url, factive, fmainmenu from col_masmenu 
                    where factive ='T' and fissubmenu='T' and fmainmenu='{$value['fmenucode']}'";
                }
             
                $result1 = $aobj_context->mobj_db->GetAll($query1);
             
       
                    foreach($result1 as $v){
                        if($v['fmainmenu'] === $value['fmenucode']){
                            if($v['ftype'] != 0){
                                $v['ftype']="T";
                                $subm['fstatus']=$v['ftype'];
                              }else if($v['ftype'] == 0){
                                $subm['fstatus']="F";
                              }
                            $subm['title']=$v['title'];
                            $subm['url']=$v['url'];
                            $subm['key']=$v['key'];
                            array_push($innerSubmenu, $subm);
                        }  
                    } 
                 
                    $sub['ssubmenu'] = $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 saveassignuserRight($aobj_context){
        $collcode = $aobj_context->mobj_data["collcode"];
        $univcode = $aobj_context->mobj_data["univcode"];
        $fusertype = $aobj_context->mobj_data["fuser"];

$_data = $aobj_context->mobj_data["data"];
        $data = json_decode($_data,true);
     
        foreach($data as $key => $val){
            $menucode=$val['key'];
            $fstatus=$val['fstatus'];

if($fstatus =="F"){
            //    $removeallmenucode= "SELECT INSTR(ftype,'{$fusertype}') AS ftype FROM col_masmenu WHERE fmenucode='{$menucode}'";
            //    $removeonemenucode=$aobj_context->mobj_db->GetRow($removeallmenucode);

//    if($removeonemenucode['ftype'] == "1"){
                $rmmenucode="UPDATE col_masmenu
                            set ftype=TRIM(BOTH '*' FROM REPLACE(REPLACE(REPLACE(ftype, '*{$fusertype}', ''), '{$fusertype}*', ''), '{$fusertype}', ''))
                            WHERE fmenucode = '{$menucode}'";
            //    }else{
            //     $rmmenucode="UPDATE col_masmenu
            //     set ftype=REPLACE(REPLACE(ftype, '*{$fusertype}', ''), '{$fusertype}*', '')
            //     WHERE fmenucode = '{$menucode}'";
            //    }
              
              
                $resrmmenucode=$aobj_context->mobj_db->Execute($rmmenucode);

}
            else 
            {
                $qrymenucode="SELECT INSTR(ftype,'{$fusertype}') AS ftype FROM col_masmenu WHERE fmenucode='{$menucode}'";
                $resmenucode=$aobj_context->mobj_db->GetRow($qrymenucode);
                if($resmenucode['ftype']==0){
                    $add1menucode="SELECT ftype FROM col_masmenu WHERE fmenucode='{$menucode}' ";
                    $resadd1menucode=$aobj_context->mobj_db->GetRow($add1menucode);
                    if($resadd1menucode['ftype']==""){
                        $qrymenucode1 = "UPDATE col_masmenu
                                        SET ftype = CONCAT(ftype, '{$fusertype}')
                                        WHERE fmenucode = '{$menucode}'";
                    }else{ $qrymenucode1 = "UPDATE col_masmenu
                                            SET ftype = CONCAT(ftype, '*{$fusertype}')
                                            WHERE fmenucode = '{$menucode}'";
                        }
                    
                    
                    $resmenucode1=$aobj_context->mobj_db->Execute($qrymenucode1);
                    if($resmenucode1){
                        $arr['msg']="Successfully Saved";
                        echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success");  
                    } else{
                        $arr['msg']="Failed";
                        echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"fail");
                    }         
                 }else{
                    $arr['msg']="Already Have Rights";
                    echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success");  
                 }
            }

foreach($val['submenu'] as $sval){
              
                     $smenucode=$sval['key'];
                     $sfstatus=$sval['fstatus'];

if($sfstatus =="F"){
                        // $removeallsmenucode= "SELECT INSTR(ftype,'{$fusertype}') AS ftype FROM col_masmenu WHERE fmenucode='{$smenucode}'";
                        // $removeonesmenucode=$aobj_context->mobj_db->GetRow($removeallsmenucode);

// if($removeonesmenucode['ftype'] == "1"){
                        //     $rmsmenucode="UPDATE col_masmenu
                        //     set ftype=''
                        //     WHERE fmenucode = '{$smenucode}' and ftype='{$fusertype}'";
                        //     }else{
                                $rmsmenucode="UPDATE col_masmenu
                                set ftype=TRIM(BOTH '*' FROM REPLACE(REPLACE(REPLACE(ftype, '*{$fusertype}', ''), '{$fusertype}*', ''), '{$fusertype}', ''))
                                WHERE fmenucode = '{$smenucode}'";

// }

// $rmsmenucode="UPDATE col_masmenu
                        //              set ftype=REPLACE(REPLACE(ftype, '*{$fusertype}', ''), '{$fusertype}*', '')
                        //              WHERE fmenucode = '{$smenucode}'";
                                   
                        $resrmsmenucode=$aobj_context->mobj_db->Execute($rmsmenucode);
                     }else{
                        $qrysmenucode="SELECT INSTR(ftype,'{$fusertype}') AS ftype FROM col_masmenu WHERE fmenucode='{$smenucode}'";
                        $ressmenucode=$aobj_context->mobj_db->GetRow($qrysmenucode);
                        
                        if($ressmenucode['ftype']==0){
                            $add1smenucode="SELECT ftype FROM col_masmenu WHERE fmenucode='{$smenucode}' ";
                            $resadd1smenucode=$aobj_context->mobj_db->GetRow($add1smenucode);

if($resadd1smenucode['ftype']==""){
                                $qrysmenucode1 = "UPDATE col_masmenu
                                                SET ftype = CONCAT(ftype, '{$fusertype}')
                                                WHERE fmenucode = '{$smenucode}'";
                            }else{ $qrysmenucode1 = "UPDATE col_masmenu
                                                    SET ftype = CONCAT(ftype, '*{$fusertype}')
                                                    WHERE fmenucode = '{$smenucode}'";
                                }

// $qrysmenucode1 = "UPDATE col_masmenu
                            //                  SET ftype = CONCAT(ftype, '*{$fusertype}')
                            //                  WHERE fmenucode = '{$smenucode}'";
                            $ressmenucode1=$aobj_context->mobj_db->Execute($qrysmenucode1);          
                         }else{
                            $arr['msg']="Already Have Rights";
                            echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success");  
                         }
                      
                     }
               
                foreach($sval['ssubmenu'] as $ssval){
               
                   $ssmenucode=$ssval['key'];
                   $ssfstatus=$ssval['fstatus'];
                  
                   if($ssfstatus=="F"){
                    // $removeallssmenucode= "SELECT INSTR(ftype,'{$fusertype}') AS ftype FROM col_masmenu WHERE fmenucode='{$ssmenucode}'";
                    // $removeonessmenucode=$aobj_context->mobj_db->GetRow($removeallssmenucode);

// if($removeonessmenucode['ftype'] == "1"){
                    //     $rmssmenucode="UPDATE col_masmenu
                    //     set ftype=''
                    //     WHERE fmenucode = '{$ssmenucode}' and ftype='{$fusertype}'";
                    //     }else{
                            $rmssmenucode="UPDATE col_masmenu
                            set ftype=TRIM(BOTH '*' FROM REPLACE(REPLACE(REPLACE(ftype, '*{$fusertype}', ''), '{$fusertype}*', ''), '{$fusertype}', ''))
                            WHERE fmenucode = '{$ssmenucode}'";
                    // }

// $rmssmenucode = "UPDATE col_masmenu
                        //                 set ftype=REPLACE(REPLACE(ftype, '*{$fusertype}', ''), '{$fusertype}*', '')
                        //                 WHERE fmenucode = '{$ssmenucode}'";
                                     
                        $resrmssmenucode=$aobj_context->mobj_db->Execute($rmssmenucode);
                   }else{
                  
                        $qryssmenucode = "SELECT INSTR(ftype,'{$fusertype}') AS ftype FROM col_masmenu WHERE fmenucode='{$ssmenucode}'";
                        $resssmenucode = $aobj_context->mobj_db->GetRow($qryssmenucode);
                    
                    if($resssmenucode['ftype'] == 0){

$add1ssmenucode="SELECT ftype FROM col_masmenu WHERE fmenucode='{$ssmenucode}' ";
                        $resadd1ssmenucode=$aobj_context->mobj_db->GetRow($add1ssmenucode);

if($resadd1ssmenucode['ftype']==""){
                            $qryssmenucode1 = "UPDATE col_masmenu
                                            SET ftype = CONCAT(ftype, '{$fusertype}')
                                            WHERE fmenucode = '{$ssmenucode}'";
                        }else{ $qryssmenucode1 = "UPDATE col_masmenu
                                                SET ftype = CONCAT(ftype, '*{$fusertype}')
                                                WHERE fmenucode = '{$ssmenucode}'";
                            }

// $qryssmenucode1 = "UPDATE col_masmenu
                        //                     SET ftype = CONCAT(ftype, '*{$fusertype}')
                        //                     WHERE fmenucode = '{$ssmenucode}'";
                                     
                         $resssmenucode1=$aobj_context->mobj_db->Execute($qryssmenucode1); 
                    }else{
                        $arr['msg']="Already Have Rights";
                        echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success");  
                    }
                   }
            }
           }
         
        }

}

function cgetusersinformation($aobj_context){
        $univcode = $aobj_context->mobj_data["univcode"];
        $collcode = $aobj_context->mobj_data["collcode"];
      
        $qry=" SELECT fusertype AS `key`,fusertype AS `value`,CONCAT(fuser,' - ',fusertype)AS `label` FROM col_masuser 
               WHERE fcollcode='{$collcode}'";
               $res=$aobj_context->mobj_db->GetAll($qry);

if($res){
                echo $aobj_context->mobj_output->ToJSONEnvelope($res,0,"success"); 
            }else{
                $data = 'Fail to load semester';
                echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
            }

}

${this.title}

Code Editor : assignUserMenu.php