⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 index.php

📁 极限网络智能办公系统 Office Automation V3.0官方100％源代码.
💻 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>
function delete_mr(MR_ID)
{
 msg='确认要删除该会议室么？';
 if(window.confirm(msg))
 {
    URL="delete.php?MR_ID=" + MR_ID;
    window.location=URL;
 }
}

function delete_all()
{
 msg='确认要删除所有会议室么？';
 if(window.confirm(msg))
 {
    URL="delete_all.php";
    window.location=URL;
 }
}
</script>
</head>

<body class="bodycolor" topmargin="5">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/notify_new.gif" align="absmiddle"><span class="big3"> 新建会议室</span>
    </td>
  </tr>
</table>
<div align="center">
  <input type="button"  value="新建会议室" class="BigButton" onClick="location='new_room.php';" title="新建会议室，并添加基本信息">
</div>
<br>

<?
$query = "SELECT count(*) from MEETING_ROOM";
$cursor= exequery($connection,$query);
$ROOM_COUNT=0;
if($ROW=mysql_fetch_array($cursor))
   $ROOM_COUNT=$ROW[0];

if($ROOM_COUNT==0)
{
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/notify_open.gif" align="absmiddle"><span class="big3"> 管理会议室</span>
    </td>
  </tr>
</table>
<?
Message("","无定义的会议室");
exit;
}
?>

<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/notify_open.gif" align="absmiddle"><span class="big3"> 管理会议室</span>
    </td>

    <td valign="bottom" class="small1">共<span class="big4">&nbsp;<?=$ROOM_COUNT?></span>&nbsp;个会议室
    </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 align="center">设备情况</td>
    <td nowrap align="center">所在地点</td>
    <td align="center">会议室描述</td>
    <td nowrap align="center">操作</td>
  </tr>

<?
//============================ 显示已发布公告 =======================================
$query = "SELECT * from MEETING_ROOM";
$cursor= exequery($connection,$query);
$ROOM_COUNT=0;
while($ROW=mysql_fetch_array($cursor))
{
   $ROOM_COUNT++;

   $MR_ID=$ROW["MR_ID"];
   $MR_NAME=$ROW["MR_NAME"];
   $MR_CAPACITY=$ROW["MR_CAPACITY"];
   $MR_DEVICE=$ROW["MR_DEVICE"];
   $MR_DESC=$ROW["MR_DESC"];
   $MR_PLACE=$ROW["MR_PLACE"];

   if($ROOM_COUNT%2==1)
      $TableLine="TableLine1";
   else
      $TableLine="TableLine2";
?>

   <tr class="<?=$TableLine?>">
     <td nowrap align="center"><?=$MR_NAME?></td>
     <td nowrap align="center"><?=$MR_CAPACITY?></a></td>
     <td align="center"><?=$MR_DEVICE?></a></td>
     <td align="center"><?=$MR_PLACE?></td>
     <td align="center"><?=$MR_DESC?></td>
     <td nowrap align="center">
     <a href="new_room.php?MR_ID=<?=$MR_ID?>"> 修改</a>&nbsp;&nbsp;&nbsp;
     <a href="javascript:delete_mr('<?=$MR_ID?>');"> 删除</a>
     </td>
   </tr>
<?
}//while
?>
<tr class="TableControl">
 <td colspan="8" align="center">
    <input type="button"  value="全部删除" class="SmallButton" onClick="delete_all()" title="删除所有会议室">
 </td>
</tr>
</table>
</body>

</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -