#!/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;"