index1.php

来自「极限网络智能办公系统 - Office Automation 2008 官方10」· PHP 代码 · 共 387 行 · 第 1/2 页

{
	++$NEWS_COUNT;
	$NEWS_ID = $ROW['NEWS_ID'];
	$SUBJECT = $ROW['SUBJECT'];
	$PROVIDER = $ROW['PROVIDER'];
	$NEWS_TIME = $ROW['NEWS_TIME'];
	$CLICK_COUNT = $ROW['CLICK_COUNT'];
	$FORMAT = $ROW['FORMAT'];
	$TYPE_ID = $ROW['TYPE_ID'];
	$PUBLISH = $ROW['PUBLISH'];
	$ANONYMITY_YN = $ROW['ANONYMITY_YN'];
	$TO_ID = $ROW['TO_ID'];
	$PRIV_ID = $ROW['PRIV_ID'];
	$USER_ID = $ROW['USER_ID'];
	$TOP = $ROW['TOP'];
	$SUBJECT = htmlspecialchars( $SUBJECT );
	if ( $TOP == "1" )
	{
		$SUBJECT = "<font color=red><b>".$SUBJECT."</b></font>";
	}
	$query1 = "select USER_NAME,DEPT_ID from USER where USER_ID='".$PROVIDER."'";
	$cursor1 = exequery( $connection, $query1 );
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$PROVIDER_NAME = $ROW['USER_NAME'];
		$DEPT_ID = $ROW['DEPT_ID'];
	}
	$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>";
	}
	$TYPE_NAME = get_code_name( $TYPE_ID, "NEWS" );
	$DEPT_NAME = dept_long_name( $DEPT_ID );
	if ( $PUBLISH == "0" )
	{
		$PUBLISH_DESC = "<font color=red>未发布</font>";
	}
	else
	{
		$PUBLISH_DESC = "<font color=green>已发布</font>";
	}
	$query1 = "SELECT count(*) from NEWS_COMMENT where NEWS_ID=".$NEWS_ID;
	$cursor1 = exequery( $connection, $query1 );
	$COMMENT_COUNT = 0;
	if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
	{
		$COMMENT_COUNT = $ROW1[0];
	}
	if ( $NEWS_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 $NEWS_ID;
	echo "\" onClick=\"check_one(self);\">\r\n      <td nowrap align=\"center\"><u title=\"部门：";
	echo $DEPT_NAME;
	echo "\" style=\"cursor:hand\">";
	echo $PROVIDER_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><a href=\"javascript:open_news('";
	echo $NEWS_ID;
	echo "','";
	echo $FORMAT;
	echo "');\">";
	echo $SUBJECT;
	echo "</a></td>\r\n      <td nowrap align=\"center\">";
	echo $NEWS_TIME;
	echo "</td>\r\n      <td nowrap align=\"center\">";
	echo $CLICK_COUNT;
	echo "</td>\r\n      <td nowrap align=\"center\">";
	echo $COMMENT_COUNT;
	echo "</td>\r\n      <td nowrap align=\"center\">";
	echo $PUBLISH_DESC;
	echo "</td>\r\n      <td align=\"center\">\r\n      <a href=\"publish.php?NEWS_ID=";
	echo $NEWS_ID;
	echo "&PUBLISH=";
	if ( $PUBLISH == 1 )
	{
		echo "0";
	}
	else
	{
		echo "1";
	}
	echo "\"> ";
	if ( $PUBLISH == 1 )
	{
		echo "停用";
	}
	else
	{
		echo "发布";
	}
	echo "</a>\r\n      <a href=\"modify.php?NEWS_ID=";
	echo $NEWS_ID;
	echo "&start=";
	echo $start;
	echo "\"> 修改</a>\r\n      <a href=\"javascript:delete_news('";
	echo $NEWS_ID;
	echo "','";
	echo $start;
	echo "');\"> 删除</a>\r\n      <a href=\"javascript:show_reader('";
	echo $NEWS_ID;
	echo "');\"> 查阅情况</a>\r\n";
	if ( $ANONYMITY_YN != "2" )
	{
		echo "      <a href=\"javascript:re_news('";
		echo $NEWS_ID;
		echo "');\"> 管理评论</a>\r\n";
	}
	echo "      </td>\r\n    </tr>\r\n";
}
echo "\r\n<tr class=\"TableControl\">\r\n<td colspan=\"9\"> &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       <select name=\"SET_TYPE\" class=\"BigSelect\" onchange=\"modify_news(this.value);\">\r\n          <option value=\"0\"";
if ( $TYPE == "0" )
{
	echo " selected";
}
echo ">请选择新闻类型</option>\r\n          ";
echo code_list( "NEWS", $TYPE );
echo "          <option value=\"\"";
if ( $TYPE == "" )
{
	echo " selected";
}
echo ">无类型</option>\r\n       </select>\r\n      &nbsp;\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\r\n</table>\r\n</form>\r\n</body>\r\n\r\n</html>\r\n";
?>