DM-ROW 接口文档

Appearance

POST /dm-device/deviceIssues/page ​

Content-Type: application/json

触发按钮：getPageListAjax

入参 ​

实际入参:

json
{
    "pageSize": 10,
    "pageNum": 1,
    "deviceClassify": null,
    "deviceTypeName": "",
    "deviceTypeNo": "",
    "issueClassify": 1,
    "issueCode": "2",
    "parentIssueCode": "",
    "description": "222"
}

出参 ​

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

json
{
  "code": 200,
  "msg": "success",
  "data": {
    "records": [
      {
        "id": 255,
        "createTime": "2024-09-10 15:37:18",
        "createUser": "mrodriguez20",
        "updateTime": "2024-09-10 15:37:18",
        "updateUser": "mrodriguez20",
        "factoryNo": "000027",
        "isDelete": 0,
        "deviceTypeNo": null,
        "deviceTypeName": null,
        "deviceClassify": null,
        "deptNoOfDevice": null,
        "name": null,
        "issueCode": "EX000154",
        "issueName": null,
        "updateIssueCode": null,
        "issueClassify": 7,
        "descriptions": [],
        "deviceModel": null,
        "deptNo": "0000027",
        "status": 0,
        "deviceCode": null,
        "actionClassify": null,
        "deviceIssueCode": null,
        "deviceName": null,
        "deviceNo": null,
        "deptName": null,
        "lineNo": null,
        "lineName": null,
        "deviceManufacturer": null,
        "icdDescription": null,
        "description": "Falla en porton acceso\n",
        "interimMeasure": null,
        "permanentMeasure": null,
        "productLineNo": null,
        "productLineName": null,
        "auditNo": null,
        "auditStatus": null,
        "addAuditStatus": 0,
        "isTriggerOrder": null
      },
      {
        "id": 254,
        "createTime": "2024-09-10 15:37:12",
        "createUser": "mrodriguez20",
        "updateTime": "2024-09-10 15:37:12",
        "updateUser": "mrodriguez20",
        "factoryNo": "000027",
        "isDelete": 0,
        "deviceTypeNo": null,
        "deviceTypeName": null,
        "deviceClassify": null,
        "deptNoOfDevice": null,
        "name": null,
        "issueCode": "EX000153",
        "issueName": null,
        "updateIssueCode": null,
        "issueClassify": 7,
        "descriptions": [],
        "deviceModel": null,
        "deptNo": "0000027",
        "status": 0,
        "deviceCode": null,
        "actionClassify": null,
        "deviceIssueCode": null,
        "deviceName": null,
        "deviceNo": null,
        "deptName": null,
        "lineNo": null,
        "lineName": null,
        "deviceManufacturer": null,
        "icdDescription": null,
        "description": "Falla en UPS\n",
        "interimMeasure": null,
        "permanentMeasure": null,
        "productLineNo": null,
        "productLineName": null,
        "auditNo": null,
        "auditStatus": null,
        "addAuditStatus": 0,
        "isTriggerOrder": null
      },
      {
        "id": 253,
        "createTime": "2024-09-10 15:37:06",
        "createUser": "mrodriguez20",
        "updateTime": "2024-09-10 15:37:06",
        "updateUser": "mrodriguez20",
        "factoryNo": "000027",
        "isDelete": 0,
        "deviceTypeNo": null,
        "deviceTypeName": null,
        "deviceClassify": null,
        "deptNoOfDevice": null,
        "name": null,
        "issueCode": "EX000152",
        "issueName": null,
        "updateIssueCode": null,
        "issueClassify": 7,
        "descriptions": [],
        "deviceModel": null,
        "deptNo": "0000027",
        "status": 0,
        "deviceCode": null,
        "actionClassify": null,
        "deviceIssueCode": null,
        "deviceName": null,
        "deviceNo": null,
        "deptName": null,
        "lineNo": null,
        "lineName": null,
        "deviceManufacturer": null,
        "icdDescription": null,
        "description": "Daño plafon\n",
        "interimMeasure": null,
        "permanentMeasure": null,
        "productLineNo": null,
        "productLineName": null,
        "auditNo": null,
        "auditStatus": null,
        "addAuditStatus": 0,
        "isTriggerOrder": null
      },
      {
        "id": 252,
        "createTime": "2024-09-10 15:37:01",
        "createUser": "mrodriguez20",
        "updateTime": "2024-09-10 15:37:01",
        "updateUser": "mrodriguez20",
        "factoryNo": "000027",
        "isDelete": 0,
        "deviceTypeNo": null,
        "deviceTypeName": null,
        "deviceClassify": null,
        "deptNoOfDevice": null,
        "name": null,
        "issueCode": "EX000151",
        "issueName": null,
        "updateIssueCode": null,
        "issueClassify": 7,
        "descriptions": [],
        "deviceModel": null,
        "deptNo": "0000027",
        "status": 0,
        "deviceCode": null,
        "actionClassify": null,
        "deviceIssueCode": null,
        "deviceName": null,
        "deviceNo": null,
        "deptName": null,
        "lineNo": null,
        "lineName": null,
        "deviceManufacturer": null,
        "icdDescription": null,
        "description": "Alfombra dañada\n",
        "interimMeasure": null,
        "permanentMeasure": null,
        "productLineNo": null,
        "productLineName": null,
        "auditNo": null,
        "auditStatus": null,
        "addAuditStatus": 0,
        "isTriggerOrder": null
      },
      {
        "id": 251,
        "createTime": "2024-09-10 15:36:53",
        "createUser": "mrodriguez20",
        "updateTime": "2024-09-10 15:36:53",
        "updateUser": "mrodriguez20",
        "factoryNo": "000027",
        "isDelete": 0,
        "deviceTypeNo": null,
        "deviceTypeName": null,
        "deviceClassify": null,
        "deptNoOfDevice": null,
        "name": null,
        "issueCode": "EX000150",
        "issueName": null,
        "updateIssueCode": null,
        "issueClassify": 7,
        "descriptions": [],
        "deviceModel": null,
        "deptNo": "0000027",
        "status": 0,
        "deviceCode": null,
        "actionClassify": null,
        "deviceIssueCode": null,
        "deviceName": null,
        "deviceNo": null,
        "deptName": null,
        "lineNo": null,
        "lineName": null,
        "deviceManufacturer": null,
        "icdDescription": null,
        "description": "Falla en trampa de grasa\n",
        "interimMeasure": null,
        "permanentMeasure": null,
        "productLineNo": null,
        "productLineName": null,
        "auditNo": null,
        "auditStatus": null,
        "addAuditStatus": 0,
        "isTriggerOrder": null
      },
      {
        "id": 250,
        "createTime": "2024-09-10 15:36:43",
        "createUser": "mrodriguez20",
        "updateTime": "2024-09-10 15:36:43",
        "updateUser": "mrodriguez20",
        "factoryNo": "000027",
        "isDelete": 0,
        "deviceTypeNo": null,
        "deviceTypeName": null,
        "deviceClassify": null,
        "deptNoOfDevice": null,
        "name": null,
        "issueCode": "EX000149",
        "issueName": null,
        "updateIssueCode": null,
        "issueClassify": 7,
        "descriptions": [],
        "deviceModel": null,
        "deptNo": "0000027",
        "status": 0,
        "deviceCode": null,
        "actionClassify": null,
        "deviceIssueCode": null,
        "deviceName": null,
        "deviceNo": null,
        "deptName": null,
        "lineNo": null,
        "lineName": null,
        "deviceManufacturer": null,
        "icdDescription": null,
        "description": "Falla de extractor\n",
        "interimMeasure": null,
        "permanentMeasure": null,
        "productLineNo": null,
        "productLineName": null,
        "auditNo": null,
        "auditStatus": null,
        "addAuditStatus": 0,
        "isTriggerOrder": null
      },
      {
        "id": 249,
        "createTime": "2024-09-10 15:36:36",
        "createUser": "mrodriguez20",
        "updateTime": "2024-09-10 15:36:36",
        "updateUser": "mrodriguez20",
        "factoryNo": "000027",
        "isDelete": 0,
        "deviceTypeNo": null,
        "deviceTypeName": null,
        "deviceClassify": null,
        "deptNoOfDevice": null,
        "name": null,
        "issueCode": "EX000148",
        "issueName": null,
        "updateIssueCode": null,
        "issueClassify": 7,
        "descriptions": [],
        "deviceModel": null,
        "deptNo": "0000027",
        "status": 0,
        "deviceCode": null,
        "actionClassify": null,
        "deviceIssueCode": null,
        "deviceName": null,
        "deviceNo": null,
        "deptName": null,
        "lineNo": null,
        "lineName": null,
        "deviceManufacturer": null,
        "icdDescription": null,
        "description": "Falla en riego\n",
        "interimMeasure": null,
        "permanentMeasure": null,
        "productLineNo": null,
        "productLineName": null,
        "auditNo": null,
        "auditStatus": null,
        "addAuditStatus": 0,
        "isTriggerOrder": null
      },
      {
        "id": 248,
        "createTime": "2024-09-10 15:36:30",
        "createUser": "mrodriguez20",
        "updateTime": "2024-09-10 15:36:30",
        "updateUser": "mrodriguez20",
        "factoryNo": "000027",
        "isDelete": 0,
        "deviceTypeNo": null,
        "deviceTypeName": null,
        "deviceClassify": null,
        "deptNoOfDevice": null,
        "name": null,
        "issueCode": "EX000147",
        "issueName": null,
        "updateIssueCode": null,
        "issueClassify": 7,
        "descriptions": [],
        "deviceModel": null,
        "deptNo": "0000027",
        "status": 0,
        "deviceCode": null,
        "actionClassify": null,
        "deviceIssueCode": null,
        "deviceName": null,
        "deviceNo": null,
        "deptName": null,
        "lineNo": null,
        "lineName": null,
        "deviceManufacturer": null,
        "icdDescription": null,
        "description": "Falla en patines hidraulicos\n",
        "interimMeasure": null,
        "permanentMeasure": null,
        "productLineNo": null,
        "productLineName": null,
        "auditNo": null,
        "auditStatus": null,
        "addAuditStatus": 0,
        "isTriggerOrder": null
      },
      {
        "id": 247,
        "createTime": "2024-09-10 15:36:22",
        "createUser": "mrodriguez20",
        "updateTime": "2024-09-10 15:36:22",
        "updateUser": "mrodriguez20",
        "factoryNo": "000027",
        "isDelete": 0,
        "deviceTypeNo": null,
        "deviceTypeName": null,
        "deviceClassify": null,
        "deptNoOfDevice": null,
        "name": null,
        "issueCode": "EX000146",
        "issueName": null,
        "updateIssueCode": null,
        "issueClassify": 7,
        "descriptions": [],
        "deviceModel": null,
        "deptNo": "0000027",
        "status": 0,
        "deviceCode": null,
        "actionClassify": null,
        "deviceIssueCode": null,
        "deviceName": null,
        "deviceNo": null,
        "deptName": null,
        "lineNo": null,
        "lineName": null,
        "deviceManufacturer": null,
        "icdDescription": null,
        "description": "Loseta dañada\n",
        "interimMeasure": null,
        "permanentMeasure": null,
        "productLineNo": null,
        "productLineName": null,
        "auditNo": null,
        "auditStatus": null,
        "addAuditStatus": 0,
        "isTriggerOrder": null
      },
      {
        "id": 246,
        "createTime": "2024-09-10 15:36:15",
        "createUser": "mrodriguez20",
        "updateTime": "2024-09-10 15:36:15",
        "updateUser": "mrodriguez20",
        "factoryNo": "000027",
        "isDelete": 0,
        "deviceTypeNo": null,
        "deviceTypeName": null,
        "deviceClassify": null,
        "deptNoOfDevice": null,
        "name": null,
        "issueCode": "EX000145",
        "issueName": null,
        "updateIssueCode": null,
        "issueClassify": 7,
        "descriptions": [],
        "deviceModel": null,
        "deptNo": "0000027",
        "status": 0,
        "deviceCode": null,
        "actionClassify": null,
        "deviceIssueCode": null,
        "deviceName": null,
        "deviceNo": null,
        "deptName": null,
        "lineNo": null,
        "lineName": null,
        "deviceManufacturer": null,
        "icdDescription": null,
        "description": "Falla en osmosis\n",
        "interimMeasure": null,
        "permanentMeasure": null,
        "productLineNo": null,
        "productLineName": null,
        "auditNo": null,
        "auditStatus": null,
        "addAuditStatus": 0,
        "isTriggerOrder": null
      }
    ],
    "total": 117,
    "size": 10,
    "current": 1,
    "pages": 12
  }
}

前端校验规则 ​

权限校验
└── 页面权限
    └── v-auth: 'information:classification:search:popup'

后端逻辑 ​

业务流程：接收分页条件 -> 筛选设备问题知识 -> 关联设备与设备类型信息 -> 按排序规则返回分页结果

├── 分页查询问题知识:DeviceIssuesClassificationServiceImpl.pages :103-143
│   └── 查询问题知识分页:DeviceIssuesClassificationMapper.selectPage :132
├── 筛选设备问题知识
│   ├── 仅查询未删除问题记录
│   ├── 未传 status 时仅查询 status=0
│   ├── 传入 status 时按指定状态筛选
│   └── 按设备、问题分类、措施分类、时间等条件筛选
├── 关联设备与设备类型信息
│   ├── 补充设备名称、部门、线体、产品线、厂商品牌
│   └── 补充设备类型名称
└── 排序返回分页结果
    ├── 传入 field 和 order 时按指定字段排序
    └── 默认按更新时间、创建时间倒序

后端校验规则 ​

无

涉及数据库表 ​

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