using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using WIDESEA_Core;
using WIDESEA_Core.BaseRepository;
using WIDESEA_Core.BaseServices;
using WIDESEA_Core.Enums;
using WIDESEA_Core.Helper;
using WIDESEA_Core.Utilities;
using WIDESEA_DTO.Stock;
using WIDESEA_IStockService;
using WIDESEA_Model.Models;

namespace WIDESEA_StockService
{
    public class PlasticContainerLedgerService : ServiceBase<Dt_PlasticContainerLedger, IRepository<Dt_PlasticContainerLedger>>, IPlasticContainerLedgerService
    {
        private readonly IRepository<Dt_StockInfo> _stockRepository;
        public PlasticContainerLedgerService(IRepository<Dt_PlasticContainerLedger> BaseDal, IRepository<Dt_StockInfo> stockRepository) : base(BaseDal)
        {
            _stockRepository = stockRepository;
        }

        public IRepository<Dt_PlasticContainerLedger> Repository => BaseDal;

        public WebResponseContent GlueLineLedgerSummary(string supplyCode)
        {
           
            supplyCode = supplyCode?.Trim() ?? "";
            
            var now = DateTime.Now;

            
            var borrowGroup = BaseDal.Db.Queryable<Dt_PlasticContainerLedger>()
                .Where(x => x.SupplyCode == supplyCode)
                .GroupBy(x => new { x.SupplyCode, x.CreateDate.Date })
                .Select(x => new
                {
                    x.SupplyCode,
                    CreateDate = x.CreateDate.Date,
                    BorrowQty = SqlFunc.AggregateCount(x.Id)
                })
                .ToList();

            
            var returnedGroup = _stockRepository.Db.Queryable<Dt_StockInfo>()
                .Where(x => x.SupplyCode == supplyCode && !string.IsNullOrEmpty(x.Remark))
                .GroupBy(x => new { x.SupplyCode, x.BorrowTime.Date })
                .Select(x => new
                {
                    x.SupplyCode,
                    CreateDate = x.BorrowTime.Date,
                    ReturnedQty = SqlFunc.AggregateCount(x.Id)
                })
                .ToList();

            var result = new List<GlueLineLedgerSummaryDTO>();

            
            foreach (var item in borrowGroup)
            {
                result.Add(new GlueLineLedgerSummaryDTO
                {
                    SupplyCode = item.SupplyCode,
                    BorrowTime = item.CreateDate.ToString("yyyy-MM-dd"),
                    UnreturnedQuantity = item.BorrowQty,
                    ReturnedQty = 0,
                    PendingReturnQty = item.BorrowQty
                });
            }

            
            foreach (var item in returnedGroup)
            {
                result.Add(new GlueLineLedgerSummaryDTO
                {
                    SupplyCode = item.SupplyCode,
                    BorrowTime = item.CreateDate.ToString("yyyy-MM-dd"),
                    UnreturnedQuantity = item.ReturnedQty,
                    ReturnedQty = item.ReturnedQty,
                    PendingReturnQty = 0
                });
            }

            var filterResult = result
                .Where(x =>
                {
                    DateTime borrowTime = DateTime.Parse(x.BorrowTime);

                    if (x.PendingReturnQty > 0)
                        return true;

                    if (borrowTime >= now.AddMonths(-1))
                        return true;

                    return false;
                })
                .ToList();

            return WebResponseContent.Instance.OK(data: filterResult);
        }


        public class GlueLineLedgerSummaryDTO{
           public string SupplyCode { get; set; }
           
           public int UnreturnedQuantity { get; set; }

           public int ReturnedQty { get; set; }
           public int PendingReturnQty { get; set; }
           public string BorrowTime { get; set; }
           
         
        }
    }
}