class.gmapsMap.php

Vai alla documentazione di questo file.

<?php
class gmapsMap extends propertyObject {

    public static $_tbl_map = "gmaps_map";
    public static $_tbl_map_point = "gmaps_map_point";
    public static $_tbl_map_polyline = "gmaps_map_polyline";
    public static $_tbl_map_polygon = "gmaps_map_polygon";

        private $_controller;

        private $_points, $_points_id;

        private $_polylines, $_polylines_id;

        private $_polygons, $_polygons_id;

        function __construct($id, $instance) {
        
                $this->_controller = $instance;

                $this->_tbl_data = self::$_tbl_map;
                parent::__construct($id);
                $this->_points = array();
                $this->_points_id = array();
                $this->_polylines = array();
                $this->_polylines_id = array();
                $this->_polygons = array();
                $this->_polygons_id = array();
                $query = "SELECT point_id FROM ".self::$_tbl_map_point." WHERE map_id='".$this->id."'";
                $a = $this->_db->selectquery($query);
                if(count($a)) {
                        foreach($a as $b) {
                                $this->_points[] = new gmapsPoint($b['point_id'], $this->_controller);  
                                $this->_points_id[] = $b['point_id'];   
                        }
                }
                $query = "SELECT polyline_id FROM ".self::$_tbl_map_polyline." WHERE map_id='".$this->id."'";
                $a = $this->_db->selectquery($query);
                if(count($a)) {
                        foreach($a as $b) {
                                $this->_polylines[] = new gmapsPolyline($b['polyline_id'], $this->_controller); 
                                $this->_polylines_id[] = $b['polyline_id'];     
                        }
                }
                $query = "SELECT polygon_id FROM ".self::$_tbl_map_polygon." WHERE map_id='".$this->id."'";
                $a = $this->_db->selectquery($query);
                if(count($a)) {
                        foreach($a as $b) {
                                $this->_polygons[] = new gmapsPolygon($b['polygon_id'], $this->_controller);    
                                $this->_polygons_id[] = $b['polygon_id'];       
                        }
                }
        }
        
        public function setInstance($value) {
                
                if($this->_p['instance']!=$value && !in_array('instance', $this->_chgP)) $this->_chgP[] = 'instance';
                $this->_p['instance'] = $value;
                return true;
        
        }

        public static function deleteInstance($instance) {

                $db = db::instance();
                $query = "DELETE FROM ".self::$_tbl_map." WHERE instance='$instance'";
                $res = $db->actionquery($query);

                return $res;

        }

        public function points_id() {

                return $this->_points_id;

        }

        public function points() {

                return $this->_points;

        }

        public function polylines_id() {

                return $this->_polylines_id;

        }

        public function polylines() {

                return $this->_polylines;

        }

        public function polygons_id() {

                return $this->_polygons_id;

        }

        public function polygons() {

                return $this->_polygons;

        }


        public function addPoints($point_ids) {

                if(!is_array($point_ids)) $points = array($point_ids);

                $values = array();
                foreach($point_ids as $pid) {
                        $values[] = "('".$this->id."', '".$pid."')";
                }
                
                $db = db::instance();
                $query = "INSERT INTO ".self::$_tbl_map_point." (map_id, point_id) VALUES ".implode(',', $values).";";

                return $db->actionquery($query);
        }

        public function addPolylines($polyline_ids) {

                if(!is_array($polyline_ids)) $points = array($polyline_ids);

                $values = array();
                foreach($polyline_ids as $pid) {
                        $values[] = "('".$this->id."', '".$pid."')";
                }
                
                $db = db::instance();
                $query = "INSERT INTO ".self::$_tbl_map_polyline." (map_id, polyline_id) VALUES ".implode(',', $values).";";

                return $db->actionquery($query);
        }

        public function addPolygons($polygon_ids) {

                if(!is_array($polygon_ids)) $points = array($polygon_ids);

                $values = array();
                foreach($polygon_ids as $pid) {
                        $values[] = "('".$this->id."', '".$pid."')";
                }
                
                $db = db::instance();
                $query = "INSERT INTO ".self::$_tbl_map_polygon." (map_id, polygon_id) VALUES ".implode(',', $values).";";

                return $db->actionquery($query);
        }


        public function removePoints($point_ids) {

                if(!is_array($point_ids)) $points = array($point_ids);

                $values = array();
                foreach($point_ids as $pid) {
                        $values[] = "point_id='".$pid."'";
                }
                
                $db = db::instance();
                $query = "DELETE FROM ".self::$_tbl_map_point." WHERE map_id='".$this->id."' AND (".implode(" OR ", $values).")";

                return $db->actionquery($query);
        }

