From ebfc739bdbbc0dd0fccd0bf47b7d2d5397c3c511 Mon Sep 17 00:00:00 2001
From: lin <sbla5888@163.com>
Date: Fri, 22 Mar 2024 12:44:21 +0800
Subject: [PATCH] 轮播图片
---
src/views/publicSecurity/ninePlaceManage/hiddenDangerStatistics.vue | 195 +++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 190 insertions(+), 5 deletions(-)
diff --git a/src/views/publicSecurity/ninePlaceManage/hiddenDangerStatistics.vue b/src/views/publicSecurity/ninePlaceManage/hiddenDangerStatistics.vue
index 566b746..eea0eca 100644
--- a/src/views/publicSecurity/ninePlaceManage/hiddenDangerStatistics.vue
+++ b/src/views/publicSecurity/ninePlaceManage/hiddenDangerStatistics.vue
@@ -9,7 +9,7 @@
</div>
<div class="btn-box">
<el-button type="primary" icon="el-icon-search" @click="searchChange">搜索</el-button>
- <el-button icon="el-icon-delete" @click="searchReset">清空</el-button>
+ <el-button icon="el-icon-refresh" @click="searchReset">重置</el-button>
<!-- <el-button type="primary" icon="el-icon-download" @click="exportAvue">导出</el-button> -->
</div>
</div>
@@ -34,6 +34,8 @@
import {
getYHTJList
} from "@/api/publicSecurity/ninePlaceManage"
+import { export_json_to_excels } from "@/util/Export2Excel"
+import { timestampToTime } from "@/util/timeStamp"
export default {
data () {
@@ -202,7 +204,184 @@
methods: {
exportAvue () {
- this.$refs.crud.rowExcel()
+ this.$confirm("是否导出隐患统计数据?", "提示", {
+ confirmButtonText: "确定",
+ cancelButtonText: "取消",
+ type: "warning"
+ }).then(() => {
+ // this.$refs.crud.rowExcel()
+ this.exportBtn()
+ })
+ },
+
+ //json格式化
+ formatJson (filterVal, tableData) {
+ return tableData.map((v) => {
+ return filterVal.map((j) => {
+ return v[j]
+ })
+ })
+ },
+
+ // 导出
+ exportBtn () {
+ const multiHeader = ["序号", "地区", "小商店", "小旅馆", "小学校（幼儿园、校外培训机构）", "", "", "小医院（诊所、养老院）", "", "", "小网吧", "小餐饮场所", "小歌舞娱乐场所", "小美容洗浴场所", "小生产加工企业", "总数"]//第一行表头
+ const tHeader = ["", "", "", "", "学校", "幼儿园", "校外培训机构", "医院", "诊所", "养老院", "", "", "", "", "", "",]//最后一行的表头
+ const filterVal = [
+ "index",
+ "name",
+ "xsd",
+ "xlg",
+ "xxx",
+ "yey",
+ "xwpxjg",
+ "yy",
+ "zs",
+ "yly",
+ "xwb",
+ "xcycs",
+ "xgwylcs",
+ "xmrxycs",
+ "xscjgqy",
+ "count"
+ ]
+
+ var time = timestampToTime((new Date()).getTime())
+ var filename = '隐患统计' + time
+
+ this.data.forEach((item, index) => {
+ item.index = index + 1
+ })
+ var data = this.formatJson(filterVal, this.data)
+ const merges = [//合并单元格
+ {
+ s: {//开始单元格
+ r: 0,//纵轴坐标（1=0,以此类推）
+ c: 0//横轴坐标（A=0,以此类推）
+ },
+ e: {//结束单元格
+ r: 1,
+ c: 0
+ }
+ },
+ {
+ s: {
+ r: 0,
+ c: 1
+ },
+ e: {
+ r: 1,
+ c: 1
+ }
+ },
+ {
+ s: {
+ r: 0,
+ c: 2
+ },
+ e: {
+ r: 1,
+ c: 2
+ }
+ },
+ {
+ s: {
+ r: 0,
+ c: 3
+ },
+ e: {
+ r: 1,
+ c: 3
+ }
+ },
+ {
+ s: {
+ r: 0,
+ c: 4
+ },
+ e: {
+ r: 0,
+ c: 6
+ }
+ },
+ {
+ s: {
+ r: 0,
+ c: 7
+ },
+ e: {
+ r: 0,
+ c: 9
+ }
+ },
+ {
+ s: {
+ r: 0,
+ c: 10
+ },
+ e: {
+ r: 1,
+ c: 10
+ }
+ },
+ {
+ s: {
+ r: 0,
+ c: 11
+ },
+ e: {
+ r: 1,
+ c: 11
+ }
+ },
+ {
+ s: {
+ r: 0,
+ c: 12
+ },
+ e: {
+ r: 1,
+ c: 12
+ }
+ },
+ {
+ s: {
+ r: 0,
+ c: 13
+ },
+ e: {
+ r: 1,
+ c: 13
+ }
+ },
+ {
+ s: {
+ r: 0,
+ c: 14
+ },
+ e: {
+ r: 1,
+ c: 14
+ }
+ },
+ {
+ s: {
+ r: 0,
+ c: 15
+ },
+ e: {
+ r: 1,
+ c: 15
+ }
+ }
+ ]
+ export_json_to_excels({
+ headerOne: multiHeader,
+ headerTwo: tHeader,
+ merges,
+ data,
+ filename
+ })
},
getLastMouth (str = '-') {
@@ -325,7 +504,7 @@
searchReset () {
this.query = {}
- this.dateTime = []
+ this.dateTime = this.getLastMouth()
this.onLoad()
},
@@ -396,10 +575,16 @@
this.loading = true
if (!this.query.startTime) {
this.query = {
- startTime: this.getLastMouth()[1],
- endTime: this.getLastMouth()[0],
+ startTime: this.getLastMouth()[0],
+ endTime: this.getLastMouth()[1],
}
}
+ if ('startTime' in this.query) {
+ this.query.startTime += ' 00:00:00'
+ }
+ if ('endTime' in this.query) {
+ this.query.endTime += ' 23:59:59'
+ }
getYHTJList(this.query).then(res => {
console.log('getZGQKList', res.data.data)
const data = res.data.data
--
Gitblit v1.9.3