Différences

Ci-dessous, les différences entre deux révisions de la page.

--- geo_data:epns_geojson [19/01/2014 16:15]
cyrille37
+++ geo_data:epns_geojson [21/08/2020 13:26]
@@ Ligne 1: / Ligne 1: @@
-<php>
-$dataPluginFile = DOKU_PLUGIN.'data/syntax/table.php';
-if(!file_exists($dataPluginFile)){
- msg('Cannot find Data plugin.', -1);
-}
-require_once $dataPluginFile;
-$pdt = new syntax_plugin_data_table();
-$data = array(
- 'classes'    => 'association',
- 'limit'      => 0,
- 'dynfilters' => false,
- 'summarize'  => false,
- 'rownumbers' => false,
- 'sepbyheaders' => false,
- 'headers'    => array(),
- 'widths'     => array(),
- 'filter'     => array()
-);
-$flt = $this->dthlp->_parse_filter('epn=oui');
-$data['filter'][] = $flt;
-$column = $pdt->dthlp->_column('lat');
-$data['cols'][$column['key']] = $column;
-$column = $pdt->dthlp->_column('lon');
-$data['cols'][$column['key']] = $column;
-$column = $pdt->dthlp->_column('nom');
-$data['cols'][$column['key']] = $column;
-$column = $pdt->dthlp->_column('adresse1');
-$data['cols'][$column['key']] = $column;
-$column = $pdt->dthlp->_column('adresse2');
-$data['cols'][$column['key']] = $column;
-$column = $pdt->dthlp->_column('adresse3');
-$data['cols'][$column['key']] = $column;
-$column = $pdt->dthlp->_column('codepostal');
-$data['cols'][$column['key']] = $column;
-$column = $pdt->dthlp->_column('ville');
-$data['cols'][$column['key']] = $column;
-$column = $pdt->dthlp->_column('web');
-$data['cols'][$column['key']] = $column;
-$sql = $pdt->_buildSQL($data);
-$sqlite = $pdt->dthlp->_getDB();
-$res = $sqlite->query($sql);
-$rows = $sqlite->res2arr($res);
-$rowsCount = count($rows);
-echo '{ "type":"FeatureCollection", "features": ['."\n";
-foreach( $rows as $n => $row ){
- $rowsCount -- ;
- list($lat, $lon, $nom, $adr1, $adr2, $adr3, $cp, $ville, $web) = array_values($row);
- // le plugin export_text vire tous les tags html donc pas possible de formater les informations
- $addresse = $adr1.' '.$adr2.' '.$adr3.' '.$cp.' '.$ville ;
- echo '{"type":"Feature","properties":{
-	  "name":"'.$nom.'",
-	  "address":"'.$addresse.'"
-	 },
-	 "geometry":{"type":"Point","coordinates":["'.trim($lon).'","'.trim($lat).'"]}
-	}';
- if( $rowsCount>0 )
-  echo ',';
-}
-echo '] }'."\n";
-</php>

Savoirs communs

Outils pour utilisateurs

Outils du site

Différences

Outils de la page