ali
2024-09-03 0ae83a895e80a4b9777a27f613d721a7e5e2ac18
energy_management_ui/src/views/reportForm/monthlyReport/index.vue
@@ -1,8 +1,16 @@
<template>
  <div class="app-container">
    <el-form :model="queryParams" ref="queryForm" :inline="true" label-width="68px">
    <el-form
      :model="queryParams"
      ref="queryForm"
      :inline="true"
      label-width="68px"
    >
      <el-form-item label="能源类型">
        <el-select v-model="queryParams.indexStorageId" placeholder="请选择能源品种">
        <el-select
          v-model="queryParams.indexStorageId"
          placeholder="请选择能源品种"
        >
          <el-option
            v-for="dict in indexCategoryOptions"
            :key="dict.dictValue"
@@ -17,230 +25,169 @@
        </el-radio-group>
      </el-form-item>-->
      <el-form-item label="统计时间">
        <el-date-picker clearable size="small" style="width: 200px"
                        v-model="queryParams.dataTime"
                        type="month"
                        value-format="yyyy-MM"
                        placeholder="选择日期">
        <el-date-picker
          clearable
          size="small"
          style="width: 200px"
          v-model="queryParams.dataTime"
          type="month"
          value-format="yyyy-MM"
          placeholder="选择日期"
        >
        </el-date-picker>
      </el-form-item>
      <el-form-item>
        <el-button type="primary" icon="el-icon-search" size="mini" @click="handleQuery">搜索</el-button>
        <el-button icon="el-icon-refresh" size="mini" @click="resetQuery">重置</el-button>
        <el-button type="warning" icon="el-icon-download" size="mini" @click="handleExport">导出</el-button>
        <el-button
          type="primary"
          icon="el-icon-search"
          size="mini"
          @click="handleQuery"
          >搜索</el-button
        >
        <el-button icon="el-icon-refresh" size="mini" @click="resetQuery"
          >重置</el-button
        >
        <el-button
          type="warning"
          icon="el-icon-download"
          size="mini"
          @click="handleExport"
          >导出</el-button
        >
      </el-form-item>
    </el-form>
    <div class="el-table el-table--fit el-table--scrollable-x el-table--enable-row-hover el-table--medium" >
      <div class="el-table__body-wrapper is-scrolling-left">
        <table class="el-table__body tableList" cellspacing="0" cellpadding="0" style="width: 2600px">
          <thead>
          <tr v-for="item in tableHead" >
            <td style="background: #dfe6ec;">能源指标名称</td>
            <td>{{item.value1}}</td>
            <td>{{item.value2}}</td>
            <td>{{item.value3}}</td>
            <td>{{item.value4}}</td>
            <td>{{item.value5}}</td>
            <td>{{item.value6}}</td>
            <td>{{item.value7}}</td>
            <td>{{item.value8}}</td>
            <td>{{item.value9}}</td>
            <td>{{item.value10}}</td>
            <td>{{item.value11}}</td>
            <td>{{item.value12}}</td>
            <td>{{item.value13}}</td>
            <td>{{item.value14}}</td>
            <td>{{item.value15}}</td>
            <td>{{item.value16}}</td>
            <td>{{item.value17}}</td>
            <td>{{item.value18}}</td>
            <td>{{item.value19}}</td>
            <td>{{item.value20}}</td>
            <td>{{item.value21}}</td>
            <td>{{item.value22}}</td>
            <td>{{item.value23}}</td>
            <td>{{item.value24}}</td>
            <td>{{item.value25}}</td>
            <td>{{item.value26}}</td>
            <td>{{item.value27}}</td>
            <td v-if="item.value29 !=null">{{item.value28}}</td>
            <td v-if="item.value29 !=null">{{item.value29}}</td>
            <td v-if="item.value30 !=null">{{item.value30}}</td>
            <td v-if="item.value31 !=null">{{item.value31}}</td>
          </tr>
          </thead>
          <tbody>
          <tr v-for="data in tableData">
            <td>{{data.indexName}}</td>
            <td>{{numFilter(data.value1)}}</td>
            <td>{{numFilter(data.value2)}}</td>
            <td>{{numFilter(data.value3)}}</td>
            <td>{{numFilter(data.value4)}}</td>
            <td>{{numFilter(data.value5)}}</td>
            <td>{{numFilter(data.value6)}}</td>
            <td>{{numFilter(data.value7)}}</td>
            <td>{{numFilter(data.value8)}}</td>
            <td>{{numFilter(data.value9)}}</td>
            <td>{{numFilter(data.value10)}}</td>
            <td>{{numFilter(data.value11)}}</td>
            <td>{{numFilter(data.value12)}}</td>
            <td>{{numFilter(data.value13)}}</td>
            <td>{{numFilter(data.value14)}}</td>
            <td>{{numFilter(data.value15)}}</td>
            <td>{{numFilter(data.value16)}}</td>
            <td>{{numFilter(data.value17)}}</td>
            <td>{{numFilter(data.value18)}}</td>
            <td>{{numFilter(data.value19)}}</td>
            <td>{{numFilter(data.value20)}}</td>
            <td>{{numFilter(data.value21)}}</td>
            <td>{{numFilter(data.value22)}}</td>
            <td>{{numFilter(data.value23)}}</td>
            <td>{{numFilter(data.value24)}}</td>
            <td>{{numFilter(data.value25)}}</td>
            <td>{{numFilter(data.value26)}}</td>
            <td>{{numFilter(data.value27)}}</td>
            <td v-if="data.count>=28">{{numFilter(data.value28)}}</td>
            <td v-if="data.count>=29">{{numFilter(data.value29)}}</td>
            <td v-if="data.count>=30">{{numFilter(data.value30)}}</td>
            <td v-if="data.count==31">{{numFilter(data.value31)}}</td>
          </tr>
          </tbody>
        </table>
      </div>
    </div>
    <el-table :data="tableData" border style="width: 100%;margin-top: 20px">
      <el-table-column
        prop="indexName"
        align="center"
        label="能源指标名称"
        min-width="220"
        fixed="left"
      />
      <el-table-column
        v-for="index in 31"
        :key="index"
        :label="`${index}日`"
        align="center"
        min-width="140px"
      >
        <template slot-scope="scope">
          <span style="font-size: 12px">
            {{ numFilter(scope.row[`value${index}`]) || "--" }}
          </span>
        </template>
      </el-table-column>
    </el-table>
  </div>