        public function removePolylines($polyline_ids) {

                if(!is_array($polyline_ids)) $points = array($polyline_ids);

                $values = array();
                foreach($polyline_ids as $pid) {
                        $values[] = "polyline_id='".$pid."'";
                }
                
                $db = db::instance();
                $query = "DELETE FROM ".self::$_tbl_map_polyline." WHERE map_id='".$this->id."' AND (".implode(" OR ", $values).")";

                return $db->actionquery($query);
        }

        public function removePolygons($polygon_ids) {

                if(!is_array($polygon_ids)) $points = array($polygon_ids);

                $values = array();
                foreach($polygon_ids as $pid) {
                        $values[] = "polygon_id='".$pid."'";
                }
                
                $db = db::instance();
                $query = "DELETE FROM ".self::$_tbl_map_polygon." WHERE map_id='".$this->id."' AND (".implode(" OR ", $values).")";

                return $db->actionquery($query);
        }


        public static function get($instance, $opts=null) {

                $where = "instance='".$instance."'".((isset($opts['where']) && $opts['where']) ? " AND ".$opts['where'] : '');
                $order = isset($opts['order']) ? $opts['order'] : 'name';
                $limit = isset($opts['limit']) ? "LIMIT ".$opts['limit'] : '';

                $res = array();

                $db = db::instance();
                $query = "SELECT id FROM ".self::$_tbl_map." WHERE $where ORDER BY $order $limit";
                $a = $db->selectquery($query);
                foreach($a as $b) {
                        $res[] = $b['id'];
                }

                return $res;

        }

        public function form($redirect) {

                if(isset($_POST['submit'])) {
                        $gform = new Form('form_map', 'post', false, array('verifyToken'=>true));
                        $gform->save('dataform');
                        $req_error = $gform->arequired();       
                        if(!$req_error) {
                                $this->name = cleanVar($_POST, 'name', 'string', '');
                                $this->description = cleanVarEditor($_POST, 'description', '');
                                $this->width = cleanVar($_POST, 'width', 'string', '');
                                $this->height = cleanVar($_POST, 'height', 'string', '');
                                $this->updateDbData();
                                header("Location: ".$redirect);
                                exit();
                        }
                        else {
                                exit(error::errorMessage(array('error'=>1), $_SERVER['QUERY_STRING']));
                        }
                }

                if($this->id) {
                        $title = _("Modifica mappa");
                        $submit = _("modifica");
                }
                else {
                        $title = _("Nuova mappa");
                        $submit= _("inserisci");
                }
                $htmlsection = new htmlSection(array('class'=>'admin', 'headerTag'=>'header', 'headerLabel'=>$title));

                $gform = new Form('form_map', 'post', true, array('trnsl_table'=>$this->_tbl_data, 'trnsl_id'=>$this->id));
                $gform->load('dataform');
                $required = "name,width,height";
                $buffer = $gform->form('', false, $required, array('generateToken'=>true));
                $buffer .= $gform->hidden('id', $this->id);

                $buffer .= $gform->cinput('name', 'text', $gform->retvar('name', htmlInput($this->name)), _("Nome"), array('required'=>true, 'maxlength'=>200, 'size'=>40, 'trnsl'=>true, 'field'=>'name'));
                $buffer .= $gform->fcktextarea('description', $gform->retvar('description', htmlInputEditor($this->description)), _("Descrizione"), array('fck_toolbar'=>"Default", 'trnsl'=>true, 'field'=>'description'));
                $buffer .= $gform->cinput('width', 'text', $gform->retvar('width', htmlInput($this->width)), array(_("Larghezza"), _("in px o percentuale<br />es: 500px, 98%")), array('required'=>true, 'maxlength'=>32, 'size'=>6));
                $buffer .= $gform->cinput('height', 'text', $gform->retvar('height', htmlInput($this->height)), array(_("Altezza"), _("in px o percentuale<br />es: 500px, 98%")), array('required'=>true, 'maxlength'=>32, 'size'=>6));
                $buffer .= $gform->cinput('submit', 'submit', $submit, '', array('classField'=>'submit'));

                $buffer .= $gform->cform();

                $htmlsection->content = $buffer;

                return $htmlsection->render();

        }

        public function delete() {

                $db = db::instance();

                // delete point associations
                $query = "DELETE FROM ".self::$_tbl_map_point." WHERE map_id='".$this->id."'";
                $res = $db->actionquery($query);

                // delete polyline associations
                $query = "DELETE FROM ".self::$_tbl_map_polyline." WHERE map_id='".$this->id."'";
                $res = $db->actionquery($query);

                return $this->deleteDbData();

        }

}

?>