| | |
| | | "f.photo_path,\n" + |
| | | "c.name communityName\n" + |
| | | "from sys_user_feedback f\n" + |
| | | "join sys_user u on f.user_id=u.user_id\n" + |
| | | "left join sys_user u on f.user_id=u.user_id\n" + |
| | | "left join com_act c on u.community_id=c.community_id\n" + |
| | | "<where>" + |
| | | "<if test='pageFeedBackDTO.phone != null and pageFeedBackDTO.phone.trim() != ""'>" + |
| | | "and u.phone=#{pageFeedBackDTO.phone}\n" + |
| | | " </if> " + |
| | |
| | | "and u.name like concat('%',#{pageFeedBackDTO.name},'%') \n" + |
| | | " </if> " + |
| | | "<if test='pageFeedBackDTO.nickName != null and pageFeedBackDTO.nickName.trim() != ""'>" + |
| | | "and u.nick_name=like concat('%',#{pageFeedBackDTO.nickName},'%') \n" + |
| | | "and u.nick_name like concat('%',#{pageFeedBackDTO.nickName},'%') \n" + |
| | | " </if> " + |
| | | "join com_act c on u.community_id=c.community_id\n" + |
| | | "</where> " + |
| | | "order by f.create_at desc\n" + |
| | | "</script>") |
| | | IPage<SysUserFeedbackVO> pageFeedback(Page page, @Param("pageFeedBackDTO") PageFeedBackDTO pageFeedBackDTO); |