From 9873e926fde8a52d3928dbae9649100b887b22a0 Mon Sep 17 00:00:00 2001
From: jiaosong <jiaosong6760@dingtalk.com>
Date: 星期一, 11 九月 2023 18:32:38 +0800
Subject: [PATCH] #公司查询 新增修改
---
server/service/src/main/java/com/doumee/service/business/impl/CompanyServiceImpl.java | 83 ++++++++++++++++++++++++++++++++++++++++-
1 files changed, 81 insertions(+), 2 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 257e018..1f1a2df 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,17 +5,29 @@
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.core.constants.ResponseStatus;
+import com.doumee.core.exception.BusinessException;
+import com.doumee.core.model.LoginUserInfo;
import com.doumee.core.model.PageData;
import com.doumee.core.model.PageWrap;
+import com.doumee.core.utils.Constants;
import com.doumee.core.utils.Utils;
import com.doumee.dao.business.CompanyMapper;
+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.model.SystemUser;
import com.doumee.service.business.CompanyService;
+import com.github.yulichang.wrapper.MPJLambdaWrapper;
+import org.apache.commons.lang3.StringUtils;
+import org.apache.shiro.SecurityUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.util.CollectionUtils;
+import java.util.Date;
import java.util.List;
+import java.util.Objects;
/**
* 绯荤粺-浼佷笟淇℃伅琛⊿ervice瀹炵幇
@@ -28,9 +40,41 @@
@Autowired
private CompanyMapper companyMapper;
+ @Autowired
+ private CompanyJoinMapper companyJoinMapper;
+
@Override
- public Integer create(Company company) {
- companyMapper.insert(company);
+ public Integer create(CompanyCreatOrUpdateRequest company) {
+ LoginUserInfo userInfo = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
+ Company insert = new Company();
+
+ if (Objects.isNull(company.getManagerId())){
+ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"鐧诲綍璐﹀彿涓嶅厑璁镐负绌�");
+ }
+ if (Objects.isNull(company.getOepnValidDate())){
+ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"鏈夋晥鏈熶笉鍏佽涓虹┖");
+ }
+ if (Objects.isNull(company.getUserNum())){
+ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"涓绘挱璐﹀彿鏁伴噺涓嶅厑璁镐负绌�");
+ }
+
+ insert.setDeleted((byte)Constants.ZERO);
+ insert.setCreateUser(userInfo.getId());
+ insert.setCreateTime(new Date());
+ insert.setUpdateUser(userInfo.getId());
+ insert.setUpdateTime(new Date());
+ insert.setName(company.getName());
+ insert.setShortName(company.getShortName());
+ insert.setRemark(company.getRemark());
+ insert.setManagerId(company.getManagerId());
+ insert.setLinkname(company.getLinkname());
+ insert.setLinkephone(company.getLinkephone());
+ insert.setCreditCode(company.getCreditCode());
+ insert.setUserNum(company.getUserNum());
+ insert.setOepnValidDate(company.getOepnValidDate());
+ insert.setOepnType(company.getOepnType());
+ insert.setSalesmanId(company.getSalesmanId());
+ companyMapper.insert(insert);
return company.getId();
}
@@ -51,6 +95,19 @@
return;
}
companyMapper.deleteBatchIds(ids);
+ }
+
+ @Override
+ public void updateById(CompanyCreatOrUpdateRequest company) {
+ UpdateWrapper<Company> wrapper = new UpdateWrapper<>();
+ wrapper.lambda().eq(Company::getId,company.getId())
+ .set(Company::getName,company.getName())
+ .set(Company::getShortName,company.getShortName())
+ .set(Company::getCreditCode,company.getCreditCode())
+ .set(Company::getSalesmanId,company.getSalesmanId())
+ .set(Company::getLinkname,company.getLinkname())
+ .set(Company::getLinkephone,company.getLinkephone());
+ companyMapper.update(null,wrapper);
}
@Override
@@ -122,6 +179,28 @@
return PageData.from(companyMapper.selectPage(page, queryWrapper));
}
+
+ @Override
+ public PageData<Company> findPlatformPage(PageWrap<Company> pageWrap) {
+ IPage<Company> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity());
+ MPJLambdaWrapper<Company> queryWrapper = new MPJLambdaWrapper<>();
+ Utils.MP.blankToNull(pageWrap.getModel());
+ queryWrapper.leftJoin(SystemUser.class,SystemUser::getId,Company::getManagerId);
+ queryWrapper.selectAll(Company.class)
+ .selectAs(SystemUser::getUsername,Company::getManagerUserName);
+ queryWrapper.select(
+ "(select su1.USERNAME from system_user su1 where su1.id = company.MANAGER_ID) as managerUserName," +
+ "(select su2.REALNAME from system_user su2 where su2.id = company.SALESMAN_ID) as salesmanRealName," +
+ "(select count(su3.id) from system_user su3 where su3.COMPANY_ID = company.ID and su3.TYPE = 2) as anchorUserNum," +
+ "(select count(su4.id) from system_user su4 where su4.COMPANY_ID = company.ID and su3.TYPE = 1) as empUserNum," +
+ "(select count(goods.id) from goods where g.COMPANY_ID = company.ID )goodsNum");
+ queryWrapper.eq(Company::getName,pageWrap.getModel().getName())
+ .like(SystemUser::getUsername,pageWrap.getModel().getManagerUserName())
+ .eq(Company::getStatus,pageWrap.getModel().getStatus())
+ .between(Company::getOepnValidDate,pageWrap.getModel().getOepnValidDateStart(),pageWrap.getModel().getOepnValidDateEnd());
+ return PageData.from(companyMapper.selectPage(page, queryWrapper));
+ }
+
@Override
public long count(Company company) {
QueryWrapper<Company> wrapper = new QueryWrapper<>(company);
--
Gitblit v1.9.3