| | |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public PageData<MemberInfoDTO> findMemberInfoPage(PageWrap<MemberQuery> pageWrap) { |
|---|
| | | /* //是否是数字 |
|---|
| | | boolean number = Validator.isNumber(pageWrap.getModel().getKeyWords()); |
|---|
| | | //是否是数字 |
|---|
| | | /* boolean number = Validator.isNumber(pageWrap.getModel().getKeyWords()); |
|---|
| | | //是否包含中文 |
|---|
| | | boolean b = Validator.hasChinese(pageWrap.getModel().getKeyWords()); |
|---|
| | | //是否包含英文 |
|---|
| | |
|---|
| | | 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.USERNAME from user_action uac left join system_user su on su.id=uac.CREATOR 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 concat(su.USERNAME,'&&',uac.create_date) from user_action uac left join system_user su on su.id=uac.CREATOR 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"); |
|---|
| | | |
|---|
