search.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 254 行
PHP
254 行
<?
include_once 'inc/auth.php';
include_once 'inc/check_type.php';
include_once 'inc/utility_all.php';
echo '
<html>
<head>
<title>新闻查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
echo '<s';
echo 'cript>
function open_news(NEWS_ID)
{
URL="/general/news/show/read_news.php?NEWS_ID="+NEWS_ID;
myleft=(screen.availWidth-650)/2;
window.open(URL,"read_news","height=500,width=650,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=100,left="+myleft+",resizable=yes");
}
function delete_news(NEWS_ID,start)
{
msg=\'确认要删除该项新闻么？\';
if(window.confirm(msg))
{
URL="';
echo 'delete.php?NEWS_ID=" + NEWS_ID + "&start=" + start;
window.location=URL;
}
}
function delete_all()
{
msg=\'确认要删除所有新闻么？\';
if(window.confirm(msg))
{
URL="delete_all.php";
window.location=URL;
}
}
function re_news(NEWS_ID)
{
URL="/general/news/show/re_news.php?NEWS_ID="+NEWS_ID+"&MANAGE=1";
myleft=(screen.availWidth-500)/2;
window.open(URL,"read_news","h';
echo 'eight=500,width=550,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=100,left="+myleft+",resizable=yes");
}
</script>
</head>
<body class="bodycolor" topmargin="5">
';
$CUR_DATE = date ('Y-m-d', time ());
if (($SEND_TIME_MIN != ''))
{
$TIME_OK = is_date ($SEND_TIME_MIN);
if (!$TIME_OK)
{
message ('错误', ('"发布日期"的格式不对，应形如 '.$CUR_DATE));
button_back ();
exit ();
}
$SEND_TIME_MIN = ($SEND_TIME_MIN.' 00:00:00');
}
if (($SEND_TIME_MAX != ''))
{
$TIME_OK = is_date ($SEND_TIME_MAX);
if (!$TIME_OK)
{
message ('错误', ('"发布日期"的格式不对，应形如 '.$CUR_DATE));
button_back ();
exit ();
}
$SEND_TIME_MAX = ($SEND_TIME_MAX.' 23:59:59');
}
$CONDITION_STR = '';
if (($SUBJECT != ''))
{
($CONDITION_STR .= ((' and SUBJECT like \'%'.$SUBJECT).'%\''));
}
if (($CONTENT != ''))
{
($CONDITION_STR .= ((' and CONTENT like \'%'.$CONTENT).'%\''));
}
if (($SEND_TIME_MIN != ''))
{
($CONDITION_STR .= (((''.' and NEWS_TIME>=\'').$SEND_TIME_MIN).'\''));
}
if (($SEND_TIME_MAX != ''))
{
($CONDITION_STR .= (((''.' and NEWS_TIME<=\'').$SEND_TIME_MAX).'\''));
}
if (($CLICK_COUNT_MIN != ''))
{
($CONDITION_STR .= ((''.' and CLICK_COUNT>=').$CLICK_COUNT_MIN));
}
if (($CLICK_COUNT_MAX != ''))
{
($CONDITION_STR .= ((''.' and CLICK_COUNT<=').$CLICK_COUNT_MAX));
}
if (($FORMAT != ''))
{
($CONDITION_STR .= (((''.' and FORMAT=\'').$FORMAT).'\''));
}
if (($TYPE_ID != ''))
{
($CONDITION_STR .= (((''.' and TYPE_ID=\'').$TYPE_ID).'\''));
}
if (($PUBLISH != ''))
{
($CONDITION_STR .= (((''.' and PUBLISH=\'').$PUBLISH).'\''));
}
echo '
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/infofind.gif" width="24" height="24" align="absMiddle">';
echo '<s';
echo 'pan class="big3"> 新闻查询结果</span><br>
</td>
</tr>
</table>
';
if (($LOGIN_USER_PRIV == '1'))
{
$query = 'SELECT NEWS_ID,SUBJECT,PROVIDER,NEWS_TIME,CLICK_COUNT,TYPE_ID,ANONYMITY_YN from NEWS where 1=1';
}
else
{
$query = (((''.'SELECT NEWS_ID,SUBJECT,PROVIDER,NEWS_TIME,CLICK_COUNT,TYPE_ID,ANONYMITY_YN from NEWS where PROVIDER=\'').$LOGIN_USER_ID).'\'');
}
($query .= ($CONDITION_STR.' order by NEWS_TIME desc'));
$cursor = exequery ($connection, $query);
$NEWS_COUNT = 0;
while ($ROW = mysql_fetch_array ($cursor))
{
++$NEWS_COUNT;
$NEWS_ID = $ROW['NEWS_ID'];
$SUBJECT = $ROW['SUBJECT'];
$PROVIDER = $ROW['PROVIDER'];
$NEWS_TIME = $ROW['NEWS_TIME'];
$CLICK_COUNT = $ROW['CLICK_COUNT'];
$TYPE_ID = $ROW['TYPE_ID'];
$ANONYMITY_YN = $ROW['ANONYMITY_YN'];
$SUBJECT = htmlspecialchars ($SUBJECT);
$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'];
}
$TYPE_NAME = get_code_name ($TYPE_ID, 'NEWS');
$DEPT_NAME = dept_long_name ($DEPT_ID);
$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';
}
if (($NEWS_COUNT == 1))
{
echo '<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
<tr class="TableHeader">
<td nowrap align="center">标题</td>
<td nowrap align="center">类型</td>
<td nowrap align="center">发布人</td>
<td nowrap align="center">发布时间 <img border=0 src="/images/arrow_down.gif" width="11" height="10"></td>
<td nowrap align="center">点击次数</td';
echo '>
<td nowrap align="center">评论(条)</td>
<td nowrap align="center">操作</td>
</tr>
';
}
if ((($NEWS_COUNT % 2) == 1))
{
$TableLine = 'TableLine1';
}
else
{
$TableLine = 'TableLine2';
}
echo ' <tr class="';
echo $TableLine;
echo '">
<td align="center">
<a href="javascript:open_news(\'';
echo $NEWS_ID;
echo '\');">';
echo $SUBJECT;
echo '</a>
</td>
<td align="center">';
echo $TYPE_NAME;
echo '</td>
<td nowrap align="center"><u title="部门：';
echo $DEPT_NAME;
echo '" style="cursor:hand">';
echo $PROVIDER_NAME;
echo '</u></td>
<td nowrap align="center">';
echo $NEWS_TIME;
echo '</td>
<td nowrap align="center">';
echo $CLICK_COUNT;
echo '</td>
<td nowrap align="center">';
echo $COMMENT_COUNT;
echo '</td>
<td nowrap align="center">
<a href="modify.php?NEWS_ID=';
echo $NEWS_ID;
echo '&start=';
echo $start;
echo '"> 修改</a>
<a href="javascript:delete_news(\'';
echo $NEWS_ID;
echo '\',\'';
echo $start;
echo '\');"> 删除</a>
';
if (($ANONYMITY_YN != '2'))
{
echo ' <a href="javascript:re_news(\'';
echo $NEWS_ID;
echo '\');"> 管理评论</a>
';
}
echo ' </td>
</tr>
';
}
if (($NEWS_COUNT == 0))
{
message ('', '无符合条件的新闻');
button_back ();
exit ();
}
else
{
echo '</table>
';
button_back ();
}
echo '</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?