maya.public

Parameters

Name	Type	Mode
_iddevice	integer	IN
_idunit	integer	IN
_startdate	timestamp with time zone	IN
_enddate	timestamp with time zone	IN
event_idevent	bigint	OUT
event_iddevice	integer	OUT
event_idmessage	bigint	OUT
event_latitude	numeric	OUT
event_longitude	numeric	OUT
event_senddate	timestamp with time zone	OUT
event_receivedate	timestamp with time zone	OUT
event_speed	real	OUT
event_direction	real	OUT
event_odometer	numeric	OUT
event_ignition_on	boolean	OUT
event_panicbutton	boolean	OUT
event_speedaverage	real	OUT
event_securitystatus	integer	OUT
event_enabled	boolean	OUT
event_reason	integer	OUT
event_otros	USER-DEFINED	OUT
event_location	USER-DEFINED	OUT
event_gnx_idmessage	bigint	OUT
event_creationdate	timestamp with time zone	OUT
event_eventcat	integer	OUT
device_iddevice	integer	OUT
device_idunit	integer	OUT
device_idtechnicalaccount	integer	OUT
device_idmodeldevice	integer	OUT
device_serialnumber	character varying	OUT
device_lastgpsdate	timestamp with time zone	OUT
device_firmware	character varying	OUT
device_createbyuser	integer	OUT
device_creationdate	timestamp without time zone	OUT
device_lastmodifiedbyuser	integer	OUT
device_lastmodificationdate	timestamp without time zone	OUT
device_originatingsystem	character varying	OUT
device_longitude	numeric	OUT
device_latitude	numeric	OUT
device_enabled	boolean	OUT
device_devicetype	integer	OUT
device_security_status	integer	OUT
device_ip	inet	OUT
device_status	integer	OUT
device_last_begin_move	timestamp with time zone	OUT
device_unit_name	character varying	OUT
device_aef_meta	USER-DEFINED	OUT
device_status_age	timestamp with time zone	OUT
device_speed	real	OUT
device_reason	integer	OUT
device_odometer	real	OUT
device_others	USER-DEFINED	OUT
device_location	USER-DEFINED	OUT
device_aef_id	integer	OUT
device_idbranch	integer	OUT
device_ignition_on	boolean	OUT
device_direction	double precision	OUT
device_idproduct	integer	OUT
device_script_version	character varying	OUT
device_driverlogin_pin	character varying	OUT
devicemodel_idmodeldevice	integer	OUT
devicemodel_name	character varying	OUT
devicemodel_description	character varying	OUT
devicemodel_protocol_in	integer	OUT
devicemodel_port_in	character varying	OUT
devicemodel_protocol_out	integer	OUT
devicemodel_port_out	character varying	OUT
devicemodel_enabled	boolean	OUT

Definition

SELECT e.idevent,e.iddevice,e.idmessage,e.latitude,e.longitude,e.senddate,e.receivedate,e.speed,e.direction,e.odometer,e.ignition_on,e.panicbutton,e.speedaverage,e.securitystatus,e.enabled,e.reason,e.otros,e.location,e.gnx_idmessage,e.creationdate,coalesce(e.eventcat,2),d.iddevice , d.idunit , d.idtechnicalaccount , d.idmodeldevice , d.serialnumber , d.lastgpsdate , d.firmware , d.createbyuser , d.creationdate , d.lastmodifiedbyuser , d.lastmodificationdate , d.originatingsystem , d.longitude , d.latitude , d.enabled, d.devicetype , d.security_status , d.ip , d.status , d.last_begin_move , d.unit_name , d.aef_meta , d.status_age , d.speed , d.reason , d.odometer , d.others , d.location , d.aef_id, d.idbranch, d.ignition_on, d.direction , d.idproduct, d.script_version, d.driverlogin_pin ,dm.* FROM event e JOIN device d ON d.iddevice = e.iddevice JOIN devicemodel dm ON dm.idmodeldevice = d.idmodeldevice WHERE e.senddate BETWEEN $3 AND $4 AND d.iddevice = $1 AND (e.eventcat is null or e.eventcat = 2) AND NOT(d.idmodeldevice = 4 AND e.odometer is null) 
UNION (SELECT e.idevent,e.iddevice,null::bigint as idmessage,e.latitude,e.longitude,e.senddate,e.senddate as receivedate,e.speed,e.direction,null::numeric as odometer,null::boolean as ignition_on,null::boolean as panicbutton, null::real as speedaverage,null::integer as securitystatus,true as enabled,null::integer as reason,e.others as otros,e.location,null::bigint as gnx_idmessage,e.creationdate,2 as eventcat,d.iddevice , d.idunit , d.idtechnicalaccount , d.idmodeldevice , d.serialnumber , d.lastgpsdate , d.firmware , d.createbyuser , d.creationdate , d.lastmodifiedbyuser , d.lastmodificationdate , d.originatingsystem , d.longitude , d.latitude , d.enabled, d.devicetype , d.security_status , d.ip , d.status , d.last_begin_move , d.unit_name , d.aef_meta , d.status_age , d.speed , d.reason , d.odometer , d.others , d.location , d.aef_id, d.idbranch, d.ignition_on, d.direction , d.idproduct, d.script_version, d.driverlogin_pin ,dm.* FROM unit u JOIN device d ON d.idunit = d.idunit JOIN devicemodel dm ON dm.idmodeldevice = d.idmodeldevice JOIN event_arch e ON e.iddevice = d.iddevice WHERE u.idunit = $2 AND e.senddate BETWEEN $3 AND $4 AND d.iddevice = $1)  ORDER BY senddate,gnx_idmessage nulls last;

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

Parameters

Definition