| | |
| | | } |
| | | } |
| | | return r; |
| | | } else if (0 == partyBuildingMemberVO.getAuditResult() && R.isOk(updated)) { |
| | | } else if (3 == partyBuildingMemberVO.getAuditResult() && R.isOk(updated)) { |
| | | R r = userService.updateUserNotPartymember(userIdcard); |
| | | if (R.isOk(r)) { |
| | | SysUserNoticeVO sysUserNoticeVO = new SysUserNoticeVO(); |
| | |
| | | "CASE\n" + |
| | | "WHEN u.id_card IS NULL THEN\n" + |
| | | "'未注册' ELSE '已注册' \n" + |
| | | "END STATUS \n" + |
| | | "END STATUS," + |
| | | " m.create_at \n" + |
| | | "FROM\n" + |
| | | "com_pb_member m\n" + |
| | | "LEFT JOIN sys_user u ON m.id_card = u.id_card\n" + |