统计查询管理

zhengpz

2021-07-22 c5041ad57359cf2f627b991ee6ba059f097e672f

统计查询管理

 src/router/views/index.js

@@ -312,5 +312,33 @@
            component: () =>
                import( /* webpackChunkName: "views" */ '@/views/securityUnitOperation/economicTable')
        }]
    },
    {
        path: '/statisticalQueryManagement/companyDetails',
        redirect: '/statisticalQueryManagement/companyDetails/index',
        component: Layout,
        children: [{
            path: 'index',
            name: '保安公司人员详情',
            meta: {
                i18n: 'index',
            },
            component: () =>
                import( /* webpackChunkName: "views" */ '@/views/statisticalQueryManagement/companyDetails')
        }]
    },
    {
        path: '/securityUnitOperation/economicTable',
        redirect: '/securityUnitOperation/economicTable/index',
        component: Layout,
        children: [{
            path: 'index',
            name: '公司经济情况智能分析详情表',
            meta: {
                i18n: 'index',
            },
            component: () =>
                import( /* webpackChunkName: "views" */ '@/views/securityUnitOperation/economicTable')
        }]
    }
]

 src/views/securityUnitOperation/economicTable.vue

@@ -92,37 +92,6 @@
  name: "公司经济情况智能分析详情表",
  data() {
    return {
      pickerOptions: {
        shortcuts: [
          {
            text: "最近一周",
            onClick(picker) {
              const end = new Date();
              const start = new Date();
              start.setTime(start.getTime() - 3600 * 1000 * 24 * 7);
              picker.$emit("pick", [start, end]);
            }
          },
          {
            text: "最近一个月",
            onClick(picker) {
              const end = new Date();
              const start = new Date();
              start.setTime(start.getTime() - 3600 * 1000 * 24 * 30);
              picker.$emit("pick", [start, end]);
            }
          },
          {
            text: "最近三个月",
            onClick(picker) {
              const end = new Date();
              const start = new Date();
              start.setTime(start.getTime() - 3600 * 1000 * 24 * 90);
              picker.$emit("pick", [start, end]);
            }
          }
        ]
      },
      value1: "",
      value2: "",
      tableData: [
@@ -130,37 +99,37 @@
          company: "江西省永安保安服务有限公司",
          subOffice: "南昌市公安局",
          time: "2021-06-1",
          sbjnrs: "12200",
          sbjnze: "400",
          sbjnrs: "2100",
          sbjnze: "350",
          gspqrs: "110",
          sbjnrszb: "10",
          bz: ""
          bz: "",
        },
        {
          company: "南昌市赣水保安服务有限公司",
          subOffice: "东湖分局",
          time: "2020-05-21",
          sbjnrs: "12200",
          sbjnze: "400",
          gspqrs: "110",
          sbjnrszb: "10",
          bz: ""
          sbjnrs: "1800",
          sbjnze: "310",
          gspqrs: "160",
          sbjnrszb: "21",
          bz: "",
        },
        {
          company: "江西中业兴达保安服务有限公司",
          subOffice: "西湖分局",
          time: "2021-08-11",
          sbjnrs: "12200",
          sbjnze: "400",
          gspqrs: "110",
          sbjnrszb: "10",
          bz: ""
        }
          sbjnrs: "2300",
          sbjnze: "612",
          gspqrs: "80",
          sbjnrszb: "7",
          bz: "",
        },
      ],
      tablePage: {
        pageSize: 10,
        currentPage: 1,
        total: 0
        total: 0,
      },
      tableOption: {
        excelBtn: true,
@@ -174,6 +143,7 @@
        height: "auto",
        calcHeight: 30,
        tip: false,
        searchShowBtn: false,
        searchShow: true,
        searchMenuSpan: 6,
        index: true,
@@ -190,40 +160,47 @@
            type: "select",
            props: {
              label: "label",
              value: "value"
              value: "value",
            },
            // cascaderItem: ["city", "area"],
            // dicUrl:subofficeOptions,
            dicData: [
              {
                value: "0",
                label: "全部"
                label: "全部",
              },
              {
                value: "1",
                label: "社保缴纳人数"
                label: "社保缴纳人数",
              },
              {
                value: "2",
                label: "社保缴纳总额"
                label: "社保缴纳总额",
              },
              {
                value: "3",
                label: "公司派遣人数"
                label: "公司派遣人数",
              },
              {
                value: "4",
                label: "社保缴纳人数占比"
              }
                label: "社保缴纳人数占比",
              },
            ],
            search: true,
            rules: [
              {
                required: true,
                message: "请选择类别",
                trigger: "blur"
              }
            ]
                trigger: "blur",
              },
            ],
          },
          {
            label: "公司名称",
            prop: "company",
            search: true,
            searchSpan: 4,
            display: false,
          },
          {
            label: "所属辖区",
@@ -232,40 +209,40 @@
            type: "select",
            props: {
              label: "label",
              value: "value"
              value: "value",
            },
            // cascaderItem: ["city", "area"],
            // dicUrl:subofficeOptions,
            dicData: [
              {
                value: "0",
                label: "南昌市公安局"
                label: "南昌市公安局",
              },
              {
                value: "2",
                label: "东湖分局"
                label: "东湖分局",
              },
              {
                value: "3",
                label: "西湖分局"
                label: "西湖分局",
              },
              {
                value: "4",
                label: "青云谱分局"
                label: "青云谱分局",
              },
              {
                value: "5",
                label: "青山湖分局"
              }
                label: "青山湖分局",
              },
            ],
            search: true,
            rules: [
              {
                required: true,
                message: "请选择所属辖区",
                trigger: "blur"
              }
            ]
                trigger: "blur",
              },
            ],
          },
          {
            label: "时间",
@@ -276,90 +253,82 @@
            searchSpan: 6,
            searchRange: true,
            search: true,
            display: false
            display: false,
          },
          {
            label: "公司名称",
            prop: "company",
            search: true,
            searchSpan: 4,
            display: false
          },

          {
            label: "社保缴纳人数",
            prop: "sbjnrs",
            display: false
            display: false,
          },
          {
            label: "社保缴纳总额（万）",
            prop: "sbjnze",
            display: false
            display: false,
          },
          {
            label: "公司派遣人数",
            prop: "gspqrs",
            display: false
            display: false,
          },
          {
            label: "社保缴纳人数占比（%）",
            prop: "sbjnrszb",
            display: false
            display: false,
          },
          {
            label: "备注",
            prop: "bz",
            display: false
          }
        ]
            display: false,
          },
        ],
      },
      typeValue: "0",
      typeOptions: [
        {
          value: "0",
          label: "全部"
          label: "全部",
        },
        {
          value: "1",
          label: "社保缴纳人数"
          label: "社保缴纳人数",
        },
        {
          value: "2",
          label: "社保缴纳总额"
          label: "社保缴纳总额",
        },
        {
          value: "3",
          label: "公司派遣人数"
          label: "公司派遣人数",
        },
        {
          value: "4",
          label: "社保缴纳人数占比"
        }
          label: "社保缴纳人数占比",
        },
      ],
      subofficeValue: "0",
      subofficeOptions: [
        {
          value: "0",
          label: "南昌市公安局"
          label: "南昌市公安局",
        },
        {
          value: "2",
          label: "东湖分局"
          label: "东湖分局",
        },
        {
          value: "3",
          label: "西湖分局"
          label: "西湖分局",
        },
        {
          value: "4",
          label: "青云谱分局"
          label: "青云谱分局",
        },
        {
          value: "5",
          label: "青山湖分局"
        }
          label: "青山湖分局",
        },
      ],
      companyName: ""
      companyName: "",
    };
  },
  computed: {
@@ -369,12 +338,12 @@
        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: {
    dateChange() {}
    dateChange() {},
    // downExcel() {
    //   let et = XLSX.utils.table_to_book(document.getElementById("table"));
    //   let etout = XLSX.write(et, {
@@ -395,7 +364,7 @@
    //   return etout;
    // }
  },
  mounted() {}
  mounted() {},
};
</script>
<style lang="scss" scoped>

 src/views/securityUnitOperation/operationTable.vue

@@ -96,37 +96,6 @@
  name: "公司运营情况智能分析详情表",
  data() {
    return {
      pickerOptions: {
        shortcuts: [
          {
            text: "最近一周",
            onClick(picker) {
              const end = new Date();
              const start = new Date();
              start.setTime(start.getTime() - 3600 * 1000 * 24 * 7);
              picker.$emit("pick", [start, end]);
            }
          },
          {
            text: "最近一个月",
            onClick(picker) {
              const end = new Date();
              const start = new Date();
              start.setTime(start.getTime() - 3600 * 1000 * 24 * 30);
              picker.$emit("pick", [start, end]);
            }
          },
          {
            text: "最近三个月",
            onClick(picker) {
              const end = new Date();
              const start = new Date();
              start.setTime(start.getTime() - 3600 * 1000 * 24 * 90);
              picker.$emit("pick", [start, end]);
            }
          }
        ]
      },
      value1: "",
      value2: "",
      tableData: [
@@ -139,41 +108,41 @@
          holderSec: "1160",
          sendSec: "1000",
          passSec: "1180",
          unit: "50",
          socialSec: "1180",
          bz: ""
          unit: "52",
          socialSec: "1160",
          bz: "",
        },
        {
          company: "南昌市赣水保安服务有限公司",
          subOffice: "东湖分局",
          time: "2021-06-11",
          totalSec: "1200",
          normalSec: "1150",
          holderSec: "1160",
          sendSec: "1000",
          totalSec: "1360",
          normalSec: "1250",
          holderSec: "1258",
          sendSec: "1210",
          passSec: "1180",
          unit: "50",
          socialSec: "1180",
          bz: ""
          unit: "48",
          socialSec: "1200",
          bz: "",
        },
        {
          company: "江西中业兴达保安服务有限公司",
          subOffice: "西湖分局",
          time: "2020-01-21",
          totalSec: "1200",
          normalSec: "1150",
          holderSec: "1160",
          sendSec: "1000",
          totalSec: "1269",
          normalSec: "1250",
          holderSec: "1042",
          sendSec: "1040",
          passSec: "1180",
          unit: "50",
          socialSec: "1180",
          bz: ""
        }
          unit: "41",
          socialSec: "1025",
          bz: "",
        },
      ],
      tablePage: {
        pageSize: 10,
        currentPage: 1,
        total: 0
        total: 0,
      },
      tableOption: {
        excelBtn: true,
@@ -187,6 +156,7 @@
        height: "auto",
        calcHeight: 30,
        tip: false,
        searchShowBtn: false,
        searchShow: true,
        searchMenuSpan: 6,
        index: true,
@@ -203,52 +173,59 @@
            type: "select",
            props: {
              label: "label",
              value: "value"
              value: "value",
            },
            // cascaderItem: ["city", "area"],
            // dicUrl:subofficeOptions,
            dicData: [
              {
                value: "0",
                label: "全部"
                label: "全部",
              },
              {
                value: "1",
                label: "总保安人数"
                label: "总保安人数",
              },
              {
                value: "2",
                label: "正常保安数"
                label: "正常保安数",
              },
              {
                value: "3",
                label: "持证保安数"
                label: "持证保安数",
              },
              {
                value: "4",
                label: "保安派遣数"
                label: "保安派遣数",
              },
              {
                value: "5",
                label: "过考保安数"
                label: "过考保安数",
              },
              {
                value: "6",
                label: "服务单位数"
                label: "服务单位数",
              },
              {
                value: "7",
                label: "缴纳社保保安数"
              }
                label: "缴纳社保保安数",
              },
            ],
            search: true,
            rules: [
              {
                required: true,
                message: "请选择类别",
                trigger: "blur"
              }
            ]
                trigger: "blur",
              },
            ],
          },
          {
            label: "公司名称",
            prop: "company",
            search: true,
            searchSpan: 4,
            display: false,
          },
          {
            label: "所属辖区",
@@ -257,40 +234,40 @@
            type: "select",
            props: {
              label: "label",
              value: "value"
              value: "value",
            },
            // cascaderItem: ["city", "area"],
            // dicUrl:subofficeOptions,
            dicData: [
              {
                value: "0",
                label: "南昌市公安局"
                label: "南昌市公安局",
              },
              {
                value: "2",
                label: "东湖分局"
                label: "东湖分局",
              },
              {
                value: "3",
                label: "西湖分局"
                label: "西湖分局",
              },
              {
                value: "4",
                label: "青云谱分局"
                label: "青云谱分局",
              },
              {
                value: "5",
                label: "青山湖分局"
              }
                label: "青山湖分局",
              },
            ],
            search: true,
            rules: [
              {
                required: true,
                message: "请选择所属辖区",
                trigger: "blur"
              }
            ]
                trigger: "blur",
              },
            ],
          },
          {
            label: "时间",
@@ -301,61 +278,54 @@
            searchSpan: 6,
            searchRange: true,
            search: true,
            display: false
          },
          {
            label: "公司名称",
            prop: "company",
            search: true,
            searchSpan: 4,
            display: false
            display: false,
          },

          {
            label: "总保安人数",
            prop: "totalSec",
            display: false
            display: false,
          },
          {
            label: "正常保安数",
            prop: "normalSec",
            display: false
            display: false,
          },
          {
            label: "持证保安数",
            prop: "holderSec",
            display: false
            display: false,
          },
          {
            label: "保安派遣数",
            prop: "sendSec",
            display: false
            display: false,
          },
          {
            label: "过考保安数",
            prop: "passSec",
            display: false
            display: false,
          },
          {
            label: "服务单位数",
            prop: "unit",
            display: false
            display: false,
          },
          {
            label: "缴纳社保保安数",
            prop: "socialSec",
            display: false
            display: false,
          },
          {
            label: "备注",
            prop: "bz",
            display: false
          }
        ]
            display: false,
          },
        ],
      },
      typeValue: "0",
      subofficeValue: "0",
      companyName: ""
      companyName: "",
    };
  },
  methods: {
@@ -364,12 +334,12 @@
      let etout = XLSX.write(et, {
        bookType: "xlsx",
        bookSST: true,
        type: "array"
        type: "array",
      });
      try {
        FileSaver.saveAs(
          new Blob([etout], {
            type: "application/octet-stream"
            type: "application/octet-stream",
          }),
          `表.xlsx`
        ); //导出的文件名
@@ -377,9 +347,9 @@
        console.log(e, etout);
      }
      return etout;
    }
    },
  },
  mounted() {}
  mounted() {},
};
</script>
<style lang="scss" scoped>

 src/views/statisticalQueryManagement/businessStatistics.vue

New file
@@ -0,0 +1,169 @@
<template>
  <basic-container>
    <avue-crud
      :option="tableOption"
      :data="tableData"
      :page.sync="tablePage"
      :permission="permissionList"
      :before-open="beforeOpen"
      @date-change="dateChange"
    >
    </avue-crud>
  </basic-container>
</template>
<script>
import FileSaver from "file-saver";
import XLSX from "xlsx";
import { mapGetters } from "vuex";
export default {
  name: "业务情况统计",
  data() {
    return {
      value1: "",
      value2: "",
      tableData: [
        {
          company: "江西省永安保安服务有限公司",
          subOffice: "南昌市公安局",
          customer: "76",
          num: "1124",
        },
        {
          company: "南昌市赣水保安服务有限公司",
          subOffice: "东湖分局",
          customer: "85",
          num: "1428",
        },
        {
          company: "江西中业兴达保安服务有限公司",
          subOffice: "西湖分局",
          customer: "46",
          num: "974",
        },
      ],
      tablePage: {
        pageSize: 10,
        currentPage: 1,
        total: 0,
      },
      tableOption: {
        excelBtn: true,
        delBtn: false,
        editBtn: false,
        addBtn: false,
        selection: false,
        menu: false,
        // dateBtn: true,
        align: "center",
        height: "auto",
        calcHeight: 30,
        tip: false,
        searchShowBtn: false,
        searchShow: true,
        searchMenuSpan: 6,
        index: true,
        viewBtn: true,
        dialogClickModal: false,
        column: [
          {
            label: "公司名称",
            prop: "company",
            search: true,
            searchSpan: 4,
            display: false,
          },

          {
            label: "所属辖区",
            prop: "subOffice",
            searchSpan: 4,
            type: "select",
            props: {
              label: "label",
              value: "value",
            },
            // cascaderItem: ["city", "area"],
            // dicUrl:subofficeOptions,
            dicData: [
              {
                value: "0",
                label: "南昌市公安局",
              },
              {
                value: "2",
                label: "东湖分局",
              },
              {
                value: "3",
                label: "西湖分局",
              },
              {
                value: "4",
                label: "青云谱分局",
              },
              {
                value: "5",
                label: "青山湖分局",
              },
            ],
            search: true,
            rules: [
              {
                required: true,
                message: "请选择所属辖区",
                trigger: "blur",
              },
            ],
          },
          {
            label: "服务对象数量",
            prop: "customer",
            display: false,
          },
          {
            label: "保安员人数",
            prop: "num",
            display: false,
          },
        ],
      },
    };
  },
  computed: {
    ...mapGetters(["permission"]),
    permissionList() {
      return {
        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),
      };
    },
  },
  methods: {
    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;
    // }
  },
  mounted() {},
};
</script>
<style lang="scss" scoped>
</style>

 src/views/statisticalQueryManagement/businessStatisticsDetail.vue

New file
@@ -0,0 +1,253 @@
<template>
  <basic-container>
    <avue-crud
      :option="tableOption"
      :data="tableData"
      :page.sync="tablePage"
      :permission="permissionList"
      :before-open="beforeOpen"
      @date-change="dateChange"
    >
    </avue-crud>
  </basic-container>
</template>
<script>
import FileSaver from "file-saver";
import XLSX from "xlsx";
import { mapGetters } from "vuex";
export default {
  name: "业务情况统计",
  data() {
    return {
      value1: "",
      value2: "",
      tableData: [
        {
          company: "江西省永安保安服务有限公司",
          subOffice: "南昌市公安局",
          customerName: "南昌市幼儿园",
          num: "7",
          status: "正在服务",
        },
        {
          company: "南昌市赣水保安服务有限公司",
          subOffice: "东湖分局",
          customerName: "南昌市第一人民医院",
          num: "32",
          status: "已完成",
        },
        {
          company: "江西中业兴达保安服务有限公司",
          subOffice: "西湖分局",
          customerName: "南昌市动物园",
          num: "12",
          status: "未下单",
        },
      ],
      tablePage: {
        pageSize: 10,
        currentPage: 1,
        total: 0,
      },
      tableOption: {
        excelBtn: true,
        delBtn: false,
        editBtn: false,
        addBtn: false,
        selection: false,
        menu: false,
        // dateBtn: true,
        align: "center",
        height: "auto",
        calcHeight: 30,
        tip: false,
        searchShowBtn: false,
        searchShow: true,
        searchMenuSpan: 6,
        index: true,
        viewBtn: true,
        dialogClickModal: false,
        column: [
          {
            label: "公司名称",
            prop: "company",
            search: true,
            searchSpan: 4,
            display: false,
          },

          {
            label: "所属辖区",
            prop: "subOffice",
            searchSpan: 4,
            type: "select",
            props: {
              label: "label",
              value: "value",
            },
            // cascaderItem: ["city", "area"],
            // dicUrl:subofficeOptions,
            dicData: [
              {
                value: "0",
                label: "南昌市公安局",
              },
              {
                value: "2",
                label: "东湖分局",
              },
              {
                value: "3",
                label: "西湖分局",
              },
              {
                value: "4",
                label: "青云谱分局",
              },
              {
                value: "5",
                label: "青山湖分局",
              },
            ],
            search: true,
            rules: [
              {
                required: true,
                message: "请选择所属辖区",
                trigger: "blur",
              },
            ],
          },
          {
            label: "服务单位名称",
            prop: "customerName",
            display: false,
          },
          {
            label: "保安人数",
            prop: "num",
            display: false,
          },
          {
            label: "服务状态",
            prop: "status",
            searchSpan: 4,
            type: "select",
            props: {
              label: "label",
              value: "value",
            },
            // cascaderItem: ["city", "area"],
            // dicUrl:subofficeOptions,
            dicData: [
              {
                value: "0",
                label: "已完成",
              },
              {
                value: "2",
                label: "正在服务",
              },
              {
                value: "3",
                label: "未下单",
              },
            ],
            search: true,
            rules: [
              {
                required: true,
                message: "请选择服务状态",
                trigger: "blur",
              },
            ],
          },
        ],
      },
      typeValue: "0",
      typeOptions: [
        {
          value: "0",
          label: "全部",
        },
        {
          value: "1",
          label: "社保缴纳人数",
        },
        {
          value: "2",
          label: "社保缴纳总额",
        },
        {
          value: "3",
          label: "公司派遣人数",
        },
        {
          value: "4",
          label: "社保缴纳人数占比",
        },
      ],
      subofficeValue: "0",
      subofficeOptions: [
        {
          value: "0",
          label: "南昌市公安局",
        },
        {
          value: "2",
          label: "东湖分局",
        },
        {
          value: "3",
          label: "西湖分局",
        },
        {
          value: "4",
          label: "青云谱分局",
        },
        {
          value: "5",
          label: "青山湖分局",
        },
      ],
      companyName: "",
    };
  },
  computed: {
    ...mapGetters(["permission"]),
    permissionList() {
      return {
        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),
      };
    },
  },
  methods: {
    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;
    // }
  },
  mounted() {},
};
</script>
<style lang="scss" scoped>
</style>

 src/views/statisticalQueryManagement/companyDetails.vue

