maya.public

Parameters

Name	Type	Mode
_iddriver	integer	IN
_startdate	timestamp with time zone	IN
_enddate	timestamp with time zone	IN
id	bigint	OUT
_idunit	integer	OUT
_iddriver1	integer	OUT
trip_starttime	timestamp with time zone	OUT
trip_endtime	timestamp with time zone	OUT
trip_startlocation	character varying	OUT
trip_endlocation	character varying	OUT
movement_hours	double precision	OUT
stopped_hours	double precision	OUT
idling_hours	double precision	OUT
distance_km	double precision	OUT
speeding_count	integer	OUT
harshbreak_count	integer	OUT

Definition

DECLARE
r record;
_logouteventdate timestamptz;
BEGIN
FOR r IN (SELECT *,d.serialnumber FROM driverlogin_history dlh JOIN unit u ON u.idunit = dlh.idunit JOIN device d ON d.idunit = u.idunit WHERE iddriver = _iddriver AND iddriver_eventtype = 0 AND driver_eventdate BETWEEN _startdate AND _enddate ORDER by dlh.driver_eventdate) LOOP
/* Find the logout event corresponding to this login */
SELECT driver_eventdate INTO _logouteventdate FROM driverlogin_history WHERE iddriver = _iddriver AND idunit = r.idunit AND iddriver_eventtype IN (3,4,5) AND driver_eventdate > r.driver_eventdate ORDER by 1 limit 1;
RETURN QUERY (SELECT (r.idunit::varchar||(extract(epoch from t.trip_starttime))::varchar)::bigint id,r.idunit,_iddriver,t.trip_starttime,t.trip_endtime,t.trip_startlocation,t.trip_endlocation,t.movement_hours,t.stopped_hours,t.idling_hours,coalesce(t.distance_km,0),t.speeding_count,t.harshbreak_count FROM public.ot_ro_summarize_trip_v2(r.serialnumber,r.driver_eventdate,_logouteventdate) as t order by trip_starttime);
END LOOP;
END;

ot_ro_driver_summarized_trip_v2(integer, timestamp with time zone, timestamp with time zone)

Parameters

Definition