📄 newspublic.php

📁 泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。
💻 PHP
📖 第 1 页 / 共 2 页
字号:
12 下一页
<?php

include_once( "inc/auth.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'];
$search = $_REQUEST['search'];
if ( $NEWS_TYPE_ID == "" && $NEWS_TYPE_NAME == "" )
{
	$NEWS_TYPE_NAME = "全部新闻";
}
if ( $_REQUEST['title'] == "1" )
{
	$message = "没有符合条件的新闻";
	$title = "查询结果";
}
else
{
	$message = "无已发布的新闻";
	$title = "已发布新闻";
}
if ( $_REQUEST['cur_page'] == NULL )
{
	$cur_page = 1;
}
else
{
	$cur_page = $_REQUEST['cur_page'];
}
$connection = openconnection( );
echo "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\r\n<html xmlns=\"http://www.w3.org/1999/xhtml\">\r\n<head>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\" />\r\n";
echo "<s";
echo "cript language=\"javascript\" src=\"/inc/common.js\"></script>\r\n";
echo "<s";
echo "cript language=\"javascript\" src=\"/inc/follow.js\"></script>\r\n";
echo "<s";
echo "cript language=\"javascript\" src=\"/inc/prototype.js\" ></script>\r\n<title>新闻管理</title>\r\n</head>\r\n<body topmargin=\"1\" leftmargin=\"0\" rightmargin=\"0\">\r\n\t";
$connection = openconnection( );
if ( $_REQUEST['search'] != "1" )
{
	if ( $LOGIN_USER_ID == "admin" )
	{
		$query = "SELECT count(*) from NEWS";
	}
	else
	{
		$query = "SELECT count(*) from NEWS where PROVIDER='{$LOGIN_USER_ID}'";
	}
}
else
{
	if ( $NEWS_TYPE_ID != "" )
	{
		if ( $WHERE_STR == "" )
		{
			$WHERE_STR .= "WHERE NEWS_TYPE_ID= '".$_REQUEST['NEWS_TYPE_ID']."'";
		}
		else
		{
			$WHERE_STR .= "AND NEWS_TYPE_ID= '".$_REQUEST['NEWS_TYPE_ID']."'";
		}
	}
	if ( $LOGIN_USER_ID == "admin" )
	{
		if ( $WHERE_STR != "" )
		{
			$query = "SELECT count(*) from NEWS ".$WHERE_STR." ";
		}
		else
		{
			$query = "SELECT count(*) from NEWS";
		}
	}
	else if ( $WHERE_STR != "" )
	{
		$query = "SELECT count(*) from NEWS ".$WHERE_STR." AND PROVIDER='{$LOGIN_USER_ID}'";
	}
	else
	{
		$query = "SELECT count(*) from NEWS WHERE AND PROVIDER='{$LOGIN_USER_ID}'";
	}
}
$cursor = exequery( $connection, $query );
$NEWS_COUNT = 0;
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$NEWS_COUNT = $ROW[0];
}
if ( $NEWS_COUNT == 0 )
{
	message( "提示", $message );
	exit( );
}
echo "\t<table border=\"0\" width=\"100%\" cellspacing=\"1\" cellpadding=\"3\" class=\"small\" >\r\n\t\t<tr class=\"tablehead2\">\r\n\t\t\t<td colspan=\"8\">【";
echo $NEWS_TYPE_NAME;
echo "】&nbsp;共";
echo $NEWS_COUNT;
echo "则新闻\r\n\t\t\t</td> \r\n\t\t</tr>\r\n\t\t";
$sens = $_REQUEST['sens'] ? 0 : 1;
$sensimg = $_REQUEST['sens'] ? "arrow_up.gif" : "arrow_down.gif";
$sensimg = "/images/".$sensimg;
$sufurl = $_SERVER['PHP_SELF']."?sens=".$sens."&NEWS_TYPE_ID=".$NEWS_TYPE_ID."&NEWS_TYPE_NAME=".$NEWS_TYPE_NAME."&search=".$search;
echo "\t\t<tr class=\"tablehead1\"  align=\"center\">\r\n\t\t\t<td nowrap colspan=\"2\">\r\n\t\t\t</td>\r\n\t\t\t<td nowrap><a href=\"";
echo $sufurl;
echo "&order=SUBJECT\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;标题&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</a>";
if ( $_REQUEST['order'] == "SUBJECT" )
{
	echo "<img src='".$sensimg."'>";
}
echo "\t\t\t</td>\r\n\t\t\t<td nowrap >\r\n\t\t\t";
if ( $LOGIN_USER_PRIV == "1" )
{
	echo "\t\t\t<a href=\"";
	echo $sufurl;
	echo "&order=PROVIDER\">发布人</a>";
	if ( $_REQUEST['order'] == "PROVIDER" )
	{
		echo "<img src='".$sensimg."'>";
	}
}
else
{
	echo "发布人";
}
echo "\t\t\t</td>\r\n\t\t\t<td nowrap ><a href=\"";
echo $sufurl;
echo "&order=NEWS_TIME\">发布时间</a>";
if ( $_REQUEST['order'] == "NEWS_TIME" )
{
	echo "<img src='".$sensimg."'>";
}
echo "\t\t\t</td>\r\n\t\t\t<td nowrap ><a href=\"";
echo $sufurl;
echo "&order=CLICK_COUNT\">浏览量</a>";
if ( $_REQUEST['order'] == "CLICK_COUNT" )
{
	echo "<img src='".$sensimg."'>";
}
echo "\t\t\t</td>\r\n\t\t\t<td nowrap>评论数\r\n\t\t\t</td>\r\n\t\t\t<td nowrap>操作\r\n\t\t\t</td>\r\n  \t\t</tr>\r\n\t\t";
if ( $_REQUEST['search'] != "1" )
{
	if ( $LOGIN_USER_ID == "admin" )
	{
		$query = "SELECT * from NEWS ";
	}
	else
	{
		$query = "SELECT * from NEWS where PROVIDER='{$LOGIN_USER_ID}'";
	}
}
else
{
	if ( $_REQUEST['news_txt'] != "" && $WHERE_STR == "" )
	{
		$WHERE_STR .= " where SUBJECT like '%".$_REQUEST['news_txt']."%' OR CONTENT like '%".$_REQUEST['news_txt']."%'";
	}
	if ( $_REQUEST['public'] != NULL )
	{
		if ( $WHERE_STR == "" )
		{
			$WHERE_STR .= " where PUBLIC=".$_REQUEST['public']."";
		}
		else
		{
			$WHERE_STR .= " and PUBLIC=".$_REQUEST['public']."";
		}
	}
	if ( $_REQUEST['putip'] != NULL )
	{
		if ( $WHERE_STR == "" )
		{
			$WHERE_STR .= " where PUTIP=".$_REQUEST['putip']."";
		}
		else
		{
			$WHERE_STR .= " and PUTIP=".$_REQUEST['putip']."";
		}
	}
	if ( $_REQUEST['date_start'] != NULL )
	{
		if ( $WHERE_STR == "" )
		{
			$WHERE_STR .= " where to_days(NEWS_TIME)>=to_days('".$_REQUEST['date_start']."')";
		}
		else
		{
			$WHERE_STR .= " and to_days(NEWS_TIME)>=to_days('".$_REQUEST['date_start']."')";
		}
	}
	if ( $_REQUEST['date_end'] != NULL )
	{
		if ( $WHERE_STR == "" )
		{
			$WHERE_STR .= " where to_days(NEWS_TIME)<=to_days('".$_REQUEST['date_end']."')";
		}
		else
		{
			$WHERE_STR .= " and to_days(NEWS_TIME)<=to_days('".$_REQUEST['date_end']."')";
		}
	}
	if ( $_REQUEST['click_count'] != NULL )
	{
		if ( $WHERE_STR == "" )
		{
			$WHERE_STR .= " where click_count>=".$_REQUEST['click_count']."";
		}
		else
		{
			$WHERE_STR .= " and click_count>=".$_REQUEST['click_count']."";
		}
12 下一页
⌨️ 快捷键说明

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