统计查询管理

zhengpz

2021-07-22 c5041ad57359cf2f627b991ee6ba059f097e672f

 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>