库存记录

查询产品库存记录

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"}]

返回示例

{
    "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(退货)"，“MOVE_STOCK（移库存）”
container-reference	容器ID	INT(10)

添加产品库存

URL	https://test.birdsystem.com/admin/Container-Product-Transaction/
接口功能	添加产品库存
支持格式	JSON	开发人员
请求方式	POST	发布日期

参数	说明	是否必填	类型
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(退货)"，“MOVE_STOCK（移库存）”
note	备注	N	VARCHAR
jump_over_client_company_check	跳过客户站点检查	N	0/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	种类