| | |
|---|
| | | queryWrapper.selectAll(Retention.class) |
|---|
| | | .selectAs(Company::getName,Retention::getCompanyName) |
|---|
| | | .selectAs(Company::getType,Retention::getCompanyType) |
|---|
| | | .select(" ( SELECT v.company_name FROM visits v WHERE v.member_id = t.member_id and v.status = "+Constants.VisitStatus.signin+" ORDER BY create_date DESC limit 1 ) as visitCompanyName "); |
|---|
| | | queryWrapper.eq(Retention::getIsdeleted,Constants.ZERO) |
|---|
| | | .eq(Company::getIsdeleted,Constants.ZERO) |
|---|
| | | .select(" ( SELECT v.company_name FROM visits v WHERE v.member_id = t.member_id and v.status = "+Constants.VisitStatus.signin+" ORDER BY create_date DESC limit 1 ) as visitCompanyName ") |
|---|
| | | .selectAs(Category::getBizType,Retention::getBizType) |
|---|
| | | .leftJoin(Category.class,Category::getId,Retention::getCategoryId) |
|---|
| | | .eq(Retention::getIsdeleted,Constants.ZERO) |
|---|
| | | // .eq(Company::getIsdeleted,Constants.ZERO) |
|---|
| | | .and(StringUtils.isNotBlank(pageWrap.getModel().getKeyWords()),w->{ |
|---|
| | | w.like( Retention::getPhone,pageWrap.getModel().getKeyWords()) |
|---|
| | | .or().like( Retention::getName,pageWrap.getModel().getKeyWords()); }) |
|---|
| | |
|---|
| | | Retention::getType,Constants.FOUR) |
|---|
| | | .eq(Objects.nonNull(pageWrap.getModel().getQueryUserType())&&Constants.equalsInteger(pageWrap.getModel().getQueryUserType(),Constants.TWO), |
|---|
| | | Retention::getType,Constants.TWO) |
|---|
| | | .eq(Objects.nonNull(pageWrap.getModel().getBizType()), |
|---|
| | | Category::getBizType,pageWrap.getModel().getBizType()) |
|---|
| | | //过滤车辆数据 |
|---|
| | | .ne(Retention::getType,3) |
|---|
| | | .and(StringUtils.isNotBlank(pageWrap.getModel().getCompanyName()), |
|---|
