out.php

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

PHP
95
字号
<?
  include_once 'inc/auth.php';
  echo '
<html>
<head>
<title>外出人员</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'cript Language=JavaScript>
window.setTimeout(\'this.location.reload();\',30000);
</script>
</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/attendance.gif" WIDTH="22" HEIGHT="20" align="absm';
  echo 'iddle">';
  echo '<s';
  echo 'pan class="big3"> 外出人员</span><br>
    </td>
  </tr>
</table>
<br>
';
  $CUR_DATE = date ('Y-m-d', time ());
  $query = (((''.'SELECT * from ATTEND_OUT,USER,DEPARTMENT where DEPARTMENT.DEPT_ID=USER.DEPT_ID and  ATTEND_OUT.USER_ID=USER.USER_ID and to_days(SUBMIT_TIME)=to_days(\'').$CUR_DATE).'\') and ALLOW=\'1\' order by DEPT_NO,USER.USER_NAME');
  $cursor = exequery ($connection, $query);
  $OUT_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    ++$OUT_COUNT;
    $USER_ID = $ROW['USER_ID'];
    $USER_NAME = $ROW['USER_NAME'];
    $OUT_TYPE = $ROW['OUT_TYPE'];
    $OUT_TIME1 = $ROW['OUT_TIME1'];
    $OUT_TIME2 = $ROW['OUT_TIME2'];
    $DEPT_ID = $ROW['DEPT_ID'];
    $query1 = ((''.'select * from DEPARTMENT where DEPT_ID=').$DEPT_ID);
    $cursor1 = exequery ($connection, $query1);
    if ($ROW = mysql_fetch_array ($cursor1))
    {
      $USER_DEPT_NAME = $ROW['DEPT_NAME'];
    }
    if (($OUT_COUNT == 1))
    {
      echo '
    <table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
';
    }
    echo '    <tr class="TableData">
      <td nowrap align="center">';
    echo $USER_DEPT_NAME;
    echo '</td>
      <td nowrap align="center">';
    echo $USER_NAME;
    echo '</td>
      <td nowrap align="center">';
    echo $OUT_TYPE;
    echo '</td>
      <td nowrap align="center">';
    echo $OUT_TIME1;
    echo '</td>
      <td nowrap align="center">';
    echo $OUT_TIME2;
    echo '</td>
    </tr>
';
  }
  if ((0 < $OUT_COUNT))
  {
    echo '    <thead class="TableHeader">
      <td nowrap align="center">部门</td>
      <td nowrap align="center">姓名</td>
      <td nowrap align="center">外出原因</td>
      <td nowrap align="center">外出时间</td>
      <td nowrap align="center">预计归来时间</td>
    </thead>
    </table>
';
  }
  else
  {
    message ('', '无外出人员');
  }
  echo '
<br>
<div align="center">
    <input type="button" value="返回" class="BigButton" onClick="location=\'user_all.php\'">
</div>
</body>
</html>';
?>

⌨️ 快捷键说明

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