📄 delete.php
字号:
<?
include_once("inc/auth.php");
?>
<html>
<head>
<title>删除客户</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor">
<?
if($CUSTOMER_ID!="")
{
$query="delete CUSTOMER,LINKMAN,CONTACT,CONTRACT,CONTRACT_LINE,SALE_HISTORY from CUSTOMER a
LEFT OUTER JOIN LINKMAN b ON a.CUSTOMER_ID = b.CUSTOMER_ID
LEFT OUTER JOIN CONTACT c ON a.CUSTOMER_ID = c.CUSTOMER_ID
LEFT OUTER JOIN CONTRACT d ON a.CUSTOMER_ID = d.CUSTOMER_ID
LEFT OUTER JOIN CONTRACT_LINE e ON d.CONTRACT_ID=e.CONTRACT_ID
LEFT OUTER JOIN SALE_HISTORY f ON a.CUSTOMER_ID = f.CUSTOMER_ID
where a.CUSTOMER_ID='$CUSTOMER_ID'";
}
else
{
$delete_str="'".str_replace(",","','",substr($delete_str,0,-1))."'";
$query="delete CUSTOMER,LINKMAN,CONTACT,CONTRACT,CONTRACT_LINE,SALE_HISTORY from CUSTOMER a
LEFT OUTER JOIN LINKMAN b ON a.CUSTOMER_ID = b.CUSTOMER_ID
LEFT OUTER JOIN CONTACT c ON a.CUSTOMER_ID = c.CUSTOMER_ID
LEFT OUTER JOIN CONTRACT d ON a.CUSTOMER_ID = d.CUSTOMER_ID
LEFT OUTER JOIN CONTRACT_LINE e ON d.CONTRACT_ID=e.CONTRACT_ID
LEFT OUTER JOIN SALE_HISTORY f ON a.CUSTOMER_ID = f.CUSTOMER_ID
where a.CUSTOMER_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&SCOPE=$SCOPE&CUSTOMER_CODE=$CUSTOMER_CODE&CUSTOMER_SHORT=$CUSTOMER_SHORT&SOURCE=$SOURCE&KIND=$KIND&SELLMODE=$SELLMODE&ATTRIBUTE=$ATTRIBUTE&ENTERTYPE=$ENTERTYPE&AREACODE=$AREACODE&CUR_PAGE=$CUR_PAGE&ORDERFIELD=$ORDERFIELD&ORDERTYPE=$ORDERTYPE");
}
?>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -