📄 query.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
include_once("inc/utility.php");
?>
<html>
<head>
<title>会议申请</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script>
window.setTimeout('this.location.reload();',40000);
function delete_meeting(M_ID,M_STATUS)
{
msg='确认要删除该会议么？';
if(window.confirm(msg))
{
URL="delete.php?M_ID=" + M_ID + "&M_STATUS=" + M_STATUS;
window.location=URL;
}
}
function confirm_end(M_ID)
{
msg='确认要结束该会议么？';
if(window.confirm(msg))
{
URL="checkup.php?M_ID=" + M_ID + "&M_STATUS=" + 4;
window.location=URL;
}
}
</script>
</head>
<body class="bodycolor" topmargin="5">
<?
$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");}
}
if($M_STATUS==0)
$M_STATUS_DESC="待批会议";
elseif($M_STATUS==1)
$M_STATUS_DESC="已准会议";
elseif($M_STATUS==2)
$M_STATUS_DESC="进行中会议";
elseif($M_STATUS==3)
$M_STATUS_DESC="未批准会议";
$query = "SELECT count(*) from MEETING where M_STATUS='$M_STATUS' and M_PROPOSER='$LOGIN_USER_ID'";
$cursor= exequery($connection,$query);
$MEETING_COUNT=0;
if($ROW=mysql_fetch_array($cursor))
$MEETING_COUNT=$ROW[0];
if($MEETING_COUNT==0)
{
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/meeting.gif" width="22" height="18"><span class="big3"> <?=$M_STATUS_DESC?></span>
</td>
</tr>
</table>
<?
Message("","无".$M_STATUS_DESC);
exit;
}
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/meeting.gif" width="22" height="18"><span class="big3"> <?=$M_STATUS_DESC?></span>
</td>
<td valign="bottom" class="small1">共<span class="big4"> <?=$MEETING_COUNT?></span> 条会议记录
</td>
</tr>
</table>
<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">开始时间</td>
<td align="center">结束时间</td>
<td nowrap align="center">会议室</td>
<td nowrap align="center">操作</td>
</tr>
<?
//============================ 显示会议情况 =======================================
$query = "SELECT * from MEETING,USER where M_STATUS='$M_STATUS' and M_PROPOSER='$LOGIN_USER_ID' and USER_ID='$LOGIN_USER_ID' order by M_STATUS";
$cursor= exequery($connection,$query);
$MEETING_COUNT=0;
while($ROW=mysql_fetch_array($cursor))
{
$MEETING_COUNT++;
$M_ID=$ROW["M_ID"];
$M_NAME=$ROW["M_NAME"];
$M_TOPIC=$ROW["M_TOPIC"];
$M_PROPOSER=$ROW["M_PROPOSER"];
$M_REQUEST_TIME=$ROW["M_REQUEST_TIME"];
$M_ATTENDEE=$ROW["M_ATTENDEE"];
$M_START =$ROW["M_START"];
$M_END=$ROW["M_END"];
$M_ROOM=$ROW["M_ROOM"];
$M_STATUS=$ROW["M_STATUS"];
$M_MANAGER=$ROW["M_MANAGER"];
$M_ATTENDEE_OUT=$ROW["M_ATTENDEE_OUT"];
$query1 = "SELECT * from USER where USER_ID='$M_PROPOSER'";
$cursor1= exequery($connection,$query1);
if($ROW1=mysql_fetch_array($cursor1))
$USER_NAME=$ROW1["USER_NAME"];
$USER_NAME2="";
$TOK=strtok($M_ATTENDEE,",");
while($TOK!="")
{
$query2 = "SELECT * from USER where USER_ID='$TOK'";
$cursor2= exequery($connection,$query2);
if($ROW=mysql_fetch_array($cursor2))
$USER_NAME2.=$ROW["USER_NAME"].",";
$TOK=strtok(",");
}
$USER_NAME2=substr($USER_NAME2,0,-1);
$M_ATTENDEE_NAME="内部：$USER_NAME2 <br>外部：$M_ATTENDEE_OUT";
if($M_START=="0000-00-00 00:00:00")
$M_START="";
if($M_END=="0000-00-00 00:00:00")
$M_END="";
if($MEETING_COUNT%2==1)
$TableLine="TableLine1";
else
$TableLine="TableLine2";
$query = "SELECT * from MEETING_ROOM where MR_ID='$M_ROOM'";
$cursor2= exequery($connection,$query);
if($ROW2=mysql_fetch_array($cursor2))
$M_ROOM_NAME=$ROW2["MR_NAME"];
?>
<tr class="<?=$TableLine?>">
<td nowrap align="center"><?=$M_NAME?></td>
<td align="center"><?=$USER_NAME?></td>
<td align="left"><?=$M_ATTENDEE_NAME?></td>
<td align="center"><?=$M_START?></td>
<td align="center"><?=$M_END?></td>
<td align="center"><?=$M_ROOM_NAME?></td>
<td nowrap align="center">
<a href="javascript:;" onClick="window.open('meeting_detail.php?M_ID=<?=$M_ID?>','','height=400,width=400,status=1,toolbar=no,menubar=no,location=no,scrollbars=auto,left=300,top=150,resizable=yes');">详细信息</a>
<?
if($M_STATUS==2)
{
?>
<a href="javascript:confirm_end('<?=$M_ID?>');"> 结束</a>
<a href="javascript:;" onClick="window.open('../apply/modify.php?M_ID=<?=$M_ID?>','','height=260,width=420,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,left=300,top=150,resizable=no');">修改</a>
<a href="javascript:;" onClick="window.open('../apply/summary.php?M_ID=<?=$M_ID?>','','height=570,width=740,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,left=150,top=80,resizable=yes');">会议纪要</a>
<?
}
if($M_STATUS==0||$M_STATUS==3)
{
echo "<a href=\"new.php?M_ID=$M_ID&FLAG=1\">修改</a> ";
echo "<a href=\"javascript:delete_meeting('$M_ID','$M_STATUS');\">删除</a>";
}
?>
</td>
</tr>
<?
}//while
?>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -