#修改表頭
def xmind_to_zentao_csv_file(xmind_file):
    """Convert XMind file to a zentao csv file"""
    xmind_file = get_absolute_path(xmind_file)  #路徑處理
    logging.info('Start converting XMind file(%s) to zentao file...', xmind_file)
    testcases = get_xmind_testcase_list(xmind_file) #解析xmind文檔，得到原始數(shù)據(jù)
    # print("testcases",testcases)
    #fileheader =      ["所屬模塊","用例標(biāo)題","前置條件","步驟", "預(yù)期", "關(guān)鍵詞>用例狀態(tài)", "優(yōu)先級", "用例類型", "適用階段?"]
    fileheader_tapd = ["用例目錄","用例名稱","需求ID","前置條件","用例步驟","預(yù)期結(jié)果","用例類型","用例狀態(tài)","用例等級","創(chuàng)建人","測試結(jié)果","備注說明"]
 
    zentao_testcase_rows = [fileheader_tapd]
    for testcase in testcases:
        #row = gen_a_testcase_row(testcase)
        row = gen_a_testcase_row_tapd(testcase)
        zentao_testcase_rows.append(row)
    zentao_file = xmind_file[:-6] + '.csv'
    if os.path.exists(zentao_file):  #判斷括號里的文件是否存在
        os.remove(zentao_file)
        # logging.info('The zentao csv file already exists, return it directly: %s', zentao_file)
        # return zentao_file
 
    with open(zentao_file, 'w', encoding='utf8') as f:
        writer = csv.writer(f)
        writer.writerows(zentao_testcase_rows)
        logging.info('Convert XMind file(%s) to a zentao csv file(%s) successfully!', xmind_file, zentao_file)
 
    return zentao_file
    
#修改為tapd的數(shù)據(jù)格式、增加獲取需求ID
def gen_a_testcase_row_tapd(testcase_dict):
 
    #用例標(biāo)題
    case_title = testcase_dict['name']
    #需求ID         產(chǎn)品名稱里的目錄獲取  
    requirement_id, product_catalog = gen_requirement_id(testcase_dict['product'])
    # 所屬模塊
    case_module =product_catalog +"-" + gen_case_module(testcase_dict['suite'])
 
    #前置條件
    case_precontion = testcase_dict['preconditions']
    #步驟       預(yù)期結(jié)果
    case_step, case_expected_result = gen_case_step_and_expected_result(testcase_dict['steps'])
    #用例類型
    case_type = gen_case_type(testcase_dict['execution_type'])
    # case_type = "功能測試"
    #用例狀態(tài)
    case_status = "正常"
    #用例等級
    case_priority = gen_case_priority(testcase_dict['importance'])
    #創(chuàng)建人
    case_created_by = ""
    #測試結(jié)果
    case_actual_result= ""
 
    row = [case_module,case_title,requirement_id,case_precontion,case_step,case_expected_result,case_type,case_status,case_priority,case_created_by,case_actual_result]
    return row
 
#修改用例類型
def get_execution_type(topics):
    labels = [topic.get('label', '') for topic in topics]
    labels = filter_empty_or_ignore_element(labels)
    exe_type = 1
    for item in labels[::-1]:
        if item.lower() in ['性能測試', '性能']:
            exe_type = 2
            break
        if item.lower() in ['功能測試', '功能']:
            exe_type = 1
            break
        if item.lower() in ['安全測試', '安全','安全性測試']:
            exe_type = 3
            break
        if item.lower() in ['其他']:
            exe_type = 4
            break
    return exe_type