maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
omni_ro_get_current_geofence_tmp(integer, double precision, double precision)
Parameters
Name
Type
Mode
in_idclient
integer
IN
longitude
double precision
IN
latitude
double precision
IN
Definition
DECLARE BEGIN IF in_idclient IN (SELECT idclientowner FROM shipperconf WHERE idclientshipper = 159) THEN RETURN QUERY (SELECT DISTINCT gr.idgeoreference FROM geofence gf JOIN georeference gr ON gr.idgeoreference = gf.idgeoreference WHERE (gr.idclient = in_idclient or gr.idclient in (select idclientshipper from shipperconf where idclientowner = in_idclient)) AND st_intersects(geom, st_geomfromtext('POINT('||longitude||' '||latitude||')',4326)) AND gr.enabled = 'true' ORDER BY 1 ); ELSE 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_geomfromtext('POINT('||longitude||' '||latitude||')',4326)) AND gr.enabled = 'true' ORDER BY 1 ); END IF; EXCEPTION WHEN OTHERS THEN RAISE WARNING 'ERROR omni_ro_get_current_geofence_tmp, shipperconf modifications are wrong'; END