type == 'geometry') { $spatialCandidates[] = $column_meta->name; } else { $labelCandidates[] = $column_meta->name; } } // Get settings if any posted $visualizationSettings = array(); if (PMA_isValid($_REQUEST['visualizationSettings'], 'array')) { $visualizationSettings = $_REQUEST['visualizationSettings']; } if (! isset($visualizationSettings['labelColumn']) && isset($labelCandidates[0])) { $visualizationSettings['labelColumn'] = ''; } // If spatial column is not set, use first geometric colum as spatial column if (! isset($visualizationSettings['spatialColumn'])) { $visualizationSettings['spatialColumn'] = $spatialCandidates[0]; } // Convert geometric columns from bytes to text. $modified_query = PMA_GIS_modifyQuery($sql_query, $visualizationSettings); $modified_result = PMA_DBI_try_query($modified_query); $data = array(); while ($row = PMA_DBI_fetch_assoc($modified_result)) { $data[] = $row; } // If all the rows contain SRID, use OpenStreetMaps on the initial loading. if (! isset($_REQUEST['displayVisualization'])) { $visualizationSettings['choice'] = 'useBaseLayer'; foreach ($data as $row) { if ($row['srid'] == 0) { unset($visualizationSettings['choice']); break; } } } if (isset($_REQUEST['saveToFile'])) { $file_name = $_REQUEST['fileName']; if ($file_name == '') { $file_name = $visualizationSettings['spatialColumn']; } $save_format = $_REQUEST['fileFormat']; PMA_GIS_saveToFile($data, $visualizationSettings, $save_format, $file_name); exit(); } $svg_support = (PMA_USR_BROWSER_AGENT == 'IE' && PMA_USR_BROWSER_VER <= 8) ? false : true; $format = $svg_support ? 'svg' : 'png'; // get the chart and settings after chart generation $visualization = PMA_GIS_visualizationResults($data, $visualizationSettings, $format); /** * Displays the page */ ?>
/>