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 : approve.php

<?php

function loadapproveinvoice($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' {$cnd}
	ORDER BY i.FVOUNO DESC, i.FAPPSTATUS;";
	// var_dump($query);
	$res = $aobj_context->mobj_db->GetAll($query);

if($res)
	{
    $data='You have already registered, Please Login';
    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;
	}
}

function savechkapproved($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$dtt =  $aobj_context->mobj_data["dtt"];
	
	$dtt = json_decode($dtt, true);

foreach($dtt as $k => $v ){
		// var_dump($v['vid']);
		$query = "UPDATE pms_payhead SET 
		FAPPBY = '{$_SESSION['FUSERNAME']}' ,
		FAPPDATE = now(),
		FAPPSTATUS = 'approved' 
		WHERE fvouno = '{$v['vid']}'";

$res = $aobj_context->mobj_db->Execute($query);
	}

if($res){
		$data='Approved invoice Successfully..!';
		echo $aobj_context->mobj_output->ToJSONEnvelope($data,0,"success");
		return;

}else{
		$data='Updation Failed..!';
		echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"Failure");
		return;

}

}
function editApprove($aobj_context)
{
	$id =  stripcslashes($aobj_context->mobj_data["id"]);
	$query = "select p.FSUPCODE,s.FSUPNAME, p.FVOUDATE,p.FVOUNO,p.FINVNO,p.FINVDATE,p.FDESCPN,p.FRECDDATE,
	p.FBASIC,p.FSGST, p.FCGST, p.FINVVAL,p.FTDSPER,p.FTDSAMT,p.FAPAYABLE,p.FCREDIT,p.FCRREM,p.FDEBIT,
	p.FDBREM,p.FAPAYABLE,ifnull(p.FPATH,'') as FPATH,ifnull(p.FAPPSTATUS,'') as FAPPSTATUS, ifnull(p.FAPPREMARKS,'') as FAPPREMARKS,
	ifnull(p.FCHKSTATUS,'') as FCHKSTATUS
	from pms_payhead p inner join 
	pms_massup s on s.FSUPCODE = p.FSUPCODE
	where ifnull(p.FDELETED,'') <> 'T'
	and FVOUNO = '{$id}'";
	$res = $aobj_context->mobj_db->GetRow($query);

if($res)
	{
    echo $aobj_context->mobj_output->ToJSONEnvelope($res,0,"success");
    return;	
	}else
	{
		$data='Invalid Supplier Code';
		echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"Failure");
		return;
	}
}

