1、设备TEEP页面大数据导出格式由xls调整为xlsx 2、大数据导出参数增加为查询区域所有字段

zhaowei

2025-06-09 4bf8212c10eb9a1421e52b60e7407922d081ba8c

1、设备TEEP页面大数据导出格式由xls调整为xlsx
2、大数据导出参数增加为查询区域所有字段

 src/views/mdc/base/modules/efficiencyReport/EfficiencyList.vue

@@ -526,12 +526,19 @@
        })
      },
      exportLongTimeExcel(fileName) {
        // let param = this.getQueryParams()
        // console.log('导出参数', param)
        const param = {
        let param = {
          startTime: moment(this.dates[0]).format('YYYYMMDD'),
          endTime: moment(this.dates[1]).format('YYYYMMDD')
        }
        Object.keys(this.queryParams).forEach(item => {
          if (Array.isArray(this.queryParams[item])) {
            param[item] = this.queryParams[item].join()
            // 此处为保证接口参数不多余，可省略
            if (this.queryParams[item].length === 0) delete param[item]
          }
        })
        param = Object.assign({}, this.queryParam, param)

        this.longTimeExportButtonLoading = true
        downFile(this.url.exportLongTimeXlsUrl, param)
          .then((data) => {
@@ -543,13 +550,13 @@
              return
            }
            if (typeof window.navigator.msSaveBlob !== 'undefined') {
              window.navigator.msSaveBlob(new Blob([data], { type: 'application/vnd.ms-excel' }), fileName + '.xls')
              window.navigator.msSaveBlob(new Blob([data], { type: 'application/vnd.ms-excel' }), fileName + '.xlsx')
            } else {
              let url = window.URL.createObjectURL(new Blob([data], { type: 'application/vnd.ms-excel' }))
              let link = document.createElement('a')
              link.style.display = 'none'
              link.href = url
              link.setAttribute('download', fileName + '.xls')
              link.setAttribute('download', fileName + '.xlsx')
              document.body.appendChild(link)
              link.click()
              document.body.removeChild(link) //下载完成移除元素
@@ -620,8 +627,6 @@
        this.tableHeads = []
        this.dataList = []
        this.spinning = true
        console.log('requestAllDataSize', this.requestAllDataSize)
        console.log('everyRequestDataSize', this.everyRequestDataSize)
        // 若日期选择器设置的查询请求数量超过15条则开启懒加载
        if (this.requestAllDataSize > this.everyRequestDataSize) {
          // 开启懒加载后将结束日期设置为开始日期之后的14天，即先查询15天内的数据
@@ -642,7 +647,6 @@

            this.tableHeads = res.result.dates
            this.dataList = res.result.mdcEfficiencyList
            console.log('dataList', this.dataList)
            this.checkSameData(this.dataList)
            this.checkSameData1(this.dataList)
            this.checkSameData2(this.dataList)
@@ -679,7 +683,6 @@
            .then(res => {
              if (res.success) {
                this.tableHeads = [...this.tableHeads.slice(0, -2), ...res.result.dates]
                console.log('dataList', this.dataList)
                this.dataList.forEach(item1 => {
                  res.result.mdcEfficiencyList.forEach(item2 => {
                    if (item1.equipmentId === item2.equipmentId) {