?? usage_detail.php
字號:
<?
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
echo '
<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">';
echo '<s';
echo 'pan class="big3">車輛使用詳細信息</span><br>
</td>
</tr>
</table>
';
$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_REMARK = str_replace ('
', '<br>', $VU_REMARK);
$VU_DESTINATION = $ROW['VU_DESTINATION'];
$VU_DRIVER = $ROW['VU_DRIVER'];
$VU_OPERATOR = $ROW['VU_OPERATOR'];
$DEPT_MANAGER = $ROW['DEPT_MANAGER'];
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 = '待批';
}
else
{
if (($VU_STATUS == 1))
{
$VU_STATUS_DESC = '已準';
}
else
{
if (($VU_STATUS == 2))
{
$VU_STATUS_DESC = '使用中';
}
else
{
if (($VU_STATUS == 3))
{
$VU_STATUS_DESC = '未準';
}
else
{
if (($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=\'').$DEPT_MANAGER).'\'');
$cursor2 = exequery ($connection, $query);
if ($ROW2 = mysql_fetch_array ($cursor2))
{
$DEPT_MANAGER_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'];
}
echo '<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">';
echo $V_NUM;
echo '</td>
</tr>
<tr class="TableLine1">
<td nowrap align="left" width="80" class="TableContent">司機：</td>
<td nowrap align="left" class="TableData">';
echo $VU_DRIVER;
echo '</td>
</tr>
<tr class="TableLine2">
<td nowrap align="left" width="80" class="TableContent">申請人：</td>
<td nowrap align="left" class="TableData">';
echo $VU_PROPOSER_NAME;
echo '</td>
</tr>
<tr class="TableLine1">
<td nowrap align="left" width="80" class="TableContent">申請時間：</td>
<td nowrap align="left" class="TableData">';
echo $VU_REQUEST_DATE;
echo '</td>
</tr>
<tr class="TableLine2">
<td nowrap align="left" width="80" class="TableContent">用車人：</td>
<td nowrap align="left" class="TableData">';
echo $VU_USER;
echo '</td>
</tr>
<tr class="TableLine1">
<td nowrap align="left" width="80" class="TableContent">用車部門：</td>
<td nowrap align="left" class="TableData">';
echo $DEPT_NAME;
echo '</td>
</tr>
<tr class="TableLine2">
<td nowrap align="left" width="80" class="TableContent">事由：</td>
<td align="left" class="TableData">';
echo $VU_REASON;
echo '</td>
</tr>
<tr class="TableLine1">
<td nowrap align="left" width="80" class="TableContent">開始時間：</td>
<td nowrap align="left" class="TableData">';
echo $VU_START;
echo '</td>
</tr>
<tr class="TableLine2">
<td nowrap align="left" width="80" class="TableContent">結束時間：</td>
<td nowrap align="left" class="TableData">';
echo $VU_END;
echo '</td>
</tr>
<tr class="TableLine2">
<td nowrap align="left" width="80" class="TableContent">目的地：</td>
<td nowrap align="left" class="TableData">';
echo $VU_DESTINATION;
echo '</td>
</tr>
<tr class="TableLine1">
<td nowrap align="left" width="80" class="TableContent">里程：</td>
<td nowrap align="left" class="TableData">';
echo $VU_MILEAGE;
echo '</td>
</tr>
<tr class="TableLine2">
<td nowrap align="left" width="80" class="TableContent">調(diào)度員：</td>
<td nowrap align="left" class="TableData">';
echo $VU_OPERATOR_NAME;
echo '</td>
</tr>
<tr class="TableLine2">
<td nowrap align="left" width="80" class="TableContent">部門審批人：</td>
<td nowrap align="left" class="TableData">';
echo $DEPT_MANAGER_NAME;
echo '</td>
</tr>
<tr class="TableLine2">
<td nowrap align="left" width="80" class="TableContent">當前狀態(tài)：</td>
<td nowrap align="left" class="TableData">';
echo $VU_STATUS_DESC;
echo '</td>
</tr>
<tr class="TableLine1">
<td nowrap align="left" width="80" class="TableContent">備注：</td>
<td align="left" class="TableData">';
echo $VU_REMARK;
echo '</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 ('', '未找到相應記錄！');
}
echo '
</body>
</html>
';
?>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -