| | |
| | | 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 !=''"> |