function saveApprove($aobj_context)
{

$seucode =  stripcslashes($aobj_context->mobj_data["seucode"]);
	$voucherdate =  stripcslashes($aobj_context->mobj_data["voucherdate"]);
	$invno =  stripcslashes($aobj_context->mobj_data["invno"]);
	$invdate =  stripcslashes($aobj_context->mobj_data["invdate"]);
	$invrecdate =  stripcslashes($aobj_context->mobj_data["invrecdate"]);
	$invdesc =  stripcslashes($aobj_context->mobj_data["invdesc"]);
	$basic =  stripcslashes($aobj_context->mobj_data["basic"]);
	$sgst =  stripcslashes($aobj_context->mobj_data["sgst"]);
	$cgst =  stripcslashes($aobj_context->mobj_data["cgst"]);
	$tdsper =  stripcslashes($aobj_context->mobj_data["tdsper"]);
	$tdsamount =  stripcslashes($aobj_context->mobj_data["tdsamount"]);
	$payable =  stripcslashes($aobj_context->mobj_data["payable"]);
	$credit =  stripcslashes($aobj_context->mobj_data["credit"]);
	$creditrem =  stripcslashes($aobj_context->mobj_data["creditrem"]);
	$rebitrem =  stripcslashes($aobj_context->mobj_data["rebitrem"]);
	$debit =  stripcslashes($aobj_context->mobj_data["debit"]);
	$totpayable =  stripcslashes($aobj_context->mobj_data["totpayable"]);
	$path =  stripcslashes($aobj_context->mobj_data["path"]);
	$total =  stripcslashes($aobj_context->mobj_data["total"]);
	$voucherid =  stripcslashes($aobj_context->mobj_data["voucherid"]);
	$approve_select =  stripcslashes($aobj_context->mobj_data["approve_select"]);
	$approve_text =  stripcslashes($aobj_context->mobj_data["approve_text"]);
	
	if($voucherid == '')
	{
		$query = "INSERT INTO pms_payhead (FVOUDATE, FSUPCODE, FINVNO, FINVDATE, FDESCPN, FRECDDATE, FBASIC, 
		FSGST, FCGST, FINVVAL, FCREDIT, FCRREM, FDEBIT, FDBREM, FTPAYABLE, FTDSPER, FTDSAMT, FAPAYABLE,FCREADATE)
		VALUES
		(date_format(STR_TO_DATE('{$voucherdate}','%Y-%m-%d'),'%Y-%m-%d'), '{$seucode}', '{$invno}',date_format(STR_TO_DATE('{$invdate}','%Y-%m-%d'),'%Y-%m-%d'), '{$invdesc}', date_format(STR_TO_DATE('{$invrecdate}','%Y-%m-%d'),'%Y-%m-%d'), 
		'{$basic}', '{$sgst}', '{$cgst}', '{$total}', '{$credit}', '{$creditrem}', '{$debit}', '{$rebitrem}', 
		'{$payable}', '{$tdsper}', '{$tdsamount}','{$totpayable}', now())";

$res = $aobj_context->mobj_db->Execute($query);
		$last_id = $aobj_context->mobj_db->Insert_ID();

if($path != '')
		{
				$cert_path = $aobj_context->main_src."/invoice";
				$GCCERT_PATH = $aobj_context->main_src.'/upload/'.$path;
				$filename = explode(".", $GCCERT_PATH);
				$ext = strtolower($filename[1]);
				$new_filename = $last_id.".".$ext;
				$new_path = $cert_path."/".$new_filename;
			if(copy($path,$new_path))
			{
				$path_name = "invoice/".$new_filename;
				$update = "update pms_payhead set FPATH = '{$path_name}' 
				where FVOUNO = '{$last_id}'";	
				$lobj_insert= $aobj_context->mobj_db->Execute($update);
				unlink($path);
			}
		}

}else
	{

$query = "update pms_payhead set FVOUDATE = date_format(STR_TO_DATE('{$voucherdate}','%Y-%m-%d'),'%Y-%m-%d'),
		FSUPCODE = '{$seucode}',
		FINVNO = '{$invno}',
		FINVDATE = date_format(STR_TO_DATE('{$invdate}','%Y-%m-%d'),'%Y-%m-%d'),
		FDESCPN ='{$invdesc}',
		FRECDDATE = date_format(STR_TO_DATE('{$invrecdate}','%Y-%m-%d'),'%Y-%m-%d'),
		FBASIC = '{$basic}',
		FSGST = '{$sgst}',
		FCGST = '{$cgst}',
		FINVVAL = '{$total}',
		FCREDIT = '{$credit}',
		FCRREM = '{$creditrem}',
		FDEBIT = '{$debit}',
		FDBREM = '{$rebitrem}',
		FTPAYABLE = '{$payable}',
		FTDSPER = '{$tdsper}',
		FTDSAMT = '{$tdsamount}',
		FAPAYABLE = '{$totpayable}',
		FMODDATE = now(),
		FAPPSTATUS = '{$approve_select}',
		FAPPREMARKS = '{$approve_text}'
		where FVOUNO = '{$voucherid}'";
		$res = $aobj_context->mobj_db->Execute($query);
		$last_id = $voucherid; 
		
		if($path != '')
		{
				$cert_path = $aobj_context->main_src."/invoice";
				$GCCERT_PATH = $aobj_context->main_src.'/upload/'.$path;
				$filename = explode(".", $GCCERT_PATH);
				$ext = strtolower($filename[1]);
				$new_filename = $last_id.".".$ext;
				$new_path = $cert_path."/".$new_filename;
			if(copy($path,$new_path))
			{
				$path_name = "invoice/".$new_filename;
				$update = "update pms_payhead set FPATH = '{$path_name}' 
				where FVOUNO = '{$voucherid}'";	
				$lobj_insert= $aobj_context->mobj_db->Execute($update);
				unlink($path);
			}
		}

}	
	
	if($res)
	{
		$data = "Approved invoice Successfully";
    echo $aobj_context->mobj_output->ToJSONEnvelope($data,0,"success");
    return;	
	}else
	{
		$data='Error while saveing!';
		echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"Failure");
		return;
	}
}

