Client/GameClient/Assets/Editor/Excel/Scanner/ItemApproachScanner.cs

using System.Collections.Generic;
using UnityEngine;
using GFGGame;
using System;

namespace GFGEditor
{
    /// <summary>
    /// 物品扫描器:
    /// 1.扫描获取途径，并填入物品表的获取途径字段
    /// 2.扫描套装部件个数
    /// </summary>
    public class ItemApproachScanner
    {

        private delegate string GetApproachCall(int itemId);


        public static void startScan()
        {
            ItemCfg[] dataArray = ItemCfgArray.Instance.dataArray;
            GetApproachCall[] actions = new GetApproachCall[] { GetClothingShopApproach, GetZhaiXingApproach, GetStoryLevelApproach, GetClothingSyntheticApproach, GetSuitGuideApproach, GetSuitSyntheticApproach };
            Dictionary<SuitCfg, List<int>> suitDic = new Dictionary<SuitCfg, List<int>>();
            int suitPartTotalCount = 0;
            foreach (ItemCfg cfg in dataArray)
            {
                HandleSuitTable(cfg, suitDic);
                HandleItemApproch(cfg, actions);
            }
            var globalCfg = GlobalCfgArray.globalCfg;
            SQLiteHelper.Instance.OpenConnection();
            try
            {
                //物品
                foreach (ItemCfg cfg in dataArray)
                {
                    var names = new string[] { nameof(cfg.subType), nameof(cfg.itemType), nameof(cfg.approach) };
                    var values = new string[] { "" + cfg.subType, "" + cfg.itemType, "" + cfg.approach };
                    SQLiteHelper.Instance.UpdateValues(nameof(ItemCfgArray), names, values, nameof(cfg.id), cfg.id.ToString());
                }
                //套装
                foreach (var a in suitDic)
                {
                    suitPartTotalCount += a.Value.Count;
                    var names = new string[] { nameof(a.Key.partsArr).Replace("Arr", "") };
                    var values = new string[] { string.Join(";", a.Value) };
                    SQLiteHelper.Instance.UpdateValues(nameof(SuitCfgArray), names, values, nameof(a.Key.id), a.Key.id.ToString());
                }
                globalCfg.suitPartTotalCount = suitPartTotalCount;
                UpdateGlobalCfg(globalCfg);
            }
            catch (Exception e)
            {
                ET.Log.Error(e.ToString());
            }
            finally
            {
                SQLiteHelper.Instance.CloseConnection();
            }
        }

        private static void UpdateGlobalCfg(GlobalCfg globalCfg)
        {
            var names = new string[] { nameof(globalCfg.suitPartTotalCount) };
            var values = new string[] { globalCfg.suitPartTotalCount.ToString() };
            SQLiteHelper.Instance.UpdateValues(nameof(GlobalCfgArray), names, values, nameof(globalCfg.id), globalCfg.id.ToString());
        }

        private static void HandleSuitTable(ItemCfg itemCfg, Dictionary<SuitCfg, List<int>> suitDic)
        {
            if (itemCfg.suitId <= 0)
            {
                return;
            }
            var suitCfg = SuitCfgArray.Instance.GetCfg(itemCfg.suitId);
            if(suitCfg == null)
            {
                return;
            }
            suitDic.TryGetValue(suitCfg, out var partsList);
            if(partsList == null)
            {
                partsList = new List<int>();
                suitDic[suitCfg] = partsList;
            }
            partsList.Add(itemCfg.id);
        }

        private static void HandleItemApproch(ItemCfg cfg, GetApproachCall[] actions)
        {
            List<string> approachs = new List<string>();
            foreach (GetApproachCall action in actions)
            {
                string tempApproach = action(cfg.id);
                if (tempApproach != null)
                {
                    approachs.Add(tempApproach);
                }
            }

            if (approachs.Count > 0)
            {
                string approach = string.Join(";", approachs);
                cfg.approach = approach;
                if (approachs.Count > 5)
                {
                    Debug.LogFormat("物品{0}的获取途径为 {1}", cfg.name, approach);
                }
            }
            else
            {
                if (cfg.id < 1000000 || cfg.id >= 2000000)
                {
                    if ((!cfg.name.Contains("原始") && !cfg.name.Contains("默认")) || cfg.id >= 1000000)
                    {
                        //Debug.LogErrorFormat("物品 {0} {1} 没有获取途径", cfg.id, cfg.name);
                    }
                }
            }
        }

        /// <summary>
        /// 尝试获取服装店产出途径
        /// </summary>
        /// <param name="itemId"></param>
        /// <returns></returns>
        private static string GetClothingShopApproach(int itemId)
        {
            ShopCfgClothingArray manager = ShopCfgClothingArray.Instance;
            ShopCfg[] dataArray = manager.dataArray;
            foreach (ShopCfg cfg in dataArray)
            {
                if (cfg.itemID == itemId)
                {
                    return "FU_ZHUANG_DIAN";
                }
            }
            return null;
        }

        /// <summary>
        /// 尝试获取摘星（抽奖）产出途径
        /// </summary>
        /// <param name="itemId"></param>
        /// <returns></returns>
        private static string GetZhaiXingApproach(int itemId)
        {
            LuckyBoxCfgArray manager = LuckyBoxCfgArray.Instance;
            LuckyBoxCfg[] dataArray = manager.dataArray;
            if (itemId == 10090)
            {
                Debug.Log("");
            }
            foreach (LuckyBoxCfg cfg in dataArray)
            {
                for (int i = 0; i < cfg.bonusArr.Length; i++)
                {
                    int dropId = cfg.bonusArr[i][0];
                    bool approach = CheckDropApproach(itemId, dropId);
                    if (approach)
                    {
                        return "ZHAI_XING";
                    }
                }
            }
            return null;
        }

