package com.ruoyi.cwgl.service.impl;

import java.util.List;

import com.ruoyi.common.utils.DateUtils;
import javax.annotation.Resource;

import com.ruoyi.cwgl.domain.*;
import com.ruoyi.cwgl.domain.vo.ReceivableBillAgingAnalysisVo;
import com.ruoyi.cwgl.domain.vo.ReceivableBillAccountAnalysisVo;
import com.ruoyi.cwgl.mapper.*;
import com.ruoyi.cwgl.service.IAgingLogService;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.stereotype.Service;
import org.springframework.scheduling.annotation.Async;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import com.ruoyi.common.utils.PageUtils;
import com.ruoyi.common.constant.Constants;
import com.ruoyi.common.annotation.DataSource;
import com.ruoyi.common.enums.DataSourceType;
import com.ruoyi.common.core.service.BaseService;

import com.ruoyi.cwgl.service.IReceivableBillManagementService;
import com.ruoyi.common.core.text.Convert;
import com.ruoyi.common.exception.ServiceException;
import com.ruoyi.common.utils.SecurityUtils;

/**
 * 应收账单管理Service业务层处理
 *
 * @author ruoyi
 * @date 2025-12-17
 */
@Service
@Transactional(rollbackFor = Exception.class)
public class ReceivableBillManagementServiceImpl  extends BaseService<ReceivableBillManagementMapper, ReceivableBillManagement> implements IReceivableBillManagementService
{
    protected final Logger logger = LoggerFactory.getLogger(getClass());
    @Resource
    private ReceivableBillManagementMapper receivableBillManagementMapper;
    @Resource
    private ReceivableFeeManagementMapper receivableFeeManagementMapper;
    
    @Resource
    private ReceivableBillManagementLogMapper receivableBillManagementLogMapper;
    @Resource
    private AgingLogMapper agingLogMapper;
    @Resource
    private AccountLogMapper accountLogMapper;


    /**
     * 查询应收账单管理
     *
     * @param id 应收账单管理ID
     * @return 应收账单管理
     */
    @DataSource(DataSourceType.SLAVE)
    @Override
    public ReceivableBillManagement selectReceivableBillManagementById(Integer id)
    {
        return receivableBillManagementMapper.selectReceivableBillManagementById(id);
    }

    /**
     * 查询应收账单管理 记录数
     *
     * @param receivableBillManagement 应收账单管理
     * @return 应收账单管理集合
     */
    @DataSource(DataSourceType.SLAVE)
    @Override
    public int selectReceivableBillManagementCount(ReceivableBillManagement receivableBillManagement)
    {
        return receivableBillManagementMapper.selectReceivableBillManagementCount(receivableBillManagement);
    }

    /**
     * 查询应收账单管理列表
     *
     * @param receivableBillManagement 应收账单管理
     * @return 应收账单管理
     */
    @DataSource(DataSourceType.SLAVE)
    @Override
    public List<ReceivableBillManagement> selectReceivableBillManagementList(ReceivableBillManagement receivableBillManagement)
    {
        return receivableBillManagementMapper.selectReceivableBillManagementList(receivableBillManagement);
    }

    /**
     * 查询应收账单管理列表 异步 导出
     *
     * @param receivableBillManagement 应收账单管理
     * @param exportKey 导出功能的唯一标识
     * @return 应收账单管理集合
     */
    @DataSource(DataSourceType.SLAVE)
    @Async
    @Override
    public void export(ReceivableBillManagement receivableBillManagement,String exportKey) {

        super.export(ReceivableBillManagement.class,exportKey,"receivableBillManagementData",(pageNum)->{
            PageUtils.startPage(pageNum, Constants.EXPORT_PATE_SIZE);
            return selectReceivableBillManagementList(receivableBillManagement);
        });
    }   /**
     * 查询应收账单管理列表 异步 导出
     *
     * @param receivableBillManagement 应收账单管理
     * @param exportKey 导出功能的唯一标识
     * @return 应收账单管理集合
     */
    @DataSource(DataSourceType.SLAVE)
    @Async
    @Override
    public void customerSummaryExport(ReceivableBillManagement receivableBillManagement,String exportKey) {

        super.export2(ReceivableBillCustomerSummary.class,exportKey,"应收账款分析管理",(pageNum)->{
            PageUtils.startPage(pageNum, Constants.EXPORT_PATE_SIZE);
            return selectReceivableBillCustomerSummaryList(receivableBillManagement);
        });
    }  @DataSource(DataSourceType.SLAVE)
    @Async
    @Override
    public void agingAnalysisExport(ReceivableBillManagement receivableBillManagement,String exportKey) {

        super.export2(ReceivableBillAgingAnalysisVo.class,exportKey,"应收账款分析管理",(pageNum)->{
            PageUtils.startPage(pageNum, Constants.EXPORT_PATE_SIZE);
            return selectReceivableBillAgingAnalysisList(receivableBillManagement);
        });
    }

