/*
 *所有关于Production_SalesOrder类的业务代码应在此处编写
*可使用repository.调用常用方法，获取EF/Dapper等信息
*如果需要事务请使用repository.DbContextBeginTransaction
*也可使用DBServerProvider.手动获取数据库相关信息
*用户信息、权限、角色等使用UserContext.Current操作
*Production_SalesOrderService对增、删、改查、导入、导出、审核业务代码扩展参照ServiceFunFilter
*/
using iMES.Core.BaseProvider;
using iMES.Core.Extensions.AutofacManager;
using iMES.Entity.DomainModels;
using System.Linq;
using iMES.Core.Utilities;
using System.Linq.Expressions;
using iMES.Core.Extensions;
using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.DependencyInjection;
using Microsoft.AspNetCore.Http;
using iMES.Production.IRepositories;
using System;
using iMES.Custom.IRepositories;
using System.Collections.Generic;
using iMES.Custom.Services;
using iMES.Custom.IServices;
using iMES.Core.ManageUser;
using iMES.Production.Repositories;
using iMES.Core.Enums;
using iMES.Core.DBManager;

namespace iMES.Production.Services
{
    public partial class Production_SalesOrderService
    {
        private readonly IHttpContextAccessor _httpContextAccessor;
        private readonly IProduction_SalesOrderRepository _repository;//访问数据库
        private readonly IProduction_SalesOrderListRepository _salesOrderListrepository;//访问数据库
        private readonly IBase_NumberRuleRepository _numberRuleRepository;//自定义编码规则访问数据库
        private readonly IProduction_WorkOrderRepository _workOrderRepository;//访问数据库
        private readonly IBase_ProductRepository _productRepository;//访问数据库
        private readonly IBase_ProcessService _processService;//访问业务代码
        private readonly IBase_ProcessRepository _processRepository;//访问数据库]
        private readonly IBase_ProcessLineRepository _processLineRepository;
        private readonly IProduction_WorkOrderListRepository _workOrderListRepository;//访问数据库
        

