maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
omni_rw_update_geofence(integer, real, real)
Parameters
Name
Type
Mode
in_idunit
integer
IN
in_longitude
real
IN
in_latitude
real
IN
Definition
DECLARE _current_geofences int[]; _idclient int; BEGIN SELECT idclient INTO _idclient FROM unit WHERE idunit = in_idunit; SELECT array_agg(g::varchar) INTO _current_geofences FROM omni_ro_get_current_geofence(_idclient,in_longitude,in_latitude) g; PERFORM omni_rw_insert_geofence_history(in_idunit,_current_geofences,timeofday()::timestamptz); PERFORM ot_rw_update_current_geofence(in_idunit,array_to_string(_current_geofences,',')); RETURN true; END;