test_salary_service.sh
2.07 KB
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 "=========================================="