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

📄 vehicle_detail.php

📁 通达OA2007SE源代码 非常好的
💻 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 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>';
    }
    else
    {
      if (($VU_STATUS == 1))
      {
        $V_STATUS_DESC = '损坏';
      }
      else
      {
        if (($V_STATUS == 2))
        {
          $V_STATUS_DESC = '维修中';
        }
        else
        {
          if (($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 ((0 < $VU_COUNT))
    {
      $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=170,top=170,resizable=yes\');" title="点击查看详情">共').$VU_COUNT).'条预定信息</a>');
    }
    else
    {
      $ORDER_DETAIL = '无预定信息';
    }
    echo '<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">';
    echo $V_MODEL;
    echo '</td>
      <td class="TableData" width="40%" 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)).'" title="点击查看放大图片"><img src=\'/inc/attach.php?ATTACHMENT_ID=').(($ATTACHMENT_ID * 3) + 2)).'&ATTACHMENT_NAME=').urlencode ($ATTACHMENT_NAME)).'\' width=\'250\' border=1></a>');
    }
    echo '      </td>
  </tr>
  <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="TableLine2">
      <td nowrap align="left" width="80" class="TableContent">司机:</td>
      <td nowrap align="left" class="TableData">';
    echo $V_DRIVER;
    echo '</td>
  </tr>
  <tr class="TableLine1">
      <td nowrap align="left" width="80" class="TableContent">车辆类型:</td>
      <td nowrap align="left" class="TableData">';
    echo $V_TYPE_DESC;
    echo '</td>
  </tr>
  <tr class="TableLine2">
      <td nowrap align="left" width="80" class="TableContent">购置日期:</td>
      <td nowrap align="left" class="TableData">';
    echo $V_DATE;
    echo '</td>
  </tr>
  <tr class="TableLine1">
      <td nowrap align="left" width="80" class="TableContent">购买价格:</td>
      <td nowrap align="left" class="TableData">';
    echo $V_PRICE;
    echo '</td>
  </tr>
  <tr class="TableLine2">
      <td nowrap align="left" width="80" class="TableContent">发动机号码:</td>
      <td nowrap align="left" class="TableData" colspan="2">';
    echo $V_ENGINE_NUM;
    echo '</td>
  </tr>
  <tr class="TableLine1">
      <td nowrap align="left" width="80" class="TableContent">预定情况:</td>
      <td nowrap align="left" class="TableData" colspan="2">';
    echo $ORDER_DETAIL;
    echo '</td>
  </tr>
  <tr class="TableLine1">
      <td nowrap align="left" width="80" class="TableContent">当前状态:</td>
      <td nowrap align="left" class="TableData" colspan="2">';
    echo $V_STATUS_DESC;
    echo '</td>
  </tr>
  <tr class="TableLine2">
      <td nowrap align="left" width="80" class="TableContent">备注:</td>
      <td align="left" class="TableData" colspan="2">';
    echo $V_REMARK;
    echo '</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 ('', '无未找到相应记录!');
  }
  echo '
</body>
</html>
';
?>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -