using Admin.NET.Core;
using Furion.DatabaseAccessor;
using Furion.DatabaseAccessor.Extensions;
using Furion.DependencyInjection;
using Furion.DynamicApiController;
using Furion.Extras.Admin.NET.Entity;
using Furion.FriendlyException;
using Mapster;
using Microsoft.AspNetCore.Http.Metadata;
using Microsoft.AspNetCore.Mvc;
using Microsoft.EntityFrameworkCore;

namespace Admin.NET.Application
{
    /// <summary>
    /// 代码生成详细配置服务
    /// </summary>
    [ApiDescriptionSettings(Name = "CodeGenConfig", Order = 100)]
    [Route("api")]
    public class SysCodeGenerateConfigService : ICodeGenConfigService, IDynamicApiController, ITransient
    {
        private readonly IRepository<SysLowCodeDataBase> _sysLowCodeRep; // 代码生成器仓储
        private readonly IRepository<SysCodeGen> _sysCodeGenRep; // 代码生成器仓储
        private readonly IRepository<SysCodeGenConfig> _sysCodeGenConfigRep; // 代码生成详细配置仓储

        /// <summary>
        /// 构造函数
        /// </summary>
        /// <param name="sysCodeGenConfigRep"></param>
        /// <param name="sysCodeGenRep"></param>
        /// <param name="sysLowCodeRep"></param>
        public SysCodeGenerateConfigService(IRepository<SysCodeGenConfig> sysCodeGenConfigRep, IRepository<SysCodeGen> sysCodeGenRep
            , IRepository<SysLowCodeDataBase> sysLowCodeRep
            )
        {
            _sysLowCodeRep = sysLowCodeRep;
            _sysCodeGenConfigRep = sysCodeGenConfigRep;
            _sysCodeGenRep = sysCodeGenRep;
        }

        /// <summary>
        /// 代码生成详细配置列表
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpGet("sysCodeGenerateConfig/list")]
        public async Task<List<CodeGenConfig>> List([FromQuery] CodeGenConfig input)
        {
            var result = await _sysCodeGenConfigRep.DetachedEntities
                                             .Where(u => u.CodeGenId == input.CodeGenId && u.WhetherCommon != YesOrNot.Y.ToString())
                                             .ProjectToType<CodeGenConfig>()
                                             .Distinct()
                                             .ToListAsync();

            var codeGen = await _sysCodeGenRep.FirstOrDefaultAsync(x => x.Id == input.CodeGenId);
            var codeGenOutput = codeGen.Adapt<CodeGenOutput>();
            result.ForEach(x => x.CodeGen = codeGenOutput);
            return result;
        }

        /// <summary>
        /// 更新
        /// </summary>
        /// <param name="inputList"></param>
        /// <returns></returns>
        [HttpPost("sysCodeGenerateConfig/edit")]
        public async Task Update(List<CodeGenConfig> inputList)
        {
            if (inputList == null || inputList.Count < 1) return;
            var list = inputList.Adapt<List<SysCodeGenConfig>>();

            CodeGenHelper.ValidateCodeGenConfig(list);

            await _sysCodeGenConfigRep.UpdateAsync(list);
        }

        /// <summary>
        /// 详情
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpGet("·/detail")]
        public async Task<SysCodeGenConfig> Detail([FromQuery] CodeGenConfig input)
        {
            return await _sysCodeGenConfigRep.FirstOrDefaultAsync(u => u.Id == input.Id);
        }

        /// <summary>
        /// 批量增加
        /// </summary>
        /// <param name="tableColumnOuputList"></param>
        /// <param name="codeGenerate"></param>
        [NonAction]
        public async Task DelAndAddList(List<TableColumnOuput> tableColumnOuputList, SysCodeGen codeGenerate)
        {
            if (tableColumnOuputList == null) return;
            var list = new List<SysCodeGenConfig>();

            List<SysLowCodeDataBase> list_LowCode = new List<SysLowCodeDataBase>();

            if (codeGenerate != null && codeGenerate.LowCodeId > 0 && _sysLowCodeRep.Where(x => x.SysLowCodeId == codeGenerate.LowCodeId).Any())
            {
                list_LowCode = _sysLowCodeRep.Where(x => x.SysLowCodeId == codeGenerate.LowCodeId).ToList();
            }

            foreach (var tableColumn in tableColumnOuputList)
            {
                var codeGenConfig = new SysCodeGenConfig();

                var YesOrNo = YesOrNot.Y.ToString();
                if (Convert.ToBoolean(tableColumn.ColumnKey))
                {
                    YesOrNo = YesOrNot.N.ToString();
                }

                if (CodeGenUtil.IsCommonColumn(tableColumn.ColumnName))
                {
                    codeGenConfig.WhetherCommon = YesOrNot.Y.ToString();
                    YesOrNo = YesOrNot.N.ToString();
                }
                else
                {
                    codeGenConfig.WhetherCommon = YesOrNot.N.ToString();
                }

                codeGenConfig.CodeGenId = codeGenerate.Id;
                codeGenConfig.ColumnName = tableColumn.ColumnName;
                codeGenConfig.ColumnComment = tableColumn.ColumnComment;
                codeGenConfig.NetType = CodeGenUtil.ConvertDataType(tableColumn.DataType);
                codeGenConfig.DtoNetType = list_LowCode.Where(x => x.FieldName == tableColumn.ColumnName).Select(x => x.DtoTypeName).FirstOrDefault();
                if (string.IsNullOrEmpty(codeGenConfig.DtoNetType)) codeGenConfig.DtoNetType = codeGenConfig.NetType;
                codeGenConfig.WhetherRetract = YesOrNot.N.ToString();

                codeGenConfig.WhetherRequired = tableColumn.IsNullable ? YesOrNot.N.ToString() : YesOrNot.Y.ToString();
                codeGenConfig.QueryWhether = YesOrNo;

                if (codeGenConfig.WhetherRequired == YesOrNot.Y.ToString())
                {//必填字段必须配置增改。
                    codeGenConfig.WhetherAddUpdate = YesOrNot.Y.ToString();
                    if (codeGenConfig.ColumnName.ToLower() == "id")
                    {
                        codeGenConfig.WhetherAddUpdate = YesOrNot.N.ToString();
                    }
                }
                else
                {//字段不必填
                    //ly-0419 生成新建 编辑页面 创建人 修改人创建时间 修改时间 也自动生成，需要去掉
                    if (codeGenConfig.ColumnName == "CreatedTime" || codeGenConfig.ColumnName == "UpdatedTime"
                        || codeGenConfig.ColumnName == "CreatedUserName" || codeGenConfig.ColumnName == "UpdatedUserName")
                    {
                        codeGenConfig.WhetherAddUpdate = YesOrNot.N.ToString();
                    }
                    else
                    {
                        codeGenConfig.WhetherAddUpdate = YesOrNo;
                    }
                }

                codeGenConfig.WhetherTable = YesOrNo;
                codeGenConfig.WhetherOrderBy = YesOrNo;
                //是否联合主键 update by liuwq 20240418 
                codeGenConfig.WhetherRequired = YesOrNot.N.ToString();
                codeGenConfig.ColumnKey = tableColumn.ColumnKey;

                codeGenConfig.DataType = tableColumn.DataType;
                codeGenConfig.EffectType = CodeGenUtil.DataTypeToEff(codeGenConfig.NetType);
                codeGenConfig.QueryType = QueryTypeConst.等于; // QueryTypeEnum.eq.ToString();
                if (codeGenConfig.DtoNetType.ToLower() == "datetime".ToLower() || codeGenConfig.DtoNetType.ToLower() == "DateTimeOffset".ToLower())
                {
                    codeGenConfig.QueryType = QueryTypeConst.介于;
                }
                codeGenConfig.ShowTitleMinWidth = tableColumn.ShowTitleMinWidth;
                list.Add(codeGenConfig);
            }

            _sysCodeGenConfigRep.Context.DeleteRange<SysCodeGenConfig>(x => x.CodeGenId == codeGenerate.Id);

            await _sysCodeGenConfigRep.InsertAsync(list);
        }

        /// <summary>
        /// 增加
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [NonAction]
        public async Task Add(CodeGenConfig input)
        {
            var codeGenConfig = input.Adapt<SysCodeGenConfig>();
            await codeGenConfig.InsertAsync();
        }

        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="codeGenId"></param>
        /// <returns></returns>
        [NonAction]
        public async Task Delete(long codeGenId)
        {
            var codeGenConfigList = await _sysCodeGenConfigRep.Where(u => u.CodeGenId == codeGenId).ToListAsync();
            await _sysCodeGenConfigRep.DeleteAsync(codeGenConfigList);
        }
    }
}