antissoft / lvqianmeiye_ERP

  #!/bin/bash
  

  # 测试工资服务接口的脚本
  # 使用方法：在仓库根目录执行 ./项目文档相关/scripts/sh/test_salary_service.sh

  BASE_URL="http://localhost:2015"

  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 "=========================================="