index.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 154 行
PHP
154 行
<?
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
echo '
<html>
<head>
<title>会议室设置</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
echo '<s';
echo 'cript>
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" w';
echo 'idth="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/notify_new.gif" align="absmiddle">';
echo '<s';
echo 'pan 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))
{
echo '<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/notify_open.gif" align="absmiddle">';
echo '<s';
echo 'pan class="big3"> 管理会议室</span>
</td>
</tr>
</table>
';
message ('', '无定义的会议室');
exit ();
}
echo '
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/notify_open.gif" align="absmiddle">';
echo '<s';
echo 'pan class="big3"> 管理会议室</span>
</td>
<td valign="bottom" class="small1">共';
echo '<s';
echo 'pan class="big4"> ';
echo $ROOM_COUNT;
echo '</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 align="center">设备情况</td>
<td nowrap align="center">所在地点</td>
<td align="center">会议室描述</td>
<td nowrap align="center"';
echo '>操作</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';
}
echo '
<tr class="';
echo $TableLine;
echo '">
<td nowrap align="center">';
echo $MR_NAME;
echo '</td>
<td nowrap align="center">';
echo $MR_CAPACITY;
echo '</a></td>
<td align="center">';
echo $MR_DEVICE;
echo '</a></td>
<td align="center">';
echo $MR_PLACE;
echo '</td>
<td align="center">';
echo $MR_DESC;
echo '</td>
<td nowrap align="center">
<a href="new_room.php?MR_ID=';
echo $MR_ID;
echo '"> 修改</a>
<a href="javascript:delete_mr(\'';
echo $MR_ID;
echo '\');"> 删除</a>
</td>
</tr>
';
}
echo '<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 + =
减小字号Ctrl + -
显示快捷键?