📄 add.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/check_type.php");
?>
<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($TYPE=="PRO")$TOTAL_PRICE=$PRICE*$TRANS_QTY;
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);
?>
</body>
</html>
<?
if($FLAGSOURCE=="ad_query")
{
?>
<script>
location="index.php?CONTRACT_ID=<?=$CONTRACT_ID?>&querstr=<?=$querstr?>&<?=$QUERY_LIST?>";
</script>
<?
}
else
{
?>
<script>
location="index.php?CONTRACT_ID=<?=$CONTRACT_ID?>&<?=$QUERY_LIST?>";
</script>
<?
}
?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -