📄 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">
<?
if($CONTRACT_ID!="")
{
$query="select ATTACHMENT_ID,ATTACHMENT_NAME from CONTRACT where CONTRACT_ID=$CONTRACT_ID";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$ATTACHMENT_ID=$ROW["ATTACHMENT_ID"];
$ATTACHMENT_NAME=$ROW["ATTACHMENT_NAME"];
}
if($ATTACHMENT_NAME!="")
{
$ATTACHMENT_ID_ARRAY=explode(",",$ATTACHMENT_ID);
$ATTACHMENT_NAME_ARRAY=explode("*",$ATTACHMENT_NAME);
$ARRAY_COUNT=sizeof($ATTACHMENT_ID_ARRAY);
for($I=0;$I<$ARRAY_COUNT;$I++)
{
if($ATTACHMENT_ID_ARRAY[$I]!="")
delete_attach($ATTACHMENT_ID_ARRAY[$I],$ATTACHMENT_NAME_ARRAY[$I]);
}
}
}
else
{
$delete_str="'".str_replace(",","','",substr($delete_str,0,-1))."'";
$query="select ATTACHMENT_ID,ATTACHMENT_NAME from CONTRACT where CONTRACT_ID in ($delete_str)";
$cursor= exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))
{
$ATTACHMENT_ID=$ROW["ATTACHMENT_ID"];
$ATTACHMENT_NAME=$ROW["ATTACHMENT_NAME"];
if($ATTACHMENT_NAME!="")
{
$ATTACHMENT_ID_ARRAY=explode(",",$ATTACHMENT_ID);
$ATTACHMENT_NAME_ARRAY=explode("*",$ATTACHMENT_NAME);
$ARRAY_COUNT=sizeof($ATTACHMENT_ID_ARRAY);
for($I=0;$I<$ARRAY_COUNT;$I++)
{
if($ATTACHMENT_ID_ARRAY[$I]!="")
delete_attach($ATTACHMENT_ID_ARRAY[$I],$ATTACHMENT_NAME_ARRAY[$I]);
}
}
}
}
if($CONTRACT_ID!="")
{
$query="delete CONTRACT, CONTRACT_LINE,SALE_HISTORY from CONTRACT a
LEFT OUTER JOIN CONTRACT_LINE b ON a.CONTRACT_ID = b.CONTRACT_ID
LEFT OUTER JOIN SALE_HISTORY d ON a.CONTRACT_ID =d.CONTRACT_ID
where a.CONTRACT_ID='$CONTRACT_ID'";
}
else
{
$query="delete CONTRACT, CONTRACT_LINE,SALE_HISTORY from CONTRACT a
LEFT OUTER JOIN CONTRACT_LINE b ON a.CONTRACT_ID = b.CONTRACT_ID
LEFT OUTER JOIN SALE_HISTORY d ON a.CONTRACT_ID =d.CONTRACT_ID
where a.CONTRACT_ID in ($delete_str)";
}
exequery($connection,$query);
if($querstr!="")
{
$urlstr1=str_replace("%","&",$querstr);
header("location: ad_query/list.php?".$urlstr1."&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&CUR_PAGE=$CUR_PAGE&ORDERFIELD=$ORDERFIELD&ORDERTYPE=$ORDERTYPE");
}
?>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -