| | |
| | | "c.name communityName\n" + |
| | | "from sys_user_feedback f\n" + |
| | | "join sys_user u on f.user_id=u.user_id\n" + |
| | | "<if test='pageFeedBackDTO.name != null and pageFeedBackDTO.name.trim() != ""'>" + |
| | | "and u.name=#{pageFeedBackDTO.name}\n" + |
| | | " </if> " + |
| | | "<if test='pageFeedBackDTO.nickName != null and pageFeedBackDTO.nickName.trim() != ""'>" + |
| | | "and u.nick_name=#{pageFeedBackDTO.nickName}\n" + |
| | | " </if> " + |
| | | "<if test='pageFeedBackDTO.phone != null and pageFeedBackDTO.phone.trim() != ""'>" + |
| | | "and u.phone=#{pageFeedBackDTO.phone}\n" + |
| | | " </if> " + |
| | | "<if test='pageFeedBackDTO.name != null and pageFeedBackDTO.name.trim() != ""'>" + |
| | | "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" + |
| | | " </if> " + |
| | | "join com_act c on u.community_id=c.community_id\n" + |
| | | "order by f.create_at desc\n" + |
| | | "</script>") |