轮播图片

lin

2024-03-22 ebfc739bdbbc0dd0fccd0bf47b7d2d5397c3c511

 src/views/publicSecurity/ninePlaceManage/hiddenDangerStatistics.vue

@@ -1,12 +1,26 @@
<template>
    <basic-container>
        <avue-crud :option="option" :table-loading="loading" :data="data" :page.sync="page" ref="crud"
            :summary-method="summaryMethod" @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">
        <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="handleExport">导出
                <el-button type="warning" size="small" plain icon="el-icon-download" @click="exportAvue">导出
                </el-button>
            </template>
        </avue-crud>
@@ -20,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 () {
@@ -33,7 +49,7 @@
                currentPage: 1,
                total: 0,
            },
            datetime: "",
            dateTime: "",
            selectionList: [],
            option: {
                height: "auto",
@@ -48,11 +64,10 @@
                editBtn: false,
                delBtn: false,
                addBtn: false,
                excelBtn: true,
                excelBtn: false,
                columnBtn: false,
                refreshBtn: false,
                dialogClickModal: false,
                showSummary: true,
                column: [
                    {
                        label: "地区",
@@ -140,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: []
        }
@@ -178,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()
@@ -197,28 +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]
        },

        summaryMethod ({ columns, data }) {
            const sums = []
            if (columns.length > 0) {
                columns.forEach((column, index) => {
                    let prop = column.property
                    if (prop == 'name') {
                        sums[index] = '信州区合计'
                    } else {
                        let values = this.data.map(item => Number(item[prop] || 0))
                        let all = values.length !== 0 ? sums[index] = values.reduce((a, b) => {
                            return a + b
                        }) : 0
                        sums[index] = all
                    }
                })
            }
            return sums
            let lastMouthDate = mYear + str + mMoth + str + mDay//暂时改成2024-01-01
            return ['2024-01-01', todayDate]
        },

        rowSave (row, done, loading) {
@@ -245,7 +430,7 @@
                label
            }).then(
                () => {
                    this.onLoad(this.page)
                    this.onLoad()
                    this.$message({
                        type: "success",
                        message: "操作成功!",
@@ -283,7 +468,7 @@
                label
            }).then(
                () => {
                    this.onLoad(this.page)
                    this.onLoad()
                    this.$message({
                        type: "success",
                        message: "操作成功!",
@@ -308,7 +493,7 @@
                    return removeTask(row)
                })
                .then(() => {
                    this.onLoad(this.page)
                    this.onLoad()

                    this.$message({
                        type: "success",
@@ -319,19 +504,17 @@

        searchReset () {
            this.query = {}
            this.onLoad(this.page)
            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(this.page)
            done()
            this.onLoad()
        },

        selectionChange (list) {
@@ -359,7 +542,7 @@
                    return remove(this.ids)
                })
                .then(() => {
                    this.onLoad(this.page)
                    this.onLoad()
                    this.$message({
                        type: "success",
                        message: "操作成功!",
@@ -388,51 +571,94 @@
            // this.onLoad(this.page, this.query)
        },

        onLoad (page, params = {}) {
        onLoad () {
            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],
                }
            }
            getYHTJList(page.currentPage, page.pageSize, this.query).then(res => {
            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: '信州区',
                    xscjgqy: 0,
                    xmrxycs: 0,
                    xgwylcs: 0,
                    xcycs: 0,
                    xwb: 0,
                    xlg: 0,
                    xsd: 0,
                    yey: 0,
                    yly: 0,
                    xwpxjg: 0,
                    xxx: 0,
                    zs: 0,
                    xxx: 0,
                    yy: 0,
                    count: 0
                }
                data.forEach(item => {
                    // 统计总数
                    item.count = 0
                    // 检查时间
                    item.dateTime = ''

                    item.nineTypeStatistics.forEach(element => {
                        item.count += Number(element.number)
                        if (element.dict_value == '小生产加工企业') {
                            item.xscjgqy = element.number
                            countItem.xscjgqy += Number(item.xscjgqy)
                        } else if (element.dict_value == '小美容洗浴场所') {
                            item.xmrxycs = element.number
                            countItem.xmrxycs += Number(item.xmrxycs)
                        } else if (element.dict_value == '小歌舞娱乐场所') {
                            item.xgwylcs = element.number
                            countItem.xgwylcs += Number(item.xgwylcs)
                        } else if (element.dict_value == '小餐饮场所') {
                            item.xcycs = element.number
                            countItem.xcycs += Number(item.xcycs)
                        } else if (element.dict_value == '小网吧') {
                            item.xwb = element.number
                            countItem.xwb += Number(item.xwb)
                        } else if (element.dict_value == '小旅馆') {
                            item.xlg = element.number
                            countItem.xlg += Number(item.xlg)
                        } else if (element.dict_value == '小商店') {
                            item.xsd = element.number
                            countItem.xsd += Number(item.xsd)
                        } else if (element.dict_value == '幼儿园') {
                            item.yey = element.number
                            countItem.yey += Number(item.yey)
                        } else if (element.dict_value == '养老院') {
                            item.yly = element.number
                            countItem.yly += Number(item.yly)
                        } else if (element.dict_value == '校外培训机构') {
                            item.xwpxjg = element.number
                        } else if (element.dict_value == '小学校') {
                            countItem.xwpxjg += Number(item.xwpxjg)
                        } else if (element.dict_value == '学校') {
                            item.xxx = element.number
                            countItem.xxx += Number(item.xxx)
                        } else if (element.dict_value == '诊所') {
                            item.zs = element.number
                            countItem.zs += Number(item.zs)
                        } else if (element.dict_value == '医院') {
                            item.yy = element.number
                            countItem.yy += Number(item.yy)
                        }
                    })
                    countItem.count += Number(item.count)
                })
                data.push(countItem)
                this.data = data
                this.loading = false
                this.selectionClear()
@@ -446,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>