📄 meeting_detail.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">
</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/meeting.gif" width="17" height="17"><span class="big3"> 会议详细信息</span><br>
</td>
</tr>
</table>
<br>
<?
$query = "SELECT * from MEETING where M_ID='$M_ID'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$MEETING_COUNT++;
$M_ID=$ROW["M_ID"];
$M_NAME=$ROW["M_NAME"];
$M_TOPIC=$ROW["M_TOPIC"];
$M_DESC=$ROW["M_DESC"];
$M_PROPOSER=$ROW["M_PROPOSER"];
$M_REQUEST_TIME=$ROW["M_REQUEST_TIME"];
$M_ATTENDEE_OUT =$ROW["M_ATTENDEE_OUT"];
$M_ATTENDEE_NOT =$ROW["M_ATTENDEE_NOT"];
$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"];
$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";
$query = "SELECT * from MEETING_ROOM where MR_ID=$M_ROOM";
$cursor1= exequery($connection,$query);
if($ROW1=mysql_fetch_array($cursor1))
$M_ROOM_NAME=$ROW1["MR_NAME"];
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="未批准";
elseif($M_STATUS==4)
$M_STATUS_DESC="已结束";
$query = "SELECT * from USER where USER_ID='$M_PROPOSER'or USER_ID='$M_MANAGER'";
$cursor2= exequery($connection,$query);
if($ROW2=mysql_fetch_array($cursor2))
$USER_NAME=$ROW2["USER_NAME"];
$query = "SELECT * from USER where USER_ID='$M_MANAGER'";
$cursor2= exequery($connection,$query);
if($ROW2=mysql_fetch_array($cursor2))
$USER_NAME2=$ROW2["USER_NAME"];
?>
<table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3">
<tr class="TableLine1">
<td nowrap align="left" width="80" class="TableContent">会议编号：</td>
<td nowrap align="left" class="TableData"><?=$M_ID?></td>
</tr>
<tr class="TableLine2">
<td nowrap align="left" width="80" class="TableContent">会议名称：</td>
<td nowrap align="left" class="TableData"><?=$M_NAME?></td>
</tr>
<tr class="TableLine1">
<td nowrap align="left" width="80" class="TableContent">会议主题：</td>
<td nowrap align="left" class="TableData"><?=$M_TOPIC?></td>
</tr>
<tr class="TableLine2">
<td nowrap align="left" width="80" class="TableContent">会议描述：</td>
<td nowrap align="left" class="TableData"><?=$M_DESC?></td>
</tr>
<tr class="TableLine1">
<td nowrap align="left" width="80" class="TableContent">申请人：</td>
<td nowrap align="left" class="TableData"><?=$USER_NAME?></td>
</tr>
<tr class="TableLine2">
<td nowrap align="left" width="80" class="TableContent">申请时间：</td>
<td nowrap align="left" class="TableData"><?=$M_REQUEST_TIME?></td>
</tr>
<tr class="TableLine1">
<td nowrap align="left" width="80" class="TableContent">出席人员：</td>
<td align="left" class="TableData"><?=$M_ATTENDEE_NAME?></td>
</tr>
<tr class="TableLine2">
<td nowrap align="left" width="80" class="TableContent">开始时间：</td>
<td nowrap align="left" class="TableData"><?=$M_START?></td>
</tr>
<tr class="TableLine1">
<td nowrap align="left" width="80" class="TableContent">结束时间：</td>
<td nowrap align="left" class="TableData"><?=$M_END?></td>
</tr>
<tr class="TableLine2">
<td nowrap align="left" width="80" class="TableContent">会议室：</td>
<td nowrap align="left" class="TableData"><?=$M_ROOM_NAME?></td>
</tr>
<tr class="TableLine2">
<td nowrap align="left" width="80" class="TableContent">会议室管<br>理员：</td>
<td nowrap align="left" class="TableData"><?=$USER_NAME2?></td>
</tr>
<tr class="TableLine1">
<td nowrap align="left" width="80" class="TableContent">状态：</td>
<td nowrap align="left" class="TableData"><?=$M_STATUS_DESC?></td>
</tr>
<?
if($M_STATUS==2 or $M_STATUS==4)
{
?>
<tr class="TableLine2">
<td nowrap align="left" width="80" class="TableContent">缺席人员：</td>
<td nowrap align="left" class="TableData"><?=$M_ATTENDEE_NOT?></td>
</tr>
<?
}
?>
<tr align="center" class="TableControl">
<td colspan="2">
<input type="button" value="打印" class="BigButton" onclick="document.execCommand('Print');" title="直接打印表格页面">
<input type="button" value="关闭" class="BigButton" onClick="window.close();" title="关闭窗口">
</td>
</tr>
</table>
<?
}
else
Message("","无未找到相应记录！");
?>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -