Data Warehouse(完成)

数仓


10张KPI卡片数据(更新)

<h5>简要描述</h5> <ul> <li>10张KPI卡片数据</li> <li>**请求URL更新</li> </ul> <h5>请求URL</h5> <ul> <li><code>***/kpi/total</code></li> </ul> <h5>请求方式</h5> <ul> <li>POST </li> </ul> <h5>输入示例</h5> <pre><code>{ "filters": { "Cycle Type": ["Discharge to RTGC","Loading From RTGC"], "Twin/Single": ["Twin Move"], "Dual Move": "0", "Optional Checkpoint": ["TS"], "QC": ["QC 21","QC26"], "RTGC": ["RTGC 001","RTGC 002","RTGC 003","RTGC 004"] }, "time": {"start_time": 0,"end_time": 0}, "Vessel": ["Vessel01","Vessel02"], "AT": "AT 01", "KPI_detial": "FMS" }</code></pre> <h5>输入参数</h5> <table> <thead> <tr> <th style="text-align: left;">参数名</th> <th style="text-align: left;">必选</th> <th style="text-align: left;">类型</th> <th>说明</th> </tr> </thead> <tbody> <tr> <td style="text-align: left;">filters</td> <td style="text-align: left;">否</td> <td style="text-align: left;">Str</td> <td>过滤条件</td> </tr> <tr> <td style="text-align: left;">start_time</td> <td style="text-align: left;">是</td> <td style="text-align: left;">Int</td> <td>开始时间(时间戳)</td> </tr> <tr> <td style="text-align: left;">end_time</td> <td style="text-align: left;">是</td> <td style="text-align: left;">Int</td> <td>结束时间(时间戳)</td> </tr> <tr> <td style="text-align: left;">vessel</td> <td style="text-align: left;">否</td> <td style="text-align: left;">Array</td> <td>船舶号</td> </tr> <tr> <td style="text-align: left;">AT</td> <td style="text-align: left;">否</td> <td style="text-align: left;">Array</td> <td>车号</td> </tr> <tr> <td style="text-align: left;">KPI_detial</td> <td style="text-align: left;">否</td> <td style="text-align: left;">Str</td> <td>类型</td> </tr> </tbody> </table> <h5>返回示例</h5> <pre><code>{ "err_code": 0, "err_info": "", "result": [ { "description": "Number of boxes completed per hour", "kpi_name": "Productivity", "tend": 1, "tend_persent": 13, "tend_value": 2, "value": 18 }, { "description": "", "kpi_name": "Cycle Time", "tend": 1, "tend_persent": 12, "tend_value": 127, "value": 1200 }, { "description": "Time to complete moving a box", "kpi_name": "Turnaround Time", "tend": -1, "tend_persent": 15, "tend_value": 109, "value": 1180 }, { "description": "Distance travelled, including forward and backward", "kpi_name": "Mileage", "tend": 1, "tend_persent": 7, "tend_value": 195, "value": 2854 }, { "description": "Number of boxes completed", "kpi_name": "Move(Box)", "tend": 1, "tend_persent": 11, "tend_value": 25, "value": 138 }, { "description": "Time duration of different stopping reasons", "kpi_name": "Stopping Reason", "tend": 1, "tend_persent": 12, "tend_value": 120, "value": 923 }, { "description": "Ratio between the number of times waiting at TSL and total numbers of vessel discharging cycles", "kpi_name": "TSL Usage", "tend": -1, "tend_persent": 13, "tend_value": 1, "value": 5 }, { "description": "Ratio between the number of times waitg at TSD and total numbers of vessel loading cycles", "kpi_name": "TSD Usage", "tend": -1, "tend_persent": 10, "tend_value": 2, "value": 30 }, { "description": "Ratio between the number of times waiting at EWA and total numbers of vessel discharging to FL cycles", "kpi_name": "EWA Usage", "tend": -1, "tend_persent": 8, "tend_value": 3, "value": 25 }, { "description": "Ratio between the number of times waiting at LWA and total numbers of vessel loading cycles", "kpi_name": "LWA Usage", "tend": 1, "tend_persent": 13, "tend_value": 351, "value": 2561 }, { "description": "", "kpi_name": "Junction", "tend": -1, "tend_persent": 3, "tend_value": 3, "value": 20 } ] }</code></pre> <h5>返回表参数说明</h5> <table> <thead> <tr> <th style="text-align: left;">参数</th> <th style="text-align: left;">参数名</th> <th style="text-align: left;">类型</th> <th>说明</th> </tr> </thead> <tbody> <tr> <td style="text-align: left;">err_code</td> <td style="text-align: left;">错误码</td> <td style="text-align: left;">Int</td> <td>正常0,其他错误非0</td> </tr> <tr> <td style="text-align: left;">err_info</td> <td style="text-align: left;">错误信息</td> <td style="text-align: left;">str</td> <td>正常为空</td> </tr> <tr> <td style="text-align: left;">description</td> <td style="text-align: left;">描述含义</td> <td style="text-align: left;">str</td> <td>-</td> </tr> <tr> <td style="text-align: left;">kpi_name</td> <td style="text-align: left;">卡片类型</td> <td style="text-align: left;">str</td> <td>-</td> </tr> <tr> <td style="text-align: left;">tend</td> <td style="text-align: left;">增长趋势</td> <td style="text-align: left;">Int</td> <td>取值 1, 0, -1</td> </tr> <tr> <td style="text-align: left;">tend_persent</td> <td style="text-align: left;">增长百分比</td> <td style="text-align: left;">Float</td> <td>-</td> </tr> <tr> <td style="text-align: left;">tend_value</td> <td style="text-align: left;">增长趋势变化值</td> <td style="text-align: left;">Int</td> <td>-</td> </tr> <tr> <td style="text-align: left;">value</td> <td style="text-align: left;">当前值</td> <td style="text-align: left;">Int</td> <td>时间戳(CycleTime)int时间戳(StoppingTime),int(Mileage),int(MoveBox)</td> </tr> </tbody> </table> <h5>备注</h5> <ul> <li>备注</li> </ul>

页面列表

ITEM_HTML