maya.public

Parameters

Name	Type	Mode
iddevice	integer	IN
start_date	timestamp without time zone	IN
end_date	timestamp without time zone	IN
idclient	integer	OUT
clientcode	character varying	OUT
client_name	character varying	OUT
iddevice	integer	OUT
serialnumber	character varying	OUT
alias	character varying	OUT
security	character varying	OUT
reason	character varying	OUT
ignition_on	boolean	OUT
status	character varying	OUT
speed	real	OUT
odometer	numeric	OUT
latitude	numeric	OUT
longitude	numeric	OUT
ciudad	character varying	OUT
switch_3	character varying	OUT
switch_4	character varying	OUT
senddate	timestamp without time zone	OUT
creationdate	timestamp without time zone	OUT
lag	interval	OUT
gnx_idmessage	bigint	OUT

Definition

SELECT c.idclient, c.clientcode, c.name, d.iddevice, d.serialnumber, u.alias,
    s.description AS security, er.description AS reason, e.ignition_on,
    vm.description AS status, e.speed, e.odometer, e.latitude, e.longitude,
    e.location -> 'ciudad'::text AS location,
    substring((e.otros -> 'switches'),3,1)::text AS switch_3,
    substring((e.otros -> 'switches'),4,1)::text AS switch_4,
    timezone('AMERICA/MEXICO_CITY'::text, e.senddate) AS senddate,
    timezone('AMERICA/MEXICO_CITY'::text, e.creationdate) AS creationdate,
    e.creationdate - e.senddate AS lag, e.gnx_idmessage
   FROM event e JOIN device d ON d.iddevice = e.iddevice
   LEFT JOIN unit u ON u.idunit = d.idunit
   LEFT JOIN vehicle_movementstatus vm ON vm.id = ((e.otros -> 'vehicle_movement_status'::text)::integer)
   JOIN client c ON c.idclient = u.idclient
   LEFT JOIN device_securitystatus s ON s.id = e.securitystatus
   LEFT JOIN event_reason er ON er.id = e.reason
   WHERE d.iddevice = $1 and e.senddate between $2 and $3;

ot_ro_position(integer, timestamp without time zone, timestamp without time zone)

Parameters

Definition