Subversion Repositories eFlore/Applications.cel

Rev

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

Rev 1500 Rev 1517
Line 1... Line 1...
1 
<?php
 1 
<?php
2 
class Dao extends Bdd {
 2 
class Dao extends Bdd {
3 
 
 - 
 
4 
 
 - 
 
5
- 
 
6 
	public function rechercherCoordonnees() {
 3 
	public function rechercherCoordonnees() {
7 
		$requete = "SELECT longitude, latitude
 4 
		$requete = "SELECT longitude, latitude
8 
					FROM `cel_obs`
 5 
					FROM `cel_obs`
9 
					GROUP BY `longitude` , `latitude`";
 6 
					GROUP BY `longitude` , `latitude`";
10 
		$resultat = $this->recupererTous($requete);
 7 
		$resultat = $this->recupererTous($requete);
11 
		return $resultat;
 8 
		return $resultat;
12 
	}
 9 
	}
Line -... Line 10...
- 
 
 10
- 
 
 11 
	public function rechercherCoordonneesSansCorrespondances() {
- 
 
 12 
		$requete = "SELECT longitude, latitude
- 
 
 13 
						FROM `cel_obs`
- 
 
 14 
						WHERE code_insee_calcule = ''
- 
 
 15 
						GROUP BY `longitude` , `latitude`";
- 
 
 16 
		$resultat = $this->recupererTous($requete);
- 
 
 17 
		return $resultat;
- 
 
 18 
	}
13
19
14 
	public function creerColonneCodeInseeCalculee() {
 20 
	public function creerColonneCodeInseeCalculee() {
15 
		$create = "ALTER TABLE `cel_obs` ADD `code_insee_calcule` VARCHAR( 5 ) NOT NULL";
 21 
		$create = "ALTER TABLE `cel_obs` ADD `code_insee_calcule` VARCHAR( 5 ) NOT NULL";
16 
		$this->requeter($create);
 22 
		$this->requeter($create);
Line 17... Line 23...
17 
	}
 23 
	}
18
24
19 
	public function ajouterCodeInseeCalculee($latitude, $longitude, $code_insee) {
 25 
	public function ajouterCodeInseeCalculee($latitude, $longitude, $code_insee) {
20 
		$insert = "UPDATE `cel_obs` SET `code_insee_calcule` = '$code_insee' ".
 26 
		$insert = "UPDATE `cel_obs` SET `code_insee_calcule` = '$code_insee' ".
21 
					"WHERE latitude = '$latitude' AND longitude = '$longitude'";
 27 
					"WHERE latitude = $latitude AND longitude = $longitude";
Line 22... Line 28...
22 
		$this->requeter($insert);
 28 
		$this->requeter($insert);
23 
	}
 29 
	}
24
30
25 
	public function modifierCodeInsee() {
 31 
	public function modifierCodeInsee() {
26 
		$update = "UPDATE `cel_obs` SET ce_zone_geo=concat('INSEE-C:' ,`code_insee_calcule`) ".
 32 
		$update = "UPDATE `cel_obs` SET `ce_zone_geo` = concat('INSEE-C:' , `code_insee_calcule`) ".
27 
						"WHERE  ce_zone_geo= '' ";
 - 
 
28 
		$this->requeter($update);
 - 
 
29 
	}
 - 
 
30
33 
						"WHERE  ce_zone_geo = '' ";
31 
 
 34 
		$this->requeter($update);
32 
 
 35 
	}