antissoft / lvqianmeiye_ERP

  # 仓库领用成本统计接口测试说明
  
  ## 📋 接口信息
  
  - **接口路径**: `POST /api/Extend/LqInventoryUsage/get-store-receive-cost-statistics`
  - **服务类**: `LqInventoryUsageService`
  - **方法名**: `GetStoreReceiveCostStatistics`
  
  ## ⚠️ 测试前准备
  
  1. **确保后端服务已重启**：接口代码修改后需要重新编译并重启服务

  2. **确认服务运行正常**：访问 `http://localhost:2015/api/test` 验证服务是否运行

  
  ## 🧪 测试用例
  
  ### 测试1: 按月份查询（202601）
  
  ```bash

  curl -X POST "http://localhost:2015/api/Extend/LqInventoryUsage/get-store-receive-cost-statistics" \

    -H "Authorization: Bearer {TOKEN}" \
    -H "Content-Type: application/json" \
    -d '{
      "statisticsMonth": "202601",
      "currentPage": 1,
      "pageSize": 20
    }'
  ```
  
  **预期返回字段**：
  - `StatisticsMonth`: 统计月份（如：202601）
  - `StoreId`: 门店ID
  - `StoreName`: 门店名称
  - `ReceiveCount`: 领取数量（按批次去重）
  - `ProductVarietyCount`: 领取品种数量
  - `AvgUnitPrice`: 平均单价
  - `TotalCostAmount`: 总价
  - `WarehouseCount`: 涉及仓库数量
  - `UsageRecordCount`: 领用记录数
  - `AvgReceiveAmount`: 平均领用金额
  - `AvgRecordAmount`: 平均单笔金额
  - `TotalUsageQuantity`: 领用总数量
  - `MaxRecordAmount`: 最大单笔金额
  - `MinRecordAmount`: 最小单笔金额
  
  ### 测试2: 按时间范围查询
  
  ```bash

  curl -X POST "http://localhost:2015/api/Extend/LqInventoryUsage/get-store-receive-cost-statistics" \

    -H "Authorization: Bearer {TOKEN}" \
    -H "Content-Type: application/json" \
    -d '{
      "startMonth": "202512",
      "endMonth": "202601",
      "currentPage": 1,
      "pageSize": 10
    }'
  ```
  
  ### 测试3: 按门店查询
  
  ```bash

  curl -X POST "http://localhost:2015/api/Extend/LqInventoryUsage/get-store-receive-cost-statistics" \

    -H "Authorization: Bearer {TOKEN}" \
    -H "Content-Type: application/json" \
    -d '{
      "statisticsMonth": "202601",
      "storeId": "1649328471923847193",
      "currentPage": 1,
      "pageSize": 20
    }'
  ```
  
  ### 测试4: 按仓库筛选
  
  ```bash

  curl -X POST "http://localhost:2015/api/Extend/LqInventoryUsage/get-store-receive-cost-statistics" \

    -H "Authorization: Bearer {TOKEN}" \
    -H "Content-Type: application/json" \
    -d '{
      "statisticsMonth": "202601",
      "warehouse": "福田仓库",
      "currentPage": 1,
      "pageSize": 20
    }'
  ```
  
  ### 测试5: 排序测试
  
  ```bash

  curl -X POST "http://localhost:2015/api/Extend/LqInventoryUsage/get-store-receive-cost-statistics" \

    -H "Authorization: Bearer {TOKEN}" \
    -H "Content-Type: application/json" \
    -d '{
      "statisticsMonth": "202601",
      "sidx": "TotalCostAmount",
      "sort": "desc",
      "currentPage": 1,
      "pageSize": 5
    }'
  ```
  
  ## 📝 使用测试脚本
  
  运行测试脚本：
  
  ```bash

  bash 项目文档相关/scripts/sh/test_store_receive_cost_statistics.sh

  ```
  
  ## ✅ 验证要点
  
  1. **接口返回码**: 应为 `200`
  2. **数据结构**: 返回的 `list` 数组应包含统计记录
  3. **分页信息**: `pagination` 应包含 `total`、`pageIndex`、`pageSize`
  4. **字段完整性**: 每个记录应包含所有必需字段
  5. **数据准确性**: 
     - `AvgUnitPrice` = `TotalCostAmount` / `ProductVarietyCount`
     - `AvgReceiveAmount` = `TotalCostAmount` / `ReceiveCount`
     - `AvgRecordAmount` = `TotalCostAmount` / `UsageRecordCount`
  
  ## 🔍 数据验证SQL
  
  可以通过以下SQL验证数据：
  
  ```sql
  -- 验证202601月份的统计数据
  SELECT 
      DATE_FORMAT(a.F_ReceiveTime, '%Y%m') as StatisticsMonth,
      u.F_StoreId as StoreId,
      store.dm as StoreName,
      COUNT(DISTINCT a.F_UsageBatchId) as ReceiveCount,
      COUNT(DISTINCT u.F_ProductId) as ProductVarietyCount,
      COALESCE(SUM(u.F_TotalAmount), 0) as TotalCostAmount,
      COUNT(DISTINCT p.F_Warehouse) as WarehouseCount
  FROM lq_inventory_usage u
  INNER JOIN lq_inventory_usage_application a ON u.F_UsageBatchId = a.F_UsageBatchId
  INNER JOIN lq_product p ON u.F_ProductId = p.F_Id
  LEFT JOIN lq_mdxx store ON u.F_StoreId = store.F_Id
  WHERE u.F_IsEffective = 1
      AND a.F_IsEffective = 1
      AND a.F_ApprovalStatus = '已通过'
      AND a.F_IsReceived = 1
      AND a.F_ReceiveTime IS NOT NULL
      AND DATE_FORMAT(a.F_ReceiveTime, '%Y%m') = '202601'
  GROUP BY 
      DATE_FORMAT(a.F_ReceiveTime, '%Y%m'),
      u.F_StoreId,
      store.dm
  ORDER BY TotalCostAmount DESC
  LIMIT 10;
  ```
  
  ## 🐛 常见问题
  
  1. **404错误**: 服务未重启，需要重新编译并重启后端服务
  2. **500错误**: 检查SQL查询是否正确，查看服务日志
  3. **空数据**: 确认指定月份是否有已领取的仓库使用记录
  4. **Token过期**: 重新获取Token