index.php

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

PHP
467 行
字号 
<?
  include_once 'inc/auth.php';
  include_once 'inc/check_type.php';
  include_once 'inc/utility_all.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">
';
  if (($SOME_DATE != ''))
  {
    $TIME_OK = is_date ($SOME_DATE);
    if (!$TIME_OK)
    {
      message ('错误', '查询日期格式不对，应形如 1999-1-2');
      button_back ();
      exit ();
    }
  }
  $query = (((''.'SELECT * from USER where USER_ID=\'').$LOGIN_USER_ID).'\'');
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $POST_PRIV = $ROW['POST_PRIV'];
  }
  echo '
<div class="Big1" align="center">
<b>
[考勤查询 - ';
  echo format_date ($SOME_DATE);
  echo ']
</b>
</div>
<br>
<!------------------------------------- 上下班 ------------------------------->
<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>
    </td>
  </tr>
</table>
<div align="center" class="Big1">
<form action="duty.php" name="form1">
<b>
部门：';
  echo '<s';
  echo 'elect name="DEPARTMENT" class="BigSelect">
';
  if (($POST_PRIV == '1'))
  {
    echo '          <option value="ALL_DEPT">所有部门</option>
';
  }
  echo my_dept_tree (0, $DEPT_ID, 1);
  echo '        </select>&nbsp;&nbsp;
排班类型：';
  echo '<s';
  echo 'elect name="DUTY_TYPE" class="BigSelect">
';
  $query = 'SELECT * from ATTEND_CONFIG order by DUTY_TYPE';
  $cursor = exequery ($connection, $query);
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $DUTY_TYPE = $ROW['DUTY_TYPE'];
    $DUTY_NAME = $ROW['DUTY_NAME'];
    echo '          <option value="';
    echo $DUTY_TYPE;
    echo '">';
    echo $DUTY_NAME;
    echo '</option>
';
  }
  echo '        </select>&nbsp;
        <input type="hidden" name="SOME_DATE" value="';
  echo $SOME_DATE;
  echo '">
        <input type="submit" value="查询" class="BigButton" title="查询指定日期的上下班时间">
</b>
</form>
</div>
<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=';
  echo '"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>
';
  $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(\'').$SOME_DATE).'\') order by DEPT_NO,USER.USER_ID');
  $cursor = exequery ($connection, $query);
  $OUT_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $USER_ID = $ROW['USER_ID'];
    $USER_NAME = $ROW['USER_NAME'];
    $OUT_TYPE = $ROW['OUT_TYPE'];
    $SUBMIT_TIME = $ROW['SUBMIT_TIME'];
    $OUT_TIME1 = $ROW['OUT_TIME1'];
    $OUT_TIME2 = $ROW['OUT_TIME2'];
    $ALLOW = $ROW['ALLOW'];
    $STATUS = $ROW['STATUS'];
    $DEPT_ID = $ROW['DEPT_ID'];
    $LEADER_ID = $ROW['LEADER_ID'];
    $LEADER_NAME = '';
    $query = (((''.'SELECT * from USER where USER_ID=\'').$LEADER_ID).'\'');
    $cursor1 = exequery ($connection, $query);
    if ($ROW = mysql_fetch_array ($cursor1))
    {
      $LEADER_NAME = $ROW['USER_NAME'];
    }
    if (!is_dept_priv ($DEPT_ID))
    {
      continue;
    }
    else
    {
      ++$OUT_COUNT;
      if (($STATUS == '0'))
      {
        $STATUS_DESC = '外出';
      }
      else
      {
        if (($STATUS == '1'))
        {
          $STATUS_DESC = '已归来';
        }
      }
      if (($ALLOW == '0'))
      {
        $STATUS_DESC = '待批';
      }
      if (($ALLOW == '2'))
      {
        $STATUS_DESC = '不批准';
      }
      $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 $SUBMIT_TIME;
      echo '</td>
      <td nowrap align="center">';
      echo $OUT_TIME1;
      echo '</td>
      <td nowrap align="center">';
      echo $OUT_TIME2;
      echo '</td>
      <td nowrap align="center">';
      echo $LEADER_NAME;
      echo '</td>
      <td nowrap align="center">';
      echo $STATUS_DESC;
      echo '</td>
    </tr>
';
      continue;
    }
  }
  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>
      <td nowrap align="center">审批人员</td>
      <td nowrap align="center">状态</td>
    </thead>
    </ta';
    echo 'ble>
