using System.Collections.Generic;
using UnityEngine;
using UnityEditor;
using System.IO;
using System.Text;
using System;
using System.Text.RegularExpressions;


public class ExcelParseTool : EditorWindow
{
    [SerializeField] string filePath = string.Empty;
    [SerializeField] string replaceFilePath = string.Empty;
    [SerializeField] string cacheDirectory = string.Empty;
    protected string[] lineStep = new string[] { "\r\n" }; //行间隔体
    public string[] m_Lines = null;
    FileInfo m_FileInfo;
    StringBuilder m_StringBuilder = new StringBuilder();
    List<int> m_FitterCols = new List<int>();
    List<string> m_FitterKeys = new List<string>();
    public Dictionary<string, string> m_Englishs = new Dictionary<string, string>();
    public Dictionary<string, string> m_EnglishReplaces = new Dictionary<string, string>();
    public Dictionary<FileInfo, string> m_AllTexts = new Dictionary<FileInfo, string>();
    [MenuItem("策划工具/Excel解析")]
    public static void OpenWindow()
    {
        ExcelParseTool _window = GetWindow(typeof(ExcelParseTool), false, "Excel解析") as ExcelParseTool;
        _window.Show();
        _window.autoRepaintOnSceneChange = true;
    }

    private void OnGUI()
    {
        GUI.skin.button.normal.textColor = Color.white;
        GUILayout.BeginHorizontal();
        GUILayout.Label(StringUtility.Contact("文件路径：", filePath));
        if (GUILayout.Button("Browser"))
        {
            filePath = EditorUtility.OpenFolderPanel("文件路径", "", "");
        }

        GUILayout.FlexibleSpace();
        GUILayout.EndHorizontal();

        GUILayout.Label(StringUtility.Contact("替换文件：", replaceFilePath));
        if (GUILayout.Button("Browser"))
        {
            replaceFilePath = EditorUtility.OpenFilePanel("替换文件", "", "");
        }

        if (GUILayout.Button("解析"))
        {
            m_Englishs.Clear();
            ConfigInitiator.EditorLoad();
            m_FitterKeys.Clear();
            m_FitterKeys.AddRange(LanguageConfig.GetKeys());
            m_FitterKeys.AddRange(SysInfoConfig.GetKeys());
            m_FitterKeys.AddRange(IconConfig.GetKeys());
            FindEnglishLabel();
        }

        if (GUILayout.Button("替换"))
        {
            m_AllTexts.Clear();
            try
            {
                var _fileInfo = new FileInfo(replaceFilePath);
                var fs = _fileInfo.OpenRead();
                var sr = new StreamReader(fs, Encoding.UTF8);
                var lines = sr.ReadToEnd().Split(lineStep, StringSplitOptions.None);
                m_EnglishReplaces.Clear();
                for (int i = 0; i < lines.Length; i++)
                {
                    var _line = lines[i].Split('\t');
                    if (_line.Length > 1 && _line[1] != string.Empty)
                    {
                        m_EnglishReplaces.Add(_line[0], _line[1]);
                    }
                }
                fs.Dispose();
                fs.Close();
            }
            catch (Exception e)
            {
                DebugEx.LogError(e.ToString());
            }
            ConfigInitiator.EditorLoad();
            m_FitterKeys.Clear();
            m_FitterKeys.AddRange(LanguageConfig.GetKeys());
            m_FitterKeys.AddRange(SysInfoConfig.GetKeys());
            m_FitterKeys.AddRange(IconConfig.GetKeys());
            FindEnglishLabel(true);
        }
    }

    void FindEnglishLabel(bool _replace = false)
    {
        string[] _files = Directory.GetFiles(filePath, "*.txt", SearchOption.AllDirectories);
        if (_files == null || _files.Length == 0)
        {
            return;
        }
        var _index = 0;
        EditorApplication.update += delegate ()
        {
            var _fileInfo = new FileInfo(_files[_index]);
            m_FileInfo = _fileInfo;
            if (_fileInfo != null && (_fileInfo.Name == "Face.txt"
               || _fileInfo.Name == "ActorShow.txt"
               || _fileInfo.Name == "DirtyWord.txt"
               || _fileInfo.Name == "Audio.txt"
               || _fileInfo.Name == "Effect.txt"
               || _fileInfo.Name == "GmCmd.txt"
               || _fileInfo.Name == "Map.txt"
               || _fileInfo.Name == "Icon.txt"
               || _fileInfo.Name == "mapnpc.txt"
               || _fileInfo.Name == "Market.txt"
               || _fileInfo.Name == "PlayerProperty.txt"
               || _fileInfo.Name == "RichTextMsgReplace.txt"
               || _fileInfo.Name == "TablePath.txt"
               || _fileInfo.Name == "LoginSeverList.txt"
               || _fileInfo.Name == "FuncConfig.txt"
               || _fileInfo.Name == "logger.txt"))
            {

            }
            else
            {
                m_AllTexts.Add(m_FileInfo, string.Empty);
                try
                {
                    var fs = m_FileInfo.OpenRead();
                    var sr = new StreamReader(fs, Encoding.UTF8);

                    var lines = sr.ReadToEnd().Split(lineStep, StringSplitOptions.None);
                    ParseExcel(lines, true);
                    fs.Dispose();
                    fs.Close();
                }
                catch (Exception e)
                {
                    DebugEx.LogError(e.ToString());
                }
            }

            bool isCancel = EditorUtility.DisplayCancelableProgressBar("查找英文",
                         StringUtility.Contact(_index, "/", _files.Length), (float)_index / _files.Length);
            _index++;
            if (isCancel || _index >= _files.Length)
            {
                EditorApplication.update = null;
                EditorUtility.ClearProgressBar();
                _index = 0;
                if (_replace)
                {
                    foreach (var _key in m_AllTexts.Keys)
                    {
                        var _replaceInfo = new FileInfo(replaceFilePath);
                        using (FileStream _fs = new FileStream(StringUtility.Contact(_replaceInfo.DirectoryName, "/", _key.Name), FileMode.Create, FileAccess.Write, FileShare.Write))
                        {
                            using (StreamWriter sw = new StreamWriter(_fs, Encoding.UTF8))
                            {
                                sw.Write(m_AllTexts[_key]);
                            }
                        }
                    }
                    return;
                }
                using (FileStream fs = new FileStream(StringUtility.Contact(filePath, "/PathCache/logger.txt"), FileMode.Create, FileAccess.Write, FileShare.Write))
                {
                    using (StreamWriter sw = new StreamWriter(fs))
                    {
                        foreach (var item in m_Englishs.Values)
                        {
                            sw.WriteLine(item);
                        }
                    }
                }
            }
        };
    }

    void ParseExcel(string[] lines, bool _replace = false)
    {
        m_FitterCols.Clear();
        var _types = lines[0].Split('\t');
        var _keys = lines[1].Split('\t');
        m_FitterCols.Add(0);
        m_Lines = lines;
        for (int i = 0; i < _types.Length; i++)
        {
            if (m_FileInfo.Name == "NPC.txt" && _types[i] == "int[]")
            {
                m_FitterCols.Add(i);
            }
            if (_types[i] == "int" || _types[i] == "int[]")
            {
                m_FitterCols.Add(i);
            }
        }
        for (int i = 0; i < _keys.Length; i++)
        {
            if (m_FileInfo.Name == "NPC.txt" && _keys[i] == "MODE")
            {
                m_FitterCols.Add(i);
            }
        }
        for (int i = 0; i < lines.Length; i++)
        {
            if (i < 3)
            {
                if (_replace)
                {
                    m_AllTexts[m_FileInfo] += lines[i];
                    m_AllTexts[m_FileInfo] += "\r\n";
                }
                continue;
            }
            FindEnglish(lines[i], _replace);
            EditorUtility.DisplayCancelableProgressBar("",
                      StringUtility.Contact(i, "/", lines.Length), (float)i / lines.Length);
        }
        if (_replace)
        {
            m_AllTexts[m_FileInfo] = m_AllTexts[m_FileInfo].Remove(m_AllTexts[m_FileInfo].Length - 2, 2);
        }
    }

    void FindEnglish(string line, bool _replace = false)
    {
        m_StringBuilder.Length = 0;
        var elements = line.Split('\t');
        for (int i = 0; i < elements.Length; i++)
        {
            if (m_FitterCols.Contains(i))
            {
                m_StringBuilder.Append(elements[i]);
                m_StringBuilder.Append('\t');
                continue;
            }
            var _label = elements[i];
            if (m_FitterKeys.Contains(_label.Trim()))
            {
                m_StringBuilder.Append(_label);
                m_StringBuilder.Append('\t');
                continue;
            }
            var _check = Regex.Replace(_label, "</r>", string.Empty);
            _check = Regex.Replace(_check, "<color=#[a-zA-Z0-9]+>", string.Empty);
            _check = Regex.Replace(_check, "</color>", string.Empty);
            _check = Regex.Replace(_check, "<size=[0-9]+>", string.Empty);
            _check = Regex.Replace(_check, "</size>", string.Empty);
            _check = Regex.Replace(_check, "<Word (.*?)/>", string.Empty);
            _check = Regex.Replace(_check, "<Img (.*?)/>", string.Empty);
            _check = Regex.Replace(_check, "<a>(.*?)</a>", string.Empty);
            _check = Regex.Replace(_check, "<Space=([0-9]*)>", string.Empty);
            _check = Regex.Replace(_check, "%s[0-9]+", string.Empty);
            MatchCollection _collection = Regex.Matches(_check, "[^a-zA-Z]*([a-zA-Z]+)[^a-zA-Z]*");
            if (_collection.Count > 0)
            {
                List<Match> _list = new List<Match>();
                for (int q = 0; q < _collection.Count; q++)
                {
                    _list.Add(_collection[q] as Match);
                }
                _list.Sort(Compare);
                for (int q = 0; q < _list.Count; q++)
                {
                    Match _match = _list[q];
                    if (m_FitterKeys.Contains(_match.Groups[1].Value))
                    {
                        continue;
                    }
                    if (_replace)
                    {
                        if (m_EnglishReplaces.ContainsKey(_match.Groups[1].Value))
                        {
                            _label = Regex.Replace(_label, _match.Groups[1].Value, m_EnglishReplaces[_match.Groups[1].Value]);
                        }
                    }
                    else if (!m_Englishs.ContainsKey(_match.Groups[1].Value))
                    {
                        m_Englishs.Add(_match.Groups[1].Value,
                            StringUtility.Contact(m_FileInfo.Name, "\t", "id:\t",
                           elements[0], "\t key:\t", m_Lines[1].Split('\t')[i].ToString(),
                            "\t", _match.Groups[1].Value));
                    }
                }
                m_StringBuilder.Append(_label);
                m_StringBuilder.Append('\t');
            }
            else
            {
                m_StringBuilder.Append(_label);
                m_StringBuilder.Append('\t');
            }
        }
        m_StringBuilder.Remove(m_StringBuilder.Length - 1, 1);
        m_AllTexts[m_FileInfo] += m_StringBuilder.ToString();
        m_AllTexts[m_FileInfo] += "\r\n";
    }

    int Compare(Match x, Match y)
    {
        return -x.Groups[1].Value.Length.CompareTo(y.Groups[1].Value.Length);
    }
}