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.64 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	5.15 KB	-rw-rw-r--
studentia.php	4.94 KB	-rw-rw-r--
studentprofile.php	6.87 KB	-rw-rw-r--
studentsubject.php	5.15 KB	-rw-rw-r--

Code Editor : attendaceSEE.php

<?php

function getattendaceSEEData($aobj_context)
{ 
	$data_json = file_get_contents("php://input");
	$data = json_decode($data_json,true);
    
	if($_SERVER['PHP_AUTH_USER'] == 'revaapiuser' && $_SERVER['PHP_AUTH_PW'] == 'reva@124')
	{

}else
	{
		$arry='Unauthorized User';
		echo $aobj_context->mobj_output->ToJSONEnvelope($arry,-1,"Failure");
		return;
	}

if(count($data) <=0)	
	{
		$arry='Kindaly Pass Data';
		echo $aobj_context->mobj_output->ToJSONEnvelope($arry,-1,"Failure");
		return;
	}

$edate = $data['edate'];
	$esession = $data['esession'];
	
	if($edate == '')
	{
		$arry='Kindly Send Exam Date';
		echo $aobj_context->mobj_output->ToJSONEnvelope($arry,-1,"Failure");
		return;
	}

if($esession == '')
	{
		$arry='Kindly Send Exam Session';
		echo $aobj_context->mobj_output->ToJSONEnvelope($arry,-1,"Failure");
		return;
	}

$resrayy = [];
	$error = 0;
	$succes = 0;
	
	$query = "select distinct '030', x.fregno,t.fqpcode , y.fsubshort,y.fsubname,
	if(ifnull(z.fregno,'') = '',if(ifnull(z1.fregno,'') = '','PR','MP'),'AB') as fstatus,
				x.fyear, x.fexamtype,now(),d.fexamdate
				from canddet x inner join subject y
				on  x.fdegree = y.fdegree and x.fexamno = y.fexamno and x.fsubcode = y.fsubcode 
				inner join degree d on x.fdegree = d.fdegree and x.fexamno = d.fexamno
				inner join candsum cs on cs.fcollcode = x.fcollcode
				inner join timetable t on y.fqpcode = t.fqpcode
				and x.fbatch = t.fbatch
				and cs.fdegree = x.fdegree and cs.fregno = x.fregno
				and ifnull(cs.frecptdate,'')<>''
				left join absent z on cs.fcntrcode = z.fcollcode and x.fregno = z.fregno
				and t.fqpcode = z.fqpcode and z.fyear = cs.fyear and z.fexamtype = cs.fexamtype
				and z.FABSTYPE = 'QpA'
				left join absent z1 on cs.fcntrcode = z1.fcollcode and x.fregno = z1.fregno
				and t.fqpcode = z1.fqpcode and z1.fyear = cs.fyear and z1.fexamtype = cs.fexamtype
				and z1.FABSTYPE = 'QpM'
				where ifnull(x.fpresent,'') = 'p' and ifnull(x.fpassmth,'') = ''
				and date_format('{$edate}','%Y-%m-%d') = date_format(t.fdoe,'%Y-%m-%d')
				and ifnull(t.FSESSION,'') like '$esession%' limit 1";
		$res9 = $aobj_context->mobj_db->getAll($query);

if($res9)
		{
			foreach($res9 as $val)
			{

$res['regno'] = $val['fregno'];
				$res['qpcode'] = $val['fqpcode'];
				$res['status'] = $val['fstatus'];
				$res['subshort'] = $val['fsubshort'];
				array_push($resrayy,$res);
			}
			$msg = "success";
			$arry['resdata'] = $resrayy;
			echo $aobj_context->mobj_output->ToJSONEnvelope($arry,0,$msg);
			return;
		}else
		{
			$arry='time table not available';
			echo $aobj_context->mobj_output->ToJSONEnvelope($arry,-1,"Failure");
			return;
		}
}

${this.title}

Code Editor : attendaceSEE.php