using JNPF.Common.Core.Manager;
using JNPF.Common.Dtos.VisualDev;
using JNPF.Common.Enums;
using JNPF.Common.Security;
using JNPF.FriendlyException;
using JNPF.VisualDev;
using JNPF.VisualDev.Entitys;
using JNPF.VisualDev.Interfaces;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.Logging;
using SqlSugar;
using Tnb.WarehouseMgr.Entities;
using Tnb.WarehouseMgr.Entities.Dto.Inputs;
using Tnb.WarehouseMgr.Entities.Dto.Outputs;
using Tnb.WarehouseMgr.Entities.Enums;
using Tnb.WarehouseMgr.Interfaces;

namespace Tnb.WarehouseMgr
{
    /// <summary>
    /// 载具解绑
    /// </summary>
    [OverideVisualDev(ModuleConsts.MODULE_WMSCARRYUNBIND_ID)]
    public class WmsCarryUnbindService : BaseWareHouseService, IWmsCarryUnbindService
    {
        private readonly ISqlSugarClient _db;
        private readonly IRunService _runService;
        private readonly IVisualDevService _visualDevService;
        private readonly IUserManager _userManager;
        public WmsCarryUnbindService(
            ISqlSugarRepository<WmsCarryH> repository,
            IRunService runService,
            IVisualDevService visualDevService,
            IUserManager userManager)
        {
            _db = repository.AsSugarClient();
            _runService = runService;
            _visualDevService = visualDevService;
            _userManager = userManager;
            OverideFuncs.CreateAsync = CarryUnbind;
        }
        private async Task<dynamic> CarryUnbind(VisualDevModelDataCrInput input)
        {
            bool isOk = false;
            try
            {
                await _db.Ado.BeginTranAsync();

                VisualDevEntity? templateEntity = await _visualDevService.GetInfoById(ModuleConsts.MODULE_WMSCARRYUNBIND_ID, true);
                await _runService.Create(templateEntity, input);

                if (input == null)
                {
                    throw new ArgumentNullException(nameof(input));
                }

                string? carryId = input.data.ContainsKey("carry_id") ? input.data["carry_id"]?.ToString() : "";
                string? subCarryId = input.data.ContainsKey("membercarry_id") ? input.data["membercarry_id"]?.ToString() : "";
                WmsCarryH? carry = await _db.Queryable<WmsCarryH>().FirstAsync(it => it.id == carryId);
                WmsCarryH? subCarry = await _db.Queryable<WmsCarryH>().FirstAsync(it => it.id == subCarryId);
                //WmsCarryunbindH wmsCarryUnbindH = carry.Adapt<WmsCarryunbindH>();
                if (carry != null && subCarry != null)
                {
                    int row = await _db.Deleteable<WmsCarryD>().Where(it => it.carry_id == carryId && it.membercarry_id == subCarryId).ExecuteCommandAsync();
                    List<WmsCarryCode> items = await _db.Queryable<WmsCarryCode>().Where(it => it.carry_id == subCarryId).ToListAsync();
                    //更新载具解绑记录条码表
                    WmsCarryunbindCode wmsCarryUnbindCode = new();
                    for (int i = 0; i < items.Count; i++)
                    {
                        wmsCarryUnbindCode.id = SnowflakeIdHelper.NextId();
                        wmsCarryUnbindCode.org_id = subCarry?.org_id!;
                        wmsCarryUnbindCode.carryunbind_id = input.data["ReturnIdentity"]?.ToString()!;
                        wmsCarryUnbindCode.material_id = items[i].material_id;
                        wmsCarryUnbindCode.material_code = items[i].material_code;
                        wmsCarryUnbindCode.barcode = items[i].barcode;
                        wmsCarryUnbindCode.code_batch = items[i].code_batch;
                        wmsCarryUnbindCode.codeqty = items[i].codeqty;
                        wmsCarryUnbindCode.membercarry_id = subCarry?.id;
                        wmsCarryUnbindCode.membercarry_code = subCarry?.carry_code;
                        wmsCarryUnbindCode.unit_id = items[i].unit_id;
                        wmsCarryUnbindCode.unit_code = items[i].unit_code;
                        wmsCarryUnbindCode.create_id = _userManager.UserId;
                        wmsCarryUnbindCode.create_time = DateTime.Now;
                        row = await _db.Insertable(wmsCarryUnbindCode).ExecuteCommandAsync();
                    }
                    carry.carry_status = ((int)EnumCarryStatus.空闲).ToString();
                    row = await _db.Updateable(carry).ExecuteCommandAsync();
                    subCarry!.carry_status = ((int)EnumCarryStatus.空闲).ToString();
                    row = await _db.Updateable(subCarry).ExecuteCommandAsync();
                    isOk = row > 0;
                    if (!isOk)
                    {
                        throw Oops.Oh(ErrorCode.COM1001);
                    }
                }
                else
                {
                    if (carry == null)
                    {
                        throw new AppFriendlyException("没有可用的主载具", 500);
                    }
                    if (subCarry == null)
                    {
                        throw new AppFriendlyException("没有可用的子载具", 500);
                    }
                }

                await _db.Ado.CommitTranAsync();
            }
            catch (Exception)
            {
                await _db.Ado.RollbackTranAsync();
                throw;
            }
            return Task.FromResult(true);
        }
        /*   public override async Task ModifyAsync(WareHouseUpInput input)
           {
               if (input == null) throw new ArgumentNullException(nameof(input));
               var isOk = await _db.Updateable<WmsCarryReplaceH>().SetColumns(it => new WmsCarryReplaceH { status = input.bizTypeId }).Where(it => it.id == input.requireId).ExecuteCommandHasChangeAsync();
               if (!isOk) throw Oops.Oh(ErrorCode.COM1001);
           }*/

        /// <summary>
        /// 解绑定料箱到料架
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        /// <exception cref="ArgumentNullException"></exception>
        /// <exception cref="AppFriendlyException"></exception>
        [NonAction]
        public async Task<Result> CarryUnbind(CarryBindInput input, ISqlSugarClient dbConn = null)
        {
            bool isOk = false;

            var db = _db;
            if (dbConn != null)
                db = dbConn;

            try
            {
                if (input == null)
                {
                    throw new ArgumentNullException(nameof(input));
                }

                WmsCarryH? carry = await db.Queryable<WmsCarryH>().SingleAsync(it => it.id == input.carry_id);
                if (carry != null)
                {

                    // 插入子载具绑定记录
                    //VisualDevModelDataCrInput visualDevModelCrInput = new() { data = new Dictionary<string, object>() };
                    //visualDevModelCrInput.data[nameof(WmsCarrybindH.carry_id)] = input.carry_id;
                    //visualDevModelCrInput.data[nameof(WmsCarrybindH.carry_code)] = input.carry_code;
                    //visualDevModelCrInput.data[nameof(WmsCarrybindH.membercarry_id)] = input.membercarry_id;
                    //visualDevModelCrInput.data[nameof(WmsCarrybindH.membercarry_code)] = input.membercarry_code;
                    //visualDevModelCrInput.data[nameof(WmsCarrybindH.type)] = 0;
                    //visualDevModelCrInput.data[nameof(WmsCarrybindH.carrystd_id)] = carry.carrystd_id;
                    //if (!string.IsNullOrEmpty(input.create_id))
                    //    visualDevModelCrInput.data[nameof(WmsCarrybindH.create_id)] = input.create_id;

                    //visualDevModelCrInput.data[nameof(WmsCarrybindH.create_time)] = DateTime.Now;
                    //visualDevModelCrInput.data[nameof(WmsCarrybindH.loc)] = 1;
                    //VisualDevEntity? templateEntity = await _visualDevService.GetInfoById(ModuleConsts.MODULE_WMSCARRYUNBIND_ID, true);
                    //await _runService.Create(templateEntity, visualDevModelCrInput);


                    int row = await db.Deleteable<WmsCarryD>().Where(r => r.carry_id == input.carry_id).ExecuteCommandAsync();
                    //isOk = row > 0;

                    //if (!isOk)
                    //{
                    //    throw new Exception($"料架id{input.carry_id}载具解绑失败");
                    //}
                    Logger.LogInformation($"【CarryUnbind】料架{carry.carry_code}已解绑,解绑条数{row}");
                  

                    await db.Ado.CommitTranAsync();
                }
                else
                {
                    if (carry == null)
                    {
                        throw new AppFriendlyException("没有可用的主载具", 500);
                    }
                }
            }
            catch (Exception ex)
            {
                Logger.LogError($"【CarryUnbind】 {ex.Message}");
                Logger.LogError($"【CarryUnbind】 {ex.StackTrace}");
                await db.Ado.RollbackTranAsync();
                return await ToApiResult(JNPF.Common.Enums.HttpStatusCode.InternalServerError, ex.Message);
            }

            return await ToApiResult(JNPF.Common.Enums.HttpStatusCode.OK, "成功");
        }

