📄 submit.php
字号:
<?php
include_once( "inc/auth.php" );
echo "\r\n<html>\r\n<head>\r\n<title>上下班登记</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n";
$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 ) || $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 "\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -