表单筛选及下载数据的使用




function findTableDataResultFinal(option, dataSource) {


    // 变量设置
  
    var tablePanel = [{}], currentDataList = dataSource;
  
    var r = getCurrentLengthFinal(option, currentDataList);
  
    var hederIndex = "";
  
  
  
  
    if (option.hPosition === "top" || option.hPosition === "left" || option.hPosition === "" || option.hPosition === "none" || !option.hPosition) {
  
      hederIndex = "0";
  
    } else if (option.hPosition === "bottom") {
  
      hederIndex = "" + r.h - 1;
  
    } else if (option.hPosition === "right") {
  
      hederIndex = "" + r.w - 1;
  
    }
  
    // 数据为空时候
  
    if (currentDataList.length === 0) {
  
      tablePanel = drawTablePanelFinal(r.w, r.h);
  
    }
  
  
  
  
    if (currentDataList && Array.isArray(currentDataList)) {
  
      // 绘制表格格式
  
      tablePanel = drawTablePanelFinal(r.w, r.h);
  
      // 表头
  
      var hederList = option.headerType === "static" ? option.headerNameList : [];
  
      // 表头数据设置
  
      for (var i in hederList) {
  
        if (option.hPosition === "left" || option.hPosition === "right") {
  
          tablePanel[i]["cells"][hederIndex]["text"] = hederList[i];
  
        } else if (option.hPosition === "top" || option.hPosition === "bottom" || option.hPosition === "" || option.hPosition === "none" || !option.hPosition) {
  
          tablePanel[hederIndex]["cells"][i]["text"] = hederList[i];
  
        }
  
      }
  
      if ((option.hPosition === "top" || option.hPosition === "left" || option.hPosition === "" || option.hPosition === "none" || !option.hPosition) && option.headerType != "none" && option.headerType) {
  
        n = 1;
  
      } else {
  
        n = 0;
  
      }
  
      // 源数据循环
  
      currentDataList.forEach(function (item, index) {
  
        for (var i in option.cellsFieldNameList) {
  
          var key = option.cellsFieldNameList[i], v = item[key] != null ? item[key] : '';
  
          if (option.hPosition === "left" || option.hPosition === "right") {
  
            tablePanel[i]["cells"][n]["text"] = v;
  
          } else {
  
            tablePanel[n]["cells"][i]["text"] = v;
  
          }
  
        }
  
        n++;
  
      })
  
    } else {
  
      tablePanel = drawTablePanelFinal(r.w, 1);
  
      var hederList = option.headerType === "static" ? option.headerNameList : [];
  
      for (var i in hederList) {
  
        if (option.hPosition === "left" || option.hPosition === "right") {
  
          tablePanel[i]["cells"][hederIndex]["text"] = hederList[i];
  
        } else {
  
          tablePanel[hederIndex]["cells"][i]["text"] = hederList[i];
  
        }
  
      }
  
      for (var i in option.cellsFieldNameList) {
  
        var key = option.cellsFieldNameList[i], v = currentDataList[key] != null ? currentDataList[key] : 0;
  
        if (option.hPosition === "left" || option.hPosition === "right") {
  
          tablePanel[i]["cells"][hederIndex]["text"] = hederList[i];
  
        } else {
  
          tablePanel[0]["cells"][i]["text"] = v;
  
        }
  
      }
  
    }
  
    return tablePanel;
  
  }
  
  function getCurrentLengthFinal(option, dataSource) {
  
    var r = { w: 1, h: 1 };
  
    var obj = [];
  
    if (dataSource && Array.isArray(dataSource)) {
  
      if (option.fn) { dataSource.forEach(function (item) { if (option.fn(item)) obj.push(item); }) }
  
      else { obj = dataSource; }
  
    } else {
  
      obj = dataSource
  
    }
  
    if (option.hPosition === "top" || option.hPosition === "bottom" || !option.hPosition) {
  
      r.w = option.headerType === "static" ? option.headerNameList.length : option.cellsFieldNameList.length;
  
      r.h = option.headerType === "static" ? obj.length + 1 : obj.length;
  
    }
  
    if (option.hPosition === "left" || option.hPosition === "right") {
  
      var headerType = option.headerType
  
      r.w = headerType === "static" ? obj.length + 1 : obj.length
  
      r.h = headerType === "static" || headerType === "none" || !headerType ? option.headerNameList.length : r.h
  
    }
  
    return r
  
  }
  
  function drawTablePanelFinal(width, height) {
  
    var row, cell, row = { "cells": {} }, cell = {};
  
    for (var i = 0; i < width; i++) row['cells'][i] = { "text": null };
  
    for (var i = 0; i < height; i++) cell[i] = JSON.parse(JSON.stringify(row));
  
    return cell;
  
  }
  
  function calculate(arrValue,data){if(!Array.isArray(data)){let e=[];e.push(data),data=e}return arrValue.forEach(handleValue=>{switch(handleValue.defaultType){case 0:switch(handleValue.dealType){case 2:data.forEach((e,t)=>{data[t][handleValue.fieldDesc.filed]=e[handleValue.fieldDesc.filed].toString().replaceAll(handleValue.config.field1,handleValue.config.field2)});break;case 3:data.forEach((e,t)=>{data[t][handleValue.fieldDesc.filed]=e[handleValue.fieldDesc.filed].toString().replaceAll(handleValue.config.field1,"")});break}break;case 1:let arr=[0,1,2,3,4,5,"+","-","*","/",10,"%"];10==handleValue.dealType?data.forEach((e,t)=>{let a=Math.round(parseFloat(e[handleValue.fieldDesc.filed])*Math.pow(10,handleValue.config.field1))/Math.pow(10,handleValue.config.field1);data[t][handleValue.fieldDesc.filed]=a.toFixed(handleValue.config.field1)}):handleValue.dealType&&data.forEach((item,index)=>{const d=(""+item[handleValue.fieldDesc.filed]).split(".").length>1?(""+item[handleValue.fieldDesc.filed]).split(".")[1].length:0,d1=(""+handleValue.config.field1).split(".").length>1?(""+handleValue.config.field1).split(".")[1].length:0;let pow=7==handleValue.dealType||6==handleValue.dealType?d>d1?d:d1:8==handleValue.dealType?d+d1:d1-d;if(7==handleValue.dealType||6==handleValue.dealType)data[index][handleValue.fieldDesc.filed]=eval(`(((${parseFloat(item[handleValue.fieldDesc.filed])} * ${Math.pow(10,pow)}) ${arr[handleValue.dealType]} (${parseFloat(handleValue.config.field1)} * ${Math.pow(10,pow)}))/ ${Math.pow(10,pow)}).toFixed(${pow})`);else if(8==handleValue.dealType||9==handleValue.dealType){const filed=(""+item[handleValue.fieldDesc.filed]).replace(".",""),filed1=(""+handleValue.config.field1).replace(".","");data[index][handleValue.fieldDesc.filed]=eval(8==handleValue.dealType?`(${Number(filed)} ${arr[handleValue.dealType]} ${Number(filed1)}) ${arr[9]} ${Math.pow(10,pow)}`:numMulti(Number(filed)/Number(filed1),Math.pow(10,pow)))}else data[index][handleValue.fieldDesc.filed]=eval(`parseInt(${parseFloat(item[handleValue.fieldDesc.filed])}  ${arr[handleValue.dealType]} ${parseFloat(handleValue.config.field1)})`)});break;case 2:let arrD=["yyyy","yyyy年","yyyy年MM月","yyyy-MM","yyyy/MM","yyyy年MM月dd日","yyyy-MM-dd","yyyy/MM/dd","yyyy.MM.dd","MM","MM月","MM月dd日","MM/dd","MM-dd","MM.dd","dd日","dd"];data.forEach((e,t)=>{handleValue.dealType?data[t][handleValue.fieldDesc.filed]=dateformatFunc(e[handleValue.fieldDesc.filed],arrD[Number(handleValue.dealType)-12]):data[t][handleValue.fieldDesc.filed]=e[handleValue.fieldDesc.filed]});break;default:break}}),data;function numMulti(e,t){var a=0;try{a+=e.toString().split(".")[1].length}catch(s){}try{a+=t.toString().split(".")[1].length}catch(s){}return Number(e.toString().replace(".",""))*Number(t.toString().replace(".",""))/Math.pow(10,a)}}
  
  function dateformatFunc(e,t){var a=new Date(e),s=a.getFullYear(),i=a.getMonth()+1,o=a.getDate();return t=t.replace("yyyy",s).replace("MM",(""+i).length>1?i:"0"+i).replace("dd",(""+o).length>1?o:"0"+o),t}
  
  function dataSourceProcess(data, args) {
  
  if (args.a) {
  
      data = data.filter(o => o["姓名"] == args.a);
  
  }
  
  if (args.b) {
  
      data = data.filter(o => o["工作地"] == args.b);
  
  }
  
  if (args.c) {
  
      data = data.filter(o => o["入职时间"] == args.c);
  
  }
  
  
  
  
  return data
  
  }
  
  var logicItem = [{"name":"员工编号","defaultType":0,"config":{"field1":"","field2":"","isEdit":false},"source":13348,"fieldDesc":{"filedId":13348,"dataItemConfigId":0,"filed":"id","mapName":"员工编号","content":""}},{"name":"姓名","defaultType":0,"config":{"field1":"","field2":"","isEdit":false},"source":13349,"fieldDesc":{"filedId":13349,"dataItemConfigId":0,"filed":"姓名","mapName":"姓名","content":""}},{"name":"工作地","defaultType":0,"config":{"field1":"","field2":"","isEdit":false},"source":13351,"fieldDesc":{"filedId":13351,"dataItemConfigId":0,"filed":"工作地","mapName":"工作地","content":""}},{"name":"部门","defaultType":0,"config":{"field1":"","field2":"","isEdit":false},"source":13350,"fieldDesc":{"filedId":13350,"dataItemConfigId":0,"filed":"部门","mapName":"部门","content":""}},{"name":"岗位","defaultType":0,"config":{"field1":"","field2":"","isEdit":false},"source":13352,"fieldDesc":{"filedId":13352,"dataItemConfigId":0,"filed":"岗位","mapName":"岗位","content":""}},{"name":"入职时间","defaultType":0,"config":{"field1":"","field2":"","isEdit":false},"source":13353,"fieldDesc":{"filedId":13353,"dataItemConfigId":0,"filed":"入职时间","mapName":"入职时间","content":""}}]
  
  data = dataSourceProcess(data, args)
  
  data = calculate(logicItem, data)
  
  var option = {"path":"","cellsFieldNameList":["id","姓名","工作地","部门","岗位","入职时间"],"headerNameList":["员工编号","姓名","工作地","部门","岗位","入职时间"],"headerType":"static","hPosition":"top"}
  
  return findTableDataResultFinal(option, data)