📄 submit.php

📁 泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。
💻 PHP
字号:
<?php

include_once( "inc/auth.php" );
include_once( "inc/utility_all.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";
$connection = openconnection( );
$STATE = "";
$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 ) )
{
	$DUTY_NAME = $ROW['DUTY_NAME'];
	$DUTY_TIME1 = $ROW['DUTY_TIME1'];
	$DUTY_TIME2 = $ROW['DUTY_TIME2'];
	$DUTY_TIME3 = $ROW['DUTY_TIME3'];
	$DUTY_TIME4 = $ROW['DUTY_TIME4'];
	$DUTY_TIME5 = $ROW['DUTY_TIME5'];
	$DUTY_TIME6 = $ROW['DUTY_TIME6'];
	$DUTY_TYPE1 = $ROW['DUTY_TYPE1'];
	$DUTY_TYPE2 = $ROW['DUTY_TYPE2'];
	$DUTY_TYPE3 = $ROW['DUTY_TYPE3'];
	$DUTY_TYPE4 = $ROW['DUTY_TYPE4'];
	$DUTY_TYPE5 = $ROW['DUTY_TYPE5'];
	$DUTY_TYPE6 = $ROW['DUTY_TYPE6'];
}
$CUR_TIME = date( "Y-m-d H:i:s", time( ) );
$query = "SELECT * from SYS_PARA where PARA_NAME='DUTY_INTERVAL'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$DUTY_INTERVAL = $ROW['PARA_VALUE'];
}
$sql = "SELECT count(*) FROM attend_leave WHERE USER_ID = '".$_SESSION['LOGIN_USER_ID']."'";
$sql .= " AND LEAVE_DATE1<='".$CUR_TIME."' AND LEAVE_DATE2>='".$CUR_TIME."' AND ALLOW = 1";
$cursor = exequery( $connection, $sql );
if ( ( $ROW = mysql_fetch_array( $cursor ) ) && $ROW[0] != 0 )
{
	$STATE = 3;
}
if ( $STATE != 3 )
{
	$sql = "SELECT COUNT(*) FROM attend_out WHERE USER_ID = '".$_SESSION['LOGIN_USER_ID']."'";
	$sql .= " AND TO_DAYS(SUBMIT_TIME ) = TO_DAYS('".$CUR_TIME."')";
	$sql .= " AND OUT_TIME1 <= '".$CUR_TIME."' AND OUT_TIME1>='".$OUT_TIME1."'";
	$sql .= " AND ALLOW = 1";
	$cursor = exequery( $connection, $sql );
	if ( ( $ROW = mysql_fetch_array( $cursor ) ) && $ROW[0] != 0 )
	{
		$STATE = 4;
	}
}
if ( $STATE != 3 && $STATE != 4 )
{
	$sql = "SELECT COUNT(*) FROM attend_evection WHERE ";
	$sql .= " USER_ID = '".$_SESSION['LOGIN_USER_ID']."' AND ";
	$sql .= " TO_DAYS(EVECTION_DATE1) <= TO_DAYS('".$CUR_TIME."') AND ";
	$sql .= " TO_DAYS(EVECTION_DATE2) >= TO_DAYS('".$CUR_TIME."')";
	$cursor = exequery( $connection, $sql );
	if ( ( $ROW = mysql_fetch_array( $cursor ) ) && $ROW[0] != 0 )
	{
		echo $ROW[0];
		$STATE = 5;
	}
}
$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 ) ) )
{
	$REGISTER_TYPE1 = $REGISTER_TYPE - 1;
	$query = "SELECT * from ATTEND_DUTY where USER_ID='{$LOGIN_USER_ID}' and REGISTER_TYPE='{$REGISTER_TYPE1}' and REGISTER_TIME<='{$CUR_TIME}' order by REGISTER_TIME desc";
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$REGISTER_TIME = $ROW['REGISTER_TIME'];
		if ( $_REQUEST['register_id'] == 1 && strtotime( $CUR_TIME ) - strtotime( $REGISTER_TIME ) <= $DUTY_INTERVAL * 60 )
		{
			message( "警告", $DUTY_INTERVAL."分钟内禁止连续考勤！" );
			button_back( );
			exit( );
		}
	}
	$DUTY_TYPE = "DUTY_TYPE".$REGISTER_TYPE;
	$DUTY_TIME = "DUTY_TIME".$REGISTER_TYPE;
	$CUR_TIME1 = date( "H:i:s", time( ) );
	if ( $STATE == "" )
	{
		if ( $$DUTY_TYPE == "1" && compare_time( $CUR_TIME1, $$DUTY_TIME ) == 1 )
		{
			$STATE = 1;
		}
		else if ( $$DUTY_TYPE == "2" && compare_time( $$DUTY_TIME, $CUR_TIME1 ) == 1 )
		{
			$STATE = 2;
		}
		else
		{
			$STATE = 0;
		}
	}
	$query = "insert into ATTEND_DUTY(USER_ID,REGISTER_TYPE,REGISTER_TIME,STATE) values ('{$LOGIN_USER_ID}','{$REGISTER_TYPE}','{$CUR_TIME}',".$STATE.")";
	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 + -