diff options
| author | Charles Cabergs <me@cacharle.xyz> | 2020-07-27 10:05:23 +0200 |
|---|---|---|
| committer | Charles Cabergs <me@cacharle.xyz> | 2020-07-27 10:05:23 +0200 |
| commit | 5bf66662a9bdd62c5bccab15e607cd95cfb8fcab (patch) | |
| tree | 39a1a4629749056191c05dfd899f931701b7acf3 /srcs/phpmyadmin/libraries/classes/Gis | |
| parent | 5afd237bbd22028b85532b8c0b3fcead49a00764 (diff) | |
| download | ft_server-master.tar.gz ft_server-master.tar.bz2 ft_server-master.zip | |
Removed wordpress and phpmyadmin, my server doesn't handle it well and it brings shame on my famillyHEADmaster
Diffstat (limited to 'srcs/phpmyadmin/libraries/classes/Gis')
10 files changed, 0 insertions, 4425 deletions
diff --git a/srcs/phpmyadmin/libraries/classes/Gis/GisFactory.php b/srcs/phpmyadmin/libraries/classes/Gis/GisFactory.php deleted file mode 100644 index 353d7e6..0000000 --- a/srcs/phpmyadmin/libraries/classes/Gis/GisFactory.php +++ /dev/null @@ -1,50 +0,0 @@ -<?php -/* vim: set expandtab sw=4 ts=4 sts=4: */ -/** - * Contains the factory class that handles the creation of geometric objects - * - * @package PhpMyAdmin-GIS - */ -declare(strict_types=1); - -namespace PhpMyAdmin\Gis; - -/** - * Factory class that handles the creation of geometric objects. - * - * @package PhpMyAdmin-GIS - */ -class GisFactory -{ - /** - * Returns the singleton instance of geometric class of the given type. - * - * @param string $type type of the geometric object - * - * @return GisMultiPolygon|GisPolygon|GisMultiPoint|GisPoint|GisMultiLineString|GisLineString|GisGeometryCollection|false the singleton instance of geometric class of the given type - * - * @access public - * @static - */ - public static function factory($type) - { - switch (strtoupper($type)) { - case 'MULTIPOLYGON': - return GisMultiPolygon::singleton(); - case 'POLYGON': - return GisPolygon::singleton(); - case 'MULTIPOINT': - return GisMultiPoint::singleton(); - case 'POINT': - return GisPoint::singleton(); - case 'MULTILINESTRING': - return GisMultiLineString::singleton(); - case 'LINESTRING': - return GisLineString::singleton(); - case 'GEOMETRYCOLLECTION': - return GisGeometryCollection::singleton(); - default: - return false; - } - } -} diff --git a/srcs/phpmyadmin/libraries/classes/Gis/GisGeometry.php b/srcs/phpmyadmin/libraries/classes/Gis/GisGeometry.php deleted file mode 100644 index a1ce83e..0000000 --- a/srcs/phpmyadmin/libraries/classes/Gis/GisGeometry.php +++ /dev/null @@ -1,407 +0,0 @@ -<?php -/* vim: set expandtab sw=4 ts=4 sts=4: */ -/** - * Base class for all GIS data type classes - * - * @package PhpMyAdmin-GIS - */ -declare(strict_types=1); - -namespace PhpMyAdmin\Gis; - -use TCPDF; - -/** - * Base class for all GIS data type classes. - * - * @package PhpMyAdmin-GIS - */ -abstract class GisGeometry -{ - /** - * Prepares and returns the code related to a row in the GIS dataset as SVG. - * - * @param string $spatial GIS data object - * @param string $label label for the GIS data object - * @param string $color color for the GIS data object - * @param array $scale_data data related to scaling - * - * @return string the code related to a row in the GIS dataset - * @access public - */ - abstract public function prepareRowAsSvg($spatial, $label, $color, array $scale_data); - - /** - * Adds to the PNG image object, the data related to a row in the GIS dataset. - * - * @param string $spatial GIS POLYGON object - * @param string|null $label Label for the GIS POLYGON object - * @param string $color Color for the GIS POLYGON object - * @param array $scale_data Array containing data related to scaling - * @param resource $image Image object - * - * @return resource the modified image object - * @access public - */ - abstract public function prepareRowAsPng( - $spatial, - ?string $label, - $color, - array $scale_data, - $image - ); - - /** - * Adds to the TCPDF instance, the data related to a row in the GIS dataset. - * - * @param string $spatial GIS data object - * @param string|null $label label for the GIS data object - * @param string $color color for the GIS data object - * @param array $scale_data array containing data related to scaling - * @param TCPDF $pdf TCPDF instance - * - * @return TCPDF the modified TCPDF instance - * @access public - */ - abstract public function prepareRowAsPdf( - $spatial, - ?string $label, - $color, - array $scale_data, - $pdf - ); - - /** - * Prepares the JavaScript related to a row in the GIS dataset - * to visualize it with OpenLayers. - * - * @param string $spatial GIS data object - * @param int $srid spatial reference ID - * @param string $label label for the GIS data object - * @param string $color color for the GIS data object - * @param array $scale_data array containing data related to scaling - * - * @return string the JavaScript related to a row in the GIS dataset - * @access public - */ - abstract public function prepareRowAsOl( - $spatial, - $srid, - $label, - $color, - array $scale_data - ); - - /** - * Scales each row. - * - * @param string $spatial spatial data of a row - * - * @return array array containing the min, max values for x and y coordinates - * @access public - */ - abstract public function scaleRow($spatial); - - /** - * Generates the WKT with the set of parameters passed by the GIS editor. - * - * @param array $gis_data GIS data - * @param int $index index into the parameter object - * @param string $empty value for empty points - * - * @return string WKT with the set of parameters passed by the GIS editor - * @access public - */ - abstract public function generateWkt(array $gis_data, $index, $empty = ''); - - /** - * Returns OpenLayers.Bounds object that correspond to the bounds of GIS data. - * - * @param string $srid spatial reference ID - * @param array $scale_data data related to scaling - * - * @return string OpenLayers.Bounds object that - * correspond to the bounds of GIS data - * @access protected - */ - protected function getBoundsForOl($srid, array $scale_data) - { - return 'bound = new OpenLayers.Bounds(); ' - . 'bound.extend(new OpenLayers.LonLat(' - . $scale_data['minX'] . ', ' . $scale_data['minY'] - . ').transform(new OpenLayers.Projection("EPSG:' - . intval($srid) . '"), map.getProjectionObject())); ' - . 'bound.extend(new OpenLayers.LonLat(' - . $scale_data['maxX'] . ', ' . $scale_data['maxY'] - . ').transform(new OpenLayers.Projection("EPSG:' - . intval($srid) . '"), map.getProjectionObject()));'; - } - - /** - * Updates the min, max values with the given point set. - * - * @param string $point_set point set - * @param array $min_max existing min, max values - * - * @return array the updated min, max values - * @access protected - */ - protected function setMinMax($point_set, array $min_max) - { - // Separate each point - $points = explode(",", $point_set); - - foreach ($points as $point) { - // Extract coordinates of the point - $cordinates = explode(" ", $point); - - $x = (float) $cordinates[0]; - if (! isset($min_max['maxX']) || $x > $min_max['maxX']) { - $min_max['maxX'] = $x; - } - if (! isset($min_max['minX']) || $x < $min_max['minX']) { - $min_max['minX'] = $x; - } - $y = (float) $cordinates[1]; - if (! isset($min_max['maxY']) || $y > $min_max['maxY']) { - $min_max['maxY'] = $y; - } - if (! isset($min_max['minY']) || $y < $min_max['minY']) { - $min_max['minY'] = $y; - } - } - - return $min_max; - } - - /** - * Generates parameters for the GIS data editor from the value of the GIS column. - * This method performs common work. - * More specific work is performed by each of the geom classes. - * - * @param string $value value of the GIS column - * - * @return array parameters for the GIS editor from the value of the GIS column - * @access protected - */ - protected function generateParams($value) - { - $geom_types = '(POINT|MULTIPOINT|LINESTRING|MULTILINESTRING' - . '|POLYGON|MULTIPOLYGON|GEOMETRYCOLLECTION)'; - $srid = 0; - $wkt = ''; - - if (preg_match("/^'" . $geom_types . "\(.*\)',[0-9]*$/i", $value)) { - $last_comma = mb_strripos($value, ","); - $srid = trim(mb_substr($value, $last_comma + 1)); - $wkt = trim(mb_substr($value, 1, $last_comma - 2)); - } elseif (preg_match("/^" . $geom_types . "\(.*\)$/i", $value)) { - $wkt = $value; - } - - return [ - 'srid' => $srid, - 'wkt' => $wkt, - ]; - } - - /** - * Extracts points, scales and returns them as an array. - * - * @param string $point_set string of comma separated points - * @param array|null $scale_data data related to scaling - * @param boolean $linear if true, as a 1D array, else as a 2D array - * - * @return array scaled points - * @access protected - */ - protected function extractPoints($point_set, $scale_data, $linear = false) - { - $points_arr = []; - - // Separate each point - $points = explode(",", $point_set); - - foreach ($points as $point) { - $point = str_replace(['(', ')'], '', $point); - // Extract coordinates of the point - $cordinates = explode(" ", $point); - - if (isset($cordinates[0]) && trim($cordinates[0]) != '' - && isset($cordinates[1]) - && trim($cordinates[1]) != '' - ) { - if ($scale_data != null) { - $x = ($cordinates[0] - $scale_data['x']) * $scale_data['scale']; - $y = $scale_data['height'] - - ($cordinates[1] - $scale_data['y']) * $scale_data['scale']; - } else { - $x = floatval(trim($cordinates[0])); - $y = floatval(trim($cordinates[1])); - } - } else { - $x = 0; - $y = 0; - } - - if (! $linear) { - $points_arr[] = [ - $x, - $y, - ]; - } else { - $points_arr[] = $x; - $points_arr[] = $y; - } - } - - return $points_arr; - } - - /** - * Generates JavaScript for adding an array of polygons to OpenLayers. - * - * @param array $polygons x and y coordinates for each polygon - * @param string $srid spatial reference id - * - * @return string JavaScript for adding an array of polygons to OpenLayers - * @access protected - */ - protected function getPolygonArrayForOpenLayers(array $polygons, $srid) - { - $ol_array = 'new Array('; - foreach ($polygons as $polygon) { - $rings = explode("),(", $polygon); - $ol_array .= $this->getPolygonForOpenLayers($rings, $srid) . ', '; - } - - $ol_array - = mb_substr( - $ol_array, - 0, - mb_strlen($ol_array) - 2 - ); - $ol_array .= ')'; - - return $ol_array; - } - - /** - * Generates JavaScript for adding points for OpenLayers polygon. - * - * @param array $polygon x and y coordinates for each line - * @param string $srid spatial reference id - * - * @return string JavaScript for adding points for OpenLayers polygon - * @access protected - */ - protected function getPolygonForOpenLayers(array $polygon, $srid) - { - return 'new OpenLayers.Geometry.Polygon(' - . $this->getLineArrayForOpenLayers($polygon, $srid, false) - . ')'; - } - - /** - * Generates JavaScript for adding an array of LineString - * or LineRing to OpenLayers. - * - * @param array $lines x and y coordinates for each line - * @param string $srid spatial reference id - * @param bool $is_line_string whether it's an array of LineString - * - * @return string JavaScript for adding an array of LineString - * or LineRing to OpenLayers - * @access protected - */ - protected function getLineArrayForOpenLayers( - array $lines, - $srid, - $is_line_string = true - ) { - $ol_array = 'new Array('; - foreach ($lines as $line) { - $points_arr = $this->extractPoints($line, null); - $ol_array .= $this->getLineForOpenLayers( - $points_arr, - $srid, - $is_line_string - ); - $ol_array .= ', '; - } - - $ol_array - = mb_substr( - $ol_array, - 0, - mb_strlen($ol_array) - 2 - ); - $ol_array .= ')'; - - return $ol_array; - } - - /** - * Generates JavaScript for adding a LineString or LineRing to OpenLayers. - * - * @param array $points_arr x and y coordinates for each point - * @param string $srid spatial reference id - * @param bool $is_line_string whether it's a LineString - * - * @return string JavaScript for adding a LineString or LineRing to OpenLayers - * @access protected - */ - protected function getLineForOpenLayers( - array $points_arr, - $srid, - $is_line_string = true - ) { - return 'new OpenLayers.Geometry.' - . ($is_line_string ? 'LineString' : 'LinearRing') . '(' - . $this->getPointsArrayForOpenLayers($points_arr, $srid) - . ')'; - } - - /** - * Generates JavaScript for adding an array of points to OpenLayers. - * - * @param array $points_arr x and y coordinates for each point - * @param string $srid spatial reference id - * - * @return string JavaScript for adding an array of points to OpenLayers - * @access protected - */ - protected function getPointsArrayForOpenLayers(array $points_arr, $srid) - { - $ol_array = 'new Array('; - foreach ($points_arr as $point) { - $ol_array .= $this->getPointForOpenLayers($point, $srid) . ', '; - } - - $ol_array - = mb_substr( - $ol_array, - 0, - mb_strlen($ol_array) - 2 - ); - $ol_array .= ')'; - - return $ol_array; - } - - /** - * Generates JavaScript for adding a point to OpenLayers. - * - * @param array $point array containing the x and y coordinates of the point - * @param string $srid spatial reference id - * - * @return string JavaScript for adding points to OpenLayers - * @access protected - */ - protected function getPointForOpenLayers(array $point, $srid) - { - return '(new OpenLayers.Geometry.Point(' . $point[0] . ',' . $point[1] . '))' - . '.transform(new OpenLayers.Projection("EPSG:' - . intval($srid) . '"), map.getProjectionObject())'; - } -} diff --git a/srcs/phpmyadmin/libraries/classes/Gis/GisGeometryCollection.php b/srcs/phpmyadmin/libraries/classes/Gis/GisGeometryCollection.php deleted file mode 100644 index dfd0cb9..0000000 --- a/srcs/phpmyadmin/libraries/classes/Gis/GisGeometryCollection.php +++ /dev/null @@ -1,419 +0,0 @@ -<?php -/* vim: set expandtab sw=4 ts=4 sts=4: */ -/** - * Handles actions related to GIS GEOMETRYCOLLECTION objects - * - * @package PhpMyAdmin-GIS - */ -declare(strict_types=1); - -namespace PhpMyAdmin\Gis; - -use TCPDF; - -/** - * Handles actions related to GIS GEOMETRYCOLLECTION objects - * - * @package PhpMyAdmin-GIS - */ -class GisGeometryCollection extends GisGeometry -{ - // Hold the singleton instance of the class - private static $_instance; - - /** - * A private constructor; prevents direct creation of object. - * - * @access private - */ - private function __construct() - { - } - - /** - * Returns the singleton. - * - * @return GisGeometryCollection the singleton - * @access public - */ - public static function singleton() - { - if (! isset(self::$_instance)) { - self::$_instance = new GisGeometryCollection(); - } - - return self::$_instance; - } - - /** - * Scales each row. - * - * @param string $spatial spatial data of a row - * - * @return array array containing the min, max values for x and y coordinates - * @access public - */ - public function scaleRow($spatial) - { - $min_max = []; - - // Trim to remove leading 'GEOMETRYCOLLECTION(' and trailing ')' - $goem_col - = mb_substr( - $spatial, - 19, - mb_strlen($spatial) - 20 - ); - - // Split the geometry collection object to get its constituents. - $sub_parts = $this->_explodeGeomCol($goem_col); - - foreach ($sub_parts as $sub_part) { - $type_pos = mb_strpos($sub_part, '('); - if ($type_pos === false) { - continue; - } - $type = mb_substr($sub_part, 0, $type_pos); - - $gis_obj = GisFactory::factory($type); - if (! $gis_obj) { - continue; - } - $scale_data = $gis_obj->scaleRow($sub_part); - - // Update minimum/maximum values for x and y coordinates. - $c_maxX = (float) $scale_data['maxX']; - if (! isset($min_max['maxX']) || $c_maxX > $min_max['maxX']) { - $min_max['maxX'] = $c_maxX; - } - - $c_minX = (float) $scale_data['minX']; - if (! isset($min_max['minX']) || $c_minX < $min_max['minX']) { - $min_max['minX'] = $c_minX; - } - - $c_maxY = (float) $scale_data['maxY']; - if (! isset($min_max['maxY']) || $c_maxY > $min_max['maxY']) { - $min_max['maxY'] = $c_maxY; - } - - $c_minY = (float) $scale_data['minY']; - if (! isset($min_max['minY']) || $c_minY < $min_max['minY']) { - $min_max['minY'] = $c_minY; - } - } - - return $min_max; - } - - /** - * Adds to the PNG image object, the data related to a row in the GIS dataset. - * - * @param string $spatial GIS POLYGON object - * @param string|null $label Label for the GIS POLYGON object - * @param string $color Color for the GIS POLYGON object - * @param array $scale_data Array containing data related to scaling - * @param resource $image Image object - * - * @return resource the modified image object - * @access public - */ - public function prepareRowAsPng($spatial, ?string $label, $color, array $scale_data, $image) - { - // Trim to remove leading 'GEOMETRYCOLLECTION(' and trailing ')' - $goem_col - = mb_substr( - $spatial, - 19, - mb_strlen($spatial) - 20 - ); - // Split the geometry collection object to get its constituents. - $sub_parts = $this->_explodeGeomCol($goem_col); - - foreach ($sub_parts as $sub_part) { - $type_pos = mb_strpos($sub_part, '('); - if ($type_pos === false) { - continue; - } - $type = mb_substr($sub_part, 0, $type_pos); - - $gis_obj = GisFactory::factory($type); - if (! $gis_obj) { - continue; - } - $image = $gis_obj->prepareRowAsPng( - $sub_part, - $label, - $color, - $scale_data, - $image - ); - } - - return $image; - } - - /** - * Adds to the TCPDF instance, the data related to a row in the GIS dataset. - * - * @param string $spatial GIS GEOMETRYCOLLECTION object - * @param string|null $label label for the GIS GEOMETRYCOLLECTION object - * @param string $color color for the GIS GEOMETRYCOLLECTION object - * @param array $scale_data array containing data related to scaling - * @param TCPDF $pdf TCPDF instance - * - * @return TCPDF the modified TCPDF instance - * @access public - */ - public function prepareRowAsPdf($spatial, ?string $label, $color, array $scale_data, $pdf) - { - // Trim to remove leading 'GEOMETRYCOLLECTION(' and trailing ')' - $goem_col - = mb_substr( - $spatial, - 19, - mb_strlen($spatial) - 20 - ); - // Split the geometry collection object to get its constituents. - $sub_parts = $this->_explodeGeomCol($goem_col); - - foreach ($sub_parts as $sub_part) { - $type_pos = mb_strpos($sub_part, '('); - if ($type_pos === false) { - continue; - } - $type = mb_substr($sub_part, 0, $type_pos); - - $gis_obj = GisFactory::factory($type); - if (! $gis_obj) { - continue; - } - $pdf = $gis_obj->prepareRowAsPdf( - $sub_part, - $label, - $color, - $scale_data, - $pdf - ); - } - - return $pdf; - } - - /** - * Prepares and returns the code related to a row in the GIS dataset as SVG. - * - * @param string $spatial GIS GEOMETRYCOLLECTION object - * @param string $label label for the GIS GEOMETRYCOLLECTION object - * @param string $color color for the GIS GEOMETRYCOLLECTION object - * @param array $scale_data array containing data related to scaling - * - * @return string the code related to a row in the GIS dataset - * @access public - */ - public function prepareRowAsSvg($spatial, $label, $color, array $scale_data) - { - $row = ''; - - // Trim to remove leading 'GEOMETRYCOLLECTION(' and trailing ')' - $goem_col - = mb_substr( - $spatial, - 19, - mb_strlen($spatial) - 20 - ); - // Split the geometry collection object to get its constituents. - $sub_parts = $this->_explodeGeomCol($goem_col); - - foreach ($sub_parts as $sub_part) { - $type_pos = mb_strpos($sub_part, '('); - if ($type_pos === false) { - continue; - } - $type = mb_substr($sub_part, 0, $type_pos); - - $gis_obj = GisFactory::factory($type); - if (! $gis_obj) { - continue; - } - $row .= $gis_obj->prepareRowAsSvg( - $sub_part, - $label, - $color, - $scale_data - ); - } - - return $row; - } - - /** - * Prepares JavaScript related to a row in the GIS dataset - * to visualize it with OpenLayers. - * - * @param string $spatial GIS GEOMETRYCOLLECTION object - * @param int $srid spatial reference ID - * @param string $label label for the GIS GEOMETRYCOLLECTION object - * @param string $color color for the GIS GEOMETRYCOLLECTION object - * @param array $scale_data array containing data related to scaling - * - * @return string JavaScript related to a row in the GIS dataset - * @access public - */ - public function prepareRowAsOl($spatial, $srid, $label, $color, array $scale_data) - { - $row = ''; - - // Trim to remove leading 'GEOMETRYCOLLECTION(' and trailing ')' - $goem_col - = mb_substr( - $spatial, - 19, - mb_strlen($spatial) - 20 - ); - // Split the geometry collection object to get its constituents. - $sub_parts = $this->_explodeGeomCol($goem_col); - - foreach ($sub_parts as $sub_part) { - $type_pos = mb_strpos($sub_part, '('); - if ($type_pos === false) { - continue; - } - $type = mb_substr($sub_part, 0, $type_pos); - - $gis_obj = GisFactory::factory($type); - if (! $gis_obj) { - continue; - } - $row .= $gis_obj->prepareRowAsOl( - $sub_part, - $srid, - $label, - $color, - $scale_data - ); - } - - return $row; - } - - /** - * Splits the GEOMETRYCOLLECTION object and get its constituents. - * - * @param string $geom_col geometry collection string - * - * @return array the constituents of the geometry collection object - * @access private - */ - private function _explodeGeomCol($geom_col) - { - $sub_parts = []; - $br_count = 0; - $start = 0; - $count = 0; - foreach (str_split($geom_col) as $char) { - if ($char == '(') { - $br_count++; - } elseif ($char == ')') { - $br_count--; - if ($br_count == 0) { - $sub_parts[] - = mb_substr( - $geom_col, - $start, - $count + 1 - $start - ); - $start = $count + 2; - } - } - $count++; - } - - return $sub_parts; - } - - /** - * Generates the WKT with the set of parameters passed by the GIS editor. - * - * @param array $gis_data GIS data - * @param int $index index into the parameter object - * @param string $empty value for empty points - * - * @return string WKT with the set of parameters passed by the GIS editor - * @access public - */ - public function generateWkt(array $gis_data, $index, $empty = '') - { - $geom_count = isset($gis_data['GEOMETRYCOLLECTION']['geom_count']) - ? $gis_data['GEOMETRYCOLLECTION']['geom_count'] : 1; - $wkt = 'GEOMETRYCOLLECTION('; - for ($i = 0; $i < $geom_count; $i++) { - if (isset($gis_data[$i]['gis_type'])) { - $type = $gis_data[$i]['gis_type']; - $gis_obj = GisFactory::factory($type); - if (! $gis_obj) { - continue; - } - $wkt .= $gis_obj->generateWkt($gis_data, $i, $empty) . ','; - } - } - if (isset($gis_data[0]['gis_type'])) { - $wkt - = mb_substr( - $wkt, - 0, - mb_strlen($wkt) - 1 - ); - } - $wkt .= ')'; - - return $wkt; - } - - /** - * Generates parameters for the GIS data editor from the value of the GIS column. - * - * @param string $value of the GIS column - * - * @return array parameters for the GIS editor from the value of the GIS column - * @access public - */ - public function generateParams($value) - { - $params = []; - $data = GisGeometry::generateParams($value); - $params['srid'] = $data['srid']; - $wkt = $data['wkt']; - - // Trim to remove leading 'GEOMETRYCOLLECTION(' and trailing ')' - $goem_col - = mb_substr( - $wkt, - 19, - mb_strlen($wkt) - 20 - ); - // Split the geometry collection object to get its constituents. - $sub_parts = $this->_explodeGeomCol($goem_col); - $params['GEOMETRYCOLLECTION']['geom_count'] = count($sub_parts); - - $i = 0; - foreach ($sub_parts as $sub_part) { - $type_pos = mb_strpos($sub_part, '('); - if ($type_pos === false) { - continue; - } - $type = mb_substr($sub_part, 0, $type_pos); - /** - * @var GisMultiPolygon|GisPolygon|GisMultiPoint|GisPoint|GisMultiLineString|GisLineString $gis_obj - */ - $gis_obj = GisFactory::factory($type); - if (! $gis_obj) { - continue; - } - $params = array_merge($params, $gis_obj->generateParams($sub_part, $i)); - $i++; - } - - return $params; - } -} diff --git a/srcs/phpmyadmin/libraries/classes/Gis/GisLineString.php b/srcs/phpmyadmin/libraries/classes/Gis/GisLineString.php deleted file mode 100644 index f309605..0000000 --- a/srcs/phpmyadmin/libraries/classes/Gis/GisLineString.php +++ /dev/null @@ -1,360 +0,0 @@ -<?php -/* vim: set expandtab sw=4 ts=4 sts=4: */ -/** - * Handles actions related to GIS LINESTRING objects - * - * @package PhpMyAdmin-GIS - */ -declare(strict_types=1); - -namespace PhpMyAdmin\Gis; - -use TCPDF; - -/** - * Handles actions related to GIS LINESTRING objects - * - * @package PhpMyAdmin-GIS - */ -class GisLineString extends GisGeometry -{ - // Hold the singleton instance of the class - private static $_instance; - - /** - * A private constructor; prevents direct creation of object. - * - * @access private - */ - private function __construct() - { - } - - /** - * Returns the singleton. - * - * @return GisLineString the singleton - * @access public - */ - public static function singleton() - { - if (! isset(self::$_instance)) { - self::$_instance = new GisLineString(); - } - - return self::$_instance; - } - - /** - * Scales each row. - * - * @param string $spatial spatial data of a row - * - * @return array an array containing the min, max values for x and y coordinates - * @access public - */ - public function scaleRow($spatial) - { - // Trim to remove leading 'LINESTRING(' and trailing ')' - $linestring - = mb_substr( - $spatial, - 11, - mb_strlen($spatial) - 12 - ); - - return $this->setMinMax($linestring, []); - } - - /** - * Adds to the PNG image object, the data related to a row in the GIS dataset. - * - * @param string $spatial GIS POLYGON object - * @param string|null $label Label for the GIS POLYGON object - * @param string $line_color Color for the GIS POLYGON object - * @param array $scale_data Array containing data related to scaling - * @param resource $image Image object - * - * @return resource the modified image object - * @access public - */ - public function prepareRowAsPng( - $spatial, - ?string $label, - $line_color, - array $scale_data, - $image - ) { - // allocate colors - $black = imagecolorallocate($image, 0, 0, 0); - $red = hexdec(mb_substr($line_color, 1, 2)); - $green = hexdec(mb_substr($line_color, 3, 2)); - $blue = hexdec(mb_substr($line_color, 4, 2)); - $color = imagecolorallocate($image, $red, $green, $blue); - - // Trim to remove leading 'LINESTRING(' and trailing ')' - $linesrting - = mb_substr( - $spatial, - 11, - mb_strlen($spatial) - 12 - ); - $points_arr = $this->extractPoints($linesrting, $scale_data); - - foreach ($points_arr as $point) { - if (! isset($temp_point)) { - $temp_point = $point; - } else { - // draw line section - imageline( - $image, - $temp_point[0], - $temp_point[1], - $point[0], - $point[1], - $color - ); - $temp_point = $point; - } - } - // print label if applicable - if (isset($label) && trim($label) != '') { - imagestring( - $image, - 1, - $points_arr[1][0], - $points_arr[1][1], - trim($label), - $black - ); - } - - return $image; - } - - /** - * Adds to the TCPDF instance, the data related to a row in the GIS dataset. - * - * @param string $spatial GIS LINESTRING object - * @param string|null $label Label for the GIS LINESTRING object - * @param string $line_color Color for the GIS LINESTRING object - * @param array $scale_data Array containing data related to scaling - * @param TCPDF $pdf TCPDF instance - * - * @return TCPDF the modified TCPDF instance - * @access public - */ - public function prepareRowAsPdf($spatial, ?string $label, $line_color, array $scale_data, $pdf) - { - // allocate colors - $red = hexdec(mb_substr($line_color, 1, 2)); - $green = hexdec(mb_substr($line_color, 3, 2)); - $blue = hexdec(mb_substr($line_color, 4, 2)); - $line = [ - 'width' => 1.5, - 'color' => [ - $red, - $green, - $blue, - ], - ]; - - // Trim to remove leading 'LINESTRING(' and trailing ')' - $linesrting - = mb_substr( - $spatial, - 11, - mb_strlen($spatial) - 12 - ); - $points_arr = $this->extractPoints($linesrting, $scale_data); - - foreach ($points_arr as $point) { - if (! isset($temp_point)) { - $temp_point = $point; - } else { - // draw line section - $pdf->Line( - $temp_point[0], - $temp_point[1], - $point[0], - $point[1], - $line - ); - $temp_point = $point; - } - } - // print label - if (isset($label) && trim($label) != '') { - $pdf->SetXY($points_arr[1][0], $points_arr[1][1]); - $pdf->SetFontSize(5); - $pdf->Cell(0, 0, trim($label)); - } - - return $pdf; - } - - /** - * Prepares and returns the code related to a row in the GIS dataset as SVG. - * - * @param string $spatial GIS LINESTRING object - * @param string $label Label for the GIS LINESTRING object - * @param string $line_color Color for the GIS LINESTRING object - * @param array $scale_data Array containing data related to scaling - * - * @return string the code related to a row in the GIS dataset - * @access public - */ - public function prepareRowAsSvg($spatial, $label, $line_color, array $scale_data) - { - $line_options = [ - 'name' => $label, - 'id' => $label . mt_rand(), - 'class' => 'linestring vector', - 'fill' => 'none', - 'stroke' => $line_color, - 'stroke-width' => 2, - ]; - - // Trim to remove leading 'LINESTRING(' and trailing ')' - $linesrting - = mb_substr( - $spatial, - 11, - mb_strlen($spatial) - 12 - ); - $points_arr = $this->extractPoints($linesrting, $scale_data); - - $row = '<polyline points="'; - foreach ($points_arr as $point) { - $row .= $point[0] . ',' . $point[1] . ' '; - } - $row .= '"'; - foreach ($line_options as $option => $val) { - $row .= ' ' . $option . '="' . trim((string) $val) . '"'; - } - $row .= '/>'; - - return $row; - } - - /** - * Prepares JavaScript related to a row in the GIS dataset - * to visualize it with OpenLayers. - * - * @param string $spatial GIS LINESTRING object - * @param int $srid Spatial reference ID - * @param string $label Label for the GIS LINESTRING object - * @param string $line_color Color for the GIS LINESTRING object - * @param array $scale_data Array containing data related to scaling - * - * @return string JavaScript related to a row in the GIS dataset - * @access public - */ - public function prepareRowAsOl($spatial, $srid, $label, $line_color, array $scale_data) - { - $style_options = [ - 'strokeColor' => $line_color, - 'strokeWidth' => 2, - 'label' => $label, - 'fontSize' => 10, - ]; - if ($srid == 0) { - $srid = 4326; - } - $result = $this->getBoundsForOl($srid, $scale_data); - - // Trim to remove leading 'LINESTRING(' and trailing ')' - $linesrting - = mb_substr( - $spatial, - 11, - mb_strlen($spatial) - 12 - ); - $points_arr = $this->extractPoints($linesrting, null); - - $result .= 'vectorLayer.addFeatures(new OpenLayers.Feature.Vector(' - . $this->getLineForOpenLayers($points_arr, $srid) - . ', null, ' . json_encode($style_options) . '));'; - - return $result; - } - - /** - * Generate the WKT with the set of parameters passed by the GIS editor. - * - * @param array $gis_data GIS data - * @param int $index Index into the parameter object - * @param string $empty Value for empty points - * - * @return string WKT with the set of parameters passed by the GIS editor - * @access public - */ - public function generateWkt(array $gis_data, $index, $empty = '') - { - $no_of_points = isset($gis_data[$index]['LINESTRING']['no_of_points']) - ? $gis_data[$index]['LINESTRING']['no_of_points'] : 2; - if ($no_of_points < 2) { - $no_of_points = 2; - } - $wkt = 'LINESTRING('; - for ($i = 0; $i < $no_of_points; $i++) { - $wkt .= ((isset($gis_data[$index]['LINESTRING'][$i]['x']) - && trim((string) $gis_data[$index]['LINESTRING'][$i]['x']) != '') - ? $gis_data[$index]['LINESTRING'][$i]['x'] : $empty) - . ' ' . ((isset($gis_data[$index]['LINESTRING'][$i]['y']) - && trim((string) $gis_data[$index]['LINESTRING'][$i]['y']) != '') - ? $gis_data[$index]['LINESTRING'][$i]['y'] : $empty) . ','; - } - - $wkt - = mb_substr( - $wkt, - 0, - mb_strlen($wkt) - 1 - ); - $wkt .= ')'; - - return $wkt; - } - - /** - * Generate parameters for the GIS data editor from the value of the GIS column. - * - * @param string $value of the GIS column - * @param int $index of the geometry - * - * @return array params for the GIS data editor from the value of the GIS column - * @access public - */ - public function generateParams($value, $index = -1) - { - $params = []; - if ($index == -1) { - $index = 0; - $data = GisGeometry::generateParams($value); - $params['srid'] = $data['srid']; - $wkt = $data['wkt']; - } else { - $params[$index]['gis_type'] = 'LINESTRING'; - $wkt = $value; - } - - // Trim to remove leading 'LINESTRING(' and trailing ')' - $linestring - = mb_substr( - $wkt, - 11, - mb_strlen($wkt) - 12 - ); - $points_arr = $this->extractPoints($linestring, null); - - $no_of_points = count($points_arr); - $params[$index]['LINESTRING']['no_of_points'] = $no_of_points; - for ($i = 0; $i < $no_of_points; $i++) { - $params[$index]['LINESTRING'][$i]['x'] = $points_arr[$i][0]; - $params[$index]['LINESTRING'][$i]['y'] = $points_arr[$i][1]; - } - - return $params; - } -} diff --git a/srcs/phpmyadmin/libraries/classes/Gis/GisMultiLineString.php b/srcs/phpmyadmin/libraries/classes/Gis/GisMultiLineString.php deleted file mode 100644 index b4524f3..0000000 --- a/srcs/phpmyadmin/libraries/classes/Gis/GisMultiLineString.php +++ /dev/null @@ -1,449 +0,0 @@ -<?php -/* vim: set expandtab sw=4 ts=4 sts=4: */ -/** - * Handles actions related to GIS MULTILINESTRING objects - * - * @package PhpMyAdmin-GIS - */ -declare(strict_types=1); - -namespace PhpMyAdmin\Gis; - -use TCPDF; - -/** - * Handles actions related to GIS MULTILINESTRING objects - * - * @package PhpMyAdmin-GIS - */ -class GisMultiLineString extends GisGeometry -{ - // Hold the singleton instance of the class - private static $_instance; - - /** - * A private constructor; prevents direct creation of object. - * - * @access private - */ - private function __construct() - { - } - - /** - * Returns the singleton. - * - * @return GisMultiLineString the singleton - * @access public - */ - public static function singleton() - { - if (! isset(self::$_instance)) { - self::$_instance = new GisMultiLineString(); - } - - return self::$_instance; - } - - /** - * Scales each row. - * - * @param string $spatial spatial data of a row - * - * @return array an array containing the min, max values for x and y coordinates - * @access public - */ - public function scaleRow($spatial) - { - $min_max = []; - - // Trim to remove leading 'MULTILINESTRING((' and trailing '))' - $multilinestirng - = mb_substr( - $spatial, - 17, - mb_strlen($spatial) - 19 - ); - // Separate each linestring - $linestirngs = explode("),(", $multilinestirng); - - foreach ($linestirngs as $linestring) { - $min_max = $this->setMinMax($linestring, $min_max); - } - - return $min_max; - } - - /** - * Adds to the PNG image object, the data related to a row in the GIS dataset. - * - * @param string $spatial GIS POLYGON object - * @param string|null $label Label for the GIS POLYGON object - * @param string $line_color Color for the GIS POLYGON object - * @param array $scale_data Array containing data related to scaling - * @param resource $image Image object - * - * @return resource the modified image object - * @access public - */ - public function prepareRowAsPng( - $spatial, - ?string $label, - $line_color, - array $scale_data, - $image - ) { - // allocate colors - $black = imagecolorallocate($image, 0, 0, 0); - $red = hexdec(mb_substr($line_color, 1, 2)); - $green = hexdec(mb_substr($line_color, 3, 2)); - $blue = hexdec(mb_substr($line_color, 4, 2)); - $color = imagecolorallocate($image, $red, $green, $blue); - - // Trim to remove leading 'MULTILINESTRING((' and trailing '))' - $multilinestirng - = mb_substr( - $spatial, - 17, - mb_strlen($spatial) - 19 - ); - // Separate each linestring - $linestirngs = explode("),(", $multilinestirng); - - $first_line = true; - foreach ($linestirngs as $linestring) { - $points_arr = $this->extractPoints($linestring, $scale_data); - foreach ($points_arr as $point) { - if (! isset($temp_point)) { - $temp_point = $point; - } else { - // draw line section - imageline( - $image, - $temp_point[0], - $temp_point[1], - $point[0], - $point[1], - $color - ); - $temp_point = $point; - } - } - unset($temp_point); - // print label if applicable - if (isset($label) && trim($label) != '' && $first_line) { - imagestring( - $image, - 1, - $points_arr[1][0], - $points_arr[1][1], - trim($label), - $black - ); - } - $first_line = false; - } - - return $image; - } - - /** - * Adds to the TCPDF instance, the data related to a row in the GIS dataset. - * - * @param string $spatial GIS MULTILINESTRING object - * @param string|null $label Label for the GIS MULTILINESTRING object - * @param string $line_color Color for the GIS MULTILINESTRING object - * @param array $scale_data Array containing data related to scaling - * @param TCPDF $pdf TCPDF instance - * - * @return TCPDF the modified TCPDF instance - * @access public - */ - public function prepareRowAsPdf($spatial, ?string $label, $line_color, array $scale_data, $pdf) - { - // allocate colors - $red = hexdec(mb_substr($line_color, 1, 2)); - $green = hexdec(mb_substr($line_color, 3, 2)); - $blue = hexdec(mb_substr($line_color, 4, 2)); - $line = [ - 'width' => 1.5, - 'color' => [ - $red, - $green, - $blue, - ], - ]; - - // Trim to remove leading 'MULTILINESTRING((' and trailing '))' - $multilinestirng - = mb_substr( - $spatial, - 17, - mb_strlen($spatial) - 19 - ); - // Separate each linestring - $linestirngs = explode("),(", $multilinestirng); - - $first_line = true; - foreach ($linestirngs as $linestring) { - $points_arr = $this->extractPoints($linestring, $scale_data); - foreach ($points_arr as $point) { - if (! isset($temp_point)) { - $temp_point = $point; - } else { - // draw line section - $pdf->Line( - $temp_point[0], - $temp_point[1], - $point[0], - $point[1], - $line - ); - $temp_point = $point; - } - } - unset($temp_point); - // print label - if (isset($label) && trim($label) != '' && $first_line) { - $pdf->SetXY($points_arr[1][0], $points_arr[1][1]); - $pdf->SetFontSize(5); - $pdf->Cell(0, 0, trim($label)); - } - $first_line = false; - } - - return $pdf; - } - - /** - * Prepares and returns the code related to a row in the GIS dataset as SVG. - * - * @param string $spatial GIS MULTILINESTRING object - * @param string $label Label for the GIS MULTILINESTRING object - * @param string $line_color Color for the GIS MULTILINESTRING object - * @param array $scale_data Array containing data related to scaling - * - * @return string the code related to a row in the GIS dataset - * @access public - */ - public function prepareRowAsSvg($spatial, $label, $line_color, array $scale_data) - { - $line_options = [ - 'name' => $label, - 'class' => 'linestring vector', - 'fill' => 'none', - 'stroke' => $line_color, - 'stroke-width' => 2, - ]; - - // Trim to remove leading 'MULTILINESTRING((' and trailing '))' - $multilinestirng - = mb_substr( - $spatial, - 17, - mb_strlen($spatial) - 19 - ); - // Separate each linestring - $linestirngs = explode("),(", $multilinestirng); - - $row = ''; - foreach ($linestirngs as $linestring) { - $points_arr = $this->extractPoints($linestring, $scale_data); - - $row .= '<polyline points="'; - foreach ($points_arr as $point) { - $row .= $point[0] . ',' . $point[1] . ' '; - } - $row .= '"'; - $line_options['id'] = $label . mt_rand(); - foreach ($line_options as $option => $val) { - $row .= ' ' . $option . '="' . trim((string) $val) . '"'; - } - $row .= '/>'; - } - - return $row; - } - - /** - * Prepares JavaScript related to a row in the GIS dataset - * to visualize it with OpenLayers. - * - * @param string $spatial GIS MULTILINESTRING object - * @param int $srid Spatial reference ID - * @param string $label Label for the GIS MULTILINESTRING object - * @param string $line_color Color for the GIS MULTILINESTRING object - * @param array $scale_data Array containing data related to scaling - * - * @return string JavaScript related to a row in the GIS dataset - * @access public - */ - public function prepareRowAsOl($spatial, $srid, $label, $line_color, array $scale_data) - { - $style_options = [ - 'strokeColor' => $line_color, - 'strokeWidth' => 2, - 'label' => $label, - 'fontSize' => 10, - ]; - if ($srid == 0) { - $srid = 4326; - } - $row = $this->getBoundsForOl($srid, $scale_data); - - // Trim to remove leading 'MULTILINESTRING((' and trailing '))' - $multilinestirng - = mb_substr( - $spatial, - 17, - mb_strlen($spatial) - 19 - ); - // Separate each linestring - $linestirngs = explode("),(", $multilinestirng); - - $row .= 'vectorLayer.addFeatures(new OpenLayers.Feature.Vector(' - . 'new OpenLayers.Geometry.MultiLineString(' - . $this->getLineArrayForOpenLayers($linestirngs, $srid) - . '), null, ' . json_encode($style_options) . '));'; - - return $row; - } - - /** - * Generate the WKT with the set of parameters passed by the GIS editor. - * - * @param array $gis_data GIS data - * @param int $index Index into the parameter object - * @param string $empty Value for empty points - * - * @return string WKT with the set of parameters passed by the GIS editor - * @access public - */ - public function generateWkt(array $gis_data, $index, $empty = '') - { - $data_row = $gis_data[$index]['MULTILINESTRING']; - - $no_of_lines = isset($data_row['no_of_lines']) - ? $data_row['no_of_lines'] : 1; - if ($no_of_lines < 1) { - $no_of_lines = 1; - } - - $wkt = 'MULTILINESTRING('; - for ($i = 0; $i < $no_of_lines; $i++) { - $no_of_points = isset($data_row[$i]['no_of_points']) - ? $data_row[$i]['no_of_points'] : 2; - if ($no_of_points < 2) { - $no_of_points = 2; - } - $wkt .= '('; - for ($j = 0; $j < $no_of_points; $j++) { - $wkt .= ((isset($data_row[$i][$j]['x']) - && trim((string) $data_row[$i][$j]['x']) != '') - ? $data_row[$i][$j]['x'] : $empty) - . ' ' . ((isset($data_row[$i][$j]['y']) - && trim((string) $data_row[$i][$j]['y']) != '') - ? $data_row[$i][$j]['y'] : $empty) . ','; - } - $wkt - = mb_substr( - $wkt, - 0, - mb_strlen($wkt) - 1 - ); - $wkt .= '),'; - } - $wkt - = mb_substr( - $wkt, - 0, - mb_strlen($wkt) - 1 - ); - $wkt .= ')'; - - return $wkt; - } - - /** - * Generate the WKT for the data from ESRI shape files. - * - * @param array $row_data GIS data - * - * @return string the WKT for the data from ESRI shape files - * @access public - */ - public function getShape(array $row_data) - { - $wkt = 'MULTILINESTRING('; - for ($i = 0; $i < $row_data['numparts']; $i++) { - $wkt .= '('; - foreach ($row_data['parts'][$i]['points'] as $point) { - $wkt .= $point['x'] . ' ' . $point['y'] . ','; - } - $wkt - = mb_substr( - $wkt, - 0, - mb_strlen($wkt) - 1 - ); - $wkt .= '),'; - } - $wkt - = mb_substr( - $wkt, - 0, - mb_strlen($wkt) - 1 - ); - $wkt .= ')'; - - return $wkt; - } - - /** - * Generate parameters for the GIS data editor from the value of the GIS column. - * - * @param string $value Value of the GIS column - * @param int $index Index of the geometry - * - * @return array params for the GIS data editor from the value of the GIS column - * @access public - */ - public function generateParams($value, $index = -1) - { - $params = []; - if ($index == -1) { - $index = 0; - $data = GisGeometry::generateParams($value); - $params['srid'] = $data['srid']; - $wkt = $data['wkt']; - } else { - $params[$index]['gis_type'] = 'MULTILINESTRING'; - $wkt = $value; - } - - // Trim to remove leading 'MULTILINESTRING((' and trailing '))' - $multilinestirng - = mb_substr( - $wkt, - 17, - mb_strlen($wkt) - 19 - ); - // Separate each linestring - $linestirngs = explode("),(", $multilinestirng); - $params[$index]['MULTILINESTRING']['no_of_lines'] = count($linestirngs); - - $j = 0; - foreach ($linestirngs as $linestring) { - $points_arr = $this->extractPoints($linestring, null); - $no_of_points = count($points_arr); - $params[$index]['MULTILINESTRING'][$j]['no_of_points'] = $no_of_points; - for ($i = 0; $i < $no_of_points; $i++) { - $params[$index]['MULTILINESTRING'][$j][$i]['x'] = $points_arr[$i][0]; - $params[$index]['MULTILINESTRING'][$j][$i]['y'] = $points_arr[$i][1]; - } - $j++; - } - - return $params; - } -} diff --git a/srcs/phpmyadmin/libraries/classes/Gis/GisMultiPoint.php b/srcs/phpmyadmin/libraries/classes/Gis/GisMultiPoint.php deleted file mode 100644 index 8a6b500..0000000 --- a/srcs/phpmyadmin/libraries/classes/Gis/GisMultiPoint.php +++ /dev/null @@ -1,416 +0,0 @@ -<?php -/* vim: set expandtab sw=4 ts=4 sts=4: */ -/** - * Handles actions related to GIS MULTIPOINT objects - * - * @package PhpMyAdmin-GIS - */ -declare(strict_types=1); - -namespace PhpMyAdmin\Gis; - -use TCPDF; - -/** - * Handles actions related to GIS MULTIPOINT objects - * - * @package PhpMyAdmin-GIS - */ -class GisMultiPoint extends GisGeometry -{ - // Hold the singleton instance of the class - private static $_instance; - - /** - * A private constructor; prevents direct creation of object. - * - * @access private - */ - private function __construct() - { - } - - /** - * Returns the singleton. - * - * @return GisMultiPoint the singleton - * @access public - */ - public static function singleton() - { - if (! isset(self::$_instance)) { - self::$_instance = new GisMultiPoint(); - } - - return self::$_instance; - } - - /** - * Scales each row. - * - * @param string $spatial spatial data of a row - * - * @return array an array containing the min, max values for x and y coordinates - * @access public - */ - public function scaleRow($spatial) - { - // Trim to remove leading 'MULTIPOINT(' and trailing ')' - $multipoint - = mb_substr( - $spatial, - 11, - mb_strlen($spatial) - 12 - ); - - return $this->setMinMax($multipoint, []); - } - - /** - * Adds to the PNG image object, the data related to a row in the GIS dataset. - * - * @param string $spatial GIS POLYGON object - * @param string|null $label Label for the GIS POLYGON object - * @param string $point_color Color for the GIS POLYGON object - * @param array $scale_data Array containing data related to scaling - * @param resource $image Image object - * - * @return resource the modified image object - * @access public - */ - public function prepareRowAsPng( - $spatial, - ?string $label, - $point_color, - array $scale_data, - $image - ) { - // allocate colors - $black = imagecolorallocate($image, 0, 0, 0); - $red = hexdec(mb_substr($point_color, 1, 2)); - $green = hexdec(mb_substr($point_color, 3, 2)); - $blue = hexdec(mb_substr($point_color, 4, 2)); - $color = imagecolorallocate($image, $red, $green, $blue); - - // Trim to remove leading 'MULTIPOINT(' and trailing ')' - $multipoint - = mb_substr( - $spatial, - 11, - mb_strlen($spatial) - 12 - ); - $points_arr = $this->extractPoints($multipoint, $scale_data); - - foreach ($points_arr as $point) { - // draw a small circle to mark the point - if ($point[0] != '' && $point[1] != '') { - imagearc($image, $point[0], $point[1], 7, 7, 0, 360, $color); - } - } - // print label for each point - if ((isset($label) && trim($label) != '') - && ($points_arr[0][0] != '' && $points_arr[0][1] != '') - ) { - imagestring( - $image, - 1, - $points_arr[0][0], - $points_arr[0][1], - trim($label), - $black - ); - } - - return $image; - } - - /** - * Adds to the TCPDF instance, the data related to a row in the GIS dataset. - * - * @param string $spatial GIS MULTIPOINT object - * @param string|null $label Label for the GIS MULTIPOINT object - * @param string $point_color Color for the GIS MULTIPOINT object - * @param array $scale_data Array containing data related to scaling - * @param TCPDF $pdf TCPDF instance - * - * @return TCPDF the modified TCPDF instance - * @access public - */ - public function prepareRowAsPdf( - $spatial, - ?string $label, - $point_color, - array $scale_data, - $pdf - ) { - // allocate colors - $red = hexdec(mb_substr($point_color, 1, 2)); - $green = hexdec(mb_substr($point_color, 3, 2)); - $blue = hexdec(mb_substr($point_color, 4, 2)); - $line = [ - 'width' => 1.25, - 'color' => [ - $red, - $green, - $blue, - ], - ]; - - // Trim to remove leading 'MULTIPOINT(' and trailing ')' - $multipoint - = mb_substr( - $spatial, - 11, - mb_strlen($spatial) - 12 - ); - $points_arr = $this->extractPoints($multipoint, $scale_data); - - foreach ($points_arr as $point) { - // draw a small circle to mark the point - if ($point[0] != '' && $point[1] != '') { - $pdf->Circle($point[0], $point[1], 2, 0, 360, 'D', $line); - } - } - // print label for each point - if ((isset($label) && trim($label) != '') - && ($points_arr[0][0] != '' && $points_arr[0][1] != '') - ) { - $pdf->SetXY($points_arr[0][0], $points_arr[0][1]); - $pdf->SetFontSize(5); - $pdf->Cell(0, 0, trim($label)); - } - - return $pdf; - } - - /** - * Prepares and returns the code related to a row in the GIS dataset as SVG. - * - * @param string $spatial GIS MULTIPOINT object - * @param string $label Label for the GIS MULTIPOINT object - * @param string $point_color Color for the GIS MULTIPOINT object - * @param array $scale_data Array containing data related to scaling - * - * @return string the code related to a row in the GIS dataset - * @access public - */ - public function prepareRowAsSvg($spatial, $label, $point_color, array $scale_data) - { - $point_options = [ - 'name' => $label, - 'class' => 'multipoint vector', - 'fill' => 'white', - 'stroke' => $point_color, - 'stroke-width' => 2, - ]; - - // Trim to remove leading 'MULTIPOINT(' and trailing ')' - $multipoint - = mb_substr( - $spatial, - 11, - mb_strlen($spatial) - 12 - ); - $points_arr = $this->extractPoints($multipoint, $scale_data); - - $row = ''; - foreach ($points_arr as $point) { - if ($point[0] != '' && $point[1] != '') { - $row .= '<circle cx="' . $point[0] . '" cy="' - . $point[1] . '" r="3"'; - $point_options['id'] = $label . mt_rand(); - foreach ($point_options as $option => $val) { - $row .= ' ' . $option . '="' . trim((string) $val) . '"'; - } - $row .= '/>'; - } - } - - return $row; - } - - /** - * Prepares JavaScript related to a row in the GIS dataset - * to visualize it with OpenLayers. - * - * @param string $spatial GIS MULTIPOINT object - * @param int $srid Spatial reference ID - * @param string $label Label for the GIS MULTIPOINT object - * @param string $point_color Color for the GIS MULTIPOINT object - * @param array $scale_data Array containing data related to scaling - * - * @return string JavaScript related to a row in the GIS dataset - * @access public - */ - public function prepareRowAsOl( - $spatial, - $srid, - $label, - $point_color, - array $scale_data - ) { - $style_options = [ - 'pointRadius' => 3, - 'fillColor' => '#ffffff', - 'strokeColor' => $point_color, - 'strokeWidth' => 2, - 'label' => $label, - 'labelYOffset' => -8, - 'fontSize' => 10, - ]; - if ($srid == 0) { - $srid = 4326; - } - $result = $this->getBoundsForOl($srid, $scale_data); - - // Trim to remove leading 'MULTIPOINT(' and trailing ')' - $multipoint - = mb_substr( - $spatial, - 11, - mb_strlen($spatial) - 12 - ); - $points_arr = $this->extractPoints($multipoint, null); - - $result .= 'vectorLayer.addFeatures(new OpenLayers.Feature.Vector(' - . 'new OpenLayers.Geometry.MultiPoint(' - . $this->getPointsArrayForOpenLayers($points_arr, $srid) - . '), null, ' . json_encode($style_options) . '));'; - - return $result; - } - - /** - * Generate the WKT with the set of parameters passed by the GIS editor. - * - * @param array $gis_data GIS data - * @param int $index Index into the parameter object - * @param string $empty Multipoint does not adhere to this - * - * @return string WKT with the set of parameters passed by the GIS editor - * @access public - */ - public function generateWkt(array $gis_data, $index, $empty = '') - { - $no_of_points = isset($gis_data[$index]['MULTIPOINT']['no_of_points']) - ? $gis_data[$index]['MULTIPOINT']['no_of_points'] : 1; - if ($no_of_points < 1) { - $no_of_points = 1; - } - $wkt = 'MULTIPOINT('; - for ($i = 0; $i < $no_of_points; $i++) { - $wkt .= ((isset($gis_data[$index]['MULTIPOINT'][$i]['x']) - && trim((string) $gis_data[$index]['MULTIPOINT'][$i]['x']) != '') - ? $gis_data[$index]['MULTIPOINT'][$i]['x'] : '') - . ' ' . ((isset($gis_data[$index]['MULTIPOINT'][$i]['y']) - && trim((string) $gis_data[$index]['MULTIPOINT'][$i]['y']) != '') - ? $gis_data[$index]['MULTIPOINT'][$i]['y'] : '') . ','; - } - - $wkt - = mb_substr( - $wkt, - 0, - mb_strlen($wkt) - 1 - ); - $wkt .= ')'; - - return $wkt; - } - - /** - * Generate the WKT for the data from ESRI shape files. - * - * @param array $row_data GIS data - * - * @return string the WKT for the data from ESRI shape files - * @access public - */ - public function getShape(array $row_data) - { - $wkt = 'MULTIPOINT('; - for ($i = 0; $i < $row_data['numpoints']; $i++) { - $wkt .= $row_data['points'][$i]['x'] . ' ' - . $row_data['points'][$i]['y'] . ','; - } - - $wkt - = mb_substr( - $wkt, - 0, - mb_strlen($wkt) - 1 - ); - $wkt .= ')'; - - return $wkt; - } - - /** - * Generate parameters for the GIS data editor from the value of the GIS column. - * - * @param string $value Value of the GIS column - * @param integer $index Index of the geometry - * - * @return array params for the GIS data editor from the value of the GIS column - * @access public - */ - public function generateParams($value, $index = -1) - { - $params = []; - if ($index == -1) { - $index = 0; - $data = GisGeometry::generateParams($value); - $params['srid'] = $data['srid']; - $wkt = $data['wkt']; - } else { - $params[$index]['gis_type'] = 'MULTIPOINT'; - $wkt = $value; - } - - // Trim to remove leading 'MULTIPOINT(' and trailing ')' - $points - = mb_substr( - $wkt, - 11, - mb_strlen($wkt) - 12 - ); - $points_arr = $this->extractPoints($points, null); - - $no_of_points = count($points_arr); - $params[$index]['MULTIPOINT']['no_of_points'] = $no_of_points; - for ($i = 0; $i < $no_of_points; $i++) { - $params[$index]['MULTIPOINT'][$i]['x'] = $points_arr[$i][0]; - $params[$index]['MULTIPOINT'][$i]['y'] = $points_arr[$i][1]; - } - - return $params; - } - - /** - * Overridden to make sure that only the points having valid values - * for x and y coordinates are added. - * - * @param array $points_arr x and y coordinates for each point - * @param string $srid spatial reference id - * - * @return string JavaScript for adding an array of points to OpenLayers - * @access protected - */ - protected function getPointsArrayForOpenLayers(array $points_arr, $srid) - { - $ol_array = 'new Array('; - foreach ($points_arr as $point) { - if ($point[0] != '' && $point[1] != '') { - $ol_array .= $this->getPointForOpenLayers($point, $srid) . ', '; - } - } - - $olArrayLength = mb_strlen($ol_array); - if (mb_substr($ol_array, $olArrayLength - 2) == ', ') { - $ol_array = mb_substr($ol_array, 0, $olArrayLength - 2); - } - $ol_array .= ')'; - - return $ol_array; - } -} diff --git a/srcs/phpmyadmin/libraries/classes/Gis/GisMultiPolygon.php b/srcs/phpmyadmin/libraries/classes/Gis/GisMultiPolygon.php deleted file mode 100644 index 3d2449c..0000000 --- a/srcs/phpmyadmin/libraries/classes/Gis/GisMultiPolygon.php +++ /dev/null @@ -1,617 +0,0 @@ -<?php -/* vim: set expandtab sw=4 ts=4 sts=4: */ -/** - * Handles actions related to GIS MULTIPOLYGON objects - * - * @package PhpMyAdmin-GIS - */ -declare(strict_types=1); - -namespace PhpMyAdmin\Gis; - -use TCPDF; - -/** - * Handles actions related to GIS MULTIPOLYGON objects - * - * @package PhpMyAdmin-GIS - */ -class GisMultiPolygon extends GisGeometry -{ - // Hold the singleton instance of the class - private static $_instance; - - /** - * A private constructor; prevents direct creation of object. - * - * @access private - */ - private function __construct() - { - } - - /** - * Returns the singleton. - * - * @return GisMultiPolygon the singleton - * @access public - */ - public static function singleton() - { - if (! isset(self::$_instance)) { - self::$_instance = new GisMultiPolygon(); - } - - return self::$_instance; - } - - /** - * Scales each row. - * - * @param string $spatial spatial data of a row - * - * @return array an array containing the min, max values for x and y coordinates - * @access public - */ - public function scaleRow($spatial) - { - $min_max = []; - - // Trim to remove leading 'MULTIPOLYGON(((' and trailing ')))' - $multipolygon - = mb_substr( - $spatial, - 15, - mb_strlen($spatial) - 18 - ); - // Separate each polygon - $polygons = explode(")),((", $multipolygon); - - foreach ($polygons as $polygon) { - // If the polygon doesn't have an inner ring, use polygon itself - if (mb_strpos($polygon, "),(") === false) { - $ring = $polygon; - } else { - // Separate outer ring and use it to determine min-max - $parts = explode("),(", $polygon); - $ring = $parts[0]; - } - $min_max = $this->setMinMax($ring, $min_max); - } - - return $min_max; - } - - /** - * Adds to the PNG image object, the data related to a row in the GIS dataset. - * - * @param string $spatial GIS POLYGON object - * @param string|null $label Label for the GIS POLYGON object - * @param string $fill_color Color for the GIS POLYGON object - * @param array $scale_data Array containing data related to scaling - * @param resource $image Image object - * - * @return resource the modified image object - * @access public - */ - public function prepareRowAsPng( - $spatial, - ?string $label, - $fill_color, - array $scale_data, - $image - ) { - // allocate colors - $black = imagecolorallocate($image, 0, 0, 0); - $red = hexdec(mb_substr($fill_color, 1, 2)); - $green = hexdec(mb_substr($fill_color, 3, 2)); - $blue = hexdec(mb_substr($fill_color, 4, 2)); - $color = imagecolorallocate($image, $red, $green, $blue); - - // Trim to remove leading 'MULTIPOLYGON(((' and trailing ')))' - $multipolygon - = mb_substr( - $spatial, - 15, - mb_strlen($spatial) - 18 - ); - // Separate each polygon - $polygons = explode(")),((", $multipolygon); - - $first_poly = true; - $points_arr = []; - foreach ($polygons as $polygon) { - // If the polygon doesn't have an inner polygon - if (mb_strpos($polygon, "),(") === false) { - $points_arr = $this->extractPoints($polygon, $scale_data, true); - } else { - // Separate outer and inner polygons - $parts = explode("),(", $polygon); - $outer = $parts[0]; - $inner = array_slice($parts, 1); - - $points_arr = $this->extractPoints($outer, $scale_data, true); - - foreach ($inner as $inner_poly) { - $points_arr = array_merge( - $points_arr, - $this->extractPoints($inner_poly, $scale_data, true) - ); - } - } - // draw polygon - imagefilledpolygon($image, $points_arr, count($points_arr) / 2, $color); - // mark label point if applicable - if (isset($label) && trim($label) != '' && $first_poly) { - $label_point = [ - $points_arr[2], - $points_arr[3], - ]; - } - $first_poly = false; - } - // print label if applicable - if (isset($label_point)) { - imagestring( - $image, - 1, - $points_arr[2], - $points_arr[3], - trim($label), - $black - ); - } - - return $image; - } - - /** - * Adds to the TCPDF instance, the data related to a row in the GIS dataset. - * - * @param string $spatial GIS MULTIPOLYGON object - * @param string|null $label Label for the GIS MULTIPOLYGON object - * @param string $fill_color Color for the GIS MULTIPOLYGON object - * @param array $scale_data Array containing data related to scaling - * @param TCPDF $pdf TCPDF instance - * - * @return TCPDF the modified TCPDF instance - * @access public - */ - public function prepareRowAsPdf($spatial, ?string $label, $fill_color, array $scale_data, $pdf) - { - // allocate colors - $red = hexdec(mb_substr($fill_color, 1, 2)); - $green = hexdec(mb_substr($fill_color, 3, 2)); - $blue = hexdec(mb_substr($fill_color, 4, 2)); - $color = [ - $red, - $green, - $blue, - ]; - - // Trim to remove leading 'MULTIPOLYGON(((' and trailing ')))' - $multipolygon - = mb_substr( - $spatial, - 15, - mb_strlen($spatial) - 18 - ); - // Separate each polygon - $polygons = explode(")),((", $multipolygon); - - $first_poly = true; - foreach ($polygons as $polygon) { - // If the polygon doesn't have an inner polygon - if (mb_strpos($polygon, "),(") === false) { - $points_arr = $this->extractPoints($polygon, $scale_data, true); - } else { - // Separate outer and inner polygons - $parts = explode("),(", $polygon); - $outer = $parts[0]; - $inner = array_slice($parts, 1); - - $points_arr = $this->extractPoints($outer, $scale_data, true); - - foreach ($inner as $inner_poly) { - $points_arr = array_merge( - $points_arr, - $this->extractPoints($inner_poly, $scale_data, true) - ); - } - } - // draw polygon - $pdf->Polygon($points_arr, 'F*', [], $color, true); - // mark label point if applicable - if (isset($label) && trim($label) != '' && $first_poly) { - $label_point = [ - $points_arr[2], - $points_arr[3], - ]; - } - $first_poly = false; - } - - // print label if applicable - if (isset($label_point)) { - $pdf->SetXY($label_point[0], $label_point[1]); - $pdf->SetFontSize(5); - $pdf->Cell(0, 0, trim($label)); - } - - return $pdf; - } - - /** - * Prepares and returns the code related to a row in the GIS dataset as SVG. - * - * @param string $spatial GIS MULTIPOLYGON object - * @param string $label Label for the GIS MULTIPOLYGON object - * @param string $fill_color Color for the GIS MULTIPOLYGON object - * @param array $scale_data Array containing data related to scaling - * - * @return string the code related to a row in the GIS dataset - * @access public - */ - public function prepareRowAsSvg($spatial, $label, $fill_color, array $scale_data) - { - $polygon_options = [ - 'name' => $label, - 'class' => 'multipolygon vector', - 'stroke' => 'black', - 'stroke-width' => 0.5, - 'fill' => $fill_color, - 'fill-rule' => 'evenodd', - 'fill-opacity' => 0.8, - ]; - - $row = ''; - - // Trim to remove leading 'MULTIPOLYGON(((' and trailing ')))' - $multipolygon - = mb_substr( - $spatial, - 15, - mb_strlen($spatial) - 18 - ); - // Separate each polygon - $polygons = explode(")),((", $multipolygon); - - foreach ($polygons as $polygon) { - $row .= '<path d="'; - - // If the polygon doesn't have an inner polygon - if (mb_strpos($polygon, "),(") === false) { - $row .= $this->_drawPath($polygon, $scale_data); - } else { - // Separate outer and inner polygons - $parts = explode("),(", $polygon); - $outer = $parts[0]; - $inner = array_slice($parts, 1); - - $row .= $this->_drawPath($outer, $scale_data); - - foreach ($inner as $inner_poly) { - $row .= $this->_drawPath($inner_poly, $scale_data); - } - } - $polygon_options['id'] = $label . mt_rand(); - $row .= '"'; - foreach ($polygon_options as $option => $val) { - $row .= ' ' . $option . '="' . trim((string) $val) . '"'; - } - $row .= '/>'; - } - - return $row; - } - - /** - * Prepares JavaScript related to a row in the GIS dataset - * to visualize it with OpenLayers. - * - * @param string $spatial GIS MULTIPOLYGON object - * @param int $srid Spatial reference ID - * @param string $label Label for the GIS MULTIPOLYGON object - * @param string $fill_color Color for the GIS MULTIPOLYGON object - * @param array $scale_data Array containing data related to scaling - * - * @return string JavaScript related to a row in the GIS dataset - * @access public - */ - public function prepareRowAsOl($spatial, $srid, $label, $fill_color, array $scale_data) - { - $style_options = [ - 'strokeColor' => '#000000', - 'strokeWidth' => 0.5, - 'fillColor' => $fill_color, - 'fillOpacity' => 0.8, - 'label' => $label, - 'fontSize' => 10, - ]; - if ($srid == 0) { - $srid = 4326; - } - $row = $this->getBoundsForOl($srid, $scale_data); - - // Trim to remove leading 'MULTIPOLYGON(((' and trailing ')))' - $multipolygon - = mb_substr( - $spatial, - 15, - mb_strlen($spatial) - 18 - ); - // Separate each polygon - $polygons = explode(")),((", $multipolygon); - - $row .= 'vectorLayer.addFeatures(new OpenLayers.Feature.Vector(' - . 'new OpenLayers.Geometry.MultiPolygon(' - . $this->getPolygonArrayForOpenLayers($polygons, $srid) - . '), null, ' . json_encode($style_options) . '));'; - - return $row; - } - - /** - * Draws a ring of the polygon using SVG path element. - * - * @param string $polygon The ring - * @param array $scale_data Array containing data related to scaling - * - * @return string the code to draw the ring - * @access private - */ - private function _drawPath($polygon, array $scale_data) - { - $points_arr = $this->extractPoints($polygon, $scale_data); - - $row = ' M ' . $points_arr[0][0] . ', ' . $points_arr[0][1]; - $other_points = array_slice($points_arr, 1, count($points_arr) - 2); - foreach ($other_points as $point) { - $row .= ' L ' . $point[0] . ', ' . $point[1]; - } - $row .= ' Z '; - - return $row; - } - - /** - * Generate the WKT with the set of parameters passed by the GIS editor. - * - * @param array $gis_data GIS data - * @param int $index Index into the parameter object - * @param string $empty Value for empty points - * - * @return string WKT with the set of parameters passed by the GIS editor - * @access public - */ - public function generateWkt(array $gis_data, $index, $empty = '') - { - $data_row = $gis_data[$index]['MULTIPOLYGON']; - - $no_of_polygons = isset($data_row['no_of_polygons']) - ? $data_row['no_of_polygons'] : 1; - if ($no_of_polygons < 1) { - $no_of_polygons = 1; - } - - $wkt = 'MULTIPOLYGON('; - for ($k = 0; $k < $no_of_polygons; $k++) { - $no_of_lines = isset($data_row[$k]['no_of_lines']) - ? $data_row[$k]['no_of_lines'] : 1; - if ($no_of_lines < 1) { - $no_of_lines = 1; - } - $wkt .= '('; - for ($i = 0; $i < $no_of_lines; $i++) { - $no_of_points = isset($data_row[$k][$i]['no_of_points']) - ? $data_row[$k][$i]['no_of_points'] : 4; - if ($no_of_points < 4) { - $no_of_points = 4; - } - $wkt .= '('; - for ($j = 0; $j < $no_of_points; $j++) { - $wkt .= ((isset($data_row[$k][$i][$j]['x']) - && trim((string) $data_row[$k][$i][$j]['x']) != '') - ? $data_row[$k][$i][$j]['x'] : $empty) - . ' ' . ((isset($data_row[$k][$i][$j]['y']) - && trim((string) $data_row[$k][$i][$j]['y']) != '') - ? $data_row[$k][$i][$j]['y'] : $empty) . ','; - } - $wkt - = mb_substr( - $wkt, - 0, - mb_strlen($wkt) - 1 - ); - $wkt .= '),'; - } - $wkt - = mb_substr( - $wkt, - 0, - mb_strlen($wkt) - 1 - ); - $wkt .= '),'; - } - $wkt - = mb_substr( - $wkt, - 0, - mb_strlen($wkt) - 1 - ); - $wkt .= ')'; - - return $wkt; - } - - /** - * Generate the WKT for the data from ESRI shape files. - * - * @param array $row_data GIS data - * - * @return string the WKT for the data from ESRI shape files - * @access public - */ - public function getShape(array $row_data) - { - // Determines whether each line ring is an inner ring or an outer ring. - // If it's an inner ring get a point on the surface which can be used to - // correctly classify inner rings to their respective outer rings. - foreach ($row_data['parts'] as $i => $ring) { - $row_data['parts'][$i]['isOuter'] - = GisPolygon::isOuterRing($ring['points']); - } - - // Find points on surface for inner rings - foreach ($row_data['parts'] as $i => $ring) { - if (! $ring['isOuter']) { - $row_data['parts'][$i]['pointOnSurface'] - = GisPolygon::getPointOnSurface($ring['points']); - } - } - - // Classify inner rings to their respective outer rings. - foreach ($row_data['parts'] as $j => $ring1) { - if ($ring1['isOuter']) { - continue; - } - foreach ($row_data['parts'] as $k => $ring2) { - if (! $ring2['isOuter']) { - continue; - } - - // If the pointOnSurface of the inner ring - // is also inside the outer ring - if (GisPolygon::isPointInsidePolygon( - $ring1['pointOnSurface'], - $ring2['points'] - ) - ) { - if (! isset($ring2['inner'])) { - $row_data['parts'][$k]['inner'] = []; - } - $row_data['parts'][$k]['inner'][] = $j; - } - } - } - - $wkt = 'MULTIPOLYGON('; - // for each polygon - foreach ($row_data['parts'] as $ring) { - if (! $ring['isOuter']) { - continue; - } - - $wkt .= '('; // start of polygon - - $wkt .= '('; // start of outer ring - foreach ($ring['points'] as $point) { - $wkt .= $point['x'] . ' ' . $point['y'] . ','; - } - $wkt - = mb_substr( - $wkt, - 0, - mb_strlen($wkt) - 1 - ); - $wkt .= ')'; // end of outer ring - - // inner rings if any - if (isset($ring['inner'])) { - foreach ($ring['inner'] as $j) { - $wkt .= ',('; // start of inner ring - foreach ($row_data['parts'][$j]['points'] as $innerPoint) { - $wkt .= $innerPoint['x'] . ' ' . $innerPoint['y'] . ','; - } - $wkt - = mb_substr( - $wkt, - 0, - mb_strlen($wkt) - 1 - ); - $wkt .= ')'; // end of inner ring - } - } - - $wkt .= '),'; // end of polygon - } - $wkt - = mb_substr( - $wkt, - 0, - mb_strlen($wkt) - 1 - ); - - $wkt .= ')'; // end of multipolygon - return $wkt; - } - - /** - * Generate parameters for the GIS data editor from the value of the GIS column. - * - * @param string $value Value of the GIS column - * @param int $index Index of the geometry - * - * @return array params for the GIS data editor from the value of the GIS column - * @access public - */ - public function generateParams($value, $index = -1) - { - $params = []; - if ($index == -1) { - $index = 0; - $data = GisGeometry::generateParams($value); - $params['srid'] = $data['srid']; - $wkt = $data['wkt']; - } else { - $params[$index]['gis_type'] = 'MULTIPOLYGON'; - $wkt = $value; - } - - // Trim to remove leading 'MULTIPOLYGON(((' and trailing ')))' - $multipolygon - = mb_substr( - $wkt, - 15, - mb_strlen($wkt) - 18 - ); - // Separate each polygon - $polygons = explode(")),((", $multipolygon); - - $param_row =& $params[$index]['MULTIPOLYGON']; - $param_row['no_of_polygons'] = count($polygons); - - $k = 0; - foreach ($polygons as $polygon) { - // If the polygon doesn't have an inner polygon - if (mb_strpos($polygon, "),(") === false) { - $param_row[$k]['no_of_lines'] = 1; - $points_arr = $this->extractPoints($polygon, null); - $no_of_points = count($points_arr); - $param_row[$k][0]['no_of_points'] = $no_of_points; - for ($i = 0; $i < $no_of_points; $i++) { - $param_row[$k][0][$i]['x'] = $points_arr[$i][0]; - $param_row[$k][0][$i]['y'] = $points_arr[$i][1]; - } - } else { - // Separate outer and inner polygons - $parts = explode("),(", $polygon); - $param_row[$k]['no_of_lines'] = count($parts); - $j = 0; - foreach ($parts as $ring) { - $points_arr = $this->extractPoints($ring, null); - $no_of_points = count($points_arr); - $param_row[$k][$j]['no_of_points'] = $no_of_points; - for ($i = 0; $i < $no_of_points; $i++) { - $param_row[$k][$j][$i]['x'] = $points_arr[$i][0]; - $param_row[$k][$j][$i]['y'] = $points_arr[$i][1]; - } - $j++; - } - } - $k++; - } - - return $params; - } -} diff --git a/srcs/phpmyadmin/libraries/classes/Gis/GisPoint.php b/srcs/phpmyadmin/libraries/classes/Gis/GisPoint.php deleted file mode 100644 index f11b0c8..0000000 --- a/srcs/phpmyadmin/libraries/classes/Gis/GisPoint.php +++ /dev/null @@ -1,363 +0,0 @@ -<?php -/* vim: set expandtab sw=4 ts=4 sts=4: */ -/** - * Handles actions related to GIS POINT objects - * - * @package PhpMyAdmin-GIS - */ -declare(strict_types=1); - -namespace PhpMyAdmin\Gis; - -use TCPDF; - -/** - * Handles actions related to GIS POINT objects - * - * @package PhpMyAdmin-GIS - */ -class GisPoint extends GisGeometry -{ - // Hold the singleton instance of the class - private static $_instance; - - /** - * A private constructor; prevents direct creation of object. - * - * @access private - */ - private function __construct() - { - } - - /** - * Returns the singleton. - * - * @return GisPoint the singleton - * @access public - */ - public static function singleton() - { - if (! isset(self::$_instance)) { - self::$_instance = new GisPoint(); - } - - return self::$_instance; - } - - /** - * Scales each row. - * - * @param string $spatial spatial data of a row - * - * @return array an array containing the min, max values for x and y coordinates - * @access public - */ - public function scaleRow($spatial) - { - // Trim to remove leading 'POINT(' and trailing ')' - $point - = mb_substr( - $spatial, - 6, - mb_strlen($spatial) - 7 - ); - - return $this->setMinMax($point, []); - } - - /** - * Adds to the PNG image object, the data related to a row in the GIS dataset. - * - * @param string $spatial GIS POLYGON object - * @param string|null $label Label for the GIS POLYGON object - * @param string $point_color Color for the GIS POLYGON object - * @param array $scale_data Array containing data related to scaling - * @param resource $image Image object - * - * @return resource the modified image object - * @access public - */ - public function prepareRowAsPng( - $spatial, - ?string $label, - $point_color, - array $scale_data, - $image - ) { - // allocate colors - $black = imagecolorallocate($image, 0, 0, 0); - $red = hexdec(mb_substr($point_color, 1, 2)); - $green = hexdec(mb_substr($point_color, 3, 2)); - $blue = hexdec(mb_substr($point_color, 4, 2)); - $color = imagecolorallocate($image, $red, $green, $blue); - - // Trim to remove leading 'POINT(' and trailing ')' - $point - = mb_substr( - $spatial, - 6, - mb_strlen($spatial) - 7 - ); - $points_arr = $this->extractPoints($point, $scale_data); - - // draw a small circle to mark the point - if ($points_arr[0][0] != '' && $points_arr[0][1] != '') { - imagearc( - $image, - $points_arr[0][0], - $points_arr[0][1], - 7, - 7, - 0, - 360, - $color - ); - // print label if applicable - if (isset($label) && trim($label) != '') { - imagestring( - $image, - 1, - $points_arr[0][0], - $points_arr[0][1], - trim($label), - $black - ); - } - } - - return $image; - } - - /** - * Adds to the TCPDF instance, the data related to a row in the GIS dataset. - * - * @param string $spatial GIS POINT object - * @param string|null $label Label for the GIS POINT object - * @param string $point_color Color for the GIS POINT object - * @param array $scale_data Array containing data related to scaling - * @param TCPDF $pdf TCPDF instance - * - * @return TCPDF the modified TCPDF instance - * @access public - */ - public function prepareRowAsPdf( - $spatial, - ?string $label, - $point_color, - array $scale_data, - $pdf - ) { - // allocate colors - $red = hexdec(mb_substr($point_color, 1, 2)); - $green = hexdec(mb_substr($point_color, 3, 2)); - $blue = hexdec(mb_substr($point_color, 4, 2)); - $line = [ - 'width' => 1.25, - 'color' => [ - $red, - $green, - $blue, - ], - ]; - - // Trim to remove leading 'POINT(' and trailing ')' - $point - = mb_substr( - $spatial, - 6, - mb_strlen($spatial) - 7 - ); - $points_arr = $this->extractPoints($point, $scale_data); - - // draw a small circle to mark the point - if ($points_arr[0][0] != '' && $points_arr[0][1] != '') { - $pdf->Circle( - $points_arr[0][0], - $points_arr[0][1], - 2, - 0, - 360, - 'D', - $line - ); - // print label if applicable - if (isset($label) && trim($label) != '') { - $pdf->SetXY($points_arr[0][0], $points_arr[0][1]); - $pdf->SetFontSize(5); - $pdf->Cell(0, 0, trim($label)); - } - } - - return $pdf; - } - - /** - * Prepares and returns the code related to a row in the GIS dataset as SVG. - * - * @param string $spatial GIS POINT object - * @param string $label Label for the GIS POINT object - * @param string $point_color Color for the GIS POINT object - * @param array $scale_data Array containing data related to scaling - * - * @return string the code related to a row in the GIS dataset - * @access public - */ - public function prepareRowAsSvg($spatial, $label, $point_color, array $scale_data) - { - $point_options = [ - 'name' => $label, - 'id' => $label . mt_rand(), - 'class' => 'point vector', - 'fill' => 'white', - 'stroke' => $point_color, - 'stroke-width' => 2, - ]; - - // Trim to remove leading 'POINT(' and trailing ')' - $point - = mb_substr( - $spatial, - 6, - mb_strlen($spatial) - 7 - ); - $points_arr = $this->extractPoints($point, $scale_data); - - $row = ''; - if ($points_arr[0][0] != '' && $points_arr[0][1] != '') { - $row .= '<circle cx="' . $points_arr[0][0] - . '" cy="' . $points_arr[0][1] . '" r="3"'; - foreach ($point_options as $option => $val) { - $row .= ' ' . $option . '="' . trim((string) $val) . '"'; - } - $row .= '/>'; - } - - return $row; - } - - /** - * Prepares JavaScript related to a row in the GIS dataset - * to visualize it with OpenLayers. - * - * @param string $spatial GIS POINT object - * @param int $srid Spatial reference ID - * @param string $label Label for the GIS POINT object - * @param string $point_color Color for the GIS POINT object - * @param array $scale_data Array containing data related to scaling - * - * @return string JavaScript related to a row in the GIS dataset - * @access public - */ - public function prepareRowAsOl( - $spatial, - $srid, - $label, - $point_color, - array $scale_data - ) { - $style_options = [ - 'pointRadius' => 3, - 'fillColor' => '#ffffff', - 'strokeColor' => $point_color, - 'strokeWidth' => 2, - 'label' => $label, - 'labelYOffset' => -8, - 'fontSize' => 10, - ]; - if ($srid == 0) { - $srid = 4326; - } - $result = $this->getBoundsForOl($srid, $scale_data); - - // Trim to remove leading 'POINT(' and trailing ')' - $point - = mb_substr( - $spatial, - 6, - mb_strlen($spatial) - 7 - ); - $points_arr = $this->extractPoints($point, null); - - if ($points_arr[0][0] != '' && $points_arr[0][1] != '') { - $result .= 'vectorLayer.addFeatures(new OpenLayers.Feature.Vector(' - . $this->getPointForOpenLayers($points_arr[0], $srid) . ', null, ' - . json_encode($style_options) . '));'; - } - - return $result; - } - - /** - * Generate the WKT with the set of parameters passed by the GIS editor. - * - * @param array $gis_data GIS data - * @param int $index Index into the parameter object - * @param string $empty Point does not adhere to this parameter - * - * @return string WKT with the set of parameters passed by the GIS editor - * @access public - */ - public function generateWkt(array $gis_data, $index, $empty = '') - { - return 'POINT(' - . ((isset($gis_data[$index]['POINT']['x']) - && trim((string) $gis_data[$index]['POINT']['x']) != '') - ? $gis_data[$index]['POINT']['x'] : '') - . ' ' - . ((isset($gis_data[$index]['POINT']['y']) - && trim((string) $gis_data[$index]['POINT']['y']) != '') - ? $gis_data[$index]['POINT']['y'] : '') . ')'; - } - - /** - * Generate the WKT for the data from ESRI shape files. - * - * @param array $row_data GIS data - * - * @return string the WKT for the data from ESRI shape files - * @access public - */ - public function getShape(array $row_data) - { - return 'POINT(' . (isset($row_data['x']) ? $row_data['x'] : '') - . ' ' . (isset($row_data['y']) ? $row_data['y'] : '') . ')'; - } - - /** - * Generate parameters for the GIS data editor from the value of the GIS column. - * - * @param string $value of the GIS column - * @param int $index of the geometry - * - * @return array params for the GIS data editor from the value of the GIS column - * @access public - */ - public function generateParams($value, $index = -1) - { - $params = []; - if ($index == -1) { - $index = 0; - $data = GisGeometry::generateParams($value); - $params['srid'] = $data['srid']; - $wkt = $data['wkt']; - } else { - $params[$index]['gis_type'] = 'POINT'; - $wkt = $value; - } - - // Trim to remove leading 'POINT(' and trailing ')' - $point - = mb_substr( - $wkt, - 6, - mb_strlen($wkt) - 7 - ); - $points_arr = $this->extractPoints($point, null); - - $params[$index]['POINT']['x'] = $points_arr[0][0]; - $params[$index]['POINT']['y'] = $points_arr[0][1]; - - return $params; - } -} diff --git a/srcs/phpmyadmin/libraries/classes/Gis/GisPolygon.php b/srcs/phpmyadmin/libraries/classes/Gis/GisPolygon.php deleted file mode 100644 index b44da07..0000000 --- a/srcs/phpmyadmin/libraries/classes/Gis/GisPolygon.php +++ /dev/null @@ -1,618 +0,0 @@ -<?php -/* vim: set expandtab sw=4 ts=4 sts=4: */ -/** - * Handles actions related to GIS POLYGON objects - * - * @package PhpMyAdmin-GIS - */ -declare(strict_types=1); - -namespace PhpMyAdmin\Gis; - -use TCPDF; - -/** - * Handles actions related to GIS POLYGON objects - * - * @package PhpMyAdmin-GIS - */ -class GisPolygon extends GisGeometry -{ - // Hold the singleton instance of the class - private static $_instance; - - /** - * A private constructor; prevents direct creation of object. - * - * @access private - */ - private function __construct() - { - } - - /** - * Returns the singleton. - * - * @return GisPolygon the singleton - * @access public - */ - public static function singleton() - { - if (! isset(self::$_instance)) { - self::$_instance = new GisPolygon(); - } - - return self::$_instance; - } - - /** - * Scales each row. - * - * @param string $spatial spatial data of a row - * - * @return array an array containing the min, max values for x and y coordinates - * @access public - */ - public function scaleRow($spatial) - { - // Trim to remove leading 'POLYGON((' and trailing '))' - $polygon = mb_substr( - $spatial, - 9, - mb_strlen($spatial) - 11 - ); - - // If the polygon doesn't have an inner ring, use polygon itself - if (mb_strpos($polygon, "),(") === false) { - $ring = $polygon; - } else { - // Separate outer ring and use it to determine min-max - $parts = explode("),(", $polygon); - $ring = $parts[0]; - } - - return $this->setMinMax($ring, []); - } - - /** - * Adds to the PNG image object, the data related to a row in the GIS dataset. - * - * @param string $spatial GIS POLYGON object - * @param string|null $label Label for the GIS POLYGON object - * @param string $fill_color Color for the GIS POLYGON object - * @param array $scale_data Array containing data related to scaling - * @param resource $image Image object - * - * @return resource the modified image object - * @access public - */ - public function prepareRowAsPng( - $spatial, - ?string $label, - $fill_color, - array $scale_data, - $image - ) { - // allocate colors - $black = imagecolorallocate($image, 0, 0, 0); - $red = hexdec(mb_substr($fill_color, 1, 2)); - $green = hexdec(mb_substr($fill_color, 3, 2)); - $blue = hexdec(mb_substr($fill_color, 4, 2)); - $color = imagecolorallocate($image, $red, $green, $blue); - - // Trim to remove leading 'POLYGON((' and trailing '))' - $polygon = mb_substr( - $spatial, - 9, - mb_strlen($spatial) - 11 - ); - - // If the polygon doesn't have an inner polygon - if (mb_strpos($polygon, "),(") === false) { - $points_arr = $this->extractPoints($polygon, $scale_data, true); - } else { - // Separate outer and inner polygons - $parts = explode("),(", $polygon); - $outer = $parts[0]; - $inner = array_slice($parts, 1); - - $points_arr = $this->extractPoints($outer, $scale_data, true); - - foreach ($inner as $inner_poly) { - $points_arr = array_merge( - $points_arr, - $this->extractPoints($inner_poly, $scale_data, true) - ); - } - } - - // draw polygon - imagefilledpolygon($image, $points_arr, count($points_arr) / 2, $color); - // print label if applicable - if (isset($label) && trim($label) != '') { - imagestring( - $image, - 1, - $points_arr[2], - $points_arr[3], - trim($label), - $black - ); - } - - return $image; - } - - /** - * Adds to the TCPDF instance, the data related to a row in the GIS dataset. - * - * @param string $spatial GIS POLYGON object - * @param string|null $label Label for the GIS POLYGON object - * @param string $fill_color Color for the GIS POLYGON object - * @param array $scale_data Array containing data related to scaling - * @param TCPDF $pdf TCPDF instance - * - * @return TCPDF the modified TCPDF instance - * @access public - */ - public function prepareRowAsPdf($spatial, ?string $label, $fill_color, array $scale_data, $pdf) - { - // allocate colors - $red = hexdec(mb_substr($fill_color, 1, 2)); - $green = hexdec(mb_substr($fill_color, 3, 2)); - $blue = hexdec(mb_substr($fill_color, 4, 2)); - $color = [ - $red, - $green, - $blue, - ]; - - // Trim to remove leading 'POLYGON((' and trailing '))' - $polygon = mb_substr( - $spatial, - 9, - mb_strlen($spatial) - 11 - ); - - // If the polygon doesn't have an inner polygon - if (mb_strpos($polygon, "),(") === false) { - $points_arr = $this->extractPoints($polygon, $scale_data, true); - } else { - // Separate outer and inner polygons - $parts = explode("),(", $polygon); - $outer = $parts[0]; - $inner = array_slice($parts, 1); - - $points_arr = $this->extractPoints($outer, $scale_data, true); - - foreach ($inner as $inner_poly) { - $points_arr = array_merge( - $points_arr, - $this->extractPoints($inner_poly, $scale_data, true) - ); - } - } - - // draw polygon - $pdf->Polygon($points_arr, 'F*', [], $color, true); - // print label if applicable - if (isset($label) && trim($label) != '') { - $pdf->SetXY($points_arr[2], $points_arr[3]); - $pdf->SetFontSize(5); - $pdf->Cell(0, 0, trim($label)); - } - - return $pdf; - } - - /** - * Prepares and returns the code related to a row in the GIS dataset as SVG. - * - * @param string $spatial GIS POLYGON object - * @param string $label Label for the GIS POLYGON object - * @param string $fill_color Color for the GIS POLYGON object - * @param array $scale_data Array containing data related to scaling - * - * @return string the code related to a row in the GIS dataset - * @access public - */ - public function prepareRowAsSvg($spatial, $label, $fill_color, array $scale_data) - { - $polygon_options = [ - 'name' => $label, - 'id' => $label . mt_rand(), - 'class' => 'polygon vector', - 'stroke' => 'black', - 'stroke-width' => 0.5, - 'fill' => $fill_color, - 'fill-rule' => 'evenodd', - 'fill-opacity' => 0.8, - ]; - - // Trim to remove leading 'POLYGON((' and trailing '))' - $polygon - = mb_substr( - $spatial, - 9, - mb_strlen($spatial) - 11 - ); - - $row = '<path d="'; - - // If the polygon doesn't have an inner polygon - if (mb_strpos($polygon, "),(") === false) { - $row .= $this->_drawPath($polygon, $scale_data); - } else { - // Separate outer and inner polygons - $parts = explode("),(", $polygon); - $outer = $parts[0]; - $inner = array_slice($parts, 1); - - $row .= $this->_drawPath($outer, $scale_data); - - foreach ($inner as $inner_poly) { - $row .= $this->_drawPath($inner_poly, $scale_data); - } - } - - $row .= '"'; - foreach ($polygon_options as $option => $val) { - $row .= ' ' . $option . '="' . trim((string) $val) . '"'; - } - $row .= '/>'; - - return $row; - } - - /** - * Prepares JavaScript related to a row in the GIS dataset - * to visualize it with OpenLayers. - * - * @param string $spatial GIS POLYGON object - * @param int $srid Spatial reference ID - * @param string $label Label for the GIS POLYGON object - * @param string $fill_color Color for the GIS POLYGON object - * @param array $scale_data Array containing data related to scaling - * - * @return string JavaScript related to a row in the GIS dataset - * @access public - */ - public function prepareRowAsOl($spatial, $srid, $label, $fill_color, array $scale_data) - { - $style_options = [ - 'strokeColor' => '#000000', - 'strokeWidth' => 0.5, - 'fillColor' => $fill_color, - 'fillOpacity' => 0.8, - 'label' => $label, - 'fontSize' => 10, - ]; - if ($srid == 0) { - $srid = 4326; - } - $row = $this->getBoundsForOl($srid, $scale_data); - - // Trim to remove leading 'POLYGON((' and trailing '))' - $polygon - = - mb_substr( - $spatial, - 9, - mb_strlen($spatial) - 11 - ); - - // Separate outer and inner polygons - $parts = explode("),(", $polygon); - $row .= 'vectorLayer.addFeatures(new OpenLayers.Feature.Vector(' - . $this->getPolygonForOpenLayers($parts, $srid) - . ', null, ' . json_encode($style_options) . '));'; - - return $row; - } - - /** - * Draws a ring of the polygon using SVG path element. - * - * @param string $polygon The ring - * @param array $scale_data Array containing data related to scaling - * - * @return string the code to draw the ring - * @access private - */ - private function _drawPath($polygon, array $scale_data) - { - $points_arr = $this->extractPoints($polygon, $scale_data); - - $row = ' M ' . $points_arr[0][0] . ', ' . $points_arr[0][1]; - $other_points = array_slice($points_arr, 1, count($points_arr) - 2); - foreach ($other_points as $point) { - $row .= ' L ' . $point[0] . ', ' . $point[1]; - } - $row .= ' Z '; - - return $row; - } - - /** - * Generate the WKT with the set of parameters passed by the GIS editor. - * - * @param array $gis_data GIS data - * @param int $index Index into the parameter object - * @param string $empty Value for empty points - * - * @return string WKT with the set of parameters passed by the GIS editor - * @access public - */ - public function generateWkt(array $gis_data, $index, $empty = '') - { - $no_of_lines = isset($gis_data[$index]['POLYGON']['no_of_lines']) - ? $gis_data[$index]['POLYGON']['no_of_lines'] : 1; - if ($no_of_lines < 1) { - $no_of_lines = 1; - } - - $wkt = 'POLYGON('; - for ($i = 0; $i < $no_of_lines; $i++) { - $no_of_points = isset($gis_data[$index]['POLYGON'][$i]['no_of_points']) - ? $gis_data[$index]['POLYGON'][$i]['no_of_points'] : 4; - if ($no_of_points < 4) { - $no_of_points = 4; - } - $wkt .= '('; - for ($j = 0; $j < $no_of_points; $j++) { - $wkt .= ((isset($gis_data[$index]['POLYGON'][$i][$j]['x']) - && trim((string) $gis_data[$index]['POLYGON'][$i][$j]['x']) != '') - ? $gis_data[$index]['POLYGON'][$i][$j]['x'] : $empty) - . ' ' . ((isset($gis_data[$index]['POLYGON'][$i][$j]['y']) - && trim((string) $gis_data[$index]['POLYGON'][$i][$j]['y']) != '') - ? $gis_data[$index]['POLYGON'][$i][$j]['y'] : $empty) . ','; - } - $wkt - = - mb_substr( - $wkt, - 0, - mb_strlen($wkt) - 1 - ); - $wkt .= '),'; - } - $wkt - = - mb_substr( - $wkt, - 0, - mb_strlen($wkt) - 1 - ); - $wkt .= ')'; - - return $wkt; - } - - /** - * Calculates the area of a closed simple polygon. - * - * @param array $ring array of points forming the ring - * - * @return float the area of a closed simple polygon - * @access public - * @static - */ - public static function area(array $ring) - { - - $no_of_points = count($ring); - - // If the last point is same as the first point ignore it - $last = count($ring) - 1; - if (($ring[0]['x'] == $ring[$last]['x']) - && ($ring[0]['y'] == $ring[$last]['y']) - ) { - $no_of_points--; - } - - // _n-1 - // A = _1_ \ (X(i) * Y(i+1)) - (Y(i) * X(i+1)) - // 2 /__ - // i=0 - $area = 0; - for ($i = 0; $i < $no_of_points; $i++) { - $j = ($i + 1) % $no_of_points; - $area += $ring[$i]['x'] * $ring[$j]['y']; - $area -= $ring[$i]['y'] * $ring[$j]['x']; - } - $area /= 2.0; - - return $area; - } - - /** - * Determines whether a set of points represents an outer ring. - * If points are in clockwise orientation then, they form an outer ring. - * - * @param array $ring array of points forming the ring - * - * @return bool whether a set of points represents an outer ring - * @access public - * @static - */ - public static function isOuterRing(array $ring) - { - // If area is negative then it's in clockwise orientation, - // i.e. it's an outer ring - return GisPolygon::area($ring) < 0; - } - - /** - * Determines whether a given point is inside a given polygon. - * - * @param array $point x, y coordinates of the point - * @param array $polygon array of points forming the ring - * - * @return bool whether a given point is inside a given polygon - * @access public - * @static - */ - public static function isPointInsidePolygon(array $point, array $polygon) - { - // If first point is repeated at the end remove it - $last = count($polygon) - 1; - if (($polygon[0]['x'] == $polygon[$last]['x']) - && ($polygon[0]['y'] == $polygon[$last]['y']) - ) { - $polygon = array_slice($polygon, 0, $last); - } - - $no_of_points = count($polygon); - $counter = 0; - - // Use ray casting algorithm - $p1 = $polygon[0]; - for ($i = 1; $i <= $no_of_points; $i++) { - $p2 = $polygon[$i % $no_of_points]; - if ($point['y'] <= min([$p1['y'], $p2['y']])) { - $p1 = $p2; - continue; - } - - if ($point['y'] > max([$p1['y'], $p2['y']])) { - $p1 = $p2; - continue; - } - - if ($point['x'] > max([$p1['x'], $p2['x']])) { - $p1 = $p2; - continue; - } - - if ($p1['y'] != $p2['y']) { - $xinters = ($point['y'] - $p1['y']) - * ($p2['x'] - $p1['x']) - / ($p2['y'] - $p1['y']) + $p1['x']; - if ($p1['x'] == $p2['x'] || $point['x'] <= $xinters) { - $counter++; - } - } - - $p1 = $p2; - } - - return $counter % 2 != 0; - } - - /** - * Returns a point that is guaranteed to be on the surface of the ring. - * (for simple closed rings) - * - * @param array $ring array of points forming the ring - * - * @return array|bool a point on the surface of the ring - * @access public - * @static - */ - public static function getPointOnSurface(array $ring) - { - $x0 = null; - $x1 = null; - $y0 = null; - $y1 = null; - // Find two consecutive distinct points. - for ($i = 0, $nb = count($ring) - 1; $i < $nb; $i++) { - if ($ring[$i]['y'] != $ring[$i + 1]['y']) { - $x0 = $ring[$i]['x']; - $x1 = $ring[$i + 1]['x']; - $y0 = $ring[$i]['y']; - $y1 = $ring[$i + 1]['y']; - break; - } - } - - if (! isset($x0)) { - return false; - } - - // Find the mid point - $x2 = ($x0 + $x1) / 2; - $y2 = ($y0 + $y1) / 2; - - // Always keep $epsilon < 1 to go with the reduction logic down here - $epsilon = 0.1; - $denominator = sqrt(pow($y1 - $y0, 2) + pow($x0 - $x1, 2)); - $pointA = []; - $pointB = []; - - while (true) { - // Get the points on either sides of the line - // with a distance of epsilon to the mid point - $pointA['x'] = $x2 + ($epsilon * ($y1 - $y0)) / $denominator; - $pointA['y'] = $y2 + ($pointA['x'] - $x2) * ($x0 - $x1) / ($y1 - $y0); - - $pointB['x'] = $x2 + ($epsilon * ($y1 - $y0)) / (0 - $denominator); - $pointB['y'] = $y2 + ($pointB['x'] - $x2) * ($x0 - $x1) / ($y1 - $y0); - - // One of the points should be inside the polygon, - // unless epsilon chosen is too large - if (GisPolygon::isPointInsidePolygon($pointA, $ring)) { - return $pointA; - } - - if (GisPolygon::isPointInsidePolygon($pointB, $ring)) { - return $pointB; - } - - //If both are outside the polygon reduce the epsilon and - //recalculate the points(reduce exponentially for faster convergence) - $epsilon = pow($epsilon, 2); - if ($epsilon == 0) { - return false; - } - } - } - - /** Generate parameters for the GIS data editor from the value of the GIS column. - * - * @param string $value Value of the GIS column - * @param int $index Index of the geometry - * - * @return array params for the GIS data editor from the value of the GIS column - * @access public - */ - public function generateParams($value, $index = -1) - { - $params = []; - if ($index == -1) { - $index = 0; - $data = GisGeometry::generateParams($value); - $params['srid'] = $data['srid']; - $wkt = $data['wkt']; - } else { - $params[$index]['gis_type'] = 'POLYGON'; - $wkt = $value; - } - - // Trim to remove leading 'POLYGON((' and trailing '))' - $polygon - = - mb_substr( - $wkt, - 9, - mb_strlen($wkt) - 11 - ); - // Separate each linestring - $linerings = explode("),(", $polygon); - $params[$index]['POLYGON']['no_of_lines'] = count($linerings); - - $j = 0; - foreach ($linerings as $linering) { - $points_arr = $this->extractPoints($linering, null); - $no_of_points = count($points_arr); - $params[$index]['POLYGON'][$j]['no_of_points'] = $no_of_points; - for ($i = 0; $i < $no_of_points; $i++) { - $params[$index]['POLYGON'][$j][$i]['x'] = $points_arr[$i][0]; - $params[$index]['POLYGON'][$j][$i]['y'] = $points_arr[$i][1]; - } - $j++; - } - - return $params; - } -} diff --git a/srcs/phpmyadmin/libraries/classes/Gis/GisVisualization.php b/srcs/phpmyadmin/libraries/classes/Gis/GisVisualization.php deleted file mode 100644 index 19f5ca8..0000000 --- a/srcs/phpmyadmin/libraries/classes/Gis/GisVisualization.php +++ /dev/null @@ -1,726 +0,0 @@ -<?php -/* vim: set expandtab sw=4 ts=4 sts=4: */ -/** - * Handles visualization of GIS data - * - * @package PhpMyAdmin-GIS - */ -declare(strict_types=1); - -namespace PhpMyAdmin\Gis; - -use PhpMyAdmin\Core; -use PhpMyAdmin\Sanitize; -use PhpMyAdmin\Util; -use TCPDF; - -/** - * Handles visualization of GIS data - * - * @package PhpMyAdmin-GIS - */ -class GisVisualization -{ - /** - * @var array Raw data for the visualization - */ - private $_data; - private $_modified_sql; - /** - * @var array Set of default settings values are here. - */ - private $_settings = [ - // Array of colors to be used for GIS visualizations. - 'colors' => [ - '#B02EE0', - '#E0642E', - '#E0D62E', - '#2E97E0', - '#BCE02E', - '#E02E75', - '#5CE02E', - '#E0B02E', - '#0022E0', - '#726CB1', - '#481A36', - '#BAC658', - '#127224', - '#825119', - '#238C74', - '#4C489B', - '#87C9BF', - ], - // The width of the GIS visualization. - 'width' => 600, - // The height of the GIS visualization. - 'height' => 450, - ]; - /** - * @var array Options that the user has specified. - */ - private $_userSpecifiedSettings = null; - - /** - * Returns the settings array - * - * @return array the settings array - * @access public - */ - public function getSettings() - { - return $this->_settings; - } - - /** - * Factory - * - * @param string $sql_query SQL to fetch raw data for visualization - * @param array $options Users specified options - * @param integer $row number of rows - * @param integer $pos start position - * - * @return GisVisualization - * - * @access public - */ - public static function get($sql_query, array $options, $row, $pos) - { - return new GisVisualization($sql_query, $options, $row, $pos); - } - - /** - * Get visualization - * - * @param array $data Raw data, if set, parameters other than $options will be - * ignored - * @param array $options Users specified options - * - * @return GisVisualization - */ - public static function getByData(array $data, array $options) - { - return new GisVisualization(null, $options, null, null, $data); - } - - /** - * Check if data has SRID - * - * @return bool - */ - public function hasSrid() - { - foreach ($this->_data as $row) { - if ($row['srid'] != 0) { - return true; - } - } - - return false; - } - - /** - * Constructor. Stores user specified options. - * - * @param string $sql_query SQL to fetch raw data for visualization - * @param array $options Users specified options - * @param integer $row number of rows - * @param integer $pos start position - * @param array|null $data raw data. If set, parameters other than $options - * will be ignored - * - * @access public - */ - private function __construct($sql_query, array $options, $row, $pos, $data = null) - { - $this->_userSpecifiedSettings = $options; - if (isset($data)) { - $this->_data = $data; - } else { - $this->_modified_sql = $this->_modifySqlQuery($sql_query, $row, $pos); - $this->_data = $this->_fetchRawData(); - } - } - - /** - * All the variable initialization, options handling has to be done here. - * - * @return void - * @access protected - */ - protected function init() - { - $this->_handleOptions(); - } - - /** - * Returns sql for fetching raw data - * - * @param string $sql_query The SQL to modify. - * @param integer $rows Number of rows. - * @param integer $pos Start position. - * - * @return string the modified sql query. - */ - private function _modifySqlQuery($sql_query, $rows, $pos) - { - $modified_query = 'SELECT '; - $spatialAsText = 'ASTEXT'; - $spatialSrid = 'SRID'; - - if ($this->_userSpecifiedSettings['mysqlVersion'] >= 50600) { - $spatialAsText = 'ST_ASTEXT'; - $spatialSrid = 'ST_SRID'; - } - - // If label column is chosen add it to the query - if (! empty($this->_userSpecifiedSettings['labelColumn'])) { - $modified_query .= Util::backquote( - $this->_userSpecifiedSettings['labelColumn'] - ) - . ', '; - } - // Wrap the spatial column with 'ST_ASTEXT()' function and add it - $modified_query .= $spatialAsText . '(' - . Util::backquote($this->_userSpecifiedSettings['spatialColumn']) - . ') AS ' . Util::backquote( - $this->_userSpecifiedSettings['spatialColumn'] - ) - . ', '; - - // Get the SRID - $modified_query .= $spatialSrid . '(' - . Util::backquote($this->_userSpecifiedSettings['spatialColumn']) - . ') AS ' . Util::backquote('srid') . ' '; - - // Append the original query as the inner query - $modified_query .= 'FROM (' . $sql_query . ') AS ' - . Util::backquote('temp_gis'); - - // LIMIT clause - if (is_numeric($rows) && $rows > 0) { - $modified_query .= ' LIMIT '; - if (is_numeric($pos) && $pos >= 0) { - $modified_query .= $pos . ', ' . $rows; - } else { - $modified_query .= $rows; - } - } - - return $modified_query; - } - - /** - * Returns raw data for GIS visualization. - * - * @return array the raw data. - */ - private function _fetchRawData() - { - $modified_result = $GLOBALS['dbi']->tryQuery($this->_modified_sql); - - if ($modified_result === false) { - return []; - } - - $data = []; - while ($row = $GLOBALS['dbi']->fetchAssoc($modified_result)) { - $data[] = $row; - } - - return $data; - } - - /** - * A function which handles passed parameters. Useful if desired - * chart needs to be a little bit different from the default one. - * - * @return void - * @access private - */ - private function _handleOptions() - { - if ($this->_userSpecifiedSettings !== null) { - $this->_settings = array_merge( - $this->_settings, - $this->_userSpecifiedSettings - ); - } - } - - /** - * Sanitizes the file name. - * - * @param string $file_name file name - * @param string $ext extension of the file - * - * @return string the sanitized file name - * @access private - */ - private function _sanitizeName($file_name, $ext) - { - $file_name = Sanitize::sanitizeFilename($file_name); - - // Check if the user already added extension; - // get the substring where the extension would be if it was included - $extension_start_pos = mb_strlen($file_name) - mb_strlen($ext) - 1; - $user_extension - = mb_substr( - $file_name, - $extension_start_pos, - mb_strlen($file_name) - ); - $required_extension = "." . $ext; - if (mb_strtolower($user_extension) != $required_extension) { - $file_name .= $required_extension; - } - - return $file_name; - } - - /** - * Handles common tasks of writing the visualization to file for various formats. - * - * @param string $file_name file name - * @param string $type mime type - * @param string $ext extension of the file - * - * @return void - * @access private - */ - private function _toFile($file_name, $type, $ext) - { - $file_name = $this->_sanitizeName($file_name, $ext); - Core::downloadHeader($file_name, $type); - } - - /** - * Generate the visualization in SVG format. - * - * @return string the generated image resource - * @access private - */ - private function _svg() - { - $this->init(); - - $output = '<?xml version="1.0" encoding="UTF-8" standalone="no"?>' - . "\n" - . '<svg version="1.1" xmlns:svg="http://www.w3.org/2000/svg"' - . ' xmlns="http://www.w3.org/2000/svg"' - . ' width="' . intval($this->_settings['width']) . '"' - . ' height="' . intval($this->_settings['height']) . '">' - . '<g id="groupPanel">'; - - $scale_data = $this->_scaleDataSet($this->_data); - $output .= $this->_prepareDataSet($this->_data, $scale_data, 'svg', ''); - - $output .= '</g></svg>'; - - return $output; - } - - /** - * Get the visualization as a SVG. - * - * @return string the visualization as a SVG - * @access public - */ - public function asSVG() - { - return $this->_svg(); - } - - /** - * Saves as a SVG image to a file. - * - * @param string $file_name File name - * - * @return void - * @access public - */ - public function toFileAsSvg($file_name) - { - $img = $this->_svg(); - $this->_toFile($file_name, 'image/svg+xml', 'svg'); - echo($img); - } - - /** - * Generate the visualization in PNG format. - * - * @return resource the generated image resource - * @access private - */ - private function _png() - { - $this->init(); - - // create image - $image = imagecreatetruecolor( - $this->_settings['width'], - $this->_settings['height'] - ); - - // fill the background - $bg = imagecolorallocate($image, 229, 229, 229); - imagefilledrectangle( - $image, - 0, - 0, - $this->_settings['width'] - 1, - $this->_settings['height'] - 1, - $bg - ); - - $scale_data = $this->_scaleDataSet($this->_data); - $image = $this->_prepareDataSet($this->_data, $scale_data, 'png', $image); - - return $image; - } - - /** - * Get the visualization as a PNG. - * - * @return string the visualization as a PNG - * @access public - */ - public function asPng() - { - $img = $this->_png(); - - // render and save it to variable - ob_start(); - imagepng($img, null, 9, PNG_ALL_FILTERS); - imagedestroy($img); - $output = ob_get_contents(); - ob_end_clean(); - - // base64 encode - $encoded = base64_encode($output); - - return '<img src="data:image/png;base64,' . $encoded . '">'; - } - - /** - * Saves as a PNG image to a file. - * - * @param string $file_name File name - * - * @return void - * @access public - */ - public function toFileAsPng($file_name) - { - $img = $this->_png(); - $this->_toFile($file_name, 'image/png', 'png'); - imagepng($img, null, 9, PNG_ALL_FILTERS); - imagedestroy($img); - } - - /** - * Get the code for visualization with OpenLayers. - * - * @todo Should return JSON to avoid eval() in gis_data_editor.js - * - * @return string the code for visualization with OpenLayers - * @access public - */ - public function asOl() - { - $this->init(); - $scale_data = $this->_scaleDataSet($this->_data); - $output - = 'if (typeof OpenLayers !== "undefined") {' - . 'var options = {' - . 'projection: new OpenLayers.Projection("EPSG:900913"),' - . 'displayProjection: new OpenLayers.Projection("EPSG:4326"),' - . 'units: "m",' - . 'numZoomLevels: 18,' - . 'maxResolution: 156543.0339,' - . 'maxExtent: new OpenLayers.Bounds(' - . '-20037508, -20037508, 20037508, 20037508),' - . 'restrictedExtent: new OpenLayers.Bounds(' - . '-20037508, -20037508, 20037508, 20037508)' - . '};' - . 'var map = new OpenLayers.Map("openlayersmap", options);' - . 'var layerNone = new OpenLayers.Layer.Boxes(' - . '"None", {isBaseLayer: true});' - . 'var layerOSM = new OpenLayers.Layer.OSM("OSM",' - . '[' - . '"https://a.tile.openstreetmap.org/${z}/${x}/${y}.png",' - . '"https://b.tile.openstreetmap.org/${z}/${x}/${y}.png",' - . '"https://c.tile.openstreetmap.org/${z}/${x}/${y}.png"' - . ']);' - . 'map.addLayers([layerOSM,layerNone]);' - . 'var vectorLayer = new OpenLayers.Layer.Vector("Data");' - . 'var bound;'; - $output .= $this->_prepareDataSet($this->_data, $scale_data, 'ol', ''); - $output .= 'map.addLayer(vectorLayer);' - . 'map.zoomToExtent(bound);' - . 'if (map.getZoom() < 2) {' - . 'map.zoomTo(2);' - . '}' - . 'map.addControl(new OpenLayers.Control.LayerSwitcher());' - . 'map.addControl(new OpenLayers.Control.MousePosition());' - . '}'; - - return $output; - } - - /** - * Saves as a PDF to a file. - * - * @param string $file_name File name - * - * @return void - * @access public - */ - public function toFileAsPdf($file_name) - { - $this->init(); - - // create pdf - $pdf = new TCPDF( - '', - 'pt', - $GLOBALS['cfg']['PDFDefaultPageSize'], - true, - 'UTF-8', - false - ); - - // disable header and footer - $pdf->setPrintHeader(false); - $pdf->setPrintFooter(false); - - //set auto page breaks - $pdf->SetAutoPageBreak(false); - - // add a page - $pdf->AddPage(); - - $scale_data = $this->_scaleDataSet($this->_data); - $pdf = $this->_prepareDataSet($this->_data, $scale_data, 'pdf', $pdf); - - // sanitize file name - $file_name = $this->_sanitizeName($file_name, 'pdf'); - $pdf->Output($file_name, 'D'); - } - - /** - * Convert file to image - * - * @param string $format Output format - * - * @return string File - */ - public function toImage($format) - { - if ($format == 'svg') { - return $this->asSVG(); - } elseif ($format == 'png') { - return $this->asPng(); - } elseif ($format == 'ol') { - return $this->asOl(); - } - } - - /** - * Convert file to given format - * - * @param string $filename Filename - * @param string $format Output format - * - * @return void - */ - public function toFile($filename, $format) - { - if ($format == 'svg') { - $this->toFileAsSvg($filename); - } elseif ($format == 'png') { - $this->toFileAsPng($filename); - } elseif ($format == 'pdf') { - $this->toFileAsPdf($filename); - } - } - - /** - * Calculates the scale, horizontal and vertical offset that should be used. - * - * @param array $data Row data - * - * @return array an array containing the scale, x and y offsets - * @access private - */ - private function _scaleDataSet(array $data) - { - $min_max = [ - 'maxX' => 0.0, - 'maxY' => 0.0, - 'minX' => 0.0, - 'minY' => 0.0, - ]; - $border = 15; - // effective width and height of the plot - $plot_width = $this->_settings['width'] - 2 * $border; - $plot_height = $this->_settings['height'] - 2 * $border; - - foreach ($data as $row) { - // Figure out the data type - $ref_data = $row[$this->_settings['spatialColumn']]; - $type_pos = mb_strpos($ref_data, '('); - if ($type_pos === false) { - continue; - } - $type = mb_substr($ref_data, 0, $type_pos); - - $gis_obj = GisFactory::factory($type); - if (! $gis_obj) { - continue; - } - $scale_data = $gis_obj->scaleRow( - $row[$this->_settings['spatialColumn']] - ); - - // Update minimum/maximum values for x and y coordinates. - $c_maxX = (float) $scale_data['maxX']; - if ($min_max['maxX'] === 0.0 || $c_maxX > $min_max['maxX']) { - $min_max['maxX'] = $c_maxX; - } - - $c_minX = (float) $scale_data['minX']; - if ($min_max['minX'] === 0.0 || $c_minX < $min_max['minX']) { - $min_max['minX'] = $c_minX; - } - - $c_maxY = (float) $scale_data['maxY']; - if ($min_max['maxY'] === 0.0 || $c_maxY > $min_max['maxY']) { - $min_max['maxY'] = $c_maxY; - } - - $c_minY = (float) $scale_data['minY']; - if ($min_max['minY'] === 0.0 || $c_minY < $min_max['minY']) { - $min_max['minY'] = $c_minY; - } - } - - // scale the visualization - $x_ratio = ($min_max['maxX'] - $min_max['minX']) / $plot_width; - $y_ratio = ($min_max['maxY'] - $min_max['minY']) / $plot_height; - $ratio = ($x_ratio > $y_ratio) ? $x_ratio : $y_ratio; - - $scale = ($ratio != 0) ? (1 / $ratio) : 1; - - if ($x_ratio < $y_ratio) { - // center horizontally - $x = ($min_max['maxX'] + $min_max['minX'] - $plot_width / $scale) / 2; - // fit vertically - $y = $min_max['minY'] - ($border / $scale); - } else { - // fit horizontally - $x = $min_max['minX'] - ($border / $scale); - // center vertically - $y = ($min_max['maxY'] + $min_max['minY'] - $plot_height / $scale) / 2; - } - - return [ - 'scale' => $scale, - 'x' => $x, - 'y' => $y, - 'minX' => $min_max['minX'], - 'maxX' => $min_max['maxX'], - 'minY' => $min_max['minY'], - 'maxY' => $min_max['maxY'], - 'height' => $this->_settings['height'], - ]; - } - - /** - * Prepares and return the dataset as needed by the visualization. - * - * @param array $data Raw data - * @param array $scale_data Data related to scaling - * @param string $format Format of the visualization - * @param object $results Image object in the case of png - * TCPDF object in the case of pdf - * - * @return mixed the formatted array of data - * @access private - */ - private function _prepareDataSet(array $data, array $scale_data, $format, $results) - { - $color_number = 0; - - // loop through the rows - foreach ($data as $row) { - $index = $color_number % count($this->_settings['colors']); - - // Figure out the data type - $ref_data = $row[$this->_settings['spatialColumn']]; - $type_pos = mb_strpos($ref_data, '('); - if ($type_pos === false) { - continue; - } - $type = mb_substr($ref_data, 0, $type_pos); - - $gis_obj = GisFactory::factory($type); - if (! $gis_obj) { - continue; - } - $label = ''; - if (isset($this->_settings['labelColumn']) - && isset($row[$this->_settings['labelColumn']]) - ) { - $label = $row[$this->_settings['labelColumn']]; - } - - if ($format == 'svg') { - $results .= $gis_obj->prepareRowAsSvg( - $row[$this->_settings['spatialColumn']], - $label, - $this->_settings['colors'][$index], - $scale_data - ); - } elseif ($format == 'png') { - $results = $gis_obj->prepareRowAsPng( - $row[$this->_settings['spatialColumn']], - $label, - $this->_settings['colors'][$index], - $scale_data, - $results - ); - } elseif ($format == 'pdf') { - $results = $gis_obj->prepareRowAsPdf( - $row[$this->_settings['spatialColumn']], - $label, - $this->_settings['colors'][$index], - $scale_data, - $results - ); - } elseif ($format == 'ol') { - $results .= $gis_obj->prepareRowAsOl( - $row[$this->_settings['spatialColumn']], - $row['srid'], - $label, - $this->_settings['colors'][$index], - $scale_data - ); - } - $color_number++; - } - - return $results; - } - - /** - * Set user specified settings - * - * @param array $userSpecifiedSettings User specified settings - * - * @return void - */ - public function setUserSpecifiedSettings(array $userSpecifiedSettings) - { - $this->_userSpecifiedSettings = $userSpecifiedSettings; - } -} |