    @Async
    @Override
    public void accountAnalysisExport(ReceivableBillManagement receivableBillManagement,String exportKey) {

        super.export2(ReceivableBillAccountAnalysisVo.class,exportKey,"应收账款分析管理",(pageNum)->{
            PageUtils.startPage(pageNum, Constants.EXPORT_PATE_SIZE);
            return selectReceivableBillAccountAnalysisList(receivableBillManagement);
        });
    }


    /**
     * 新增应收账单管理
     *
     * @param receivableBillManagement 应收账单管理
     * @return 结果
     */
    @Override
    public int insertReceivableBillManagement(ReceivableBillManagement receivableBillManagement)
    {
        receivableBillManagement.setCreateTime(DateUtils.getNowDate());
        return receivableBillManagementMapper.insertReceivableBillManagement(receivableBillManagement);
    }

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

    /**
     * 修改应收账单管理
     *
     * @param receivableBillManagement 应收账单管理
     * @return 结果
     */
    @Override
    public int updateReceivableBillManagement(ReceivableBillManagement receivableBillManagement)
    {
        receivableBillManagement.setUpdateTime(DateUtils.getNowDate());
        int result = receivableBillManagementMapper.updateReceivableBillManagement(receivableBillManagement);
        
        // 记录操作日志
        if (result > 0) {
            ReceivableBillManagementLog log = new ReceivableBillManagementLog();
            log.setBillId(receivableBillManagement.getId());
            log.setCreateBy(SecurityUtils.getUsername());
            log.setCreateTime(DateUtils.getNowDate());
            log.setOperation("修改应收账单，账单编号：" + receivableBillManagement.getSystemNo());
            receivableBillManagementLogMapper.insertReceivableBillManagementLog(log);
        }
        
        return result;
    } @Override
    public int aging(ReceivableBillManagement receivableBillManagement)
    {
        receivableBillManagement.setUpdateTime(DateUtils.getNowDate());
        int result = receivableBillManagementMapper.updateReceivableBillManagement(receivableBillManagement);

        // 记录操作日志
        if (result > 0) {
            AgingLog log = new AgingLog();
            log.setHeadId(receivableBillManagement.getId());
            log.setCreateBy(SecurityUtils.getUsername());
            log.setCreateTime(DateUtils.getNowDate());
            log.setOperation("编辑账龄分析信息");
            agingLogMapper.insertAgingLog(log);
        }

        return result;
    }
    @Override
    public int account(ReceivableBillManagement receivableBillManagement)
    {
        receivableBillManagement.setUpdateTime(DateUtils.getNowDate());
        int result = receivableBillManagementMapper.updateReceivableBillManagement(receivableBillManagement);

        // 记录操作日志
        if (result > 0) {
            AccountLog log = new AccountLog();
            log.setHeadId(receivableBillManagement.getId());
            log.setCreateBy(SecurityUtils.getUsername());
            log.setCreateTime(DateUtils.getNowDate());
            log.setOperation("编辑账款分析信息");
            accountLogMapper.insertAccountLog(log);
        }

        return result;
    }

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

    /**
     * 删除应收账单管理对象
     *
     * @param ids 需要删除的数据ID
     * @return 结果
     */
    @Override
    public int deleteReceivableBillManagementByIds(String ids)
    {
        return deleteReceivableBillManagementByIds(Convert.toIntArray(ids));
    }

    /**
     * 删除应收账单管理对象
     *
     *
     * @param ids 需要删除的数据ID
     * @return 结果
     */
    @Override
    public int deleteReceivableBillManagementByIds(Integer[] ids)
    {
        return receivableBillManagementMapper.deleteReceivableBillManagementByIds(ids);
    }

    /**
     * 删除应收账单管理信息
     *
     * @param id 应收账单管理ID
     * @return 结果
     */
    @Override
    public int deleteReceivableBillManagementById(Integer id)
    {
        return receivableBillManagementMapper.deleteReceivableBillManagementById(id);
    }
    
    /**
     * 作废应收账单管理记录
     *
     * @param id 应收账单管理ID
     * @return 结果
     */
    @Override
    public int voidReceivableBillManagement(Integer id) {
        // 1. 查询应收账单记录
        ReceivableBillManagement billManagement = receivableBillManagementMapper.selectReceivableBillManagementById(id);
        if (billManagement == null) {
            throw new ServiceException("应收账单记录不存在");
        }
        
        // 2. 判断状态是否为0（未结算），只有状态为0才能作废
        if (!"0".equals(billManagement.getStatus())) {
            throw new ServiceException("只有状态为未结算的账单才能作废");
        }
        
        // 3. 设置状态为作废
        billManagement.setStatus("2");
        billManagement.setUpdateTime(DateUtils.getNowDate());
        
        // 4. 更新应收账单记录
        int result = receivableBillManagementMapper.updateReceivableBillManagement(billManagement);
        
        // 5. 如果更新成功，清除关联应收费用的账单编号并更新状态
        if (result > 0) {
            // 获取账单系统编号
            String billSystemNo = billManagement.getSystemNo();
            if (billSystemNo != null && !billSystemNo.trim().isEmpty()) {
                // 查询关联该账单的应收费用记录
//                ReceivableFeeManagement queryFee = new ReceivableFeeManagement();
//                queryFee.setRelatedBillNo(billSystemNo);
//                List<ReceivableFeeManagement> feeList = receivableFeeManagementMapper.selectReceivableFeeManagementList(queryFee);
                
                // 清除关联账单编号并将状态改为0（待生成账单）
                receivableFeeManagementMapper.updateReceivableFeeManagementByRelatedBillNo(billSystemNo);
            }
            
            // 记录作废操作日志
            ReceivableBillManagementLog log = new ReceivableBillManagementLog();
            log.setBillId(id);
            try {
                log.setCreateBy(SecurityUtils.getUsername());
            } catch (Exception e) {
                // 远程调用时没有登录信息，使用api作为创建人
                log.setCreateBy("api");
            }
            log.setCreateTime(DateUtils.getNowDate());
            log.setOperation("作废应收账单，账单编号：" + billManagement.getSystemNo());
            receivableBillManagementLogMapper.insertReceivableBillManagementLog(log);
        }
        
        return result;
    }
    
    /**
     * 根据系统编号查询应收账单管理
     * 
     * @param systemNo 系统编号
     * @return 应收账单管理
     */
    @DataSource(DataSourceType.SLAVE)
    @Override
    public ReceivableBillManagement selectReceivableBillManagementBySystemNo(String systemNo)
    {
        return receivableBillManagementMapper.selectReceivableBillManagementBySystemNo(systemNo);
    }
    
    /**
     * 查询应收账单客户汇总列表
     *
     * @param receivableBillManagement 查询条件
     * @return 应收账单客户汇总列表
     */
    @DataSource(DataSourceType.SLAVE)
    @Override
    public List<ReceivableBillCustomerSummary> selectReceivableBillCustomerSummaryList(ReceivableBillManagement receivableBillManagement)
    {
        return receivableBillManagementMapper.selectReceivableBillCustomerSummaryList(receivableBillManagement);
    }

    /**
     * 查询应收账单账龄分析列表
     *
     * @param receivableBillManagement 查询条件
     * @return 应收账单账龄分析列表
     */
    @DataSource(DataSourceType.SLAVE)
    @Override
    public List<ReceivableBillAgingAnalysisVo> selectReceivableBillAgingAnalysisList(ReceivableBillManagement receivableBillManagement)
    {
        // 直接查询数据库中的预计算账龄数据
        List<ReceivableBillAgingAnalysisVo> result = receivableBillManagementMapper.selectReceivableBillAgingAnalysisList(receivableBillManagement);
        
        return result;
    }

    /**
     * 批量更新应收账单账龄分析数据
     * 直接在数据库层面计算账龄分段，避免查询大量数据到应用层
     *
     * @return 更新的记录数
     */
    @Override
    public int batchUpdateAgingAnalysisData()
    {
        return receivableBillManagementMapper.batchUpdateAgingAnalysisData();
    }

    /**
     * 查询应收账单账款分析列表
     *
     * @param receivableBillManagement 查询条件
     * @return 应收账单账款分析列表
     */
    @DataSource(DataSourceType.SLAVE)
    @Override
    public List<ReceivableBillAccountAnalysisVo> selectReceivableBillAccountAnalysisList(ReceivableBillManagement receivableBillManagement)
    {
        // 直接查询数据库中的账款分析数据
        List<ReceivableBillAccountAnalysisVo> result = receivableBillManagementMapper.selectReceivableBillAccountAnalysisList(receivableBillManagement);
        
        return result;
    }
}