prearrange.php

来自「通达OA2007SE源代码非常好的」· PHP 代码 · 共 118 行

PHP

118 行

<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  echo '
<HTML>
<HEAD>
<TITLE>预约情况</TITLE>
</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" HEIGHT="20" width="20" align="absmiddle">';
  echo '<s';
  echo 'pan class="big3"> 会议预约情况图表</span>
    </td>
  </tr>
</table>	
<table class=small>
	<tr>
		<td><font color="#FFFFFF">图例说明：</font></td>
		<td width=20 bgColor="#378CD9"></td>
		<td width=40><font color="#FFFFFF">空闲</font></td>
		<td width=20 bgColor="#ff33ff"></td>
		<td width=40><font color="#FFFFFF">待批</font></td>
		<td width=20 bgColor="#00ff00"></td>
		<td width=40><font color="#FFFFFF">已准</';
  echo 'font></td>
		<td width=20 bgColor="#ff0000"></td>
		<td width=80><font color="#FFFFFF">进行中</font></td>
	</tr>
</table>
<table border="0" width="100%" cellpadding="3" cellspacing="1" bgcolor="#000000" class="small" align="center">
<tr class=TableHeader>
	<td width="10%" align="center">未来七天</td>
';
  $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 '	
	<td width="20%" align="center">';
    echo $MR_NAME;
    echo '</td>
';
  }
  echo '</tr>
';
  $CUR_TIME = date ('Y-m-d H:i:s', time ());
  for ($I = 0; ($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">
	<td width="10%" align="center" height="30">';
    echo $WEEK_DAY;
    echo '</td>
';
    for ($J = 0; ($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).'\'))');
      $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'];
        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'];
        $TIME_STR = ((substr ($M_START, 11, 5).'-<BR>').substr ($M_END, 11, 5));
        $TIME_STR1 = ((substr ($M_START, 5, 11).' 至 ').substr ($M_END, 5, 11));
        ($HTML_STR .= (((((('<td title=\''.$TIME_STR1).'\' bgColor=#').$bgColor1).' width=\'20%\'>').$TIME_STR).'</td>'));
      }
      if (($COUNT == 0))
      {
        echo '<td width="20%" align="center" bgColor="#378CD9">&nbsp;</td>';
        continue;
      }
      else
      {
        echo (((('<td width="20%" align="center">'.$HTML_STR).'<td width=\'').$COUNT1).'%\'  bgColor="#FFFFFF">&nbsp;</td></tr></table></td>');
        continue;
      }
    }
    echo '</tr>	
';
  }
  echo '<tr class=TableControl>
	<td colspan=100 align=center>
		<input type="button" value="关 闭" class="BigButton" onclick="window.close()">
  </td>
</tr>
</table>
</body>
</HTML>
';
?>

prearrange.php - 源码说明

本页面展示了「通达OA2007SE源代码非常好的」中的 prearrange.php 源码文件，采用 PHP 编程语言编写，共 118 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与2007相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C

搜索代码Ctrl + F

全屏模式F11

增大字号Ctrl + =

减小字号Ctrl + -

显示快捷键?