phpmyadmin/libraries/gis/pma_gis_geometry.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * Base class for all GIS data type classes
   5  *
   6  * @package PhpMyAdmin-GIS
   7  */
   8
   9 if (! defined('PHPMYADMIN')) {
  10     exit;
  11 }
  12
  13 /**
  14  * Base class for all GIS data type classes.
  15  *
  16  * @package PhpMyAdmin-GIS
  17  */
  18 abstract class PMA_GIS_Geometry
  19 {
  20     /**
  21      * Prepares and returns the code related to a row in the GIS dataset as SVG.
  22      *
  23      * @param string $spatial    GIS data object
  24      * @param string $label      label for the GIS data object
  25      * @param string $color      color for the GIS data object
  26      * @param array  $scale_data data related to scaling
  27      *
  28      * @return string the code related to a row in the GIS dataset
  29      * @access public
  30      */
  31     public abstract function prepareRowAsSvg($spatial, $label, $color, $scale_data);
  32
  33     /**
  34      * Adds to the PNG image object, the data related to a row in the GIS dataset.
  35      *
  36      * @param string $spatial    GIS data object
  37      * @param string $label      label for the GIS data object
  38      * @param string $color      color for the GIS data object
  39      * @param array  $scale_data array containing data related to scaling
  40      * @param object $image      image object
  41      *
  42      * @return object the modified image object
  43      * @access public
  44      */
  45     public abstract function prepareRowAsPng($spatial, $label, $color,
  46         $scale_data, $image
  47     );
  48
  49     /**
  50      * Adds to the TCPDF instance, the data related to a row in the GIS dataset.
  51      *
  52      * @param string $spatial    GIS data object
  53      * @param string $label      label for the GIS data object
  54      * @param string $color      color for the GIS data object
  55      * @param array  $scale_data array containing data related to scaling
  56      * @param object $pdf        TCPDF instance
  57      *
  58      * @return object the modified TCPDF instance
  59      * @access public
  60      */
  61     public abstract function prepareRowAsPdf($spatial, $label, $color,
  62         $scale_data, $pdf
  63     );
  64
  65     /**
  66      * Prepares the JavaScript related to a row in the GIS dataset
  67      * to visualize it with OpenLayers.
  68      *
  69      * @param string $spatial    GIS data object
  70      * @param int    $srid       spatial reference ID
  71      * @param string $label      label for the GIS data object
  72      * @param string $color      color for the GIS data object
  73      * @param array  $scale_data array containing data related to scaling
  74      *
  75      * @return string the JavaScript related to a row in the GIS dataset
  76      * @access public
  77      */
  78     public abstract function prepareRowAsOl($spatial, $srid, $label,
  79         $color, $scale_data
  80     );
  81
  82     /**
  83      * Scales each row.
  84      *
  85      * @param string $spatial spatial data of a row
  86      *
  87      * @return array array containing the min, max values for x and y cordinates
  88      * @access public
  89      */
  90     public abstract function scaleRow($spatial);
  91
  92     /**
  93      * Generates the WKT with the set of parameters passed by the GIS editor.
  94      *
  95      * @param array  $gis_data GIS data
  96      * @param int    $index    index into the parameter object
  97      * @param string $empty    value for empty points
  98      *
  99      * @return string WKT with the set of parameters passed by the GIS editor
 100      * @access public
 101      */
 102     public abstract function generateWkt($gis_data, $index, $empty = '');
 103
 104     /**
 105      * Returns OpenLayers.Bounds object that correspond to the bounds of GIS data.
 106      *
 107      * @param string $srid       spatial reference ID
 108      * @param array  $scale_data data related to scaling
 109      *
 110      * @return string OpenLayers.Bounds object that
 111      *                correspond to the bounds of GIS data
 112      * @access protected
 113      */
 114     protected function getBoundsForOl($srid, $scale_data)
 115     {
 116         return 'bound = new OpenLayers.Bounds(); '
 117             . 'bound.extend(new OpenLayers.LonLat('
 118             . $scale_data['minX'] . ', ' . $scale_data['minY']
 119             . ').transform(new OpenLayers.Projection("EPSG:'
 120             . $srid . '"), map.getProjectionObject())); '
 121             . 'bound.extend(new OpenLayers.LonLat('
 122             . $scale_data['maxX'] . ', ' . $scale_data['maxY']
 123             . ').transform(new OpenLayers.Projection("EPSG:'
 124             . $srid . '"), map.getProjectionObject()));';
 125     }
 126
 127     /**
 128      * Updates the min, max values with the given point set.
 129      *
 130      * @param string $point_set point set
 131      * @param array  $min_max   existing min, max values
 132      *
 133      * @return array the updated min, max values
 134      * @access protected
 135      */
 136     protected function setMinMax($point_set, $min_max)
 137     {
 138         // Seperate each point
 139         $points = explode(",", $point_set);
 140
 141         foreach ($points as $point) {
 142             // Extract cordinates of the point
 143             $cordinates = explode(" ", $point);
 144
 145             $x = (float) $cordinates[0];
 146             if (! isset($min_max['maxX']) || $x > $min_max['maxX']) {
 147                 $min_max['maxX'] = $x;
 148             }
 149             if (! isset($min_max['minX']) || $x < $min_max['minX']) {
 150                 $min_max['minX'] = $x;
 151             }
 152             $y = (float) $cordinates[1];
 153             if (! isset($min_max['maxY']) || $y > $min_max['maxY']) {
 154                 $min_max['maxY'] = $y;
 155             }
 156             if (! isset($min_max['minY']) || $y < $min_max['minY']) {
 157                 $min_max['minY'] = $y;
 158             }
 159         }
 160         return $min_max;
 161     }
 162
 163     /**
 164      * Generates parameters for the GIS data editor from the value of the GIS column.
 165      * This method performs common work.
 166      * More specific work is performed by each of the geom classes.
 167      *
 168      * @param string $value value of the GIS column
 169      *
 170      * @return array parameters for the GIS editor from the value of the GIS column
 171      * @access protected
 172      */
 173     protected function generateParams($value)
 174     {
 175         $geom_types = '(POINT|MULTIPOINT|LINESTRING|MULTILINESTRING'
 176             . '|POLYGON|MULTIPOLYGON|GEOMETRYCOLLECTION)';
 177         $srid = 0;
 178         $wkt = '';
 179         if (preg_match("/^'" . $geom_types . "\(.*\)',[0-9]*$/i", $value)) {
 180             $last_comma = strripos($value, ",");
 181             $srid = trim(substr($value, $last_comma + 1));
 182             $wkt = trim(substr($value, 1, $last_comma - 2));
 183         } elseif (preg_match("/^" . $geom_types . "\(.*\)$/i", $value)) {
 184             $wkt = $value;
 185         }
 186         return array('srid' => $srid, 'wkt' => $wkt);
 187     }
 188
 189     /**
 190      * Extracts points, scales and returns them as an array.
 191      *
 192      * @param string  $point_set  string of comma sperated points
 193      * @param array   $scale_data data related to scaling
 194      * @param boolean $linear     if true, as a 1D array, else as a 2D array
 195      *
 196      * @return array scaled points
 197      * @access protected
 198      */
 199     protected function extractPoints($point_set, $scale_data, $linear = false)
 200     {
 201         $points_arr = array();
 202
 203         // Seperate each point
 204         $points = explode(",", $point_set);
 205
 206         foreach ($points as $point) {
 207             // Extract cordinates of the point
 208             $cordinates = explode(" ", $point);
 209
 210             if (isset($cordinates[0]) && trim($cordinates[0]) != ''
 211                 && isset($cordinates[1]) && trim($cordinates[1]) != ''
 212             ) {
 213                 if ($scale_data != null) {
 214                     $x = ($cordinates[0] - $scale_data['x']) * $scale_data['scale'];
 215                     $y = $scale_data['height']
 216                         - ($cordinates[1] - $scale_data['y']) * $scale_data['scale'];
 217                 } else {
 218                     $x = trim($cordinates[0]);
 219                     $y = trim($cordinates[1]);
 220                 }
 221             } else {
 222                 $x = '';
 223                 $y = '';
 224             }
 225
 226
 227             if (! $linear) {
 228                 $points_arr[] = array($x, $y);
 229             } else {
 230                 $points_arr[] = $x;
 231                 $points_arr[] = $y;
 232             }
 233         }
 234
 235         return $points_arr;
 236     }
 237
 238     /**
 239      * Generates JavaScript for adding an array of polygons to OpenLayers.
 240      *
 241      * @param array  $polygons x and y coordinates for each polygon
 242      * @param string $srid     spatial reference id
 243      *
 244      * @return string JavaScript for adding an array of polygons to OpenLayers
 245      * @access protected
 246      */
 247     protected function getPolygonArrayForOpenLayers($polygons, $srid)
 248     {
 249         $ol_array = 'new Array(';
 250         foreach ($polygons as $polygon) {
 251             $rings = explode("),(", $polygon);
 252             $ol_array .= $this->getPolygonForOpenLayers($rings, $srid) . ', ';
 253         }
 254         $ol_array = substr($ol_array, 0, strlen($ol_array) - 2);
 255         $ol_array .= ')';
 256
 257         return $ol_array;
 258     }
 259
 260     /**
 261      * Generates JavaScript for adding points for OpenLayers polygon.
 262      *
 263      * @param array  $polygon x and y coordinates for each line
 264      * @param string $srid    spatial reference id
 265      *
 266      * @return string JavaScript for adding points for OpenLayers polygon
 267      * @access protected
 268      */
 269     protected function getPolygonForOpenLayers($polygon, $srid)
 270     {
 271         return 'new OpenLayers.Geometry.Polygon('
 272             . $this->getLineArrayForOpenLayers($polygon, $srid, false)
 273             . ')';
 274     }
 275
 276     /**
 277      * Generates JavaScript for adding an array of LineString
 278      * or LineRing to OpenLayers.
 279      *
 280      * @param array  $lines          x and y coordinates for each line
 281      * @param string $srid           spatial reference id
 282      * @param bool   $is_line_string whether it's an array of LineString
 283      *
 284      * @return string JavaScript for adding an array of LineString
 285      *                or LineRing to OpenLayers
 286      * @access protected
 287      */
 288     protected function getLineArrayForOpenLayers($lines, $srid,
 289         $is_line_string = true
 290     ) {
 291         $ol_array = 'new Array(';
 292         foreach ($lines as $line) {
 293             $points_arr = $this->extractPoints($line, null);
 294             $ol_array .= $this->getLineForOpenLayers(
 295                 $points_arr, $srid, $is_line_string
 296             );
 297             $ol_array .= ', ';
 298         }
 299         $ol_array = substr($ol_array, 0, strlen($ol_array) - 2);
 300         $ol_array .= ')';
 301
 302         return $ol_array;
 303     }
 304
 305     /**
 306      * Generates JavaScript for adding a LineString or LineRing to OpenLayers.
 307      *
 308      * @param array  $points_arr     x and y coordinates for each point
 309      * @param string $srid           spatial reference id
 310      * @param bool   $is_line_string whether it's a LineString
 311      *
 312      * @return string JavaScript for adding a LineString or LineRing to OpenLayers
 313      * @access protected
 314      */
 315     protected function getLineForOpenLayers($points_arr, $srid,
 316         $is_line_string = true
 317     ) {
 318         return 'new OpenLayers.Geometry.'
 319             . ($is_line_string ? 'LineString' : 'LinearRing') . '('
 320             . $this->getPointsArrayForOpenLayers($points_arr, $srid)
 321             . ')';
 322     }
 323
 324     /**
 325      * Generates JavaScript for adding an array of points to OpenLayers.
 326      *
 327      * @param array  $points_arr x and y coordinates for each point
 328      * @param string $srid       spatial reference id
 329      *
 330      * @return string JavaScript for adding an array of points to OpenLayers
 331      * @access protected
 332      */
 333     protected function getPointsArrayForOpenLayers($points_arr, $srid)
 334     {
 335         $ol_array = 'new Array(';
 336         foreach ($points_arr as $point) {
 337             $ol_array .= $this->getPointForOpenLayers($point, $srid) . ', ';
 338         }
 339         $ol_array = substr($ol_array, 0, strlen($ol_array) - 2);
 340         $ol_array .= ')';
 341
 342         return $ol_array;
 343     }
 344
 345     /**
 346      * Generates JavaScript for adding a point to OpenLayers.
 347      *
 348      * @param array  $point array containing the x and y coordinates of the point
 349      * @param string $srid  spatial reference id
 350      *
 351      * @return string JavaScript for adding points to OpenLayers
 352      * @access protected
 353      */
 354     protected function getPointForOpenLayers($point, $srid)
 355     {
 356         return '(new OpenLayers.Geometry.Point(' . $point[0] . ',' . $point[1] . '))'
 357             . '.transform(new OpenLayers.Projection("EPSG:'
 358             . $srid . '"), map.getProjectionObject())';
 359     }
 360 }
 361 ?>