| 145,9 → 145,7 |
|---|
| } |
| |
| private function unifierNull() { |
| $requete_colonnes = "SELECT column_name FROM information_schema.columns WHERE table_name = '".$this->bd_cel.".cel_obs' AND table_schema='tb_cel';"; |
| $colonnes = $this->bdd->recupererTous($requete_colonnes); |
| foreach ($colonnes as $colonne) { |
| foreach ($this->colonnes as $id=>$colonne) { |
| echo "Suppression des vides dans la colonne ".$colonne['column_name']." ..."; |
| $dsl = array( 'transmission', 'altitude'); |
| if (isset($dsl[$colonne['column_name']])) { |
| 401,13 → 399,13 |
|---|
| $requete = "UPDATE ".$this->bd_cel.".cel_obs SET input_source = 'autre' WHERE `mots_cles_texte` like '%MobileSauvages%'"; |
| $this->bdd->requeter($requete); |
| |
| $requete = "UPDATE ".$this->bd_cel.".cel_obs SET input_source = 'widget' WHERE `mots_cles_texte` like '%Projets coopératifs%' and input_source = ''"; |
| $requete = "UPDATE ".$this->bd_cel.".cel_obs SET input_source = 'widget' WHERE `mots_cles_texte` like '%Projets coopératifs%' and (input_source = '' OR input_source IS NULL)"; |
| $this->bdd->requeter($requete); |
| |
| $requete = "UPDATE ".$this->bd_cel.".cel_obs SET input_source = 'widget' WHERE `mots_cles_texte` like '%widget%' and input_source = ''"; |
| $requete = "UPDATE ".$this->bd_cel.".cel_obs SET input_source = 'widget' WHERE `mots_cles_texte` like '%widget%' and (input_source = '' OR input_source IS NULL)"; |
| $this->bdd->requeter($requete); |
| |
| $requete = "UPDATE ".$this->bd_cel.".cel_obs SET input_source = 'cel' WHERE input_source = ''"; |
| $requete = "UPDATE ".$this->bd_cel.".cel_obs SET input_source = 'cel' WHERE input_source = '' OR input_source IS NULL"; |
| $this->bdd->requeter($requete); |
| |
| echo "Suppression motcle du chemin \n"; |