Reports
Method
Url
Filters
GET
/api/route
startDate=YYYY-mm-dd
endDate=YYYY-mm-dd
accountId=[array of ids]
vendorId=[array of ids]
serviceId=[array of ids]
Required
Required
Optional
Optional
Optional
JS:
generateAndDownloadPDF(
{
vendorId:[1],
accountId:[54,55],
service:66,
startDate:"2023-05-06",
endDate:"2023-03-02"
}
)
html:
proccess maps 0 - n/a
proccess creating pdf 0 - n/a
1. https://platform.scheduleinterpreter.com/api/route?eventId=229605,229611
3 options (Multiple events in the same day)
1. from home to event (First) - */route?action=report&eventId=home,228802
2. from event to event - */route?action=report&eventId=228802,228806
3. from event(Last) to home - */route?action=report&eventId=228806,home
1 options (Single event in the same day)
portal to portal = home to event
3. from event(Last) to home - */route?action=report&eventId=228806,home
order by startime estimated
//startDate
//endDate
SQL
Option 1.
SELECT
id AS eventId,
interpreting.lat AS dLat,
interpreting.lon AS dLon,
userContact.lat AS oLat,
userContact.lon AS oLon
FROM interpreting, userContact
WHERE interpreting.interpID = userContact.userID
AND interpreting.interpID <> 0
AND interpreting.lat <> 0
AND interpreting.lon <> 0
Option 2.
SELECT
id,
dateTime,
lon,
lat
FROM
bestinterp.interpreting
WHERE
id in (228830, 228813)
ORDER BY dateTime ASC;
Option 3.
SELECT
id AS eventId,
interpreting.lat AS oLat,
interpreting.lon AS oLon,
userContact.lat AS dLat,
userContact.lon AS dLon
FROM interpreting, userContact
WHERE interpreting.interpID = userContact.userID
AND interpreting.interpID <> 0
AND interpreting.lat <> 0
AND interpreting.lon <> 0