Subversion Repositories eFlore/Applications.cel

Compare Revisions

Ignore whitespace Rev 3442 → Rev 3443

/trunk/scripts/modules/migrat2019/Migrat2019.php
35,6 → 35,18
$this->mode_verbeux = $this->getParametre('v');
 
switch($cmd) {
case 'tout' :
$this->migrerObservations();
$this->migrerObsEtendusChampsUtilisateur();
$this->migrerObsEtendusUtilisateur();
$this->migrerObsEtendusProjet();
$this->migrerMotsClesObs();
$this->migrerMotsClesObsLiaison();
$this->migrerImages();
$this->migrerMotsClesImages();
$this->migrerMotsClesImagesLiaison();
$this->ajouterIdProjet();
break;
case 'obs':
$this->migrerObservations();
break;
54,6 → 66,9
$this->migrerMotsClesImages();
$this->migrerMotsClesImagesLiaison();
break;
case 'projet_id':
$this->ajouterIdProjet();
break;
default:
echo 'Méthode inconnue, les méthodes possibles sont obs et images'."\n";
}
78,7 → 93,7
$this->bdd->requeter($requete);
$requete = "INSERT INTO ".$this->bd_new_cel.".`user_custom_field`
(name, data_type, default_value, field_id)
SELECT label, type, valeur, cle
SELECT label, 'text', '', cle
FROM ".$this->bd_cel.".`cel_catalogue_champs_etendus`
WHERE `cle` not in (SELECT `champ` FROM `cel_catalogue_champs_etendus_liaison`)";
$this->bdd->requeter($requete);
89,7 → 104,8
(`occurrence_id`, `user_custom_field_id`, `value`)
SELECT `id_observation`, id, `valeur`
FROM ".$this->bd_cel.".`cel_obs_etendues`
LEFT JOIN ".$this->bd_new_cel.".`user_custom_field` ON field_id = cle";
RIGHT JOIN ".$this->bd_new_cel.".`user_custom_field` ON field_id = cle
WHERE id_observation in (select id FROM `occurrence`)";
$this->bdd->requeter($requete);
}
100,7 → 116,7
SELECT `id_observation`, id, `valeur`
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`)";
WHERE id_observation in (select id FROM ".$this->bd_new_cel.".`occurrence`)";
$this->bdd->requeter($requete);
}
127,8 → 143,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
WHERE ";
FROM ".$this->bd_cel.".cel_images";
$this->bdd->requeter($requete);
}
 
146,6 → 161,19
SELECT `id_element_lie`, `id_mot_cle` FROM ".$this->bd_cel.".`cel_mots_cles_images_liaison`";
$this->bdd->requeter($requete);
}
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` ";
$this->bdd->requeter($requete);
$requete = "UPDATE `extended_field` f right join `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
s.`project` = o.`project` SET o.`project_id` = s.`project_id`";
$this->bdd->requeter($requete);
}
 
 
}