Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
phpmailer	[ DIR ]	drwxrwxrwx
.htaccess	602 B	-rwxrwxrwx
appForm.php	14.61 KB	-rwxrwxrwx
applicationFormReportPOSTOFFIC...	19.27 KB	-rwxrwxrwx
applicationStatus.php	4.49 KB	-rwxrwxrwx
applicationStatus_31012018.php	2.94 KB	-rwxrwxrwx
cManualMailer.php	1.52 KB	-rwxrwxrwx
caccesscontext.php	1.24 KB	-rwxrwxrwx
candidate_list.php	54.71 KB	-rwxrwxrwx
cappcontext.php	2.66 KB	-rwxrwxrwx
cmailer.php	6.83 KB	-rwxrwxrwx
code39.php	6.38 KB	-rwxrwxrwx
coutput.php	1.75 KB	-rwxrwxrwx
crequestbroker.php	2.49 KB	-rwxrwxrwx
csessions.php	514 B	-rwxrwxrwx
cuser.php	3.41 KB	-rwxrwxrwx
customappcontext.php	2.35 KB	-rwxrwxrwx
dropdown.php	844 B	-rwxrwxrwx
feehead.php	1.51 KB	-rwxrwxrwx
format.php	7.43 KB	-rwxrwxrwx
fpdf_protection.php	5.61 KB	-rwxrwxrwx
getdata.php	1.06 KB	-rwxrwxrwx
getnumword.php	7.15 KB	-rwxrwxrwx
home.html	14.48 KB	-rwxrwxrwx
json.php	33.22 KB	-rwxrwxrwx
login.php	1.76 KB	-rwxrwxrwx
mregistry.php	2.92 KB	-rwxrwxrwx
mregistry_31012018.php	2.65 KB	-rwxrwxrwx
report_appstatus.php	5.91 KB	-rwxrwxrwx
reportapplicationform - Copy.p...	19.59 KB	-rwxrwxrwx
reportapplicationform.php	23.92 KB	-rwxrwxrwx
rotation.php	596 B	-rwxrwxrwx
servfee.php	1.38 KB	-rwxrwxrwx
servicedet.php	1.6 KB	-rwxrwxrwx
stringspliter.php	693 B	-rwxrwxrwx
student.php	24.46 KB	-rwxrwxrwx

Code Editor : applicationStatus_31012018.php

<?php

function getApplicationDetails($aobj_context)
{
	//var_dump($aobj_context);
	$status = trim($aobj_context->mobj_data["status"]);
	$fromdate = trim($aobj_context->mobj_data["fromdate"]);
	$todate = trim($aobj_context->mobj_data["todate"]);
	$fromroll = trim($aobj_context->mobj_data["fromroll"]);
	$toroll = trim($aobj_context->mobj_data["toroll"]);
	$servcode = trim($aobj_context->mobj_data["servcode"]);
	$paystatus = trim($aobj_context->mobj_data["paystatus"]);

$lstrserv = "and st.fservcode='$servcode'";
	if($servcode=="all")
	$lstrserv="";
	
	$lstrstatus = "and st.fverifystatus='$status'";
	if($status=="all")
	$lstrstatus="";
	
	$lstrpaystatus = "and st.fpaystatus='$paystatus'";
	if($paystatus == "all")
	$lstrpaystatus = "";

$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$query = "SELECT st.fappno,DATE_FORMAT(fappdate,'%d/%m/%Y') AS fappdate, st.fregno, st.fname, st.fcategory, st.ftotal, st.fpaystatus, 
	s.fservname, st.fverifystatus, DATE_FORMAT(st.fverifydate,'%d/%m/%Y') as fverifydate FROM servtran st INNER JOIN servtype s ON 
	s.fservcode =  st.fservcode
	WHERE st.fappdate BETWEEN DATE_FORMAT(str_to_date('{$fromdate}','%d/%m/%Y'),'%Y-%m-%d') 
	AND DATE_FORMAT(str_to_date('{$todate}','%d/%m/%Y'),'%Y-%m-%d') 
	AND st.fregno BETWEEN '$fromroll' AND '$toroll' {$lstrserv} {$lstrstatus} 
	{$lstrpaystatus} order by st.fappno, st.fregno";
	//var_dump($query);
	$result = $aobj_context->mobj_db->GetAll($query);
	$i=1;
	//$table .= "<tbody id="trecords">"; 	
	foreach($result as $key => $value)
	{
		$table.="<tr style='cursor:pointer;' id='tr$value[fappno]'>";
		
		$table.="<td>
				<span><center>{$i}</center></span>
				</td>";
		$table.="<td id='appno' onclick='loadStudDet($value[fappno])'>
				{$value['fappno']}
				</td>";
		$table.="<td id='appno' onclick='loadStudDet($value[fappno])'>
				{$value['fappdate']}
				</td>";
		$table.="<td onclick='loadStudDet($value[fappno])'>
				{$value['fregno']}
				</td>";
		$table.="<td onclick='loadStudDet($value[fappno])'>
				{$value['fname']}
				</td>";
		$table.="<td onclick='loadStudDet($value[fappno])'>
				{$value['fcategory']}
				</td>";

$table.="<td onclick='loadStudDet($value[fappno])'>
				{$value['fservname']}
				</td>";
		$table.="<td onclick='loadStudDet($value[fappno])'>
				<span style='float : right;'>{$value['ftotal']}</span>
				</td>";
		$table.="<td id='$value[fappno]' onclick='loadStudDet($value[fappno])'>
				{$value['fverifystatus']}
				</td>";
		$table.="<td id='date$value[fappno]' onclick='loadStudDet($value[fappno])'>
				{$value['fverifydate']}
				</td>";
		$table.="<td>
				<span class='btn btn-primary waves-effect' onclick='printMailAdd($value[fappno])'>Cov. Lett.</span>
				</td>";
		$table.="</tr>";
		$i++;
	}
	//$table .= "</tbody>";

if($result)
	{
		$arr['table'] = $table;
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success");	
		return; 
	}else
	{
		$arr = '';
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failur");	
		return; 
	}

}

${this.title}

Code Editor : applicationStatus_31012018.php