⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 duty_edit.php

📁 极限网络智能办公系统 Office Automation V3.0官方100％源代码.
💻 PHP
字号:
🔍 
<?
include_once 'inc/auth.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">
';
$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'];
}
$query = 'SELECT * from USER where USER_ID=\'' . $USER_ID . '\'';
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
	$USER_NAME = $ROW['USER_NAME'];
	$DEPT_ID = $ROW['DEPT_ID'];
}
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 $USER_NAME;
echo ' - ';
echo format_date ($SOME_DATE);
echo '</span><br>
	</td>
</tr>
</table>
<br>
';
message ('注意', '输入的时间格式要形如 12:12:12，不填写则代表未登记');
echo '
<form action="duty_update.php" name="form1">
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3" align="center">
<tr class="TableHeader">
';
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>
</tr>
';
}
$query1 = 'select * from DEPARTMENT where DEPT_ID=' . $DEPT_ID;
$cursor1 = exequery ($connection, $query1);
if ($ROW = mysql_fetch_array ($cursor1))
{
	$USER_DEPT_NAME = $ROW['DEPT_NAME'];
}
if ($USER_COUNT % 2 == 1)
{
	$TableLine = 'TableLine1';
}
else
{
	$TableLine = 'TableLine2';
}
echo '    <tr class="';
echo $TableLine;
echo '">
';
if ($DUTY_TIME1 != '')
{
	$query = 'SELECT * from ATTEND_DUTY where USER_ID=\'' . $USER_ID . '\' and to_days(REGISTER_TIME)=to_days(\'' . $SOME_DATE . '\') and REGISTER_TYPE=\'1\'';
	$cursor = exequery ($connection, $query);
	if ($ROW = mysql_fetch_array ($cursor))
	{
		$REGISTER_TIME1 = $ROW['REGISTER_TIME'];
		$REGISTER_TIME1 = strtok ($REGISTER_TIME1, ' ');
		$REGISTER_TIME1 = strtok (' ');
	}
	echo '      <td nowrap align="center">
		<input name="REGISTER_TIME1" value="';
	echo $REGISTER_TIME1;
	echo '" class="SmallInput" size="8">
		</td>
';
}
if ($DUTY_TIME2 != '')
{
	$query = 'SELECT * from ATTEND_DUTY where USER_ID=\'' . $USER_ID . '\' and to_days(REGISTER_TIME)=to_days(\'' . $SOME_DATE . '\') and REGISTER_TYPE=\'2\'';
	$cursor = exequery ($connection, $query);
	if ($ROW = mysql_fetch_array ($cursor))
	{
		$REGISTER_TIME2 = $ROW['REGISTER_TIME'];
		$REGISTER_TIME2 = strtok ($REGISTER_TIME2, ' ');
		$REGISTER_TIME2 = strtok (' ');
	}
	echo '      <td nowrap align="center">
		<input name="REGISTER_TIME2" value="';
	echo $REGISTER_TIME2;
	echo '" class="SmallInput" size="8">
		</td>
';
}
if ($DUTY_TIME3 != '')
{
	$query = 'SELECT * from ATTEND_DUTY where USER_ID=\'' . $USER_ID . '\' and to_days(REGISTER_TIME)=to_days(\'' . $SOME_DATE . '\') and REGISTER_TYPE=\'3\'';
	$cursor = exequery ($connection, $query);
	if ($ROW = mysql_fetch_array ($cursor))
	{
		$REGISTER_TIME3 = $ROW['REGISTER_TIME'];
		$REGISTER_TIME3 = strtok ($REGISTER_TIME3, ' ');
		$REGISTER_TIME3 = strtok (' ');
	}
	echo '      <td nowrap align="center">
		<input name="REGISTER_TIME3" value="';
	echo $REGISTER_TIME3;
	echo '" class="SmallInput" size="8">
		</td>
';
}
if ($DUTY_TIME4 != '')
{
	$query = 'SELECT * from ATTEND_DUTY where USER_ID=\'' . $USER_ID . '\' and to_days(REGISTER_TIME)=to_days(\'' . $SOME_DATE . '\') and REGISTER_TYPE=\'4\'';
	$cursor = exequery ($connection, $query);
	if ($ROW = mysql_fetch_array ($cursor))
	{
		$REGISTER_TIME4 = $ROW['REGISTER_TIME'];
		$REGISTER_TIME4 = strtok ($REGISTER_TIME4, ' ');
		$REGISTER_TIME4 = strtok (' ');
	}
	echo '      <td nowrap align="center">
		<input name="REGISTER_TIME4" value="';
	echo $REGISTER_TIME4;
	echo '" class="SmallInput" size="8">
		</td>
';
}
if ($DUTY_TIME5 != '')
{
	$query = 'SELECT * from ATTEND_DUTY where USER_ID=\'' . $USER_ID . '\' and to_days(REGISTER_TIME)=to_days(\'' . $SOME_DATE . '\') and REGISTER_TYPE=\'5\'';
	$cursor = exequery ($connection, $query);
	if ($ROW = mysql_fetch_array ($cursor))
	{
		$REGISTER_TIME5 = $ROW['REGISTER_TIME'];
		$REGISTER_TIME5 = strtok ($REGISTER_TIME5, ' ');
		$REGISTER_TIME5 = strtok (' ');
	}
	echo '      <td nowrap align="center">
		<input name="REGISTER_TIME5" value="';
	echo $REGISTER_TIME5;
	echo '" class="SmallInput" size="8">
		</td>
';
}
if ($DUTY_TIME6 != '')
{
	$query = 'SELECT * from ATTEND_DUTY where USER_ID=\'' . $USER_ID . '\' and to_days(REGISTER_TIME)=to_days(\'' . $SOME_DATE . '\') and REGISTER_TYPE=\'6\'';
	$cursor = exequery ($connection, $query);
	if ($ROW = mysql_fetch_array ($cursor))
	{
		$REGISTER_TIME6 = $ROW['REGISTER_TIME'];
		$REGISTER_TIME6 = strtok ($REGISTER_TIME6, ' ');
		$REGISTER_TIME6 = strtok (' ');
	}
	echo '      <td nowrap align="center">
		<input name="REGISTER_TIME6" value="';
	echo $REGISTER_TIME6;
	echo '" class="SmallInput" size="8">
		</td>
';
}
echo '   </tr>
</table>
<br>
<div align="center">
<input type="hidden" name="USER_ID" value="';
echo $USER_ID;
echo '">
<input type="hidden" name="SOME_DATE" value="';
echo $SOME_DATE;
echo '">
<input type="submit"  value="保存" class="BigButton">&nbsp;&nbsp;
<input type="button"  value="返回" class="BigButton" onClick="history.back();">
</div>
</form>
</body>
</html>';
?>

⌨️ 快捷键说明

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