maya.public

Parameters

Name	Type	Mode
clientcode	character varying	IN
unit_alias	character varying	IN
begindate_local	timestamp without time zone	IN
enddate_local	timestamp without time zone	IN
unit_alias	character varying	OUT
serialnumber	character varying	OUT
tmci	character varying	OUT
senddate_local	timestamp without time zone	OUT
creationdate_local	timestamp without time zone	OUT
sw1	character varying	OUT
sw2	character varying	OUT
sw3	character varying	OUT
sw4	character varying	OUT
reason	character varying	OUT
ignition_on	character varying	OUT
gnx_idmessage	bigint	OUT
latitude	character varying	OUT
longitude	character varying	OUT
rssi	character varying	OUT
idle_time	character varying	OUT
stopduration	character varying	OUT
num_satellites	character varying	OUT
track_num_satellites	character varying	OUT
call_suported	character varying	OUT
otros	USER-DEFINED	OUT

Definition

SELECT u.alias unit_alias,d.serialnumber,v.serialnumber tmci,e.senddate at time zone 'America/Mexico_city' senddate_local,
e.creationdate at time zone 'America/Mexico_city' creationdate_local,
e.otros->'switch_1' switch_1,e.otros->'switch_2' switch_2,e.otros->'switch_3' switch_3,e.otros->'switch_4' switch_4, r.description reason,
case e.ignition_on when 'true' then 'true' else 'false' end ignition_on , e.gnx_idmessage,e.latitude::varchar, e.longitude::varchar,otros->'rssi' rssi,
otros->'idle_time' idle_time, otros->'stopduration' stopduration, otros->'num_satellites' num_satellites, otros->'track_num_satellites' track_num_satellites,otros->'call_supported',otros  
FROM event e JOIN device d ON d.iddevice = e.iddevice JOIN unit u ON u.idunit = d.idunit JOIN catalogs.event_reason r
ON e.reason = r.id JOIN client c ON c.idclient = u.idclient JOIN vehicle v ON v.idunit = u.idunit WHERE u.alias = $2 AND c.clientcode = $1 AND e.creationdate
BETWEEN ($3::timestamp at time zone 'America/Mexico_city') AND ($4::timestamp at time zone 'America/Mexico_city')  order by e.senddate;

ot_ro_posiciones(character varying, character varying, timestamp without time zone, timestamp without time zone)

Parameters

Definition