From b9903ead016b8b1aa68eb04b48fca3b53fdab0d3 Mon Sep 17 00:00:00 2001 From: cloudroam <cloudroam> Date: 星期一, 30 十二月 2024 10:42:43 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master-v4' into master-v4 --- src/main/java/com/mzl/flower/mapper/payment/OrderMapper.java | 24 ++++++++++++++++++++++++ 1 files changed, 24 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/mzl/flower/mapper/payment/OrderMapper.java b/src/main/java/com/mzl/flower/mapper/payment/OrderMapper.java index ec510dc..debf57f 100644 --- a/src/main/java/com/mzl/flower/mapper/payment/OrderMapper.java +++ b/src/main/java/com/mzl/flower/mapper/payment/OrderMapper.java @@ -9,6 +9,7 @@ import org.apache.ibatis.annotations.Select; import org.springframework.stereotype.Repository; +import java.math.BigDecimal; import java.time.LocalDateTime; import java.util.List; @@ -55,4 +56,27 @@ List<OrderListExportDTO> selectOrderExportList(@Param("condition") OrderQueryDTO dto); + + @Select("SELECT si.contact_tel " + + "FROM t_supplier_info si " + + "WHERE si.id IN ( " + + " SELECT oi.supplier_id " + + " FROM t_order_item oi " + + " JOIN t_order q ON oi.order_id = q.id " + + " WHERE q.deleted = 0 " + + " AND q.status_backend = #{Status} " + + " AND q.payment_time >= #{startTime} " + + " AND q.payment_time <= #{endTime} " + + " GROUP BY oi.supplier_id " + + ")") + List<String> getWaitSendMessageInfoBySupplier(String Status, LocalDateTime startTime, LocalDateTime endTime); + + BigDecimal getOrderSaleAmount(@Param("startTime") LocalDateTime startTime + , @Param("endTime") LocalDateTime endTime); + + List<Order> selectAllDateList(); + + void updatePaymentCreateDate(@Param("order") Order order); + + List<OrderStatusCountDTO> getAbnormalOrderStatusCount(@Param("condition") OrderQueryDTO dto); } -- Gitblit v1.9.3