using Model.ModelDto.SysDto;
using Model.ModelVm.DailyInventory;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Runtime.CompilerServices;
using System.Text;
using WMS.DAL;
using WMS.Entity.BllCheckEntity;
using WMS.Entity.Context;
using WMS.IBLL.IIndexEcharServer;

namespace WMS.BLL.IndexEcharServer
{
    public class DailyInventoryServer : DbHelper<DailyInventoryVM>, IDailyInventoryServer
    {
        private static readonly SqlSugarScope Db = DataContext.Db;
        public DailyInventoryServer() : base(Db)
        {
        }

        /// <summary>
        /// 当天任务量
        /// </summary>
        /// <returns></returns>
        public List<DailyInventoryVM> DailyInventory()
        {
            //捕获异常
            try
            {
                string onedate = DateTime.Now.AddDays(-6).ToString("yyyy-MM-dd");//第一天
                string twodate = DateTime.Now.AddDays(-5).ToString("yyyy-MM-dd");//第二天
                string threedate = DateTime.Now.AddDays(-4).ToString("yyyy-MM-dd");//第三天
                string fourdate = DateTime.Now.AddDays(-3).ToString("yyyy-MM-dd");//第四天
                string fivedate = DateTime.Now.AddDays(-2).ToString("yyyy-MM-dd");//第五天
                string sixdate = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");//第六天
                string sevendate = DateTime.Now.ToString("yyyy-MM-dd");//第七天

                string str = "select convert(varchar(10),CreateTime,120) TaskDay,OrderType TaskType,COUNT(*) TaskNum from logtask where CreateTime >= CONVERT(datetime,CONVERT(varchar(10),GETDATE(),120)) - 6 group by convert(varchar(10),CreateTime,120),OrderType Order by convert(varchar(10),CreateTime,120) desc";
                var list = Db.Ado.SqlQuery<DailyInventoryVM>(str);

                List<DailyInventoryVM> list2 = new List<DailyInventoryVM>();
                DailyInventoryVM daily = new DailyInventoryVM();
                foreach (var item in list)
                {
                    if (list2.Count == 0)
                    {
                        daily.TaskDay = item.TaskDay; //时间
                        daily.TaskType = item.TaskType; //类型
                        //入库
                        if (item.TaskType == "0")
                        {
                            daily.ASoTaskNum = item.TaskNum;
                            daily.SoTaskNum = "0";
                            daily.CheckTaskNum = "0";
                        }
                        //出库
                        else if (item.TaskType == "1")
                        {
                            daily.ASoTaskNum = "0";
                            daily.SoTaskNum= item.TaskNum;
                            daily.CheckTaskNum = "0";
                        }
                        //盘点
                        else if (item.TaskType == "2")
                        {
                            daily.ASoTaskNum = "0";
                            daily.SoTaskNum= "0";
                            daily.CheckTaskNum = item.TaskNum;
                        }
                        list2.Add(daily);
                        continue;
                    }
                    else
                    {
                        int aa = 0;
                        foreach (var item2 in list2)
                        {
                            aa += 1;
                            if (item.TaskDay == item2.TaskDay)
                            {
                                //daily.TaskDay = item.TaskDay; //时间
                                //daily.TaskType = item.TaskType; //类型
                                //入库
                                if (item.TaskType == "0")
                                {
                                    item2.ASoTaskNum = item.TaskNum;
                                }
                                //出库
                                else if (item.TaskType == "1")
                                {
                                    item2.SoTaskNum= item.TaskNum;
                                }
                                //盘点
                                else if (item.TaskType == "2")
                                {
                                    item2.CheckTaskNum = item.TaskNum;
                                }
                                //list2.Add(daily);
                                break;
                            }
                            else if (aa == list2.Count)
                            {
                                daily = new DailyInventoryVM();
                                daily.TaskDay = item.TaskDay; //时间
                                //daily.TaskType = item.TaskType; //类型
                                //入库
                                if (item.TaskType == "0")
                                {
                                    daily.ASoTaskNum = item.TaskNum;
                                    daily.SoTaskNum = "0";
                                    daily.CheckTaskNum = "0";
                                }
                                //出库
                                else if (item.TaskType == "1")
                                {
                                    daily.ASoTaskNum = "0";
                                    daily.SoTaskNum = item.TaskNum;
                                    daily.CheckTaskNum = "0";
                                }
                                //盘点
                                else if (item.TaskType == "2")
                                {
                                    daily.ASoTaskNum = "0";
                                    daily.SoTaskNum = "0";
                                    daily.CheckTaskNum = item.TaskNum;
                                }
                                list2.Add(daily);
                                break;
                            }
                        }
                    }
                }
                int a = 0;
                int b = 0;
                int c = 0;
                int d = 0;
                int e = 0;
                int f = 0;
                int g = 0;
                foreach (var item2 in list2)
                {
                    if (item2.TaskDay == onedate)
                    {
                        a = 1;
                    }
                    else if (item2.TaskDay == twodate)
                    {
                        b = 1;
                    }
                    else if (item2.TaskDay == threedate)
                    {
                        c = 1;
                    }
                    else if (item2.TaskDay == fourdate)
                    {
                        d = 1;
                    }
                    else if (item2.TaskDay == fivedate)
                    {
                        e = 1;
                    }
                    else if (item2.TaskDay == sixdate)
                    {
                        f = 1;
                    }
                    else if (item2.TaskDay == sevendate)
                    {
                        g = 1;
                    }
                }

                if (a == 0)
                {
                    daily = new DailyInventoryVM();
                    daily.TaskDay = onedate;
                    daily.ASoTaskNum = "0";
                    daily.SoTaskNum = "0";
                    daily.CheckTaskNum = "0";
                    list2.Add(daily);
                }
                if (b == 0)
                {
                    daily = new DailyInventoryVM();
                    daily.TaskDay = twodate;
                    daily.ASoTaskNum = "0";
                    daily.SoTaskNum = "0";
                    daily.CheckTaskNum = "0";
                    list2.Add(daily);
                }
                if (c == 0)
                {
                    daily = new DailyInventoryVM();
                    daily.TaskDay = threedate;
                    daily.ASoTaskNum = "0";
                    daily.SoTaskNum = "0";
                    daily.CheckTaskNum = "0";
                    list2.Add(daily);
                }
                if (d == 0)
                {
                    daily = new DailyInventoryVM();
                    daily.TaskDay = fourdate;
                    daily.ASoTaskNum = "0";
                    daily.SoTaskNum = "0";
                    daily.CheckTaskNum = "0";
                    list2.Add(daily);
                }
                if (e == 0)
                {
                    daily = new DailyInventoryVM();
                    daily.TaskDay = fivedate;
                    daily.ASoTaskNum = "0";
                    daily.SoTaskNum = "0";
                    daily.CheckTaskNum = "0";
                    list2.Add(daily);
                }
                if (f == 0)
                {
                    daily = new DailyInventoryVM();
                    daily.TaskDay = sixdate;
                    daily.ASoTaskNum = "0";
                    daily.SoTaskNum = "0";
                    daily.CheckTaskNum = "0";
                    list2.Add(daily);
                }
                if (g == 0)
                {
                    daily = new DailyInventoryVM();
                    daily.TaskDay = sevendate;
                    daily.ASoTaskNum = "0";
                    daily.SoTaskNum = "0";
                    daily.CheckTaskNum = "0";
                    list2.Add(daily);
                }

                return list2.OrderBy(a => a.TaskDay).ToList();

            }
            //抛出异常
            catch (Exception ex)
            {

                throw new Exception("获取当天入库任务量异常", ex);
            }
        }

