Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
AdmLogin.php	714 B	-rw-r--r--
addStudToCls.php	19.78 KB	-rw-r--r--
admdet.php	1.06 KB	-rw-r--r--
assignUserMenu.php	14.91 KB	-rw-r--r--
attEntryDaywise.php	11.03 KB	-rw-r--r--
caccesscontext.php	1.33 KB	-rwxr-xr-x
cappcontext.php	3.76 KB	-rw-r--r--
cdegree.php	4.54 KB	-rw-r--r--
cgetclsdepts.php	1.65 KB	-rw-r--r--
clogin.php	4.31 KB	-rw-r--r--
cmenus.php	2.46 KB	-rw-r--r--
constants.php	818 B	-rw-r--r--
coutput.php	1.84 KB	-rw-r--r--
crequestbroker.php	2.49 KB	-rw-r--r--
csessions.php	548 B	-rw-r--r--
csubject.php	5.75 KB	-rw-r--r--
cuser.php	3.53 KB	-rw-r--r--
cuserType.php	1.86 KB	-rw-r--r--
degreeResultSheet.php	3.82 KB	-rw-r--r--
degreeWise_IA_Report.php	4.79 KB	-rw-r--r--
deletecreatedclass.php	779 B	-rw-r--r--
duringExam.php	2.7 KB	-rw-r--r--
editclass.php	1.06 KB	-rw-r--r--
error_log.php	749 B	-rw-r--r--
getDegSemSubDetnew.php	8.55 KB	-rw-r--r--
getnumword.php	7.45 KB	-rwxr-xr-x
guidelines.php	578 B	-rw-r--r--
iamarksentry.php	6.92 KB	-rw-r--r--
json.php	34.52 KB	-rw-r--r--
jwt.php	13.16 KB	-rw-r--r--
login.php	8.01 KB	-rw-r--r--
marks_entry_qnWise.php	14.01 KB	-rw-r--r--
mregistry.php	21.88 KB	-rw-r--r--
practicalMark.php	28.2 KB	-rw-r--r--
preparethqp.php	23.68 KB	-rw-r--r--
protected.php	661 B	-rw-r--r--
savePassword.php	1.31 KB	-rw-r--r--
saveUserSetup.php	7.46 KB	-rw-r--r--
saveclsdets.php	2.27 KB	-rw-r--r--
sendGridMail.php	1.72 KB	-rw-r--r--
sendsmsapi_onex_new.php	4.19 KB	-rw-r--r--
student.php	61.41 KB	-rw-r--r--
studentsem.php	3.79 KB	-rw-r--r--
subject_Details.php	8.92 KB	-rw-r--r--
updateclass.php	583 B	-rw-r--r--
uploadStudentPhoto.php	2.15 KB	-rw-r--r--
uploadphotoofstud.php	1.84 KB	-rw-r--r--
userRightDetails.php	1.39 KB	-rw-r--r--

Code Editor : cdegree.php

<?php
    function cgetDegreedet($aobj_context){
        $univcode = $aobj_context->mobj_data["univcode"];
        $type = $aobj_context->mobj_data["type"];
        $collcode = $aobj_context->mobj_data["collcode"];
        $degree_code=trim($aobj_context->mobj_data["degree_range"]);
     
        if($type === 'selectedonly'){
             $query="select ifnull(B.FDEGREE, '') as FDEGREE, ifnull(B.FDESCPN,'') as FDESCPN ,A.FDELETED ,
                    IF(A.FDELETED='F','CHECKED',' ') AS CHECKED from colldeg A 
                    left join degree B on A.FDEGREE = B.FDEGREE 
                    Where A.FCOLLCODE='{$collcode}' and ifnull(B.FDEGREE,'')<>'' and A.FDELETED='F' group by A.FDEGREE ";
        }else{
            $degree_code=($degree_code=='')?"where ifnull(FDEGREE, '') <> ''":" where FDEGREE like '%{$degree_code}%'";
            $query = "select ifnull(A.FDEGREE, '')as FDEGREE, ifnull(A.FDESCPN, '')as FDESCPN, IF(B.FDELETED='F','CHECKED',' ') AS CHECKED from
                    (select ifnull(FDEGREE, '')as FDEGREE, ifnull(FDESCPN, '')as FDESCPN from degree     {$degree_code} 
                    group by FDEGREE) A	
                    LEFT JOIN colldeg B on A.FDEGREE = B.FDEGREE and B.FCOLLCODE='{$collcode}' and B.FDELETED='F'
                    and ifnull(A.FDEGREE , '')<> ''						 
                    group by A.FDEGREE ";
          
        }
        $result = $aobj_context->mobj_db->GetAll($query);
        if($result){
            echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); 
        }else{
            $arr['msg']='failed to load';
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure");
            return;
        }
      
    }

function csaveDegreedet($aobj_context){

$data=json_decode($aobj_context->mobj_data["data"],true);
        $univcode = $aobj_context->mobj_data["univcode"];
        $degree = $aobj_context->mobj_data["degree"];
        $collcode = $aobj_context->mobj_data["collcode"];
        $user = $aobj_context->mobj_data["user"];

foreach($data as $val){
            if($val['CHECKED'] === "CHECKED"){
                $cond = 'F';
            }else{
                $cond = 'T';
            }
            
            $check_dup = "select count(*) as count from colldeg where  
                            FCOLLCODE='{$collcode}' 
                            and FDEGREE='{$val['FDEGREE']}'";
                                   
		    $res_check_dup = $aobj_context->mobj_db->getRow($check_dup); 
          
            $dup_flag = $lobj_check_dup['count'];

if($dup_flag === 0){
                $query = "insert into colldeg( FCOLLCODE,FDEGREE,FDELETED,FLOGNAME,FLOGDATE)values	
								   ('{$collcode}','{$val['FDEGREE']}','{$cond}','{$user}',now())";	
                                 
            }else{
                $query = "update colldeg set fdeleted='{$cond}' where fcollcode='{$collcode}' and 
                          fdegree = '{$val['FDEGREE']}'";
                         
            }

$resupd = $aobj_context->mobj_db->Execute($query);

$check_dup_collexam = "select count(*) as count from collexam where 
                                   fcollcode='{$collcode}' and fdegree='{$val['FDEGREE']}'";
                                   
            $res_check_dup_collexam = $aobj_context->mobj_db->getRow($check_dup_collexam);
            $dup_flag_collexam =  $res_check_dup_collexam['count'];

if($dup_flag_collexam === 0){
                $query_collexam = "insert into collexam (fcollcode, fdegree, fexamno, fsuspend, fdeleted)
                                   select '{$collcode}', fdegree, fexamno, 'F', '{$cond}'
                                   from degree where fdegree='{$val['FDEGREE']}'";
                                   
            }else{
                $query_collexam = "update collexam set fdeleted='{$cond}' where fcollcode='{$collcode}' and 
                                   fdegree='{$val['FDEGREE']}'";
                                 
            }
            $resupd_colexam = $aobj_context->mobj_db->Execute($query_collexam);
        
        }  
        
        if($resupd){
            $arr['msg'] = "updated successfully";
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
        }else{
            $arr['msg']='failed to update';
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure");
            return;
        }
       
    }
?>

${this.title}

Code Editor : cdegree.php