libraries/gis/pma_gis_point.php

   1 <?php
   2 /**
   3  * Handles the visualization of GIS POINT objects.
   4  *
   5  * @package PhpMyAdmin-GIS
   6  */
   7 class PMA_GIS_Point extends PMA_GIS_Geometry
   8 {
   9     // Hold the singleton instance of the class
  10     private static $_instance;
  11
  12     /**
  13      * A private constructor; prevents direct creation of object.
  14      */
  15     private function __construct()
  16     {
  17     }
  18
  19     /**
  20      * Returns the singleton.
  21      *
  22      * @return the singleton
  23      */
  24     public static function singleton()
  25     {
  26         if (!isset(self::$_instance)) {
  27             $class = __CLASS__;
  28             self::$_instance = new $class;
  29         }
  30
  31         return self::$_instance;
  32     }
  33
  34     /**
  35      * Scales each row.
  36      *
  37      * @param string $spatial spatial data of a row
  38      *
  39      * @return array containing the min, max values for x and y cordinates
  40      */
  41     public function scaleRow($spatial)
  42     {
  43         // Trim to remove leading 'POINT(' and trailing ')'
  44         $point = substr($spatial, 6, (strlen($spatial) - 7));
  45         return $this->setMinMax($point, array());
  46     }
  47
  48     /**
  49      * Adds to the PNG image object, the data related to a row in the GIS dataset.
  50      *
  51      * @param string $spatial     GIS POINT object
  52      * @param string $label       Label for the GIS POINT object
  53      * @param string $point_color Color for the GIS POINT object
  54      * @param array  $scale_data  Array containing data related to scaling
  55      * @param image  $image       Image object
  56      *
  57      * @return the modified image object
  58      */
  59     public function prepareRowAsPng($spatial, $label, $point_color, $scale_data, $image)
  60     {
  61         // allocate colors
  62         $black = imagecolorallocate($image, 0, 0, 0);
  63         $red   = hexdec(substr($point_color, 1, 2));
  64         $green = hexdec(substr($point_color, 3, 2));
  65         $blue  = hexdec(substr($point_color, 4, 2));
  66         $color = imagecolorallocate($image, $red, $green, $blue);
  67
  68         // Trim to remove leading 'POINT(' and trailing ')'
  69         $point = substr($spatial, 6, (strlen($spatial) - 7));
  70         $points_arr = $this->extractPoints($point, $scale_data);
  71
  72         // draw a small circle to mark the point
  73         if ($points_arr[0][0] != '' && $points_arr[0][1] != '') {
  74             imagearc($image, $points_arr[0][0], $points_arr[0][1], 7, 7, 0, 360, $color);
  75             // print label if applicable
  76             if (isset($label) && trim($label) != '') {
  77                 imagestring($image, 1, $points_arr[0][0], $points_arr[0][1], trim($label), $black);
  78             }
  79         }
  80         return $image;
  81     }
  82
  83     /**
  84      * Adds to the TCPDF instance, the data related to a row in the GIS dataset.
  85      *
  86      * @param string $spatial     GIS POINT object
  87      * @param string $label       Label for the GIS POINT object
  88      * @param string $point_color Color for the GIS POINT object
  89      * @param array  $scale_data  Array containing data related to scaling
  90      * @param image  $pdf         TCPDF instance
  91      *
  92      * @return the modified TCPDF instance
  93      */
  94     public function prepareRowAsPdf($spatial, $label, $point_color, $scale_data, $pdf)
  95     {
  96         // allocate colors
  97         $red   = hexdec(substr($point_color, 1, 2));
  98         $green = hexdec(substr($point_color, 3, 2));
  99         $blue  = hexdec(substr($point_color, 4, 2));
 100         $line  = array('width' => 1.25, 'color' => array($red, $green, $blue));
 101
 102         // Trim to remove leading 'POINT(' and trailing ')'
 103         $point = substr($spatial, 6, (strlen($spatial) - 7));
 104         $points_arr = $this->extractPoints($point, $scale_data);
 105
 106         // draw a small circle to mark the point
 107         if ($points_arr[0][0] != '' && $points_arr[0][1] != '') {
 108             $pdf->Circle($points_arr[0][0], $points_arr[0][1], 2, 0, 360, 'D', $line);
 109             // print label if applicable
 110             if (isset($label) && trim($label) != '') {
 111                 $pdf->SetXY($points_arr[0][0], $points_arr[0][1]);
 112                 $pdf->SetFontSize(5);
 113                 $pdf->Cell(0, 0, trim($label));
 114             }
 115         }
 116         return $pdf;
 117     }
 118
 119     /**
 120      * Prepares and returns the code related to a row in the GIS dataset as SVG.
 121      *
 122      * @param string $spatial     GIS POINT object
 123      * @param string $label       Label for the GIS POINT object
 124      * @param string $point_color Color for the GIS POINT object
 125      * @param array  $scale_data  Array containing data related to scaling
 126      *
 127      * @return the code related to a row in the GIS dataset
 128      */
 129     public function prepareRowAsSvg($spatial, $label, $point_color, $scale_data)
 130     {
 131         $point_options = array(
 132             'name'        => $label,
 133             'id'          => $label . rand(),
 134             'class'       => 'point vector',
 135             'fill'        => 'white',
 136             'stroke'      => $point_color,
 137             'stroke-width'=> 2,
 138         );
 139
 140         // Trim to remove leading 'POINT(' and trailing ')'
 141         $point = substr($spatial, 6, (strlen($spatial) - 7));
 142         $points_arr = $this->extractPoints($point, $scale_data);
 143
 144         $row = '';
 145         if ($points_arr[0][0] != '' && $points_arr[0][1] != '') {
 146             $row .= '<circle cx="' . $points_arr[0][0] . '" cy="' . $points_arr[0][1] . '" r="3"';
 147             foreach ($point_options as $option => $val) {
 148                 $row .= ' ' . $option . '="' . trim($val) . '"';
 149             }
 150             $row .= '/>';
 151         }
 152
 153         return $row;
 154     }
 155
 156     /**
 157      * Prepares JavaScript related to a row in the GIS dataset
 158      * to visualize it with OpenLayers.
 159      *
 160      * @param string $spatial     GIS POINT object
 161      * @param int    $srid        Spatial reference ID
 162      * @param string $label       Label for the GIS POINT object
 163      * @param string $point_color Color for the GIS POINT object
 164      * @param array  $scale_data  Array containing data related to scaling
 165      *
 166      * @return JavaScript related to a row in the GIS dataset
 167      */
 168     public function prepareRowAsOl($spatial, $srid, $label, $point_color, $scale_data)
 169     {
 170         $style_options = array(
 171             'pointRadius'  => 3,
 172             'fillColor'    => '#ffffff',
 173             'strokeColor'  => $point_color,
 174             'strokeWidth'  => 2,
 175             'label'        => $label,
 176             'labelYOffset' => -8,
 177             'fontSize'     => 10,
 178         );
 179         if ($srid == 0) {
 180             $srid = 4326;
 181         }
 182         $result = $this->getBoundsForOl($srid, $scale_data);
 183
 184         // Trim to remove leading 'POINT(' and trailing ')'
 185         $point = substr($spatial, 6, (strlen($spatial) - 7));
 186         $points_arr = $this->extractPoints($point, null);
 187
 188         if ($points_arr[0][0] != '' && $points_arr[0][1] != '') {
 189             $result .= 'vectorLayer.addFeatures(new OpenLayers.Feature.Vector(('
 190                 . 'new OpenLayers.Geometry.Point(' . $points_arr[0][0] . ', '
 191                 . $points_arr[0][1] . ').transform(new OpenLayers.Projection("EPSG:'
 192                 . $srid . '"), map.getProjectionObject())), null, '
 193                 . json_encode($style_options) . '));';
 194         }
 195         return $result;
 196     }
 197
 198     /**
 199      * Generate the WKT with the set of parameters passed by the GIS editor.
 200      *
 201      * @param array  $gis_data GIS data
 202      * @param int    $index    Index into the parameter object
 203      * @param string $empty    Point deos not adhere to this parameter
 204      *
 205      * @return WKT with the set of parameters passed by the GIS editor
 206      */
 207     public function generateWkt($gis_data, $index, $empty = '')
 208     {
 209          return 'POINT('
 210              . ((isset($gis_data[$index]['POINT']['x']) && trim($gis_data[$index]['POINT']['x']) != '')
 211              ? $gis_data[$index]['POINT']['x'] : '') . ' '
 212              . ((isset($gis_data[$index]['POINT']['y']) && trim($gis_data[$index]['POINT']['y']) != '')
 213              ? $gis_data[$index]['POINT']['y'] : '') . ')';
 214     }
 215
 216     /**
 217      * Generate the WKT for the data from ESRI shape files.
 218      *
 219      * @param array $row_data GIS data
 220      *
 221      * @return the WKT for the data from ESRI shape files
 222      */
 223     public function getShape($row_data)
 224     {
 225         return 'POINT(' . (isset($row_data['x']) ? $row_data['x'] : '')
 226              . ' ' . (isset($row_data['y']) ? $row_data['y'] : '') . ')';
 227     }
 228
 229     /**
 230      * Generate parameters for the GIS data editor from the value of the GIS column.
 231      *
 232      * @param string $value of the GIS column
 233      * @param index  $index of the geometry
 234      *
 235      * @return  parameters for the GIS data editor from the value of the GIS column
 236      */
 237     public function generateParams($value, $index = -1)
 238     {
 239         if ($index == -1) {
 240             $index = 0;
 241             $params = array();
 242             $data = PMA_GIS_Geometry::generateParams($value);
 243             $params['srid'] = $data['srid'];
 244             $wkt = $data['wkt'];
 245         } else {
 246             $params[$index]['gis_type'] = 'POINT';
 247             $wkt = $value;
 248         }
 249
 250         // Trim to remove leading 'POINT(' and trailing ')'
 251         $point = substr($wkt, 6, (strlen($wkt) - 7));
 252         $points_arr = $this->extractPoints($point, null);
 253
 254         $params[$index]['POINT']['x'] = $points_arr[0][0];
 255         $params[$index]['POINT']['y'] = $points_arr[0][1];
 256
 257         return $params;
 258     }
 259 }
 260 ?>