diff --git a/src/api/minipro.js b/src/api/minipro.js
index 77dfb03..dfb1617 100644
--- a/src/api/minipro.js
+++ b/src/api/minipro.js
@@ -4,24 +4,85 @@
 
 // 消息列表
 export function GetMessageList(data) {
+  const {
+    offset,
+    limit
+  } = data
   return request({
     baseURL,
-    url: 'message/messageList',
+    url: `message/messageList?limit=${limit}&offset=${offset}`,
     method: 'post',
     data
   })
 }
 
-// 用户列表
-export function getUserList(data) {
+// 消息导出
+export function messageExport(data) {
   return request({
     baseURL,
-    url: 'user/getUserList',
+    url: '/message/exportList',
+    method: 'post',
+    timeout: 120000,
+    data,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+// 用户列表
+export function getUserList(data) {
+  const {
+    offset,
+    limit
+  } = data
+  return request({
+    baseURL,
+    url: `user/getUserList?limit=${limit}&offset=${offset}`,
     method: 'post',
     data
   })
 }
 
+// 人员导入
+export function batchImportFire(fileobj) {
+  const param = new FormData()
+  param.append('multipartFile', fileobj)
+  return request({
+    baseURL,
+    url: '/user/importList',
+    method: 'post',
+    headers: { 'Content-Type': 'multipart/form-data' },
+    data: param
+  })
+}
+
+// 模板下载
+export function downloadTemplate(fileName) {
+  return request({
+    baseURL,
+    url: '/user/download',
+    method: 'get',
+    params: {
+      filename: 'userModel.xlsx'
+    },
+    headers: {
+      responseType: 'blob'
+    },
+    responseType: 'blob'
+  })
+}
+
+// 访客导出
+export function userExport(data) {
+  return request({
+    baseURL,
+    url: '/user/exportList',
+    method: 'post',
+    timeout: 120000,
+    data,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
 // 新增
 export function addUser(data) {
   return request({
@@ -32,6 +93,16 @@
   })
 }
 
+// 编辑
+export function updateUser(data) {
+  return request({
+    baseURL,
+    url: 'user/updateUser',
+    method: 'post',
+    data
+  })
+}
+
 // 删除
 export function delUser(data) {
   return request({
@@ -42,13 +113,29 @@
   })
 }
 
-
 // 访客列表
 export function getApplyList(data) {
+  const {
+    offset,
+    limit
+  } = data
   return request({
     baseURL,
-    url: 'visitor/getApplyList',
+    url: `visitor/getApplyList?limit=${limit}&offset=${offset}`,
     method: 'post',
     data
   })
 }
+
+// 访客导出
+export function visitorExport(data) {
+  return request({
+    baseURL,
+    url: '/visitor/exportApplyList',
+    method: 'post',
+    timeout: 120000,
+    data,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+

diff --git a/src/api/minipro.js b/src/api/minipro.js
index 77dfb03..dfb1617 100644
--- a/src/api/minipro.js
+++ b/src/api/minipro.js
@@ -4,24 +4,85 @@
 
 // 消息列表
 export function GetMessageList(data) {
+  const {
+    offset,
+    limit
+  } = data
   return request({
     baseURL,
-    url: 'message/messageList',
+    url: `message/messageList?limit=${limit}&offset=${offset}`,
     method: 'post',
     data
   })
 }
 
-// 用户列表
-export function getUserList(data) {
+// 消息导出
+export function messageExport(data) {
   return request({
     baseURL,
-    url: 'user/getUserList',
+    url: '/message/exportList',
+    method: 'post',
+    timeout: 120000,
+    data,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+// 用户列表
+export function getUserList(data) {
+  const {
+    offset,
+    limit
+  } = data
+  return request({
+    baseURL,
+    url: `user/getUserList?limit=${limit}&offset=${offset}`,
     method: 'post',
     data
   })
 }
 
+// 人员导入
+export function batchImportFire(fileobj) {
+  const param = new FormData()
+  param.append('multipartFile', fileobj)
+  return request({
+    baseURL,
+    url: '/user/importList',
+    method: 'post',
+    headers: { 'Content-Type': 'multipart/form-data' },
+    data: param
+  })
+}
+
+// 模板下载
+export function downloadTemplate(fileName) {
+  return request({
+    baseURL,
+    url: '/user/download',
+    method: 'get',
+    params: {
+      filename: 'userModel.xlsx'
+    },
+    headers: {
+      responseType: 'blob'
+    },
+    responseType: 'blob'
+  })
+}
+
+// 访客导出
+export function userExport(data) {
+  return request({
+    baseURL,
+    url: '/user/exportList',
+    method: 'post',
+    timeout: 120000,
+    data,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
 // 新增
 export function addUser(data) {
   return request({
@@ -32,6 +93,16 @@
   })
 }
 
+// 编辑
+export function updateUser(data) {
+  return request({
+    baseURL,
+    url: 'user/updateUser',
+    method: 'post',
+    data
+  })
+}
+
 // 删除
 export function delUser(data) {
   return request({
@@ -42,13 +113,29 @@
   })
 }
 
-
 // 访客列表
 export function getApplyList(data) {
+  const {
+    offset,
+    limit
+  } = data
   return request({
     baseURL,
-    url: 'visitor/getApplyList',
+    url: `visitor/getApplyList?limit=${limit}&offset=${offset}`,
     method: 'post',
     data
   })
 }
+
+// 访客导出
+export function visitorExport(data) {
+  return request({
+    baseURL,
+    url: '/visitor/exportApplyList',
+    method: 'post',
+    timeout: 120000,
+    data,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
diff --git a/src/router/modules/menu0.js b/src/router/modules/menu0.js
index 3a62b17..dc2d4fd 100644
--- a/src/router/modules/menu0.js
+++ b/src/router/modules/menu0.js
@@ -273,37 +273,6 @@
         meta: { title: '能源数据', icon: '', permission: ['/energy/list'] }
       }
     ]
-  },
-  {
-    path: 'backstage',
-    component: Layout,
-    redirect: '/backstage',
-    name: 'Backstage',
-    meta: {
-      title: '',
-      // permission: ['/asset'], // 权限名称
-      icon: 'icon-config' // 图标
-    },
-    children: [
-      {
-        path: '/messageList',
-        name: 'MessageList',
-        component: () => import('@/views/backstage/messageList'),
-        meta: { title: '消息后台', icon: '', permission: [''] }
-      },
-      {
-        path: '/personList',
-        name: 'PersonList',
-        component: () => import('@/views/backstage/personList'),
-        meta: { title: '人员管理后台', icon: '', permission: [''] }
-      },
-      {
-        path: '/visitList',
-        name: 'VisitList',
-        component: () => import('@/views/backstage/visitList'),
-        meta: { title: '访客申请后台', icon: '', permission: [''] }
-      }
-    ]
   }
   // {
   //   path: 'security',

diff --git a/src/api/minipro.js b/src/api/minipro.js
index 77dfb03..dfb1617 100644
--- a/src/api/minipro.js
+++ b/src/api/minipro.js
@@ -4,24 +4,85 @@
 
 // 消息列表
 export function GetMessageList(data) {
+  const {
+    offset,
+    limit
+  } = data
   return request({
     baseURL,
-    url: 'message/messageList',
+    url: `message/messageList?limit=${limit}&offset=${offset}`,
     method: 'post',
     data
   })
 }
 
-// 用户列表
-export function getUserList(data) {
+// 消息导出
+export function messageExport(data) {
   return request({
     baseURL,
-    url: 'user/getUserList',
+    url: '/message/exportList',
+    method: 'post',
+    timeout: 120000,
+    data,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+// 用户列表
+export function getUserList(data) {
+  const {
+    offset,
+    limit
+  } = data
+  return request({
+    baseURL,
+    url: `user/getUserList?limit=${limit}&offset=${offset}`,
     method: 'post',
     data
   })
 }
 
+// 人员导入
+export function batchImportFire(fileobj) {
+  const param = new FormData()
+  param.append('multipartFile', fileobj)
+  return request({
+    baseURL,
+    url: '/user/importList',
+    method: 'post',
+    headers: { 'Content-Type': 'multipart/form-data' },
+    data: param
+  })
+}
+
+// 模板下载
+export function downloadTemplate(fileName) {
+  return request({
+    baseURL,
+    url: '/user/download',
+    method: 'get',
+    params: {
+      filename: 'userModel.xlsx'
+    },
+    headers: {
+      responseType: 'blob'
+    },
+    responseType: 'blob'
+  })
+}
+
+// 访客导出
+export function userExport(data) {
+  return request({
+    baseURL,
+    url: '/user/exportList',
+    method: 'post',
+    timeout: 120000,
+    data,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
 // 新增
 export function addUser(data) {
   return request({
@@ -32,6 +93,16 @@
   })
 }
 
+// 编辑
+export function updateUser(data) {
+  return request({
+    baseURL,
+    url: 'user/updateUser',
+    method: 'post',
+    data
+  })
+}
+
 // 删除
 export function delUser(data) {
   return request({
@@ -42,13 +113,29 @@
   })
 }
 
-
 // 访客列表
 export function getApplyList(data) {
+  const {
+    offset,
+    limit
+  } = data
   return request({
     baseURL,
-    url: 'visitor/getApplyList',
+    url: `visitor/getApplyList?limit=${limit}&offset=${offset}`,
     method: 'post',
     data
   })
 }
+
+// 访客导出
+export function visitorExport(data) {
+  return request({
+    baseURL,
+    url: '/visitor/exportApplyList',
+    method: 'post',
+    timeout: 120000,
+    data,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
diff --git a/src/router/modules/menu0.js b/src/router/modules/menu0.js
index 3a62b17..dc2d4fd 100644
--- a/src/router/modules/menu0.js
+++ b/src/router/modules/menu0.js
@@ -273,37 +273,6 @@
         meta: { title: '能源数据', icon: '', permission: ['/energy/list'] }
       }
     ]
-  },
-  {
-    path: 'backstage',
-    component: Layout,
-    redirect: '/backstage',
-    name: 'Backstage',
-    meta: {
-      title: '',
-      // permission: ['/asset'], // 权限名称
-      icon: 'icon-config' // 图标
-    },
-    children: [
-      {
-        path: '/messageList',
-        name: 'MessageList',
-        component: () => import('@/views/backstage/messageList'),
-        meta: { title: '消息后台', icon: '', permission: [''] }
-      },
-      {
-        path: '/personList',
-        name: 'PersonList',
-        component: () => import('@/views/backstage/personList'),
-        meta: { title: '人员管理后台', icon: '', permission: [''] }
-      },
-      {
-        path: '/visitList',
-        name: 'VisitList',
-        component: () => import('@/views/backstage/visitList'),
-        meta: { title: '访客申请后台', icon: '', permission: [''] }
-      }
-    ]
   }
   // {
   //   path: 'security',
diff --git a/src/views/backstage/messageList.vue b/src/views/backstage/messageList.vue
index 99032bb..8fc86ef 100644
--- a/src/views/backstage/messageList.vue
+++ b/src/views/backstage/messageList.vue
@@ -7,9 +7,8 @@
       size="small"
       search-more-type="default"
       @search="fetchData(false)"
-      @clear="clearInput">
-      <!--一般查询条件-->
-      <!--一般查询条件-->
+      @clear="clearInput"
+    >
       <search-item>
         <el-input v-model.trim="listQuery.id" size="small" placeholder="请输入消息编号" />
       </search-item>
@@ -45,8 +44,8 @@
       </search-item>
       <search-item>
         <el-date-picker
-          style="width:200px"
           v-model="listQuery.createEndTime"
+          style="width:200px"
           type="datetime"
           size="small"
           value-format="yyyy-MM-dd HH:mm:ss"
@@ -65,7 +64,7 @@
       :tools-option="tableOption.toolsOption"
       size="small"
       @change="changePage"
-      @selectionChange="handleSelectionChange">
+    >
       <template slot="btns">
         <el-button size="small" class="edit_btn" icon="el-icon-download" @click="exportFile()">
           导出
@@ -76,9 +75,9 @@
 </template>
 
 <script>
-import { GetMessageList } from '@/api/minipro'
+import { GetMessageList, messageExport } from '@/api/minipro'
 export default {
-  name: 'DeviceList',
+  name: 'MessageList',
   data() {
     return {
       listQuery: {
@@ -96,11 +95,11 @@
       statusList: [
         {
           name: '发送成功',
-          value: '发送成功'
+          value: '0'
         },
         {
           name: '发送失败',
-          value: '发送失败'
+          value: '1'
         }
       ],
       columns: [
@@ -118,13 +117,13 @@
         },
         {
           text: '访客申请状态',
-          value: 'status',
+          value: 'visitorApplyStatus',
           align: 'center',
           width: 100
         },
         {
           text: '发送状态',
-          value: 'visitorApplyStatus',
+          value: 'status',
           align: 'center',
           width: 100
         },
@@ -167,7 +166,7 @@
         toolsOption: {
           selectColumns: false, // 是否需要筛选列
           refresh: false, // 是否需要刷新按钮
-          needCheckBox: true
+          needCheckBox: false
         }
       } // 表格属性
     }
@@ -218,8 +217,30 @@
     },
     // 导出
     exportFile() {
-      if (this.selectList.length === 0) {
-        this.$message.warning('暂未选中数据!')
+      if (this.list.length === 0) {
+        this.$message.warning('暂无数据导出!')
+      } else {
+        const loading = this.$loading({
+          lock: true,
+          text: '数据处理中,请稍后...',
+          spinner: 'el-icon-loading',
+          background: 'rgba(0, 0, 0, 0.7)'
+        })
+        messageExport({ ...this.listQuery }).then(res => {
+          loading.close() // 关闭加载动画
+          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)
+        })
       }
     }
   }

diff --git a/src/api/minipro.js b/src/api/minipro.js
index 77dfb03..dfb1617 100644
--- a/src/api/minipro.js
+++ b/src/api/minipro.js
@@ -4,24 +4,85 @@
 
 // 消息列表
 export function GetMessageList(data) {
+  const {
+    offset,
+    limit
+  } = data
   return request({
     baseURL,
-    url: 'message/messageList',
+    url: `message/messageList?limit=${limit}&offset=${offset}`,
     method: 'post',
     data
   })
 }
 
-// 用户列表
-export function getUserList(data) {
+// 消息导出
+export function messageExport(data) {
   return request({
     baseURL,
-    url: 'user/getUserList',
+    url: '/message/exportList',
+    method: 'post',
+    timeout: 120000,
+    data,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+// 用户列表
+export function getUserList(data) {
+  const {
+    offset,
+    limit
+  } = data
+  return request({
+    baseURL,
+    url: `user/getUserList?limit=${limit}&offset=${offset}`,
     method: 'post',
     data
   })
 }
 
+// 人员导入
+export function batchImportFire(fileobj) {
+  const param = new FormData()
+  param.append('multipartFile', fileobj)
+  return request({
+    baseURL,
+    url: '/user/importList',
+    method: 'post',
+    headers: { 'Content-Type': 'multipart/form-data' },
+    data: param
+  })
+}
+
+// 模板下载
+export function downloadTemplate(fileName) {
+  return request({
+    baseURL,
+    url: '/user/download',
+    method: 'get',
+    params: {
+      filename: 'userModel.xlsx'
+    },
+    headers: {
+      responseType: 'blob'
+    },
+    responseType: 'blob'
+  })
+}
+
+// 访客导出
+export function userExport(data) {
+  return request({
+    baseURL,
+    url: '/user/exportList',
+    method: 'post',
+    timeout: 120000,
+    data,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
 // 新增
 export function addUser(data) {
   return request({
@@ -32,6 +93,16 @@
   })
 }
 
+// 编辑
+export function updateUser(data) {
+  return request({
+    baseURL,
+    url: 'user/updateUser',
+    method: 'post',
+    data
+  })
+}
+
 // 删除
 export function delUser(data) {
   return request({
@@ -42,13 +113,29 @@
   })
 }
 
-
 // 访客列表
 export function getApplyList(data) {
+  const {
+    offset,
+    limit
+  } = data
   return request({
     baseURL,
-    url: 'visitor/getApplyList',
+    url: `visitor/getApplyList?limit=${limit}&offset=${offset}`,
     method: 'post',
     data
   })
 }
+
+// 访客导出
+export function visitorExport(data) {
+  return request({
+    baseURL,
+    url: '/visitor/exportApplyList',
+    method: 'post',
+    timeout: 120000,
+    data,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
diff --git a/src/router/modules/menu0.js b/src/router/modules/menu0.js
index 3a62b17..dc2d4fd 100644
--- a/src/router/modules/menu0.js
+++ b/src/router/modules/menu0.js
@@ -273,37 +273,6 @@
         meta: { title: '能源数据', icon: '', permission: ['/energy/list'] }
       }
     ]
-  },
-  {
-    path: 'backstage',
-    component: Layout,
-    redirect: '/backstage',
-    name: 'Backstage',
-    meta: {
-      title: '',
-      // permission: ['/asset'], // 权限名称
-      icon: 'icon-config' // 图标
-    },
-    children: [
-      {
-        path: '/messageList',
-        name: 'MessageList',
-        component: () => import('@/views/backstage/messageList'),
-        meta: { title: '消息后台', icon: '', permission: [''] }
-      },
-      {
-        path: '/personList',
-        name: 'PersonList',
-        component: () => import('@/views/backstage/personList'),
-        meta: { title: '人员管理后台', icon: '', permission: [''] }
-      },
-      {
-        path: '/visitList',
-        name: 'VisitList',
-        component: () => import('@/views/backstage/visitList'),
-        meta: { title: '访客申请后台', icon: '', permission: [''] }
-      }
-    ]
   }
   // {
   //   path: 'security',
diff --git a/src/views/backstage/messageList.vue b/src/views/backstage/messageList.vue
index 99032bb..8fc86ef 100644
--- a/src/views/backstage/messageList.vue
+++ b/src/views/backstage/messageList.vue
@@ -7,9 +7,8 @@
       size="small"
       search-more-type="default"
       @search="fetchData(false)"
-      @clear="clearInput">
-      <!--一般查询条件-->
-      <!--一般查询条件-->
+      @clear="clearInput"
+    >
       <search-item>
         <el-input v-model.trim="listQuery.id" size="small" placeholder="请输入消息编号" />
       </search-item>
@@ -45,8 +44,8 @@
       </search-item>
       <search-item>
         <el-date-picker
-          style="width:200px"
           v-model="listQuery.createEndTime"
+          style="width:200px"
           type="datetime"
           size="small"
           value-format="yyyy-MM-dd HH:mm:ss"
@@ -65,7 +64,7 @@
       :tools-option="tableOption.toolsOption"
       size="small"
       @change="changePage"
-      @selectionChange="handleSelectionChange">
+    >
       <template slot="btns">
         <el-button size="small" class="edit_btn" icon="el-icon-download" @click="exportFile()">
           导出
@@ -76,9 +75,9 @@
 </template>
 
 <script>
-import { GetMessageList } from '@/api/minipro'
+import { GetMessageList, messageExport } from '@/api/minipro'
 export default {
-  name: 'DeviceList',
+  name: 'MessageList',
   data() {
     return {
       listQuery: {
@@ -96,11 +95,11 @@
       statusList: [
         {
           name: '发送成功',
-          value: '发送成功'
+          value: '0'
         },
         {
           name: '发送失败',
-          value: '发送失败'
+          value: '1'
         }
       ],
       columns: [
@@ -118,13 +117,13 @@
         },
         {
           text: '访客申请状态',
-          value: 'status',
+          value: 'visitorApplyStatus',
           align: 'center',
           width: 100
         },
         {
           text: '发送状态',
-          value: 'visitorApplyStatus',
+          value: 'status',
           align: 'center',
           width: 100
         },
@@ -167,7 +166,7 @@
         toolsOption: {
           selectColumns: false, // 是否需要筛选列
           refresh: false, // 是否需要刷新按钮
-          needCheckBox: true
+          needCheckBox: false
         }
       } // 表格属性
     }
@@ -218,8 +217,30 @@
     },
     // 导出
     exportFile() {
-      if (this.selectList.length === 0) {
-        this.$message.warning('暂未选中数据!')
+      if (this.list.length === 0) {
+        this.$message.warning('暂无数据导出!')
+      } else {
+        const loading = this.$loading({
+          lock: true,
+          text: '数据处理中,请稍后...',
+          spinner: 'el-icon-loading',
+          background: 'rgba(0, 0, 0, 0.7)'
+        })
+        messageExport({ ...this.listQuery }).then(res => {
+          loading.close() // 关闭加载动画
+          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)
+        })
       }
     }
   }
diff --git a/src/views/backstage/personList.vue b/src/views/backstage/personList.vue
index 3e855ed..e9b7b13 100644
--- a/src/views/backstage/personList.vue
+++ b/src/views/backstage/personList.vue
@@ -7,13 +7,13 @@
       size="small"
       search-more-type="default"
       @search="fetchData(false)"
-      @clear="clearInput">
-      <!--一般查询条件-->
+      @clear="clearInput"
+    >
       <search-item>
         <el-input v-model.trim="listQuery.account" size="small" placeholder="请输入员工证件编号" />
       </search-item>
       <search-item>
-        <el-input v-model.trim="listQuery.username" size="small" placeholder="请输入员工姓名" />
+        <el-input v-model.trim="listQuery.name" size="small" placeholder="请输入员工姓名" />
       </search-item>
       <search-item>
         <el-select v-model="listQuery.documentType" size="small" placeholder="请选择证件类型" style="width: 200px" clearable>
@@ -26,7 +26,7 @@
         </el-select>
       </search-item>
       <search-item>
-        <el-input v-model.trim="listQuery.phone" size="small" placeholder="请输入手机号"  />
+        <el-input v-model.trim="listQuery.phone" size="small" placeholder="请输入手机号" />
       </search-item>
       <br>
       <search-item>
@@ -39,8 +39,8 @@
           />
         </el-select>
       </search-item>
-      <search-item label="员工类型" prop="position">
-        <el-select v-model="listQuery.personType" size="small" placeholder="请选择员工类型">
+      <search-item label="员工类型" prop="staffType">
+        <el-select v-model="listQuery.staffType" size="small" placeholder="请选择员工类型" style="width: 190px" clearable>
           <el-option
             v-for="item in personList"
             :key="item.value"
@@ -50,7 +50,7 @@
         </el-select>
       </search-item>
       <search-item>
-        <el-select v-model="listQuery.role" size="small" placeholder="请选择员工角色" style="width: 190px" clearable >
+        <el-select v-model="listQuery.roleName" size="small" placeholder="请选择员工角色" style="width: 190px" clearable >
           <el-option
             v-for="item in roleList"
             :key="item.value"
@@ -71,7 +71,8 @@
       :tools-option="tableOption.toolsOption"
       size="small"
       @change="changePage"
-      @selectionChange="handleSelectionChange">
+      @selectionChange="handleSelectionChange"
+    >
       <template slot="btns">
         <el-button size="small" class="edit_btn" icon="el-icon-edit" @click="add()">
           新增
@@ -82,7 +83,6 @@
         <el-button size="small" class="edit_btn" icon="el-icon-download" style="float:right" @click="exportFile()">
           导出
         </el-button>
-        <download-template :filename="filename" />
         <el-upload
           :limit="1"
           :show-file-list="false"
@@ -101,7 +101,7 @@
         </el-button>
       </template>
       <template slot="columns">
-        <el-table-column label="操作" align="center" width="150">
+        <el-table-column label="操作" align="center" width="80">
           <template slot-scope="scope">
             <el-button type="text" size="small" @click.stop="edit(scope.row)">
               编辑
@@ -113,11 +113,11 @@
     <el-dialog
       :title="`${editStatus ? '编辑' : '添加'}员工`"
       :visible.sync="dialogVisible"
-      width="45%"
+      width="50%"
       append-to-body
       center
       :close-on-click-modal="false"
-      >
+    >
       <el-form ref="ruleForm" :rules="rules" :model="form" label-position="right" label-width="140px">
         <el-row :gutter="20">
           <el-col :span="12">
@@ -148,8 +148,8 @@
             </el-form-item>
           </el-col>
           <el-col :span="12">
-            <el-form-item label="员工类型" prop="personType">
-              <el-select v-model="form.personType" placeholder="必填">
+            <el-form-item label="员工类型" prop="staffType">
+              <el-select v-model="form.staffType" placeholder="必填">
                 <el-option
                   v-for="item in personList"
                   :key="item.value"
@@ -160,12 +160,26 @@
             </el-form-item>
           </el-col>
           <el-col :span="12">
-            <el-form-item label="员工角色" prop="role">
-              <el-radio-group v-model="form.role" style="display:flex;margin-top: 14px;">
-                <el-radio :label="1">管理员</el-radio><br>
-                <el-radio :label="2">普通员工</el-radio>
-                <span class="el-form-item__error" v-show="form.role == 1">具有查看物联网安全监测模块权限</span>
-                <span class="el-form-item__error" v-show="form.role == 2">不具有查看物联网安全监测模块权限</span>
+            <el-form-item label="员工角色" prop="staffRole">
+              <el-radio-group
+                v-model="form.staffRole"
+                style="display:flex;margin-top: 14px;"
+                @change="changeRole"
+              >
+                <el-radio label="1319814546311985641">
+                  管理员
+                </el-radio><br>
+                <el-radio label="1397015476211346433">
+                  普通员工
+                </el-radio>
+                <span
+                  v-show="form.staffRole == '1319814546311985641'"
+                  class="el-form-item__error"
+                >具有查看物联网安全监测模块权限</span>
+                <span
+                  v-show="form.staffRole == '1397015476211346433'"
+                  class="el-form-item__error"
+                >不具有查看物联网安全监测模块权限</span>
               </el-radio-group>
             </el-form-item>
           </el-col>
@@ -173,7 +187,7 @@
         <el-row :gutter="20" style="margin-top:20px">
           <el-col :span="24">
             <el-form-item label="备注">
-              <el-input v-model.trim="form.remarks" :rows="3" type="textarea" placeholder="备注" />
+              <el-input v-model.trim="form.remark" :rows="3" type="textarea" placeholder="备注" />
             </el-form-item>
           </el-col>
         </el-row>
@@ -191,9 +205,9 @@
 </template>
 
 <script>
-import { getUserList, addUser, delUser } from '@/api/minipro'
+import { getUserList, addUser, updateUser, delUser, userExport, downloadTemplate, batchImportFire } from '@/api/minipro'
 export default {
-  name: 'DeviceList',
+  name: 'PersonList',
   data() {
     return {
       editStatus: false,
@@ -204,7 +218,8 @@
         account: '',
         name: '',
         documentType: '',
-        role: '',
+        roleName: '',
+        staffType: '',
         logonState: '',
         offset: 1,
         limit: 20
@@ -212,45 +227,45 @@
       cardTypeList: [
         {
           name: '出入证',
-          value: 0
+          value: '0'
         },
         {
           name: '工作证',
-          value: 1
+          value: '1'
         }
       ],
       statusList: [
         {
           name: '是',
-          value: 1
+          value: 0
         },
         {
           name: '否',
-          value: 0
+          value: 1
         }
       ],
       personList: [
         {
           name: '正式员工',
-          value: '1'
+          value: '1556844891841564673'
         },
         {
-          name: '物业管理员',
-          value: '2'
+          name: '物业人员',
+          value: '1556844890952372225'
         },
         {
           name: '运维人员',
-          value: '3'
+          value: '1556844891459883009'
         }
       ],
       roleList: [
         {
           name: '管理员',
-          value: '1'
+          value: '1319814546311985641'
         },
         {
           name: '普通员工',
-          value: '2'
+          value: '1397015476211346433'
         }
       ],
       columns: [
@@ -286,13 +301,13 @@
         },
         {
           text: '员工类型',
-          value: 'perosnType',
+          value: 'staffType',
           align: 'center',
           width: 150
         },
         {
           text: '员工角色',
-          value: 'perosnType',
+          value: 'roleName',
           align: 'center',
           width: 150
         },
@@ -303,7 +318,6 @@
         }
       ], // 显示列
       filename: '',
-      uploadFile: '',
       fileList: [], // 文件数据
       list: [], // 列表数据
       selectList: [], // 选中的数据
@@ -328,9 +342,9 @@
         name: '',
         documentType: '',
         phone: '',
-        personType: '',
-        role: '',
-        remarks: ''
+        staffType: '',
+        staffRole: '',
+        remark: ''
       },
       rules: {
         account: [
@@ -340,13 +354,13 @@
           { required: true, message: '请输入员工名称', trigger: 'blur' }
         ],
         documentType: [
-          { required: true, message: '请选择证件类型', trigger: 'change' }
+          { required: true, message: '请选择证件类型', trigger: 'blur' }
         ],
-        personType: [
-          { required: true, message: '请选择员工类型', trigger: 'change' }
+        staffType: [
+          { required: true, message: '请选择员工类型', trigger: 'blur' }
         ],
-        role: [
-          { required: true, message: '请选择员工角色', trigger: 'change' }
+        staffRole: [
+          { required: true, message: '请选择员工角色', trigger: 'blur' }
         ]
       }
     }
@@ -376,6 +390,8 @@
         account: '',
         name: '',
         documentType: '',
+        roleName: '',
+        staffType: '',
         logonState: '',
         offset: 1,
         limit: 20
@@ -394,46 +410,86 @@
     },
     // 新增
     add() {
+      if (this.$refs.ruleForm) {
+        this.$nextTick(() => {
+          this.$refs.ruleForm.clearValidate()
+        })
+      }
       this.editStatus = false
       this.dialogVisible = true
+      this.form = {
+        account: '',
+        name: '',
+        documentType: '',
+        phone: '',
+        staffType: '',
+        staffRole: '',
+        remark: ''
+      }
     },
     // 删除
     batchDel() {
       if (this.selectList.length === 0) {
         this.$message.warning('暂未选中数据!')
+      } else {
+        const ids = this.selectList.map((item) => {
+          return item.id
+        })
+        delUser({ ids }).then(res => {
+          if (res.code === 200) {
+            this.$message.success('删除成功!')
+            this.fetchData()
+          }
+        })
       }
-      delUser(this.selectList).then(res => {
-        console.log(res)
-      })
     },
     // 修改
     // eslint-disable-next-line vue/no-dupe-keys
     edit(row) {
+      if (this.$refs.ruleForm) {
+        this.$nextTick(() => {
+          this.$refs.ruleForm.clearValidate()
+        })
+      }
       this.editStatus = true
       this.dialogVisible = true
+      // const roleMap = {
+      //   '普通员工': '1397015476211346433',
+      //   '管理员': '1319814546311985641'
+      // }
       this.form = row
     },
+    changeRole(e) {
+      console.log(e)
+    },
     // 确定
     saveData() {
       this.$refs.ruleForm.validate(valid => {
-        console.log(valid)
         if (valid) {
           if (this.editStatus) {
-            // addUser({ ...this.form }).then(res => {
-            //   console.log(res)
-            // }).catch(err =>{
-            // this.dialogVisible = false
-            // })
+            updateUser({ ...this.form }).then(res => {
+              if (res.code === 200) {
+                this.$message.success('修改成功!')
+                this.dialogVisible = false
+                this.fetchData()
+              }
+            }).catch(_err => {
+              this.dialogVisible = false
+            })
           } else {
             addUser({ ...this.form }).then(res => {
               console.log(res)
               if (res.code === 200) {
-                console.log(200)
+                this.$message.success('新增成功!')
+                this.dialogVisible = false
+                this.fetchData()
               }
             }).catch(_err => {
               this.dialogVisible = false
             })
           }
+        } else {
+          this.$message.warning('请填写完整表单!')
         }
       })
     },
@@ -441,14 +497,87 @@
     cancel() {
       this.dialogVisible = false
     },
+    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)'
+      })
+      // 发起导入请求
+      batchImportFire(_file).then(res => {
+        loading.close() // 关闭加载动画
+        if (res.code === 200) {
+          this.$message.success('导入成功')
+          this.fetchData(false)
+        } else {
+          this.$message.error(res.message)
+        }
+      }).catch(() => {
+        loading.close() // 关闭加载动画
+      })
+      this.fileList = []
+    },
     // 下载模板
     downTemplate() {
-
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '数据处理中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      downloadTemplate().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)
+      })
     },
     // 导出
     exportFile() {
-      if (this.selectList.length === 0) {
-        this.$message.warning('暂未选中数据!')
+      if (this.list.length === 0) {
+        this.$message.warning('暂无数据导出!')
+      } else {
+        const loading = this.$loading({
+          lock: true,
+          text: '数据处理中,请稍后...',
+          spinner: 'el-icon-loading',
+          background: 'rgba(0, 0, 0, 0.7)'
+        })
+        userExport({ ...this.listQuery }).then(res => {
+          loading.close() // 关闭加载动画
+          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)
+        })
       }
     }
   }

diff --git a/src/api/minipro.js b/src/api/minipro.js
index 77dfb03..dfb1617 100644
--- a/src/api/minipro.js
+++ b/src/api/minipro.js
@@ -4,24 +4,85 @@
 
 // 消息列表
 export function GetMessageList(data) {
+  const {
+    offset,
+    limit
+  } = data
   return request({
     baseURL,
-    url: 'message/messageList',
+    url: `message/messageList?limit=${limit}&offset=${offset}`,
     method: 'post',
     data
   })
 }
 
-// 用户列表
-export function getUserList(data) {
+// 消息导出
+export function messageExport(data) {
   return request({
     baseURL,
-    url: 'user/getUserList',
+    url: '/message/exportList',
+    method: 'post',
+    timeout: 120000,
+    data,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
+// 用户列表
+export function getUserList(data) {
+  const {
+    offset,
+    limit
+  } = data
+  return request({
+    baseURL,
+    url: `user/getUserList?limit=${limit}&offset=${offset}`,
     method: 'post',
     data
   })
 }
 
+// 人员导入
+export function batchImportFire(fileobj) {
+  const param = new FormData()
+  param.append('multipartFile', fileobj)
+  return request({
+    baseURL,
+    url: '/user/importList',
+    method: 'post',
+    headers: { 'Content-Type': 'multipart/form-data' },
+    data: param
+  })
+}
+
+// 模板下载
+export function downloadTemplate(fileName) {
+  return request({
+    baseURL,
+    url: '/user/download',
+    method: 'get',
+    params: {
+      filename: 'userModel.xlsx'
+    },
+    headers: {
+      responseType: 'blob'
+    },
+    responseType: 'blob'
+  })
+}
+
+// 访客导出
+export function userExport(data) {
+  return request({
+    baseURL,
+    url: '/user/exportList',
+    method: 'post',
+    timeout: 120000,
+    data,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
 // 新增
 export function addUser(data) {
   return request({
@@ -32,6 +93,16 @@
   })
 }
 
+// 编辑
+export function updateUser(data) {
+  return request({
+    baseURL,
+    url: 'user/updateUser',
+    method: 'post',
+    data
+  })
+}
+
 // 删除
 export function delUser(data) {
   return request({
@@ -42,13 +113,29 @@
   })
 }
 
-
 // 访客列表
 export function getApplyList(data) {
+  const {
+    offset,
+    limit
+  } = data
   return request({
     baseURL,
-    url: 'visitor/getApplyList',
+    url: `visitor/getApplyList?limit=${limit}&offset=${offset}`,
     method: 'post',
     data
   })
 }
+
+// 访客导出
+export function visitorExport(data) {
+  return request({
+    baseURL,
+    url: '/visitor/exportApplyList',
+    method: 'post',
+    timeout: 120000,
+    data,
+    responseType: 'blob' // 这一步也很关键，一定要加上 responseType 值为 blob
+  })
+}
+
diff --git a/src/router/modules/menu0.js b/src/router/modules/menu0.js
index 3a62b17..dc2d4fd 100644
--- a/src/router/modules/menu0.js
+++ b/src/router/modules/menu0.js
@@ -273,37 +273,6 @@
         meta: { title: '能源数据', icon: '', permission: ['/energy/list'] }
       }
     ]
-  },
-  {
-    path: 'backstage',
-    component: Layout,
-    redirect: '/backstage',
-    name: 'Backstage',
-    meta: {
-      title: '',
-      // permission: ['/asset'], // 权限名称
-      icon: 'icon-config' // 图标
-    },
-    children: [
-      {
-        path: '/messageList',
-        name: 'MessageList',
-        component: () => import('@/views/backstage/messageList'),
-        meta: { title: '消息后台', icon: '', permission: [''] }
-      },
-      {
-        path: '/personList',
-        name: 'PersonList',
-        component: () => import('@/views/backstage/personList'),
-        meta: { title: '人员管理后台', icon: '', permission: [''] }
-      },
-      {
-        path: '/visitList',
-        name: 'VisitList',
-        component: () => import('@/views/backstage/visitList'),
-        meta: { title: '访客申请后台', icon: '', permission: [''] }
-      }
-    ]
   }
   // {
   //   path: 'security',
diff --git a/src/views/backstage/messageList.vue b/src/views/backstage/messageList.vue
index 99032bb..8fc86ef 100644
--- a/src/views/backstage/messageList.vue
+++ b/src/views/backstage/messageList.vue
@@ -7,9 +7,8 @@
       size="small"
       search-more-type="default"
       @search="fetchData(false)"
-      @clear="clearInput">
-      <!--一般查询条件-->
-      <!--一般查询条件-->
+      @clear="clearInput"
+    >
       <search-item>
         <el-input v-model.trim="listQuery.id" size="small" placeholder="请输入消息编号" />
       </search-item>
@@ -45,8 +44,8 @@
       </search-item>
       <search-item>
         <el-date-picker
-          style="width:200px"
           v-model="listQuery.createEndTime"
+          style="width:200px"
           type="datetime"
           size="small"
           value-format="yyyy-MM-dd HH:mm:ss"
@@ -65,7 +64,7 @@
       :tools-option="tableOption.toolsOption"
       size="small"
       @change="changePage"
-      @selectionChange="handleSelectionChange">
+    >
       <template slot="btns">
         <el-button size="small" class="edit_btn" icon="el-icon-download" @click="exportFile()">
           导出
@@ -76,9 +75,9 @@
 </template>
 
 <script>
-import { GetMessageList } from '@/api/minipro'
+import { GetMessageList, messageExport } from '@/api/minipro'
 export default {
-  name: 'DeviceList',
+  name: 'MessageList',
   data() {
     return {
       listQuery: {
@@ -96,11 +95,11 @@
       statusList: [
         {
           name: '发送成功',
-          value: '发送成功'
+          value: '0'
         },
         {
           name: '发送失败',
-          value: '发送失败'
+          value: '1'
         }
       ],
       columns: [
@@ -118,13 +117,13 @@
         },
         {
           text: '访客申请状态',
-          value: 'status',
+          value: 'visitorApplyStatus',
           align: 'center',
           width: 100
         },
         {
           text: '发送状态',
-          value: 'visitorApplyStatus',
+          value: 'status',
           align: 'center',
           width: 100
         },
@@ -167,7 +166,7 @@
         toolsOption: {
           selectColumns: false, // 是否需要筛选列
           refresh: false, // 是否需要刷新按钮
-          needCheckBox: true
+          needCheckBox: false
         }
       } // 表格属性
     }
@@ -218,8 +217,30 @@
     },
     // 导出
     exportFile() {
-      if (this.selectList.length === 0) {
-        this.$message.warning('暂未选中数据!')
+      if (this.list.length === 0) {
+        this.$message.warning('暂无数据导出!')
+      } else {
+        const loading = this.$loading({
+          lock: true,
+          text: '数据处理中,请稍后...',
+          spinner: 'el-icon-loading',
+          background: 'rgba(0, 0, 0, 0.7)'
+        })
+        messageExport({ ...this.listQuery }).then(res => {
+          loading.close() // 关闭加载动画
+          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)
+        })
       }
     }
   }
diff --git a/src/views/backstage/personList.vue b/src/views/backstage/personList.vue
index 3e855ed..e9b7b13 100644
--- a/src/views/backstage/personList.vue
+++ b/src/views/backstage/personList.vue
@@ -7,13 +7,13 @@
       size="small"
       search-more-type="default"
       @search="fetchData(false)"
-      @clear="clearInput">
-      <!--一般查询条件-->
+      @clear="clearInput"
+    >
       <search-item>
         <el-input v-model.trim="listQuery.account" size="small" placeholder="请输入员工证件编号" />
       </search-item>
       <search-item>
-        <el-input v-model.trim="listQuery.username" size="small" placeholder="请输入员工姓名" />
+        <el-input v-model.trim="listQuery.name" size="small" placeholder="请输入员工姓名" />
       </search-item>
       <search-item>
         <el-select v-model="listQuery.documentType" size="small" placeholder="请选择证件类型" style="width: 200px" clearable>
@@ -26,7 +26,7 @@
         </el-select>
       </search-item>
       <search-item>
-        <el-input v-model.trim="listQuery.phone" size="small" placeholder="请输入手机号"  />
+        <el-input v-model.trim="listQuery.phone" size="small" placeholder="请输入手机号" />
       </search-item>
       <br>
       <search-item>
@@ -39,8 +39,8 @@
           />
         </el-select>
       </search-item>
-      <search-item label="员工类型" prop="position">
-        <el-select v-model="listQuery.personType" size="small" placeholder="请选择员工类型">
+      <search-item label="员工类型" prop="staffType">
+        <el-select v-model="listQuery.staffType" size="small" placeholder="请选择员工类型" style="width: 190px" clearable>
           <el-option
             v-for="item in personList"
             :key="item.value"
@@ -50,7 +50,7 @@
         </el-select>
       </search-item>
       <search-item>
-        <el-select v-model="listQuery.role" size="small" placeholder="请选择员工角色" style="width: 190px" clearable >
+        <el-select v-model="listQuery.roleName" size="small" placeholder="请选择员工角色" style="width: 190px" clearable >
           <el-option
             v-for="item in roleList"
             :key="item.value"
@@ -71,7 +71,8 @@
       :tools-option="tableOption.toolsOption"
       size="small"
       @change="changePage"
-      @selectionChange="handleSelectionChange">
+      @selectionChange="handleSelectionChange"
+    >
       <template slot="btns">
         <el-button size="small" class="edit_btn" icon="el-icon-edit" @click="add()">
           新增
@@ -82,7 +83,6 @@
         <el-button size="small" class="edit_btn" icon="el-icon-download" style="float:right" @click="exportFile()">
           导出
         </el-button>
-        <download-template :filename="filename" />
         <el-upload
           :limit="1"
           :show-file-list="false"
@@ -101,7 +101,7 @@
         </el-button>
       </template>
       <template slot="columns">
-        <el-table-column label="操作" align="center" width="150">
+        <el-table-column label="操作" align="center" width="80">
           <template slot-scope="scope">
             <el-button type="text" size="small" @click.stop="edit(scope.row)">
               编辑
@@ -113,11 +113,11 @@
     <el-dialog
       :title="`${editStatus ? '编辑' : '添加'}员工`"
       :visible.sync="dialogVisible"
-      width="45%"
+      width="50%"
       append-to-body
       center
       :close-on-click-modal="false"
-      >
+    >
       <el-form ref="ruleForm" :rules="rules" :model="form" label-position="right" label-width="140px">
         <el-row :gutter="20">
           <el-col :span="12">
@@ -148,8 +148,8 @@
             </el-form-item>
           </el-col>
           <el-col :span="12">
-            <el-form-item label="员工类型" prop="personType">
-              <el-select v-model="form.personType" placeholder="必填">
+            <el-form-item label="员工类型" prop="staffType">
+              <el-select v-model="form.staffType" placeholder="必填">
                 <el-option
                   v-for="item in personList"
                   :key="item.value"
@@ -160,12 +160,26 @@
             </el-form-item>
           </el-col>
           <el-col :span="12">
-            <el-form-item label="员工角色" prop="role">
-              <el-radio-group v-model="form.role" style="display:flex;margin-top: 14px;">
-                <el-radio :label="1">管理员</el-radio><br>
-                <el-radio :label="2">普通员工</el-radio>
-                <span class="el-form-item__error" v-show="form.role == 1">具有查看物联网安全监测模块权限</span>
-                <span class="el-form-item__error" v-show="form.role == 2">不具有查看物联网安全监测模块权限</span>
+            <el-form-item label="员工角色" prop="staffRole">
+              <el-radio-group
+                v-model="form.staffRole"
+                style="display:flex;margin-top: 14px;"
+                @change="changeRole"
+              >
+                <el-radio label="1319814546311985641">
+                  管理员
+                </el-radio><br>
+                <el-radio label="1397015476211346433">
+                  普通员工
+                </el-radio>
+                <span
+                  v-show="form.staffRole == '1319814546311985641'"
+                  class="el-form-item__error"
+                >具有查看物联网安全监测模块权限</span>
+                <span
+                  v-show="form.staffRole == '1397015476211346433'"
+                  class="el-form-item__error"
+                >不具有查看物联网安全监测模块权限</span>
               </el-radio-group>
             </el-form-item>
           </el-col>
@@ -173,7 +187,7 @@
         <el-row :gutter="20" style="margin-top:20px">
           <el-col :span="24">
             <el-form-item label="备注">
-              <el-input v-model.trim="form.remarks" :rows="3" type="textarea" placeholder="备注" />
+              <el-input v-model.trim="form.remark" :rows="3" type="textarea" placeholder="备注" />
             </el-form-item>
           </el-col>
         </el-row>
@@ -191,9 +205,9 @@
 </template>
 
 <script>
-import { getUserList, addUser, delUser } from '@/api/minipro'
+import { getUserList, addUser, updateUser, delUser, userExport, downloadTemplate, batchImportFire } from '@/api/minipro'
 export default {
-  name: 'DeviceList',
+  name: 'PersonList',
   data() {
     return {
       editStatus: false,
@@ -204,7 +218,8 @@
         account: '',
         name: '',
         documentType: '',
-        role: '',
+        roleName: '',
+        staffType: '',
         logonState: '',
         offset: 1,
         limit: 20
@@ -212,45 +227,45 @@
       cardTypeList: [
         {
           name: '出入证',
-          value: 0
+          value: '0'
         },
         {
           name: '工作证',
-          value: 1
+          value: '1'
         }
       ],
       statusList: [
         {
           name: '是',
-          value: 1
+          value: 0
         },
         {
           name: '否',
-          value: 0
+          value: 1
         }
       ],
       personList: [
         {
           name: '正式员工',
-          value: '1'
+          value: '1556844891841564673'
         },
         {
-          name: '物业管理员',
-          value: '2'
+          name: '物业人员',
+          value: '1556844890952372225'
         },
         {
           name: '运维人员',
-          value: '3'
+          value: '1556844891459883009'
         }
       ],
       roleList: [
         {
           name: '管理员',
-          value: '1'
+          value: '1319814546311985641'
         },
         {
           name: '普通员工',
-          value: '2'
+          value: '1397015476211346433'
         }
       ],
       columns: [
@@ -286,13 +301,13 @@
         },
         {
           text: '员工类型',
-          value: 'perosnType',
+          value: 'staffType',
           align: 'center',
           width: 150
         },
         {
           text: '员工角色',
-          value: 'perosnType',
+          value: 'roleName',
           align: 'center',
           width: 150
         },
@@ -303,7 +318,6 @@
         }
       ], // 显示列
       filename: '',
-      uploadFile: '',
       fileList: [], // 文件数据
       list: [], // 列表数据
       selectList: [], // 选中的数据
@@ -328,9 +342,9 @@
         name: '',
         documentType: '',
         phone: '',
-        personType: '',
-        role: '',
-        remarks: ''
+        staffType: '',
+        staffRole: '',
+        remark: ''
       },
       rules: {
         account: [
@@ -340,13 +354,13 @@
           { required: true, message: '请输入员工名称', trigger: 'blur' }
         ],
         documentType: [
-          { required: true, message: '请选择证件类型', trigger: 'change' }
+          { required: true, message: '请选择证件类型', trigger: 'blur' }
         ],
-        personType: [
-          { required: true, message: '请选择员工类型', trigger: 'change' }
+        staffType: [
+          { required: true, message: '请选择员工类型', trigger: 'blur' }
         ],
-        role: [
-          { required: true, message: '请选择员工角色', trigger: 'change' }
+        staffRole: [
+          { required: true, message: '请选择员工角色', trigger: 'blur' }
         ]
       }
     }
@@ -376,6 +390,8 @@
         account: '',
         name: '',
         documentType: '',
+        roleName: '',
+        staffType: '',
         logonState: '',
         offset: 1,
         limit: 20
@@ -394,46 +410,86 @@
     },
     // 新增
     add() {
+      if (this.$refs.ruleForm) {
+        this.$nextTick(() => {
+          this.$refs.ruleForm.clearValidate()
+        })
+      }
       this.editStatus = false
       this.dialogVisible = true
+      this.form = {
+        account: '',
+        name: '',
+        documentType: '',
+        phone: '',
+        staffType: '',
+        staffRole: '',
+        remark: ''
+      }
     },
     // 删除
     batchDel() {
       if (this.selectList.length === 0) {
         this.$message.warning('暂未选中数据!')
+      } else {
+        const ids = this.selectList.map((item) => {
+          return item.id
+        })
+        delUser({ ids }).then(res => {
+          if (res.code === 200) {
+            this.$message.success('删除成功!')
+            this.fetchData()
+          }
+        })
       }
-      delUser(this.selectList).then(res => {
-        console.log(res)
-      })
     },
     // 修改
     // eslint-disable-next-line vue/no-dupe-keys
     edit(row) {
+      if (this.$refs.ruleForm) {
+        this.$nextTick(() => {
+          this.$refs.ruleForm.clearValidate()
+        })
+      }
       this.editStatus = true
       this.dialogVisible = true
+      // const roleMap = {
+      //   '普通员工': '1397015476211346433',
+      //   '管理员': '1319814546311985641'
+      // }
       this.form = row
     },
+    changeRole(e) {
+      console.log(e)
+    },
     // 确定
     saveData() {
       this.$refs.ruleForm.validate(valid => {
-        console.log(valid)
         if (valid) {
           if (this.editStatus) {
-            // addUser({ ...this.form }).then(res => {
-            //   console.log(res)
-            // }).catch(err =>{
-            // this.dialogVisible = false
-            // })
+            updateUser({ ...this.form }).then(res => {
+              if (res.code === 200) {
+                this.$message.success('修改成功!')
+                this.dialogVisible = false
+                this.fetchData()
+              }
+            }).catch(_err => {
+              this.dialogVisible = false
+            })
           } else {
             addUser({ ...this.form }).then(res => {
               console.log(res)
               if (res.code === 200) {
-                console.log(200)
+                this.$message.success('新增成功!')
+                this.dialogVisible = false
+                this.fetchData()
               }
             }).catch(_err => {
               this.dialogVisible = false
             })
           }
+        } else {
+          this.$message.warning('请填写完整表单!')
         }
       })
     },
@@ -441,14 +497,87 @@
     cancel() {
       this.dialogVisible = false
     },
+    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)'
+      })
+      // 发起导入请求
+      batchImportFire(_file).then(res => {
+        loading.close() // 关闭加载动画
+        if (res.code === 200) {
+          this.$message.success('导入成功')
+          this.fetchData(false)
+        } else {
+          this.$message.error(res.message)
+        }
+      }).catch(() => {
+        loading.close() // 关闭加载动画
+      })
+      this.fileList = []
+    },
     // 下载模板
     downTemplate() {
-
+      // 全屏加载动画
+      const loading = this.$loading({
+        lock: true,
+        text: '数据处理中,请稍后...',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.7)'
+      })
+      downloadTemplate().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)
+      })
     },
     // 导出
     exportFile() {
-      if (this.selectList.length === 0) {
-        this.$message.warning('暂未选中数据!')
+      if (this.list.length === 0) {
+        this.$message.warning('暂无数据导出!')
+      } else {
+        const loading = this.$loading({
+          lock: true,
+          text: '数据处理中,请稍后...',
+          spinner: 'el-icon-loading',
+          background: 'rgba(0, 0, 0, 0.7)'
+        })
+        userExport({ ...this.listQuery }).then(res => {
+          loading.close() // 关闭加载动画
+          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)
+        })
       }
     }
   }
diff --git a/src/views/backstage/visitList.vue b/src/views/backstage/visitList.vue
index 5e94df8..1739d7b 100644
--- a/src/views/backstage/visitList.vue
+++ b/src/views/backstage/visitList.vue
@@ -7,7 +7,8 @@
       size="small"
       search-more-type="default"
       @search="fetchData(false)"
-      @clear="clearInput">
+      @clear="clearInput"
+    >
       <search-item>
         <el-input v-model.trim="listQuery.applyNo" size="small" placeholder="申请单号" />
       </search-item>
@@ -17,45 +18,39 @@
       <search-item>
         <el-select v-model="listQuery.visitReason" size="small" placeholder="访问目的" style="width: 190px" clearable>
           <el-option
-            v-for="item in statusList"
+            v-for="item in visitReasonList"
             :key="item.value"
             :label="item.name"
-            :value="item.value"
+            :value="item.name"
           />
         </el-select>
       </search-item>
       <search-item>
         <el-select v-model="listQuery.visitPosition" size="small" placeholder="访问楼栋" style="width: 190px" clearable>
           <el-option
-            v-for="item in statusList"
+            v-for="item in positionList"
             :key="item.value"
             :label="item.name"
-            :value="item.value"
+            :value="item.name"
           />
         </el-select>
       </search-item>
       <search-item>
         <el-date-picker
           v-model="listQuery.timeRange"
-          type="datetimerange"
+          type="daterange"
           value-format="yyyy-MM-dd"
-          placeholder="访问日期"
+          placeholder="访问日期1"
           size="small"
           @change="handleTimeRange"
         />
       </search-item>
-      <br/>
+      <br>
       <search-item>
         <el-input v-model.trim="listQuery.staffCode" size="small" placeholder="请输入申请者证件编号" />
       </search-item>
       <search-item>
-        <el-input v-model.trim="listQuery.staffName" size="small" placeholder="请输入申请人姓名" />
-      </search-item>
-      <search-item>
-        <el-input v-model.trim="listQuery.user" size="small" placeholder="请输入处理人证件编号" />
-      </search-item>
-      <search-item>
-        <el-input v-model.trim="listQuery.user" size="small" placeholder="请输入处理人姓名" />
+        <el-input v-model.trim="listQuery.staffName" size="small" placeholder="请输入申请者姓名" />
       </search-item>
     </search-area>
     <normal-table
@@ -69,7 +64,7 @@
       :tools-option="tableOption.toolsOption"
       size="small"
       @change="changePage"
-      @selectionChange="handleSelectionChange">
+    >
       <template slot="btns">
         <el-button size="small" class="edit_btn" icon="el-icon-download" @click="exportFile()">
           导出
@@ -80,9 +75,9 @@
 </template>
 
 <script>
-import { getApplyList } from '@/api/minipro'
+import { getApplyList, visitorExport } from '@/api/minipro'
 export default {
-  name: 'DeviceList',
+  name: 'VisitList',
   data() {
     return {
       listQuery: {
@@ -98,24 +93,74 @@
         offset: 1,
         limit: 20
       }, // 筛选条件
-      statusList: [
+      visitReasonList: [
+        {
+          name: '商务会议',
+          value: '1556848929681248258'
+        },
+        {
+          name: '安装维修',
+          value: '1556848930381697025'
+        },
+        {
+          name: '商务洽谈',
+          value: '1556848930889207809'
+        },
+        {
+          name: '节目参演',
+          value: '1592417639036743683'
+        },
+        {
+          name: '会议拜访',
+          value: '1592417639036743684'
+        },
+        {
+          name: '工程维保',
+          value: '1592417639036743685'
+        },
+        {
+          name: '其他事宜',
+          value: '1592417639036743686'
+        }
+      ],
+      positionList: [
+        {
+          name: '一期主楼',
+          value: '1556848151176482817'
+        },
+        {
+          name: '二期主楼',
+          value: '1556848151621079042'
+        },
+        {
+          name: '	录制楼',
+          value: '1556848152069869569'
+        },
+        {
+          name: '演播厅',
+          value: '15568481526444892171600'
+        },
+        {
+          name: '大院工作区',
+          value: '1556848152963256321'
+        }
       ],
       columns: [
         {
           text: '申请单号',
           value: 'applyNo',
           align: 'center',
-          width: 100
+          width: 150
         },
         {
           text: '访客姓名',
           value: 'visitorName',
           align: 'center',
-          width: 80
+          width: 120
         },
         {
           text: '访客身份证',
-          value: 'visitorIdCard	',
+          value: 'visitorIdCard',
           align: 'center',
           width: 150
         },
@@ -129,13 +174,13 @@
           text: '访问目的',
           value: 'visitReason',
           align: 'center',
-          width: 90
+          width: 100
         },
         {
           text: '访问楼栋',
           value: 'visitPosition',
           align: 'center',
-          width: 90
+          width: 100
         },
         {
           text: '访问时间',
@@ -153,45 +198,26 @@
           text: '申请者姓名',
           value: 'staffName',
           align: 'center',
-          width: 100
+          width: 120
         },
         {
           text: '申请者联系方式',
-          value: 'visitorPhone',
+          value: 'staffPhone',
           align: 'center',
           width: 120
         },
         {
           text: '备注',
           value: 'remarks',
-          align: 'center',
-          width: 200
+          align: 'center'
         },
         {
           text: '申请状态',
-          value: 'status',
-          align: 'center',
-          width: 80
-        },
-        {
-          text: '处理人证件编号',
-          value: 'installTime',
-          align: 'center',
-          width: 140
-        },
-        {
-          text: '处理人姓名',
-          value: 'installTime',
+          value: 'visitorApplyStatus',
           align: 'center',
           width: 100
-        },
-        {
-          text: '处理时间',
-          value: 'installTime',
-          align: 'center',
-          width: 150
         }
-      ], // 显示列
+      ],
       list: [], // 列表数据
       selectList: [], // 选中的数
       total: 0, // 数据总数
@@ -207,7 +233,7 @@
         toolsOption: {
           selectColumns: false, // 是否需要筛选列
           refresh: false, // 是否需要刷新按钮
-          needCheckBox: true
+          needCheckBox: false
         }
       } // 表格属性
     }
@@ -222,8 +248,8 @@
       getApplyList({ ...this.listQuery }).then(res => {
         this.listLoading = false
         if (res.code === 200) {
-          this.list = res.data.rows
-          this.total = res.data.total
+          this.list = res.data.records
+          this.total = parseInt(res.data.total)
         }
       }).catch(err => {
         console.log(err)
@@ -259,14 +285,32 @@
       this.listQuery.limit = size || this.listQuery.limit
       this.fetchData()
     },
-    handleSelectionChange(select) {
-      this.selectList = select
-      console.log(this.selectList)
-    },
-    // 导出
+    // 导出 visitorExport
     exportFile() {
-      if (this.selectList.length === 0) {
-        this.$message.warning('暂未选中数据!')
+      if (this.list.length === 0) {
+        this.$message.warning('暂无数据导出!')
+      } else {
+        const loading = this.$loading({
+          lock: true,
+          text: '数据处理中,请稍后...',
+          spinner: 'el-icon-loading',
+          background: 'rgba(0, 0, 0, 0.7)'
+        })
+        visitorExport({ ...this.listQuery }).then(res => {
+          loading.close() // 关闭加载动画
+          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)
+        })
       }
     }
   }