From f6b439c8958e7e0520057404b7226c7507f5d1a1 Mon Sep 17 00:00:00 2001 From: 李林 <z1292839451@163.com> Date: 星期四, 11 四月 2024 18:01:23 +0800 Subject: [PATCH] 报告生成功能:支持数据填充,发现单元格合并bug,发现模板重复 --- inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderServiceImpl.java | 51 +++++++++++++++++++++++++++++++++++++++++++-------- 1 files changed, 43 insertions(+), 8 deletions(-) diff --git a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderServiceImpl.java b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderServiceImpl.java index 9ece3f3..bd725d6 100644 --- a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderServiceImpl.java +++ b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InsOrderServiceImpl.java @@ -9,15 +9,9 @@ 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.InsOderDto; -import com.yuanchu.mom.dto.OrderThingDto; -import com.yuanchu.mom.dto.SampleOrderDto; -import com.yuanchu.mom.dto.SampleProductDto; +import com.yuanchu.mom.dto.*; import com.yuanchu.mom.mapper.*; -import com.yuanchu.mom.pojo.InsOrder; -import com.yuanchu.mom.pojo.InsProduct; -import com.yuanchu.mom.pojo.InsSample; -import com.yuanchu.mom.pojo.InsSampleUser; +import com.yuanchu.mom.pojo.*; import com.yuanchu.mom.service.InsOrderService; import com.yuanchu.mom.service.StandardTemplateService; import com.yuanchu.mom.utils.GiveCode; @@ -29,6 +23,7 @@ import java.time.LocalDate; import java.time.LocalDateTime; import java.util.*; +import java.util.stream.Collectors; /** * @author gaoaoy @@ -52,6 +47,8 @@ private InsSampleUserMapper insSampleUserMapper; + private InsOrderStateMapper insOrderStateMapper; + //鑾峰彇妫�楠屼笅鍗曟暟鎹� @Override public Map<String, Object> selectInsOrderParameter(IPage<InsOrder> page, SampleOrderDto sampleOrderDto) { @@ -71,6 +68,16 @@ insOrder.setAppointed(LocalDate.parse(appointed)); insOrder.setSendTime(LocalDateTime.now()); insOrderMapper.updateById(insOrder); + List<InsSample> insSamples = insSampleMapper.selectList(Wrappers.<InsSample>lambdaQuery().eq(InsSample::getInsOrderId, orderId).select(InsSample::getId)); + List<Integer> ids = insSamples.stream().map(a-> a.getId()).collect(Collectors.toList()); + List<InsProduct> insProducts = insProductMapper.selectList(Wrappers.<InsProduct>lambdaQuery().in(InsProduct::getInsSampleId, ids).select(InsProduct::getSonLaboratory).groupBy(InsProduct::getSonLaboratory)); + for (InsProduct insProduct : insProducts) { + InsOrderState insOrderState = new InsOrderState(); + insOrderState.setInsOrderId(orderId); + insOrderState.setLaboratory(insProduct.getSonLaboratory()); + insOrderState.setInsState(0); + insOrderStateMapper.insert(insOrderState); + } if(userId!=null){ InsSampleUser insSampleUser = new InsSampleUser(); insSampleUser.setState(0); @@ -124,6 +131,34 @@ public int upInsOrderOfState(InsOrder insOrder) { return insOrderMapper.updateById(insOrder); } + + @Override + public Map<String, Object> getInsOrderAndSample(Integer id, String laboratory) { + Map<String, Object> map = new HashMap<>(); + InsOrder insOrder = insOrderMapper.selectById(id); + List<SampleProductDto> list = insSampleMapper.getInsOrderAndSample(id, laboratory); + map.put("insOrder", insOrder); + map.put("sampleProduct", list); + return map; + } + + @Override + public Map<String, Object> selectSampleAndProductByOrderId(IPage<SampleProductDto2> page, SampleProductDto2 sampleProductDto) { + Map<String, Object> map = new HashMap<>(); + map.put("head", PrintChina.printChina(SampleProductDto2.class)); + map.put("body", insOrderMapper.selectSampleAndProductByOrderId(page, QueryWrappers.queryWrappers(sampleProductDto))); + return map; + } + + @Override + public Map<String, Object> costStatistics(IPage<CostStatisticsDto> page, CostStatisticsDto costStatisticsDto) { + Map<String, Object> map = new HashMap<>(); + map.put("head", PrintChina.printChina(CostStatisticsDto.class)); + Map<String, Integer> map1 = getLook.selectPowerByMethodAndUserId("costStatistics"); + if (map1.get("look") == 1) costStatisticsDto.setCreateUser(map1.get("userId")); + map.put("body", insOrderMapper.selectCostStatistics(page, QueryWrappers.queryWrappers(costStatisticsDto))); + return map; + } } -- Gitblit v1.9.3