From 453ee097563df5788f96e102b38249f0ca70d82a Mon Sep 17 00:00:00 2001
From: xuhy <3313886187@qq.com>
Date: 星期二, 14 十月 2025 18:41:54 +0800
Subject: [PATCH] 诊所和供应商首页统计

---
 ruoyi-system/src/main/java/com/ruoyi/system/mapper/TSysOrderMapper.java |   24 ++++++++++++++++++++++++
 1 files changed, 24 insertions(+), 0 deletions(-)

diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TSysOrderMapper.java b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TSysOrderMapper.java
index 5767450..591b134 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TSysOrderMapper.java
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TSysOrderMapper.java
@@ -4,10 +4,13 @@
 import com.ruoyi.common.basic.PageInfo;
 import com.ruoyi.system.model.TSysOrder;
 import com.ruoyi.system.query.TSysOrderQuery;
+import com.ruoyi.system.vo.ClinicSalesStatisticsGoodsCountVO;
+import com.ruoyi.system.vo.ClinicSalesStatisticsGoodsTypeVO;
 import com.ruoyi.system.vo.TSysOrderPageVo;
 import com.ruoyi.system.vo.TSysOrderVO;
 import org.apache.ibatis.annotations.Param;
 
+import java.math.BigDecimal;
 import java.util.List;
 
 /**
@@ -31,4 +34,25 @@
 
     List<TSysOrderPageVo> pageList(@Param("page") PageInfo<TSysOrderPageVo> page, @Param("query") TSysOrderQuery query, @Param("sTime") String sTime, @Param("eTime") String eTime);
 
+    Integer clinicSalesStatisticsCount(@Param("clinicId")String clinicId);
+
+    Integer clinicSalesStatisticsTypeCount(@Param("clinicId")String clinicId);
+
+    BigDecimal clinicSalesStatisticsMoney(@Param("clinicId")String clinicId,
+                                          @Param("startTime")String startTime,
+                                          @Param("endTime")String endTime);
+
+    List<ClinicSalesStatisticsGoodsTypeVO> supplierSalesStatisticsGoodsType(@Param("clinicId")String clinicId,
+                                                                            @Param("startTime")String startTime,
+                                                                            @Param("endTime")String endTime);
+
+    List<ClinicSalesStatisticsGoodsCountVO> supplierSalesStatisticsGoodsCount(@Param("clinicId")String clinicId,
+                                                                              @Param("startTime")String startTime,
+                                                                              @Param("endTime")String endTime,
+                                                                              @Param("goodsName")String goodsName);
+
+    List<ClinicSalesStatisticsGoodsCountVO> supplierSalesStatisticsGoodsCountMonth(@Param("clinicId")String clinicId,
+                                                                                   @Param("startTime")String startTime,
+                                                                                   @Param("endTime")String endTime,
+                                                                                   @Param("goodsName")String goodsName);
 }

--
Gitblit v1.7.1