推荐箱型与设箱校验
测试作业手册

SELECT table_name, column_name, column_type
FROM information_schema.columns
WHERE table_schema = DATABASE()
  AND ((table_name = 'xm_bulky_pack_config' AND column_name = 'flower_weight')
    OR (table_name = 'xm_bulky_wms_express_package'
        AND column_name IN ('suggest_pack_id', 'suggest_pack_info')))
ORDER BY table_name, ordinal_position;

-- 预期恰好返回 3 行

SELECT p.send_no, p.serial_num, p.package_num,
       p.suggest_pack_id, p.suggest_pack_info,
       c.flower_weight AS suggest_capacity,
       p.total_weight, p.express_status
FROM xm_bulky_wms_express_package p
LEFT JOIN xm_bulky_pack_config c ON c.id = p.suggest_pack_id
WHERE p.send_no LIKE 'TESTADM%'
  AND p.data_status = 0
ORDER BY p.send_no, p.serial_num;

-- 幂等前后记录两次结果，COUNT 与 id 集合都应一致
SELECT COUNT(*) AS row_count,
       GROUP_CONCAT(id ORDER BY id) AS id_list
FROM xm_bulky_wms_express_package
WHERE send_no LIKE 'TESTADM%' AND data_status = 0;

// 货架列表。status=0 查待打包；status=1 查已打包
POST /package/shelf/page
{
  "date": "<测试日期>",
  "userId": <测试账号ID>,
  "userName": "<测试账号名称>",
  "status": 1,
  "boxMatchFilter": 2,
  "current": 1,
  "size": 20
}

// 首次设箱。codeContent 填 SQL 输出的包裹 id
POST /package/pack/finish
{
  "codeContent": "<包裹ID>",
  "userId": <测试账号ID>,
  "userName": "<测试账号名称>",
  "phone": "13800000000",
  "packId": <实际箱ID>,
  "packName": "<实际箱名称>",
  "url": "",
  "shelfPackage": 0,
  "forceFlag": 0
}

// 收到 code=6001 后，只把 forceFlag 改成 1，其余参数原样重调

SELECT package_id, origin_pack_id, origin_pack_name,
       target_pack_id, target_pack_name,
       operate_user_id, operate_user_name, remark, create_time
FROM xm_bulky_package_box_modify_record
WHERE send_no LIKE 'TESTBOX%'
  AND data_status = 0
ORDER BY id DESC;

-- 小程序强制使用预期 remark：
-- 实际箱型与推荐箱型不一致，已确认强制使用
-- PDA 不符预期 remark：
-- 扫码枪打包，实际箱型与推荐箱型不一致

SELECT id, round_no, ware_id, partner_id, serial_num, package_num,
       total_weight, item_num, express_status,
       package_id, package_info, suggest_pack_id, suggest_pack_info,
       data_status, create_time, update_time
FROM xm_bulky_wms_express_package
WHERE round_no = CURDATE()
  AND type = 2
  AND ware_id = <SQL输出的wareId>
  AND partner_id = 0
ORDER BY serial_num, id;

-- 幂等前后比较
SELECT COUNT(*) AS row_count,
       GROUP_CONCAT(id ORDER BY id) AS id_list,
       GROUP_CONCAT(serial_num ORDER BY serial_num) AS serial_list
FROM xm_bulky_wms_express_package
WHERE round_no = CURDATE()
  AND type = 2
  AND ware_id = <SQL输出的wareId>
  AND partner_id = 0
  AND data_status = 0;

提交：0019b5646c3a98e7c813e0cd14a4ba7561ebf89f
环境：test1 / API 实例：________
场次：________    测试账号：________

白场后台：通过 / 不通过 / 未测
供应商设箱：通过 / 不通过 / 未测
晚场 NORMAL：通过 / 不通过 / 未测
晚场 PACKED：通过 / 不通过 / 未测
晚场 PARTIAL：通过 / 不通过 / 未测
晚场 SPECIAL/ZTO：通过 / 不通过 / 未测

失败用例 ID：________
请求与响应：________
数据库前后快照：________
重跑结果：________
日志关键字：________
结论与阻塞：________