diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/UserActionMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/UserActionMapper.xml
new file mode 100644
index 0000000..b5b1bc7
--- /dev/null
+++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/UserActionMapper.xml
@@ -0,0 +1,82 @@
+<?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.UserActionMapper">
+    <resultMap id="BaseResultMap" type="com.casic.missiles.modular.system.model.Dict">
+        <id column="id" property="id"/>
+        <result column="num" property="num"/>
+        <result column="pid" property="pid"/>
+        <result column="name" property="name"/>
+        <result column="code" property="code"/>
+        <result column="tips" property="tips"/>
+    </resultMap>
+    <select id="getList" resultMap="BaseResultMap">
+        select * from sys_dict t where t.PID = '1556844890633605122'
+        <if test="id != null and id != ''">
+            and t.id = #{id}
+        </if>
+    </select>
+    <select id="getUserInfo" resultType="com.casic.missiles.modular.system.dto.UserDto">
+        SELECT * FROM sys_user t WHERE 1=1 <include refid="userInfo"/>
+    </select>
+    <sql id="userInfo">
+        <if test="userDto.account != null and userDto.account != ''">
+            and t.ACCOUNT = #{userDto.account}
+        </if>
+        <if test="userDto.name != null and userDto.name != ''">
+            and t.NAME = #{userDto.name}
+        </if>
+        <if test="userDto.attr1 != null and userDto.attr1 != ''">
+            and t.PHONE = #{userDto.attr1}
+        </if>
+        <if test="userDto.syncId != null and userDto.syncId != ''">
+            and t.SYNC_ID = #{userDto.syncId}
+        </if>
+    </sql>
+    <update id="userRegister" parameterType="com.casic.missiles.modular.system.dto.UserDto">
+        UPDATE sys_user SET `PHONE` = #{userDto.phone},`SALT`=#{userDto.salt} WHERE `ACCOUNT` = #{userDto.account} and `NAME` = #{userDto.name}
+    </update>
+    <update id="setUserOpenId" parameterType="com.casic.missiles.modular.system.dto.UserDto">
+        UPDATE sys_user SET `SYNC_ID` = #{userDto.syncId} WHERE `ACCOUNT` = #{userDto.account} and `NAME` = #{userDto.name} and `PHONE` = #{userDto.phone}
+    </update>
+    <insert id="userEmpowerment" parameterType="string">
+        INSERT INTO sys_ru_relation ( `ID`, `USERID`, `ROLEID`,`UPDATE_TIME`)
+        VALUES (#{id},#{userId},'1397015476211346433',DATE_FORMAT(#{updateTime},'%Y-%m-%d %H:%i:%S'))
+    </insert>
+    <insert id="insertMessageLog" parameterType="com.casic.missiles.modular.system.dto.MessageDto">
+        INSERT INTO bus_message ( `ID`, `MESSAGE_ID`, `STATUS`,`CREATE_TIME`)
+        VALUES (#{message.id},#{message.messageId},#{message.status},DATE_FORMAT(#{message.createTime},'%Y-%m-%d %H:%i:%S'))
+    </insert>
+    <update id="updateUserImg" parameterType="string">
+        UPDATE sys_user SET `AVATAR` = #{fileId} WHERE `ID` = #{uid}
+    </update>
+    <select id="getUserJurisdiction" parameterType="string" resultType="string">
+        SELECT
+            url
+        FROM
+            sys_rm_relation t
+                LEFT JOIN sys_resource t1 ON t.MENUID = t1.ID
+        WHERE
+                t.ROLEID IN (
+                SELECT
+                    ROLEID
+                FROM
+                    sys_ru_relation t
+                WHERE
+                    t.Userid = ( SELECT id FROM sys_user WHERE id = #{uid} ))
+    </select>
+    <select id="getPropertyManager" resultType="string">
+        SELECT
+            SYNC_ID
+        FROM
+            sys_user t
+        WHERE
+                t.ID IN (
+                SELECT
+                    ru.USERID
+                FROM
+                    sys_ru_relation ru
+                WHERE
+                    ru.ROLEID = '1319814546311985641')
+    </select>
+
+</mapper>
\ No newline at end of file

diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/UserActionMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/UserActionMapper.xml
new file mode 100644
index 0000000..b5b1bc7
--- /dev/null
+++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/UserActionMapper.xml
@@ -0,0 +1,82 @@
+<?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.UserActionMapper">
+    <resultMap id="BaseResultMap" type="com.casic.missiles.modular.system.model.Dict">
+        <id column="id" property="id"/>
+        <result column="num" property="num"/>
+        <result column="pid" property="pid"/>
+        <result column="name" property="name"/>
+        <result column="code" property="code"/>
+        <result column="tips" property="tips"/>
+    </resultMap>
+    <select id="getList" resultMap="BaseResultMap">
+        select * from sys_dict t where t.PID = '1556844890633605122'
+        <if test="id != null and id != ''">
+            and t.id = #{id}
+        </if>
+    </select>
+    <select id="getUserInfo" resultType="com.casic.missiles.modular.system.dto.UserDto">
+        SELECT * FROM sys_user t WHERE 1=1 <include refid="userInfo"/>
+    </select>
+    <sql id="userInfo">
+        <if test="userDto.account != null and userDto.account != ''">
+            and t.ACCOUNT = #{userDto.account}
+        </if>
+        <if test="userDto.name != null and userDto.name != ''">
+            and t.NAME = #{userDto.name}
+        </if>
+        <if test="userDto.attr1 != null and userDto.attr1 != ''">
+            and t.PHONE = #{userDto.attr1}
+        </if>
+        <if test="userDto.syncId != null and userDto.syncId != ''">
+            and t.SYNC_ID = #{userDto.syncId}
+        </if>
+    </sql>
+    <update id="userRegister" parameterType="com.casic.missiles.modular.system.dto.UserDto">
+        UPDATE sys_user SET `PHONE` = #{userDto.phone},`SALT`=#{userDto.salt} WHERE `ACCOUNT` = #{userDto.account} and `NAME` = #{userDto.name}
+    </update>
+    <update id="setUserOpenId" parameterType="com.casic.missiles.modular.system.dto.UserDto">
+        UPDATE sys_user SET `SYNC_ID` = #{userDto.syncId} WHERE `ACCOUNT` = #{userDto.account} and `NAME` = #{userDto.name} and `PHONE` = #{userDto.phone}
+    </update>
+    <insert id="userEmpowerment" parameterType="string">
+        INSERT INTO sys_ru_relation ( `ID`, `USERID`, `ROLEID`,`UPDATE_TIME`)
+        VALUES (#{id},#{userId},'1397015476211346433',DATE_FORMAT(#{updateTime},'%Y-%m-%d %H:%i:%S'))
+    </insert>
+    <insert id="insertMessageLog" parameterType="com.casic.missiles.modular.system.dto.MessageDto">
+        INSERT INTO bus_message ( `ID`, `MESSAGE_ID`, `STATUS`,`CREATE_TIME`)
+        VALUES (#{message.id},#{message.messageId},#{message.status},DATE_FORMAT(#{message.createTime},'%Y-%m-%d %H:%i:%S'))
+    </insert>
+    <update id="updateUserImg" parameterType="string">
+        UPDATE sys_user SET `AVATAR` = #{fileId} WHERE `ID` = #{uid}
+    </update>
+    <select id="getUserJurisdiction" parameterType="string" resultType="string">
+        SELECT
+            url
+        FROM
+            sys_rm_relation t
+                LEFT JOIN sys_resource t1 ON t.MENUID = t1.ID
+        WHERE
+                t.ROLEID IN (
+                SELECT
+                    ROLEID
+                FROM
+                    sys_ru_relation t
+                WHERE
+                    t.Userid = ( SELECT id FROM sys_user WHERE id = #{uid} ))
+    </select>
+    <select id="getPropertyManager" resultType="string">
+        SELECT
+            SYNC_ID
+        FROM
+            sys_user t
+        WHERE
+                t.ID IN (
+                SELECT
+                    ru.USERID
+                FROM
+                    sys_ru_relation ru
+                WHERE
+                    ru.ROLEID = '1319814546311985641')
+    </select>
+
+</mapper>
\ No newline at end of file
diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/VisitorApplyMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/VisitorApplyMapper.xml
new file mode 100644
index 0000000..e81414d
--- /dev/null
+++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/VisitorApplyMapper.xml
@@ -0,0 +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

diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/UserActionMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/UserActionMapper.xml
new file mode 100644
index 0000000..b5b1bc7
--- /dev/null
+++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/UserActionMapper.xml
@@ -0,0 +1,82 @@
+<?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.UserActionMapper">
+    <resultMap id="BaseResultMap" type="com.casic.missiles.modular.system.model.Dict">
+        <id column="id" property="id"/>
+        <result column="num" property="num"/>
+        <result column="pid" property="pid"/>
+        <result column="name" property="name"/>
+        <result column="code" property="code"/>
+        <result column="tips" property="tips"/>
+    </resultMap>
+    <select id="getList" resultMap="BaseResultMap">
+        select * from sys_dict t where t.PID = '1556844890633605122'
+        <if test="id != null and id != ''">
+            and t.id = #{id}
+        </if>
+    </select>
+    <select id="getUserInfo" resultType="com.casic.missiles.modular.system.dto.UserDto">
+        SELECT * FROM sys_user t WHERE 1=1 <include refid="userInfo"/>
+    </select>
+    <sql id="userInfo">
+        <if test="userDto.account != null and userDto.account != ''">
+            and t.ACCOUNT = #{userDto.account}
+        </if>
+        <if test="userDto.name != null and userDto.name != ''">
+            and t.NAME = #{userDto.name}
+        </if>
+        <if test="userDto.attr1 != null and userDto.attr1 != ''">
+            and t.PHONE = #{userDto.attr1}
+        </if>
+        <if test="userDto.syncId != null and userDto.syncId != ''">
+            and t.SYNC_ID = #{userDto.syncId}
+        </if>
+    </sql>
+    <update id="userRegister" parameterType="com.casic.missiles.modular.system.dto.UserDto">
+        UPDATE sys_user SET `PHONE` = #{userDto.phone},`SALT`=#{userDto.salt} WHERE `ACCOUNT` = #{userDto.account} and `NAME` = #{userDto.name}
+    </update>
+    <update id="setUserOpenId" parameterType="com.casic.missiles.modular.system.dto.UserDto">
+        UPDATE sys_user SET `SYNC_ID` = #{userDto.syncId} WHERE `ACCOUNT` = #{userDto.account} and `NAME` = #{userDto.name} and `PHONE` = #{userDto.phone}
+    </update>
+    <insert id="userEmpowerment" parameterType="string">
+        INSERT INTO sys_ru_relation ( `ID`, `USERID`, `ROLEID`,`UPDATE_TIME`)
+        VALUES (#{id},#{userId},'1397015476211346433',DATE_FORMAT(#{updateTime},'%Y-%m-%d %H:%i:%S'))
+    </insert>
+    <insert id="insertMessageLog" parameterType="com.casic.missiles.modular.system.dto.MessageDto">
+        INSERT INTO bus_message ( `ID`, `MESSAGE_ID`, `STATUS`,`CREATE_TIME`)
+        VALUES (#{message.id},#{message.messageId},#{message.status},DATE_FORMAT(#{message.createTime},'%Y-%m-%d %H:%i:%S'))
+    </insert>
+    <update id="updateUserImg" parameterType="string">
+        UPDATE sys_user SET `AVATAR` = #{fileId} WHERE `ID` = #{uid}
+    </update>
+    <select id="getUserJurisdiction" parameterType="string" resultType="string">
+        SELECT
+            url
+        FROM
+            sys_rm_relation t
+                LEFT JOIN sys_resource t1 ON t.MENUID = t1.ID
+        WHERE
+                t.ROLEID IN (
+                SELECT
+                    ROLEID
+                FROM
+                    sys_ru_relation t
+                WHERE
+                    t.Userid = ( SELECT id FROM sys_user WHERE id = #{uid} ))
+    </select>
+    <select id="getPropertyManager" resultType="string">
+        SELECT
+            SYNC_ID
+        FROM
+            sys_user t
+        WHERE
+                t.ID IN (
+                SELECT
+                    ru.USERID
+                FROM
+                    sys_ru_relation ru
+                WHERE
+                    ru.ROLEID = '1319814546311985641')
+    </select>
+
+</mapper>
\ No newline at end of file
diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/VisitorApplyMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/VisitorApplyMapper.xml
new file mode 100644
index 0000000..e81414d
--- /dev/null
+++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/VisitorApplyMapper.xml
@@ -0,0 +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
diff --git a/casic-web/src/main/java/com/casic/missiles/CasicApplication.java b/casic-web/src/main/java/com/casic/missiles/CasicApplication.java
index 3422629..7f92b1d 100644
--- a/casic-web/src/main/java/com/casic/missiles/CasicApplication.java
+++ b/casic-web/src/main/java/com/casic/missiles/CasicApplication.java
@@ -20,7 +20,6 @@
 @EnableTransactionManagement(proxyTargetClass = true)
 @EnableAsync
 @Slf4j
-@MapperScan("com.casic.missiles.modular.system.dao")
 public class CasicApplication {
     public static void main(String[] args) {
         SpringApplication.run(CasicApplication.class, args);

diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/UserActionMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/UserActionMapper.xml
new file mode 100644
index 0000000..b5b1bc7
--- /dev/null
+++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/UserActionMapper.xml
@@ -0,0 +1,82 @@
+<?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.UserActionMapper">
+    <resultMap id="BaseResultMap" type="com.casic.missiles.modular.system.model.Dict">
+        <id column="id" property="id"/>
+        <result column="num" property="num"/>
+        <result column="pid" property="pid"/>
+        <result column="name" property="name"/>
+        <result column="code" property="code"/>
+        <result column="tips" property="tips"/>
+    </resultMap>
+    <select id="getList" resultMap="BaseResultMap">
+        select * from sys_dict t where t.PID = '1556844890633605122'
+        <if test="id != null and id != ''">
+            and t.id = #{id}
+        </if>
+    </select>
+    <select id="getUserInfo" resultType="com.casic.missiles.modular.system.dto.UserDto">
+        SELECT * FROM sys_user t WHERE 1=1 <include refid="userInfo"/>
+    </select>
+    <sql id="userInfo">
+        <if test="userDto.account != null and userDto.account != ''">
+            and t.ACCOUNT = #{userDto.account}
+        </if>
+        <if test="userDto.name != null and userDto.name != ''">
+            and t.NAME = #{userDto.name}
+        </if>
+        <if test="userDto.attr1 != null and userDto.attr1 != ''">
+            and t.PHONE = #{userDto.attr1}
+        </if>
+        <if test="userDto.syncId != null and userDto.syncId != ''">
+            and t.SYNC_ID = #{userDto.syncId}
+        </if>
+    </sql>
+    <update id="userRegister" parameterType="com.casic.missiles.modular.system.dto.UserDto">
+        UPDATE sys_user SET `PHONE` = #{userDto.phone},`SALT`=#{userDto.salt} WHERE `ACCOUNT` = #{userDto.account} and `NAME` = #{userDto.name}
+    </update>
+    <update id="setUserOpenId" parameterType="com.casic.missiles.modular.system.dto.UserDto">
+        UPDATE sys_user SET `SYNC_ID` = #{userDto.syncId} WHERE `ACCOUNT` = #{userDto.account} and `NAME` = #{userDto.name} and `PHONE` = #{userDto.phone}
+    </update>
+    <insert id="userEmpowerment" parameterType="string">
+        INSERT INTO sys_ru_relation ( `ID`, `USERID`, `ROLEID`,`UPDATE_TIME`)
+        VALUES (#{id},#{userId},'1397015476211346433',DATE_FORMAT(#{updateTime},'%Y-%m-%d %H:%i:%S'))
+    </insert>
+    <insert id="insertMessageLog" parameterType="com.casic.missiles.modular.system.dto.MessageDto">
+        INSERT INTO bus_message ( `ID`, `MESSAGE_ID`, `STATUS`,`CREATE_TIME`)
+        VALUES (#{message.id},#{message.messageId},#{message.status},DATE_FORMAT(#{message.createTime},'%Y-%m-%d %H:%i:%S'))
+    </insert>
+    <update id="updateUserImg" parameterType="string">
+        UPDATE sys_user SET `AVATAR` = #{fileId} WHERE `ID` = #{uid}
+    </update>
+    <select id="getUserJurisdiction" parameterType="string" resultType="string">
+        SELECT
+            url
+        FROM
+            sys_rm_relation t
+                LEFT JOIN sys_resource t1 ON t.MENUID = t1.ID
+        WHERE
+                t.ROLEID IN (
+                SELECT
+                    ROLEID
+                FROM
+                    sys_ru_relation t
+                WHERE
+                    t.Userid = ( SELECT id FROM sys_user WHERE id = #{uid} ))
+    </select>
+    <select id="getPropertyManager" resultType="string">
+        SELECT
+            SYNC_ID
+        FROM
+            sys_user t
+        WHERE
+                t.ID IN (
+                SELECT
+                    ru.USERID
+                FROM
+                    sys_ru_relation ru
+                WHERE
+                    ru.ROLEID = '1319814546311985641')
+    </select>
+
+</mapper>
\ No newline at end of file
diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/VisitorApplyMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/VisitorApplyMapper.xml
new file mode 100644
index 0000000..e81414d
--- /dev/null
+++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/VisitorApplyMapper.xml
@@ -0,0 +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
diff --git a/casic-web/src/main/java/com/casic/missiles/CasicApplication.java b/casic-web/src/main/java/com/casic/missiles/CasicApplication.java
index 3422629..7f92b1d 100644
--- a/casic-web/src/main/java/com/casic/missiles/CasicApplication.java
+++ b/casic-web/src/main/java/com/casic/missiles/CasicApplication.java
@@ -20,7 +20,6 @@
 @EnableTransactionManagement(proxyTargetClass = true)
 @EnableAsync
 @Slf4j
-@MapperScan("com.casic.missiles.modular.system.dao")
 public class CasicApplication {
     public static void main(String[] args) {
         SpringApplication.run(CasicApplication.class, args);
diff --git a/casic-web/src/main/resources/config/application.yml b/casic-web/src/main/resources/config/application.yml
index 1b9c063..9dc8566 100644
--- a/casic-web/src/main/resources/config/application.yml
+++ b/casic-web/src/main/resources/config/application.yml
@@ -20,7 +20,6 @@
     # 配置结果集属性为空时 是否映射返回结果
     log-impl: org.apache.ibatis.logging.stdout.StdOutImpl #打印sql语句,调试用
     map-underscore-to-camel-case: true
-  mapper-locations: classpath:mapper/*.xml
 ###################  guns配置  ###################
 casic:
   swagger-open: false #是否开启swagger (true/false)

diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/UserActionMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/UserActionMapper.xml
new file mode 100644
index 0000000..b5b1bc7
--- /dev/null
+++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/UserActionMapper.xml
@@ -0,0 +1,82 @@
+<?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.UserActionMapper">
+    <resultMap id="BaseResultMap" type="com.casic.missiles.modular.system.model.Dict">
+        <id column="id" property="id"/>
+        <result column="num" property="num"/>
+        <result column="pid" property="pid"/>
+        <result column="name" property="name"/>
+        <result column="code" property="code"/>
+        <result column="tips" property="tips"/>
+    </resultMap>
+    <select id="getList" resultMap="BaseResultMap">
+        select * from sys_dict t where t.PID = '1556844890633605122'
+        <if test="id != null and id != ''">
+            and t.id = #{id}
+        </if>
+    </select>
+    <select id="getUserInfo" resultType="com.casic.missiles.modular.system.dto.UserDto">
+        SELECT * FROM sys_user t WHERE 1=1 <include refid="userInfo"/>
+    </select>
+    <sql id="userInfo">
+        <if test="userDto.account != null and userDto.account != ''">
+            and t.ACCOUNT = #{userDto.account}
+        </if>
+        <if test="userDto.name != null and userDto.name != ''">
+            and t.NAME = #{userDto.name}
+        </if>
+        <if test="userDto.attr1 != null and userDto.attr1 != ''">
+            and t.PHONE = #{userDto.attr1}
+        </if>
+        <if test="userDto.syncId != null and userDto.syncId != ''">
+            and t.SYNC_ID = #{userDto.syncId}
+        </if>
+    </sql>
+    <update id="userRegister" parameterType="com.casic.missiles.modular.system.dto.UserDto">
+        UPDATE sys_user SET `PHONE` = #{userDto.phone},`SALT`=#{userDto.salt} WHERE `ACCOUNT` = #{userDto.account} and `NAME` = #{userDto.name}
+    </update>
+    <update id="setUserOpenId" parameterType="com.casic.missiles.modular.system.dto.UserDto">
+        UPDATE sys_user SET `SYNC_ID` = #{userDto.syncId} WHERE `ACCOUNT` = #{userDto.account} and `NAME` = #{userDto.name} and `PHONE` = #{userDto.phone}
+    </update>
+    <insert id="userEmpowerment" parameterType="string">
+        INSERT INTO sys_ru_relation ( `ID`, `USERID`, `ROLEID`,`UPDATE_TIME`)
+        VALUES (#{id},#{userId},'1397015476211346433',DATE_FORMAT(#{updateTime},'%Y-%m-%d %H:%i:%S'))
+    </insert>
+    <insert id="insertMessageLog" parameterType="com.casic.missiles.modular.system.dto.MessageDto">
+        INSERT INTO bus_message ( `ID`, `MESSAGE_ID`, `STATUS`,`CREATE_TIME`)
+        VALUES (#{message.id},#{message.messageId},#{message.status},DATE_FORMAT(#{message.createTime},'%Y-%m-%d %H:%i:%S'))
+    </insert>
+    <update id="updateUserImg" parameterType="string">
+        UPDATE sys_user SET `AVATAR` = #{fileId} WHERE `ID` = #{uid}
+    </update>
+    <select id="getUserJurisdiction" parameterType="string" resultType="string">
+        SELECT
+            url
+        FROM
+            sys_rm_relation t
+                LEFT JOIN sys_resource t1 ON t.MENUID = t1.ID
+        WHERE
+                t.ROLEID IN (
+                SELECT
+                    ROLEID
+                FROM
+                    sys_ru_relation t
+                WHERE
+                    t.Userid = ( SELECT id FROM sys_user WHERE id = #{uid} ))
+    </select>
+    <select id="getPropertyManager" resultType="string">
+        SELECT
+            SYNC_ID
+        FROM
+            sys_user t
+        WHERE
+                t.ID IN (
+                SELECT
+                    ru.USERID
+                FROM
+                    sys_ru_relation ru
+                WHERE
+                    ru.ROLEID = '1319814546311985641')
+    </select>
+
+</mapper>
\ No newline at end of file
diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/VisitorApplyMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/VisitorApplyMapper.xml
new file mode 100644
index 0000000..e81414d
--- /dev/null
+++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/VisitorApplyMapper.xml
@@ -0,0 +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
diff --git a/casic-web/src/main/java/com/casic/missiles/CasicApplication.java b/casic-web/src/main/java/com/casic/missiles/CasicApplication.java
index 3422629..7f92b1d 100644
--- a/casic-web/src/main/java/com/casic/missiles/CasicApplication.java
+++ b/casic-web/src/main/java/com/casic/missiles/CasicApplication.java
@@ -20,7 +20,6 @@
 @EnableTransactionManagement(proxyTargetClass = true)
 @EnableAsync
 @Slf4j
-@MapperScan("com.casic.missiles.modular.system.dao")
 public class CasicApplication {
     public static void main(String[] args) {
         SpringApplication.run(CasicApplication.class, args);
diff --git a/casic-web/src/main/resources/config/application.yml b/casic-web/src/main/resources/config/application.yml
index 1b9c063..9dc8566 100644
--- a/casic-web/src/main/resources/config/application.yml
+++ b/casic-web/src/main/resources/config/application.yml
@@ -20,7 +20,6 @@
     # 配置结果集属性为空时 是否映射返回结果
     log-impl: org.apache.ibatis.logging.stdout.StdOutImpl #打印sql语句,调试用
     map-underscore-to-camel-case: true
-  mapper-locations: classpath:mapper/*.xml
 ###################  guns配置  ###################
 casic:
   swagger-open: false #是否开启swagger (true/false)
diff --git a/casic-web/src/main/resources/mapper/UserActionMapper.xml b/casic-web/src/main/resources/mapper/UserActionMapper.xml
deleted file mode 100644
index b5b1bc7..0000000
--- a/casic-web/src/main/resources/mapper/UserActionMapper.xml
+++ /dev/null
@@ -1,82 +0,0 @@
-<?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.UserActionMapper">
-    <resultMap id="BaseResultMap" type="com.casic.missiles.modular.system.model.Dict">
-        <id column="id" property="id"/>
-        <result column="num" property="num"/>
-        <result column="pid" property="pid"/>
-        <result column="name" property="name"/>
-        <result column="code" property="code"/>
-        <result column="tips" property="tips"/>
-    </resultMap>
-    <select id="getList" resultMap="BaseResultMap">
-        select * from sys_dict t where t.PID = '1556844890633605122'
-        <if test="id != null and id != ''">
-            and t.id = #{id}
-        </if>
-    </select>
-    <select id="getUserInfo" resultType="com.casic.missiles.modular.system.dto.UserDto">
-        SELECT * FROM sys_user t WHERE 1=1 <include refid="userInfo"/>
-    </select>
-    <sql id="userInfo">
-        <if test="userDto.account != null and userDto.account != ''">
-            and t.ACCOUNT = #{userDto.account}
-        </if>
-        <if test="userDto.name != null and userDto.name != ''">
-            and t.NAME = #{userDto.name}
-        </if>
-        <if test="userDto.attr1 != null and userDto.attr1 != ''">
-            and t.PHONE = #{userDto.attr1}
-        </if>
-        <if test="userDto.syncId != null and userDto.syncId != ''">
-            and t.SYNC_ID = #{userDto.syncId}
-        </if>
-    </sql>
-    <update id="userRegister" parameterType="com.casic.missiles.modular.system.dto.UserDto">
-        UPDATE sys_user SET `PHONE` = #{userDto.phone},`SALT`=#{userDto.salt} WHERE `ACCOUNT` = #{userDto.account} and `NAME` = #{userDto.name}
-    </update>
-    <update id="setUserOpenId" parameterType="com.casic.missiles.modular.system.dto.UserDto">
-        UPDATE sys_user SET `SYNC_ID` = #{userDto.syncId} WHERE `ACCOUNT` = #{userDto.account} and `NAME` = #{userDto.name} and `PHONE` = #{userDto.phone}
-    </update>
-    <insert id="userEmpowerment" parameterType="string">
-        INSERT INTO sys_ru_relation ( `ID`, `USERID`, `ROLEID`,`UPDATE_TIME`)
-        VALUES (#{id},#{userId},'1397015476211346433',DATE_FORMAT(#{updateTime},'%Y-%m-%d %H:%i:%S'))
-    </insert>
-    <insert id="insertMessageLog" parameterType="com.casic.missiles.modular.system.dto.MessageDto">
-        INSERT INTO bus_message ( `ID`, `MESSAGE_ID`, `STATUS`,`CREATE_TIME`)
-        VALUES (#{message.id},#{message.messageId},#{message.status},DATE_FORMAT(#{message.createTime},'%Y-%m-%d %H:%i:%S'))
-    </insert>
-    <update id="updateUserImg" parameterType="string">
-        UPDATE sys_user SET `AVATAR` = #{fileId} WHERE `ID` = #{uid}
-    </update>
-    <select id="getUserJurisdiction" parameterType="string" resultType="string">
-        SELECT
-            url
-        FROM
-            sys_rm_relation t
-                LEFT JOIN sys_resource t1 ON t.MENUID = t1.ID
-        WHERE
-                t.ROLEID IN (
-                SELECT
-                    ROLEID
-                FROM
-                    sys_ru_relation t
-                WHERE
-                    t.Userid = ( SELECT id FROM sys_user WHERE id = #{uid} ))
-    </select>
-    <select id="getPropertyManager" resultType="string">
-        SELECT
-            SYNC_ID
-        FROM
-            sys_user t
-        WHERE
-                t.ID IN (
-                SELECT
-                    ru.USERID
-                FROM
-                    sys_ru_relation ru
-                WHERE
-                    ru.ROLEID = '1319814546311985641')
-    </select>
-
-</mapper>
\ No newline at end of file

diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/UserActionMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/UserActionMapper.xml
new file mode 100644
index 0000000..b5b1bc7
--- /dev/null
+++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/UserActionMapper.xml
@@ -0,0 +1,82 @@
+<?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.UserActionMapper">
+    <resultMap id="BaseResultMap" type="com.casic.missiles.modular.system.model.Dict">
+        <id column="id" property="id"/>
+        <result column="num" property="num"/>
+        <result column="pid" property="pid"/>
+        <result column="name" property="name"/>
+        <result column="code" property="code"/>
+        <result column="tips" property="tips"/>
+    </resultMap>
+    <select id="getList" resultMap="BaseResultMap">
+        select * from sys_dict t where t.PID = '1556844890633605122'
+        <if test="id != null and id != ''">
+            and t.id = #{id}
+        </if>
+    </select>
+    <select id="getUserInfo" resultType="com.casic.missiles.modular.system.dto.UserDto">
+        SELECT * FROM sys_user t WHERE 1=1 <include refid="userInfo"/>
+    </select>
+    <sql id="userInfo">
+        <if test="userDto.account != null and userDto.account != ''">
+            and t.ACCOUNT = #{userDto.account}
+        </if>
+        <if test="userDto.name != null and userDto.name != ''">
+            and t.NAME = #{userDto.name}
+        </if>
+        <if test="userDto.attr1 != null and userDto.attr1 != ''">
+            and t.PHONE = #{userDto.attr1}
+        </if>
+        <if test="userDto.syncId != null and userDto.syncId != ''">
+            and t.SYNC_ID = #{userDto.syncId}
+        </if>
+    </sql>
+    <update id="userRegister" parameterType="com.casic.missiles.modular.system.dto.UserDto">
+        UPDATE sys_user SET `PHONE` = #{userDto.phone},`SALT`=#{userDto.salt} WHERE `ACCOUNT` = #{userDto.account} and `NAME` = #{userDto.name}
+    </update>
+    <update id="setUserOpenId" parameterType="com.casic.missiles.modular.system.dto.UserDto">
+        UPDATE sys_user SET `SYNC_ID` = #{userDto.syncId} WHERE `ACCOUNT` = #{userDto.account} and `NAME` = #{userDto.name} and `PHONE` = #{userDto.phone}
+    </update>
+    <insert id="userEmpowerment" parameterType="string">
+        INSERT INTO sys_ru_relation ( `ID`, `USERID`, `ROLEID`,`UPDATE_TIME`)
+        VALUES (#{id},#{userId},'1397015476211346433',DATE_FORMAT(#{updateTime},'%Y-%m-%d %H:%i:%S'))
+    </insert>
+    <insert id="insertMessageLog" parameterType="com.casic.missiles.modular.system.dto.MessageDto">
+        INSERT INTO bus_message ( `ID`, `MESSAGE_ID`, `STATUS`,`CREATE_TIME`)
+        VALUES (#{message.id},#{message.messageId},#{message.status},DATE_FORMAT(#{message.createTime},'%Y-%m-%d %H:%i:%S'))
+    </insert>
+    <update id="updateUserImg" parameterType="string">
+        UPDATE sys_user SET `AVATAR` = #{fileId} WHERE `ID` = #{uid}
+    </update>
+    <select id="getUserJurisdiction" parameterType="string" resultType="string">
+        SELECT
+            url
+        FROM
+            sys_rm_relation t
+                LEFT JOIN sys_resource t1 ON t.MENUID = t1.ID
+        WHERE
+                t.ROLEID IN (
+                SELECT
+                    ROLEID
+                FROM
+                    sys_ru_relation t
+                WHERE
+                    t.Userid = ( SELECT id FROM sys_user WHERE id = #{uid} ))
+    </select>
+    <select id="getPropertyManager" resultType="string">
+        SELECT
+            SYNC_ID
+        FROM
+            sys_user t
+        WHERE
+                t.ID IN (
+                SELECT
+                    ru.USERID
+                FROM
+                    sys_ru_relation ru
+                WHERE
+                    ru.ROLEID = '1319814546311985641')
+    </select>
+
+</mapper>
\ No newline at end of file
diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/VisitorApplyMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/VisitorApplyMapper.xml
new file mode 100644
index 0000000..e81414d
--- /dev/null
+++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/VisitorApplyMapper.xml
@@ -0,0 +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
diff --git a/casic-web/src/main/java/com/casic/missiles/CasicApplication.java b/casic-web/src/main/java/com/casic/missiles/CasicApplication.java
index 3422629..7f92b1d 100644
--- a/casic-web/src/main/java/com/casic/missiles/CasicApplication.java
+++ b/casic-web/src/main/java/com/casic/missiles/CasicApplication.java
@@ -20,7 +20,6 @@
 @EnableTransactionManagement(proxyTargetClass = true)
 @EnableAsync
 @Slf4j
-@MapperScan("com.casic.missiles.modular.system.dao")
 public class CasicApplication {
     public static void main(String[] args) {
         SpringApplication.run(CasicApplication.class, args);
diff --git a/casic-web/src/main/resources/config/application.yml b/casic-web/src/main/resources/config/application.yml
index 1b9c063..9dc8566 100644
--- a/casic-web/src/main/resources/config/application.yml
+++ b/casic-web/src/main/resources/config/application.yml
@@ -20,7 +20,6 @@
     # 配置结果集属性为空时 是否映射返回结果
     log-impl: org.apache.ibatis.logging.stdout.StdOutImpl #打印sql语句,调试用
     map-underscore-to-camel-case: true
-  mapper-locations: classpath:mapper/*.xml
 ###################  guns配置  ###################
 casic:
   swagger-open: false #是否开启swagger (true/false)
diff --git a/casic-web/src/main/resources/mapper/UserActionMapper.xml b/casic-web/src/main/resources/mapper/UserActionMapper.xml
deleted file mode 100644
index b5b1bc7..0000000
--- a/casic-web/src/main/resources/mapper/UserActionMapper.xml
+++ /dev/null
@@ -1,82 +0,0 @@
-<?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.UserActionMapper">
-    <resultMap id="BaseResultMap" type="com.casic.missiles.modular.system.model.Dict">
-        <id column="id" property="id"/>
-        <result column="num" property="num"/>
-        <result column="pid" property="pid"/>
-        <result column="name" property="name"/>
-        <result column="code" property="code"/>
-        <result column="tips" property="tips"/>
-    </resultMap>
-    <select id="getList" resultMap="BaseResultMap">
-        select * from sys_dict t where t.PID = '1556844890633605122'
-        <if test="id != null and id != ''">
-            and t.id = #{id}
-        </if>
-    </select>
-    <select id="getUserInfo" resultType="com.casic.missiles.modular.system.dto.UserDto">
-        SELECT * FROM sys_user t WHERE 1=1 <include refid="userInfo"/>
-    </select>
-    <sql id="userInfo">
-        <if test="userDto.account != null and userDto.account != ''">
-            and t.ACCOUNT = #{userDto.account}
-        </if>
-        <if test="userDto.name != null and userDto.name != ''">
-            and t.NAME = #{userDto.name}
-        </if>
-        <if test="userDto.attr1 != null and userDto.attr1 != ''">
-            and t.PHONE = #{userDto.attr1}
-        </if>
-        <if test="userDto.syncId != null and userDto.syncId != ''">
-            and t.SYNC_ID = #{userDto.syncId}
-        </if>
-    </sql>
-    <update id="userRegister" parameterType="com.casic.missiles.modular.system.dto.UserDto">
-        UPDATE sys_user SET `PHONE` = #{userDto.phone},`SALT`=#{userDto.salt} WHERE `ACCOUNT` = #{userDto.account} and `NAME` = #{userDto.name}
-    </update>
-    <update id="setUserOpenId" parameterType="com.casic.missiles.modular.system.dto.UserDto">
-        UPDATE sys_user SET `SYNC_ID` = #{userDto.syncId} WHERE `ACCOUNT` = #{userDto.account} and `NAME` = #{userDto.name} and `PHONE` = #{userDto.phone}
-    </update>
-    <insert id="userEmpowerment" parameterType="string">
-        INSERT INTO sys_ru_relation ( `ID`, `USERID`, `ROLEID`,`UPDATE_TIME`)
-        VALUES (#{id},#{userId},'1397015476211346433',DATE_FORMAT(#{updateTime},'%Y-%m-%d %H:%i:%S'))
-    </insert>
-    <insert id="insertMessageLog" parameterType="com.casic.missiles.modular.system.dto.MessageDto">
-        INSERT INTO bus_message ( `ID`, `MESSAGE_ID`, `STATUS`,`CREATE_TIME`)
-        VALUES (#{message.id},#{message.messageId},#{message.status},DATE_FORMAT(#{message.createTime},'%Y-%m-%d %H:%i:%S'))
-    </insert>
-    <update id="updateUserImg" parameterType="string">
-        UPDATE sys_user SET `AVATAR` = #{fileId} WHERE `ID` = #{uid}
-    </update>
-    <select id="getUserJurisdiction" parameterType="string" resultType="string">
-        SELECT
-            url
-        FROM
-            sys_rm_relation t
-                LEFT JOIN sys_resource t1 ON t.MENUID = t1.ID
-        WHERE
-                t.ROLEID IN (
-                SELECT
-                    ROLEID
-                FROM
-                    sys_ru_relation t
-                WHERE
-                    t.Userid = ( SELECT id FROM sys_user WHERE id = #{uid} ))
-    </select>
-    <select id="getPropertyManager" resultType="string">
-        SELECT
-            SYNC_ID
-        FROM
-            sys_user t
-        WHERE
-                t.ID IN (
-                SELECT
-                    ru.USERID
-                FROM
-                    sys_ru_relation ru
-                WHERE
-                    ru.ROLEID = '1319814546311985641')
-    </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
deleted file mode 100644
index e81414d..0000000
--- a/casic-web/src/main/resources/mapper/VisitorApplyMapper.xml
+++ /dev/null
@@ -1,43 +0,0 @@
-<?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