Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
ApplicationFeeSummary.php	10.14 KB	-rwxr-xr-x
ApplicationReport.php	9.8 KB	-rwxr-xr-x
Applicationfeereport.php	8.56 KB	-rwxr-xr-x
Collegewise_SeatAllotedList.ph...	11.13 KB	-rwxr-xr-x
Degreewise_SeatAllotedList.php	11.34 KB	-rwxr-xr-x
SeatMatrixReport.php	24.02 KB	-rwxr-xr-x
admconfirmation.php	4.43 KB	-rwxr-xr-x
admissionfeedetails.php	1.56 KB	-rw-rw-r--
admissionfeereport.php	11.59 KB	-rw-rw-r--
admissionstatusreport.php	12.62 KB	-rwxr-xr-x
applicationview.php	9.5 KB	-rwxr-xr-x
collegedegree.php	1.92 KB	-rwxr-xr-x
collegedetails.php	1.96 KB	-rwxr-xr-x
create-stud_login.php	4.09 KB	-rwxr-xr-x
create-user.php	4.17 KB	-rwxr-xr-x
documentverification.php	4.91 KB	-rwxr-xr-x
dudseatallot.php	4.11 KB	-rw-rw-r--
meritlist.php	3.22 KB	-rwxr-xr-x
report_merit_list.php	6.82 KB	-rwxr-xr-x
report_rcub_merit_list.php	12.77 KB	-rwxr-xr-x
reportadm_admission_ticket.php	13.73 KB	-rwxr-xr-x
rostertable.php	490 B	-rwxr-xr-x
saveApplication.php	19.01 KB	-rwxr-xr-x
seatmatrix.php	8.53 KB	-rwxr-xr-x
signin.php	849 B	-rwxr-xr-x

Code Editor : meritlist.php

<?php
function loaddegree($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);  
	//var_dump($_SESSION['fusertype']);

if($_SESSION['USERNAME'] == NULL || $_SESSION['USERNAME'] == '')
	{
		$arr = "Please login";
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"error"); 
		return;
	}
	
	$query = "select * from entmasuser where fusername = '{$_SESSION['USERNAME']}'";
	$res = $aobj_context->mobj_db->GetRow($query);
	$fdegree = $res['fdegree'];
	//var_dump($query);
	$cond = "";
	if($_SESSION['fusertype'] == 'user')
	{
		$cnd = "where INSTR ('{$fdegree}', concat(fdegree,'*'))";
	}else
	{
		$cnd = "";
	}

$query1 = "select fdegree, fdescpn from entdeg {$cnd} order by forder";
  	$result1 = $aobj_context->mobj_db->GetAll($query1);
  
	if(count($result1) > 0)
	{	
		echo $aobj_context->mobj_output->ToJSONEnvelope($result1,0,"success"); 
	}	
	else
	{	
		$arr = "Some Failure as occured";
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"error"); 
	}
}

function UpdMeritList($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);  
	$degree = stripslashes($aobj_context->mobj_data["degree"]);

if($_SESSION['USERNAME'] == NULL || $_SESSION['USERNAME'] == '')
	{
		$arr = "Please login";
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"error"); 
		return;
	}

$query = "select count(*) as cnt from entoptdeg d
	inner join entstudadm s on d.fappno = s.fappno
	where d.fdegree = '{$degree}' 
	and ifnull(fpaystatus,'') = 'success'
	and ifnull(s.ffreez,'') <> 'T'
	and (ifnull(d.fstatus,'') = ''
	or ifnull(d.fmerittype,'') = '')";
	$res = $aobj_context->mobj_db->GetRow($query);
	
	if($res['cnt']>0)
	{
		$arr = "All applications are not verified.";
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"error"); 
		return;
	}
	$query = "update entoptdeg set frank = NULL where fdegree = '{$degree}'";
	$res = $aobj_context->mobj_db->Execute($query);

$query = "select fmeritopt from entdeg where fdegree = '{$degree}'";
	$res = $aobj_context->mobj_db->GetRow($query);
	$fmeritopt = $res['fmeritopt'];

if($fmeritopt == 'T')
	{
		$order = "order by d.fmerittype,d.foptper desc,d.ftotper desc,s.fdob desc";
	}
	else
	{
		$order = "order by d.fmerittype,d.ftotper desc,d.foptper desc,s.fdob desc";
	}
	
	$query = "select d.fappno,d.fdegree,d.ftotper, d.fmerittype from entoptdeg d
	inner join entstudadm s on d.fappno = s.fappno
	where d.fdegree = '{$degree}' 
	and ifnull(fpaystatus,'') = 'success'
	and ifnull(d.fstatus,'') = 'Approved'
	and ifnull(s.ffreez,'') <> 'T'
	and ifnull(d.fmerittype,'') <> ''
	{$order}";
	
	$res = $aobj_context->mobj_db->GetAll($query);
	$i=001;
	$o = $res[0]['fmerittype'];
	$n = "";
	foreach($res as $value)
	{
		$n = $value['fmerittype'];
		if($o != $n) {
			$i = 001;
			$o = $value['fmerittype'];	
		}
		$updquery = "update entoptdeg set frank = '{$i}',
		frankdate = now()
		where fappno = '{$value['fappno']}'
		and fdegree = '{$value['fdegree']}'";
		$rst1 = $aobj_context->mobj_db->Execute($updquery);
		$i++;
	}

if($rst1)
	{
		$arr = "Generated Successfully.";
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
		return;
	}else{
		$arr = "Some Failure as occured";
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"error"); 
		return;
	}
}

${this.title}

Code Editor : meritlist.php