平台分账报表

xuhy

2025-10-15 69e70841125d2e1f12fca17b0751d6d8842fc6cf

 ruoyi-system/src/main/java/com/ruoyi/system/mapper/TErpProcurementMapper.java

@@ -3,13 +3,19 @@
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.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,4 +34,105 @@
    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);
}