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

<?php

function getRoomAllotmentData($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,'S','RA', t.fqpcode ,y.fsubshort,  
	if(ifnull(z.froomname,'') = '',
	ifnull(x.FHALLNO,''),ifnull(z.froomname,'')) as roomname,
	w.FDESCPN as session,
	t.fdoe as doe,
	concat(t.fqpcode,' - ',y.fsubname) as subname,
	concat('Dear Student, you have been alloted to room no. : ',
	if(ifnull(z.froomname,'') = '',
	ifnull(x.FHALLNO,''),ifnull(z.froomname,'')), ' for the QP Code ',
	concat(t.fqpcode,' - ',left(y.fsubname,20)),' on ',
	date_format(t.fdoe,'%d/%m/%Y'),' (',w.FDESCPN,').') as fmessage,
	'F', 'F', 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 masroom z on cs.fcntrcode = z.fcollcode 
	and x.FHALLNO = z.froomno
	left join reason w on t.FSESSION = w.FREASONCD
	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}%' and ifnull(x.fhallno,'') <> ''";
		$res9 = $aobj_context->mobj_db->getAll($query);

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

$res['regno'] = $val['fregno'];
				$res['qpcode'] = $val['fqpcode'];

$res['roomname'] = $val['roomname'];
				$res['session'] = $val['session'];
				$res['doe'] = $val['doe'];
				$res['subname'] = $val['subname'];
				
				$res['msg'] = $val['fmessage'];
				$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 : eRoomAllotmentData.php