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>
        /// <returns></returns>
        public async Task<string> getOrgTreeList(string orgName, string status)
        {
            var data = new List<OrgItem>();
            SYS_ORGANIZATION func = null;
            if (!string.IsNullOrEmpty(orgName))
            {
                func = Biz.Db.Queryable<SYS_ORGANIZATION>().Where(x=>x.ORG_NAME == orgName).First();
            }
            var items = await Biz.Db.Queryable<SYS_ORGANIZATION>()
                .WhereIF(!string.IsNullOrEmpty(status),q=>q.STATUS == Convert.ToInt32(status))
                .OrderBy(x => x.SEQ_NO)
                .Distinct().ToListAsync();
            //没有查询的时候
            if (func == null)
            {
                List<SYS_ORGANIZATION> entities = items.OrderBy(x => x.SEQ_NO).ToList().FindAll(t => t.PARENT.IsNullOrEmpty());
                foreach (var item in entities)
                {
                    OrgItem deptItem = new();
                    deptItem.id = item.ID;
                    deptItem.deptCode = item.ORG_CODE;
                    deptItem.deptName = item.ORG_NAME;
                    deptItem.PARENT = item.PARENT;
                    deptItem.createTime = item.CREATE_TIME.ToString("yyyy-MM-dd mm:dd:ss");
                    deptItem.status = item.STATUS;
                    deptItem.remark = item.REMARK;
                    deptItem.orderNo= item.SEQ_NO;
                    deptItem.children = new();
                    deptItem.DefaultApi = item.DEFAULTAPI;
                    GetOrgItem(items, item.ORG_CODE, ref deptItem);
                    data.Add(deptItem);
                }
            }
            //有查询条件的时候
            else { 
                
            }

            //string where = page.sqlcmd;
            //action.Data = isAsync ? await Db.Queryable<T>().Where(where).ToPageAsync(page.pageIndex, page.pageSize) : Db.Queryable<T>().Where(where).ToPage(page.pageIndex, page.pageSize);
            //action.Data.draw = page.draw;
            //action.Message = $"Query {typeof(T).Name} entity page from database success";

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


        /// <summary>
        /// 递归返回组织机构
        /// </summary>
        /// <param name="data"></param>
        /// <param name="parent"></param>
        /// <param name="pOrgItem"></param>
        private static void GetOrgItem(List<SYS_ORGANIZATION> data, string parent, ref OrgItem pOrgItem)
        {
            List<SYS_ORGANIZATION> entities = data.OrderBy(x => x.SEQ_NO).ToList().FindAll(t => t.PARENT == parent).Distinct().ToList();
            if (entities.Count > 0)
            {
                foreach (var item in entities)
                {
                    OrgItem deptItem = new();
                    deptItem.id = item.ID;
                    deptItem.deptCode = item.ORG_CODE;
                    deptItem.deptName = item.ORG_NAME;
                    deptItem.PARENT = item.PARENT;
                    deptItem.createTime = item.CREATE_TIME.ToString("yyyy-MM-dd mm:dd:ss");
                    deptItem.status = item.STATUS;
                    deptItem.remark = item.REMARK;
                    deptItem.orderNo = item.SEQ_NO;
                    deptItem.children = new();
                    deptItem.DefaultApi = item.DEFAULTAPI;
                    GetOrgItem(data, item.ORG_CODE, ref deptItem);
                    pOrgItem.children.Add(deptItem);
                }
            }
        }

        public async Task<string> getProdTreeList(string prodName)
        {
            var data = new List<OrgItem>();
            MES_FACTORY func = null;
            if (!string.IsNullOrEmpty(prodName))
            {
                func = Biz.Db.Queryable<MES_FACTORY>().Where(x => x.FTY_CODE == prodName).First();
            }
            var items = await Biz.Db.Queryable<MES_FACTORY>()
                .Distinct().ToListAsync();
            //没有查询的时候
            if (func == null)
            {
                int i = 0;
                foreach (var item in items)
                {
                    OrgItem deptItem = new();
                    deptItem.id = item.ID;
                    deptItem.deptCode = item.FTY_CODE;
                    deptItem.deptName = item.FTY_NAME;
                    deptItem.PARENT = "";
                    deptItem.createTime = item.CREATE_TIME.ToString("yyyy-MM-dd mm:dd:ss");
                    deptItem.status = 0;
                    deptItem.remark = item.REMARK;
                    deptItem.orderNo = i++;
                    deptItem.children = new();
                    deptItem.DefaultApi = "";
                    data.Add(deptItem);
                }
            }
            //有查询条件的时候
            else
            {

            }

            //string where = page.sqlcmd;
            //action.Data = isAsync ? await Db.Queryable<T>().Where(where).ToPageAsync(page.pageIndex, page.pageSize) : Db.Queryable<T>().Where(where).ToPage(page.pageIndex, page.pageSize);
            //action.Data.draw = page.draw;
            //action.Message = $"Query {typeof(T).Name} entity page from database success";

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

    }


    /// <summary>
    /// 部门树形列表
    /// </summary>
    public class OrgItem
    {
        public List<OrgItem> children { get; set; }
        public int? status { get; set; }
        public string PARENT { get; set; }
        public string deptCode { get; set; }
        public string deptName { get; set; }
        public string createTime { get; set; }
        public int? orderNo { get; set; }
        public string remark { get; set; }
        public string id { get; set; }
        public string DefaultApi { get; set; }
        
    }
}