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.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>
|
* erp采购 Mapper 接口
|
* </p>
|
*
|
* @author xiaochen
|
* @since 2025-08-20
|
*/
|
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);
|
}
|
