📄 search_del.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/check_type.php");
include_once("inc/utility_all.php");
?>
<html>
<head>
<title>公告通知查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
<?
$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=$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=$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($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 = "delete from NOTIFY where FROM_ID='$LOGIN_USER_ID'";
else
$query = "delete from NOTIFY where 1=1";
$query.=$CONDITION_STR." order by TOP desc, SEND_TIME desc";
exequery($connection,$query);
$NOTIFY_COUNT=mysql_affected_rows();
Message("","共删除".$NOTIFY_COUNT."条公告通知");
Button_Back();
add_log(15,"查询删除".$NOTIFY_COUNT."公告通知",$LOGIN_USER_ID);
?>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -