库存记录

Owned by Seven Zhang
Last updated: 2021-05-10 by Devin (Unlicensed)
8 min read

查询产品库存记录

URLhttp://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"}]

返回示例

{
    "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库存记录列表IDINT(10)
container_id货架上的容器IDINT(10)
product_id产品IDINT(10)
quantity数量INT(10)
consignment_id订单IDBIGINT(16)
client_dispatch_id发货单IDINT(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(退货)"，“MOVE_STOCK（移库存）”
container-reference容器IDINT(10)

添加产品库存

URLhttps://test.birdsystem.com/admin/Container-Product-Transaction/
接口功能添加产品库存
支持格式JSON开发人员
请求方式POST发布日期
参数说明是否必填类型
container-reference容器referenceYINT（10）
product_id产品IDYINT（10）
quantity数量YINT（10）
client_id客户IDNINT（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(退货)"，“MOVE_STOCK（移库存）”
note备注NVARCHAR
jump_over_client_company_check跳过客户站点检查N0/1（1表示跳过客户站点检查）

返回示例

{
    "data": {
        "total": null,
        "quantity_left": null,
        "id": 54386955,
        "container_id": 5502451,
        "product_id": 2990372,
        "quantity": "1",
        "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-12-02 15:07:46",
        "type": "ADJUSTMENT",
        "primary_keys": [
            "id"
        ]
    },
    "success": true,
    "moduleName": "admin"
}

返回说明

字段说明
id系统库存记录ID
container_id货架上的容器ID
quantity添加数量
product_id产品ID
company_user_id用户ID
update_time最后更新时间
type种类