📄 add.php

📁 泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。

💻 PHP

字号:

<?php

include_once( "inc/auth.php" );
include_once( "inc/check_type.php" );
echo "\r\n<html>\r\n<head>\r\n<title>增加客户 </title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n</head>\r\n\r\n<body class=\"bodycolor\">\r\n";
$connection = openconnection( );
$query = "select * from CUSTOMER where CUSTOMER_NAME='".$_REQUEST['CUSTOMER_NAME']."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	message( "错误", "客户 ".$_REQUEST['CUSTOMER_NAME']." 已存在" );
	echo "<br>\r\n<div align=\"center\">\r\n <input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"location='new.php?CUSTOMER_NAME=";
	echo $CUSTOMER_NAME;
	echo "&TEL_NO=";
	echo $TEL_NO;
	echo "&FAX_NO=";
	echo $FAX_NO;
	echo "&CUSTOMER_WWW=";
	echo $CUSTOMER_WWW;
	echo "&EMAIL=";
	echo $EMAIL;
	echo "&address=";
	echo $_REQUEST['address'];
	echo "&POSTALCODE=";
	echo $POSTALCODE;
	echo "&MEMO=";
	echo $MEMO;
	echo "&customer_no=";
	echo $_REQUEST['customer_no'];
	echo "&door_type=";
	echo $_REQUEST['door_type'];
	echo "&scale=";
	echo $_REQUEST['scale'];
	echo "&province=";
	echo $_REQUEST['province'];
	echo "&cityid=";
	echo $_REQUEST['cityid'];
	echo "&purview=";
	echo $_REQUEST['purview'];
	echo "'\">\r\n</div>\r\n";
	exit( );
}
$query = "INSERT into CUSTOMER(CUSTOMER_NAME,TEL_NO,FAX_NO,CUSTOMER_WWW,EMAIL,CUSTOMER_ADD,POSTALCODE,MEMO,MANAGE_USER, CUSTOMER_NUMBER,CUSTOMER_TYPE,SCALE,PROVINCE,CITY,PURVIEW,PURVIEW_DEPT,PURVIEW_ROLE,PURVIEW_USER,CREATEOR)values('{$CUSTOMER_NAME}','{$TEL_NO}','{$FAX_NO}','{$CUSTOMER_WWW}','{$EMAIL}','".$_REQUEST['address']."','{$POSTALCODE}','{$MEMO}','{$MANAGE_USER}','".$_REQUEST['customer_no']."',".$_REQUEST['door_type'].",".$_REQUEST['scale'].",'".$_REQUEST['province']."','".$_REQUEST['cityid']."',".$_REQUEST['purview'].",'".$_REQUEST['TO_ID']."','".$_REQUEST['USER_PRIV_ID']."','".$_REQUEST['COPY_TO_ID']."','".$_SESSION['LOGIN_USER_ID']."')";
exequery( $connection, $query );
header( "location: ../linkman/new.php?CUSTOMER_NAME=".$_REQUEST['CUSTOMER_NAME']."&new_customer=new_customer" );
echo "</body>\r\n</html>";
?>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -