📄 delete.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.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\r\n";
$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}" );
}
echo "</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -