DM-ROW 接口文档

Appearance

POST /dm-store/storePermission/page ​

Content-Type: application/json

触发按钮：pageAjax

入参 ​

传递对象：StorePermissionQueryVo

字段类型必填多选校验规则说明
fieldString否否--
orderString否否--
factoryNoString否否--
userAccountString否否-用户编码
userNameString否否-用户名称
userAccountOrNameString否否-用户信息
storeNoString否否-仓库代号

实际入参:

json
{
    "pageSize": 10,
    "pageNum": 1,
    "userAccountOrName": "22",
    "storeCodeOrName": "222"
}

出参 ​

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

json
 {
  "code": 200,
  "msg": "success",
  "data": {
    "rows": [
      {
        "id": 255,
        "createTime": "2026-05-12 00:35:46",
        "createUser": "zhongmg2",
        "updateTime": null,
        "updateUser": null,
        "factoryNo": null,
        "isDelete": null,
        "userNo": null,
        "userAccount": "zhongmg2",
        "userName": "zhongmg2",
        "storeNo": null,
        "storeNoList": null,
        "storeCode": "STORE-02",
        "storeName": "TOOL ROOM B2"
      },
      {
        "id": 254,
        "createTime": "2026-05-12 00:35:46",
        "createUser": "zhongmg2",
        "updateTime": null,
        "updateUser": null,
        "factoryNo": null,
        "isDelete": null,
        "userNo": null,
        "userAccount": "zhongmg2",
        "userName": "zhongmg2",
        "storeNo": null,
        "storeNoList": null,
        "storeCode": "STORE-01",
        "storeName": "TOOL ROOM B1"
      },
      {
        "id": 197,
        "createTime": "2025-05-15 03:30:52",
        "createUser": "yangkx2",
        "updateTime": null,
        "updateUser": null,
        "factoryNo": null,
        "isDelete": null,
        "userNo": null,
        "userAccount": "yangkx2",
        "userName": "yangkx2",
        "storeNo": null,
        "storeNoList": null,
        "storeCode": "STORE-02",
        "storeName": "TOOL ROOM B2"
      },
      {
        "id": 198,
        "createTime": "2025-05-15 03:30:52",
        "createUser": "yangkx2",
        "updateTime": null,
        "updateUser": null,
        "factoryNo": null,
        "isDelete": null,
        "userNo": null,
        "userAccount": "yangkx2",
        "userName": "yangkx2",
        "storeNo": null,
        "storeNoList": null,
        "storeCode": "STORE-01",
        "storeName": "TOOL ROOM B1"
      },
      {
        "id": 130,
        "createTime": "2024-10-24 04:20:31",
        "createUser": "yuman2",
        "updateTime": null,
        "updateUser": null,
        "factoryNo": null,
        "isDelete": null,
        "userNo": null,
        "userAccount": "yuman2",
        "userName": "yuman2",
        "storeNo": null,
        "storeNoList": null,
        "storeCode": "STORE-02",
        "storeName": "TOOL ROOM B2"
      },
      {
        "id": 129,
        "createTime": "2024-10-24 04:20:31",
        "createUser": "yuman2",
        "updateTime": null,
        "updateUser": null,
        "factoryNo": null,
        "isDelete": null,
        "userNo": null,
        "userAccount": "yuman2",
        "userName": "yuman2",
        "storeNo": null,
        "storeNoList": null,
        "storeCode": "STORE-01",
        "storeName": "TOOL ROOM B1"
      },
      {
        "id": 128,
        "createTime": "2024-10-22 21:47:38",
        "createUser": "yexl8",
        "updateTime": null,
        "updateUser": null,
        "factoryNo": null,
        "isDelete": null,
        "userNo": null,
        "userAccount": "yexl8",
        "userName": "Xiaolong",
        "storeNo": null,
        "storeNoList": null,
        "storeCode": "STORE-02",
        "storeName": "TOOL ROOM B2"
      },
      {
        "id": 127,
        "createTime": "2024-10-22 21:47:38",
        "createUser": "yexl8",
        "updateTime": null,
        "updateUser": null,
        "factoryNo": null,
        "isDelete": null,
        "userNo": null,
        "userAccount": "yexl8",
        "userName": "Xiaolong",
        "storeNo": null,
        "storeNoList": null,
        "storeCode": "STORE-01",
        "storeName": "TOOL ROOM B1"
      },
      {
        "id": 120,
        "createTime": "2024-08-29 22:10:12",
        "createUser": "jflores6",
        "updateTime": null,
        "updateUser": null,
        "factoryNo": null,
        "isDelete": null,
        "userNo": null,
        "userAccount": "mrodriguez20",
        "userName": "Mauricio",
        "storeNo": null,
        "storeNoList": null,
        "storeCode": "STORE-02",
        "storeName": "TOOL ROOM B2"
      },
      {
        "id": 119,
        "createTime": "2024-08-29 22:08:49",
        "createUser": "jflores6",
        "updateTime": null,
        "updateUser": null,
        "factoryNo": null,
        "isDelete": null,
        "userNo": null,
        "userAccount": "mrodriguez20",
        "userName": "Mauricio",
        "storeNo": null,
        "storeNoList": null,
        "storeCode": "STORE-01",
        "storeName": "TOOL ROOM B1"
      }
    ],
    "total": 10
  }
}

前端校验规则 ​

无

后端逻辑 ​

业务流程：按筛选条件检索仓库权限 -> 分页查询权限与仓库信息 -> 按创建时间倒序返回结果

├── 执行分页查询
│   ├── StorePermissionServiceImpl.query :65-69
│   └── StorePermissionMapper.search :68
│       ├── 查询 store_permission 与 store_main 关联数据
│       ├── 仅查询未删除权限与未删除仓库
│       ├── 按用户账号/姓名模糊筛选
│       ├── 按仓库编码/名称模糊筛选
│       └── 按仓库名称集合筛选
└── 结果排序
    └── 按创建时间倒序

后端校验规则 ​

无

涉及数据库表 ​

库名.表名mapper.statement描述
store.store_permissionStorePermissionMapper.selectPage按筛选条件分页查询storePermission数据
permission_mapperpermissionMapper.searchpermissionMapper