From e92163c601f2ccfda20a138b60ed9ad31c47e4d6 Mon Sep 17 00:00:00 2001 From: cloudroam <cloudroam> Date: 星期二, 12 十一月 2024 18:37:22 +0800 Subject: [PATCH] add:553-结算列表增加导出表格功能;562-订单列表需要增加订单的扎数统计字段 --- src/main/java/com/mzl/flower/service/payment/OrderService.java | 7 ++++++- 1 files changed, 6 insertions(+), 1 deletions(-) diff --git a/src/main/java/com/mzl/flower/service/payment/OrderService.java b/src/main/java/com/mzl/flower/service/payment/OrderService.java index d8a9c9d..497b07c 100644 --- a/src/main/java/com/mzl/flower/service/payment/OrderService.java +++ b/src/main/java/com/mzl/flower/service/payment/OrderService.java @@ -921,6 +921,10 @@ orderIds.add(o.getId()); OrderPlatformListDTO p = new OrderPlatformListDTO(); + //增加订单扎数 + Integer sumNumByOrderId = orderItemMapper.getSumNumByOrderId(o.getId()); + o.setSaleNum(sumNumByOrderId); + BeanUtils.copyProperties(o, p); result.add(p); } @@ -1752,7 +1756,7 @@ public void exportOrderDetail(HttpServletResponse response, OrderQueryDTO dto) { List<OrderListExportDTO> ls = getOrderExportListBase( dto); String[] rowsName = new String[]{"序号","订单号", "用户账号", "收货人", "收货人电话", "收货地址", "订单金额" - , "底价", "订单状态", "下单时间", "合伙人", "库位", "特殊需求", "备注"}; + , "底价","销售扎数", "订单状态", "下单时间", "合伙人", "库位", "特殊需求", "备注"}; List<Object[]> dataList = new ArrayList<>(); int sn = 1; for (OrderListExportDTO o : ls) { @@ -1766,6 +1770,7 @@ objs[a++] = o.getCustomerAddress(); objs[a++] = o.getTotalAmount(); objs[a++] = o.getSupplierAmount(); + objs[a++] = o.getSaleNum(); objs[a++] = o.getStatusBackendStr(); objs[a++] = o.getCreateTime(); objs[a++] = o.getPartnerName(); -- Gitblit v1.9.3