Skip to content

POST /dm-store/line/page

Content-Type: application/json

触发按钮:pageAjax

入参

字段类型必填多选校验规则说明
processCode字符串工序编码
processName字符串工序名称
lineCode字符串产线编码
lineName字符串产线名称
startTime日期合法日期格式 yyyy-MM-dd开始时间
endTime日期合法日期格式 yyyy-MM-dd,结束时间不早于开始时间结束时间

实际入参:

json
{
    "pageSize": 10,
    "pageNum": 1,
    "processCode": "22",
    "processName": "22",
    "lineCode": "222",
    "lineName": "2222",
    "startTime": "2026-05-07",
    "endTime": "2026-06-10"
}

出参

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

json
{
  "code": 200,
  "msg": "success",
  "data": {
    "rows": [
      {
        "id": null,
        "createTime": "2024-12-03 08:56:48",
        "createUser": "mrodriguez20",
        "updateTime": "2024-12-03 15:30:16",
        "updateUser": "mrodriguez20",
        "factoryNo": null,
        "isDelete": null,
        "lineId": 86,
        "processId": 38,
        "processCode": "A00001",
        "processName": "REVISION",
        "processNo": "000039",
        "lineNo": "000085",
        "lineCode": "B2MTY-LINE-202",
        "lineName": "B2-STREAM LINE 3",
        "validFlag": 1,
        "productLineNo": "000213",
        "productLineName": "MTY-ISG",
        "productLineCode": "LENOVO"
      },
      {
        "id": null,
        "createTime": "2024-12-03 08:56:15",
        "createUser": "mrodriguez20",
        "updateTime": "2024-12-03 15:30:16",
        "updateUser": "mrodriguez20",
        "factoryNo": null,
        "isDelete": null,
        "lineId": 85,
        "processId": 38,
        "processCode": "A00001",
        "processName": "REVISION",
        "processNo": "000039",
        "lineNo": "000084",
        "lineCode": "B2MTY-LINE-201",
        "lineName": "B2-STREAM LINE 2",
        "validFlag": 1,
        "productLineNo": "000213",
        "productLineName": "MTY-ISG",
        "productLineCode": "LENOVO"
      },
      {
        "id": null,
        "createTime": "2024-12-03 08:55:36",
        "createUser": "mrodriguez20",
        "updateTime": "2024-12-03 15:30:16",
        "updateUser": "mrodriguez20",
        "factoryNo": null,
        "isDelete": null,
        "lineId": 84,
        "processId": 38,
        "processCode": "A00001",
        "processName": "REVISION",
        "processNo": "000039",
        "lineNo": "000083",
        "lineCode": "B2MTY-LINE-200",
        "lineName": "B2-STREAM LINE 1",
        "validFlag": 1,
        "productLineNo": "000213",
        "productLineName": "MTY-ISG",
        "productLineCode": "LENOVO"
      },
      {
        "id": null,
        "createTime": "2024-12-02 16:34:22",
        "createUser": "mrodriguez20",
        "updateTime": "2024-12-03 15:30:16",
        "updateUser": "mrodriguez20",
        "factoryNo": null,
        "isDelete": null,
        "lineId": 83,
        "processId": 38,
        "processCode": "A00001",
        "processName": "REVISION",
        "processNo": "000039",
        "lineNo": "000082",
        "lineCode": "B1MTY LINE 035",
        "lineName": "STREAM LINE 3.5",
        "validFlag": 1,
        "productLineNo": "000213",
        "productLineName": "MTY-ISG",
        "productLineCode": "LENOVO"
      },
      {
        "id": null,
        "createTime": "2024-09-10 17:20:15",
        "createUser": "mrodriguez20",
        "updateTime": "2024-12-03 15:30:16",
        "updateUser": "mrodriguez20",
        "factoryNo": null,
        "isDelete": null,
        "lineId": 82,
        "processId": 38,
        "processCode": "A00001",
        "processName": "REVISION",
        "processNo": "000039",
        "lineNo": "000081",
        "lineCode": "B2MTY-LINE-005",
        "lineName": "B2-LINEA DOS",
        "validFlag": 1,
        "productLineNo": "000213",
        "productLineName": "MTY-ISG",
        "productLineCode": "LENOVO"
      },
      {
        "id": null,
        "createTime": "2024-09-10 17:20:02",
        "createUser": "mrodriguez20",
        "updateTime": "2024-12-03 15:30:16",
        "updateUser": "mrodriguez20",
        "factoryNo": null,
        "isDelete": null,
        "lineId": 81,
        "processId": 38,
        "processCode": "A00001",
        "processName": "REVISION",
        "processNo": "000039",
        "lineNo": "000080",
        "lineCode": "B2MTY-LINE-004",
        "lineName": "B2-LINEA UNO",
        "validFlag": 1,
        "productLineNo": "000213",
        "productLineName": "MTY-ISG",
        "productLineCode": "LENOVO"
      },
      {
        "id": null,
        "createTime": "2024-09-10 17:19:42",
        "createUser": "mrodriguez20",
        "updateTime": "2024-12-03 15:30:16",
        "updateUser": "mrodriguez20",
        "factoryNo": null,
        "isDelete": null,
        "lineId": 80,
        "processId": 38,
        "processCode": "A00001",
        "processName": "REVISION",
        "processNo": "000039",
        "lineNo": "000079",
        "lineCode": "B2MTY-CORT-001",
        "lineName": "B2-CORT_ESQ_NEUM",
        "validFlag": 1,
        "productLineNo": "000213",
        "productLineName": "MTY-ISG",
        "productLineCode": "LENOVO"
      },
      {
        "id": null,
        "createTime": "2024-09-10 17:19:21",
        "createUser": "mrodriguez20",
        "updateTime": "2024-12-03 15:30:16",
        "updateUser": "mrodriguez20",
        "factoryNo": null,
        "isDelete": null,
        "lineId": 79,
        "processId": 38,
        "processCode": "A00001",
        "processName": "REVISION",
        "processNo": "000039",
        "lineNo": "000078",
        "lineCode": "B1MTY-LINE 018",
        "lineName": "B1-MTR_EXTR_BIOS",
        "validFlag": 1,
        "productLineNo": "000214",
        "productLineName": "MTY-IDG",
        "productLineCode": "LCT"
      },
      {
        "id": null,
        "createTime": "2024-09-10 17:18:26",
        "createUser": "mrodriguez20",
        "updateTime": "2024-12-03 15:30:16",
        "updateUser": "mrodriguez20",
        "factoryNo": null,
        "isDelete": null,
        "lineId": 78,
        "processId": 38,
        "processCode": "A00001",
        "processName": "REVISION",
        "processNo": "000039",
        "lineNo": "000077",
        "lineCode": "B1MTY-LINE 016",
        "lineName": "STREAM LINE 2.5",
        "validFlag": 1,
        "productLineNo": "000214",
        "productLineName": "MTY-IDG",
        "productLineCode": "LCT"
      },
      {
        "id": null,
        "createTime": "2024-09-10 17:18:09",
        "createUser": "mrodriguez20",
        "updateTime": "2024-12-03 15:30:16",
        "updateUser": "mrodriguez20",
        "factoryNo": null,
        "isDelete": null,
        "lineId": 77,
        "processId": 38,
        "processCode": "A00001",
        "processName": "REVISION",
        "processNo": "000039",
        "lineNo": "000076",
        "lineCode": "B1MTY-LINE 015",
        "lineName": "STREAM LINE 4",
        "validFlag": 1,
        "productLineNo": "000214",
        "productLineName": "MTY-IDG",
        "productLineCode": "LCT"
      }
    ],
    "total": 28
  }
}

前端校验规则

后端逻辑

业务流程:整理筛选与排序条件 -> 按条件分页检索未删除线体 -> 关联工序与产品线信息返回列表

├── 整理筛选与排序条件:LineServiceImpl.query :90-97
│   ├── 规范查询时间范围
│   └── 转换排序字段
└── 分页查询线体及关联信息:LineServiceImpl.query :98
    └── LineMapper.search :23
        ├── 关联工序与产品线
        ├── 仅查询未删除数据
        ├── 按有效标识、工厂、工序、线体、时间范围、产品线筛选
        └── 按指定字段或创建时间倒序排序

后端校验规则

涉及数据库表

库名.表名mapper.statement描述
store.lineLineMapper.selectPage按筛选条件分页查询line数据
line_mapperlineMapper.searchlineMapper