duty_update.php

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

<?
  include_once 'inc/auth.php';
  include_once 'inc/check_type.php';
  include_once 'inc/utility_all.php';
  for ($I = 1; ($I <= 6); ++$I)
  {
    $STR = ('REGISTER_TIME'.$I);
    $REGISTER_TIME = $$STR;
    $REGISTER_TIME1 = '';
    $query = (((((((''.'select * from ATTEND_DUTY where USER_ID=\'').$USER_ID).'\' and to_days(REGISTER_TIME)=to_days(\'').$SOME_DATE).'\') and REGISTER_TYPE=\'').$I).'\'');
    $cursor = exequery ($connection, $query);
    if ($ROW = mysql_fetch_array ($cursor))
    {
      $REGISTER_TIME1 = $ROW['REGISTER_TIME'];
    }
    if (($REGISTER_TIME == ''))
    {
      $query = (((((((''.'delete from ATTEND_DUTY where USER_ID=\'').$USER_ID).'\' and to_days(REGISTER_TIME)=to_days(\'').$SOME_DATE).'\') and REGISTER_TYPE=\'').$I).'\'');
      $cursor = exequery ($connection, $query);
      $REMARK = ((((('删除考勤记录，日期['.$SOME_DATE).']，类型[').$I).'],USER_ID=').$USER_ID);
      if (($REGISTER_TIME1 != ''))
      {
        add_log (13, $REMARK, $LOGIN_USER_ID);
        continue;
      }
      continue;
    }
    if (is_time ($REGISTER_TIME))
    {
      $REGISTER_TIME = (($SOME_DATE.' ').$REGISTER_TIME);
      $query = (((((((''.'select * from ATTEND_DUTY where USER_ID=\'').$USER_ID).'\' and to_days(REGISTER_TIME)=to_days(\'').$SOME_DATE).'\') and REGISTER_TYPE=\'').$I).'\'');
      $cursor = exequery ($connection, $query);
      if ($ROW = mysql_fetch_array ($cursor))
      {
        $query = (((((((((''.'update ATTEND_DUTY set REGISTER_TIME=\'').$REGISTER_TIME).'\' where USER_ID=\'').$USER_ID).'\' and to_days(REGISTER_TIME)=to_days(\'').$SOME_DATE).'\') and REGISTER_TYPE=\'').$I).'\'');
      }
      else
      {
        $query = (((((((''.'insert into  ATTEND_DUTY(USER_ID,REGISTER_TYPE,REGISTER_TIME) values (\'').$USER_ID).'\',\'').$I).'\',\'').$REGISTER_TIME).'\')');
      }
      $cursor = exequery ($connection, $query);
      $REMARK = ((((('修改考勤时间['.$REGISTER_TIME).'],原时间[').$REGISTER_TIME1).'],USER_ID=').$USER_ID);
      if (($REGISTER_TIME1 != $REGISTER_TIME))
      {
        add_log (13, $REMARK, $LOGIN_USER_ID);
        continue;
      }
      continue;
    }
  }
  header (((''.'location: user.php?USER_ID=').$USER_ID));
?>