diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/UserActionMapper.java b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/UserActionMapper.java
index 31f7534..6a293d2 100644
--- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/UserActionMapper.java
+++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/UserActionMapper.java
@@ -30,7 +30,5 @@
 
     List<String> getPropertyManager();
 
-    List<VisitorApply> selectApplyList(@Param("request") VisitorApplyListRequest request);
 
-    List<HashMap<String, Object>> getMessageList(@Param("openid") String openid);
 }

diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/UserActionMapper.java b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/UserActionMapper.java
index 31f7534..6a293d2 100644
--- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/UserActionMapper.java
+++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/UserActionMapper.java
@@ -30,7 +30,5 @@
 
     List<String> getPropertyManager();
 
-    List<VisitorApply> selectApplyList(@Param("request") VisitorApplyListRequest request);
 
-    List<HashMap<String, Object>> getMessageList(@Param("openid") String openid);
 }
diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/VisitorApplyMapper.java b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/VisitorApplyMapper.java
index 0f66d88..197e81c 100644
--- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/VisitorApplyMapper.java
+++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/VisitorApplyMapper.java
@@ -18,4 +18,8 @@
 
 public interface VisitorApplyMapper extends BaseMapper<VisitorApply> {
 
+    List<VisitorApply> selectApplyList(@Param("request") VisitorApplyListRequest request);
+
+    List<HashMap<String, Object>> getMessageList(@Param("openid") String openid);
+
 }

diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/UserActionMapper.java b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/UserActionMapper.java
index 31f7534..6a293d2 100644
--- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/UserActionMapper.java
+++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/UserActionMapper.java
@@ -30,7 +30,5 @@
 
     List<String> getPropertyManager();
 
-    List<VisitorApply> selectApplyList(@Param("request") VisitorApplyListRequest request);
 
-    List<HashMap<String, Object>> getMessageList(@Param("openid") String openid);
 }
diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/VisitorApplyMapper.java b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/VisitorApplyMapper.java
index 0f66d88..197e81c 100644
--- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/VisitorApplyMapper.java
+++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/VisitorApplyMapper.java
@@ -18,4 +18,8 @@
 
 public interface VisitorApplyMapper extends BaseMapper<VisitorApply> {
 
+    List<VisitorApply> selectApplyList(@Param("request") VisitorApplyListRequest request);
+
+    List<HashMap<String, Object>> getMessageList(@Param("openid") String openid);
+
 }
diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/service/impl/VisitorApplyServiceImpl.java b/casic-server/src/main/java/com/casic/missiles/modular/system/service/impl/VisitorApplyServiceImpl.java
index ec16d89..2e18abf 100644
--- a/casic-server/src/main/java/com/casic/missiles/modular/system/service/impl/VisitorApplyServiceImpl.java
+++ b/casic-server/src/main/java/com/casic/missiles/modular/system/service/impl/VisitorApplyServiceImpl.java
@@ -93,7 +93,7 @@
         if(null == jsonObject){
             return ResponseData.error(2401,Status.TOKEN_EXPIRES);
         }
-        List<VisitorApply> list = userActionMapper.selectApplyList(visitorApplyListRequest);
+        List<VisitorApply> list = visitorApplyMapper.selectApplyList(visitorApplyListRequest);
         if(CollectionUtils.isEmpty(list)){
             return ResponseData.success(new ArrayList<>());
         }
@@ -145,7 +145,7 @@
                 return ResponseData.error(2401,Status.TOKEN_EXPIRES);
             }
             String openid = jsonObject.get("openid").toString();
-            List<HashMap<String,Object>> resMap =  userActionMapper.getMessageList(openid);
+            List<HashMap<String,Object>> resMap =  visitorApplyMapper.getMessageList(openid);
             for (HashMap<String, Object> map : resMap){
                 map.put("apply_time",map.get("in_time").toString()+"-"+map.get("out_time").toString());
                 map.put("send_time",DateUtils.parseDate(map.get("create_time").toString()).getTime());

diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/UserActionMapper.java b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/UserActionMapper.java
index 31f7534..6a293d2 100644
--- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/UserActionMapper.java
+++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/UserActionMapper.java
@@ -30,7 +30,5 @@
 
     List<String> getPropertyManager();
 
-    List<VisitorApply> selectApplyList(@Param("request") VisitorApplyListRequest request);
 
-    List<HashMap<String, Object>> getMessageList(@Param("openid") String openid);
 }
diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/VisitorApplyMapper.java b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/VisitorApplyMapper.java
index 0f66d88..197e81c 100644
--- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/VisitorApplyMapper.java
+++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/VisitorApplyMapper.java
@@ -18,4 +18,8 @@
 
 public interface VisitorApplyMapper extends BaseMapper<VisitorApply> {
 
+    List<VisitorApply> selectApplyList(@Param("request") VisitorApplyListRequest request);
+
+    List<HashMap<String, Object>> getMessageList(@Param("openid") String openid);
+
 }
diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/service/impl/VisitorApplyServiceImpl.java b/casic-server/src/main/java/com/casic/missiles/modular/system/service/impl/VisitorApplyServiceImpl.java
index ec16d89..2e18abf 100644
--- a/casic-server/src/main/java/com/casic/missiles/modular/system/service/impl/VisitorApplyServiceImpl.java
+++ b/casic-server/src/main/java/com/casic/missiles/modular/system/service/impl/VisitorApplyServiceImpl.java
@@ -93,7 +93,7 @@
         if(null == jsonObject){
             return ResponseData.error(2401,Status.TOKEN_EXPIRES);
         }
-        List<VisitorApply> list = userActionMapper.selectApplyList(visitorApplyListRequest);
+        List<VisitorApply> list = visitorApplyMapper.selectApplyList(visitorApplyListRequest);
         if(CollectionUtils.isEmpty(list)){
             return ResponseData.success(new ArrayList<>());
         }
@@ -145,7 +145,7 @@
                 return ResponseData.error(2401,Status.TOKEN_EXPIRES);
             }
             String openid = jsonObject.get("openid").toString();
-            List<HashMap<String,Object>> resMap =  userActionMapper.getMessageList(openid);
+            List<HashMap<String,Object>> resMap =  visitorApplyMapper.getMessageList(openid);
             for (HashMap<String, Object> map : resMap){
                 map.put("apply_time",map.get("in_time").toString()+"-"+map.get("out_time").toString());
                 map.put("send_time",DateUtils.parseDate(map.get("create_time").toString()).getTime());
diff --git a/casic-web/src/main/resources/mapper/UserActionMapper.xml b/casic-web/src/main/resources/mapper/UserActionMapper.xml
index 9b5a965..b5b1bc7 100644
--- a/casic-web/src/main/resources/mapper/UserActionMapper.xml
+++ b/casic-web/src/main/resources/mapper/UserActionMapper.xml
@@ -78,42 +78,5 @@
                 WHERE
                     ru.ROLEID = '1319814546311985641')
     </select>
