Gecko [ 8.222.176.185 ]

Name	Size	Permission
Config	[ DIR ]	drwxrwxrwx
Database	[ DIR ]	drwxrwxrwx
Export	[ DIR ]	drwxrwxrwx
Import	[ DIR ]	drwxrwxrwx
Preferences	[ DIR ]	drwxrwxrwx
Server	[ DIR ]	drwxrwxrwx
Setup	[ DIR ]	drwxrwxrwx
Sql	[ DIR ]	drwxrwxrwx
Table	[ DIR ]	drwxrwxrwx
Transformation	[ DIR ]	drwxrwxrwx
View	[ DIR ]	drwxrwxrwx
AbstractController.php	2.53 KB	-rw-rw-rw-
BrowseForeignersController.php	2.41 KB	-rw-rw-rw-
ChangeLogController.php	3.44 KB	-rw-rw-rw-
CheckRelationsController.php	2.25 KB	-rw-rw-rw-
CollationConnectionController....	809 B	-rw-rw-rw-
ColumnController.php	1.04 KB	-rw-rw-rw-
DatabaseController.php	275 B	-rw-rw-rw-
ErrorReportController.php	6.05 KB	-rw-rw-rw-
GisDataEditorController.php	5.09 KB	-rw-rw-rw-
GitInfoController.php	1.19 KB	-rw-rw-rw-
HomeController.php	17.05 KB	-rw-rw-rw-
JavaScriptMessagesController.p...	36.16 KB	-rw-rw-rw-
LicenseController.php	940 B	-rw-rw-rw-
LintController.php	1.73 KB	-rw-rw-rw-
LogoutController.php	421 B	-rw-rw-rw-
NavigationController.php	3.2 KB	-rw-rw-rw-
NormalizationController.php	5.54 KB	-rw-rw-rw-
PhpInfoController.php	685 B	-rw-rw-rw-
RecentTablesListController.php	426 B	-rw-rw-rw-
SchemaExportController.php	667 B	-rw-rw-rw-
TableController.php	820 B	-rw-rw-rw-
ThemeSetController.php	1.23 KB	-rw-rw-rw-
ThemesController.php	772 B	-rw-rw-rw-
UserPasswordController.php	3.3 KB	-rw-rw-rw-
VersionCheckController.php	1.2 KB	-rw-rw-rw-

Code Editor : GisDataEditorController.php

<?php
/**
 * Editor for Geometry data types.
 */

declare(strict_types=1);

namespace PhpMyAdmin\Controllers;

use PhpMyAdmin\Gis\GisFactory;
use PhpMyAdmin\Gis\GisVisualization;
use PhpMyAdmin\Http\ServerRequest;

use function array_merge;
use function in_array;
use function intval;
use function is_array;
use function mb_strpos;
use function mb_strtoupper;
use function mb_substr;
use function substr;
use function trim;

/**
 * Editor for Geometry data types.
 */
class GisDataEditorController extends AbstractController
{
    public function __invoke(ServerRequest $request): void
    {
        global $gis_data, $gis_types, $start, $geom_type, $gis_obj, $srid, $wkt, $wkt_with_zero;
        global $result, $visualizationSettings, $data, $visualization, $open_layers, $geom_count, $dbi;

/** @var string|null $field */
        $field = $request->getParsedBodyParam('field');
        /** @var array|null $gisDataParam */
        $gisDataParam = $request->getParsedBodyParam('gis_data');
        /** @var string $type */
        $type = $request->getParsedBodyParam('type', '');
        /** @var string|null $value */
        $value = $request->getParsedBodyParam('value');
        /** @var string|null $generate */
        $generate = $request->getParsedBodyParam('generate');
        /** @var string|null $inputName */
        $inputName = $request->getParsedBodyParam('input_name');

if (! isset($field)) {
            return;
        }

// Get data if any posted
        $gis_data = [];
        if (is_array($gisDataParam)) {
            $gis_data = $gisDataParam;
        }

$gis_types = [
            'POINT',
            'MULTIPOINT',
            'LINESTRING',
            'MULTILINESTRING',
            'POLYGON',
            'MULTIPOLYGON',
            'GEOMETRYCOLLECTION',
        ];

// Extract type from the initial call and make sure that it's a valid one.
        // Extract from field's values if available, if not use the column type passed.
        if (! isset($gis_data['gis_type'])) {
            if ($type !== '') {
                $gis_data['gis_type'] = mb_strtoupper($type);
            }

if (isset($value) && trim($value) !== '') {
                $start = substr($value, 0, 1) == "'" ? 1 : 0;
                $gis_data['gis_type'] = mb_substr($value, $start, (int) mb_strpos($value, '(') - $start);
            }

if (! isset($gis_data['gis_type']) || (! in_array($gis_data['gis_type'], $gis_types))) {
                $gis_data['gis_type'] = $gis_types[0];
            }
        }

$geom_type = $gis_data['gis_type'];

// Generate parameters from value passed.
        $gis_obj = GisFactory::factory($geom_type);
        if ($gis_obj === false) {
            return;
        }

if (isset($value)) {
            $gis_data = array_merge(
                $gis_data,
                $gis_obj->generateParams($value)
            );
        }

// Generate Well Known Text
        $srid = isset($gis_data['srid']) && $gis_data['srid'] != '' ? (int) $gis_data['srid'] : 0;
        $wkt = $gis_obj->generateWkt($gis_data, 0);
        $wkt_with_zero = $gis_obj->generateWkt($gis_data, 0, '0');
        $result = "'" . $wkt . "'," . $srid;

// Generate SVG based visualization
        $visualizationSettings = [
            'width' => 450,
            'height' => 300,
            'spatialColumn' => 'wkt',
            'mysqlVersion' => $dbi->getVersion(),
            'isMariaDB' => $dbi->isMariaDB(),
        ];
        $data = [
            [
                'wkt' => $wkt_with_zero,
                'srid' => $srid,
            ],
        ];
        $visualization = GisVisualization::getByData($data, $visualizationSettings)
            ->toImage('svg');

$open_layers = GisVisualization::getByData($data, $visualizationSettings)
            ->asOl();

// If the call is to update the WKT and visualization make an AJAX response
        if ($generate) {
            $this->response->addJSON([
                'result' => $result,
                'visualization' => $visualization,
                'openLayers' => $open_layers,
            ]);

return;
        }

$geom_count = 1;
        if ($geom_type === 'GEOMETRYCOLLECTION') {
            $geom_count = isset($gis_data[$geom_type]['geom_count'])
                ? intval($gis_data[$geom_type]['geom_count']) : 1;
            if (isset($gis_data[$geom_type]['add_geom'])) {
                $geom_count++;
            }
        }

$templateOutput = $this->template->render('gis_data_editor_form', [
            'width' => $visualizationSettings['width'],
            'height' => $visualizationSettings['height'],
            'field' => $field,
            'input_name' => $inputName,
            'srid' => $srid,
            'visualization' => $visualization,
            'open_layers' => $open_layers,
            'gis_types' => $gis_types,
            'geom_type' => $geom_type,
            'geom_count' => $geom_count,
            'gis_data' => $gis_data,
            'result' => $result,
        ]);

$this->response->addJSON(['gis_editor' => $templateOutput]);
    }
}

${this.title}

Code Editor : GisDataEditorController.php