package com.yuanchu.mom.service.impl; import cn.hutool.core.util.ObjectUtil; import cn.hutool.core.util.StrUtil; import com.alibaba.fastjson.JSON; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.core.toolkit.ObjectUtils; import com.baomidou.mybatisplus.core.toolkit.Wrappers; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.yuanchu.mom.common.GetLook; import com.yuanchu.mom.common.PrintChina; import com.yuanchu.mom.dto.*; import com.yuanchu.mom.exception.ErrorException; import com.yuanchu.mom.mapper.*; import com.yuanchu.mom.pojo.*; import com.yuanchu.mom.service.InsOrderService; import com.yuanchu.mom.utils.GiveCode; import com.yuanchu.mom.utils.QueryWrappers; import com.yuanchu.mom.vo.SampleDefectsFatherVo; import lombok.AllArgsConstructor; import org.apache.commons.lang3.StringUtils; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import java.time.LocalDate; import java.time.LocalDateTime; import java.time.format.DateTimeFormatter; import java.util.*; import java.util.concurrent.atomic.AtomicInteger; import java.util.stream.Collectors; /** * @author gaoaoy * @description 针对表【ins_order(检验下单)】的数据库操作Service实现 * @createDate 2024-03-12 16:17:55 */ @Service @AllArgsConstructor public class InsOrderServiceImpl extends ServiceImpl implements InsOrderService { private GetLook getLook; private InsOrderMapper insOrderMapper; private InsSampleMapper insSampleMapper; private InsProductMapper insProductMapper; private GiveCode giveCode; private InsSampleUserMapper insSampleUserMapper; private InsOrderStateMapper insOrderStateMapper; UserMapper userMapper; PowerMapper powerMapper; private InsBushingMapper insBushingMapper; private InsFibersMapper insFibersMapper; private InsFiberMapper insFiberMapper; CustomMapper customMapper; //获取检验下单数据 @Override public Map selectInsOrderParameter(IPage page, SampleOrderDto sampleOrderDto) { //判断全部,个人,组织的权限 Map map1 = getLook.selectPowerByMethodAndUserId("selectInsOrderParameter"); User user = userMapper.selectById(map1.get("userId")); Integer roleId = user.getRoleId(); //判断是否是全部权限 Power power = powerMapper.selectOne(Wrappers.lambdaQuery().eq(Power::getRoleId, roleId).eq(Power::getMenuMethod, "selectAllInsOrder")); if (ObjectUtils.isEmpty(power)) { if (map1.get("look") == 1) { //个人 sampleOrderDto.setCreateUser(map1.get("userId")); } else { //组织 try { sampleOrderDto.setCompany(customMapper.selectById(user.getCompany()).getCompany()); } catch (NullPointerException e) { throw new ErrorException("找不到所属单位"); } } } Map map = new HashMap<>(); map.put("head", PrintChina.printChina(SampleOrderDto.class)); map.put("body", insOrderMapper.selectInsOrderPage(page, QueryWrappers.queryWrappers(sampleOrderDto))); return map; } @Override @Transactional(rollbackFor = Exception.class) public int upInsOrder(Integer orderId, Integer sampleId, String appointed, Integer userId) { InsOrder insOrder = new InsOrder(); insOrder.setId(orderId); insOrder.setAppointed(LocalDate.parse(appointed)); insOrder.setSendTime(LocalDateTime.now()); insOrderMapper.updateById(insOrder); List insSamples = insSampleMapper.selectList(Wrappers.lambdaQuery().eq(InsSample::getInsOrderId, orderId).select(InsSample::getId)); List ids = insSamples.stream().map(a -> a.getId()).collect(Collectors.toList()); List insProducts = insProductMapper.selectList(Wrappers.lambdaQuery().in(InsProduct::getInsSampleId, ids).eq(InsProduct::getState, 1).isNull(InsProduct::getInsFibersId).isNull(InsProduct::getInsFiberId).select(InsProduct::getSonLaboratory).groupBy(InsProduct::getSonLaboratory)); for (InsProduct insProduct : insProducts) { InsOrderState insOrderState = new InsOrderState(); insOrderState.setInsOrderId(orderId); try { insOrderState.setLaboratory(insProduct.getSonLaboratory()); } catch (NullPointerException e) { throw new ErrorException("该检验单有未维护实验室的检验项目"); } insOrderState.setInsState(0); insOrderStateMapper.insert(insOrderState); } if (userId != null) { InsSampleUser insSampleUser = new InsSampleUser(); insSampleUser.setState(0); insSampleUser.setUserId(userId); insSampleUser.setInsSampleId(orderId); insSampleUserMapper.insert(insSampleUser); } return 1; } @Override @Transactional(rollbackFor = Exception.class) public int addInsOrder(List list, InsOrder insOrder, List> pairing) { insOrder.setState(0); String code = customMapper.selectById(insOrder.getCompanyId()).getCode2(); //insOrder.setEntrustCode(giveCode.giveCode("JCZX-" + code + "-", "ins_order", "", "yyMMdd")); String giveCode = this.giveCode.giveCode("JCZX-" + code + "-", "ins_order", "", "yyMMdd"); insOrderMapper.insert(insOrder); AtomicInteger count = new AtomicInteger(); list.forEach(a -> { count.getAndIncrement(); a.setId(null); a.setInsOrderId(insOrder.getId()); if (StrUtil.isEmpty(a.getSampleCode())) { a.setSampleCode(giveCode.split("-")[2] + "-" + count.get()); } insSampleMapper.insert(a); if (ObjectUtil.isNotEmpty(a.getInsProduct())) { addInsProductMethod(a.getId(), a.getInsProduct(), null, 0); } if (ObjectUtil.isNotEmpty(a.getInsulating())) { List ip2 = new ArrayList<>(); for (Integer i = 0; i < a.getInsulating().getNum(); i++) { ip2.addAll(a.getInsulating().getInsProduct()); } for (InsProduct product : ip2) { product.setStandardMethodListId(a.getInsulating().getStandardMethodListId()); } addInsProductMethod(a.getId(), ip2, null, 0); } if (ObjectUtil.isNotEmpty(a.getSheath())) { for (InsProduct product : a.getSheath().getInsProduct()) { product.setStandardMethodListId(a.getSheath().getStandardMethodListId()); } addInsProductMethod(a.getId(), a.getSheath().getInsProduct(), null, 0); } if (ObjectUtil.isNotEmpty(a.getChildSampleList())) { for (SampleProductDto b : a.getChildSampleList()) { for (int i = 0; i < b.getNum(); i++) { b.setId(null); b.setInsOrderId(insOrder.getId()); b.setParentId(a.getId()); if (StrUtil.isEmpty(b.getSampleCode())) { b.setSampleCode(this.giveCode.giveCode("", "ins_sample", "", "yyMMdd")); } insSampleMapper.insert(b); if (ObjectUtil.isNotEmpty(b.getInsProduct())) { addInsProductMethod(b.getId(), b.getInsProduct(), null, 0); } } } } if (ObjectUtil.isNotEmpty(a.getBushing())) { for (BushingDto bushingDto : a.getBushing()) { bushingDto.setInsSampleId(a.getId()); insBushingMapper.insert(bushingDto); if (bushingDto.getFiber().size() != 0) { for (FiberDto fiberDto : bushingDto.getFiber()) { fiberDto.setInsBushingId(bushingDto.getId()); insFiberMapper.insert(fiberDto); addInsProductMethod(a.getId(), fiberDto.getProductList(), fiberDto.getId(), 2); } } else { for (FibersDto fibersDto : bushingDto.getFibers()) { fibersDto.setInsBushingId(bushingDto.getId()); fibersDto.setCode(this.giveCode.giveCode("", "ins_fibers", "", "yyMMdd")); insFibersMapper.insert(fibersDto); for (FiberDto fiberDto : fibersDto.getFiber()) { fiberDto.setInsFibersId(fibersDto.getId()); insFiberMapper.insert(fiberDto); addInsProductMethod(a.getId(), fiberDto.getProductList(), fiberDto.getId(), 2); } addInsProductMethod(a.getId(), fibersDto.getProductList(), fibersDto.getId(), 1); } } } } }); for (List i : pairing) { SampleProductDto sample = JSON.parseObject(JSON.toJSONString(list.get(i.get(0) - 1)), SampleProductDto.class); sample.setSampleCode(list.get(i.get(0) - 1).getSampleCode() + "/" + list.get(i.get(1) - 1).getSampleCode()); sample.setId(null); insSampleMapper.insert(sample); try { InsProduct insProduct = sample.getInsProduct().stream().filter(a -> Objects.equals(a.getInspectionItem(), "熔接损耗")).findFirst().get(); insProduct.setId(null); insProduct.setInsSampleId(sample.getId()); insProductMapper.insert(insProduct); } catch (Exception e) { } } return insOrder.getId(); } private void addInsProductMethod(Integer sampleId, List productList, Integer id, Integer type) { for (InsProduct product : productList) { /*if(product.getState()==1 && (product.getAsk().indexOf("D")>-1||product.getAsk().indexOf("W")>-1||product.getAsk().indexOf("X")>-1 ||product.getAsk().indexOf("RTS")>-1||product.getAsk().indexOf("H")>-1||product.getAsk().indexOf("L")>-1)){ throw new ErrorException("提交失败,存在未填写的变量:"+product.getInspectionItem()+" "+product.getInspectionItemSubclass()); }*/ if (product.getState() == 1 && !product.getInspectionItem().equals("熔接损耗")) { switch (type) { case 1: product.setInsFibersId(id); break; case 2: product.setInsFiberId(id); break; } product.setId(null); product.setCreateTime(null); product.setUpdateTime(null); product.setUpdateTime(null); product.setUpdateUser(null); product.setInsSampleId(sampleId); if (product.getInspectionItemSubclass() == null) { product.setInspectionItemSubclass(""); } insProductMapper.insert(product); } } } @Override public Map getInsOrder(Integer id) { Map map = new HashMap<>(); InsOrder insOrder = insOrderMapper.selectById(id); List list = insSampleMapper.selectSampleProductListByOrderId2(id); map.put("insOrder", insOrder); map.put("sampleProduct", list); return map; } @Override public int upInsOrderOfState(InsOrder insOrder) { insOrder.setExamineTime(LocalDateTime.now()); String code = baseMapper.selLaboratoryCode(insOrder.getLaboratory()); if (StringUtils.isEmpty(code)) { code = ""; } String code2 = customMapper.selectById(insOrder.getCompanyId()).getCode2(); insOrder.setEntrustCode(giveCode.giveCode("JC/ZX" + code + "-" + code2 + "-", "ins_order", "", "yyMM")); return insOrderMapper.updateById(insOrder); } @Override public Map getInsOrderAndSample(Integer id, String laboratory) { Map map = new HashMap<>(); InsOrder insOrder = insOrderMapper.selectById(id); List list = insSampleMapper.getInsOrderAndSample(id, laboratory); map.put("insOrder", insOrder); map.put("sampleProduct", list); return map; } @Override public Map selectSampleAndProductByOrderId(IPage page, SampleProductDto2 sampleProductDto) { Map map = new HashMap<>(); map.put("head", PrintChina.printChina(SampleProductDto2.class)); map.put("body", insOrderMapper.selectSampleAndProductByOrderId(page, QueryWrappers.queryWrappers(sampleProductDto))); return map; } @Override public Map costStatistics(IPage page, CostStatisticsDto costStatisticsDto) { String dates = costStatisticsDto.getDates(); String[] split = dates.replaceAll("\\[", "").replaceAll("]", "").replaceAll("\"", "").split(","); costStatisticsDto.setDates(null); Map map = new HashMap<>(); map.put("head", PrintChina.printChina(CostStatisticsDto.class)); Map map1 = getLook.selectPowerByMethodAndUserId("costStatistics"); if (map1.get("look") == 1) costStatisticsDto.setCreateUser(map1.get("userId")); map.put("body", insOrderMapper.selectCostStatistics(page, QueryWrappers.queryWrappers(costStatisticsDto).ge("create_time", split[0]).le("create_time", split[1] + " 23:59:59"))); return map; } @Override public Map selectSampleDefects(Page page, String inspectionItems, String orderNumber) { List sampleDefectsFatherVos = insOrderMapper.selectSampleDefects(page, inspectionItems, orderNumber); Map map = new HashMap<>(); map.put("records", sampleDefectsFatherVos); Long aLong = insOrderMapper.getCount(inspectionItems, orderNumber); map.put("total", aLong); return map; } @Override public int updateStatus(Integer id) { return insOrderMapper.updateStatus(id); } //标签打印 @Override public List labelPrinting(String ids) { List list = Arrays.stream(ids.split(",")).map(Integer::parseInt).collect(Collectors.toList()); List sampleProductDtos = insSampleMapper.selectSampleProductListByOrderId3(list); Set processedCodes = new HashSet<>(); //如果是光纤或者是光纤带默认只打印第一个 List sampleProductDto3s = sampleProductDtos.stream().filter(sampleProductDto3 -> { if (!"光纤".equals(sampleProductDto3.getIoSampleType()) && !"光纤带".equals(sampleProductDto3.getIoSampleType())) { return true; } if (processedCodes.contains(sampleProductDto3.getCode())) { return false; } else { processedCodes.add(sampleProductDto3.getCode()); return true; } }).collect(Collectors.toList()); return sampleProductDto3s; } }