📄 delete.php

📁 泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。

💻 PHP

字号:

<?php

include_once( "inc/auth.php" );
$connection = openconnection( );
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";
$query2 = "select sh.*, c.* from sale_history as sh, customer as c where sh.CUSTOMER_ID=c.CUSTOMER_ID and sh.CUSTOMER_ID=".$_REQUEST['CUSTOMER_ID'];
$cursor2 = exequery( $connection, $query2 );
$count = 0;
while ( $row2 = mysql_fetch_row( $cursor2 ) )
{
	++$count;
	$customer_id = $row2['CUSTOMER_ID'];
}
if ( $count != 0 )
{
	message( "提示", "请先删除产品对应的销售记录，再删除客户" );
	echo "<br>\r\n<div align=\"center\">\r\n\t<input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"javascript:location='index.php'\">\r\n</div>\r\n";
	exit( );
}
$query = "delete from CUSTOMER where CUSTOMER_ID='{$CUSTOMER_ID}'";
exequery( $connection, $query );
$query2 = "delete from linkman where CUSTOMER_ID='{$CUSTOMER_ID}'";
exequery( $connection, $query2 );
$query3 = "delete from contact where CUSTOMER_ID='{$CUSTOMER_ID}'";
exequery( $connection, $query3 );
if ( $_REQUEST['del_type'] == "list" )
{
	header( "location: list.php?cur_page=".$_REQUEST['cur_page']."&sens=".$_REQUEST['sens']."&order=".$_REQUEST['order']."&CUSTOMER_NAME=".$_REQUEST['CUSTOMER_NAME']."&TEL_NO=".$_REQUEST['TEL_NO']."&FAX_NO=".$_REQUEST['FAX_NO']."&CUSTOMER_WWW=".$_REQUEST['CUSTOMER_WWW']."&EMAIL=".$_REQUEST['EMAIL']."&CUSTOMER_ADD=".$_REQUEST['CUSTOMER_ADD']."&POSTALCODE=".$_REQUEST['POSTALCODE']."&MEMO=".$_REQUEST['MEMO']."" );
}
else
{
	header( "location: index.php?cur_page=".$_REQUEST['cur_page']."&CUSTOMER_NAME={$CUSTOMER_NAME}&TEL_NO={$TEL_NO}&FAX_NO={$FAX_NO}&CUSTOMER_WWW={$CUSTOMER_WWW}&EMAIL={$EMAIL}&CUSTOMER_ADD={$CUSTOMER_ADD}&POSTALCODE={$POSTALCODE}&MEMO={$MEMO}&PAGE_START={$PAGE_START}" );
}
echo "</body>\r\n</html>";
?>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -