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 |
}
|