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

<?php

function saveConsultant($aobj_context)
{

$FSUPCODE =  stripcslashes($aobj_context->mobj_data["FSUPCODE"]);
	$FSUPNAME =  stripcslashes($aobj_context->mobj_data["FSUPNAME"]);
	$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"]);
	$FGSTNO =  stripcslashes($aobj_context->mobj_data["FGSTNO"]);
	$FPANNO =  stripcslashes($aobj_context->mobj_data["FPANNO"]);
	$FACNO =  stripcslashes($aobj_context->mobj_data["FACNO"]);
	$FBANK =  stripcslashes($aobj_context->mobj_data["FBANK"]);
	$FIFSCCODE =  stripcslashes($aobj_context->mobj_data["FIFSCCODE"]);
	$FTDSPER =  stripcslashes($aobj_context->mobj_data["FTDSPER"]);
	$FCRPERIOD =  stripcslashes($aobj_context->mobj_data["FCRPERIOD"]);
	
	
		$query = "INSERT IGNORE INTO pms_massup (FSUPCODE,FSUPNAME,FCONTACT,FPHONE,FMOBILE,
        FEMAIL,FGSTNO,FPANNO,FACNO,FBANK,FIFSCCODE,FTDSPER,FCRPERIOD,FCREADATE,FMODDATE,FTYPE)
		VALUES
		('{$FSUPCODE}','{$FSUPNAME}','{$FCONTACT}','{$FPHONE}','{$FMOBILE}',
        '{$FEMAIL}','{$FGSTNO}','{$FPANNO}','{$FACNO}','{$FBANK}','{$FIFSCCODE}',
        '{$FTDSPER}','{$FCRPERIOD}',now(),now(),'C')
        ON DUPLICATE KEY UPDATE FMODDATE=now(), FCONTACT='{$FCONTACT}', FPHONE='{$FPHONE}', FMOBILE='{$FMOBILE}',
        FEMAIL='{$FEMAIL}',FGSTNO='{$FGSTNO}', FPANNO='{$FPANNO}', FACNO='{$FACNO}', FBANK='{$FBANK}', 
        FIFSCCODE='{$FIFSCCODE}', FTDSPER='{$FTDSPER}', FCRPERIOD='{$FCRPERIOD}'";
        // 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 loadconsultantlist($aobj_context)
{ 
	session_start();
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	
  $query = "SELECT FSUPCODE,FSUPNAME,FCONTACT,FPHONE,FMOBILE,FEMAIL,FGSTNO,FPANNO,FACNO,FBANK,
  FIFSCCODE,FTDSPER,FCRPERIOD,DATE_FORMAT(FCREADATE,'%d/%m/%Y') AS FCREADATE,
  DATE_FORMAT(FMODDATE,'%d/%m/%Y') AS FMODDATE,FTYPE, IFNULL(FDELETED,'F') as FDELETED
  FROM pms_massup WHERE FTYPE = 'C'
  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 editConsultant($aobj_context)
{ 
	session_start();
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
    $id =  stripcslashes($aobj_context->mobj_data["id"]);
	
  $query = "SELECT FSUPCODE,FSUPNAME,FCONTACT,FPHONE,FMOBILE,FEMAIL,FGSTNO,FPANNO,FACNO,FBANK,
  FIFSCCODE,FTDSPER,FCRPERIOD,DATE_FORMAT(FCREADATE,'%d/%m/%Y') AS FCREADATE,
  DATE_FORMAT(FMODDATE,'%d/%m/%Y') AS FMODDATE,FTYPE, FDELETED
  FROM pms_massup where FSUPCODE = '{$id}' ";
	$res = $aobj_context->mobj_db->GetRow($query);

${this.title}

Code Editor : consultant.php