| | |
| | | <id property="id" column="id"/> |
| | | <result property="content" column="content"/> |
| | | <result property="images" column="images" typeHandler="com.baomidou.mybatisplus.extension.handlers.FastjsonTypeHandler"/> |
| | | <result property="phone" column="phone"/> |
| | | <result property="phone" column="userPhone"/> |
| | | |
| | | <result property="reportUserName" column="real_name"/> |
| | | |
| | |
| | | <result property="isDeleted" column="is_deleted"/> |
| | | </resultMap> |
| | | <select id="selectMyPage" resultMap="vo"> |
| | | SELECT SF.*,u.real_name FROM SM_FEEDBACK SF |
| | | SELECT SF.*,u.real_name,u.phone userPhone FROM SM_FEEDBACK SF |
| | | LEFT JOIN BLADE_USER U ON U.ID = SF.CREATE_USER |
| | | WHERE SF.IS_DELETED = 0 |
| | | <if test="vo.createUser != null and vo.createUser !=''"> |