查询产品库存记录
| URL | http://test.birdsystem.com/client/Container-Product-Transaction | ||
|---|---|---|---|
| 接口功能 | 查询产品库存记录 | ||
| 支持格式 | JSON | 开发人员 | |
| 请求方式 | GET | 发布时间 | |
...
| 参数名 | 注释 | 示例 |
|---|---|---|
product_id | 产品ID | product_id=1 |
| sort | 排序 | sort=[{"property":"update_time","direction":"DESC"}] |
| limit | 获取多少条记录 | limit=50 |
请求示例
http://test.birdsystem.com/client/Container-Product-Transaction?product_id=2941864&sort=[{"property":"update_time","direction":"DESC"}]
返回示例
| Code Block | ||||
|---|---|---|---|---|
| ||||
{
"total": 7,
"data": [
{
"total": null,
"quantity_left": null,
"id": 54386927,
"container_id": 1935355,
"product_id": 2941864,
"quantity": "10",
"consignment_id": null,
"warehouse_dispatch_id": null,
"client_dispatch_id": null,
"warehouse_transfer_id": null,
"additional_service_id": null,
"company_user_id": 1745,
"note": null,
"update_time": "2020-11-26 11:37:06",
"type": "ADJUSTMENT",
"primary_keys": [
"id"
],
"container-reference": "101999"
},
{
"total": null,
"quantity_left": null,
"id": 54386819,
"container_id": 1935355,
"product_id": 2941864,
"quantity": "-1",
"consignment_id": 2005290360000029,
"warehouse_dispatch_id": null,
"client_dispatch_id": null,
"warehouse_transfer_id": null,
"additional_service_id": null,
"company_user_id": null,
"note": null,
"update_time": "2020-05-29 17:48:52",
"type": "CONSIGNMENT",
"primary_keys": [
"id"
],
"container-reference": "101999"
},
{
"total": null,
"quantity_left": null,
"id": 54386820,
"container_id": 1935355,
"product_id": 2941864,
"quantity": "-1",
"consignment_id": 2005290360000030,
"warehouse_dispatch_id": null,
"client_dispatch_id": null,
"warehouse_transfer_id": null,
"additional_service_id": null,
"company_user_id": null,
"note": null,
"update_time": "2020-05-29 17:48:52",
"type": "CONSIGNMENT",
"primary_keys": [
"id"
],
"container-reference": "101999"
},
{
"total": null,
"quantity_left": null,
"id": 54386821,
"container_id": 1935355,
"product_id": 2941864,
"quantity": "-1",
"consignment_id": 2005290360000031,
"warehouse_dispatch_id": null,
"client_dispatch_id": null,
"warehouse_transfer_id": null,
"additional_service_id": null,
"company_user_id": null,
"note": null,
"update_time": "2020-05-29 17:48:52",
"type": "CONSIGNMENT",
"primary_keys": [
"id"
],
"container-reference": "101999"
},
{
"total": null,
"quantity_left": null,
"id": 54386822,
"container_id": 1935355,
"product_id": 2941864,
"quantity": "-1",
"consignment_id": 2005290360000032,
"warehouse_dispatch_id": null,
"client_dispatch_id": null,
"warehouse_transfer_id": null,
"additional_service_id": null,
"company_user_id": null,
"note": null,
"update_time": "2020-05-29 17:48:52",
"type": "CONSIGNMENT",
"primary_keys": [
"id"
],
"container-reference": "101999"
},
{
"total": null,
"quantity_left": null,
"id": 54386823,
"container_id": 1935355,
"product_id": 2941864,
"quantity": "-1",
"consignment_id": 2005290360000033,
"warehouse_dispatch_id": null,
"client_dispatch_id": null,
"warehouse_transfer_id": null,
"additional_service_id": null,
"company_user_id": null,
"note": null,
"update_time": "2020-05-29 17:48:52",
"type": "CONSIGNMENT",
"primary_keys": [
"id"
],
"container-reference": "101999"
},
{
"total": null,
"quantity_left": null,
"id": 54386804,
"container_id": 1935355,
"product_id": 2941864,
"quantity": "100",
"consignment_id": null,
"warehouse_dispatch_id": null,
"client_dispatch_id": null,
"warehouse_transfer_id": null,
"additional_service_id": null,
"company_user_id": 1834,
"note": null,
"update_time": "2020-05-29 15:31:45",
"type": "MOVE_STOCK",
"primary_keys": [
"id"
],
"container-reference": "101999"
}
],
"success": true,
"moduleName": "client"
} |
...
| 列名 | 注释 | 类型 |
|---|---|---|
| id | 库存记录列表ID | INT(10) |
| container_id | 货架上的容器ID | INT(10) |
| product_id | 产品ID | INT(10) |
| quantity | 数量 | INT(10) |
| consignment_id | 订单ID | BIGINT(16) |
| client_dispatch_id | 发货单ID | INT(10) |
| update_time | 更新时间 | TIMESTAMP |
| type | 类型 | 'ADJUSTMENT'（调整）,'CONSIGNMENT'（订单）,'WAREHOUSE_DISPATCH'（仓库发货）,"INVENTORY_PROFIT（盘盈）","INVENTORY_LOSS（盘亏，数量必须为负数）","SLOW_PRODUCT_ADJUSTMENT(滞销库存调整)","CORRECTION(数据修复)","ADDITIONAL_SERVICE_INVENTORY_OUT(增值服务—下架)","WAREHOUSE_TRANSFER(仓库调拨)","WAREHOUSE_CHECE（仓库查验）","CLIENT_DISPATCH_TRANSFER(客户发货)","CLIENT_DISPATCH(客户发货单直接上架)","RETURN(退货)" |
| container-reference | 容器ID | INT(10) |
...
| 参数 | 说明 | 是否必填 | 类型 |
|---|---|---|---|
| container-reference | 容器reference | Y | INT（10） |
| product_id | 产品ID | Y | INT（10） |
| quantity | 数量 | Y | INT（10） |
| client_id | 客户ID | N | INT（10） |
| type | 种类 | Y | 'ADJUSTMENT'（调整）,'CONSIGNMENT'（订单）,'WAREHOUSE_DISPATCH'（仓库发货）,"INVENTORY_PROFIT（盘盈）","INVENTORY_LOSS（盘亏，数量必须为负数）","SLOW_PRODUCT_ADJUSTMENT(滞销库存调整)","CORRECTION(数据修复)","ADDITIONAL_SERVICE_INVENTORY_OUT(增值服务—下架)","WAREHOUSE_TRANSFER(仓库调拨)","WAREHOUSE_CHECE（仓库查验）","CLIENT_DISPATCH_TRANSFER(客户发货)","CLIENT_DISPATCH(客户发货单直接上架)","RETURN(退货)" |
| note | 备注 | N | VARCHAR |
| jump_over_client_company_check | 跳过客户站点检查 | N | 0/1（1表示跳过客户站点检查） |
...
| 字段 | 说明 |
|---|---|
| id | 系统库存记录ID |
| container_id | 货架上的容器ID |
| quantity | 添加数量 |
| product_id | 产品ID |
| company_user_id | 用户ID |
| update_time | 最后更新时间 |
| type | 种类 |
...