From 04d6d5ca99ebfd1cebb8ce06618fb3811fc1a8aa Mon Sep 17 00:00:00 2001
From: Charles <sircharlesaze@gmail.com>
Date: Thu, 9 Jan 2020 10:55:03 +0100
Subject: phpmyadmin working

---
 .../phpmyadmin/templates/gis_data_editor_form.twig | 221 +++++++++++++++++++++
 1 file changed, 221 insertions(+)
 create mode 100644 srcs/phpmyadmin/templates/gis_data_editor_form.twig

(limited to 'srcs/phpmyadmin/templates/gis_data_editor_form.twig')

diff --git a/srcs/phpmyadmin/templates/gis_data_editor_form.twig b/srcs/phpmyadmin/templates/gis_data_editor_form.twig
new file mode 100644
index 0000000..412561a
--- /dev/null
+++ b/srcs/phpmyadmin/templates/gis_data_editor_form.twig
@@ -0,0 +1,221 @@
+<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>
-- 
cgit