📄 index.php
字号:
<?php
include_once( "../auth.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\r\n</head>\r\n<body>\r\n<font color=blue size=+2><b>新公告通知</b></font>\r\n<br><br>\r\n\r\n\r\n";
$CUR_DATE = date( "Y-m-d", time( ) );
$query = "SELECT * from NOTIFY where (TO_ID='ALL_DEPT' or find_in_set('".$LOGIN_DEPT_ID."',TO_ID) or find_in_set('{$LOGIN_USER_PRIV}',PRIV_ID) or find_in_set('{$LOGIN_USER_ID}',USER_ID)) and begin_date<='{$CUR_DATE}' and (end_date>='{$CUR_DATE}' or end_date is null) and PUBLISH='1' and READERS not like '%,{$LOGIN_USER_ID},%' and READERS not like '{$LOGIN_USER_ID},%' order by TOP desc,BEGIN_DATE desc,SEND_TIME desc";
$cursor = exequery( $connection, $query );
$NOTIFY_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$NOTIFY_COUNT;
if ( 20 < $NOTIFY_COUNT )
{
break;
}
$NOTIFY_ID = $ROW['NOTIFY_ID'];
$FROM_ID = $ROW['FROM_ID'];
$SUBJECT = $ROW['SUBJECT'];
$TOP = $ROW['TOP'];
$TYPE_ID = $ROW['TYPE_ID'];
$SUBJECT = str_replace( "<", "<", $SUBJECT );
$SUBJECT = str_replace( ">", ">", $SUBJECT );
$SUBJECT = stripslashes( $SUBJECT );
$BEGIN_DATE = $ROW['BEGIN_DATE'];
$BEGIN_DATE = strtok( $BEGIN_DATE, " " );
$TYPE_NAME = get_code_name( $TYPE_ID, "NOTIFY" );
if ( $TYPE_NAME != "" )
{
$SUBJECT = "【".$TYPE_NAME."】".$SUBJECT;
}
$query1 = "SELECT * from USER where USER_ID='".$FROM_ID."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$FROM_NAME = $ROW['USER_NAME'];
}
else
{
$FROM_NAME = $FROM_ID;
}
echo "\r\n";
echo $NOTIFY_COUNT;
echo ".";
echo $FROM_NAME;
echo "：";
echo $SUBJECT;
echo "<br>\r\n<i>";
echo $BEGIN_DATE;
echo "</i>\r\n";
if ( $TOP == "1" )
{
echo "<font color=red><b>重要：</b></font>";
}
echo "<a href=\"read.php?P=";
echo $P;
echo "&NOTIFY_ID=";
echo $NOTIFY_ID;
echo "\">阅读</a> \r\n<hr>\r\n";
}
if ( $NOTIFY_COUNT == 0 )
{
echo "无新公告通知";
}
echo "\r\n<a href=\"../main.php?P=";
echo $P;
echo "\">返回</a>\r\n\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -