From bc87b51e20a0adf0badf2033ede93cafeb5fc147 Mon Sep 17 00:00:00 2001 From: jiangping <jp@doumee.com> Date: 星期三, 27 十一月 2024 17:29:59 +0800 Subject: [PATCH] 开发更新 --- server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/CompanyServiceImpl.java | 71 +++++++++++++++++++++++++++-------- 1 files changed, 55 insertions(+), 16 deletions(-) diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/CompanyServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/CompanyServiceImpl.java index e7aa1ca..b056465 100644 --- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/CompanyServiceImpl.java +++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/CompanyServiceImpl.java @@ -64,9 +64,36 @@ @Autowired private CompanyJoinMapper companyJoinMapper; + /** + * 鍒涘缓璐㈠姟鍏徃 + * @param company + * @return + */ + @Override + public Integer createFinanceCompany(Company company) { + company.setType(Constants.TWO); + if(companyMapper.selectCount(new QueryWrapper<Company>().lambda() + .eq(Company::getName,company.getName()) + .eq(Company::getType,company.getType()) + .eq(Company::getIsdeleted,Constants.ZERO)) >0){ + throw new BusinessException(ResponseStatus.DATA_EXISTS.getCode(), "瀵逛笉璧凤紝鍚嶇О涓嶈兘閲嶅~"); + } + company.setCreateDate(new Date()); + company.setCreator(company.getLoginUserInfo().getId()); + company.setIsdeleted(Constants.ZERO); + company.setStatus(Constants.ZERO); + company.setSortnum(0);//榛樿鏈�涓婇潰 + company.setHkDate(company.getCreateDate()); + company.setEditDate(company.getCreateDate()); + company.setEditor(company.getCreator()); + companyMapper.insert(company); + return company.getId(); + } + @Override @Transactional(rollbackFor = {BusinessException.class,Exception.class}) public Integer create(Company company) { + company.setType(Constants.ONE); if(StringUtils.isBlank(company.getName())){ throw new BusinessException(ResponseStatus.BAD_REQUEST); } @@ -120,9 +147,9 @@ company.setHkId(UUID.randomUUID().toString().replace("-","")); companyMapper.insert(company); //涓嬪彂娴峰悍瀹夐槻骞冲彴 - if(!addHkOrg(company)){ - throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),"瀵逛笉璧凤紝缁勭粐鍚屾涓嬪彂澶辫触锛岃绋嶅悗閲嶈瘯"); - } +// if(!addHkOrg(company)){ +// throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),"瀵逛笉璧凤紝缁勭粐鍚屾涓嬪彂澶辫触锛岃绋嶅悗閲嶈瘯"); +// } Company com = new Company(); com.setId(company.getId()); com.setCompanyPath(idPath+company.getId()+"/"); @@ -243,9 +270,9 @@ company.setHkDate(company.getHkDate()); companyMapper.updateById(company); //涓嬪彂娴峰悍瀹夐槻骞冲彴 - if(StringUtils.isNotBlank(model.getHkId()) && Constants.equalsInteger(Constants.ONE,model.getHkStatus()) && !delHkOrg(model)){ - throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),"瀵逛笉璧凤紝缁勭粐鍒犻櫎涓嬪彂澶辫触锛岃纭璇ョ粍缁囨棤涓嬬骇缁勭粐鎴栫粍缁囦汉鍛樹俊鎭瘇"); - } +// if(StringUtils.isNotBlank(model.getHkId()) && Constants.equalsInteger(Constants.ONE,model.getHkStatus()) && !delHkOrg(model)){ +// throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),"瀵逛笉璧凤紝缁勭粐鍒犻櫎涓嬪彂澶辫触锛岃纭璇ョ粍缁囨棤涓嬬骇缁勭粐鎴栫粍缁囦汉鍛樹俊鎭瘇"); +// } } @Override @@ -313,7 +340,7 @@ .setSql("hk_company_path=REPLACE(hk_company_path,'"+ model.getCompanyNamePath()+"','"+newName+"')") .likeRight(Company::getCompanyPath,model.getCompanyPath())); //涓嬪彂娴峰悍瀹夐槻骞冲彴 - if(StringUtils.isNotBlank(model.getHkId())){ + /* if(StringUtils.isNotBlank(model.getHkId())){ if(!editHkOrg(company)){ throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),"瀵逛笉璧凤紝缁勭粐鍚屾涓嬪彂澶辫触锛岃绋嶅悗閲嶈瘯"); } @@ -321,7 +348,7 @@ if(!addHkOrg(company)){ throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),"瀵逛笉璧凤紝缁勭粐鍚屾涓嬪彂澶辫触锛岃绋嶅悗閲嶈瘯"); } - } + }*/ } @@ -330,6 +357,18 @@ checkUnique(company); companyMapper.updateById(company); return null; + } + @Override + public Integer updateFinanceCompany(Company company) { + if(companyMapper.selectCount(new QueryWrapper<Company>().lambda() + .eq(Company::getName,company.getName()) + .eq(Company::getType,company.getType()) + .ne(Company::getId,company.getId()) + .eq(Company::getIsdeleted,Constants.ZERO)) >0){ + throw new BusinessException(ResponseStatus.DATA_EXISTS.getCode(), "瀵逛笉璧凤紝鍚嶇О涓嶈兘閲嶅~"); + } + companyMapper.updateById(company); + return company.getId(); } @Override @@ -453,7 +492,7 @@ 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.leftJoin("company t1 on t1.id=t.parent_id"); 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); @@ -461,7 +500,7 @@ 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.like(StringUtils.isNotBlank(company.getParentName()),"t1.name",company.getParentName()); return companyMapper.selectList(queryWrapper); } @@ -565,23 +604,22 @@ queryWrapper.le(Company::getFsDate, Utils.Date.getEnd(pageWrap.getModel().getFsDate())); } queryWrapper.orderByDesc(Company::getCreateDate); - queryWrapper.leftJoin(Company.class,Company::getId,Company::getParentId); - /* .leftJoin(Member.class, Member::getId,Company::getHeadId)*/ - /* queryWrapper.leftJoin(" company c on c.id=t.parent_id");*/ + queryWrapper.leftJoin("company t1 on t1.id=t.parant_id"); queryWrapper.selectAll(Company.class) - .select("(select count(m.id) from member m where m.COMPANY_ID=t.id and m.ISDELETED=0) as countNum") ; + .select("(select count(m.id) from member m where m.COMPANY_ID=t.id and m.ISDELETED=0) ",Company::getCountNum) + .select("(select count(m.id) from yw_account m where m.COMPANY_ID=t.id and m.ISDELETED=0)",Company::getAccountNum) ; queryWrapper.select("t1.name",Company::getParentName); queryWrapper.select("t1.company_path",Company::getParentCompanyPath); queryWrapper.eq(Objects.nonNull(pageWrap.getModel().getStatus()),Company::getStatus,Constants.ZERO); queryWrapper.like(StringUtils.isNotBlank(pageWrap.getModel().getName()),Company::getName,pageWrap.getModel().getName()); - queryWrapper.like(StringUtils.isNotBlank(pageWrap.getModel().getParentName()),"c.name",pageWrap.getModel().getParentName()); + queryWrapper.like(StringUtils.isNotBlank(pageWrap.getModel().getParentName()),"t1.name",pageWrap.getModel().getParentName()); IPage<Company> companyIPage = companyJoinMapper.selectJoinPage(page, Company.class, queryWrapper); return PageData.from(companyIPage); } @Override public void updateStatusById(Company company) { - LoginUserInfo loginUserInfo = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal(); + LoginUserInfo loginUserInfo = company.getLoginUserInfo(); if(loginUserInfo==null){ loginUserInfo = company.getLoginUserInfo(); } @@ -650,6 +688,7 @@ QueryWrapper<Company> wrapper = new QueryWrapper<>(); wrapper.lambda() .eq(Company::getIsdeleted,Constants.ZERO) + .eq(Company::getType,company.getType()) .eq(Company::getName,company.getName()); List<Company> companies = companyMapper.selectList(wrapper); if (CollectionUtils.isEmpty(companies)){ -- Gitblit v1.9.3