📄 export.php
字号:
<?
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");
?>
<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: #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>
<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%'";
//============================ =======================================
$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="待批";
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"];
?>
<tr>
<td><?=$V_NUM?></td>
<td align="center"><?=$VU_DRIVER?></td>
<td align="center"><?=$VU_PROPOSER_NAME?></td>
<td nowrap align="center" x:str="'<?=$VU_REQUEST_DATE?>"><?=$VU_REQUEST_DATE?></td>
<td><?=$VU_USER?></td>
<td><?=$VU_DEPT?></td>
<td><?=$VU_REASON?></td>
<td nowrap align="center" x:str="'<?=$VU_START?>"><?=$VU_START?></a></td>
<td nowrap align="center" x:str="'<?=$VU_END?>"><?=$VU_END?></a></td>
<td><?=$VU_DESTINATION?></a></td>
<td align="right"><?=$VU_MILEAGE?></a></td>
<td align="center"><?=$VU_OPERATOR_NAME?></a></td>
<td align="center"><?=$VU_STATUS_DESC?></a></td>
<td><?=$VU_REMARK?></td>
</tr>
<?
}
?>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -