using System.Web;
using Microsoft.AspNetCore.Mvc;
using Stardust.Data.Nodes;
using NewLife;
using NewLife.Cube;
using NewLife.Cube.ViewModels;
using NewLife.Data;
using NewLife.Log;
using NewLife.Web;
using XCode.Membership;
using Stardust.Server.Services;

namespace Stardust.Web.Areas.MySql.Controllers;

[Menu(50)]
[MySqlArea]
public class MySqlNodeController : EntityController<MySqlNode>
{
    private readonly IMySqlService _mySqlService;

    static MySqlNodeController()
    {
        LogOnChange = true;

        ListFields.RemoveField("WebHook", "AlarmConnections", "AlarmQPS", "AlarmSlowQuery");
        ListFields.RemoveCreateField();
        ListFields.RemoveField("UpdateUser", "UpdateUserID", "UpdateIP", "Remark");

        {
            var df = ListFields.GetField("ProjectName") as ListField;
            df.Url = "/Platform/GalaxyProject?projectId={ProjectId}";
            df.Target = "_frame";
        }
        {
            var df = ListFields.AddListField("Monitor", "UpdateTime");
            df.DisplayName = "监控";
            df.Header = "监控";
            df.Url = "/MySql/MySqlData?mysqlId={Id}";
        }
        {
            var df = ListFields.AddListField("Refresh", "UpdateTime");
            df.DisplayName = "刷新";
            df.Header = "刷新";
            df.Url = "/MySql/MySqlNode/Refresh?Id={Id}";
            df.DataAction = "action";
        }
        {
            var df = ListFields.AddListField("Log", "UpdateTime");
            df.DisplayName = "审计日志";
            df.Header = "审计日志";
            df.Url = $"/Admin/Log?category={HttpUtility.UrlEncode("MySql节点")}&linkId={{Id}}";
            df.Target = "_frame";
        }
    }

    public MySqlNodeController(IMySqlService mySqlService) => _mySqlService = mySqlService;

    /// <summary>高级搜索。按条件分页查询</summary>
    /// <param name="p">分页参数</param>
    /// <returns>实体列表</returns>
    protected override IEnumerable<MySqlNode> Search(Pager p)
    {
        var nodeId = p["Id"].ToInt(-1);
        if (nodeId > 0)
        {
            var node = MySqlNode.FindById(nodeId);
            if (node != null) return new[] { node };
        }

        var server = p["server"];
        var port = p["port"].ToInt(-1);
        var projectId = p["projectId"].ToInt(-1);
        var enable = p["enable"]?.ToBoolean();

        var start = p["dtStart"].ToDateTime();
        var end = p["dtEnd"].ToDateTime();

        return MySqlNode.Search(server, port, projectId, enable, start, end, p["Q"], p);
    }

    [EntityAuthorize(PermissionFlags.Update)]
    public ActionResult Refresh(Int32 id)
    {
        var node = MySqlNode.FindById(id);
        if (node != null)
        {
            XTrace.WriteLine("Refreshing {0}/{1} {2}:{3}", node.Name, node.Id, node.Server, node.Port);

            try
            {
                _mySqlService.TraceNode(node);

                LogProvider.Provider.WriteLog("MySqlNode", "Refresh", true, L.TLog("MySql node [{0}] refreshed successfully.", node));
            }
            catch (Exception ex)
            {
                LogProvider.Provider.WriteLog("MySqlNode", "Refresh", false, ex?.GetMessage());

                throw;
            }
        }

        return JsonRefresh($"刷新[{node}]成功！");
    }
}