Subversion Repositories eFlore/Applications.cel

Rev

Rev 3774 | Rev 3905 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 3774 Rev 3822
Line 112... Line 112...
112
        $concatenation_id = "CONCAT(IFNULL(latitude,''),IFNULL(longitude,'')) ";
112
        $concatenation_id = "CONCAT(IFNULL(latitude,''),IFNULL(longitude,'')) ";
113
        $transmission = ( $this->standard == 0) ? "transmission = '1' AND " : "";
113
        $transmission = ( $this->standard == 0) ? "transmission = '1' AND " : "";
114
        $requete =  'SELECT distinct ce_zone_geo, zone_geo, NULL as station, '.
114
        $requete =  'SELECT distinct ce_zone_geo, zone_geo, NULL as station, '.
115
            "NULL as mots_cles_texte, ".
115
            "NULL as mots_cles_texte, ".
116
            "latitude, ".
116
            "latitude, ".
117
            "NULL as wgs84_latitude, ".
117
            "wgs84_latitude, ".
118
            "longitude, ".
118
            "longitude, ".
119
            "NULL as wgs84_longitude, ".
119
            "wgs84_longitude, ".
120
            $concatenation_id." as id_coord ".
120
            $concatenation_id." as id_coord ".
121
            'FROM '.$this->table_export.' AS co '.
121
            'FROM '.$this->table_export.' AS co left join cel_zones_geo on ce_zone_geo=code and (pays = "fr" or pays = "france" '.
Line 122... Line 122...
122
            
122
            
123
            "WHERE ".$transmission.
123
            "WHERE ".$transmission.
124
            " (".
124
            " (".
125
            $this->construireWhereRectangleStationOR()." ".
125
            $this->construireWhereRectangleStationOR()." ".