📄 history.php

📁 通达OA2007SE源代码非常好的
💻 PHP
字号:
<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  echo '
<HTML>
<link rel="stylesheet" type="text/css" href="/css/main.css">
<HEAD>
<TITLE>资源申请历史记录</TITLE>
</HEAD>
<body>
';
  $query = (((''.'select * from OA_SOURCE where SOURCEID=\'').$SOURCEID).'\'');
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $SOURCENAME = $ROW['SOURCENAME'];
    $TIME_TITLE = $ROW['TIME_TITLE'];
    $MANAGE_USER = $ROW['MANAGE_USER'];
  }
  if (($TIME_TITLE == ''))
  {
    message ('提示', '未设定资源申请时间段');
    exit ();
  }
  $TIME_ARRAY = explode (',', $TIME_TITLE);
  $ARRAY_COUNT = sizeof ($TIME_ARRAY);
  if (($TIME_ARRAY[($ARRAY_COUNT - 1)] == ''))
  {
    --$ARRAY_COUNT;
  }
  if (!find_id ($MANAGE_USER, $LOGIN_USER_ID))
  {
    message ('', '无权查看历史记录');
    exit ();
  }
  echo '
<table class=small>
	<tr>
		<td><b>图例说明：</b></td>
		<td width=20 bgColor="#00ff00"></td>
		<td width=40>申请</td>
		<td width=20 bgColor="#ff33ff""></td>
		<td width=40>撤销</td>
		<td width=20 bgColor="#ff0000"></td>
		<td width=60>他人申请</td>
		<td width=20 bgColor="#0000ff"></td>
		<td width=60>本人申请</td>
	</tr>
</table>
<form name=form1 action="submit.php" method=post>
<table class=small bor';
  echo 'der="0" cellspacing="1" cellpadding="1" bgcolor="#000000">
<tr class=TableHeader>
	<td colspan=100 height=30>';
  echo date ('Y', time ());
  echo '年度资源申请历史记录：
		';
  echo $SOURCENAME;
  echo '</td>
</tr>
';
  $CUR_DATE = date ('Y-m-d', time ());
  $CUR_YEAR = date ('Y-01-01', time ());
  $I = 0;
  $query = (((((''.'select * from OA_SOURCE_USED where SOURCEID=\'').$SOURCEID).'\' and APPLY_DATE>=\'').$CUR_YEAR).'\'');
  $cursor = exequery ($connection, $query);
  while ($ROW = mysql_fetch_array ($cursor))
  {
    ++$I;
    if ((($I % 2) == 1))
    {
      $TableLine = 'TableData';
    }
    else
    {
      $TableLine = 'TableContent';
    }
    $APPLY_DATE = $ROW['APPLY_DATE'];
    $USER_ID = $ROW['USER_ID'];
    $APPLY_DATE_DESC = substr ($APPLY_DATE, 5);
    $WEEK_DAY = ('周'.get_week ($APPLY_DATE));
    $USER_ARRAY = explode (',', $USER_ID);
    echo '
<tr class="';
    echo $TableLine;
    echo '" height="35">
  <td nowrap><b>';
    echo $APPLY_DATE_DESC;
    echo '<br>';
    echo $WEEK_DAY;
    echo '</b></td>
';
    for ($J = 0; ($J < $ARRAY_COUNT); ++$J)
    {
      if ((($USER_ARRAY[$J] == '') OR ($USER_ARRAY[$J] == '0')))
      {
        $APPLY_VALUE = '0';
        $COLOR = '';
      }
      else
      {
        if (($USER_ARRAY[$J] == $LOGIN_USER_ID))
        {
          $APPLY_VALUE = $USER_ARRAY[$J];
          $COLOR = '#0000ff';
        }
        else
        {
          $APPLY_VALUE = $USER_ARRAY[$J];
          $COLOR = '#ff0000';
        }
      }
      if (($APPLY_VALUE != '0'))
      {
        $query = (((''.'select * from USER where USER_ID=\'').$APPLY_VALUE).'\'');
        $cursor1 = exequery ($connection, $query);
        if ($ROW = mysql_fetch_array ($cursor1))
        {
          $USER_NAME = $ROW['USER_NAME'];
        }
        else
        {
          $USER_NAME = $APPLY_VALUE;
        }
      }
      echo '			<td  width=36 bgcolor="';
      echo $COLOR;
      echo '">
				';
      if (($APPLY_VALUE == '0'))
      {
        echo $TIME_ARRAY[$J];
      }
      else
      {
        echo (('<font color=#FFFFFF>'.$USER_NAME).'</font>');
      }
      echo '			</td>
';
    }
    echo '</tr>
';
  }
  echo '<tr class=TableControl>
	<td colspan=100 align=center>
		<input type="button" value="关 闭" class="BigButton" onclick="window.close()">&nbsp;&nbsp;
		<input type="button" value="返 回" class="BigButton" onclick="history.back()">
  </td>
</tr>
</table>
</form>
</body>
</HTML>
';
?>
⌨️ 快捷键说明

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