using JiepeiWMS.Common.Enums;
using JiepeiWMS.Common.Helper;
using JiepeiWMS.Extends;
using JiepeiWMS.IServices;
using JiepeiWMS.Model;
using JiepeiWMS.Model.Models;
using Microsoft.AspNetCore.Authorization;
using Microsoft.AspNetCore.Mvc;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Linq.Expressions;
using System.Threading.Tasks;

namespace JiepeiWMS.Api.Controllers
{
    [Route("api/[controller]/[action]")]
    [ApiController]
    [Authorize(Permissions.Name)]
    public class WMStockLogController : ControllerBase
    {
        /// <summary>
        /// 库存流水日志
        /// </summary>
        private readonly IWMStockLogServices _wMStockLogServices;
        private readonly IWMProductListServices _wMProductListServices;
        private readonly IWMProductClassServices _wMProductClassServices;
        private readonly IWMMaterialCostServices _wMMaterialCostServices;

        public WMStockLogController(IWMStockLogServices WMStockLogServices,
            IWMProductListServices WMProductListServices,
            IWMProductClassServices WMProductClassServices,
            IWMMaterialCostServices WMMaterialCostServices)
        {
            _wMStockLogServices = WMStockLogServices;
            _wMProductListServices = WMProductListServices;
            _wMProductClassServices = WMProductClassServices;
            _wMMaterialCostServices = WMMaterialCostServices;
        }

        /// <summary>
        /// 查询列表
        /// </summary>
        /// <param name="page">页数</param>
        /// <param name="typeoptions">台账类型</param>
        /// <param name="warehouseoptions">所属仓库</param>
        /// <param name="startdate">开始时间</param>
        /// <param name="enddate">结束时间</param>
        /// <param name="key">关键字</param>
        /// <param name="intPageSize">条数</param>
        /// <returns></returns>
        [HttpGet]
        public async Task<MessageModel<PageModel<WMStockLog>>> Index(string key = "", string typeoptions = "", string warehouseoptions = "", DateTime? startdate = null, DateTime? enddate = null, int page = 1, int intPageSize = 20)
        {
            if (string.IsNullOrWhiteSpace(key))
                key = "";
            if (string.IsNullOrWhiteSpace(typeoptions))
                typeoptions = "";
            if (string.IsNullOrWhiteSpace(warehouseoptions))
                warehouseoptions = "";

            var PageList = await _wMStockLogServices.GetWMStockLogPage(page, intPageSize, key, typeoptions, warehouseoptions, startdate, enddate);

            return new MessageModel<PageModel<WMStockLog>>()
            {
                msg = "获取成功",
                success = PageList.dataCount >= 0,
                response = PageList
            };
        }

