Skip to content

POST /dm-store/supplier/page

Content-Type: application/json

触发按钮:pageAjax

入参

传递对象:SupplierQueryVo

字段类型必填多选校验规则说明
fieldString--
orderString--
factoryNoString--
idsList<Long>--
supplierCodeString-供应商编码
supplierNameString-供应商名称

实际入参:

json
{
    "pageSize": 10,
    "pageNum": 1,
    "supplierCode": "22",
    "supplierName": "2222"
}

出参

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

json
{
  "code": 200,
  "msg": "success",
  "data": {
    "rows": [
      {
        "id": 198,
        "createTime": "2026-05-25 21:38:16",
        "createUser": "zhongmg2",
        "updateTime": "2026-05-25 21:38:16",
        "updateUser": "zhongmg2",
        "factoryNo": "000027",
        "isDelete": 0,
        "supplierNo": "000206",
        "supplierCode": "22",
        "supplierName": "2",
        "address": "22",
        "contacter": "22",
        "phone": "22",
        "email": "asdjasd@ww.com",
        "fax": "22",
        "url": "222",
        "description": "ssss",
        "validFlag": 1
      },
      {
        "id": 169,
        "createTime": "2024-09-06 10:11:35",
        "createUser": "mrodriguez20",
        "updateTime": "2024-09-06 10:11:35",
        "updateUser": "mrodriguez20",
        "factoryNo": "000027",
        "isDelete": 0,
        "supplierNo": "000177",
        "supplierCode": "4049846",
        "supplierName": "Ortega Martinez",
        "address": "MONTERREY N.L",
        "contacter": null,
        "phone": "8121968873",
        "email": null,
        "fax": null,
        "url": null,
        "description": "proveedor",
        "validFlag": 1
      },
      {
        "id": 168,
        "createTime": "2024-09-06 10:11:35",
        "createUser": "mrodriguez20",
        "updateTime": "2024-09-06 10:11:35",
        "updateUser": "mrodriguez20",
        "factoryNo": "000027",
        "isDelete": 0,
        "supplierNo": "000176",
        "supplierCode": "4022123",
        "supplierName": "TRISTAN",
        "address": "MONTERREY N.L",
        "contacter": null,
        "phone": null,
        "email": null,
        "fax": null,
        "url": null,
        "description": "proveedor",
        "validFlag": 1
      },
      {
        "id": 167,
        "createTime": "2024-09-06 10:11:35",
        "createUser": "mrodriguez20",
        "updateTime": "2024-09-06 10:11:35",
        "updateUser": "mrodriguez20",
        "factoryNo": "000027",
        "isDelete": 0,
        "supplierNo": "000175",
        "supplierCode": "4048038",
        "supplierName": "AISEN",
        "address": "APODACA N.L.",
        "contacter": null,
        "phone": "83-21-25-82",
        "email": null,
        "fax": null,
        "url": null,
        "description": "proveedor",
        "validFlag": 1
      },
      {
        "id": 166,
        "createTime": "2024-09-06 10:11:35",
        "createUser": "mrodriguez20",
        "updateTime": "2024-09-06 10:11:35",
        "updateUser": "mrodriguez20",
        "factoryNo": "000027",
        "isDelete": 0,
        "supplierNo": "000174",
        "supplierCode": "4049193",
        "supplierName": "THERMALTEC",
        "address": "MONTERREY N.L",
        "contacter": null,
        "phone": "8120105429",
        "email": null,
        "fax": null,
        "url": null,
        "description": "proveedor",
        "validFlag": 1
      },
      {
        "id": 165,
        "createTime": "2024-09-06 10:11:35",
        "createUser": "mrodriguez20",
        "updateTime": "2024-09-06 10:11:35",
        "updateUser": "mrodriguez20",
        "factoryNo": "000027",
        "isDelete": 0,
        "supplierNo": "000173",
        "supplierCode": "1900101269",
        "supplierName": "EVARISTO",
        "address": "SAN PEDRO N.L",
        "contacter": null,
        "phone": "8117799647",
        "email": null,
        "fax": null,
        "url": null,
        "description": "proveedor",
        "validFlag": 1
      },
      {
        "id": 164,
        "createTime": "2024-09-06 10:11:35",
        "createUser": "mrodriguez20",
        "updateTime": "2024-09-06 10:11:35",
        "updateUser": "mrodriguez20",
        "factoryNo": "000027",
        "isDelete": 0,
        "supplierNo": "000172",
        "supplierCode": "4049472",
        "supplierName": "REDELEC",
        "address": "MONTERREY N.L",
        "contacter": null,
        "phone": "8111891712",
        "email": null,
        "fax": null,
        "url": null,
        "description": "proveedor",
        "validFlag": 1
      },
      {
        "id": 163,
        "createTime": "2024-09-06 10:11:35",
        "createUser": "mrodriguez20",
        "updateTime": "2024-09-06 10:11:35",
        "updateUser": "mrodriguez20",
        "factoryNo": "000027",
        "isDelete": 0,
        "supplierNo": "000171",
        "supplierCode": "4051563",
        "supplierName": "MECATRONICA",
        "address": "ESCOBEDO N.L.",
        "contacter": null,
        "phone": "83977175",
        "email": null,
        "fax": null,
        "url": null,
        "description": "proveedor",
        "validFlag": 1
      },
      {
        "id": 162,
        "createTime": "2024-09-06 10:11:35",
        "createUser": "mrodriguez20",
        "updateTime": "2024-09-06 10:11:35",
        "updateUser": "mrodriguez20",
        "factoryNo": "000027",
        "isDelete": 0,
        "supplierNo": "000170",
        "supplierCode": "4005017",
        "supplierName": "BARRON",
        "address": "APODACA N.L.",
        "contacter": null,
        "phone": null,
        "email": null,
        "fax": null,
        "url": null,
        "description": "proveedor",
        "validFlag": 1
      },
      {
        "id": 161,
        "createTime": "2024-09-06 10:11:35",
        "createUser": "mrodriguez20",
        "updateTime": "2024-09-06 10:11:35",
        "updateUser": "mrodriguez20",
        "factoryNo": "000027",
        "isDelete": 0,
        "supplierNo": "000169",
        "supplierCode": "4019413",
        "supplierName": "ALLIANCE",
        "address": "GUADALUPE N.L.",
        "contacter": null,
        "phone": "8118101588",
        "email": null,
        "fax": null,
        "url": null,
        "description": "proveedor",
        "validFlag": 1
      }
    ],
    "total": 52
  }
}

前端校验规则

后端逻辑

业务流程:按条件筛选供应商 -> 按排序规则分页查询 -> 返回供应商分页结果

├── 组装筛选条件 :93-117
│   ├── 按供应商名称模糊筛选 :99-100
│   ├── 按供应商编码模糊筛选 :101-102
│   ├── 判断是否指定排序字段 :103-113
│   │   ├── 否
│   │   │   └── 默认按创建时间倒序 :104
│   │   └── 是
│   │       └── 按指定字段升降序排序 :106-113
│   └── 仅查询未删除供应商 :116
├── 分页查询供应商 :76-85
│   ├── 组装条件:SupplierServiceImpl.findSupplierCondition :78
│   └── 分页查询:page :83
└── 返回供应商分页结果

后端校验规则

涉及数据库表

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