📄 user_duty.php

📁 通达60％源码
💻 PHP
字号:
<?

/* King DeZender(http://www.dezend.org) 2006-03-01 */





include_once 'inc/auth.php';

include_once 'inc/check_type.php';

include_once 'inc/utility_all.php';

echo '

<html>

<head>

<title>上下班记录查询</title>

<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

</head>



<body class="bodycolor" topmargin="5">



';

if ($DATE1 != '')

{

	$TIME_OK = is_date ($DATE1);

	if (!($TIME_OK))

	{

		message ('错误', '起始日期格式不对，应形如 1999-1-2');

		button_back ();

		exit ();

	}

}



if ($DATE2 != '')

{

	$TIME_OK = is_date ($DATE2);

	if (!($TIME_OK))

	{

		message ('错误', '截止日期格式不对，应形如 1999-1-2');

		button_back ();

		exit ();

	}

}



if (compare_date ($DATE1, $DATE2) == 1)

{

	message ('错误', '查询的起始日期不能晚于截止日期');

	button_back ();

	exit ();

}



$query = 'SELECT to_days(\'' . $DATE2 . '\')-to_days(\'' . $DATE1 . '\') from ATTEND_CONFIG';

$cursor = exequery ($connection, $query);

if ($ROW = mysql_fetch_array ($cursor))

{

	$DAY_TOTAL = $ROW[0] + 1;

}



$query = 'SELECT * from USER where USER_ID=\'' . $USER_ID . '\'';

$cursor = exequery ($connection, $query);

if ($ROW = mysql_fetch_array ($cursor))

{

	$DUTY_TYPE = $ROW['DUTY_TYPE'];

	$USER_NAME = $ROW['USER_NAME'];

}



echo '

<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">

<tr>

	<td class="Big"><img src="/images/menu/attendance.gif" WIDTH="22" HEIGHT="20" align="absmiddle">

	<span class="big3"> 上下班查询结果 - [';

echo format_date ($DATE1);

echo ' 至 ';

echo format_date ($DATE2);

echo ' 共 ';

echo $DAY_TOTAL;

echo ' 天]</span><br>

	</td>

</tr>

</table>



<br>



';

$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'];

	$GENERAL = $ROW['GENERAL'];

	$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'];

}



echo '

<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3" align="center">

<tr class="TableHeader">

	<td nowrap align="center">日期</td>

';

if ($DUTY_TIME1 != '')

{

	if ($DUTY_TYPE1 == '1')

	{

		$DUTY_TYPE_DESC = '上班';

	}

	else

	{

		$DUTY_TYPE_DESC = '下班';

	}



	echo '    <td nowrap align="center">';

	echo $DUTY_TYPE_DESC;

	echo '(';

	echo $DUTY_TIME1;

	echo ')</td>

';

}



if ($DUTY_TIME2 != '')

{

	if ($DUTY_TYPE2 == '1')

	{

		$DUTY_TYPE_DESC = '上班';

	}

	else

	{

		$DUTY_TYPE_DESC = '下班';

	}



	echo '    <td nowrap align="center">';

	echo $DUTY_TYPE_DESC;

	echo '(';

	echo $DUTY_TIME2;

	echo ')</td>

';

}



if ($DUTY_TIME3 != '')

{

	if ($DUTY_TYPE3 == '1')

	{

		$DUTY_TYPE_DESC = '上班';

	}

	else

	{

		$DUTY_TYPE_DESC = '下班';

	}



	echo '    <td nowrap align="center">';

	echo $DUTY_TYPE_DESC;

	echo '(';

	echo $DUTY_TIME3;

	echo ')</td>

';

}



if ($DUTY_TIME4 != '')

{

	if ($DUTY_TYPE4 == '1')

	{

		$DUTY_TYPE_DESC = '上班';

	}

	else

	{

		$DUTY_TYPE_DESC = '下班';

	}



	echo '    <td nowrap align="center">';

	echo $DUTY_TYPE_DESC;

	echo '(';

	echo $DUTY_TIME4;

	echo ')</td>

';

}



if ($DUTY_TIME5 != '')

{

	if ($DUTY_TYPE5 == '1')

	{

		$DUTY_TYPE_DESC = '上班';

	}

	else

	{

		$DUTY_TYPE_DESC = '下班';

	}



	echo '    <td nowrap align="center">';

	echo $DUTY_TYPE_DESC;

	echo '(';

	echo $DUTY_TIME5;

	echo ')</td>

';

}



if ($DUTY_TIME6 != '')

{

	if ($DUTY_TYPE6 == '1')

	{

		$DUTY_TYPE_DESC = '上班';

	}

	else

	{

		$DUTY_TYPE_DESC = '下班';

	}



	echo '    <td nowrap align="center">';

	echo $DUTY_TYPE_DESC;

	echo '(';

	echo $DUTY_TIME6;

	echo ')</td>

';

}



echo '  </tr>



';

$query1 = 'SELECT * from ATTEND_DUTY where USER_ID=\'' . $USER_ID . '\' and to_days(REGISTER_TIME)>=to_days(\'' . $DATE1 . '\') and to_days(REGISTER_TIME)<=to_days(\'' . $DATE2 . '\') GROUP by to_days(REGISTER_TIME)';

$cursor1 = exequery ($connection, $query1);

$LINE_COUNT = 0;

while ($ROW = mysql_fetch_array ($cursor1))

{

	++$LINE_COUNT;

	$REGISTER_TIME = $ROW['REGISTER_TIME'];

	$SOME_DATE = strtok ($REGISTER_TIME, ' ');

	$WEEK = date ('w', strtotime ($SOME_DATE));

	$HOLIDAY = '';

	$query = 'select * from ATTEND_HOLIDAY where BEGIN_DATE <=\'' . $SOME_DATE . '\' and END_DATE>=\'' . $SOME_DATE . '\'';

	$cursor = exequery ($connection, $query);

	if ($ROW = mysql_fetch_array ($cursor))

	{

		$HOLIDAY = '<font color=\'#008000\'>节假日</font>';

	}

	else

	{

		if (find_id ($GENERAL, $WEEK))

		{

			$HOLIDAY = '<font color=\'#008000\'>公休日</font>';

		}

	}



	if ($HOLIDAY == '')

	{

		$TableLine = 'TableData';

	}

	else

	{

		$TableLine = 'TableContent';

	}



	$query = 'select * from ATTEND_EVECTION where USER_ID=\'' . $USER_ID . '\' and ALLOW=\'1\' and to_days(EVECTION_DATE1)<=to_days(\'' . $SOME_DATE . '\') and to_days(EVECTION_DATE2)>=to_days(\'' . $SOME_DATE . '\')';

	$cursor = exequery ($connection, $query);

	if ($ROW = mysql_fetch_array ($cursor))

	{

		$HOLIDAY = '<font color=\'#008000\'>出差</font>';

	}



	echo '    <tr class="';

	echo $TableLine;

	echo '">

		<td nowrap align="center">';

	echo $SOME_DATE;

	echo '(周';

	echo get_week ($SOME_DATE);

	echo ')</td>



';

	for ($I = 1; $I <= 6; ++$I)

	{

		$DUTY_TIME_I = 'DUTY_TIME' . $I;

		$DUTY_TIME_I = $$DUTY_TIME_I;

		$DUTY_TYPE_I = 'DUTY_TYPE' . $I;

		$DUTY_TYPE_I = $$DUTY_TYPE_I;

		if (!($DUTY_TIME_I == ''))

		{

			if (!($DUTY_TIME_I == '00:00:00'))

			{

				$HOLIDAY1 = '';

				if ($HOLIDAY == '')

				{

					$query = 'select * from ATTEND_LEAVE where USER_ID=\'' . $USER_ID . '\' and ALLOW=\'1\' and LEAVE_DATE1<=\'' . $SOME_DATE . ' ' . $DUTY_TIME_I . '\' and LEAVE_DATE2>=\'' . $SOME_DATE . ' ' . $DUTY_TIME_I . '\'';

					$cursor = exequery ($connection, $query);

					if ($ROW = mysql_fetch_array ($cursor))

					{

						$HOLIDAY1 = '<font color=\'#008000\'>请假</font>';

					}

				}

				else

				{

					$HOLIDAY1 = $HOLIDAY;

				}



				if ($HOLIDAY == '')

				{

					if ($HOLIDAY1 == '')

					{

						$query = 'select * from ATTEND_OUT where USER_ID=\'' . $USER_ID . '\' and ALLOW=\'1\' and to_days(SUBMIT_TIME)=to_days(\'' . $SOME_DATE . '\') and OUT_TIME1<=\'' . substr ($DUTY_TIME_I, 0, strrpos ($DUTY_TIME_I, ':')) . '\' and OUT_TIME2>=\'' . substr ($DUTY_TIME_I, 0, strrpos ($DUTY_TIME_I, ':')) . '\'';

						$cursor = exequery ($connection, $query);

						if ($ROW = mysql_fetch_array ($cursor))

						{

							$HOLIDAY1 = '<font color=\'#008000\'>外出</font>';

						}

					}

				}



				$REGISTER_TIME = '';

				$REMARK11 = '';

				$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_TIME = $ROW['REGISTER_TIME'];

					$REMAK = $ROW['REMARK'];

					$REGISTER_TIME = strtok ($REGISTER_TIME, ' ');

					$REGISTER_TIME = strtok (' ');

					if ($HOLIDAY1 == '')

					{

						if ($DUTY_TYPE_I == '1')

						{

							if (compare_time ($REGISTER_TIME, $DUTY_TIME_I) == 1)

							{

								$REGISTER_TIME .= ' 迟到';

								$REMARK11 = '<br>备注：' . $REMAK;

							}

						}

					}



					if ($HOLIDAY1 == '')

					{

						if ($DUTY_TYPE_I == '2')

						{

							if (compare_time ($REGISTER_TIME, $DUTY_TIME_I) == -1)

							{

								$REGISTER_TIME .= ' 早退';

								$REMARK11 = '<br>备注：' . $REMAK;

							}

						}

					}

				}

				else

				{

					if ($HOLIDAY1 == '')

					{

						$REGISTER_TIME = '未登记';

					}

					else

					{

						$REGISTER_TIME = $HOLIDAY1;

					}

				}



				echo '      <td nowrap align="center">';

				echo $REGISTER_TIME;

				echo $REMARK11;

				echo '</td>

';

				continue;

			}



			continue;

		}

	}



	echo '    </tr>

';

}



echo '

</table>



';

button_back ();

echo '

</body>

</html>';

?>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -