layui导出多表头文件

js代码

/**

• 主页模块
  */
  layui.define([“form”, “element”, “laydate”, “table”,], function(exports) {

  var foo = {

   /**
    * 初始化函数
    */
   init: function(){
       this.form = layui.form;
       this.element = layui.element;
       this.table = layui.table;
       this.laydate = layui.laydate;
       var me = this;
       me.queryXzq='';
       me.queryYear='';
       me.getYear();
       me.getXzq();
       //数据列表表格
       me.queryTable();
       $("#export-1").click(function () {
           let table2excel = new Table2Excel();
           $('#dataExchangeDetails-table').show();
           table2excel.export($('#dataExchangeDetails-table'), "矿产资源指标使用情况");
           $('#dataExchangeDetails-table').hide();
       });
   },
   exportData:function(){
       let header_tr = $("#dataExchangeDetails-table").next().find(".layui-table-header").find("tr");
       let body_tr = $("#dataExchangeDetails-table").next().find(".layui-table-body").find("tr");
       let header_html = "";
       let body_html = "";
       // 获取表头html，包括单元格的合并
       $.each(header_tr,function (i,tr) {
           let header_th = $(tr).find("th");
           header_html += "<tr>";
           $.each(header_th,function (j,th) {
               let rowspan_num = $(th).attr("rowspan");// 行合并数
               let colspan_num = $(th).attr("colspan");// 列合并数
               if (rowspan_num && !colspan_num){// 只有行合并时
                   header_html += '<th rowspan= "'+ rowspan_num +'">';
               } else if (colspan_num && !rowspan_num){// 只有列合并时
                   header_html += '<th colspan= "'+ colspan_num +'">';
               } else if (rowspan_num && colspan_num){// 行列合并均有时
                   header_html += '<th rowspan= "'+ rowspan_num +'" colspan="'+ colspan_num +'">';
               } else {// 没有发生单元格合并
                   header_html += '<th>';
               }
               header_html += $(th).children().children().text() + '</th>';// 获取表头名称并拼接th标签
           })
           header_html += '</tr>';
       })
       // 获取表格body数据
       $.each(body_tr,function (i,tr) {
           let body_td = $(tr).find("td");
           body_html += '<tr>';
           $.each(body_td,function (j,td) {
               body_html += '<td>' + $(td).children().text() + '</td>';
           })
           body_html += '</tr>';
       })
       $("#dataExchangeDetails-table").append(header_html).append(body_html);
       $("#dataExchangeDetails-table").hide();
   },
  
   //数据列表表格
   queryTable:function(){
       var me = this;
       me.ins=me.table.render({
           elem: '#dataExchangeDetails-table',
           url:window.RestApiBaseUrl+'/commonQuery/getMineralQuota?xzqdm='+me.queryXzq+'&year='+me.queryYear,
           height:$('.dataExchangeDetails-main-tbl').height()+50,
           page:false,
           response: {
               statusName: 'code', //规定数据状态的字段名称，默认：code
               statusCode: 200, //规定成功的状态码，默认：0
               countName: 'count', //规定数据总数的字段名称，默认：count
               msgName: 'msg', //规定状态信息的字段名称，默认：msg
               dataName: 'data' //规定数据列表的字段名称，默认：data
           },
           cols: [[
               {field:'ND', title:'年度',rowspan:"4",align:'center',width:90}
               ,{field:'XZQMC', title:'行政区',rowspan:"4",align:'center',width:100}
               ,{field:'kszykc1', title:'矿山资源勘查',colspan:"4", align:'center'}
               ,{field:'kszykl1', title:'矿山资源开发利用与保护',colspan:"13",align:'center'}
               ,{field:'ksdzhjbh1', title: '矿山地质环境保护与治理恢复',colspan:"3", align:'center'}],
  
               [{field:'ZYKCXFXZDXKCD', title:'重要矿产新发现中大型矿产地',rowspan:"3", align:'center',width:225}
                   ,{field:'yxqqz1', title:'新增查明资源储量',colspan:"3", align:'center'}
                   ,{field:'KYJJ_KYNCZ', title:'矿业年产值(亿元)', rowspan:"3",align:'center',width:150}
                   ,{field:'kckckz1', title:'主要矿种开采量',colspan:"5", align:'center'}
                   ,{field:'kyqrmc1', title:'矿业转型升级与绿色矿业发展',colspan:"7", align:'center'}
                   ,{field:'kyqrdz1', title:'历史遗留矿山地质环境治理',colspan:"2", align:'center'}
                   ,{field:'KQTDFKMJ', title:'矿区土地复垦面积(km2)',rowspan:"3", align:'center',width:200}],[
                   {field:'XZCMZYCL_TK', title:'铁矿(万吨)',rowspan:"2", align:'center',width:120},
                   {field:'XZCMZYCL_JK', title:'铁矿(金 吨)',rowspan:"2", align:'center',width:120},
                   {field:'XZCMZYCL_SMK', title:'石墨矿(矿物 万吨)',rowspan:"2", align:'center',width:150},
  
                   {field:'ZYKZNKCL_SSNT', title:'矿石黏土(万立方米)', rowspan:"2",align:'center',width:160},
                   {field:'ZYKZNKCL_TK', title:'铁矿(万吨)',rowspan:"2", align:'center',width:130},
                   {field:'ZYKZNKCL_JK', title:'金矿(矿石 万吨)',rowspan:"2", align:'center',width:140},
                   {field:'ZYKZNKCL_SMK', title:'石墨矿(矿石 万吨)', rowspan:"2",align:'center',width:150},
                   {field:'ZYKZNKCL_KQS', title:'矿泉水(万立方米)',rowspan:"2", align:'center',width:145},
                   {field:'KYZX_CKQZS', title:'采矿权总数(个)', rowspan:"2",align:'center',width:140},
                   {field:'KYZX_DZXKSBL', title:'大中型矿山比例(%)',rowspan:"2", align:'center',width:160},
                   {field:'KYZX_ZYKC_KSKCSL_SPDBL', title:'重要矿山矿产开采"三率"水平达标率(%)',rowspan:"2", align:'center',width:200},
                   {field:'dzl', title:'大中小型生产矿山建成绿色矿山比例（%）',colspan:"3", align:'center'},
                   {field:'KYZX_LSKYFZSSQ', title:'绿色矿业发展示范区（个）',rowspan:"2", align:'center',width:180},
                   {field:'LSYLKSDZHJZL_KSGS', title:'矿山个数（个）',rowspan:"2", align:'center',width:160},
                   {field:'LSYLKSSZHJZL_ZLMJ', title:'治理面积（km2)', rowspan:"2",align:'center',width:160}],
               [
                   {field:'KYZX_DZXXSCKS_JCLSKSBL_DX', title:'大型', align:'center',width:160},
                   {field:'KYZX_DZXXSCKS_JCLSKSBL_ZX', title:'中型', align:'center',width:160},
                   {field:'KYZX_DZXXSCKS_JCLSKSBL_XX', title:'小型', align:'center',width:160}
               ]],
           done: function(res, curr, count){
               me.exportData();
           }
       });
   },
  

  };
  exports(‘mineralQuota’, foo);
  })