using Tiger.Model;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq.Expressions;
using System.Text;
using System.Threading.Tasks;
using Rhea.Common;
using System.Net;
using System.Linq;
using Newtonsoft.Json;

namespace Tiger.Business
{
    public partial class Biz
    {
        /// <summary>
        /// 获取菜单列表
        /// </summary>
        /// <param name="userid"></param>
        /// <returns></returns>
        public async Task<string> getMenuList(string userid, string rootCode)
        {
            var data = new List<MenuItem>();
            var query = Biz.Db.Queryable<SYS_USER, SYS_USERINGROUP, SYS_USERGROUP, SYS_USERGROUP_ROLE, SYS_ROLE_MENU, SYS_MENU>((t, p, g, r, m, f) =>
                                    new JoinQueryInfos(
                                        JoinType.Inner, t.ID == p.USER_ID,
                                        JoinType.Inner, p.USERGROUP_CODE == g.ID,
                                        JoinType.Inner, p.USERGROUP_CODE == r.USERGROUP_CODE,
                                        JoinType.Inner, r.ROLE_CODE == m.ROLE_CODE,
                                        JoinType.Inner, m.FUNC_CODE == f.ID))
                                .WhereIF(!string.IsNullOrEmpty(userid), (t, p, g, r, m, f) => t.USER_ID == userid && f.IS_USE == "1" && f.FUNC_TYPE != "2")
                                .Select((t, p, g, r, m, f) => new SYS_MENU
                                {
                                    ID = f.ID,
                                    FUNC_CODE = f.FUNC_CODE,
                                    FUNC_NAME = f.FUNC_NAME,
                                    FUNC_DESC = f.FUNC_DESC,
                                    FUNC_GROUP = f.FUNC_GROUP,
                                    FUNC_TYPE = f.FUNC_TYPE,
                                    PFUNC_CODE = f.PFUNC_CODE,
                                    FUNC_CLASS = f.FUNC_CLASS,
                                    PATH = f.PATH,
                                    ICON_URL = f.ICON_URL,
                                    SEQ_NO = f.SEQ_NO,
                                    OPEN_MODE = f.OPEN_MODE,
                                    IS_USE = f.IS_USE,
                                    OPER_CODE = f.OPER_CODE,
                                    CREATE_USER = f.CREATE_USER,
                                    CREATE_TIME = f.CREATE_TIME,
                                    UPDATE_USER = f.UPDATE_USER,
                                    UPDATE_TIME = f.UPDATE_TIME,
                                    SYMBOLIC_NAME = f.SYMBOLIC_NAME,
                                    COMPONENT = f.COMPONENT,
                                    CURRENTACTIVEMENU = f.CURRENTACTIVEMENU,
                                    SHOW = f.SHOW,
                                    IGNOREKEEPALIVE = f.IGNOREKEEPALIVE,
                                    IGNOREAUTH = f.IGNOREAUTH,
                                    BUTTON_TYPE = f.BUTTON_TYPE,
                                    DO_METHOD = f.DO_METHOD,
                                });
            var items = await query.Distinct().ToListAsync();
            List<SYS_MENU> entities = items.OrderBy(x => x.SEQ_NO).ToList().FindAll(t => t.PFUNC_CODE == rootCode); //"23858079-7241-4e64-b0cf-eb5dbe84a9d6"
            foreach (var item in entities)
            {
                MenuItem menuItem = new();
                menuItem.id = item.ID;
                menuItem.func_code = item.FUNC_CODE;
                menuItem.path = (item.PATH ?? "").StartsWith("/dashboard") ? "/dashboard" : $"{item.PATH}";
                menuItem.name = item.FUNC_NAME;
                menuItem.component = (item.PATH == null || item.PATH == "#") ? "LAYOUT" : item.COMPONENT;
                if (item.FUNC_CLASS == "PDA")
                {
                    menuItem.pages = menuItem.component;
                    menuItem.url = item.ICON_URL;
                }
                menuItem.meta = new();
                menuItem.meta.icon = item.ICON_URL;  // item.ICON_URL;
                menuItem.meta.orderNo = item.SEQ_NO;
                menuItem.meta.title = item.FUNC_NAME;
                menuItem.meta.menuId = item.ID;
                menuItem.meta.menuCode = item.FUNC_CODE;
                menuItem.btnType = item.BUTTON_TYPE;
                menuItem.meta.btnType = item.BUTTON_TYPE;
                menuItem.meta.doMethod = item.DO_METHOD;
                if (!string.IsNullOrEmpty(item.IGNOREKEEPALIVE))
                {
                    menuItem.meta.ignoreKeepAlive = item.IGNOREKEEPALIVE == "0" ? true : false;
                }
                if (!string.IsNullOrEmpty(item.CURRENTACTIVEMENU))
                {
                    menuItem.meta.currentActiveMenu = item.CURRENTACTIVEMENU;
                }
                if (!string.IsNullOrEmpty(item.SHOW))
                {
                    menuItem.meta.hideMenu = item.SHOW == "1" ? true : false;
                    menuItem.meta.showMenu = item.SHOW == "0" ? true : false;
                }
                if (!string.IsNullOrEmpty(item.IGNOREAUTH))
                {
                    menuItem.meta.ignoreAuth = item.IGNOREAUTH == "Y";
                }
                menuItem.keepalive = item.IGNOREKEEPALIVE;
                menuItem.show = item.SHOW;
                menuItem.menuName = item.FUNC_NAME;
                menuItem.status = item.IS_USE;
                menuItem.btnType = item.BUTTON_TYPE;
                menuItem.func_group = item.FUNC_GROUP;
                menuItem.children = new();
                GetMenuItem(items.ToList(), item.FUNC_CODE, ref menuItem);
                data.Add(menuItem);
            }
            //转换Json时，去除值为null的属性
            var jsonSetting = new JsonSerializerSettings { NullValueHandling = NullValueHandling.Ignore };
            var json = JsonConvert.SerializeObject(data, Formatting.Indented, jsonSetting);
            return json;
        }

