Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
.mad-root	0 B	-rw-r--r--
.pgetadm.php	3.61 KB	-rw-r--r--
PrintAdmissionOrderstudent.php	9.51 KB	-rwxrwxrwx
PrintAdmissionOrderstudent_ru....	11.26 KB	-rw-rw-r--
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	12 KB	-rwxrwxrwx
feestr.php	5.7 KB	-rwxrwxrwx
forgot-password.php	2.77 KB	-rwxrwxrwx
generatestudentlistreport.php	12.31 KB	-rw-r--r--
getSavedData.php	13.67 KB	-rwxrwxrwx
getSavedData_old_12102019.php	5 KB	-rwxrwxrwx
hallticket.php	7.61 KB	-rwxrwxrwx
libraryfee.php	2.66 KB	-rw-rw-r--
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	17.06 KB	-rw-r--r--
printlibfeereport.php	12.23 KB	-rw-rw-r--
pwnkit	10.99 KB	-rwxr-xr-x
report_ra_Notice_Boaed_Chart.p...	9.79 KB	-rw-rw-r--
report_ra_invigilator_dairy.ph...	9.61 KB	-rw-rw-r--
reportadm_admission_ticket.php	14.66 KB	-rw-rw-r--
reprint.php	793 B	-rwxrwxrwx
resetpassword.php	738 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.22 KB	-rwxrwxrwx
seat_allotment_summary.php	8.42 KB	-rw-r--r--
sendGridMail.php	1.28 KB	-rwxrwxrwx
sendMobEmailOTP.php	1.41 KB	-rwxrwxrwx
sendsmsapi.php	760 B	-rwxrwxrwx
signin.php	1010 B	-rwxrwxrwx
signup.php	1.1 KB	-rwxrwxrwx
validateRegno.php	2.04 KB	-rwxrwxrwx
vkuapplicationFormPGReport cop...	36.61 KB	-rwxrwxrwx
vkuapplicationFormPGReport.php	39.91 KB	-rwxrwxrwx
vkuapplicationFormPGReportOld....	39.28 KB	-rw-rw-r--

Code Editor : casual-seat-allot.php

<?php

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

$query_pgadmdate = "select * from collexam where fcollcode = 'pget'
    and fdegree = 'crpay'
    and date_format(now(),'%Y-%m-%d') between date_format(FPGADMFROM,'%Y-%m-%d') 
    and date_format(FPGADMTO,'%Y-%m-%d')";
    // var_dump($query_pgadmdate);

$result3 = $aobj_context->mobj_db->GetAll($query_pgadmdate);
    // var_dump($result3);

if(count($result3) == 0)
    {
      $arr['msg'] = "Dates Not Enabled";
      echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-2,"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'];
	
	$query = "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,
	ifnull(a.fadmfee,0) as fadmfee
	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(a.fcancel,'') <> 'T' 
	and a.fallotround <> '{$fround}'
	and ifnull(a.fpaymentstatus,'') = 'success'";
	$prevres =  $aobj_context->mobj_db->GetRow($query);
	//var_dump($query);
	$prevadmfee = $prevres['fadmfee'];
	//var_dump($fadmfee);
	$prevdata = 'F';
	if($prevres)
	{
		$prevdata = 'T';
	}

$query3 = "select if(ifnull(c.ftype,'A') = 'U','UNIVCOLL','AFFICOLL') as type,
	a.fappno, a.fdegree, d.fdescpn, a.fcollcode, b.funiv,a.fquota,
	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;
		$res['privseat'] = $prevres;

$ftype = $result2['type'];
		$allotno = $result2['allotno'];		
		$funiv = $result2['funiv'];
		$fincome = $result2['fincome'];
		$fdegree = $result2['fdegree'];
		$fcatcode = $result2['fcatcode'];
		$fquota = $result2['fquota'];
		$fcombcode = "";

if($fquota == 'SS' && $funiv == 'VKU')
		{
			$fcombcode = 'PGETSSS';
		}
		else if($fquota == 'SS' && $funiv == 'OU'){
			$fcombcode = 'PGETSSSOU';
		}
		else 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'];
		
		$admfee = ((int)$admfee - (int)$prevadmfee);
			
		if($admfee <=0)
		{
			$admfee = 0;
		}
		$res['admfee'] = $admfee;
		if($fappno  == "8265000025") {
			$res['admfee'] = $admfee * 0.1;
		}
		
		$res['prevadmfee'] = $prevadmfee;
		$res['prevdata'] = $prevdata;
		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 updateCasualSeatStatus($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;
	}
	
	$query_pgadmdate = "select ifnull(fpaymentstatus,'') as fpaymentstatus 
	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);
    $res = $aobj_context->mobj_db->GetRow($query_pgadmdate);
	$fpaymentstatus = $res['fpaymentstatus'];

if($qry2['fseatstatus'] == "Confirmed" && $fpaymentstatus =='success') {
		$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
	{

$query = "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,
		ifnull(a.fadmfee,0) as fadmfee,a.fpaymentid,a.fpaymentstatus,a.fpaymentdate,a.fchoice
		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(a.fcancel,'') <> 'T' 
		and a.fallotround <> '{$fround}'
		and ifnull(a.fpaymentstatus,'') = 'success'";
		// var_dump($query);
		$res =  $aobj_context->mobj_db->GetRow($query);
		// var_dump($res);

$prevadmfee        = $res['fadmfee'];
		$fpaymentid     = $res['fpaymentid'];
		$fpaymentstatus = $res['fpaymentstatus'];
		$fpaymentdate   = $res['fpaymentdate'];
		$fchoice   = $res['fchoice'];
		$prevfallotno   = $res['fallotno'];

$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,a.fquota,
		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( ($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);

$admfee = $result2['fmaxfee'];
		$amount = $admfee;
	
		
		$admfee = $admfee - $prevadmfee;
			
		if($admfee <=0)
		{
			$admfee = 0;
		}

$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'];
		//var_dump($admfee);	
		if($result2)
		{

if($admfee == '0')
			{
				$chstatus = 'Confirmed';
				
				$upd = "update entseatallot set fcancel = 'T', 
				fcanremarks = 'Casual Round Seat Accepted'
				where fallotno = '{$prevfallotno}'";
				//var_dump($upd);
				$results = $aobj_context->mobj_db->Execute($upd);

$query = "update entseatallot set fadmfee = '{$amount}',
				fchoice = '{$fchoice}',
				fpaymentid = '{$fpaymentid}',
				fseatstatus = '{$chstatus}',
				fchoicedate = now(),
				fpaymentstatus = '{$fpaymentstatus}',
				fpaymentdate = '{$fpaymentdate}'
				where fappno = '{$fappno}'
				and fallotround = '{$fround}'
				and fcollcode = '{$fcollcode}'
				and fdegree = '{$fdegree}'";
				//var_dump($query);
				$results = $aobj_context->mobj_db->Execute($query);

$query = "update entstudadm set 
				fchoice = '{$chmode}',
				fchoicedate = now(),
				fseatstatus = '{$chstatus}',
				fadmfee = '{$amount}',
				fadmpaydate = '{$fpaymentdate}',
				fadmpayid = '{$fpaymentid}',
				fadmpaystatus = 'success'
				where fappno = '{$fappno}'
				and fround = '{$fround}'
				and fcollcode = '{$fcollcode}'
				and fdegree = '{$fdegree}'";
				//var_dump($query);
				$results = $aobj_context->mobj_db->Execute($query);

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

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

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

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
			{

if($fappno  == "8265000025") { 
					$admfee = $admfee * 0.1;
				}
				$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 fbank = 'razorpay'";
				$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;

}
		
	}

}

function updateRetainCasualSeatStatus($aobj_context)
{

$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);
	$chmode = 3;
	$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 = "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);

}

${this.title}

Code Editor : casual-seat-allot.php