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

BEGIN
RETURN QUERY EXECUTE 'WITH e AS (SELECT * FROM public.ot_ro_event_cassandra($1,$3,$4) WHERE eventcat <> 5) SELECT e.*,d.*,dm.* FROM unit u JOIN device d ON d.idunit = d.idunit JOIN devicemodel dm ON dm.idmodeldevice = d.idmodeldevice JOIN e ON e.iddevice = d.iddevice WHERE u.idunit = $2 AND  (e.eventcat is null or e.eventcat = 2) AND NOT(d.idmodeldevice = 4 AND e.odometer is null and e.eventcat <> 2) 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.*,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' USING $1,$2,$3,$4;
END;

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

Parameters

Definition