1.飞行巡检和审核辅助页面中的对话框写成组件 2.增加了数据请求和异常分析配置参数的可视化页面 3.修改了站点输入框，使能够模糊匹配

zmc

2023-12-14 b8b2820d1a0a55a5555434a3ec95f8bbec1db06d

 src/views/data_management/HistoryData.vue

@@ -1,15 +1,15 @@
<script>
import TimeShortCuts from '@/sfc/TimeShortCuts.vue';
import ScenarioType from '@/sfc/ScenarioType.vue';
import InputSearch from '@/sfc/InputSearch.vue';
import TimeShortCuts from '@/sfc/TimeShortCuts.vue'
import ScenarioType from '@/sfc/ScenarioType.vue'
import InputSearch from '@/sfc/InputSearch.vue'
import { ElMessage } from 'element-plus'
import AreaAndmonitorType from '@/sfc/AreaAndmonitorType.vue'

import { useCommonFunction } from '../../utils/common.js';
import { useCommonFunction } from '../../utils/common.js'
import requetsApi from '@/api/exportExcel/requetsApi.js'
import ButtonClick from '@/sfc/ButtonClick.vue'
import ButtonExportExcel from '@/sfc/ButtonExportExcel.vue'
import dayjs from 'dayjs';
import dayjs from 'dayjs'

