车辆派遣管理系统-09-派车单统计
发布时间
阅读量：
阅读量
今日完成任务：派车单统计功能及页面设计
核心代码：见下列插入的代码
遇到的问题：无
解决的方法：无
功能模块：派车单统计
需要角色：任意
数据加载：派车单信息列表、用车单位、车牌号码、驾驶员、业务员
数据验证：非空验证、历史日期验证
导出报表：excel文件
列表分页：AJAX分页查询
业务描述：
根据用车单位、车辆车牌号以及驾驶员姓名等信息，并结合业务员负责的相关数据进行查询统计，在指定出车日期范围内汇总派车单的各项详细信息，并形成相应的清单文档
单击左侧导航栏中的"查询统计"选项卡下的"派车单统计"菜单项，在右侧主题区域调用派车单统计子页面，并完整调用并显示所有的派车单数据进行分页浏览。在弹出的"选择查询条件"对话框中依次展开查看用车单位、车牌号、驾驶员及业务员等参数设置选项。在选定一个具体的参数后，在页面上调用并显示相关信息内容。随后，在确认具体日期范围后完成查询操作，并点击"生成报表"按钮以获取所需的数据导出功能。
视频演示地址：https://www.bilibili.com/video/BV1sV411z7AK/
图文演示：
派车单列表
统计查询
生成报表
派车单统计子页面html代码：
<table id="table0" width='100%' cellspacing="0" border='0'>
<tr align="left">
<td style="height:32px;">
<div class="cxtjDiv">
<input type="text" name="cxtj" value="--请选择查询条件--" readonly="readonly"/>
<ul>
<li>用车单位</li>
<li>车牌号码</li>
<li>驾驶员</li>
<li>业务员</li>
</ul>
</div>
<b id="tjtb"><img src="img/down.png" width="10px"/></b>
<div class="dataDiv">
<input type="text" name="sj" value="" readonly="readonly"/>
<input type="hidden" name="bh" value=""/>
<ul>
</ul>
</div>
<b id="tjtb2"><img src="img/down.png" width="10px"/></b>
<span style="margin-left:25px;">出车日期范围:</span>
<span>
<input type="date" name="start" />
</span>
<span>--</span>
<span>
<input type="date" name="end" />
</span>
<span style="margin-top:4px;margin-bottom:4px;margin-left:10px;">
<button onclick="tjcx()">统 计 查 询</button>
</span>
<span style="margin-top:4px;margin-bottom:4px;margin-left:10px;">
<button onclick="scbb()">生 成 报 表</button>
</span>
</td>
</tr>
</table>
<table class="table1" width='100%' cellspacing="0" border='0'>
<tr align="left">
<td width="12%">派车单号</td>
<td width="8%">登记日期</td>
<td width="8%">出车日期</td>
<td width="7%">车牌号</td>
<td width="5%">业务员</td>
<td width="5%">联系人</td>
<td width="8%">客户电话</td>
<td width="6%">租车费</td>
<td width="5%">实收</td>
<td width="5%">缴费</td>
<td width="5%">审核</td>
<td width="5%">油费</td>
<td width="5%">过桥费</td>
<td width="5%">停车费</td>
<td width="5%">车补贴</td>
<td width="">行驶公里</td>
</tr>
</table>
<table class="list" width='100%' cellspacing="0">
</table>
<p class="pageManager">
<span><input type="hidden" name="rows" value="10"/></span>
<b >
<button onclick="first()">首页</button>
<button onclick="prev()">上一页</button>
<button onclick="next()">下一页</button>
<button onclick="last()">尾页</button>
第
<select name="toNumPage" onchange="changeNumPage()">
<option value="1">1</option>
</select>
页
共
<span></span>
页
</b>
</p>
<div class="updatePageDiv">
<div class="updatePage">
<h2>派车月结算信息<span><sup onclick="closeUpdatePageDiv()">×</sup></span></h2>
<form name="pcddjForm" class="layui-form pcddjForm">
<table class="list1" width='' cellpadding="0" cellspacing="0">
<tr>
<td> </td>
</tr>
<tr >
<td class="layui-form-label">车牌号</td>
<td>
<input type="text" name="cphm" class="layui-input" readonly="readonly"/>
</td>
<td class="layui-form-label">结算年份</td>
<td>
<input type="text" name="jsnf" class="layui-input" readonly="readonly"/>
</td>
<td class="layui-form-label">结算月份</td>
<td>
<input type="text" name="jsyf" class="layui-input" readonly="readonly"/>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td class="layui-form-label">总营业额</td>
<td>
<input type="text" name="zyye" class="layui-input" readonly="readonly"/>
</td>
<td class="layui-form-label">总公里数</td>
<td>
<input type="text" name="zgls" class="layui-input" readonly="readonly"/>
</td>
<td class="layui-form-label">总油费</td>
<td>
<input type="text" name="yf" class="layui-input" readonly="readonly"/>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td class="layui-form-label">总过桥费</td>
<td>
<input type="text" name="gqf" class="layui-input" readonly="readonly"/>
</td>
<td class="layui-form-label">总停车费</td>
<td>
<input type="text" name="tcf" class="layui-input" readonly="readonly"/>
</td>
<td class="layui-form-label">总修理费</td>
<td>
<input type="text" name="xlf" class="layui-input" readonly="readonly"/>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td class="layui-form-label">轮胎耗损费</td>
<td>
<input type="text" name="ltf" class="layui-input" readonly="readonly"/>
</td>
<td class="layui-form-label">总工资费</td>
<td>
<input type="text" name="gz" class="layui-input" readonly="readonly"/>
</td>
<td class="layui-form-label">运营毛利润</td>
<td>
<input type="text" name="mlr" class="layui-input" readonly="readonly"/>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td> </td>
</tr>
</table>
</form>
<script>
layui.use('form', function() {
var form = layui.form;
});
</script>
<p>
<span class="bc">确认结算</span>
<span onclick="closeUpdatePageDiv()">取消</span>
</p>
</div>
</div>派车单统计子页面js代码：
function loadPage(rows,page,cxtj,bh,start,end){
$.ajax({
url:'pcdtjList',
type:'post',
data:'rows='+rows+'&row='+((page-1)*rows)+'&cxtj='+cxtj+'&bh='+bh+'&start='+start+'&end='+end,
async:false,
success:function(data){
var arr = eval(data);
if(arr.length==0){
$("#message").html("暂无派车单信息！");
var left = $("#message").width()/2;
$("#message").css("left",$(window).width()/2-left);
$("#message").css("top",270);
$("#message").fadeIn(1000);
messageOut();
return;
}
var row="";
$.each(arr,function(i,o){
row +="<tr>";
row +="<td width='12%'>"+o.pcdh+"</td>";
row +="<td width='8%'>"+o.djrq+"</td>";
row +="<td width='8%'>"+o.ccrq+"</td>";
row +="<td width='7%'>"+o.cphm+"</td>";
row +="<td width='5%'>"+o.ywyxm+"</td>";
row +="<td width='5%'>"+o.lxr+"</td>";
row +="<td width='8%'>"+o.lxdh+"</td>";
row +="<td width='5%'>"+o.zcf+".00</td>";
if(o.sjsf==''){
row +="<td width='5%'>0.00</td>";
}else{
row +="<td width='5%'>"+o.sjsf+".00</td>";
}
if(o.zt=='未缴费'||o.zt=='未缴清'){
row +="<td width='5%' style='color:#f66;'>"+o.zt+"</td>";
}else{
row +="<td width='5%'>"+o.zt+"</td>";
}
if(o.sh=='未审核'){
row +="<td width='5%' style='color:#f66;'>"+o.sh+"</td>";
}else{
row +="<td width='5%'>"+o.sh+"</td>";
}
if(typeof o.yf != 'number'){
row +="<td width='5%'>0.00</td>";
}else{
row +="<td width='5%'>"+o.yf+".00</td>";
}
if(typeof o.gqf != 'number'){
row +="<td width='5%'>0.00</td>";
}else{
row +="<td width='5%'>"+o.gqf+".00</td>";
}
if(typeof o.tcf != 'number'){
row +="<td width='5%'>0.00</td>";
}else{
row +="<td width='5%'>"+o.tcf+".00</td>";
}
if(typeof o.cbf != 'number'){
row +="<td width='5%'>0.00</td>";
}else{
row +="<td width='5%'>"+o.cbf+".00</td>";
}
if(typeof o.xsgls != 'number'){
row +="<td width='5%'>0</td>";
}else{
row +="<td width='5%'>"+o.xsgls+"</td>";
}
row +="</tr>";
});
$(".list").html(row);
$.ajax({
url:'pcdtjPages',
type:'post',
data:'rows='+$('.pageManager>span>input').val(),
aysnc:false,
success:function(data){
$(".pageManager>b>span").html(data);
var options = "";
var n = parseInt(data);
for(var i=1;i<=n;i++){
if(page==i){
options+="<option value='"+i+"' selected>"+i+"</option>";
}else{
options+="<option value='"+i+"'>"+i+"</option>";
}
}
$(".pageManager select[name='toNumPage']").html(options);
}
});
}
});
}
$(function(){
var rows = $('.pageManager>span>input').val();
var page = $('.pageManager>b>select').val();
loadPage(rows,page,'','','','');
});
function changeNumPage(){
var rows = $(".pageManager input[name='rows']").val();
var page = $(".pageManager select[name='toNumPage']").val();
var cxtj = $("input[name='cxtj']").val();
var bh = $("input[name='bh']").val();
var start = $("input[name='start']").val();
var end = $("input[name='end']").val();
if((typeof cxtj)=='undefined'||cxtj=='--请选择查询条件--'){
cxtj="";
}
if((typeof bh)=='undefined'){
bh="";
}
if((typeof start)=='undefined'){
start="";
}
if((typeof end)=='undefined'){
end="";
}
loadPage(rows,page,cxtj,bh,start,end);
}
function first(){
var rows = $(".pageManager input[name='rows']").val();
var page = 1;
var cxtj = $("input[name='cxtj']").val();
var bh = $("input[name='bh']").val();
var start = $("input[name='start']").val();
var end = $("input[name='end']").val();
if((typeof cxtj)=='undefined'||cxtj=='--请选择查询条件--'){
cxtj="";
}
if((typeof bh)=='undefined'){
bh="";
}
if((typeof start)=='undefined'){
start="";
}
if((typeof end)=='undefined'){
end="";
}
loadPage(rows,page,cxtj,bh,start,end);
}
function last(){
var rows = $(".pageManager input[name='rows']").val();
var pages = $(".pageManager>b>span").html();
var cxtj = $("input[name='cxtj']").val();
var bh = $("input[name='bh']").val();
var start = $("input[name='start']").val();
var end = $("input[name='end']").val();
if((typeof cxtj)=='undefined'||cxtj=='--请选择查询条件--'){
cxtj="";
}
if((typeof bh)=='undefined'){
bh="";
}
if((typeof start)=='undefined'){
start="";
}
if((typeof end)=='undefined'){
end="";
}
loadPage(rows,pages,cxtj,bh,start,end);
}
function prev(){
var rows = $(".pageManager input[name='rows']").val();
var page = parseInt($(".pageManager select[name='toNumPage']").val());
if(page-1<1){
$(".pageManager select[name='toNumPage']").children(":last").prop("selected","true");
last();
}else{
$(".pageManager select[name='toNumPage']").children(":eq("+(page-1)+")").prop("selected","true");
var cxtj = $("input[name='cxtj']").val();
var bh = $("input[name='bh']").val();
var start = $("input[name='start']").val();
var end = $("input[name='end']").val();
if((typeof cxtj)=='undefined'||cxtj=='--请选择查询条件--'){
cxtj="";
}
if((typeof bh)=='undefined'){
bh="";
}
if((typeof start)=='undefined'){
start="";
}
if((typeof end)=='undefined'){
end="";
}
loadPage(rows,page-1,cxtj,bh,start,end);
}
}
function next(){
var rows = $(".pageManager input[name='rows']").val();
var page = parseInt($(".pageManager select[name='toNumPage']").val());
var pages = parseInt($(".pageManager>b>span").html());
if(page+1>pages){
$(".pageManager select[name='toNumPage']").children(":eq(0)").prop("selected","true");
first();
}else{
$(".pageManager select[name='toNumPage']").children(":eq("+(page+1)+")").prop("selected","true");
var cxtj = $("input[name='cxtj']").val();
var bh = $("input[name='bh']").val();
var start = $("input[name='start']").val();
var end = $("input[name='end']").val();
if((typeof cxtj)=='undefined'||cxtj=='--请选择查询条件--'){
cxtj="";
}
if((typeof bh)=='undefined'){
bh="";
}
if((typeof start)=='undefined'){
start="";
}
if((typeof end)=='undefined'){
end="";
}
loadPage(rows,page+1,cxtj,bh,start,end);
}
}
var bj=0;
$(function(){
$(".cxtjDiv input[name='cxtj'] , #tjtb").click(function(){
$(".cxtjDiv>ul").slideDown();
$("#tjtb>img").prop("src","img/up.png");
bj=1;
});
$(document).mousedown(function(){
if(bj==1){
var ulLeft = $(".cxtjDiv ul").offset().left;
var ulTop = $(".cxtjDiv ul").offset().top;
if(event.x>=ulLeft && event.x<=ulLeft+180 &&event.y>=ulTop&&event.y<=ulTop+116){
}else{
$(".cxtjDiv ul").slideUp();
bj=0;
}
}
});
$(".cxtjDiv ul li").click(function(){
var cxtj = $(this).html();
$(".cxtjDiv input[name='cxtj']").val(cxtj);
$("#tjtb img").attr("src","img/down.png");
$(".cxtjDiv input[name='cxtj']").css("padding-left","30px").css("color","#069");
bj=0;
$(".dataDiv input[name='sj']").css("padding-left","30px").css("color","#069");
$(".cxtjDiv ul").slideUp();
if(cxtj=='用车单位'){
$.ajax({
url:'pcdtjYcdw',
async:false,
success:function(data){
var arr = eval(data);
var lis="";
$.each(arr,function(i,o){
if(i==0){
$(".dataDiv input[name='sj']").val(o.ycdw);
$(".dataDiv input[name='bh']").val(o.khbh);
}
lis+="<li bh='"+o.khbh+"'>"+o.ycdw+"</li>";
$(".dataDiv ul").html(lis);
});
}
});
$(".dataDiv input[name='sj'] , #tjtb2").click(function(){
$(".dataDiv>ul").slideDown();
$("#tjtb2 img").prop("src","img/up.png");
bj2=1;
});
$(document).mousedown(function(){
if(bj2==1){
var ulLeft = $(".dataDiv ul").offset().left;
var ulTop = $(".dataDiv ul").offset().top;
if(event.x>=ulLeft && event.x<=ulLeft+180 &&event.y>=ulTop&&event.y<=ulTop+116){
}else{
$(".dataDiv ul").slideUp();
$("#tjtb2 img").prop("src","img/down.png");
bj2=0;
}
}
});
$(".dataDiv ul li").click(function(){
$(".dataDiv input[name='sj']").val($(this).html());
$(".dataDiv input[name='bh']").val($(this).attr("bh"));
$("#tjtb2 img").prop("src","img/down.png");
bj2=0;
$(".dataDiv ul").slideUp();
});
}
if(cxtj=='车牌号码'){
$.ajax({
url:'pcdtjCphm',
async:false,
success:function(data){
var arr = eval(data);
var lis="";
$.each(arr,function(i,o){
if(i==0){
$(".dataDiv input[name='sj']").val(o.cphm);
$(".dataDiv input[name='bh']").val(o.clbh);
}
lis+="<li bh='"+o.clbh+"'>"+o.cphm+"</li>";
$(".dataDiv ul").html(lis);
});
}
});
$(".dataDiv input[name='sj'] , #tjtb2").click(function(){
$(".dataDiv>ul").slideDown();
$("#tjtb2 img").prop("src","img/up.png");
bj2=1;
});
$(document).mousedown(function(){
if(bj2==1){
var ulLeft = $(".dataDiv ul").offset().left;
var ulTop = $(".dataDiv ul").offset().top;
if(event.x>=ulLeft && event.x<=ulLeft+180 &&event.y>=ulTop&&event.y<=ulTop+116){
}else{
$(".dataDiv ul").slideUp();
$("#tjtb2 img").prop("src","img/down.png");
bj2=0;
}
}
});
$(".dataDiv ul li").click(function(){
$(".dataDiv input[name='sj']").val($(this).html());
$(".dataDiv input[name='bh']").val($(this).attr("bh"));
$("#tjtb2 img").prop("src","img/down.png");
bj2=0;
$(".dataDiv ul").slideUp();
});
}
if(cxtj=='驾驶员'){
$.ajax({
url:'pcdtjJsy',
async:false,
success:function(data){
var arr = eval(data);
var lis="";
$.each(arr,function(i,o){
if(i==0){
$(".dataDiv input[name='sj']").val(o.jsyxm);
$(".dataDiv input[name='bh']").val(o.jsybh);
}
lis+="<li bh='"+o.jsybh+"'>"+o.jsyxm+"</li>";
$(".dataDiv ul").html(lis);
});
}
});
$(".dataDiv input[name='sj'] , #tjtb2").click(function(){
$(".dataDiv>ul").slideDown();
$("#tjtb2 img").prop("src","img/up.png");
bj2=1;
});
$(document).mousedown(function(){
if(bj2==1){
var ulLeft = $(".dataDiv ul").offset().left;
var ulTop = $(".dataDiv ul").offset().top;
if(event.x>=ulLeft && event.x<=ulLeft+180 &&event.y>=ulTop&&event.y<=ulTop+116){
}else{
$(".dataDiv ul").slideUp();
$("#tjtb2 img").prop("src","img/down.png");
bj2=0;
}
}
});
$(".dataDiv ul li").click(function(){
$(".dataDiv input[name='sj']").val($(this).html());
$(".dataDiv input[name='bh']").val($(this).attr("bh"));
$("#tjtb2 img").prop("src","img/down.png");
bj2=0;
$(".dataDiv ul").slideUp();
});
}
if(cxtj=='业务员'){
$.ajax({
url:'pcdtjYwy',
async:false,
success:function(data){
var arr = eval(data);
var lis="";
$.each(arr,function(i,o){
if(i==0){
$(".dataDiv input[name='sj']").val(o.ywyxm);
$(".dataDiv input[name='bh']").val(o.ywybh);
}
lis+="<li bh='"+o.ywybh+"'>"+o.ywyxm+"</li>";
$(".dataDiv ul").html(lis);
});
}
});
$(".dataDiv input[name='sj'] , #tjtb2").click(function(){
$(".dataDiv>ul").slideDown();
$("#tjtb2 img").prop("src","img/up.png");
bj2=1;
});
$(document).mousedown(function(){
if(bj2==1){
var ulLeft = $(".dataDiv ul").offset().left;
var ulTop = $(".dataDiv ul").offset().top;
if(event.x>=ulLeft && event.x<=ulLeft+180 &&event.y>=ulTop&&event.y<=ulTop+116){
}else{
$(".dataDiv ul").slideUp();
$("#tjtb2 img").prop("src","img/down.png");
bj2=0;
}
}
});
$(".dataDiv ul li").click(function(){
$(".dataDiv input[name='sj']").val($(this).html());
$(".dataDiv input[name='bh']").val($(this).attr("bh"));
$("#tjtb2 img").prop("src","img/down.png");
bj2=0;
$(".dataDiv ul").slideUp(1000);
});
}
$(".dataDiv").fadeIn();
$("#tjtb2").show();
});
});
var bj2=0;
function tjcx(){
sc=1;
var cxtj = $("input[name='cxtj']").val();
if(cxtj=='--请选择查询条件--'){
$("#message").html("请先选择统计的查询条件！");
var left = $("#message").width()/2;
$("#message").css("left",$(window).width()/2-left);
$("#message").css("top",270);
$("#message").fadeIn(1000);
messageOut();
return;
}
var cxtj = $("input[name='cxtj']").val();
var bh = $("input[name='bh']").val();
var cxtj = $("input[name='cxtj']").val();
var bh = $("input[name='bh']").val();
var start = $("input[name='start']").val();
if(start==''){
$("#message").html("请选择开始日期！");
var left = $("#message").width()/2;
$("#message").css("left",$(window).width()/2-left);
$("#message").css("top",270);
$("#message").fadeIn(1000);
messageOut();
return;
}
var startDate = new Date(start).getTime();
var now = new Date().getTime();
if(now-startDate<=24*60*60*1000){
$("#message").html("开始日期请选择历史日期！");
var left = $("#message").width()/2;
$("#message").css("left",$(window).width()/2-left);
$("#message").css("top",270);
$("#message").fadeIn(1000);
messageOut();
return;
}
var cxtj = $("input[name='cxtj']").val();
var bh = $("input[name='bh']").val();
var start = $("input[name='start']").val();
var end = $("input[name='end']").val();
if(end==''){
$("#message").html("请选择截止日期！");
var left = $("#message").width()/2;
$("#message").css("left",$(window).width()/2-left);
$("#message").css("top",270);
$("#message").fadeIn(1000);
messageOut();
return;
}
var endDate = new Date(end).getTime();
if(now-endDate<=24*60*60*1000){
$("#message").html("截止日期请选择历史日期！");
var left = $("#message").width()/2;
$("#message").css("left",$(window).width()/2-left);
$("#message").css("top",270);
$("#message").fadeIn(1000);
messageOut();
return;
}
if((endDate-startDate)/1000/60/60<24){
$("#message").html("开始日期到结束日期至少要相隔一天！");
var left = $("#message").width()/2;
$("#message").css("left",$(window).width()/2-left);
$("#message").css("top",270);
$("#message").fadeIn(1000);
messageOut();
return;
}
var rows = $('.pageManager>span>input').val();
var page = $('.pageManager>b>select').val();
loadPage(rows,page,cxtj,bh,start,end);
}
var sc=0;
function scbb(){
if(sc==0){
$("#message").html("请查询后再进行报表导出！");
var left = $("#message").width()/2;
$("#message").css("left",$(window).width()/2-left);
$("#message").css("top",270);
$("#message").fadeIn(1000);
messageOut();
return;
}
var cxtj = $("input[name='cxtj']").val();
var bh = $("input[name='bh']").val();
var start = $("input[name='start']").val();
var end = $("input[name='end']").val();
$.ajax({
url:'pcdtjList2',
type:'post',
data:'&cxtj='+cxtj+'&bh='+bh+'&start='+start+'&end='+end,
async:false,
success:function(data){
var arrData = eval(data);
if(arrData.length==0){
$("#message").html("未查询到派车单信息，不能生成报表！");
var left = $("#message").width()/2;
$("#message").css("left",$(window).width()/2-left);
$("#message").css("top",270);
$("#message").fadeIn(1000);
messageOut();
return;
}
var ShowLabel = [{ "value": "派车单号" },
{ "value": "登记日期" },
{ "value": "业务员编号" },
{ "value": "业务员姓名" },
{ "value": "客户编号" },
{ "value": "用车单位" },
{ "value": "联系人" },
{ "value": "联系电话" },
{ "value": "车牌号码" },
{ "value": "驾驶员编号" },
{ "value": "驾驶员姓名" },
{ "value": "出车日期" },
{ "value": "出车时间" },
{ "value": "支付方式" },
{ "value": "目的地点" },
{ "value": "租车费" },
{ "value": "实收" },
{ "value": "缴费" },
{ "value": "审核" },
{ "value": "油费" },
{ "value": "过桥费" },
{ "value": "修理费" },
{ "value": "停车费" },
{ "value": "车补贴" },
{ "value": "行驶公里" },
{ "value": "备注" }
];
var excel = '<table>';
var row = "<tr>";
for (var i = 0, l = ShowLabel.length; i < l; i++) {
row += "<td style=\"color:blue\">" + ShowLabel[i].value + '</td>';
}
excel += row + "</tr>";
for (var i = 0; i < arrData.length; i++) {
var row = "<tr>";
row += '<td style="mso-number-format:\ @;">' + arrData[i].pcdh + '</td>';
row += '<td>' + arrData[i].djrq + '</td>';
row += '<td>' + arrData[i].ywybh + '</td>';
row += '<td>' + arrData[i].ywyxm + '</td>';
row += '<td>' + arrData[i].khbh + '</td>';
row += '<td>' + arrData[i].ycdw + '</td>';
row += '<td>' + arrData[i].lxr + '</td>';
row += '<td>' + arrData[i].lxdh + '</td>';
row += '<td>' + arrData[i].cphm + '</td>';
row += '<td>' + arrData[i].jsybh + '</td>';
row += '<td>' + arrData[i].jsyxm + '</td>';
row += '<td>' + arrData[i].ccrq + '</td>';
row += '<td>' + arrData[i].ccsj + '</td>';
row += '<td>' + arrData[i].zffs + '</td>';
row += '<td>' + arrData[i].mddd + '</td>';
row += '<td>' + arrData[i].zcf + '</td>';
row += '<td>' + arrData[i].sjsf + '</td>';
row += '<td>' + arrData[i].zt + '</td>';
row += '<td>' + arrData[i].sh + '</td>';
if(typeof arrData[i].yf != 'number'){
row += '<td>0.00</td>';
}else{
row += '<td>' + arrData[i].yf + '.00</td>';
}
if(typeof arrData[i].gqf != 'number'){
row += '<td>0.00</td>';
}else{
row += '<td>' + arrData[i].gqf + '.00</td>';
}
if(typeof arrData[i].xlf != 'number'){
row += '<td>0.00</td>';
}else{
row += '<td>' + arrData[i].xlf + '.00</td>';
}
if(typeof arrData[i].tcf != 'number'){
row += '<td>0.00</td>';
}else{
row += '<td>' + arrData[i].tcf + '.00</td>';
}
if(typeof arrData[i].cbf != 'number'){
row += '<td>0.00</td>';
}else{
row += '<td>' + arrData[i].cbf + '.00</td>';
}
if(typeof arrData[i].xsgls != 'number'){
row += '<td>0</td>';
}else{
row += '<td>' + arrData[i].xsgls + '</td>';
}
row += '<td>' + arrData[i].xsgls + '</td>';
row += '<td>' + arrData[i].bz + '</td>';
excel += row + "</tr>";
}
excel += "</table>";
var excelFile = "<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'>";
excelFile += '<meta http-equiv="content-type" content="application/vnd.ms-excel; charset=UTF-8">';
excelFile += '<meta http-equiv="content-type" content="application/vnd.ms-excel';
excelFile += '; charset=UTF-8">';
excelFile += "<head>";
excelFile += "<!--[if gte mso 9]>";
excelFile += "<xml>";
excelFile += "<x:ExcelWorkbook>";
excelFile += "<x:ExcelWorksheets>";
excelFile += "<x:ExcelWorksheet>";
excelFile += "<x:Name>";
excelFile += "{worksheet}";
excelFile += "</x:Name>";
excelFile += "<x:WorksheetOptions>";
excelFile += "<x:DisplayGridlines/>";
excelFile += "</x:WorksheetOptions>";
excelFile += "</x:ExcelWorksheet>";
excelFile += "</x:ExcelWorksheets>";
excelFile += "</x:ExcelWorkbook>";
excelFile += "</xml>";
excelFile += "<![endif]-->";
excelFile += "</head>";
excelFile += "<body>";
excelFile += excel;
excelFile += "</body>";
excelFile += "</html>";
var uri = 'data:application/vnd.ms-excel;charset=utf-8,' + encodeURIComponent(excelFile);
var link = document.createElement("a");
link.href = uri;
link.style = "visibility:hidden";
link.download = "派车单信息查询统计报表.xls";
document.body.appendChild(link);
link.click();
document.body.removeChild(link);
}
});
}派车单统计子页面css代码：
.xg{
color:#fff;
border-radius:5px;
border:none;
line-height:25px;
width:70px;
background-color:#01AAED;
outline:none;
cursor:pointer;
}
#table0{
background-color:#01AAED;
color:#fff;
font-size:12px;
padding-left:45px;
font-weight:bolder;
}
#table0 span{
float:left;
margin-top:5px;
margin-bottom:5px;
margin-left:5px;
line-height:20px;
}
#table0 button{
outline:none;
border:none;
padding:3px 15px;
background-color:#fff;
color:#069;
cursor:pointer;
margin-left:15px;
box-shadow:2px 2px 2px #666;
}
#table0 button:hover{
color:#01AAED;
}
.table1{
background-color:#eef;
line-height:41px;
font-size:12px;
padding-left:25px;
font-weight:bolder;
color:#666;
}
.table1 tr td{
padding-left:10px;
}
.list{
font-size:12px;
padding-left:25px;
margin-top:15px;
color:#666;
}
.list tr{
background-color:#fff;
height:50px;
outline:3px solid #def;
}
.list tr:hover{
background-color:#aef;
}
.list tr td{
padding-left:10px;
}
.updatePageDiv{
display:none;
position:absolute;
left:0px;
top:0px;
width:100%;
height:100%;
background-color:rgba(0,0,0,0.3);
}
.updatePage{
width:950px;
border-radius:5px;
background-color:#fff;
margin:200px auto;
box-shadow:3px 3px 3px #999;
}
.updatePage input{
outline:none;
line-height:25px;
}
.updatePage>h2{
border-bottom:1px solid #ccc;
padding:15px 20px;
color:#fff;
background-color:#0cf;
}
.updatePage h2 span{
float:right;
color:#fff;
margin-top:-10px;
margin-right:-5px;
cursor:pointer;
}
.updatePage table{
color:#666;
font-size:14px;
margin:10px auto;
}
.updatePage table input{
border:1px solid #ccc;
padding-top:3px;
padding-left:10px;
border-radius:2px;
}
.updatePage p{
border-top:1px solid #ccc;
padding:15px 15px;
overflow: auto;
}
.updatePage p span{
float:right;
border:1px solid #999;
border-radius:3px;
font-size:9px;
padding:3px 5px;
letter-spacing:2px;
margin-right:10px;
font-weight:500;
cursor:pointer;
}
.updatePage p .bc{
background-color:#0cf;
color:#fff;
}
.pageManager{
margin-top:10px;
margin-left:25px;
background-color:#fff;
padding:5px 10px;
color:#999;
box-shadow:2px 2px 3px #999;
}
.pageManager>span{
font-size:9px;
}
.pageManager>span>input{
width:40px;
border:1px solid #ccc;
outline:none;
padding-left:5px;
border-radius:5px;
margin-left:5px;
}
.pageManager>b{
font-weight:100;
font-size:9px;
margin-left:15px;
}
.pageManager>b>select{
border:1px solid #ccc;
outline:none;
border-radius:5px;
}
.pageManager>b>button{
border:1px solid #ccc;
outline:none;
background-color:#fff;
color:#666;
font-size:9px;
padding:1px 2px;
cursor:pointer;
}
.pageManager>b>button:hover{
color:white;
font-weight:bolder;
background-color:#0DE;
}
#xz{
box-shadow:2px 2px 2px #aaa;
cursor:pointer;
}
.pcddjForm{
border:1px dotted #ccc;
margin-bottom:0px;
background-color:#fff;
}
.list1{
font-size:12px;
margin-top:15px;
color:#666;
}
.pcddjForm input[type='text']{
height:30px;
color:#666;
}
.pcddjForm input[type='number']{
height:30px;
}
.cxtjDiv{
float:left;
overflow: auto;
box-shadow:2px 2px 2px #666;
}
.cxtjDiv ul{
display:none;
list-style:none;
outline:none;
position:absolute;
background-color:#fff;
margin-top:5px;
width:168px;
border:1px solid #eee;
padding-bottom:10px;
box-shadow:2px 2px 2px #666;
}
.cxtjDiv ul li{
padding-left:28px;
line-height:25px;
border-bottom:1px dotted #eee;
cursor:pointer;
color:#777;
}
.cxtjDiv ul li:hover{
background-color:#01AAED;
color:#fff;
}
.cxtjDiv>input{
padding-left:15px;
line-height:22px;
margin-top:4px;
width:170px;
border:none;
outline:none;
color:#777;
font-size:8px;
font-family:'宋体';
cursor:pointer;
}
#tjtb{
float:left;
margin-left:-18px;
display:block;
width:16px;
height:16px;
color:red;
margin-top:7px;
padding-top:6px;
cursor:pointer;
}
.dataDiv{
float:left;
overflow: auto;
box-shadow:2px 2px 2px #666;
margin-left:20px;
display: none;
}
.dataDiv ul{
display:none;
list-style:none;
outline:none;
position:absolute;
background-color:#fff;
margin-top:5px;
width:168px;
border:1px solid #eee;
padding-bottom:10px;
box-shadow:2px 2px 2px #666;
height:250px;
overflow:scroll;
}
.dataDiv ul li{
padding-left:28px;
line-height:25px;
border-bottom:1px dotted #eee;
cursor:pointer;
color:#777;
}
.dataDiv ul li:hover{
background-color:#01AAED;
color:#fff;
}
.dataDiv>input{
padding-left:30px;
line-height:22px;
margin-top:4px;
width:170px;
border:none;
outline:none;
color:#777;
font-size:8px;
font-family:'宋体';
cursor:pointer;
}
#tjtb2{
float:left;
margin-left:-18px;
display:block;
width:16px;
height:16px;
color:red;
margin-top:7px;
padding-top:6px;
cursor:pointer;
display: none;
}
#table0 input[type='date']{
color:#069;
border:none;
outline:none;
height:20px;
}全部评论 (0)
还没有任何评论哟~