Blame view

scripts/sh/test_salary_service.sh 2.07 KB
83a6fd1f   “wangming”   feat: 添加员工确认状态及相关...
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
  #!/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 "=========================================="