DM-ROW 接口文档

Appearance

POST /dm-store/safeStock/page ​

Content-Type: application/json

触发按钮：pageAjax

入参 ​

传递对象：SafeStockQueryVo

字段类型必填多选校验规则说明
storeCodeString否否--
partCodeString否否--
storeNameString否否--
partNameString否否--
startTimeDate否否-开始时间
endTimeDate否否-结束时间

实际入参:

json
{
    "pageSize": 10,
    "pageNum": 1,
    "storeCode": "2",
    "storeName": "22",
    "partCode": "22",
    "partName": "22",
    "startTime": "2026-05-05",
    "endTime": "2026-06-12"
}

出参 ​

传递对象：ResultData，前端实际消费的是 data 中的 rows / total。<rows + total>

json
{
  "code": 200,
  "msg": "success",
  "data": {
    "rows": [
      {
        "id": 584,
        "createTime": "2024-12-13 14:36:48",
        "createUser": "taoqin1",
        "updateTime": "2026-05-18 10:01:22",
        "updateUser": "zhuqing5",
        "factoryNo": "LSSC",
        "storeNo": "000022",
        "storeCode": "天津联想仓库04",
        "storeName": "TJSC IE/FE 备件库",
        "partNo": "003142",
        "partCode": "TJSCA207102",
        "partName": "绿联网线",
        "uom": "根",
        "maxStock": 300,
        "minStock": 30,
        "safeStock": 100
      },
      {
        "id": 696,
        "createTime": "2026-05-18 09:59:28",
        "createUser": "zhuqing5",
        "updateTime": "2026-05-18 09:59:28",
        "updateUser": "zhuqing5",
        "factoryNo": "LSSC",
        "storeNo": "000022",
        "storeCode": "天津联想仓库04",
        "storeName": "TJSC IE/FE 备件库",
        "partNo": "008518",
        "partCode": "TJSCA211457",
        "partName": "开关电源3",
        "uom": "个",
        "maxStock": 6,
        "minStock": 1,
        "safeStock": 2
      },
      {
        "id": 695,
        "createTime": "2026-05-18 09:58:58",
        "createUser": "zhuqing5",
        "updateTime": "2026-05-18 09:58:58",
        "updateUser": "zhuqing5",
        "factoryNo": "LSSC",
        "storeNo": "000022",
        "storeCode": "天津联想仓库04",
        "storeName": "TJSC IE/FE 备件库",
        "partNo": "003252",
        "partCode": "TJSCA207348",
        "partName": "离子风机 BFN-801",
        "uom": "台",
        "maxStock": 6,
        "minStock": 1,
        "safeStock": 2
      },
      {
        "id": 694,
        "createTime": "2026-05-18 09:56:47",
        "createUser": "zhuqing5",
        "updateTime": "2026-05-18 09:56:47",
        "updateUser": "zhuqing5",
        "factoryNo": "LSSC",
        "storeNo": "000022",
        "storeCode": "天津联想仓库04",
        "storeName": "TJSC IE/FE 备件库",
        "partNo": "007920",
        "partCode": "TJSCA209866",
        "partName": "USB转J45百兆网卡",
        "uom": "个",
        "maxStock": 90,
        "minStock": 9,
        "safeStock": 30
      },
      {
        "id": 693,
        "createTime": "2026-05-18 09:56:07",
        "createUser": "zhuqing5",
        "updateTime": "2026-05-18 09:56:07",
        "updateUser": "zhuqing5",
        "factoryNo": "LSSC",
        "storeNo": "000022",
        "storeCode": "天津联想仓库04",
        "storeName": "TJSC IE/FE 备件库",
        "partNo": "007304",
        "partCode": "TJSCA210218",
        "partName": "接近开关E2G",
        "uom": "个",
        "maxStock": 15,
        "minStock": 2,
        "safeStock": 5
      },
      {
        "id": 692,
        "createTime": "2026-05-18 09:55:41",
        "createUser": "zhuqing5",
        "updateTime": "2026-05-18 09:55:41",
        "updateUser": "zhuqing5",
        "factoryNo": "LSSC",
        "storeNo": "000022",
        "storeCode": "天津联想仓库04",
        "storeName": "TJSC IE/FE 备件库",
        "partNo": "007798",
        "partCode": "TJSCA208029",
        "partName": "光电",
        "uom": "个",
        "maxStock": 15,
        "minStock": 2,
        "safeStock": 5
      },
      {
        "id": 691,
        "createTime": "2026-05-18 09:54:36",
        "createUser": "zhuqing5",
        "updateTime": "2026-05-18 09:55:04",
        "updateUser": "zhuqing5",
        "factoryNo": "LSSC",
        "storeNo": "000022",
        "storeCode": "天津联想仓库04",
        "storeName": "TJSC IE/FE 备件库",
        "partNo": "008523",
        "partCode": "TJSCA211442",
        "partName": "光电开关传感器1",
        "uom": "个",
        "maxStock": 15,
        "minStock": 2,
        "safeStock": 5
      },
      {
        "id": 655,
        "createTime": "2025-08-27 09:55:08",
        "createUser": "zhuqing5",
        "updateTime": "2026-05-18 09:49:12",
        "updateUser": "zhuqing5",
        "factoryNo": "LSSC",
        "storeNo": "000022",
        "storeCode": "天津联想仓库04",
        "storeName": "TJSC IE/FE 备件库",
        "partNo": "002883",
        "partCode": "TJSCA206764",
        "partName": "自动化批头1",
        "uom": "根",
        "maxStock": 150,
        "minStock": 30,
        "safeStock": 60
      },
      {
        "id": 186,
        "createTime": "2024-08-15 10:38:35",
        "createUser": "taoqin1",
        "updateTime": "2026-05-18 09:48:41",
        "updateUser": "zhuqing5",
        "factoryNo": "LSSC",
        "storeNo": "000022",
        "storeCode": "天津联想仓库04",
        "storeName": "TJSC IE/FE 备件库",
        "partNo": "002076",
        "partCode": "TJSCA205896",
        "partName": "十字批头3.0平头",
        "uom": "个",
        "maxStock": 300,
        "minStock": 20,
        "safeStock": 40
      },
      {
        "id": 187,
        "createTime": "2024-08-15 10:38:35",
        "createUser": "taoqin1",
        "updateTime": "2026-05-18 09:48:20",
        "updateUser": "zhuqing5",
        "factoryNo": "LSSC",
        "storeNo": "000022",
        "storeCode": "天津联想仓库04",
        "storeName": "TJSC IE/FE 备件库",
        "partNo": "000596",
        "partCode": "TJSCA203378",
        "partName": "十字批头2.5平头",
        "uom": "个",
        "maxStock": 900,
        "minStock": 60,
        "safeStock": 120
      }
    ],
    "total": 403
  }
}

前端校验规则 ​

无

后端逻辑 ​

业务流程：归一化查询条件 -> 按条件查询安全库存 -> 关联仓库与物料信息 -> 按排序规则分页返回

├── 归一化查询条件
│   ├── 规范时间范围 :88-90
│   └── 转换排序字段为下划线 :92-94
└── 分页查询安全库存
    └── SafeStockMapper.search :97
        ├── 查询未删除安全库存并关联仓库、物料信息 :24-34
        ├── 条件筛选 :35-52
        │   ├── 仓库编码
        │   ├── 物料编码
        │   ├── 仓库名称
        │   ├── 物料名称
        │   └── 创建时间范围
        └── 排序规则 :53-59
            ├── 按前端指定字段排序
            └── 默认按更新时间倒序

后端校验规则 ​

无

涉及数据库表 ​

库名.表名mapper.statement描述
store.safe_stockSafeStockMapper.selectPage按筛选条件分页查询safety数据
safe_stock_mappersafeStockMapper.searchsafeStockMapper