| Line 788... |
Line 788... |
| 788 |
private function analyserMotsCles(){
|
788 |
private function analyserMotsCles(){
|
| 789 |
echo "Input source \n";
|
789 |
echo "Input source \n";
|
| 790 |
$requete = "ALTER TABLE ".$this->bd_cel.".`cel_obs` ADD IF NOT EXISTS `input_source` VARCHAR(15)";
|
790 |
$requete = "ALTER TABLE ".$this->bd_cel.".`cel_obs` ADD IF NOT EXISTS `input_source` VARCHAR(15)";
|
| 791 |
$this->bdd->requeter($requete);
|
791 |
$this->bdd->requeter($requete);
|
| Line 792... |
Line 792... |
| 792 |
|
792 |
|
| 793 |
$requete = "UPDATE ".$this->bd_cel.".cel_obs SET input_source = 'plantnet' WHERE `mots_cles_texte` like '%plantnet%'";
|
793 |
$requete = "UPDATE ".$this->bd_cel.".cel_obs SET input_source = 'PlantNet' WHERE `mots_cles_texte` like '%plantnet%'";
|
| Line 794... |
Line 794... |
| 794 |
$this->bdd->requeter($requete);
|
794 |
$this->bdd->requeter($requete);
|
| 795 |
|
795 |
|
| Line 800... |
Line 800... |
| 800 |
$this->bdd->requeter($requete);
|
800 |
$this->bdd->requeter($requete);
|
| Line 801... |
Line 801... |
| 801 |
|
801 |
|
| 802 |
$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)";
|
802 |
$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 803... |
Line 803... |
| 803 |
$this->bdd->requeter($requete);
|
803 |
$this->bdd->requeter($requete);
|
| 804 |
|
804 |
|
| Line 805... |
Line 805... |
| 805 |
$requete = "UPDATE ".$this->bd_cel.".cel_obs SET input_source = 'cel' WHERE input_source = '' OR input_source IS NULL";
|
805 |
$requete = "UPDATE ".$this->bd_cel.".cel_obs SET input_source = 'CEL' WHERE input_source = '' OR input_source IS NULL";
|
| 806 |
$this->bdd->requeter($requete);
|
806 |
$this->bdd->requeter($requete);
|
| 807 |
|
807 |
|