history.php
来自「极限网络智能办公系统 Office Automation V3.0官方100%源」· PHP 代码 · 共 92 行
PHP
92 行
<?
include_once("inc/auth.php");
?>
<html>
<head>
<title>请假历史记录</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
<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>
<div align="center">
<input type="button" value="返回上页" class="BigButton" onClick="location='index.php';">
<br>
<br>
<?
//---- 请假历史记录 -----
$LEAVE_COUNT=0;
$query = "SELECT * from ATTEND_LEAVE where USER_ID='$LOGIN_USER_ID' and STATUS='2' order by LEAVE_DATE1 desc";
$cursor= exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))
{
$LEAVE_COUNT++;
$LEAVE_ID=$ROW["LEAVE_ID"];
$LEAVE_DATE1=$ROW["LEAVE_DATE1"];
$LEAVE_DATE2=$ROW["LEAVE_DATE2"];
$LEAVE_TYPE=$ROW["LEAVE_TYPE"];
$LEADER_ID=$ROW["LEADER_ID"];
$LEADER_NAME="";
$query1 = "SELECT * from USER where USER_ID='$LEADER_ID'";
$cursor1= exequery($connection,$query1);
if($ROW=mysql_fetch_array($cursor1))
$LEADER_NAME=$ROW["USER_NAME"];
if($LEAVE_COUNT==1)
{
?>
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
<?
}
if($LEAVE_COUNT%2==1)
$TableLine="TableLine1";
else
$TableLine="TableLine2";
?>
<tr class="<?=$TableLine?>">
<td nowrap align="center"><?=$LEAVE_TYPE?></td>
<td nowrap align="center"><?=$LEADER_NAME?></td>
<td nowrap align="center"><?=$LEAVE_DATE1?></td>
<td nowrap align="center"><?=$LEAVE_DATE2?></td>
</tr>
<?
}
if($LEAVE_COUNT>0)
{
?>
<thead class="TableHeader">
<td nowrap align="center">请假原因</td>
<td nowrap align="center">审批人员</td>
<td nowrap align="center">开始时间 <img border=0 src="/images/arrow_down.gif" width="11" height="10"></td>
<td nowrap align="center">结束时间</td>
</thead>
</table>
<?
}
else
message("","无历史记录");
?>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?