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 : iamarksentry.php

<?php
	function getDegreeFOrIAMarks($aobj_context){
		$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
		$collcode = $aobj_context->mobj_data['collcode'];

$qry = "SELECT DISTINCT IFNULL(m.fdegree,'') AS `key`,IFNULL(m.fdegree,'') AS `value`, 
		        IFNULL(CONCAT(m.fdegree,' - ',d.FDESCPN),'') AS label FROM marks m LEFT JOIN degree d
				ON m.fdegree=d.fdegree AND m.`FEXAMNO`=d.`FEXAMNO` 
				WHERE m.fdegree <> '' AND d.FDESCPN<>'' AND m.fcollcode='{$collcode}'";
					
	    $res = $aobj_context->mobj_db->GetAll($qry);			
		if($res){
            echo $aobj_context->mobj_output->ToJSONEnvelope($res, 0, "success"); 
        }else{
            $arr['msg'] = "failed to load";
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); 
            return;
        }
	}

function getSemOnDeg($aobj_context){
        $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
		$collcode = $aobj_context->mobj_data['collcode'];
		$degree= $aobj_context->mobj_data['degree'];

$qry = "SELECT DISTINCT IFNULL(m.FEXAMNO,'') AS `key`,IFNULL(m.FEXAMNO,'') AS `value`, 
				CONCAT(m.FEXAMNO,' - ',d.fexamname) AS label FROM marks m LEFT JOIN degree d
				ON m.fdegree=d.fdegree AND m.`FEXAMNO`=d.`FEXAMNO` 
				WHERE m.fdegree='{$degree}' AND  d.fexamname IS NOT NULL AND m.FEXAMNO <> ''";
			
	     $res = $aobj_context->mobj_db->GetAll($qry);
		 if($res){
            echo $aobj_context->mobj_output->ToJSONEnvelope($res, 0, "success"); 
        }else{
            $arr['msg'] = "failed to load";
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); 
            return;
        			
	}}

$qry = "SELECT s.FCSUBCODE,s.FSUBNAME,COUNT(fregno) AS cnt,s.FVALMAX,m.fmarks,COUNT(fmarks)AS entered,ca.ffreezed as fstatus
		        FROM subject s INNER JOIN collexam c ON s.fdegree=c.fdegree AND s.fexamno=c.fexamno
				INNER JOIN marks m ON s.fdegree=m.fdegree AND s.fexamno=m.fexamno AND s.fcsubcode=m.fsubcode AND c.fcollcode=m.fcollcode
				INNER JOIN collia ca ON m.fdegree=ca.fdegree AND m.fexamno=ca.fexamno AND m.fsubcode=ca.fsubcode AND m.fcollcode=ca.fcollcode
				WHERE NOW() BETWEEN c.fiafrom AND c.fiato AND fintass='T' AND c.fcollcode='{$collcode}' AND c.fdegree='{$degree}' $cnd
				GROUP BY m.fsubcode";
				
        $res = $aobj_context->mobj_db->GetAll($qry);  
		if($res){
            echo $aobj_context->mobj_output->ToJSONEnvelope($res, 0, "success"); 
        }else{
            $arr['msg'] = "failed to load";
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); 
            return;		
	}
	}

$collcode=$aobj_context->mobj_data['collcode'];
		$user=$aobj_context->mobj_data['fuser'];
		$subcode=$aobj_context->mobj_data['subcode'];
		$degree=$aobj_context->mobj_data['degree'];
		$sem=$aobj_context->mobj_data['sem'];
		$status=$aobj_context->mobj_data['status'];
		$ip = $_SERVER['REMOTE_ADDR'];
		
		// $freeze = $aobj_context->mobj_data["freeze"];
		// $freezed = json_decode($freeze,true);

// foreach($freezed as $val){
		// if($val['fstatus'] == "T"){
		// 	$query1="UPDATE collia
		// 			  SET ffreezed='{$val['fstatus']}',ffreezeuser='{$user}',ffreezedate=now(),ffreezeip='{$ip}'
		// 			  WHERE fdegree='{$degree}' AND fexamno='{$sem}' AND fsubcode='{$val['FCSUBCODE']}' AND fcollcode='{$collcode}'";
		// }else{
		// 	$query1="UPDATE collia
		// 			  SET ffreezed='{$val['ffreezed']}',ffreezeuser='{$user}',ffreezedate=now(),ffreezeip='{$ip}'
		// 			  WHERE fdegree='{$degree}' AND fexamno='{$sem}' AND fsubcode='{$val['FCSUBCODE']}' AND fcollcode='{$collcode}'";
		// }
        //     $res1=$aobj_context->mobj_db->Execute($query1);	
		// 	if($res1){
		// 		$arr['msg'] = "Successfully Saved";
		// 		echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "success"); 
		// 	}else{
		// 		$arr['msg'] = "failed to load";
		// 		echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); 
		// 		return;		
		// 	}
		
		// }

foreach($array as $value){
			$qry = "UPDATE marks 
					SET fmarks='{$value['fmarks']}',flogname='{$user}',flogdate=now()
					WHERE fdegree='{$degree}' AND fexamno='{$sem}' AND fregno='{$value['fregno']}' AND fsubcode='{$subcode}'";
            $res = $aobj_context->mobj_db->Execute($qry);

$query = "UPDATE collia
					  SET ffreezed='{$status}',ffreezeuser='{$user}',ffreezedate=now(),ffreezeip='{$ip}'
					  WHERE fdegree='{$degree}' AND fexamno='{$sem}' AND fsubcode='{$subcode}' AND fcollcode='{$collcode}'";
				
			$result=$aobj_context->mobj_db->Execute($query);
		
			if($res || $result){
				$arr['msg'] = "Successfully Saved";
				echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "success"); 
			}else{
				$arr['msg'] = "failed to load";
				echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); 
				return;		
			}
		
		}
		
	}

function freezeSujects($aobj_context){
		$collcode=$aobj_context->mobj_data['collcode'];
		$user=$aobj_context->mobj_data['fuser'];
		$subcode=$aobj_context->mobj_data['subcode'];
		$degree=$aobj_context->mobj_data['degree'];
		$sem=$aobj_context->mobj_data['sem'];
		$status=$aobj_context->mobj_data['status'];
		$ip = $_SERVER['REMOTE_ADDR'];

if($status=="true"){
			$freeze="T";
		}else if($status=="false"){
			$freeze="";
		}
		$query1 = "UPDATE collia
		 		   SET ffreezed='{$freeze}',ffreezeuser='{$user}',ffreezedate=now(),ffreezeip='{$ip}'
				   WHERE fdegree='{$degree}' AND fexamno='{$sem}' AND fsubcode='{$subcode}' AND fcollcode='{$collcode}'";

$result=$aobj_context->mobj_db->Execute($query1);
	
		 if($result){
			$arr['msg'] = "Successfully Saved";
			echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "success"); 
		}else{
			$arr['msg'] = "failed to load";
			echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); 
			return;		
		}
  
	}
?>

${this.title}

Code Editor : iamarksentry.php