Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
abcolleges.php	2.25 KB	-rwxr-xr-x
changeStudyCentre.php	3.84 KB	-rwxr-xr-x
connection.php	680 B	-rwxr-xr-x
createUser.php	1.1 KB	-rwxr-xr-x
dashboard.php	2.11 KB	-rwxr-xr-x
database.php	294 B	-rwxr-xr-x
examapp.php	3.19 KB	-rwxr-xr-x
examapp_iframe.php	280 B	-rwxr-xr-x
getapprapps.php	2.56 KB	-rwxr-xr-x
getassignapps.php	2.05 KB	-rwxr-xr-x
getautofill.php	738 B	-rwxr-xr-x
getgapstudent.php	1.92 KB	-rwxr-xr-x
getgapstudent_22062018.php	1.89 KB	-rwxr-xr-x
login.php	326 B	-rwxr-xr-x
logout.php	155 B	-rwxr-xr-x
pgRedirect.php	2.73 KB	-rwxr-xr-x
profile.php	629 B	-rwxr-xr-x
report_admission_ticket.php	46.94 KB	-rwxr-xr-x
results.php	640 B	-rwxr-xr-x
saveapps.php	541 B	-rwxr-xr-x
savestuddet.php	1.58 KB	-rwxr-xr-x
savestuddet_23072018.php	1.58 KB	-rwxr-xr-x
studdet.php	2.85 KB	-rwxr-xr-x

Code Editor : getapprapps.php

<?php
ini_set('memory_limit','900M');
ini_set('max_execution_time',0);
include ("database.php");

$fromdeg = $_POST['fromdeg'];
$todeg = $_POST['todeg'];
$fromcoll = $_POST['fromcoll'];
$tocoll = $_POST['tocoll'];
$fromapp = $_POST['fromapp'];
$toapp = $_POST['toapp'];
$year = $_POST['year'];
$strAprtype = $_POST['pAprtype'];

if($strAprtype == 'APPROVED')
	$aprCondition = "and sa.fapprstatus = 'APPROVED'";
else if($strAprtype == 'PENDING')
	$aprCondition = "and (sa.fapprstatus = 'PENDING' or sa.fapprstatus is null)";
else
	$aprCondition = "";

if($_SESSION['USERTYPE'] == 'usr')
{
	$usr_condition = "and sa.fapprusername = '{$_SESSION['USER']}'";
}
else
{
	$usr_condition = "";
}

$lentry_cond = ")";

if($year == 'L')
{
	$year = 'A';
	$lentry_cond = "or sa.fexamno in ('B', 'C')) and FLATERAL_ENTRY = 'T'";
}

$get_app_query = "select fappno, fappno,ifnull(faregno,'') as faregno,
	ifnull(DATE_FORMAT(fcreatedate, '%d/%m/%Y'), '02/03/2018') as applied_date,
	ifnull(sa.fphotopath,'') as fphotopath,
	fname, fcollcode, 
	dg.fdescpn as degree,   
	if(ifnull(sa.fpaymenttype,'') = 'DEBIT/CREDIT/NET BANKING', 
	'PAYTM', ifnull(sa.fpaymenttype,'')) 
	as fpaymenttype, ifnull(sa.ftotfee,'') as ftotfee, 
	ifnull(dg.fadmfee,'') as fadmfee, 
	ifnull(sa.fapprstatus,'PENDING') as status, fappno
	from studadm sa 
	inner join degree dg 
	on sa.fdegree = dg.fdegree 
	and sa.fexamno = dg.fexamno
	where sa.fdegree between '{$fromdeg}' and '{$todeg}'
	and sa.fcollcode between '{$fromcoll}' and '{$tocoll}'
	and sa.fappno between '{$fromapp}' and '{$toapp}'
	and (sa.fexamno = '{$year}' {$lentry_cond} {$usr_condition} {$aprCondition} 
	and IFNULL(fpaymenttype,'') NOT IN ('undefined', 'null') 
	order by fcreatedate desc";
 //var_dump($get_app_query);
$result = mysqli_query($conn, $get_app_query);
$i=0;
$count = mysqli_num_rows($result);
if($count > 0)
{
	while($app = mysqli_fetch_array($result,MYSQLI_NUM)) 
	{
		if($year == 'A')
			$app[4] = "http://oasis.logisys.org/kusdde/adm2018/".$app[4];
		else
			$app[4] = "http://oasis.logisys.org/kusdde/".$app[4];
		$apps[$i] = $app;
		/*if($i == 20)
			break;*/
		$i++;
	}
	$row['apps'] = $apps;
	$row['query'] = $get_app_query;
	$row['status'] = 'success';

$get_usr_query = "select fusername from masuser where fusertype = 'usr'";
	$result = mysqli_query($conn,$get_usr_query);

while($usr = mysqli_fetch_array($result,MYSQLI_ASSOC)) 
	{
		$users[$i++] = $usr['fusername'];
		$i++;
	}

$row['users'] = $users;
}
else
{
	$row['msg'] = "No Applications Found";
	$row['status'] = 'error';
}
echo json_encode($row);
//select fappno, fname, fdegree, fexamno from studadm

${this.title}

Code Editor : getapprapps.php