PHP PMA_getHtmlForGisVisualization Examples

Example #1

File: tbl_gis_visualization.php Project: xtreme-jamil-shamy/phpmyadmin-cf

    $response->disable();
    $file_name = $visualizationSettings['spatialColumn'];
    $save_format = $_REQUEST['fileFormat'];
    PMA_GIS_saveToFile($data, $visualizationSettings, $save_format, $file_name);
    exit;
}
$header = $response->getHeader();
$scripts = $header->getScripts();
$scripts->addFile('openlayers/OpenLayers.js');
$scripts->addFile('jquery/jquery.svg.js');
$scripts->addFile('tbl_gis_visualization.js');
$scripts->addFile('OpenStreetMap.js');
// 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;
        }
    }
}
$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
 */
$html = PMA_getHtmlForGisVisualization($url_params, $labelCandidates, $spatialCandidates, $visualizationSettings, $sql_query, $visualization, $svg_support, $data);
$response->addHTML($html);

Example #2

File: PMA_tbl_gis_visualization_test.php Project: xtreme-jamil-shamy/phpmyadmin-cf

 /**
  * Tests for PMA_getHtmlForGisVisualization() method.
  *
  * @return void
  * @test
  */
 public function testPMAGetHtmlForGisVisualization()
 {
     $url_params = array("url_params");
     $labelCandidates = array("option1", "option2");
     $spatialCandidates = array("option2", "option3");
     $visualizationSettings = array('width' => 10, 'height' => 12, 'labelColumn' => 'labelColumn', 'spatialColumn' => 'spatialColumn', 'choice' => 'choice');
     $sql_query = "sql_query";
     $visualization = "visualization";
     $svg_support = array();
     $data = array();
     $html = PMA_getHtmlForGisVisualization($url_params, $labelCandidates, $spatialCandidates, $visualizationSettings, $sql_query, $visualization, $svg_support, $data);
     $this->assertContains('<legend>' . __('Display GIS Visualization') . '</legend>', $html);
     $this->assertContains(PMA_URL_getHiddenInputs($url_params), $html);
     $output = PMA_getHtmlForSelect("labelColumn", $labelCandidates, $visualizationSettings);
     $this->assertContains($output, $html);
     $output = PMA_getHtmlForSelect("spatialColumn", $spatialCandidates, $visualizationSettings);
     $this->assertContains($output, $html);
     $this->assertContains(htmlspecialchars($sql_query), $html);
     $this->assertContains('>PNG</a>', $html);
     $this->assertContains('>PDF</a>', $html);
     $this->assertContains(htmlspecialchars($visualizationSettings['width']), $html);
     $this->assertContains(htmlspecialchars($visualizationSettings['height']), $html);
     $this->assertContains($visualization, $html);
 }