Wiki source code of get_d8_driver_time.php
Last modified by YellowFox_RD on 2024/12/19 10:11
Show last authors
| author | version | line-number | content |
|---|---|---|---|
| 1 | (% class="box" %) | ||
| 2 | (((Table of Contents))) | ||
| 3 | {{toc/}} | ||
| 4 | |||
| 5 | Returns current information about steering time, working time, remaining steer time, start of shift of current day, week and doubleweek of a driver based on digital tachometer information interface.(D8). | ||
| 6 | = Description = | ||
| 7 | **(% class="green mark" %)GET(%%) get_d8_driver_time.php?****company**=//COMPANY_RTIKEY//**&import**=//IMPORT_RTIKEY//**&driver**=//DF0123456789000//**&format**//=csv// | ||
| 8 | = Parameter = | ||
| 9 | |=Parameter|=Description|=Type|=Note|=Mandatory | ||
| 10 | |company|RTI company key|string||yes | ||
| 11 | |import|RTI import key|string||yes | ||
| 12 | |driver|driver key|string||yes | ||
| 13 | |format|return format|string|csv or json (default)|no | ||
| 14 | |||
| 15 | = Return = | ||
| 16 | Return a **string**. In case of error it returns "(% class="error" %)**ERROR:Description**(%%)". | ||
| 17 | == CSV Format == | ||
| 18 | === Meta informations === | ||
| 19 | |=Separator|Semicolon ( ; ) | ||
| 20 | |=Delimiter|Double quote ( " ) | ||
| 21 | |=Line break|0x0D 0x0A (CarriageReturn LineFeed) | ||
| 22 | |=Header|Line 1 | ||
| 23 | |||
| 24 | === Columns === | ||
| 25 | |=column|=Description|= | ||
| 26 | |DRIVER_NAME|driver name| | ||
| 27 | |DRIVER_KEY|driver key| | ||
| 28 | |STEER_SECONDS|steering time in seconds of current day| | ||
| 29 | |STEER_TIME|steering time of current day|format 0h 00m | ||
| 30 | |WORK_SECONDS|working time in seconds of current day| | ||
| 31 | |WORK_TIME|working time of current day|format 0h 00m | ||
| 32 | |IDLE_SECONDS|booked idle time during current shift in seconds| | ||
| 33 | |IDLE_TIME|booked idle time during current shift|format 0h 00m | ||
| 34 | |REMAINING_SECONDS|remaining steer time in seconds of current day| | ||
| 35 | |REMAINING_TIME|remaining steer time of current day|format 0h 00m | ||
| 36 | |SHIFT_START|start of shift|format YYYY-MM-DD HH:MM:SS | ||
| 37 | |WEEK_STEER_SECONDS|weekly steering time in seconds| | ||
| 38 | |WEEK_STEER_TIME|weekly steering time|format 0h 00m | ||
| 39 | |WEEK_WORK_SECONDS|weekly working time in seconds| | ||
| 40 | |WEEK_WORK_TIME|weekly working time|format 0h 00m | ||
| 41 | |WEEK_REMAINING_SECONDS|weekly remaining steer time in seconds| | ||
| 42 | |WEEK_REMAINING_TIME|weekly remaining steer time|format 0h 00m | ||
| 43 | |WEEK_START|start of week|format YYYY-MM-DD HH:MM:SS | ||
| 44 | |DBL_WEEK_STEER_SECONDS|doubleweek steering time in seconds| | ||
| 45 | |DBL_WEEK_STEER_TIME|doubleweek steering time|format 0h 00m | ||
| 46 | |DBL_WEEK_WORK_SECONDS|doubleweek working time in seconds| | ||
| 47 | |DBL_WEEK_WORK_TIME|doubleweek working time|format 0h 00m | ||
| 48 | |DBL_WEEK_REMAINING_SECONDS|doubleweek remaining steer time in seconds| | ||
| 49 | |DBL_WEEK_REMAINING_TIME|doubleweek remaining steer time|format 0h 00m | ||
| 50 | |DBL_WEEK_START|start of doubleweek|format YYYY-MM-DD HH:MM:SS | ||
| 51 | |BLOCK_STEER_TIME_SECONDS|steer time since last break in seconds| | ||
| 52 | |BLOCK_STEER_TIME|steer time since last break|format 0h 00m | ||
| 53 | |BLOCK_REMAINING_TIME_SECONDS|remaining steer time until next break in seconds| | ||
| 54 | |BLOCK_REMAINING_TIME|remaining steer time until next break|format 0h 00m | ||
| 55 | |NEXT_BREAK_DURATION_SECONDS|next break duration in seconds| | ||
| 56 | |NEXT_BREAK_DURATION|next break duration|format 0h 00m | ||
| 57 | |LAST_TACHOGRAPH_STATUS|latest digitacho activity state | ||
| 58 | 0 .. idle/break | ||
| 59 | 1 .. standby | ||
| 60 | 2 .. work | ||
| 61 | 3 .. steer| | ||
| 62 | |LAST_TACHOGRAPH_TIME|date and time of latest digitacho activity state|format YYYY-MM-DD HH:MM:SS | ||
| 63 | |LAST_TACHOGRAPH_SLOT|used card slot for this booking | ||
| 64 | 1 .. driver | ||
| 65 | 2 .. codriver| | ||
| 66 | |WEEK_SHORT_IDLES_TIMES|count of shortened per-day idle-times during current shift week| | ||
| 67 | |WEEK_EXTENED_STEER_TIMES|count of extended per-day steer times during current shift week | ||
| 68 | ((( | ||
| 69 | * regular per-day steer time <= 9h | ||
| 70 | * 9h < extened per-day steer time <= 10h | ||
| 71 | )))| | ||
| 72 | |||
| 73 | **example** | ||
| 74 | {{code language="java"}}"DRIVER_NAME";"DRIVER_KEY";"STEER_SECONDS";"STEER_TIME";"WORK_SECONDS";"WORK_TIME";"IDLE_SECONDS";"IDLE_TIME";"REMAINING_SECONDS";"REMAINING_TIME";"SHIFT_START";"WEEK_STEER_SECONDS";"WEEK_STEER_TIME";"WEEK_WORK_SECONDS";"WEEK_WORK_TIME";"WEEK_REMAINING_SECONDS";"WEEK_REMAINING_TIME";"WEEK_START";"DBL_WEEK_STEER_SECONDS";"DBL_WEEK_STEER_TIME";"DBL_WEEK_WORK_SECONDS";"DBL_WEEK_WORK_TIME";"DBL_WEEK_REMAINING_SECONDS";"DBL_WEEK_REMAINING_TIME";"DBL_WEEK_START";"BLOCK_STEER_TIME_SECONDS";"BLOCK_STEER_TIME";"BLOCK_REMAINING_TIME_SECONDS";"BLOCK_REMAINING_TIME";"NEXT_BREAK_DURATION_SECONDS";"NEXT_BREAK_DURATION";"LAST_TACHOGRAPH_STATUS";"LAST_TACHOGRAPH_TIME";"LAST_TACHOGRAPH_SLOT" | ||
| 75 | "Musternamm, Paul";"DF00011424169815";"0";"0 h 0 m";"0";"0 h 0 m";"0";"0 h 0 m";"36000";"10 h 0 m";"2015-11-17 10:02:43";"20520";"5 h 42 m";"3180";"0 h 53 m";"181080";"50 h 18 m";"2015-11-16 00:00:00";"166140";"46 h 9 m";"11520";"3 h 12 m";"157860";"43 h 51 m";"2015-11-09 00:00:00";"3900";"1 h 5 m";"12325";"3 h 25 m";"2700";"0 h 45 m";"0";"2015-1-16 14:30:00";"1"{{/code}} | ||
| 76 | |||
| 77 | == JSON Format == | ||
| 78 | === Columns === | ||
| 79 | |=Column|=Description|= | ||
| 80 | |driverName|driver name| | ||
| 81 | |driverKey|driver key| | ||
| 82 | |steerTimeSeconds|steering time in seconds of current day| | ||
| 83 | |steerTime|steering time of current day|format 0h 00m | ||
| 84 | |workTimeSeconds|working time in seconds of current day| | ||
| 85 | |workTime|working time of current day|format 0h 00m | ||
| 86 | |idleTimeSeconds|booked idle time during current shift in seconds| | ||
| 87 | |idleTime|booked idle time during current shift|format 0h 00m | ||
| 88 | |remainingTimeSeconds|remaining steer time in seconds of current day| | ||
| 89 | |remainingTime|remaining steer time of current day|format 0h 00m | ||
| 90 | |blockSteerTimeSeconds|steer time since last break in seconds| | ||
| 91 | |blockSteerTime|steer time since last break|format 0h 00m | ||
| 92 | |blockRemainingTimeSeconds|remaining steer time until next break in seconds| | ||
| 93 | |blockRemainingTime|remaining steer time until next break|format 0h 00m | ||
| 94 | |nextBreakDurationSeconds|next break duration in seconds| | ||
| 95 | |nextBreakDuration|next break duration|format 0h 00m | ||
| 96 | |shiftStart|start of shift|format YYYY-MM-DD HH:MM:SS | ||
| 97 | |steerTimeSecondsSingleWeek|weekly steering time in seconds| | ||
| 98 | |steerTimeSingleWeek|weekly steering time|format 0h 00m | ||
| 99 | |workTimeSecondsSingleWeek|weekly working time in seconds| | ||
| 100 | |workTimeSingleWeek|weekly working time|format 0h 00m | ||
| 101 | |remainingTimeSecondsSingleWeek|weekly remaining steer time in seconds| | ||
| 102 | |remainingTimeSingleWeek|weekly remaining steer time|format 0h 00m | ||
| 103 | |startSingleWeek|start of week|format YYYY-MM-DD HH:MM:SS | ||
| 104 | |singleWeekShortIdles|count of shortened per-day idle-times during current shift week| | ||
| 105 | |singleWeekExtendedSteer|count of extended per-day steer times during current shift week | ||
| 106 | ((( | ||
| 107 | * regular per-day steer time <= 9h | ||
| 108 | * 9h < extened per-day steer time <= 10h | ||
| 109 | )))| | ||
| 110 | |steerTimeSecondsDoubleWeek|doubleweek steering time in seconds| | ||
| 111 | |steerTimeDoubleWeek|doubleweek steering time|format 0h 00m | ||
| 112 | |workTimeSecondsDoubleWeek|doubleweek working time in seconds| | ||
| 113 | |workTimeDoubleWeek|doubleweek working time|format 0h 00m | ||
| 114 | |remainingTimeSecondsDoubleWeek|doubleweek remaining steer time in seconds| | ||
| 115 | |remainingTimeDoubleWeek|doubleweek remaining steer time|format 0h 00m | ||
| 116 | |startDoubleWeek|start of doubleweek|format YYYY-MM-DD HH:MM:SS | ||
| 117 | |lastTachographStatus|latest digitacho activity state | ||
| 118 | 0 .. idle/break | ||
| 119 | 1 .. standby | ||
| 120 | 2 .. work | ||
| 121 | 3 .. steer| | ||
| 122 | |lastTachographTime|date and time of latest digitacho activity state|format YYYY-MM-DD HH:MM:SS | ||
| 123 | |lastTachographSlot|used card slot for this booking | ||
| 124 | 1 .. driver | ||
| 125 | 2 .. codriver| | ||
| 126 | |||
| 127 | **example** | ||
| 128 | {{code language="java"}}{"driverName":"Mustermann, Paul","driverKey":"DF0123456789815","steerTimeSeconds":12325,"steerTime":"3 h 25 m","workTimeSeconds":120,"workTime":"0 h 2 m","idleTimeSeconds":240,"idleTime":"","remainingTimeSeconds":23675,"remainingTime":"6 h 35 m","blockSteerTimeSeconds":660,"blockSteerTime":"0h 11m","blockRemainingTimeSeconds":12325,"blockRemainingTime":"3 h 25 m","nextBreakDurationSeconds":2700,"nextBreakDuration":"0 h 45 m","shiftStart":"2015-11-16 12:04:00","steerTimeSecondsSingleWeek":12325,"steerTimeSingleWeek":"3 h 25 m","workTimeSecondsSingleWeek":120,"workTimeSingleWeek":"0 h 2 m","remainingTimeSecondsSingleWeek":189275,"remainingTimeSingleWeek":"52 h 35 m","startSingleWeek":"2015-11-16 00:00:00","steerTimeSecondsDoöubleWeek":157945,"steerTimeDoubleWeek":"43 h 52 m","workTimeSecondsDoubleWeek":8460,"workTimeDoubleWeek":"2 h 21 m","remainingTimeSecondsDoubleWeek":166055,"remainingTimeDoubleWeek":"46 h 8 m","startDoubleWeek":"2015-11-09 00:00:00","lastTachographStatus":3,"lastTachographTime":"2015-11-16 13:25:00","lastTachographSlot":1}{{/code}} | ||
| 129 | |||
| 130 | = Example calls = | ||
| 131 | **Request in JSON format** | ||
| 132 | {{code language="java"}}https://map.yellowfox.de/rti/get_d8_driver_time.php?company=COMPANY_RTIKEY&import=IMPORT_RTIKEY&driver=DF0123456789000{{/code}} | ||
| 133 | |||
| 134 | **Request in CSV format** | ||
| 135 | {{code language="java"}}https://map.yellowfox.de/rti/get_d8_driver_time.php?company=COMPANY_RTIKEY&import=IMPORT_RTIKEY&driver=DF0123456789000&format=csv{{/code}} | ||
| 136 |