tanqiu/assets/data/excel/启动配置工具.bat

@echo off
chcp 65001 >nul
cd /d "%~dp0"

REM Activate virtual environment
if exist "..\..\..\..\.\.venv\Scripts\activate.bat" (
    call "..\..\..\..\.\.venv\Scripts\activate.bat"
    echo Virtual environment activated: .venv
) else if exist "..\..\..\..\.\.venv\Scripts\activate" (
    call "..\..\..\..\.\.venv\Scripts\activate"
    echo Virtual environment activated: .venv
) else if exist "..\..\..\..\.\.venv\pyvenv.cfg" (
    set "VIRTUAL_ENV=%~dp0..\..\..\..\.\.venv"
    set "PATH=%VIRTUAL_ENV%\Scripts;%PATH%"
    echo Virtual environment path set: .venv
) else (
    echo Virtual environment not found, using system Python
)
echo.

:start
echo ========================================
echo Game Configuration Management Tool - Multi-table Support
echo ========================================
echo.
echo Please select an operation:
echo 1. Launch GUI Configuration Management Tool (Excel to JSON)
echo 2. Convert JSON configuration to Excel tables
echo 3. Verify Excel file content
echo 4. Exit
echo.
set /p choice=Please enter option (1-4): 

if "%choice%"=="1" goto gui_tool
if "%choice%"=="2" goto json_to_excel
if "%choice%"=="3" goto verify_excel
if "%choice%"=="4" goto exit
echo Invalid option, please choose again
pause
goto start

:gui_tool
echo.
echo Starting GUI Configuration Management Tool...
echo.
set "CFG_CASE_INSENSITIVE=1"
python config_manager.py
if errorlevel 1 (
    py config_manager.py
    if errorlevel 1 (
        python3 config_manager.py
        if errorlevel 1 (
            echo.
            echo Unable to start Python environment
            echo Please ensure Python is installed and added to PATH
            echo Or run manually: py config_manager.py
            echo.
            echo If pandas library is not installed, please run:
            echo pip install pandas openpyxl
            echo.
            pause
        )
    )
)
goto end

:json_to_excel
echo.
echo Converting JSON configuration to Excel tables...
echo.
python json_to_excel.py
if errorlevel 1 (
    py json_to_excel.py
    if errorlevel 1 (
        python3 json_to_excel.py
        if errorlevel 1 (
            echo.
            echo Conversion failed, please check Python environment and dependencies
            echo.
            pause
        )
    )
)
echo.
echo Conversion completed! Press any key to continue...
pause
goto start

:verify_excel
echo.
echo Verifying Excel file content...
echo.
python verify_excel.py
if errorlevel 1 (
    py verify_excel.py
    if errorlevel 1 (
        python3 verify_excel.py
        if errorlevel 1 (
            echo.
            echo Verification failed, please check Python environment and dependencies
            echo.
            pause
        )
    )
)
echo.
echo Verification completed! Press any key to continue...
pause
goto start

:exit
echo Exiting program...
exit /b 0

:end
echo.
echo Operation completed!
pause