Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
approve.php	11.58 KB	-rw-rw-r--
bank.php	4.12 KB	-rwxrwxrwx
caccesscontext.php	1.28 KB	-rwxrwxr-x
cappcontext.php	2.71 KB	-rwxrwxr-x
consultant.php	3.59 KB	-rwxrwxrwx
coutput.php	1.84 KB	-rwxrwxr-x
crequestbroker.php	2.49 KB	-rwxrwxr-x
csessions.php	548 B	-rwxrwxr-x
cuser.php	3.53 KB	-rwxrwxr-x
excelapprove.php	1.39 KB	-rw-r--r--
invoice.php	7.78 KB	-rw-rw-r--
json.php	34.52 KB	-rwxrwxr-x
login.php	8.64 KB	-rwxrwxr-x
mailService.php	1.36 KB	-rw-rw-r--
makepayment.php	13.06 KB	-rwxrwxrwx
mregistry.php	3.86 KB	-rwxrwxr-x
searchpms.php	3.54 KB	-rw-r--r--
supplier.php	4.14 KB	-rwxrwxrwx
uploadexcel.php	20.49 KB	-rw-r--r--
users.php	3.9 KB	-rwxrwxrwx
verify.php	7.57 KB	-rw-rw-r--

Code Editor : excelapprove.php

<?php

function getexcelapprove($aobj_context)
{ 
	session_start();
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);

$getstatusapp =  $aobj_context->mobj_data["getstatusapp"];

if($getstatusapp == ''){
		$cnd = "and i.FCHKSTATUS = 'Verified' and i.FAPPSTATUS <> 'Approved'";
	}elseif($getstatusapp == 'Pending'){
		$cnd = "and i.FCHKSTATUS = 'Pending'";
	}elseif($getstatusapp == 'Verified'){
		$cnd = "and i.FCHKSTATUS = 'Verified'";
	}elseif($getstatusapp == 'Approved'){
		$cnd = "and i.FAPPSTATUS = 'Approved'";
	}elseif($getstatusapp == 'All'){
		$cnd = '';
	}else{
		$cnd = "and i.FAPPSTATUS = 'Approved' and fbatchno <> ''";
	}
	
  $query = "select i.FVOUNO, date_format(i.FVOUDATE,'%d/%m/%Y') as FVOUDATE, i.FSUPCODE, s.FSUPNAME, i.FINVNO,
  date_format(i.FINVDATE,'%d/%m/%Y') as FINVDATE,i.FTPAYABLE, ifnull(i.FCHKSTATUS,'') as FCHKSTATUS,i.FAPAYABLE,
  ifnull(i.FAPPSTATUS,'') as FAPPSTATUS,ifnull(i.fbatchno,'') as fbatchno
  from pms_payhead i inner join pms_massup s on i.FSUPCODE = s.FSUPCODE
  where ifnull(i.FDELETED,'') <> 'T' and fuploadtype = 'EXL'
  ORDER BY i.FVOUNO DESC, i.FAPPSTATUS";
	// var_dump($query);
	$res = $aobj_context->mobj_db->GetAll($query);

if($res)
	{
    
    echo $aobj_context->mobj_output->ToJSONEnvelope($res,0,"success");
    return;	
	}else
	{
		$data='No Invoice Deatils Found';
		echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"Failure");
		return;
	}
}

${this.title}

Code Editor : excelapprove.php