hklhai / dashboard

dashboard
0 stars 0 forks source link

dashboard、visualize 分页集成查询接口更改 #18

Closed hklhai closed 5 years ago

hklhai commented 5 years ago

@aym19900825 测试已通过

visualize带条件查询分页

POST http://192.168.1.140:8090/show/visualizeList2?page=0&size=15 { "type": "line", "visualizename": "BNOP-" }

Return: { "page": { "sort": [ { "direction": "DESC", "property": "vid", "ignoreCase": false, "nullHandling": "NATIVE", "ascending": false, "descending": true } ], "offset": 0, "pageSize": 15, "pageNumber": 0 }, "totalPages": 1, "visualizeList": [ { "vid": 18, "visualizename": "BNOP-line_test5", "tablename": "tb_line_4", "visualizedescription": null, "visualizeshowname": null, "type": "line", "businesscategory": null, "xname": null, "yname": null, "ytype": "double", "echarttitle": null, "legendShow": null, "legendPos": null, "legendOrient": null, "tooltipShow": null }, { "vid": 15, "visualizename": "BNOP-line_test", "tablename": "tb_line_1", "visualizedescription": null, "visualizeshowname": null, "type": "line", "businesscategory": "工具校准单", "xname": null, "yname": null, "ytype": "double", "echarttitle": null, "legendShow": null, "legendPos": null, "legendOrient": null, "tooltipShow": null } ], "distinctBusinesscategory": [ "工具校准单", "设备管理" ] }

dashboard带条件查询分页

POST http://192.168.1.140:8090/show/dashboardList2?page=0&size=10 { "dashboardname": "上映", "dashboarddescription": "" }

RETURN: { "page": { "sort": [ { "direction": "DESC", "property": "bid", "ignoreCase": false, "nullHandling": "NATIVE", "ascending": false, "descending": true } ], "offset": 0, "pageSize": 10, "pageNumber": 0 }, "totalPages": 1, "visualizeList": [ { "bid": 3, "dashboardname": "上映电影2-update", "dashboarddescription": null, "dashboardshowname": "cpcc-上映电影2-update", "type": "update", "businesscategory": "市场分析2-update" }, { "bid": 1, "dashboardname": "上映电影", "dashboarddescription": null, "dashboardshowname": "cpcc-上映电影", "type": null, "businesscategory": "市场分析" } ], "distinctBusinesscategory": [ "工具校准单", "设备管理" ] }

hklhai commented 5 years ago

@aym19900825 31日上午解决

hklhai commented 5 years ago

集成根据dashboard查询已经绑定的visualize的返回,需要传入bid POST http://192.168.1.140:8090/show/visualizeList2?page=0&size=15&bid=10 {}

return: { "page": { "sort": [ { "direction": "DESC", "property": "vid", "ignoreCase": false, "nullHandling": "NATIVE", "descending": true, "ascending": false } ], "offset": 0, "pageSize": 15, "pageNumber": 0 }, "totalPages": 1, "total": 8, "visualizeList": [ { "vid": 41, "visualizename": "开发line", "tablename": "ab_line_4", "visualizedescription": null, "visualizeshowname": null, "type": "line", "businesscategory": "工具校准单", "xname": null, "yname": null, "ytype": "double", "echarttitle": null, "legendShow": null, "legendPos": null, "legendOrient": null, "tooltipShow": null }, { "vid": 40, "visualizename": "物资审批记录", "tablename": "ab_pie_4", "visualizedescription": null, "visualizeshowname": null, "type": "pie", "businesscategory": "物资发放列表", "xname": null, "yname": null, "ytype": "double", "echarttitle": null, "legendShow": true, "legendPos": "topRight", "legendOrient": "vertical", "tooltipShow": true }, { "vid": 39, "visualizename": "物资发放行", "tablename": "ab_pie_3", "visualizedescription": null, "visualizeshowname": null, "type": "pie", "businesscategory": "物资发放列表", "xname": null, "yname": null, "ytype": "double", "echarttitle": null, "legendShow": true, "legendPos": "topLeft", "legendOrient": "vertical", "tooltipShow": true }, { "vid": 38, "visualizename": "物资发放页面", "tablename": "ab_bar_2", "visualizedescription": null, "visualizeshowname": null, "type": "bar", "businesscategory": "物资发放列表", "xname": null, "yname": null, "ytype": "float", "echarttitle": null, "legendShow": true, "legendPos": "topLeft", "legendOrient": "vertical", "tooltipShow": true }, { "vid": 37, "visualizename": "物资发放列表", "tablename": "ab_line_3", "visualizedescription": null, "visualizeshowname": null, "type": "line", "businesscategory": "物资发放列表", "xname": null, "yname": null, "ytype": "float", "echarttitle": null, "legendShow": null, "legendPos": null, "legendOrient": null, "tooltipShow": null }, { "vid": 34, "visualizename": "工具校准行页面", "tablename": "ab_bar_1", "visualizedescription": null, "visualizeshowname": null, "type": "bar", "businesscategory": "工具校准单", "xname": null, "yname": null, "ytype": "float", "echarttitle": null, "legendShow": null, "legendPos": null, "legendOrient": null, "tooltipShow": null }, { "vid": 33, "visualizename": "工具校准单列表", "tablename": "ab_pie_1", "visualizedescription": null, "visualizeshowname": null, "type": "pie", "businesscategory": "工具校准单", "xname": null, "yname": null, "ytype": "double", "echarttitle": null, "legendShow": null, "legendPos": null, "legendOrient": null, "tooltipShow": null }, { "vid": 32, "visualizename": "工具台账页面", "tablename": "ab_line_1", "visualizedescription": null, "visualizeshowname": null, "type": "line", "businesscategory": "工具校准单", "xname": null, "yname": null, "ytype": "double", "echarttitle": null, "legendShow": null, "legendPos": null, "legendOrient": null, "tooltipShow": null } ], "distinctBusinesscategory": [ "工具校准单", "物资发放列表" ], "hasBindList": [ 38, 39, 40 ] }