📄 query.php

📁 泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。
💻 PHP
字号:
<?php

include_once( "inc/auth.php" );
include_once( "inc/utility.php" );
echo "\r\n<html>\r\n<head>\r\n<title>会议室预定情况</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n</head>\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"1\"  cellpadding=\"0\">\r\n  <tr class=\"tablehead1\">\r\n    <td><img src=\"/images/manage/meeting.gif\" align=\"absmiddle\"> 会议室预订情况</td>\r\n  </tr>\r\n  <tr class=\"tablehead2\">\r\n    <td><input name=\"image2\" type";
echo "=\"image\" src=\"../../../../images/button/return.gif\"  onClick=\"location='index.php';\" width=\"105\" height=\"20\" border=\"0\"></td>\r\n  </tr>\r\n</table>\r\n";
$query = "SELECT * from MEETING_ROOM where MR_ID={$MR_ID}";
$cursor1 = exequery( $connection, $query );
if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
{
	$MR_NAME = $ROW1['MR_NAME'];
}
echo "<table width=\"95%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n <tr>\r\n  <td width=\"100%\">\r\n";
message( "", "会议室预定情况 —— ".$MR_NAME );
echo "  </td>\r\n  </tr>\r\n  <tr>\r\n   <td background=\"/images/dian1.gif\" width=\"100%\" height=\"3\"></td>\r\n </tr>\r\n</table>\r\n<br>\r\n";
$M_STATUS = 2;
for ( ;	0 <= $M_STATUS;	--$M_STATUS	)
{
	if ( $M_STATUS == 0 )
	{
		$M_STATUS_DESC = "待批";
	}
	else if ( $M_STATUS == 1 )
	{
		$M_STATUS_DESC = "已准";
	}
	else if ( $M_STATUS == 2 )
	{
		$M_STATUS_DESC = "进行中";
	}
	$connection = openconnection( );
	$query = "SELECT count(*) from MEETING where M_STATUS={$M_STATUS} and M_ROOM='{$MR_ID}'";
	$cursor = exequery( $connection, $query );
	$MEETING_COUNT = 0;
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$MEETING_COUNT = $ROW[0];
	}
	if ( $MEETING_COUNT == 0 )
	{
		echo $M_STATUS_DESC;
		echo "会议列表\r\n<hr width=\"95%\" height=\"1\" align=\"left\" color=\"#FFFFFF\">\r\n";
		message( "", "无".$M_STATUS_DESC."的会议" );
		echo "<br><br>";
	}
	else
	{
		echo "\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n  <tr>\r\n    <td>";
		echo $M_STATUS_DESC;
		echo "会议列表\r\n    </td>\r\n\r\n    <td valign=\"bottom\">共";
		echo "<s";
		echo "pan class=\"big4\">&nbsp;";
		echo $MEETING_COUNT;
		echo "</span>&nbsp;条会议记录\r\n    </td>\r\n  </tr>\r\n</table>\r\n\r\n<hr width=\"95%\" height=\"1\" align=\"left\" color=\"#FFFFFF\">\r\n\r\n<table border=\"0\" cellspacing=\"1\" width=\"95%\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\">\r\n  <tr class=\"TableHeader\">\r\n      <td nowrap >会议名称</td>\r\n      <td nowrap >会议主题</td>\r\n      <td nowrap >会议描述</td>\r\n      <td nowrap >申请人</td>\r\n      <td nowrap >申请时间</td>\r\n      <td nowr";
		echo "ap >出席人员</td>\r\n      <td nowrap >开始时间</td>\r\n      <td nowrap >结束时间</td>\r\n      <td nowrap >会议室</td>\r\n</tr>\r\n\r\n";
		$query = "SELECT * from MEETING where M_STATUS={$M_STATUS} and M_ROOM='{$MR_ID}'";
		$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_DESC = $ROW['M_DESC'];
			$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'];
			if ( $MEETING_COUNT % 2 == 1 )
			{
				$TableLine = "TableLine1";
			}
			else
			{
				$TableLine = "TableLine2";
			}
			echo "    <tr class=\"";
			echo $TableLine;
			echo "\">\r\n      <td >";
			echo $M_NAME;
			echo "</td>\r\n      <td >";
			echo $M_TOPIC;
			echo "</a></td>\r\n      <td >";
			echo $M_DESC;
			echo "</a></td>\r\n      <td nowrap >";
			echo $M_PROPOSER;
			echo "</td>\r\n      <td nowrap >";
			echo $M_REQUEST_TIME;
			echo "</td>\r\n      <td >";
			echo $M_ATTENDEE;
			echo "</td>\r\n      <td nowrap >";
			echo $M_START;
			echo "</a></td>\r\n      <td nowrap >";
			echo $M_END;
			echo "</a></td>\r\n      <td nowrap >";
			echo $MR_NAME;
			echo "</td>\r\n    </tr>\r\n";
		}
		echo "</table>";
		echo "<br><br>";
	}
}
echo "</body>\r\n\r\n</html>\r\n";
?>
⌨️ 快捷键说明

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