        /// <summary>
        /// 
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        /// <exception cref="ArgumentNullException"></exception>
        /// <exception cref="AppFriendlyException"></exception>
        [NonAction]
        public async Task<Result> CarryCodeUnbind(CarryCodeUnbindInput input, ISqlSugarClient dbConn = null)
        {
            bool isOk = false;

            var db = _db;
            if (dbConn != null)
                db = dbConn;

            try
            {
                if (input == null)
                {
                    throw new ArgumentNullException(nameof(input));
                }

                WmsCarryH? carry = await db.Queryable<WmsCarryH>().SingleAsync(it => it.id == input.carry_id);
                if (carry != null)
                {
                    int row = await db.Deleteable<WmsCarryCode>().Where(r => r.carry_id == input.carry_id).ExecuteCommandAsync();
                    isOk = row > 0;

                    Logger.LogInformation($"【CarryCodeUnbind】载具{carry.carry_code}已解绑,解绑条数{row}");
                    //if (!isOk)
                    //{
                    //    throw Oops.Oh(ErrorCode.COM1001);
                    //}
                }
                else
                {
                    if (carry == null)
                    {
                        throw new AppFriendlyException("没有可用的主载具", 500);
                    }
                }
            }
            catch (Exception ex)
            {
                Logger.LogError($"【CarryCodeUnbind】 {ex.Message}");
                Logger.LogError($"【CarryCodeUnbind】 {ex.StackTrace}");
                return await ToApiResult(JNPF.Common.Enums.HttpStatusCode.InternalServerError, ex.Message);
            }
            return await ToApiResult(JNPF.Common.Enums.HttpStatusCode.OK, "成功");
        }

        public async Task<Result> CarryCodeUnbindCode(CarryCodeUnbindCodeInput input, ISqlSugarClient dbConn = null)
        {
            bool isOk = false;

            var db = _db;
            if (dbConn != null)
                db = dbConn;

            try
            {
                if (input == null)
                {
                    throw new ArgumentNullException(nameof(input));
                }

                if (!string.IsNullOrEmpty(input.carry_code_id))
                {
                    int row = await db.Deleteable<WmsCarryCode>().Where(r => r.id == input.carry_code_id).ExecuteCommandAsync();
                    isOk = row > 0;

                    Logger.LogInformation($"【CarryCodeUnbind】载具物料明细{input.carry_code_id}已解绑,解绑条数{row}");
                    //if (!isOk)
                    //{
                    //    throw Oops.Oh(ErrorCode.COM1001);
                    //}
                }
                else
                {
                    throw new AppFriendlyException("载具物料明细不能为空", 500);
                }
            }
            catch (Exception ex)
            {
                Logger.LogError($"【CarryCodeUnbind】 {ex.Message}");
                Logger.LogError($"【CarryCodeUnbind】 {ex.StackTrace}");
                return await ToApiResult(JNPF.Common.Enums.HttpStatusCode.InternalServerError, ex.Message);
            }
            return await ToApiResult(JNPF.Common.Enums.HttpStatusCode.OK, "成功");
        }

        public async Task<Result> CarryUnbindWithoutTran(CarryBindInput input, ISqlSugarClient dbConn = null)
        {
            bool isOk = false;

            ISqlSugarClient db = null;
            bool tranFlag = true;

            if (dbConn == null)
            {
                db = _db;
            }
            else
            {
                tranFlag = false;
                db = dbConn;
            }

            try
            {
                if (input == null)
                {
                    throw new ArgumentNullException(nameof(input));
                }

                WmsCarryH? carry = await db.Queryable<WmsCarryH>().SingleAsync(it => it.id == input.carry_id);
                if (carry != null)
                {

                    // 插入子载具绑定记录
                    //VisualDevModelDataCrInput visualDevModelCrInput = new() { data = new Dictionary<string, object>() };
                    //visualDevModelCrInput.data[nameof(WmsCarrybindH.carry_id)] = input.carry_id;
                    //visualDevModelCrInput.data[nameof(WmsCarrybindH.carry_code)] = input.carry_code;
                    //visualDevModelCrInput.data[nameof(WmsCarrybindH.membercarry_id)] = input.membercarry_id;
                    //visualDevModelCrInput.data[nameof(WmsCarrybindH.membercarry_code)] = input.membercarry_code;
                    //visualDevModelCrInput.data[nameof(WmsCarrybindH.type)] = 0;
                    //visualDevModelCrInput.data[nameof(WmsCarrybindH.carrystd_id)] = carry.carrystd_id;
                    //if (!string.IsNullOrEmpty(input.create_id))
                    //    visualDevModelCrInput.data[nameof(WmsCarrybindH.create_id)] = input.create_id;

                    //visualDevModelCrInput.data[nameof(WmsCarrybindH.create_time)] = DateTime.Now;
                    //visualDevModelCrInput.data[nameof(WmsCarrybindH.loc)] = 1;
                    //VisualDevEntity? templateEntity = await _visualDevService.GetInfoById(ModuleConsts.MODULE_WMSCARRYUNBIND_ID, true);
                    //await _runService.Create(templateEntity, visualDevModelCrInput);

                    if (tranFlag)
                    {
                        Logger.LogInformation($"【CarryUnbindWithoutTran】开始事务");
                        await db.Ado.BeginTranAsync();
                    } 
                    else
                    {
                        Logger.LogInformation($"【CarryCodeUnbindWithoutTran】不使用事务");
                    }

                    if (await db.Queryable<WmsCarryD>().Where(r => r.carry_id == input.carry_id).AnyAsync())
                    {
                        int row = await db.Deleteable<WmsCarryD>().Where(r => r.carry_id == input.carry_id).ExecuteCommandAsync();
                        //isOk = row > 0;

                        //if (!isOk)
                        //{
                        //    throw new Exception($"料架id{input.carry_id}载具解绑失败");
                        //}
                        Logger.LogInformation($"【CarryUnbindWithoutTran】料架{carry.carry_code}已解绑,解绑条数{row}");


                        if (tranFlag)
                        {
                            Logger.LogInformation($"【CarryUnbindWithoutTran】提交事务");
                            await db.Ado.CommitTranAsync();
                        }
                    }
                }
                else
                {
                    if (carry == null)
                    {
                        throw new AppFriendlyException("没有可用的主载具", 500);
                    }
                }
            }
            catch (Exception ex)
            {
                Logger.LogError($"【CarryUnbindWithoutTran】 {ex.Message}");
                Logger.LogError($"【CarryUnbindWithoutTran】 {ex.StackTrace}");
                if (tranFlag)
                {
                    Logger.LogInformation($"【CarryUnbindWithoutTran】回滚事务");
                    await db.Ado.RollbackTranAsync();
                }
                throw Oops.Bah(ex.Message);
            }

            return await ToApiResult(JNPF.Common.Enums.HttpStatusCode.OK, "成功");
        }

        public async Task<Result> CarryCodeUnbindWithoutTran(CarryCodeUnbindInput input, ISqlSugarClient dbConn = null)
        {
            bool isOk = false;

            ISqlSugarClient db = null;
            bool tranFlag = true;

            if (dbConn == null)
            {
                db = _db;
            }
            else
            {
                tranFlag = false;
                db = dbConn;
            }

            try
            {
                if (input == null)
                {
                    throw new ArgumentNullException(nameof(input));
                }

                WmsCarryH? carry = await db.Queryable<WmsCarryH>().SingleAsync(it => it.id == input.carry_id);
                if (carry != null)
                {
                    if (tranFlag)
                    {
                        Logger.LogInformation($"【CarryCodeUnbindWithoutTran】开始事务");
                        await db.Ado.BeginTranAsync();
                    }
                    else
                    {
                        Logger.LogInformation($"【CarryCodeUnbindWithoutTran】不使用事务");
                    }

                    if (await db.Queryable<WmsCarryCode>().Where(r => r.carry_id == input.carry_id).AnyAsync())
                    {
                        int row = await db.Deleteable<WmsCarryCode>().Where(r => r.carry_id == input.carry_id).ExecuteCommandAsync();
                        if (tranFlag)
                        {
                            Logger.LogInformation($"【CarryCodeUnbindWithoutTran】提交事务");
                            await db.Ado.CommitTranAsync();
                        }
                        isOk = row > 0;

                        Logger.LogInformation($"【CarryCodeUnbindWithoutTran】载具{carry.carry_code}已解绑,解绑条数{row}");
                        //if (!isOk)
                        //{
                        //    throw Oops.Oh(ErrorCode.COM1001);
                        //}
                    }
                }
                else
                {
                    if (carry == null)
                    {
                        throw new AppFriendlyException("没有可用的主载具", 500);
                    }
                }
            }
            catch (Exception ex)
            {
                Logger.LogError($"【CarryCodeUnbindWithoutTran】 {ex.Message}");
                Logger.LogError($"【CarryCodeUnbindWithoutTran】 {ex.StackTrace}");
                if (tranFlag)
                {
                    Logger.LogInformation($"【CarryCodeUnbindWithoutTran】回滚事务");
                    await db.Ado.RollbackTranAsync();
                }
                throw Oops.Bah(ex.Message);
            }
            return await ToApiResult(JNPF.Common.Enums.HttpStatusCode.OK, "成功");
        }
    }
}