From 70d2a5d0f9c6951b2d4cac954041ed73582ff7eb Mon Sep 17 00:00:00 2001
From: liujie <1793218484@qq.com>
Date: 星期一, 09 六月 2025 11:54:00 +0800
Subject: [PATCH] 6.9新增登录失败冻结逻辑
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComShopFlowerOrderDAO.java | 112 +++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 111 insertions(+), 1 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComShopFlowerOrderDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComShopFlowerOrderDAO.java
index e839fcb..c13c93e 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComShopFlowerOrderDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComShopFlowerOrderDAO.java
@@ -1,15 +1,125 @@
package com.panzhihua.service_community.dao;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.panzhihua.common.model.dtos.shop.PageComFlowerOrderListDTO;
+import com.panzhihua.common.model.dtos.shop.PageComShopOrderSearchDTO;
+import com.panzhihua.common.model.vos.shop.*;
import com.panzhihua.service_community.model.dos.ComShopFlowerOrderDO;
import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+
+import java.math.BigDecimal;
+import java.util.Date;
+import java.util.List;
/**
- * @ClassName: ComShopFlowerOrderMapper
+ * @ClassName: ComShopFlowerOrderMapper
* @Author: yh
* @Date: 2022/11/9 16:46
* @Description: TODO
*/
@Mapper
public interface ComShopFlowerOrderDAO extends BaseMapper<ComShopFlowerOrderDO> {
+
+
+ IPage<ComShopFlowerOrderPageVO> pageOrderList(@Param("page") Page page, @Param("comOrderListDTO") PageComFlowerOrderListDTO comOrderListDTO);
+
+
+ IPage<ComShopFlowerOrderPageVO> pageOrderListNoDelivery(@Param("page") Page page, @Param("comOrderListDTO") PageComFlowerOrderListDTO comOrderListDTO);
+
+
+ IPage<ComShopOrderSearchVO> pageOrderBy(@Param("page") Page page,
+ @Param("pageComShopOrderSearchDTO") PageComShopOrderSearchDTO pageComShopOrderSearchDTO);
+
+ /**
+ * 修改配送中状态
+ *
+ * @param orderIds
+ * @param deliveryId
+ * @param status
+ * @param deliveryTime
+ */
+ void updateOrder(@Param("orderIds") List<Long> orderIds,
+ @Param("deliveryId") Long deliveryId,
+ @Param("deliveryNo") String deliveryNo,
+ @Param("status") int status,
+ @Param("deliveryTime") Date deliveryTime);
+
+ /**
+ * 自提送达后修改配送状态和时间
+ *
+ * @param deliveryId
+ * @param serviceTime
+ * @param status
+ */
+ void updateOrderStatus(@Param("deliveryId") Long deliveryId, @Param("serviceTime") Date serviceTime, @Param("status") int status);
+
+ IPage<ComShopFlowerOrderStoreListVO> pageOrderByStoreId(@Param("page") Page page, @Param("comOrderListDTO") PageComFlowerOrderListDTO comOrderListDTO);
+
+ /**
+ * 根据类型统计订单数量
+ *
+ * @param deliveryType
+ * @return
+ */
+ List<ComShopOrderCountVO> selectCountByDeliveryType(@Param("deliveryType") Integer deliveryType, @Param("storeId") Long storeId);
+
+
+ List<ComShopOrderStoreIdCountVO> selectCountByStoreId(@Param("storeId") Long storeId, @Param("deliveryType") Integer deliveryType);
+
+ List<ComShopOrderStoreIdNumVO> selectSumAmountByStoreId(@Param("storeId") Long storeId);
+
+ /**
+ * 获取商家总营业额
+ *
+ * @param storeId
+ * @return
+ */
+ BigDecimal selectTurnover(@Param("storeId") Long storeId);
+
+ /**
+ * 获取商家可结算额度 15天以前的完成的订单
+ *
+ * @param storeId
+ * @return
+ */
+ BigDecimal selectSettlement(@Param("storeId") Long storeId);
+
+ List<ComShopOrderStoreIdNumVO> selectSumOrderAndAmountByStoreId(@Param("storeId") Long storeId);
+
+ /**
+ * 查询近15天的订单量
+ *
+ * @param storeId
+ * @return
+ */
+ List<ComShopOrderStoreIdCountVO> selectCountOrderDayByStoreId(@Param("storeId") Long storeId, @Param("days") Integer days);
+
+ /**
+ * 查询当年月份的订单量
+ *
+ * @param storeId
+ * @return
+ */
+ List<ComShopOrderStoreIdCountVO> selectCountOrderMonthByStoreId(@Param("storeId") Long storeId);
+
+ IPage<ComShopFlowerOrderStoreListVO> pageOrderByDeliveryNo(@Param("page") Page page, @Param("comOrderListDTO") PageComFlowerOrderListDTO comOrderListDTO);
+
+ /**
+ * 查询近n天的营收
+ *
+ * @param storeId
+ * @return
+ */
+ List<ComShopOrderStoreIdNumVO> selectOrderSumPayDayByStoreId(@Param("storeId") Long storeId, @Param("days") Integer days);
+
+ /**
+ * 查询当年月份的营收
+ *
+ * @param storeId
+ * @return
+ */
+ List<ComShopOrderStoreIdNumVO> selectOrderSumMonthByStoreId(@Param("storeId") Long storeId);
}
\ No newline at end of file
--
Gitblit v1.7.1