| 95,7 → 95,7 |
|---|
| (name, data_type, default_value, field_id) |
| SELECT label, 'text', '', cle |
| FROM ".$this->bd_cel.".`cel_catalogue_champs_etendus` |
| WHERE `cle` not in (SELECT `champ` FROM `cel_catalogue_champs_etendus_liaison`)"; |
| WHERE `cle` not in (SELECT `champ` FROM ".$this->bd_cel.".`cel_catalogue_champs_etendus_liaison`)"; |
| $this->bdd->requeter($requete); |
| } |
| |
| 105,7 → 105,7 |
|---|
| SELECT `id_observation`, id, `valeur` |
| FROM ".$this->bd_cel.".`cel_obs_etendues` |
| RIGHT JOIN ".$this->bd_new_cel.".`user_custom_field` ON field_id = cle |
| WHERE id_observation in (select id FROM `occurrence`)"; |
| WHERE id_observation in (select id FROM ".$this->bd_new_cel.".`occurrence`)"; |
| $this->bdd->requeter($requete); |
| } |
| |
| 165,12 → 165,12 |
|---|
| private function ajouterIdProjet() { |
| $requete = "UPDATE ".$this->bd_new_cel.".`project_settings` SET `project_id` = `id`"; |
| $this->bdd->requeter($requete); |
| $requete = "INSERT INTO `tb_project`(`id`, `label`, `is_private`) SELECT `id`, `project`, '0' FROM `project_settings` "; |
| $requete = "INSERT INTO ".$this->bd_new_cel.".`tb_project`(`id`, `label`, `is_private`) SELECT `id`, `project`, '0' FROM ".$this->bd_new_cel.".`project_settings` "; |
| $this->bdd->requeter($requete); |
| $requete = "UPDATE `extended_field` f right join `project_settings` s on |
| $requete = "UPDATE ".$this->bd_new_cel.".`extended_field` f right join ".$this->bd_new_cel.".`project_settings` s on |
| s.`project` = f.`project` SET f.`project_id` = s.`project_id`"; |
| $this->bdd->requeter($requete); |
| $requete = "UPDATE `occurrence` o right join `project_settings` s on |
| $requete = "UPDATE ".$this->bd_new_cel.".`occurrence` o right join ".$this->bd_new_cel.".`project_settings` s on |
| s.`project` = o.`project` SET o.`project_id` = s.`project_id`"; |
| $this->bdd->requeter($requete); |
| } |