Subversion Repositories eFlore/Projets.eflore-projets

Rev

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

Rev 747 Rev 750
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 
		$requete =
 126 
		$requete =
126 
		"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 ".
127 
		"FROM lion1906_communes_v2008 WHERE insee IN (".implode(',', array_unique($codesInsee)).") ORDER BY insee";
 128 
		"FROM $nomTableCommunes WHERE insee IN (".implode(',', array_unique($codesInsee)).") ORDER BY insee";
128 
		$communes = $this->bdd->recupererTous($requete);
 129 
		$communes = $this->bdd->recupererTous($requete);
Line 129... Line 130...
129
130
130 
		$indexStation = 0;
 131 
		$indexStation = 0;
131 
		foreach ($communes as $commune) {
 132 
		foreach ($communes as $commune) {