del_res.php

来自「极限网络智能办公系统—MYOA26—100%—源程序。」· PHP 代码 · 共 75 行

PHP
75
字号
<?php

include_once( "inc/auth.php" );
include_once( "ikernel/utility.php" );
include_once( "inc/utility_all.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\" topmargin=\"5\">\r\n";
if ( $BEGIN_DATE != "" )
{
	$TIME_OK = is_date_time( $BEGIN_DATE );
	if ( !$TIME_OK )
	{
		message( "错误", "起始时间格式不对,应形如 1999-1-2 14:55:20" );
		button_back( );
		exit( );
	}
}
if ( $END_DATE != "" )
{
	$TIME_OK = is_date_time( $END_DATE );
	if ( !$TIME_OK )
	{
		message( "错误", "截止时间格式不对,应形如 1999-1-2 14:55:20" );
		button_back( );
		exit( );
	}
}
if ( $END_DATE != "" && $BEGIN_DATE != "" && $END_DATE < $BEGIN_DATE )
{
	message( "错误", "截止时间不能晚于起始时间!" );
	button_back( );
	exit( );
}
if ( $BEGIN_DATE != "" )
{
	$query1 .= "SEND_TIME>='{$BEGIN_DATE}' and ";
}
if ( $END_DATE != "" )
{
	$query1 .= "SEND_TIME<='{$END_DATE}' and ";
}
$query1 = substr( $query1, 0, -5 );
if ( $SMS == "on" )
{
	$query = "delete from SMS where ".$query1;
	exequery( $connection, $query );
}
if ( $EMAIL == "on" )
{
	$query = "select * from EMAIL where ".$query1;
	$cursor = exequery( $connection, $query );
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$EMAIL_ID = $ROW['EMAIL_ID'];
		$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
		$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
		if ( $ATTACHMENT_NAME != "" )
		{
			$ATTACHMENT_ID_ARRAY = explode( ",", $ATTACHMENT_ID );
			$ATTACHMENT_NAME_ARRAY = explode( "*", $ATTACHMENT_NAME );
			$ARRAY_COUNT = sizeof( $ATTACHMENT_ID_ARRAY );
			$I = 0;
			for ( ;	$I < $ARRAY_COUNT - 1;	++$I	)
			{
				delete_attach( $ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I] );
			}
		}
		$query = "delete from EMAIL where EMAIL_ID={$EMAIL_ID}";
		exequery( $connection, $query );
	}
}
message( "提示", "操作已完成!" );
button_back( );
echo "\r\n</body>\r\n</html>\r\n";
?>

⌨️ 快捷键说明

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