| 154,21 → 154,24 |
|---|
| private function migrerImages() { |
| $requete = "INSERT INTO ".$this->bd_new_cel.".photo |
| (id, occurrence_id, user_id, user_pseudo, user_email, date_shot, original_name, mime_type, |
| date_updated, date_created, date_linked_to_occurrence, content_url, url) |
| date_updated, date_created, date_linked_to_occurrence, content_url, size, 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('https://api.tela-botanica.org/img:', |
| date_creation, date_liaison, '', '6444444',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`)))) |
| ',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`)))) |
| ',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); |
| '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.jpg") |
| WHERE content_url = "" and (`original_name` != "" or `original_name` is null)'; |
| } |
| |
| private function migrerMotsClesImages() { |