Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
apitest.php	1.61 KB	-rw-rw-r--
attendaceSEE.php	2.61 KB	-rwxr-xr-x
caccesscontext.php	1.28 KB	-rwxr-xr-x
cappcontext.php	2.71 KB	-rwxr-xr-x
coutput.php	1.84 KB	-rwxr-xr-x
crequestbroker.php	2.49 KB	-rwxr-xr-x
csessions.php	548 B	-rwxr-xr-x
cuser.php	3.53 KB	-rwxr-xr-x
downloadStudHalltiket.php	2.53 KB	-rw-rw-r--
downloadStudPhoto.php	416 B	-rw-rw-r--
ePRTimetable.php	2.68 KB	-rwxr-xr-x
eRoomAllotmentData.php	2.88 KB	-rwxr-xr-x
eThTimetable.php	2.64 KB	-rwxr-xr-x
edegree.php	2.5 KB	-rwxr-xr-x
esubject.php	4.31 KB	-rwxr-xr-x
genToken.php	790 B	-rw-rw-r--
getexamevent.php	3.41 KB	-rwxr-xr-x
json.php	34.52 KB	-rwxr-xr-x
jssstuMarksAPI.php	2.21 KB	-rw-r--r--
mregistry.php	1.87 KB	-rwxr-xr-x
profile.php	938 B	-rwxr-xr-x
sduvaldata.php	2.57 KB	-rw-r--r--
studentExamFee.php	7.53 KB	-rw-rw-r--
studentResults.php	4.94 KB	-rw-rw-r--
studentia.php	4.5 KB	-rw-rw-r--
studentprofile.php	6.87 KB	-rw-rw-r--
studentsubject.php	5.15 KB	-rw-rw-r--

Code Editor : sduvaldata.php

<?php

function sduvaldata($aobj_context)
{ 
	
		$fexamdate = $aobj_context->mobj_data['examdate']; 
		$subcode = $aobj_context->mobj_data['subcode']; 
		
		$user = "webuser";
		$password = "YOk1PvmvqB";
		$url = "http://115.240.134.84:90/iondvs_sduaher/api/v1/export-marks";
		
		$body = "crs_code={$subcode}&event_name={$fexamdate}";
		
		$ch = curl_init();
		curl_setopt( $ch,CURLOPT_URL, $url);            
		curl_setopt( $ch,CURLOPT_POST, true );

curl_setopt($ch, CURLOPT_RETURNTRANSFER,1);
		curl_setopt($ch, CURLOPT_HTTPAUTH, CURLAUTH_BASIC);
		curl_setopt($ch, CURLOPT_USERPWD, "$user:$password");
		curl_setopt( $ch,CURLOPT_SSL_VERIFYPEER, false );
		curl_setopt( $ch,CURLOPT_POSTFIELDS, $body );
		$result2 = curl_exec($ch);
		//curl_close( $ch );

$resjuno = json_decode($result2,true);
		//echo $resjuno;
		$resdata = $resjuno['data'];
		echo $resdata;
		if($resdata =='Invalid request')
		{
			$query = "INSERT ignore INTO logisys3_sdu.resvalapi (fexamdate,fsubcode,fdate,fmsg)
				VALUES
				('{$fexamdate}','{$subcode}',now(),'{$resdata}')";
			$upres = $aobj_context->mobj_db->Execute($query);
			echo "Exam Date: ".$fexamdate." Subcode: ".$subcode."</br>";
		}else if($resdata =='No data available to export.')
		{
			echo $resdata;
		}
		else
		{
			print_r($resdata);
			foreach($resdata as $val)
			{
				$regno = $val['student_token_id'];
				$degcode = $val['program_acronym'];		
				$subcode = $val['course_code'];
				$subname = str_replace("'","`",$val['course_acronym']);
				$uniqid = $val['student_unique_id'];
				$feditversion = $val['idvs_coe_edit_version'];

$v1 = $val['V1'];
				$v1name = $val['Evaluator_V1'];

$v2 = $val['V2'];
				$v2name = $val['Evaluator_V2'];

$v3 = $val['V3'];
				$v3name = $val['Evaluator_V3'];

$v4 = $val['V4'];
				$v4name = $val['Evaluator_V4'];

$query = "INSERT ignore INTO logisys3_sdu.resvalapi (fexamdate,fregno,funiqid, fdegname, fsubcode, fsubname, feditversion, 
				fv1, fv1teach, fv2, fv2teach, fv3, fv3teach, fv4, fv4teach, fdate,fmsg)
				VALUES
				('{$fexamdate}','{$regno}','{$uniqid}', '{$degcode}','{$subcode}','{$subname}','{$feditversion}',
				'{$v1}','{$v1name}','{$v2}','{$v2name}','{$v3}','{$v3name}','{$v4}','{$v4name}',now(),'success')
				on duplicate key update fv1 = '{$v1}', fv2 = '{$v2}',
				fv1teach = '{$v1name}',fv2teach = '{$v2name}',fv3 = '{$v3}',fv3teach = '{$v3name}',fv4 = '{$v4}',fv4teach = '{$v4name}',
				funiqid = '{$uniqid}',fupddate = now()";
				//var_dump($query);
				$upres = $aobj_context->mobj_db->Execute($query);

echo "regno: ".$regno." Subcode: ".$subcode."</br>";
			}
		}

}

${this.title}

Code Editor : sduvaldata.php