📄 newslist.php

📁 泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。
💻 PHP
字号:
<?php

include_once( "inc/auth.php" );
include_once( "inc/conn.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/function_page_01.php" );
include_once( "inc/function_picture.php" );
$NEWS_TYPE_ID = $_REQUEST['NEWS_TYPE_ID'];
$NEWS_TYPE_NAME = $_REQUEST['NEWS_TYPE_NAME'];
$dotype = $_REQUEST['dotype'];
$connection = openconnection( );
if ( $NEWS_TYPE_ID == "" )
{
	$sql = "SELECT * FROM news WHERE PUBLIC = 1 ORDER BY PUTIP DESC,NEWS_TIME DESC";
	$NEWS_TYPE_NAME = "全部新闻";
}
else
{
	$sql = "SELECT * FROM news WHERE NEWS_TYPE_ID={$NEWS_TYPE_ID} AND PUBLIC = 1  ORDER BY NEWS_TIME DESC";
}
$sql = page( $sql, 7 );
$rs = exequery( $connection, $sql );
echo "\r\n<head>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\" />\r\n<title>新闻列表</title>\r\n<link rel=\"stylesheet\" type=\"text/css\" href=\"/theme/1/style.css\">\r\n</head>\r\n";
echo "<s";
echo "cript language=\"javascript\" src=\"/inc/prototype.js\" ></script>\r\n";
echo "<s";
echo "cript language=javascript src=\"/inc/common.js\"></script>\r\n";
echo "<s";
echo "cript language=\"javascript\" >\r\nfunction open_news(NEWS_ID)\r\n{\r\n URL=\"read_news.php?NEWS_ID=\"+NEWS_ID;\r\n myleft=(screen.availWidth-500)/2;\r\n window.open(URL,\"read_news\",\"height=400,width=750,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left=\"+myleft+\",resizable=yes\");\r\n}\r\n\r\nfunction re_news(NEWS_ID)\r\n{\r\n URL=\"/general/news/show/re_news.php?NEWS_ID=\"+NEWS_ID+\"&MANAGE=1\";\r\n mylef";
echo "t=(screen.availWidth-500)/2;\r\n window.open(URL,\"read_news\",\"height=500,width=750,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=100,left=\"+myleft+\",resizable=yes\");\r\n}\r\nfunction show_big(obj,ATTACHMENT_ID,ATTACHMENT_NAME)\r\n{\r\n\tvar objdiv = document.getElementById(obj);\r\n\tobjdiv.style.display = \"\";\r\n\tobjdiv.style.posLeft = event.clientX+document.body.scrollLeft;\r\n\tobjdiv.style.posTop";
echo " = event.clientY+document.body.scrollTop-20;\r\n\tobjdiv.innerHTML = \"<DIV id='picload'><img src='/images/loading.gif'>正在生成图片预览，请稍等...</DIV>\";\r\n\turl = \"showpic.php\";\r\n\tpar =  \"ATTACHMENT_ID=\"+ATTACHMENT_ID+\"&ATTACHMENT_NAME=\"+ATTACHMENT_NAME;\r\n\tloadingImg(obj,url,par);\r\n}\r\n\r\nfunction loadingImg(divid,url,par){\r\n\tvar objDivID = document.getElementById(divid);\r\n\tvar saveGimg = {\r\n\t\tonCreate: f";
echo "unction(){\r\n\t\t\tElement.show('picload');\r\n\t\t},\r\n\t\tonComplete: function() {\r\n\t\t\tif(Ajax.activeRequestCount == 0){\r\n\t\t\t\tElement.hide('picload');\r\n\t\t\t}\r\n\t\t}\r\n\t};\r\n\tAjax.Responders.register(saveGimg);\t\r\n\t\r\n\tqueryString = par;\r\n\tnew Ajax.Request\r\n\t(\r\n\t\turl,\r\n\t\t{\r\n\t\t\tmethod: \"post\",\t\r\n\t\t\tonSuccess : function(resp)\r\n\t\t\t\t\t\t{\r\n\t\t\t\t\t\t\tobjDivID.innerHTML = resp.responseText;\r\n\t\t\t\t\t\t\t//alert(objDivID.src);\r\n\t\t";
echo "\t\t\t\t\t\r\n\t\t\t\t\t\t},\r\n\t\t\tonFailure : function()\r\n\t\t\t\t\t\t{\r\n\t\t\t\t\t\t\talert(url);\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t},\r\n\t\t\tparameters : queryString\r\n\t\t}\r\n\t);\r\n\r\n}\r\n\r\nfunction hiddenDiv(obj){\r\n\tvar objdiv = document.getElementById(obj);\r\n\tobjdiv.style.display = 'none';\r\n\r\n}\r\n</script>\r\n<body topmargin=\"0\" rightmargin=\"0\">\r\n\t<table border=\"0\" width=\"100%\" cellspacing=\"0\"  cellpadding=\"0\" >\r\n\t\t<tr class=\"tablehead1\">\r\n\t\t\t<td>\r\n\t\t\t\t&";
echo "nbsp;&nbsp;";
echo $NEWS_TYPE_NAME;
echo "\t\t\t</td>\r\n\t\t</tr>\r\n\t</table>\r\n\t<br>\r\n\t\t";
while ( $rows = mysql_fetch_array( $rs ) )
{
	$NEWS_ID = $rows['NEWS_ID'];
	$SUBJECT = $rows['SUBJECT'];
	$CONTENT = substrgb( strip_tags( $rows['CONTENT'] ), 200, "..." );
	$PROVIDER = $rows['PROVIDER'];
	$NEWS_TIME = $rows['NEWS_TIME'];
	$CLICK_COUNT = $rows['CLICK_COUNT'];
	$ATTACHMENT_ID = $rows['ATTACHMENT_ID'];
	$ATTACHMENT_NAME = $rows['ATTACHMENT_NAME'];
	$sql = "SELECT COUNT(COMMENT_ID) AS count FROM news_comment WHERE NEWS_ID='{$NEWS_ID}'";
	$getcountrs = exequery( $connection, $sql );
	while ( $rows = mysql_fetch_array( $getcountrs ) )
	{
		$comment_count = $rows['count'];
	}
	$query = "SELECT USER_NAME FROM user WHERE USER_ID = '".$PROVIDER."'";
	$usernamers = exequery( $connection, $query );
	while ( $rows = mysql_fetch_array( $usernamers ) )
	{
		$NEWS_PROVIDER = $rows['USER_NAME'];
	}
	if ( $ATTACHMENT_ID != "" && $ATTACHMENT_NAME != "" )
	{
		$source_src = ROOT_PATH."attachment/{$ATTACHMENT_ID}/{$ATTACHMENT_NAME}";
		if ( is_file( $source_src ) )
		{
			$FILENAME = createimage( $source_src, $ATTACHMENT_NAME, "80" );
			$ATTACHMENT_NAME = base64_encode( $ATTACHMENT_NAME );
			echo "<table border='0' cellpadding='0' cellspacing='0' style='border-collapse:collapse'><tr><td rowspan='5' valign='top' width='80' align='center'><img src='{$FILENAME}' onclick=\"show_big('divlargepic','{$ATTACHMENT_ID}','{$ATTACHMENT_NAME}')\" style='cursor:hand;'title='点击查看大图' ></td><td>&nbsp;&nbsp;&nbsp;</td><td><table border='0' cellpadding='0' cellspacing='0' style='border-collapse:collapse'><tr valign='top'><td valign='top'><a href='#' onClick='open_news({$NEWS_ID})'><font color='#000099' size='3'><B><U>{$SUBJECT}</B></U></font></a></td></tr><tr><td><font color='#000000' >发布人：</font><font color='#999999' size='-1'>{$NEWS_PROVIDER}</font>&nbsp;&nbsp;&nbsp;&nbsp;<font color='#000000' >发布时间：</font><font color='#999999' size='-1'>{$NEWS_TIME}</font></td></tr><tr><td><font color='#00000' >{$CONTENT}</font></td></tr><tr><td><font color='#0000ff' >有{$CLICK_COUNT} 个人浏览了此新闻&nbsp;&nbsp;&nbsp;&nbsp;有{$comment_count} 个人作了评价</font></td></tr><tr><td><a href='#' onClick='re_news({$NEWS_ID})'><font color='#000099' ><U> 点击评价</U></font></a></td></tr><tr><td>&nbsp;</td></tr></table></td></tr></table>";
		}
	}
	else
	{
		echo "<table border='0' cellpadding='0' cellspacing='0' style='border-collapse:collapse'><tr><td rowspan='5'  ></td><td><table border='0' cellpadding='0' cellspacing='0' style='border-collapse:collapse'><tr valign='top'><td><a href='#' onClick='open_news({$NEWS_ID})'><font color='#000099' size='3'><B><U>{$SUBJECT}</B></U></font></a></td></tr><tr><td><font color='#000000' >发布人：</font><font color='#999999' size='-1'>{$NEWS_PROVIDER}</font>&nbsp;&nbsp;&nbsp;&nbsp;<font color='#000000' >发布时间：</font><font color='#999999' size='-1'>{$NEWS_TIME}</font></td></tr><tr><td><font color='#00000' >{$CONTENT}</font></td></tr><tr><td><font color='#0000ff' >有{$CLICK_COUNT} 个人浏览了此新闻&nbsp;&nbsp;&nbsp;&nbsp;有{$comment_count} 个人作了评价</font></td></tr><tr><td><a href='#' onClick='re_news({$NEWS_ID})'><font color='#000099' ><U> 点击评价</U></font></a></td></tr><tr><td>&nbsp;</td></tr></table></td></tr></table>";
	}
}
echo "<table width=\"100%\"  border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n  <tr class=\"TableLine2\">\r\n    <td width=\"83%\" align=\"right\">";
disp( "NEWS_TYPE_ID=".$NEWS_TYPE_ID."&NEWS_TYPE_NAME=".$NEWS_TYPE_NAME );
echo "</td>\r\n  </tr>\r\n</table>\r\n<div id=\"divlargepic\" title=\"点击关闭\"style=\"display:none;position:absolute;cursor:hand;background:#efefef;width:auto;height:auto;padding:5px\" onClick=\"hiddenDiv('divlargepic')\">\r\n</div>\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明

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