        /// <summary>
        /// 尝试获取剧情关卡产出途径
        /// </summary>
        /// <param name="itemId"></param>
        /// <returns></returns>
        private static string GetStoryLevelApproach(int itemId)
        {
            List<string> approachs = new List<string>();
            StoryLevelCfgArray manager = StoryLevelCfgArray.Instance;
            StoryLevelCfg[] dataArray = manager.dataArray;
            foreach (StoryLevelCfg cfg in dataArray)
            {
                bool result = CheckItemInBonus(itemId, cfg);
                if (result)
                {
                    string approach = "JU_QING_GUAN_QIA=" + cfg.id;
                    approachs.Add(approach);
                }
            }
            if (approachs.Count > 0)
            {
                return string.Join(";", approachs);
            }
            return null;
        }

        /// <summary>
        /// 尝试获取服装合成产出途径
        /// </summary>
        /// <param name="itemId"></param>
        /// <returns></returns>
        private static string GetClothingSyntheticApproach(int itemId)
        {
            var itemCfg = ItemCfgArray.Instance.GetCfg(itemId);
            if(itemCfg == null)
            {
                return null;
            }
            if(itemCfg.suitId <= 0)
            {
                return null;
            }
            var suitCfg = SuitCfgArray.Instance.GetCfg(itemCfg.suitId);
            if(suitCfg == null)
            {
                return null;
            }
            if(suitCfg.syntheticType <= 0)
            {
                return null;
            }
            return "FU_ZHUANG_HE_CHENG=" + suitCfg.id;
        }

        private static string GetSuitGuideApproach(int itemId)
        {
            SuitCfgArray manager = SuitCfgArray.Instance;
            SuitCfg[] dataArray = manager.dataArray;
            foreach (SuitCfg cfg in dataArray)
            {
                bool result = CheckItemInBonus(itemId, cfg.guideBoxBonusArr);
                if (result)
                {
                    return "TAO_ZHUANG_TU_JIAN";
                }
            }
            return null;
        }

        private static string GetSuitSyntheticApproach(int itemId)
        {

            var itemCfg = ItemCfgArray.Instance.GetCfg(itemId);
            if (itemCfg == null)
            {
                return null;
            }
            if (itemCfg.suitId <= 0)
            {
                return null;
            }
            var suitCfg = SuitCfgArray.Instance.GetCfg(itemCfg.suitId);
            if (suitCfg == null)
            {
                return null;
            }
            if (suitCfg.syntheticType <= 0)
            {
                return null;
            }
            bool result = CheckItemInBonus(itemId, suitCfg.syntheticBoxBonusArr);
            if (result)
            {
                return "TAO_ZHUANG_HE_CHENG";
            }
            return null;
        }

        /// <summary>
        /// 检测掉落表是否产出该物品
        /// </summary>
        /// <param name="itemId"></param>
        /// <returns></returns>
        private static bool CheckDropApproach(int itemId, int dropId)
        {
            DropOutCfgArray manager = DropOutCfgArray.Instance;
            List<DropOutCfg> dataArray = manager.GetCfgs(dropId);
            for (int i = 0; i < dataArray.Count; i++)
            {
                if (dataArray[i].item == itemId)
                {
                    return true;
                }
                if (manager.GetCfgs(dataArray[i].item).Count > 0)
                {

                    return CheckDropApproach(itemId, dataArray[i].item);
                }
            }
            return false;
        }

        private static bool CheckItemInBonus(int itemId, StoryLevelCfg cfg)
        {
            if (cfg.fightID.Length > 0)
            {
                StoryFightCfgArray manager = StoryFightCfgArray.Instance;
                StoryFightCfg storyFightCfg = manager.GetCfg(cfg.fightID);
                List<int[]> a = new List<int[]>();
                a.AddRange(cfg.bonusOnceArr);
                a.AddRange(storyFightCfg.bonusBaseArr);
                int[][] bonus = a.ToArray();
                bool result = CheckItemInBonus(itemId, bonus);
                if (result)
                {
                    return true;
                }
                result = CheckItemInDropOut(itemId, storyFightCfg.bonusRandomArr);
                return result;
            }

            return false;
        }

        private static bool CheckItemInBonus(int itemId, int[][] bosnu)
        {
            List<ItemData> aList = ItemUtil.CreateItemDataList(bosnu);
            foreach (ItemData itemData in aList)
            {
                if (itemId == itemData.id)
                {
                    return true;
                }
            }
            return false;
        }

        private static bool CheckItemInDropOut(int itemId, int[] dropIds)
        {
            List<ItemData> result = new List<ItemData>();
            foreach (int dropId in dropIds)
            {
                DropOutCfgArray manager = DropOutCfgArray.Instance;
                List<DropOutCfg> aList = manager.GetCfgs(dropId);
                foreach (DropOutCfg dropOutCfg in aList)
                {
                    if (itemId == dropOutCfg.item)
                    {
                        return true;
                    }
                }
            }
            return false;
        }

    }
}