using GB5Shared.DTO.Framework.Login;
using System.Data.Common;

namespace MMDAL.CustomCode.StockLedgerCost;

public interface IStockLedgerCostDAL
{
    /// <summary>
    /// Sets PostedCost/PostedValue on TSTOCKLEDGER rows from current TSTOCKPOSITION.AverageCost.
    /// For non-transfer transactions.
    /// </summary>
    Task ApplyAverageCostNonTransferAsync(
        int objectTypeId, int objectId, int ouid,
        LoginDTO login, DbTransaction tx, CancellationToken ct);

    /// <summary>
    /// Sets PostedCost/PostedValue on TSTOCKLEDGER rows using the FROM-store's AverageCost.
    /// For stock transfer transactions.
    /// </summary>
    Task ApplyAverageCostTransferAsync(
        int objectTypeId, int objectId, int ouid, int fromStoreId,
        LoginDTO login, DbTransaction tx, CancellationToken ct);

    /// <summary>
    /// Updates TSTOCKPOSITION.AverageValue from the document's posted movement values.
    /// For non-transfer transactions.
    /// </summary>
    Task UpdateAverageValueNonTransferAsync(
        int objectTypeId, int objectId,
        LoginDTO login, DbTransaction tx, CancellationToken ct);

    /// <summary>
    /// Updates TSTOCKPOSITION.AverageValue for the FROM-store only.
    /// For stock transfer transactions.
    /// </summary>
    Task UpdateAverageValueTransferFromStoreAsync(
        int objectTypeId, int objectId, int fromStoreId,
        LoginDTO login, DbTransaction tx, CancellationToken ct);

    /// <summary>
    /// Recomputes AverageCost from AverageValue/Quantity (store-wise valuation path).
    /// </summary>
    Task ApplyCostAffectingStorewiseAsync(
        int objectTypeId, int objectId, bool isStockTransfer, int toStoreId,
        LoginDTO login, DbTransaction tx, CancellationToken ct);

    /// <summary>
    /// Recomputes AverageCost consolidated across all stores for the item.
    /// </summary>
    Task ApplyCostAffectingConsolidatedAsync(
        int objectTypeId, int objectId,
        LoginDTO login, DbTransaction tx, CancellationToken ct);

    /// <summary>
    /// Returns the OU-level storewise valuation flag from MOULEVELSETTING.
    /// 0 = storewise (per-store), 1 = consolidated. Returns 1 (consolidated) if not configured.
    /// </summary>
    Task<byte> GetIsStorewiseAsync(int ouid, LoginDTO login, CancellationToken ct);

    /// <summary>
    /// Runs the 3-step perpetual rerun batch (computes running avg → joins ledger rows →
    /// updates PostedCost/PostedValue). All three steps share the same connection so temp
    /// tables remain in scope. Cleanup DROP statements always execute.
    /// </summary>
    Task RunPerpetualRerunBatchAsync(
        int ouid, DateOnly fromDate, DateOnly toDate, int documentId,
        bool isStorewise,
        LoginDTO login, CancellationToken ct);
}