guoshilong
2023-08-16 3f57214be21c7774ad8f87420c4ee59f53b99f82
业务日志分页查询隐藏加密字段
1 files modified
16 ■■■■■ changed files
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/log/mapper/SmLogManageMapper.xml 16 ●●●●● patch | view | raw | blame | history
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/log/mapper/SmLogManageMapper.xml
@@ -29,7 +29,21 @@
        GROUP BY A.useTime
    </select>
    <select id="selectMyPage" resultType="cn.gistack.sm.log.vo.SmLogManageVO">
        SELECT L.*,U.real_name createUserName FROM SM_LOG_MANAGE L
        SELECT
               L.ID,
               L.OPERATION_DESCRIPTION,
               L.URL,
               L.IP,
               L.CREATE_TIME,
               L.CREATE_USER,
               L.CREATE_DEPT,
               L.UPDATE_TIME,
               L.UPDATE_USER,
               L.STATUS,
               L.IS_DELETED,
               L.SOURCE,
               U.real_name createUserName
        FROM SM_LOG_MANAGE L
        LEFT JOIN BLADE_USER U ON U.ID = L.CREATE_USER
        WHERE L.IS_DELETED = 0
        <if test="vo.createUserName !=null and vo.createUserName !=''">