Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
.admin-src.php	3.61 KB	-rw-r--r--
ApplicationFeeSummary.php	10.25 KB	-rwxrwxrwx
ApplicationReport.php	9.96 KB	-rwxrwxrwx
Applicationfeereport.php	9.13 KB	-rwxrwxrwx
Collegewise_SeatAllotedList.ph...	11.13 KB	-rwxrwxrwx
Degreewise_SeatAllotedList.php	11.28 KB	-rwxrwxrwx
PrintDocumentVerification.php	23.98 KB	-rwxrwxrwx
SeatMatrixReport.php	24.02 KB	-rwxrwxrwx
admconfirmation.php	4.43 KB	-rwxrwxrwx
admissionMeritListExcel.php	11.08 KB	-rwxrwxrwx
admissionstatusreport.php	12.62 KB	-rwxrwxrwx
admorder_ru.php	4.53 KB	-rw-rw-r--
applicationFormReportBank.php	11.82 KB	-rw-rw-r--
applicationview.php	4.39 KB	-rwxrwxrwx
bnuAdmissionMeritListExcel.php	12.07 KB	-rwxrwxrwx
bnuAdmissionMeritListExcel_161...	11.88 KB	-rwxrwxrwx
changepasswordadmin.php	1.12 KB	-rwxrwxrwx
collegedegree.php	1.92 KB	-rwxrwxrwx
collegedetails.php	2.49 KB	-rwxrwxrwx
create-user.php	4.96 KB	-rwxrwxrwx
documentverification.php	8.75 KB	-rwxrwxrwx
dudseatallot.php	14.5 KB	-rw-rw-r--
editapp.php	1.38 KB	-rw-rw-r--
getAdmOrderDet.php	1.53 KB	-rw-r--r--
getnumword.php	9.1 KB	-rw-rw-r--
meritlist.php	6.41 KB	-rwxrwxrwx
presealallot.php	7.58 KB	-rw-rw-r--
provisionsellist.php	692 B	-rw-rw-r--
provisionsellistReport.php	13.57 KB	-rw-rw-r--
provisionsellistReport1.php	11.76 KB	-rw-rw-r--
provisionsellistReport1Downloa...	12.84 KB	-rw-rw-r--
provisionsellistReportDownload...	15 KB	-rw-rw-r--
report_merit_list.php	6.82 KB	-rwxrwxrwx
rostertable.php	490 B	-rwxrwxrwx
saveApplication.php	20.67 KB	-rwxrwxrwx
savevacantseats.php	2.57 KB	-rw-rw-r--
seatmatrix.php	8.53 KB	-rwxrwxrwx
signin.php	848 B	-rwxrwxrwx
viewpresealallot2.php	8.05 KB	-rw-rw-r--

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 masuser 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;
	}
}

if($res)
	{
		$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