////////////////////////update on 04/10/2021//////////////////

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

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

// var_dump($getstatusapp, $radio);
	// die();

if($getstatusapp == 'All' && $radio == 'All' ){
		$cnd = '';
	}elseif($getstatusapp == 'All' && $radio == 'SEL'){
		$cnd = "and i.FAPPSTATUS = 'Approved'";

}elseif($getstatusapp == 'All' && $radio == 'UNSEL'){
		$cnd = "and i.FAPPSTATUS <> 'Approved'";

}elseif($getstatusapp == 'EXUP' && $radio == 'All'){
		$cnd = "and fuploadtype = 'EXL'";

}elseif($getstatusapp == 'EXUP' && $radio == 'SEL'){
		$cnd = "and fuploadtype = 'EXL' and i.FAPPSTATUS = 'Approved'";

}elseif($getstatusapp == 'EXUP' && $radio == 'UNSEL'){
		$cnd = "and fuploadtype = 'EXL' and i.FAPPSTATUS <> 'Approved'";

}elseif($getstatusapp == 'DTET' && $radio == 'All'){
		$cnd = "and ifnull(fuploadtype,'') <> 'EXL'";

}elseif($getstatusapp == 'DTET' && $radio == 'SEL'){
		$cnd = "and ifnull(fuploadtype,'') <> 'EXL' and i.FAPPSTATUS = 'Approved'";

}elseif($getstatusapp == 'DTET' && $radio == 'UNSEL'){
		$cnd = "and ifnull(fuploadtype,'') <> 'EXL' and i.FAPPSTATUS <> 'Approved'";

}

// 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,ifnull(fuploadtype,'') as fuploadtype
  from pms_payhead i inner join pms_massup s on i.FSUPCODE = s.FSUPCODE
  where ifnull(i.FDELETED,'') <> 'T' 	{$cnd}
  ORDER BY i.FVOUNO DESC, i.FAPPSTATUS;";
	// var_dump($query);
	$res = $aobj_context->mobj_db->GetAll($query);

function savebulkapprove($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$dttrue =  $aobj_context->mobj_data["dttrue"];
	$dttfalse =  $aobj_context->mobj_data["dttfalse"];
	//  var_dump($dttrue);
	
	$dttrue = json_decode($dttrue, true);
	$dttfalse = json_decode($dttfalse, true);

// var_dump($dttrue);
	// die();
	
	if(count($dttrue) > 0){
	foreach($dttrue as $k => $v ){
		// var_dump($v);
		$query = "UPDATE pms_payhead SET 
		FAPPBY = '{$_SESSION['FUSERNAME']}' ,
		FAPPDATE = now(),
		FAPPSTATUS = 'Approved' 
		WHERE fvouno = '{$v}'";
		
		// var_dump($query);

$res = $aobj_context->mobj_db->Execute($query);
	}
}
	
	
	if(count($dttfalse) > 0){
		foreach($dttfalse as $k => $v ){
			
			$query = "UPDATE pms_payhead SET 
			FAPPBY = '{$_SESSION['FUSERNAME']}' ,
			FAPPDATE = now(),
			FAPPSTATUS = '' 
			WHERE fvouno = '{$v}'";
			// var_dump($query);
			
			
	
			$resfalse = $aobj_context->mobj_db->Execute($query);
		}

}

if($res || count($dttrue) == 0){
		$data='Approved invoice Successfully..!';
		echo $aobj_context->mobj_output->ToJSONEnvelope($data,0,"success");
		return;

}else{
		$data='Updation Failed..!';
		echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"Failure");
		return;

}

${this.title}

Code Editor : approve.php