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

📄 history.php

📁 极限网络智能办公系统 Office Automation V3.0官方100%源代码.
💻 PHP
字号:
<?
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>


<?
 //---- 出差历史记录 -----
 $EVECTION_COUNT=0;

 $query = "SELECT * from ATTEND_EVECTION where USER_ID='$LOGIN_USER_ID' and STATUS='2' order by EVECTION_DATE1 desc";
 $cursor= exequery($connection,$query);
 while($ROW=mysql_fetch_array($cursor))
 {
    $EVECTION_COUNT++;

    $EVECTION_ID=$ROW["EVECTION_ID"];
    $EVECTION_DEST=$ROW["EVECTION_DEST"];

    $EVECTION_DATE1=$ROW["EVECTION_DATE1"];
    $EVECTION_DATE1=strtok($EVECTION_DATE1," ");

    $EVECTION_DATE2=$ROW["EVECTION_DATE2"];
    $EVECTION_DATE2=strtok($EVECTION_DATE2," ");
    
    $LEADER_ID=$ROW["LEADER_ID"];
    
    $USER_NAME="";
    $query = "SELECT * from USER where USER_ID='$LEADER_ID'";
    $cursor1= exequery($connection,$query);
    if($ROW=mysql_fetch_array($cursor1))
       $USER_NAME=$ROW["USER_NAME"];

    if($EVECTION_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"><?=$EVECTION_DEST?></td>
      <td nowrap align="center"><?=$USER_NAME?></td>
      <td nowrap align="center"><?=$EVECTION_DATE1?></td>
      <td nowrap align="center"><?=$EVECTION_DATE2?></td>
    </tr>
<?
 }

 if($EVECTION_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 + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -