using ExportMap.db;
using ExportMap.Models;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Diagnostics;
using System.IO;
using System.Linq;
using System.Threading;
using System.Web;

namespace ExportMap.cs
{
    public class SGUtils
    {
        /// <summary>
        /// Mpt目录
        /// </summary>
        public static string MptPath
        {
            get
            {
                return ConfigurationManager.AppSettings["mptFolder"];
            }
        }

        /// <summary>
        /// 3DML目录
        /// </summary>
        public static string D3mlFolder
        {
            get
            {
                return ConfigurationManager.AppSettings["3dmlFolder"];
            }
        }

        /// <summary>
        /// 廊坊数据目录
        /// </summary>
        public static string LFData
        {
            get
            {
                return ConfigurationManager.AppSettings["lfData"];
            }
        }

        /// <summary>
        /// SG的DB库
        /// </summary>
        public static string SGDB
        {
            get
            {
                return ConfigurationManager.AppSettings["sgDB"];
            }
        }

        /// <summary>
        /// 获取发布地址
        /// </summary>
        public static string GetReleaseUrl(SysMeta meta, Int64 sgsID)
        {
            switch (meta.type)
            {
                case "mpt":
                    return "http://{host}/SG/Imagery;" + sgsID + ".mpt"; // Elevation
                case "3dml":
                    return "http://{host}/SG/b3dm/" + sgsID + "/tileset.json";
                default:
                    return string.Empty;
            }
        }

        /// <summary>
        /// 发布数据
        /// </summary>
        /// <param name="args">XYZ参数</param>
        /// <returns>行数</returns>
        public int Release(XYZArgs args, ref string err)
        {
            List<SysMeta> list = XYZUtils.selectMetas(args.ids, "and type in ('mpt', '3dml')");
            if (null == list || list.Count == 0) return 0;

            int maxId = GetMaxId(); // maxId = 411576;
            RomoveNoneFiles(list);
            if (list.Count == 0) return 0;

            //err = LinkFiles(list);
            //if (!string.IsNullOrEmpty(err)) return 0;
            MoveFiles(list);

            int count = 0;
            for (int i = 0; i < 25; i++)
            {
                Thread.Sleep(3000);

                List<SpatialItem> items = SelectItems(maxId);
                if (null == items || items.Count == 0) continue;

                InsertInto(list, items, args);
                count = items.Count;
                break;
            }

            return count;
        }

        /// <summary>
        /// 获取最大ID值
        /// </summary>
        public int GetMaxId()
        {
            Object obj = SQLiteHelper.ExecuteScalar("select max(id) from SpatialItems");

            return null == obj ? 0 : Convert.ToInt32(obj);
        }

        /// <summary>
        /// 查询SG数据项
        /// </summary>
        /// <param name="maxId">最大ID值</param>
        /// <returns>SG数据项</returns>
        public List<SpatialItem> SelectItems(int maxId)
        {
            string sql = string.Format("select id, Name, RelativePath, LayerName, DataSourceId, Description from SpatialItems where id > {0} order by id desc", maxId);

            DataTable dt = SQLiteHelper.GetDataTable(sql);
            List<SpatialItem> list = ModelHandler.FillModel<SpatialItem>(dt);

            return list;
        }

        /// <summary>
        /// 移除空文件
        /// </summary>
        private void RomoveNoneFiles(List<SysMeta> list)
        {
            string uploadFolder = Tool.GetSetting("uploadFolder");

            int i = 0;
            while (i < list.Count)
            {
                SysMeta meta = list[i];
                string filePath = Path.Combine(uploadFolder, meta.path);
                if (!File.Exists(filePath))
                {
                    list.RemoveAt(i);
                    continue;
                }

                if ("mpt".Equals(meta.type))
                {
                    string midx = Path.Combine(uploadFolder, meta.path.Replace(".mpt", ".midx"));
                    string strmi = Path.Combine(uploadFolder, meta.path.Replace(".mpt", ".strmi"));
                    if (!File.Exists(midx) || !File.Exists(strmi))
                    {
                        list.RemoveAt(i);
                        continue;
                    }
                }

                i++;
            }
        }

        /// <summary>
        /// 插入数据发布表
        /// </summary>
        private void InsertInto(List<SysMeta> list, List<SpatialItem> items, XYZArgs args)
        {
            foreach (SysMeta meta in list)
            {
                IEnumerable<SpatialItem> iterator = from item in items where item.Name.Equals(meta.id + "_" + meta.name) select item;
                if (null == iterator) return;

                meta.verid = iterator.First().id;
                InsertToDB(meta, args);
            }
        }

        /// <summary>
        /// 插入数据库
        /// </summary>
        private static void InsertToDB(SysMeta meta, XYZArgs args)
        {
            if (PubDBHelper.IsPublish(meta.id)) return;

            SysPublish sys = NewPublish(meta, args);
            sys.path = meta.id + "\\" + meta.name;

            int pubid = PubDBHelper.InsertPublish(sys);
            if (pubid > 0)
            {
                sys.id = pubid;
                PubDBHelper.InsertLayer(sys, meta);
                PubDBHelper.InsertMetaPub(meta.id, pubid, args.userId);
            }
        }

        /// <summary>
        /// 创建数据发布类
        /// </summary>
        private static SysPublish NewPublish(SysMeta meta, XYZArgs args)
        {
            SysPublish sp = new SysPublish();
            sp.name = meta.name;
            sp.url = GetReleaseUrl(meta, meta.verid);
            sp.type = meta.type;
            sp.status = 3;
            sp.dirid = meta.dircode;
            sp.depid = args.depcode;
            sp.min = 0;
            sp.max = 0;
            sp.json = null;
            sp.create_user = args.userId;
            sp.geom = null;
            sp.bak = null;

            return sp;
        }

        /// <summary>
        /// 移动文件
        /// </summary>
        private static void MoveFiles(List<SysMeta> metas)
        {
            string uploadFolder = Tool.GetSetting("uploadFolder");
            string sgFolder = Path.Combine(uploadFolder, "SG");
            if (!Directory.Exists(sgFolder)) Directory.CreateDirectory(sgFolder);

            List<string> list = new List<string>();
            foreach (SysMeta meta in metas)
            {
                string source = Path.Combine(uploadFolder, meta.path);
                File.Move(source, Path.Combine(sgFolder, meta.id + "_" + meta.name));

                if ("mpt".Equals(meta.type))
                {
                    string midx = Path.Combine(uploadFolder, meta.path.Replace(".mpt", ".midx"));
                    File.Move(midx, Path.Combine(sgFolder, meta.id + "_" + meta.name.Replace(".mpt", ".midx")));

                    string strmi = Path.Combine(uploadFolder, meta.path.Replace(".mpt", ".strmi"));
                    File.Move(strmi, Path.Combine(sgFolder, meta.id + "_" + meta.name.Replace(".mpt", ".strmi")));
                }

                meta.path = "SG" + "\\" + meta.id + "_" + meta.name;
                PubDBHelper.UpdateMetaPath(meta);
            }
        }

        #region 链接文件
        /// <summary>
        /// 链接文件
        /// </summary>
        private string LinkFiles(List<SysMeta> metas)
        {
            List<string> list = new List<string>();
            foreach (SysMeta meta in metas)
            {
                switch (meta.type)
                {
                    case "3dml":
                        AddMptLinkFile(list, meta);
                        break;
                    case "mpt":
                        AddD3mlLinkFile(list, meta);
                        break;
                }

            }

            if (0 == list.Count) return "没有需要更新发布的文件";

            return Tool.ExecCmd(list);
        }

        /// <summary>
        /// 添加链接文件
        /// </summary>
        private void AddMptLinkFile(List<string> list, SysMeta meta)
        {
            string uploadFolder = Tool.GetSetting("uploadFolder");
            string d3mlFolder = Tool.GetSetting("3dmlFolder");

            string targetFolder = Path.Combine(d3mlFolder, meta.id.ToString());
            if (!Directory.Exists(targetFolder)) Directory.CreateDirectory(targetFolder);

            string d3ml = Path.Combine(uploadFolder, meta.path);
            string targetD3ml = Path.Combine(d3mlFolder, meta.id.ToString(), meta.name);

            if (!File.Exists(targetD3ml)) list.Add(string.Format("mklink \"{0}\" \"{1}\"", targetD3ml, d3ml)); // /H
        }

        /// <summary>
        /// 添加链接文件
        /// </summary>
        private void AddD3mlLinkFile(List<string> list, SysMeta meta)
        {
            string uploadFolder = Tool.GetSetting("uploadFolder");
            string mptFolder = Tool.GetSetting("mptFolder");

            string targetFolder = Path.Combine(mptFolder, meta.id.ToString());
            if (!Directory.Exists(targetFolder)) Directory.CreateDirectory(targetFolder);

            string mpt = Path.Combine(uploadFolder, meta.path);
            string targetMpt = Path.Combine(mptFolder, meta.id.ToString(), meta.name);

            string midx = Path.Combine(uploadFolder, meta.path.Replace(".mpt", ".midx"));
            string targetMidx = Path.Combine(mptFolder, meta.id.ToString(), meta.name.Replace(".mpt", ".midx"));

            string strmi = Path.Combine(uploadFolder, meta.path.Replace(".mpt", ".strmi"));
            string targetStrmi = Path.Combine(mptFolder, meta.id.ToString(), meta.name.Replace(".mpt", ".strmi"));

            if (!File.Exists(targetMpt)) list.Add(string.Format("mklink \"{0}\" \"{1}\"", targetMpt, mpt));
            if (!File.Exists(targetMidx)) list.Add(string.Format("mklink \"{0}\" \"{1}\"", targetMidx, midx));
            if (!File.Exists(targetStrmi)) list.Add(string.Format("mklink \"{0}\" \"{1}\"", targetStrmi, strmi));
        }
        #endregion
    }
}