| | |
|---|
| | | userAction.setCreator(loginUserInfo.getId()); |
|---|
| | | if(Constants.equalsInteger(result.getType(),Constants.TWO)){ |
|---|
| | | userAction.setType(Constants.ONE); |
|---|
| | | userAction.setRemark("由【"+loginUserInfo.getUsername()+"】于【操作时间"+new Date()+"】，进行【冻结】"); |
|---|
| | | } |
|---|
| | | if(Constants.equalsInteger(result.getType(),Constants.ZERO)){ |
|---|
| | | userAction.setType(Constants.TWO); |
|---|
| | | userAction.setRemark("由【"+loginUserInfo.getUsername()+"】于【操作时间"+new Date()+"】，进行【拉黑】"); |
|---|
| | | |
|---|
| | | } |
|---|
| | | userAction.setMemberId(result.getId()+""); |
|---|
| | | userAction.setBeforeStatus(status); |
|---|
| | |
|---|
| | | IPage<Member> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); |
|---|
| | | MPJLambdaWrapper<Member> queryWrapper = new MPJLambdaWrapper<>(); |
|---|
| | | queryWrapper.leftJoin(Company.class,Company::getId,Member::getCompanyId); |
|---|
| | | queryWrapper.leftJoin(SystemUser.class,SystemUser::getId,Member::getCreator); |
|---|
| | | queryWrapper.selectAs(SystemUser::getUsername,MemberInfoDTO::getCreatorName); |
|---|
| | | queryWrapper.selectAll(Member.class) |
|---|
| | | .selectAs(Company::getName,MemberInfoDTO::getCompanyName) |
|---|
| | | .select(" (select ua.CREATE_DATE from user_action ua where ua.MEMBER_ID=t.id and ua.ISDELETED=0 and ua.type=1 order by ua.CREATE_DATE limit 1) as userActionType1") |
|---|
| | | .select(" (select su.remark from user_action uac where uac.MEMBER_ID=t.id and uac.ISDELETED=0 and uac.type=1 order by uac.CREATE_DATE limit 1) as creatorName") |
|---|
| | | /* .select(" (select count(v.id) from visits v where v.MEMBER_ID=t.id and v.ISDELETED=0) as visitsCount")*/ |
|---|
| | | .select(" (select STARTTIME from visits v where v.MEMBER_ID=t.id and v.ISDELETED=0 order by CREATE_DATE limit 1) as visitsLastDate"); |
|---|
| | | |
|---|
