package com.ruoyi.cwgl.mapper;

import java.util.List;

import com.ruoyi.cwgl.domain.ReceivableBillCustomerSummary;
import com.ruoyi.cwgl.domain.ReceivableBillManagement;
import com.ruoyi.cwgl.domain.vo.ReceivableBillAgingAnalysisVo;
import com.ruoyi.cwgl.domain.vo.ReceivableBillAccountAnalysisVo;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;


/**
 * 应收账单管理Mapper接口
 * 
 * @author ruoyi
 * @date 2025-12-17
 */
public interface ReceivableBillManagementMapper  extends BaseMapper<ReceivableBillManagement>
{
    /**
     * 查询应收账单管理
     * 
     * @param id 应收账单管理ID
     * @return 应收账单管理
     */
    public ReceivableBillManagement selectReceivableBillManagementById(Integer id);

    /**
     * 查询应收账单管理 记录数
     *
     * @param receivableBillManagement 应收账单管理
     * @return 应收账单管理集合
     */
    public int selectReceivableBillManagementCount(ReceivableBillManagement receivableBillManagement);

    /**
     * 查询应收账单管理列表
     * 
     * @param receivableBillManagement 应收账单管理
     * @return 应收账单管理集合
     */
    public List<ReceivableBillManagement> selectReceivableBillManagementList(ReceivableBillManagement receivableBillManagement);

    /**
     * 新增应收账单管理
     * 
     * @param receivableBillManagement 应收账单管理
     * @return 结果
     */
    public int insertReceivableBillManagement(ReceivableBillManagement receivableBillManagement);

    /**
     * 新增应收账单管理[批量]
     *
     * @param receivableBillManagements 应收账单管理
     * @return 结果
     */
    public int insertReceivableBillManagementBatch(List<ReceivableBillManagement> receivableBillManagements);

    /**
     * 修改应收账单管理
     * 
     * @param receivableBillManagement 应收账单管理
     * @return 结果
     */
    public int updateReceivableBillManagement(ReceivableBillManagement receivableBillManagement);

    /**
     * 修改应收账单管理[批量]
     *
     * @param receivableBillManagements 应收账单管理
     * @return 结果
     */
    public int updateReceivableBillManagementBatch(List<ReceivableBillManagement> receivableBillManagements);

    /**
     * 删除应收账单管理
     * 
     * @param id 应收账单管理ID
     * @return 结果
     */
    public int deleteReceivableBillManagementById(Integer id);

    /**
     * 批量删除应收账单管理
     * 
     * @param ids 需要删除的数据ID
     * @return 结果
     */
    public int deleteReceivableBillManagementByIds(Integer[] ids);
    
    /**
     * 根据系统编号查询应收账单管理
     * 
     * @param systemNo 系统编号
     * @return 应收账单管理
     */
    public ReceivableBillManagement selectReceivableBillManagementBySystemNo(String systemNo);
    
    /**
     * 查询应收账单客户汇总列表
     * 
     * @param receivableBillManagement 查询条件
     * @return 应收账单客户汇总列表
     */
    public List<ReceivableBillCustomerSummary> selectReceivableBillCustomerSummaryList(ReceivableBillManagement receivableBillManagement);
    
    /**
     * 查询应收账单账龄分析列表
     * 
     * @param receivableBillManagement 查询条件
     * @return 应收账单账龄分析列表
     */
    public List<ReceivableBillAgingAnalysisVo> selectReceivableBillAgingAnalysisList(ReceivableBillManagement receivableBillManagement);
    
    /**
     * 批量更新应收账单账龄分析数据
     * 直接在数据库层面计算账龄分段
     * 
     * @return 更新的记录数
     */
    public int batchUpdateAgingAnalysisData();
    
    /**
     * 查询应收账单账款分析列表
     * 
     * @param receivableBillManagement 查询条件
     * @return 应收账单账款分析列表
     */
    public List<ReceivableBillAccountAnalysisVo> selectReceivableBillAccountAnalysisList(ReceivableBillManagement receivableBillManagement);
}