Subversion Repositories eFlore/Applications.cel

Rev

Rev 2894 | Rev 2936 | Go to most recent revision | Show entire file | Regard whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 2894 Rev 2895
Line 88... Line 88...
88 
	private function unifierNull() {
 88 
	private function unifierNull() {
89 
		$requete_colonnes = "SELECT column_name FROM information_schema.columns WHERE table_name = 'cel_obs' AND table_schema='tb_cel';";
 89 
		$requete_colonnes = "SELECT column_name FROM information_schema.columns WHERE table_name = 'cel_obs' AND table_schema='tb_cel';";
90 
		$colonnes = $this->bdd->recupererTous($requete_colonnes);
 90 
		$colonnes = $this->bdd->recupererTous($requete_colonnes);
91 
		foreach ($colonnes as $colonne) {
 91 
		foreach ($colonnes as $colonne) {
92 
			echo "Suppression des vides dans la colonne ".$colonne['column_name']." ...";
 92 
			echo "Suppression des vides dans la colonne ".$colonne['column_name']." ...";
93 
			$dsl = array( 'nom_sel_nn', 'nom_ret_nn', 'nt');
 93 
			$dsl = array( 'transmission', 'altitude');
94 
			if (isset($dsl[$colonne['column_name']])) {
 94 
			if (isset($dsl[$colonne['column_name']])) {
95 
				$requete = "UPDATE cel_obs SET ".$colonne['column_name']." = NULL WHERE ".$colonne['column_name']."= '' OR ".$colonne['column_name']." = 0";
 95 
				$requete = "UPDATE cel_obs SET ".$colonne['column_name']." = NULL WHERE ".$colonne['column_name']."= ''";
96 
			} else {
 96 
			} else {
97 
				$requete = "UPDATE cel_obs SET ".$colonne['column_name']." = NULL WHERE ".$colonne['column_name']."= '' OR ".$colonne['column_name']." IN ('INSEE-C:', '0000-00-00 00:00:00', '0.00000')";
 97 
				$requete = "UPDATE cel_obs SET ".$colonne['column_name']." = NULL WHERE ".$colonne['column_name']."= '' OR ".$colonne['column_name']." IN ('INSEE-C:', '0000-00-00 00:00:00', '0.00000')";
98 
			}
 98 
			}
99 
			$this->bdd->requeter($requete);
 99 
			$this->bdd->requeter($requete);
100 
			echo "effectuée \n";
 100 
			echo "effectuée \n";
Line 127... Line 127...
127 
		foreach ($referentiels as $referentiel) {
 127 
		foreach ($referentiels as $referentiel) {
128 
			$requete = "UPDATE cel_obs SET nom_referentiel = '".$referentiel."' WHERE nom_referentiel like '".$referentiel."%'";
 128 
			$requete = "UPDATE cel_obs SET nom_referentiel = '".$referentiel."' WHERE nom_referentiel like '".$referentiel."%'";
129 
			$this->bdd->requeter($requete);
 129 
			$this->bdd->requeter($requete);
130 
			$requete = "UPDATE cel_obs SET nom_referentiel = NULL WHERE nom_sel_nn = '' or nom_sel_nn = '0'";
 130 
			$requete = "UPDATE cel_obs SET nom_referentiel = NULL WHERE nom_sel_nn = '' or nom_sel_nn = '0'";
131 
			$this->bdd->requeter($requete);
 131 
			$this->bdd->requeter($requete);
- 
 
 132 
			$requete = "UPDATE cel_obs SET nom_referentiel = 'APD' WHERE nom_referentiel like 'bdtao%'";
- 
 
 133 
			$this->bdd->requeter($requete);
- 
 
 134 
			$requete = "UPDATE cel_obs SET nom_referentiel = 'BDTFX' WHERE nom_referentiel like 'bdnff%'";
- 
 
 135 
			$this->bdd->requeter($requete);
132 
			echo "effectuée \n";
 136 
			echo "effectuée \n";
133 
		}
 137 
		}
134 
		$requete_verif = "SELECT nom_referentiel FROM cel_obs WHERE nom_referentiel NOT IN ('".implode("', '", $referentiels)."')";
 138 
		$requete_verif = "SELECT nom_referentiel FROM cel_obs WHERE nom_referentiel NOT IN ('".implode("', '", $referentiels)."', 'autre')";
135 
		$verif = $this->bdd->recupererTous($requete_verif);
 139 
		$verif = $this->bdd->recupererTous($requete_verif);
136 
		if ($verif != array()) print_r($verif);
 140 
		if ($verif != array()) print_r($verif);
137 
	}
 141 
	}
Line 138... Line 142...
138
142
139 
	private function verifierGeodatum() {
 143 
	private function verifierGeodatum() {
140 
		echo "Uniformisation du geodatum";
 144 
		echo "Uniformisation du geodatum";
141 
		$requete = "UPDATE cel_obs SET geodatum = 'wgs84' WHERE (latitude IS NOT NULL or latitude != '0.00000') AND geodatum = ''";
 145 
		$requete = "UPDATE cel_obs SET geodatum = 'wgs84' WHERE (latitude IS NOT NULL or latitude != '0.00000') AND geodatum = ''";
- 
 
 146 
		$this->bdd->requeter($requete);
- 
 
 147 
		$requete = "UPDATE cel_obs SET geodatum = NULL WHERE (latitude IS NULL or latitude == '0.00000')";
142 
		$this->bdd->requeter($requete);
 148 
		$this->bdd->requeter($requete);
143 
		echo "effectuée \n";
 149 
		echo "effectuée \n";
144 
	}
 150 
	}
145 
}
 151 
}