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