| | |
| | | <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" |
| | |
| | | </el-radio-group> |
| | | </el-form-item>--> |
| | | <el-form-item label="统计时间"> |
| | | <el-date-picker clearable size="small" style="width: 200px" |
| | | v-model="queryParams.dataTime" |
| | | type="year" |
| | | value-format="yyyy" |
| | | placeholder="选择日期"> |
| | | <el-date-picker |
| | | clearable |
| | | size="small" |
| | | style="width: 200px" |
| | | v-model="queryParams.dataTime" |
| | | type="year" |
| | | value-format="yyyy" |
| | | 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> |
| | | |
| | | <el-table :data="list" border style="width: 100%; margin-top: 20px" class="tableList" > |
| | | <el-table-column fixed prop="indexName" align="center" label="能源名称" min-width="240px"></el-table-column> |
| | | <el-table-column label="1月" align="center" min-width="140px"> <template slot-scope="scope">{{numFilter(scope.row.value1)}}</template></el-table-column> |
| | | <el-table-column label="2月" align="center" min-width="140px"> <template slot-scope="scope">{{numFilter(scope.row.value2)}}</template></el-table-column> |
| | | <el-table-column label="3月" align="center" min-width="140px"> <template slot-scope="scope">{{numFilter(scope.row.value3)}}</template></el-table-column> |
| | | <el-table-column label="4月" align="center" min-width="140px"> <template slot-scope="scope">{{numFilter(scope.row.value4)}}</template></el-table-column> |
| | | <el-table-column label="5月" align="center" min-width="140px"> <template slot-scope="scope">{{numFilter(scope.row.value5)}}</template></el-table-column> |
| | | <el-table-column label="6月" align="center" min-width="140px"> <template slot-scope="scope">{{numFilter(scope.row.value6)}}</template></el-table-column> |
| | | <el-table-column label="7月" align="center" min-width="140px"> <template slot-scope="scope">{{numFilter(scope.row.value7)}}</template></el-table-column> |
| | | <el-table-column label="8月" align="center" min-width="140px"> <template slot-scope="scope">{{numFilter(scope.row.value8)}}</template></el-table-column> |
| | | <el-table-column label="9月" align="center" min-width="140px"> <template slot-scope="scope">{{numFilter(scope.row.value9)}}</template></el-table-column> |
| | | <el-table-column label="10月" align="center" min-width="140px"> <template slot-scope="scope">{{numFilter(scope.row.value10)}}</template></el-table-column> |
| | | <el-table-column label="11月" align="center" min-width="140px"> <template slot-scope="scope">{{numFilter(scope.row.value11)}}</template></el-table-column> |
| | | <el-table-column label="12月" align="center" min-width="140px"> <template slot-scope="scope">{{numFilter(scope.row.value12)}}</template></el-table-column> |
| | | <el-table :data="list" border style="width: 100%; margin-top: 20px"> |
| | | <el-table-column |
| | | fixed |
| | | prop="indexName" |
| | | align="center" |
| | | label="能源指标名称" |
| | | min-width="240px" |
| | | ></el-table-column> |
| | | <el-table-column label="1月" align="center" min-width="140px"> |
| | | <template slot-scope="scope">{{ |
| | | numFilter(scope.row.value1) |
| | | }}</template></el-table-column |
| | | > |
| | | <el-table-column label="2月" align="center" min-width="140px"> |
| | | <template slot-scope="scope">{{ |
| | | numFilter(scope.row.value2) |
| | | }}</template></el-table-column |
| | | > |
| | | <el-table-column label="3月" align="center" min-width="140px"> |
| | | <template slot-scope="scope">{{ |
| | | numFilter(scope.row.value3) |
| | | }}</template></el-table-column |
| | | > |
| | | <el-table-column label="4月" align="center" min-width="140px"> |
| | | <template slot-scope="scope">{{ |
| | | numFilter(scope.row.value4) |
| | | }}</template></el-table-column |
| | | > |
| | | <el-table-column label="5月" align="center" min-width="140px"> |
| | | <template slot-scope="scope">{{ |
| | | numFilter(scope.row.value5) |
| | | }}</template></el-table-column |
| | | > |
| | | <el-table-column label="6月" align="center" min-width="140px"> |
| | | <template slot-scope="scope">{{ |
| | | numFilter(scope.row.value6) |
| | | }}</template></el-table-column |
| | | > |
| | | <el-table-column label="7月" align="center" min-width="140px"> |
| | | <template slot-scope="scope">{{ |
| | | numFilter(scope.row.value7) |
| | | }}</template></el-table-column |
| | | > |
| | | <el-table-column label="8月" align="center" min-width="140px"> |
| | | <template slot-scope="scope">{{ |
| | | numFilter(scope.row.value8) |
| | | }}</template></el-table-column |
| | | > |
| | | <el-table-column label="9月" align="center" min-width="140px"> |
| | | <template slot-scope="scope">{{ |
| | | numFilter(scope.row.value9) |
| | | }}</template></el-table-column |
| | | > |
| | | <el-table-column label="10月" align="center" min-width="140px"> |
| | | <template slot-scope="scope">{{ |
| | | numFilter(scope.row.value10) |
| | | }}</template></el-table-column |
| | | > |
| | | <el-table-column label="11月" align="center" min-width="140px"> |
| | | <template slot-scope="scope">{{ |
| | | numFilter(scope.row.value11) |
| | | }}</template></el-table-column |
| | | > |
| | | <el-table-column label="12月" align="center" min-width="140px"> |
| | | <template slot-scope="scope">{{ |
| | | numFilter(scope.row.value12) |
| | | }}</template></el-table-column |
| | | > |
| | | </el-table> |
| | | |
| | | </div> |
| | | </template> |
| | | |
| | | <script> |
| | | import { reportStatisticsList,exportList} from "@/api/reportForm/annualReport/annualReport"; |
| | | import { |
| | | reportStatisticsList, |
| | | exportList |
| | | } from "@/api/reportForm/annualReport/annualReport"; |
| | | |
| | | export default { |
| | | data() { |
| | | return { |
| | | list: [], |
| | | skinName:"", |
| | | queryParams:{ |
| | | timeType:"MONTH", |
| | | 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 => { |
| | | export default { |
| | | data() { |
| | | return { |
| | | list: [], |
| | | skinName: "", |
| | | queryParams: { |
| | | timeType: "MONTH", |
| | | 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; |
| | | let times = this.queryParams.dataTime.slice(0, 4); |
| | | this.queryParams.beginTime = times + "-01-01 00:00:00"; |
| | | this.queryParams.endTime = times + "-12-31 00:00:00"; |
| | | reportStatisticsList(this.queryParams).then(response => { |
| | | 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; |
| | | let times=this.queryParams.dataTime.slice(0,4); |
| | | this.queryParams.beginTime=times+"-01-01 00:00:00" |
| | | this.queryParams.endTime=times+"-12-31 00:00:00" |
| | | reportStatisticsList(this.queryParams).then(response => { |
| | | 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; |
| | | queryParams.dataTime=queryParams.dataTime+"-01-01"; |
| | | this.$confirm('是否确认导出所有报表数据?', "警告", { |
| | | confirmButtonText: "确定", |
| | | cancelButtonText: "取消", |
| | | type: "warning" |
| | | }).then(function () { |
| | | /** 重置按钮操作 */ |
| | | resetQuery() { |
| | | this.resetForm("queryForm"); |
| | | this.handleQuery(); |
| | | }, |
| | | /** 导出按钮操作 */ |
| | | handleExport() { |
| | | const queryParams = this.queryParams; |
| | | queryParams.dataTime = queryParams.dataTime + "-01-01"; |
| | | 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{ |
| | | border-bottom: 1px solid #000000 !important; |
| | | border-right: 1px solid #000000 !important; |
| | | } |
| | | .tableList{ |
| | | border: 1px solid #000000 !important; |
| | | } |
| | | </style> |
| | | <style scoped></style> |