using AnalyticsDAL.DTO.KPIEvaluation;
using GB5Shared.DTO.Framework.Login;

namespace AnalyticsDAL.CustomCode.KPIEvaluation
{
    // Thin read/write primitives only -- the actual BI-engine call (IAnalysisAggregationService)
    // and formula evaluation live in KPIEvaluationBLL, since DAL must never call up into BLL
    // (CLAUDE.md layering rule).
    public interface IKPIEvaluationDAL
    {
        Task<List<int>> GetAccessibleOuIds(int userId, LoginDTO login, CancellationToken ct);
        Task<(DateTime PeriodFromDate, DateTime PeriodToDate)?> GetPeriodRange(int periodDetailId, LoginDTO login, CancellationToken ct);
        Task<int> ResolveDateKey(DateTime date, LoginDTO login, CancellationToken ct);
        Task<int?> ResolveLatestFFinanceDateKeyOnOrBefore(int ouId, int toDateKey, LoginDTO login, CancellationToken ct);
        Task<List<KpiDefinitionDTO>> GetComputableKpis(List<int> kpiIds, LoginDTO login, CancellationToken ct);
        Task<List<int>> GetAllComputableKpiIds(LoginDTO login, CancellationToken ct);
        Task<Dictionary<string, byte>> GetMeasureAdditivity(LoginDTO login, CancellationToken ct);
        Task<List<KpiStatusBandDTO>> GetStatusBands(List<int> kpiIds, LoginDTO login, CancellationToken ct);
        Task<decimal?> GetPreviousActual(int kpiId, int periodDetailId, int ouId, LoginDTO login, CancellationToken ct);
        Task<int?> GetPreviousPeriodDetailId(int periodDetailId, LoginDTO login, CancellationToken ct);
        Task<int?> GetLatestPostedPeriodDetailId(int ouId, LoginDTO login, CancellationToken ct);
        Task DeleteExistingValues(int periodDetailId, int ouId, LoginDTO login, CancellationToken ct);
        Task InsertValue(int kpiId, int periodDetailId, int ouId, int dimOuId, decimal? actual, decimal? target, byte? trend, int? statusId, LoginDTO login, CancellationToken ct);
        Task<List<KpiValueResultDTO>> GetKpiValues(List<int> kpiIds, int periodDetailId, int ouId, LoginDTO login, CancellationToken ct);
    }
}