Subversion Repositories eFlore/Projets.eflore-projets

Rev

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

Rev 750 Rev 751
Line 120... Line 120...
120 
					$codesInsee[] = "'$codeInsee2'";
 120 
					$codesInsee[] = "'$codeInsee2'";
121 
				}
 121 
				}
122 
				$codesInsee[] = "'$codeInsee'";
 122 
				$codesInsee[] = "'$codeInsee'";
123 
			}
 123 
			}
124 
		}
 124 
		}
125 
		$nomTableCommunes = Config::get('bdd_nom_communes');
 125 
		$nomTableCommunes = Config::get('bdd_table_communes');
126 
		$requete =
 126 
		$requete =
127 
		"SELECT insee, nom AS commune, Floor(latitude_degre*10)/10 AS lat, Floor(longitude_degre*10)/10 AS lng ".
 127 
		"SELECT insee, nom AS commune, Floor(latitude_degre*10)/10 AS lat, Floor(longitude_degre*10)/10 AS lng ".
128 
		"FROM $nomTableCommunes WHERE insee IN (".implode(',', array_unique($codesInsee)).") ORDER BY insee";
 128 
		"FROM $nomTableCommunes WHERE insee IN (".implode(',', array_unique($codesInsee)).") ORDER BY insee";
129 
		$communes = $this->bdd->recupererTous($requete);
 129 
		$communes = $this->bdd->recupererTous($requete);