From dfc54795e807536ac980aae5350347d79fc8536d Mon Sep 17 00:00:00 2001 From: 赵文轩 <1652863494@qq.com> Date: 星期五, 21 六月 2024 16:15:53 +0800 Subject: [PATCH] 总价明细数据 --- ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjOrderController.java | 62 +++++++++++++++++++++++++++++++ 1 files changed, 62 insertions(+), 0 deletions(-) diff --git a/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjOrderController.java b/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjOrderController.java index 683b6a5..dc3d545 100644 --- a/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjOrderController.java +++ b/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjOrderController.java @@ -23,6 +23,9 @@ import cn.hutool.core.date.DateUtil; import cn.hutool.crypto.symmetric.DES; import cn.hutool.extra.pinyin.PinyinUtil; +import cn.hutool.json.JSONArray; +import cn.hutool.json.JSONObject; +import cn.hutool.json.JSONUtil; import com.alibaba.fastjson2.JSON; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; @@ -183,6 +186,8 @@ private HisMzJysqController hisMzJysqController; @Autowired private HisApiGetMethodService hisApiGetMethodService; + @Autowired + private ISysDeptService sysDeptService; /** @@ -2218,6 +2223,63 @@ return AjaxResult.success(transitionService.remove(wq)); } + @GetMapping("/getTransitionInfo") + @ApiOperation(value = "鏍规嵁浣撴鍙疯幏鍙栨眹鎬诲拰鏄庣粏鐨勬暟鎹�") + public AjaxResult getTransitionInfo(@RequestParam("tjNumber")String tjNumber){ + QueryWrapper<TbTransition> wrapper = new QueryWrapper<>(); + wrapper.select("parent_pro_id","parent_pro_name","sum(ord_price) as ord_price") + .eq("tj_num",tjNumber) + .groupBy("parent_pro_name"); + List<TbTransition> list = transitionService.list(wrapper); + List<Long> parentProIds = list.stream().map(item -> item.getParentProId()).collect(Collectors.toList()); + LambdaQueryWrapper<TjProject> projectQueryWrapper = new LambdaQueryWrapper<>(); + projectQueryWrapper.in(TjProject::getProId,parentProIds); + List<TjProject> projects = projectService.list(projectQueryWrapper); + JSONArray huiZong = JSONUtil.createArray(); + int index = 1; + for (TjProject project : projects) { + LambdaQueryWrapper<SysDept> queryWrapper = new LambdaQueryWrapper<>(); + queryWrapper.eq(SysDept::getDeptId,project.getDeptId()); + SysDept dept = sysDeptService.getOne(queryWrapper); + for (TbTransition tbTransition : list) { + if (tbTransition.getParentProId().toString().equals(project.getProId().toString())){ + JSONObject obj = JSONUtil.createObj(); + obj.putOpt("index",index++); + obj.putOpt("parent_pro_name",tbTransition.getParentProName()); + obj.putOpt("price",tbTransition.getOrdPrice()); + obj.putOpt("ks",dept.getDeptName()); + huiZong.add(obj); + } + } + } + wrapper = new QueryWrapper<>(); + wrapper.eq("tj_num",tjNumber); + list = transitionService.list(wrapper); + JSONArray info = JSONUtil.createArray(); + index = 0; + for (TbTransition tbTransition : list) { + JSONObject obj = JSONUtil.createObj(); + obj.putOpt("index",index++); + obj.putOpt("parent_pro_name",tbTransition.getParentProName()); + obj.putOpt("pro_name",tbTransition.getProName()); + BigDecimal ordPrice = tbTransition.getOrdPrice(); + obj.putOpt("zongjia",ordPrice); + QueryWrapper<TjProject> queryWrapper = new QueryWrapper<>(); + queryWrapper.eq("pro_id",tbTransition.getProId()); + TjProject tjProject = projectService.getOne(queryWrapper); + Integer num = tjProject.getSl(); + obj.putOpt("num",num); + BigDecimal price = ordPrice.divide(new BigDecimal(num)); + obj.putOpt("danjia",price); + obj.putOpt("time",tbTransition.getCreateTime()); + info.put(obj); + } + HashMap<String, Object> map = new HashMap<>(); + map.put("huizong",huiZong); + map.put("info",info); + return AjaxResult.success().put("data",map); + } + public void newSaveextracted(TjOrder tjOrder, TjCustomer tjCustomer, BigDecimal discount, SysUser sysUser, TjReservation tjReservation, TjFlowingWater tjFlowingWater) { tjAskMedicalHistoryService.updateTjAskMedicalHistoryByCusId(tjOrder.getTjNumber(), sysUser.getNickName(), String.valueOf(sysUser.getUserId()), String.valueOf(tjCustomer.getCusId())); tjOrderDetailService.saveTjOrderDetailsByCusId(tjCustomer.getCusIdcard(), String.valueOf(tjOrder.getOrderId()), sysUser.getNickName(), String.valueOf(sysUser.getUserId())); -- Gitblit v1.8.0