From dcdb0231034810232f2542f3865666ebf72daf11 Mon Sep 17 00:00:00 2001 From: jiangping <jp@doumee.com> Date: 星期三, 30 四月 2025 16:45:34 +0800 Subject: [PATCH] sf --- server/service/src/main/java/com/doumee/service/business/impl/CompanyServiceImpl.java | 27 +++++++++++++-------------- 1 files changed, 13 insertions(+), 14 deletions(-) diff --git a/server/service/src/main/java/com/doumee/service/business/impl/CompanyServiceImpl.java b/server/service/src/main/java/com/doumee/service/business/impl/CompanyServiceImpl.java index 8f6815e..0c55e2a 100644 --- a/server/service/src/main/java/com/doumee/service/business/impl/CompanyServiceImpl.java +++ b/server/service/src/main/java/com/doumee/service/business/impl/CompanyServiceImpl.java @@ -5,7 +5,6 @@ import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; -import com.doumee.biz.system.SystemDictBiz; import com.doumee.biz.system.SystemDictDataBiz; import com.doumee.core.constants.ResponseStatus; import com.doumee.core.exception.BusinessException; @@ -18,15 +17,12 @@ import com.doumee.dao.business.join.CompanyJoinMapper; import com.doumee.dao.business.model.Company; import com.doumee.dao.business.model.dto.CompanyCreatOrUpdateRequest; -import com.doumee.dao.system.SystemDictMapper; import com.doumee.dao.system.SystemUserMapper; import com.doumee.dao.system.SystemUserRoleMapper; -import com.doumee.dao.system.model.SystemDict; import com.doumee.dao.system.model.SystemDictData; import com.doumee.dao.system.model.SystemUser; import com.doumee.dao.system.model.SystemUserRole; import com.doumee.service.business.CompanyService; -import com.doumee.service.system.SystemDictService; import com.github.yulichang.wrapper.MPJLambdaWrapper; import org.apache.commons.lang3.RandomStringUtils; import org.apache.commons.lang3.StringUtils; @@ -118,7 +114,7 @@ insert.setStatus(Constants.ZERO); companyMapper.insert(insert); //鍒涘缓浼佷笟鐢ㄦ埛 - SystemUser companyUser = createCompanyUser(company.getManagerUserName(), insert.getId()); + SystemUser companyUser = createCompanyUser(company, insert.getId()); Company update = new Company(); update.setId(insert.getId()); update.setManagerId(companyUser.getId()); @@ -137,14 +133,14 @@ return company.getId(); } - private SystemUser createCompanyUser(String managerUserName,Integer companyId){ + private SystemUser createCompanyUser(CompanyCreatOrUpdateRequest company, Integer companyId){ QueryWrapper<SystemUser> query = new QueryWrapper<>(); query.lambda() .eq(SystemUser::getType,Constants.ONE) .eq(SystemUser::getDeleted,Boolean.FALSE) - .eq(SystemUser::getUsername,managerUserName); - Integer integer = systemUserMapper.selectCount(query); + .eq(SystemUser::getUsername,company.getManagerUserName()); + Long integer = systemUserMapper.selectCount(query); if (integer > Constants.ZERO){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"璐﹀彿宸插瓨鍦ㄨ閲嶆柊杈撳叆璐﹀彿"); } @@ -153,10 +149,12 @@ SystemDictData dictDataPassword = systemDictDataBiz.queryByCode(Constants.SYSTEM, Constants.DEFAULT_PASSWORD); String salt = RandomStringUtils.randomAlphabetic(6); SystemUser user = new SystemUser(); - user.setUsername(managerUserName); + user.setUsername(company.getManagerUserName()); user.setPassword(Utils.Secure.encryptPassword(dictDataPassword.getCode(), salt)); user.setSalt(salt); user.setCompanyId(companyId); + user.setMobile(company.getLinkephone()); + user.setRealname(company.getLinkname()); user.setType(Constants.ONE); user.setCreateTime(new Date()); user.setUpdateTime(new Date()); @@ -293,16 +291,17 @@ queryWrapper.selectAll(Company.class) .selectAs(SystemUser::getUsername,Company::getManagerUserName); queryWrapper.select( - "(select su1.USERNAME from system_user su1 where su1.id = t.MANAGER_ID) as managerUserName," + + "(select su1.USERNAME from system_user su1 where su1.id = t.MANAGER_ID) as managerUserName," + "(select su2.REALNAME from system_user su2 where su2.id = t.SALESMAN_ID) as salesmanRealName," + - "(select count(su3.id) from system_user su3 where su3.COMPANY_ID = t.ID and su3.TYPE = 2) as anchorUserNum," + - "(select count(su4.id) from system_user su4 where su4.COMPANY_ID = t.ID and su4.TYPE = 1) as empUserNum," + - "(select count(g.id) from goods g where g.COMPANY_ID = t.ID )goodsNum"); + "(select count(su3.id) from system_user su3 where su3.deleted=0 and su3.COMPANY_ID = t.ID and su3.TYPE = 2) as anchorUserNum," + + "(select count(su4.id) from system_user su4 where su4.deleted=0 and su4.COMPANY_ID = t.ID and su4.TYPE = 1) as empUserNum," + + "(select count(g.id) from goods g where g.isdeleted=0 and g.COMPANY_ID = t.ID )goodsNum"); queryWrapper.like(StringUtils.isNotBlank(pageWrap.getModel().getName()),Company::getName,pageWrap.getModel().getName()) .like(StringUtils.isNotBlank(pageWrap.getModel().getManagerUserName()),SystemUser::getUsername,pageWrap.getModel().getManagerUserName()) .eq(Objects.nonNull(pageWrap.getModel().getStatus()),Company::getStatus,pageWrap.getModel().getStatus()) .between((Objects.nonNull(pageWrap.getModel().getOepnValidDateStart()) && Objects.nonNull(pageWrap.getModel().getOepnValidDateEnd())), - Company::getOepnValidDate,pageWrap.getModel().getOepnValidDateStart(),pageWrap.getModel().getOepnValidDateEnd()); + Company::getOepnValidDate,pageWrap.getModel().getOepnValidDateStart(),pageWrap.getModel().getOepnValidDateEnd()) + .orderByDesc(Company::getCreateTime); return PageData.from(companyJoinMapper.selectJoinPage(page,Company.class,queryWrapper)); } -- Gitblit v1.9.3