| 90,6 → 90,9 |
|---|
| case 'unifierNull' : // lancer en dernier pour bien réussir |
| $this->unifierNull(); |
| break; |
| case 'supprimerImagesetTagAnonymes' : |
| $this->supprimerImagesetTagAnonymes(); |
| break; |
| case 'supprimerInfosLiesObsInexistante' : |
| $this->supprimerInfosLiesObsInexistante(); |
| break; |
| 149,9 → 152,9 |
|---|
| echo "Suppression des vides dans la colonne ".$colonne['column_name']." ..."; |
| $dsl = array( 'transmission', 'altitude'); |
| if (isset($dsl[$colonne['column_name']])) { |
| $requete = "UPDATE ".$this->bd_cel.".cel_obs SET ".$colonne['column_name']." = NULL WHERE ".$colonne['column_name']."= ''"; |
| $requete = "UPDATE ".$this->bd_cel.".cel_obs SET ".$colonne['column_name']." = NULL WHERE trim(".$colonne['column_name'].") = ''"; |
| } else { |
| $requete = "UPDATE ".$this->bd_cel.".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')"; |
| $requete = "UPDATE ".$this->bd_cel.".cel_obs SET ".$colonne['column_name']." = NULL WHERE trim(".$colonne['column_name'].") = '' OR ".$colonne['column_name']." IN ('INSEE-C:', '0000-00-00 00:00:00', '0.00000')"; |
| } |
| $this->bdd->requeter($requete); |
| echo "effectuée \n"; |
| 261,7 → 264,7 |
|---|
| $this->bdd->requeter($requete); |
| |
| echo "modification des observations ayant une adresse mail en identifiant"; |
| $requete_annu_mail = "UPDATE ".$this->bd_cel.".`cel_obs` join ".$this->bd_cel.".`users` ON `user_email` = ce_utilisateur SET `ce_utilisateur` = `ID`, pseudo = user_nicename, |
| $requete_annu_mail = "UPDATE ".$this->bd_cel.".`cel_obs` right join ".$this->bd_cel.".`users` ON `user_email` = ce_utilisateur SET `ce_utilisateur` = `ID`, pseudo = user_nicename, |
| `courriel_utilisateur` = `user_email` WHERE ce_utilisateur like '%@%'"; |
| $utilisateur_mail = $this->bdd->recupererTous($requete_annu_mail); |
| |