index.php

来自「极限网络智能办公系统 Office Automation V3.0官方100%源」· PHP 代码 · 共 70 行

PHP
70
字号
<? 
include_once("../auth.php"); 
include_once("inc/utility_all.php"); 
?> 

<html> 
<head> 
<title>公告通知</title> 
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"> 

</head> 
<body> 
<font color=blue size=+2><b>新公告通知</b></font> 
<br><br> 


<? 
//============================ 显示公告通知 ======================================= 
$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++; 

//---- 显示20条 ---- 
if($NOTIFY_COUNT>20) 
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("<","&lt",$SUBJECT); 
$SUBJECT=str_replace(">","&gt",$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; 
?> 

<?=$NOTIFY_COUNT?>.<?=$FROM_NAME?>:<?=$SUBJECT?><br> 
<i><?=$BEGIN_DATE?></i> 
<?if($TOP=="1") echo "<font color=red><b>重要:</b></font>";?><a href="read.php?P=<?=$P?>&NOTIFY_ID=<?=$NOTIFY_ID?>">阅读</a>&nbsp; 
<hr> 
<? 
}//while 

if($NOTIFY_COUNT==0) 
echo "无新公告通知"; 
?> 

<a href="../main.php?P=<?=$P?>">返回</a> 

</body> 
</html>

⌨️ 快捷键说明

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