server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/CompanyServiceImpl.java
@@ -436,6 +436,7 @@ MPJLambdaWrapper<Company> queryWrapper = new MPJLambdaWrapper<>(); queryWrapper.selectAll(Company.class); queryWrapper.like(company.getName() != null,Company::getName, company.getName()); queryWrapper.eq(Company::getStatus, Constants.ZERO); queryWrapper.eq(Company::getType, Constants.TWO); queryWrapper.eq(Company::getIsdeleted, Constants.ZERO); queryWrapper.exists("select b.id from yw_account b where b.isdeleted=0 and b.company_id=t.id and b.status=0");