Subversion Repositories eFlore/Applications.cel

Rev

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

Rev 3857 Rev 3858
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 
            "wgs84_latitude, ".
 117 
            "NULL as wgs84_latitude, ".
118 
            "longitude, ".
 118 
            "longitude, ".
119 
            "wgs84_longitude, ".
 119 
            "NULL as wgs84_longitude, ".
120 
            $concatenation_id." as id_coord ".
 120 
            $concatenation_id." as id_coord ".
121 
            'FROM '.$this->table_export.' AS co left join cel_zones_geo on ce_zone_geo=code and (pays = "fr" or pays = "france" '.
 121 
            'FROM '.$this->table_export.' AS co '.
Line 122... Line 122...
122
122
123 
            "WHERE ".$transmission.
 123 
            "WHERE ".$transmission.
124 
            " (".
 124 
            " (".
125 
            $this->construireWhereRectangleStationOR()." ".
 125 
            $this->construireWhereRectangleStationOR()." ".