maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
omni_ro_get_current_geofence_old(integer, double precision, double precision)
Parameters
Name
Type
Mode
in_idclient
integer
IN
longitude
double precision
IN
latitude
double precision
IN
Definition
DECLARE BEGIN /* New version includes paths */ RETURN QUERY ( SELECT DISTINCT gr.idgeoreference FROM geofence gf JOIN georeference gr ON gr.idgeoreference = gf.idgeoreference WHERE gr.idclient = in_idclient AND st_intersects(geom, st_setsrid(st_makepoint(longitude,latitude),4326)) AND gr.enabled = 'true' UNION SELECT DISTINCT gr.idgeoreference FROM path p JOIN georeference gr ON gr.idgeoreference = p.idgeoreference WHERE gr.idclient = in_idclient AND st_dwithin(geom,st_setsrid(st_makepoint(longitude,latitude),4326),0.001) AND gr.enabled = 'true' ); EXCEPTION WHEN OTHERS THEN RAISE WARNING 'ERROR in calculating georeference'; RETURN QUERY (SELECT null); END