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 + -
显示快捷键?