diff --git a/src/api/batch.js b/src/api/batch.js
new file mode 100644
index 0000000..2bb662c
--- /dev/null
+++ b/src/api/batch.js
@@ -0,0 +1,114 @@
+import request from '@/utils/request'
+
+export function visitorPersonExport(params) {
+  return request({
+    url: '/visitorPerson/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function alarmExport(params) {
+  return request({
+    url: '/alarm/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function deviceExport(params) {
+  return request({
+    url: '/device/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function personListExport(params) {
+  return request({
+    url: '/statistics/personListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+export function carExport(params) {
+  return request({
+    url: '/car/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+export function carListExport(params) {
+  return request({
+    url: '/statistics/carListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function personDurationListExport(params) {
+  return request({
+    url: '/statistics/personDurationListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function carDurationListExport(params) {
+  return request({
+    url: '/statistics/carDurationListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function staffExport(params) {
+  return request({
+    url: '/staff/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function visitorCarExport(params) {
+  return request({
+    url: '/visitorCar/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function batchImportStaff(fileobj) {
+  const param = new FormData()
+  param.append('fs', fileobj)
+  return request({
+    url: '/staff/imp',
+    method: 'post',
+    headers: { 'Content-Type': 'multipart/form-data' },
+    data: param
+  })
+}

diff --git a/src/api/batch.js b/src/api/batch.js
new file mode 100644
index 0000000..2bb662c
--- /dev/null
+++ b/src/api/batch.js
@@ -0,0 +1,114 @@
+import request from '@/utils/request'
+
+export function visitorPersonExport(params) {
+  return request({
+    url: '/visitorPerson/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function alarmExport(params) {
+  return request({
+    url: '/alarm/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function deviceExport(params) {
+  return request({
+    url: '/device/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function personListExport(params) {
+  return request({
+    url: '/statistics/personListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+export function carExport(params) {
+  return request({
+    url: '/car/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+export function carListExport(params) {
+  return request({
+    url: '/statistics/carListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function personDurationListExport(params) {
+  return request({
+    url: '/statistics/personDurationListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function carDurationListExport(params) {
+  return request({
+    url: '/statistics/carDurationListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function staffExport(params) {
+  return request({
+    url: '/staff/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function visitorCarExport(params) {
+  return request({
+    url: '/visitorCar/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function batchImportStaff(fileobj) {
+  const param = new FormData()
+  param.append('fs', fileobj)
+  return request({
+    url: '/staff/imp',
+    method: 'post',
+    headers: { 'Content-Type': 'multipart/form-data' },
+    data: param
+  })
+}
diff --git a/src/components/DownloadTemplate/index.vue b/src/components/DownloadTemplate/index.vue
index 8ded2cd..5e5020f 100644
--- a/src/components/DownloadTemplate/index.vue
+++ b/src/components/DownloadTemplate/index.vue
@@ -15,8 +15,10 @@
   methods: {
     // 下载模板
     downloadTemplate() {
+      console.log('###############################')
       if (this.filename !== '') {
         const filename = this.filename
+        console.log(filename)
         // 全屏加载动画
         const loading = this.$loading({
           lock: true,

diff --git a/src/api/batch.js b/src/api/batch.js
new file mode 100644
index 0000000..2bb662c
--- /dev/null
+++ b/src/api/batch.js
@@ -0,0 +1,114 @@
+import request from '@/utils/request'
+
+export function visitorPersonExport(params) {
+  return request({
+    url: '/visitorPerson/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function alarmExport(params) {
+  return request({
+    url: '/alarm/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function deviceExport(params) {
+  return request({
+    url: '/device/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function personListExport(params) {
+  return request({
+    url: '/statistics/personListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+export function carExport(params) {
+  return request({
+    url: '/car/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+export function carListExport(params) {
+  return request({
+    url: '/statistics/carListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function personDurationListExport(params) {
+  return request({
+    url: '/statistics/personDurationListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function carDurationListExport(params) {
+  return request({
+    url: '/statistics/carDurationListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function staffExport(params) {
+  return request({
+    url: '/staff/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function visitorCarExport(params) {
+  return request({
+    url: '/visitorCar/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function batchImportStaff(fileobj) {
+  const param = new FormData()
+  param.append('fs', fileobj)
+  return request({
+    url: '/staff/imp',
+    method: 'post',
+    headers: { 'Content-Type': 'multipart/form-data' },
+    data: param
+  })
+}
diff --git a/src/components/DownloadTemplate/index.vue b/src/components/DownloadTemplate/index.vue
index 8ded2cd..5e5020f 100644
--- a/src/components/DownloadTemplate/index.vue
+++ b/src/components/DownloadTemplate/index.vue
@@ -15,8 +15,10 @@
   methods: {
     // 下载模板
     downloadTemplate() {
+      console.log('###############################')
       if (this.filename !== '') {
         const filename = this.filename
+        console.log(filename)
         // 全屏加载动画
         const loading = this.$loading({
           lock: true,
diff --git a/src/router/modules/doorSys.js b/src/router/modules/doorSys.js
index 04bfaf4..8017e4b 100644
--- a/src/router/modules/doorSys.js
+++ b/src/router/modules/doorSys.js
@@ -1,3 +1,5 @@
+
+
 /* Layout */
 import Layout from '../../views/layout/Layout'
 import OverviewLayout from '../../views/layout/OverviewLayout'

diff --git a/src/api/batch.js b/src/api/batch.js
new file mode 100644
index 0000000..2bb662c
--- /dev/null
+++ b/src/api/batch.js
@@ -0,0 +1,114 @@
+import request from '@/utils/request'
+
+export function visitorPersonExport(params) {
+  return request({
+    url: '/visitorPerson/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function alarmExport(params) {
+  return request({
+    url: '/alarm/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function deviceExport(params) {
+  return request({
+    url: '/device/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function personListExport(params) {
+  return request({
+    url: '/statistics/personListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+export function carExport(params) {
+  return request({
+    url: '/car/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+export function carListExport(params) {
+  return request({
+    url: '/statistics/carListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function personDurationListExport(params) {
+  return request({
+    url: '/statistics/personDurationListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function carDurationListExport(params) {
+  return request({
+    url: '/statistics/carDurationListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function staffExport(params) {
+  return request({
+    url: '/staff/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function visitorCarExport(params) {
+  return request({
+    url: '/visitorCar/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function batchImportStaff(fileobj) {
+  const param = new FormData()
+  param.append('fs', fileobj)
+  return request({
+    url: '/staff/imp',
+    method: 'post',
+    headers: { 'Content-Type': 'multipart/form-data' },
+    data: param
+  })
+}
diff --git a/src/components/DownloadTemplate/index.vue b/src/components/DownloadTemplate/index.vue
index 8ded2cd..5e5020f 100644
--- a/src/components/DownloadTemplate/index.vue
+++ b/src/components/DownloadTemplate/index.vue
@@ -15,8 +15,10 @@
   methods: {
     // 下载模板
     downloadTemplate() {
+      console.log('###############################')
       if (this.filename !== '') {
         const filename = this.filename
+        console.log(filename)
         // 全屏加载动画
         const loading = this.$loading({
           lock: true,
diff --git a/src/router/modules/doorSys.js b/src/router/modules/doorSys.js
index 04bfaf4..8017e4b 100644
--- a/src/router/modules/doorSys.js
+++ b/src/router/modules/doorSys.js
@@ -1,3 +1,5 @@
+
+
 /* Layout */
 import Layout from '../../views/layout/Layout'
 import OverviewLayout from '../../views/layout/OverviewLayout'
diff --git a/src/views/alarm/alarmList.vue b/src/views/alarm/alarmList.vue
index cdd1454..704f797 100644
--- a/src/views/alarm/alarmList.vue
+++ b/src/views/alarm/alarmList.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -92,6 +92,7 @@
 </template>
 
 <script>
+import { alarmExport } from '@/api/batch'
 import { getAlarmList } from '@/api/alarm'
 import { getRegion, getAreaTypeBySubSystem } from '@/api/area'
 import { getDetailDevice } from '@/api/device'
@@ -110,6 +111,7 @@
         alarmContent: '',
         areaType: '',
         areaId: '',
+        valid: 0,
         startTime: '',
         endTime: '',
         offset: 1,
@@ -183,6 +185,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      alarmExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `报警列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     detailAlarm(row) {
       this.dialogDetailVisible = true
       this.$refs.alarmDetail.initDialog('detail', this.dialogDetailVisible, row)

diff --git a/src/api/batch.js b/src/api/batch.js
new file mode 100644
index 0000000..2bb662c
--- /dev/null
+++ b/src/api/batch.js
@@ -0,0 +1,114 @@
+import request from '@/utils/request'
+
+export function visitorPersonExport(params) {
+  return request({
+    url: '/visitorPerson/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function alarmExport(params) {
+  return request({
+    url: '/alarm/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function deviceExport(params) {
+  return request({
+    url: '/device/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function personListExport(params) {
+  return request({
+    url: '/statistics/personListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+export function carExport(params) {
+  return request({
+    url: '/car/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+export function carListExport(params) {
+  return request({
+    url: '/statistics/carListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function personDurationListExport(params) {
+  return request({
+    url: '/statistics/personDurationListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function carDurationListExport(params) {
+  return request({
+    url: '/statistics/carDurationListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function staffExport(params) {
+  return request({
+    url: '/staff/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function visitorCarExport(params) {
+  return request({
+    url: '/visitorCar/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function batchImportStaff(fileobj) {
+  const param = new FormData()
+  param.append('fs', fileobj)
+  return request({
+    url: '/staff/imp',
+    method: 'post',
+    headers: { 'Content-Type': 'multipart/form-data' },
+    data: param
+  })
+}
diff --git a/src/components/DownloadTemplate/index.vue b/src/components/DownloadTemplate/index.vue
index 8ded2cd..5e5020f 100644
--- a/src/components/DownloadTemplate/index.vue
+++ b/src/components/DownloadTemplate/index.vue
@@ -15,8 +15,10 @@
   methods: {
     // 下载模板
     downloadTemplate() {
+      console.log('###############################')
       if (this.filename !== '') {
         const filename = this.filename
+        console.log(filename)
         // 全屏加载动画
         const loading = this.$loading({
           lock: true,
diff --git a/src/router/modules/doorSys.js b/src/router/modules/doorSys.js
index 04bfaf4..8017e4b 100644
--- a/src/router/modules/doorSys.js
+++ b/src/router/modules/doorSys.js
@@ -1,3 +1,5 @@
+
+
 /* Layout */
 import Layout from '../../views/layout/Layout'
 import OverviewLayout from '../../views/layout/OverviewLayout'
diff --git a/src/views/alarm/alarmList.vue b/src/views/alarm/alarmList.vue
index cdd1454..704f797 100644
--- a/src/views/alarm/alarmList.vue
+++ b/src/views/alarm/alarmList.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -92,6 +92,7 @@
 </template>
 
 <script>
+import { alarmExport } from '@/api/batch'
 import { getAlarmList } from '@/api/alarm'
 import { getRegion, getAreaTypeBySubSystem } from '@/api/area'
 import { getDetailDevice } from '@/api/device'
@@ -110,6 +111,7 @@
         alarmContent: '',
         areaType: '',
         areaId: '',
+        valid: 0,
         startTime: '',
         endTime: '',
         offset: 1,
@@ -183,6 +185,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      alarmExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `报警列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     detailAlarm(row) {
       this.dialogDetailVisible = true
       this.$refs.alarmDetail.initDialog('detail', this.dialogDetailVisible, row)
diff --git a/src/views/alarm/alarmNow.vue b/src/views/alarm/alarmNow.vue
index 7122e83..03bb5ea 100644
--- a/src/views/alarm/alarmNow.vue
+++ b/src/views/alarm/alarmNow.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -93,6 +93,7 @@
 </template>
 
 <script>
+import { alarmExport } from '@/api/batch'
 import { getAlarmNowList } from '@/api/alarm'
 import { getRegion, getAreaTypeBySubSystem } from '@/api/area'
 import { getDetailDevice } from '@/api/device'
@@ -182,6 +183,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      alarmExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `当前报警列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     alarmCancel(row) {
       this.dialogCancelVisible = true
       this.$refs.alarmCancel.initDialog('detail', this.dialogCancelVisible, row)

diff --git a/src/api/batch.js b/src/api/batch.js
new file mode 100644
index 0000000..2bb662c
--- /dev/null
+++ b/src/api/batch.js
@@ -0,0 +1,114 @@
+import request from '@/utils/request'
+
+export function visitorPersonExport(params) {
+  return request({
+    url: '/visitorPerson/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function alarmExport(params) {
+  return request({
+    url: '/alarm/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function deviceExport(params) {
+  return request({
+    url: '/device/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function personListExport(params) {
+  return request({
+    url: '/statistics/personListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+export function carExport(params) {
+  return request({
+    url: '/car/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+export function carListExport(params) {
+  return request({
+    url: '/statistics/carListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function personDurationListExport(params) {
+  return request({
+    url: '/statistics/personDurationListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function carDurationListExport(params) {
+  return request({
+    url: '/statistics/carDurationListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function staffExport(params) {
+  return request({
+    url: '/staff/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function visitorCarExport(params) {
+  return request({
+    url: '/visitorCar/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function batchImportStaff(fileobj) {
+  const param = new FormData()
+  param.append('fs', fileobj)
+  return request({
+    url: '/staff/imp',
+    method: 'post',
+    headers: { 'Content-Type': 'multipart/form-data' },
+    data: param
+  })
+}
diff --git a/src/components/DownloadTemplate/index.vue b/src/components/DownloadTemplate/index.vue
index 8ded2cd..5e5020f 100644
--- a/src/components/DownloadTemplate/index.vue
+++ b/src/components/DownloadTemplate/index.vue
@@ -15,8 +15,10 @@
   methods: {
     // 下载模板
     downloadTemplate() {
+      console.log('###############################')
       if (this.filename !== '') {
         const filename = this.filename
+        console.log(filename)
         // 全屏加载动画
         const loading = this.$loading({
           lock: true,
diff --git a/src/router/modules/doorSys.js b/src/router/modules/doorSys.js
index 04bfaf4..8017e4b 100644
--- a/src/router/modules/doorSys.js
+++ b/src/router/modules/doorSys.js
@@ -1,3 +1,5 @@
+
+
 /* Layout */
 import Layout from '../../views/layout/Layout'
 import OverviewLayout from '../../views/layout/OverviewLayout'
diff --git a/src/views/alarm/alarmList.vue b/src/views/alarm/alarmList.vue
index cdd1454..704f797 100644
--- a/src/views/alarm/alarmList.vue
+++ b/src/views/alarm/alarmList.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -92,6 +92,7 @@
 </template>
 
 <script>
+import { alarmExport } from '@/api/batch'
 import { getAlarmList } from '@/api/alarm'
 import { getRegion, getAreaTypeBySubSystem } from '@/api/area'
 import { getDetailDevice } from '@/api/device'
@@ -110,6 +111,7 @@
         alarmContent: '',
         areaType: '',
         areaId: '',
+        valid: 0,
         startTime: '',
         endTime: '',
         offset: 1,
@@ -183,6 +185,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      alarmExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `报警列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     detailAlarm(row) {
       this.dialogDetailVisible = true
       this.$refs.alarmDetail.initDialog('detail', this.dialogDetailVisible, row)
diff --git a/src/views/alarm/alarmNow.vue b/src/views/alarm/alarmNow.vue
index 7122e83..03bb5ea 100644
--- a/src/views/alarm/alarmNow.vue
+++ b/src/views/alarm/alarmNow.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -93,6 +93,7 @@
 </template>
 
 <script>
+import { alarmExport } from '@/api/batch'
 import { getAlarmNowList } from '@/api/alarm'
 import { getRegion, getAreaTypeBySubSystem } from '@/api/area'
 import { getDetailDevice } from '@/api/device'
@@ -182,6 +183,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      alarmExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `当前报警列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     alarmCancel(row) {
       this.dialogCancelVisible = true
       this.$refs.alarmCancel.initDialog('detail', this.dialogCancelVisible, row)
diff --git a/src/views/area/areaList.vue b/src/views/area/areaList.vue
index d9dddc0..1950028 100644
--- a/src/views/area/areaList.vue
+++ b/src/views/area/areaList.vue
@@ -31,7 +31,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <!--<el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>-->
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>

diff --git a/src/api/batch.js b/src/api/batch.js
new file mode 100644
index 0000000..2bb662c
--- /dev/null
+++ b/src/api/batch.js
@@ -0,0 +1,114 @@
+import request from '@/utils/request'
+
+export function visitorPersonExport(params) {
+  return request({
+    url: '/visitorPerson/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function alarmExport(params) {
+  return request({
+    url: '/alarm/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function deviceExport(params) {
+  return request({
+    url: '/device/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function personListExport(params) {
+  return request({
+    url: '/statistics/personListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+export function carExport(params) {
+  return request({
+    url: '/car/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+export function carListExport(params) {
+  return request({
+    url: '/statistics/carListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function personDurationListExport(params) {
+  return request({
+    url: '/statistics/personDurationListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function carDurationListExport(params) {
+  return request({
+    url: '/statistics/carDurationListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function staffExport(params) {
+  return request({
+    url: '/staff/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function visitorCarExport(params) {
+  return request({
+    url: '/visitorCar/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function batchImportStaff(fileobj) {
+  const param = new FormData()
+  param.append('fs', fileobj)
+  return request({
+    url: '/staff/imp',
+    method: 'post',
+    headers: { 'Content-Type': 'multipart/form-data' },
+    data: param
+  })
+}
diff --git a/src/components/DownloadTemplate/index.vue b/src/components/DownloadTemplate/index.vue
index 8ded2cd..5e5020f 100644
--- a/src/components/DownloadTemplate/index.vue
+++ b/src/components/DownloadTemplate/index.vue
@@ -15,8 +15,10 @@
   methods: {
     // 下载模板
     downloadTemplate() {
+      console.log('###############################')
       if (this.filename !== '') {
         const filename = this.filename
+        console.log(filename)
         // 全屏加载动画
         const loading = this.$loading({
           lock: true,
diff --git a/src/router/modules/doorSys.js b/src/router/modules/doorSys.js
index 04bfaf4..8017e4b 100644
--- a/src/router/modules/doorSys.js
+++ b/src/router/modules/doorSys.js
@@ -1,3 +1,5 @@
+
+
 /* Layout */
 import Layout from '../../views/layout/Layout'
 import OverviewLayout from '../../views/layout/OverviewLayout'
diff --git a/src/views/alarm/alarmList.vue b/src/views/alarm/alarmList.vue
index cdd1454..704f797 100644
--- a/src/views/alarm/alarmList.vue
+++ b/src/views/alarm/alarmList.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -92,6 +92,7 @@
 </template>
 
 <script>
+import { alarmExport } from '@/api/batch'
 import { getAlarmList } from '@/api/alarm'
 import { getRegion, getAreaTypeBySubSystem } from '@/api/area'
 import { getDetailDevice } from '@/api/device'
@@ -110,6 +111,7 @@
         alarmContent: '',
         areaType: '',
         areaId: '',
+        valid: 0,
         startTime: '',
         endTime: '',
         offset: 1,
@@ -183,6 +185,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      alarmExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `报警列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     detailAlarm(row) {
       this.dialogDetailVisible = true
       this.$refs.alarmDetail.initDialog('detail', this.dialogDetailVisible, row)
diff --git a/src/views/alarm/alarmNow.vue b/src/views/alarm/alarmNow.vue
index 7122e83..03bb5ea 100644
--- a/src/views/alarm/alarmNow.vue
+++ b/src/views/alarm/alarmNow.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -93,6 +93,7 @@
 </template>
 
 <script>
+import { alarmExport } from '@/api/batch'
 import { getAlarmNowList } from '@/api/alarm'
 import { getRegion, getAreaTypeBySubSystem } from '@/api/area'
 import { getDetailDevice } from '@/api/device'
@@ -182,6 +183,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      alarmExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `当前报警列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     alarmCancel(row) {
       this.dialogCancelVisible = true
       this.$refs.alarmCancel.initDialog('detail', this.dialogCancelVisible, row)
diff --git a/src/views/area/areaList.vue b/src/views/area/areaList.vue
index d9dddc0..1950028 100644
--- a/src/views/area/areaList.vue
+++ b/src/views/area/areaList.vue
@@ -31,7 +31,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <!--<el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>-->
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
diff --git a/src/views/area/defenceList.vue b/src/views/area/defenceList.vue
index 4230d00..9e2ed68 100644
--- a/src/views/area/defenceList.vue
+++ b/src/views/area/defenceList.vue
@@ -33,7 +33,7 @@
         <el-col :span="12" :offset="6" class="edit_btns">
           <el-button class="edit_btn" size="small">批量导入</el-button>
           <el-button class="edit_btn" size="small">导入模板下载</el-button>
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <!--<el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>-->
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>

diff --git a/src/api/batch.js b/src/api/batch.js
new file mode 100644
index 0000000..2bb662c
--- /dev/null
+++ b/src/api/batch.js
@@ -0,0 +1,114 @@
+import request from '@/utils/request'
+
+export function visitorPersonExport(params) {
+  return request({
+    url: '/visitorPerson/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function alarmExport(params) {
+  return request({
+    url: '/alarm/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function deviceExport(params) {
+  return request({
+    url: '/device/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function personListExport(params) {
+  return request({
+    url: '/statistics/personListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+export function carExport(params) {
+  return request({
+    url: '/car/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+export function carListExport(params) {
+  return request({
+    url: '/statistics/carListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function personDurationListExport(params) {
+  return request({
+    url: '/statistics/personDurationListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function carDurationListExport(params) {
+  return request({
+    url: '/statistics/carDurationListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function staffExport(params) {
+  return request({
+    url: '/staff/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function visitorCarExport(params) {
+  return request({
+    url: '/visitorCar/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function batchImportStaff(fileobj) {
+  const param = new FormData()
+  param.append('fs', fileobj)
+  return request({
+    url: '/staff/imp',
+    method: 'post',
+    headers: { 'Content-Type': 'multipart/form-data' },
+    data: param
+  })
+}
diff --git a/src/components/DownloadTemplate/index.vue b/src/components/DownloadTemplate/index.vue
index 8ded2cd..5e5020f 100644
--- a/src/components/DownloadTemplate/index.vue
+++ b/src/components/DownloadTemplate/index.vue
@@ -15,8 +15,10 @@
   methods: {
     // 下载模板
     downloadTemplate() {
+      console.log('###############################')
       if (this.filename !== '') {
         const filename = this.filename
+        console.log(filename)
         // 全屏加载动画
         const loading = this.$loading({
           lock: true,
diff --git a/src/router/modules/doorSys.js b/src/router/modules/doorSys.js
index 04bfaf4..8017e4b 100644
--- a/src/router/modules/doorSys.js
+++ b/src/router/modules/doorSys.js
@@ -1,3 +1,5 @@
+
+
 /* Layout */
 import Layout from '../../views/layout/Layout'
 import OverviewLayout from '../../views/layout/OverviewLayout'
diff --git a/src/views/alarm/alarmList.vue b/src/views/alarm/alarmList.vue
index cdd1454..704f797 100644
--- a/src/views/alarm/alarmList.vue
+++ b/src/views/alarm/alarmList.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -92,6 +92,7 @@
 </template>
 
 <script>
+import { alarmExport } from '@/api/batch'
 import { getAlarmList } from '@/api/alarm'
 import { getRegion, getAreaTypeBySubSystem } from '@/api/area'
 import { getDetailDevice } from '@/api/device'
@@ -110,6 +111,7 @@
         alarmContent: '',
         areaType: '',
         areaId: '',
+        valid: 0,
         startTime: '',
         endTime: '',
         offset: 1,
@@ -183,6 +185,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      alarmExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `报警列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     detailAlarm(row) {
       this.dialogDetailVisible = true
       this.$refs.alarmDetail.initDialog('detail', this.dialogDetailVisible, row)
diff --git a/src/views/alarm/alarmNow.vue b/src/views/alarm/alarmNow.vue
index 7122e83..03bb5ea 100644
--- a/src/views/alarm/alarmNow.vue
+++ b/src/views/alarm/alarmNow.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -93,6 +93,7 @@
 </template>
 
 <script>
+import { alarmExport } from '@/api/batch'
 import { getAlarmNowList } from '@/api/alarm'
 import { getRegion, getAreaTypeBySubSystem } from '@/api/area'
 import { getDetailDevice } from '@/api/device'
@@ -182,6 +183,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      alarmExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `当前报警列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     alarmCancel(row) {
       this.dialogCancelVisible = true
       this.$refs.alarmCancel.initDialog('detail', this.dialogCancelVisible, row)
diff --git a/src/views/area/areaList.vue b/src/views/area/areaList.vue
index d9dddc0..1950028 100644
--- a/src/views/area/areaList.vue
+++ b/src/views/area/areaList.vue
@@ -31,7 +31,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <!--<el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>-->
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
diff --git a/src/views/area/defenceList.vue b/src/views/area/defenceList.vue
index 4230d00..9e2ed68 100644
--- a/src/views/area/defenceList.vue
+++ b/src/views/area/defenceList.vue
@@ -33,7 +33,7 @@
         <el-col :span="12" :offset="6" class="edit_btns">
           <el-button class="edit_btn" size="small">批量导入</el-button>
           <el-button class="edit_btn" size="small">导入模板下载</el-button>
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <!--<el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>-->
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
diff --git a/src/views/car/carList.vue b/src/views/car/carList.vue
index 54a8c57..ceb77ff 100644
--- a/src/views/car/carList.vue
+++ b/src/views/car/carList.vue
@@ -31,9 +31,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">批量导入</el-button>
-          <el-button class="edit_btn" size="small">导入模板下载</el-button>
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
           <el-button v-if="hasPerm('/door/car/add')" class="edit_btn" size="small" @click="add">新增</el-button>
           <!--          <el-button v-if="hasPerm('/door/car/delete')" v-show="false" class="edit_btn" size="small" @click="batchDel">删除</el-button>-->
         </el-col>
@@ -80,6 +78,7 @@
 import CarAdd from '@/views/car/carAdd'
 import { getCarList, deleteCar } from '@/api/car'
 import { getCarProperty } from '@/api/allDict'
+import { carExport } from '@/api/batch'
 
 export default {
   name: 'CarList',
@@ -133,6 +132,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      carExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `车辆列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     // 检查选择情况
     checkSelection() {
       if (this.multipleSelection.length === 0) {

diff --git a/src/api/batch.js b/src/api/batch.js
new file mode 100644
index 0000000..2bb662c
--- /dev/null
+++ b/src/api/batch.js
@@ -0,0 +1,114 @@
+import request from '@/utils/request'
+
+export function visitorPersonExport(params) {
+  return request({
+    url: '/visitorPerson/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function alarmExport(params) {
+  return request({
+    url: '/alarm/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function deviceExport(params) {
+  return request({
+    url: '/device/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function personListExport(params) {
+  return request({
+    url: '/statistics/personListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+export function carExport(params) {
+  return request({
+    url: '/car/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+export function carListExport(params) {
+  return request({
+    url: '/statistics/carListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function personDurationListExport(params) {
+  return request({
+    url: '/statistics/personDurationListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function carDurationListExport(params) {
+  return request({
+    url: '/statistics/carDurationListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function staffExport(params) {
+  return request({
+    url: '/staff/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function visitorCarExport(params) {
+  return request({
+    url: '/visitorCar/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function batchImportStaff(fileobj) {
+  const param = new FormData()
+  param.append('fs', fileobj)
+  return request({
+    url: '/staff/imp',
+    method: 'post',
+    headers: { 'Content-Type': 'multipart/form-data' },
+    data: param
+  })
+}
diff --git a/src/components/DownloadTemplate/index.vue b/src/components/DownloadTemplate/index.vue
index 8ded2cd..5e5020f 100644
--- a/src/components/DownloadTemplate/index.vue
+++ b/src/components/DownloadTemplate/index.vue
@@ -15,8 +15,10 @@
   methods: {
     // 下载模板
     downloadTemplate() {
+      console.log('###############################')
       if (this.filename !== '') {
         const filename = this.filename
+        console.log(filename)
         // 全屏加载动画
         const loading = this.$loading({
           lock: true,
diff --git a/src/router/modules/doorSys.js b/src/router/modules/doorSys.js
index 04bfaf4..8017e4b 100644
--- a/src/router/modules/doorSys.js
+++ b/src/router/modules/doorSys.js
@@ -1,3 +1,5 @@
+
+
 /* Layout */
 import Layout from '../../views/layout/Layout'
 import OverviewLayout from '../../views/layout/OverviewLayout'
diff --git a/src/views/alarm/alarmList.vue b/src/views/alarm/alarmList.vue
index cdd1454..704f797 100644
--- a/src/views/alarm/alarmList.vue
+++ b/src/views/alarm/alarmList.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -92,6 +92,7 @@
 </template>
 
 <script>
+import { alarmExport } from '@/api/batch'
 import { getAlarmList } from '@/api/alarm'
 import { getRegion, getAreaTypeBySubSystem } from '@/api/area'
 import { getDetailDevice } from '@/api/device'
@@ -110,6 +111,7 @@
         alarmContent: '',
         areaType: '',
         areaId: '',
+        valid: 0,
         startTime: '',
         endTime: '',
         offset: 1,
@@ -183,6 +185,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      alarmExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `报警列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     detailAlarm(row) {
       this.dialogDetailVisible = true
       this.$refs.alarmDetail.initDialog('detail', this.dialogDetailVisible, row)
diff --git a/src/views/alarm/alarmNow.vue b/src/views/alarm/alarmNow.vue
index 7122e83..03bb5ea 100644
--- a/src/views/alarm/alarmNow.vue
+++ b/src/views/alarm/alarmNow.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -93,6 +93,7 @@
 </template>
 
 <script>
+import { alarmExport } from '@/api/batch'
 import { getAlarmNowList } from '@/api/alarm'
 import { getRegion, getAreaTypeBySubSystem } from '@/api/area'
 import { getDetailDevice } from '@/api/device'
@@ -182,6 +183,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      alarmExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `当前报警列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     alarmCancel(row) {
       this.dialogCancelVisible = true
       this.$refs.alarmCancel.initDialog('detail', this.dialogCancelVisible, row)
diff --git a/src/views/area/areaList.vue b/src/views/area/areaList.vue
index d9dddc0..1950028 100644
--- a/src/views/area/areaList.vue
+++ b/src/views/area/areaList.vue
@@ -31,7 +31,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <!--<el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>-->
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
diff --git a/src/views/area/defenceList.vue b/src/views/area/defenceList.vue
index 4230d00..9e2ed68 100644
--- a/src/views/area/defenceList.vue
+++ b/src/views/area/defenceList.vue
@@ -33,7 +33,7 @@
         <el-col :span="12" :offset="6" class="edit_btns">
           <el-button class="edit_btn" size="small">批量导入</el-button>
           <el-button class="edit_btn" size="small">导入模板下载</el-button>
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <!--<el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>-->
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
diff --git a/src/views/car/carList.vue b/src/views/car/carList.vue
index 54a8c57..ceb77ff 100644
--- a/src/views/car/carList.vue
+++ b/src/views/car/carList.vue
@@ -31,9 +31,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">批量导入</el-button>
-          <el-button class="edit_btn" size="small">导入模板下载</el-button>
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
           <el-button v-if="hasPerm('/door/car/add')" class="edit_btn" size="small" @click="add">新增</el-button>
           <!--          <el-button v-if="hasPerm('/door/car/delete')" v-show="false" class="edit_btn" size="small" @click="batchDel">删除</el-button>-->
         </el-col>
@@ -80,6 +78,7 @@
 import CarAdd from '@/views/car/carAdd'
 import { getCarList, deleteCar } from '@/api/car'
 import { getCarProperty } from '@/api/allDict'
+import { carExport } from '@/api/batch'
 
 export default {
   name: 'CarList',
@@ -133,6 +132,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      carExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `车辆列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     // 检查选择情况
     checkSelection() {
       if (this.multipleSelection.length === 0) {
diff --git a/src/views/deviceManage/deviceList.vue b/src/views/deviceManage/deviceList.vue
index f5a7417..5966b45 100644
--- a/src/views/deviceManage/deviceList.vue
+++ b/src/views/deviceManage/deviceList.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border @selection-change="handleSelectionChange">
@@ -89,6 +89,7 @@
 </template>
 
 <script>
+import { deviceExport } from '@/api/batch'
 import { getDeviceList } from '@/api/device'
 import { getDeviceType } from '@/api/allDict'
 import { getAreaTypeBySubSystem } from '@/api/area'
@@ -175,6 +176,31 @@
     this.fetchDeviceType() // 获取设备类别
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      deviceExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `设备列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     initAreaType() {
       this.listQuery.areaType = getAreaTypeBySubSystem(this.$store.getters.currentSystem.code)
     },

diff --git a/src/api/batch.js b/src/api/batch.js
new file mode 100644
index 0000000..2bb662c
--- /dev/null
+++ b/src/api/batch.js
@@ -0,0 +1,114 @@
+import request from '@/utils/request'
+
+export function visitorPersonExport(params) {
+  return request({
+    url: '/visitorPerson/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function alarmExport(params) {
+  return request({
+    url: '/alarm/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function deviceExport(params) {
+  return request({
+    url: '/device/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function personListExport(params) {
+  return request({
+    url: '/statistics/personListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+export function carExport(params) {
+  return request({
+    url: '/car/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+export function carListExport(params) {
+  return request({
+    url: '/statistics/carListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function personDurationListExport(params) {
+  return request({
+    url: '/statistics/personDurationListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function carDurationListExport(params) {
+  return request({
+    url: '/statistics/carDurationListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function staffExport(params) {
+  return request({
+    url: '/staff/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function visitorCarExport(params) {
+  return request({
+    url: '/visitorCar/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function batchImportStaff(fileobj) {
+  const param = new FormData()
+  param.append('fs', fileobj)
+  return request({
+    url: '/staff/imp',
+    method: 'post',
+    headers: { 'Content-Type': 'multipart/form-data' },
+    data: param
+  })
+}
diff --git a/src/components/DownloadTemplate/index.vue b/src/components/DownloadTemplate/index.vue
index 8ded2cd..5e5020f 100644
--- a/src/components/DownloadTemplate/index.vue
+++ b/src/components/DownloadTemplate/index.vue
@@ -15,8 +15,10 @@
   methods: {
     // 下载模板
     downloadTemplate() {
+      console.log('###############################')
       if (this.filename !== '') {
         const filename = this.filename
+        console.log(filename)
         // 全屏加载动画
         const loading = this.$loading({
           lock: true,
diff --git a/src/router/modules/doorSys.js b/src/router/modules/doorSys.js
index 04bfaf4..8017e4b 100644
--- a/src/router/modules/doorSys.js
+++ b/src/router/modules/doorSys.js
@@ -1,3 +1,5 @@
+
+
 /* Layout */
 import Layout from '../../views/layout/Layout'
 import OverviewLayout from '../../views/layout/OverviewLayout'
diff --git a/src/views/alarm/alarmList.vue b/src/views/alarm/alarmList.vue
index cdd1454..704f797 100644
--- a/src/views/alarm/alarmList.vue
+++ b/src/views/alarm/alarmList.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -92,6 +92,7 @@
 </template>
 
 <script>
+import { alarmExport } from '@/api/batch'
 import { getAlarmList } from '@/api/alarm'
 import { getRegion, getAreaTypeBySubSystem } from '@/api/area'
 import { getDetailDevice } from '@/api/device'
@@ -110,6 +111,7 @@
         alarmContent: '',
         areaType: '',
         areaId: '',
+        valid: 0,
         startTime: '',
         endTime: '',
         offset: 1,
@@ -183,6 +185,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      alarmExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `报警列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     detailAlarm(row) {
       this.dialogDetailVisible = true
       this.$refs.alarmDetail.initDialog('detail', this.dialogDetailVisible, row)
diff --git a/src/views/alarm/alarmNow.vue b/src/views/alarm/alarmNow.vue
index 7122e83..03bb5ea 100644
--- a/src/views/alarm/alarmNow.vue
+++ b/src/views/alarm/alarmNow.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -93,6 +93,7 @@
 </template>
 
 <script>
+import { alarmExport } from '@/api/batch'
 import { getAlarmNowList } from '@/api/alarm'
 import { getRegion, getAreaTypeBySubSystem } from '@/api/area'
 import { getDetailDevice } from '@/api/device'
@@ -182,6 +183,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      alarmExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `当前报警列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     alarmCancel(row) {
       this.dialogCancelVisible = true
       this.$refs.alarmCancel.initDialog('detail', this.dialogCancelVisible, row)
diff --git a/src/views/area/areaList.vue b/src/views/area/areaList.vue
index d9dddc0..1950028 100644
--- a/src/views/area/areaList.vue
+++ b/src/views/area/areaList.vue
@@ -31,7 +31,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <!--<el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>-->
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
diff --git a/src/views/area/defenceList.vue b/src/views/area/defenceList.vue
index 4230d00..9e2ed68 100644
--- a/src/views/area/defenceList.vue
+++ b/src/views/area/defenceList.vue
@@ -33,7 +33,7 @@
         <el-col :span="12" :offset="6" class="edit_btns">
           <el-button class="edit_btn" size="small">批量导入</el-button>
           <el-button class="edit_btn" size="small">导入模板下载</el-button>
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <!--<el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>-->
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
diff --git a/src/views/car/carList.vue b/src/views/car/carList.vue
index 54a8c57..ceb77ff 100644
--- a/src/views/car/carList.vue
+++ b/src/views/car/carList.vue
@@ -31,9 +31,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">批量导入</el-button>
-          <el-button class="edit_btn" size="small">导入模板下载</el-button>
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
           <el-button v-if="hasPerm('/door/car/add')" class="edit_btn" size="small" @click="add">新增</el-button>
           <!--          <el-button v-if="hasPerm('/door/car/delete')" v-show="false" class="edit_btn" size="small" @click="batchDel">删除</el-button>-->
         </el-col>
@@ -80,6 +78,7 @@
 import CarAdd from '@/views/car/carAdd'
 import { getCarList, deleteCar } from '@/api/car'
 import { getCarProperty } from '@/api/allDict'
+import { carExport } from '@/api/batch'
 
 export default {
   name: 'CarList',
@@ -133,6 +132,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      carExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `车辆列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     // 检查选择情况
     checkSelection() {
       if (this.multipleSelection.length === 0) {
diff --git a/src/views/deviceManage/deviceList.vue b/src/views/deviceManage/deviceList.vue
index f5a7417..5966b45 100644
--- a/src/views/deviceManage/deviceList.vue
+++ b/src/views/deviceManage/deviceList.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border @selection-change="handleSelectionChange">
@@ -89,6 +89,7 @@
 </template>
 
 <script>
+import { deviceExport } from '@/api/batch'
 import { getDeviceList } from '@/api/device'
 import { getDeviceType } from '@/api/allDict'
 import { getAreaTypeBySubSystem } from '@/api/area'
@@ -175,6 +176,31 @@
     this.fetchDeviceType() // 获取设备类别
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      deviceExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `设备列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     initAreaType() {
       this.listQuery.areaType = getAreaTypeBySubSystem(this.$store.getters.currentSystem.code)
     },
diff --git a/src/views/staff/staffList.vue b/src/views/staff/staffList.vue
index 3014740..4a92b0c 100644
--- a/src/views/staff/staffList.vue
+++ b/src/views/staff/staffList.vue
@@ -32,8 +32,19 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
+          <el-upload
+            :limit="1"
+            :show-file-list="false"
+            :http-request="uploadFile"
+            :file-list="fileList"
+            class="edit_btn"
+            action="string"
+            accept=".xls,.xlsx">
+            <el-button class="filter-item" size="small">批量导入</el-button>
+          </el-upload>
+          <download-template :filename="personImpTem" btnname="导入模板下载"/>
           <el-button v-if="hasPerm('/staff/delete')" size="small" class="edit_btn" @click="del">删除</el-button>
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
           <el-button v-if="hasPerm('/staff/add')" class="edit_btn" size="small" @click="add">新增</el-button>
         </el-col>
       </el-row>
@@ -80,11 +91,16 @@
 import StaffDetail from '@/views/staff/staffDetail'
 import { getStaffList, batchDelStaff } from '@/api/staff'
 import { getDeptTreeList } from '@/api/dept'
+import { staffExport, batchImportStaff } from '@/api/batch'
+import DownloadTemplate from '@/components/DownloadTemplate/index'
+
 export default {
   name: 'StaffList',
-  components: { StaffDetail, DeptSelect },
+  components: { StaffDetail, DeptSelect, DownloadTemplate },
   data() {
     return {
+      fileList: [], // 批量导入
+      personImpTem:'personImpTem.xlsx',
       deptList: [],
       listQuery: {
         keywords: '',
@@ -142,6 +158,63 @@
     this.fetchData()
   },
   methods: {
+    // 批量导入
+    uploadFile(param) {
+      // 判断文件大小是否符合要求
+      const _file = param.file
+      const isLt5M = _file.size / 1024 / 1024 < 5
+      if (!isLt5M) {
+        this.$message.error('请上传5M以下的excel文件')
+        return false
+      }
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '导入中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      // 批量导入上传请求
+      batchImportStaff(_file).then(res => {
+        loading.close() // 关闭加载动画
+        if (res.code === 200) {
+          this.$message.success('导入成功')
+          this.fileList = []
+          this.fetchData()
+        } else {
+          this.$message.error(res.message)
+        }
+      }).catch(err => {
+        loading.close()
+        this.$message.error(err.message)
+      })
+      this.fileList = []
+    },
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      staffExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `人员列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     // 检查选择情况
     checkSelection() {
       if (this.multipleSelection.length === 0) {

diff --git a/src/api/batch.js b/src/api/batch.js
new file mode 100644
index 0000000..2bb662c
--- /dev/null
+++ b/src/api/batch.js
@@ -0,0 +1,114 @@
+import request from '@/utils/request'
+
+export function visitorPersonExport(params) {
+  return request({
+    url: '/visitorPerson/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function alarmExport(params) {
+  return request({
+    url: '/alarm/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function deviceExport(params) {
+  return request({
+    url: '/device/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function personListExport(params) {
+  return request({
+    url: '/statistics/personListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+export function carExport(params) {
+  return request({
+    url: '/car/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+export function carListExport(params) {
+  return request({
+    url: '/statistics/carListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function personDurationListExport(params) {
+  return request({
+    url: '/statistics/personDurationListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function carDurationListExport(params) {
+  return request({
+    url: '/statistics/carDurationListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function staffExport(params) {
+  return request({
+    url: '/staff/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function visitorCarExport(params) {
+  return request({
+    url: '/visitorCar/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function batchImportStaff(fileobj) {
+  const param = new FormData()
+  param.append('fs', fileobj)
+  return request({
+    url: '/staff/imp',
+    method: 'post',
+    headers: { 'Content-Type': 'multipart/form-data' },
+    data: param
+  })
+}
diff --git a/src/components/DownloadTemplate/index.vue b/src/components/DownloadTemplate/index.vue
index 8ded2cd..5e5020f 100644
--- a/src/components/DownloadTemplate/index.vue
+++ b/src/components/DownloadTemplate/index.vue
@@ -15,8 +15,10 @@
   methods: {
     // 下载模板
     downloadTemplate() {
+      console.log('###############################')
       if (this.filename !== '') {
         const filename = this.filename
+        console.log(filename)
         // 全屏加载动画
         const loading = this.$loading({
           lock: true,
diff --git a/src/router/modules/doorSys.js b/src/router/modules/doorSys.js
index 04bfaf4..8017e4b 100644
--- a/src/router/modules/doorSys.js
+++ b/src/router/modules/doorSys.js
@@ -1,3 +1,5 @@
+
+
 /* Layout */
 import Layout from '../../views/layout/Layout'
 import OverviewLayout from '../../views/layout/OverviewLayout'
diff --git a/src/views/alarm/alarmList.vue b/src/views/alarm/alarmList.vue
index cdd1454..704f797 100644
--- a/src/views/alarm/alarmList.vue
+++ b/src/views/alarm/alarmList.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -92,6 +92,7 @@
 </template>
 
 <script>
+import { alarmExport } from '@/api/batch'
 import { getAlarmList } from '@/api/alarm'
 import { getRegion, getAreaTypeBySubSystem } from '@/api/area'
 import { getDetailDevice } from '@/api/device'
@@ -110,6 +111,7 @@
         alarmContent: '',
         areaType: '',
         areaId: '',
+        valid: 0,
         startTime: '',
         endTime: '',
         offset: 1,
@@ -183,6 +185,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      alarmExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `报警列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     detailAlarm(row) {
       this.dialogDetailVisible = true
       this.$refs.alarmDetail.initDialog('detail', this.dialogDetailVisible, row)
diff --git a/src/views/alarm/alarmNow.vue b/src/views/alarm/alarmNow.vue
index 7122e83..03bb5ea 100644
--- a/src/views/alarm/alarmNow.vue
+++ b/src/views/alarm/alarmNow.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -93,6 +93,7 @@
 </template>
 
 <script>
+import { alarmExport } from '@/api/batch'
 import { getAlarmNowList } from '@/api/alarm'
 import { getRegion, getAreaTypeBySubSystem } from '@/api/area'
 import { getDetailDevice } from '@/api/device'
@@ -182,6 +183,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      alarmExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `当前报警列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     alarmCancel(row) {
       this.dialogCancelVisible = true
       this.$refs.alarmCancel.initDialog('detail', this.dialogCancelVisible, row)
diff --git a/src/views/area/areaList.vue b/src/views/area/areaList.vue
index d9dddc0..1950028 100644
--- a/src/views/area/areaList.vue
+++ b/src/views/area/areaList.vue
@@ -31,7 +31,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <!--<el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>-->
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
diff --git a/src/views/area/defenceList.vue b/src/views/area/defenceList.vue
index 4230d00..9e2ed68 100644
--- a/src/views/area/defenceList.vue
+++ b/src/views/area/defenceList.vue
@@ -33,7 +33,7 @@
         <el-col :span="12" :offset="6" class="edit_btns">
           <el-button class="edit_btn" size="small">批量导入</el-button>
           <el-button class="edit_btn" size="small">导入模板下载</el-button>
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <!--<el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>-->
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
diff --git a/src/views/car/carList.vue b/src/views/car/carList.vue
index 54a8c57..ceb77ff 100644
--- a/src/views/car/carList.vue
+++ b/src/views/car/carList.vue
@@ -31,9 +31,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">批量导入</el-button>
-          <el-button class="edit_btn" size="small">导入模板下载</el-button>
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
           <el-button v-if="hasPerm('/door/car/add')" class="edit_btn" size="small" @click="add">新增</el-button>
           <!--          <el-button v-if="hasPerm('/door/car/delete')" v-show="false" class="edit_btn" size="small" @click="batchDel">删除</el-button>-->
         </el-col>
@@ -80,6 +78,7 @@
 import CarAdd from '@/views/car/carAdd'
 import { getCarList, deleteCar } from '@/api/car'
 import { getCarProperty } from '@/api/allDict'
+import { carExport } from '@/api/batch'
 
 export default {
   name: 'CarList',
@@ -133,6 +132,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      carExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `车辆列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     // 检查选择情况
     checkSelection() {
       if (this.multipleSelection.length === 0) {
diff --git a/src/views/deviceManage/deviceList.vue b/src/views/deviceManage/deviceList.vue
index f5a7417..5966b45 100644
--- a/src/views/deviceManage/deviceList.vue
+++ b/src/views/deviceManage/deviceList.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border @selection-change="handleSelectionChange">
@@ -89,6 +89,7 @@
 </template>
 
 <script>
+import { deviceExport } from '@/api/batch'
 import { getDeviceList } from '@/api/device'
 import { getDeviceType } from '@/api/allDict'
 import { getAreaTypeBySubSystem } from '@/api/area'
@@ -175,6 +176,31 @@
     this.fetchDeviceType() // 获取设备类别
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      deviceExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `设备列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     initAreaType() {
       this.listQuery.areaType = getAreaTypeBySubSystem(this.$store.getters.currentSystem.code)
     },
diff --git a/src/views/staff/staffList.vue b/src/views/staff/staffList.vue
index 3014740..4a92b0c 100644
--- a/src/views/staff/staffList.vue
+++ b/src/views/staff/staffList.vue
@@ -32,8 +32,19 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
+          <el-upload
+            :limit="1"
+            :show-file-list="false"
+            :http-request="uploadFile"
+            :file-list="fileList"
+            class="edit_btn"
+            action="string"
+            accept=".xls,.xlsx">
+            <el-button class="filter-item" size="small">批量导入</el-button>
+          </el-upload>
+          <download-template :filename="personImpTem" btnname="导入模板下载"/>
           <el-button v-if="hasPerm('/staff/delete')" size="small" class="edit_btn" @click="del">删除</el-button>
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
           <el-button v-if="hasPerm('/staff/add')" class="edit_btn" size="small" @click="add">新增</el-button>
         </el-col>
       </el-row>
@@ -80,11 +91,16 @@
 import StaffDetail from '@/views/staff/staffDetail'
 import { getStaffList, batchDelStaff } from '@/api/staff'
 import { getDeptTreeList } from '@/api/dept'
+import { staffExport, batchImportStaff } from '@/api/batch'
+import DownloadTemplate from '@/components/DownloadTemplate/index'
+
 export default {
   name: 'StaffList',
-  components: { StaffDetail, DeptSelect },
+  components: { StaffDetail, DeptSelect, DownloadTemplate },
   data() {
     return {
+      fileList: [], // 批量导入
+      personImpTem:'personImpTem.xlsx',
       deptList: [],
       listQuery: {
         keywords: '',
@@ -142,6 +158,63 @@
     this.fetchData()
   },
   methods: {
+    // 批量导入
+    uploadFile(param) {
+      // 判断文件大小是否符合要求
+      const _file = param.file
+      const isLt5M = _file.size / 1024 / 1024 < 5
+      if (!isLt5M) {
+        this.$message.error('请上传5M以下的excel文件')
+        return false
+      }
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '导入中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      // 批量导入上传请求
+      batchImportStaff(_file).then(res => {
+        loading.close() // 关闭加载动画
+        if (res.code === 200) {
+          this.$message.success('导入成功')
+          this.fileList = []
+          this.fetchData()
+        } else {
+          this.$message.error(res.message)
+        }
+      }).catch(err => {
+        loading.close()
+        this.$message.error(err.message)
+      })
+      this.fileList = []
+    },
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      staffExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `人员列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     // 检查选择情况
     checkSelection() {
       if (this.multipleSelection.length === 0) {
diff --git a/src/views/statistics/carDuration.vue b/src/views/statistics/carDuration.vue
index 9ab73a8..e4093d5 100644
--- a/src/views/statistics/carDuration.vue
+++ b/src/views/statistics/carDuration.vue
@@ -41,7 +41,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -76,6 +76,7 @@
 import { formatToString } from '@/utils/calendarUtil'
 import { carDurationStatistics } from '@/api/statistics'
 import { getCarType } from '@/api/allDict'
+import { carDurationListExport } from '@/api/batch'
 
 export default {
   name: 'CarDuration',
@@ -144,6 +145,31 @@
     this.fetchData()// 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      carDurationListExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `车辆所处时长统计列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     // 查询数据
     search() {
       this.fetchData(false)

diff --git a/src/api/batch.js b/src/api/batch.js
new file mode 100644
index 0000000..2bb662c
--- /dev/null
+++ b/src/api/batch.js
@@ -0,0 +1,114 @@
+import request from '@/utils/request'
+
+export function visitorPersonExport(params) {
+  return request({
+    url: '/visitorPerson/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function alarmExport(params) {
+  return request({
+    url: '/alarm/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function deviceExport(params) {
+  return request({
+    url: '/device/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function personListExport(params) {
+  return request({
+    url: '/statistics/personListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+export function carExport(params) {
+  return request({
+    url: '/car/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+export function carListExport(params) {
+  return request({
+    url: '/statistics/carListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function personDurationListExport(params) {
+  return request({
+    url: '/statistics/personDurationListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function carDurationListExport(params) {
+  return request({
+    url: '/statistics/carDurationListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function staffExport(params) {
+  return request({
+    url: '/staff/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function visitorCarExport(params) {
+  return request({
+    url: '/visitorCar/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function batchImportStaff(fileobj) {
+  const param = new FormData()
+  param.append('fs', fileobj)
+  return request({
+    url: '/staff/imp',
+    method: 'post',
+    headers: { 'Content-Type': 'multipart/form-data' },
+    data: param
+  })
+}
diff --git a/src/components/DownloadTemplate/index.vue b/src/components/DownloadTemplate/index.vue
index 8ded2cd..5e5020f 100644
--- a/src/components/DownloadTemplate/index.vue
+++ b/src/components/DownloadTemplate/index.vue
@@ -15,8 +15,10 @@
   methods: {
     // 下载模板
     downloadTemplate() {
+      console.log('###############################')
       if (this.filename !== '') {
         const filename = this.filename
+        console.log(filename)
         // 全屏加载动画
         const loading = this.$loading({
           lock: true,
diff --git a/src/router/modules/doorSys.js b/src/router/modules/doorSys.js
index 04bfaf4..8017e4b 100644
--- a/src/router/modules/doorSys.js
+++ b/src/router/modules/doorSys.js
@@ -1,3 +1,5 @@
+
+
 /* Layout */
 import Layout from '../../views/layout/Layout'
 import OverviewLayout from '../../views/layout/OverviewLayout'
diff --git a/src/views/alarm/alarmList.vue b/src/views/alarm/alarmList.vue
index cdd1454..704f797 100644
--- a/src/views/alarm/alarmList.vue
+++ b/src/views/alarm/alarmList.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -92,6 +92,7 @@
 </template>
 
 <script>
+import { alarmExport } from '@/api/batch'
 import { getAlarmList } from '@/api/alarm'
 import { getRegion, getAreaTypeBySubSystem } from '@/api/area'
 import { getDetailDevice } from '@/api/device'
@@ -110,6 +111,7 @@
         alarmContent: '',
         areaType: '',
         areaId: '',
+        valid: 0,
         startTime: '',
         endTime: '',
         offset: 1,
@@ -183,6 +185,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      alarmExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `报警列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     detailAlarm(row) {
       this.dialogDetailVisible = true
       this.$refs.alarmDetail.initDialog('detail', this.dialogDetailVisible, row)
diff --git a/src/views/alarm/alarmNow.vue b/src/views/alarm/alarmNow.vue
index 7122e83..03bb5ea 100644
--- a/src/views/alarm/alarmNow.vue
+++ b/src/views/alarm/alarmNow.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -93,6 +93,7 @@
 </template>
 
 <script>
+import { alarmExport } from '@/api/batch'
 import { getAlarmNowList } from '@/api/alarm'
 import { getRegion, getAreaTypeBySubSystem } from '@/api/area'
 import { getDetailDevice } from '@/api/device'
@@ -182,6 +183,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      alarmExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `当前报警列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     alarmCancel(row) {
       this.dialogCancelVisible = true
       this.$refs.alarmCancel.initDialog('detail', this.dialogCancelVisible, row)
diff --git a/src/views/area/areaList.vue b/src/views/area/areaList.vue
index d9dddc0..1950028 100644
--- a/src/views/area/areaList.vue
+++ b/src/views/area/areaList.vue
@@ -31,7 +31,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <!--<el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>-->
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
diff --git a/src/views/area/defenceList.vue b/src/views/area/defenceList.vue
index 4230d00..9e2ed68 100644
--- a/src/views/area/defenceList.vue
+++ b/src/views/area/defenceList.vue
@@ -33,7 +33,7 @@
         <el-col :span="12" :offset="6" class="edit_btns">
           <el-button class="edit_btn" size="small">批量导入</el-button>
           <el-button class="edit_btn" size="small">导入模板下载</el-button>
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <!--<el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>-->
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
diff --git a/src/views/car/carList.vue b/src/views/car/carList.vue
index 54a8c57..ceb77ff 100644
--- a/src/views/car/carList.vue
+++ b/src/views/car/carList.vue
@@ -31,9 +31,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">批量导入</el-button>
-          <el-button class="edit_btn" size="small">导入模板下载</el-button>
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
           <el-button v-if="hasPerm('/door/car/add')" class="edit_btn" size="small" @click="add">新增</el-button>
           <!--          <el-button v-if="hasPerm('/door/car/delete')" v-show="false" class="edit_btn" size="small" @click="batchDel">删除</el-button>-->
         </el-col>
@@ -80,6 +78,7 @@
 import CarAdd from '@/views/car/carAdd'
 import { getCarList, deleteCar } from '@/api/car'
 import { getCarProperty } from '@/api/allDict'
+import { carExport } from '@/api/batch'
 
 export default {
   name: 'CarList',
@@ -133,6 +132,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      carExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `车辆列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     // 检查选择情况
     checkSelection() {
       if (this.multipleSelection.length === 0) {
diff --git a/src/views/deviceManage/deviceList.vue b/src/views/deviceManage/deviceList.vue
index f5a7417..5966b45 100644
--- a/src/views/deviceManage/deviceList.vue
+++ b/src/views/deviceManage/deviceList.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border @selection-change="handleSelectionChange">
@@ -89,6 +89,7 @@
 </template>
 
 <script>
+import { deviceExport } from '@/api/batch'
 import { getDeviceList } from '@/api/device'
 import { getDeviceType } from '@/api/allDict'
 import { getAreaTypeBySubSystem } from '@/api/area'
@@ -175,6 +176,31 @@
     this.fetchDeviceType() // 获取设备类别
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      deviceExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `设备列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     initAreaType() {
       this.listQuery.areaType = getAreaTypeBySubSystem(this.$store.getters.currentSystem.code)
     },
diff --git a/src/views/staff/staffList.vue b/src/views/staff/staffList.vue
index 3014740..4a92b0c 100644
--- a/src/views/staff/staffList.vue
+++ b/src/views/staff/staffList.vue
@@ -32,8 +32,19 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
+          <el-upload
+            :limit="1"
+            :show-file-list="false"
+            :http-request="uploadFile"
+            :file-list="fileList"
+            class="edit_btn"
+            action="string"
+            accept=".xls,.xlsx">
+            <el-button class="filter-item" size="small">批量导入</el-button>
+          </el-upload>
+          <download-template :filename="personImpTem" btnname="导入模板下载"/>
           <el-button v-if="hasPerm('/staff/delete')" size="small" class="edit_btn" @click="del">删除</el-button>
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
           <el-button v-if="hasPerm('/staff/add')" class="edit_btn" size="small" @click="add">新增</el-button>
         </el-col>
       </el-row>
@@ -80,11 +91,16 @@
 import StaffDetail from '@/views/staff/staffDetail'
 import { getStaffList, batchDelStaff } from '@/api/staff'
 import { getDeptTreeList } from '@/api/dept'
+import { staffExport, batchImportStaff } from '@/api/batch'
+import DownloadTemplate from '@/components/DownloadTemplate/index'
+
 export default {
   name: 'StaffList',
-  components: { StaffDetail, DeptSelect },
+  components: { StaffDetail, DeptSelect, DownloadTemplate },
   data() {
     return {
+      fileList: [], // 批量导入
+      personImpTem:'personImpTem.xlsx',
       deptList: [],
       listQuery: {
         keywords: '',
@@ -142,6 +158,63 @@
     this.fetchData()
   },
   methods: {
+    // 批量导入
+    uploadFile(param) {
+      // 判断文件大小是否符合要求
+      const _file = param.file
+      const isLt5M = _file.size / 1024 / 1024 < 5
+      if (!isLt5M) {
+        this.$message.error('请上传5M以下的excel文件')
+        return false
+      }
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '导入中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      // 批量导入上传请求
+      batchImportStaff(_file).then(res => {
+        loading.close() // 关闭加载动画
+        if (res.code === 200) {
+          this.$message.success('导入成功')
+          this.fileList = []
+          this.fetchData()
+        } else {
+          this.$message.error(res.message)
+        }
+      }).catch(err => {
+        loading.close()
+        this.$message.error(err.message)
+      })
+      this.fileList = []
+    },
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      staffExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `人员列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     // 检查选择情况
     checkSelection() {
       if (this.multipleSelection.length === 0) {
diff --git a/src/views/statistics/carDuration.vue b/src/views/statistics/carDuration.vue
index 9ab73a8..e4093d5 100644
--- a/src/views/statistics/carDuration.vue
+++ b/src/views/statistics/carDuration.vue
@@ -41,7 +41,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -76,6 +76,7 @@
 import { formatToString } from '@/utils/calendarUtil'
 import { carDurationStatistics } from '@/api/statistics'
 import { getCarType } from '@/api/allDict'
+import { carDurationListExport } from '@/api/batch'
 
 export default {
   name: 'CarDuration',
@@ -144,6 +145,31 @@
     this.fetchData()// 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      carDurationListExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `车辆所处时长统计列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     // 查询数据
     search() {
       this.fetchData(false)
diff --git a/src/views/statistics/inOutCar.vue b/src/views/statistics/inOutCar.vue
index 3126575..9371b0d 100644
--- a/src/views/statistics/inOutCar.vue
+++ b/src/views/statistics/inOutCar.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -80,6 +80,7 @@
 </template>
 
 <script>
+import { visitorCarExport } from '@/api/batch'
 import { formatToString } from '@/utils/calendarUtil'
 import { carInOutRecord } from '@/api/statistics'
 import { getCarType, getInOutType } from '@/api/allDict'
@@ -152,6 +153,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      visitorCarExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `车辆出入列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     // 身份证号加密显示
     encrypIdCardNo(idCard) {
       if (idCard.length > 6) {

diff --git a/src/api/batch.js b/src/api/batch.js
new file mode 100644
index 0000000..2bb662c
--- /dev/null
+++ b/src/api/batch.js
@@ -0,0 +1,114 @@
+import request from '@/utils/request'
+
+export function visitorPersonExport(params) {
+  return request({
+    url: '/visitorPerson/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function alarmExport(params) {
+  return request({
+    url: '/alarm/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function deviceExport(params) {
+  return request({
+    url: '/device/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function personListExport(params) {
+  return request({
+    url: '/statistics/personListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+export function carExport(params) {
+  return request({
+    url: '/car/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+export function carListExport(params) {
+  return request({
+    url: '/statistics/carListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function personDurationListExport(params) {
+  return request({
+    url: '/statistics/personDurationListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function carDurationListExport(params) {
+  return request({
+    url: '/statistics/carDurationListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function staffExport(params) {
+  return request({
+    url: '/staff/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function visitorCarExport(params) {
+  return request({
+    url: '/visitorCar/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function batchImportStaff(fileobj) {
+  const param = new FormData()
+  param.append('fs', fileobj)
+  return request({
+    url: '/staff/imp',
+    method: 'post',
+    headers: { 'Content-Type': 'multipart/form-data' },
+    data: param
+  })
+}
diff --git a/src/components/DownloadTemplate/index.vue b/src/components/DownloadTemplate/index.vue
index 8ded2cd..5e5020f 100644
--- a/src/components/DownloadTemplate/index.vue
+++ b/src/components/DownloadTemplate/index.vue
@@ -15,8 +15,10 @@
   methods: {
     // 下载模板
     downloadTemplate() {
+      console.log('###############################')
       if (this.filename !== '') {
         const filename = this.filename
+        console.log(filename)
         // 全屏加载动画
         const loading = this.$loading({
           lock: true,
diff --git a/src/router/modules/doorSys.js b/src/router/modules/doorSys.js
index 04bfaf4..8017e4b 100644
--- a/src/router/modules/doorSys.js
+++ b/src/router/modules/doorSys.js
@@ -1,3 +1,5 @@
+
+
 /* Layout */
 import Layout from '../../views/layout/Layout'
 import OverviewLayout from '../../views/layout/OverviewLayout'
diff --git a/src/views/alarm/alarmList.vue b/src/views/alarm/alarmList.vue
index cdd1454..704f797 100644
--- a/src/views/alarm/alarmList.vue
+++ b/src/views/alarm/alarmList.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -92,6 +92,7 @@
 </template>
 
 <script>
+import { alarmExport } from '@/api/batch'
 import { getAlarmList } from '@/api/alarm'
 import { getRegion, getAreaTypeBySubSystem } from '@/api/area'
 import { getDetailDevice } from '@/api/device'
@@ -110,6 +111,7 @@
         alarmContent: '',
         areaType: '',
         areaId: '',
+        valid: 0,
         startTime: '',
         endTime: '',
         offset: 1,
@@ -183,6 +185,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      alarmExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `报警列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     detailAlarm(row) {
       this.dialogDetailVisible = true
       this.$refs.alarmDetail.initDialog('detail', this.dialogDetailVisible, row)
diff --git a/src/views/alarm/alarmNow.vue b/src/views/alarm/alarmNow.vue
index 7122e83..03bb5ea 100644
--- a/src/views/alarm/alarmNow.vue
+++ b/src/views/alarm/alarmNow.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -93,6 +93,7 @@
 </template>
 
 <script>
+import { alarmExport } from '@/api/batch'
 import { getAlarmNowList } from '@/api/alarm'
 import { getRegion, getAreaTypeBySubSystem } from '@/api/area'
 import { getDetailDevice } from '@/api/device'
@@ -182,6 +183,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      alarmExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `当前报警列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     alarmCancel(row) {
       this.dialogCancelVisible = true
       this.$refs.alarmCancel.initDialog('detail', this.dialogCancelVisible, row)
diff --git a/src/views/area/areaList.vue b/src/views/area/areaList.vue
index d9dddc0..1950028 100644
--- a/src/views/area/areaList.vue
+++ b/src/views/area/areaList.vue
@@ -31,7 +31,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <!--<el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>-->
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
diff --git a/src/views/area/defenceList.vue b/src/views/area/defenceList.vue
index 4230d00..9e2ed68 100644
--- a/src/views/area/defenceList.vue
+++ b/src/views/area/defenceList.vue
@@ -33,7 +33,7 @@
         <el-col :span="12" :offset="6" class="edit_btns">
           <el-button class="edit_btn" size="small">批量导入</el-button>
           <el-button class="edit_btn" size="small">导入模板下载</el-button>
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <!--<el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>-->
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
diff --git a/src/views/car/carList.vue b/src/views/car/carList.vue
index 54a8c57..ceb77ff 100644
--- a/src/views/car/carList.vue
+++ b/src/views/car/carList.vue
@@ -31,9 +31,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">批量导入</el-button>
-          <el-button class="edit_btn" size="small">导入模板下载</el-button>
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
           <el-button v-if="hasPerm('/door/car/add')" class="edit_btn" size="small" @click="add">新增</el-button>
           <!--          <el-button v-if="hasPerm('/door/car/delete')" v-show="false" class="edit_btn" size="small" @click="batchDel">删除</el-button>-->
         </el-col>
@@ -80,6 +78,7 @@
 import CarAdd from '@/views/car/carAdd'
 import { getCarList, deleteCar } from '@/api/car'
 import { getCarProperty } from '@/api/allDict'
+import { carExport } from '@/api/batch'
 
 export default {
   name: 'CarList',
@@ -133,6 +132,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      carExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `车辆列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     // 检查选择情况
     checkSelection() {
       if (this.multipleSelection.length === 0) {
diff --git a/src/views/deviceManage/deviceList.vue b/src/views/deviceManage/deviceList.vue
index f5a7417..5966b45 100644
--- a/src/views/deviceManage/deviceList.vue
+++ b/src/views/deviceManage/deviceList.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border @selection-change="handleSelectionChange">
@@ -89,6 +89,7 @@
 </template>
 
 <script>
+import { deviceExport } from '@/api/batch'
 import { getDeviceList } from '@/api/device'
 import { getDeviceType } from '@/api/allDict'
 import { getAreaTypeBySubSystem } from '@/api/area'
@@ -175,6 +176,31 @@
     this.fetchDeviceType() // 获取设备类别
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      deviceExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `设备列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     initAreaType() {
       this.listQuery.areaType = getAreaTypeBySubSystem(this.$store.getters.currentSystem.code)
     },
diff --git a/src/views/staff/staffList.vue b/src/views/staff/staffList.vue
index 3014740..4a92b0c 100644
--- a/src/views/staff/staffList.vue
+++ b/src/views/staff/staffList.vue
@@ -32,8 +32,19 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
+          <el-upload
+            :limit="1"
+            :show-file-list="false"
+            :http-request="uploadFile"
+            :file-list="fileList"
+            class="edit_btn"
+            action="string"
+            accept=".xls,.xlsx">
+            <el-button class="filter-item" size="small">批量导入</el-button>
+          </el-upload>
+          <download-template :filename="personImpTem" btnname="导入模板下载"/>
           <el-button v-if="hasPerm('/staff/delete')" size="small" class="edit_btn" @click="del">删除</el-button>
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
           <el-button v-if="hasPerm('/staff/add')" class="edit_btn" size="small" @click="add">新增</el-button>
         </el-col>
       </el-row>
@@ -80,11 +91,16 @@
 import StaffDetail from '@/views/staff/staffDetail'
 import { getStaffList, batchDelStaff } from '@/api/staff'
 import { getDeptTreeList } from '@/api/dept'
+import { staffExport, batchImportStaff } from '@/api/batch'
+import DownloadTemplate from '@/components/DownloadTemplate/index'
+
 export default {
   name: 'StaffList',
-  components: { StaffDetail, DeptSelect },
+  components: { StaffDetail, DeptSelect, DownloadTemplate },
   data() {
     return {
+      fileList: [], // 批量导入
+      personImpTem:'personImpTem.xlsx',
       deptList: [],
       listQuery: {
         keywords: '',
@@ -142,6 +158,63 @@
     this.fetchData()
   },
   methods: {
+    // 批量导入
+    uploadFile(param) {
+      // 判断文件大小是否符合要求
+      const _file = param.file
+      const isLt5M = _file.size / 1024 / 1024 < 5
+      if (!isLt5M) {
+        this.$message.error('请上传5M以下的excel文件')
+        return false
+      }
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '导入中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      // 批量导入上传请求
+      batchImportStaff(_file).then(res => {
+        loading.close() // 关闭加载动画
+        if (res.code === 200) {
+          this.$message.success('导入成功')
+          this.fileList = []
+          this.fetchData()
+        } else {
+          this.$message.error(res.message)
+        }
+      }).catch(err => {
+        loading.close()
+        this.$message.error(err.message)
+      })
+      this.fileList = []
+    },
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      staffExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `人员列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     // 检查选择情况
     checkSelection() {
       if (this.multipleSelection.length === 0) {
diff --git a/src/views/statistics/carDuration.vue b/src/views/statistics/carDuration.vue
index 9ab73a8..e4093d5 100644
--- a/src/views/statistics/carDuration.vue
+++ b/src/views/statistics/carDuration.vue
@@ -41,7 +41,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -76,6 +76,7 @@
 import { formatToString } from '@/utils/calendarUtil'
 import { carDurationStatistics } from '@/api/statistics'
 import { getCarType } from '@/api/allDict'
+import { carDurationListExport } from '@/api/batch'
 
 export default {
   name: 'CarDuration',
@@ -144,6 +145,31 @@
     this.fetchData()// 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      carDurationListExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `车辆所处时长统计列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     // 查询数据
     search() {
       this.fetchData(false)
diff --git a/src/views/statistics/inOutCar.vue b/src/views/statistics/inOutCar.vue
index 3126575..9371b0d 100644
--- a/src/views/statistics/inOutCar.vue
+++ b/src/views/statistics/inOutCar.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -80,6 +80,7 @@
 </template>
 
 <script>
+import { visitorCarExport } from '@/api/batch'
 import { formatToString } from '@/utils/calendarUtil'
 import { carInOutRecord } from '@/api/statistics'
 import { getCarType, getInOutType } from '@/api/allDict'
@@ -152,6 +153,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      visitorCarExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `车辆出入列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     // 身份证号加密显示
     encrypIdCardNo(idCard) {
       if (idCard.length > 6) {
diff --git a/src/views/statistics/inOutPerson.vue b/src/views/statistics/inOutPerson.vue
index 52dffda..6827de3 100644
--- a/src/views/statistics/inOutPerson.vue
+++ b/src/views/statistics/inOutPerson.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -82,6 +82,7 @@
 <script>
 import { formatToString } from '@/utils/calendarUtil'
 import { personInOutRecord } from '@/api/statistics'
+import { personListExport } from '@/api/batch'
 import { getPersonType, getInOutType } from '@/api/allDict'
 
 export default {
@@ -157,6 +158,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      personListExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `人员出入列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     // 身份证号加密显示
     encrypIdCardNo(idCard) {
       if (idCard.length > 6) {

diff --git a/src/api/batch.js b/src/api/batch.js
new file mode 100644
index 0000000..2bb662c
--- /dev/null
+++ b/src/api/batch.js
@@ -0,0 +1,114 @@
+import request from '@/utils/request'
+
+export function visitorPersonExport(params) {
+  return request({
+    url: '/visitorPerson/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function alarmExport(params) {
+  return request({
+    url: '/alarm/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function deviceExport(params) {
+  return request({
+    url: '/device/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function personListExport(params) {
+  return request({
+    url: '/statistics/personListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+export function carExport(params) {
+  return request({
+    url: '/car/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+export function carListExport(params) {
+  return request({
+    url: '/statistics/carListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function personDurationListExport(params) {
+  return request({
+    url: '/statistics/personDurationListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function carDurationListExport(params) {
+  return request({
+    url: '/statistics/carDurationListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function staffExport(params) {
+  return request({
+    url: '/staff/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function visitorCarExport(params) {
+  return request({
+    url: '/visitorCar/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function batchImportStaff(fileobj) {
+  const param = new FormData()
+  param.append('fs', fileobj)
+  return request({
+    url: '/staff/imp',
+    method: 'post',
+    headers: { 'Content-Type': 'multipart/form-data' },
+    data: param
+  })
+}
diff --git a/src/components/DownloadTemplate/index.vue b/src/components/DownloadTemplate/index.vue
index 8ded2cd..5e5020f 100644
--- a/src/components/DownloadTemplate/index.vue
+++ b/src/components/DownloadTemplate/index.vue
@@ -15,8 +15,10 @@
   methods: {
     // 下载模板
     downloadTemplate() {
+      console.log('###############################')
       if (this.filename !== '') {
         const filename = this.filename
+        console.log(filename)
         // 全屏加载动画
         const loading = this.$loading({
           lock: true,
diff --git a/src/router/modules/doorSys.js b/src/router/modules/doorSys.js
index 04bfaf4..8017e4b 100644
--- a/src/router/modules/doorSys.js
+++ b/src/router/modules/doorSys.js
@@ -1,3 +1,5 @@
+
+
 /* Layout */
 import Layout from '../../views/layout/Layout'
 import OverviewLayout from '../../views/layout/OverviewLayout'
diff --git a/src/views/alarm/alarmList.vue b/src/views/alarm/alarmList.vue
index cdd1454..704f797 100644
--- a/src/views/alarm/alarmList.vue
+++ b/src/views/alarm/alarmList.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -92,6 +92,7 @@
 </template>
 
 <script>
+import { alarmExport } from '@/api/batch'
 import { getAlarmList } from '@/api/alarm'
 import { getRegion, getAreaTypeBySubSystem } from '@/api/area'
 import { getDetailDevice } from '@/api/device'
@@ -110,6 +111,7 @@
         alarmContent: '',
         areaType: '',
         areaId: '',
+        valid: 0,
         startTime: '',
         endTime: '',
         offset: 1,
@@ -183,6 +185,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      alarmExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `报警列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     detailAlarm(row) {
       this.dialogDetailVisible = true
       this.$refs.alarmDetail.initDialog('detail', this.dialogDetailVisible, row)
diff --git a/src/views/alarm/alarmNow.vue b/src/views/alarm/alarmNow.vue
index 7122e83..03bb5ea 100644
--- a/src/views/alarm/alarmNow.vue
+++ b/src/views/alarm/alarmNow.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -93,6 +93,7 @@
 </template>
 
 <script>
+import { alarmExport } from '@/api/batch'
 import { getAlarmNowList } from '@/api/alarm'
 import { getRegion, getAreaTypeBySubSystem } from '@/api/area'
 import { getDetailDevice } from '@/api/device'
@@ -182,6 +183,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      alarmExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `当前报警列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     alarmCancel(row) {
       this.dialogCancelVisible = true
       this.$refs.alarmCancel.initDialog('detail', this.dialogCancelVisible, row)
diff --git a/src/views/area/areaList.vue b/src/views/area/areaList.vue
index d9dddc0..1950028 100644
--- a/src/views/area/areaList.vue
+++ b/src/views/area/areaList.vue
@@ -31,7 +31,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <!--<el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>-->
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
diff --git a/src/views/area/defenceList.vue b/src/views/area/defenceList.vue
index 4230d00..9e2ed68 100644
--- a/src/views/area/defenceList.vue
+++ b/src/views/area/defenceList.vue
@@ -33,7 +33,7 @@
         <el-col :span="12" :offset="6" class="edit_btns">
           <el-button class="edit_btn" size="small">批量导入</el-button>
           <el-button class="edit_btn" size="small">导入模板下载</el-button>
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <!--<el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>-->
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
diff --git a/src/views/car/carList.vue b/src/views/car/carList.vue
index 54a8c57..ceb77ff 100644
--- a/src/views/car/carList.vue
+++ b/src/views/car/carList.vue
@@ -31,9 +31,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">批量导入</el-button>
-          <el-button class="edit_btn" size="small">导入模板下载</el-button>
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
           <el-button v-if="hasPerm('/door/car/add')" class="edit_btn" size="small" @click="add">新增</el-button>
           <!--          <el-button v-if="hasPerm('/door/car/delete')" v-show="false" class="edit_btn" size="small" @click="batchDel">删除</el-button>-->
         </el-col>
@@ -80,6 +78,7 @@
 import CarAdd from '@/views/car/carAdd'
 import { getCarList, deleteCar } from '@/api/car'
 import { getCarProperty } from '@/api/allDict'
+import { carExport } from '@/api/batch'
 
 export default {
   name: 'CarList',
@@ -133,6 +132,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      carExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `车辆列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     // 检查选择情况
     checkSelection() {
       if (this.multipleSelection.length === 0) {
diff --git a/src/views/deviceManage/deviceList.vue b/src/views/deviceManage/deviceList.vue
index f5a7417..5966b45 100644
--- a/src/views/deviceManage/deviceList.vue
+++ b/src/views/deviceManage/deviceList.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border @selection-change="handleSelectionChange">
@@ -89,6 +89,7 @@
 </template>
 
 <script>
+import { deviceExport } from '@/api/batch'
 import { getDeviceList } from '@/api/device'
 import { getDeviceType } from '@/api/allDict'
 import { getAreaTypeBySubSystem } from '@/api/area'
@@ -175,6 +176,31 @@
     this.fetchDeviceType() // 获取设备类别
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      deviceExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `设备列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     initAreaType() {
       this.listQuery.areaType = getAreaTypeBySubSystem(this.$store.getters.currentSystem.code)
     },
diff --git a/src/views/staff/staffList.vue b/src/views/staff/staffList.vue
index 3014740..4a92b0c 100644
--- a/src/views/staff/staffList.vue
+++ b/src/views/staff/staffList.vue
@@ -32,8 +32,19 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
+          <el-upload
+            :limit="1"
+            :show-file-list="false"
+            :http-request="uploadFile"
+            :file-list="fileList"
+            class="edit_btn"
+            action="string"
+            accept=".xls,.xlsx">
+            <el-button class="filter-item" size="small">批量导入</el-button>
+          </el-upload>
+          <download-template :filename="personImpTem" btnname="导入模板下载"/>
           <el-button v-if="hasPerm('/staff/delete')" size="small" class="edit_btn" @click="del">删除</el-button>
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
           <el-button v-if="hasPerm('/staff/add')" class="edit_btn" size="small" @click="add">新增</el-button>
         </el-col>
       </el-row>
@@ -80,11 +91,16 @@
 import StaffDetail from '@/views/staff/staffDetail'
 import { getStaffList, batchDelStaff } from '@/api/staff'
 import { getDeptTreeList } from '@/api/dept'
+import { staffExport, batchImportStaff } from '@/api/batch'
+import DownloadTemplate from '@/components/DownloadTemplate/index'
+
 export default {
   name: 'StaffList',
-  components: { StaffDetail, DeptSelect },
+  components: { StaffDetail, DeptSelect, DownloadTemplate },
   data() {
     return {
+      fileList: [], // 批量导入
+      personImpTem:'personImpTem.xlsx',
       deptList: [],
       listQuery: {
         keywords: '',
@@ -142,6 +158,63 @@
     this.fetchData()
   },
   methods: {
+    // 批量导入
+    uploadFile(param) {
+      // 判断文件大小是否符合要求
+      const _file = param.file
+      const isLt5M = _file.size / 1024 / 1024 < 5
+      if (!isLt5M) {
+        this.$message.error('请上传5M以下的excel文件')
+        return false
+      }
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '导入中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      // 批量导入上传请求
+      batchImportStaff(_file).then(res => {
+        loading.close() // 关闭加载动画
+        if (res.code === 200) {
+          this.$message.success('导入成功')
+          this.fileList = []
+          this.fetchData()
+        } else {
+          this.$message.error(res.message)
+        }
+      }).catch(err => {
+        loading.close()
+        this.$message.error(err.message)
+      })
+      this.fileList = []
+    },
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      staffExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `人员列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     // 检查选择情况
     checkSelection() {
       if (this.multipleSelection.length === 0) {
diff --git a/src/views/statistics/carDuration.vue b/src/views/statistics/carDuration.vue
index 9ab73a8..e4093d5 100644
--- a/src/views/statistics/carDuration.vue
+++ b/src/views/statistics/carDuration.vue
@@ -41,7 +41,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -76,6 +76,7 @@
 import { formatToString } from '@/utils/calendarUtil'
 import { carDurationStatistics } from '@/api/statistics'
 import { getCarType } from '@/api/allDict'
+import { carDurationListExport } from '@/api/batch'
 
 export default {
   name: 'CarDuration',
@@ -144,6 +145,31 @@
     this.fetchData()// 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      carDurationListExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `车辆所处时长统计列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     // 查询数据
     search() {
       this.fetchData(false)
diff --git a/src/views/statistics/inOutCar.vue b/src/views/statistics/inOutCar.vue
index 3126575..9371b0d 100644
--- a/src/views/statistics/inOutCar.vue
+++ b/src/views/statistics/inOutCar.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -80,6 +80,7 @@
 </template>
 
 <script>
+import { visitorCarExport } from '@/api/batch'
 import { formatToString } from '@/utils/calendarUtil'
 import { carInOutRecord } from '@/api/statistics'
 import { getCarType, getInOutType } from '@/api/allDict'
@@ -152,6 +153,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      visitorCarExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `车辆出入列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     // 身份证号加密显示
     encrypIdCardNo(idCard) {
       if (idCard.length > 6) {
diff --git a/src/views/statistics/inOutPerson.vue b/src/views/statistics/inOutPerson.vue
index 52dffda..6827de3 100644
--- a/src/views/statistics/inOutPerson.vue
+++ b/src/views/statistics/inOutPerson.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -82,6 +82,7 @@
 <script>
 import { formatToString } from '@/utils/calendarUtil'
 import { personInOutRecord } from '@/api/statistics'
+import { personListExport } from '@/api/batch'
 import { getPersonType, getInOutType } from '@/api/allDict'
 
 export default {
@@ -157,6 +158,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      personListExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `人员出入列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     // 身份证号加密显示
     encrypIdCardNo(idCard) {
       if (idCard.length > 6) {
diff --git a/src/views/statistics/personDuration.vue b/src/views/statistics/personDuration.vue
index ef0f325..063b247 100644
--- a/src/views/statistics/personDuration.vue
+++ b/src/views/statistics/personDuration.vue
@@ -41,7 +41,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -76,6 +76,7 @@
 import { formatToString } from '@/utils/calendarUtil'
 import { personDurationStatistics } from '@/api/statistics'
 import { getPersonType } from '@/api/allDict'
+import { personDurationListExport } from '@/api/batch'
 
 export default {
   name: 'PersonDuration',
@@ -149,6 +150,31 @@
     this.fetchData()// 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      personDurationListExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `人员所处时长统计列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     // 身份证号加密显示
     encrypIdCardNo(idCard) {
       if (idCard.length > 6) {

diff --git a/src/api/batch.js b/src/api/batch.js
new file mode 100644
index 0000000..2bb662c
--- /dev/null
+++ b/src/api/batch.js
@@ -0,0 +1,114 @@
+import request from '@/utils/request'
+
+export function visitorPersonExport(params) {
+  return request({
+    url: '/visitorPerson/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function alarmExport(params) {
+  return request({
+    url: '/alarm/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function deviceExport(params) {
+  return request({
+    url: '/device/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function personListExport(params) {
+  return request({
+    url: '/statistics/personListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+export function carExport(params) {
+  return request({
+    url: '/car/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+export function carListExport(params) {
+  return request({
+    url: '/statistics/carListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function personDurationListExport(params) {
+  return request({
+    url: '/statistics/personDurationListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function carDurationListExport(params) {
+  return request({
+    url: '/statistics/carDurationListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function staffExport(params) {
+  return request({
+    url: '/staff/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function visitorCarExport(params) {
+  return request({
+    url: '/visitorCar/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function batchImportStaff(fileobj) {
+  const param = new FormData()
+  param.append('fs', fileobj)
+  return request({
+    url: '/staff/imp',
+    method: 'post',
+    headers: { 'Content-Type': 'multipart/form-data' },
+    data: param
+  })
+}
diff --git a/src/components/DownloadTemplate/index.vue b/src/components/DownloadTemplate/index.vue
index 8ded2cd..5e5020f 100644
--- a/src/components/DownloadTemplate/index.vue
+++ b/src/components/DownloadTemplate/index.vue
@@ -15,8 +15,10 @@
   methods: {
     // 下载模板
     downloadTemplate() {
+      console.log('###############################')
       if (this.filename !== '') {
         const filename = this.filename
+        console.log(filename)
         // 全屏加载动画
         const loading = this.$loading({
           lock: true,
diff --git a/src/router/modules/doorSys.js b/src/router/modules/doorSys.js
index 04bfaf4..8017e4b 100644
--- a/src/router/modules/doorSys.js
+++ b/src/router/modules/doorSys.js
@@ -1,3 +1,5 @@
+
+
 /* Layout */
 import Layout from '../../views/layout/Layout'
 import OverviewLayout from '../../views/layout/OverviewLayout'
diff --git a/src/views/alarm/alarmList.vue b/src/views/alarm/alarmList.vue
index cdd1454..704f797 100644
--- a/src/views/alarm/alarmList.vue
+++ b/src/views/alarm/alarmList.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -92,6 +92,7 @@
 </template>
 
 <script>
+import { alarmExport } from '@/api/batch'
 import { getAlarmList } from '@/api/alarm'
 import { getRegion, getAreaTypeBySubSystem } from '@/api/area'
 import { getDetailDevice } from '@/api/device'
@@ -110,6 +111,7 @@
         alarmContent: '',
         areaType: '',
         areaId: '',
+        valid: 0,
         startTime: '',
         endTime: '',
         offset: 1,
@@ -183,6 +185,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      alarmExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `报警列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     detailAlarm(row) {
       this.dialogDetailVisible = true
       this.$refs.alarmDetail.initDialog('detail', this.dialogDetailVisible, row)
diff --git a/src/views/alarm/alarmNow.vue b/src/views/alarm/alarmNow.vue
index 7122e83..03bb5ea 100644
--- a/src/views/alarm/alarmNow.vue
+++ b/src/views/alarm/alarmNow.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -93,6 +93,7 @@
 </template>
 
 <script>
+import { alarmExport } from '@/api/batch'
 import { getAlarmNowList } from '@/api/alarm'
 import { getRegion, getAreaTypeBySubSystem } from '@/api/area'
 import { getDetailDevice } from '@/api/device'
@@ -182,6 +183,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      alarmExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `当前报警列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     alarmCancel(row) {
       this.dialogCancelVisible = true
       this.$refs.alarmCancel.initDialog('detail', this.dialogCancelVisible, row)
diff --git a/src/views/area/areaList.vue b/src/views/area/areaList.vue
index d9dddc0..1950028 100644
--- a/src/views/area/areaList.vue
+++ b/src/views/area/areaList.vue
@@ -31,7 +31,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <!--<el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>-->
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
diff --git a/src/views/area/defenceList.vue b/src/views/area/defenceList.vue
index 4230d00..9e2ed68 100644
--- a/src/views/area/defenceList.vue
+++ b/src/views/area/defenceList.vue
@@ -33,7 +33,7 @@
         <el-col :span="12" :offset="6" class="edit_btns">
           <el-button class="edit_btn" size="small">批量导入</el-button>
           <el-button class="edit_btn" size="small">导入模板下载</el-button>
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <!--<el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>-->
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
diff --git a/src/views/car/carList.vue b/src/views/car/carList.vue
index 54a8c57..ceb77ff 100644
--- a/src/views/car/carList.vue
+++ b/src/views/car/carList.vue
@@ -31,9 +31,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">批量导入</el-button>
-          <el-button class="edit_btn" size="small">导入模板下载</el-button>
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
           <el-button v-if="hasPerm('/door/car/add')" class="edit_btn" size="small" @click="add">新增</el-button>
           <!--          <el-button v-if="hasPerm('/door/car/delete')" v-show="false" class="edit_btn" size="small" @click="batchDel">删除</el-button>-->
         </el-col>
@@ -80,6 +78,7 @@
 import CarAdd from '@/views/car/carAdd'
 import { getCarList, deleteCar } from '@/api/car'
 import { getCarProperty } from '@/api/allDict'
+import { carExport } from '@/api/batch'
 
 export default {
   name: 'CarList',
@@ -133,6 +132,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      carExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `车辆列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     // 检查选择情况
     checkSelection() {
       if (this.multipleSelection.length === 0) {
diff --git a/src/views/deviceManage/deviceList.vue b/src/views/deviceManage/deviceList.vue
index f5a7417..5966b45 100644
--- a/src/views/deviceManage/deviceList.vue
+++ b/src/views/deviceManage/deviceList.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border @selection-change="handleSelectionChange">
@@ -89,6 +89,7 @@
 </template>
 
 <script>
+import { deviceExport } from '@/api/batch'
 import { getDeviceList } from '@/api/device'
 import { getDeviceType } from '@/api/allDict'
 import { getAreaTypeBySubSystem } from '@/api/area'
@@ -175,6 +176,31 @@
     this.fetchDeviceType() // 获取设备类别
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      deviceExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `设备列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     initAreaType() {
       this.listQuery.areaType = getAreaTypeBySubSystem(this.$store.getters.currentSystem.code)
     },
diff --git a/src/views/staff/staffList.vue b/src/views/staff/staffList.vue
index 3014740..4a92b0c 100644
--- a/src/views/staff/staffList.vue
+++ b/src/views/staff/staffList.vue
@@ -32,8 +32,19 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
+          <el-upload
+            :limit="1"
+            :show-file-list="false"
+            :http-request="uploadFile"
+            :file-list="fileList"
+            class="edit_btn"
+            action="string"
+            accept=".xls,.xlsx">
+            <el-button class="filter-item" size="small">批量导入</el-button>
+          </el-upload>
+          <download-template :filename="personImpTem" btnname="导入模板下载"/>
           <el-button v-if="hasPerm('/staff/delete')" size="small" class="edit_btn" @click="del">删除</el-button>
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
           <el-button v-if="hasPerm('/staff/add')" class="edit_btn" size="small" @click="add">新增</el-button>
         </el-col>
       </el-row>
@@ -80,11 +91,16 @@
 import StaffDetail from '@/views/staff/staffDetail'
 import { getStaffList, batchDelStaff } from '@/api/staff'
 import { getDeptTreeList } from '@/api/dept'
+import { staffExport, batchImportStaff } from '@/api/batch'
+import DownloadTemplate from '@/components/DownloadTemplate/index'
+
 export default {
   name: 'StaffList',
-  components: { StaffDetail, DeptSelect },
+  components: { StaffDetail, DeptSelect, DownloadTemplate },
   data() {
     return {
+      fileList: [], // 批量导入
+      personImpTem:'personImpTem.xlsx',
       deptList: [],
       listQuery: {
         keywords: '',
@@ -142,6 +158,63 @@
     this.fetchData()
   },
   methods: {
+    // 批量导入
+    uploadFile(param) {
+      // 判断文件大小是否符合要求
+      const _file = param.file
+      const isLt5M = _file.size / 1024 / 1024 < 5
+      if (!isLt5M) {
+        this.$message.error('请上传5M以下的excel文件')
+        return false
+      }
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '导入中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      // 批量导入上传请求
+      batchImportStaff(_file).then(res => {
+        loading.close() // 关闭加载动画
+        if (res.code === 200) {
+          this.$message.success('导入成功')
+          this.fileList = []
+          this.fetchData()
+        } else {
+          this.$message.error(res.message)
+        }
+      }).catch(err => {
+        loading.close()
+        this.$message.error(err.message)
+      })
+      this.fileList = []
+    },
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      staffExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `人员列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     // 检查选择情况
     checkSelection() {
       if (this.multipleSelection.length === 0) {
diff --git a/src/views/statistics/carDuration.vue b/src/views/statistics/carDuration.vue
index 9ab73a8..e4093d5 100644
--- a/src/views/statistics/carDuration.vue
+++ b/src/views/statistics/carDuration.vue
@@ -41,7 +41,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -76,6 +76,7 @@
 import { formatToString } from '@/utils/calendarUtil'
 import { carDurationStatistics } from '@/api/statistics'
 import { getCarType } from '@/api/allDict'
+import { carDurationListExport } from '@/api/batch'
 
 export default {
   name: 'CarDuration',
@@ -144,6 +145,31 @@
     this.fetchData()// 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      carDurationListExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `车辆所处时长统计列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     // 查询数据
     search() {
       this.fetchData(false)
diff --git a/src/views/statistics/inOutCar.vue b/src/views/statistics/inOutCar.vue
index 3126575..9371b0d 100644
--- a/src/views/statistics/inOutCar.vue
+++ b/src/views/statistics/inOutCar.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -80,6 +80,7 @@
 </template>
 
 <script>
+import { visitorCarExport } from '@/api/batch'
 import { formatToString } from '@/utils/calendarUtil'
 import { carInOutRecord } from '@/api/statistics'
 import { getCarType, getInOutType } from '@/api/allDict'
@@ -152,6 +153,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      visitorCarExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `车辆出入列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     // 身份证号加密显示
     encrypIdCardNo(idCard) {
       if (idCard.length > 6) {
diff --git a/src/views/statistics/inOutPerson.vue b/src/views/statistics/inOutPerson.vue
index 52dffda..6827de3 100644
--- a/src/views/statistics/inOutPerson.vue
+++ b/src/views/statistics/inOutPerson.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -82,6 +82,7 @@
 <script>
 import { formatToString } from '@/utils/calendarUtil'
 import { personInOutRecord } from '@/api/statistics'
+import { personListExport } from '@/api/batch'
 import { getPersonType, getInOutType } from '@/api/allDict'
 
 export default {
@@ -157,6 +158,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      personListExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `人员出入列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     // 身份证号加密显示
     encrypIdCardNo(idCard) {
       if (idCard.length > 6) {
diff --git a/src/views/statistics/personDuration.vue b/src/views/statistics/personDuration.vue
index ef0f325..063b247 100644
--- a/src/views/statistics/personDuration.vue
+++ b/src/views/statistics/personDuration.vue
@@ -41,7 +41,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -76,6 +76,7 @@
 import { formatToString } from '@/utils/calendarUtil'
 import { personDurationStatistics } from '@/api/statistics'
 import { getPersonType } from '@/api/allDict'
+import { personDurationListExport } from '@/api/batch'
 
 export default {
   name: 'PersonDuration',
@@ -149,6 +150,31 @@
     this.fetchData()// 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      personDurationListExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `人员所处时长统计列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     // 身份证号加密显示
     encrypIdCardNo(idCard) {
       if (idCard.length > 6) {
diff --git a/src/views/visitor/visitorCarTodayList.vue b/src/views/visitor/visitorCarTodayList.vue
index 77ff55f..f8e00aa 100644
--- a/src/views/visitor/visitorCarTodayList.vue
+++ b/src/views/visitor/visitorCarTodayList.vue
@@ -35,7 +35,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -79,6 +79,7 @@
 <script>
 import VisitorCarDetail from '@/views/visitor/visitorCarDetail'
 import { getVisitorCarList } from '@/api/visitor'
+import { visitorCarExport } from '@/api/batch'
 import { getDate, formatToString } from '@/utils/calendarUtil'
 
 export default {
@@ -170,6 +171,31 @@
     this.fetchData()
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      visitorCarExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `当日来访车辆.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     initTime() {
       this.listQuery.startTime = getDate(0, 'DATE') + ' 00:00:00'
       this.listQuery.endTime = getDate(1, 'DATE') + ' 00:00:00'

diff --git a/src/api/batch.js b/src/api/batch.js
new file mode 100644
index 0000000..2bb662c
--- /dev/null
+++ b/src/api/batch.js
@@ -0,0 +1,114 @@
+import request from '@/utils/request'
+
+export function visitorPersonExport(params) {
+  return request({
+    url: '/visitorPerson/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function alarmExport(params) {
+  return request({
+    url: '/alarm/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function deviceExport(params) {
+  return request({
+    url: '/device/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function personListExport(params) {
+  return request({
+    url: '/statistics/personListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+export function carExport(params) {
+  return request({
+    url: '/car/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+export function carListExport(params) {
+  return request({
+    url: '/statistics/carListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+export function personDurationListExport(params) {
+  return request({
+    url: '/statistics/personDurationListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function carDurationListExport(params) {
+  return request({
+    url: '/statistics/carDurationListExport',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function staffExport(params) {
+  return request({
+    url: '/staff/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function visitorCarExport(params) {
+  return request({
+    url: '/visitorCar/export',
+    method: 'get',
+    timeout: 120000,
+    params,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+
+export function batchImportStaff(fileobj) {
+  const param = new FormData()
+  param.append('fs', fileobj)
+  return request({
+    url: '/staff/imp',
+    method: 'post',
+    headers: { 'Content-Type': 'multipart/form-data' },
+    data: param
+  })
+}
diff --git a/src/components/DownloadTemplate/index.vue b/src/components/DownloadTemplate/index.vue
index 8ded2cd..5e5020f 100644
--- a/src/components/DownloadTemplate/index.vue
+++ b/src/components/DownloadTemplate/index.vue
@@ -15,8 +15,10 @@
   methods: {
     // 下载模板
     downloadTemplate() {
+      console.log('###############################')
       if (this.filename !== '') {
         const filename = this.filename
+        console.log(filename)
         // 全屏加载动画
         const loading = this.$loading({
           lock: true,
diff --git a/src/router/modules/doorSys.js b/src/router/modules/doorSys.js
index 04bfaf4..8017e4b 100644
--- a/src/router/modules/doorSys.js
+++ b/src/router/modules/doorSys.js
@@ -1,3 +1,5 @@
+
+
 /* Layout */
 import Layout from '../../views/layout/Layout'
 import OverviewLayout from '../../views/layout/OverviewLayout'
diff --git a/src/views/alarm/alarmList.vue b/src/views/alarm/alarmList.vue
index cdd1454..704f797 100644
--- a/src/views/alarm/alarmList.vue
+++ b/src/views/alarm/alarmList.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -92,6 +92,7 @@
 </template>
 
 <script>
+import { alarmExport } from '@/api/batch'
 import { getAlarmList } from '@/api/alarm'
 import { getRegion, getAreaTypeBySubSystem } from '@/api/area'
 import { getDetailDevice } from '@/api/device'
@@ -110,6 +111,7 @@
         alarmContent: '',
         areaType: '',
         areaId: '',
+        valid: 0,
         startTime: '',
         endTime: '',
         offset: 1,
@@ -183,6 +185,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      alarmExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `报警列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     detailAlarm(row) {
       this.dialogDetailVisible = true
       this.$refs.alarmDetail.initDialog('detail', this.dialogDetailVisible, row)
diff --git a/src/views/alarm/alarmNow.vue b/src/views/alarm/alarmNow.vue
index 7122e83..03bb5ea 100644
--- a/src/views/alarm/alarmNow.vue
+++ b/src/views/alarm/alarmNow.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -93,6 +93,7 @@
 </template>
 
 <script>
+import { alarmExport } from '@/api/batch'
 import { getAlarmNowList } from '@/api/alarm'
 import { getRegion, getAreaTypeBySubSystem } from '@/api/area'
 import { getDetailDevice } from '@/api/device'
@@ -182,6 +183,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      alarmExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `当前报警列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     alarmCancel(row) {
       this.dialogCancelVisible = true
       this.$refs.alarmCancel.initDialog('detail', this.dialogCancelVisible, row)
diff --git a/src/views/area/areaList.vue b/src/views/area/areaList.vue
index d9dddc0..1950028 100644
--- a/src/views/area/areaList.vue
+++ b/src/views/area/areaList.vue
@@ -31,7 +31,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <!--<el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>-->
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
diff --git a/src/views/area/defenceList.vue b/src/views/area/defenceList.vue
index 4230d00..9e2ed68 100644
--- a/src/views/area/defenceList.vue
+++ b/src/views/area/defenceList.vue
@@ -33,7 +33,7 @@
         <el-col :span="12" :offset="6" class="edit_btns">
           <el-button class="edit_btn" size="small">批量导入</el-button>
           <el-button class="edit_btn" size="small">导入模板下载</el-button>
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <!--<el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>-->
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
diff --git a/src/views/car/carList.vue b/src/views/car/carList.vue
index 54a8c57..ceb77ff 100644
--- a/src/views/car/carList.vue
+++ b/src/views/car/carList.vue
@@ -31,9 +31,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">批量导入</el-button>
-          <el-button class="edit_btn" size="small">导入模板下载</el-button>
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
           <el-button v-if="hasPerm('/door/car/add')" class="edit_btn" size="small" @click="add">新增</el-button>
           <!--          <el-button v-if="hasPerm('/door/car/delete')" v-show="false" class="edit_btn" size="small" @click="batchDel">删除</el-button>-->
         </el-col>
@@ -80,6 +78,7 @@
 import CarAdd from '@/views/car/carAdd'
 import { getCarList, deleteCar } from '@/api/car'
 import { getCarProperty } from '@/api/allDict'
+import { carExport } from '@/api/batch'
 
 export default {
   name: 'CarList',
@@ -133,6 +132,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      carExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `车辆列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     // 检查选择情况
     checkSelection() {
       if (this.multipleSelection.length === 0) {
diff --git a/src/views/deviceManage/deviceList.vue b/src/views/deviceManage/deviceList.vue
index f5a7417..5966b45 100644
--- a/src/views/deviceManage/deviceList.vue
+++ b/src/views/deviceManage/deviceList.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border @selection-change="handleSelectionChange">
@@ -89,6 +89,7 @@
 </template>
 
 <script>
+import { deviceExport } from '@/api/batch'
 import { getDeviceList } from '@/api/device'
 import { getDeviceType } from '@/api/allDict'
 import { getAreaTypeBySubSystem } from '@/api/area'
@@ -175,6 +176,31 @@
     this.fetchDeviceType() // 获取设备类别
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      deviceExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `设备列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     initAreaType() {
       this.listQuery.areaType = getAreaTypeBySubSystem(this.$store.getters.currentSystem.code)
     },
diff --git a/src/views/staff/staffList.vue b/src/views/staff/staffList.vue
index 3014740..4a92b0c 100644
--- a/src/views/staff/staffList.vue
+++ b/src/views/staff/staffList.vue
@@ -32,8 +32,19 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
+          <el-upload
+            :limit="1"
+            :show-file-list="false"
+            :http-request="uploadFile"
+            :file-list="fileList"
+            class="edit_btn"
+            action="string"
+            accept=".xls,.xlsx">
+            <el-button class="filter-item" size="small">批量导入</el-button>
+          </el-upload>
+          <download-template :filename="personImpTem" btnname="导入模板下载"/>
           <el-button v-if="hasPerm('/staff/delete')" size="small" class="edit_btn" @click="del">删除</el-button>
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
           <el-button v-if="hasPerm('/staff/add')" class="edit_btn" size="small" @click="add">新增</el-button>
         </el-col>
       </el-row>
@@ -80,11 +91,16 @@
 import StaffDetail from '@/views/staff/staffDetail'
 import { getStaffList, batchDelStaff } from '@/api/staff'
 import { getDeptTreeList } from '@/api/dept'
+import { staffExport, batchImportStaff } from '@/api/batch'
+import DownloadTemplate from '@/components/DownloadTemplate/index'
+
 export default {
   name: 'StaffList',
-  components: { StaffDetail, DeptSelect },
+  components: { StaffDetail, DeptSelect, DownloadTemplate },
   data() {
     return {
+      fileList: [], // 批量导入
+      personImpTem:'personImpTem.xlsx',
       deptList: [],
       listQuery: {
         keywords: '',
@@ -142,6 +158,63 @@
     this.fetchData()
   },
   methods: {
+    // 批量导入
+    uploadFile(param) {
+      // 判断文件大小是否符合要求
+      const _file = param.file
+      const isLt5M = _file.size / 1024 / 1024 < 5
+      if (!isLt5M) {
+        this.$message.error('请上传5M以下的excel文件')
+        return false
+      }
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '导入中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      // 批量导入上传请求
+      batchImportStaff(_file).then(res => {
+        loading.close() // 关闭加载动画
+        if (res.code === 200) {
+          this.$message.success('导入成功')
+          this.fileList = []
+          this.fetchData()
+        } else {
+          this.$message.error(res.message)
+        }
+      }).catch(err => {
+        loading.close()
+        this.$message.error(err.message)
+      })
+      this.fileList = []
+    },
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      staffExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `人员列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     // 检查选择情况
     checkSelection() {
       if (this.multipleSelection.length === 0) {
diff --git a/src/views/statistics/carDuration.vue b/src/views/statistics/carDuration.vue
index 9ab73a8..e4093d5 100644
--- a/src/views/statistics/carDuration.vue
+++ b/src/views/statistics/carDuration.vue
@@ -41,7 +41,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -76,6 +76,7 @@
 import { formatToString } from '@/utils/calendarUtil'
 import { carDurationStatistics } from '@/api/statistics'
 import { getCarType } from '@/api/allDict'
+import { carDurationListExport } from '@/api/batch'
 
 export default {
   name: 'CarDuration',
@@ -144,6 +145,31 @@
     this.fetchData()// 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      carDurationListExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `车辆所处时长统计列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     // 查询数据
     search() {
       this.fetchData(false)
diff --git a/src/views/statistics/inOutCar.vue b/src/views/statistics/inOutCar.vue
index 3126575..9371b0d 100644
--- a/src/views/statistics/inOutCar.vue
+++ b/src/views/statistics/inOutCar.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -80,6 +80,7 @@
 </template>
 
 <script>
+import { visitorCarExport } from '@/api/batch'
 import { formatToString } from '@/utils/calendarUtil'
 import { carInOutRecord } from '@/api/statistics'
 import { getCarType, getInOutType } from '@/api/allDict'
@@ -152,6 +153,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      visitorCarExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `车辆出入列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     // 身份证号加密显示
     encrypIdCardNo(idCard) {
       if (idCard.length > 6) {
diff --git a/src/views/statistics/inOutPerson.vue b/src/views/statistics/inOutPerson.vue
index 52dffda..6827de3 100644
--- a/src/views/statistics/inOutPerson.vue
+++ b/src/views/statistics/inOutPerson.vue
@@ -48,7 +48,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -82,6 +82,7 @@
 <script>
 import { formatToString } from '@/utils/calendarUtil'
 import { personInOutRecord } from '@/api/statistics'
+import { personListExport } from '@/api/batch'
 import { getPersonType, getInOutType } from '@/api/allDict'
 
 export default {
@@ -157,6 +158,31 @@
     this.fetchData() // 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      personListExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `人员出入列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     // 身份证号加密显示
     encrypIdCardNo(idCard) {
       if (idCard.length > 6) {
diff --git a/src/views/statistics/personDuration.vue b/src/views/statistics/personDuration.vue
index ef0f325..063b247 100644
--- a/src/views/statistics/personDuration.vue
+++ b/src/views/statistics/personDuration.vue
@@ -41,7 +41,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -76,6 +76,7 @@
 import { formatToString } from '@/utils/calendarUtil'
 import { personDurationStatistics } from '@/api/statistics'
 import { getPersonType } from '@/api/allDict'
+import { personDurationListExport } from '@/api/batch'
 
 export default {
   name: 'PersonDuration',
@@ -149,6 +150,31 @@
     this.fetchData()// 获取数据
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      personDurationListExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `人员所处时长统计列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     // 身份证号加密显示
     encrypIdCardNo(idCard) {
       if (idCard.length > 6) {
diff --git a/src/views/visitor/visitorCarTodayList.vue b/src/views/visitor/visitorCarTodayList.vue
index 77ff55f..f8e00aa 100644
--- a/src/views/visitor/visitorCarTodayList.vue
+++ b/src/views/visitor/visitorCarTodayList.vue
@@ -35,7 +35,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -79,6 +79,7 @@
 <script>
 import VisitorCarDetail from '@/views/visitor/visitorCarDetail'
 import { getVisitorCarList } from '@/api/visitor'
+import { visitorCarExport } from '@/api/batch'
 import { getDate, formatToString } from '@/utils/calendarUtil'
 
 export default {
@@ -170,6 +171,31 @@
     this.fetchData()
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      visitorCarExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `当日来访车辆.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     initTime() {
       this.listQuery.startTime = getDate(0, 'DATE') + ' 00:00:00'
       this.listQuery.endTime = getDate(1, 'DATE') + ' 00:00:00'
diff --git a/src/views/visitor/visitorTodayList.vue b/src/views/visitor/visitorTodayList.vue
index 4f10726..26d8da6 100644
--- a/src/views/visitor/visitorTodayList.vue
+++ b/src/views/visitor/visitorTodayList.vue
@@ -35,7 +35,7 @@
       <el-row class="table-title">
         <el-col :span="6"><div class="title-header"><i class="el-icon-menu"/>数据列表</div></el-col>
         <el-col :span="12" :offset="6" class="edit_btns">
-          <el-button class="edit_btn" size="small">导出</el-button>
+          <el-button class="edit_btn" size="small" @click="batchExport">导出</el-button>
         </el-col>
       </el-row>
       <el-table v-loading="listLoading" :data="list" class="table" row-class-name="small-row-class" border>
@@ -76,6 +76,7 @@
 </template>
 
 <script>
+import { visitorPersonExport } from '@/api/batch'
 import { getVisitorList } from '@/api/visitor'
 import { getDate, formatToString } from '@/utils/calendarUtil'
 import VisitorDetail from '@/views/visitor/visitorDetail'
@@ -168,6 +169,31 @@
     this.fetchData()
   },
   methods: {
+    batchExport() {
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '下载中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      visitorPersonExport(this.listQuery).then(res => {
+        loading.close() // 关闭加载动画
+        console.log('download===', res)
+        const blob = new Blob([res.data])
+        const downloadElement = document.createElement('a')
+        const href = window.URL.createObjectURL(blob) // 创建下载的链接
+        downloadElement.href = href
+        downloadElement.download = `当日来访人员列表.xlsx` // 下载后文件名
+        document.body.appendChild(downloadElement)
+        downloadElement.click() // 点击下载
+        document.body.removeChild(downloadElement) // 下载完成移除元素
+        window.URL.revokeObjectURL(href) // 释放blob对象
+      }).catch((res) => {
+        loading.close()
+        this.$message.error(res.message)
+      })
+    },
     initTime() {
       this.listQuery.startTime = getDate(0, 'DATE') + ' 00:00:00'
       this.listQuery.endTime = getDate(1, 'DATE') + ' 00:00:00'