apply.php

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

PHP
227
字号
<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  echo '
<HTML>
<HEAD>
<TITLE>资源申请</TITLE>
';
  echo '<s';
  echo 'cript language=JavaScript>
function changeColor(obj,name)/*改变单元格的颜色*/
{
  if(document.form1.item(name).value == 0 || document.form1.item(name).value == 1)
  	document.form1.item(name).value = 1-document.form1.item(name).value;
  else if(document.form1.item(name).value==-1)
  	document.form1.item(name).value = document.form1.item(name).title;
  else
    document.form1.item(name).val';
  echo 'ue = -1;
  document.form1.item("submit").disabled = false;
  if(obj.bgColor == \'#0000ff\')
  {
    obj.bgColor = \'#ff33ff\';//撤销已申请
    return;
  }
  if(obj.bgColor == \'#ff33ff\')
  {
    obj.bgColor = \'#0000ff\';	//撤销‘撤销已申请’
    return;
  }
  if(obj.bgColor == \'#00ff00\')//绿色表示申请的
  {
  	obj.bgColor = \'\';	//撤销申请
    return;
  }
  obj.bgColor = \'#00ff00\';';
  echo '	//自己即将申请的
}
</script>
</HEAD>
<body>
';
  $query = (((''.'select * from OA_SOURCE where SOURCEID=\'').$SOURCEID).'\'');
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $SOURCENAME = $ROW['SOURCENAME'];
    $DAY_LIMIT = $ROW['DAY_LIMIT'];
    $WEEKDAY_SET = $ROW['WEEKDAY_SET'];
    $TIME_TITLE = $ROW['TIME_TITLE'];
    $MANAGE_USER = $ROW['MANAGE_USER'];
  }
  if (((($WEEKDAY_SET == '') OR ($DAY_LIMIT == '')) OR ($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))
  {
    $MANAGE_PRIV = 1;
  }
  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=80>他人已经申请</td>
		<td width=20 bgColor="#0000ff"></td>
		<td width=80>本人已经申请</td>
';
  if (($MANAGE_PRIV == 1))
  {
    echo '<td width=180><b>身份:管理员</b> <a href="history.php?SOURCEID=';
    echo $SOURCEID;
    echo '">查看历史记录</a></td>
';
  }
  echo '	</tr>
</table>
<form name=form1 action="submit.php" method=post>
<table class=small border="0" cellspacing="1" cellpadding="1" bgcolor="#000000">
<tr class=TableHeader>
	<td colspan=100 height=30>资源申请:';
  echo $SOURCENAME;
  echo '</td>
</tr>
';
  $CUR_DATE = date ('Y-m-d', time ());
  for ($I = 0; ($I < $DAY_LIMIT); ++$I)
  {
    if ((($I % 2) == 1))
    {
      $TableLine = 'TableData';
    }
    else
    {
      $TableLine = 'TableContent';
    }
    $APPLY_DATE = (time () + (($I * 24) * 3600));
    if (!find_id ($WEEKDAY_SET, date ('w', $APPLY_DATE)))
    {
      ++$DAY_LIMIT;
      continue;
    }
    else
    {
      $APPLY_DATE = date ('Y-m-d', $APPLY_DATE);
      $APPLY_DATE_DESC = substr ($APPLY_DATE, 5);
      $WEEK_DAY = ('周'.get_week ($APPLY_DATE));
      $query = (((((''.'select * from OA_SOURCE_USED where SOURCEID=\'').$SOURCEID).'\' and APPLY_DATE=\'').$APPLY_DATE).'\'');
      $cursor = exequery ($connection, $query);
      if ($ROW = mysql_fetch_array ($cursor))
      {
        $USER_ID = $ROW['USER_ID'];
      }
      else
      {
        $USER_ID = '';
      }
      $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) OR ($MANAGE_PRIV == 1)))
          {
            $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).'\'');
          $cursor = exequery ($connection, $query);
          if ($ROW = mysql_fetch_array ($cursor))
          {
            $USER_NAME = $ROW['USER_NAME'];
          }
          else
          {
            $USER_NAME = $APPLY_VALUE;
          }
        }
        echo '			<td  width=36 ';
        if (($COLOR != '#ff0000'))
        {
          echo 'onclick="changeColor(this,\'';
          echo $APPLY_DATE;
          echo '_';
          echo $J;
          echo '\')" style="cursor:hand" ';
        }
        echo 'bgcolor="';
        echo $COLOR;
        echo '">
				';
        if (($APPLY_VALUE === '0'))
        {
          echo $TIME_ARRAY[$J];
        }
        else
        {
          echo (('<font color=#FFFFFF>'.$USER_NAME).'</font>');
        }
        echo '				<INPUT TYPE="hidden" NAME="';
        echo $APPLY_DATE;
        echo '_';
        echo $J;
        echo '" value="';
        echo $APPLY_VALUE;
        echo '" title="';
        echo $APPLY_VALUE;
        echo '">
			</td>
';
      }
      echo '</tr>
';
      continue;
    }
  }
  echo '<tr class=TableControl>
	<INPUT TYPE="hidden" NAME="SOURCEID" value="';
  echo $SOURCEID;
  echo '">
	<td colspan=100 align=center>
		<input class="BigButton" type=submit disabled name="submit" value="提 交">&nbsp;&nbsp;
		<input type="button" value="关 闭" class="BigButton" onclick="window.close()">
  </td>
</tr>
</table>
</form>
</body>
</HTML>
';
?>

⌨️ 快捷键说明

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