📄 prearrange.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
echo "\r\n<HTML>\r\n<HEAD>\r\n<TITLE>预约情况</TITLE>\r\n</HEAD>\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/menu/meeting.gif\" HEIGHT=\"20\" width=\"20\" align=\"absmiddle\"><span class=\"big3\"> 会议预约情况图表</span>\r\n </td>\r\n </tr>\r\n</table>\t\r\n<table class=small>\r\n\t<tr>\r\n\t\t<td>图例说明：</td>\r\n\t\t<td width=20 bgColor=\"#378CD9\"></td>\r\n\t\t<td width=40>空闲</td>\r\n\t\t<td width=20 bgColor=\"#ff33ff\"></td>\r\n\t\t<td width=40>待批</td>\r\n\t\t<td width=20 bgColor=\"#00ff00\"></td>\r\n\t\t<td width=40>已准</td>\r\n\t\t<td width=20 bgColor=\"#ff0000\"></td>\r\n\t\t<td width=80>进行中</td>\r\n\t</tr>\r\n</table>\r\n\r\n<table border=\"0\" width=\"100%\" cellpadding=\"3\" cellspacing=\"1\" bgcolor=\"#000000\" class=\"small\" align=\"center\">\r\n<tr class=TableHeader>\r\n\t<td width=\"10%\" align=\"center\" nowrap>未来七天</td>\r\n";
$query = "SELECT * from MEETING_ROOM";
$cursor = exequery( $connection, $query );
$ROOM_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$ROOM_COUNT;
$MR_ID_ARRAY[] = $MR_ID = $ROW['MR_ID'];
$MR_NAME = $ROW['MR_NAME'];
echo "\t\r\n\t<td align=\"center\" nowrap>";
echo $MR_NAME;
echo "</td>\r\n";
}
echo "</tr>\r\n\r\n";
$CUR_TIME = date( "Y-m-d H:i:s", time( ) );
$I = 0;
for ( ; $I < 7; ++$I )
{
$PRE_DATE = time( ) + $I * 24 * 3600;
$PRE_DATE = date( "Y-m-d", $PRE_DATE );
$PRE_DATE_START = $PRE_DATE." 00:00:00";
$PRE_DATE_END = $PRE_DATE." 23:59:59";
$PRE_DATE_DESC = substr( $PRE_DATE, 5 );
$WEEK_DAY = substr( $PRE_DATE, 5, 10 )."(周".get_week( $PRE_DATE ).")";
echo "<tr class=\"TableData\">\r\n\t<td width=\"10%\" align=\"center\" height=\"30\" nowrap>";
echo $WEEK_DAY;
echo "</td>\r\n";
$J = 0;
for ( ; $J < $ROOM_COUNT; ++$J )
{
$query = "select * from MEETING where M_ROOM='".$MR_ID_ARRAY[$J]."' and M_STATUS!=4 and M_STATUS!=3 and ((M_START>'{$PRE_DATE_START}'and M_START<'{$PRE_DATE_END}') or (M_END>'{$PRE_DATE_START}' and M_END<'{$PRE_DATE_END}') or (M_START <'{$PRE_DATE_START}' and M_END>'{$PRE_DATE_END}')) order by M_START";
$cursor = exequery( $connection, $query );
$COUNT = 0;
$HTML_STR = "<table border=0 width=100% height=100%><tr>";
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$COUNT;
$M_STATUS = $ROW['M_STATUS'];
$M_PROPOSER = $ROW['M_PROPOSER'];
$query1 = "select USER_NAME from USER where USER_ID='".$M_PROPOSER."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
{
$USER_NAME = $ROW1['USER_NAME'];
}
if ( $M_STATUS == 0 )
{
$bgColor1 = "ff33ff";
}
if ( $M_STATUS == 1 )
{
$bgColor1 = "00ff00";
}
if ( $M_STATUS == 2 )
{
$bgColor1 = "ff0000";
}
$M_START = $ROW['M_START'];
$M_END = $ROW['M_END'];
$COUNT_DATE = round( ( strtotime( $M_END ) - strtotime( $M_START ) ) / 86400 * 1000 ) / 1000;
if ( 0 < $COUNT_DATE && $COUNT_DATE < 1 )
{
$COUNT_DATE = 1;
}
else
{
$COUNT_DATE += 1;
}
if ( $COUNT_DATE == 1 )
{
$TIME_STR = substr( $M_START, 11, 5 )."-<BR>".substr( $M_END, 11, 5 );
}
else if ( $PRE_DATE == substr( $M_END, 0, 10 ) )
{
$TIME_STR = "08:00-<BR>".substr( $M_END, 11, 5 );
}
else if ( $PRE_DATE == substr( $M_START, 0, 10 ) )
{
$TIME_STR = substr( $M_START, 11, 5 )."-<BR>17:00";
}
else
{
$TIME_STR = "08:00-<BR>17:00";
}
$TIME_STR1 = substr( $M_START, 5, 11 )." 至 ".substr( $M_END, 5, 11 );
$HTML_STR .= "<td title='".$TIME_STR1." 申请人：".$USER_NAME."' bgColor=#".$bgColor1." width='40'><font size=2>".$TIME_STR."</font></td>";
}
if ( $COUNT == 0 )
{
echo "<td align=\"center\" bgColor=\"#378CD9\"> </td>";
}
else
{
echo "<td align=\"center\">".$HTML_STR."<td width='".$COUNT1."%' bgColor=\"#FFFFFF\"> </td></tr></table></td>";
}
}
echo "</tr>\t\r\n";
}
echo "<tr class=TableControl>\r\n\t<td colspan=100 align=center>\r\n\t\t<input type=\"button\" value=\"关 闭\" class=\"BigButton\" onclick=\"window.close()\">\r\n </td>\r\n</tr>\r\n</table>\r\n\r\n</body>\r\n</HTML>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -