using DTO;
using Microsoft.AspNetCore.Http;
using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.Configuration;
using Microsoft.Extensions.DependencyInjection;
using System;
using System.Collections.Generic;
using System.Configuration;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace zhengcaioa.Models
{
   public   class UserPage
    {

        

        /// <summary>
        ///  数据实体转换
        /// </summary>
        /// <param name="datadt"></param>
        /// <returns></returns>
        public static List<PageEntity> GetUserPage(string userid, List<int> systemidlist, string page_method)
        {
            List<PageEntity> entityList = new List<PageEntity>();
            
            var connectionString = "";
                try
            {
                var builder = new ConfigurationBuilder().SetBasePath(Directory.GetCurrentDirectory())
            .AddJsonFile("appsettings.Development.json");
                connectionString = builder.Build().GetValue<string>("ConnectionStrings:" + "DefaultConnection");
            }
            catch
            {
                var builder = new ConfigurationBuilder().SetBasePath(Directory.GetCurrentDirectory())
                               .AddJsonFile("appsettings.json");
                connectionString = builder.Build().GetValue<string>("ConnectionStrings:" + "DefaultConnection");

            }

            
            var dbContextOptionBuilder = new DbContextOptionsBuilder<zhengcaioaContext>();
            using (var db = new zhengcaioaContext(dbContextOptionBuilder.UseSqlServer(connectionString).Options))
            {

                #region 超级管理员操作
                var roleId = db.PltUserRoles.Where(o => o.UserId == userid).Select(o => o.RoleId).ToList(); ;//获取角色类型
                var rolename = db.PltRoles.Where(o => roleId.Contains(o.Id) && o.RoleName == "系统管理员").ToList();

                if (rolename!=null&& rolename.Count>0)//超级管理员操作
                {
                    var adminList = from page in db.PltPages
                                    where
                                    page.RecStatus == "A" &&
                                    new List<string> { "M", "P" }.Contains(page.PageType)
                                    orderby page.DisplaySeq
                                    select new PageEntity()
                                    {
                                        Open_Type = page.OpenType ?? 0,
                                        PageID = page.Id,
                                        SystemID = page.SystemId,
                                        PageName = page.PageName,
                                        DisplaySeq = page.DisplaySeq ?? 0,
                                        PagePath = page.PagePath,
                                        PageType = page.PageType,
                                        PageSuperior = page.PageSuperior,
                                        PageIco = page.PageIco ?? "",  //fa  fa-angle-right
                                        OpenType = page.OpenType ?? 0,
                                    };
                    entityList = adminList.ToList();
                }
                #endregion
                else
                {
                    var list = from user in db.PltUsers
                               join user_role in db.PltUserRoles on user.Id equals user_role.UserId
                               join role in db.PltRoles on user_role.RoleId equals role.Id
                               join auth in db.PltAuths.Distinct() on role.Id equals auth.RoleId
                               join page in db.PltPages on auth.ItemId equals page.Id
                               where
                               user.Id == userid &&
                               user.RecStatus == "A" &&
                               user_role.RecStatus == "A" &&
                               role.RecStatus == "A" &&
                               auth.RecStatus == "A" &&
                               page.RecStatus == "A" &&
                               new List<string> { "M", "P" }.Contains(page.PageType) &&
                               //systemidlist.Contains(page.system_id) &&
                               (string.IsNullOrEmpty(page_method) ? true : page.PageMethod == page_method)
                               orderby page.DisplaySeq
                               select new PageEntity()
                               {
                                   Open_Type = page.OpenType ?? 0,
                                   PageID = page.Id,
                                   SystemID = page.SystemId,
                                   PageName = page.PageName,
                                   DisplaySeq = page.DisplaySeq ?? 0,
                                   PagePath = page.PagePath,
                                   PageType = page.PageType,
                                   PageSuperior = page.PageSuperior,
                                   PageIco = page.PageIco ?? "",  //fa  fa-angle-right
                                   OpenType = page.OpenType ?? 0,
                               };
                    entityList = list.ToList().Distinct(new PageEntityIdComparer()).ToList();
                }
            }

            return entityList;
        }

        /// <summary>
        /// 获取菜单信息
        /// </summary>
        /// <returns></returns>
        public static string GetMeum(string userid)
        {
            StringBuilder sbm = new StringBuilder();
            int count = 0;
            List<PageEntity> list = GetUserPage(userid, new List<int> { 1 }, "").OrderBy(D => D.DisplaySeq).ToList();

            list.Where(d => d.PageType == "M").Where(d => d.PageSuperior == "0").OrderBy(o => o.DisplaySeq).ToList().ForEach(f =>
            {
                count++;
                string exp = "";
                if (count == 1)
                {
                    exp = "class=\"active\"";
                }
                var leve2 = list.Where(d => d.PageSuperior == f.PageID && d.PageType == "M").ToList();
                sbm.Append("<li " + exp + " >");
                sbm.Append(" <a href = \"" + f.PagePath + "\" >");
                sbm.Append("<i class=\"" + f.PageIco + "\"></i><span class=\"nav-label\">" + f.PageName + "</span>");
                if (leve2.Count > 0)
                {
                    sbm.Append("<span class=\"fa arrow\"></span>");
                }
                sbm.Append(" </a>");
                #region 二级
                if (leve2.Count > 0)
                {
                    leve2.ForEach(t =>
                    {
                        var level3 = list.Where(d => d.PageSuperior == t.PageID && d.PageType == "M").OrderBy(o => o.DisplaySeq).ToList();

                        sbm.Append(" <ul class=\"nav nav-second-level\"> ");
                        sbm.Append("     <li>");
                        string arrow3 = "";
                        if (level3.Count > 0)
                        {
                            arrow3 = " <span class=\"fa arrow\"></span>";
                        }
                        sbm.Append("    <a  " + (level3.Count == 0 ? " class=\"J_menuItem\" " : "") + "    href = \"" + t.PagePath + "\" > <i class=\"" + t.PageIco + "\"></i>" + t.PageName + " " + arrow3 + "</a>");
                        #region 三级
                        if (level3.Count > 0)
                        {
                            sbm.Append("     <ul class=\"nav nav-third-level\"> ");
                            level3.ForEach(t3 =>
                            {
                                sbm.Append("      <li><a class=\"J_menuItem\" href=\"" + t3.PagePath + "\"> <i class=\"" + t3.PageIco + "\"></i>" + t3.PageName + "</a> </li> ");
                            });
                            sbm.Append("     </ul> ");
                        }
                        #endregion
                        sbm.Append("   </li>");
                        sbm.Append("</ul>");

                    });
                }
                #endregion
                sbm.Append("</li>");
            });
            return sbm.ToString();
        }
    }
}