-    <select id="selectApplyList" resultType="com.casic.missiles.modular.system.model.VisitorApply">
-        SELECT *
-        FROM bus_visit_apply
-        WHERE 1=1
-        <if test="request.keywords != null and request.keywords !=''">
-            and (apply_no like concat('%',#{request.keywords},'%')
-            or staff_code like concat('%',#{request.keywords},'%')
-            or visitor_name like concat('%',#{request.keywords},'%')
-            or visitor_phone like concat('%',#{request.keywords},'%'))
-        </if>
-        <if test="request.startTime != null and request.startTime !=''">
-            and in_time &gt;= #{request.startTime}
-        </if>
-        <if test="request.endTime != null and request.endTime != ''">
-            and out_time &lt;= #{request.endTime}
-        </if>
-        <if test="request.status != null and request.status != ''">
-            and visitor_apply_status = #{request.status}
-        </if>
-        ORDER BY create_time DESC
-    </select>
-    <select id="getMessageList" parameterType="string" resultType="hashmap">
-        SELECT
-            t1.message_id,
-            t2.staff_code,
-            t2.visitor_name,
-            t2.visitor_apply_status,
-            DATE_FORMAT(t2.in_time,'%Y/%m/%d %H:%i:%s') as in_time,
-            DATE_FORMAT(t2.out_time,'%Y/%m/%d %H:%i:%s') as out_time,
-            DATE_FORMAT(t1.create_time,'%Y/%m/%d %H:%i:%s') as create_time
-        FROM
-            bus_message t1
-                LEFT JOIN bus_visit_apply t2 ON t1.message_id = t2.apply_no
-        WHERE
-            1 = 1
-          AND t1.`status` = '0' and t1.open_id = #{openid}
-        ORDER BY t1.create_time desc
-    </select>
+
 </mapper>
\ No newline at end of file

diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/UserActionMapper.java b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/UserActionMapper.java
index 31f7534..6a293d2 100644
--- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/UserActionMapper.java
+++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/UserActionMapper.java
@@ -30,7 +30,5 @@
 
     List<String> getPropertyManager();
 
-    List<VisitorApply> selectApplyList(@Param("request") VisitorApplyListRequest request);
 
-    List<HashMap<String, Object>> getMessageList(@Param("openid") String openid);
 }
diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/VisitorApplyMapper.java b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/VisitorApplyMapper.java
index 0f66d88..197e81c 100644
--- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/VisitorApplyMapper.java
+++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/VisitorApplyMapper.java
@@ -18,4 +18,8 @@
 
 public interface VisitorApplyMapper extends BaseMapper<VisitorApply> {
 
+    List<VisitorApply> selectApplyList(@Param("request") VisitorApplyListRequest request);
+
+    List<HashMap<String, Object>> getMessageList(@Param("openid") String openid);
+
 }
diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/service/impl/VisitorApplyServiceImpl.java b/casic-server/src/main/java/com/casic/missiles/modular/system/service/impl/VisitorApplyServiceImpl.java
index ec16d89..2e18abf 100644
--- a/casic-server/src/main/java/com/casic/missiles/modular/system/service/impl/VisitorApplyServiceImpl.java
+++ b/casic-server/src/main/java/com/casic/missiles/modular/system/service/impl/VisitorApplyServiceImpl.java
@@ -93,7 +93,7 @@
         if(null == jsonObject){
             return ResponseData.error(2401,Status.TOKEN_EXPIRES);
         }
-        List<VisitorApply> list = userActionMapper.selectApplyList(visitorApplyListRequest);
+        List<VisitorApply> list = visitorApplyMapper.selectApplyList(visitorApplyListRequest);
         if(CollectionUtils.isEmpty(list)){
             return ResponseData.success(new ArrayList<>());
         }
@@ -145,7 +145,7 @@
                 return ResponseData.error(2401,Status.TOKEN_EXPIRES);
             }
             String openid = jsonObject.get("openid").toString();
-            List<HashMap<String,Object>> resMap =  userActionMapper.getMessageList(openid);
+            List<HashMap<String,Object>> resMap =  visitorApplyMapper.getMessageList(openid);
             for (HashMap<String, Object> map : resMap){
                 map.put("apply_time",map.get("in_time").toString()+"-"+map.get("out_time").toString());
                 map.put("send_time",DateUtils.parseDate(map.get("create_time").toString()).getTime());
diff --git a/casic-web/src/main/resources/mapper/UserActionMapper.xml b/casic-web/src/main/resources/mapper/UserActionMapper.xml
index 9b5a965..b5b1bc7 100644
--- a/casic-web/src/main/resources/mapper/UserActionMapper.xml
+++ b/casic-web/src/main/resources/mapper/UserActionMapper.xml
@@ -78,42 +78,5 @@
                 WHERE
                     ru.ROLEID = '1319814546311985641')
     </select>
-    <select id="selectApplyList" resultType="com.casic.missiles.modular.system.model.VisitorApply">
-        SELECT *
-        FROM bus_visit_apply
-        WHERE 1=1
-        <if test="request.keywords != null and request.keywords !=''">
-            and (apply_no like concat('%',#{request.keywords},'%')
-            or staff_code like concat('%',#{request.keywords},'%')
-            or visitor_name like concat('%',#{request.keywords},'%')
-            or visitor_phone like concat('%',#{request.keywords},'%'))
-        </if>
-        <if test="request.startTime != null and request.startTime !=''">
-            and in_time &gt;= #{request.startTime}
-        </if>
-        <if test="request.endTime != null and request.endTime != ''">
-            and out_time &lt;= #{request.endTime}
-        </if>
-        <if test="request.status != null and request.status != ''">
-            and visitor_apply_status = #{request.status}
-        </if>
-        ORDER BY create_time DESC
-    </select>
-    <select id="getMessageList" parameterType="string" resultType="hashmap">
-        SELECT
-            t1.message_id,
-            t2.staff_code,
-            t2.visitor_name,
-            t2.visitor_apply_status,
-            DATE_FORMAT(t2.in_time,'%Y/%m/%d %H:%i:%s') as in_time,
-            DATE_FORMAT(t2.out_time,'%Y/%m/%d %H:%i:%s') as out_time,
-            DATE_FORMAT(t1.create_time,'%Y/%m/%d %H:%i:%s') as create_time
-        FROM
-            bus_message t1
-                LEFT JOIN bus_visit_apply t2 ON t1.message_id = t2.apply_no
-        WHERE
-            1 = 1
-          AND t1.`status` = '0' and t1.open_id = #{openid}
-        ORDER BY t1.create_time desc
-    </select>
+
 </mapper>
\ No newline at end of file
diff --git a/casic-web/src/main/resources/mapper/VisitorApplyMapper.xml b/casic-web/src/main/resources/mapper/VisitorApplyMapper.xml
index af11619..e81414d 100644
--- a/casic-web/src/main/resources/mapper/VisitorApplyMapper.xml
+++ b/casic-web/src/main/resources/mapper/VisitorApplyMapper.xml
@@ -1,6 +1,43 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
 <mapper namespace="com.casic.missiles.modular.system.dao.VisitorApplyMapper">
-
+    <select id="selectApplyList" resultType="com.casic.missiles.modular.system.model.VisitorApply">
+        SELECT *
+        FROM bus_visit_apply
+        WHERE 1=1
+        <if test="request.keywords != null and request.keywords !=''">
+            and (apply_no like concat('%',#{request.keywords},'%')
+            or staff_code like concat('%',#{request.keywords},'%')
+            or visitor_name like concat('%',#{request.keywords},'%')
+            or visitor_phone like concat('%',#{request.keywords},'%'))
+        </if>
+        <if test="request.startTime != null and request.startTime !=''">
+            and in_time &gt;= #{request.startTime}
+        </if>
+        <if test="request.endTime != null and request.endTime != ''">
+            and out_time &lt;= #{request.endTime}
+        </if>
+        <if test="request.status != null and request.status != ''">
+            and visitor_apply_status = #{request.status}
+        </if>
+        ORDER BY create_time DESC
+    </select>
+    <select id="getMessageList" parameterType="string" resultType="hashmap">
+        SELECT
+            t1.message_id,
+            t2.staff_code,
+            t2.visitor_name,
+            t2.visitor_apply_status,
+            DATE_FORMAT(t2.in_time,'%Y/%m/%d %H:%i:%s') as in_time,
+            DATE_FORMAT(t2.out_time,'%Y/%m/%d %H:%i:%s') as out_time,
+            DATE_FORMAT(t1.create_time,'%Y/%m/%d %H:%i:%s') as create_time
+        FROM
+            bus_message t1
+                LEFT JOIN bus_visit_apply t2 ON t1.message_id = t2.apply_no
+        WHERE
+            1 = 1
+          AND t1.`status` = '0' and t1.open_id = #{openid}
+        ORDER BY t1.create_time desc
+    </select>
 
 </mapper>
\ No newline at end of file