index.php

来自「通达OA2007SE源代码非常好的」· PHP 代码 · 共 362 行
PHP
362 行
<?
  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();\',60000);
</script>
</head>
<body class="bodycolor" topmargin="5">
';
  $CUR_DATE = date ('Y-m-d', time ());
  echo '
<!------------------------------------- 今日外出审批 ------------------------------->
<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="absmiddle">';
  echo '<s';
  echo 'pan class="big3"> 今日外出审批</span><br>
    </td>
  </tr>
</table>
<br>
';
  if (($LOGIN_USER_ID == 'admin'))
  {
    $query = (((''.'SELECT * from ATTEND_OUT,USER where ATTEND_OUT.USER_ID=USER.USER_ID and to_days(SUBMIT_TIME)=to_days(\'').$CUR_DATE).'\') and ALLOW=\'0\' order by USER.USER_ID');
  }
  else
  {
    $query = (((((''.'SELECT * from ATTEND_OUT,USER where ATTEND_OUT.USER_ID=USER.USER_ID and LEADER_ID=\'').$LOGIN_USER_ID).'\' and to_days(SUBMIT_TIME)=to_days(\'').$CUR_DATE).'\') and ALLOW=\'0\' order by USER.USER_ID');
  }
  $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'];
    $ALLOW = $ROW['ALLOW'];
    $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">
';
    }
    if ((($OUT_COUNT % 2) == 1))
    {
      $TableLine = 'TableLine1';
    }
    else
    {
      $TableLine = 'TableLine2';
    }
    echo '    <tr class="';
    echo $TableLine;
    echo '">
      <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>
      <td nowrap align="center">
          <a href="out_confirm.php?CONFIRM=1&USER_ID=';
    echo $USER_ID;
    echo '">批准</a>&nbsp;
          <a href="out_confirm.php?CONFIRM=2&USER_ID=';
    echo $USER_ID;
    echo '">不批准</a>
      </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>
      <td nowrap align="center">操作</td>
    </thead>
    </table>
';
  }
  else
  {
    message ('', '无外出审批申请');
  }
  echo '
<br>
<table width="95%" border="0" cellspacing="0" cellpadding="0" height="3">
 <tr>
   <td background="/images/dian1.gif" width="100%"></td>
 </tr>
</table>
<!------------------------------------- 请假审批 ------------------------------->
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/attendance.gif" WIDTH="22" HE';
  echo 'IGHT="20" align="absmiddle">';
  echo '<s';
  echo 'pan class="big3"> 请假审批</span><br>
    </td>
  </tr>
</table>
<br>
';
  if (($LOGIN_USER_ID == 'admin'))
  {
    $query = 'SELECT * from ATTEND_LEAVE,USER where ATTEND_LEAVE.USER_ID=USER.USER_ID and status=\'1\' and allow in(\'0\',\'3\')';
  }
  else
  {
    $query = (((''.'SELECT * from ATTEND_LEAVE,USER where ATTEND_LEAVE.USER_ID=USER.USER_ID and LEADER_ID=\'').$LOGIN_USER_ID).'\' and status=\'1\' and allow in(\'0\',\'3\')');
  }
  $cursor = exequery ($connection, $query);
  $LEAVE_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    ++$LEAVE_COUNT;
    $LEAVE_ID = $ROW['LEAVE_ID'];
    $USER_ID = $ROW['USER_ID'];
    $USER_NAME = $ROW['USER_NAME'];
    $LEAVE_DATE1 = $ROW['LEAVE_DATE1'];
    $LEAVE_DATE2 = $ROW['LEAVE_DATE2'];
    $LEAVE_TYPE = $ROW['LEAVE_TYPE'];
    $ALLOW = $ROW['ALLOW'];
    $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 (($LEAVE_COUNT == 1))
    {
      echo '
    <table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
';
    }
    if ((($LEAVE_COUNT % 2) == 1))
    {
      $TableLine = 'TableLine1';
    }
    else
    {
      $TableLine = 'TableLine2';
    }
    echo '    <tr class="';
    echo $TableLine;
    echo '">
      <td nowrap align="center">';
    echo $USER_DEPT_NAME;
    echo '</td>
      <td nowrap align="center">';
    echo $USER_NAME;
    echo '</td>
      <td nowrap align="center">';
    echo $LEAVE_TYPE;
    echo '</td>
      <td nowrap align="center">';
    echo $LEAVE_DATE1;
    echo '</td>
      <td nowrap align="center">';
    echo $LEAVE_DATE2;
    echo '</td>
';
    if (($ALLOW == '0'))
    {
      echo '      <td nowrap align="center">请假申请</td>
      <td nowrap align="center">
          <a href="leave_confirm.php?CONFIRM=1&LEAVE_ID=';
      echo $LEAVE_ID;
      echo '&USER_ID=';
      echo $USER_ID;
      echo '">批准</a>&nbsp;
          <a href="leave_confirm.php?CONFIRM=2&LEAVE_ID=';
      echo $LEAVE_ID;
      echo '&USER_ID=';
      echo $USER_ID;
      echo '">不批准</a>&nbsp;
';
    }
    else
    {
      echo '      <td nowrap align="center">销假申请</td>
      <td nowrap align="center">
          <a href="leave_confirm.php?STATUS=2&LEAVE_ID=';
      echo $LEAVE_ID;
      echo '&USER_ID=';
      echo $USER_ID;
      echo '">销假</a>
      </td>
';
    }
    echo '      </td>
    </tr>
';
  }
  if ((0 < $LEAVE_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>
      <td nowrap align="center">申请类型</td>
      <td nowrap align="center">操作</td>
    </thead>
    </table>
';
  }
  else
  {
    message ('', '无请假审批申请');
  }
  echo '
<br>
<table width="95%" border="0" cellspacing="0" cellpadding="0" height="3">
 <tr>
   <td background="/images/dian1.gif" width="100%"></td>
 </tr>
</table>
<!------------------------------------- 出差审批 ------------------------------->
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/attendance.gif" WIDTH="22" ';
  echo 'HEIGHT="20" align="absmiddle">';
  echo '<s';
  echo 'pan class="big3"> 出差审批</span><br>
    </td>
  </tr>
</table>
<br>
';
  if (($LOGIN_USER_ID == 'admin'))
  {
    $query = 'SELECT * from ATTEND_EVECTION,USER where ATTEND_EVECTION.USER_ID=USER.USER_ID and status=\'1\' and allow=\'0\'';
  }
  else
  {
    $query = (((''.'SELECT * from ATTEND_EVECTION,USER where ATTEND_EVECTION.USER_ID=USER.USER_ID and LEADER_ID=\'').$LOGIN_USER_ID).'\' and status=\'1\' and allow=\'0\'');
  }
  $cursor = exequery ($connection, $query);
  $EVECTION_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    ++$EVECTION_COUNT;
    $EVECTION_ID = $ROW['EVECTION_ID'];
    $USER_ID = $ROW['USER_ID'];
    $USER_NAME = $ROW['USER_NAME'];
    $REASON = $ROW['REASON'];
    $EVECTION_DATE1 = $ROW['EVECTION_DATE1'];
    $EVECTION_DATE1 = strtok ($EVECTION_DATE1, ' ');
    $EVECTION_DATE2 = $ROW['EVECTION_DATE2'];
    $EVECTION_DATE2 = strtok ($EVECTION_DATE2, ' ');
    $EVECTION_DEST = $ROW['EVECTION_DEST'];
    $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 (($EVECTION_COUNT == 1))
    {
      echo '    <table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
';
    }
    if ((($EVECTION_COUNT % 2) == 1))
    {
      $TableLine = 'TableLine1';
    }
    else
    {
      $TableLine = 'TableLine2';
    }
    echo '    <tr class="';
    echo $TableLine;
    echo '">
      <td nowrap align="center">';
    echo $USER_DEPT_NAME;
    echo '</td>
      <td nowrap align="center">';
    echo $USER_NAME;
    echo '</td>
      <td nowrap align="center">';
    echo $EVECTION_DEST;
    echo '</td>
      <td nowrap align="center">';
    echo $REASON;
    echo '</td>
      <td nowrap align="center">';
    echo $EVECTION_DATE1;
    echo '</td>
      <td nowrap align="center">';
    echo $EVECTION_DATE2;
    echo '</td>
      <td nowrap align="center">
          <a href="evection_confirm.php?CONFIRM=1&EVECTION_ID=';
    echo $EVECTION_ID;
    echo '&USER_ID=';
    echo $USER_ID;
    echo '">批准</a>&nbsp;
          <a href="evection_confirm.php?CONFIRM=2&EVECTION_ID=';
    echo $EVECTION_ID;
    echo '&USER_ID=';
    echo $USER_ID;
    echo '">不批准</a>&nbsp;
      </td>
    </tr>
';
  }
  if ((0 < $EVECTION_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>
      <td nowrap align="center">结束日期</td>
      <td nowrap align="center">操作</td>
    </thead>
    </table>
';
  }
  else
  {
    message ('', '无出差审批申请');
  }
  echo '
</body>
</html>';
?>
index.php - 源码说明

本页面展示了「通达OA2007SE源代码非常好的」中的 index.php 源码文件，采用 PHP 编程语言编写，共 362 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。
虫虫下载站收录了大量与2007相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。
⌨️ 快捷键说明

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