        /// <summary>
        /// 导出物料初期、初末实况表格
        /// </summary>
        [HttpGet]
        public async Task<IActionResult> ExportStockLog(int type)
        {
            var stockLogList = await _wMStockLogServices.QuerySql("select sl.Id,case when sl.Type=1 then (select PurchaseCode from WMPurchaseInfo where Id=OrderId) when sl.Type=2 then (select SaleCode from WMSaleInfo where Id=OrderId) when sl.Type=4 then (select QuoteCode from WMQuoteInfo where Id=OrderId) end CodeNo,Code,pl.Name ProductName,ps.Name ProductSpec,wh.Name WareHouseName,case when sl.Type=0 then '初始化库存' when sl.Type=1 then '采购入库' when sl.Type=2 then '销售出库' when sl.Type=3 then '库存盘点' when sl.Type=4 then '报价入库' end TypeName,case when sl.Quantity > 0 then case when sl.Operation=1 then '+' else '-' end + CAST(sl.Quantity AS varchar) else '' end QuantitySign,pl.Price,TotalPrice,RemainQuantity,RemainPrice,TotalRemainPrice,sl.CreateTime,ui.uRealName AdminName from WMStockLog sl left join WMProductList pl on sl.ProductListId = pl.id left join WMProductSpec ps on sl.ProductSpecId = ps.id left join WMWareHouse wh on sl.WareHouseId = wh.id left join sysUserInfo ui on sl.AdminId = ui.uID");

            if (stockLogList != null && stockLogList.Any())
            {
                var classId = 0;
                var date = DateTime.Now;
                var StartCreateTime = date.ToString("yyyy-MM-01").ObjToDate();//当前月份得第一天
                var EndCreateTime = StartCreateTime.AddMonths(1).AddSeconds(-1);//当月月份得最后一天

                var LList = stockLogList.Where(x => x.CreateTime >= StartCreateTime && x.CreateTime < EndCreateTime).Select(c => new { c.Id, c.CodeNo, c.Code, c.ProductName, c.ProductSpec, c.WareHouseName, c.TypeName, c.QuantitySign, c.Price, c.TotalPrice, c.RemainQuantity, c.RemainPrice, c.TotalRemainPrice, c.CreateTime, c.AdminName }).ToList();

                var heads = new List<string>() { "编号", "订单编号", "商品编号", "商品名称", "商品规格", "仓库名称", "台账类型", "台账数量", "台账单价", "台账总价", "库存数量", "库存均价", "库存总价", "创建时间", "创建人" };
                var stream = ExcelHelper.CreateExcelStreamFromList(LList, heads);

                foreach (var item in await _wMStockLogServices.Query(x => x.CreateTime >= StartCreateTime && x.CreateTime < EndCreateTime))
                {
                    var DepId = item.DepId.Value;
                    var ProductListId = item.ProductListId;
                    var Year = item.CreateTime.Year;
                    var Month = item.CreateTime.Month;

                    var ProductListModel = await _wMProductListServices.QueryById(item.ProductListId);
                    if (ProductListModel != null)
                    {
                        var ProductClassModel = await _wMProductClassServices.QueryById(ProductListModel.ClassId);
                        if (ProductClassModel != null)
                            classId = ProductClassModel.Id;
                    }
                    var PeriodEndCost = item.RemainQuantity * item.RemainPrice;//库存数量 * 库存均价

                    Expression<Func<WMMaterialCost, bool>> whereExpression = x => x.Id > 0;
                    if (DepId > 0)
                        whereExpression = whereExpression.And(x => x.DepId == DepId);
                    if (classId > 0)
                        whereExpression = whereExpression.And(x => x.ClassId == classId);
                    if (ProductListId > 0)
                        whereExpression = whereExpression.And(x => x.ProductId == ProductListId);
                    if (Year > 0)
                        whereExpression = whereExpression.And(x => x.Years == Year);
                    if (Month > 0)
                        whereExpression = whereExpression.And(x => x.Months == Month);

                    var MaterialCostModel = await _wMMaterialCostServices.GetModel(whereExpression);
                    if (MaterialCostModel != null)
                    {
                        MaterialCostModel.UpdateTime = DateTime.Now;
                        MaterialCostModel.PeriodEndCost = PeriodEndCost;
                        var result = await _wMMaterialCostServices.Update(MaterialCostModel);
                    }
                    else
                    {
                        WMMaterialCost model = new WMMaterialCost()
                        {
                            DepId = DepId,
                            ClassId = classId,
                            ProductId = ProductListId,
                            Years = Year,
                            Months = Month,
                            CreateTime = DateTime.Now,
                            PeriodEndCost = PeriodEndCost
                        };
                        var result1 = await _wMMaterialCostServices.Add(model);
                    }
                }

                return File(stream, "application/octet-stream", type == 1 ? "物料初期实况" + StartCreateTime.ToString("yyyy-MM-dd") + "~" + EndCreateTime.ToString("yyyy-MM-dd") + ".xlsx" : type == 2 ? "物料初末实况.xlsx" : "");
            }
            return null;
        }
    }
}