| | |
|---|
| | | queryWrapper.selectAs(Company::getName,Visits::getReceptMemberDepartment); |
|---|
| | | queryWrapper.leftJoin(Member.class,Member::getId,Visits::getReceptMemberId); |
|---|
| | | queryWrapper.leftJoin(Company.class,Company::getId,Member::getCompanyId); |
|---|
| | | queryWrapper.leftJoin(" member m on m.id=t.MEMBER_ID"); |
|---|
| | | |
|---|
| | | queryWrapper.ne(Member::getType,Constants.TWO); |
|---|
| | | queryWrapper.ne("m.type ",Constants.TWO); |
|---|
| | | queryWrapper.eq(Visits::getIsdeleted,Constants.ZERO); |
|---|
| | | queryWrapper.eq(Objects.nonNull(pageWrap.getModel().getType()),Visits::getType,pageWrap.getModel().getType()); |
|---|
| | | queryWrapper.and(StringUtils.isNotBlank(pageWrap.getModel().getName()),ms->ms.like(Visits::getPhone,pageWrap.getModel().getName()) |
|---|
