Skip to content

POST /dm-store/manufacturer/page

Content-Type: application/json

触发按钮:pageAjax

入参

传递对象:ManufacturerQueryVo

字段类型必填多选校验规则说明
fieldString--
orderString--
factoryNoString--
idsList<Long>-id集合
manufacturerCodeString-制造商编码
manufacturerNameString-制造商名称

实际入参:

json
{
    "pageSize": 10,
    "pageNum": 1,
    "manufacturerCode": "22",
    "manufacturerName": "222"
}

出参

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

json
{
  "code": 200,
  "msg": "success",
  "data": {
    "rows": [
      {
        "id": 133,
        "createTime": "2024-11-26 12:52:57",
        "createUser": "mrodriguez20",
        "updateTime": "2024-11-26 12:52:57",
        "updateUser": "mrodriguez20",
        "factoryNo": "000027",
        "isDelete": 0,
        "manufacturerNo": "000133",
        "manufacturerCode": "LAVAMANOS",
        "manufacturerName": "MANUFACTURADOS",
        "address": "",
        "contacter": "",
        "phone": "",
        "email": "",
        "fax": "",
        "url": "",
        "description": "",
        "validFlag": 1
      },
      {
        "id": 132,
        "createTime": "2024-09-27 14:25:43",
        "createUser": "mrodriguez20",
        "updateTime": "2024-09-27 14:25:43",
        "updateUser": "mrodriguez20",
        "factoryNo": "000027",
        "isDelete": 0,
        "manufacturerNo": "000132",
        "manufacturerCode": "COMPRESOR D AIRE 40HP",
        "manufacturerName": "KAESER",
        "address": "",
        "contacter": "",
        "phone": "",
        "email": "",
        "fax": "",
        "url": "",
        "description": "",
        "validFlag": 1
      },
      {
        "id": 131,
        "createTime": "2024-09-27 14:24:55",
        "createUser": "mrodriguez20",
        "updateTime": "2024-09-27 14:24:55",
        "updateUser": "mrodriguez20",
        "factoryNo": "000027",
        "isDelete": 0,
        "manufacturerNo": "000131",
        "manufacturerCode": "COMPRESOR DE AIRE 40HP",
        "manufacturerName": "DAN AIR",
        "address": "",
        "contacter": "",
        "phone": "",
        "email": "",
        "fax": "",
        "url": "",
        "description": "",
        "validFlag": 1
      },
      {
        "id": 130,
        "createTime": "2024-09-26 09:38:14",
        "createUser": "mrodriguez20",
        "updateTime": "2024-09-26 09:38:14",
        "updateUser": "mrodriguez20",
        "factoryNo": "000027",
        "isDelete": 0,
        "manufacturerNo": "000130",
        "manufacturerCode": "TORQUE ELECTRICOS",
        "manufacturerName": "DELTA REGIS",
        "address": "",
        "contacter": "",
        "phone": "",
        "email": "",
        "fax": "",
        "url": "",
        "description": "",
        "validFlag": 1
      },
      {
        "id": 129,
        "createTime": "2024-09-11 13:38:52",
        "createUser": "mrodriguez20",
        "updateTime": "2024-09-11 13:38:52",
        "updateUser": "mrodriguez20",
        "factoryNo": "000027",
        "isDelete": 0,
        "manufacturerNo": "000129",
        "manufacturerCode": "HVAC",
        "manufacturerName": "TRANE",
        "address": "",
        "contacter": "",
        "phone": "",
        "email": "",
        "fax": "",
        "url": "",
        "description": "",
        "validFlag": 1
      },
      {
        "id": 128,
        "createTime": "2024-09-05 12:41:23",
        "createUser": "mrodriguez20",
        "updateTime": "2024-09-05 12:41:23",
        "updateUser": "mrodriguez20",
        "factoryNo": "000027",
        "isDelete": 0,
        "manufacturerNo": "000128",
        "manufacturerCode": "AIRE ACONDICIONADO",
        "manufacturerName": "YORK",
        "address": null,
        "contacter": null,
        "phone": null,
        "email": null,
        "fax": null,
        "url": null,
        "description": null,
        "validFlag": 1
      },
      {
        "id": 127,
        "createTime": "2024-09-05 12:41:23",
        "createUser": "mrodriguez20",
        "updateTime": "2024-09-05 12:41:23",
        "updateUser": "mrodriguez20",
        "factoryNo": "000027",
        "isDelete": 0,
        "manufacturerNo": "000127",
        "manufacturerCode": "AIRE ACONDICIONADO",
        "manufacturerName": "MIRAGE",
        "address": null,
        "contacter": null,
        "phone": null,
        "email": null,
        "fax": null,
        "url": null,
        "description": null,
        "validFlag": 1
      },
      {
        "id": 126,
        "createTime": "2024-09-05 12:41:23",
        "createUser": "mrodriguez20",
        "updateTime": "2024-09-05 12:41:23",
        "updateUser": "mrodriguez20",
        "factoryNo": "000027",
        "isDelete": 0,
        "manufacturerNo": "000126",
        "manufacturerCode": "AIRE ACONDICIONADO",
        "manufacturerName": "CARRIER",
        "address": null,
        "contacter": null,
        "phone": null,
        "email": null,
        "fax": null,
        "url": null,
        "description": null,
        "validFlag": 1
      },
      {
        "id": 125,
        "createTime": "2024-09-05 12:41:23",
        "createUser": "mrodriguez20",
        "updateTime": "2024-09-05 12:41:23",
        "updateUser": "mrodriguez20",
        "factoryNo": "000027",
        "isDelete": 0,
        "manufacturerNo": "000125",
        "manufacturerCode": "BOMBA CENTRIFUGA",
        "manufacturerName": "PATTERSON",
        "address": null,
        "contacter": null,
        "phone": null,
        "email": null,
        "fax": null,
        "url": null,
        "description": null,
        "validFlag": 1
      },
      {
        "id": 124,
        "createTime": "2024-09-05 12:41:23",
        "createUser": "mrodriguez20",
        "updateTime": "2024-09-05 12:41:23",
        "updateUser": "mrodriguez20",
        "factoryNo": "000027",
        "isDelete": 0,
        "manufacturerNo": "000124",
        "manufacturerCode": "AIRE ACONDICIONADO",
        "manufacturerName": "LENNOX",
        "address": null,
        "contacter": null,
        "phone": null,
        "email": null,
        "fax": null,
        "url": null,
        "description": null,
        "validFlag": 1
      }
    ],
    "total": 71
  }
}

前端校验规则

后端逻辑

业务流程:按条件筛选制造商 -> 确定排序规则 -> 分页查询未删除制造商 -> 返回分页列表

├── 组装筛选条件:ManufacturerServiceImpl.findManufacturerCondition :73
│   ├── 按制造商名称模糊匹配
│   ├── 按制造商编码模糊匹配
│   └── 条件: isDelete=0
├── 确定排序规则:ManufacturerServiceImpl.findManufacturerCondition :106-117
│   ├── 未指定排序时按创建时间倒序
│   └── 指定字段时按前端排序方向处理
└── 分页查询制造商:page :78

后端校验规则

涉及数据库表

库名.表名mapper.statement描述
store.manufacturerManufacturerMapper.selectPage按筛选条件分页查询manufacturer数据