| Line 143... |
Line 143... |
| 143 |
echo "effectuée \n";
|
143 |
echo "effectuée \n";
|
| 144 |
}
|
144 |
}
|
| 145 |
}
|
145 |
}
|
| Line 146... |
Line 146... |
| 146 |
|
146 |
|
| 147 |
private function unifierNull() {
|
- |
|
| 148 |
$requete_colonnes = "SELECT column_name FROM information_schema.columns WHERE table_name = '".$this->bd_cel.".cel_obs' AND table_schema='tb_cel';";
|
- |
|
| 149 |
$colonnes = $this->bdd->recupererTous($requete_colonnes);
|
147 |
private function unifierNull() {
|
| 150 |
foreach ($colonnes as $colonne) {
|
148 |
foreach ($this->colonnes as $id=>$colonne) {
|
| 151 |
echo "Suppression des vides dans la colonne ".$colonne['column_name']." ...";
|
149 |
echo "Suppression des vides dans la colonne ".$colonne['column_name']." ...";
|
| 152 |
$dsl = array( 'transmission', 'altitude');
|
150 |
$dsl = array( 'transmission', 'altitude');
|
| 153 |
if (isset($dsl[$colonne['column_name']])) {
|
151 |
if (isset($dsl[$colonne['column_name']])) {
|
| 154 |
$requete = "UPDATE ".$this->bd_cel.".cel_obs SET ".$colonne['column_name']." = NULL WHERE ".$colonne['column_name']."= ''";
|
152 |
$requete = "UPDATE ".$this->bd_cel.".cel_obs SET ".$colonne['column_name']." = NULL WHERE ".$colonne['column_name']."= ''";
|
| Line 399... |
Line 397... |
| 399 |
$this->bdd->requeter($requete);
|
397 |
$this->bdd->requeter($requete);
|
| Line 400... |
Line 398... |
| 400 |
|
398 |
|
| 401 |
$requete = "UPDATE ".$this->bd_cel.".cel_obs SET input_source = 'autre' WHERE `mots_cles_texte` like '%MobileSauvages%'";
|
399 |
$requete = "UPDATE ".$this->bd_cel.".cel_obs SET input_source = 'autre' WHERE `mots_cles_texte` like '%MobileSauvages%'";
|
| Line 402... |
Line 400... |
| 402 |
$this->bdd->requeter($requete);
|
400 |
$this->bdd->requeter($requete);
|
| 403 |
|
401 |
|
| Line 404... |
Line 402... |
| 404 |
$requete = "UPDATE ".$this->bd_cel.".cel_obs SET input_source = 'widget' WHERE `mots_cles_texte` like '%Projets coopératifs%' and input_source = ''";
|
402 |
$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)";
|
| 405 |
$this->bdd->requeter($requete);
|
403 |
$this->bdd->requeter($requete);
|
| Line 406... |
Line 404... |
| 406 |
|
404 |
|
| 407 |
$requete = "UPDATE ".$this->bd_cel.".cel_obs SET input_source = 'widget' WHERE `mots_cles_texte` like '%widget%' and input_source = ''";
|
405 |
$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)";
|
| Line 408... |
Line 406... |
| 408 |
$this->bdd->requeter($requete);
|
406 |
$this->bdd->requeter($requete);
|
| 409 |
|
407 |
|
| 410 |
$requete = "UPDATE ".$this->bd_cel.".cel_obs SET input_source = 'cel' WHERE input_source = ''";
|
408 |
$requete = "UPDATE ".$this->bd_cel.".cel_obs SET input_source = 'cel' WHERE input_source = '' OR input_source IS NULL";
|