delete.php

来自「极限网络智能办公系统 Office Automation V3.0官方100％源」· PHP 代码 · 共 48 行

PHP
48 行
字号 
<?
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>

delete.php - 源码说明

本页面展示了「极限网络智能办公系统 Office Automation V3.0官方100％源代码.」中的 delete.php 源码文件，采用 PHP 编程语言编写，共 48 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与Automation相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?