        /// <summary>
        /// 当天单据量
        /// </summary>
        /// <returns></returns>
        public List<DailyReceiptsVm> DailyReceipts()
        {
            //捕获异常
            try
            {
                string onedate = DateTime.Now.AddDays(-6).ToString("yyyy-MM-dd");//第一天
                string twodate = DateTime.Now.AddDays(-5).ToString("yyyy-MM-dd");//第二天
                string threedate = DateTime.Now.AddDays(-4).ToString("yyyy-MM-dd");//第三天
                string fourdate = DateTime.Now.AddDays(-3).ToString("yyyy-MM-dd");//第四天
                string fivedate = DateTime.Now.AddDays(-2).ToString("yyyy-MM-dd");//第五天
                string sixdate = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");//第六天
                string sevendate = DateTime.Now.ToString("yyyy-MM-dd");//第七天

                string str = @"select * from (
                                select 
                                convert(varchar(10),CreateTime,120) TaskDay,
                                0 TaskType,
                                COUNT(*) TaskNum 
                                from BllArrivalNotice 
                                where CreateTime >= CONVERT(datetime,CONVERT(varchar(10),GETDATE(),120)) - 6 
                                group by convert(varchar(10),CreateTime,120) 

                                UNION ALL

                                select 
                                convert(varchar(10),CreateTime,120) TaskDay,
                                1 TaskType,
                                COUNT(*) TaskNum 
                                from BllExportNotice 
                                where CreateTime >= CONVERT(datetime,CONVERT(varchar(10),GETDATE(),120)) - 6 
                                group by convert(varchar(10),CreateTime,120) 
                                )  t
                              Order by t.TaskDay desc";
                var list = Db.Ado.SqlQuery<DailyReceiptsVm>(str);

                List<DailyReceiptsVm> list2 = new List<DailyReceiptsVm>();
                DailyReceiptsVm daily = new DailyReceiptsVm();
                foreach (var item in list)
                {
                    if (list2.Count == 0)
                    {
                        daily.TaskDay = item.TaskDay; //时间
                        daily.TaskType = item.TaskType; //类型
                        //入库
                        if (item.TaskType == "0")
                        {
                            daily.ASoTaskNum = item.TaskNum;
                            daily.SoTaskNum = "0";
                        }
                        //出库
                        else if (item.TaskType == "1")
                        {
                            daily.ASoTaskNum = "0";
                            daily.SoTaskNum = item.TaskNum;
                        }
                        list2.Add(daily);
                        continue;
                    }
                    else
                    {
                        int aa = 0;
                        foreach (var item2 in list2)
                        {
                            aa += 1;
                            if (item.TaskDay == item2.TaskDay)
                            {
                                //daily.TaskDay = item.TaskDay; //时间
                                //daily.TaskType = item.TaskType; //类型
                                //入库
                                if (item.TaskType == "0")
                                {
                                    item2.ASoTaskNum = item.TaskNum;
                                }
                                //出库
                                else if (item.TaskType == "1")
                                {
                                    item2.SoTaskNum = item.TaskNum;
                                }
                                //list2.Add(daily);
                                break;
                            }
                            else if (aa == list2.Count)
                            {
                                daily = new DailyReceiptsVm();
                                daily.TaskDay = item.TaskDay; //时间
                                //daily.TaskType = item.TaskType; //类型
                                //入库
                                if (item.TaskType == "0")
                                {
                                    daily.ASoTaskNum = item.TaskNum;
                                    daily.SoTaskNum = "0";
                                }
                                //出库
                                else if (item.TaskType == "1")
                                {
                                    daily.ASoTaskNum = "0";
                                    daily.SoTaskNum = item.TaskNum;
                                }
                                list2.Add(daily);
                                break;
                            }
                        }
                    }
                }
                int a = 0;
                int b = 0;
                int c = 0;
                int d = 0;
                int e = 0;
                int f = 0;
                int g = 0;
                foreach (var item2 in list2)
                {
                    if (item2.TaskDay == onedate)
                    {
                        a = 1;
                    }
                    else if (item2.TaskDay == twodate)
                    {
                        b = 1;
                    }
                    else if (item2.TaskDay == threedate)
                    {
                        c = 1;
                    }
                    else if (item2.TaskDay == fourdate)
                    {
                        d = 1;
                    }
                    else if (item2.TaskDay == fivedate)
                    {
                        e = 1;
                    }
                    else if (item2.TaskDay == sixdate)
                    {
                        f = 1;
                    }
                    else if (item2.TaskDay == sevendate)
                    {
                        g = 1;
                    }
                }

                if (a == 0)
                {
                    daily = new DailyReceiptsVm();
                    daily.TaskDay = onedate;
                    daily.ASoTaskNum = "0";
                    daily.SoTaskNum = "0";
                    list2.Add(daily);
                }
                if (b == 0)
                {
                    daily = new DailyReceiptsVm();
                    daily.TaskDay = twodate;
                    daily.ASoTaskNum = "0";
                    daily.SoTaskNum = "0";
                    list2.Add(daily);
                }
                if (c == 0)
                {
                    daily = new DailyReceiptsVm();
                    daily.TaskDay = threedate;
                    daily.ASoTaskNum = "0";
                    daily.SoTaskNum = "0";
                    list2.Add(daily);
                }
                if (d == 0)
                {
                    daily = new DailyReceiptsVm();
                    daily.TaskDay = fourdate;
                    daily.ASoTaskNum = "0";
                    daily.SoTaskNum = "0";
                    list2.Add(daily);
                }
                if (e == 0)
                {
                    daily = new DailyReceiptsVm();
                    daily.TaskDay = fivedate;
                    daily.ASoTaskNum = "0";
                    daily.SoTaskNum = "0";
                    list2.Add(daily);
                }
                if (f == 0)
                {
                    daily = new DailyReceiptsVm();
                    daily.TaskDay = sixdate;
                    daily.ASoTaskNum = "0";
                    daily.SoTaskNum = "0";
                    list2.Add(daily);
                }
                if (g == 0)
                {
                    daily = new DailyReceiptsVm();
                    daily.TaskDay = sevendate;
                    daily.ASoTaskNum = "0";
                    daily.SoTaskNum = "0";
                    list2.Add(daily);
                }

                return list2.OrderBy(a => a.TaskDay).ToList();

            }
            //抛出异常
            catch (Exception ex)
            {
                throw new Exception("获取当天入库单据量异常", ex);
            }
        }
        /// <summary>
        /// 获取储位占用量
        /// </summary>
        /// <returns></returns>
        public List<LocatInventoryVm> LocatInventory()
        {
            //捕获异常
            try
            {
                string str = "select Status LocatStatus,Count(*) LocatNum from SysStorageLocat where IsDel = '0' and WareHouseNo = 'W01' group by Status";
                var list = Db.Ado.SqlQuery<LocatInventoryVm>(str);

                int a = 0;

                foreach (var item in list)
                {
                    if (item.LocatStatus == "0" || item.LocatStatus == "1" || item.LocatStatus == "2" || item.LocatStatus == "3")
                    {
                        a += 1;
                    }
                    //else if (item.LocatStatus == "1")
                    //{
                    //    a += 1;
                    //}
                    //else if (item.LocatStatus == "2")
                    //{
                    //    a += 1;
                    //}
                    //else if (item.LocatStatus == "3")
                    //{
                    //    a += 1;
                    //}
                }
                if (a != 4)
                {
                    for (int i = 0; i < 4; i++)
                    {
                        if (list[i].LocatStatus != "4" || list[i].LocatStatus != "5")
                        {
                            if (list.Count < 6)
                            {
                                LocatInventoryVm locat = new LocatInventoryVm();
                                locat.LocatStatus = list.Count.ToString();
                                locat.LocatNum = "0";
                                list.Add(locat);
                            }

                            continue;
                        }
                        else if (list.Count < 6)
                        {
                            LocatInventoryVm locat = new LocatInventoryVm();
                            locat.LocatStatus = i.ToString();
                            locat.LocatNum = "0";
                            list.Add(locat);
                        }
                        else
                        {
                            LocatInventoryVm locat = new LocatInventoryVm();
                            locat.LocatStatus = i.ToString();
                            locat.LocatNum = "0";
                            list.Add(locat);
                        }
                    }
                }

                return list;

            }
            //抛出异常
            catch (Exception ex)
            {

                throw new Exception("获取当前储位占用量异常", ex);
            }
        }

