add.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 43 行
PHP
43 行
<?
include_once 'inc/auth.php';
include_once 'inc/check_type.php';
echo '
<html>
<head>
<title>增加合同明细</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor">
';
$CREATE_DATE = date ('Y-m-d', time ());
if (($OP == 'ADD'))
{
$query = (((((((((((((((((((((((''.'INSERT into SALE_HISTORY (CUSTOMER_ID,PRODUCT_ID,SERVICE_ID,TYPE,DATE,AMT,PRICE,TOTAL_PRICE,SALESMAN,CONTRACT_ID,LINE_ID)
values(\'').$CUSTOMER_ID).'\',\'').$PRO_ID).'\',\'').$SER_ID).'\',\'').$TYPE).'\',\'').$CREATE_DATE).'\',\'').$TRANS_QTY).'\',\'').$PRICE).'\',\'').$TOTAL_PRICE).'\',\'').$LOGIN_USER_ID).'\',\'').$CONTRACT_ID).'\',\'').$LINE_ID).'\')');
}
else
{
$query = (((((((((((((((((((((((((''.'update SALE_HISTORY set CUSTOMER_ID=\'').$CUSTOMER_ID).'\',PRODUCT_ID=\'').$PRO_ID).'\',SERVICE_ID=\'').$SER_ID).'\',TYPE=\'').$TYPE).'\',DATE=\'').$CREATE_DATE).'\',AMT=\'').$TRANS_QTY).'\',PRICE=\'').$PRICE).'\',TOTAL_PRICE=\'').$TOTAL_PRICE).'\',SALESMAN=\'').$LOGIN_USER_ID).'\',CONTRACT_ID=\'').$CONTRACT_ID).'\',LINE_ID=\'').$LINE_ID).'\' where HISTORY_ID=\'').$HISTORY_ID).'\'');
}
exequery ($connection, $query);
$query = ((''.'SELECT SUM(TOTAL_PRICE) as PAYMENT from SALE_HISTORY where LINE_ID=').$LINE_ID);
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$PAYMENT = $ROW['PAYMENT'];
}
$query = ((((''.'update CONTRACT_LINE set PAYMENT=').$PAYMENT).' where LINE_ID=').$LINE_ID);
$cursor = exequery ($connection, $query);
echo '</body>
</html>
';
echo '<s';
echo 'cript>
location="index.php?CONTRACT_ID=';
echo $CONTRACT_ID;
echo '&CUSTOMER_ID=';
echo $CUSTOMER_ID;
echo '";
</script>';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?