#!/bin/bash

# 测试工资服务接口的脚本
# 使用方法：./scripts/sh/test_salary_service.sh

BASE_URL="http://localhost:2011"
TOKEN=""

echo "=========================================="
echo "开始测试工资服务接口"
echo "=========================================="
echo ""

# 1. 获取Token
echo "1. 获取Token..."
LOGIN_RESPONSE=$(curl -s -X POST "${BASE_URL}/api/oauth/Login" \
  -H "Content-Type: application/x-www-form-urlencoded" \
  -d "account=admin&password=e10adc3949ba59abbe56e057f20f883e")

TOKEN=$(echo $LOGIN_RESPONSE | python3 -c "import sys, json; print(json.load(sys.stdin)['data']['token'])" 2>/dev/null)

if [ -z "$TOKEN" ]; then
  echo "❌ 获取Token失败"
  echo "响应: $LOGIN_RESPONSE"
  exit 1
fi

echo "✅ Token获取成功"
echo ""

# 2. 测试计算健康师工资接口
echo "2. 测试计算健康师工资接口（calculate/health-coach）..."
echo "请求参数: year=2025, month=9"
echo ""

CALCULATE_RESPONSE=$(curl -s -X POST "${BASE_URL}/api/Extend/LqSalary/calculate/health-coach?year=2025&month=9" \
  -H "Authorization: ${TOKEN}")

echo "响应:"
echo "$CALCULATE_RESPONSE" | python3 -m json.tool 2>/dev/null || echo "$CALCULATE_RESPONSE"
echo ""

# 检查返回结果
if echo "$CALCULATE_RESPONSE" | python3 -c "import sys, json; data=json.load(sys.stdin); exit(0 if data.get('code') == 200 or '操作成功' in str(data) else 1)" 2>/dev/null; then
  echo "✅ 计算健康师工资接口测试通过"
else
  echo "⚠️  计算健康师工资接口可能存在问题"
fi
echo ""

# 3. 检查数据库中是否有已锁定或已确认的记录被跳过
echo "3. 检查数据库中已锁定和已确认的记录..."
echo ""

LOCKED_COUNT=$(mysql -u${DB_USER:-root} -p${DB_PASSWORD:-} ${DB_NAME:-lvqianmeiye_ERP} -se "SELECT COUNT(*) FROM lq_salary_statistics WHERE F_StatisticsMonth='202509' AND (F_IsLocked=1 OR F_EmployeeConfirmStatus=1)" 2>/dev/null || echo "0")

echo "已锁定或已确认的记录数量: $LOCKED_COUNT"
echo ""

echo "=========================================="
echo "测试完成"
echo "=========================================="