📄 search_del.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/check_type.php" );
include_once( "inc/utility_file.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\r\n</head>\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n";
$CUR_DATE = date( "Y-m-d", time( ) );
if ( $SEND_TIME_MIN != "" )
{
$TIME_OK = is_date( $SEND_TIME_MIN );
if ( !$TIME_OK )
{
message( "错误", "\"发布日期\"的格式不对，应形如 ".$CUR_DATE );
button_back( );
exit( );
}
$SEND_TIME_MIN .= " 00:00:00";
}
if ( $SEND_TIME_MAX != "" )
{
$TIME_OK = is_date( $SEND_TIME_MAX );
if ( !$TIME_OK )
{
message( "错误", "\"发布日期\"的格式不对，应形如 ".$CUR_DATE );
button_back( );
exit( );
}
$SEND_TIME_MAX .= " 23:59:59";
}
$CONDITION_STR = "";
if ( $SUBJECT != "" )
{
$CONDITION_STR .= " and SUBJECT like '%".$SUBJECT."%'";
}
if ( $CONTENT != "" )
{
$CONDITION_STR .= " and CONTENT like '%".$CONTENT."%'";
}
if ( $SEND_TIME_MIN != "" )
{
$CONDITION_STR .= " and SEND_TIME>='".$SEND_TIME_MIN."'";
}
if ( $SEND_TIME_MAX != "" )
{
$CONDITION_STR .= " and SEND_TIME<='".$SEND_TIME_MAX."'";
}
if ( $FORMAT != "" )
{
$CONDITION_STR .= " and FORMAT='".$FORMAT."'";
}
if ( $TYPE_ID != "" )
{
$CONDITION_STR .= " and TYPE_ID='".$TYPE_ID."'";
}
if ( $PUBLISH != "" )
{
$CONDITION_STR .= " and PUBLISH='".$PUBLISH."'";
}
if ( $TOP != "" )
{
$CONDITION_STR .= " and TOP='".$TOP."'";
}
if ( $STAT != "" )
{
if ( $STAT == 1 )
{
$CONDITION_STR .= " and BEGIN_DATE>'".$CUR_DATE."'";
}
else if ( $STAT == 2 )
{
$CONDITION_STR .= " and BEGIN_DATE<='".$CUR_DATE."' and (END_DATE='0000-00-00' or END_DATE>='{$CUR_DATE}')";
}
else if ( $STAT == 3 )
{
$CONDITION_STR .= " and END_DATE!='0000-00-00' and END_DATE<='".$CUR_DATE."'";
}
}
if ( $LOGIN_USER_PRIV != "1" )
{
$query = "select ATTACHMENT_ID,ATTACHMENT_NAME from NOTIFY where ATTACHMENT_NAME!='' and FROM_ID='".$LOGIN_USER_ID."'";
}
else
{
$query = "select ATTACHMENT_ID,ATTACHMENT_NAME from NOTIFY where ATTACHMENT_NAME!=''";
}
$query .= $CONDITION_STR;
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
delete_attach( $ATTACHMENT_ID, $ATTACHMENT_NAME );
}
if ( $LOGIN_USER_PRIV != "1" )
{
$query = "delete from NOTIFY where FROM_ID='".$LOGIN_USER_ID."'";
}
else
{
$query = "delete from NOTIFY where 1=1";
}
$query .= $CONDITION_STR;
exequery( $connection, $query );
$NOTIFY_COUNT = mysql_affected_rows( );
message( "", "共删除".$NOTIFY_COUNT."条公告通知" );
button_back( );
add_log( 15, "查询删除".$NOTIFY_COUNT."公告通知", $LOGIN_USER_ID );
echo "</body>\r\n\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -