index.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 579 行 · 第 1/2 页

PHP
579
字号
<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  echo '<s';
  echo 'cript language="JavaScript">
function remark(REGISTER_TYPE,REGISTER_TIME)
{
  URL="remark.php?REGISTER_TYPE="+REGISTER_TYPE+"&REGISTER_TIME="+REGISTER_TIME;
  myleft=(screen.availWidth-650)/2;
  window.open(URL,"formul_edit","height=250,width=450,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}
</script>
<html>
<head>
<title>上下班登记</titl';
  echo 'e>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
';
  $USER_IP = get_client_ip ();
  if (!check_ip ($USER_IP, '1', $LOGIN_USER_ID))
  {
    message ('警告', (('您无权限从该IP('.$USER_IP).')考勤!'));
    exit ();
  }
  $query1 = (((''.'select * from USER where USER_ID=\'').$LOGIN_USER_ID).'\'');
  $cursor1 = exequery ($connection, $query1);
  if ($ROW = mysql_fetch_array ($cursor1))
  {
    $DUTY_TYPE = $ROW['DUTY_TYPE'];
  }
  $query = ((''.'SELECT * from ATTEND_CONFIG where DUTY_TYPE=').$DUTY_TYPE);
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $DUTY_NAME = $ROW['DUTY_NAME'];
    $GENERAL = $ROW['GENERAL'];
    $DUTY_TIME1 = $ROW['DUTY_TIME1'];
    $DUTY_TIME2 = $ROW['DUTY_TIME2'];
    $DUTY_TIME3 = $ROW['DUTY_TIME3'];
    $DUTY_TIME4 = $ROW['DUTY_TIME4'];
    $DUTY_TIME5 = $ROW['DUTY_TIME5'];
    $DUTY_TIME6 = $ROW['DUTY_TIME6'];
    $DUTY_TYPE1 = $ROW['DUTY_TYPE1'];
    $DUTY_TYPE2 = $ROW['DUTY_TYPE2'];
    $DUTY_TYPE3 = $ROW['DUTY_TYPE3'];
    $DUTY_TYPE4 = $ROW['DUTY_TYPE4'];
    $DUTY_TYPE5 = $ROW['DUTY_TYPE5'];
    $DUTY_TYPE6 = $ROW['DUTY_TYPE6'];
  }
  echo '
<!----  上下班登记 ---->
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small" align="center">
  <tr>
    <td class="Big"><img src="/images/menu/attendance.gif" WIDTH="22" HEIGHT="20" align="absmiddle">';
  echo '<s';
  echo 'pan class="big3"> 今日上下班登记 (';
  echo $DUTY_NAME;
  echo ')</span><br>
    </td>
  </tr>
</table>
';
  $query = 'SELECT * from SYS_PARA where PARA_NAME=\'DUTY_INTERVAL_BEFORE1\'';
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $DUTY_INTERVAL_BEFORE1 = $ROW['PARA_VALUE'];
  }
  $query = 'SELECT * from SYS_PARA where PARA_NAME=\'DUTY_INTERVAL_AFTER1\'';
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $DUTY_INTERVAL_AFTER1 = $ROW['PARA_VALUE'];
  }
  $query = 'SELECT * from SYS_PARA where PARA_NAME=\'DUTY_INTERVAL_BEFORE2\'';
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $DUTY_INTERVAL_BEFORE2 = $ROW['PARA_VALUE'];
  }
  $query = 'SELECT * from SYS_PARA where PARA_NAME=\'DUTY_INTERVAL_AFTER2\'';
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $DUTY_INTERVAL_AFTER2 = $ROW['PARA_VALUE'];
  }
  message ('', (((((((((''.'规定时间之前 ').$DUTY_INTERVAL_BEFORE1).' 分钟,之后 ').$DUTY_INTERVAL_AFTER1).' 分钟起可进行上班登记,规定时间之前 ').$DUTY_INTERVAL_BEFORE2).' 分钟,之后 ').$DUTY_INTERVAL_AFTER2).' 分钟起可进行下班登记'));
  $SOME_DATE = date ('Y-m-d');
  $WEEK = date ('w', strtotime ($SOME_DATE));
  $HOLIDAY = '';
  $query = (((((''.'select * from ATTEND_HOLIDAY where BEGIN_DATE <=\'').$SOME_DATE).'\' and END_DATE>=\'').$SOME_DATE).'\'');
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $HOLIDAY = '<font color=\'#008000\'>节假日</font>';
  }
  else
  {
    if (find_id ($GENERAL, $WEEK))
    {
      $HOLIDAY = '<font color=\'#008000\'>公休日</font>';
    }
  }
  echo '
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="2">
    <tr 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>
    </tr>
