按条件查询数据记录, 返回符合条件、带有分页信息的数据对象

models.模型名称.Paginate

Object Paginate 带有分页信息的数据对象

返回符合条件带有分页信息的数据对象, 其中数据记录集合 JSON 类型字段自动解析, AES 字段自动解密。 关联模型作为一个独立字段，字段名称为关联关系名称； hasOne 关联为数据记录 Object , hasMany 关联为数据记录数组 Array\<Object>。

Object Paginate 数据结构

models.user.Paginate

[
  {
    "select": ["id", "name", "mobile", "status", "extra"],
    "withs": { "manu": {}, "mother": {}, "addresses": {} },
    "wheres": [{ "column": "status", "value": "enabled" }],
    "limit": 2
  },
  1,
  2
]

{
  "data": [
    {
      "addresses": [
        {
          "city": "丰台区",
          "created_at": "2021-09-15T08:34:19+08:00",
          "deleted_at": null,
          "id": 2,
          "location": "北京国家数字出版基地A103",
          "province": "北京市",
          "status": "enabled",
          "updated_at": null,
          "user_id": 1
        }
      ],
      "extra": {
        "sex": "男"
      },
      "id": 1,
      "manu": {
        "contact_mobile": null,
        "contact_name": null,
        "created_at": "2021-09-15T08:34:14+08:00",
        "deleted_at": null,
        "desc": null,
        "id": 1,
        "link": null,
        "logo": null,
        "name": "北京云道天成科技有限公司",
        "rank": 9999999,
        "short_name": "云道天成",
        "status": "enabled",
        "summary": null,
        "type": "服务商",
        "updated_at": null
      },
      "mobile": "13900001111",
      "mother": {
        "extra": {
          "sex": "女"
        },
        "friends": {
          "friend_id": 2,
          "status": "enabled",
          "type": "monther"
        },
        "id": 2,
        "name": "员工",
        "secret": "wBeYjL7FjbcvpAdBrxtDFfjydsoPKhRN",
        "status": "enabled",
        "type": "staff"
      },
      "name": "管理员"
    },
    {
      "addresses": [
        {
          "city": "海淀区",
          "created_at": "2021-09-15T08:34:20+08:00",
          "deleted_at": null,
          "id": 3,
          "location": "华严北里7号楼7单元7层2048室",
          "province": "北京市",
          "status": "enabled",
          "updated_at": null,
          "user_id": 2
        }
      ],
      "extra": {
        "sex": "女"
      },
      "id": 2,
      "manu": {
        "contact_mobile": null,
        "contact_name": null,
        "created_at": "2021-09-15T08:34:14+08:00",
        "deleted_at": null,
        "desc": null,
        "id": 1,
        "link": null,
        "logo": null,
        "name": "北京云道天成科技有限公司",
        "rank": 9999999,
        "short_name": "云道天成",
        "status": "enabled",
        "summary": null,
        "type": "服务商",
        "updated_at": null
      },
      "mobile": "13900002222",
      "mother": {
        "extra": null,
        "friends": {
          "friend_id": null,
          "status": null,
          "type": null
        },
        "id": null,
        "name": null,
        "secret": null,
        "status": null,
        "type": null
      },
      "name": "员工"
    }
  ],
  "next": 2,
  "page": 1,
  "pagecnt": 2,
  "pagesize": 2,
  "prev": -1,
  "total": 3
}

{
  "nodes": [
    {
      "name": "users",
      "process": "models.user.Paginate",
      "args": [
        {
          "select": ["id", "name", "mobile", "status", "extra"],
          "withs": { "manu": {}, "mother": {}, "addresses": {} },
          "wheres": [{ "column": "status", "value": "enabled" }],
          "limit": 2
        },
        1,
        2
      ],
      "outs": ["{{$out.data}}"]
    }
  ]
}

{
  "paths": [
    {
      "path": "/paginate",
      "method": "GET",
      "process": "models.user.Paginate",
      "in": [":params", "$params.page", "$params.pagesize"],
      "out": {
        "status": 200,
        "type": "application/json"
      }
    }
  ]
}

GET /api/user/paginate?withs=manu,mother,addresses&where.status.eq=enabled&&select=id,name,mobile,status,extra&page=1&pagesize=2