| | |
| | | "JOIN com_pb_member me ON m.member_id = me.id\n" + |
| | | "LEFT JOIN sys_user u ON me.id_card = u.id_card \n" + |
| | | "WHERE\n" + |
| | | "m.activity_id = 1 \n" + |
| | | "<if test='name != null and name.trim() != ""'>" + |
| | | "AND me.`name` = #{name} \n" + |
| | | "m.activity_id = #{pageActivityMembersVO.activityId} \n" + |
| | | "<if test='pageActivityMembersVO.name != null and pageActivityMembersVO.name.trim() != ""'>" + |
| | | "AND me.`name` = #{pageActivityMembersVO.name} \n" + |
| | | " </if> " + |
| | | "<if test='phone != null and phone.trim() != ""'>" + |
| | | "AND u.phone = #{phone}" + |
| | | "<if test='pageActivityMembersVO.phone != null and pageActivityMembersVO.phone.trim() != ""'>" + |
| | | "AND u.phone = #{pageActivityMembersVO.phone}" + |
| | | " </if> " + |
| | | "</script>") |
| | | IPage<PageActivityMembersVO> pageActivityMembers(Page page, @Param("pageActivityMembersVO") PageActivityMembersVO pageActivityMembersVO); |