export.php

来自「通达OA2007SE源代码非常好的」· PHP 代码 · 共 306 行
PHP
306 行
<?
  include_once 'inc/auth.php';
  include_once 'inc/check_type.php';
  include_once 'inc/utility_all.php';
  ob_end_clean ();
  header ('Cache-control: private');
  header ('Content-type: application/vnd.ms-excel');
  header ('Content-Disposition: attachment; filename= 车辆使用记录.xls');
  echo '
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">
<head>
<title>车辆使用记录</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body topmargin="5">
 <table border="1" cellspacing="1" width="95%" class="small" cellpadding="3">
    <tr style="BACKGROUND: #D3E5FA; color';
  echo ': #000000; font-weight: bold;">
      <td align="center">车牌号</td>
      <td align="center">司机</td>
      <td align="center">申请人</td>
      <td align="center">申请时间</td>
      <td align="center">用车人</td>
      <td align="center">用车部门</td>
      <td align="center">事由</td>
      <td align="center">开始时间</td>
      <td align="center">结束时间</td>
      <td align="center">目的地</td>
   ';
  echo '   <td align="center">里程(公里)</td>
      <td align="center">调度员</td>
      <td align="center">当前状态</td>
      <td align="center">备注</td>
    </tr>
';
  if (($VU_REQUEST_DATE_MIN != ''))
  {
    $TIME_OK = is_date ($VU_REQUEST_DATE_MIN);
    if (!$TIME_OK)
    {
      message ('错误', '申请日期格式不对，应形如 1999-1-2');
      button_back ();
      exit ();
    }
    ($VU_REQUEST_DATE_MIN .= ' 00:00:00');
  }
  if (($VU_REQUEST_DATE_MAX != ''))
  {
    $TIME_OK = is_date ($VU_REQUEST_DATE_MAX);
    if (!$TIME_OK)
    {
      message ('错误', '申请日期格式不对，应形如 1999-1-2');
      button_back ();
      exit ();
    }
    ($VU_REQUEST_DATE_MAX .= ' 23:59:59');
  }
  if (($VU_START_MIN != ''))
  {
    $TIME_OK = is_date ($VU_START_MIN);
    if (!$TIME_OK)
    {
      message ('错误', '起始日期格式不对，应形如 1999-1-2');
      button_back ();
      exit ();
    }
    ($VU_START_MIN .= ' 00:00:00');
  }
  if (($VU_START_MAX != ''))
  {
    $TIME_OK = is_date ($VU_START_MAX);
    if (!$TIME_OK)
    {
      message ('错误', '起始日期格式不对，应形如 1999-1-2');
      button_back ();
      exit ();
    }
    ($VU_START_MAX .= ' 23:59:59');
  }
  if (($VU_END_MIN != ''))
  {
    $TIME_OK = is_date ($VU_END_MIN);
    if (!$TIME_OK)
    {
      message ('错误', '结束日期格式不对，应形如 1999-1-2');
      button_back ();
      exit ();
    }
    ($VU_END_MIN .= ' 00:00:00');
  }
  if (($VU_END_MAX != ''))
  {
    $TIME_OK = is_date ($VU_END_MAX);
    if (!$TIME_OK)
    {
      message ('错误', '结束日期格式不对，应形如 1999-1-2');
      button_back ();
      exit ();
    }
    ($VU_END_MAX .= ' 23:59:59');
  }
  if (($VU_STATUS != ''))
  {
    ($WHERE_STR .= (((''.' and VU_STATUS=\'').$VU_STATUS).'\''));
  }
  if (($V_ID != ''))
  {
    ($WHERE_STR .= (((''.' and V_ID=\'').$V_ID).'\''));
  }
  if (($VU_REQUEST_DATE_MIN != ''))
  {
    ($WHERE_STR .= (((''.' and VU_REQUEST_DATE>=\'').$VU_REQUEST_DATE_MIN).'\''));
  }
  if (($VU_REQUEST_DATE_MAX != ''))
  {
    ($WHERE_STR .= (((''.' and VU_REQUEST_DATE<=\'').$VU_REQUEST_DATE_MAX).'\''));
  }
  if (($VU_USER != ''))
  {
    ($WHERE_STR .= (((''.' and VU_USER like \'%').$VU_USER).'%\''));
  }
  if (($VU_DEPT != ''))
  {
    ($WHERE_STR .= (((''.' and VU_DEPT=\'').$VU_DEPT).'\''));
  }
  if (($VU_START_MIN != ''))
  {
    ($WHERE_STR .= (((''.' and VU_START>=\'').$VU_START_MIN).'\''));
  }
  if (($VU_START_MAX != ''))
  {
    ($WHERE_STR .= (((''.' and VU_START<=\'').$VU_START_MAX).'\''));
  }
  if (($VU_END_MIN != ''))
  {
    ($WHERE_STR .= (((''.' and VU_END>=\'').$VU_END_MIN).'\''));
  }
  if (($VU_END_MAX != ''))
  {
    ($WHERE_STR .= (((''.' and VU_END<=\'').$VU_END_MAX).'\''));
  }
  if (($TO_ID != ''))
  {
    ($WHERE_STR .= (((''.' and VU_PROPOSER=\'').$TO_ID).'\''));
  }
  if (($VU_OPERATOR != ''))
  {
    ($WHERE_STR .= (((''.' and VU_OPERATOR=\'').$VU_OPERATOR).'\''));
  }
  if (($VU_REASON != ''))
  {
    ($WHERE_STR .= (((''.' and VU_REASON like \'%').$VU_REASON).'%\''));
  }
  if (($VU_REMARK != ''))
  {
    ($WHERE_STR .= (((''.' and VU_REMARK like \'%').$VU_REMARK).'%\''));
  }
  if (($VU_DRIVER != ''))
  {
    ($WHERE_STR .= (((''.' and VU_DRIVER like \'%').$VU_DRIVER).'%\''));
  }
  $query = (('SELECT * from VEHICLE_USAGE where 1=1'.$WHERE_STR).' order by VU_STATUS,VU_START');
  $cursor = exequery ($connection, $query);
  $VU_COUNT = 0;
  while ($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 = '待批';
    }
    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=\'').$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 '    <tr>
      <td>';
    echo $V_NUM;
    echo '</td>
      <td align="center">';
    echo $VU_DRIVER;
    echo '</td>
      <td align="center">';
    echo $VU_PROPOSER_NAME;
    echo '</td>
      <td nowrap align="center" x:str="\'';
    echo $VU_REQUEST_DATE;
    echo '">';
    echo $VU_REQUEST_DATE;
    echo '</td>
      <td>';
    echo $VU_USER;
    echo '</td>
      <td>';
    echo $VU_DEPT;
    echo '</td>
      <td>';
    echo $VU_REASON;
    echo '</td>
      <td nowrap align="center" x:str="\'';
    echo $VU_START;
    echo '">';
    echo $VU_START;
    echo '</a></td>
      <td nowrap align="center" x:str="\'';
    echo $VU_END;
    echo '">';
    echo $VU_END;
    echo '</a></td>
      <td>';
    echo $VU_DESTINATION;
    echo '</a></td>
      <td align="right">';
    echo $VU_MILEAGE;
    echo '</a></td>
      <td align="center">';
    echo $VU_OPERATOR_NAME;
    echo '</a></td>
      <td align="center">';
    echo $VU_STATUS_DESC;
    echo '</a></td>
      <td>';
    echo $VU_REMARK;
    echo '</td>
    </tr>
';
  }
  echo '
  </table>
</body>
</html>
';
?>
export.php - 源码说明

本页面展示了「通达OA2007SE源代码非常好的」中的 export.php 源码文件，采用 PHP 编程语言编写，共 306 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。
虫虫下载站收录了大量与2007相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。
⌨️ 快捷键说明

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