| | |
|---|
| | | @Override |
|---|
| | | public List<Company> findList(Company company) { |
|---|
| | | MPJLambdaWrapper<Company> queryWrapper = new MPJLambdaWrapper<>(); |
|---|
| | | queryWrapper.eq(Company::getIsdeleted,Constants.ZERO) ; |
|---|
| | | if (company.getId() != null) { |
|---|
| | | queryWrapper.eq(Company::getId, company.getId()); |
|---|
| | | } |
|---|
| | |
|---|
| | | .select("(select count(m.id) from member m where m.COMPANY_ID=t.id and m.ISDELETED=0) as countNum") ; |
|---|
| | | queryWrapper.select("t1.name",Company::getParentName); |
|---|
| | | queryWrapper.select("t1.company_path",Company::getParentCompanyPath); |
|---|
| | | queryWrapper.apply(" t.isdeleted = 0 ") ; |
|---|
| | | queryWrapper.eq(Objects.nonNull(company.getStatus()),Company::getStatus,Constants.ZERO); |
|---|
| | | queryWrapper.like(StringUtils.isNotBlank(company.getName()),Company::getName,company.getName()); |
|---|
| | | queryWrapper.like(StringUtils.isNotBlank(company.getParentName()),"c.name",company.getParentName()); |
|---|
