From 2a7adfe776c3c7e0aad9405cfd4cc86b2d1c134b Mon Sep 17 00:00:00 2001 From: guoyuji <guoyujie@ng.com> Date: 星期一, 20 五月 2024 11:41:20 +0800 Subject: [PATCH] 添加订单根据产品分类报表功能 --- north-glass-erp/src/main/java/com/example/erp/service/sd/OrderService.java | 24 ++++++++++++++++++++++++ 1 files changed, 24 insertions(+), 0 deletions(-) diff --git a/north-glass-erp/src/main/java/com/example/erp/service/sd/OrderService.java b/north-glass-erp/src/main/java/com/example/erp/service/sd/OrderService.java index 187f252..4b263ee 100644 --- a/north-glass-erp/src/main/java/com/example/erp/service/sd/OrderService.java +++ b/north-glass-erp/src/main/java/com/example/erp/service/sd/OrderService.java @@ -315,4 +315,28 @@ public List<Order> exportOrderReport() { return orderDetailMapper.exportOrderReport(); } + + public Map<String,Object> getOrderProductSummary(Integer pageNum, Integer pageSize, List<String> selectDate, OrderDetail orderDetail) { + Integer offset = (pageNum-1)*pageSize; + String endDate = LocalDate.now().toString(); + String startDate = LocalDate.now().minusDays(15).toString(); + if(selectDate !=null && selectDate.size()==2){ + if(!selectDate.get(0).isEmpty()){ + startDate = selectDate.get(0); + } + if(!selectDate.get(1).isEmpty()){ + endDate = selectDate.get(1); + } + } + + Map<String,Object> map = new HashMap<>(); + map.put("data",orderDetailMapper.getOrderProductSummary(offset, pageSize, startDate, endDate, orderDetail)); + map.put("total",orderDetailMapper.getOrderReportTotal(offset, pageSize, startDate, endDate, orderDetail)); + List<String> list = new ArrayList<>(); + list.add(startDate); + list.add(endDate); + map.put("selectDate",list); +// map.put("total",orderMapper.getPageTotal(offset, pageSize, startDate, endDate, orderDetail)); + return map; + } } -- Gitblit v1.8.0