| Line 16... |
Line 16... |
| 16 |
$this->regenererMotsClesTexteObs();
|
16 |
$this->regenererMotsClesTexteObs();
|
| 17 |
break;
|
17 |
break;
|
| 18 |
case 'regenererMotsClesTexteImages' :
|
18 |
case 'regenererMotsClesTexteImages' :
|
| 19 |
$this->regenererMotsClesTexteImages();
|
19 |
$this->regenererMotsClesTexteImages();
|
| 20 |
break;
|
20 |
break;
|
| - |
|
21 |
case 'viderMotsClesTexteImagesSansMotsCles' :
|
| - |
|
22 |
$this->viderMotsClesTexteImagesSansMotsCles();
|
| - |
|
23 |
break;
|
| - |
|
24 |
case 'viderMotsClesTexteObsSansMotsCles' :
|
| - |
|
25 |
$this->viderMotsClesTexteObsSansMotsCles();
|
| - |
|
26 |
break;
|
| 21 |
default :
|
27 |
default :
|
| 22 |
$msg = "Erreur : la commande '$cmd' n'existe pas!\n".
|
28 |
$msg = "Erreur : la commande '$cmd' n'existe pas!\n".
|
| 23 |
"Commandes existantes : regenererMotsClesTexteImages, regenererMotsClesTexteObs";
|
29 |
"Commandes existantes : regenererMotsClesTexteImages, regenererMotsClesTexteObs";
|
| 24 |
throw new Exception($msg);
|
30 |
throw new Exception($msg);
|
| 25 |
}
|
31 |
}
|
| Line 55... |
Line 61... |
| 55 |
. "INNER JOIN cel_mots_cles_obs_liaison cml ON cml.id_mot_cle = cm.id_mot_cle AND cml.id_element_lie = '" . $image['id_observation'] . "') "
|
61 |
. "INNER JOIN cel_mots_cles_obs_liaison cml ON cml.id_mot_cle = cm.id_mot_cle AND cml.id_element_lie = '" . $image['id_observation'] . "') "
|
| 56 |
. "WHERE id_observation = '" . $image['id_observation'] . "'";
|
62 |
. "WHERE id_observation = '" . $image['id_observation'] . "'";
|
| 57 |
$this->bdd->requeter($req);
|
63 |
$this->bdd->requeter($req);
|
| 58 |
}
|
64 |
}
|
| 59 |
}
|
65 |
}
|
| - |
|
66 |
|
| - |
|
67 |
// Vide le champ "mots_cles_texte" pour toutes les images n'ayant aucun mot clé
|
| - |
|
68 |
protected function viderMotsClesTexteImagesSansMotsCles() {
|
| - |
|
69 |
$req = "UPDATE cel_images SET mots_cles_texte = NULL WHERE id_image NOT IN (SELECT id_element_lie FROM cel_mots_cles_images_liaison)";
|
| - |
|
70 |
$res = $this->bdd->requeter($req);
|
| - |
|
71 |
echo "$res images mises à jour\n";
|
| - |
|
72 |
}
|
| - |
|
73 |
|
| - |
|
74 |
// Vide le champ "mots_cles_texte" pour toutes les obs n'ayant aucun mot clé
|
| - |
|
75 |
protected function viderMotsClesTexteObsSansMotsCles() {
|
| - |
|
76 |
$req = "UPDATE cel_obs SET mots_cles_texte = NULL WHERE id_observation NOT IN (SELECT id_element_lie FROM cel_mots_cles_obs_liaison)";
|
| - |
|
77 |
$res = $this->bdd->requeter($req);
|
| - |
|
78 |
echo "$res observations mises à jour\n";
|
| - |
|
79 |
}
|
| 60 |
}
|
80 |
}
|
| 61 |
?>
|
81 |
?>
|
| 62 |
|
82 |
|