New file
@@ -0,0 +1,331 @@
<template>
  <basic-container>
    <avue-crud
      :option="tableOption"
      :data="tableData"
      :page.sync="tablePage"
      :permission="permissionList"
      :before-open="beforeOpen"
      @date-change="dateChange"
    >
    </avue-crud>
  </basic-container>
</template>
<script>
import FileSaver from "file-saver";
import XLSX from "xlsx";
import { mapGetters } from "vuex";
export default {
  name: "公司人员详情",
  data() {
    return {
      value1: "",
      value2: "",
      tableData: [
        {
          name: "张强",
          No: "NO.2143",
          idNumber: "230229187623601221",
          tel: "13728198762",
          holder: "是",
          socialSecurity: "是",
          picture: "是",
          qualification: "通过",
          pass: "是",
          send: "是",
        },
        {
          name: "张强",
          No: "NO.2143",
          idNumber: "230229187623601221",
          tel: "13728198762",
          holder: "是",
          socialSecurity: "是",
          picture: "是",
          qualification: "通过",
          pass: "是",
          send: "是",
        },
        {
          name: "张强",
          No: "NO.2143",
          idNumber: "230229187623601221",
          tel: "13728198762",
          holder: "是",
          socialSecurity: "是",
          picture: "是",
          qualification: "通过",
          pass: "是",
          send: "是",
        },
      ],
      tablePage: {
        pageSize: 10,
        currentPage: 1,
        total: 0,
      },
      tableOption: {
        excelBtn: true,
        delBtn: false,
        editBtn: false,
        addBtn: false,
        selection: false,
        menu: false,
        // dateBtn: true,
        align: "center",
        height: "auto",
        calcHeight: 90,
        tip: false,
        searchShowBtn: false,
        searchShow: true,
        searchMenuSpan: 6,
        index: true,
        viewBtn: true,
        dialogClickModal: false,
        column: [
          {
            label: "保安员姓名",
            searchLabelWidth: 110,
            prop: "name",
            search: true,
            searchSpan: 4,
            display: false,
          },

          {
            label: "保安员编号",
            prop: "No",
            display: false,
          },
          {
            label: "身份证号",
            prop: "idNumber",
            display: false,
          },
          {
            label: "联系电话",
            prop: "tel",
            display: false,
          },
          {
            label: "是否持证",
            prop: "holder",
            searchSpan: 4,
            type: "select",
            props: {
              label: "label",
              value: "value",
            },
            // cascaderItem: ["city", "area"],
            // dicUrl:subofficeOptions,
            dicData: [
              {
                value: "0",
                label: "是",
              },
              {
                value: "2",
                label: "否",
              },
            ],
            search: true,
            rules: [
              {
                required: true,
                message: "请选择是否持证",
                trigger: "blur",
              },
            ],
          },
          {
            label: "是否缴纳社保",
            //  labelWidth: 120,
            searchLabelWidth: 110,
            prop: "socialSecurity",
            searchSpan: 4,
            type: "select",
            props: {
              label: "label",
              value: "value",
            },
            dicData: [
              {
                value: "0",
                label: "是",
              },
              {
                value: "2",
                label: "否",
              },
            ],
            search: true,
            rules: [
              {
                required: true,
                message: "请选择是否缴纳社保",
                trigger: "blur",
              },
            ],
          },

          {
            label: "是否已采集照片",
            searchLabelWidth: 120,
            prop: "picture",
            searchSpan: 4,
            type: "select",
            props: {
              label: "label",
              value: "value",
            },
            dicData: [
              {
                value: "0",
                label: "是",
              },
              {
                value: "2",
                label: "否",
              },
            ],
            search: true,
            rules: [
              {
                required: true,
                message: "请选择是否已采集照片",
                trigger: "blur",
              },
            ],
          },
          {
            label: "资格审查情况",
            searchLabelWidth: 110,
            prop: "qualification",
            searchSpan: 4,
            type: "select",
            props: {
              label: "label",
              value: "value",
            },
            dicData: [
              {
                value: "0",
                label: "通过",
              },
              {
                value: "2",
                label: "异常",
              },
            ],
            search: true,
            rules: [
              {
                required: true,
                message: "请选择资格审查情况",
                trigger: "blur",
              },
            ],
          },
          {
            label: "是否通过考试",
            searchLabelWidth: 110,
            prop: "pass",
            searchSpan: 4,
            type: "select",
            props: {
              label: "label",
              value: "value",
            },
            dicData: [
              {
                value: "0",
                label: "是",
              },
              {
                value: "2",
                label: "否",
              },
            ],
            search: true,
            rules: [
              {
                required: true,
                message: "请选择是否通过考试",
                trigger: "blur",
              },
            ],
          },
          {
            label: "是否派遣",
            prop: "send",
            searchSpan: 4,
            type: "select",
            props: {
              label: "label",
              value: "value",
            },
            dicData: [
              {
                value: "0",
                label: "是",
              },
              {
                value: "2",
                label: "否",
              },
            ],
            search: true,
            rules: [
              {
                required: true,
                message: "请选择是否派遣",
                trigger: "blur",
              },
            ],
          },
        ],
      },
      companyName: "",
    };
  },
  computed: {
    ...mapGetters(["permission"]),
    permissionList() {
      return {
        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),
      };
    },
  },
  methods: {
    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;
    // }
  },
  mounted() {},
};
</script>
<style lang="scss" scoped>
/deep/ .avue-crud__menu {
  height: 130px !important;
}
</style>

 src/views/statisticalQueryManagement/securityGuardStatistics.vue

