| 157,10 → 157,18 |
|---|
| date_updated, date_created, date_linked_to_occurrence, content_url, url) |
| SELECT id_image, ce_observation, ce_utilisateur, prenom_utilisateur, |
| 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') |
| date_creation, date_liaison, '', concat('https://api.tela-botanica.org/img:', |
| lpad(`id_image`, 9, '0'), 'O') |
| FROM ".$this->bd_cel.".cel_images"; |
| $this->bdd->requeter($requete); |
| $requete_jpg = 'UPDATE `photo` SET `mime_type` = "image/jpeg", `content_url`= concat('.Config::get('nettoyage.chemin_photo'). |
| ',substr(lpad(id, 9, "0"),1,3),"/",substr(lpad(id, 9, "0"),4,3),"/O/",substr(lpad(id, 9, "0"),1,3),"_",substr(lpad(id, 9, "0"),4,3),"_",substr(lpad(id, 9, "0"),7,3),"_O.",substr(`original_name` , char_length(`original_name`) - locate('.', reverse(`original_name`)) +1, locate('.', reverse(`original_name`)))) |
| WHERE `original_name` like "%.jp%" and content_url = ""'; |
| $this->bdd->requeter($requete_jpg); |
| $requete_png = 'UPDATE `photo` SET `mime_type` = "image/png", `content_url`= concat('.Config::get('nettoyage.chemin_photo'). |
| ',substr(lpad(id, 9, "0"),1,3),"/",substr(lpad(id, 9, "0"),4,3),"/O/",substr(lpad(id, 9, "0"),1,3),"_",substr(lpad(id, 9, "0"),4,3),"_",substr(lpad(id, 9, "0"),7,3),"_O.",substr(`original_name` , char_length(`original_name`) - locate('.', reverse(`original_name`)) +1, locate('.', reverse(`original_name`)))) |
| WHERE `original_name` like "%.png" and content_url = ""'; |
| $this->bdd->requeter($requete_png); |
| } |
| |
| private function migrerMotsClesImages() { |