export default {
  components: {
@@ -33,7 +33,7 @@
        endTime: ''
      },
      // 搜索框传递上来的设备编号
      tempMnCode :'',
      tempMnCode: '',
      // 返回的数据
      tableData: [],
      // 表格数据
@@ -46,7 +46,7 @@
      // 加载中
      loading: false,
      queryButton: false,
      exportButton:false,
      exportButton: false,
      // 空状态
      isNoData: false,
      // 已选中的场景类型
@@ -54,36 +54,35 @@
      // 表格高度
      tableHeight: '500',
      // 站点总数量
      siteNums:0
    };
      siteNums: 0
    }
  },
  setup() {
    const { isExceedOneMonth, exportToExcel } = useCommonFunction()
    return { isExceedOneMonth, exportToExcel }
  },
  mounted() {
    this.backMinuteDataAWeekAgo();
    this.calTableHeight();
    this.backMinuteDataAWeekAgo()
    this.calTableHeight()
  },

  methods: {
    exportDom() {

      let params = {
        'beginTime': this.form.beginTime,
        'endTime': this.form.endTime,
        beginTime: this.form.beginTime,
        endTime: this.form.endTime
      }
      if (this.form.name) {
        params['siteName'] = this.form.name;
        params['siteName'] = this.form.name
      }
      if (this.form.number) {
        params['mnCode'] = this.form.numbe;
        params['mnCode'] = this.form.numbe
      }
      if (this.scenarioType.length != 0) {
        params['scenarioType'] = this.scenarioType;
        params['scenarioType'] = this.scenarioType
      }
      this.exportButton = true
      requetsApi.fetchAlSiteData(params).then(res => {
      requetsApi.fetchAlSiteData(params).then((res) => {
        const data = res.data.data
        if (data.length != 0) {
          const tableColumns = [
@@ -96,15 +95,22 @@
            'noiseValue',
            'lst',
            'quality',
            'groupName',

            'groupName'
          ]
          const excelColumns = [['A1', '站点名称'],
          ['B1', '地址'], ['C1', '供应商'], ['D1', '设备编号'],
          ['E1', '类型'], ['F1', '扬尘浓度(mg/m³)'], ['G1', '噪声(dB)'],
          ['H1', '采集时间'], ['I1', '等级'], ['J1', '所在区县']]
          const excelColumns = [
            ['A1', '站点名称'],
            ['B1', '地址'],
            ['C1', '供应商'],
            ['D1', '设备编号'],
            ['E1', '类型'],
            ['F1', '扬尘浓度(mg/m³)'],
            ['G1', '噪声(dB)'],
            ['H1', '采集时间'],
            ['I1', '等级'],
            ['J1', '所在区县']
          ]
          this.exportToExcel(data, tableColumns, excelColumns, '历史数据表.xlsx')
        }else{
        } else {
          ElMessage('无数据需要导出')
        }
        this.exportButton = false
@@ -112,198 +118,260 @@
    },
    // 功能：表格高度根据内容自适应
    calTableHeight() {
      const h1 = this.$refs.h1.$el.offsetHeight;
      const h2 = this.$refs.h2.$el.offsetHeight;
      const h1 = this.$refs.h1.$el.offsetHeight
      const h2 = this.$refs.h2.$el.offsetHeight
      // 其中一个40是盒子的总外边距
      this.tableHeight = `calc(100vh - ${h1}px - ${h2}px - 40px - 40px - var(--el-main-padding) * 2`;
      this.tableHeight = `calc(100vh - ${h1}px - ${h2}px - 40px - 40px - var(--el-main-padding) * 2`
    },
    giveTime(val) {
      //将中国标准时间转为指定格式(该组件返回的标准时间的格式，所以必须的加这个函数)
      this.form.beginTime = dayjs(val[0]).format('YYYY-MM-DD HH:mm:ss');
      this.form.endTime = dayjs(val[1]).format('YYYY-MM-DD HH:mm:ss');
      this.form.beginTime = dayjs(val[0]).format('YYYY-MM-DD HH:mm:ss')
      this.form.endTime = dayjs(val[1]).format('YYYY-MM-DD HH:mm:ss')
    },
    // 页大小改变时触发
    handleSizeChange(val) {
      this.pageSize = val;
      this.pageSize = val

      // 改变每页显示数目时跳到当前页
      this.handleCurrentChange(1);
      this.handleCurrentChange(1)
    },

    // 页号改变时触发
    handleCurrentChange(val) {
      // 将当前页号给currentPage
      this.currentPage = val;
      this.currentPage = val

      // 页面变化时调用 查询数据函数
      this.handleSubmit();
      this.handleSubmit()
    },
    //序号递增
    indexMethod(index) {
      return index + 1 + (this.currentPage - 1) * this.pageSize;
      return index + 1 + (this.currentPage - 1) * this.pageSize
    },

    // 查询数据
    handleSubmit() {

      this.loading = true;
      this.loading = true
      this.queryButton = true
      let params = {};
      params['page'] = this.currentPage;
      params['pageSize'] = this.pageSize;
      let params = {}
      params['page'] = this.currentPage
      params['pageSize'] = this.pageSize
      if (this.form.name) {
        params['siteName'] = this.form.name;
        params['siteName'] = this.form.name
      }
      if (this.form.number) {
        params['mnCode'] = this.form.number;
        params['mnCode'] = this.form.number
      }
      params['beginTime'] = this.form.beginTime;
      params['endTime'] = this.form.endTime;
      params['beginTime'] = this.form.beginTime
      params['endTime'] = this.form.endTime
      if (this.scenarioType.length != 0) {
        params['scenarioType'] = this.scenarioType.join();
        params['scenarioType'] = this.scenarioType.join()
      }
      this.$http.get('/dust/history1', { params: params }).then((response) => {
        // 保存返回的
        this.tableData = response.data.data.rows;
        this.displayData = this.tableData;
        this.loading = false;
        this.tableData = response.data.data.rows
        this.displayData = this.tableData
        this.loading = false
        this.queryButton = false
        if (response.data.data.total == 0) {
          ElMessage('该时段无数据');
          this.loading = false;
          ElMessage('该时段无数据')
          this.loading = false
          this.queryButton = false
          this.isNoData = true;
          return;
          this.isNoData = true
          return
        }
        this.total = response.data.data.total;
        this.total = response.data.data.total
        // 移除空数据状态
        this.isNoData = false;
      });
        this.isNoData = false
      })
    },
    backMinuteDataAWeekAgo() {
      // 打开页面加载最近一周的数据
      this.loading = true;
      this.loading = true
      // 给输入框设置默认的选择项

      let params = {};
      params['siteName'] = this.form.name;
      params['beginTime'] = this.form.beginTime;
      params['endTime'] = this.form.endTime;
      let params = {}
      params['siteName'] = this.form.name
      params['beginTime'] = this.form.beginTime
      params['endTime'] = this.form.endTime

      this.$http.get('/dust/history1', { params: params }).then((response) => {
        // 保存返回的
        this.tableData = response.data.data.rows;
        this.displayData = this.tableData;
        this.tableData = response.data.data.rows
        this.displayData = this.tableData

        if (response.data.data.total == 0) {
          ElMessage('该时段无数据');
          this.isNoData = true;
          return;
          ElMessage('该时段无数据')
          this.isNoData = true
          return
        }
        this.total = response.data.data.total;
        this.loading = false;
      });
    }
        this.total = response.data.data.total
        this.loading = false
      })
    } 
  }
};
}
</script>

