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.*; import com.by4cloud.platformx.business.mapper.*; 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 implements ContractSubjectMatterService { private final ContractMapper contractMapper; private final ProductMapper productMapper; private final TaxCodeMapper taxCodeMapper; private final BipDictMapper bipDictMapper; 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 wrapper = new MPJLambdaWrapper() .selectAll(ContractSubjectMatter.class) .eq(ContractSubjectMatter::getContractId, id) .orderByAsc(ContractSubjectMatter::getCreateTime); List matterVoList = baseMapper.selectJoinList(ContractSubjectMatterVo.class, wrapper); return R.ok(matterVoList); } @Override public R selectSubjectMatter(Long contractId) { return R.ok(baseMapper.selectList(Wrappers.lambdaQuery() .eq(ContractSubjectMatter::getContractId, contractId) .orderByAsc(ContractSubjectMatter::getCreateTime))); } @Override public R importSubjectMatter(List excelVOList, BindingResult bindingResult) { List errorMessageList = (List) bindingResult.getTarget(); List addDTOList = new ArrayList<>(); for (SubjectMatterExcelVO item : excelVOList) { Set 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.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 smjList = new ArrayList<>(); smjList.add(smj); smjList.add(smjhw); Product one = productMapper.selectOne(Wrappers.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.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.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.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.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.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.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.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.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.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.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.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 annotateDTOList) { if (CollUtil.isNotEmpty(annotateDTOList)){ Long contractId = annotateDTOList.get(0).getContractId(); annotateDTOList.stream().forEach(annotateDTO->{ ContractSubjectMatter subjectMatter = baseMapper.selectById(annotateDTO.getId()); subjectMatter.setBusinessProject(annotateDTO.getBusinessProject()); if (StrUtil.isNotBlank(annotateDTO.getProductCategory())){ subjectMatter.setProductCategory(annotateDTO.getProductCategory()); BipDict dict = bipDictMapper.selectOne(Wrappers.lambdaQuery().eq(BipDict::getDictCode,annotateDTO.getProductCategory()) .eq(BipDict::getCompId,SecurityUtils.getUser().getCompId()).eq(BipDict::getDictKey,"zb-cpmc").last("limit 1")); if (ObjUtil.isNotNull(dict)){ subjectMatter.setProductSection(dict.getProductSection()); } } baseMapper.updateById(subjectMatter); }); List subjectMatterList = baseMapper.selectList(Wrappers.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.lambdaUpdate().eq(Contract::getId,contractId).set(Contract::getAnnotateFlag,"1")); } } return R.ok(); } }