📄 usage_detail.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
include_once("inc/utility.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/vehicle.gif" width="24" height="24"><span class="big3">车辆使用详细信息</span><br>
</td>
</tr>
</table>
<?
$connection=OpenConnection();
$query = "SELECT * from VEHICLE_USAGE where VU_ID='$VU_ID'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$VU_ID=$ROW["VU_ID"];
$V_ID=$ROW["V_ID"];
$VU_PROPOSER=$ROW["VU_PROPOSER"];
$VU_REQUEST_DATE=$ROW["VU_REQUEST_DATE"];
$VU_USER=$ROW["VU_USER"];
$VU_REASON=$ROW["VU_REASON"];
$VU_START =$ROW["VU_START"];
$VU_END=$ROW["VU_END"];
$VU_MILEAGE=$ROW["VU_MILEAGE"];
$VU_DEPT=$ROW["VU_DEPT"];
$VU_STATUS=$ROW["VU_STATUS"];
$VU_REMARK=$ROW["VU_REMARK"];
$VU_DESTINATION=$ROW["VU_DESTINATION"];
$VU_DRIVER=$ROW["VU_DRIVER"];
$VU_OPERATOR=$ROW["VU_OPERATOR"];
if($VU_START=="0000-00-00 00:00:00")
$VU_START="";
if($VU_END=="0000-00-00 00:00:00")
$VU_END="";
if($VU_STATUS==0)
$VU_STATUS_DESC="待批";
elseif($VU_STATUS==1)
$VU_STATUS_DESC="已准";
elseif($VU_STATUS==2)
$VU_STATUS_DESC="使用中";
elseif($VU_STATUS==3)
$VU_STATUS_DESC="未准";
elseif($VU_STATUS==4)
$VU_STATUS_DESC="结束";
$query = "SELECT * from USER where USER_ID='$VU_PROPOSER'";
$cursor2= exequery($connection,$query);
if($ROW2=mysql_fetch_array($cursor2))
$VU_PROPOSER_NAME=$ROW2["USER_NAME"];
$query = "SELECT * from USER where USER_ID='$VU_OPERATOR'";
$cursor2= exequery($connection,$query);
if($ROW2=mysql_fetch_array($cursor2))
$VU_OPERATOR_NAME=$ROW2["USER_NAME"];
$query = "SELECT * from DEPARTMENT where DEPT_ID='$VU_DEPT'";
$cursor2= exequery($connection,$query);
if($ROW2=mysql_fetch_array($cursor2))
$DEPT_NAME=$ROW2["DEPT_NAME"];
$query = "SELECT * from VEHICLE where V_ID='$V_ID'";
$cursor2= exequery($connection,$query);
if($ROW2=mysql_fetch_array($cursor2))
$V_NUM=$ROW2["V_NUM"];
?>
<table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3">
<tr class="TableLine1">
<td nowrap align="left" width="80" class="TableContent">车牌号：</td>
<td nowrap align="left" class="TableData"><?=$V_NUM?></td>
</tr>
<tr class="TableLine1">
<td nowrap align="left" width="80" class="TableContent">司机：</td>
<td nowrap align="left" class="TableData"><?=$VU_DRIVER?></td>
</tr>
<tr class="TableLine2">
<td nowrap align="left" width="80" class="TableContent">申请人：</td>
<td nowrap align="left" class="TableData"><?=$VU_PROPOSER_NAME?></td>
</tr>
<tr class="TableLine1">
<td nowrap align="left" width="80" class="TableContent">申请时间：</td>
<td nowrap align="left" class="TableData"><?=$VU_REQUEST_DATE?></td>
</tr>
<tr class="TableLine2">
<td nowrap align="left" width="80" class="TableContent">用车人：</td>
<td nowrap align="left" class="TableData"><?=$VU_USER?></td>
</tr>
<tr class="TableLine1">
<td nowrap align="left" width="80" class="TableContent">用车部门：</td>
<td nowrap align="left" class="TableData"><?=$DEPT_NAME?></td>
</tr>
<tr class="TableLine2">
<td nowrap align="left" width="80" class="TableContent">事由：</td>
<td nowrap align="left" class="TableData"><?=$VU_REASON?></td>
</tr>
<tr class="TableLine1">
<td nowrap align="left" width="80" class="TableContent">开始时间：</td>
<td nowrap align="left" class="TableData"><?=$VU_START?></td>
</tr>
<tr class="TableLine2">
<td nowrap align="left" width="80" class="TableContent">结束时间：</td>
<td nowrap align="left" class="TableData"><?=$VU_END?></td>
</tr>
<tr class="TableLine2">
<td nowrap align="left" width="80" class="TableContent">目的地：</td>
<td nowrap align="left" class="TableData"><?=$VU_DESTINATION?></td>
</tr>
<tr class="TableLine1">
<td nowrap align="left" width="80" class="TableContent">里程：</td>
<td nowrap align="left" class="TableData"><?=$VU_MILEAGE?></td>
</tr>
<tr class="TableLine2">
<td nowrap align="left" width="80" class="TableContent">调度员：</td>
<td nowrap align="left" class="TableData"><?=$VU_OPERATOR_NAME?></td>
</tr>
<tr class="TableLine2">
<td nowrap align="left" width="80" class="TableContent">当前状态：</td>
<td nowrap align="left" class="TableData"><?=$VU_STATUS_DESC?></td>
</tr>
<tr class="TableLine1">
<td nowrap align="left" width="80" class="TableContent">备注：</td>
<td nowrap align="left" class="TableData"><?=$VU_REMARK?></td>
</tr>
<tr align="center" class="TableControl">
<td colspan="2">
<input type="button" value="打印" class="BigButton" onclick="document.execCommand('Print');" title="直接打印表格页面">
<input type="button" value="关闭" class="BigButton" onClick="window.close();" title="关闭窗口">
</td>
</tr>
</table>
<?
}
else
Message("","未找到相应记录！");
?>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -