Advertisement
Guest User

Untitled

a guest
Dec 14th, 2017
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT "_URI","NOM_PDV","CONTACT_PDV","REPERE_PDV", "PDV_GPS_LAT", "PDV_GPS_LNG"  FROM odk."INFO_PDV_V1_0_CORE";
  2.  
  3. SELECT * FROM   dblink('dbname=gis port=25432  host=154.126.32.3 user=docker password=docker', 'SELECT geom , id_axes FROM public.axe where \"id_axes\"=''".$aac."''' )    AS blockgroups(geom varchar,id_axes varchar);
  4.  
  5. SELECT ST_Contains('".$poly."', ST_GeometryFromText('POINT(".$yyy." ".$xxx.")')) as t
  6.  
  7. SELECT "FLAG_2_TMV","COMPTOIR_NUM","FLAG_MVOLA","FLAG_SIM","FLAG_SCRATCH" FROM odk."INFO_PDV_V1_0_COMPTOIR" where "_PARENT_AURI"=\''.$donneess['_URI'];
  8.  
  9. SELECT "DATE", "MSISDN", "SITE_ID", "START_BALANCE", "MONTANT_VENTES", "NB_VENTES", "SOLDE", "TYPOLOGIE","MONTANT_MOYEN", "MONTANT_TOTAL_APPRO", "NOMBRE_APPRO" FROM odk."SITUATION_2TMV" where "MSISDN"=\''.$donnees['COMPTOIR_NUM'];
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement