分页和条件查询[物料位置](带位置)
GET
/materials-locs请求参数
Query 参数
limit
number
可选
每页显示条数(默认10)
示例值:
10
page
number
页数(默认1)
示例值:
1
materials_address
string
物料位置
materials_batch
string
物料批次
materials_name
string
物料名称
materials_sn
string
物料编号
vendor_id
string
供应商id
warehouse_id
string
仓库id
order
string
可选
顺序(默认降序) descend: 降序 ascend: 升序
sort
string
可选
排序字段,默认创建时间create_time
keyword
string
可选
关键字,查找物料名称、仓库、物料编号其中一项匹配查找
materials_type
string
物料规格
category
string
物料类别
Header 参数
warehouse_ids
string
必需
示例值:
1
Body 参数text/plain
示例代码
返回响应
成功(200)
HTTP 状态码: 200
内容格式: JSONapplication/json
数据结构
code
integer
必需
message
string
必需
data
object
必需
records
array [object {20}]
必需
total
integer
必需
size
integer
必需
current
integer
必需
orders
array[string]
必需
optimizeCountSql
boolean
必需
hitCount
boolean
必需
countId
null
必需
maxLimit
null
必需
searchCount
boolean
必需
pages
integer
必需
示例
成功示例
{
"code": 20000,
"message": "分页成功",
"data": {
"records": [
{
"materials_stock": 7,
"materials_address": "B-1-1-2",
"materials_unit": "条",
"create_time": "2023-12-27T14:33:49",
"vendor_name": "供应商名称3",
"materials_name": "Yanka_玛卡巴卡",
"materials_batch": "批次-3",
"materials_min": 0,
"warehouse_name": "仓库三号",
"materials_loc_id": 23,
"vendor_id": 3,
"materials_type": "200*150/18cm",
"materials_id": 25,
"materials_sn": "Yanka",
"materials_state": "充足",
"by_user": "admin"
},
{
"materials_stock": 7,
"materials_address": "B-1-1-1",
"materials_unit": "条",
"create_time": "2023-12-27T14:33:49",
"vendor_name": "供应商名称3",
"materials_name": "Yanka_玛卡巴卡",
"materials_batch": "批次-3",
"materials_min": 0,
"warehouse_name": "仓库三号",
"materials_loc_id": 22,
"vendor_id": 3,
"materials_type": "200*150/18cm",
"materials_id": 25,
"materials_sn": "Yanka",
"materials_state": "充足",
"by_user": "admin"
},
{
"materials_stock": 13,
"materials_address": "A-1-2-4",
"create_time": "2023-12-27T14:21:49",
"vendor_name": "供应商名称1",
"materials_name": "JS100冷却风扇",
"materials_batch": "批次-1",
"materials_min": 0,
"materials_color": "",
"warehouse_name": "仓库二号",
"materials_loc_id": 21,
"vendor_id": 1,
"materials_type": "200*60 0.23A",
"materials_id": 24,
"materials_sn": "JS100",
"materials_state": "充足",
"by_user": "admin"
},
{
"materials_stock": 13,
"materials_address": "A-1-2-3",
"create_time": "2023-12-27T14:21:49",
"vendor_name": "供应商名称1",
"materials_name": "JS100冷却风扇",
"materials_batch": "批次-1",
"materials_min": 0,
"materials_color": "",
"warehouse_name": "仓库二号",
"materials_loc_id": 20,
"vendor_id": 1,
"materials_type": "200*60 0.23A",
"materials_id": 24,
"materials_sn": "JS100",
"materials_state": "充足",
"by_user": "admin"
},
{
"materials_stock": 6,
"materials_address": "A-1-1-1",
"create_time": "2023-12-27T13:14:26",
"vendor_name": "供应商名称2",
"materials_name": "JS404冷却风扇",
"materials_min": 0,
"warehouse_name": "仓库二号",
"materials_loc_id": 19,
"vendor_id": 2,
"materials_type": "200*60 0.23A",
"materials_id": 23,
"materials_sn": "JS404",
"materials_state": "充足",
"by_user": "admin"
},
{
"materials_unit": "只",
"create_time": "2023-12-26T10:24:59",
"materials_color_number": "",
"description": "浅浅再借点一下",
"vendor_name": "供应商名称1",
"remark": "",
"materials_name": "棉花娃娃",
"materials_batch": "批次-2",
"materials_min": 2,
"materials_color": "五彩斑斓",
"vendor_id": 1,
"materials_type": "啊噗版",
"materials_id": 19,
"materials_sn": "181818",
"by_user": "admin"
},
{
"materials_unit": "只",
"create_time": "2023-12-25T14:04:49",
"materials_color_number": "",
"description": "浅浅再借点一下",
"vendor_name": "供应商名称1",
"remark": "",
"materials_name": "线条小狗",
"materials_batch": "批次-1",
"materials_min": 3,
"materials_color": "暗夜黑",
"vendor_id": 1,
"materials_type": "经典皮肤版",
"materials_id": 16,
"materials_sn": "181815",
"by_user": "admin"
},
{
"materials_stock": 7,
"materials_address": "A-2-2-2",
"materials_unit": "个",
"create_time": "2023-12-25T14:04:49",
"materials_color_number": "",
"description": "浅浅再借点一下",
"vendor_name": "供应商名称1",
"remark": "",
"materials_name": "海绵宝宝",
"materials_batch": "批次-1",
"materials_min": 3,
"materials_color": "黄色",
"warehouse_name": "仓库一号",
"materials_loc_id": 13,
"vendor_id": 1,
"materials_type": "经典皮肤版",
"materials_id": 15,
"materials_sn": "1818",
"materials_state": "短缺",
"by_user": "admin"
},
{
"materials_stock": 4,
"materials_address": "A-1-1-3",
"materials_unit": "个",
"create_time": "2023-12-25T14:04:49",
"materials_color_number": "",
"description": "浅浅再借点一下",
"vendor_name": "供应商名称1",
"remark": "",
"materials_name": "海绵宝宝",
"materials_batch": "批次-1",
"materials_min": 3,
"materials_color": "黄色",
"warehouse_name": "仓库一号",
"materials_loc_id": 14,
"vendor_id": 1,
"materials_type": "经典皮肤版",
"materials_id": 15,
"materials_sn": "1818",
"materials_state": "充足",
"by_user": "admin"
},
{
"materials_stock": 4,
"materials_address": "A-1-1-2",
"materials_unit": "件",
"create_time": "2023-12-25T13:39:37",
"materials_color_number": "",
"description": "你相信光吗",
"vendor_name": "供应商名称1",
"remark": "",
"materials_name": "奥特曼",
"materials_batch": "批次-1",
"materials_min": 2,
"materials_color": "红蓝撞色",
"warehouse_name": "仓库一号",
"materials_loc_id": 12,
"vendor_id": 1,
"materials_type": "赛文",
"materials_id": 14,
"materials_sn": "12345",
"materials_state": "充足",
"by_user": "admin"
}
],
"total": 14,
"size": 10,
"current": 1,
"orders": [],
"optimizeCountSql": true,
"hitCount": false,
"countId": null,
"maxLimit": null,
"searchCount": true,
"pages": 2
}
}
最后修改时间: 8 个月前