';
  $CUR_DATE = date ('Y-m-d', time ());
  $CUR_TIME = date ('Y-m-d H:i:s', time ());
  if (($DUTY_TIME1 != ''))
  {
    $SIGN = '0';
    $query = (((((''.'SELECT * from ATTEND_DUTY where USER_ID=\'').$LOGIN_USER_ID).'\' and to_days(REGISTER_TIME)=to_days(\'').$CUR_DATE).'\') and REGISTER_TYPE=\'1\'');
    $cursor = exequery ($connection, $query);
    if ($ROW = mysql_fetch_array ($cursor))
    {
      $REGISTER_TIME1 = $ROW['REGISTER_TIME'];
      $REGISTER_TIME11 = $ROW['REGISTER_TIME'];
      $REGISTER_TIME1 = strtok ($REGISTER_TIME1, ' ');
      $REGISTER_TIME1 = strtok (' ');
      if (((($HOLIDAY == '') AND ($DUTY_TYPE1 == '1')) AND (compare_time ($REGISTER_TIME1, $DUTY_TIME1) == 1)))
      {
        ($REGISTER_TIME1 .= ' 迟到');
        $SIGN = '1';
      }
      if (((($HOLIDAY == '') AND ($DUTY_TYPE1 == '2')) AND (compare_time ($REGISTER_TIME1, $DUTY_TIME1) == -1)))
      {
        ($REGISTER_TIME1 .= ' 早退');
        $SIGN = '1';
      }
    }
    $DUTY_INTERVAL_BEFORE = ('DUTY_INTERVAL_BEFORE'.$DUTY_TYPE1);
    $DUTY_INTERVAL_AFTER = ('DUTY_INTERVAL_AFTER'.$DUTY_TYPE1);
    if (($DUTY_TYPE1 == '1'))
    {
      $DUTY_TYPENAME1 = '上班登记';
    }
    else
    {
      $DUTY_TYPENAME1 = '下班登记';
    }
    echo '    <tr class="TableData">
      <td nowrap align="center">第1次登记</td>
      <td nowrap align="center">';
    echo $DUTY_TYPENAME1;
    echo '</td>
      <td nowrap align="center">';
    echo $DUTY_TIME1;
    echo '</td>
';
    if (($REGISTER_TIME1 == ''))
    {
      echo '      <td nowrap align="center">未登记</td>
      <td nowrap align="center">
';
      $REGISTER_TIME = (($CUR_DATE.' ').$DUTY_TIME1);
      if ((((strtotime ($REGISTER_TIME) - strtotime ($CUR_TIME)) <= ($$DUTY_INTERVAL_BEFORE * 60)) AND ((strtotime ($CUR_TIME) - strtotime ($REGISTER_TIME)) <= ($$DUTY_INTERVAL_AFTER * 60))))
      {
        echo '      <a href="submit.php?REGISTER_TYPE=1">';
        echo $DUTY_TYPENAME1;
        echo '</a>
';
      }
      else
      {
        echo '无';
      }
      echo '      </td>
    </tr>
';
    }
    else
    {
      echo '      <td nowrap align="center">';
      echo $REGISTER_TIME1;
      echo '</td>
      <td nowrap align="center">
       已考勤  <a href="javascript:remark(\'1\',\'';
      echo $REGISTER_TIME11;
      echo '\');">备注</a>
      </td>
    </tr>
';
    }
  }
  if (($DUTY_TIME2 != ''))
  {
    $SIGN = '0';
    $query = (((((''.'SELECT * from ATTEND_DUTY where USER_ID=\'').$LOGIN_USER_ID).'\' and to_days(REGISTER_TIME)=to_days(\'').$CUR_DATE).'\') and REGISTER_TYPE=\'2\'');
    $cursor = exequery ($connection, $query);
    if ($ROW = mysql_fetch_array ($cursor))
    {
      $REGISTER_TIME2 = $ROW['REGISTER_TIME'];
      $REGISTER_TIME22 = $ROW['REGISTER_TIME'];
      $REGISTER_TIME2 = strtok ($REGISTER_TIME2, ' ');
      $REGISTER_TIME2 = strtok (' ');
      if ((($DUTY_TYPE2 == '1') AND (compare_time ($REGISTER_TIME2, $DUTY_TIME2) == 1)))
      {
        ($REGISTER_TIME2 .= ' 迟到');
        $SIGN = '1';
      }
      if ((($DUTY_TYPE2 == '2') AND (compare_time ($REGISTER_TIME2, $DUTY_TIME2) == -1)))
      {
        ($REGISTER_TIME2 .= ' 早退');
        $SIGN = '1';
      }
    }
    $DUTY_INTERVAL_BEFORE = ('DUTY_INTERVAL_BEFORE'.$DUTY_TYPE2);
    $DUTY_INTERVAL_AFTER = ('DUTY_INTERVAL_AFTER'.$DUTY_TYPE2);
    if (($DUTY_TYPE2 == '1'))
    {
      $DUTY_TYPENAME2 = '上班登记';
    }
    else
    {
      $DUTY_TYPENAME2 = '下班登记';
    }
    echo '    <tr class="TableData">
      <td nowrap align="center">第2次登记</td>
      <td nowrap align="center">';
    echo $DUTY_TYPENAME2;
    echo '</td>
      <td nowrap align="center">';
    echo $DUTY_TIME2;
    echo '</td>
';
    if (($REGISTER_TIME2 == ''))
    {
      echo '      <td nowrap align="center">未登记</td>
      <td nowrap align="center">
';
      $REGISTER_TIME = (($CUR_DATE.' ').$DUTY_TIME2);
      if ((((strtotime ($REGISTER_TIME) - strtotime ($CUR_TIME)) <= ($$DUTY_INTERVAL_BEFORE * 60)) AND ((strtotime ($CUR_TIME) - strtotime ($REGISTER_TIME)) <= ($$DUTY_INTERVAL_AFTER * 60))))
      {
        echo '      <a href="submit.php?REGISTER_TYPE=2">';
        echo $DUTY_TYPENAME2;
        echo '</a>
';
      }
      else
      {
        echo '无';
      }
      echo '      </td>
    </tr>
';
    }
    else
    {
      echo '      <td nowrap align="center">';
      echo $REGISTER_TIME2;
      echo '</td>
       <td nowrap align="center">
       已考勤  <a href="javascript:remark(\'2\',\'';
      echo $REGISTER_TIME22;
      echo '\');">备注</a>
     </td>
    </tr>
';
    }
  }
  if (($DUTY_TIME3 != ''))
  {
    $SIGN = '0';
    $query = (((((''.'SELECT * from ATTEND_DUTY where USER_ID=\'').$LOGIN_USER_ID).'\' and to_days(REGISTER_TIME)=to_days(\'').$CUR_DATE).'\') and REGISTER_TYPE=\'3\'');
    $cursor = exequery ($connection, $query);
    if ($ROW = mysql_fetch_array ($cursor))
    {
      $REGISTER_TIME3 = $ROW['REGISTER_TIME'];
      $REGISTER_TIME33 = $ROW['REGISTER_TIME'];
      $REGISTER_TIME3 = strtok ($REGISTER_TIME3, ' ');
      $REGISTER_TIME3 = strtok (' ');
      if ((($DUTY_TYPE3 == '1') AND (compare_time ($REGISTER_TIME3, $DUTY_TIME3) == 1)))
      {
        ($REGISTER_TIME3 .= ' 迟到');
        $SIGN = '1';
      }
      if ((($DUTY_TYPE3 == '2') AND (compare_time ($REGISTER_TIME3, $DUTY_TIME3) == -1)))
      {
        ($REGISTER_TIME3 .= ' 早退');
        $SIGN = '1';
      }

⌨️ 快捷键说明

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