From 488cc3665822da42c4a4173d962920c6bd057a3d Mon Sep 17 00:00:00 2001 From: zjh <1084500556@qq.com> Date: 星期五, 15 九月 2023 17:57:01 +0800 Subject: [PATCH] zjh 2023/09/15--3 --- ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TbTransitionServiceImpl.java | 5 ++ ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjFlowingWaterController.java | 29 ++++++++------ ltkj-admin/src/test/java/zjhTest.java | 22 +---------- ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjFlowingWaterServiceImpl.java | 5 ++ ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TbTransitionMapper.java | 10 +++++ ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITbTransitionService.java | 2 + ltkj-admin/src/main/java/com/ltkj/web/controller/system/SysDeptController.java | 1 ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITjFlowingWaterService.java | 2 + ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjFlowingWaterMapper.java | 3 + 9 files changed, 47 insertions(+), 32 deletions(-) diff --git a/ltkj-admin/src/main/java/com/ltkj/web/controller/system/SysDeptController.java b/ltkj-admin/src/main/java/com/ltkj/web/controller/system/SysDeptController.java index bd20863..f2e0ed6 100644 --- a/ltkj-admin/src/main/java/com/ltkj/web/controller/system/SysDeptController.java +++ b/ltkj-admin/src/main/java/com/ltkj/web/controller/system/SysDeptController.java @@ -608,6 +608,7 @@ one.setType(1); remarkService.updateById(one); } + asyncService.updateCheckType(orderRemark.getTjNumber()); return AjaxResult.success("鎿嶄綔鎴愬姛"); } asyncService.updateCheckType(orderRemark.getTjNumber()); diff --git a/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjFlowingWaterController.java b/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjFlowingWaterController.java index 92968de..93a98f6 100644 --- a/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjFlowingWaterController.java +++ b/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjFlowingWaterController.java @@ -539,18 +539,23 @@ if (null != tjProjectList && tjProjectList.size() > 0) { for (TjProject project : tjProjectList) { if (project.getProParentId() == 0) { - LambdaQueryWrapper<TbTransition> wqq1 = new LambdaQueryWrapper<>(); - wqq1.eq(TbTransition::getCusId, customerService.getById(order.getUserId()).getCusIdcard()); - wqq1.eq(TbTransition::getParentProId, project.getProId()); - List<TbTransition> tbTransitionList = transitionService.list(wqq1); - BigDecimal bigDecimal = new BigDecimal("0.00"); - BigDecimal bigDecimal1 = new BigDecimal("0.00"); - for (TbTransition transition : tbTransitionList) { - bigDecimal = bigDecimal.add(transition.getNowPrice()); - bigDecimal1=bigDecimal1.add(transition.getOrdPrice()); - } - project.setProPrice(bigDecimal.setScale(0,BigDecimal.ROUND_UP)); - project.setProOrdPrice(bigDecimal1); + // LambdaQueryWrapper<TbTransition> wqq1 = new LambdaQueryWrapper<>(); +// wqq1.eq(TbTransition::getCusId, customerService.getById(order.getUserId()).getCusIdcard()); +// wqq1.eq(TbTransition::getParentProId, project.getProId()); +// List<TbTransition> tbTransitionList = transitionService.list(wqq1); +// BigDecimal bigDecimal = new BigDecimal("0.00"); +// BigDecimal bigDecimal1 = new BigDecimal("0.00"); +// for (TbTransition transition : tbTransitionList) { +// bigDecimal = bigDecimal.add(transition.getNowPrice()); +// bigDecimal1=bigDecimal1.add(transition.getOrdPrice()); +// } +// project.setProPrice(bigDecimal.setScale(0,BigDecimal.ROUND_UP)); +// project.setProOrdPrice(bigDecimal1); + BigDecimal decimal = transitionService.getTbTransitionPriceAndOrdPrice(customerService.getById(order.getUserId()).getCusIdcard(), + project.getProId()); + String s = tjFlowingWaterService.getDiscount(OrderId); + project.setProPrice(decimal.setScale(2)); + project.setProOrdPrice(decimal.multiply(BigDecimal.valueOf(Long.parseLong(s))).setScale(2)); } } } diff --git a/ltkj-admin/src/test/java/zjhTest.java b/ltkj-admin/src/test/java/zjhTest.java index 63d2d2d..b5caa2e 100644 --- a/ltkj-admin/src/test/java/zjhTest.java +++ b/ltkj-admin/src/test/java/zjhTest.java @@ -48,26 +48,8 @@ @Test public void test() { -// util.setDataBase(1); -// stringRedisTemplate.opsForValue().set("1","1"); -// ExecutorService pool = Executors.newFixedThreadPool(5); -// -// for (int i = 1; i < 6; i++) { -// int finalI = i; -// pool.execute(new Runnable() { -// @Override -// public void run() { -// try { -// redisCache.setDataBase(finalI); -// redisCache.setCacheObject("娴嬭瘯",finalI+"111111111111111111"); -// } catch (Exception e) { -// e.printStackTrace(); -// } -// pool.shutdown(); -// } -// }); -// } - log.info("鍢垮樋!!!"); +// redisCache.setCacheObject("璧典匠璞�","hahahahaha"); +// log.info("鍢垮樋!!!"); } diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TbTransitionMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TbTransitionMapper.java index 28116d3..3074a8a 100644 --- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TbTransitionMapper.java +++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TbTransitionMapper.java @@ -196,4 +196,14 @@ "\tLEFT JOIN tj_project c ON c.pro_parent_id=b.pro_id\n" + "WHERE 1=1 AND a.grouping_id =#{groupingId} ") boolean saveTemoTransitionByGroupingId(@Param("cusId")String cusId,@Param("groupingId")String groupingId); + + + @Select("SELECT b.price_now FROM \n" + + "(SELECT a.pac_id FROM tb_transition a WHERE\n" + + "\ta.cus_id = #{cusId} \n" + + "GROUP BY\n" + + "\ta.pac_id) aa \n" + + "LEFT JOIN tj_package_project b\n" + + "\tON aa.pac_id=b.pac_id WHERE b.pro_id=#{proId} ") + BigDecimal getTbTransitionPriceAndOrdPrice(@Param("cusId")String cusId,@Param("proId")Long proId); } diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjFlowingWaterMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjFlowingWaterMapper.java index bf63a6f..88f4d80 100644 --- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjFlowingWaterMapper.java +++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjFlowingWaterMapper.java @@ -69,4 +69,7 @@ "\n" + " tj_flowing_water b ON a.order_id = b.order_id WHERE a.tj_number =#{tjNum} AND a.deleted='0' AND b.deleted='0'") List<String> getFlowingWaterIds(String tjNum); + + @Select("\tSELECT a.discount/10 FROM tj_flowing_water a WHERE 1=1 AND a.deleted =0 AND a.order_id=#{orderId} AND a.discount !='/'") + String getDiscount(String orderId); } diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITbTransitionService.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITbTransitionService.java index d6aaf97..f749a1e 100644 --- a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITbTransitionService.java +++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITbTransitionService.java @@ -99,4 +99,6 @@ void saveRedisTransitionByProId(String cusId, Long proId); boolean saveTemoTransitionByGroupingId(String cusId,String groupingId); + + BigDecimal getTbTransitionPriceAndOrdPrice(String cusId,Long proId); } diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITjFlowingWaterService.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITjFlowingWaterService.java index c2766ce..80ce564 100644 --- a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITjFlowingWaterService.java +++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITjFlowingWaterService.java @@ -62,4 +62,6 @@ public int deleteTjFlowingWaterById(String id); List<String> getFlowingWaterIds(String tjNum); + + String getDiscount(String orderId); } diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TbTransitionServiceImpl.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TbTransitionServiceImpl.java index 4d9334d..e640e4f 100644 --- a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TbTransitionServiceImpl.java +++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TbTransitionServiceImpl.java @@ -150,4 +150,9 @@ public boolean saveTemoTransitionByGroupingId(String cusId,String groupingId) { return tbTransitionMapper.saveTemoTransitionByGroupingId(cusId,groupingId); } + + @Override + public BigDecimal getTbTransitionPriceAndOrdPrice(String cusId, Long proId) { + return tbTransitionMapper.getTbTransitionPriceAndOrdPrice(cusId,proId); + } } diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjFlowingWaterServiceImpl.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjFlowingWaterServiceImpl.java index 1c7abf4..4b72293 100644 --- a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjFlowingWaterServiceImpl.java +++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjFlowingWaterServiceImpl.java @@ -97,4 +97,9 @@ public List<String> getFlowingWaterIds(String tjNum) { return tjFlowingWaterMapper.getFlowingWaterIds(tjNum); } + + @Override + public String getDiscount(String orderId) { + return tjFlowingWaterMapper.getDiscount(orderId); + } } -- Gitblit v1.8.0