From e173071d2a65a8303095895c4c6a61a7fd170312 Mon Sep 17 00:00:00 2001
From: liujie <1793218484@qq.com>
Date: 星期四, 16 十月 2025 11:26:14 +0800
Subject: [PATCH] Merge branch 'master' of http://120.76.84.145:10101/gitblit/r/java/haizhentong
---
ruoyi-system/src/main/java/com/ruoyi/system/mapper/TErpProcurementMapper.java | 151 ++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 151 insertions(+), 0 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 75af99a..7c8ce6f 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
@@ -1,7 +1,23 @@
package com.ruoyi.system.mapper;
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.PlatformLedgerReportExport;
+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.model.TErpProcurementGoods;
+import com.ruoyi.system.query.ClinicProcurementReportQuery;
+import com.ruoyi.system.query.PerformanceReportQuery;
+import com.ruoyi.system.query.TErpGoodsQuery;
+import com.ruoyi.system.query.TErpProcurementQuery;
+import com.ruoyi.system.vo.*;
+import org.apache.ibatis.annotations.Param;
+
+import java.math.BigDecimal;
+import java.util.List;
/**
* <p>
@@ -13,4 +29,139 @@
*/
public interface TErpProcurementMapper extends BaseMapper<TErpProcurement> {
+ List<TErpProcurementVo> pageList(@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<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") 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);
+ List<TErpProcurementGoods> branchAdminStatisticsThree(@Param("clinicIds") List<String> clinicIds);
+
+ /**
+ * 平台分账报表
+ * @param query
+ * @return
+ */
+ List<ClinicProcurementReportVO> platformLedgerReport(@Param("query")ClinicProcurementReportQuery query, @Param("pageInfo")PageInfo<ClinicProcurementReportVO> pageInfo);
+
+ /**
+ * 平台分账报表导出
+ * @param query
+ * @return
+ */
+ List<PlatformLedgerReportExport> exportPlatformLedgerReport(@Param("query")ClinicProcurementReportQuery query);
+
+ /**
+ * 分公司业绩报表
+ * @param query
+ * @return
+ */
+ List<BranchPerformanceReportVO> branchPerformanceReport(@Param("query")PerformanceReportQuery query, @Param("pageInfo")PageInfo<BranchPerformanceReportVO> pageInfo);
+
+ /**
+ * 业务员业绩报表
+ * @param query
+ * @return
+ */
+ List<SalespersonPerformanceReportVO> salespersonPerformanceReport(@Param("query")PerformanceReportQuery query, @Param("pageInfo")PageInfo<SalespersonPerformanceReportVO> pageInfo);
+
+ /**
+ * 分公司业绩报表导出
+ * @param query
+ * @return
+ */
+ List<BranchPerformanceReportVO> exportBranchPerformanceReport(@Param("query")PerformanceReportQuery query);
+
+ /**
+ * 业务员业绩报表导出
+ * @param query
+ * @return
+ */
+ List<SalespersonPerformanceReportVO> exportSalespersonPerformanceReport(@Param("query")PerformanceReportQuery query);
}
--
Gitblit v1.7.1