add.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 77 行
PHP
77 行
<?
include_once 'inc/auth.php';
include_once 'inc/check_type.php';
include_once 'inc/utility_all.php';
echo '
<html>
<head>
<title>增加客户 </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor">
';
$CUR_DATE = date ('Y-m-d', time ());
if (($ATTACHMENT_NAME != ''))
{
$ATTACHMENT_ID = upload ($ATTACHMENT, $ATTACHMENT_NAME);
$ATTACHMENT_ID = (($ATTACHMENT_ID_OLD.$ATTACHMENT_ID).',');
$ATTACHMENT_NAME = (($ATTACHMENT_NAME_OLD.$ATTACHMENT_NAME).'*');
}
else
{
$ATTACHMENT_ID = $ATTACHMENT_ID_OLD;
$ATTACHMENT_NAME = $ATTACHMENT_NAME_OLD;
}
if (($CUSTOMER_ID == ''))
{
$query = (((''.'select * from CUSTOMER where CUSTOMER_NAME=\'').$CUSTOMER_NAME).'\'');
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
message ('错误', (('客户 '.$CUSTOMER_NAME).' 已存在'));
echo '
<br>
<div align="center">
<input type="button" value="返回" class="BigButton" onClick="location=\'index.php\'">
</div>
';
exit ();
}
}
if (($CUSTOMER_ID == ''))
{
$query = (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((''.'INSERT into CUSTOMER(CUSTOMER_NAME,CUSTOMER_SHORT,CUSTOMER_CODE,TEL_NO,FAX_NO,CUSTOMER_WWW,EMAIL,CUSTOMER_AREA,CUSTOMER_ADD,POSTALCODE,MEMO,SELLER,SHARE,SHAREUSER,SOURCE,KIND,SELLMODE,ATTRIBUTE,ENTERTYPE,ENTERMEMO,MEMO1,CREATDATE,ATTACHMENT_ID,ATTACHMENT_NAME,CREATOR,USERDEF1,USERDEF2,USERDEF3,USERDEF4,USERDEF5)
values(\'').$CUSTOMER_NAME).'\',\'').$CUSTOMER_SHORT).'\',\'').$CUSTOMER_CODE).'\',\'').$TEL_NO).'\',\'').$FAX_NO).'\',\'').$CUSTOMER_WWW).'\',\'').$EMAIL).'\',\'').$CUSTOMER_AREA).'\',\'').$CUSTOMER_ADD).'\',\'').$POSTALCODE).'\',\'').$MEMO).'\',\'').$TO_ID).'\',\'').$SHARE).'\',\'').$SHARE_USER).'\',\'').$SOURCE).'\',\'').$KIND).'\',\'').$SELLMODE).'\',\'').$ATTRIBUTE).'\',\'').$ENTERTYPE).'\',\'').$ENTERMEMO).'\',\'').$MEMO1).'\',\'').$CUR_DATE).'\',\'').$ATTACHMENT_ID).'\',\'').$ATTACHMENT_NAME).'\',\'').$LOGIN_USER_ID).'\',\'').$USERDEF1).'\',\'').$USERDEF2).'\',\'').$USERDEF3).'\',\'').$USERDEF4).'\',\'').$USERDEF5).'\')');
exequery ($connection, $query);
$CUSTOMER_ID = mysql_insert_id ();
save_field_data ('CUSTOMER', $CUSTOMER_ID, $_POST);
}
else
{
$query = (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((''.'update CUSTOMER set CUSTOMER_NAME=\'').$CUSTOMER_NAME).'\',CUSTOMER_SHORT=\'').$CUSTOMER_SHORT).'\',CUSTOMER_CODE=\'').$CUSTOMER_CODE).'\',TEL_NO=\'').$TEL_NO).'\',FAX_NO=\'').$FAX_NO).'\',CUSTOMER_WWW=\'').$CUSTOMER_WWW).'\',EMAIL=\'').$EMAIL).'\',CUSTOMER_AREA=\'').$CUSTOMER_AREA).'\',CUSTOMER_ADD=\'').$CUSTOMER_ADD).'\',POSTALCODE=\'').$POSTALCODE).'\',MEMO=\'').$MEMO).'\',SELLER=\'').$TO_ID).'\',SHARE=\'').$SHARE).'\',SHAREUSER=\'').$SHARE_USER).'\',SOURCE=\'').$SOURCE).'\',KIND=\'').$KIND).'\',SELLMODE=\'').$SELLMODE).'\',ATTRIBUTE=\'').$ATTRIBUTE).'\',ENTERTYPE=\'').$ENTERTYPE).'\',ENTERMEMO=\'').$ENTERMEMO).'\',MEMO1=\'').$MEMO1).'\',ATTACHMENT_ID=\'').$ATTACHMENT_ID).'\',ATTACHMENT_NAME=\'').$ATTACHMENT_NAME).'\',USERDEF1=\'').$USERDEF1).'\',USERDEF2=\'').$USERDEF2).'\',USERDEF3=\'').$USERDEF3).'\',USERDEF4=\'').$USERDEF4).'\',USERDEF5=\'').$USERDEF5).'\' where CUSTOMER_ID=\'').$CUSTOMER_ID).'\'');
exequery ($connection, $query);
save_field_data ('CUSTOMER', $CUSTOMER_ID, $_POST);
}
if (($OP == '1'))
{
echo '<s';
echo 'cript>
location="index.php?CUSTOMER_ID=';
echo $CUSTOMER_ID;
echo '";
</script>
';
exit ();
}
echo '<br>
<div align=center>
';
message ('提示', '客户添加成功!!');
echo ' <input type="button" value="返回" class="BigButton" onClick="location=\'index.php?CUSTOMER_ID=';
echo $CUSTOMER_ID;
echo '\'">
</div>
</body>
</html>';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?