⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 newspublic.php

📁 泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。
💻 PHP
📖 第 1 页 / 共 2 页
字号:
🔍
12 
	}
	if ( $_REQUEST['click_counts'] != NULL )
	{
		if ( $WHERE_STR == "" )
		{
			$WHERE_STR .= " where click_count<=".$_REQUEST['click_counts']."";
		}
		else
		{
			$WHERE_STR .= " and click_count<=".$_REQUEST['click_counts']."";
		}
	}
	if ( $LOGIN_USER_ID == "admin" )
	{
		if ( $WHERE_STR != "" )
		{
			$query = "SELECT * from NEWS ".$WHERE_STR." ";
		}
		else
		{
			$query = "SELECT * from NEWS";
		}
	}
	else if ( $WHERE_STR != "" )
	{
		$query = "SELECT * from NEWS ".$WHERE_STR." AND PROVIDER='{$LOGIN_USER_ID}'";
	}
	else
	{
		$query = "SELECT * from NEWS WHERE PROVIDER='{$LOGIN_USER_ID}'";
	}
}
switch ( $_REQUEST['order'] )
{
case "SUBJECT" :
	$query .= " ORDER BY SUBJECT";
	break;
case "PROVIDER" :
	$query .= " ORDER BY PROVIDER";
	break;
case "NEWS_TIME" :
	$query .= " ORDER BY NEWS_TIME";
	break;
case "CLICK_COUNT" :
	$query .= " ORDER BY CLICK_COUNT";
	break;
default :
	$query .= " ORDER BY PUTIP";
	break;
}
$query .= $_REQUEST['sens'] ? " ASC" : " DESC";
$query .= ",NEWS_TIME DESC ";
$query = page( $query, 8 );
$cursor = exequery( $connection, $query );
$NEWS_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	++$NEWS_COUNT;
	$NEWS_ID = $ROW['NEWS_ID'];
	$SUBJECT = $ROW['SUBJECT'];
	$CONTENT = $ROW['CONTENT'];
	$PROVIDER = $ROW['PROVIDER'];
	$NEWS_TIME = $ROW['NEWS_TIME'];
	$CLICK_COUNT = $ROW['CLICK_COUNT'];
	$PUTIP = $ROW['PUTIP'];
	$PUBLIC = $ROW['PUBLIC'];
	$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
	$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
	if ( $PUBLIC == 1 )
	{
		$optext = "公开";
		$showvalue = 1;
		$fontcolor = "#0000FF";
	}
	else
	{
		$optext = "不公开";
		$showvalue = 0;
		$fontcolor = "#999999";
	}
	$SUBJECT = str_replace( "<", "&lt", $SUBJECT );
	$SUBJECT = str_replace( ">", "&gt", $SUBJECT );
	$SUBJECT = stripslashes( $SUBJECT );
	$SUBJECT = substrgb( $SUBJECT, 40, "..." );
	$query1 = "select * 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'];
	}
	$DEPT_NAME = dept_long_name( $DEPT_ID );
	$query3 = "SELECT count(*) from NEWS_COMMENT where NEWS_ID={$NEWS_ID} ";
	$cursor3 = exequery( $connection, $query3 );
	$COMMENT_COUNT = 0;
	if ( $ROW3 = mysql_fetch_array( $cursor3 ) )
	{
		$COMMENT_COUNT = $ROW3[0];
	}
	if ( $NEWS_COUNT % 2 == 1 )
	{
		$TableLine = "TableLine1";
	}
	else
	{
		$TableLine = "TableLine2";
	}
	echo "    <tr class=\"";
	echo $TableLine;
	echo "\" align=\"center\">\r\n\t\t<td nowrap>\r\n\t\t\t<input name=\"box\" type=\"checkbox\" id=\"box\" value=\"";
	echo $NEWS_ID;
	echo "\">&nbsp;&nbsp;\r\n\t\t</td>\r\n\t\t<td nowrap=\"nowrap\">\r\n\t\t\t";
	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 "<img src='{$FILENAME}' align='middle' style='cursor:hand' title='点击看大图'onclick=\"show_big('divlargepic','{$ATTACHMENT_ID}','{$ATTACHMENT_NAME}')\">";
		}
		else
		{
			$source_src = ROOT_PATH."images/nopicture.gif";
			$ATTACHMENT_NAME = "nopicture.gif";
			$FILENAME = createimage( $source_src, $ATTACHMENT_NAME, "80" );
			echo "<img src='{$FILENAME}' align='middle'>";
		}
	}
	else
	{
		$source_src = ROOT_PATH."images/nopicture.gif";
		$ATTACHMENT_NAME = "nopicture.gif";
		$FILENAME = createimage( $source_src, $ATTACHMENT_NAME, "80" );
		echo "<img src='{$FILENAME}' align='middle'>";
	}
	echo "\t\t\t\r\n      \t</td>\r\n\t  <td>\r\n\t  \t<a href=\"javascript:open_news('";
	echo $NEWS_ID;
	echo "');\" style=\"color:";
	echo $fontcolor;
	echo "\">";
	echo $SUBJECT;
	echo "</a>\r\n\t  </td>\r\n      <td nowrap >";
	echo $PROVIDER_NAME;
	echo "</td>\r\n      <td nowrap >";
	echo $NEWS_TIME;
	echo "</td>\r\n      <td nowrap >";
	echo $CLICK_COUNT;
	echo "</td>\r\n      <td nowrap >";
	echo $COMMENT_COUNT;
	echo "</td>\r\n      <td nowrap >\r\n\t  ";
	if ( $_SESSION['LOGIN_USER_ID'] == $PROVIDER )
	{
		echo "<a href=\"modify.php?NEWS_ID=".$NEWS_ID."&NEWS_TYPE_ID=".$NEWS_TYPE_ID."&NEWS_TYPE_NAME=".$NEWS_TYPE_NAME."&search=".$search."\"> 修改</a>";
	}
	echo "      <a href=\"javascript:delete_news('";
	echo $NEWS_ID;
	echo "','";
	echo $NEWS_TYPE_ID;
	echo "','";
	echo $NEWS_TYPE_NAME;
	echo "','";
	echo $search;
	echo "');\"> 删除</a>\r\n      <a href=\"javascript:re_news('";
	echo $NEWS_ID;
	echo "');\"> 管理评论</a>\r\n\t  ";
	if ( $PUTIP == 0 )
	{
		echo "<a href=\"javascript:up_news('{$NEWS_ID}','{$NEWS_TYPE_ID}','{$NEWS_TYPE_NAME}','{$search}');\"> 置顶&nbsp;</a>";
	}
	else
	{
		echo "<a href=\"javascript:cancelup_news('{$NEWS_ID}','{$NEWS_TYPE_ID}','{$NEWS_TYPE_NAME}','{$search}');\"> 取消置顶</a>";
	}
	echo "\t  \r\n      </td>\r\n    </tr>\r\n\t";
}
echo "</table>\r\n<table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"5\">\r\n  <tr>\r\n    <td  nowrap><input type=\"checkbox\" name=\"allbox\" onClick=\"check_all();\">全选&nbsp;&nbsp;<input type=\"button\" class=\"BigButton\" name=\"delete_all\" value=\"删除\" onClick=\"delete_select();\"></td>\r\n  </tr>\r\n  <tr>\r\n    <td nowrap align=\"right\">";
disp( "NEWS_TYPE_ID=".$NEWS_TYPE_ID."&NEWS_TYPE_NAME=".$NEWS_TYPE_NAME."&search=".$search );
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\r\n";
if ( 0 < ( $n = $_REQUEST['cur_page'] - $total_page_nums ) )
{
	$cur_page = $_REQUEST['cur_page'] - $n;
	header( "location:".$_SERVER['PHP_SELF']."?&order=".$_REQUEST['order']."&sens=".$_REQUEST['sens']."&cur_page=".$cur_page );
}
echo "</body>\r\n</html>\r\n";
echo "<s";
echo "cript language=\"javascript\" >\r\nfunction remove_putip()\r\n{\r\n\tremove_str=\"\";\r\n  for(i=0;i<document.all(\"box\").length;i++)\r\n  {\r\n\r\n      el=document.all(\"box\").item(i);\r\n      if(el.checked)\r\n      {  val=el.value;\r\n         remove_str+=val + \",\";\r\n      }\r\n  }\r\n  \r\n  if(i==0)\r\n  {\r\n      el=document.all(\"box\");\r\n      if(el.checked)\r\n      {  val=el.value;\r\n         remove_str+=val + \",\";\r\n      }\r\n ";
echo " }\r\n\r\n  if(remove_str==\"\")\r\n  {\r\n     alert(\"请至少选择其中一条记录！\");\r\n     return;\r\n  }\r\n\r\n  msg='确认要取消所选记录么？';\r\n  if(window.confirm(msg))\r\n  {\r\n    url=\"do.php?cur_page=";
echo $cur_page;
echo "&id_str=\"+ remove_str +\"&operate=remove\";\r\n    location=url;\r\n  }\r\n}\r\n\r\nfunction update_putip()\r\n{\r\n\tupdate_str=\"\";\r\n  for(i=0;i<document.all(\"box\").length;i++)\r\n  {\r\n\r\n      el=document.all(\"box\").item(i);\r\n      if(el.checked)\r\n      {  val=el.value;\r\n         update_str+=val + \",\";\r\n      }\r\n  }\r\n  \r\n  if(i==0)\r\n  {\r\n      el=document.all(\"box\");\r\n      if(el.checked)\r\n      {  val=el.value;\r\n  ";
echo "       update_str+=val + \",\";\r\n      }\r\n  }\r\n\r\n  if(update_str==\"\")\r\n  {\r\n     alert(\"请至少选择其中一条记录！\");\r\n     return;\r\n  }\r\n\r\n  msg='确认要更新所选新闻么？';\r\n  if(window.confirm(msg))\r\n  {\r\n    url=\"do.php?id_str=\"+ update_str +\"&operate=update&cur_page=";
echo $cur_page;
echo "\";\r\n    location=url;\r\n  }\r\n}\r\n\r\nfunction delete_select()\r\n{\r\n  delete_str=\"\";\r\n  for(i=0;i<document.all(\"box\").length;i++)\r\n  {\r\n\r\n      el=document.all(\"box\").item(i);\r\n      if(el.checked)\r\n      {  val=el.value;\r\n         delete_str+=val + \",\";\r\n      }\r\n  }\r\n  \r\n  if(i==0)\r\n  {\r\n      el=document.all(\"box\");\r\n      if(el.checked)\r\n      {  val=el.value;\r\n         delete_str+=val + \",\";\r\n      ";
echo "}\r\n  }\r\n\r\n  if(delete_str==\"\")\r\n  {\r\n     alert(\"请至少选择其中一条记录！\");\r\n     return;\r\n  }\r\n\r\n  msg='确认要删除所选新闻么？';\r\n  if(window.confirm(msg))\r\n  {\r\n    url=\"do.php?id_str=\"+ delete_str +\"&operate=delete&cur_page=";
echo $cur_page;
echo "\";\r\n    location=url;\r\n  }\r\n}\r\n\r\nfunction check_all()\r\n{\r\n\tfor (i=0;i<document.all(\"box\").length;i++)\r\n\t{\r\n\t\tif(document.all(\"allbox\").checked)\r\n\t\t  document.all(\"box\").item(i).checked=true;\r\n\t\telse\r\n\t\t  document.all(\"box\").item(i).checked=false;\r\n\t}\r\n\t\r\n\tif(i==0)\r\n\t{\r\n\t\tif(document.all(\"allbox\").checked)\r\n\t\t  document.all(\"box\").checked=true;\r\n\t\telse\r\n\t\t  document.all(\"box\").checked=false;\r\n\t}\r\n}\r";
echo "\n\r\n\r\nfunction searchs()\r\n{\r\n\turl\t= \"search.php\";\r\n\twindow.location\t= url;\r\n}\r\n\r\nfunction open_news(NEWS_ID)\r\n{\r\n URL=\"/general/news/show/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 delete_news(NEWS_ID,NEWS_TYP";
echo "E_ID,NEWS_TYPE_NAME,SEARCH)\r\n{\r\n msg='确认要删除该项新闻么？';\r\n if(window.confirm(msg))\r\n {\r\n  URL=\"delete.php?cur_page=";
echo $cur_page;
echo "&NEWS_ID=\" + NEWS_ID+\"&NEWS_TYPE_ID=\"+NEWS_TYPE_ID+\"&NEWS_TYPE_NAME=\"+NEWS_TYPE_NAME+\"&search=\"+SEARCH;\r\n  window.location=URL;\r\n }\r\n}\r\n\r\nfunction delete_all()\r\n{\r\n msg='确认要删除所有新闻么？';\r\n if(window.confirm(msg))\r\n {\r\n  URL=\"delete_all.php\";\r\n  window.location=URL;\r\n }\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 myleft=(screen.a";
echo "vailWidth-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\n\r\nfunction up_news(NEWS_ID,NEWS_TYPE_ID,NEWS_TYPE_NAME,SEARCH)\r\n{\r\n\turl = \"do.php?NEWS_ID=\"+NEWS_ID+\"&operate=update&cur_page=";
echo $cur_page;
echo "\"+\"&NEWS_TYPE_ID=\"+NEWS_TYPE_ID+\"&NEWS_TYPE_NAME=\"+NEWS_TYPE_NAME+\"&SEARCH=\"+SEARCH;\r\n\twindow.location = url;\r\n}\r\n\r\nfunction cancelup_news(NEWS_ID,NEWS_TYPE_ID,NEWS_TYPE_NAME,SEARCH)\r\n{\r\n\turl = \"do.php?NEWS_ID=\"+NEWS_ID+\"&operate=remove&cur_page=";
echo $cur_page;
echo "\"+\"&NEWS_TYPE_ID=\"+NEWS_TYPE_ID+\"&NEWS_TYPE_NAME=\"+NEWS_TYPE_NAME+\"&SEARCH=\"+SEARCH;\r\n\twindow.location = url ;\r\n}\r\n\r\nfunction show_big(obj,ATTACHMENT_ID,ATTACHMENT_NAME)\r\n{\r\n\t//ATTACHMENT_NAME = ATTACHMENT_NAME.urldecode();\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 = event.clientY";
echo "+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\t/*var objOtext = document.getElementById('otext";
echo "');\r\n\tobjOtext.innerHTML = \"图形加载中...\";*/\r\n\r\n\tvar saveGimg = {\r\n\t\tonCreate: function(){\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";
echo "\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\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\r\nfunction newstypemanage()\r\n{\r\n\turl = \"newstypemanage.php\";\r\n\twindow.lo";
echo "cation = url ;\r\n}\r\nfunction addnews()\r\n{\r\n\turl = \"new/index.php\";\r\n\twindow.location = url;\r\n}\r\n</script>";
?>
12

⌨️ 快捷键说明

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