using GB5Shared.DTO.Framework.Criteria;
using GB5Shared.DTO.Framework.Login;
using MMDAL.DTO.AccountBooksDetail;
using MMDAL.DTO.MMHead;
using MMDAL.DTO.MMReports;

namespace MMDAL.CustomCode.MMReports
{
    public interface IMMReportsDAL
    {
        IAsyncEnumerable<HeadWithDetailRegisterDTO> MMHeadRegister(
        int OrderbyType,
        int FirstNumber,
        int MaxResult,
        CriteriaDTO CriteriaDTO,
        LoginDTO LoginDTO,
        bool IsDocument = false,
        bool Count = false,
        CancellationToken cancellationToken = default);

        /// <summary>
        /// Active/UnApproved/Cancelled counts+totals per BizTransactionClass (UNION ALL'd with a
        /// pending-allocation-based row, see EmployeeQB-style shared-DTO-both-halves-populated pattern).
        /// </summary>
        Task<(List<MMPendingStatusReportDTO> Items, int Total)> GetMMPendingStatusReport(
            int firstNumber, int maxResult, string bizTransactionClassIds, int? ouId, DateTime periodFromDate, DateTime periodToDate, LoginDTO loginDTO, CancellationToken ct = default);

        Task<(List<MMRegisterPartyWiseSummaryReportDTO> Items, int Total)> GetMMRegisterPartyWiseSummaryReport(
            int firstNumber, int maxResult, string bizTransactionClassIds, int type, int? ouId, LoginDTO loginDTO, CancellationToken ct = default);

        Task<(List<MMRegisterItemWiseReportDTO> Items, int Total)> GetMMRegisterItemWiseReport(
            int firstNumber, int maxResult, string bizTransactionClassIds, int? ouId, LoginDTO loginDTO, CancellationToken ct = default);

        Task<(List<MMPendingRegisterListReportDTO> Items, int Total)> GetMMPendingRegisterListReport(
            int firstNumber, int maxResult, string bizTransactionClassIds, int? ouId, LoginDTO loginDTO, CancellationToken ct = default);

        /// <summary>BizProcess Phase 8 -- open-document count per BizTransactionTypeId, no paging (dashboard overlay, small result set).</summary>
        Task<IEnumerable<PendingCountByTransactionTypeDTO>> GetPendingCountsByTransactionType(
            IEnumerable<int> bizTransactionTypeIds, LoginDTO loginDTO, CancellationToken ct = default);

        // Procurement Overview Dashboard (Phase 1) -- one composite method per tile, each
        // aggregating several of the primitives above plus the new MV_MMRegister-based queries
        // in MMReportsQB.cs. See the Procurement dashboard plan for the tile-by-tile scope.

        Task<MMDAL.DTO.MMReports.ProcurementSpendOverviewDTO> GetProcurementSpendOverview(
            string bizTransactionClassIdsCsv, IEnumerable<int> bizTransactionClassIds,
            int? ouId, DateTime periodFromDate, DateTime periodToDate, LoginDTO loginDTO, CancellationToken ct = default);

        Task<MMDAL.DTO.MMReports.PRToPOTrackerDashboardDTO> GetPRToPOTrackerDashboard(
            int firstNumber, int maxResult,
            int prBizTransactionClassId, int inquiryBizTransactionClassId,
            int quotationBizTransactionClassId, int poBizTransactionClassId,
            int? ouId, DateTime periodFromDate, DateTime periodToDate, LoginDTO loginDTO, CancellationToken ct = default);

        Task<MMDAL.DTO.MMReports.POMonitoringDashboardDTO> GetPOMonitoringDashboard(
            string poBizTransactionClassIdsCsv, int poBizTransactionClassId, int grnBizTransactionClassId,
            int? ouId, DateTime periodFromDate, DateTime periodToDate, LoginDTO loginDTO, CancellationToken ct = default);

        Task<MMDAL.DTO.MMReports.SpendAnalysisDashboardDTO> GetSpendAnalysisDashboard(
            string bizTransactionClassIdsCsv, IEnumerable<int> bizTransactionClassIds,
            int? ouId, DateTime periodFromDate, DateTime periodToDate, LoginDTO loginDTO, CancellationToken ct = default);

        // Sales Overview Dashboard (Phase 1) -- Enquiry->Quotation->Order funnel tile. Reuses the
        // same generic GetFunnelStage/aging/open-list primitives GetPRToPOTrackerDashboard uses.
        Task<MMDAL.DTO.MMReports.SalesFunnelDashboardDTO> GetSalesFunnelDashboard(
            int firstNumber, int maxResult,
            int enquiryBizTransactionClassId, int quotationBizTransactionClassId, int orderBizTransactionClassId,
            int? ouId, LoginDTO loginDTO, CancellationToken ct = default);
    }

}