public void DrawUI()
{
EditorGUILayout.Space();
EditorGUILayout.BeginHorizontal();
EditorGUILayout.TextField("", LocalSaveManager.GetString(outputSaveKey, "", false));
if (GUILayout.Button("选择"))
{
string tempOutputPath = EditorUtility.OpenFolderPanel("选择导出目录", LocalSaveManager.GetString(outputSaveKey, "", false), "xlsx");
LocalSaveManager.Save(outputSaveKey, tempOutputPath, false);
}
if (GUILayout.Button("导出数据"))
{
OutputExcel();
}
EditorGUILayout.EndHorizontal();
EditorGUILayout.Space();
EditorGUILayout.BeginHorizontal();
EditorGUILayout.TextField("", LocalSaveManager.GetString(inputSaveKey, "", false));
if (GUILayout.Button("选择"))
{
string tempOutputPath = EditorUtility.OpenFolderPanel("选择导入目录", LocalSaveManager.GetString(inputSaveKey, "", false), "");
LocalSaveManager.Save(inputSaveKey, tempOutputPath, false);
}
if (GUILayout.Button("导入数据"))
{
InputExcel();
}
EditorGUILayout.EndHorizontal();
}
/// <summary>
/// 删除无用的行数
/// 这里单独写一个方法而不放到导入里的原因是，比如当前这个表已经给外包翻译了，但是代码中删除了一些字段，
/// 会造成新生成的表和之前的对不上，单列一个方法，没事的时候手动删一下
/// </summary>
private void DeleteUnUseRows()
{
string path = LocalSaveManager.GetString(inputSaveKey, "", false);
if (path == "")
{
EditorUtility.DisplayDialog("路径不能为空", "", "确定");
return;
}
string filePath = path + "/" + excelName;
FileInfo fileInfo = new FileInfo(filePath);
List <int> deleteRowList = new List <int>();
using (ExcelPackage destPackage = new ExcelPackage(fileInfo))
{
ExcelWorksheet worksheet = destPackage.Workbook.Worksheets[sheetName];
//代码中的key放入set
HashSet <string> codeSet = new HashSet <string>();
FieldInfo[] fieldInfos = typeof(LanguageSet).GetFields();
for (int i = 0; i < fieldInfos.Length; i++)
{
codeSet.Add(fieldInfos[i].Name);
}
for (int i = DataManager.startRow; i <= worksheet.Dimension.Rows; i++)
{
if (worksheet.Cells[i, 1].Value == null)
{
break;
}
else
{
string key = worksheet.Cells[i, 1].Value.ToString();
if (!codeSet.Contains(key))
{
deleteRowList.Add(i);
}
}
}
//删除，每次删除下面的都会上来，所以这里特殊处理一下
int deleteIndex = 0;
foreach (var item in deleteRowList)
{
worksheet.DeleteRow(item - deleteIndex);
deleteIndex++;
}
destPackage.Save();
}
if (deleteRowList.Count == 0)
{
Debug.Log("无删除项");
}
else
{
Debug.Log("删除" + deleteRowList.Count + "项");
}
Debug.Log("完成");
}
private void InputExcel()
{
string path = LocalSaveManager.GetString(inputSaveKey, "", false);
if (path == "")
{
EditorUtility.DisplayDialog("路径不能为空", "路径不能为空", "确定");
return;
}
string filePath = path + "/" + excelName;
byte[] bytes = ExcelTools.Excel2Bytes(filePath, sheetName);
File.WriteAllBytes(LanguageEditorWindow.projectBytesPath + "/" + sheetName + ".bytes", bytes);
Debug.Log("生成完成");
}
public void LoadConfigs()
{
m_logTMP.SetText("LoadConfigs");
SettingDataA data = LocalSaveManager.TempLoad <SettingDataA>();
if (null == data)
{
m_data = (SettingDataA)SettingDataA.GetDefaultSetting();
}
else
{
m_data = data;
}
m_languageDropDownItem.SetData((int)m_data.Language);
m_volumeItem.SetData(m_data.Volume);
}
//----------------------------------------------------------------------------
/*!
* @brief セーブ操作：セーブデータ破棄
*/
//----------------------------------------------------------------------------
static public void ExecDataDelete()
{
#if BUILD_TYPE_DEBUG
Debug.Log(">Call LocalSaveUtil Delete()");
#endif
PlayerPrefs.DeleteAll();
//----------------------------------------
// 破棄後にセーブデータバージョンが消滅する。
// これが消滅したままほっておくと、
// 次の起動時にResidentManagerの生成タイミングで全セーブデータが破棄される。
//
// ちゃんと今の起動状態からセーブされるように、
// 安全策のためセーブデータのセーフティを噛ませておく
//----------------------------------------
LocalSaveManager.SaveVersionSafety();
}
/*==========================================================================*/
/* func */
/*==========================================================================*/
//----------------------------------------------------------------------------
/*!
* @brief Unity固有処理：初期化処理 ※初回のUpdateを呼び出す直前に呼出し
*/
//----------------------------------------------------------------------------
protected override void Start()
{
base.Start();
//--------------------------------
// 回転制御許可設定
//--------------------------------
Screen.orientation = ScreenOrientation.AutoRotation;
Screen.autorotateToPortrait = true;
Screen.autorotateToPortraitUpsideDown = true;
Screen.autorotateToLandscapeLeft = false;
Screen.autorotateToLandscapeRight = false;
#if true
//--------------------------------
// ビルド情報をログ出力。
//
// マスター版で焼いた際にログが出なくて、
// それぞれのシンボル情報の確証が得にくいので情報として出しておく
//--------------------------------
string strApplicationSymbolData = "BuildParam - ";
#if UNITY_IPHONE
strApplicationSymbolData += " Platform:iOS , ";
#elif UNITY_ANDROID
strApplicationSymbolData += " Platform:Android , ";
#else
strApplicationSymbolData += " Platform:????? , ";
#endif
#if BUILD_TYPE_DEBUG
strApplicationSymbolData += " BuildType:debug , ";
#else
strApplicationSymbolData += "";
#endif
#if STORE_SIMULATION
strApplicationSymbolData += " Store:disable , ";
#else
strApplicationSymbolData += " Store:enable , ";
#endif
#if _MASTER_BUILD
strApplicationSymbolData += " Master:On , ";
#else
strApplicationSymbolData += " Master:Off , ";
#endif
UnityEngine.Debug.Log(strApplicationSymbolData);
#endif
#if BUILD_TYPE_DEBUG && UNITY_EDITOR
//--------------------------------
//
//--------------------------------
Application.runInBackground = true;
#endif // #if BUILD_TYPE_DEBUG && UNITY_EDITOR
//--------------------------------
// staticパラメータのクリア
//--------------------------------
ResidentParam.ParamReset();
//--------------------------------
// マルチタッチ無効
//--------------------------------
Input.multiTouchEnabled = false;
//--------------------------------
// 負荷軽減モードの適用分岐
//--------------------------------
if (SystemUtil.GetLoadReductionMode() == true)
{
ResidentParam.m_OptionWorkLoadLevel = 1;
}
else
{
ResidentParam.m_OptionWorkLoadLevel = 0;
}
#if BUILD_TYPE_DEBUG
#if DEBUG_LOG
m_ManagerMemoryLog = MemoryLogManager.getInstance();
#endif // DEBUG_LOG
#endif
//--------------------------------
// ローカルのセーブ情報をユーザークラスに譲渡するためロード実行
//--------------------------------
if (LocalSaveManager.Instance != null)
{
// 2015/07/15 k_iida V280 招待機能先送りに伴い封印する V290復活予定.
// LocalSaveStorage.Instance.InitLocalSaveStorage( "DivineGate" );
LocalSaveManager.SaveVersionSafety();
LocalSaveManager.Instance.LoadFuncUUID();
LocalSaveManager.Instance.LoadFuncLocalData();
// LocalSaveManager.Instance.LoadFuncRestore();
}
else
{
Debug.LogError("LocalSaveManager None!");
}
//--------------------------------
// Prime31 PlayGameServices 初期化処理
//--------------------------------
PlayGameServiceUtil.InitPlayGameService();
//--------------------------------
// サーバープッシュ通知初期化
// @add Developer 2016/10/31
//--------------------------------
RemoteNotificationManager.Init();
}
public void SaveConfigs()
{
m_logTMP.SetText("SaveConfigs");
m_data.SetDataWa(m_volumeItem.GetData(), m_languageDropDownItem.GetData());
LocalSaveManager.TempSave <SettingDataA>(m_data);
}
private void OutputExcel()
{
string outputPath = LocalSaveManager.GetString(outputSaveKey, "", false);
if (outputPath == "")
{
EditorUtility.DisplayDialog("路径不能为空", "路径不能为空", "确定");
return;
}
string filePath = outputPath + "/" + excelName;
FileInfo fileInfo = new FileInfo(filePath);
bool isChange = false;
using (ExcelPackage package = new ExcelPackage(fileInfo))
{
ExcelWorksheet sheet = null;
if (package.Workbook.Worksheets.Count == 0)
{
sheet = package.Workbook.Worksheets.Add(sheetName);
LanguageEditorWindow.InitSheet(sheet);
}
else
{
sheet = package.Workbook.Worksheets[sheetName];
}
int newRow = DataManager.startRow;
if (sheet.Dimension.Rows > newRow)
{
newRow = sheet.Dimension.Rows + 1;
}
int cols = sheet.Dimension.Columns;
Dictionary <string, string> excelDict = GetCodeExcelDic(sheet, ref newRow);
FieldInfo[] fieldInfos = typeof(LanguageSet).GetFields();
for (int i = 0; i < fieldInfos.Length; i++)
{
string keyName = fieldInfos[i].Name;
string valueName = TransforEscape(fieldInfos[i].GetValue(null).ToString());
if (excelDict.ContainsKey(keyName))
{
//如果出现代码和excel的key相同，但是value不一致，则输出一条错误
//这里不能去随意替换，因为并不能确定哪方是对的
//比如翻译人员发现一个字写错了直接改了，虽然这种行为是禁止的，但是还是选择不相信
if (!excelDict[keyName].Equals(valueName))
{
Debug.LogError("excelDict[keyName]===" + excelDict[keyName]);
Debug.LogError("valueName===" + valueName);
Debug.LogError("keyName===" + keyName + "->这个主键的值变了");
Debug.LogError("--------------");
}
}
else
{
if (newRow > sheet.Dimension.Rows)
{
sheet.InsertRow(newRow, 1);
}
sheet.Cells[newRow, 1].Value = keyName;
sheet.Cells[newRow, 2].Value = valueName;
for (int j = 1; j <= cols; j++)
{
sheet.Cells[newRow, j].Style.Border.BorderAround(ExcelBorderStyle.Thin);
}
newRow++;
isChange = true;
}
}
package.Save();
}
if (!isChange)
{
Debug.Log("无新增项");
}
Debug.Log("成功");
}
public void DeleteSettingA()
{
LocalSaveManager.TempDelete <SettingDataA>();
}
/// <summary>
/// API結果：成功：ユーザー削除
/// </summary>
void SendUserRenewSuccess(ServerApi.ResultData _data)
{
//----------------------------------------
// 情報反映
//----------------------------------------
#if BUILD_TYPE_DEBUG
Debug.LogError("UUID Renew : " + m_RenewUUID);
#endif
//----------------------------------------
// ローカルセーブを破棄して再構築
//----------------------------------------
LocalSaveManager.LocalSaveRenew(false, false);
//----------------------------------------
// FoxSDKの仕様による進行不可回避
//----------------------------------------
#if BUILD_TYPE_DEBUG
Debug.Log("FoxSDK Safety");
#endif
LocalSaveManager.Instance.SaveFuncInformationOK(LocalSaveManager.AGREEMENT.FOX_CALLED);
//----------------------------------------
// UUID記憶
//----------------------------------------
LocalSaveManager.Instance.SaveFuncUUID(m_RenewUUID);
LocalSaveManager.Instance.SaveFuncTitleUUID();
UserDataAdmin.Instance.m_StructPlayer = _data.UpdateStructPlayer <RecvRenewUser>(UserDataAdmin.Instance.m_StructPlayer);
UserDataAdmin.Instance.m_StructSystem = _data.GetResult <RecvRenewUser>().result.system;
UserDataAdmin.Instance.ConvertPartyAssing();
//----------------------------------------
// メインメニューパラメータクリア
//----------------------------------------
MainMenuParam.ParamReset();
MainMenuHeader.ParamReset();
ResidentParam.ParamResetUserRenew();
//----------------------------------------
// 共有パラメータクリア
//----------------------------------------
if (UserDataAdmin.Instance != null)
{
UserDataAdmin.Instance.ParamReset();
}
MainMenuManager.s_LastLoginTime = 0;
// 完了ダイアログ
Dialog newDialog = Dialog.Create(DialogType.DialogOK);
newDialog.SetDialogTextFromTextkey(DialogTextType.Title, "he179q_title");
newDialog.SetDialogTextFromTextkey(DialogTextType.MainText, "he179q_content");
newDialog.SetDialogTextFromTextkey(DialogTextType.OKText, "common_button1");
newDialog.SetDialogEvent(DialogButtonEventType.OK, new System.Action(() =>
{
LoadingManager.Instance.RequestLoadingStart(LOADING_TYPE.GUARD);
StartCoroutine(SQLiteClient.Instance.LocalSqlite3ClearExec(() =>
{
LoadingManager.Instance.RequestLoadingFinish(LOADING_TYPE.GUARD);
//----------------------------------------
// 初回起動時の動作を想定してタイトルに戻る
//----------------------------------------
SceneCommon.Instance.GameToTitle();
}));
}));
newDialog.EnableFadePanel();
newDialog.DisableCancelButton();
newDialog.Show();
}
public void DrawUI()
{
EditorGUILayout.Space();
if (GUILayout.Button("添加需要多语言功能的prefab文件夹"))
{
string path = EditorUtility.OpenFolderPanel("选择导出目录", Application.dataPath, "");
pathList.Add(path);
LocalSaveManager.Save(folderSaveKey, JsonMapper.ToJson(pathList), false);
}
EditorGUILayout.Space();
EditorGUILayout.Space();
for (int i = 0, count = pathList.Count; i < count; i++)
{
EditorGUILayout.BeginHorizontal();
EditorGUILayout.LabelField(pathList[i]);
if (GUILayout.Button("删除"))
{
removeName = pathList[i];
}
EditorGUILayout.EndHorizontal();
}
if (removeName != "")
{
pathList.Remove(removeName);
LocalSaveManager.Save(folderSaveKey, JsonMapper.ToJson(pathList), false);
removeName = "";
}
EditorGUILayout.Space();
EditorGUILayout.Space();
EditorGUILayout.BeginHorizontal();
EditorGUILayout.TextField("", LocalSaveManager.GetString(outputSaveKey, "", false));
if (GUILayout.Button("选择"))
{
string tempOutputPath = EditorUtility.OpenFolderPanel("选择导出目录", LocalSaveManager.GetString(outputSaveKey, "", false), "xlsx");
LocalSaveManager.Save(outputSaveKey, tempOutputPath, false);
}
if (GUILayout.Button("导出数据"))
{
OutputExcel();
}
EditorGUILayout.EndHorizontal();
EditorGUILayout.Space();
EditorGUILayout.BeginHorizontal();
EditorGUILayout.TextField("", LocalSaveManager.GetString(inputSaveKey, "", false));
if (GUILayout.Button("选择"))
{
string tempOutputPath = EditorUtility.OpenFolderPanel("选择导入目录", LocalSaveManager.GetString(inputSaveKey, "", false), "");
LocalSaveManager.Save(inputSaveKey, tempOutputPath, false);
}
if (GUILayout.Button("导入数据"))
{
InputExcel();
}
EditorGUILayout.EndHorizontal();
}
public void Init()
{
pathList = JsonMapper.ToObject <List <string> >(LocalSaveManager.GetString(folderSaveKey, "[]", false));
}
/// <summary>
/// 删除无用的行数,做法是先拿到表里所有的value对应的row，然后遍历所有Prefab中文，在dic中存在就直接删掉，剩下的就是没用的
/// 这里单独写一个方法而不放到导入里的原因是，比如当前这个表已经给外包翻译了，但是代码中删除了一些字段，
/// 会造成新生成的表和之前的对不上，单列一个方法，没事的时候手动删一下
/// </summary>
private void DeleteUnUseRows()
{
string path = LocalSaveManager.GetString(inputSaveKey, "", false);
if (path == "")
{
EditorUtility.DisplayDialog("路径不能为空", "", "确定");
return;
}
string[] prefabPaths = AssetDatabase.FindAssets("t:prefab", pathList.ToArray());
FileInfo fileInfo = new FileInfo(path + "/" + sheetName);
Dictionary <string, int> value2RowDic = new Dictionary <string, int>();
using (ExcelPackage package = new ExcelPackage(fileInfo))
{
ExcelWorksheet sheet = package.Workbook.Worksheets[sheetName];
for (int i = DataManager.startRow; i <= sheet.Dimension.Rows; i++)
{
if (sheet.Cells[i, 1].Value == null)
{
break;
}
string value = sheet.Cells[i, 2].Value.ToString();
value2RowDic.Add(value, i);
}
//遍历所有prefab
for (int i = 0; i < prefabPaths.Length; i++)
{
string name = AssetDatabase.GUIDToAssetPath(prefabPaths[i]);
//一些不想翻译的
if (name.Contains("UITest"))
{
continue;
}
GameObject obj = (GameObject)AssetDatabase.LoadMainAssetAtPath(name);
Text[] texts = obj.GetComponentsInChildren <Text>(true);
for (int j = 0; j < texts.Length; j++)
{
Text text = texts[j];
if (!LanguageManager.IsHaveChinese(text.text))
{
continue;
}
string value = text.text;
//如果在prefab中，限制了文字范围，那么ngui会在折行处添加\r，所以要去掉
value = value.Replace("\r", "");
if (value2RowDic.ContainsKey(value))
{
value2RowDic.Remove(value);
}
}
}
//删除
int index = 0;
//行数从小到大排序,因为他这个删除是会自动把下一行移上来，所以需要特殊处理
List <int> list = value2RowDic.Values.ToList();
list.Sort((x, y) =>
{
return(x.CompareTo(y));
});
foreach (var item in list)
{
sheet.DeleteRow(item - index);
index++;
}
package.Save();
}
if (value2RowDic.Count == 0)
{
Debug.Log("无删除项");
}
else
{
Debug.Log("删除" + value2RowDic.Count + "项");
}
Debug.Log("完成");
}
private void OutputExcel()
{
string outputPath = LocalSaveManager.GetString(outputSaveKey, "", false);
if (outputPath == "")
{
EditorUtility.DisplayDialog("路径不能为空", "路径不能为空", "确定");
return;
}
//string[] stringsPrefab = AssetDatabase.FindAssets("t:prefab", new string[] { "Assets/Resources/prefab", "Assets/Resources/beginAsset" });
string[] prefabPaths = AssetDatabase.FindAssets("t:prefab", pathList.ToArray());
bool isChange = false;
FileInfo fileInfo = new FileInfo(outputPath + "/" + sheetName);
using (ExcelPackage package = new ExcelPackage(fileInfo))
{
ExcelWorksheet sheet = null;
if (package.Workbook.Worksheets.Count == 0)
{
sheet = package.Workbook.Worksheets.Add(sheetName);
LanguageEditorWindow.InitSheet(sheet);
}
else
{
sheet = package.Workbook.Worksheets[sheetName];
}
int newRow = DataManager.startRow;
if (sheet.Dimension.Rows > newRow)
{
newRow = sheet.Dimension.Rows + 1;
}
int cols = sheet.Dimension.Columns;
Dictionary <string, string> key2ValueDic = new Dictionary <string, string>();
Dictionary <string, string> value2KeyDic = new Dictionary <string, string>();
for (int i = DataManager.startRow; i <= sheet.Dimension.Rows; i++)
{
if (sheet.Cells[i, 1].Value == null)
{
newRow = i;
break;
}
string key = sheet.Cells[i, 1].Value.ToString();
string value = sheet.Cells[i, 2].Value.ToString();
key2ValueDic.Add(key, value);
value2KeyDic.Add(value, key);
}
for (int i = 0; i < prefabPaths.Length; i++)
{
string name = AssetDatabase.GUIDToAssetPath(prefabPaths[i]);
//一些不想翻译的
if (name.Contains("UITest"))
{
continue;
}
GameObject obj = (GameObject)AssetDatabase.LoadMainAssetAtPath(name);
int index = 1;
Text[] texts = obj.GetComponentsInChildren <Text>(true);
for (int j = 0; j < texts.Length; j++)
{
Text text = texts[j];
if (!LanguageManager.IsHaveChinese(text.text))
{
continue;
}
string value = text.text;
//如果在prefab中，限制了文字范围，那么ngui会在折行处添加\r，所以要去掉
value = value.Replace("\r", "");
//如果excel中没有对应中文，就新加一条
if (!value2KeyDic.ContainsKey(value))
{
isChange = true;
if (newRow > sheet.Dimension.Rows)
{
sheet.InsertRow(newRow, 1);
}
sheet.Cells[newRow, 1].Value = GetKey(key2ValueDic, obj.name, index);;
sheet.Cells[newRow, 2].Value = value;
for (int k = 1; k <= cols; k++)
{
sheet.Cells[newRow, k].Style.Border.BorderAround(ExcelBorderStyle.Thin);
}
newRow++;
}
}
}
package.Save();
}
if (!isChange)
{
Debug.Log("无新增项");
}
Debug.Log("完成");
}
