| | |
|---|
| | | List<Solutions> solutionsList = solutionsJoinMapper.selectJoinList(Solutions.class,new MPJLambdaWrapper<Solutions>() |
|---|
| | | .selectAll(Solutions.class) |
|---|
| | | .leftJoin(CompanySolution.class,CompanySolution::getSolutionId,Solutions::getId) |
|---|
| | | .leftJoin(Company.class,Company::getId,CompanySolution::getCompanyId) |
|---|
| | | .leftJoin(Insurance.class,Insurance::getId,Solutions::getInsuranceId) |
|---|
| | | .eq(Solutions::getIsdeleted,Constants.ZERO) |
|---|
| | | .eq(Solutions::getStatus,Constants.ZERO) |
|---|
| | | .eq(Solutions::getDataType,dataType) |
|---|
| | | .eq(CompanySolution::getIsdeleted,Constants.ZERO) |
|---|
| | | .eq(CompanySolution::getCompanyId,user.getCompanyId()) |
|---|
| | | .eq(Company::getIsdeleted,Constants.ZERO) |
|---|
| | | .eq(Company::getStatus,Constants.ZERO) |
|---|
| | | .eq(Insurance::getIsdeleted,Constants.ZERO) |
|---|
| | | .eq(Insurance::getStatus,Constants.ZERO) |
|---|
| | | .orderByAsc(Solutions::getSortnum) |
|---|
| | | ); |
|---|
| | | return solutionsList; |
|---|
