矛盾纠纷新增校验，新增导入导出

zhongrj

2024-03-25 cf5de156ec890412db81404a9028821bc4bdd11e

矛盾纠纷新增校验，新增导入导出

 src/api/disputeRecord/disputeRecord.js

New file
@@ -0,0 +1,49 @@
import request from '@/router/axios';

export const getList = (current, size, params) => {
  return request({
    url: '/api/blade-disputeRecord/disputeRecord/page',
    method: 'get',
    params: {
      ...params,
      current,
      size,
    }
  })
}

export const remove = (ids) => {
  return request({
    url: '/api/blade-disputeRecord/disputeRecord/remove',
    method: 'post',
    params: {
      ids,
    }
  })
}

export const add = (row) => {
  return request({
    url: '/api/blade-disputeRecord/disputeRecord/saveOrUpdate',
    method: 'post',
    data: row
  })
}

export const update = (row) => {
  return request({
    url: '/api/blade-disputeRecord/disputeRecord/saveOrUpdate',
    method: 'post',
    data: row
  })
}

export const getDetail = (id) => {
  return request({
    url: '/api/blade-disputeRecord/disputeRecord/getDetail',
    method: 'get',
    params: {
      id
    }
  })
}

 src/views/backblask/BackblastPubRecord.vue

@@ -395,6 +395,7 @@
                this.page.total = data.total
                this.data = data.records
                this.data.forEach(item => {
                    this.$set(item, 'policemanPhoneflag', false)
                    if (item.pubUrls && item.pubUrls != '' && item.pubUrls != null && item.pubUrls.length) {
                        var urls = []
                        var names = item.pubUrls.split(",").filter(item => item != '')

 src/views/backblask/BackblastWarnHanRec.vue

@@ -397,6 +397,7 @@
                this.page.total = data.total
                this.data = data.records
                this.data.forEach(item => {
                    this.$set(item, 'policemanPhoneflag', false)
                    if (item.sceUrls && item.sceUrls != '' && item.sceUrls != null && item.sceUrls.length) {
                        var urls = []
                        var names = item.sceUrls.split(",").filter(item => item != '')

 src/views/disputeRecord/disputeRecord.vue

New file
@@ -0,0 +1,812 @@
<template>
    <basic-container>
        <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-scope="{row, size}" slot="phoneOne">
                <el-button :size="size" type="text" @click="showStringDispose(row, 'phoneOneflag')"
                    v-text="textDispose(row, 'phoneOneflag', 'phoneOne')">
                </el-button>
            </template>
            <template slot-scope="{row, size}" slot="idCardOne">
                <el-button :size="size" type="text" @click="showStringDispose(row, 'idCardOneflag')"
                    v-text="textDispose(row, 'idCardOneflag', 'idCardOne')">
                </el-button>
            </template>


            <template slot="menuLeft">
                <el-button type="success" size="small" plain v-if="permission.dispute_record_import"
                    icon="el-icon-upload2" @click="handleImport">导入
                </el-button>
                <el-button type="warning" size="small" plain v-if="permission.dispute_record_export"
                    icon="el-icon-download" @click="handleExport">导出
                </el-button>
            </template>
        </avue-crud>
        <el-dialog title="矛盾纠纷事件数据导入" append-to-body :visible.sync="excelBox" width="555px">
            <avue-form :option="excelOption" v-model="excelForm" :upload-after="uploadAfter">
                <template slot="excelTemplate">
                    <el-button size="small" type="primary" @click="handleTemplate">
                        点击下载<i class="el-icon-download el-icon--right"></i>
                    </el-button>
                </template>
            </avue-form>
        </el-dialog>
    </basic-container>
</template>

<script>
import {
    mapGetters
} from "vuex"
import {
    getList,
    add,
    update,
    remove,
    getDetail
} from "@/api/disputeRecord/disputeRecord"
import NProgress from 'nprogress'
import 'nprogress/nprogress.css'
import Qs from "qs"
import {
    exportBlob
} from "@/api/common"
import {
    getToken
} from '@/util/auth'
import {
    downloadXls
} from "@/util/util"
import {
    dateNow
} from "@/util/date"
import website from '@/config/website'
export default {
    data() {
        let isCardId = function (rule, value, callback) {
            // 15位和18位身份证号码的正则表达式
            var regIdCard =
                /^(^[1-9]\d{7}((0\d)|(1[0-2]))(([0|1|2]\d)|3[0-1])\d{3}$)|(^[1-9]\d{5}[1-9]\d{3}((0\d)|(1[0-2]))(([0|1|2]\d)|3[0-1])((\d{4})|\d{3}[Xx])$)$/

            // 如果通过该验证，说明身份证格式正确，但准确性还需计算
            if (regIdCard.test(value) || value == '') {
                if (value.length == 18) {
                    var idCardWi = new Array(7, 9, 10, 5, 8, 4, 2, 1, 6, 3, 7, 9, 10,
                        5, 8, 4, 2) // 将前17位加权因子保存在数组里
                    var idCardY = new Array(1, 0, 10, 9, 8, 7, 6, 5, 4, 3, 2) // 这是除以11后，可能产生的11位余数、验证码，也保存成数组
                    var idCardWiSum = 0 // 用来保存前17位各自乖以加权因子后的总和
                    for (var i = 0; i < 17; i++) {
                        idCardWiSum += value.substring(i, i + 1) * idCardWi[i]
                    }

                    var idCardMod = idCardWiSum % 11 // 计算出校验码所在数组的位置
                    var idCardLast = value.substring(17) // 得到最后一位身份证号码

                    // 如果等于2，则说明校验码是10，身份证号码最后一位应该是X
                    if (idCardMod == 2) {
                        if (idCardLast == "X" || idCardLast == "x") {
                            callback()
                        } else {
                            callback(new Error("身份证号格式有误！"))
                        }
                    } else {
                        // 用计算出的验证码与最后一位身份证号码匹配，如果一致，说明通过，否则是无效的身份证号码
                        if (idCardLast == idCardY[idCardMod]) {
                            callback()
                        } else {
                            callback(new Error("身份证号格式有误！"))
                        }
                    }
                } else {
                    callback()
                }
            } else {
                //alert("身份证格式不正确!");
                callback(new Error("身份证号格式有误！"))
            }

            callback()
        }

        //手机号格式校验
        let validatorPhone = function (rule, value, callback) {
            if (value) {
                if (!/^1[3456789]\d{9}$/.test(value)) {
                    callback(new Error('手机号格式有误！'))
                } else {
                    callback()
                }
            }
            callback()
        }
        return {
            excelForm: {},
            excelBox: false,
            excelOption: {
                submitBtn: false,
                emptyBtn: false,
                column: [{
                    label: '模板上传',
                    prop: 'excelFile',
                    type: 'upload',
                    drag: true,
                    loadText: '模板上传中，请稍等',
                    span: 24,
                    propsHttp: {
                        res: 'data'
                    },
                    tip: '请上传 .xls,.xlsx 标准格式文件',
                    action: "/api/blade-disputeRecord/disputeRecord/import-disputeRecord"
                },
                // {
                //     label: "数据覆盖",
                //     prop: "isCovered",
                //     type: "switch",
                //     align: "center",
                //     width: 80,
                //     dicData: [{
                //         label: "否",
                //         value: 0
                //     },
                //     {
                //         label: "是",
                //         value: 1
                //     }
                //     ],
                //     value: 0,
                //     slot: true,
                //     rules: [{
                //         required: true,
                //         message: "请选择是否覆盖",
                //         trigger: "blur"
                //     }]
                // },
                {
                    label: '模板下载',
                    prop: 'excelTemplate',
                    formslot: true,
                    span: 24,
                }
                ]
            },
            form: {},
            query: {},
            loading: true,

            page: {
                pageSize: 10,
                currentPage: 1,
                total: 0,
            },
            datetime: "",
            selectionList: [],
            option: {
                height: "auto",
                calcHeight: 54,
                dialogWidth: 950,
                menuWidth: 210,
                tip: false,
                searchShow: true,
                searchMenuSpan: 3,
                border: true,
                index: true,
                editBtn: true,
                delBtn: true,
                addBtn: true,
                viewBtn: true,
                refreshBtn: true,
                searchShowBtn: true,
                columnBtn: true,
                dialogClickModal: false,
                column: [
                    {
                        label: "事发地址",
                        prop: "address",
                        align: 'center',
                        minWidth: 210,
                        search: true,
                        searchSpan: 5,
                        display: false,
                        overHidden: true,
                    },
                    {
                        label: "事发地址",
                        prop: "location",
                        align: 'center',
                        minWidth: 210,
                        span: 12,
                        hide: true,
                        overHidden: true,
                        labelWidth: 150,
                        // row: true,
                        type: 'map',
                        dataType: "string",
                        value: [117.966460, 28.431002, ""],
                        rules: [
                            {
                                required: true,
                                message: "请选择巡查地址",
                                trigger: "blur",
                            },
                        ],
                    }, {
                        width: 150,
                        label: "事发时间",
                        prop: "eventTime",
                        type: "datetime",
                        labelWidth: 150,
                        format: "yyyy-MM-dd HH:mm:ss",
                        valueFormat: "yyyy-MM-dd HH:mm:ss",
                        rules: [
                            {
                                required: true,
                                message: "请选择事发时间",
                                trigger: "blur",
                            },
                        ],
                    }, {
                        label: "事发时间",
                        prop: "dateTime",
                        type: "daterange",
                        format: "yyyy-MM-dd",
                        valueFormat: "yyyy-MM-dd",
                        searchSpan: 6,
                        searchRange: true,
                        hide: true,
                        addDisplay: false,
                        editDisplay: false,
                        viewDisplay: false,
                        search: true,
                        rules: [{
                            required: true,
                            message: "请选择事发时间",
                            trigger: "blur",
                        },],
                    }, {
                        label: "纠纷内容",
                        prop: "disputeContent",
                        align: 'center',
                        minWidth: 150,
                        labelWidth: 150,
                        type: "textarea",
                        row: true,
                        span: 24,
                        overHidden: true,
                        rules: [
                            {
                                required: true,
                                message: "请输入纠纷内容",
                                trigger: "blur",
                            },
                        ],
                    },
                    {
                        label: "纠纷类型",
                        prop: "disputeType",
                        align: 'center',
                        minWidth: 150,
                        labelWidth: 150,
                        search: true,
                        searchSpan: 4,
                        dataType: "number",
                        type: "select",
                        dicUrl: "/api/blade-system/dict-biz/dictionary?code=disputeType",
                        props: {
                            label: "dictValue",
                            value: "dictKey",
                        },
                        rules: [{
                            required: true,
                            message: "请选择纠纷类型",
                            trigger: "blur",
                        },],
                    },
                    {
                        label: "是否受伤",
                        prop: "injuryFlag",
                        align: 'center',
                        width: 80,
                        search: true,
                        searchSpan: 3,
                        labelWidth: 150,
                        type: "select",
                        dicData: [
                            {
                                label: "是",
                                value: 1
                            },
                            {
                                label: "否",
                                value: 0
                            }
                        ],
                        rules: [
                            {
                                required: true,
                                message: "请选择是否受伤",
                                trigger: "blur",
                            },
                        ],
                    },
                    {
                        label: "受伤情况描述",
                        prop: "injuryDesc",
                        align: 'center',
                        minWidth: 150,
                        labelWidth: 150,
                        display: false,
                        hide: true,
                        row: true,
                        span: 24,
                        overHidden: true,
                        rules: [
                            {
                                required: false,
                                message: "请输入受伤情况描述",
                                trigger: "blur",
                            },
                        ],
                    },
                    {
                        label: "报警次数",
                        prop: "alarmNum",
                        align: 'center',
                        type: "number",
                        labelWidth: 150,
                    },
                    {
                        label: "信息来源",
                        prop: "source",
                        labelWidth: 150,
                        align: 'center',
                        width: 156,
                        dataType: "number",
                        type: "select",
                        dicUrl: "/api/blade-system/dict-biz/dictionary?code=disputeSource",
                        props: {
                            label: "dictValue",
                            value: "dictKey",
                        },
                        rules: [{
                            required: true,
                            message: "请选择信息来源",
                            trigger: "blur",
                        },],
                    }, {
                        label: "纠纷人1姓名",
                        prop: "nameOne",
                        align: 'center',
                        slot: true,
                        labelWidth: 150,
                        search: true,
                        searchLabelWidth: 110,
                        searchSpan: 4,
                        width: 100,
                        rules: [
                            {
                                required: true,
                                message: "请输入纠纷人1姓名",
                                trigger: "blur",
                            },
                        ],
                    }, {
                        label: "纠纷人1电话",
                        prop: "phoneOne",
                        align: 'center',
                        slot: true,
                        labelWidth: 150,
                        search: true,
                        searchLabelWidth: 110,
                        searchSpan: 4,
                        width: 100,
                        rules: [
                            {
                                required: true,
                                message: "请输入纠纷人1电话",
                                trigger: "blur",
                            },
                            {
                                validator: validatorPhone,
                                trigger: 'blur'
                            }
                        ],
                    },
                    {
                        label: "纠纷人1身份证号",
                        prop: "idCardOne",
                        align: 'center',
                        slot: true,
                        labelWidth: 150,
                        // search: true,
                        searchLabelWidth: 150,
                        searchSpan: 5,
                        width: 150,
                        row: true,
                        rules: [
                            {
                                required: true,
                                message: "请输入纠纷人1身份证号",
                                trigger: "blur",
                            }, {
                                validator: isCardId,
                                trigger: 'blur'
                            }
                        ],
                    },
                    {
                        label: "纠纷人2姓名",
                        prop: "nameTwo",
                        align: 'center',
                        slot: true,
                        hide: true,
                        labelWidth: 150,
                        searchLabelWidth: 110,
                        searchSpan: 4,
                        width: 120,
                        rules: [
                            {
                                required: true,
                                message: "请输入纠纷人2姓名",
                                trigger: "blur",
                            },
                        ],
                    }, {
                        label: "纠纷人2电话",
                        prop: "phoneTwo",
                        align: 'center',
                        slot: true,
                        hide: true,
                        labelWidth: 150,
                        searchLabelWidth: 110,
                        searchSpan: 4,
                        width: 120,
                        rules: [
                            {
                                required: true,
                                message: "请输入纠纷人2电话",
                                trigger: "blur",
                            },
                            {
                                validator: validatorPhone,
                                trigger: 'blur'
                            }
                        ],
                    },
                    {
                        label: "纠纷人2身份证号",
                        prop: "idCardTwo",
                        align: 'center',
                        slot: true,
                        hide: true,
                        labelWidth: 150,
                        searchLabelWidth: 110,
                        searchSpan: 4,
                        width: 120,
                        rules: [
                            {
                                required: true,
                                message: "请输入纠纷人2身份证号",
                                trigger: "blur",
                            }, {
                                validator: isCardId,
                                trigger: 'blur'
                            }
                        ],
                    },
                    {
                        label: "地区",
                        prop: "townName",
                        align: 'center',
                        search: true,
                        addDisplay: false,
                        editDisplay: false,
                        searchSpan: 3,
                        searchLabelWidth: 60,
                        labelWidth: 150,
                        width: 120,
                        searchPlaceholder: '请输入地区'
                    }, {
                        label: "辖区派出所",
                        prop: "pcsName",
                        align: 'center',
                        search: true,
                        addDisplay: false,
                        editDisplay: false,
                        searchSpan: 4,
                        labelWidth: 150,
                        width: 120,
                        searchLabelWidth: 96,
                        searchPlaceholder: '请输入辖区派出所'
                    }, {
                        label: "处理结果",
                        prop: "handleResult",
                        align: 'center',
                        search: true,
                        labelWidth: 150,
                        searchSpan: 4,
                        width: 110,
                        type: "select",
                        dicData: [
                            {
                                label: "已化解",
                                value: 1
                            },
                            {
                                label: "未化解",
                                value: 2
                            },
                            {
                                label: "移送e呼即办",
                                value: 3
                            }
                        ],
                        rules: [
                            {
                                required: true,
                                message: "请选择处理结果",
                                trigger: "blur",
                            },
                        ],
                    }],
            },
            data: []
        }
    },

    computed: {
        ...mapGetters(["permission", "userInfo"]),
        permissionList() {
            return {
                addBtn: this.vaildData(this.permission.dispute_record_add, true),
                viewBtn: this.vaildData(this.permission.dispute_record_view, true),
                delBtn: this.vaildData(this.permission.dispute_record_delete, true),
                editBtn: this.vaildData(this.permission.dispute_record_edit, true),
            }
        },
        ids() {
            let ids = []
            this.selectionList.forEach((ele) => {
                ids.push(ele.id)
            })
            return ids.join(",")
        },

        textDispose() {
            return (row, flag, type) => {
                if (row[flag] || row[type] == null) {
                    return row[type]
                } else {
                    if (type == 'principalIdCard') {
                        return row[type].replace(/^(.{6})(?:\d+)(.{4})$/, "$1******$2")
                    } else {
                        return row[type].replace(/^(.{3})(?:\d+)(.{4})$/, "$1****$2")
                    }
                }
            }
        }
    },
    watch: {
        "form.injuryFlag": {
            // form是表单或者表格绑定的数据集，v-model='form'
            handler(val) {
                let injuryDescColumn = this.findObject(
                    this.option.column,
                    'injuryDesc'
                )
                if (val == 1) {
                    injuryDescColumn.rules[0].required = true
                    injuryDescColumn.display = true
                } else {
                    injuryDescColumn.rules[0].required = false
                    injuryDescColumn.display = false
                }
            },
            immediate: true,
        },
    },
    methods: {
        locationDispose(data) {
            data = data.split(',')

            return {
                lng: data[0],
                lat: data[1],
                address: data[2]
            }
        },
        handleTemplate() {
            exportBlob(`/api/blade-disputeRecord/disputeRecord/export-template?${this.website.tokenHeader}=${getToken()}`).then(res => {
                downloadXls(res.data, "矛盾纠纷事件数据模板.xlsx")
            })
        },
        handleImport() {
            this.excelBox = true
        },
        uploadAfter(res, done, loading, column) {
            this.excelBox = false
            this.refreshChange()
            done()
        },
        handleExport() {
            this.$confirm("是否导出矛盾纠纷事件数据?", "提示", {
                confirmButtonText: "确定",
                cancelButtonText: "取消",
                type: "warning"
            }).then(() => {
                NProgress.start()
                var data = {
                    ...this.query
                }
                data.isNine = 1
                data = Qs.stringify(data)
                exportBlob(
                    `/api/blade-disputeRecord/disputeRecord/export-disputeRecord?${this.website.tokenHeader}=${getToken()}&` + data
                ).then(res => {
                    console.log('exportBlob', res)
                    downloadXls(res.data, `矛盾纠纷事件${dateNow()}.xlsx`)
                    NProgress.done()
                })
            })
        },

        showStringDispose(row, type) {
            row[type] = !row[type]
        },

        rowSave(row, done, loading) {
            add({
                ...row,
                ...this.locationDispose(row.location)
            }).then(
                () => {
                    this.onLoad(this.page)
                    this.$message({
                        type: "success",
                        message: "操作成功!",
                    })
                    done()
                },
                (error) => {
                    window.console.log(error)
                    loading()
                }
            )
        },
        rowUpdate(row, index, done, loading) {
            update({
                ...row,
                ...this.locationDispose(row.location)
            }).then(
                () => {
                    this.onLoad(this.page)
                    this.$message({
                        type: "success",
                        message: "操作成功!",
                    })
                    done()
                },
                (error) => {
                    window.console.log(error)
                    loading()
                }
            )
        },
        rowDel(row) {
            this.$confirm("确定将选择数据删除?", {
                confirmButtonText: "确定",
                cancelButtonText: "取消",
                type: "warning",
            })
                .then(() => {
                    return remove(row.id)
                })
                .then(() => {
                    this.onLoad(this.page)

                    this.$message({
                        type: "success",
                        message: "操作成功!",
                    })
                })
        },

        searchReset() {
            this.query = {}
            this.onLoad(this.page)
        },

        searchChange(params, done) {
            this.query = params
            this.page.currentPage = 1
            this.onLoad(this.page, params)
            done()
        },

        selectionChange(list) {
            this.selectionList = list
        },

        selectionClear() {
            this.selectionList = []
            this.$nextTick(() => {
                this.$refs.crud && this.$refs.crud.toggleSelection()
            })
        },

        handleDelete() {
            if (this.selectionList.length === 0) {
                this.$message.warning("请选择至少一条数据")
                return
            }
            this.$confirm("确定将选择数据删除?", {
                confirmButtonText: "确定",
                cancelButtonText: "取消",
                type: "warning",
            })
                .then(() => {
                    return remove(this.ids)
                })
                .then(() => {
                    this.onLoad(this.page)
                    this.$message({
                        type: "success",
                        message: "操作成功!",
                    })
                    this.$refs.crud.toggleSelection()
                })
        },

        beforeOpen(done, type) {
            if (["edit", "view"].includes(type)) {
                getDetail(this.form.id).then(res => {
                    this.form = res.data.data
                    this.form.location = [this.form.lng, this.form.lat, this.form.address].join(',')
                })
                done()
            } else {
                done()
            }
        },
        currentChange(currentPage) {
            this.page.currentPage = currentPage
        },
        sizeChange(pageSize) {
            this.page.pageSize = pageSize
        },
        refreshChange() {
            this.onLoad(this.page, this.query)
        },
        onLoad(page, params = {}) {
            const {
                dateTime
            } = this.query
            if (dateTime) {
                params['startTime'] = dateTime[0]
                params['endTime'] = dateTime[1]
            }
            this.loading = true
            getList(page.currentPage, page.pageSize, Object.assign(params, this.query)).then(res => {
                const data = res.data.data;
                this.page.total = data.total
                this.data = data.records
                this.data.forEach(item => {
                    this.$set(item, 'phoneOneflag', false)
                    this.$set(item, 'idCardOneflag', false)
                })
                this.loading = false
                this.selectionClear()
            })
        }
    }
}
</script>

<style lang="scss" scoped>
.avue-upload__icon {
    line-height: 6;
}
</style>