duty_update.php

来自「极限网络智能办公系统 Office Automation V3.0官方100％源」· PHP 代码 · 共 47 行

<?
include_once("inc/auth.php");
include_once("inc/check_type.php");
include_once("inc/utility_all.php");

$connection=OpenConnection();

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);
  }
  else 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);
  }
}

header("location: user.php?USER_ID=$USER_ID");
?>