New file
@@ -0,0 +1,231 @@
<template>
  <basic-container>
    <avue-crud
      :option="tableOption"
      :data="tableData"
      :page.sync="tablePage"
      :permission="permissionList"
      :before-open="beforeOpen"
      @date-change="dateChange"
      @row-click="handleRowClick"
    >
      <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>
<script>
import FileSaver from "file-saver";
import XLSX from "xlsx";
import { mapGetters } from "vuex";
export default {
  name: "业务情况统计",
  data() {
    return {
      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",
        },
      ],
      tablePage: {
        pageSize: 10,
        currentPage: 1,
        total: 0,
      },
      tableOption: {
        align: "center",
        viewBtn: true,
        excelBtn: true,
        delBtn: false,
        editBtn: false,
        addBtn: false,
        selection: false,
        menu: false,
        // dateBtn: true,
        height: "auto",
        menuWidth: 380,
        calcHeight: 30,
        tip: false,
        searchShowBtn: false,
        searchShow: true,
        searchMenuSpan: 6,
        index: true,
        dialogClickModal: false,
        column: [
          {
            label: "公司名称",
            prop: "company",
            search: true,
            searchSpan: 4,
            display: false,
          },

          {
            label: "所属辖区",
            prop: "subOffice",
            searchSpan: 4,
            type: "select",
            props: {
              label: "label",
              value: "value",
            },
            // cascaderItem: ["city", "area"],
            // dicUrl:subofficeOptions,
            dicData: [
              {
                value: "0",
                label: "南昌市公安局",
              },
              {
                value: "2",
                label: "东湖分局",
              },
              {
                value: "3",
                label: "西湖分局",
              },
              {
                value: "4",
                label: "青云谱分局",
              },
              {
                value: "5",
                label: "青山湖分局",
              },
            ],
            search: true,
            rules: [
              {
                required: true,
                message: "请选择所属辖区",
                trigger: "blur",
              },
            ],
          },
          {
            label: "保安员总数",
            prop: "total",
            display: false,
          },
          {
            label: "持证上岗人数",
            prop: "holder",
            display: false,
          },
          {
            label: "未派遣人数",
            prop: "nosend",
            display: false,
          },
          {
            label: "派遣人数",
            prop: "send",
            display: false,
          },
          {
            label: "未采集照片人数",
            prop: "nopicture",
            display: false,
          },
          {
            label: "资格审查异常人数",
            prop: "qualification",
            display: false,
          },
          {
            label: "过考保安人数",
            prop: "pass",
            display: false,
          },
          {
            label: "缴纳社保人数",
            prop: "socialSecurity",
            display: false,
          },
        ],
      },
      companyName: "",
    };
  },
  computed: {
    ...mapGetters(["permission"]),
    permissionList() {
      return {
        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),
      };
    },
  },
  methods: {
    toCompanyDetails() {
      this.$router.push({ path: "/statisticalQueryManagement/companyDetails" });
    },
    handleRowClick(row, event, column) {
      this.$router.push({ path: "/statisticalQueryManagement/companyDetails" });
    },
    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;
    // }
  },
  mounted() {},
};
</script>
<style lang="scss" scoped>
</style>