duty_update.php

极限网络智能办公系统 Office Automation V3.0官方100％源代码.

<?
include_once 'inc/auth.php';
include_once 'inc/check_type.php';
include_once 'inc/utility_all.php';
$connection = openconnection ();
for ($I = 1; $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);
			continue;
		}
		continue;
	}
	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);
				continue;
			}
			continue;
		}
		continue;
	}
}
header ('location: user.php?USER_ID=' . $USER_ID);
?>