</template>
<script>
  import { reportStatisticsList,exportList} from "@/api/reportForm/monthlyReport/monthlyReport";
  export default {
    data() {
      return {
        tableData: [],
        tableHead:[],
        skinName:"",
        queryParams:{
          timeType:"DAY",
          energyId:undefined,
          dataTime:undefined,
          beginTime:undefined,
          endTime:undefined,
          indexCode:undefined,
          indexStorageId:undefined,
        },
        indexCategoryOptions:[],
      };
    },
    created() {
      this.modelCode=this.$route.query.modelCode;
      /*this.getDicts("report_form").then(response => {
import {
  reportStatisticsList,
  exportList
} from "@/api/reportForm/monthlyReport/monthlyReport";
export default {
  data() {
    return {
      tableData: [],
      tableHead: [],
      skinName: "",
      queryParams: {
        timeType: "DAY",
        energyId: undefined,
        dataTime: undefined,
        beginTime: undefined,
        endTime: undefined,
        indexCode: undefined,
        indexStorageId: undefined
      },
      indexCategoryOptions: []
    };
  },
  created() {
    this.modelCode = this.$route.query.modelCode;
    /*this.getDicts("report_form").then(response => {
        this.dateTypeOptions = response.data;
        this.queryParams.timeType = this.dateTypeOptions.find(f => f.isDefault === 'Y').dictValue;
      });*/
      this.getDicts("energy_type").then(response => {
        this.indexCategoryOptions = response.data;
        //this.queryParams.indexStorageId = this.indexCategoryOptions[0].dictValue;
    this.getDicts("energy_type").then(response => {
      this.indexCategoryOptions = response.data;
      //this.queryParams.indexStorageId = this.indexCategoryOptions[0].dictValue;
    });
    this.getConfigKey("report_statistics").then(response => {
      this.skinName = response.msg;
    });
    this.getTime();
    this.getList();
  },
  methods: {
    /** 查询部门列表 */
    getList() {
      //this.loading = true;
      this.queryParams.indexCode = this.modelCode;
      reportStatisticsList(this.queryParams).then(response => {
        console.log(response.data);
        this.tableData = response.data.tabledata;
        this.tableHead = response.data.tablehead;
        //this.list=response.data;
        this.loading = false;
      });
      this.getConfigKey("report_statistics").then(response => {
        this.skinName=response.msg;
      });
      this.getTime();
    },
    /** 搜索按钮操作 */
    handleQuery() {
      this.getList();
    },
    methods: {
      /** 查询部门列表 */
      getList() {
        //this.loading = true;
        this.queryParams.indexCode=this.modelCode;
        reportStatisticsList(this.queryParams).then(response => {
          console.log(response.data)
          this.tableData=response.data.tabledata
          this.tableHead=response.data.tablehead
          //this.list=response.data;
          this.loading = false;
        });
      },
      /** 搜索按钮操作 */
      handleQuery() {
        this.queryParams.pageNum = 1;
        this.getList();
      },
      /** 重置按钮操作 */
      resetQuery() {
        this.resetForm("queryForm");
        this.handleQuery();
      },
      /** 导出按钮操作 */
      handleExport() {
        const queryParams = this.queryParams;
        this.$confirm('是否确认导出所有报表数据?', "警告", {
          confirmButtonText: "确定",
          cancelButtonText: "取消",
          type: "warning"
        }).then(function () {
    /** 重置按钮操作 */
    resetQuery() {
      this.resetForm("queryForm");
      this.handleQuery();
    },
    /** 导出按钮操作 */
    handleExport() {
      const queryParams = this.queryParams;
      this.$confirm("是否确认导出所有报表数据?", "警告", {
        confirmButtonText: "确定",
        cancelButtonText: "取消",
        type: "warning"
      })
        .then(function() {
          return exportList(queryParams);
        }).then(response => {
        })
        .then(response => {
          this.download(response.msg);
        }).catch(function () {
        });
      },
      handleTime(date){
        if(date=='MONTH'){
          this.dateTypes= 'year',
          this.valueFormat='yyyy'
        }else if(date=='DAY'){
          this.dateTypes= 'month',
          this.valueFormat='yyyy-MM'
        }else{
          this.dateTypes= 'date',
          this.valueFormat='yyyy-MM-dd'
        }
      },
      getTime(){
        var date = new Date()
        var year = date.getFullYear()
        var month = date.getMonth() + 1
        var date = date.getDate()
        month = month < 10 ? '0' + month : month
        date = date < 10 ? '0' + date : date
        this.queryParams.dataTime=year + '-' + month
      },
      numFilter(value) {// 截取当前数据到小数点后的几位
        let realVal = '' ;
        if (!isNaN(value) && value !== '' && value !== null) {
          realVal = parseFloat(value).toFixed(this.skinName)
        } else {
          realVal = '--'
        }
        return realVal
      },
        })
        .catch(function() {});
    },
    handleTime(date) {
      if (date == "MONTH") {
        (this.dateTypes = "year"), (this.valueFormat = "yyyy");
      } else if (date == "DAY") {
        (this.dateTypes = "month"), (this.valueFormat = "yyyy-MM");
      } else {
        (this.dateTypes = "date"), (this.valueFormat = "yyyy-MM-dd");
      }
    },
    getTime() {
      var date = new Date();
      var year = date.getFullYear();
      var month = date.getMonth() + 1;
      var date = date.getDate();
      month = month < 10 ? "0" + month : month;
      date = date < 10 ? "0" + date : date;
      this.queryParams.dataTime = year + "-" + month;
    },
    numFilter(value) {
      // 截取当前数据到小数点后的几位
      let realVal = "";
      if (!isNaN(value) && value !== "" && value !== null) {
        realVal = parseFloat(value).toFixed(this.skinName);
      } else {
        realVal = "--";
      }
      return realVal;
    }
  };
  }
};
</script>
<style scoped>
  .tableList th.is-leaf, .tableList td{
    text-align: center;
    width:180px !important;
    border-bottom: 1px solid #000000 !important;
    border-right: 1px solid #000000 !important;
  }
  .tableList{
    border: 1px solid #000000 !important;
    max-height: 300px;
  }
/*  .tableList thead tr > th:first-child,*/
  .tableList tr > td:first-child {
    position: sticky;
    left: 0;
    z-index: 1;
    background: #fff;
    width: 240px;
  }
  .tableList thead tr {
    position: sticky;
    top: 0;
    z-index: 2;
    background: #dfe6ec;
  }
</style>
<style scoped></style>