maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
omni_ro_get_current_geofence_array(integer, double precision, double precision)
Parameters
Name
Type
Mode
idclient
integer
IN
longitude
double precision
IN
latitude
double precision
IN
Definition
-- tiene que discriminar a los clientes shield y aef para que a los primeros no les haga cálculos geoespaciales SELECT array_agg(g.idgeoreference) FROM geofence g JOIN georeference gr ON gr.idgeoreference = g.idgeoreference WHERE gr.idclient = idclient AND gr.enabled = 't' AND st_intersects(g.geom, st_geomfromtext('POINT('||longitude||' '||latitude||')',4326)) ORDER BY 1;