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 + -
显示快捷键?