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