        /// <summary>
        /// 获取储位占用量
        /// </summary>
        /// <returns></returns>
        public List<LocatInventoryVm> LocatInventoryA()
        {
            //捕获异常
            try
            {
                //获取空储位和有储位的
                string str = "select Status LocatStatus,Count(*) LocatNum from SysStorageLocat where IsDel = '0' and WareHouseNo = 'W01' and (Status = '0' or Status = '1' or Status = '2' or Status = '3') group by Status";
                var list = Db.Ado.SqlQuery<LocatInventoryVm>(str);
                if (list == null)
                {
                    throw new Exception("获取储位占比失败");
                }

                //获取储位总数
                string strsum = "select Count(*) LocatNum from SysStorageLocat where IsDel = '0' and WareHouseNo = 'W01'";
                var lista = Db.Ado.SqlQuerySingle<LocatInventoryVm>(strsum);
                if (lista == null)
                {
                    throw new Exception("获取储位总数失败");
                }

                //获取空托盘占用数
                string strpallet = "select Count(*) LocatNum from DataStockDetail where IsDel = '0' and WareHouseNo = 'W01' and SkuNo = '100099' and LocatNo != ''";
                var listb = Db.Ado.SqlQuerySingle<LocatInventoryVm>(strpallet);
                if (listb == null)
                {
                    throw new Exception("获取空托盘占用数失败");
                }

                //LocatStatus 储位状态 0：空储位 1：有物品 2：入库中 3：出库中 9:空托盘 99:总量
                var locatList = new List<LocatInventoryVm>();
                var locatListText = new LocatInventoryVm();
                foreach ( var item in list)
                {
                    if (item.LocatStatus == "0" || item.LocatStatus == "1" || item.LocatStatus == "2" || item.LocatStatus == "3")
                    {
                        locatList.Add(item);
                        continue;
                    }
                    else
                    {
                        continue;
                    }
                }
                //增加总数
                locatListText = new LocatInventoryVm();
                locatListText.LocatStatus = "99";
                locatListText.LocatNum = lista.LocatNum;
                locatList.Add(locatListText);
                //增加空托盘数
                locatListText = new LocatInventoryVm();
                locatListText.LocatStatus = "9";
                locatListText.LocatNum = listb.LocatNum;
                locatList.Add(locatListText);

                return locatList;

            }
            //抛出异常
            catch (Exception ex)
            {

                throw new Exception("获取当前储位占用量异常", ex);
            }
        }
    }
}