1 files modified
1 files added
| | |
| | | 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') |
| | | }] |
| | | } |
| | | ] |
| New file |
| | |
| | | <template> |
| | | <basic-container> |
| | | <avue-crud |
| | | :option="tableOption" |
| | | :data="tableData" |
| | | :page.sync="tablePage" |
| | | :permission="permissionList" |
| | | :before-open="beforeOpen" |
| | | @date-change="dateChange" |
| | | > |
| | | </avue-crud> |
| | | </basic-container> |
| | | <!-- <div class="operation-table"> |
| | | <el-row> |
| | | <el-col> |
| | | <span>时间范围:</span> |
| | | <el-date-picker |
| | | v-model="value2" |
| | | type="daterange" |
| | | align="right" |
| | | unlink-panels |
| | | range-separator="至" |
| | | start-placeholder="开始日期" |
| | | end-placeholder="结束日期" |
| | | :picker-options="pickerOptions" |
| | | > |
| | | </el-date-picker> |
| | | <span>类别:</span> |
| | | <el-select v-model="typeValue" placeholder="请选择"> |
| | | <el-option |
| | | v-for="item in typeOptions" |
| | | :key="item.value" |
| | | :label="item.label" |
| | | :value="item.value" |
| | | > |
| | | </el-option> |
| | | </el-select> |
| | | <span>所属辖区:</span> |
| | | <el-select v-model="subofficeValue" placeholder="请选择"> |
| | | <el-option |
| | | v-for="item in subofficeOptions" |
| | | :key="item.value" |
| | | :label="item.label" |
| | | :value="item.value" |
| | | > |
| | | </el-option> |
| | | </el-select> |
| | | <span>公司名称:</span> |
| | | <el-input v-model="companyName"></el-input> |
| | | <el-button>查询</el-button> |
| | | <el-button>重置</el-button> |
| | | </el-col> |
| | | </el-row> |
| | | <el-row> |
| | | <el-col> |
| | | <div class="table"> |
| | | <el-button @click="downExcel">下载</el-button> |
| | | <el-table id="table" :data="tableData" style="width: 100%"> |
| | | <el-table-column type="index" label="序号" width="50"> |
| | | </el-table-column> |
| | | <el-table-column prop="company" label="公司名称" width="180"> |
| | | </el-table-column> |
| | | <el-table-column prop="subOffice" label="所属分局" width="180"> |
| | | </el-table-column> |
| | | <el-table-column prop="time" label="时间"> </el-table-column> |
| | | <el-table-column prop="totalSec" label="总保安人数"> |
| | | </el-table-column> |
| | | <el-table-column prop="normalSec" label="正常保安数"> |
| | | </el-table-column> |
| | | <el-table-column prop="holderSec" label="持证保安数"> |
| | | </el-table-column> |
| | | <el-table-column prop="sendSec" label="保安派遣数"> |
| | | </el-table-column> |
| | | <el-table-column prop="passSec" label="过考保安数"> |
| | | </el-table-column> |
| | | <el-table-column prop="unit" label="服务单位数"> </el-table-column> |
| | | <el-table-column prop="socialSec" label="缴纳社保保安数"> |
| | | </el-table-column> |
| | | <el-table-column prop="bz" label="备注"> </el-table-column> |
| | | </el-table> |
| | | <el-pagination |
| | | background |
| | | layout="prev, pager, next" |
| | | :total="tableData.length" |
| | | > |
| | | </el-pagination> |
| | | </div> |
| | | </el-col> |
| | | </el-row> |
| | | </div> --> |
| | | </template> |
| | | <script> |
| | | import FileSaver from "file-saver"; |
| | | import XLSX from "xlsx"; |
| | | export default { |
| | | name: "公司运营情况智能分析详情表", |
| | | data() { |
| | | return { |
| | | value1: "", |
| | | value2: "", |
| | | tableData: [ |
| | | { |
| | | company: "江西省永安保安服务有限公司", |
| | | subOffice: "南昌市公安局", |
| | | time: "2020-07-21", |
| | | totalSec: "1200", |
| | | normalSec: "1150", |
| | | holderSec: "1160", |
| | | sendSec: "1000", |
| | | passSec: "1180", |
| | | unit: "52", |
| | | socialSec: "1160", |
| | | bz: "", |
| | | }, |
| | | { |
| | | company: "南昌市赣水保安服务有限公司", |
| | | subOffice: "东湖分局", |
| | | time: "2021-06-11", |
| | | totalSec: "1360", |
| | | normalSec: "1250", |
| | | holderSec: "1258", |
| | | sendSec: "1210", |
| | | passSec: "1180", |
| | | unit: "48", |
| | | socialSec: "1200", |
| | | bz: "", |
| | | }, |
| | | { |
| | | company: "江西中业兴达保安服务有限公司", |
| | | subOffice: "西湖分局", |
| | | time: "2020-01-21", |
| | | totalSec: "1269", |
| | | normalSec: "1250", |
| | | holderSec: "1042", |
| | | sendSec: "1040", |
| | | passSec: "1180", |
| | | unit: "41", |
| | | socialSec: "1025", |
| | | bz: "", |
| | | }, |
| | | ], |
| | | 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: "类别", |
| | | hide: true, |
| | | prop: "", |
| | | search: true, |
| | | searchSpan: 4, |
| | | display: true, |
| | | type: "select", |
| | | props: { |
| | | label: "label", |
| | | value: "value", |
| | | }, |
| | | // cascaderItem: ["city", "area"], |
| | | // dicUrl:subofficeOptions, |
| | | dicData: [ |
| | | { |
| | | value: "0", |
| | | label: "全部", |
| | | }, |
| | | { |
| | | value: "1", |
| | | label: "总保安人数", |
| | | }, |
| | | { |
| | | value: "2", |
| | | label: "正常保安数", |
| | | }, |
| | | { |
| | | value: "3", |
| | | label: "持证保安数", |
| | | }, |
| | | { |
| | | value: "4", |
| | | label: "保安派遣数", |
| | | }, |
| | | { |
| | | value: "5", |
| | | label: "过考保安数", |
| | | }, |
| | | { |
| | | value: "6", |
| | | label: "服务单位数", |
| | | }, |
| | | { |
| | | value: "7", |
| | | label: "缴纳社保保安数", |
| | | }, |
| | | ], |
| | | search: true, |
| | | rules: [ |
| | | { |
| | | required: true, |
| | | message: "请选择类别", |
| | | trigger: "blur", |
| | | }, |
| | | ], |
| | | }, |
| | | { |
| | | 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: "time", |
| | | type: "date", |
| | | format: "yyyy-MM-dd hh:mm:ss", |
| | | valueFormat: "yyyy-MM-dd hh:mm:ss", |
| | | searchSpan: 6, |
| | | searchRange: true, |
| | | search: true, |
| | | display: false, |
| | | }, |
| | | |
| | | { |
| | | label: "总保安人数", |
| | | prop: "totalSec", |
| | | display: false, |
| | | }, |
| | | { |
| | | label: "正常保安数", |
| | | prop: "normalSec", |
| | | display: false, |
| | | }, |
| | | { |
| | | label: "持证保安数", |
| | | prop: "holderSec", |
| | | display: false, |
| | | }, |
| | | { |
| | | label: "保安派遣数", |
| | | prop: "sendSec", |
| | | display: false, |
| | | }, |
| | | { |
| | | label: "过考保安数", |
| | | prop: "passSec", |
| | | display: false, |
| | | }, |
| | | { |
| | | label: "服务单位数", |
| | | prop: "unit", |
| | | display: false, |
| | | }, |
| | | { |
| | | label: "缴纳社保保安数", |
| | | prop: "socialSec", |
| | | display: false, |
| | | }, |
| | | { |
| | | label: "备注", |
| | | prop: "bz", |
| | | display: false, |
| | | }, |
| | | ], |
| | | }, |
| | | typeValue: "0", |
| | | subofficeValue: "0", |
| | | companyName: "", |
| | | }; |
| | | }, |
| | | methods: { |
| | | 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> |
| | | .operation-table { |
| | | height: 100%; |
| | | width: 100%; |
| | | .el-row:first-child { |
| | | height: 100px; |
| | | margin-bottom: 20px; |
| | | background: rgba(255, 255, 255, 0.1); |
| | | box-shadow: 0px 0px 1px #fff; |
| | | .el-col { |
| | | padding: 20px; |
| | | .el-date-editor { |
| | | margin-right: 20px; |
| | | } |
| | | .el-select { |
| | | width: 115px; |
| | | margin-right: 20px; |
| | | } |
| | | .el-input { |
| | | width: 115px; |
| | | margin-right: 20px; |
| | | } |
| | | .el-button { |
| | | width: 70px !important; |
| | | } |
| | | } |
| | | } |
| | | .el-row:nth-child(2) { |
| | | height: calc(100% - 120px); |
| | | background: rgba(255, 255, 255, 0.1); |
| | | box-shadow: 0px 0px 1px #fff; |
| | | } |
| | | .el-col { |
| | | height: 100%; |
| | | span { |
| | | color: #fff; |
| | | } |
| | | } |
| | | } |
| | | .table { |
| | | padding: 20px; |
| | | height: calc(100% - 40px); |
| | | width: calc(100% - 40px); |
| | | .el-button { |
| | | width: 55px; |
| | | height: 30px; |
| | | padding: 0px; |
| | | margin-left: calc(100% - 55px); |
| | | } |
| | | } |
| | | /deep/ .el-table { |
| | | width: 100%; |
| | | height: calc(100% - 100px); |
| | | margin: 10px 0px; |
| | | .cell { |
| | | color: #fff; |
| | | text-align: center; |
| | | } |
| | | } |
| | | .el-pagination { |
| | | height: 40px; |
| | | float: right; |
| | | } |
| | | </style> |