index1.php

极限网络智能办公系统 - Office Automation 2008 官方100％ 源码

{
	echo "1";
}
echo "');\" style=\"cursor:hand;\"><u>生效日期</u>";
if ( $FIELD == "BEGIN_DATE" )
{
	echo $ORDER_IMG;
}
echo "</td>\r\n      <td nowrap align=\"center\" onclick=\"order_by('END_DATE','";
if ( $FIELD == "END_DATE" )
{
	echo 1 - $ASC_DESC;
}
else
{
	echo "1";
}
echo "');\" style=\"cursor:hand;\"><u>终止日期</u>";
if ( $FIELD == "END_DATE" )
{
	echo $ORDER_IMG;
}
echo "</td>\r\n      <td nowrap align=\"center\">阅读率</td>\r\n      <td nowrap align=\"center\">生效</td>\r\n      <td nowrap align=\"center\">操作</td>\r\n    </tr>\r\n\r\n";
$CUR_DATE = date( "Y-m-d", time( ) );
$cursor = exequery( $connection, $query );
$NOTIFY_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	++$NOTIFY_COUNT;
	$NOTIFY_ID = $ROW['NOTIFY_ID'];
	$FROM_ID = $ROW['FROM_ID'];
	$TO_ID = $ROW['TO_ID'];
	$SUBJECT = $ROW['SUBJECT'];
	$FORMAT = $ROW['FORMAT'];
	$TOP = $ROW['TOP'];
	$PRIV_ID = $ROW['PRIV_ID'];
	$USER_ID = $ROW['USER_ID'];
	$TYPE_ID = $ROW['TYPE_ID'];
	$PUBLISH = $ROW['PUBLISH'];
	$READERS = $ROW['READERS'];
	$NOTIFY_NO = $ROW['NOTIFY_NO'];
	$READERS_ARRAY = explode( ",", $READERS );
	$READERS_COUNT = sizeof( $READERS_ARRAY );
	--$READERS_COUNT;
	$query1 = "SELECT COUNT(USER_ID) from USER where find_in_set(USER_ID,'".$READERS."')";
	$cursor1 = exequery( $connection, $query1 );
	while ( $ROW1 = mysql_fetch_array( $cursor1 ) )
	{
		$READERS_COUNT = $ROW1['0'];
	}
	$query1 = "SELECT count(DISTINCT USER.USER_ID) from USER,NOTIFY where (TO_ID='ALL_DEPT' or find_in_set(USER.DEPT_ID,NOTIFY.TO_ID) or find_in_set(USER_PRIV,PRIV_ID) or find_in_set(USER.USER_ID,NOTIFY.USER_ID)) and NOTIFY_ID='".$NOTIFY_ID."'  and NOT_LOGIN='0'";
	$cursor1 = exequery( $connection, $query1 );
	if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
	{
		$READERS_TOTAL_COUNT = $ROW1[0];
	}
	if ( 0 < $READERS_TOTAL_COUNT )
	{
		$READERS1 = intval( $READERS_COUNT / $READERS_TOTAL_COUNT * 100 );
	}
	else
	{
		$READERS1 = 0;
	}
	$SUBJECT = htmlspecialchars( $SUBJECT );
	$SEND_TIME = $ROW['SEND_TIME'];
	$BEGIN_DATE = $ROW['BEGIN_DATE'];
	$END_DATE = $ROW['END_DATE'];
	$BEGIN_DATE = strtok( $BEGIN_DATE, " " );
	$END_DATE = strtok( $END_DATE, " " );
	if ( $END_DATE == "0000-00-00" )
	{
		$END_DATE = "";
	}
	$query1 = "select USER_NAME,DEPT_ID from USER where USER_ID='".$FROM_ID."'";
	$cursor1 = exequery( $connection, $query1 );
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$FROM_NAME = $ROW['USER_NAME'];
		$DEPT_ID = $ROW['DEPT_ID'];
	}
	$DEPT_NAME = dept_long_name( $DEPT_ID );
	$TYPE_NAME = get_code_name( $TYPE_ID, "NOTIFY" );
	$TO_NAME = "";
	if ( $TO_ID == "ALL_DEPT" )
	{
		$TO_NAME = "全体部门";
	}
	else
	{
		$query1 = "select DEPT_NAME from DEPARTMENT where find_in_set(DEPT_ID,'".$TO_ID."')";
		$cursor1 = exequery( $connection, $query1 );
		while ( $ROW = mysql_fetch_array( $cursor1 ) )
		{
			$TO_NAME .= $ROW['DEPT_NAME']."，";
		}
	}
	$TO_NAME_TITLE = "";
	$TO_NAME_STR = "";
	if ( $TO_NAME != "" )
	{
		if ( substr( $TO_NAME, -2 ) == "，" )
		{
			$TO_NAME = substr( $TO_NAME, 0, -2 );
		}
		$TO_NAME_TITLE .= "部门：".$TO_NAME;
		$TO_NAME_STR .= "<font color=#0000FF><b>部门：</b></font>".csubstr( strip_tags( $TO_NAME ), 0, 20 ).( 20 < strlen( $TO_NAME ) ? "..." : "" )."<br>";
	}
	$PRIV_NAME = "";
	$query1 = "SELECT PRIV_NAME from USER_PRIV where find_in_set(USER_PRIV,'".$PRIV_ID."')";
	$cursor1 = exequery( $connection, $query1 );
	while ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$PRIV_NAME .= $ROW['PRIV_NAME']."，";
	}
	if ( $PRIV_NAME != "" )
	{
		$PRIV_NAME = substr( $PRIV_NAME, 0, -2 );
		if ( $TO_NAME_TITLE != "" )
		{
			$TO_NAME_TITLE .= "\n\n";
		}
		$TO_NAME_TITLE .= "角色：".$PRIV_NAME;
		$TO_NAME_STR .= "<font color=#0000FF><b>角色：</b></font>".csubstr( strip_tags( $PRIV_NAME ), 0, 20 ).( 20 < strlen( $PRIV_NAME ) ? "..." : "" )."<br>";
	}
	$USER_NAME = "";
	$query1 = "SELECT USER_NAME from USER where find_in_set(USER_ID,'".$USER_ID."')";
	$cursor1 = exequery( $connection, $query1 );
	while ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$USER_NAME .= $ROW['USER_NAME']."，";
	}
	if ( $USER_NAME != "" )
	{
		$USER_NAME = substr( $USER_NAME, 0, -2 );
		if ( $TO_NAME_TITLE != "" )
		{
			$TO_NAME_TITLE .= "\n\n";
		}
		$TO_NAME_TITLE .= "人员：".$USER_NAME;
		$TO_NAME_STR .= "<font color=#0000FF><b>人员：</b></font>".csubstr( strip_tags( $USER_NAME ), 0, 20 ).( 20 < strlen( $USER_NAME ) ? "..." : "" )."<br>";
	}
	if ( compare_date( $CUR_DATE, $BEGIN_DATE ) < 0 )
	{
		$NOTIFY_STATUS = 1;
		$NOTIFY_STATUS_STR = "待生效";
	}
	else
	{
		$NOTIFY_STATUS = 2;
		$NOTIFY_STATUS_STR = "<font color='#00AA00'><b>生效</font>";
	}
	if ( ( $END_DATE != "" || $PUBLISH == "0" ) && 0 < compare_date( $CUR_DATE, $END_DATE ) )
	{
		$NOTIFY_STATUS = 3;
		$NOTIFY_STATUS_STR = "<font color='#FF0000'><b>终止</font>";
	}
	if ( $PUBLISH == "0" )
	{
		if ( $NOTIFY_CONFIRM == 0 )
		{
			$NOTIFY_STATUS_STR = "<font color=red>未发布</font>";
		}
		else
		{
			$NOTIFY_STATUS_STR = "<font color=red>待批</font>";
		}
	}
	if ( $TOP == "1" )
	{
		$SUBJECT = "<font color=red><b>".$SUBJECT."</b></font>";
	}
	if ( $NOTIFY_COUNT % 2 == 1 )
	{
		$TableLine = "TableLine1";
	}
	else
	{
		$TableLine = "TableLine2";
	}
	echo "    <tr class=\"";
	echo $TableLine;
	echo "\">\r\n       <td>&nbsp;<input type=\"checkbox\" name=\"news_select\" value=\"";
	echo $NOTIFY_ID;
	echo "\" onClick=\"check_one(self);\">\r\n     <td nowrap align=\"center\">";
	echo $NOTIFY_NO;
	echo "</td>\r\n     <td nowrap align=\"center\"><u title=\"部门：";
	echo $DEPT_NAME;
	echo "\" style=\"cursor:hand\">";
	echo $FROM_NAME;
	echo "</u></td>\r\n      <td nowrap align=\"center\">";
	echo $TYPE_NAME;
	echo "</td>\r\n      <td style=\"cursor:hand\" title=\"";
	echo $TO_NAME_TITLE;
	echo "\">";
	echo $TO_NAME_STR;
	echo "</td>\r\n      <td>\r\n      <a href=\"javascript:open_notify('";
	echo $NOTIFY_ID;
	echo "','";
	echo $FORMAT;
	echo "');\">";
	echo $SUBJECT;
	echo "</a>\r\n      </td>\r\n      <td align=\"center\">";
	echo $SEND_TIME;
	echo "</a></td>\r\n      <td nowrap align=\"center\">";
	echo $BEGIN_DATE;
	echo "</td>\r\n      <td nowrap align=\"center\">";
	echo $END_DATE;
	echo "</td>\r\n      <td nowrap align=\"center\">";
	echo $READERS1;
	echo "%</td>\r\n      <td nowrap align=\"center\">";
	echo $NOTIFY_STATUS_STR;
	echo "</td>\r\n      <td align=\"center\">\r\n      <a href=\"modify.php?NOTIFY_ID=";
	echo $NOTIFY_ID;
	echo "&start=";
	echo $start;
	echo "\"> 修改</a>\r\n      <a href=\"javascript:delete_notify('";
	echo $NOTIFY_ID;
	echo "','";
	echo $start;
	echo "');\"> 删除</a>\r\n      ";
	if ( $NOTIFY_STATUS == 1 && $PUBLISH == "1" )
	{
		echo "      <a href=\"manage.php?OP=1&NOTIFY_ID=";
		echo $NOTIFY_ID;
		echo "&OPERATION=1&start=";
		echo $start;
		echo "&STATUS=";
		echo $STATUS;
		echo "&TYPE=";
		echo $TYPE;
		echo "&FIELD=";
		echo $FIELD;
		echo "&ASC_DESC=";
		echo $ASC_DESC;
		echo "\"> 立即生效</a>\r\n      ";
	}
	else if ( $NOTIFY_STATUS == 2 && $PUBLISH == "1" )
	{
		echo "      <a href=\"manage.php?OP=1&NOTIFY_ID=";
		echo $NOTIFY_ID;
		echo "&OPERATION=2&start=";
		echo $start;
		echo "&STATUS=";
		echo $STATUS;
		echo "&TYPE=";
		echo $TYPE;
		echo "&FIELD=";
		echo $FIELD;
		echo "&ASC_DESC=";
		echo $ASC_DESC;
		echo "\"> 终止</a>\r\n      ";
	}
	else if ( $NOTIFY_STATUS == 3 && $PUBLISH == "1" )
	{
		echo "      <a href=\"manage.php?OP=1&NOTIFY_ID=";
		echo $NOTIFY_ID;
		echo "&OPERATION=3&start=";
		echo $start;
		echo "&STATUS=";
		echo $STATUS;
		echo "&TYPE=";
		echo $TYPE;
		echo "&FIELD=";
		echo $FIELD;
		echo "&ASC_DESC=";
		echo $ASC_DESC;
		echo "\"> 生效</a>\r\n      ";
	}
	echo "      <br>\r\n      <a href=\"javascript:show_reader('";
	echo $NOTIFY_ID;
	echo "');\"> 查阅情况</a>\r\n";
	if ( $TOP == "1" )
	{
		echo "      <a href=\"notop.php?OP=1&NOTIFY_ID=";
		echo $NOTIFY_ID;
		echo "&start=";
		echo $start;
		echo "&STATUS=";
		echo $STATUS;
		echo "&TYPE=";
		echo $TYPE;
		echo "&FIELD=";
		echo $FIELD;
		echo "&ASC_DESC=";
		echo $ASC_DESC;
		echo "\"> 取消置顶</a>\r\n";
	}
	echo "      </td>\r\n    </tr>\r\n";
}
echo "\r\n<tr class=\"TableControl\">\r\n<td colspan=\"11\"> &nbsp;<input type=\"checkbox\" name=\"allbox\" id=\"allbox_for\" onClick=\"check_all();\">\r\n      <label for=\"allbox_for\">全选</label> \r\n      <input type=\"button\"  value=\"删除\" class=\"SmallButton\" onClick=\"del_news();\" title=\"删除所选公告\"> &nbsp;\r\n\t\t";
if ( $NOTIFY_CONFIRM == 0 )
{
	echo "      <input type=\"button\"  value=\"发布\" class=\"SmallButton\" onClick=\"confirm_news();\" title=\"发布所选公告\"> &nbsp;\r\n\t\t";
}
echo "\t\t";
if ( $NOTIFY_CONFIRM == 1 && find_id( $NOTIFY_MANAGER, $LOGIN_USER_ID ) )
{
	echo "      <input type=\"button\"  value=\"审核发布\" class=\"SmallButton\" onClick=\"confirm_news();\" title=\"审核发布所选公告\"> &nbsp;\r\n\t\t";
}
echo "       <select name=\"TYPE\" class=\"BigSelect\" onchange=\"modify_notify(this.value);\">\r\n          <option value=\"0\"";
if ( $TYPE == "0" )
{
	echo " selected";
}
echo ">请选择公告类型</option>\r\n          ";
echo code_list( "NOTIFY", $TYPE );
echo "          <option value=\"\"";
if ( $TYPE == "" )
{
	echo " selected";
}
echo ">无类型</option>\r\n       </select>\r\n</td>\r\n<td>\r\n<input type=\"button\"  value=\"全部删除\" class=\"SmallButton\" onClick=\"delete_all()\" title=\"删除所有已发布的公告\">\r\n</td>\r\n</tr>\r\n</table>\r\n</body>\r\n\r\n</html>\r\n";
?>