tanqiu/assets/resources/data/excel/verify_sync.py

#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
验证Excel文件与JSON文件的同步状态
"""

import json
import pandas as pd
from pathlib import Path

def load_json_data():
    """加载JSON数据"""
    json_file = Path('../enemies.json')
    try:
        with open(json_file, 'r', encoding='utf-8') as f:
            return json.load(f)
    except Exception as e:
        print(f"❌ 加载JSON文件失败: {e}")
        return None

def load_excel_data():
    """加载Excel数据"""
    excel_file = Path('敌人配置表.xlsx')
    if not excel_file.exists():
        print(f"❌ Excel文件不存在: {excel_file}")
        return None
    
    try:
        # 读取所有工作表
        excel_data = pd.read_excel(excel_file, sheet_name=None)
        return excel_data
    except Exception as e:
        print(f"❌ 加载Excel文件失败: {e}")
        return None

def verify_basic_config(json_data, excel_data):
    """验证基础配置"""
    print("\n🔍 验证敌人基础配置...")
    
    json_enemies = {enemy['id']: enemy for enemy in json_data.get('enemies', [])}
    excel_basic = excel_data.get('敌人基础配置')
    
    if excel_basic is None:
        print("❌ Excel中缺少'敌人基础配置'工作表")
        return False
    
    success = True
    for _, row in excel_basic.iterrows():
        enemy_id = row['敌人ID']
        if enemy_id not in json_enemies:
            print(f"❌ Excel中的敌人ID '{enemy_id}' 在JSON中不存在")
            success = False
            continue
        
        json_enemy = json_enemies[enemy_id]
        
        # 验证关键字段
        checks = [
            ('敌人名称', json_enemy['name']),
            ('敌人类型', json_enemy['type']),
            ('生命值', json_enemy['stats']['health']),
            ('攻击力', json_enemy['stats']['attack']),
            ('防御力', json_enemy['stats']['defense']),
            ('移动速度', json_enemy['stats']['speed'])
        ]
        
        for field, expected in checks:
            actual = row[field]
            if actual != expected:
                print(f"⚠️  {enemy_id} 的 {field}: Excel={actual}, JSON={expected}")
                success = False
    
    if success:
        print("✅ 敌人基础配置验证通过")
    return success

def verify_visual_config(json_data, excel_data):
    """验证视觉配置"""
    print("\n🎬 验证视觉配置...")
    
    json_enemies = {enemy['id']: enemy for enemy in json_data.get('enemies', [])}
    excel_visual = excel_data.get('视觉配置')
    
    if excel_visual is None:
        print("❌ Excel中缺少'视觉配置'工作表")
        return False
    
    success = True
    animation_count = 0
    
    for _, row in excel_visual.iterrows():
        enemy_id = row['敌人ID']
        if enemy_id not in json_enemies:
            continue
        
        json_visual = json_enemies[enemy_id].get('visualConfig', {})
        
        # 验证精灵路径
        sprite_path = row['精灵路径']
        expected_sprite = json_visual.get('spritePath', '')
        
        if sprite_path != expected_sprite:
            print(f"⚠️  {enemy_id} 精灵路径不匹配: Excel={sprite_path}, JSON={expected_sprite}")
            success = False
        
        # 检查动画路径格式
        if '@EnemyAni' in sprite_path:
            animation_count += 1
            print(f"  ✅ {enemy_id}: {sprite_path}")
        else:
            print(f"  ⚠️  {enemy_id}: 动画路径格式不正确 - {sprite_path}")
            success = False
        
        # 验证动画配置
        animations = json_visual.get('animations', {})
        animation_fields = ['待机动画', '行走动画', '攻击动画', '死亡动画']
        animation_keys = ['idle', 'walk', 'attack', 'death']
        
        for field, key in zip(animation_fields, animation_keys):
            excel_anim = row[field]
            json_anim = animations.get(key, '')
            if excel_anim != json_anim:
                print(f"⚠️  {enemy_id} {field}不匹配: Excel={excel_anim}, JSON={json_anim}")
                success = False
    
    print(f"\n📊 动画配置统计: {animation_count}/11 个敌人配置了EnemyAni动画路径")
    
    if success:
        print("✅ 视觉配置验证通过")
    return success

def verify_combat_config(json_data, excel_data):
    """验证战斗配置"""
    print("\n⚔️  验证战斗配置...")
    
    json_enemies = {enemy['id']: enemy for enemy in json_data.get('enemies', [])}
    excel_combat = excel_data.get('战斗配置')
    
    if excel_combat is None:
        print("❌ Excel中缺少'战斗配置'工作表")
        return False
    
    success = True
    attack_types = set()
    
    for _, row in excel_combat.iterrows():
        enemy_id = row['敌人ID']
        if enemy_id not in json_enemies:
            continue
        
        json_combat = json_enemies[enemy_id].get('combat', {})
        
        # 验证攻击类型
        attack_type = row['攻击类型']
        expected_type = json_combat.get('attackType', 'melee')
        attack_types.add(attack_type)
        
        if attack_type != expected_type:
            print(f"⚠️  {enemy_id} 攻击类型不匹配: Excel={attack_type}, JSON={expected_type}")
            success = False
        
        # 验证武器类型
        weapon_type = row['武器类型']
        expected_weapon = json_combat.get('weaponType', 'none')
        
        if weapon_type != expected_weapon:
            print(f"⚠️  {enemy_id} 武器类型不匹配: Excel={weapon_type}, JSON={expected_weapon}")
            success = False
    
    print(f"\n📊 攻击类型统计: {', '.join(sorted(attack_types))}")
    
    if success:
        print("✅ 战斗配置验证通过")
    return success

def verify_movement_config(json_data, excel_data):
    """验证移动配置"""
    print("\n🚶 验证移动配置...")
    
    json_enemies = {enemy['id']: enemy for enemy in json_data.get('enemies', [])}
    excel_movement = excel_data.get('移动配置')
    
    if excel_movement is None:
        print("❌ Excel中缺少'移动配置'工作表")
        return False
    
    success = True
    move_types = set()
    
    for _, row in excel_movement.iterrows():
        enemy_id = row['敌人ID']
        if enemy_id not in json_enemies:
            continue
        
        json_movement = json_enemies[enemy_id].get('movement', {})
        
        # 验证移动类型
        move_type = row['移动类型']
        expected_type = json_movement.get('moveType', 'straight')
        move_types.add(move_type)
        
        if move_type != expected_type:
            print(f"⚠️  {enemy_id} 移动类型不匹配: Excel={move_type}, JSON={expected_type}")
            success = False
        
        # 验证移动模式
        pattern = row['移动模式']
        expected_pattern = json_movement.get('pattern', 'walk_forward')
        
        if pattern != expected_pattern:
            print(f"⚠️  {enemy_id} 移动模式不匹配: Excel={pattern}, JSON={expected_pattern}")
            success = False
    
    print(f"\n📊 移动类型统计: {', '.join(sorted(move_types))}")
    
    if success:
        print("✅ 移动配置验证通过")
    return success

def main():
    """主函数"""
    print("🔍 开始验证Excel与JSON文件的同步状态...")
    
    # 加载数据
    json_data = load_json_data()
    excel_data = load_excel_data()
    
    if not json_data or not excel_data:
        return False
    
    print(f"\n📊 数据概览:")
    print(f"   JSON敌人数量: {len(json_data.get('enemies', []))}")
    print(f"   Excel工作表数量: {len(excel_data)}")
    print(f"   Excel工作表: {', '.join(excel_data.keys())}")
    
    # 执行验证
    all_passed = True
    
    all_passed &= verify_basic_config(json_data, excel_data)
    all_passed &= verify_visual_config(json_data, excel_data)
    all_passed &= verify_combat_config(json_data, excel_data)
    all_passed &= verify_movement_config(json_data, excel_data)
    
    # 总结
    print("\n" + "="*50)
    if all_passed:
        print("🎉 验证完成！Excel文件与JSON文件完全同步")
        print("\n✅ 同步成功的内容:")
        print("   📋 敌人基础信息 (ID、名称、属性)")
        print("   🎬 动画配置 (@EnemyAni路径和动画状态)")
        print("   ⚔️  战斗配置 (攻击类型、武器、投射物)")
        print("   🚶 移动配置 (移动模式和类型)")
        print("   🔊 音频配置")
        print("   🎯 特殊能力和BOSS配置")
        print("\n🎯 Excel配置表现在包含了完整的动画和战斗配置！")
        return True
    else:
        print("❌ 验证失败！发现数据不一致")
        return False

if __name__ == '__main__':
    success = main()
    if not success:
        print("\n❌ 验证过程中发现问题，请检查上述错误信息")