设备日志导出

Lius

2025-01-09 bd0d5396694b67e39ebaa44535b0df39895d5743

设备日志导出

 src/views/mdc/base/modules/DeviceLog/LogInfo.vue

@@ -24,6 +24,7 @@
            <a-space>
              <a-button type="primary" @click="searchQuery" icon="search">查询</a-button>
              <a-button type="primary" @click="searchReset" icon="reload">重置</a-button>
              <a-button type="primary" icon="download" @click="handleExport">导出</a-button>
            </a-space>
          </a-col>
        </a-row>
@@ -165,7 +166,7 @@
  import AlarmLogList from './AlarmLogList'
  import WorkChartModel from './WorkChartModel'
  import WorkHistoryModel from './WorkHistoryModel'
  import { getAction } from '@/api/manage'
  import { downFile, getAction } from '@/api/manage'

  export default {
     components: {
@@ -199,7 +200,8 @@
        url: {
          getBaseTree: '/mdc/mdcequipment/loadTree',
          getEquipmentByPid: '/mdc/mdcEquipment/getEquipmentByPid',
          list: '/mdc/mdcEquipmentRunningSection/logList'
          list: '/mdc/mdcEquipmentRunningSection/logList',
          exportXlsUrl: '/mdc/mdcEquipmentRunningSection/exportLogXls'
        },
        ProStartId: ''
      }
@@ -342,6 +344,11 @@

          }
        })
      },

      handleExport(){
        this.$refs.logList.queryParam=Object.assign({},this.queryParams,this.$refs.logList.queryParam)
        this.$refs.logList.handleExportXls('设备日志')
      }
    },
    created() {

 src/views/mdc/base/modules/DeviceLog/LogList.vue

@@ -20,7 +20,7 @@
  import JDictSelectTag from '@/components/dict/JDictSelectTag'
  import {
    requestPut,
    deleteAction
    deleteAction, downFile
  } from '@/api/manage'

  import JInput from '@/components/jeecg/JInput'
@@ -141,7 +141,10 @@
            align: 'center',
            dataIndex: 'sequenceNumber'
          }
        ]
        ],
        url: {
          exportXlsUrl: '/mdc/mdcEquipmentRunningSection/exportLogXls'
        },
      }
    },
    methods: {
@@ -174,7 +177,42 @@
            }
          }
        }
      }
      },

      handleExportXls(fileName){
        if(!fileName || typeof fileName != "string"){
          fileName = "导出文件"
        }
        let param = this.getQueryParams();
        if(this.selectedRowKeys && this.selectedRowKeys.length>0){
          param['selections'] = this.selectedRowKeys.join(",")
        }
        console.log("导出参数",param)
        downFile(this.url.exportXlsUrl,param).then((data)=>{
          if (!data) {
            // this.$message.warning("文件下载失败")
            this.$notification.warning({
              message:'消息',
              description:"文件下载失败"
            });
            return
          }
          if (typeof window.navigator.msSaveBlob !== 'undefined') {
            window.navigator.msSaveBlob(new Blob([data],{type: 'application/vnd.ms-excel'}), fileName+'.xls')
          }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')
            document.body.appendChild(link)
            link.click()
            document.body.removeChild(link); //下载完成移除元素
            window.URL.revokeObjectURL(url); //释放掉blob对象
          }
        })
      },

    },
    created() {
    }