📄 add.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";
$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)\r\n 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>\r\n</html>\r\n";
if ( $FLAGSOURCE == "ad_query" )
{
echo "<script>\r\nlocation=\"index.php?CONTRACT_ID=";
echo $CONTRACT_ID;
echo "&querstr=";
echo $querstr;
echo "&";
echo $QUERY_LIST;
echo "\";\r\n</script>\r\n";
}
else
{
echo "<script>\r\nlocation=\"index.php?CONTRACT_ID=";
echo $CONTRACT_ID;
echo "&";
echo $QUERY_LIST;
echo "\";\r\n</script>\r\n";
}
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -