Subversion Repositories eFlore/Projets.eflore-projets

Rev

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

Rev 751 Rev 860
Line 121... Line 121...
121 
				}
 121 
				}
122 
				$codesInsee[] = "'$codeInsee'";
 122 
				$codesInsee[] = "'$codeInsee'";
123 
			}
 123 
			}
124 
		}
 124 
		}
125 
		$nomTableCommunes = Config::get('bdd_table_communes');
 125 
		$nomTableCommunes = Config::get('bdd_table_communes');
- 
 
 126 
		$communes = array();
- 
 
 127 
		if(count($codesInsee) > 0) {
126 
		$requete =
 128 
			$requete =
127 
		"SELECT insee, nom AS commune, Floor(latitude_degre*10)/10 AS lat, Floor(longitude_degre*10)/10 AS lng ".
 129 
			"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";
 130 
			"FROM $nomTableCommunes WHERE insee IN (".implode(',', array_unique($codesInsee)).") ORDER BY insee";
129 
		$communes = $this->bdd->recupererTous($requete);
 131 
			$communes = $this->bdd->recupererTous($requete);
130
132 
		}
131 
		$indexStation = 0;
 133 
		$indexStation = 0;
132 
		foreach ($communes as $commune) {
 134 
		foreach ($communes as $commune) {
133 
			$codeInsee = $commune['insee'];
 135 
			$codeInsee = $commune['insee'];
134 
			if (substr($codeInsee, 0, 2) == '2A' || substr($codeInsee, 0, 2) == '2B') {
 136 
			if (substr($codeInsee, 0, 2) == '2A' || substr($codeInsee, 0, 2) == '2B') {
135 
				$codeInsee = '20'.substr($codeInsee, 2);
 137 
				$codeInsee = '20'.substr($codeInsee, 2);