';
  }
  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>
';
  $query = (((((''.'SELECT * from ATTEND_LEAVE,USER,DEPARTMENT where DEPARTMENT.DEPT_ID=USER.DEPT_ID and ATTEND_LEAVE.USER_ID=USER.USER_ID and to_days(LEAVE_DATE1)<=to_days(\'').$SOME_DATE).'\') and to_days(LEAVE_DATE2)>=to_days(\'').$SOME_DATE).'\') and allow in(\'1\',\'3\') order by DEPT_NO,USER.USER_ID');
  $cursor = exequery ($connection, $query);
  $LEAVE_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $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'];
    $DEPT_ID = $ROW['DEPT_ID'];
    $LEADER_ID = $ROW['LEADER_ID'];
    $STATUS = $ROW['STATUS'];
    $LEADER_NAME = '';
    $query = (((''.'SELECT * from USER where USER_ID=\'').$LEADER_ID).'\'');
    $cursor1 = exequery ($connection, $query);
    if ($ROW = mysql_fetch_array ($cursor1))
    {
      $LEADER_NAME = $ROW['USER_NAME'];
    }
    if (($STATUS == 1))
    {
      $STATUS = '现行';
    }
    else
    {
      $STATUS = '已销假';
    }
    if (!is_dept_priv ($DEPT_ID))
    {
      continue;
    }
    else
    {
      ++$LEAVE_COUNT;
      $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 $LEADER_NAME;
      echo '</td>
      <td nowrap align="center">';
      echo $LEAVE_DATE1;
      echo '</td>
      <td nowrap align="center">';
      echo $LEAVE_DATE2;
      echo '</td>
      <td nowrap align="center">';
      echo $STATUS;
      echo '</td>
    </tr>
';
      continue;
    }
  }
  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>
';
  $query = (((((''.'SELECT * from ATTEND_EVECTION,USER,DEPARTMENT where DEPARTMENT.DEPT_ID=USER.DEPT_ID and ATTEND_EVECTION.USER_ID=USER.USER_ID and to_days(EVECTION_DATE1)<=to_days(\'').$SOME_DATE).'\') and to_days(EVECTION_DATE2)>=to_days(\'').$SOME_DATE).'\') and ALLOW=\'1\' order by DEPT_NO,USER.USER_ID');
  $cursor = exequery ($connection, $query);
  $EVECTION_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $USER_ID = $ROW['USER_ID'];
    $USER_NAME = $ROW['USER_NAME'];
    $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'];
    $LEADER_ID = $ROW['LEADER_ID'];
    $STATUS = $ROW['STATUS'];
    $LEADER_NAME = '';
    $query = (((''.'SELECT * from USER where USER_ID=\'').$LEADER_ID).'\'');
    $cursor1 = exequery ($connection, $query);
    if ($ROW = mysql_fetch_array ($cursor1))
    {
      $LEADER_NAME = $ROW['USER_NAME'];
    }
    if (($STATUS == '1'))
    {
      $STATUS = '在外';
    }
    else
    {
      $STATUS = '归来';
    }
    if (!is_dept_priv ($DEPT_ID))
    {
      continue;
    }
    else
    {
      ++$EVECTION_COUNT;
      $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 $LEADER_NAME;
      echo '</td>
      <td nowrap align="center">';
      echo $EVECTION_DATE1;
      echo '</td>
      <td nowrap align="center">';
      echo $EVECTION_DATE2;
      echo '</td>
      <td nowrap align="center">';
      echo $STATUS;
      echo '</td>
    </tr>
';
      continue;
    }
  }
  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>
';
  }
  else
  {
    message ('', '无出差记录');
  }
  echo '
</table>
<br>
<div align="center">
  <input type="button"  value="返回" class="BigButton" onClick="location=\'../\';">
</div>
</body>
</html>';
?>

index.php - 源码说明

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

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

⌨️ 快捷键说明

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