📄 index.php

📁 极限网络智能办公系统 Office Automation V3.0官方100％源代码.
💻 PHP
字号:
<?
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">
<script Language=JavaScript>
window.setTimeout(\'this.location.reload();\',60000);
</script>
</head>
<body class="bodycolor" topmargin="5">
';
if ($SOME_DATE != '')
{
	$TIME_OK = is_date ($SOME_DATE);
	if (!($TIME_OK))
	{
		message ('错误', '查询日期格式不对，应形如 1999-1-2');
		button_back ();
		exit ();
	}
}
$query = 'SELECT * from USER where USER_ID=\'' . $LOGIN_USER_ID . '\'';
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
	$POST_PRIV = $ROW['POST_PRIV'];
}
echo '
<div class="Big1" align="center">
<b>
[考勤查询 - ';
echo format_date ($SOME_DATE);
echo ']
</b>
</div>
<br>
<!------------------------------------- 上下班 ------------------------------->
<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"> 上下班</span>
	</td>
</tr>
</table>
<div align="center" class="Big1">
<form action="duty.php" name="form1">
<b>
部门：<select name="DEPARTMENT" class="BigSelect">
';
if ($POST_PRIV == '1')
{
	echo '          <option value="ALL_DEPT">所有部门</option>
';
}
echo my_dept_tree (0, $DEPT_ID, 1);
echo '        </select>&nbsp;&nbsp;
排班类型：<select name="DUTY_TYPE" class="BigSelect">
';
$query = 'SELECT * from ATTEND_CONFIG order by DUTY_TYPE';
$cursor = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor))
{
	$DUTY_TYPE = $ROW['DUTY_TYPE'];
	$DUTY_NAME = $ROW['DUTY_NAME'];
	echo '          <option value="';
	echo $DUTY_TYPE;
	echo '">';
	echo $DUTY_NAME;
	echo '</option>
';
}
echo '        </select>&nbsp;
			<input type="hidden" name="SOME_DATE" value="';
echo $SOME_DATE;
echo '">
			<input type="submit" value="查询" class="BigButton" title="查询指定日期的上下班时间">
</b>
</form>
</div>
<table width="95%" border="0" cellspacing="0" cellpadding="0" height="3">
 <tr>
 <td background="/images/dian1.gif" width="100%"></td>
 </tr>
</table>
<!------------------------------------- 外出人员 ------------------------------->
<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"> 外出人员</span><br>
	</td>
</tr>
</table>
';
$query = 'SELECT * from ATTEND_OUT,USER,DEPARTMENT where DEPARTMENT.DEPT_ID=USER.DEPT_ID and ATTEND_OUT.USER_ID=USER.USER_ID and to_days(SUBMIT_TIME)=to_days(\'' . $SOME_DATE . '\') order by DEPT_NO,USER.USER_ID';
$cursor = exequery ($connection, $query);
$OUT_COUNT = 0;
while ($ROW = mysql_fetch_array ($cursor))
{
	$USER_ID = $ROW['USER_ID'];
	$USER_NAME = $ROW['USER_NAME'];
	$OUT_TYPE = $ROW['OUT_TYPE'];
	$SUBMIT_TIME = $ROW['SUBMIT_TIME'];
	$OUT_TIME1 = $ROW['OUT_TIME1'];
	$OUT_TIME2 = $ROW['OUT_TIME2'];
	$ALLOW = $ROW['ALLOW'];
	$STATUS = $ROW['STATUS'];
	$DEPT_ID = $ROW['DEPT_ID'];
	$LEADER_ID = $ROW['LEADER_ID'];
	$LEADER_NAME = '';
	$query = 'SELECT * from USER where USER_ID=\'' . $LEADER_ID . '\'';
	$cursor1 = exequery ($connection, $query);
	if ($ROW = mysql_fetch_array ($cursor1))
	{
		$LEADER_NAME = $ROW['USER_NAME'];
	}
	if (is_dept_priv ($DEPT_ID))
	{
		++$OUT_COUNT;
		if ($STATUS == '0')
		{
			$STATUS_DESC = '外出';
		}
		else
		{
			if ($STATUS == '1')
			{
				$STATUS_DESC = '已归来';
			}
		}
		if ($ALLOW == '0')
		{
			$STATUS_DESC = '待批';
		}
		if ($ALLOW == '2')
		{
			$STATUS_DESC = '不批准';
		}
		$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 ($OUT_COUNT == 1)
		{
			echo '
	<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
';
		}
		echo '    <tr class="TableData">
		<td nowrap align="center">';
		echo $USER_DEPT_NAME;
		echo '</td>
		<td nowrap align="center">';
		echo $USER_NAME;
		echo '</td>
		<td nowrap align="center">';
		echo $OUT_TYPE;
		echo '</td>
		<td nowrap align="center">';
		echo $SUBMIT_TIME;
		echo '</td>
		<td nowrap align="center">';
		echo $OUT_TIME1;
		echo '</td>
		<td nowrap align="center">';
		echo $OUT_TIME2;
		echo '</td>
		<td nowrap align="center">';
		echo $LEADER_NAME;
		echo '</td>
		<td nowrap align="center">';
		echo $STATUS_DESC;
		echo '</td>
	</tr>
';
		continue;
	}
}
if (0 < $OUT_COUNT)
{
	echo '    <thead class="TableHeader">
		<td nowrap align="center">部门</td>
		<td nowrap align="center">姓名</td>
		<td nowrap align="center">外出原因</td>
		<td nowrap align="center">申请时间</td>
		<td nowrap align="center">外出时间</td>
		<td nowrap align="center">归来时间</td>
		<td nowrap align="center">批示领导</td>
		<td nowrap align="center">状态</td>
	</thead>
	</table>
';
}
else
{
	message ('', '无外出记录');
}
echo '
<br>
<table width="95%" border="0" cellspacing="0" cellpadding="0" height="3">
 <tr>
 <td background="/images/dian1.gif" width="100%"></td>
 </tr>
</table>
<!------------------------------------- 请假人员 ------------------------------->
<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"> 请假人员</span><br>
	</td>
</tr>
</table>
';
$query = 'SELECT * from ATTEND_LEAVE,USER,DEPARTMENT where DEPARTMENT.DEPT_ID=USER.DEPT_ID and ATTEND_LEAVE.USER_ID=USER.USER_ID and to_days(LEAVE_DATE1)<=to_days(\'' . $SOME_DATE . '\') and to_days(LEAVE_DATE2)>=to_days(\'' . $SOME_DATE . '\') and status=\'1\' and allow in(\'1\',\'3\') order by DEPT_NO,USER.USER_ID';
$cursor = exequery ($connection, $query);
$LEAVE_COUNT = 0;
while ($ROW = mysql_fetch_array ($cursor))
{
	$USER_ID = $ROW['USER_ID'];
	$USER_NAME = $ROW['USER_NAME'];
	$LEAVE_DATE1 = $ROW['LEAVE_DATE1'];
	$LEAVE_DATE2 = $ROW['LEAVE_DATE2'];
	$LEAVE_TYPE = $ROW['LEAVE_TYPE'];
	$DEPT_ID = $ROW['DEPT_ID'];
	$LEADER_ID = $ROW['LEADER_ID'];
	$LEADER_NAME = '';
	$query = 'SELECT * from USER where USER_ID=\'' . $LEADER_ID . '\'';
	$cursor1 = exequery ($connection, $query);
	if ($ROW = mysql_fetch_array ($cursor1))
	{
		$LEADER_NAME = $ROW['USER_NAME'];
	}
	if (is_dept_priv ($DEPT_ID))
	{
		++$LEAVE_COUNT;
		$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 ($LEAVE_COUNT == 1)
		{
			echo '
	<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
';
		}
		if ($LEAVE_COUNT % 2 == 1)
		{
			$TableLine = 'TableLine1';
		}
		else
		{
			$TableLine = 'TableLine2';
		}
		echo '    <tr class="';
		echo $TableLine;
		echo '">
		<td nowrap align="center">';
		echo $USER_DEPT_NAME;
		echo '</td>
		<td nowrap align="center">';
		echo $USER_NAME;
		echo '</td>
		<td nowrap align="center">';
		echo $LEAVE_TYPE;
		echo '</td>
		<td nowrap align="center">';
		echo $LEADER_NAME;
		echo '</td>
		<td nowrap align="center">';
		echo $LEAVE_DATE1;
		echo '</td>
		<td nowrap align="center">';
		echo $LEAVE_DATE2;
		echo '</td>
	</tr>
';
		continue;
	}
}
if (0 < $LEAVE_COUNT)
{
	echo '    <thead class="TableHeader">
		<td nowrap align="center">部门</td>
		<td nowrap align="center">姓名</td>
		<td nowrap align="center">请假原因</td>
		<td nowrap align="center">批示领导</td>
		<td nowrap align="center">开始日期</td>
		<td nowrap align="center">结束日期</td>
	</thead>
	</table>
';
}
else
{
	message ('', '无请假记录');
}
echo '
<br>
<table width="95%" border="0" cellspacing="0" cellpadding="0" height="3">
 <tr>
 <td background="/images/dian1.gif" width="100%"></td>
 </tr>
</table>
<!------------------------------------- 出差人员 ------------------------------->
<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"> 出差人员</span><br>
	</td>
</tr>
</table>
';
$query = 'SELECT * from ATTEND_EVECTION,USER,DEPARTMENT where DEPARTMENT.DEPT_ID=USER.DEPT_ID and ATTEND_EVECTION.USER_ID=USER.USER_ID and to_days(EVECTION_DATE1)<=to_days(\'' . $SOME_DATE . '\') and to_days(EVECTION_DATE2)>=to_days(\'' . $SOME_DATE . '\') and status=\'1\' order by DEPT_NO,USER.USER_ID';
$cursor = exequery ($connection, $query);
$EVECTION_COUNT = 0;
while ($ROW = mysql_fetch_array ($cursor))
{
	$USER_ID = $ROW['USER_ID'];
	$USER_NAME = $ROW['USER_NAME'];
	$EVECTION_DATE1 = $ROW['EVECTION_DATE1'];
	$EVECTION_DATE1 = strtok ($EVECTION_DATE1, ' ');
	$EVECTION_DATE2 = $ROW['EVECTION_DATE2'];
	$EVECTION_DATE2 = strtok ($EVECTION_DATE2, ' ');
	$EVECTION_DEST = $ROW['EVECTION_DEST'];
	$DEPT_ID = $ROW['DEPT_ID'];
	$LEADER_ID = $ROW['LEADER_ID'];
	$LEADER_NAME = '';
	$query = 'SELECT * from USER where USER_ID=\'' . $LEADER_ID . '\'';
	$cursor1 = exequery ($connection, $query);
	if ($ROW = mysql_fetch_array ($cursor1))
	{
		$LEADER_NAME = $ROW['USER_NAME'];
	}
	if (is_dept_priv ($DEPT_ID))
	{
		++$EVECTION_COUNT;
		$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 ($EVECTION_COUNT == 1)
		{
			echo '
	<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
';
		}
		if ($EVECTION_COUNT % 2 == 1)
		{
			$TableLine = 'TableLine1';
		}
		else
		{
			$TableLine = 'TableLine2';
		}
		echo '    <tr class="';
		echo $TableLine;
		echo '">
		<td nowrap align="center">';
		echo $USER_DEPT_NAME;
		echo '</td>
		<td nowrap align="center">';
		echo $USER_NAME;
		echo '</td>
		<td nowrap align="center">';
		echo $EVECTION_DEST;
		echo '</td>
		<td nowrap align="center">';
		echo $LEADER_NAME;
		echo '</td>
		<td nowrap align="center">';
		echo $EVECTION_DATE1;
		echo '</td>
		<td nowrap align="center">';
		echo $EVECTION_DATE2;
		echo '</td>
	</tr>
';
		continue;
	}
}
if (0 < $EVECTION_COUNT)
{
	echo '    <thead class="TableHeader">
		<td nowrap align="center">部门</td>
		<td nowrap align="center">姓名</td>
		<td nowrap align="center">出差地点</td>
		<td nowrap align="center">批示领导</td>
		<td nowrap align="center">开始日期</td>
		<td nowrap align="center">结束日期</td>
	</thead>
';
}
else
{
	message ('', '无出差记录');
}
echo '
</table>
<br>
<div align="center">
<input type="button"  value="返回" class="BigButton" onClick="location=\'../\';">
</div>
</body>
</html>';
?>
💿 文件大小 24085 K
👤 上传用户 happy_christina
📂 所属分类 OA系统
🏷️ 相关标签

#Automation #Office #3.0 #100
⌨️ 快捷键说明

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