submit.php

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

PHP
110
字号
<?
  include_once 'inc/auth.php';
  echo '
<html>
<head>
<title>上下班登记</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
';
  $CUR_DATE = date ('Y-m-d', time ());
  $CUR_TIME = date ('Y-m-d H:i:s', time ());
  $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))
  {
    if (($REGISTER_TYPE == 1))
    {
      $DUTY_TIME = $ROW['DUTY_TIME1'];
      $DUTY_TYPE = $ROW['DUTY_TYPE1'];
    }
    else
    {
      if (($REGISTER_TYPE == 2))
      {
        $DUTY_TIME = $ROW['DUTY_TIME2'];
        $DUTY_TYPE = $ROW['DUTY_TYPE2'];
      }
      else
      {
        if (($REGISTER_TYPE == 3))
        {
          $DUTY_TIME = $ROW['DUTY_TIME3'];
          $DUTY_TYPE = $ROW['DUTY_TYPE3'];
        }
        else
        {
          if (($REGISTER_TYPE == 4))
          {
            $DUTY_TIME = $ROW['DUTY_TIME4'];
            $DUTY_TYPE = $ROW['DUTY_TYPE4'];
          }
          else
          {
            if (($REGISTER_TYPE == 5))
            {
              $DUTY_TIME = $ROW['DUTY_TIME5'];
              $DUTY_TYPE = $ROW['DUTY_TYPE5'];
            }
            else
            {
              if (($REGISTER_TYPE == 6))
              {
                $DUTY_TIME = $ROW['DUTY_TIME6'];
                $DUTY_TYPE = $ROW['DUTY_TYPE6'];
              }
            }
          }
        }
      }
    }
  }
  $DUTY_INTERVAL_BEFORE = ('DUTY_INTERVAL_BEFORE'.$DUTY_TYPE);
  $query = (((''.'SELECT * from SYS_PARA where PARA_NAME=\'').$DUTY_INTERVAL_BEFORE).'\'');
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $DUTY_INTERVAL_BEFORE = $ROW['PARA_VALUE'];
  }
  $DUTY_INTERVAL_AFTER = ('DUTY_INTERVAL_AFTER'.$DUTY_TYPE);
  $query = (((''.'SELECT * from SYS_PARA where PARA_NAME=\'').$DUTY_INTERVAL_AFTER).'\'');
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $DUTY_INTERVAL_AFTER = $ROW['PARA_VALUE'];
  }
  $REGISTER_TIME = (($CUR_DATE.' ').$DUTY_TIME);
  if (((($DUTY_INTERVAL_BEFORE * 60) < (strtotime ($REGISTER_TIME) - strtotime ($CUR_TIME))) OR (($DUTY_INTERVAL_AFTER * 60) < (strtotime ($CUR_TIME) - strtotime ($REGISTER_TIME)))))
  {
    if (($DUTY_TYPE == '1'))
    {
      message ('警告', (((((''.'规定时间之前 ').$DUTY_INTERVAL_BEFORE).' 分钟,之后 ').$DUTY_INTERVAL_AFTER).' 分钟起可进行上班登记!'));
    }
    if (($DUTY_TYPE == '2'))
    {
      message ('警告', (((((''.'规定时间之前 ').$DUTY_INTERVAL_BEFORE).' 分钟,之后 ').$DUTY_INTERVAL_AFTER).' 分钟起可进行下班登记!'));
    }
    button_back ();
    exit ();
  }
  $query = (((((((''.'SELECT * from ATTEND_DUTY where USER_ID=\'').$LOGIN_USER_ID).'\' and REGISTER_TYPE=\'').$REGISTER_TYPE).'\' and to_days(REGISTER_TIME)=to_days(\'').$CUR_TIME).'\')');
  $cursor = exequery ($connection, $query);
  if (!$ROW = mysql_fetch_array ($cursor))
  {
    $query = (((((((((''.'insert into ATTEND_DUTY(USER_ID,REGISTER_TYPE,REGISTER_TIME,REGISTER_IP) values (\'').$LOGIN_USER_ID).'\',\'').$REGISTER_TYPE).'\',\'').$CUR_TIME).'\',\'').$_SERVER['REMOTE_ADDR']).'\')');
    exequery ($connection, $query);
  }
  header ('location: index.php');
  echo '
</body>
</html>
';
?>

⌨️ 快捷键说明

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