扬尘Vue

zmc

2023-08-31 17388fa7ecd1f3ebadad470a463573a1cfe4468f

 src/views/origin_data/HistoryData.vue

ÎļþÃû´Ó src/views/origin_data/TableData.vue ÐÞ¸Ä
@@ -5,6 +5,7 @@
import AreaAndmonitorType from '../../sfc/AreaAndmonitorType.vue'

import {useCommonFunction} from '../../utils/common.js';
import requetsApi from '@/api/exportExcel/requetsApi.js'

import dayjs from 'dayjs';

@@ -47,8 +48,8 @@
    };
  },
  setup(){
    const {isExceedOneMonth} = useCommonFunction()
    return {isExceedOneMonth}
    const {isExceedOneMonth,exportToExcel} = useCommonFunction()
    return {isExceedOneMonth,exportToExcel}
  },
  mounted() {
    this.backMinuteDataAWeekAgo();
@@ -56,6 +57,45 @@
  },

  methods: {
    exportDom(){
 
      let params  ={
        'beginTime':this.form.beginTime,
        'endTime': this.form.endTime,
      }
      if (this.form.name) {
        params['siteName'] = this.form.name;
      }
      if (this.form.number) {
        params['mnCode'] = this.form.numbe;
      }
      if (this.scenarioType.length != 0) {
          params['scenarioType'] = this.scenarioType;
      }
      requetsApi.fetchAlSiteData(params).then(res => {
        const data = res.data.data
        console.log('长度：',data.length);

        const  tableColumns = [
        'name',
        'address',
        'dutyCompany',
        'mnCode',
        'typeName',
        'dustValue',
        'noiseValue',
        'lst',
        'quality',
        'groupName',

      ]
      const excelColumns = [['A1','站点名称'],
      ['B1','地址'],['C1','供应商'],['D1','设备编号'],
      ['E1','类型'],['F1','扬尘浓度(mg/m³)'],['G1','噪声(dB)'],
      ['H1','采集时间'],['I1','等级'],['J1','所在区县']]
      this.exportToExcel(data,tableColumns,excelColumns,'历史数据表.xlsx')
      })
    },
    // åŠŸèƒ½ï¼šè¡¨æ ¼é«˜åº¦æ ¹æ®å†…容自适应
    calTableHeight() {
      const h1 = this.$refs.h1.$el.offsetHeight;
@@ -92,10 +132,10 @@

    // æŸ¥è¯¢æ•°æ®
    handleSubmit() {
      if (this.isExceedOneMonth(this.form.beginTime, this.form.endTime)) {
        alert('时间跨度不能超过一个月');
        return;
      }
      // if (this.isExceedOneMonth(this.form.beginTime, this.form.endTime)) {
      //   alert('时间跨度不能超过一个月');
      //   return;
      // }
      this.loading = true;
      let params = {};
      params['page'] = this.currentPage;
@@ -221,12 +261,12 @@
        :data="displayData"
        :height="tableHeight"
        v-loading="loading"
        table-layout="auto"
      >
        <!--绑定一个方法，将返回值赋给index,即表格每行数据的下标-->
        <el-table-column
          type="index"
          label="序号"
          width="60px"
          align="center"
          fixed
          :index="indexMethod"
@@ -244,7 +284,7 @@
          show-overflow-tooltip
        ></el-table-column>
        <el-table-column
          prop="sname"
          prop="dutyCompany"
          label="供应商"
          align="center"
          show-overflow-tooltip
@@ -262,8 +302,14 @@
        ></el-table-column>
        <el-table-column
          prop="dustValue"
          label="扬尘浓度"
          width="80px"
          label="扬尘浓度(mg/m³)"
          align="center"
          sortable 
          show-overflow-tooltip
        ></el-table-column>
        <el-table-column
          prop="noiseValue"
          label="噪声(dB)"
          align="center"
          sortable 
          show-overflow-tooltip
@@ -278,7 +324,6 @@
        <el-table-column
          prop="quality"
          label="等级"
          width="50px"
          align="center"
          show-overflow-tooltip
        ></el-table-column>