using NewLife.AI.Interfaces;
using NewLife.Data;
using XCode;

namespace NewLife.ChatAI.Entity;

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

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

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

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

    /// <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;

        return true;
    }

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

    //    if (XTrace.Debug) XTrace.WriteLine("开始初始化Conversation[会话]数据……");

    //    var entity = new Conversation();
    //    entity.UserId = 0;
    //    entity.Title = "abc";
    //    entity.ModelCode = "abc";
    //    entity.ThinkingMode = 0;
    //    entity.IsPinned = true;
    //    entity.MessageCount = 0;
    //    entity.LastMessageTime = DateTime.Now;
    //    entity.Insert();

    //    if (XTrace.Debug) XTrace.WriteLine("完成初始化Conversation[会话]数据！");
    //}

    ///// <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 扩展属性
    ///// <summary>技能</summary>
    //[XmlIgnore, IgnoreDataMember, ScriptIgnore]
    //public Skill? Skill => Extends.Get(nameof(Skill), k => Skill.FindById(SkillId));
    #endregion

    #region 高级查询
    /// <summary>根据编号查找</summary>
    /// <param name="id">编号</param>
    /// <returns>实体对象</returns>
    public static Conversation? FindById(Int64 id)
    {
        if (id < 0) return null;

        //return Find(_.Id == id);
        return Meta.SingleCache[id] as Conversation;
    }

    // Select Count(Id) as Id,Category From Conversation Where CreateTime>'2020-01-24 00:00:00' Group By Category Order By Id Desc limit 20
    //static readonly FieldCache<Conversation> _CategoryCache = new(nameof(Category))
    //{
    //Where = _.CreateTime > DateTime.Today.AddDays(-30) & Expression.Empty
    //};

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

    /// <summary>分页搜索用户会话列表。按置顶降序、最后消息时间降序排列</summary>
    /// <param name="userId">用户编号</param>
    /// <param name="keyword">标题关键字，为空时不过滤</param>
    /// <param name="page">分页参数</param>
    /// <returns>会话列表</returns>
    public static IList<Conversation> Search(Int32 userId, String? keyword, PageParameter page)
    {
        page.Sort = _.IsPinned.Desc() + "," + _.LastMessageTime.Desc();

        var exp = new WhereExpression();
        exp &= _.UserId == userId;
        exp &= _.Enable == true;
        if (!keyword.IsNullOrEmpty()) exp &= _.Title.Contains(keyword.Trim());

        return FindAll(exp, page);
    }

    /// <summary>根据用户编号查找所有会话编号（仅取 Id 列，用于 IN 子查询）</summary>
    /// <param name="userId">用户编号</param>
    /// <returns>会话编号数组</returns>
    public static Int64[] FindIdsByUserId(Int32 userId)
        => FindAll(_.UserId == userId & _.Enable == true, null, _.Id, 0, 0).Select(e => e.Id).ToArray();

    /// <summary>获取用户最近的会话列表，按最后消息时间倒序</summary>
    /// <param name="userId">用户编号</param>
    /// <param name="maxCount">最大返回数</param>
    /// <returns>会话列表</returns>
    public static IList<Conversation> FindAllByUserId(Int32 userId, Int32 maxCount)
    {
        if (userId <= 0 || maxCount <= 0) return [];

        return FindAll(_.UserId == userId & _.Enable == true, _.LastMessageTime.Desc(), null, 0, maxCount);
    }

    /// <summary>统计用户的会话总数</summary>
    /// <param name="userId">用户编号</param>
    /// <returns>会话总数</returns>
    public static Int32 CountByUserId(Int32 userId)
    {
        if (userId <= 0) return 0;

        return (Int32)FindCount(_.UserId == userId);
    }
    #endregion

    #region 业务操作
    #endregion
}