68,7 → 68,7 |
SELECT id_observation, CASE WHEN `mots_cles_texte` like '%sauvages%' then 'sauvages' WHEN `mots_cles_texte` like '%missions-flore%' then 'missions-flore' WHEN `mots_cles_texte` like '%arbres-tetards%' then 'arbres-tetards' WHEN `mots_cles_texte` like '%arbres-remarquables%' then 'arbres-remarquables' WHEN `mots_cles_texte` like '%bellesdemarue%' then 'bellesdemarue' WHEN `mots_cles_texte` like '%biodiversite34%' then 'biodiversite34' WHEN `mots_cles_texte` like '%messicoles%' then 'messicoles' WHEN `mots_cles_texte` like '%florileges%' then 'florileges' END, |
ce_utilisateur, courriel_utilisateur, concat (prenom_utilisateur, ' ', nom_utilisateur), date_observation, date_creation, date_modification, date_transmission, nom_sel, nom_sel_nn, nom_ret, nom_ret_nn, famille, certitude, commentaire, abondance, phenologie, input_source, transmission, 1, |
CONCAT('{\"type\":\"Point\",\"coordinates\":[', longitude, ',', latitude,']}'), altitude, geodatum, zone_geo, ce_zone_geo, lieudit, milieu, locality_consistency, station, published_location, pays, nom_referentiel |
FROM ".$this->bd_cel."`cel_obs`"; |
FROM ".$this->bd_cel.".`cel_obs`"; |
|
$this->bdd->requeter($requete); |
} |
79,7 → 79,7 |
$requete = "INSERT INTO ".$this->bd_new_cel.".`user_custom_field` |
(name, data_type, default_value, field_id) |
SELECT label, type, valeur, cle |
FROM ".$this->bd_cel."`cel_catalogue_champs_etendus` |
FROM ".$this->bd_cel.".`cel_catalogue_champs_etendus` |
WHERE `cle` not in (SELECT `champ` FROM `cel_catalogue_champs_etendus_liaison`)"; |
$this->bdd->requeter($requete); |
} |
88,7 → 88,7 |
$requete = "INSERT INTO ".$this->bd_new_cel.".`user_custom_field_occurrence` |
(`occurrence_id`, `user_custom_field_id`, `value`) |
SELECT `id_observation`, id, `valeur` |
FROM ".$this->bd_cel."`cel_obs_etendues` |
FROM ".$this->bd_cel.".`cel_obs_etendues` |
LEFT JOIN ".$this->bd_new_cel.".`user_custom_field` ON field_id = cle"; |
$this->bdd->requeter($requete); |
} |
98,7 → 98,7 |
$requete = "INSERT INTO ".$this->bd_new_cel.".`extended_field_occurrence` |
(`occurrence_id`, `extended_field_id`, `value`) |
SELECT `id_observation`, id, `valeur` |
FROM ".$this->bd_cel."`cel_obs_etendues` |
FROM ".$this->bd_cel.".`cel_obs_etendues` |
RIGHT JOIN ".$this->bd_new_cel.".`extended_field` ON field_id = cle |
WHERE id_observation in (select id FROM `occurrence`)"; |
$this->bdd->requeter($requete); |
108,7 → 108,7 |
$requete = "INSERT INTO ".$this->bd_new_cel.".user_occurrence_tag |
(id, user_id, name, path) |
SELECT id_mot_cle, id_utilisateur, mot_cle, chemin |
FROM ".$this->bd_cel."`cel_arbre_mots_cles_obs`"; |
FROM ".$this->bd_cel.".`cel_arbre_mots_cles_obs`"; |
$this->bdd->requeter($requete); |
} |
|
115,7 → 115,7 |
private function migrerMotsClesObsLiaison() { |
$requete = "INSERT INTO ".$this->bd_new_cel.".occurrence_user_occurrence_tag |
(occurrence_id, user_occurrence_tag_id) |
SELECT `id_element_lie`, `id_mot_cle` FROM ".$this->bd_cel."`cel_mots_cles_obs_liaison`"; |
SELECT `id_element_lie`, `id_mot_cle` FROM ".$this->bd_cel.".`cel_mots_cles_obs_liaison`"; |
$this->bdd->requeter($requete); |
} |
|
127,7 → 127,7 |
courriel_utilisateur, date_prise_de_vue, nom_original,'' , date_modification, |
date_creation, date_liaison, '', concat('http://api.tela-botanica.org/img:000', '', `id_image`, |
'O.jpg') |
FROM ".$this->bd_cel."cel_images |
FROM ".$this->bd_cel.".cel_images |
WHERE "; |
$this->bdd->requeter($requete); |
} |
136,7 → 136,7 |
$requete = "INSERT INTO ".$this->bd_new_cel.".photo_tag |
(id, user_id, name, path) |
SELECT id_mot_cle, id_utilisateur, mot_cle, chemin |
FROM ".$this->bd_cel."`cel_arbre_mots_cles_images`"; |
FROM ".$this->bd_cel.".`cel_arbre_mots_cles_images`"; |
$this->bdd->requeter($requete); |
} |
|
143,7 → 143,7 |
private function migrerMotsClesImagesLiaison() { |
$requete = "INSERT INTO ".$this->bd_new_cel.".photo_tag_photo |
(photo_id, photo_tag_id) |
SELECT `id_element_lie`, `id_mot_cle` FROM ".$this->bd_cel."`cel_mots_cles_images_liaison`"; |
SELECT `id_element_lie`, `id_mot_cle` FROM ".$this->bd_cel.".`cel_mots_cles_images_liaison`"; |
$this->bdd->requeter($requete); |
} |
|