package com.ruoyi.account.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ruoyi.account.pojo.FinanceAccount;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.math.BigDecimal;
import java.util.List;
import java.util.Map;

@Mapper
public interface FinanceAccountMapper extends BaseMapper<FinanceAccount> {

    /** 分页查询(带当前余额) */
    IPage<FinanceAccount> selectAccountPageWithBalance(Page page, @Param("c") FinanceAccount account);

    /** 计算某账户当前余额:期初 + Σ(方向×金额) */
    BigDecimal selectBalance(@Param("accountId") Long accountId);

    /** 所有启用账户当前余额合计 */
    BigDecimal selectTotalBalance();

    BigDecimal selectTotalSafetyLine();

    /** 资金流趋势:按日聚合(收入/支出/净额) */
    List<Map<String, Object>> trend(@Param("accountId") Long accountId,
                                    @Param("start") String start,
                                    @Param("end") String end);
}