maya.public

Parameters

Name	Type	Mode
in_idmayauser	integer	IN
in_start_date	timestamp with time zone	IN
alert_alias	character varying	OUT
unit_alias	character varying	OUT
alert_type_text	character varying	OUT
date_gen_alert	timestamp with time zone	OUT
relevantinfo	character varying	OUT
place_gen_alert	character varying	OUT
latitude	numeric	OUT
longitude	numeric	OUT
idvehicle	integer	OUT
alerttype	integer	OUT
idalert	integer	OUT
coverages	ARRAY	OUT
unitgroups	ARRAY	OUT
leveltype	smallint	OUT
severity	character varying	OUT

Definition

WITH tmp_mayauser_alerts_coverages AS (SELECT d.iddevice,u.alias unit_alias,u.idunit idvehicle, array_agg(co.idcoverage) coverages, array_agg(ug.idunitgroup) unitgroups
FROM mayauser mu
JOIN mayauser_mayausergroup mmu ON mu.idmayauser = mmu.idmayauser
JOIN mayausergroup mug ON mmu.idmayausergroup = mug.idmayausergroup
JOIN coverage_usergroup cou ON cou.idmayausergroup = mmu.idmayausergroup
JOIN coverage co ON co.idcoverage = cou.idcoverage
JOIN coverage_unitgroup coug ON coug.idcoverage = cou.idcoverage
JOIN unitgroup ug ON ug.idunitgroup = coug.idunitgroup
JOIN unit_unitgroup uug ON uug.idunitgroup = ug.idunitgroup
JOIN unit u ON u.idunit =  uug.idunit
JOIN device d ON d.idunit = u.idunit
WHERE
mu.enabled = true AND
mug.enabled = true AND
co.enabled = true AND
ug.enabled = true AND
uug.enabled = true AND
d.enabled = true AND
d.status = 1 AND /* enabled from the billing system */
u.enabled = true AND
mmu.enabled = true AND
mu.idmayauser = $1
GROUP BY 1,2,3)
SELECT ac.alias alert_alias,c.unit_alias,  aet.description alert_type_text, a.alertdate + '5 hours'::interval date_gen_alert,a.relevantinfo,a.location->'ciudad' place_gen_alert,a.latitude,a.longitude,c.idvehicle,a.alert_type alerttype,a.idalert::int,c.coverages,c.unitgroups,ac.leveltype,configmeta->'severity' FROM alert a JOIN alertconf ac ON ac.idalertconf = a.idalertconf JOIN catalogs.alertconf_eventtype aet ON aet.id = ac.eventype JOIN tmp_mayauser_alerts_coverages c ON c.iddevice = a.iddevice WHERE a.enabled = true AND a.alertdate >= $2;

ot_ro_get_alerts_by_user_v2(integer, timestamp with time zone)

Parameters

Definition