📄 delete.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
?>
<html>
<head>
<title>删除合同明细</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor">
<?
$query = "SELECT LINE_ID from SALE_HISTORY where HISTORY_ID=$HISTORY_ID";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))$LINE_ID=$ROW["LINE_ID"];
$query="delete SALE_HISTORY from SALE_HISTORY where HISTORY_ID='$HISTORY_ID'";
exequery($connection,$query);
$query = "SELECT sum(IFNULL(TOTAL_PRICE, 0)) as PAYMENT from SALE_HISTORY where LINE_ID=$LINE_ID";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))$PAYMENT=$ROW["PAYMENT"];
if($PAYMENT=="")$PAYMENT=0;
$query="update CONTRACT_LINE set PAYMENT=$PAYMENT where LINE_ID=$LINE_ID";
$cursor= exequery($connection,$query);
if($querstr!="")
{
header("location: index.php?querstr=$querstr&CONTRACT_ID=$CONTRACT_ID&CUR_PAGE=$CUR_PAGE&ORDERFIELD=$ORDERFIELD&ORDERTYPE=$ORDERTYPE");
}
else
header("location: index.php?CUSTOMER_NAME=$CUSTOMER_NAME&KIND=$KIND&SELLMODE=$SELLMODE&CONTRACT_TYPE=$CONTRACT_TYPE&DATE_TYPE=$DATE_TYPE&CONTRACT_NO=$CONTRACT_NO&CONTRACT_NAME=$CONTRACT_NAME&CONTRACT_LINKMAN1=$CONTRACT_LINKMAN1&CONTRACT_LINKMAN2=$CONTRACT_LINKMAN2&DATE1=$DATE1&DATE2=$DATE2&SIGN=$SIGN&CONTRACT_ID=$CONTRACT_ID&CUR_PAGE=$CUR_PAGE&ORDERFIELD=$ORDERFIELD&ORDERTYPE=$ORDERTYPE");
?>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -