index.php

来自「极限网络智能办公系统 Office Automation V3.0官方100％源」· PHP 代码 · 共 352 行

PHP
352 行
字号 
<?
include_once 'inc/auth.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">
';
$CUR_DATE = date ('Y-m-d', time ());
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"> 今日外出审批</span><br>
	</td>
</tr>
</table>
<br>
';
if ($LOGIN_USER_ID == 'admin')
{
	$query = 'SELECT * from ATTEND_OUT,USER where ATTEND_OUT.USER_ID=USER.USER_ID and to_days(SUBMIT_TIME)=to_days(\'' . $CUR_DATE . '\') and ALLOW=\'0\' order by USER.USER_ID';
}
else
{
	$query = 'SELECT * from ATTEND_OUT,USER where ATTEND_OUT.USER_ID=USER.USER_ID and LEADER_ID=\'' . $LOGIN_USER_ID . '\' and to_days(SUBMIT_TIME)=to_days(\'' . $CUR_DATE . '\') and ALLOW=\'0\' order by USER.USER_ID';
}
$cursor = exequery ($connection, $query);
$OUT_COUNT = 0;
while ($ROW = mysql_fetch_array ($cursor))
{
	++$OUT_COUNT;
	$USER_ID = $ROW['USER_ID'];
	$USER_NAME = $ROW['USER_NAME'];
	$OUT_TYPE = $ROW['OUT_TYPE'];
	$OUT_TIME1 = $ROW['OUT_TIME1'];
	$OUT_TIME2 = $ROW['OUT_TIME2'];
	$ALLOW = $ROW['ALLOW'];
	$DEPT_ID = $ROW['DEPT_ID'];
	$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">
';
	}
	if ($OUT_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 $OUT_TYPE;
	echo '</td>
		<td nowrap align="center">';
	echo $OUT_TIME1;
	echo '</td>
		<td nowrap align="center">';
	echo $OUT_TIME2;
	echo '</td>
		<td nowrap align="center">
				<a href="out_confirm.php?CONFIRM=1&USER_ID=';
	echo $USER_ID;
	echo '">批准</a>&nbsp;
				<a href="out_confirm.php?CONFIRM=2&USER_ID=';
	echo $USER_ID;
	echo '">不批准</a>
		</td>
	</tr>
';
}
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>
	</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>
<br>
';
if ($LOGIN_USER_ID == 'admin')
{
	$query = 'SELECT * from ATTEND_LEAVE,USER where ATTEND_LEAVE.USER_ID=USER.USER_ID and status=\'1\' and allow in(\'0\',\'3\')';
}
else
{
	$query = 'SELECT * from ATTEND_LEAVE,USER where ATTEND_LEAVE.USER_ID=USER.USER_ID and LEADER_ID=\'' . $LOGIN_USER_ID . '\' and status=\'1\' and allow in(\'0\',\'3\')';
}
$cursor = exequery ($connection, $query);
$LEAVE_COUNT = 0;
while ($ROW = mysql_fetch_array ($cursor))
{
	++$LEAVE_COUNT;
	$LEAVE_ID = $ROW['LEAVE_ID'];
	$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'];
	$ALLOW = $ROW['ALLOW'];
	$DEPT_ID = $ROW['DEPT_ID'];
	$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 $LEAVE_DATE1;
	echo '</td>
		<td nowrap align="center">';
	echo $LEAVE_DATE2;
	echo '</td>
';
	if ($ALLOW == '0')
	{
		echo '      <td nowrap align="center">请假申请</td>
		<td nowrap align="center">
				<a href="leave_confirm.php?CONFIRM=1&LEAVE_ID=';
		echo $LEAVE_ID;
		echo '&USER_ID=';
		echo $USER_ID;
		echo '">批准</a>&nbsp;
				<a href="leave_confirm.php?CONFIRM=2&LEAVE_ID=';
		echo $LEAVE_ID;
		echo '&USER_ID=';
		echo $USER_ID;
		echo '">不批准</a>&nbsp;
';
	}
	else
	{
		echo '      <td nowrap align="center">销假申请</td>
		<td nowrap align="center">
				<a href="leave_confirm.php?STATUS=2&LEAVE_ID=';
		echo $LEAVE_ID;
		echo '&USER_ID=';
		echo $USER_ID;
		echo '">销假</a>
		</td>
';
	}
	echo '      </td>
	</tr>
';
}
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>
		<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>
<br>
';
if ($LOGIN_USER_ID == 'admin')
{
	$query = 'SELECT * from ATTEND_EVECTION,USER where ATTEND_EVECTION.USER_ID=USER.USER_ID and status=\'1\' and allow=\'0\'';
}
else
{
	$query = 'SELECT * from ATTEND_EVECTION,USER where ATTEND_EVECTION.USER_ID=USER.USER_ID and LEADER_ID=\'' . $LOGIN_USER_ID . '\' and status=\'1\' and allow=\'0\'';
}
$cursor = exequery ($connection, $query);
$EVECTION_COUNT = 0;
while ($ROW = mysql_fetch_array ($cursor))
{
	++$EVECTION_COUNT;
	$EVECTION_ID = $ROW['EVECTION_ID'];
	$USER_ID = $ROW['USER_ID'];
	$USER_NAME = $ROW['USER_NAME'];
	$REASON = $ROW['REASON'];
	$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'];
	$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 $REASON;
	echo '</td>
		<td nowrap align="center">';
	echo $EVECTION_DATE1;
	echo '</td>
		<td nowrap align="center">';
	echo $EVECTION_DATE2;
	echo '</td>
		<td nowrap align="center">
				<a href="evection_confirm.php?CONFIRM=1&EVECTION_ID=';
	echo $EVECTION_ID;
	echo '&USER_ID=';
	echo $USER_ID;
	echo '">批准</a>&nbsp;
				<a href="evection_confirm.php?CONFIRM=2&EVECTION_ID=';
	echo $EVECTION_ID;
	echo '&USER_ID=';
	echo $USER_ID;
	echo '">不批准</a>&nbsp;
		</td>
	</tr>
';
}
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>
		<td nowrap align="center">操作</td>
	</thead>
	</table>
';
}
else
{
	message ('', '无出差审批申请');
}
echo '
</body>
</html>';
?>

index.php - 源码说明

本页面展示了「极限网络智能办公系统 Office Automation V3.0官方100％源代码.」中的 index.php 源码文件，采用 PHP 编程语言编写，共 352 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与Automation相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

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