📄 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($PRODUCT_ID!="")
{
$query="delete PRODUCT,CONTRACT_LINE,SALE_HISTORY from PRODUCT a
LEFT OUTER JOIN CONTRACT_LINE b ON a.PRODUCT_ID = b.PRODUCT_ID
LEFT OUTER JOIN SALE_HISTORY d ON a.PRODUCT_ID =d.PRODUCT_ID
LEFT OUTER JOIN SALE_HISTORY e ON e.LINE_ID=b.LINE_ID
where a.PRODUCT_ID='$PRODUCT_ID'";
}
else
{
$delete_str="'".str_replace(",","','",substr($delete_str,0,-1))."'";
$query="delete PRODUCT,CONTRACT_LINE,SALE_HISTORY from PRODUCT a
LEFT OUTER JOIN CONTRACT_LINE b ON a.PRODUCT_ID = b.PRODUCT_ID
LEFT OUTER JOIN SALE_HISTORY d ON a.PRODUCT_ID =d.PRODUCT_ID
LEFT OUTER JOIN SALE_HISTORY e ON e.LINE_ID=b.LINE_ID
where a.PRODUCT_ID in ($delete_str)";
}
exequery($connection,$query);
header("location: index.php?PRODUCT_NAME=$PRODUCT_NAME&PRODUCT_TYPE=$PRODUCT_TYPE&PRODUCT_DESC=$PRODUCT_DESC&PRODUCT_MODE=$PRODUCT_MODE&PROVIDER_NAME=$PROVIDER_NAME&CUR_PAGE=$CUR_PAGE&ORDERFIELD=$ORDERFIELD&ORDERTYPE=$ORDERTYPE");
?>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -