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

📄 vehicle_detail.php

📁 极限网络智能办公系统 Office Automation V3.0官方100%源代码.
💻 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 where V_ID='$V_ID'";

$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
  $V_MODEL=$ROW["V_MODEL"];
  $V_NUM=$ROW["V_NUM"];
  $V_DRIVER=$ROW["V_DRIVER"];
  $V_TYPE=$ROW["V_TYPE"];
  $V_DATE=$ROW["V_DATE"];
  $V_PRICE =$ROW["V_PRICE"];
  $V_ENGINE_NUM=$ROW["V_ENGINE_NUM"];
  $V_STATUS=$ROW["V_STATUS"];
  $V_REMARK=$ROW["V_REMARK"];
  $ATTACHMENT_ID=$ROW["ATTACHMENT_ID"];
  $ATTACHMENT_NAME=$ROW["ATTACHMENT_NAME"];
       
  if($V_DATE=="0000-00-00")
     $V_DATE="";


  $V_TYPE_DESC=get_code_name($V_TYPE,"VEHICLE_TYPE");
  
  if($V_STATUS==0)
     $V_STATUS_DESC="<font color=\"#00AA00\"><b>可用</b></font>";
  elseif($VU_STATUS==1)
     $V_STATUS_DESC="损坏";
  elseif($V_STATUS==2)
     $V_STATUS_DESC="维修中";
  elseif($V_STATUS==3)
    $V_STATUS_DESC="报废";
    
  $query = "SELECT count(*) from VEHICLE_USAGE where V_ID='$V_ID' and VU_STATUS!='4'";
  $cursor= exequery($connection,$query);
  if($ROW=mysql_fetch_array($cursor))
     $VU_COUNT=$ROW[0];
  if($VU_COUNT>0)
     $ORDER_DETAIL="<a href=\"javascript:;\" onClick=\"window.open('order_detail.php?V_ID=".$V_ID."','','height=400,width=700,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,left=250,top=170,resizable=yes');\" title=\"点击查看详情\">共".$VU_COUNT."条预定信息</a>";
  else
     $ORDER_DETAIL="无预定信息";
?>    
<table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3">
  <tr class="TableLine2">
      <td nowrap align="left" width="80" class="TableContent">型号:</td>
      <td nowrap align="left" class="TableData"><?=$V_MODEL?></td>
      <td class="TableData" width="250" rowspan="6">
<?
   if($ATTACHMENT_NAME=="")
      echo "<center>暂无照片</center>";
   else
      echo "<a href=\"/inc/attach.php?ATTACHMENT_ID=".($ATTACHMENT_ID*3+2)."&ATTACHMENT_NAME=".urlencode($ATTACHMENT_NAME)."\" target=\"_blank\" title=\"点击查看放大图片\"><img src='/inc/attach.php?ATTACHMENT_ID=".($ATTACHMENT_ID*3+2)."&ATTACHMENT_NAME=".urlencode($ATTACHMENT_NAME)."' width='250' border=1>";
?>
      </td>
  </tr>
  <tr class="TableLine1">
      <td nowrap align="left" width="80" class="TableContent">车牌号:</td>
      <td nowrap align="left" class="TableData"><?=$V_NUM?></td>
  </tr>
  <tr class="TableLine2">
      <td nowrap align="left" width="80" class="TableContent">司机:</td>
      <td nowrap align="left" class="TableData"><?=$V_DRIVER?></td>
  </tr>
  <tr class="TableLine1">
      <td nowrap align="left" width="80" class="TableContent">车辆类型:</td>
      <td nowrap align="left" class="TableData"><?=$V_TYPE_DESC?></td>
  </tr>
  <tr class="TableLine2">
      <td nowrap align="left" width="80" class="TableContent">购置日期:</td>
      <td nowrap align="left" class="TableData"><?=$V_DATE?></td>
  </tr>
  <tr class="TableLine1">
      <td nowrap align="left" width="80" class="TableContent">购买价格:</td>
      <td nowrap align="left" class="TableData"><?=$V_PRICE?></td>
  </tr>
  <tr class="TableLine2">
      <td nowrap align="left" width="80" class="TableContent">发动机号码:</td>
      <td nowrap align="left" class="TableData" colspan="2"><?=$V_ENGINE_NUM?></td>
  </tr>
  <tr class="TableLine1">
      <td nowrap align="left" width="80" class="TableContent">预定情况:</td>
      <td nowrap align="left" class="TableData" colspan="2"><?=$ORDER_DETAIL?></td>
  </tr>
  <tr class="TableLine1">
      <td nowrap align="left" width="80" class="TableContent">当前状态:</td>
      <td nowrap align="left" class="TableData" colspan="2"><?=$V_STATUS_DESC?></td>
  </tr>
  <tr class="TableLine2">
      <td nowrap align="left" width="80" class="TableContent">备注:</td>
      <td nowrap align="left" class="TableData" colspan="2"><?=$V_REMARK?></td>
  </tr>
  <tr align="center" class="TableControl">
      <td colspan="3">
        <input type="button" value="打印" class="BigButton" onclick="document.execCommand('Print');" title="直接打印表格页面">&nbsp;&nbsp;&nbsp;&nbsp;
        <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 + -