From 04316f0c84a0da562f0f526e6e537b372dfd8ad9 Mon Sep 17 00:00:00 2001
From: xuhy <3313886187@qq.com>
Date: 星期三, 15 十月 2025 16:09:32 +0800
Subject: [PATCH] 诊所采购报表,导出
---
ruoyi-system/src/main/java/com/ruoyi/system/mapper/TErpProcurementMapper.java | 94 +++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 91 insertions(+), 3 deletions(-)
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TErpProcurementMapper.java b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TErpProcurementMapper.java
index bf37058..916fad6 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TErpProcurementMapper.java
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TErpProcurementMapper.java
@@ -3,13 +3,17 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.common.basic.PageInfo;
import com.ruoyi.common.core.domain.entity.SysUser;
+import com.ruoyi.system.export.ProcurementReportClinicExport;
+import com.ruoyi.system.export.ProcurementReportPlatformExport;
+import com.ruoyi.system.export.ProcurementReportSupplierExport;
import com.ruoyi.system.model.TErpProcurement;
+import com.ruoyi.system.query.ClinicProcurementReportQuery;
import com.ruoyi.system.query.TErpGoodsQuery;
import com.ruoyi.system.query.TErpProcurementQuery;
-import com.ruoyi.system.vo.TErpGoodsVO;
-import com.ruoyi.system.vo.TErpProcurementVo;
+import com.ruoyi.system.vo.*;
import org.apache.ibatis.annotations.Param;
+import java.math.BigDecimal;
import java.util.List;
/**
@@ -28,6 +32,90 @@
List<TErpGoodsVO> inventoryNotEnoughList(@Param("user") SysUser user);
- List<TErpProcurementVo> pageListWarehouse(@Param("query") TErpProcurementQuery query, @Param("pageInfo") PageInfo<TErpProcurementVo> pageInfo, @Param("user") SysUser user, @Param("sTime") String sTime, @Param("eTime") String eTime, @Param("supplierClinicId") String supplierClinicId);
+ List<TErpProcurementVo> pageListWarehouse(@Param("query") TErpProcurementQuery query, @Param("pageInfo") PageInfo<TErpProcurementVo> pageInfo, @Param("user") SysUser user, @Param("sTime") String sTime, @Param("eTime") String eTime, @Param("supplierClinicId") List<String> supplierClinicId);
+ List<SupplierThirtyProcurementStatisticsVO> supplierThirtyProcurementStatistics(@Param("supplierAndClinicId")String supplierAndClinicId,
+ @Param("startTime")String startTime,
+ @Param("endTime")String endTime,
+ @Param("roleType")Integer roleType);
+
+ List<SupplierThirtyMoneyProcurementStatisticsVO> supplierThirtyMoneyProcurementStatistics(@Param("supplierAndClinicId")String supplierAndClinicId,
+ @Param("startTime")String startTime,
+ @Param("endTime")String endTime,
+ @Param("roleType")Integer roleType);
+
+ /**
+ * 供应商销售统计-类型
+ * @param supplierId
+ * @return
+ */
+ Integer supplierSalesStatisticsTypeCount(@Param("supplierId")String supplierId);
+
+ /**
+ * 供应商销售统计-数量
+ * @param supplierId
+ * @return
+ */
+ Integer supplierSalesStatisticsCount(@Param("supplierId")String supplierId);
+
+ /**
+ * 供应商销售统计-金额
+ * @param supplierId
+ * @return
+ */
+ BigDecimal supplierSalesStatisticsMoney(@Param("supplierId")String supplierId,
+ @Param("startTime")String startTime,
+ @Param("endTime")String endTime);
+
+ /**
+ * 供应商销售统计-商品类型
+ * @param supplierId
+ * @return
+ */
+ List<SupplierSalesStatisticsGoodsTypeVO> supplierSalesStatisticsGoodsType(@Param("supplierId")String supplierId,
+ @Param("startTime")String startTime,
+ @Param("endTime")String endTime);
+
+ /**
+ * 供应商销售统计-商品数量
+ * @param supplierId
+ * @return
+ */
+ List<SupplierSalesStatisticsGoodsCountVO> supplierSalesStatisticsGoodsCount(@Param("supplierId")String supplierId,
+ @Param("startTime")String startTime,
+ @Param("endTime")String endTime,
+ @Param("goodsName")String goodsName);
+
+ List<SupplierSalesStatisticsGoodsCountVO> supplierSalesStatisticsGoodsCountMonth(@Param("supplierId")String supplierId,
+ @Param("startTime")String startTime,
+ @Param("endTime")String endTime,
+ @Param("goodsName")String goodsName);
+
+ /**
+ * 诊所采购报表
+ * @param query
+ * @return
+ */
+ List<ClinicProcurementReportVO> clinicProcurementReport(@Param("query")ClinicProcurementReportQuery query, @Param("pageInfo")PageInfo<ClinicProcurementReportVO> pageInfo);
+
+ /**
+ * 诊所采购报表导出
+ * @param query
+ * @return
+ */
+ List<ProcurementReportClinicExport> exportProcurementReportClinic(@Param("query")ClinicProcurementReportQuery query);
+
+ /**
+ * 供应商-诊所采购报表导出
+ * @param query
+ * @return
+ */
+ List<ProcurementReportSupplierExport> exportProcurementReportSupplier(@Param("query")ClinicProcurementReportQuery query);
+
+ /**
+ * 平台-诊所采购报表导出
+ * @param query
+ * @return
+ */
+ List<ProcurementReportPlatformExport> exportProcurementReportPlatform(@Param("query")ClinicProcurementReportQuery query);
}
--
Gitblit v1.7.1