📄 index.php
字号:
<?
include_once 'inc/auth.php';
echo '
<html>
<head>
<title>会议查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
echo '<S';
echo 'CRIPT 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");
}
f';
echo 'unction 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>
';
echo '
<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">';
echo '<s';
echo 'pan 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="TableLine';
echo '2">
<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 (($M_START3 <= $CUR_TIME))
{
exequery ($connection, ((''.'UPDATE MEETING SET M_STATUS= \'2\' WHERE M_ID=').$M_ID3));
continue;
}
}
$query = 'SELECT * from MEETING where M_STATUS=2';
$cursor = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor))
{
$M_ID3 = $ROW['M_ID'];
$M_END3 = $ROW['M_END'];
if (($M_END3 <= $CUR_TIME))
{
exequery ($connection, ((''.'UPDATE MEETING SET M_STATUS= \'4\' WHERE M_ID=').$M_ID3));
continue;
}
}
$BEGIN_DATE = date ('Y-m-01', time ());
$CUR_DATE = date ('Y-m-d', time ());
echo ' <tr class="TableLine1">
<td nowrap>开始时间：</td>
<td nowrap>
从 <INPUT type=text name="M_START_B" size=10 class=SmallInput value="';
echo $BEGIN_DATE;
echo '"><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="';
echo $CUR_DATE;
echo '"><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>
';
echo '<s';
echo 'elect 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'];
echo ' <option value="';
echo $MR_ID;
echo '" ';
if (($M_ROOM == $MR_ID))
{
echo 'selected';
}
echo '>';
echo $MR_NAME;
echo '</option>
';
}
echo ' </select></td>
</tr>
<tr class="TableLine1">
<td nowrap>会议状态：</td>
<td nowrap>
';
echo '<s';
echo 'elect 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="BigBut';
echo 'ton">
</td>
</tr>
</form>
</table>
</body>
</html>';
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -