| | |
| | | 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; |
| | | |
| | | /** |
| | | * 合同标的物明细表 |
| | |
| | | * @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) |
| | | .eq(ContractSubjectMatter::getContractId, id) |
| | | .orderByAsc(ContractSubjectMatter::getCreateTime); |
| | | List<ContractSubjectMatterVo> matterVoList = baseMapper.selectJoinList(ContractSubjectMatterVo.class,wrapper); |
| | | List<ContractSubjectMatterVo> matterVoList = baseMapper.selectJoinList(ContractSubjectMatterVo.class, wrapper); |
| | | return R.ok(matterVoList); |
| | | } |
| | | |
| | | @Override |
| | | public R selectSubjectMatter(Long contractId) { |
| | | return R.ok(baseMapper.selectListByScope(Wrappers.<ContractSubjectMatter>lambdaQuery().eq(ContractSubjectMatter::getContractId,contractId) |
| | | .orderByAsc(ContractSubjectMatter::getCreateTime), DataScope.of("comp_id"))); |
| | | 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(); |
| | | } |
| | | } |