using MES.Service.DB;
using MES.Service.Dto.webApi;
using MES.Service.Modes;

namespace MES.Service.service.BasicData;

/// <summary>
/// MesSimple服务管理类
/// </summary>
public class MesSimpleManager : Repository<MesSimple>
{
    /// <summary>
    /// 获取树形结构数据
    /// </summary>
    public List<TreeView> GetTree()
    {
        var tree = ToTree();
        return tree;
    }

    /// <summary>
    /// 获取树形结构数据（新表 MES_SIMPLE_NEW）
    /// </summary>
    public List<TreeView> GetTreeNew()
    {
        var tree = ToTreeNew();
        return tree;
    }

    /// <summary>
    /// 转换为树形结构
    /// </summary>
    public List<TreeView> ToTree()
    {
        var topList = GetTopList();
        return ConvertToTreeViewList(topList);
    }

    /// <summary>
    /// 转换为树形结构（新表 MES_SIMPLE_NEW）
    /// </summary>
    public List<TreeView> ToTreeNew()
    {
        var topList = GetTopListNew();
        return ConvertToTreeViewListNew(topList);
    }

    /// <summary>
    /// 获取顶级节点列表
    /// </summary>
    private List<MesSimple> GetTopList()
    {
        return Db.Queryable<MesSimple>()
            .Where(x => x.IsTop == 0 && x.Disabled == 0)
            .OrderBy(x => x.Id)
            .ToList();
    }

    /// <summary>
    /// 获取顶级节点列表（新表 MES_SIMPLE_NEW）
    /// </summary>
    private List<MesSimpleNew> GetTopListNew()
    {
        return Db.Queryable<MesSimpleNew>()
            .Where(x => x.IsTop == 0 && x.Disabled == 0)
            .OrderBy(x => new { x.SortOrder, x.Id })
            .ToList();
    }

    /// <summary>
    /// 将MesSimple列表转换为TreeView列表
    /// </summary>
    private List<TreeView> ConvertToTreeViewList(List<MesSimple> mesSimpleList)
    {
        var treeViews = new List<TreeView>();
        
        foreach (var mesSimple in mesSimpleList)
        {
            var treeView = ConvertToTreeView(mesSimple);
            treeViews.Add(treeView);
        }

        return treeViews;
    }

    /// <summary>
    /// 将MesSimpleNew列表转换为TreeView列表
    /// </summary>
    private List<TreeView> ConvertToTreeViewListNew(List<MesSimpleNew> mesSimpleList)
    {
        var treeViews = new List<TreeView>();
        
        foreach (var mesSimple in mesSimpleList)
        {
            var treeView = ConvertToTreeViewNew(mesSimple);
            treeViews.Add(treeView);
        }

        return treeViews;
    }

    /// <summary>
    /// 转换单个MesSimple为TreeView
    /// </summary>
    private TreeView ConvertToTreeView(MesSimple mesSimple)
    {
        var treeView = new TreeView
        {
            Id = mesSimple.Id,
            Title = mesSimple.Title,
            Field = mesSimple.Field,
            Spread = mesSimple.Spread.HasValue && mesSimple.Spread.Value == 1
        };

        // 查询子节点
        var childList = Db.Queryable<MesSimple>()
            .Where(x => x.Disabled == 0 && x.Fid == mesSimple.Id)
            .OrderBy(x => x.Id)
            .ToList();

        // 构建子节点列表
        var childrenList = new List<Children>();
        foreach (var child in childList)
        {
            var children = new Children
            {
                Id = child.Id,
                Title = child.Title,
                Field = child.Field
            };

            // 判断是否为轮播
            if ("轮播".Equals(child.Href))
            {
                children.Href = $"bi_view.html?menuId={child.Id}&lbsj={child.Lbtime}";
            }
            else
            {
                children.Href = child.Href;
            }

            childrenList.Add(children);
        }

        treeView.Children = childrenList;

        return treeView;
    }

    /// <summary>
    /// 转换单个MesSimpleNew为TreeView
    /// </summary>
    private TreeView ConvertToTreeViewNew(MesSimpleNew mesSimple)
    {
        var treeView = new TreeView
        {
            Id = mesSimple.Id,
            Title = mesSimple.Title,
            Field = mesSimple.Field,
            Spread = mesSimple.Spread.HasValue && mesSimple.Spread.Value == 1
        };

        // 查询子节点
        var childList = Db.Queryable<MesSimpleNew>()
            .Where(x => x.Disabled == 0 && x.Fid == mesSimple.Id)
            .OrderBy(x => new { x.SortOrder, x.Id })
            .ToList();

        // 构建子节点列表
        var childrenList = new List<Children>();
        foreach (var child in childList)
        {
            var children = new Children
            {
                Id = child.Id,
                Title = child.Title,
                Field = child.Field
            };

            // 判断是否为轮播
            if ("轮播".Equals(child.Href))
            {
                children.Href = $"bi_view.html?menuId={child.Id}&lbsj={child.Lbtime}";
            }
            else
            {
                children.Href = child.Href;
            }

            childrenList.Add(children);
        }

        treeView.Children = childrenList;

        return treeView;
    }
}