From dc91db9bb3473c3ed058f86f74359e15c035a8a5 Mon Sep 17 00:00:00 2001
From: zhengpz <1838927346@qq.com>
Date: Mon, 23 Aug 2021 22:13:10 +0800
Subject: [PATCH] 表查询完善
---
src/views/statisticalQueryManagement/securityGuardStatistics.vue | 294 ++++++++++++++++++++++++++++++++--------------------------
1 files changed, 163 insertions(+), 131 deletions(-)
diff --git a/src/views/statisticalQueryManagement/securityGuardStatistics.vue b/src/views/statisticalQueryManagement/securityGuardStatistics.vue
index eab7afd..1e36ecf 100644
--- a/src/views/statisticalQueryManagement/securityGuardStatistics.vue
+++ b/src/views/statisticalQueryManagement/securityGuardStatistics.vue
@@ -2,19 +2,20 @@
<basic-container>
<avue-crud
:option="tableOption"
+ :table-loading="loading"
:data="tableData"
- :page.sync="tablePage"
+ :page.sync="page"
:permission="permissionList"
- :before-open="beforeOpen"
- @date-change="dateChange"
+ ref="crud"
+ @search-change="searchChange"
+ @search-reset="searchReset"
+ @current-change="currentChange"
+ @size-change="sizeChange"
+ @refresh-change="refreshChange"
+ @on-load="onLoad"
@row-click="handleRowClick"
class="rowClick"
>
- <template slot-scope="{ type, size }" slot="menu">
- <el-button icon="el-icon-check" :size="size" :type="type"
- >自定义菜单按钮</el-button
- >
- </template>
</avue-crud>
</basic-container>
</template>
@@ -22,55 +23,58 @@
import FileSaver from "file-saver";
import XLSX from "xlsx";
import { mapGetters } from "vuex";
+import { selectLi } from "../../api/statisticalQueryManagement/statisticalQueryManagement";
+import { lazyTreeJu } from "../../api/index/index";
export default {
name: "业务情况统计",
data() {
return {
+ page: {
+ pageSize: 10,
+ currentPage: 1,
+ total: 0
+ },
+ query: {},
value1: "",
value2: "",
tableData: [
- {
- company: "江西省永安保安服务有限公司",
- subOffice: "东湖分局",
- total: "21540",
- holder: "21520",
- nosend: "10200",
- send: "1320",
- nopicture: "314",
- qualification: "142",
- pass: "21120",
- socialSecurity: "21535",
- },
- {
- company: "南昌市赣水保安服务有限公司",
- subOffice: "东湖分局",
- total: "21540",
- holder: "21520",
- nosend: "10200",
- send: "1320",
- nopicture: "314",
- qualification: "142",
- pass: "21120",
- socialSecurity: "21535",
- },
- {
- company: "江西中业兴达保安服务有限公司",
- subOffice: "东湖分局",
- total: "21540",
- holder: "21520",
- nosend: "10200",
- send: "1320",
- nopicture: "314",
- qualification: "142",
- pass: "21120",
- socialSecurity: "21535",
- },
+ // {
+ // company: "江西省永安保安服务有限公司",
+ // subOffice: "东湖分局",
+ // total: "21540",
+ // holder: "21520",
+ // nosend: "10200",
+ // send: "1320",
+ // nopicture: "314",
+ // qualification: "142",
+ // pass: "21120",
+ // socialSecurity: "21535",
+ // },
+ // {
+ // company: "南昌市赣水保安服务有限公司",
+ // subOffice: "东湖分局",
+ // total: "21540",
+ // holder: "21520",
+ // nosend: "10200",
+ // send: "1320",
+ // nopicture: "314",
+ // qualification: "142",
+ // pass: "21120",
+ // socialSecurity: "21535",
+ // },
+ // {
+ // company: "江西中业兴达保安服务有限公司",
+ // subOffice: "东湖分局",
+ // total: "21540",
+ // holder: "21520",
+ // nosend: "10200",
+ // send: "1320",
+ // nopicture: "314",
+ // qualification: "142",
+ // pass: "21120",
+ // socialSecurity: "21535",
+ // },
],
- tablePage: {
- pageSize: 10,
- currentPage: 1,
- total: 0,
- },
tableOption: {
align: "center",
viewBtn: true,
@@ -93,97 +97,97 @@
column: [
{
label: "公司名称",
- prop: "company",
+ prop: "deptname",
search: true,
searchSpan: 4,
- display: false,
+ display: false
},
-
{
label: "所属辖区",
- prop: "subOffice",
+ prop: "jurname",
searchSpan: 4,
type: "select",
props: {
- label: "label",
- value: "value",
+ label: "title",
+ value: "value"
},
- // cascaderItem: ["city", "area"],
- // dicUrl:subofficeOptions,
+ // dicUrl: "/api/information/lazyTreeJu",
+ // dicMethod:'post',
dicData: [
- {
- value: "0",
- label: "南昌市公安局",
- },
- {
- value: "2",
- label: "东湖分局",
- },
- {
- value: "3",
- label: "西湖分局",
- },
- {
- value: "4",
- label: "青云谱分局",
- },
- {
- value: "5",
- label: "青山湖分局",
- },
+ // {
+ // value: "0",
+ // label: "南昌市公安局"
+ // },
+ // {
+ // value: "2",
+ // label: "东湖分局"
+ // },
+ // {
+ // value: "3",
+ // label: "西湖分局"
+ // },
+ // {
+ // value: "4",
+ // label: "青云谱分局"
+ // },
+ // {
+ // value: "5",
+ // label: "青山湖分局"
+ // }
],
search: true,
rules: [
{
required: true,
message: "请选择所属辖区",
- trigger: "blur",
- },
- ],
+ trigger: "blur"
+ }
+ ]
},
{
label: "保安员总数",
- prop: "total",
- display: false,
+ prop: "num",
+ display: false
},
{
label: "持证上岗人数",
- prop: "holder",
- display: false,
+ prop: "cznum",
+ display: false
},
{
label: "未派遣人数",
- prop: "nosend",
- display: false,
+ prop: "wpaiqnum",
+ display: false
},
{
label: "派遣人数",
- prop: "send",
- display: false,
+ prop: "paiqnum",
+ display: false
},
{
label: "未采集照片人数",
- prop: "nopicture",
- display: false,
+ prop: "wcaijnum",
+ display: false
},
{
label: "资格审查异常人数",
- prop: "qualification",
- display: false,
+ prop: "yicnum",
+ display: false
},
- {
- label: "过考保安人数",
- prop: "pass",
- display: false,
- },
+ // {
+ // label: "过考保安人数",
+ // prop: "pass",
+ // display: false,
+ // },
{
label: "缴纳社保人数",
- prop: "socialSecurity",
- display: false,
- },
- ],
+ prop: "sbnum",
+ display: false
+ }
+ ]
},
companyName: "",
+ loading: true
};
},
computed: {
@@ -193,43 +197,71 @@
addBtn: this.vaildData(this.permission.post_add, false),
viewBtn: this.vaildData(this.permission.post_view, false),
delBtn: this.vaildData(this.permission.post_delete, false),
- editBtn: this.vaildData(this.permission.post_edit, false),
+ editBtn: this.vaildData(this.permission.post_edit, false)
};
- },
+ }
},
methods: {
- // toCompanyDetails() {
- // this.$router.push({ path: "/statisticalQueryManagement/companyDetails" });
- // },
- handleRowClick(row, event, column) {
- this.$router.push({ path: "/statisticalQueryManagement/companyDetails" });
+ getSubOfficeData() {
+ lazyTreeJu().then(res => {
+ if (res.data.code === 200) {
+ this.tableOption.column.forEach(item => {
+ if (item.label == "所属辖区") {
+ item.dicData = res.data.data;
+ }
+ });
+ } else {
+ this.$message.error(res.msg);
+ }
+ });
},
- dateChange() {},
- // downExcel() {
- // let et = XLSX.utils.table_to_book(document.getElementById("table"));
- // let etout = XLSX.write(et, {
- // bookType: "xlsx",
- // bookSST: true,
- // type: "array"
- // });
- // try {
- // FileSaver.saveAs(
- // new Blob([etout], {
- // type: "application/octet-stream"
- // }),
- // `表.xlsx`
- // ); //导出的文件名
- // } catch (e) {
- // console.log(e, etout);
- // }
- // return etout;
- // }
+ searchChange(params, done) {
+ this.query = params;
+ this.page.currentPage = 1;
+ this.onLoad(this.page, params);
+ done();
+ },
+
+ searchReset() {
+ this.query = {};
+ this.onLoad(this.page);
+ },
+ currentChange(currentPage) {
+ this.page.currentPage = currentPage;
+ },
+ sizeChange(pageSize) {
+ this.page.pageSize = pageSize;
+ },
+ refreshChange() {
+ this.onLoad(this.page, this.query);
+ },
+ onLoad(page, params = {}) {
+ this.loading = true;
+ let param = {};
+ param["jurisdiction"] = params["jurname"] || "";
+ param["deptid"] = params["deptname"] || "";
+ param["current"] = page.currentPage;
+ param["size"] = page.pageSize;
+ selectLi(param).then(res => {
+ const data = res.data.data;
+ this.page.total = data.total;
+ this.tableData = data.records;
+ this.loading = false;
+ });
+ },
+ handleRowClick(row, event, column) {
+ this.$router.push({
+ path: "/statisticalQueryManagement/companyDetails?deptid=" + row.dept_id
+ });
+ }
},
- mounted() {},
+ mounted() {
+ this.getSubOfficeData();
+ }
};
</script>
-<style lang="scss" scoped>
-/deep/ .rowClick .el-table__row:hover td{
+<style lang="scss" scoped>
+/deep/ .rowClick .el-table__row:hover td {
cursor: pointer;
}
</style>
--
Gitblit v1.9.3