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 | 307 ++++++++++++++++++++++++++++++++++++++++++++++----
1 files changed, 279 insertions(+), 28 deletions(-)
diff --git a/src/views/publicSecurity/ninePlaceManage/hiddenDangerStatistics.vue b/src/views/publicSecurity/ninePlaceManage/hiddenDangerStatistics.vue
index 4284ecc..eea0eca 100644
--- a/src/views/publicSecurity/ninePlaceManage/hiddenDangerStatistics.vue
+++ b/src/views/publicSecurity/ninePlaceManage/hiddenDangerStatistics.vue
@@ -1,10 +1,28 @@
<template>
<basic-container>
+ <div class="search-box">
+ <div class="date-box">
+ <div class="name">检查时间:</div>
+ <el-date-picker v-model="dateTime" type="daterange" range-separator="至" start-placeholder="开始日期"
+ end-placeholder="结束日期" value-format="yyyy-MM-dd" format="yyyy-MM-dd">
+ </el-date-picker>
+ </div>
+ <div class="btn-box">
+ <el-button type="primary" icon="el-icon-search" @click="searchChange">搜索</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>
+
<avue-crud :option="option" :table-loading="loading" :data="data" :page.sync="page" ref="crud" @row-del="rowDel"
v-model="form" :permission="permissionList" @row-update="rowUpdate" @row-save="rowSave"
:before-open="beforeOpen" @search-change="searchChange" @search-reset="searchReset"
@selection-change="selectionChange" @current-change="currentChange" @size-change="sizeChange"
@refresh-change="refreshChange" @on-load="onLoad">
+ <template slot="menuLeft">
+ <el-button type="warning" size="small" plain icon="el-icon-download" @click="exportAvue">导出
+ </el-button>
+ </template>
</avue-crud>
</basic-container>
</template>
@@ -16,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 () {
@@ -29,7 +49,7 @@
currentPage: 1,
total: 0,
},
- datetime: "",
+ dateTime: "",
selectionList: [],
option: {
height: "auto",
@@ -44,7 +64,7 @@
editBtn: false,
delBtn: false,
addBtn: false,
- excelBtn: true,
+ excelBtn: false,
columnBtn: false,
refreshBtn: false,
dialogClickModal: false,
@@ -135,19 +155,24 @@
prop: "count",
align: 'center',
},
- {
- label: "检查时间",
- prop: "daterange",
- type: "daterange",
- format: 'yyyy-MM-DD',
- valueFormat: 'yyyy-MM-DD',
- startPlaceholder: '日期开始范围自定义',
- endPlaceholder: '日期结束范围自定义',
- hide: true,
- search: true,
- searchSpan: 6,
- searchRange: true,
- }],
+ // {
+ // label: "检查时间",
+ // prop: "dateTime",
+ // type: "daterange",
+ // format: 'yyyy-MM-DD',
+ // valueFormat: 'yyyy-MM-DD',
+ // isAdmin: true,//自定义属性
+ // startPlaceholder: '日期开始范围',
+ // endPlaceholder: '日期结束范围',
+ // hide: true,
+ // addDisplay: false,
+ // editDisplay: false,
+ // viewDisplay: false,
+ // search: true,
+ // searchSpan: 6,
+ // searchRange: true,
+ // }
+ ],
},
data: []
}
@@ -173,7 +198,192 @@
},
+ created () {
+ this.dateTime = this.getLastMouth()
+ },
+
methods: {
+ exportAvue () {
+ 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 = '-') {
let today = new Date()
let lastMouth = new Date()
@@ -192,9 +402,8 @@
let mDay = lastMouth.getDate().toString()
if (mDay.length <= 1) mDay = "0" + mDay
let todayDate = oYear + str + oMoth + str + oDay
- let lastMouthDate = mYear + str + mMoth + str + mDay
- console.log('[todayDate, lastMouthDate]', [todayDate, lastMouthDate])
- return [todayDate, lastMouthDate]
+ let lastMouthDate = mYear + str + mMoth + str + mDay//暂时改成2024-01-01
+ return ['2024-01-01', todayDate]
},
rowSave (row, done, loading) {
@@ -295,19 +504,17 @@
searchReset () {
this.query = {}
+ this.dateTime = this.getLastMouth()
this.onLoad()
},
- searchChange (params, done) {
- console.log('searchChange', params)
-
- this.query = params.daterange ? {
- startTime: params.daterange[0],
- endTime: params.daterange[1],
+ searchChange (params) {
+ this.query = this.dateTime ? {
+ startTime: this.dateTime[0],
+ endTime: this.dateTime[1],
} : {}
this.page.currentPage = 1
this.onLoad()
- done()
},
selectionChange (list) {
@@ -368,16 +575,22 @@
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
// 总合计行
let countItem = {
- name: '信州区合计',
+ name: '信州区',
xscjgqy: 0,
xmrxycs: 0,
xgwylcs: 0,
@@ -397,6 +610,8 @@
data.forEach(item => {
// 统计总数
item.count = 0
+ // 检查时间
+ item.dateTime = ''
item.nineTypeStatistics.forEach(element => {
item.count += Number(element.number)
@@ -457,4 +672,40 @@
.avue-upload__icon {
line-height: 6;
}
+
+.search-box {
+ display: flex;
+ margin-bottom: 20px;
+
+ .date-box {
+ display: flex;
+
+ .name {
+ margin-right: 10px;
+ display: flex;
+ align-items: center;
+ font-size: 14px;
+ }
+
+ :deep(.el-input__inner) {
+ height: 32px;
+ }
+
+ :deep(.el-date-editor .el-range__icon),
+ :deep(.el-date-editor .el-range__close-icon) {
+ line-height: 26px;
+ }
+ }
+
+
+ .btn-box {
+ margin-left: 20px;
+
+ :deep(.el-button) {
+ width: 76px;
+ height: 32px;
+ padding: 0;
+ }
+ }
+}
</style>
--
Gitblit v1.9.3