Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
.pgetadm.php	3.61 KB	-rw-r--r--
PrintAdmissionOrderstudent.php	9.51 KB	-rwxrwxrwx
PrintAdmissionOrderstudent_ru....	11.26 KB	-rwxrwxrwx
acuapplicationFormPGReport.php	26.02 KB	-rwxr-xr-x
add-course.php	5.63 KB	-rwxrwxrwx
admissionorderPGReport.php	15.91 KB	-rwxrwxrwx
admissionordertest.php	356 B	-rwxrwxrwx
app-status.php	2.87 KB	-rwxrwxrwx
applicationFormPGReport.php	43.11 KB	-rwxrwxrwx
bcuapplicationFormPGReport.php	50.46 KB	-rwxrwxrwx
cancelSeat.php	4.51 KB	-rwxrwxrwx
casual-seat-allot.php	16.88 KB	-rwxrwxrwx
category.php	2.95 KB	-rwxrwxrwx
data.json	1.98 KB	-rwxrwxrwx
degree.php	11.73 KB	-rwxrwxrwx
feestr.php	5.7 KB	-rwxrwxrwx
forgot-password.php	2.77 KB	-rwxrwxrwx
generatestudentlistreport.php	11.34 KB	-rwxrwxrwx
getSavedData.php	13.67 KB	-rwxrwxrwx
getSavedData_old_12102019.php	5 KB	-rwxrwxrwx
hallticket.php	7.61 KB	-rwxrwxrwx
leaddetmail.php	2.09 KB	-rwxr-xr-x
login.php	1.21 KB	-rwxrwxrwx
logout.php	44 B	-rwxrwxrwx
option-entry-cr.php	4.76 KB	-rwxrwxrwx
option-entry.php	9.11 KB	-rwxrwxrwx
option-entryPrint.php	9.34 KB	-rwxrwxrwx
printadmissionorder.php	1.38 KB	-rwxrwxrwx
printhostelfeereport.php	11.84 KB	-rwxrwxrwx
report_ra_Notice_Boaed_Chart.p...	9.79 KB	-rwxrwxrwx
report_ra_invigilator_dairy.ph...	9.61 KB	-rwxrwxrwx
reportadm_admission_ticket.php	14.66 KB	-rwxrwxrwx
reprint.php	707 B	-rwxrwxrwx
resetpassword.php	783 B	-rwxrwxrwx
saveApplication.php	24.33 KB	-rwxrwxrwx
saveApplication_BACKUP_15072.p...	48.01 KB	-rwxrwxrwx
saveApplication_BASE_15072.php	23.61 KB	-rwxrwxrwx
saveApplication_LOCAL_15072.ph...	24.27 KB	-rwxrwxrwx
saveApplication_REMOTE_15072.p...	23.67 KB	-rwxrwxrwx
saveApplication_old_12102019.p...	14.67 KB	-rwxrwxrwx
seat-allot.php	9.18 KB	-rwxrwxrwx
seat_allotment_summary.php	8.42 KB	-rwxrwxrwx
sendGridMail.php	1.47 KB	-rwxrwxrwx
sendMobEmailOTP.php	1.41 KB	-rwxrwxrwx
sendsmsapi.php	760 B	-rwxrwxrwx
signin.php	1.24 KB	-rwxrwxrwx
signup.php	1.21 KB	-rwxrwxrwx
validateRegno.php	3.12 KB	-rwxrwxrwx
vkuapplicationFormPGReport cop...	36.61 KB	-rwxrwxrwx
vkuapplicationFormPGReport.php	24.17 KB	-rwxrwxrwx
vkuapplicationFormPGReportOld....	39.28 KB	-rwxrwxrwx

Code Editor : seat-allot.php

<?php

