@echo off
REM ========================================
REM 离职日志自动化处理脚本
REM ========================================

chcp 65001 >nul

echo.
echo ============================================================
echo           Termination Automation Script
echo ============================================================
echo.

REM 设置路径
set BASE_DIR=%~dp0
set OUTPUT_DIR=%BASE_DIR%output
set LOG_DIR=%BASE_DIR%logs

REM 创建输出目录
if not exist "%OUTPUT_DIR%" mkdir "%OUTPUT_DIR%"

echo [%TIME%] Step 1: Running ETL...
python "%BASE_DIR%logs_etl.py"
if %ERRORLEVEL% NEQ 0 (
    echo [ERROR] ETL failed with error code %ERRORLEVEL%
    pause
    exit /b 1
)

echo [%TIME%] Step 2: Checking output...
if not exist "%OUTPUT_DIR%\Unified_Termination_Logs.csv" (
    echo [ERROR] Unified_Termination_Logs.csv not found
    pause
    exit /b 1
)

REM 统计记录数
for /f %%A in ('type "%OUTPUT_DIR%\Unified_Termination_Logs.csv" ^| find /c /v ""') do set LINE_COUNT=%%A
set /a RECORD_COUNT=LINE_COUNT-1
echo [INFO] Total records: %RECORD_COUNT%

echo.
echo ============================================================
echo                     Processing Complete!
echo ============================================================
echo.
echo Output files:
echo - %OUTPUT_DIR%\Unified_Termination_Logs.csv
echo - %OUTPUT_DIR%\Daily_Summary.csv
echo - %OUTPUT_DIR%\Error_Details.csv
echo.
echo [%TIME%] All done!
echo.

REM 可选：打开Power BI
REM start "" "PowerBI_Dashboard.pbix"

pause