| | |
|---|
| | | + "DATE_FORMAT( NOW(), '%Y-%m-%d' )) partyAge,\n" + "m.join_time,\n" + "m.employment_time,\n" + "CASE\n" |
|---|
| | | + "WHEN u.id_card IS NULL THEN\n" + "'未注册' ELSE '已注册' \n" + "END STATUS \n" + "FROM\n" + "com_pb_member m\n" |
|---|
| | | + "LEFT JOIN sys_user u ON m.id_card = u.id_card\n" + "LEFT JOIN com_pb_org o ON m.org_id = o.id" |
|---|
| | | + " where m.community_id=#{pagePartyOrganizationVO.communityId} and m.audit_result='1' " |
|---|
| | | + " where m.community_id = #{pagePartyOrganizationVO.communityId} and m.audit_result='1' " |
|---|
| | | + "<if test='pagePartyOrganizationVO.orgName != null and pagePartyOrganizationVO.orgName != ""'>" |
|---|
| | | + "and o.name like concat(#{pagePartyOrganizationVO.orgName},'%') " + " </if> " |
|---|
| | | + "<if test='pagePartyOrganizationVO.orgId != null'>" + " and o.id = #{pagePartyOrganizationVO.orgId} " |
|---|
