# coding=utf-8
import os
import sys
import xlrd
import codecs
import collections
import json
import io

# 
def genLangJson (fileName, nameIdx, idx):
    data = xlrd.open_workbook(fileName)
    table = data.sheets()[0]
    rowNum = table.nrows                  # 行數(shù)
    colNum = table.ncols                  # 列數(shù)

    if colNum <= idx:
        return False
    
    lang = ''                                       #語言代號 從第0行讀取
    data = {}
    for lineIdx in range(rowNum):
        name  = table.cell(lineIdx,nameIdx).value   #第N行 的 key 值
        value = table.cell(lineIdx,idx).value       #第N行 的 對應(yīng)翻譯 
        if not name.strip():
            # 跳過沒有對應(yīng)token字體的文本
            continue

        if not value.strip():
            # 文本缺失
            print("For " + lang + "in line " + str(lineIdx+1) + "miss")
            continue

        if lineIdx == 0:
            # 首行
            lang = value                     # 語言代號en_us es_es
        else:
            # print("%s" % (value) )
            data[name] = value

    lang = lang#.encode("utf-8")
    print("lang:%s" % lang)

    # 文件結(jié)束翻斟，寫文件
    curPath  = os.path.dirname(os.path.abspath(__file__))
    jsonPath = os.path.join(curPath, "res", "lang1", lang, "text.txt")
    # jsonPath = curPath + "\\" + lang + "\\text.txt"
    
    # 生成文件夾
    dirname = os.path.dirname(jsonPath)
    if not os.path.exists(dirname):
        os.makedirs(dirname)

    with io.open(jsonPath, 'w', encoding='utf-8') as f:
        f.write(json.dumps(data, ensure_ascii=False, indent=4, sort_keys=True))

    return True

# 生成json翻譯文本
def makeJsonFile(fileName, tokenIdx, startIdx):
    idx = startIdx
    while (1):
        bret = genLangJson(fileName, tokenIdx, idx)      # 從左往右拆内，一列列讀取
        if (bret == False):
            break
        idx += 1

if __name__ == '__main__':

    # 自動查找excel文檔- 
    curPath = os.path.dirname(os.path.abspath(__file__))
    xlsFile = curPath + '\\lang.xlsx'

    print("xlsx file:%s" % xlsFile)

    # 各列位置（從0開始）
    tokenIdx = 0  # Token所在的列   key 值
    startIdx = 1  # 正式語言列
    # fntIdx = 3    # 字體列ttf_xx

    makeJsonFile(xlsFile, tokenIdx, startIdx)