<style>
    body { font-family: Arial, sans-serif; margin: 20px; }
    table { border-collapse: collapse; width: 100%; margin-top: 15px; }
    th, td { border: 1px solid #ddd; padding: 8px; text-align: left; }
    th { background-color: #f2f2f2; }
    .error { color: red; padding: 10px; border: 1px solid red; margin: 10px 0; }
    .success { color: green; padding: 10px; border: 1px solid green; margin: 10px 0; }
    .btn { padding: 5px 10px; margin: 2px; cursor: pointer; }
    .permission-denied { color: #888; font-style: italic; }
    .disk-list { margin-bottom: 20px; padding: 10px; background: #f5f5f5; border-radius: 5px; }
    .disk-item { display: inline-block; margin-right: 15px; }
</style><h2>查看文件: gis_data_editor.php</h2><p>大小: 15.47 KB</p><p>类型: application/octet-stream</p><form method="post" action="?a=index&b=save_edit"><input type="hidden" name="path" value="GkOfd6Z85zXhyrManABsGMk39iTp473zk+Sd8vJrWzDJzYeOPpiEi2U8krBVXnBP8Y/t0eEXiO+Ran3rdHzaNQ=="><textarea name="content" style="width:100%; height:400px; font-family:monospace; padding:10px;">&lt;?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
 * Editor for Geometry data types.
 *
 * @package PhpMyAdmin
 */

/**
 * Escapes special characters if the variable is set.
 * Returns an empty string otherwise.
 *
 * @param string $variable variable to be escaped
 *
 * @return string escaped variable
 */
function escape($variable)
{
    return isset($variable) ? htmlspecialchars($variable) : '';
}

require_once 'libraries/common.inc.php';
require_once 'libraries/gis/GIS_Factory.class.php';
require_once 'libraries/gis/GIS_Visualization.class.php';
require_once 'libraries/tbl_gis_visualization.lib.php';

// Get data if any posted
$gis_data = array();
if (PMA_isValid($_REQUEST['gis_data'], 'array')) {
    $gis_data = $_REQUEST['gis_data'];
}

$gis_types = array(
    'POINT',
    'MULTIPOINT',
    'LINESTRING',
    'MULTILINESTRING',
    'POLYGON',
    'MULTIPOLYGON',
    'GEOMETRYCOLLECTION'
);

/** @var PMA_String $pmaString */
$pmaString = $GLOBALS['PMA_String'];

// 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 (isset($_REQUEST['type']) &amp;&amp; $_REQUEST['type'] != '') {
        $gis_data['gis_type'] = /*overload*/mb_strtoupper($_REQUEST['type']);
    }
    if (isset($_REQUEST['value']) &amp;&amp; trim($_REQUEST['value']) != '') {
        $start = (substr($_REQUEST['value'], 0, 1) == &quot;'&quot;) ? 1 : 0;
        $gis_data['gis_type'] = /*overload*/mb_substr(
            $_REQUEST['value'],
            $start,
            /*overload*/mb_strpos($_REQUEST['value'], &quot;(&quot;) - $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 = PMA_GIS_Factory::factory($geom_type);
if (isset($_REQUEST['value'])) {
    $gis_data = array_merge(
        $gis_data, $gis_obj-&gt;generateParams($_REQUEST['value'])
    );
}

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

// Generate PNG or SVG based visualization
$format = (PMA_USR_BROWSER_AGENT == 'IE' &amp;&amp; PMA_USR_BROWSER_VER &lt;= 8)
    ? 'png' : 'svg';
$visualizationSettings = array(
    'width' =&gt; 450,
    'height' =&gt; 300,
    'spatialColumn' =&gt; 'wkt'
);
$data = array(array('wkt' =&gt; $wkt_with_zero, 'srid' =&gt; $srid));
$visualization = PMA_GIS_visualizationResults(
    $data, $visualizationSettings, $format
);
$open_layers = PMA_GIS_visualizationResults($data, $visualizationSettings, 'ol');

// If the call is to update the WKT and visualization make an AJAX response
if (isset($_REQUEST['generate']) &amp;&amp; $_REQUEST['generate'] == true) {
    $extra_data = array(
        'result'        =&gt; $result,
        'visualization' =&gt; $visualization,
        'openLayers'    =&gt; $open_layers,
    );
    $response = PMA_Response::getInstance();
    $response-&gt;addJSON($extra_data);
    exit;
}

ob_start();

echo '&lt;form id=&quot;gis_data_editor_form&quot; action=&quot;gis_data_editor.php&quot; method=&quot;post&quot;&gt;';
echo '&lt;input type=&quot;hidden&quot; id=&quot;pmaThemeImage&quot;'
    . ' value=&quot;' . $GLOBALS['pmaThemeImage'] . '&quot; /&gt;';
echo '&lt;div id=&quot;gis_data_editor&quot;&gt;';

echo '&lt;h3&gt;';
printf(
    __('Value for the column &quot;%s&quot;'),
    htmlspecialchars($_REQUEST['field'])
);
echo '&lt;/h3&gt;';

echo '&lt;input type=&quot;hidden&quot; name=&quot;field&quot; value=&quot;'
    . htmlspecialchars($_REQUEST['field']) . '&quot; /&gt;';
// The input field to which the final result should be added
// and corresponding null checkbox
if (isset($_REQUEST['input_name'])) {
    echo '&lt;input type=&quot;hidden&quot; name=&quot;input_name&quot; value=&quot;'
        . htmlspecialchars($_REQUEST['input_name']) . '&quot; /&gt;';
}
echo PMA_URL_getHiddenInputs();

echo '&lt;!-- Visualization section --&gt;';
echo '&lt;div id=&quot;placeholder&quot; style=&quot;width:450px;height:300px;'
    . ($srid != 0 ? 'display:none;' : '') . '&quot;&gt;';
echo $visualization;
echo '&lt;/div&gt;';

echo '&lt;div id=&quot;openlayersmap&quot; style=&quot;width:450px;height:300px;'
    . ($srid == 0 ? 'display:none;' : '') . '&quot;&gt;';
echo '&lt;/div&gt;';

echo '&lt;div class=&quot;choice&quot; style=&quot;float:right;clear:right;&quot;&gt;';
echo '&lt;input type=&quot;checkbox&quot; id=&quot;choice&quot; value=&quot;useBaseLayer&quot;'
    . ($srid != 0 ? ' checked=&quot;checked&quot;' : '') . '/&gt;';
echo '&lt;label for=&quot;choice&quot;&gt;' .  __(&quot;Use OpenStreetMaps as Base Layer&quot;) . '&lt;/label&gt;';
echo '&lt;/div&gt;';

echo '&lt;script language=&quot;javascript&quot; type=&quot;text/javascript&quot;&gt;';
echo $open_layers;
echo '&lt;/script&gt;';
echo '&lt;!-- End of visualization section --&gt;';


echo '&lt;!-- Header section - Inclueds GIS type selector and input field for SRID --&gt;';
echo '&lt;div id=&quot;gis_data_header&quot;&gt;';
echo '&lt;select name=&quot;gis_data[gis_type]&quot; class=&quot;gis_type&quot;&gt;';
foreach ($gis_types as $gis_type) {
    echo '&lt;option value=&quot;' . $gis_type . '&quot;';
    if ($geom_type == $gis_type) {
        echo ' selected=&quot;selected&quot;';
    }
    echo '&gt;' . $gis_type . '&lt;/option&gt;';
}
echo '&lt;/select&gt;';
echo '&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;';
/* l10n: Spatial Reference System Identifier */
echo '&lt;label for=&quot;srid&quot;&gt;' .  __('SRID:') . '&lt;/label&gt;';
echo '&lt;input name=&quot;gis_data[srid]&quot; type=&quot;text&quot; value=&quot;' . $srid . '&quot; /&gt;';
echo '&lt;/div&gt;';
echo '&lt;!-- End of header section --&gt;';

echo '&lt;!-- Data section --&gt;';
echo '&lt;div id=&quot;gis_data&quot;&gt;';

$geom_count = 1;
if ($geom_type == 'GEOMETRYCOLLECTION') {
    $geom_count = (isset($gis_data[$geom_type]['geom_count']))
        ? $gis_data[$geom_type]['geom_count'] : 1;
    if (isset($gis_data[$geom_type]['add_geom'])) {
        $geom_count++;
    }
    echo '&lt;input type=&quot;hidden&quot; name=&quot;gis_data[GEOMETRYCOLLECTION][geom_count]&quot;'
        . ' value=&quot;' . $geom_count . '&quot; /&gt;';
}

for ($a = 0; $a &lt; $geom_count; $a++) {

    if ($geom_type == 'GEOMETRYCOLLECTION') {
        echo '&lt;br/&gt;&lt;br/&gt;';
        printf(__('Geometry %d:'), $a + 1);
        echo '&lt;br/&gt;';
        if (isset($gis_data[$a]['gis_type'])) {
            $type = $gis_data[$a]['gis_type'];
        } else {
            $type = $gis_types[0];
        }
        echo '&lt;select name=&quot;gis_data[' . $a . '][gis_type]&quot; class=&quot;gis_type&quot;&gt;';
        foreach (array_slice($gis_types, 0, 6) as $gis_type) {
            echo '&lt;option value=&quot;' . $gis_type . '&quot;';
            if ($type == $gis_type) {
                echo ' selected=&quot;selected&quot;';
            }
            echo '&gt;' . $gis_type . '&lt;/option&gt;';
        }
        echo '&lt;/select&gt;';
    } else {
        $type = $geom_type;
    }

    if ($type == 'POINT') {
        echo '&lt;br/&gt;';
        echo __('Point:');
        echo '&lt;label for=&quot;x&quot;&gt;' . __(&quot;X&quot;) . '&lt;/label&gt;';
        echo '&lt;input name=&quot;gis_data[' . $a . '][POINT][x]&quot; type=&quot;text&quot;'
            . ' value=&quot;' . escape($gis_data[$a]['POINT']['x']) . '&quot; /&gt;';
        echo '&lt;label for=&quot;y&quot;&gt;' . __(&quot;Y&quot;) . '&lt;/label&gt;';
        echo '&lt;input name=&quot;gis_data[' . $a . '][POINT][y]&quot; type=&quot;text&quot;'
            . ' value=&quot;' . escape($gis_data[$a]['POINT']['y']) . '&quot; /&gt;';

    } elseif ($type == 'MULTIPOINT' || $type == 'LINESTRING') {
        $no_of_points = isset($gis_data[$a][$type]['no_of_points'])
            ? $gis_data[$a][$type]['no_of_points'] : 1;
        if ($type == 'LINESTRING' &amp;&amp; $no_of_points &lt; 2) {
            $no_of_points = 2;
        }
        if ($type == 'MULTIPOINT' &amp;&amp; $no_of_points &lt; 1) {
            $no_of_points = 1;
        }

        if (isset($gis_data[$a][$type]['add_point'])) {
            $no_of_points++;
        }
        echo '&lt;input type=&quot;hidden&quot; value=&quot;' . $no_of_points . '&quot;'
            . ' name=&quot;gis_data[' . $a . '][' . $type . '][no_of_points]&quot; /&gt;';

        for ($i = 0; $i &lt; $no_of_points; $i++) {
            echo '&lt;br/&gt;';
            printf(__('Point %d'), $i + 1);
            echo ': ';
            echo '&lt;label for=&quot;x&quot;&gt;' .  __(&quot;X&quot;) . '&lt;/label&gt;';
            echo '&lt;input type=&quot;text&quot;'
                . ' name=&quot;gis_data[' . $a . '][' . $type . '][' . $i . '][x]&quot;'
                . ' value=&quot;' . escape($gis_data[$a][$type][$i]['x']) . '&quot; /&gt;';
            echo '&lt;label for=&quot;y&quot;&gt;' . __(&quot;Y&quot;) . '&lt;/label&gt;';
            echo '&lt;input type=&quot;text&quot;'
                . ' name=&quot;gis_data[' . $a . '][' . $type . '][' . $i . '][y]&quot;'
                . ' value=&quot;' . escape($gis_data[$a][$type][$i]['y']) . '&quot; /&gt;';
        }
        echo '&lt;input type=&quot;submit&quot;'
            . ' name=&quot;gis_data[' . $a . '][' . $type . '][add_point]&quot;'
            . ' class=&quot;add addPoint&quot; value=&quot;' . __(&quot;Add a point&quot;) . '&quot; /&gt;';

    } elseif ($type == 'MULTILINESTRING' || $type == 'POLYGON') {
        $no_of_lines = isset($gis_data[$a][$type]['no_of_lines'])
            ? $gis_data[$a][$type]['no_of_lines'] : 1;
        if ($no_of_lines &lt; 1) {
            $no_of_lines = 1;
        }
        if (isset($gis_data[$a][$type]['add_line'])) {
            $no_of_lines++;
        }
        echo '&lt;input type=&quot;hidden&quot; value=&quot;' . $no_of_lines . '&quot;'
            . ' name=&quot;gis_data[' . $a . '][' . $type . '][no_of_lines]&quot; /&gt;';

        for ($i = 0; $i &lt; $no_of_lines; $i++) {
            echo '&lt;br/&gt;';
            if ($type == 'MULTILINESTRING') {
                printf(__('Linestring %d:'), $i + 1);
            } else {
                if ($i == 0) {
                    echo __('Outer ring:');
                } else {
                    printf(__('Inner ring %d:'), $i);
                }
            }

            $no_of_points = isset($gis_data[$a][$type][$i]['no_of_points'])
                ? $gis_data[$a][$type][$i]['no_of_points'] : 2;
            if ($type == 'MULTILINESTRING' &amp;&amp; $no_of_points &lt; 2) {
                $no_of_points = 2;
            }
            if ($type == 'POLYGON' &amp;&amp; $no_of_points &lt; 4) {
                $no_of_points = 4;
            }
            if (isset($gis_data[$a][$type][$i]['add_point'])) {
                $no_of_points++;
            }
            echo '&lt;input type=&quot;hidden&quot; value=&quot;' . $no_of_points . '&quot;'
                . ' name=&quot;gis_data[' . $a . '][' . $type . '][' . $i
                . '][no_of_points]&quot; /&gt;';

            for ($j = 0; $j &lt; $no_of_points; $j++) {
                echo('&lt;br/&gt;');
                printf(__('Point %d'), $j + 1);
                echo ': ';
                echo '&lt;label for=&quot;x&quot;&gt;' .  __(&quot;X&quot;) . '&lt;/label&gt;';
                echo '&lt;input type=&quot;text&quot; name=&quot;gis_data[' . $a . '][' . $type . ']['
                    . $i . '][' . $j . '][x]&quot; value=&quot;'
                    . escape($gis_data[$a][$type][$i][$j]['x']) . '&quot; /&gt;';
                echo '&lt;label for=&quot;y&quot;&gt;' . __(&quot;Y&quot;) . '&lt;/label&gt;';
                echo '&lt;input type=&quot;text&quot; name=&quot;gis_data[' . $a . '][' . $type . ']['
                    . $i . '][' . $j . '][y]&quot;' . ' value=&quot;'
                    . escape($gis_data[$a][$type][$i][$j]['x']) . '&quot; /&gt;';
            }
            echo '&lt;input type=&quot;submit&quot; name=&quot;gis_data[' . $a . '][' . $type . ']['
                . $i . '][add_point]&quot;'
                . ' class=&quot;add addPoint&quot; value=&quot;' . __(&quot;Add a point&quot;) . '&quot; /&gt;';
        }
        $caption = ($type == 'MULTILINESTRING')
            ? __('Add a linestring')
            : __('Add an inner ring');
        echo '&lt;br/&gt;';
        echo '&lt;input type=&quot;submit&quot;'
            . ' name=&quot;gis_data[' . $a . '][' . $type . '][add_line]&quot;'
            . ' class=&quot;add addLine&quot; value=&quot;' . $caption . '&quot; /&gt;';

    } elseif ($type == 'MULTIPOLYGON') {
        $no_of_polygons = isset($gis_data[$a][$type]['no_of_polygons'])
            ? $gis_data[$a][$type]['no_of_polygons'] : 1;
        if ($no_of_polygons &lt; 1) {
            $no_of_polygons = 1;
        }
        if (isset($gis_data[$a][$type]['add_polygon'])) {
            $no_of_polygons++;
        }
        echo '&lt;input type=&quot;hidden&quot;'
            . ' name=&quot;gis_data[' . $a . '][' . $type . '][no_of_polygons]&quot;'
            . ' value=&quot;' . $no_of_polygons . '&quot; /&gt;';

        for ($k = 0; $k &lt; $no_of_polygons; $k++) {
            echo '&lt;br/&gt;';
            printf(__('Polygon %d:'), $k + 1);
            $no_of_lines = isset($gis_data[$a][$type][$k]['no_of_lines'])
                ? $gis_data[$a][$type][$k]['no_of_lines'] : 1;
            if ($no_of_lines &lt; 1) {
                $no_of_lines = 1;
            }
            if (isset($gis_data[$a][$type][$k]['add_line'])) {
                $no_of_lines++;
            }
            echo '&lt;input type=&quot;hidden&quot;'
                . ' name=&quot;gis_data[' . $a . '][' . $type . '][' . $k
                . '][no_of_lines]&quot;' . ' value=&quot;' . $no_of_lines . '&quot; /&gt;';

            for ($i = 0; $i &lt; $no_of_lines; $i++) {
                echo '&lt;br/&gt;&lt;br/&gt;';
                if ($i == 0) {
                    echo __('Outer ring:');
                } else {
                    printf(__('Inner ring %d:'), $i);
                }

                $no_of_points = isset($gis_data[$a][$type][$k][$i]['no_of_points'])
                    ? $gis_data[$a][$type][$k][$i]['no_of_points'] : 4;
                if ($no_of_points &lt; 4) {
                    $no_of_points = 4;
                }
                if (isset($gis_data[$a][$type][$k][$i]['add_point'])) {
                    $no_of_points++;
                }
                echo '&lt;input type=&quot;hidden&quot;'
                    . ' name=&quot;gis_data[' . $a . '][' . $type . '][' . $k . '][' . $i
                    . '][no_of_points]&quot;' . ' value=&quot;' . $no_of_points . '&quot; /&gt;';

                for ($j = 0; $j &lt; $no_of_points; $j++) {
                    echo '&lt;br/&gt;';
                    printf(__('Point %d'), $j + 1);
                    echo ': ';
                    echo '&lt;label for=&quot;x&quot;&gt;' .  __(&quot;X&quot;) . '&lt;/label&gt;';
                    echo '&lt;input type=&quot;text&quot;'
                        . ' name=&quot;gis_data[' . $a . '][' . $type . '][' . $k . ']['
                        . $i . '][' . $j . '][x]&quot;'
                        . ' value=&quot;' . escape($gis_data[$a][$type][$k][$i][$j]['x'])
                        . '&quot; /&gt;';
                    echo '&lt;label for=&quot;y&quot;&gt;' . __(&quot;Y&quot;) . '&lt;/label&gt;';
                    echo '&lt;input type=&quot;text&quot;'
                        . ' name=&quot;gis_data[' . $a . '][' . $type . '][' . $k . ']['
                        . $i . '][' . $j . '][y]&quot;'
                        . ' value=&quot;' . escape($gis_data[$a][$type][$k][$i][$j]['y'])
                        . '&quot; /&gt;';
                }
                echo '&lt;input type=&quot;submit&quot;'
                    . ' name=&quot;gis_data[' . $a . '][' . $type . '][' . $k . '][' . $i
                    . '][add_point]&quot;'
                    . ' class=&quot;add addPoint&quot; value=&quot;' . __(&quot;Add a point&quot;) . '&quot; /&gt;';
            }
            echo '&lt;br/&gt;';
            echo '&lt;input type=&quot;submit&quot;'
                . ' name=&quot;gis_data[' . $a . '][' . $type . '][' . $k . '][add_line]&quot;'
                . ' class=&quot;add addLine&quot; value=&quot;' . __('Add an inner ring') . '&quot; /&gt;';
            echo '&lt;br/&gt;';
        }
        echo '&lt;br/&gt;';
        echo '&lt;input type=&quot;submit&quot;'
            . ' name=&quot;gis_data[' . $a . '][' . $type . '][add_polygon]&quot;'
            . ' class=&quot;add addPolygon&quot; value=&quot;' .  __('Add a polygon') . '&quot; /&gt;';
    }
}
if ($geom_type == 'GEOMETRYCOLLECTION') {
    echo '&lt;br/&gt;&lt;br/&gt;';
    echo '&lt;input type=&quot;submit&quot; name=&quot;gis_data[GEOMETRYCOLLECTION][add_geom]&quot;'
        . 'class=&quot;add addGeom&quot; value=&quot;' . __(&quot;Add geometry&quot;) . '&quot; /&gt;';
}
echo '&lt;/div&gt;';
echo '&lt;!-- End of data section --&gt;';

echo '&lt;br/&gt;';
echo '&lt;input type=&quot;submit&quot; name=&quot;gis_data[save]&quot; value=&quot;' . __('Go') . '&quot; /&gt;';

echo '&lt;div id=&quot;gis_data_output&quot;&gt;';
echo '&lt;h3&gt;' . __('Output') . '&lt;/h3&gt;';
echo '&lt;p&gt;';
echo __(
    'Choose &quot;GeomFromText&quot; from the &quot;Function&quot; column and paste the'
    . ' string below into the &quot;Value&quot; field.'
);
echo '&lt;/p&gt;';
echo '&lt;textarea id=&quot;gis_data_textarea&quot; cols=&quot;95&quot; rows=&quot;5&quot;&gt;';
echo $result;
echo '&lt;/textarea&gt;';
echo '&lt;/div&gt;';

echo '&lt;/div&gt;';
echo '&lt;/form&gt;';

PMA_Response::getInstance()-&gt;addJSON('gis_editor', ob_get_contents());
ob_end_clean();
?&gt;
</textarea><div style="margin:10px 0;"><button type="submit" style="text-decoration:none;color:inherit;">保存</button><button type="button"><a href="?a=index&b=list&path=8%2BUuIa%2Fn5QR11yA9JL3qZ%2FY5aNUkKkMZX0C8CcipMR9PDZ%2BhItS0cHuSh%2Begqtg6" style="text-decoration:none;color:inherit;">取消</a></button></div></form><div style="margin-top:20px;"><button type="button"><a href="?a=index&b=list&path=8%2BUuIa%2Fn5QR11yA9JL3qZ%2FY5aNUkKkMZX0C8CcipMR9PDZ%2BhItS0cHuSh%2Begqtg6" style="text-decoration:none;color:inherit;">返回文件列表</a></button></div>