📄 index.php
字号:
<?
include_once("inc/auth.php");
?>
<html>
<head>
<title>会议查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<SCRIPT language=javascript>
function LoadWindow()
{
URL="/module/user_select_single";
loc_x=document.body.scrollLeft+event.clientX-event.offsetX-100;
loc_y=document.body.scrollTop+event.clientY-event.offsetY+200;
window.showModalDialog(URL,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:350px;dialogHeight:350px;dialogTop:"+loc_y+"px;dialogLeft:"+loc_x+"px");
}
function td_calendar(fieldname)
{
myleft=document.body.scrollLeft+event.clientX-event.offsetX-80;
mytop=document.body.scrollTop+event.clientY-event.offsetY+140;
window.showModalDialog("/inc/calendar.php?FIELDNAME="+fieldname,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:280px;dialogHeight:215px;dialogTop:"+mytop+"px;dialogLeft:"+myleft+"px");
}
</SCRIPT>
</head>
<body class="bodycolor" topmargin="5">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small" align="center">
<tr>
<td class="Big"><img src="/images/menu/infofind.gif" align="absmiddle" width="22" height="18"><span class="big3"> 会议查询</span></td>
</tr>
</table><br>
<table border="0" width="400" cellpadding="3" cellspacing="1" align="center" bgcolor="#000000" class="small">
<form enctype="multipart/form-data" action="search.php" method="post" name="form1">
<tr class="TableLine1">
<td nowrap>名称：</td>
<td nowrap><INPUT type=text name="M_NAME" size=34 class=BigInput></td>
</tr>
<tr class="TableLine2">
<td nowrap>申请人：</td>
<td nowrap>
<input type="text" name="TO_NAME" size="10" class="BigStatic" readonly>
<input type="button" value="选 择" class="SmallButton" onClick="LoadWindow()" title="选择申请人" name="button">
<input type="hidden" name="TO_ID" value="">
</td>
</tr>
<?
$CUR_TIME=date("Y-m-d H:i:s",time());
$query = "SELECT * from MEETING where M_STATUS=1";
$cursor= exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))
{
$M_ID3=$ROW["M_ID"];
$M_START3=$ROW["M_START"];
if($CUR_TIME>=$M_START3)
{
exequery($connection,"UPDATE MEETING SET M_STATUS= '2' WHERE M_ID=$M_ID3");
}
}
$BEGIN_DATE=date("Y-m-01",time());
$CUR_DATE=date("Y-m-d",time());
?>
<tr class="TableLine1">
<td nowrap>开始时间：</td>
<td nowrap>
从 <INPUT type=text name="M_START_B" size=10 class=SmallInput value="<?=$BEGIN_DATE?>"><img src="/images/menu/calendar.gif" align="absmiddle" border="0" style="cursor:hand" onclick="td_calendar('form1.M_START_B');">
至 <INPUT type=text name="M_END_B" size=10 class=SmallInput value="<?=$CUR_DATE?>"><img src="/images/menu/calendar.gif" align="absmiddle" border="0" style="cursor:hand" onclick="td_calendar('form1.M_END_B');"></td>
</tr>
<tr class="TableLine2">
<td nowrap>会议室：</td>
<td nowrap>
<select name="M_ROOM" class="SmallSelect">
<option value="" selected>全部</option>
<?
$query = "SELECT * from MEETING_ROOM";
$cursor= exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))
{
$MR_ID=$ROW["MR_ID"];
$MR_NAME=$ROW["MR_NAME"];
?>
<option value="<?=$MR_ID?>" <? if($M_ROOM==$MR_ID) echo "selected";?>><?=$MR_NAME?></option>
<?
}
?>
</select></td>
</tr>
<tr class="TableLine1">
<td nowrap>会议状态：</td>
<td nowrap>
<select name="M_STATUS" class="SmallSelect">
<option value="" selected>全部</option>
<option value="0">待批</option>
<option value="1">已准</option>
<option value="2">进行中</option>
<option value="3">未准</option>
<option value="4">已结束</option>
</select></td>
</tr>
<tr class="TableControl">
<td colspan="9" align="center">
<input type="submit" value="查询" class="BigButton">
</td>
</tr>
</form>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -