submit.php

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

PHP
79
字号
<?
include_once("inc/auth.php");
?>

<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"];}
    elseif($REGISTER_TYPE==2)
       {$DUTY_TIME=$ROW["DUTY_TIME2"];$DUTY_TYPE=$ROW["DUTY_TYPE2"];}
    elseif($REGISTER_TYPE==3)
       {$DUTY_TIME=$ROW["DUTY_TIME3"];$DUTY_TYPE=$ROW["DUTY_TYPE3"];}
    elseif($REGISTER_TYPE==4)
       {$DUTY_TIME=$ROW["DUTY_TIME4"];$DUTY_TYPE=$ROW["DUTY_TYPE4"];}
    elseif($REGISTER_TYPE==5)
       {$DUTY_TIME=$ROW["DUTY_TIME5"];$DUTY_TYPE=$ROW["DUTY_TYPE5"];}
    elseif($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(strtotime($REGISTER_TIME)-strtotime($CUR_TIME)> $DUTY_INTERVAL_BEFORE*60 || strtotime($CUR_TIME)-strtotime($REGISTER_TIME)>$DUTY_INTERVAL_AFTER*60)
 {
    
    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");
?>

</body>
</html>

⌨️ 快捷键说明

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