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

<?php

function getThtimetable($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;
	}

$regno = $data['regno'];
	
	if($regno == '')
	{
		$arry='Kindly Send USN No.';
		echo $aobj_context->mobj_output->ToJSONEnvelope($arry,-1,"Failure");
		return;
	}

$resrayy = [];
	$error = 0;
	$succes = 0;
	
	$query = "select cd.fregno, dg.fexamname, cd.fexamno, st.fname,
		concat(cd.fdegree,' - ',dg.fdescpn) as fdegree, cd.fexamtype, 
		concat(dg.fexamdate, '') as fexamdate, cd.fyear, 
		su.fqpcode, su.fsubname, su.fsubshort,
		if(ifnull(t.fdoe,'0000-00-00') = '0000-00-00','-',concat(date_format(t.fdoe,'%d/%m/%Y'),' [',dayname(t.fdoe),']')) as fdoe, 
		if(ifnull(t.fsession,'') = '','-',re.fdescpn) as fdescpn,
		'' as centre 
		from canddet cd inner join subject su on cd.fdegree = su.fdegree and cd.fexamno = su.fexamno
		and cd.fsubcode = su.fsubcode and ifnull(su.fqpcode,'') <> '' 
		inner join degree dg on cd.fdegree = dg.fdegree and cd.fexamno = dg.fexamno
		inner join student st on cd.fregno =st.fregno
		inner join candsum cs on cd.fcollcode = cs.fcollcode and cd.fregno = cs.fregno
		and cs.fyear = cd.fyear and cs.fexamtype = cd.fexamtype
		inner join timetable t on su.fqpcode = t.fqpcode 
		and t.fyear and cs.fyear and t.fexamtype = cs.fexamtype and ifnull(cd.fbatch,'1') = t.fbatch
		left join reason re on t.fsession = re.freasoncd
		where cd.fregno = '{$regno}' and ifnull(cd.fpassmth,'') = '' 
		#and INSTR(cs.fhtenable,cd.fexamno) >0
		and ifnull(cd.fpresent,'') = 'P' 
		and ifnull(cd.fthpr,'') <> 'T'
		and ifnull(t.fdoe,'') <> ''
		and su.ftheory = 'T'";
		$res9 = $aobj_context->mobj_db->getAll($query);

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

$res['regno'] = $val['fregno'];
				$res['sem'] = $val['fexamname'];
				$res['examdate'] = $val['fexamdate'];
				$res['subshort'] = $val['fsubshort'];
				$res['qpcode'] = $val['fqpcode'];
				$res['fsubname'] = $val['fsubname'];
				$res['doe'] = $val['fdoe'];
				$res['session'] = $val['fdescpn'];
				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 : eThTimetable.php