search.php
来自「极限网络智能办公系统 Office Automation V3.0官方100％源」· PHP 代码 · 共 139 行
PHP
139 行
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
include_once("inc/check_type.php");
?>
<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"><span 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) && $LOGIN_USER_PRIV!=1)
continue;
elseif($SUMMARY!='')
{
$COUNT++;
if($COUNT==1)
{
?>
<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)
{
?>
<tr class="<?=$TableLine?>">
<td nowrap align="center"><?=$M_NAME?></td>
<td nowrap align="center"><?=$USER_NAME?></td>
<td nowrap align="center"><?=$M_START?></td>
<td nowrap align="center"><?=$M_END?></td>
<td align="center"><a href="javascript:;" onClick="window.open('show_summary.php?M_ID=<?=$M_ID?>','','height=520,width=650,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,left=180,top=100,resizable=yes');">会议纪要</a> </td>
</tr>
<?
}
}
}//while
if($COUNT==0)
message("提示：","无符合条件的会议纪要！")
?>
</table>
<br><center><input type="button" class="BigButton" value="返回" onclick="history.back();"></center>
</body>
</html>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?