<template>
  <div class="history-container"> 
  <el-row>
    <el-col ref="h1" class="head-row">
      <el-card>
        <el-form :inline="true">
          <div class="demo-form-inline">
            <el-row>
              <el-col>
                <el-form-item>
                  <AreaAndmonitorType></AreaAndmonitorType>
                </el-form-item>
  <div class="history-container">
    <el-row>
      <el-col ref="h1" class="head-row">
        <el-card>
          <el-form :inline="true">
            <div class="demo-form-inline">
              <el-row>
                <el-col>
                  <el-form-item>
                    <AreaAndmonitorType></AreaAndmonitorType>
                  </el-form-item>

                <el-form-item>
                  <InputSearch isNeedDefaultSite="1" @submit-value="(n) => (form.name = n)" @submit-site-nums="(n)=>(siteNums=n)">
                  </InputSearch>
                </el-form-item>
                
                <el-form-item>
                  <template #label>
                    <span class="font-label">设备编号:</span>
                  </template>
                  <el-input v-model="form.number" clearable placeholder="请输入"></el-input>
                </el-form-item>
              </el-col>
                  <el-form-item>
                    <InputSearch
                      isNeedDefaultSite="1"
                      @submit-value="(n) => (form.name = n)"
                      @submit-site-nums="(n) => (siteNums = n)"
                    >
                    </InputSearch>
                  </el-form-item>

              <el-col> 
                <el-form-item>
                <TimeShortCuts time-type="week"  @submit-time="giveTime"></TimeShortCuts>
                  <el-form-item>
                    <template #label>
                      <span class="font-label">设备编码:</span>
                    </template>
                    <el-input v-model="form.number" clearable placeholder="请输入"></el-input>
                  </el-form-item>
                </el-col>

                <el-col>
                  <el-form-item>
                    <TimeShortCuts time-type="week" @submit-time="giveTime"></TimeShortCuts>
                  </el-form-item>

                  <el-form-item>
                    <ScenarioType @submitScenarioType="(val) => (scenarioType = val)">
                    </ScenarioType>
                  </el-form-item>
                </el-col>
              </el-row>
            </div>
            <div class="button-and-export">
              <el-form-item>
                <el-tag class="ml-2" type="success" size="large">点位总数</el-tag>
                <span class="tag-text">{{ siteNums }}</span>
              </el-form-item>

              <el-form-item>
                  <ScenarioType @submitScenarioType="(val) => (scenarioType = val)">
                  </ScenarioType>
                </el-form-item>
                <ButtonClick
                  style="margin-right: 12px"
                  content="搜索"
                  type="primary"
                  :loading="queryButton"
                  @do-search="handleSubmit"
                ></ButtonClick>
                <ButtonExportExcel
                  content="导出数据"
                  type="success"
                  :loading="exportButton"
                  @do-export="exportDom"
                ></ButtonExportExcel>
              </el-form-item>
            </div>
          </el-form>
        </el-card>
      </el-col>
      <el-col> </el-col>
    </el-row>

              </el-col>

              
            </el-row>
          </div>
          <div class="button-and-export">
            <el-form-item>
              <el-tag class="ml-2" type="success" size="large">站点总数</el-tag>
              <span class="tag-text">{{ siteNums }}</span>
            </el-form-item>
            
            <el-form-item>
              <ButtonClick style="margin-right: 12px;" content="搜索" type="primary" :loading="queryButton" @do-search="handleSubmit"></ButtonClick>
              <ButtonExportExcel  content="导出数据" type="success" :loading="exportButton" @do-export="exportDom"></ButtonExportExcel>
            </el-form-item>
          </div>
        </el-form>
           
      </el-card>
    </el-col>
    <el-col>
     
    </el-col>
  </el-row>

  <el-row>
    <el-col v-show="!isNoData">

      <el-table border size="default" :highlight-current-row="true" :data="displayData" :height="tableHeight"
        v-loading="loading">
        <!--绑定一个方法，将返回值赋给index,即表格每行数据的下标-->
        <el-table-column type="index" label="序号" align="center" fixed :index="indexMethod"></el-table-column>
        <el-table-column prop="name" label="点位名称" show-overflow-tooltip></el-table-column>
        <el-table-column prop="address" label="地址" align="center" show-overflow-tooltip></el-table-column>
        <el-table-column prop="dutyCompany" label="运维商" align="center" show-overflow-tooltip></el-table-column>
        <el-table-column prop="mnCode" label="设备编码" show-overflow-tooltip></el-table-column>
        <el-table-column prop="typeName" label="类型" align="center" show-overflow-tooltip></el-table-column>
        <el-table-column prop="dustValue" label="TSP(mg/m³)" align="center" sortable
          show-overflow-tooltip></el-table-column>
        <el-table-column prop="noiseValue" label="噪声(dB)" align="center" sortable show-overflow-tooltip></el-table-column>
        <el-table-column prop="lst" label="采集时间" sortable align="center" show-overflow-tooltip></el-table-column>
        <el-table-column prop="quality" label="等级" align="center" show-overflow-tooltip></el-table-column>
        <el-table-column prop="groupName" label="所在区县" align="center" show-overflow-tooltip>
        </el-table-column>
      </el-table>
      <!--size-change 是pageSize 改变时会触发的事件,handleSizeChange是事件处理函数
    <el-row>
      <el-col v-show="!isNoData">
        <el-table
          border
          size="default"
          :highlight-current-row="true"
          :data="displayData"
          :height="tableHeight"
          v-loading="loading"
        >
          <!--绑定一个方法，将返回值赋给index,即表格每行数据的下标-->
          <el-table-column
            type="index"
            label="序号"
            align="center"
            fixed
            :index="indexMethod"
          ></el-table-column>
          <el-table-column prop="name" label="点位名称" show-overflow-tooltip></el-table-column>
          <el-table-column
            prop="address"
            label="地址"
            align="center"
            show-overflow-tooltip
          ></el-table-column>
          <el-table-column
            prop="dutyCompany"
            label="运维商"
            align="center"
            show-overflow-tooltip
          ></el-table-column>
          <el-table-column prop="mnCode" label="设备编码" show-overflow-tooltip></el-table-column>
          <el-table-column
            prop="typeName"
            label="类型"
            align="center"
            show-overflow-tooltip
          ></el-table-column>
          <el-table-column
            prop="dustValue"
            label="TSP(mg/m³)"
            align="center"
            sortable
            show-overflow-tooltip
          ></el-table-column>
          <el-table-column
            prop="noiseValue"
            label="噪声(dB)"
            align="center"
            sortable
            show-overflow-tooltip
          ></el-table-column>
          <el-table-column
            prop="lst"
            label="采集时间"
            sortable
            align="center"
            show-overflow-tooltip
          ></el-table-column>
          <el-table-column
            prop="quality"
            label="等级"
            align="center"
            show-overflow-tooltip
          ></el-table-column>
          <el-table-column prop="groupName" label="所在区县" align="center" show-overflow-tooltip>
          </el-table-column>
        </el-table>
        <!--size-change 是pageSize 改变时会触发的事件,handleSizeChange是事件处理函数
     current-change 是currentPage 改变时会触发的事件    -->

      <el-pagination ref="h2" background @size-change="handleSizeChange" @current-change="handleCurrentChange"
        :page-sizes="[10, 20, 50, 100]" :page-size="pageSize" :total="total"
        layout="total,sizes, prev, pager, next, jumper" :current-page="currentPage"></el-pagination>

    </el-col>
    <el-empty v-show="isNoData" :image-size="200" />

  </el-row>
</div>
        <el-pagination
          ref="h2"
          background
          @size-change="handleSizeChange"
          @current-change="handleCurrentChange"
          :page-sizes="[10, 20, 50, 100]"
          :page-size="pageSize"
          :total="total"
          layout="total,sizes, prev, pager, next, jumper"
          :current-page="currentPage"
        ></el-pagination>
      </el-col>
      <el-empty v-show="isNoData" :image-size="200" />
    </el-row>
  </div>
</template>

<style  scoped>
<style scoped>
.history-container {
  min-width: 1200px;
}
@@ -340,12 +408,12 @@

.el-table {
  /* color: #303133 */
  color: rgb(59, 60, 63)
  color: rgb(59, 60, 63);
}
.el-pagination {
  margin: 10px 10px;
}
.tag-text{
.tag-text {
  margin-left: 10px;
  font-size: 14px;
}