duty_update.php

通达网络办公 - Office Anywhere 2008 增强版100％源码(3.4.081216) 内含 通达OA2008增強版接近完美破解补丁20081216集 及 最新通达OA2008ADV(

<?php

include_once( "inc/auth.php" );
include_once( "inc/check_type.php" );
include_once( "inc/utility_all.php" );
$I = 1;
for ( ;	$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 );
?>