        [ActivatorUtilitiesConstructor]
        public Production_SalesOrderService(
            IProduction_SalesOrderRepository dbRepository,
            IBase_NumberRuleRepository numberRuleRepository,
            IHttpContextAccessor httpContextAccessor,
            IProduction_WorkOrderRepository workOrderRepository,
            IBase_ProductRepository productRepository,
            IBase_ProcessService processService,
            IBase_ProcessRepository processRepository,
            IProduction_WorkOrderListRepository workOrderListRepository,
            IProduction_SalesOrderListRepository salesOrderListrepository,
            IBase_ProcessLineRepository processLineRepository
            )
        : base(dbRepository)
        {
            _httpContextAccessor = httpContextAccessor;
            _numberRuleRepository = numberRuleRepository;
            _repository = dbRepository;
            _workOrderRepository = workOrderRepository;
            _productRepository = productRepository;
            _processService = processService;
            _processRepository = processRepository;
            _workOrderListRepository = workOrderListRepository;
            _salesOrderListrepository = salesOrderListrepository;
            _processLineRepository = processLineRepository;
            //多租户会用到这init代码，其他情况可以不用
            //base.Init(dbRepository);
        }
        WebResponseContent webResponse = new WebResponseContent();
        /// <summary>
        /// 新建
        /// </summary>
        /// <param name="saveDataModel"></param>
        /// <returns></returns>
        public override WebResponseContent Add(SaveModel saveDataModel)
        {
            //此处saveModel是从前台提交的原生数据，可对数据进修改过滤
            AddOnExecuting = (Production_SalesOrder salesOrder, object list) =>
            {
                if (string.IsNullOrWhiteSpace(salesOrder.SalesOrderCode))
                    salesOrder.SalesOrderCode = GetSalesOrderCode();
                //如果返回false,后面代码不会再执行
                if (repository.Exists(x => x.SalesOrderCode == salesOrder.SalesOrderCode))
                {
                    return webResponse.Error("销售订单编号已存在");
                }
                UserInfo userInfo = UserContext.Current.UserInfo;
                List<Production_SalesOrderList> orderLists = list as List<Production_SalesOrderList>;
                int sequence = 1;
                string maxWorkOrderCode = _workOrderRepository.FindAsIQueryable(x => x.WorkOrderCode.Contains(salesOrder.SalesOrderCode))
                  .OrderByDescending(x => x.CreateDate)
                  .Select(s => s.WorkOrderCode)
                  .FirstOrDefault();
                if (!string.IsNullOrEmpty(maxWorkOrderCode) &&  maxWorkOrderCode.Contains("-"))
                {
                    sequence = maxWorkOrderCode.Split('-')[1].GetInt() + 1;
                }
                for (int i = 0; i < orderLists.Count; i++)
                {
                    sequence += i;
                    orderLists[i].WorkOrderCode = salesOrder.SalesOrderCode + "-" + sequence;
                    Production_WorkOrder workOrder = new Production_WorkOrder();
                    workOrder.WorkOrderCode = orderLists[i].WorkOrderCode;
                    workOrder.Product_Id = orderLists[i].Product_Id;
                    workOrder.ProductCode = orderLists[i].ProductCode;
                    workOrder.ProductName = orderLists[i].ProductName;
                    workOrder.ProductStandard = orderLists[i].ProductStandard;
                    var product = _productRepository.FindAsIQueryable(x => x.Product_Id == orderLists[i].Product_Id)
                               .OrderByDescending(x => x.CreateDate)
                               .Select(s => new
                               {
                                   s.Unit_Id,
                                   s.Product_Id,
                                   s.Process_Id
                               })
                               .FirstOrDefault();
                    workOrder.Unit_Id = product.Unit_Id;
                    workOrder.AssociatedForm = salesOrder.SalesOrderCode;
                    workOrder.FromType = "SalesOrder";
                    workOrder.Status = "1";
                    workOrder.PlanStartDate = (DateTime)DateTime.Now.ToString("yyyy-MM-dd 00:00:00").ToDateTime();
                    workOrder.PlanEndDate = (DateTime)DateTime.Now.ToString("yyyy-MM-dd 23:59:59").ToDateTime();
                    workOrder.PlanQty = orderLists[i].Qty;
                    workOrder.RealQty = 0;
                    workOrder.GoodQty = 0;
                    workOrder.NoGoodQty = 0;
                    workOrder.CreateID = userInfo.User_Id;
                    workOrder.Creator = userInfo.UserTrueName;
                    workOrder.CreateDate = DateTime.Now;
                    _workOrderRepository.Add(workOrder, true);
                    List<Base_Process>  processList =  (List<Base_Process>)_processService.GetProcessListByLineID(product.Process_Id.GetInt());
                    List<Production_WorkOrderList> orderListNext = new List<Production_WorkOrderList>();
                    for (int j = 0; j < processList.Count; j++)
                    {
                         var process = _processRepository.FindAsIQueryable(x => x.Process_Id == processList[j].Process_Id)
                               .OrderByDescending(x => x.CreateDate)
                               .Select(s => new
                               {
                                   s.Process_Id,
                                   s.ProcessName,
                                   s.ProcessCode,
                                   s.SubmitWorkLimit,
                                   s.SubmitWorkMatch,
                                   s.DefectItem
                               })
                               .FirstOrDefault();
                        Production_WorkOrderList entity = new Production_WorkOrderList();
                        entity.Process_Id = process.Process_Id;
                        entity.ProcessName = process.ProcessName;
                        entity.ProcessCode = process.ProcessCode;
                        entity.SubmitWorkLimit = process.SubmitWorkLimit;
                        entity.SubmitWorkMatch = process.SubmitWorkMatch;
                        entity.DefectItem = process.DefectItem;
                        var processLine = _processLineRepository.FindAsIQueryable(x => x.ProcessLine_Id == product.Process_Id.GetInt())
                                .OrderByDescending(x => x.CreateDate)
                                .Select(s => new
                                {
                                    s.ProcessLine_Id,
                                    s.Approve
                                })
                               .FirstOrDefault();
                        entity.ProcessLine_Id = product.Process_Id.GetInt();
                        entity.ProcessLine_Approve = processLine.Approve;
                        entity.PlanStartDate = (DateTime)DateTime.Now.ToString("yyyy-MM-dd 00:00:00").ToDateTime();
                        entity.PlanEndDate = (DateTime)DateTime.Now.ToString("yyyy-MM-dd 23:59:59").ToDateTime();
                        entity.PlanQty = orderLists[i].Qty;
                        entity.GoodQty = 0;
                        entity.NoGoodQty = 0;
                        entity.WorkOrder_Id = workOrder.WorkOrder_Id;
                        entity.WorkOrderCode = workOrder.WorkOrderCode;
                        entity.CreateID = userInfo.User_Id;
                        entity.Creator = userInfo.UserTrueName;
                        entity.CreateDate = DateTime.Now;
                        orderListNext.Add(entity);
                    }
                    _workOrderListRepository.AddRange(orderListNext, true);
                }
                return webResponse.OK();
            };
            return base.Add(saveDataModel);
        }
        /// <summary>
        /// 编辑操作
        /// </summary>
        /// <param name="saveModel"></param>
        /// <returns></returns>
        public override WebResponseContent Update(SaveModel saveModel)
        {
            UpdateOnExecute = (SaveModel model) =>
            {
                return webResponse.OK();
            };
            //编辑方法保存数据库前处理
            UpdateOnExecuting = (Production_SalesOrder salesOrder, object addList, object updateList, List<object> delKeys) =>
            {
                //新增的明细表
                List<Production_SalesOrderList> orderLists = addList as List<Production_SalesOrderList>;
                if (orderLists.Count > 0)
                {
                    int sequence = 1;
                    string maxWorkOrderCode = _workOrderRepository.FindAsIQueryable(x => x.WorkOrderCode.Contains(salesOrder.SalesOrderCode))
                     .OrderByDescending(x => x.CreateDate)
                     .Select(s => s.WorkOrderCode)
                     .FirstOrDefault();
                    if (!string.IsNullOrEmpty(maxWorkOrderCode) && maxWorkOrderCode.Contains("-"))
                    {
                        sequence = maxWorkOrderCode.Split('-')[1].GetInt() + 1;
                    }
                    UserInfo userInfo = UserContext.Current.UserInfo;
                    for (int i = 0; i < orderLists.Count; i++)
                    {
                        sequence += i;
                        orderLists[i].WorkOrderCode = salesOrder.SalesOrderCode + "-" + sequence;
                        Production_WorkOrder workOrder = new Production_WorkOrder();
                        workOrder.WorkOrderCode = orderLists[i].WorkOrderCode;
                        workOrder.Product_Id = orderLists[i].Product_Id;
                        workOrder.ProductCode = orderLists[i].ProductCode;
                        workOrder.ProductName = orderLists[i].ProductName;
                        workOrder.ProductStandard = orderLists[i].ProductStandard;
                        var product = _productRepository.FindAsIQueryable(x => x.Product_Id == orderLists[i].Product_Id)
                                   .OrderByDescending(x => x.CreateDate)
                                   .Select(s => new
                                   {
                                       s.Unit_Id,
                                       s.Product_Id,
                                       s.Process_Id
                                   })
                                   .FirstOrDefault();
                        workOrder.Unit_Id = product.Unit_Id;
                        workOrder.AssociatedForm = salesOrder.SalesOrderCode;
                        workOrder.FromType = "SalesOrder";
                        workOrder.Status = "1";
                        workOrder.PlanStartDate = (DateTime)DateTime.Now.ToString("yyyy-MM-dd 00:00:00").ToDateTime();
                        workOrder.PlanEndDate = (DateTime)DateTime.Now.ToString("yyyy-MM-dd 23:59:59").ToDateTime();
                        workOrder.PlanQty = orderLists[i].Qty;
                        workOrder.RealQty = 0;
                        workOrder.GoodQty = 0;
                        workOrder.NoGoodQty = 0;
                        workOrder.ModifyID = userInfo.User_Id;
                        workOrder.Modifier = userInfo.UserTrueName;
                        workOrder.ModifyDate = DateTime.Now;
                        _workOrderRepository.Add(workOrder, true);
                        List<Base_Process> processList = (List<Base_Process>)_processService.GetProcessListByLineID(product.Process_Id.GetInt());
                        List<Production_WorkOrderList> orderListNext = new List<Production_WorkOrderList>();
                        for (int j = 0; j < processList.Count; j++)
                        {
                            var process = _processRepository.FindAsIQueryable(x => x.Process_Id == processList[j].Process_Id)
                                  .OrderByDescending(x => x.CreateDate)
                                  .Select(s => new
                                  {
                                      s.Process_Id,
                                      s.ProcessName,
                                      s.ProcessCode,
                                      s.SubmitWorkLimit,
                                      s.SubmitWorkMatch,
                                      s.DefectItem
                                  })
                                  .FirstOrDefault();
                            Production_WorkOrderList entity = new Production_WorkOrderList();
                            entity.Process_Id = process.Process_Id;
                            entity.ProcessName = process.ProcessName;
                            entity.ProcessCode = process.ProcessCode;
                            entity.SubmitWorkLimit = process.SubmitWorkLimit;
                            entity.SubmitWorkMatch = process.SubmitWorkMatch;
                            entity.DefectItem = process.DefectItem;
                            entity.PlanStartDate = (DateTime)DateTime.Now.ToString("yyyy-MM-dd 00:00:00").ToDateTime();
                            entity.PlanEndDate = (DateTime)DateTime.Now.ToString("yyyy-MM-dd 23:59:59").ToDateTime();
                            entity.PlanQty = orderLists[i].Qty;
                            entity.GoodQty = 0;
                            entity.NoGoodQty = 0;
                            entity.WorkOrder_Id = workOrder.WorkOrder_Id;
                            entity.WorkOrderCode = workOrder.WorkOrderCode;
                            entity.ModifyID = userInfo.User_Id;
                            entity.Modifier = userInfo.UserTrueName;
                            entity.ModifyDate = DateTime.Now;
                            orderListNext.Add(entity);
                        }
                        _workOrderListRepository.AddRange(orderListNext, true);
                    }
                };
                //修改的明细表
                List<Production_SalesOrderList> updateOrderLists = updateList as List<Production_SalesOrderList>;
                if (updateOrderLists.Count > 0)
                {
                    for (int i = 0; i < updateOrderLists.Count; i++)
                    {
                        Production_WorkOrder workOrder = new Production_WorkOrder();
                        int workOrder_Id = _workOrderRepository.FindAsIQueryable(x => x.WorkOrderCode== updateOrderLists[i].WorkOrderCode && x.Product_Id == updateOrderLists[i].Product_Id)
                                      .OrderByDescending(x => x.CreateDate)
                                      .Select(s => s.WorkOrder_Id)
                                      .FirstOrDefault();
                        workOrder.WorkOrder_Id = workOrder_Id;
                        var product = _productRepository.FindAsIQueryable(x => x.Product_Id == updateOrderLists[i].Product_Id)
                                   .OrderByDescending(x => x.CreateDate)
                                   .Select(s => new
                                   {
                                       s.Unit_Id,
                                       s.Product_Id,
                                       s.Process_Id
                                   })
                                   .FirstOrDefault();
                        workOrder.PlanQty = updateOrderLists[i].Qty;
                        _workOrderRepository.Update(workOrder, x => new { x.PlanQty }, true);
                        List<Base_Process> processList = (List<Base_Process>)_processService.GetProcessListByLineID(product.Process_Id.GetInt());
                        List<Production_WorkOrderList> orderListNext = new List<Production_WorkOrderList>();
                        for (int j = 0; j < processList.Count; j++)
                        {
                            Production_WorkOrderList entity = new Production_WorkOrderList();
                            int workOrderList_Id = _workOrderListRepository.FindAsIQueryable(x => x.WorkOrderCode == updateOrderLists[i].WorkOrderCode && x.Process_Id == processList[j].Process_Id)
                                    .OrderByDescending(x => x.CreateDate)
                                    .Select(s => s.WorkOrderList_Id)
                                    .FirstOrDefault();
                            entity.WorkOrderList_Id = workOrderList_Id;
                            entity.PlanQty = updateOrderLists[i].Qty;
                            if (!orderListNext.Exists(order => order.WorkOrderList_Id == workOrderList_Id) && workOrderList_Id > 0)
                            {
                                orderListNext.Add(entity);
                            }
                        }
                        _workOrderListRepository.UpdateRange(orderListNext, x => new { x.PlanQty }, true);
                    }
                }
               
                //删除明细表Id
                var guids = delKeys?.Select(x => (int)x);
                foreach (int id in guids)
                {
                      
                    var wo = _salesOrderListrepository.FindAsIQueryable(x => x.SalesOrderList_Id == id)
                         .OrderByDescending(x => x.CreateDate)
                         .Select(s => new
                         {
                             s.WorkOrderCode
                         })
                         .FirstOrDefault();
                    var woi = _workOrderRepository.FindAsIQueryable(x => x.WorkOrderCode== wo.WorkOrderCode)
                         .OrderByDescending(x => x.CreateDate)
                         .Select(s => new
                         {
                             s.WorkOrder_Id
                         })
                         .FirstOrDefault();
                    if (woi != null)
                    {
                        object[] mainIds = new object[] { woi.WorkOrder_Id };
                        _workOrderRepository.DeleteWithKeys(mainIds, true);
                    }
                }
                return webResponse.OK();
            };
            return base.Update(saveModel);
        }
        public override object GetDetailPage(PageDataOptions pageData)
        {
            var query = Production_SalesOrderListRepository.Instance.IQueryablePage<Production_SalesOrderList>(
                 pageData.Page,
                 pageData.Rows,
                 out int count,
                 x => x.SalesOrder_Id == pageData.Value.GetInt(),
                  orderBy: x => new Dictionary<object, QueryOrderBy>() { { x.CreateDate, QueryOrderBy.Asc } }
                );
            PageGridData<Production_SalesOrderList> detailGrid = new PageGridData<Production_SalesOrderList>();
            detailGrid.rows = query.ToList();
            detailGrid.total = count;
            for (int i = 0; i < detailGrid.rows.Count; i++)
            {
                string woSql = " select * from Production_WorkOrder ";
                List<Production_WorkOrder> list = DBServerProvider.SqlDapper.QueryList<Production_WorkOrder>(woSql, new { });
                if (list.Exists(x => x.WorkOrderCode == detailGrid.rows[i].WorkOrderCode))
                {
                    detailGrid.rows[i].FinishQty = list.Find(x => x.WorkOrderCode == detailGrid.rows[i].WorkOrderCode).GoodQty;
                }
                else
                {
                    detailGrid.rows[i].FinishQty = 0;
                }
            }
            return detailGrid;
        }
        /// <summary>
        /// 自动生成工序编号
        /// </summary>
        /// <returns></returns>
        public string GetSalesOrderCode()
        {
            DateTime dateNow = (DateTime)DateTime.Now.ToString("yyyy-MM-dd").GetDateTime();
            //查询当天最新的订单号
            string defectItemCode = repository.FindAsIQueryable(x => x.CreateDate > dateNow && x.SalesOrderCode.Length > 8)
                .OrderByDescending(x => x.SalesOrderCode)
                .Select(s => s.SalesOrderCode)
                .FirstOrDefault();
            Base_NumberRule numberRule = _numberRuleRepository.FindAsIQueryable(x => x.FormCode == "SalesOrder")
                .OrderByDescending(x => x.CreateDate)
                .FirstOrDefault();
            if (numberRule != null)
            {
                string rule = numberRule.Prefix + DateTime.Now.ToString(numberRule.SubmitTime.Replace("hh", "HH"));
                if (string.IsNullOrEmpty(defectItemCode))
                {
                    rule += "1".PadLeft(numberRule.SerialNumber, '0');
                }
                else
                {
                    rule += (defectItemCode.Substring(defectItemCode.Length - numberRule.SerialNumber).GetInt() + 1).ToString("0".PadLeft(numberRule.SerialNumber, '0'));
                }
                return rule;
            }
            else //如果自定义序号配置项不存在，则使用日期生成
            {
                return DateTime.Now.ToString("yyyyMMddHHmmssffff");
            }
        }
    }
}