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

<?php

function saveBank($aobj_context)
{

$FBANKCODE =  stripcslashes($aobj_context->mobj_data["FBANKCODE"]);
	$FBANKNAME =  stripcslashes($aobj_context->mobj_data["FBANKNAME"]);
	$FBRANCH =  stripcslashes($aobj_context->mobj_data["FBRANCH"]);
	$FCONTACT =  stripcslashes($aobj_context->mobj_data["FCONTACT"]);
	$FPHONE =  stripcslashes($aobj_context->mobj_data["FPHONE"]);
	$FMOBILE =  stripcslashes($aobj_context->mobj_data["FMOBILE"]);
	$FEMAIL =  stripcslashes($aobj_context->mobj_data["FEMAIL"]);
	$FADDR1 =  stripcslashes($aobj_context->mobj_data["FADDR1"]);
	$FADDR2 =  stripcslashes($aobj_context->mobj_data["FADDR2"]);
	$FADDR3 =  stripcslashes($aobj_context->mobj_data["FADDR3"]);
	$FADDR4 =  stripcslashes($aobj_context->mobj_data["FADDR4"]);
	$FACNO =  stripcslashes($aobj_context->mobj_data["FACNO"]);
	$FIFSCCODE =  stripcslashes($aobj_context->mobj_data["FIFSCCODE"]);	
	
	
		$query = "INSERT IGNORE INTO pms_masbank (FBANKCODE,FBANKNAME,FCONTACT,FPHONE,
        FMOBILE,FEMAIL,FADDR1,FADDR2,FADDR3,FADDR4,FACNO,FIFSCCODE,
        FCREADATE,FMODDATE,FBRANCH)
		VALUES
		('{$FBANKCODE}','{$FBANKNAME}','{$FCONTACT}','{$FPHONE}','{$FMOBILE}','{$FEMAIL}',
        '{$FADDR1}','{$FADDR2}','{$FADDR3}','{$FADDR4}','{$FACNO}','{$FIFSCCODE}',now(),now(),'{$FBRANCH}')
        ON DUPLICATE KEY UPDATE FMODDATE=now(), FCONTACT = '{$FCONTACT}',FPHONE = '{$FPHONE}',
        FMOBILE = '{$FMOBILE}',FEMAIL = '{$FEMAIL}',FADDR1 = '{$FADDR1}',FADDR2 = '{$FADDR2}',
        FADDR3 = '{$FADDR3}',FADDR4 = '{$FADDR4}',FACNO = '{$FACNO}',FIFSCCODE = '{$FIFSCCODE}',FBRANCH = '{$FBRANCH}'";
        // var_dump($query);

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

if($res)
	{
		$data = "Updated 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;
	}
}

function loadbanklist($aobj_context)
{ 
	session_start();
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	
  $query = "SELECT FBANKCODE,CONCAT(FBANKNAME,', ',fbranch) AS FBANKNAME,FBRANCH, FCONTACT,FPHONE,
  FMOBILE,FEMAIL,FADDR1,FADDR2,FADDR3,FADDR4,FACNO,FIFSCCODE,DATE_FORMAT(FCREADATE,'%d/%m/%Y') AS FCREADATE,
  DATE_FORMAT(FMODDATE,'%d/%m/%Y') AS FMODDATE, FDELETED
  FROM pms_masbank
  ORDER BY FCREADATE DESC";
	$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 Supplier Deatils Found';
		echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"Failure");
		return;
	}
}

function editBank($aobj_context)
{ 
	session_start();
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
    $id =  stripcslashes($aobj_context->mobj_data["id"]);
	
  $query = "SELECT FBANKCODE,FBANKNAME,FBRANCH, FCONTACT,FPHONE,
  FMOBILE,FEMAIL,FADDR1,FADDR2,FADDR3,FADDR4,FACNO,FIFSCCODE,DATE_FORMAT(FCREADATE,'%d/%m/%Y') AS FCREADATE,
  DATE_FORMAT(FMODDATE,'%d/%m/%Y') AS FMODDATE, FDELETED
  FROM pms_masbank where FBANKCODE = '{$id}' ";
	$res = $aobj_context->mobj_db->GetRow($query);

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

function checkbankcode($aobj_context)
{ 
	session_start();
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
  $supcode =  stripcslashes($aobj_context->mobj_data["supcode"]);
	
  $query = "select * from pms_masbank where fbankcode = '{$supcode}'";
	$res = $aobj_context->mobj_db->GetRow($query);

if(!$res)
	{
    $data='ret';
    echo $aobj_context->mobj_output->ToJSONEnvelope($res,-1,"Failure");
    return;	
	}else
	{
		$data='Bank Code already present..!';
		echo $aobj_context->mobj_output->ToJSONEnvelope($data,0,"success");
		return;
	}
}

${this.title}

Code Editor : bank.php