| | |
|---|
| | | @Override |
|---|
| | | public List<Company> findList(Company company) { |
|---|
| | | MPJLambdaWrapper<Company> queryWrapper = new MPJLambdaWrapper<>(); |
|---|
| | | company.setIsdeleted(Constants.ZERO); |
|---|
| | | if (company.getId() != null) { |
|---|
| | | queryWrapper.eq(Company::getId, company.getId()); |
|---|
| | | } |
|---|
| | |
|---|
| | | queryWrapper.ge(Company::getFsDate, Utils.Date.getStart(company.getFsDate())); |
|---|
| | | queryWrapper.le(Company::getFsDate, Utils.Date.getEnd(company.getFsDate())); |
|---|
| | | } |
|---|
| | | if (company.getQueryHiddenDanger() != null && Constants.equalsInteger(company.getQueryHiddenDanger(),Constants.ONE)) { |
|---|
| | | queryWrapper.apply(" t.id in ( select hdp.COMPANY_ID from hidden_danger_param hdp where hdp.ISDELETED = 0 and hdp.STATUS = 0 and hdp.TYPE = 0 ) "); |
|---|
| | | } |
|---|
| | | queryWrapper.orderByDesc(Company::getCreateDate); |
|---|
| | | queryWrapper.leftJoin(Company.class,Company::getId,Company::getParentId); |
|---|
| | | queryWrapper.select(" t.* ") |
|---|
| | | .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()); |
|---|
| | |
|---|
| | | queryWrapper.leftJoin(Member.class,Member::getId,Company::getHeadId); |
|---|
| | | queryWrapper.leftJoin(SystemUser.class,SystemUser::getId,Company::getEditor); |
|---|
| | | queryWrapper.eq(Company::getIsdeleted,Constants.ZERO); |
|---|
| | | queryWrapper.eq(type!=null,Company::getType,type); |
|---|
| | | if(Objects.nonNull(type) && ( Constants.equalsInteger(type,Constants.ONE) || Constants.equalsInteger(type,Constants.ZERO))){ |
|---|
| | | queryWrapper.eq(type!=null,Company::getType,type); |
|---|
| | | }else if(Objects.nonNull(type) && Constants.equalsInteger(type,Constants.TWO)){ |
|---|
| | | String companySpecialId = systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.SPECIAL_COMPANY_ID).getCode(); |
|---|
| | | if(StringUtils.isNotBlank(companySpecialId)){ |
|---|
| | | queryWrapper.apply(" (find_in_set('"+companySpecialId+"',REPLACE(t.company_path,'/',',')) or t.parent_id is null ) "); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | queryWrapper.orderByAsc(true,"t.sortnum"); |
|---|
| | | List<Company> companyList = companyJoinMapper.selectJoinList(Company.class,queryWrapper); |
|---|
| | | //配置组员人员类型来源方式 0自建 1ERP |
|---|
