maya.public

Parameters

Name	Type	Mode
in_idclient	integer	IN
x0	double precision	IN
y0	double precision	IN
x1	double precision	IN
y1	double precision	IN
in_zoom_factor	integer	IN

Definition

DECLARE
_points varchar;
BEGIN
/*
Regresa los id's las geocercas del cliente que intersectan al rectángulo construido de la siguiente forma:

x0y0 ----------------  x1y0
|                       |
|                       |
x0y1 ----------------  x1y1

donde x es la longitud y y la latitud

Ejemplo:

select omni_ro_get_current_geofence(45,-101.2974930,20.6518192,-101.3,20.7);

_points := concat_ws(',',concat_ws(' ',x0,y0),concat_ws(' ',x1,y0),concat_ws(' ',x1,y1),concat_ws(' ',x0,y1),concat_ws(' ',x0,y0));
-- tiene que discriminar a los clientes shield y aef para que a los primeros no les haga cálculos geoespaciales
RETURN QUERY (SELECT gr.idgeoreference FROM geofence gf JOIN georeference gr ON gr.idgeoreference = gf.idgeoreference WHERE
gr.idclient = in_idclient AND st_intersects(geom, st_geomfromtext('POLYGON(('|| _points ||'))',4326)) AND gr.enabled = 'true' AND zoom_factor <= in_zoom_factor
UNION
 SELECT gr.idgeoreference FROM path p JOIN georeference gr ON gr.idgeoreference = p.idgeoreference WHERE
gr.idclient = in_idclient AND st_intersects(geom, st_geomfromtext('POLYGON(('|| _points ||'))',4326)) AND gr.enabled = 'true'
);
END;

omni_ro_get_current_geofence(integer, double precision, double precision, double precision, double precision, integer)

Parameters

Definition