function getSeatAllotDet($aobj_context) 
{
	session_start();
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	// var_dump($_SESSION['MOBILE']);
	if(!isset($_SESSION['MOBILE'])){
		$arr['msg'] = 'Session Expired!!! Login again.';
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
		return;
	}

$query2 = "select ifnull(fappno,'') as fappno, fround as fround 
	from entstudadm 
	where fmobileno = '{$_SESSION['MOBILE']}'";
	$qry2 =  $aobj_context->mobj_db->GetRow($query2);
	$fappno = $qry2['fappno'];
	$fround = $qry2['fround'];
	
	
	$query3 = "select if(ifnull(c.ftype,'A') = 'U','UNIVCOLL','AFFICOLL') as type,
	a.fappno, a.fdegree, d.fdescpn, a.fcollcode, b.funiv,
	c.fcollname, a.frank, b.fcategory_ver as fcatcode, ifnull(fincome_ver,'-') as fincome,
	b.fname,a.freserve, a.fallotround,ifnull(a.fseatstatus,'-') as fseatstatus, a.fallotno
	from entseatallot a inner join entstudadm b
	on a.fappno = b.fappno
	inner join entdeg d on a.fdegree = d.fdegree 
	inner join entcoll c on a.fcollcode = c.fcollcode
	where a.fappno = '{$fappno}' and ifnull(fcancel,'') <> 'T' 
	and a.fallotround = '{$fround}'";
	// var_dump($query3);
	$result2 = $aobj_context->mobj_db->GetRow($query3);
	  
	if(count($result2) > 0) {
		$res['seat'] = $result2;

$ftype = $result2['type'];
		$allotno = $result2['allotno'];		
		$funiv = $result2['funiv'];
		$fincome = $result2['fincome'];
		$fdegree = $result2['fdegree'];
		$fcatcode = $result2['fcatcode'];
		$fcombcode = "";
		if($funiv == 'VKU')
		{
			$fcombcode = 'PGETADM';
		}
		else
		{
			$fcombcode = 'PGETSOU';
		}

if( ($fcatcode == "SC" || $fcatcode == "ST" || $fcatcode == "CAT-I") && $fincome > 250000) {
			$fcatcode = "GM";
		}
		if( ($fcatcode == "IIA" || $fcatcode == "IIB" || $fcatcode == "IIIA" || $fcatcode == "IIIB") && $fincome > 100000) {
			$fcatcode = "GM";
		}

$query = "select fmaxfee from admfeestr 
		where fdegree = '{$fdegree}'
		and fcombcode = '{$fcombcode}'
		and fconstype = '{$ftype}'
		and fcatcode = '{$fcatcode}'";
		//var_dump($query);
		$result2 = $aobj_context->mobj_db->GetRow($query);
		$res['admfee'] = $result2['fmaxfee'];
		echo $aobj_context->mobj_output->ToJSONEnvelope($res,0,"success"); 
	}
	else {
		$arr['msg'] = 'Seat allotment details not available.';
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
	}
	return;

}

function updateSeatStatus($aobj_context) 
{
	session_start();
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$chmode = $aobj_context->mobj_data["chmode"];

// var_dump($result3);

$query2 = "select ifnull(fappno,'') as fappno,
	fround, funiv, fdegree,fcollcode, fcategory_ver as fcatcode, 
	ifnull(fseatstatus,'-') as fseatstatus from entstudadm 
	where fmobileno = '{$_SESSION['MOBILE']}'";
	// var_dump($query2);
	$qry2 =  $aobj_context->mobj_db->GetRow($query2);
	$fappno = $qry2['fappno'];
	$fround = $qry2['fround'];
	$funiv = $qry2['funiv'];
	$fdegree = $qry2['fdegree'];
	$fcollcode = $qry2['fcollcode'];
	$fcatcode = $qry2['fcatcode'];

$query_pgadmdate = "select * from entseatallot where fappno = '{$fappno}' 
	and fallotround = '{$fround}'
    and date_format(now(),'%Y-%m-%d') <= date_format(fpaydate,'%Y-%m-%d')";
    // var_dump($query_pgadmdate);

$result3 = $aobj_context->mobj_db->GetAll($query_pgadmdate);
	
	if(count($result3) == 0)
    {
      $arr['msg'] = "Admission fee payment is disabled.";
      echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-2,"Failure"); 
      return;
    }

if($qry2['fseatstatus'] == "Confirmed") {
		$arr['msg'] = 'Seat status is confirmed.';
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
		return;
	}

if($chmode != '1')	
	{
		$arr['msg'] = 'Only Choice 1 is allowed.';
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
		return;
	}

