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