From ddc6cd417d5e912d5cba297bb7849a1dcf7367be Mon Sep 17 00:00:00 2001 From: pang.jiabao <pang_jiabao@163.com> Date: 星期日, 27 四月 2025 11:01:41 +0800 Subject: [PATCH] 获取未完成订单统计信息 --- src/main/java/com/zy/asrs/mapper/OrderMapper.java | 36 ++++++++++++++++++++++++++++++++++-- 1 files changed, 34 insertions(+), 2 deletions(-) diff --git a/src/main/java/com/zy/asrs/mapper/OrderMapper.java b/src/main/java/com/zy/asrs/mapper/OrderMapper.java index 2e52b23..8cdf6be 100644 --- a/src/main/java/com/zy/asrs/mapper/OrderMapper.java +++ b/src/main/java/com/zy/asrs/mapper/OrderMapper.java @@ -1,8 +1,8 @@ package com.zy.asrs.mapper; -import com.zy.asrs.entity.Order; import com.baomidou.mybatisplus.mapper.BaseMapper; -import com.zy.asrs.entity.OrderDetl; +import com.zy.asrs.entity.Order; +import com.zy.asrs.entity.OrderStatisticsDto; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; import org.springframework.stereotype.Repository; @@ -15,4 +15,36 @@ int updateSettle(@Param("orderId")Long orderId, @Param("settle")Long settle, @Param("userId")Long userId); + List<Order> selectComplete(); + + int addToLogTable(Order order); + + List<Order> selectorderNoL(@Param("orderNo")String orderNo); + + void updateSettleByOrderNo(@Param("orderNo") String orderNo, @Param("status") long status, @Param("userId") Long userId); + + /** + * 鏇存柊鍗曟嵁鐘舵�侊紝鍙湁寰呭鐞嗘墠鏇存柊 + */ + void updatePendingSettleByOrderNo(@Param("orderNo") String orderNo, @Param("status") long status); + + /** + * 鏌ヨ鍑哄簱鐢宠鍗曚腑娌℃湁澶囪揣鐨勮鍗曟槑缁嗙殑鍖呰缁勫彿 + */ + List<String> selectStockUpOrderDetl(); + + /** + * 鏇存柊璁㈠崟澶囪揣鐘舵�� + */ + void updateStatusByOrderNo(@Param("orderNo") String orderNo,@Param("status") int status,@Param("userId") int userId); + + /** + * 鏍规嵁鍗曟嵁缂栧彿妯$硦鏌ヨ鍗曟嵁缂栧彿 + */ + List<String> selectOrderNosByOrderNoLike(@Param("orderNo") String orderNo); + + /** + * 鑾峰彇鏈畬鎴愯鍗曠粺璁′俊鎭� + */ + List<OrderStatisticsDto> getUnfulfilledOrders(); } -- Gitblit v1.9.1