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

zhaowei

2025-06-09 4bf8212c10eb9a1421e52b60e7407922d081ba8c

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

@@ -38,7 +38,9 @@
          </a-col>
          <a-col :md="6" :sm="6">
            <a-form-item label="时间">
              <a-range-picker @change="dateParamChange" :disabledDate="disabledDate" format="YYYYMMDD"
              <a-range-picker @change="dateParamChange" :disabledDate="disabledDate"
                              @calendarChange="handleCalendarChange" @openChange="handleCalendarOpenChange"
                              format="YYYYMMDD"
                              v-model="dates" :allowClear="false"/>
            </a-form-item>
          </a-col>
@@ -95,8 +97,13 @@
                <a-button type="primary" @click="searchQuery" icon="search">查询</a-button>
                <a-button type="primary" @click="searchReset" icon="reload">重置</a-button>
                <a-button type="primary" @click="exportExcel" icon="download">导出</a-button>
                <!--<a-button type="primary" @click="exportOneYearExcel('设备TEEP')" icon="download">大数据导出</a-button>-->
                <a-button type="primary" @click="handleShowFeedbackModal" icon="plus" v-has="'efficiency:feedback'">异常反馈</a-button>
                <a-button type="primary" @click="exportLongTimeExcel('设备TEEP')" icon="download"
                          :loading="longTimeExportButtonLoading">
                  大数据导出
                </a-button>
                <a-button type="primary" @click="handleShowFeedbackModal" icon="plus" v-has="'efficiency:feedback'">
                  异常反馈
                </a-button>
                <a-button type="primary" icon="printer" v-print="'#Efficiency'"
                          v-has="'efficiency:print'">打印
                </a-button>
@@ -275,7 +282,7 @@
          list: '/mdc/efficiencyReport/efficiencyList',
          listByType: '/mdc/MdcUtilizationRate/getByType',
          queryEquipmentType: '/mdc/mdcEquipmentType/queryEquipmentType',
          exportOneYearXlsUrl: ''
          exportLongTimeXlsUrl: '/mdc/efficiencyReport/exportEfficiencyXls'
        },
        tableHeads: [],
        utilizationRateRowAverage: '',
@@ -289,7 +296,9 @@
        requestAllDataSize: 8,// 总共请求的列表项数目(默认值为默认日期的差值+1)
        everyRequestDataSize: 15,// 每次请求的列表项数目
        toggleSearchStatus: false,
        modalVisible: false// 异常反馈弹窗是否弹出
        modalVisible: false,// 异常反馈弹窗是否弹出
        preSelectFirstDate: null,
        longTimeExportButtonLoading: false
      }
    },
    props: { nodeTree: '', Type: '', nodePeople: '' },
@@ -469,10 +478,42 @@
        }
        return list
      },
      disabledDate(current) {
        //Can not slect days before today and today
        return current && current > moment().subtract('days', 1)

      dateParamChange(v1, v2) {
        this.queryParam.startTime = v2[0]
        this.queryParam.endTime = v2[1]
      },

      /**
       * 时间选择器面板上的值发生改变时触发
       * @param dates 面板上的两个值组成的数组
       */
      handleCalendarChange(dates) {
        if (dates.length === 1) this.preSelectFirstDate = dates[0]
      },

      /**
       * 控制时间选择器面板开启与关闭
       * @param status 开启状态
       */
      handleCalendarOpenChange(status) {
        if (status) this.preSelectFirstDate = null
      },

      /**
       * 面板上禁止选择的日期
       * @param current 禁止的时间范围
       */
      disabledDate(current) {
        if (!this.preSelectFirstDate) {
          return current > moment().startOf('days')
        } else {
          return current < moment(this.preSelectFirstDate).subtract(365, 'days').startOf('days')
            || current > moment().startOf('days')
            || current > moment(this.preSelectFirstDate).add(365, 'days').endOf('days')
        }
      },

      exportExcel() {
        $('#Efficiency').table2excel({
          exclude: '.noExl',
@@ -484,10 +525,22 @@
          exclude_inputs: false
        })
      },
      exportOneYearExcel(fileName) {
        // let param = this.getQueryParams()
        // console.log('导出参数', param)
        downFile(this.url.exportOneYearXlsUrl)
      exportLongTimeExcel(fileName) {
        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) => {
            if (!data) {
              this.$notification.warning({
@@ -497,18 +550,25 @@
              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) //下载完成移除元素
              window.URL.revokeObjectURL(url) //释放掉blob对象
            }
          })
          .finally(() => {
            let timer = setTimeout(() => {
              this.longTimeExportButtonLoading = false
              clearTimeout(timer)
              timer = null
            }, 1000)
          })
      },
      showIdentifying() {
@@ -517,11 +577,6 @@
            this.identifying = res.result
          }
        })
      },
      dateParamChange(v1, v2) {
        this.queryParam.startTime = v2[0]
        this.queryParam.endTime = v2[1]
        this.dates = [v1[0], v1[1]]
      },
      efficiencyOptionsOnChange(checkedList) {
        this.checkedList = checkedList
@@ -572,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天内的数据
@@ -594,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)
@@ -631,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) {