search.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 175 行
PHP
175 行
<?
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
include_once 'inc/check_type.php';
echo '
<html>
<head>
<title>查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/infofind.gif" width="22" height="18" align="absMiddle">';
echo '<s';
echo 'pan class="big3"> 查询结果</span><br>
</td>
</tr>
</form>
</table>
';
$CUR_DATE = date ('Y-m-d', time ());
if (($M_START_B != ''))
{
$TIME_OK = is_date ($M_START_B);
if (!$TIME_OK)
{
message ('错误', ('"开始时间"的格式不对，应形如 '.$CUR_DATE));
button_back ();
exit ();
}
}
if (($M_END_B != ''))
{
$TIME_OK = is_date ($M_END_B);
if (!$TIME_OK)
{
message ('错误', ('"开始时间"的格式不对，应形如 '.$CUR_DATE));
button_back ();
exit ();
}
}
if (($M_START_B != ''))
{
$M_START_B = ($M_START_B.' 00:00:00');
}
else
{
$M_START_B = '';
}
if (($M_END_B != ''))
{
$M_END_B = ($M_END_B.' 23:59:59');
}
else
{
$M_START_B = '';
}
$CONDITION_STR = '';
if (($M_NAME != ''))
{
($CONDITION_STR .= ((' and M_NAME like \'%'.$M_NAME).'%\''));
}
if (($TO_ID != ''))
{
($CONDITION_STR .= (((''.' and M_PROPOSER=\'').$TO_ID).'\''));
}
if (($M_START_B != ''))
{
($CONDITION_STR .= (((''.' and M_START>=\'').$M_START_B).'\''));
}
if (($M_END_B != ''))
{
($CONDITION_STR .= (((''.' and M_START<=\'').$M_END_B).'\''));
}
if (($M_ROOM != ''))
{
($CONDITION_STR .= (((''.' and M_ROOM=\'').$M_ROOM).'\''));
}
if (($KEY_WORD1 != ''))
{
($CONDITION_STR .= ((' and SUMMARY like \'%'.$KEY_WORD1).'%\''));
}
if (($KEY_WORD2 != ''))
{
($CONDITION_STR .= ((' and SUMMARY like \'%'.$KEY_WORD2).'%\''));
}
if (($KEY_WORD3 != ''))
{
($CONDITION_STR .= ((' and SUMMARY like \'%'.$KEY_WORD3).'%\''));
}
$COUNT = 0;
$query = (((''.'SELECT * from MEETING where 1=1 ').$CONDITION_STR).' order by M_START desc');
$cursor = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor))
{
$M_ID = $ROW['M_ID'];
$M_PROPOSER = $ROW['M_PROPOSER'];
$M_ATTENDEE = $ROW['M_ATTENDEE'];
$M_NAME = $ROW['M_NAME'];
$M_START = $ROW['M_START'];
$M_END = $ROW['M_END'];
$SUMMARY = $ROW['SUMMARY'];
$READ_PEOPLE_ID = $ROW['READ_PEOPLE_ID'];
$query1 = (((''.'SELECT * from USER where USER_ID=\'').$M_PROPOSER).'\'');
$cursor1 = exequery ($connection, $query1);
if ($ROW1 = mysql_fetch_array ($cursor1))
{
$USER_NAME = $ROW1['USER_NAME'];
}
$M_ATTENDEE = ((($M_ATTENDEE.$M_PROPOSER).',').$READ_PEOPLE_ID);
if ((!find_id ($M_ATTENDEE, $LOGIN_USER_ID) AND ($LOGIN_USER_PRIV != 1)))
{
continue;
}
if (($SUMMARY != ''))
{
++$COUNT;
if (($COUNT == 1))
{
echo ' <table align="center" 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">结束时间</td>
<td align="center">查看纪要</td>
</tr>
';
}
if ((($ROOM_COUNT % 2) == 1))
{
$TableLine = 'TableLine1';
}
else
{
$TableLine = 'TableLine2';
}
if (($COUNT <= 15))
{
echo ' <tr class="';
echo $TableLine;
echo '">
<td nowrap align="center">';
echo $M_NAME;
echo '</td>
<td nowrap align="center">';
echo $USER_NAME;
echo '</td>
<td nowrap align="center">';
echo $M_START;
echo '</td>
<td nowrap align="center">';
echo $M_END;
echo '</td>
<td align="center"><a href="javascript:;" onClick="window.open(\'show_summary.php?M_ID=';
echo $M_ID;
echo '\',\'\',\'height=520,width=650,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,left=180,top=100,resizable=yes\');">会议纪要</a> </td>
</tr>
';
continue;
}
continue;
}
}
if (($COUNT == 0))
{
message ('提示：', '无符合条件的会议纪要！');
}
echo '</table>
<br><center><input type="button" class="BigButton" value="返回" onclick="history.back();"></center>
</body>
</html>';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?