package com.by4cloud.platformx.business.service.impl;
|
|
import cn.hutool.core.collection.CollUtil;
|
import cn.hutool.core.util.ObjUtil;
|
import cn.hutool.core.util.StrUtil;
|
import cn.hutool.http.HttpRequest;
|
import cn.hutool.http.HttpResponse;
|
import cn.hutool.http.HttpUtil;
|
import com.alibaba.fastjson.JSONObject;
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import com.by4cloud.platformx.admin.api.entity.SysDept;
|
import com.by4cloud.platformx.admin.api.vo.DeptExcelVO;
|
import com.by4cloud.platformx.business.dto.ContractSubjectMatterAddDTO;
|
import com.by4cloud.platformx.business.dto.ContractSubjectMatterAnnotateDTO;
|
import com.by4cloud.platformx.business.entity.Contract;
|
import com.by4cloud.platformx.business.entity.ContractSubjectMatter;
|
import com.by4cloud.platformx.business.entity.Product;
|
import com.by4cloud.platformx.business.entity.TaxCode;
|
import com.by4cloud.platformx.business.mapper.ContractMapper;
|
import com.by4cloud.platformx.business.mapper.ContractSubjectMatterMapper;
|
import com.by4cloud.platformx.business.mapper.ProductMapper;
|
import com.by4cloud.platformx.business.mapper.TaxCodeMapper;
|
import com.by4cloud.platformx.business.service.ContractSubjectMatterService;
|
import com.by4cloud.platformx.business.vo.ContractSubjectMatterVo;
|
import com.by4cloud.platformx.business.vo.SubjectMatterExcelVO;
|
import com.by4cloud.platformx.common.core.util.R;
|
import com.by4cloud.platformx.common.data.datascope.DataScope;
|
import com.by4cloud.platformx.common.data.mybatis.BaseModel;
|
import com.by4cloud.platformx.common.excel.vo.ErrorMessage;
|
import com.by4cloud.platformx.common.security.util.SecurityUtils;
|
import com.github.yulichang.wrapper.MPJLambdaWrapper;
|
import lombok.RequiredArgsConstructor;
|
import lombok.extern.slf4j.Slf4j;
|
import org.springframework.beans.factory.annotation.Value;
|
import org.springframework.data.redis.core.StringRedisTemplate;
|
import org.springframework.stereotype.Service;
|
import org.springframework.validation.BindingResult;
|
|
import java.util.ArrayList;
|
import java.util.HashSet;
|
import java.util.List;
|
import java.util.Set;
|
|
/**
|
* 合同标的物明细表
|
*
|
* @author platformx
|
* @date 2026-04-29 16:39:29
|
*/
|
@Service
|
@RequiredArgsConstructor
|
@Slf4j
|
public class ContractSubjectMatterServiceImpl extends ServiceImpl<ContractSubjectMatterMapper, ContractSubjectMatter> implements ContractSubjectMatterService {
|
|
private final ContractMapper contractMapper;
|
|
private final ProductMapper productMapper;
|
|
private final TaxCodeMapper taxCodeMapper;
|
|
private final StringRedisTemplate redisTemplate;
|
|
@Value("${dept.smj}")
|
private String smj;
|
|
@Value("${dept.smjhw}")
|
private String smjhw;
|
|
@Value("${dept.smjsc}")
|
private String smjsc;
|
|
@Value("${dept.smjzt}")
|
private String smjzt;
|
|
@Value("${dept.sgb}")
|
private String sgb;
|
|
@Value("${dept.tfgs}")
|
private String tfgs;
|
|
@Value("${dept.jxc}")
|
private String jxc;
|
|
@Value("${dept.ymj}")
|
private String ymj;
|
|
@Value("${erp.smj}")
|
private String smjErp;
|
|
@Override
|
public R selectSubjectMatterProcess(Long id) {
|
MPJLambdaWrapper<ContractSubjectMatter> wrapper = new MPJLambdaWrapper<ContractSubjectMatter>()
|
.selectAll(ContractSubjectMatter.class)
|
.eq(ContractSubjectMatter::getContractId, id)
|
.orderByAsc(ContractSubjectMatter::getCreateTime);
|
List<ContractSubjectMatterVo> matterVoList = baseMapper.selectJoinList(ContractSubjectMatterVo.class, wrapper);
|
return R.ok(matterVoList);
|
}
|
|
@Override
|
public R selectSubjectMatter(Long contractId) {
|
return R.ok(baseMapper.selectList(Wrappers.<ContractSubjectMatter>lambdaQuery()
|
.eq(ContractSubjectMatter::getContractId, contractId)
|
.orderByAsc(ContractSubjectMatter::getCreateTime)));
|
}
|
|
@Override
|
public R importSubjectMatter(List<SubjectMatterExcelVO> excelVOList, BindingResult bindingResult) {
|
List<ErrorMessage> errorMessageList = (List<ErrorMessage>) bindingResult.getTarget();
|
List<ContractSubjectMatterAddDTO> addDTOList = new ArrayList<>();
|
for (SubjectMatterExcelVO item : excelVOList) {
|
Set<String> errorMsg = new HashSet<>();
|
if (StrUtil.isBlank(item.getMaterialCode())) {
|
errorMsg.add(item.getMaterialCode() + "erp编码不能为空");
|
// 数据不合法情况
|
errorMessageList.add(new ErrorMessage(item.getLineNum(), errorMsg));
|
continue;
|
}
|
if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", sgb) || StrUtil.equals(SecurityUtils.getUser().getCompId() + "", tfgs) ||
|
StrUtil.equals(SecurityUtils.getUser().getCompId() + "", jxc) || StrUtil.equals(SecurityUtils.getUser().getCompId() + "", ymj)) {
|
Product one = productMapper.selectOne(Wrappers.<Product>lambdaQuery()
|
.eq(Product::getErpCode, item.getMaterialCode())
|
.eq(Product::getCompId, SecurityUtils.getUser().getCompId())
|
.last("limit 1"));
|
if (ObjUtil.isNull(one)) {
|
errorMsg.add(item.getMaterialCode() + "erp编码不存在");
|
// 数据不合法情况
|
errorMessageList.add(new ErrorMessage(item.getLineNum(), errorMsg));
|
} else {
|
ContractSubjectMatterAddDTO addDTO = new ContractSubjectMatterAddDTO();
|
addDTO.setMaterialCode(item.getMaterialCode());
|
addDTO.setMaterialInternalName(one.getProductName());
|
addDTO.setMaterialName(item.getMaterialName());
|
addDTO.setUnitPrice(item.getUnitPrice());
|
addDTO.setQuantity(item.getQuantity());
|
addDTO.setSpecification(one.getProductType());
|
addDTOList.add(addDTO);
|
}
|
}
|
|
if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smj) || StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smjhw)) {
|
List<String> smjList = new ArrayList<>();
|
smjList.add(smj);
|
smjList.add(smjhw);
|
Product one = productMapper.selectOne(Wrappers.<Product>lambdaQuery()
|
.eq(Product::getErpCode, item.getMaterialCode())
|
.in(Product::getCompId, smjList)
|
.last("limit 1"));
|
if (ObjUtil.isNull(one)) {
|
JSONObject object = syncProductBySMJ("tenant1", item.getMaterialCode());
|
if (ObjUtil.isNotNull(object)) {
|
Product productClass = productMapper.selectOne(Wrappers.<Product>lambdaQuery()
|
.eq(Product::getProductName, object.getString("itemClassName"))
|
.eq(Product::getCompId, "2089995177814495234")
|
.last("limit 1")
|
);
|
if (ObjUtil.isNull(productClass)) {
|
log.info("产品分类:{}不存在", object.getString("itemClassName"));
|
productClass = new Product();
|
productClass.setProductName(object.getString("itemClassName"));
|
productClass.setErpCode(object.getString("itemClassName"));
|
productClass.setParentId(0L);
|
productClass.setCompId(2089995177814495234L);
|
TaxCode taxCode = taxCodeMapper.selectOne(Wrappers.<TaxCode>lambdaQuery().eq(TaxCode::getBm, object.getString("tfTaxClass")).last("limit 1"));
|
if (ObjUtil.isNotNull(taxCode)) {
|
productClass.setTaxClass(taxCode.getSphwjc());
|
productClass.setTaxRate(Double.valueOf(taxCode.getSl().replace("%", "")));
|
}
|
productMapper.insert(productClass);
|
log.info("产品分类:{}新增成功", object.getString("itemClassName"));
|
}
|
|
log.info("产品:{}不存在", object.getString("itemNo"));
|
Product productNew = new Product();
|
productNew.setProductName(object.getString("note"));
|
productNew.setErpCode(object.getString("itemNo"));
|
productNew.setProductType(object.getString("grade"));
|
productNew.setUnitName(object.getString("unitName"));
|
productNew.setCompId(2089995177814495234L);
|
productNew.setParentId(productClass.getId());
|
TaxCode taxCode = taxCodeMapper.selectOne(Wrappers.<TaxCode>lambdaQuery().eq(TaxCode::getBm, object.getString("tfTaxClass")).last("limit 1"));
|
if (ObjUtil.isNotNull(taxCode)) {
|
productClass.setTaxClass(taxCode.getSphwjc());
|
productClass.setTaxRate(Double.valueOf(taxCode.getSl().replace("%", "")));
|
}
|
productMapper.insert(productNew);
|
log.info("产品:{}新增成功", object.getString("itemNo"));
|
}
|
errorMsg.add(item.getMaterialCode() + "erp编码不存在");
|
// 数据不合法情况
|
errorMessageList.add(new ErrorMessage(item.getLineNum(), errorMsg));
|
continue;
|
}
|
ContractSubjectMatterAddDTO addDTO = new ContractSubjectMatterAddDTO();
|
addDTO.setMaterialCode(item.getMaterialCode());
|
addDTO.setMaterialInternalName(one.getProductName());
|
addDTO.setMaterialName(item.getMaterialName());
|
addDTO.setUnitPrice(item.getUnitPrice());
|
addDTO.setQuantity(item.getQuantity());
|
addDTO.setSpecification(one.getProductType());
|
addDTOList.add(addDTO);
|
}
|
if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smjsc)) {
|
Product one = productMapper.selectOne(Wrappers.<Product>lambdaQuery()
|
.eq(Product::getErpCode, item.getMaterialCode())
|
.eq(Product::getCompId, smjsc)
|
.last("limit 1"));
|
if (ObjUtil.isNull(one)) {
|
JSONObject object = syncProductBySMJ("tenant2", item.getMaterialCode());
|
if (ObjUtil.isNotNull(object)) {
|
Product productClass = productMapper.selectOne(Wrappers.<Product>lambdaQuery()
|
.eq(Product::getProductName, object.getString("itemClassName"))
|
.eq(Product::getCompId, "2089996921978040321")
|
.last("limit 1")
|
);
|
if (ObjUtil.isNull(productClass)) {
|
log.info("产品分类:{}不存在", object.getString("itemClassName"));
|
productClass = new Product();
|
productClass.setProductName(object.getString("itemClassName"));
|
productClass.setErpCode(object.getString("itemClassName"));
|
productClass.setParentId(0L);
|
productClass.setCompId(2089996921978040321L);
|
TaxCode taxCode = taxCodeMapper.selectOne(Wrappers.<TaxCode>lambdaQuery().eq(TaxCode::getBm, object.getString("tfTaxClass")).last("limit 1"));
|
if (ObjUtil.isNotNull(taxCode)) {
|
productClass.setTaxClass(taxCode.getSphwjc());
|
productClass.setTaxRate(Double.valueOf(taxCode.getSl().replace("%", "")));
|
}
|
productMapper.insert(productClass);
|
log.info("产品分类:{}新增成功", object.getString("itemClassName"));
|
}
|
|
log.info("产品:{}不存在", object.getString("itemNo"));
|
Product productNew = new Product();
|
productNew.setProductName(object.getString("note"));
|
productNew.setErpCode(object.getString("itemNo"));
|
productNew.setProductType(object.getString("grade"));
|
productNew.setUnitName(object.getString("unitName"));
|
productNew.setCompId(2089996921978040321L);
|
productNew.setParentId(productClass.getId());
|
TaxCode taxCode = taxCodeMapper.selectOne(Wrappers.<TaxCode>lambdaQuery().eq(TaxCode::getBm, object.getString("tfTaxClass")).last("limit 1"));
|
if (ObjUtil.isNotNull(taxCode)) {
|
productClass.setTaxClass(taxCode.getSphwjc());
|
productClass.setTaxRate(Double.valueOf(taxCode.getSl().replace("%", "")));
|
}
|
productMapper.insert(productNew);
|
log.info("产品:{}新增成功", object.getString("itemNo"));
|
}
|
errorMsg.add(item.getMaterialCode() + "erp编码不存在");
|
// 数据不合法情况
|
errorMessageList.add(new ErrorMessage(item.getLineNum(), errorMsg));
|
continue;
|
}
|
ContractSubjectMatterAddDTO addDTO = new ContractSubjectMatterAddDTO();
|
addDTO.setMaterialCode(item.getMaterialCode());
|
addDTO.setMaterialInternalName(one.getProductName());
|
addDTO.setMaterialName(item.getMaterialName());
|
addDTO.setUnitPrice(item.getUnitPrice());
|
addDTO.setQuantity(item.getQuantity());
|
addDTO.setSpecification(one.getProductType());
|
addDTOList.add(addDTO);
|
}
|
if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smjzt)) {
|
Product one = productMapper.selectOne(Wrappers.<Product>lambdaQuery()
|
.eq(Product::getErpCode, item.getMaterialCode())
|
.eq(Product::getCompId, smjzt)
|
.last("limit 1"));
|
if (ObjUtil.isNull(one)) {
|
JSONObject object = syncProductBySMJ("tenant3", item.getMaterialCode());
|
if (ObjUtil.isNotNull(object)) {
|
Product productClass = productMapper.selectOne(Wrappers.<Product>lambdaQuery()
|
.eq(Product::getProductName, object.getString("itemClassName"))
|
.eq(Product::getCompId, "2089997578009128962")
|
.last("limit 1")
|
);
|
if (ObjUtil.isNull(productClass)) {
|
log.info("产品分类:{}不存在", object.getString("itemClassName"));
|
productClass = new Product();
|
productClass.setProductName(object.getString("itemClassName"));
|
productClass.setErpCode(object.getString("itemClassName"));
|
productClass.setParentId(0L);
|
productClass.setCompId(2089997578009128962L);
|
TaxCode taxCode = taxCodeMapper.selectOne(Wrappers.<TaxCode>lambdaQuery().eq(TaxCode::getBm, object.getString("tfTaxClass")).last("limit 1"));
|
if (ObjUtil.isNotNull(taxCode)) {
|
productClass.setTaxClass(taxCode.getSphwjc());
|
productClass.setTaxRate(Double.valueOf(taxCode.getSl().replace("%", "")));
|
}
|
productMapper.insert(productClass);
|
log.info("产品分类:{}新增成功", object.getString("itemClassName"));
|
}
|
|
log.info("产品:{}不存在", object.getString("itemNo"));
|
Product productNew = new Product();
|
productNew.setProductName(object.getString("note"));
|
productNew.setErpCode(object.getString("itemNo"));
|
productNew.setProductType(object.getString("grade"));
|
productNew.setUnitName(object.getString("unitName"));
|
productNew.setCompId(2089997578009128962L);
|
productNew.setParentId(productClass.getId());
|
TaxCode taxCode = taxCodeMapper.selectOne(Wrappers.<TaxCode>lambdaQuery().eq(TaxCode::getBm, object.getString("tfTaxClass")).last("limit 1"));
|
if (ObjUtil.isNotNull(taxCode)) {
|
productClass.setTaxClass(taxCode.getSphwjc());
|
productClass.setTaxRate(Double.valueOf(taxCode.getSl().replace("%", "")));
|
}
|
productMapper.insert(productNew);
|
log.info("产品:{}新增成功", object.getString("itemNo"));
|
}
|
errorMsg.add(item.getMaterialCode() + "erp编码不存在");
|
// 数据不合法情况
|
errorMessageList.add(new ErrorMessage(item.getLineNum(), errorMsg));
|
continue;
|
}
|
ContractSubjectMatterAddDTO addDTO = new ContractSubjectMatterAddDTO();
|
addDTO.setMaterialCode(item.getMaterialCode());
|
addDTO.setMaterialInternalName(one.getProductName());
|
addDTO.setMaterialName(item.getMaterialName());
|
addDTO.setUnitPrice(item.getUnitPrice());
|
addDTO.setQuantity(item.getQuantity());
|
addDTO.setSpecification(one.getProductType());
|
addDTOList.add(addDTO);
|
}
|
}
|
if (CollUtil.isNotEmpty(errorMessageList)) {
|
return R.failed(errorMessageList, "部门导入失败");
|
}
|
return R.ok(addDTOList, "部门导入成功");
|
}
|
@Override
|
public JSONObject syncProductBySMJ(String tenant1, String materialCode) {
|
String token = "";
|
if (redisTemplate.hasKey("SMJ_ERP_TOKEN")) {
|
token = (String) redisTemplate.opsForValue().get("SMJ_ERP_TOKEN");
|
} else {
|
token = getErpToken();
|
}
|
log.info("石煤机——" + tenant1 + "合同新增产品导入查询入参:{}", materialCode);
|
HttpResponse response = HttpRequest.get(smjErp + "/api/item/v1/detail?itemNo=" + materialCode + "&tenantId=" + tenant1)
|
.header("token", token) // 添加认证头
|
.execute(); // 执行请求.post(ymjErp,request.toJSONString());
|
log.info("石煤机——" + tenant1 + "合同新增产品导入查询回参:{}", response.body());
|
JSONObject resp = JSONObject.parseObject(response.body());
|
if (StrUtil.equals(resp.getString("code"), "0")) {
|
return resp.getJSONObject("data");
|
}
|
if (StrUtil.equals(resp.getString("code"), "401001")) {
|
getErpToken();
|
}
|
return null;
|
}
|
|
private String getErpToken() {
|
JSONObject loginJson = new JSONObject();
|
loginJson.put("username", "admin");
|
loginJson.put("password", "Zimafold@2026");
|
log.info("石煤机产品获取token入参:{}", loginJson.toJSONString());
|
String loginResp = HttpUtil.post(smjErp + "/api/account/v1/login", loginJson.toJSONString());
|
log.info("石煤机产品获取token回参:{}", loginResp);
|
JSONObject respJson = JSONObject.parseObject(loginResp);
|
if (respJson.getInteger("code") == 0) {
|
JSONObject dataJson = JSONObject.parseObject(respJson.getString("data"));
|
redisTemplate.opsForValue().set("SMJ_ERP_TOEKN", dataJson.getString("token"));
|
log.info("石煤机erp token为:{}", dataJson.getString("token"));
|
return dataJson.getString("token");
|
}
|
return "";
|
}
|
|
@Override
|
public R smjProduct(String erpCode) {
|
String token = "";
|
if (redisTemplate.hasKey("SMJ_ERP_TOKEN")) {
|
token = (String) redisTemplate.opsForValue().get("SMJ_ERP_TOKEN");
|
} else {
|
token = getErpToken();
|
}
|
log.info("石煤机——tenant1合同新增产品导入查询入参:{}", erpCode);
|
HttpResponse response = HttpRequest.get(smjErp + "/api/item/v1/detail?itemNo=" + erpCode + "&tenantId=tenant1")
|
.header("token", token) // 添加认证头
|
.execute(); // 执行请求.post(ymjErp,request.toJSONString());
|
log.info("石煤机——tenant1合同新增产品导入查询回参:{}", response.body());
|
return R.ok(response.body());
|
}
|
|
@Override
|
public R annotate(List<ContractSubjectMatterAnnotateDTO> annotateDTOList) {
|
if (CollUtil.isNotEmpty(annotateDTOList)){
|
Long contractId = annotateDTOList.get(0).getContractId();
|
annotateDTOList.stream().forEach(annotateDTO->{
|
ContractSubjectMatter subjectMatter = baseMapper.selectById(annotateDTO.getId());
|
subjectMatter.setProductSection(annotateDTO.getProductSection());
|
subjectMatter.setBusinessProject(annotateDTO.getBusinessProject());
|
subjectMatter.setProductCategory(annotateDTO.getProductCategory());
|
baseMapper.updateById(subjectMatter);
|
});
|
List<ContractSubjectMatter> subjectMatterList = baseMapper.selectList(Wrappers.<ContractSubjectMatter>lambdaQuery()
|
.eq(ContractSubjectMatter::getContractId,contractId)
|
.and(wrapper -> wrapper.isNull(ContractSubjectMatter::getProductSection)
|
.or().isNull(ContractSubjectMatter::getBusinessProject)
|
.or().isNull(ContractSubjectMatter::getProductCategory)));
|
if (CollUtil.isEmpty(subjectMatterList)){
|
contractMapper.update(Wrappers.<Contract>lambdaUpdate().eq(Contract::getId,contractId).set(Contract::getAnnotateFlag,"1"));
|
}
|
}
|
return R.ok();
|
}
|
}
|