| Server IP : 85.214.239.14 / Your IP : 3.139.86.53 Web Server : Apache/2.4.62 (Debian) System : Linux h2886529.stratoserver.net 4.9.0 #1 SMP Tue Jan 9 19:45:01 MSK 2024 x86_64 User : www-data ( 33) PHP Version : 7.4.18 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /var/www/wordpress/phpMyAdmin/templates/ |
Upload File : |
<form id="gis_data_editor_form" action="gis_data_editor.php" method="post">
<input type="hidden" id="pmaThemeImage" value="{{ pma_theme_image }}">
<div id="gis_data_editor">
<h3>{{ 'Value for the column "%s"'|trans|format(field) }}</h3>
<input type="hidden" name="field" value="{{ field }}">
{# The input field to which the final result should be added and corresponding null checkbox #}
{% if input_name is not null %}
<input type="hidden" name="input_name" value="{{ input_name }}">
{% endif %}
{{ get_hidden_inputs() }}
{# Visualization section #}
<div id="placeholder"{{ srid != 0 ? ' class="hide"' }}>
{{ visualization|raw }}
</div>
<div id="openlayersmap" style="width: {{width}}px; height: {{height}}px;"{{ srid == 0 ? ' class="hide"' }}></div>
<div class="choice floatright">
<input type="checkbox" id="choice" value="useBaseLayer"{{ srid != 0 ? ' checked="checked"' }}>
<label for="choice">{% trans "Use OpenStreetMaps as Base Layer" %}</label>
</div>
<script language="javascript" type="text/javascript">{{ open_layers|raw }}</script>
{# End of visualization section #}
{# Header section - Inclueds GIS type selector and input field for SRID #}
<div id="gis_data_header">
<select name="gis_data[gis_type]" class="gis_type">
{% for gis_type in gis_types %}
<option value="{{ gis_type }}"{{ geom_type == gis_type ? ' selected="selected"' }}>
{{ gis_type }}
</option>
{% endfor %}
</select>
<label for="srid">{% trans %}SRID:{% context %}Spatial Reference System Identifier{% endtrans %}</label>
<input name="gis_data[srid]" type="text" value="{{ srid }}">
</div>
{# End of header section #}
{# Data section #}
<div id="gis_data">
{% if geom_type == 'GEOMETRYCOLLECTION' %}
<input type="hidden" name="gis_data[GEOMETRYCOLLECTION][geom_count]" value="{{ geom_count }}">
{% endif %}
{% for a in 0..geom_count - 1 %}
{% if gis_data[a] is not null %}
{% if geom_type == 'GEOMETRYCOLLECTION' %}
<br><br>
{{ 'Geometry %d:'|trans|format(a + 1) }}
<br>
{% if gis_data[a]['gis_type'] is not null %}
{% set type = gis_data[a]['gis_type'] %}
{% else %}
{% set type = gis_types[0] %}
{% endif %}
<select name="gis_data[{{ a }}][gis_type]" class="gis_type">
{% for gis_type in gis_types|slice(0, 6) %}
<option value="{{ gis_type }}"{{ type == gis_type ? ' selected="selected"' }}>
{{ gis_type }}
</option>
{% endfor %}
</select>
{% else %}
{% set type = geom_type %}
{% endif %}
{% if type == 'POINT' %}
<br>
{% trans 'Point:' %}
<label for="x">{% trans 'X' %}</label>
<input name="gis_data[{{ a }}][POINT][x]" type="text" value="{{ gis_data[a]['POINT']['x'] }}">
<label for="y">{% trans 'Y' %}</label>
<input name="gis_data[{{ a }}][POINT][y]" type="text" value="{{ gis_data[a]['POINT']['y'] }}">
{% elseif type == 'MULTIPOINT' or type == 'LINESTRING' %}
{% set no_of_points = gis_data[a][type]['no_of_points'] ?? 1 %}
{% if type == 'LINESTRING' and no_of_points < 2 %}
{% set no_of_points = 2 %}
{% endif %}
{% if type == 'MULTIPOINT' and no_of_points < 1 %}
{% set no_of_points = 1 %}
{% endif %}
{% if gis_data[a][type]['add_point'] is not null %}
{% set no_of_points = no_of_points + 1 %}
{% endif %}
<input type="hidden" value="{{ no_of_points }}" name="gis_data[{{ a }}][{{ type }}][no_of_points]">
{% for i in 0..no_of_points - 1 %}
<br>
{{ 'Point %d:'|trans|format(i + 1) }}
<label for="x">{% trans 'X' %}</label>
<input type="text" name="gis_data[{{ a }}][{{ type }}][{{ i }}][x]" value="{{ gis_data[a][type][i]['x'] }}">
<label for="y">{% trans 'Y' %}</label>
<input type="text" name="gis_data[{{ a }}][{{ type }}][{{ i }}][y]" value="{{ gis_data[a][type][i]['y'] }}">
{% endfor %}
<input type="submit" name="gis_data[{{ a }}][{{ type }}][add_point]" class="btn btn-secondary add addPoint" value="{% trans 'Add a point' %}">
{% elseif type == 'MULTILINESTRING' or type == 'POLYGON' %}
{% set no_of_lines = gis_data[a][type]['no_of_lines'] ?? 1 %}
{% if no_of_lines < 1 %}
{% set no_of_lines = 1 %}
{% endif %}
{% if gis_data[a][type]['add_line'] is not null %}
{% set no_of_lines = no_of_lines + 1 %}
{% endif %}
<input type="hidden" value="{{ no_of_lines }}" name="gis_data[{{ a }}][{{ type }}][no_of_lines]">
{% for i in 0..no_of_lines - 1 %}
<br>
{% if type == 'MULTILINESTRING' %}
{{ 'Linestring %d:'|trans|format(i + 1) }}
{% elseif i == 0 %}
{% trans 'Outer ring:' %}
{% else %}
{{ 'Inner ring %d:'|trans|format(i) }}
{% endif %}
{% set no_of_points = gis_data[a][type][i]['no_of_points'] ?? 2 %}
{% if type == 'MULTILINESTRING' and no_of_points < 2 %}
{% set no_of_points = 2 %}
{% endif %}
{% if type == 'POLYGON' and no_of_points < 4 %}
{% set no_of_points = 4 %}
{% endif %}
{% if gis_data[a][type][i]['add_point'] is not null %}
{% set no_of_points = no_of_points + 1 %}
{% endif %}
<input type="hidden" value="{{ no_of_points }}" name="gis_data[{{ a }}][{{ type }}][{{ i }}][no_of_points]">
{% for j in 0..no_of_points - 1 %}
<br>
{{ 'Point %d:'|trans|format(j + 1) }}
<label for="x">{% trans 'X' %}</label>
<input type="text" name="gis_data[{{ a }}][{{ type }}][{{ i }}][{{ j }}][x]" value="{{ gis_data[a][type][i][j]['x'] }}">
<label for="y">{% trans 'Y' %}</label>
<input type="text" name="gis_data[{{ a }}][{{ type }}][{{ i }}][{{ j }}][y]" value="{{ gis_data[a][type][i][j]['y'] }}">
{% endfor %}
<input type="submit" name="gis_data[{{ a }}][{{ type }}][{{ i }}][add_point]" class="btn btn-secondary add addPoint" value="{% trans 'Add a point' %}">
{% endfor %}
<br>
<input type="submit" name="gis_data[{{ a }}][{{ type }}][add_line]" class="btn btn-secondary add addLine" value="
{{- type == 'MULTILINESTRING' ? 'Add a linestring'|trans : 'Add an inner ring'|trans }}">
{% elseif type == 'MULTIPOLYGON' %}
{% set no_of_polygons = gis_data[a][type]['no_of_polygons'] ?? 1 %}
{% if no_of_polygons < 1 %}
{% set no_of_polygons = 1 %}
{% endif %}
{% if gis_data[a][type]['add_polygon'] is not null %}
{% set no_of_polygons = no_of_polygons + 1 %}
{% endif %}
<input type="hidden" name="gis_data[{{ a }}][{{ type }}][no_of_polygons]" value="{{ no_of_polygons }}">
{% for k in 0..no_of_polygons - 1 %}
<br>
{{ 'Polygon %d:'|trans|format(k + 1) }}
{% set no_of_lines = gis_data[a][type][k]['no_of_lines'] ?? 1 %}
{% if no_of_lines < 1 %}
{% set no_of_lines = 1 %}
{% endif %}
{% if gis_data[a][type][k]['add_line'] is not null %}
{% set no_of_lines = no_of_lines + 1 %}
{% endif %}
<input type="hidden" name="gis_data[{{ a }}][{{ type }}][{{ k }}][no_of_lines]" value="{{ no_of_lines }}">
{% for i in 0..no_of_lines - 1 %}
<br><br>
{% if i == 0 %}
{% trans 'Outer ring:' %}
{% else %}
{{ 'Inner ring %d:'|trans|format(i) }}
{% endif %}
{% set no_of_points = gis_data[a][type][k][i]['no_of_points'] ?? 4 %}
{% if no_of_points < 4 %}
{% set no_of_points = 4 %}
{% endif %}
{% if gis_data[a][type][k][i]['add_point'] is not null %}
{% set no_of_points = no_of_points + 1 %}
{% endif %}
<input type="hidden" name="gis_data[{{ a }}][{{ type }}][{{ k }}][{{ i }}][no_of_points]" value="{{ no_of_points }}">
{% for j in 0..no_of_points - 1 %}
<br>
{{ 'Point %d:'|trans|format(j + 1) }}
<label for="x">{% trans 'X' %}</label>
<input type="text" name="gis_data[{{ a }}][{{ type }}][{{ k }}][{{ i }}][{{ j }}][x]" value="{{ gis_data[a][type][k][i][j]['x'] }}">
<label for="y">{% trans 'Y' %}</label>
<input type="text" name="gis_data[{{ a }}][{{ type }}][{{ k }}][{{ i }}][{{ j }}][y]" value="{{ gis_data[a][type][k][i][j]['y'] }}">
{% endfor %}
<input type="submit" name="gis_data[{{ a }}][{{ type }}][{{ k }}][{{ i }}][add_point]" class="btn btn-secondary add addPoint" value="{% trans 'Add a point' %}">
{% endfor %}
<br>
<input type="submit" name="gis_data[{{ a }}][{{ type }}][{{ k }}][add_line]" class="btn btn-secondary add addLine" value="{% trans 'Add an inner ring' %}">
<br>
{% endfor %}
<br>
<input type="submit" name="gis_data[{{ a }}][{{ type }}][add_polygon]" class="btn btn-secondary add addPolygon" value="{% trans 'Add a polygon' %}">
{% endif %}
{% endif %}
{% endfor %}
{% if geom_type == 'GEOMETRYCOLLECTION' %}
<br><br>
<input type="submit" name="gis_data[GEOMETRYCOLLECTION][add_geom]" class="btn btn-secondary add addGeom" value="{% trans 'Add geometry' %}">
{% endif %}
</div>
{# End of data section #}
<br>
<input class="btn btn-primary" type="submit" name="gis_data[save]" value="{% trans 'Go' %}">
<div id="gis_data_output">
<h3>{% trans 'Output' %}</h3>
<p>
{% trans 'Choose "GeomFromText" from the "Function" column and paste the string below into the "Value" field.' %}
</p>
<textarea id="gis_data_textarea" cols="95" rows="5">{{ result }}</textarea>
</div>
</div>
</form>