You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

Returns a list of all orders, created during the given timerange.

Description

get_orders.php?company=COMPANY_RTIKEY&vehicleVEHICLE_RTIKEY&start=YYYYMMDDHHMMSS&end=YYYYMMDDHHMMSS

Parameters

ParameterDescriptionTypeNoteMandatory
companyRTI company keystring yes
vehicleRTI vehicle keystringeither vehicle, group or import parameter(yes)
groupRTI group keystringeither vehicle, group or import parameter(yes)
importRTI import keystringeither vehicle, group or import parameter(yes)
startstart of requested timerangedatestring

format: YYYYMMDDHHMMSS

  • the timerange between "start" and "end" is limited to 31 days
yes
endend of requested timerangedatestring

format: YYYYMMDDHHMMSS

  • the timerange between "start" and "end" is limited to 31 days

yes

only_ondisplay_created only return orders, created on a displayint 

order creation at display is limited to specific Display types and has to be activated seperately

  • not set or value "0": Returns all created orders
  • value "1": Returns only orders created on a display 
no 

Return

Returns a string. In case of error it returns "ERROR:Beschreibung".

CSV Format

The result of a correct request will be a csv (comma seperated values) formatted file containing always a head with column names as first line. The following lines containing the single entries.

Meta informations

SeparatorSemicolon ( ; )
DelimiterDouble quote ( " )
Line break0x0D 0x0A (CarriageReturn LineFeed)
HeaderLine 1
EncodingUTF-8

Columns

Column
Description
DATE

date when order was created

  • format: YYYY-MM-DD HH:MM:SS
CUSTORDERself defined order number
TEXTorder text
VEHICLEassigned vehicle
DELETED_IN_VEHICLE 

indicate, if order deleted on vehicle display

  • 0 = no
  • 1 = yes
ACTIVE 

indicate, if order is currently active

  • 0 = no
  • 1 = yes
LAST_STATE_DATE 

Date of latest state change

  • format YYYY-MM-DD HH:MM:SS 
LAST_STATE_TEXT the state description
NAV_CUSTOMER 

customer name

NAV_TEXT target adress
NAV_LAT geocoordinate for target adress (Latitude)
NAV_LON geocoordinate for target adress (Longitude) 
FORM_NAME assigned user defined form

Example

"DATE";"CUSTORDER";"TEXT";"VEHICLE";"DELETED_IN_VEHICLE";"ACTIVE";"LAST_STATE_DATE";"LAST_STATE_TEXT";"NAV_CUSTOMER";"NAV_TEXT";"NAV_LAT";"NAV_LON";
"2012-12-27 14:39:00";"ORDER1";"TEXT1";"FZG1";"1";"0";"2012-12-27 13:44:44";"Auftrag im Display gelöscht";"";"";"";"";
"2012-12-27 13:42:00";"ORDER2";"TEXT2";"FZG1";"0";"1";"2012-12-27 13:28:29";"Start";"";"";"";"";
"2012-12-27 12:03:34";"ORDER3";"TEXT3";"FZG2";"1";"0";"2013-01-11 15:57:50";"Erledigt";"YellowFox";"D-01723 Kesselsdorf Am Wüstberg 3";"51.036307";"13.598907";
"2012-12-27 12:03:15";"ORDER4";"TEXT4";"FZG2";"0";"1";"2012-12-27 12:04:03";"Angenommen";"YellowFox";"D-01723 Kesselsdorf Am Wüstberg 3";"51.036307";"13.598907";

Example calls

All orders sent by or to a vehicle
http://map.yellowfox.de/rti/get_orders?company=COMPANY_RTIKEY&VEHICLE=VEHICLE_RTIKEY&start=YYYYMMDDHHMMSS&end=YYYYMMDDHHMMSS
All orders created on any vehicle
http://map.yellowfox.de/rti/get_orders?company=COMPANY_RTIKEY&import=IMPORT_RTIKEY&start=YYYYMMDDHHMMSS&end=YYYYMMDDHHMMSS&only_ondisplay_created=1
All orders sent or created on any vehicle of the vehicle group
http://map.yellowfox.de/rti/get_orders?company=COMPANY_RTIKEY&group=IMPORT_GROUPKEY&start=YYYYMMDDHHMMSS&end=YYYYMMDDHHMMSS

 

 

  • No labels