Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
apitest.php	1.61 KB	-rw-r--r--
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.47 KB	-rw-r--r--
downloadStudPhoto.php	416 B	-rw-r--r--
genToken.php	712 B	-rw-r--r--
json.php	34.52 KB	-rwxr-xr-x
mregistry.php	1.29 KB	-rwxr-xr-x
profile.php	938 B	-rwxr-xr-x
studentExamFee.php	4.11 KB	-rw-r--r--
studentResults.php	27.27 KB	-rw-r--r--
studentResults_live.php	2.69 KB	-rw-r--r--
studentia.php	8.14 KB	-rw-r--r--
studentprofile.php	6.25 KB	-rw-r--r--
studentsubject.php	5.14 KB	-rw-r--r--

Code Editor : studentResults.php

<?php

function getStudRes($aobj_context)
{ 		
		
	
	$headers = array
	(
		"Content-Type: application/json"
	);

$degcode = ($aobj_context->mobj_data["degcode"]);
	$sem = ($aobj_context->mobj_data["sem"]);
	$cnd = "and m.fexamno = '{$sem}'";
	if($sem == 'All')
		$cnd = '';

$query = "select d.fexamdate,d.fexamno,d.fdescpn,d.fexamname,s.fsubshort,
	s.fsubname,m.fregno, m.fmarks11 as fmarks,
	s.fvalmax 
	From tabulate m inner join degree d on m.fdegree = d.fdegree 
	and m.fexamno = d.fexamno inner join subject s on m.fdegree = s.fdegree 
	and m.fexamno = s.fexamno
	and m.fsubcode = s.fcsubcode
	
	where ifnull(m.fstatus,'') <> 'success'
	and m.fdegree = '{$degcode}'
	{$cnd}";	
	
	$res1 = $aobj_context->mobj_db->getAll($query);	
	
	$finalarry = [];
	
	$i = 0;
	$sems = array("A"=>"I", "B"=>"II","C"=>"III","D"=>"IV","E"=>"V","F"=>"VI","G"=>"VII","H"=>"VIII","I"=>"IX","J"=>"X");

foreach($res1 as $val)
	{	
		$fexamno = $val['fexamno'];
		$fregno = $val['fregno'];
		$fsubshort = $val['fsubshort'];
		$fexamname = $sems[$fexamno];
		$fdescpn = $val['fdescpn'];
		$fsubname = $val['fsubname'];
		$fmarks = $val['fmarks'];
		$fvalmax = $val['fvalmax'];
		$fexamdate = $val['fexamdate'];
		$subarry = [];
		
		$subarry['regno'] = $fregno;
		$subarry['sem'] = $fexamname;
		$subarry['subcode'] = $fsubshort;
		$subarry['exam'] = $fexamdate;
		$subarry['maxmarks'] = $fvalmax;
		
		//$subarry['subname'] = $fsubname;
		//$subarry['degree'] = $fdescpn;
		$subarry['marks'] = $fmarks;
		
		// if($fregno == 'R14CV100')
		// 	$subarry['status'] = "Update";
		// else
		// 	$subarry['status'] = "New";
		
		array_push($finalarry,$subarry);
		$i++;
	}

$res['data'] = $finalarry;
	$res['status'] = "success";
	$msg = "success";

$resdata = $aobj_context->mobj_output->ToJSONEnvelope($res,0,$msg);

$url = "https://ruasportal.msruas.ac.in/restApi/updatingExamCodingDecodingEntries.json?apiKey=7d32das2sd-3df71-6w2h9-s3hwo-a2q95lf3cp";

$ch = curl_init();
	curl_setopt( $ch,CURLOPT_URL, $url); 
	curl_setopt( $ch,CURLOPT_POST, true );
	curl_setopt( $ch,CURLOPT_HTTPHEADER, $headers );
	curl_setopt( $ch,CURLOPT_RETURNTRANSFER, true );
	curl_setopt( $ch,CURLOPT_SSL_VERIFYPEER, false );
	curl_setopt( $ch,CURLOPT_POSTFIELDS, $resdata );
	$result2 = curl_exec($ch);
	curl_close( $ch );
	echo $result2;
	$resjuno = json_decode($result2,true);
	foreach($resjuno as $val)
	{
		$regno = $val['regno'];
		$status = $val['status'];		
		$msg = $val['msg'];
		$subcode = $val['subcode'];
	
		$query = "update tabulate set fstatus = '{$status}',fmsg = '{$msg}',
		fpushdate = now()
		where fregno = '{$regno}' and fsubshort = '{$subcode}'";
	
		$upres = $aobj_context->mobj_db->Execute($query);
		echo "regno: ".$regno." Subcode: ".$subcode." Message: ".$msg." ";
	}
	die();

}

function getStudResTest($aobj_context)
{ 		
		
	$headers = array
	(
		"Content-Type: application/json"
	);

$degcode = ($aobj_context->mobj_data["degcode"]);
	$sem = ($aobj_context->mobj_data["sem"]);
	$cnd = "and m.fexamno = '{$sem}'";
	if($sem == 'All')
		$cnd = '';

$query = "select d.fexamdate,d.fexamno,s.fvalmax,
	d.fdescpn,d.fexamname,m.fsubshort,
	s.fsubname,m.fregno, m.fmarks11 as fmarks 
	From tabulate m inner join degree d on m.fdegree = d.fdegree 
	and m.fexamno = d.fexamno inner join subject s on m.fdegree = s.fdegree 
	and m.fexamno = s.fexamno
	and m.fsubcode = s.fcsubcode
	where m.fregno in('20ETCS002153') and m.fexamno = 'C'";
	
	$res1 = $aobj_context->mobj_db->getAll($query);	
	
	$finalarry = [];
	
	$i = 0;
	$sems = array("A"=>"I", "B"=>"II","C"=>"III","D"=>"IV","E"=>"V","F"=>"VI","G"=>"VII","H"=>"VIII","I"=>"IX","J"=>"X");

$subarry['subcode'] = $fsubshort;
		$subarry['exam'] = $fexamdate;
		//$subarry['subname'] = $fsubname;
		//$subarry['degree'] = $fdescpn;
		$subarry['marks'] = $fmarks;
		$subarry['maxmarks'] = $fvalmax;
		
		// if($fregno == 'R14CV100')
		// 	$subarry['status'] = "Update";
		// else
		// 	$subarry['status'] = "New";
		
		array_push($finalarry,$subarry);
		$i++;
	}

$res['data'] = $finalarry;
	$res['status'] = "success";
	$msg = "success";

$resdata = $aobj_context->mobj_output->ToJSONEnvelope($res,0,$msg);
	echo $resdata;

//$url = "http://45.113.248.145:8001/restApi/updatingExamCodingDecodingEntries.json?apiKey=31sdf658g3-s3p62-lk21f-a1qw9re2rt";
	$url = "https://ruasportal.msruas.ac.in/restApi/updatingExamCodingDecodingEntries.json?apiKey=7d32das2sd-3df71-6w2h9-s3hwo-a2q95lf3cp";
	$ch = curl_init();
	curl_setopt( $ch,CURLOPT_URL, $url); 
	curl_setopt( $ch,CURLOPT_POST, true );
	curl_setopt( $ch,CURLOPT_HTTPHEADER, $headers );
	curl_setopt( $ch,CURLOPT_RETURNTRANSFER, true );
	curl_setopt( $ch,CURLOPT_SSL_VERIFYPEER, false );
	curl_setopt( $ch,CURLOPT_POSTFIELDS, $resdata );
	$result2 = curl_exec($ch);
	curl_close( $ch );
	echo $result2;
	$resjuno = json_decode($result2,true);
	foreach($resjuno as $val)
	{
		$regno = $val['regno'];
		$status = $val['status'];		
		$msg = $val['msg'];
		$subcode = $val['subcode'];
	
		$query = "update tabulate set fteststatus = '{$status}',ftestmsg = '{$msg}',
		ftestpushdate = now()
		where fregno = '{$regno}' and fsubshort = '{$subcode}'";
	
		$upres = $aobj_context->mobj_db->Execute($query);
		echo "regno: ".$regno." Subcode: ".$subcode." Message: ".$msg." ";
	}
	die();

}

function getStudResTDVS($aobj_context)
{ 		
		
	$headers = array
	(
		"Content-Type: application/json"
	);

$degcode = ($aobj_context->mobj_data["degcode"]);
	$sem = ($aobj_context->mobj_data["sem"]);
	$qpcode = ($aobj_context->mobj_data["qpcode"]);

$year = ($aobj_context->mobj_data["year"]);
	$examtype = ($aobj_context->mobj_data["examtype"]);

$cnd = "and m.fexamno = '{$sem}'";
	if($sem == 'All')
		$cnd = '';

// $query = "select distinct fdegree,fqpcode 
		// From subject where fqpcode in('19FET508A')";	
		// $res9 = $aobj_context->mobj_db->getAll($query);

// foreach($res9 as $v)
		// {
			// $degcode = $v['fdegree'];
			// $qpcode  = $v['fqpcode'];

$query = "select count(fregcode) as cnt
			From tdvs_tabsum where ifnull(fqpcode,'') = '{$qpcode}'
			and ifnull(fstatus,'') <> 'FINAL'";	
			$res3 = $aobj_context->mobj_db->getRow($query);

if($res3['cnt'] >0)
			{
				echo "Val. is Incomplete. QP Code: ".$qpcode."; Scripts: ".$res3['cnt'];
				return;
				die();
			}

$query = "select if(fnoval = '','1',ifnull(fnoval,'1')) as fnoval 
			From tdvs_masqp where ifnull(fqpcode,'') = '{$qpcode}'";	
			$res2 = $aobj_context->mobj_db->getRow($query);

if($res2['fnoval'] == '1')
			{	
				$query = "select r.fregcode,r.fqpcode,r.fregno,m.fsubname,
				CEILING(t1.fsysmarks) as fmarks,
				d.fexamdate,
				m.fexamno,
				s.fsubshort as fsubshort,
				s.fvalmax as fvalmax
				from tdvs_tabulate r 
				inner join tdvs_masqp m on r.fqpcode = m.fqpcode
				inner join tdvs_deggrp d on m.fdeggrp = d.fdeggrp
				inner join (select distinct fqpcode,fsubshort,fvalmax from subject 
				where ifnull(fqpcode,'') <> '' group by fqpcode) s on m.fqpcode = s.fqpcode
				inner join tdvs_tabsum t1 on r.fregcode= t1.fregcode and r.fqpcode = t1.fqpcode and t1.fvalno = '1'
				where r.fqpcode in(select fqpcode from subject where fqpcode = '{$qpcode}')
				and r.fqpcode = '{$qpcode}'
				and r.fyear = '{$year}'
				and r.fexamtype = '{$examtype}'
				and ifnull(r.fstatus,'') <> 'success'
				and r.fregno = r.fregno2
				and ifnull(r.fregno,'') <> ''
				and ifnull(t1.fstatus,'') = 'FINAL'
				and ifnull(r.fregno2,'') <> ''
				and ifnull(t1.fsysmarks,'') <> ''
				and r.fregno = r.fregno2
				group by r.fregcode
				having fmarks <=fvalmax";
				
				$res1 = $aobj_context->mobj_db->getAll($query);	
				// var_dump($query);
				// die();
			}else if($res2['fnoval'] == '4')
			{
				$query = "select r.fregcode,r.fqpcode,r.fregno,m.fsubname,
				CEILING((t1.fsysmarks+t2.fsysmarks+t3.fsysmarks+t4.fsysmarks)/4) as fmarks,
				d.fexamdate,
				m.fexamno,
				s.fsubshort as fsubshort,
				s.fvalmax as fvalmax
				from tdvs_tabulate r 
				inner join tdvs_masqp m on r.fqpcode = m.fqpcode
				inner join tdvs_deggrp d on m.fdeggrp = d.fdeggrp
				inner join (select distinct fqpcode,fsubshort,fvalmax from subject 
				where fqpcode = '{$qpcode}'
				and ifnull(fqpcode,'') <> ''
				group by fqpcode
				) s on m.fqpcode = s.fqpcode
				inner join tdvs_tabsum t1 on r.fregcode= t1.fregcode 
				and r.fqpcode = t1.fqpcode and t1.fvalno = '1'
				inner join tdvs_tabsum t2 on r.fregcode = t2.fregcode 
				and r.fqpcode = t2.fqpcode and t2.fvalno = '2'
				inner join tdvs_tabsum t3 on r.fregcode = t3.fregcode 
				and r.fqpcode = t3.fqpcode and t3.fvalno = '3'
				inner join tdvs_tabsum t4 on r.fregcode = t4.fregcode 
				and r.fqpcode = t4.fqpcode and t4.fvalno = '4'
				left join student st on r.fregno = st.fregno
				where r.fqpcode = '{$qpcode}'
				and r.fyear = '{$year}'
				and r.fexamtype = '{$examtype}'
				and ifnull(r.fstatus,'') <> 'success'
				and ifnull(r.fregno,'') <> ''
				and ifnull(r.fregno2,'') <> ''
				and r.fregno = r.fregno2
				and m.fnoval = '4'
				having fmarks <=fvalmax";
				$res1 = $aobj_context->mobj_db->getAll($query);	
				// var_dump($query);
				// die();
			}
			else if($degcode == 'MBBS1')
			{
				$query = "select r.fregcode,r.fqpcode,r.fregno,m.fsubname,
				(if(ifnull(t3.fsysmarks,'') = '', CEILING((CEILING(t2.fsysmarks)+CEILING(t1.fsysmarks))/2) ,
				(CEILING(if( ABS(ifnull(t3.fsysmarks,'0')-ifnull(t2.fsysmarks,'0')) > ABS(ifnull(t3.fsysmarks,'0')-ifnull(t1.fsysmarks,'0')), ((CEILING(ifnull(t3.fsysmarks,'0'))+CEILING(ifnull(t1.fsysmarks,'0')))/2), ((CEILING(ifnull(t3.fsysmarks,'0'))+CEILING(ifnull(t2.fsysmarks,'0')))/2) ))))+o.fmarks) as fmarks ,
				d.fexamdate,
				m.fexamno,
				s.fsubshort as fsubshort,
				s.fvalmax as fvalmax
				from tdvs_tabulate r 
				left join student st on r.fregno = st.fregno
				inner join tdvs_masqp m on r.fqpcode = m.fqpcode
				inner join tdvs_deggrp d on m.fdeggrp = d.fdeggrp
				inner join omrmarks o on o.fqpcode = m.fqpcode
				and r.fregno = o.fregno and o.fansbook = r.fansbook
				inner join (select distinct fqpcode,fsubshort,fvalmax from subject where fdegree = '{$degcode}'
				and fqpcode = '{$qpcode}'
				and ifnull(fqpcode,'') <> ''
				group by fqpcode) s on m.fqpcode = s.fqpcode
				inner join tdvs_tabsum t1 on r.fregcode= t1.fregcode and r.fqpcode = t1.fqpcode and t1.fvalno = '1'
				and ifnull(t1.fstatus,'') = 'FINAL'
				inner join tdvs_tabsum t2 on r.fregcode = t2.fregcode and r.fqpcode = t2.fqpcode and t2.fvalno = '2'
				and ifnull(t2.fstatus,'') = 'FINAL'
				left join tdvs_tabsum t3 on r.fregcode = t3.fregcode and r.fqpcode = t3.fqpcode and t3.fvalno = 'D'
				and ifnull(t3.fstatus,'') = 'FINAL'
				where r.fqpcode in(select fqpcode from subject where fdegree = '{$degcode}')
				and ifnull(r.fstatus,'') <> 'success'
				and ifnull(r.fregno,'') <> ''
				and ifnull(r.fregno2,'') <> ''
				and r.fregno = r.fregno2
				and r.fqpcode = '{$qpcode}'
				and r.fyear = '{$year}'
				and r.fexamtype = '{$examtype}'
				having fmarks <= fvalmax";
				
				$res1 = $aobj_context->mobj_db->getAll($query);	
			}else if($qpcode == 'MICR201(IC)x')
			{
				$query = "select * from tdvs_tabulate_m where fqpcode = '{$qpcode}'";
				$res1 = $aobj_context->mobj_db->getAll($query);
			}
			else
			{
				// $query = "select r.fregcode,r.fqpcode,r.fregno,m.fsubname,
				// if(ifnull(t3.fsysmarks,'') = '', CEILING((t2.fsysmarks+t1.fsysmarks)/2) ,
				// if(ABS(t3.fsysmarks - t1.fsysmarks) > ABS(t3.fsysmarks - t2.fsysmarks),
				// CEILING((t3.fsysmarks+t2.fsysmarks)/2),
				// CEILING((t3.fsysmarks+t1.fsysmarks)/2))
				// ) as fmarks,
				// d.fexamdate,
				// m.fexamno,
				// s.fsubshort as fsubshort,
				// m.fsmaxmarks as fvalmax
				// from tdvs_tabulate r 
				// inner join tdvs_masqp m on r.fqpcode = m.fqpcode
				// inner join tdvs_deggrp d on m.fdeggrp = d.fdeggrp
				// inner join (select distinct fqpcode,fsubshort from subject where fdegree = '{$degcode}'
				// and fqpcode = '{$qpcode}'
				// and ifnull(fqpcode,'') <> '') s on m.fqpcode = s.fqpcode
				// inner join tdvs_tabsum t1 on r.fregcode= t1.fregcode and r.fqpcode = t1.fqpcode and t1.fvalno = '1'
				// inner join tdvs_tabsum t2 on r.fregcode = t2.fregcode and r.fqpcode = t2.fqpcode and t2.fvalno = '2'
				// left join tdvs_tabsum t3 on r.fregcode = t3.fregcode and r.fqpcode = t3.fqpcode and t3.fvalno = 'D'
				// where r.fqpcode in(select fqpcode from subject where fdegree = '{$degcode}')
				// and ifnull(r.fstatus,'') <> 'success'
				// and ifnull(r.fregno,'') <> ''
				// and ifnull(r.fregno2,'') <> ''
				// and r.fregno = r.fregno2
				// and r.fqpcode = '{$qpcode}'";

$query = "select r.fregcode,r.fqpcode,r.fregno,m.fsubname,
				if(ifnull(t3.fsysmarks,'') = '', CEILING((t2.fsysmarks+t1.fsysmarks)/2) ,
				CEILING(((t3.fsysmarks+t2.fsysmarks+t1.fsysmarks) - least(t3.fsysmarks,t2.fsysmarks,t1.fsysmarks))/2)
				) as fmarks,
				d.fexamdate,
				m.fexamno,
				s.fsubshort as fsubshort,
				s.fvalmax as fvalmax
				from tdvs_tabulate r 
				left join student st on r.fregno = st.fregno
				inner join tdvs_masqp m on r.fqpcode = m.fqpcode
				inner join tdvs_deggrp d on m.fdeggrp = d.fdeggrp
				inner join (select distinct fqpcode,fsubshort,fvalmax from subject where fdegree = '{$degcode}'
				and fqpcode = '{$qpcode}'
				and ifnull(fqpcode,'') <> ''
				group by fqpcode) s on m.fqpcode = s.fqpcode
				inner join tdvs_tabsum t1 on r.fregcode= t1.fregcode and r.fqpcode = t1.fqpcode and t1.fvalno = '1'
				and ifnull(t1.fstatus,'') = 'FINAL'
				inner join tdvs_tabsum t2 on r.fregcode = t2.fregcode and r.fqpcode = t2.fqpcode and t2.fvalno = '2'
				and ifnull(t2.fstatus,'') = 'FINAL'
				left join tdvs_tabsum t3 on r.fregcode = t3.fregcode and r.fqpcode = t3.fqpcode and t3.fvalno = 'D'
				and ifnull(t3.fstatus,'') = 'FINAL'
				where r.fqpcode in(select fqpcode from subject where fdegree = '{$degcode}')
				and ifnull(r.fstatus,'') <> 'success'
				and ifnull(r.fregno,'') <> ''
				and ifnull(r.fregno2,'') <> ''
				and r.fregno = r.fregno2
				and r.fqpcode = '{$qpcode}'
				and r.fyear = '{$year}'
				and r.fexamtype = '{$examtype}'
				having fmarks <=fvalmax";
				// var_dump($query);
				// die();
				$res1 = $aobj_context->mobj_db->getAll($query);	
			}
		
			
			$finalarry = [];
			
			$i = 0;
			$sems = array("A"=>"I", "B"=>"II","C"=>"III","D"=>"IV","E"=>"V","F"=>"VI","G"=>"VII","H"=>"VIII","I"=>"IX","J"=>"X");

foreach($res1 as $val)
			{

$fexamno = $val['fexamno'];
				$fregno = $val['fregno'];
				$fsubshort = $val['fsubshort'];
				$fexamname = $sems[$fexamno];
				$fdescpn = $val['fdescpn'];
				$fsubname = $val['fsubname'];
				$fmarks = $val['fmarks'];
				$fvalmax = $val['fvalmax'];
				$fexamdate = $val['fexamdate'];
				$subarry = [];
				
				$subarry['regno'] = $fregno;
				$subarry['sem'] = $fexamname;

$subarry['subcode'] = $fsubshort;
				$subarry['exam'] = $fexamdate;
			
				$subarry['marks'] = $fmarks;
				$subarry['maxmarks'] = $fvalmax;

array_push($finalarry,$subarry);
				$i++;
			}

$res['data'] = $finalarry;
			$res['status'] = "success";
			$msg = "success";

$resdata = $aobj_context->mobj_output->ToJSONEnvelope($res,0,$msg);

//$url = "http://45.113.248.145:8001/restApi/updatingExamCodingDecodingEntries.json?apiKey=31sdf658g3-s3p62-lk21f-a1qw9re2rt";
			$url = "https://ruasportal.msruas.ac.in/restApi/updatingExamCodingDecodingEntries.json?apiKey=7d32das2sd-3df71-6w2h9-s3hwo-a2q95lf3cp";
			$ch = curl_init();
			curl_setopt( $ch,CURLOPT_URL, $url); 
			curl_setopt( $ch,CURLOPT_POST, true );
			curl_setopt( $ch,CURLOPT_HTTPHEADER, $headers );
			curl_setopt( $ch,CURLOPT_RETURNTRANSFER, true );
			curl_setopt( $ch,CURLOPT_SSL_VERIFYPEER, false );
			curl_setopt( $ch,CURLOPT_POSTFIELDS, $resdata );
			$result2 = curl_exec($ch);
			curl_close( $ch );
			echo $result2;
			$resjuno = json_decode($result2,true);
			foreach($resjuno as $val)
			{
				$regno = $val['regno'];
				$status = $val['status'];		
				$msg = $val['msg'];
				$subcode = $val['subcode'];
			
				$query = "select fqpcode from subject 
				where fsubshort = '{$subcode}'";
				$res1 = $aobj_context->mobj_db->getRow($query);	
				$qpcode = $res1['fqpcode'];
				
				$query = "update tdvs_tabulate set fstatus = '{$status}',fmsg = '{$msg}',
				fpushdate = now()
				where fregno = '{$regno}' and fqpcode = '{$qpcode}'";
			
				$upres = $aobj_context->mobj_db->Execute($query);
				echo "regno: ".$regno." Subcode: ".$subcode." Message: ".$msg." ";
			}
		//}
	die();
}

function getStudResTDVSBluk($aobj_context)
{ 		
		
	$headers = array
	(
		"Content-Type: application/json"
	);

$degcode = ($aobj_context->mobj_data["degcode"]);
	$sem = ($aobj_context->mobj_data["sem"]);
	$qpcode = ($aobj_context->mobj_data["qpcode"]);

$cnd = "and m.fexamno = '{$sem}'";
	if($sem == 'All')
		$cnd = '';

$query = "select distinct fdegree, fqpcode 
		From subject where fqpcode in(select fqpcode 
		from tdvs_masqp where fnoval = '2')
		and fdegree like 'MDS1%'";
		$res9 = $aobj_context->mobj_db->getAll($query);

foreach($res9 as $v)
		{
			$degcode = $v['fdegree'];
			$qpcode  = $v['fqpcode'];

$query = "select if(fnoval = '','1',ifnull(fnoval,'1')) as fnoval 
			From tdvs_masqp where ifnull(fqpcode,'') = '{$qpcode}'";	
			$res2 = $aobj_context->mobj_db->getRow($query);

$query = "select r.fregcode,r.fqpcode,r.fregno,m.fsubname,
				if(ifnull(t3.fsysmarks,'') = '', CEILING((t2.fsysmarks+t1.fsysmarks)/2) ,
				CEILING(((t3.fsysmarks+t2.fsysmarks+t1.fsysmarks) - least(t3.fsysmarks,t2.fsysmarks,t1.fsysmarks))/2)
				) as fmarks,
				d.fexamdate,
				m.fexamno,
				s.fsubshort as fsubshort,
				m.fsmaxmarks as fvalmax
				from tdvs_tabulate r 
				inner join tdvs_masqp m on r.fqpcode = m.fqpcode
				inner join tdvs_deggrp d on m.fdeggrp = d.fdeggrp
				inner join (select distinct fqpcode,fsubshort from subject where fdegree = '{$degcode}'
				and fqpcode = '{$qpcode}'
				and ifnull(fqpcode,'') <> '') s on m.fqpcode = s.fqpcode
				inner join tdvs_tabsum t1 on r.fregcode= t1.fregcode and r.fqpcode = t1.fqpcode and t1.fvalno = '1'
				inner join tdvs_tabsum t2 on r.fregcode = t2.fregcode and r.fqpcode = t2.fqpcode and t2.fvalno = '2'
				left join tdvs_tabsum t3 on r.fregcode = t3.fregcode and r.fqpcode = t3.fqpcode and t3.fvalno = 'D'
				where r.fqpcode in(select fqpcode from subject where fdegree = '{$degcode}')
				and ifnull(r.fstatus,'') <> 'success'
				and ifnull(r.fregno,'') <> ''
				and ifnull(r.fregno2,'') <> ''
				and r.fregno = r.fregno2
				and r.fqpcode = '{$qpcode}'";
				
				$res1 = $aobj_context->mobj_db->getAll($query);	
			}
			
			// var_dump($query);
			// die();
			
			
			$finalarry = [];
			
			$i = 0;
			$sems = array("A"=>"I", "B"=>"II","C"=>"III","D"=>"IV","E"=>"V","F"=>"VI","G"=>"VII","H"=>"VIII","I"=>"IX","J"=>"X");

foreach($res1 as $val)
			{

$subarry['subcode'] = $fsubshort;
				$subarry['exam'] = $fexamdate;
			
				$subarry['marks'] = $fmarks;
				$subarry['maxmarks'] = $fvalmax;

array_push($finalarry,$subarry);
				$i++;
			}

$res['data'] = $finalarry;
			$res['status'] = "success";
			$msg = "success";

$resdata = $aobj_context->mobj_output->ToJSONEnvelope($res,0,$msg);

//$url = "http://45.113.248.145:8001/restApi/updatingExamCodingDecodingEntries.json?apiKey=31sdf658g3-s3p62-lk21f-a1qw9re2rt";
			$url = "https://ruasportal.msruas.ac.in/restApi/updatingExamCodingDecodingEntries.json?apiKey=7d32das2sd-3df71-6w2h9-s3hwo-a2q95lf3cp";
			$ch = curl_init();
			curl_setopt( $ch,CURLOPT_URL, $url); 
			curl_setopt( $ch,CURLOPT_POST, true );
			curl_setopt( $ch,CURLOPT_HTTPHEADER, $headers );
			curl_setopt( $ch,CURLOPT_RETURNTRANSFER, true );
			curl_setopt( $ch,CURLOPT_SSL_VERIFYPEER, false );
			curl_setopt( $ch,CURLOPT_POSTFIELDS, $resdata );
			$result2 = curl_exec($ch);
			curl_close( $ch );
			echo $result2;
			$resjuno = json_decode($result2,true);
			foreach($resjuno as $val)
			{
				$regno = $val['regno'];
				$status = $val['status'];		
				$msg = $val['msg'];
				$subcode = $val['subcode'];
			
				$query = "select fqpcode from subject 
				where fsubshort = '{$subcode}'
				and fdegree = '{$degcode}'";
				$res1 = $aobj_context->mobj_db->getRow($query);	
				$qpcode = $res1['fqpcode'];
				
				$query = "update tdvs_tabulate set fstatus = '{$status}',fmsg = '{$msg}',
				fpushdate = now()
				where fregno = '{$regno}' and fqpcode = '{$qpcode}'";
			
				$upres = $aobj_context->mobj_db->Execute($query);
				echo "regno: ".$regno." Subcode: ".$subcode." Message: ".$msg." ";
			}
		}
	die();
}

function getStudResREP($aobj_context)
{ 		
		
	$headers = array
	(
		"Content-Type: application/json"
	);

$degcode = ($aobj_context->mobj_data["degcode"]);
	$sem = ($aobj_context->mobj_data["sem"]);
	$cnd = "and m.fexamno = '{$sem}'";
	if($sem == 'All')
		$cnd = '';

$query = "select 'Even Sem Exam - May 2023' as fexamdate,m.fexamno,m.fvalmax,
	m.fsubshort,m.fregno, m.fmarks11 as fmarks 
	From tabulate_rep1 m where fregno = '18MCMS017024'";
	
	$res1 = $aobj_context->mobj_db->getAll($query);	
	
	$finalarry = [];
	
	$i = 0;
	$sems = array("A"=>"I", "B"=>"II","C"=>"III","D"=>"IV","E"=>"V","F"=>"VI","G"=>"VII","H"=>"VIII","I"=>"IX","J"=>"X");

$res['data'] = $finalarry;
	$res['status'] = "success";
	$msg = "success";

$resdata = $aobj_context->mobj_output->ToJSONEnvelope($res,0,$msg);
	//echo $resdata;

//$url = "http://45.113.248.145:8001/restApi/updatingExamCodingDecodingEntries.json?apiKey=31sdf658g3-s3p62-lk21f-a1qw9re2rt";
	$url = "https://ruasportal.msruas.ac.in/restApi/updatingExamCodingDecodingEntries.json?apiKey=7d32das2sd-3df71-6w2h9-s3hwo-a2q95lf3cp";
	$ch = curl_init();
	curl_setopt( $ch,CURLOPT_URL, $url); 
	curl_setopt( $ch,CURLOPT_POST, true );
	curl_setopt( $ch,CURLOPT_HTTPHEADER, $headers );
	curl_setopt( $ch,CURLOPT_RETURNTRANSFER, true );
	curl_setopt( $ch,CURLOPT_SSL_VERIFYPEER, false );
	curl_setopt( $ch,CURLOPT_POSTFIELDS, $resdata );
	$result2 = curl_exec($ch);
	curl_close( $ch );
	echo $result2;
	$resjuno = json_decode($result2,true);
	foreach($resjuno as $val)
	{
		$regno = $val['regno'];
		$status = $val['status'];		
		$msg = $val['msg'];
		$subcode = $val['subcode'];
	
		$query = "update tabulate_rep1 set fstatus = '{$status}',fmsg = '{$msg}',
		fpushdate = now()
		where fregno = '{$regno}' and fsubshort = '{$subcode}'";
	
		$upres = $aobj_context->mobj_db->Execute($query);
		echo "regno: ".$regno." Subcode: ".$subcode." Message: ".$msg." ";
	}
	die();

}

${this.title}

Code Editor : studentResults.php