From 527d899a65c45843d1b96e9b1f27f9a7cfab2feb Mon Sep 17 00:00:00 2001 From: 陶杰 <1378534974@qq.com> Date: 星期四, 12 九月 2024 20:38:24 +0800 Subject: [PATCH] 1.供应商-订单统计-下拉刷新 --- src/main/java/com/mzl/flower/service/payment/DeliveryOrderService.java | 73 +++++++++++++++++++++++++++++------- 1 files changed, 58 insertions(+), 15 deletions(-) diff --git a/src/main/java/com/mzl/flower/service/payment/DeliveryOrderService.java b/src/main/java/com/mzl/flower/service/payment/DeliveryOrderService.java index 2a89ef7..055edd1 100644 --- a/src/main/java/com/mzl/flower/service/payment/DeliveryOrderService.java +++ b/src/main/java/com/mzl/flower/service/payment/DeliveryOrderService.java @@ -34,6 +34,7 @@ import java.time.LocalDate; import java.time.LocalDateTime; import java.time.format.DateTimeFormatter; +import java.time.temporal.ChronoUnit; import java.util.ArrayList; import java.util.HashMap; import java.util.List; @@ -179,6 +180,8 @@ } public Page<DeliveryOrderStatisticsDTO> selectSupplierDoStatistics(Page page){ + + DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyyMMdd"); LocalDate theDay = parseLocalDate("2024-08-03"); long current = page.getCurrent(); @@ -187,7 +190,7 @@ current = current == 0 ? 1 : current; long endDays = (current - 1) * size; - long beginDays = endDays + size; + long beginDays = endDays + size-1; LocalDate beginDate = now.plusDays(-beginDays); LocalDate endDate = now.plusDays(-endDays); @@ -207,6 +210,7 @@ , fivePm.plusDays(-1), fivePm); DeliveryOrderStatisticsDTO dto = new DeliveryOrderStatisticsDTO(); + dto.setId(endDate.format(formatter)); dto.setDate(endDate); dto.setNum(0); dto.setPrice(new BigDecimal(0)); @@ -219,6 +223,14 @@ } page.setRecords(ls); + + + // 获取当前日期 + LocalDate today = LocalDate.now(); + // 计算当前日期与给定日期的天数差 + long daysBetween = ChronoUnit.DAYS.between(theDay, today); + page.setTotal(daysBetween); + return page; } @@ -354,7 +366,7 @@ ); if (items != null && items.size() > 0) { for (OrderItem i : items) { - i.setStatus(Constants.CHECK_OPERATE.ok.name()); + i.setStatus(Constants.ORDER_ITEM_STATUS.ok.name()); i.setCheckTime(LocalDateTime.now()); orderItemMapper.updateById(i); } @@ -399,12 +411,14 @@ } Integer orderCountToday = deliveryOrderMapper.selectCount(new QueryWrapper<DeliveryOrder>() + .eq("deleted", 0) .eq("supplier_id", supplierId) .gt("create_time", startDate) .le("create_time", endDate)); dto.setOrderCountToday(orderCountToday == null ? 0 : orderCountToday); Integer orderCountYesterday = deliveryOrderMapper.selectCount(new QueryWrapper<DeliveryOrder>() + .eq("deleted", 0) .eq("supplier_id", supplierId) .gt("create_time", startDate.plusDays(-1)) .le("create_time", endDate.plusDays(-1))); @@ -412,13 +426,16 @@ LocalDateTime ffPm = LocalDate.now().withDayOfMonth(1).atTime(17, 0, 0).plusDays(-1); Integer orderCountMonth = deliveryOrderMapper.selectCount(new QueryWrapper<DeliveryOrder>() + .eq("deleted", 0) .eq("supplier_id", supplierId) .gt("create_time", ffPm)); dto.setOrderCountMonth(orderCountMonth == null ? 0 : orderCountMonth); BigDecimal salesRate = new BigDecimal(0); Integer orderTotal = deliveryOrderMapper.selectCount(new QueryWrapper<DeliveryOrder>() - .eq("supplier_id", supplierId)); + .eq("deleted", 0) + .eq("supplier_id", supplierId) + ); Integer salesCount = orderItemSalesMapper.getSupplierSalesCount(supplierId); if (orderTotal != null && orderTotal > 0) { BigDecimal rate = new BigDecimal(salesCount).divide(new BigDecimal(orderTotal), 2, RoundingMode.HALF_UP); @@ -463,6 +480,7 @@ //////////////////////////////////////////////////////////////新接口 public Page<DeliveryOrderList4CheckDTO> selectSupplierDoList4Check(Page page, DeliveryOrderStationQueryDTO dto) { + dto.setStatusList(splitParam(dto.getStatus())); List<DeliveryOrderList4CheckDTO> ls = deliveryOrderMapper.selectSupplierDoList4Check(page, dto); page.setRecords(ls); @@ -473,6 +491,7 @@ if(dto.getSupplierId() == null){ throw new ValidationException("供应商id不能为空"); } + dto.setStatusList(splitParam(dto.getStatus())); List<DeliveryOrder4CheckDTO> ls = deliveryOrderMapper.selectSupplierDoInfo4Check(page, dto); if(ls != null && ls.size() > 0){ @@ -591,17 +610,37 @@ throw new ValidationException("处理数量不能大于商品数量"); } - if(deductAmount != null && deductAmount.doubleValue() > oi.getTotal().doubleValue()){ - throw new ValidationException("降级金额不能大于商品总金额"); + List<OrderItemCheck> cLs = orderItemCheckMapper.selectList(new QueryWrapper<OrderItemCheck>() + .ne("type", dto.getType()) + .eq("order_item_id", dto.getOrderItemId()) + ); + int otherNum = 0; + if(cLs != null && cLs.size() > 0){ + for(OrderItemCheck c : cLs){ + if(Constants.CHECK_AUDIT_STATUS.REJECTED.name().equals(c.getAuditStatus())){ + continue; + } + otherNum += c.getNum(); + } + } + if(otherNum + dto.getNum() > oi.getNum()){ + throw new ValidationException("处理总数量不能大于商品数量"); } - BigDecimal deduct = deductAmount; - if(deduct == null){ - deduct = new BigDecimal(0); - if(Constants.CHECK_TYPE.replace.name().equals(dto.getType())){ - deduct = oi.getSupplierPrice().multiply(new BigDecimal(dto.getNum())); - } else if(Constants.CHECK_TYPE.lack.name().equals(dto.getType())){ - deduct = oi.getPrice().multiply(new BigDecimal(dto.getNum())); + BigDecimal deduct = new BigDecimal(0); + BigDecimal realPrice = getAmount(oi.getRealPrice()); + if(Constants.CHECK_TYPE.replace.name().equals(dto.getType())){ + deduct = oi.getSupplierPrice().multiply(new BigDecimal(dto.getNum())); + } else if(Constants.CHECK_TYPE.lack.name().equals(dto.getType())){ + deduct = realPrice.multiply(new BigDecimal(dto.getNum())); + } else if (Constants.CHECK_TYPE.reduce.name().equals(dto.getType())) { + if(deductAmount == null){ + throw new ValidationException("降级金额不能为空"); + } + deduct = deductAmount.multiply(new BigDecimal(dto.getNum())); + BigDecimal dt = realPrice.multiply(new BigDecimal(dto.getNum())); + if(deduct.doubleValue() > dt.doubleValue()){ + throw new ValidationException("降级金额不能大于商品处理数量金额"); } } @@ -610,8 +649,8 @@ .eq("order_item_id", dto.getOrderItemId()) ); if(c != null){ - if(StringUtils.isNotEmpty(c.getAuditStatus())){ - throw new ValidationException("已审核,不可修改"); + if(Constants.CHECK_AUDIT_STATUS.AGREED.name().equals(c.getAuditStatus())){ + throw new ValidationException("已审核通过,不可修改"); } c.setCheckTime(LocalDateTime.now()); c.setNum(dto.getNum()); @@ -619,6 +658,8 @@ c.setPictures(toJSONString(pictureList)); c.setTargetLevel(targetLevel); c.setDeductAmount(deduct); + c.setAuditStatus(null); + c.setAuditTime(null); c.update(SecurityUtils.getUserId()); orderItemCheckMapper.updateById(c); } else { @@ -638,7 +679,7 @@ } } - public void checkOrderItemStatus(String id){ + public String checkOrderItemStatus(String id){ OrderItem oi = orderItemMapper.selectById(id); List<OrderItemCheck> cLs = orderItemCheckMapper.selectList(new QueryWrapper<OrderItemCheck>() .eq("order_item_id", id) @@ -669,6 +710,8 @@ deliveryOrderMapper.updateById(d); } } + + return oi.getOrderId(); } public void deleteCheckInfo(String itemId, String type){ -- Gitblit v1.9.3