if($chmode == '3')	
	{
		$query = "update entseatallot set 
		fchoice = '{$chmode}',
		fchoicedate = now(),
		fseatstatus = 'Cancelled' 
		where fappno = '{$fappno}'
		and fallotround = '{$fround}'
		and fcollcode = '{$fcollcode}'
		and fdegree = '{$fdegree}'";
		$results1 = $aobj_context->mobj_db->Execute($query);

$query = "update entstudadm set 
		fchoice = '{$chmode}',
		fchoicedate = now(),
		fseatstatus = 'Cancelled' 
		where fappno = '{$fappno}'
		and fround = '{$fround}'
		and fcollcode = '{$fcollcode}'
		and fdegree = '{$fdegree}'";
		
		$results2 = $aobj_context->mobj_db->Execute($query);

$query = "update entoptions set 
		fchoice = '{$chmode}',
		fchoicedate = now(),
		fseatstatus = 'Cancelled' 
		where fappno = '{$fappno}'
		and fround = '{$fround}'
		and fcollcode = '{$fcollcode}'
		and fdegree = '{$fdegree}'";
		
		$results3 = $aobj_context->mobj_db->Execute($query);

$query = "update entoptdeg set 
		fchoice = '{$chmode}',
		fchoicedate = now(),
		fseatstatus = 'Cancelled' 
		where fappno = '{$fappno}'
		and fround = '{$fround}'
		and fcollcode = '{$fcollcode}'
		and fdegree = '{$fdegree}'";
		
		$results4 = $aobj_context->mobj_db->Execute($query);

$query = "INSERT INTO `entseatlog` (`fappno`, `fdegree`, `fcollcode`, `frank`, `fallotno`, `fallotround`, `fseatstatus`, `fchoice`, `fchoicedate`)
		select `fappno`, `fdegree`, `fcollcode`, `frank`,`fallotno`, `fallotround`,
		 'Cancelled', '{$chmode}', now() from entseatallot
		 where fappno = '{$fappno}'
		and fallotround = '{$fround}'
		and fcollcode = '{$fcollcode}'
		and fdegree = '{$fdegree}'";
		$results5 = $aobj_context->mobj_db->Execute($query);

if($results1 && $results2 && $results5)
		{
			$res['msg'] = "Updated successfully.";
			$res['chmode'] = $chmode;
			echo $aobj_context->mobj_output->ToJSONEnvelope($res,0,"success"); 
			return;
		}else
		{
			$arr['msg'] = 'Updation failed Please try later.';
			echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
			return;
		}

}else
	{

$query3 = "select if(ifnull(c.ftype,'A') = 'U','UNIVCOLL','AFFICOLL') as type
		from entcoll c
		where fcollcode = '{$fcollcode}'";
		$result2 = $aobj_context->mobj_db->GetRow($query3);
		$ftype = $result2['type'];

$query3 = "select if(ifnull(c.ftype,'A') = 'U','UNIVCOLL','AFFICOLL') as type,
		a.fappno, a.fdegree, d.fdescpn, a.fcollcode, b.funiv,
		c.fcollname, a.frank, b.fcategory_ver as fcatcode, ifnull(fincome_ver,'-') as fincome,
		b.fname,a.freserve, a.fallotround,ifnull(a.fseatstatus,'-') as fseatstatus, a.fallotno
		from entseatallot a inner join entstudadm b
		on a.fappno = b.fappno
		inner join entdeg d on a.fdegree = d.fdegree 
		inner join entcoll c on a.fcollcode = c.fcollcode
		where a.fappno = '{$fappno}'
		and a.fallotround = '{$fround}'";
		//var_dump($query3);
		$result2 = $aobj_context->mobj_db->GetRow($query3);

// if($funiv == 'VKU')
		// {
		// 	$fcombcode = 'PGETADM';
		// }else
		// {
		// 	$fcombcode = 'PGETSOU';
		// }
		// if( ($fcatcode == "SC" || $fcatcode == "ST" || $fcatcode == "CAT-I") && $fincome > 250000) {
		// 	$fcatcode = "GM";
		// }
		// if( ($fcatcode == "IIA" || $fcatcode == "IIB" || $fcatcode == "IIIA" || $fcatcode == "IIIB") && $fincome > 100000) {
		// 	$fcatcode = "GM";
		// }

// $query = "select fmaxfee from admfeestr 
		// where fdegree = '{$fdegree}'
		// and fcombcode = '{$fcombcode}'
		// and fconstype = '{$ftype}'
		// and fcatcode = '{$fcatcode}'";
		
		// $result2 = $aobj_context->mobj_db->GetRow($query);
		$admfee = $result2['fmaxfee'];

$query3 = "select  fallotno as allotno
		from entseatallot
		where fappno = '{$fappno}'
		and fallotround = '{$fround}'
		and fcollcode = '{$fcollcode}'
		and fdegree = '{$fdegree}'";
		$result2 = $aobj_context->mobj_db->GetRow($query3);
		$allotno = $result2['allotno'];
			
		if($result2)
		{
			$query = "update entseatallot set fadmfee = '{$admfee}',
			fchoice = '{$chmode}'
			where fappno = '{$fappno}'
			and fallotround = '{$fround}'
			and fcollcode = '{$fcollcode}'
			and fdegree = '{$fdegree}'";
			//var_dump($query);
			$results = $aobj_context->mobj_db->Execute($query);

$query = "select * from masbank where ifnull(fsuspend,'') <> 'T'";
      		$respayment = $aobj_context->mobj_db->GetAll($query);

$res['masbank'] = $respayment;

if($results)
			{
				$res['msg'] = "Updated successfully.";
				$res['chmode'] = $chmode;
				$res['fee'] = $admfee;
				$res['appno'] = $allotno;

echo $aobj_context->mobj_output->ToJSONEnvelope($res,0,"success"); 
				return;
			}else
			{
				$arr['msg'] = 'Updation failed Please try later.';
				echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
				return;
			}

}
		
	}

}

${this.title}

Code Editor : seat-allot.php