using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.IO;
using System.Linq;
using System.Reflection;
using System.Runtime.Serialization;
using System.Text;
using System.Threading.Tasks;
using System.Web;
using System.Web.Script.Serialization;
using System.Xml.Serialization;
using NewLife;
using NewLife.Data;
using NewLife.Log;
using NewLife.Model;
using NewLife.Reflection;
using NewLife.Threading;
using NewLife.Web;
using XCode;
using XCode.Cache;
using XCode.Configuration;
using XCode.DataAccessLayer;
using XCode.Membership;
using XCode.Shards;

namespace Rainbow.Entity;

public partial class Device : Entity<Device>
{
    #region 对象操作
    // 控制最大缓存数量，Find/FindAll查询方法在表行数小于该值时走实体缓存
    private static Int32 MaxCacheCount = 1000;

    static Device()
    {
        // 累加字段，生成 Update xx Set Count=Count+1234 Where xxx
        //var df = Meta.Factory.AdditionalFields;
        //df.Add(nameof(Kind));

        // 拦截器 UserInterceptor、TimeInterceptor、IPInterceptor
        Meta.Interceptors.Add(new UserInterceptor { AllowEmpty = false });
        Meta.Interceptors.Add<TimeInterceptor>();
        Meta.Interceptors.Add(new IPInterceptor { AllowEmpty = false });

        // 实体缓存
        // var ec = Meta.Cache;
        // ec.Expire = 60;

        // 单对象缓存
        var sc = Meta.SingleCache;
        // sc.Expire = 60;
        sc.FindSlaveKeyMethod = k => Find(_.Mac == k);
        sc.GetSlaveKeyMethod = e => e.Mac;
    }

    /// <summary>验证并修补数据，返回验证结果，或者通过抛出异常的方式提示验证失败。</summary>
    /// <param name="method">添删改方法</param>
    public override Boolean Valid(DataMethod method)
    {
        //if (method == DataMethod.Delete) return true;
        // 如果没有脏数据，则不需要进行任何处理
        if (!HasDirty) return true;

        // 建议先调用基类方法，基类方法会做一些统一处理
        if (!base.Valid(method)) return false;

        // 在新插入数据或者修改了指定字段时进行修正

        // 处理当前已登录用户信息，可以由UserInterceptor拦截器代劳
        /*var user = ManageProvider.User;
        if (user != null)
        {
            if (method == DataMethod.Insert && !Dirtys[nameof(CreateUserID)]) CreateUserID = user.ID;
            if (!Dirtys[nameof(UpdateUserID)]) UpdateUserID = user.ID;
        }*/
        //if (method == DataMethod.Insert && !Dirtys[nameof(CreateTime)]) CreateTime = DateTime.Now;
        //if (!Dirtys[nameof(UpdateTime)]) UpdateTime = DateTime.Now;
        //if (method == DataMethod.Insert && !Dirtys[nameof(CreateIP)]) CreateIP = ManageProvider.UserHost;
        //if (!Dirtys[nameof(UpdateIP)]) UpdateIP = ManageProvider.UserHost;

        // 检查唯一索引
        // CheckExist(method == DataMethod.Insert, nameof(Mac));

        return true;
    }

    ///// <summary>首次连接数据库时初始化数据，仅用于实体类重载，用户不应该调用该方法</summary>
    //[EditorBrowsable(EditorBrowsableState.Never)]
    //protected override void InitData()
    //{
    //    // InitData一般用于当数据表没有数据时添加一些默认数据，该实体类的任何第一次数据库操作都会触发该方法，默认异步调用
    //    if (Meta.Session.Count > 0) return;

    //    if (XTrace.Debug) XTrace.WriteLine("开始初始化Device[终端设备]数据……");

    //    var entity = new Device();
    //    entity.Name = "abc";
    //    entity.Mac = "abc";
    //    entity.IP = "abc";
    //    entity.HostName = "abc";
    //    entity.Kind = 0;
    //    entity.Vendor = "abc";
    //    entity.Icon = "abc";
    //    entity.Owner = "abc";
    //    entity.GroupID = 0;
    //    entity.Online = true;
    //    entity.LastOnline = DateTime.Now;
    //    entity.OnlineTime = 0;
    //    entity.Traffic = 0;
    //    entity.Logins = 0;
    //    entity.Enable = true;
    //    entity.Insert();

    //    if (XTrace.Debug) XTrace.WriteLine("完成初始化Device[终端设备]数据！");
    //}

    ///// <summary>已重载。基类先调用Valid(true)验证数据，然后在事务保护内调用OnInsert</summary>
    ///// <returns></returns>
    //public override Int32 Insert()
    //{
    //    return base.Insert();
    //}

    ///// <summary>已重载。在事务保护范围内处理业务，位于Valid之后</summary>
    ///// <returns></returns>
    //protected override Int32 OnDelete()
    //{
    //    return base.OnDelete();
    //}
    #endregion

    #region 扩展属性
    #endregion

    #region 高级查询

    // Select Count(ID) as ID,Owner From Device Where UpdateTime>'2020-01-24 00:00:00' Group By Owner Order By ID Desc limit 20
    static readonly FieldCache<Device> _OwnerCache = new(nameof(MemberId))
    {
        //Where = _.UpdateTime > DateTime.Today.AddDays(-30) & Expression.Empty
    };

    /// <summary>获取所属人列表，字段缓存10分钟，分组统计数据最多的前20种，用于魔方前台下拉选择</summary>
    /// <returns></returns>
    public static IDictionary<String, String> GetOwnerList() => _OwnerCache.FindAllName();
    #endregion

    #region 业务操作

    /// <summary>已重载。更新后同步DHCP静态绑定</summary>
    /// <returns></returns>
    protected override Int32 OnUpdate()
    {
        // 静态IP变更时同步DHCP绑定
        if (Dirtys["StaticIP"])
        {
            if (StaticIP && !IP.IsNullOrEmpty())
            {
                var binding = DhcpBinding.FindByMac(Mac);
                if (binding == null)
                {
                    binding = new DhcpBinding
                    {
                        Mac = Mac,
                        IP = IP,
                        HostName = HostName,
                        DeviceId = Id,
                        Enable = true
                    };
                    binding.Insert();
                }
                else
                {
                    binding.IP = IP;
                    binding.HostName = HostName;
                    binding.DeviceId = Id;
                    binding.Enable = true;
                    binding.Update();
                }
            }
            else if (!StaticIP)
            {
                var binding = DhcpBinding.FindByMac(Mac);
                if (binding != null)
                {
                    binding.Enable = false;
                    binding.Update();
                }
            }
        }

        return base.OnUpdate();
    }
    #endregion
}