From fd45fcbd496bbeaf9ee18edd8f2f858cf9cebaf3 Mon Sep 17 00:00:00 2001 From: Pu Zhibing <393733352@qq.com> Date: 星期五, 24 一月 2025 16:47:38 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master' --- ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/controller/OrderController.java | 68 ++++++++++++++++++++++++++++++---- 1 files changed, 60 insertions(+), 8 deletions(-) diff --git a/ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/controller/OrderController.java b/ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/controller/OrderController.java index 349856a..ef78283 100644 --- a/ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/controller/OrderController.java +++ b/ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/controller/OrderController.java @@ -9,6 +9,7 @@ import com.ruoyi.account.api.model.UserAddress; import com.ruoyi.common.core.domain.R; import com.ruoyi.common.core.utils.StringUtils; +import com.ruoyi.common.core.utils.poi.ExcelUtil; import com.ruoyi.common.core.web.controller.BaseController; import com.ruoyi.common.core.web.page.PageInfo; import com.ruoyi.common.core.web.page.TableDataInfo; @@ -31,6 +32,7 @@ import io.swagger.annotations.*; import org.springframework.validation.annotation.Validated; import org.springframework.web.bind.annotation.*; +import org.springframework.web.multipart.MultipartFile; import javax.annotation.Resource; import javax.servlet.http.HttpServletResponse; @@ -235,7 +237,15 @@ @PostMapping("/byUserId") public R<List<Order>> byUserId(@RequestParam("appUserId") Long appUserId,@RequestParam("shopId") Integer shopId){ - return R.ok(orderService.lambdaQuery().eq(Order::getAppUserId, appUserId).eq(Order::getShopId, shopId).list()); + List<Order> list = orderService.lambdaQuery() + .eq(Order::getAppUserId, appUserId) + .eq(null != shopId && -1 != shopId, Order::getShopId, shopId) + .eq(Order::getDistributionMode, 1) + .eq(Order::getPayStatus, 2) + .isNull(Order::getRefundStatus) + .eq(Order::getDelFlag, 0) + .notIn(Order::getOrderStatus, 5, 6).list(); + return R.ok(list); } @PostMapping("/byShopId") public R<List<Order>> byShopId(@RequestParam("shopId") Integer shopId){ @@ -243,7 +253,13 @@ } @PostMapping("/byShopIdAndUserId") public R<List<Order>> byShopIdAndUserId(@RequestParam("appUserId") Long appUserId,@RequestParam("shopId") Integer shopId){ - List<Order> list = orderService.lambdaQuery().isNotNull(Order::getEndTime).eq(Order::getShopId, shopId).eq(Order::getAppUserId, appUserId).in(Order::getOrderStatus, 4, 7, 8).list(); + List<Order> list = orderService.lambdaQuery().isNotNull(Order::getEndTime) + .eq(null != shopId && -1 != shopId, Order::getShopId, shopId) + .eq(Order::getAppUserId, appUserId) + .eq(Order::getPayStatus, 2) + .isNull(Order::getRefundStatus) + .eq(Order::getDelFlag, 0) + .notIn(Order::getOrderStatus, 5, 6).list(); return R.ok(list); } @@ -302,6 +318,7 @@ Long userid = tokenService.getLoginUser().getUserid(); SysUser sysUser = sysUserClient.getSysUser(userid).getData(); List<Order> orderList = orderService.list(new LambdaQueryWrapper<Order>() + .ne(Order::getOrderStatus,5) .eq(sysUser.getRoleType() == 2, Order::getShopId, sysUser.getObjectId()) .between(Order::getCreateTime, LocalDateTime.parse(startTime, DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss")), LocalDateTime.parse(endTime, DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"))) .orderByAsc(Order::getCreateTime)); @@ -326,14 +343,14 @@ for (Order order : value) { if (order.getOrderType().equals(1)) { serviceTotal++; - serviceTotalMoney = serviceTotalMoney.add(order.getPaymentAmount()); + serviceTotalMoney = serviceTotalMoney.add(order.getTotalAmount()); total++; - totalMoney = totalMoney.add(order.getPaymentAmount()); - }else if (order.getOrderType().equals(2) && 1 == order.getDistributionMode()){ + totalMoney = totalMoney.add(order.getTotalAmount()); + }else if (order.getOrderType().equals(2)){ singleTotal++; - singleTotalMoney = singleTotalMoney.add(order.getPaymentAmount()); + singleTotalMoney = singleTotalMoney.add(order.getTotalAmount()); total++; - totalMoney = totalMoney.add(order.getPaymentAmount()); + totalMoney = totalMoney.add(order.getTotalAmount()); } } orderStatisticsDetail.setDate(key); @@ -360,7 +377,7 @@ } catch (ParseException e) { throw new RuntimeException(e); } - }).reversed()) + })) .collect(Collectors.toList()); orderStatistics.setOrderStatisticsDetailList(sortedDetails); } @@ -497,5 +514,40 @@ orderService.updateById(order); return R.ok(); } + + + /** + * 导入物流信息 + */ + @PostMapping("/importExpress") + public R importExpress(@RequestParam("file") MultipartFile file){ + orderService.importExpress(file); + return R.ok(); + } + + /** + * 导出订单信息 + */ + @GetMapping("/exportExpress") + public void exportExpress(HttpServletResponse response,OrderPageList orderPage){ + PageInfo<OrderPageListVo> orderPageList = orderService.getOrderPageList(orderPage); + List<OrderPageListVo> list = orderPageList.getRecords(); + ExcelUtil<OrderPageListVo> util = new ExcelUtil<OrderPageListVo>(OrderPageListVo.class); + util.exportExcel(response, list, "订单数据"); + } + + + /** + * 获取用户订单数量 + * @param appUserId + * @return + */ + @PostMapping("/getOrderCountByAppUserId") + public R<Long> getOrderCountByAppUserId(@RequestParam("id") Long appUserId){ + long count = orderService.count(new LambdaQueryWrapper<Order>().eq(Order::getDelFlag, 0) + .eq(Order::getAppUserId, appUserId).in(Order::getOrderStatus, Arrays.asList(1, 2, 3, 4, 7, 8)) + .eq(Order::getPayStatus, 2)); + return R.ok(count); + } } -- Gitblit v1.7.1