Merge remote-tracking branch 'origin/master'
| | |
| | | |
| | | |
| | | <select id="selectUserTopicsPage" resultMap="userTopicsResultMap"> |
| | | SELECT |
| | | SELECT distinct |
| | | jut.article_id, |
| | | jut.id, |
| | | jut.delete_flag, |
| | | jut.signature_path, |
| | | jut.create_time, |
| | |
| | | <if test="userTopics.deleteFlag != null ">and jut.delete_flag = #{userTopics.deleteFlag}</if> |
| | | <if test="userTopics.articleId != null ">and jut.article_id = #{userTopics.articleId} |
| | | and jut.delete_flag = 0 |
| | | GROUP BY jut.article_id, jut.signature_path,jut.create_time,jut.id,jut.delete_flag, |
| | | GROUP BY jut.article_id, jut.signature_path,jut.create_time,jut.delete_flag, |
| | | bu.avatar, |
| | | bu.`name`, |
| | | bu.phone, |
| | |
| | | AND jtrfr.phone like concat('%',#{vo.phone},'%') |
| | | </if> |
| | | <if test="vo.confirmFlag != null"> |
| | | AND (jtrfr.confirm_flag = #{vo.confirmFlag} |
| | | <if test="vo.confirmUserId != null and vo.roleName!='网格员'"> |
| | | or jtrfr.confirm_user_id = #{vo.confirmUserId} |
| | | </if> |
| | | ) |
| | | AND jtrfr.confirm_flag = #{vo.confirmFlag} |
| | | </if> |
| | | |
| | | <if test="vo.status != null"> |