        /// <summary>
        /// 获取所有菜单列表
        /// </summary>
        /// <returns></returns>
        public async Task<string> getMenuListAll(string menuName, string status)
        {
            var data = new List<MenuItem>();
            SYS_MENU func = null;
            if (!string.IsNullOrEmpty(menuName))
            {
                string name = menuName.StartsWith("BS")?"BS": menuName;
                func = Biz.Db.Queryable<SYS_MENU>().Where(x => x.FUNC_NAME == name).First();
            }
            if (func != null)
            {
                var items = await Biz.Db.Queryable<SYS_MENU>()
                    .WhereIF(!string.IsNullOrEmpty(status), q => q.IS_USE == status)
                    .OrderBy(x => x.SEQ_NO)
                    .Distinct().ToListAsync();
                List<SYS_MENU> entities = items.OrderBy(x => x.SEQ_NO).ToList().FindAll(t => t.PFUNC_CODE == func.FUNC_CODE);
                foreach (var item in entities)
                {
                    MenuItem menuItem = new();
                    menuItem.id = item.ID;
                    menuItem.func_code = item.FUNC_CODE;
                    menuItem.path = (item.PATH ?? "").StartsWith("/dashboard") ? "/dashboard" : $"{item.PATH}";
                    menuItem.name = item.FUNC_NAME;
                    menuItem.component = (item.PATH == null || item.PATH == "#") ? "LAYOUT" : item.COMPONENT;
                    if (item.FUNC_CLASS == "PDA")
                    {
                        menuItem.pages = menuItem.component;
                        menuItem.url = item.ICON_URL;
                    }
                    menuItem.meta = new();
                    menuItem.meta.icon = item.ICON_URL;  // item.ICON_URL;
                    menuItem.meta.orderNo = item.SEQ_NO;
                    menuItem.meta.title = item.FUNC_NAME;
                    menuItem.meta.menuId = item.ID;
                    menuItem.meta.menuCode = item.FUNC_CODE;
                    menuItem.meta.btnType = item.BUTTON_TYPE;
                    menuItem.meta.doMethod = item.DO_METHOD;
                    if (!string.IsNullOrEmpty(item.IGNOREKEEPALIVE))
                    {
                        menuItem.meta.ignoreKeepAlive = item.IGNOREKEEPALIVE == "0" ? true : false;
                    }
                    if (!string.IsNullOrEmpty(item.CURRENTACTIVEMENU))
                    {
                        menuItem.meta.currentActiveMenu = item.CURRENTACTIVEMENU;
                    }
                    if (!string.IsNullOrEmpty(item.SHOW))
                    {
                        menuItem.meta.hideMenu = item.SHOW == "1" ? true : false;
                        menuItem.meta.showMenu = item.SHOW == "0" ? true : false;
                    }
                    if (!string.IsNullOrEmpty(item.IGNOREAUTH))
                    {
                        menuItem.meta.ignoreAuth = item.IGNOREAUTH == "Y";
                    }
                    menuItem.keepalive = item.IGNOREKEEPALIVE;
                    menuItem.show = item.SHOW;
                    menuItem.menuName = item.FUNC_NAME;
                    menuItem.createTime = item.CREATE_TIME;
                    menuItem.status = item.IS_USE;
                    menuItem.icon = menuItem.meta.icon;
                    menuItem.func_type = item.FUNC_TYPE;
                    menuItem.func_group = item.FUNC_GROUP;
                    menuItem.btnType = item.BUTTON_TYPE;
                    menuItem.parentMenu = item.PFUNC_CODE;
                    menuItem.orderNo = item.SEQ_NO;
                    menuItem.children = null;
                    GetMenuItem(items, item.FUNC_CODE, ref menuItem);
                    data.Add(menuItem);
                }
            };

            //转换Json时，去除值为null的属性
            var jsonSetting = new JsonSerializerSettings { DefaultValueHandling = DefaultValueHandling.Ignore, NullValueHandling = NullValueHandling.Ignore };
            var json = JsonConvert.SerializeObject(data, Formatting.Indented, jsonSetting);
            return json;
        }

        /// <summary>
        /// 保存菜单
        /// </summary>
        /// <param name="action"></param>
        /// <param name="Async"></param>
        /// <returns></returns>
        public async Task<ApiAction> SaveMenu(ApiAction<SaveMenuParams> action, bool Async = true)
        {
            var apiAction = new ApiAction();
            try
            {
                SaveMenuParams data = action.Data;
                //保存到数据库
                var db = Business.Biz.Db;
                var dbTran = db.UseTran(() =>
                {
                    SYS_MENU func = Biz.Db.Queryable<SYS_MENU>().Where(x => x.ID == data.id).First();
                    if (func != null)
                    {
                        func.FUNC_NAME = data.menuName;
                        func.IS_USE = data.status;
                        func.PFUNC_CODE = data.parentMenu;
                        func.PATH = data.path;
                        func.ICON_URL = data.icon;
                        func.SEQ_NO = (int)data.orderNo;
                        func.FUNC_TYPE = data.func_type;
                        func.BUTTON_TYPE = data.btnType;
                        func.DO_METHOD = data.doMethod;
                        func.COMPONENT = string.IsNullOrEmpty(data.component) && data.func_type == "0" ? "LAYOUT" : data.component;
                        func.IGNOREKEEPALIVE = data.keepalive;
                        func.SHOW = data.show;
                        func.FUNC_GROUP = data.func_group;
                        //func.CURRENTACTIVEMENU = data.keepalive
                    }
                    else
                    {
                        func = new()
                        {
                            ID = data.id ?? Guid.NewGuid().ToString("N"),
                            FUNC_CODE = Guid.NewGuid().ToString("N"),
                            FUNC_NAME = data.menuName,
                            FUNC_DESC = data.menuName,
                            FUNC_GROUP = data.func_group,
                            FUNC_TYPE = data.func_type,
                            BUTTON_TYPE = data.btnType,
                            DO_METHOD = data.doMethod,
                            PFUNC_CODE = data.parentMenu,
                            FUNC_CLASS = data.func_class?? "BS",
                            PATH = data.path,
                            ICON_URL = data.icon,
                            SEQ_NO = (int)data.orderNo,
                            IS_USE = data.status,
                            COMPONENT = string.IsNullOrEmpty(data.component) && data.func_type == "0" ? "LAYOUT" : data.component,
                            IGNOREKEEPALIVE = data.keepalive,
                            SHOW = data.show
                        };
                    }
                    //更新
                    if (data != null && data.isUpdate)
                    {
                        db.Updateable(func, "system").ExecuteCommand();
                    }
                    //新增
                    else
                    {
                        db.Insertable(func, "system").ExecuteCommand();
                        //如果是新增的菜单，查出所有父级更新为半选
                        List<SYS_MENU> menus = new();
                        GetRootMenu(func, ref menus);
                        var roles = menus.Select(x => x.ID).ToList();
                        db.Updateable<SYS_ROLE_MENU>().SetColumns(t => t.HALF_CHECK == "Y").Where(x => roles.Contains(x.FUNC_CODE) || x.FUNC_CODE == "system").ExecuteCommand();
                    }
                });
                if (!dbTran.IsSuccess)
                {
                    apiAction.Data = null;
                    apiAction.IsSuccessed = false;
                    apiAction.Message += $"保存数据失败：{dbTran.ErrorMessage}";
                    return apiAction;
                }
            }
            catch (System.Exception ex)
            {

            }
            return apiAction;
        }

        /// <summary>
        /// 递归返回菜单
        /// </summary>
        /// <param name="data"></param>
        /// <param name="parent"></param>
        /// <param name="pMenuItem"></param>
        private static void GetMenuItem(List<SYS_MENU> data, string parent, ref MenuItem pMenuItem)
        {
            List<SYS_MENU> entities = data.OrderBy(x => x.SEQ_NO).ToList().FindAll(t => t.PFUNC_CODE == parent).Distinct().ToList();
            if (entities.Count > 0)
            {
                foreach (var item in entities)
                {
                    MenuItem menuItem = new();
                    menuItem.id = item.ID;
                    menuItem.func_code = item.FUNC_CODE;
                    menuItem.path = (item.PATH ?? "").StartsWith("/dashboard") ? "/dashboard" : $"{item.PATH}";
                    menuItem.name = item.FUNC_NAME;
                    menuItem.component = (item.PATH == null || item.PATH == "#") ? "LAYOUT" : item.COMPONENT;
                    if (item.FUNC_CLASS == "PDA")
                    {
                        menuItem.pages = menuItem.component;
                        menuItem.url = item.ICON_URL;
                    }
                    menuItem.meta = new();
                    menuItem.meta.icon = item.ICON_URL;  //item.ICON_URL;
                    menuItem.meta.orderNo = item.SEQ_NO;
                    menuItem.meta.title = item.FUNC_NAME;
                    menuItem.meta.menuId = item.ID;
                    menuItem.meta.menuCode = item.FUNC_CODE;
                    menuItem.meta.btnType = item.BUTTON_TYPE;
                    menuItem.meta.doMethod = item.DO_METHOD;
                    if (!string.IsNullOrEmpty(item.IGNOREKEEPALIVE))
                    {
                        menuItem.meta.ignoreKeepAlive = item.IGNOREKEEPALIVE == "0" ? true : false;
                    }
                    if (!string.IsNullOrEmpty(item.CURRENTACTIVEMENU))
                    {
                        menuItem.meta.currentActiveMenu = item.CURRENTACTIVEMENU;
                    }
                    if (!string.IsNullOrEmpty(item.SHOW))
                    {
                        menuItem.meta.hideMenu = item.SHOW == "1" ? true : false;
                        menuItem.meta.showMenu = item.SHOW == "0" ? true : false;
                    }
                    if (!string.IsNullOrEmpty(item.IGNOREAUTH))
                    {
                        menuItem.meta.ignoreAuth = item.IGNOREAUTH == "Y";
                    }
                    menuItem.keepalive = item.IGNOREKEEPALIVE;
                    menuItem.show = item.SHOW;
                    menuItem.menuName = item.FUNC_NAME;
                    menuItem.createTime = item.CREATE_TIME;
                    menuItem.icon = menuItem.meta.icon;
                    menuItem.func_type = item.FUNC_TYPE;
                    menuItem.btnType = item.BUTTON_TYPE;
                    menuItem.doMethod = item.DO_METHOD;
                    menuItem.parentMenu = item.PFUNC_CODE;
                    menuItem.func_group = item.FUNC_GROUP;
                    menuItem.orderNo = item.SEQ_NO;
                    menuItem.status = item.IS_USE;
                    menuItem.children = null;
                    GetMenuItem(data, item.FUNC_CODE, ref menuItem);
                    if (pMenuItem.children == null) { pMenuItem.children = new(); }
                    pMenuItem.children.Add(menuItem);
                }
            }
        }

        private static void GetRootMenu(SYS_MENU menu, ref List<SYS_MENU> items)
        {
            SYS_MENU menuRet = null;
            try
            {
                menuRet = Biz.Db.Queryable<SYS_MENU>().Where(q => q.FUNC_CODE == menu.PFUNC_CODE && q.FUNC_CODE != "system01").Single(); //23858079-7241-4e64-b0cf-eb5dbe84a9d6
                if (menuRet != null)
                {
                    if (!items.Where(x => x.FUNC_CODE == menuRet.FUNC_CODE).Any())
                    {
                        items.Add(menuRet);
                    }
                    GetRootMenu(menuRet, ref items);
                }
            }
            catch (System.Exception ex)
            {
                Logger.Default.Fatal($"获取菜单[{menu.FUNC_CODE}]的root菜单异常: {ex.Message}");
            }
        }
    }
}