| | |
| | | "LEFT JOIN com_pb_org o ON m.org_id = o.id"+ |
| | | " where m.audit_result in (0,3) " + |
| | | "<if test='pagePartyBuildingMemberVO.phone != null and pagePartyBuildingMemberVO.phone != ""'>" + |
| | | " and u.phone = #{pagePartyBuildingMemberVO.phone} "+ |
| | | " and u.phone LIKE CONCAT('%',#{pagePartyBuildingMemberVO.phone},'%') "+ |
| | | " </if> " + |
| | | "<if test='pagePartyBuildingMemberVO.name != null and pagePartyBuildingMemberVO.name != ""'>" + |
| | | " and u.name like concat (#{pagePartyBuildingMemberVO.name},'%')"+ |
| | | " and u.name like concat ('%',#{pagePartyBuildingMemberVO.name},'%')"+ |
| | | " </if> " + |
| | | "<if test='pagePartyBuildingMemberVO.auditStatus != null'>" + |
| | | " and m.audit_result = #{pagePartyBuildingMemberVO.auditStatus}"+ |