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

📄 index.php

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

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





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

?>

⌨️ 快捷键说明

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