| | |
|---|
| | | queryWrapper.leftJoin(Company.class,Company::getId,Member::getCompanyId); |
|---|
| | | queryWrapper.selectAll(Member.class) |
|---|
| | | .selectAs(Company::getName,MemberInfoDTO::getCompanyName) |
|---|
| | | .select(" (select count(v.id) from visits v where v.MEMBER_ID=t.id and v.ISDELETED=0 and v.status = 2 ) as visitsCount") |
|---|
| | | .select(" (select STARTTIME from visits v where v.MEMBER_ID=t.id and v.ISDELETED=0 and v.status = 2 order by CREATE_DATE limit 1) as visitsLastDate"); |
|---|
| | | |
|---|
| | | .selectAs(Member::getLastVisitDate,MemberInfoDTO::getVisitsLastDate) |
|---|
| | | .select(" (select count(v.id) from visits v where v.MEMBER_ID=t.id and v.ISDELETED=0 and v.status in (7,8) ) as visitsCount"); |
|---|
| | | queryWrapper.like(StringUtils.isNotBlank(pageWrap.getModel().getName()),Member::getName,pageWrap.getModel().getName()) |
|---|
| | | .like(StringUtils.isNotBlank(pageWrap.getModel().getPhone()),Member::getPhone,pageWrap.getModel().getPhone()) |
|---|
| | | .and(StringUtils.isNotBlank(pageWrap.getModel().getCompanyName()), ms->ms.like(Member::getVisitCompanyName,pageWrap.getModel().getCompanyName()) |
|---|
