test-inventory-usage-fix.sh
1.6 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
#!/bin/bash
# 库存使用记录修复与测试脚本
# 前置：API 需运行在 localhost:2011
BASE_URL="${API_BASE_URL:-http://localhost:2011}"
echo "=== 1. 获取 Token ==="
LOGIN_RESP=$(curl -s -X POST "${BASE_URL}/api/oauth/Login" \
-H "Content-Type: application/x-www-form-urlencoded" \
-d "account=admin&password=e10adc3949ba59abbe56e057f20f883e")
if command -v jq &> /dev/null; then
TOKEN=$(echo "$LOGIN_RESP" | jq -r '.data.token // empty')
else
TOKEN=$(echo "$LOGIN_RESP" | grep -o '"token":"[^"]*"' | sed 's/"token":"\(.*\)"/\1/')
fi
if [ -z "$TOKEN" ]; then
echo "登录失败，请检查 API 是否运行: $BASE_URL"
echo "响应: $LOGIN_RESP"
exit 1
fi
echo "Token 获取成功"
echo ""
echo "=== 2. 执行修复接口 FixDuplicateUsageRecords ==="
FIX_RESP=$(curl -s -X POST "${BASE_URL}/api/Extend/LqInventoryUsage/FixDuplicateUsageRecords" \
-H "Authorization: $TOKEN" \
-H "Content-Type: application/json")
echo "$FIX_RESP"
if echo "$FIX_RESP" | grep -q '"success":true'; then
echo "修复接口调用成功"
else
echo "修复接口可能失败，请检查响应"
fi
echo ""
echo "=== 3. 验证说明 ==="
echo "请使用 MCP 或 MySQL 客户端执行以下 SQL 验证修复结果："
echo ""
echo " -- 检查是否还有重复（应无结果）"
echo " SELECT F_UsageBatchId, F_ProductId, F_StoreId, COUNT(*) as cnt"
echo " FROM lq_inventory_usage WHERE F_IsEffective = 1"
echo " GROUP BY F_UsageBatchId, F_ProductId, F_StoreId HAVING COUNT(*) > 1;"
echo ""
echo " -- 检查作废记录数"
echo " SELECT F_IsEffective, COUNT(*) FROM lq_inventory_usage GROUP BY F_IsEffective;"