| Line 155... |
Line 155... |
| 155 |
$requete = "INSERT INTO ".$this->bd_new_cel.".photo
|
155 |
$requete = "INSERT INTO ".$this->bd_new_cel.".photo
|
| 156 |
(id, occurrence_id, user_id, user_pseudo, user_email, date_shot, original_name, mime_type,
|
156 |
(id, occurrence_id, user_id, user_pseudo, user_email, date_shot, original_name, mime_type,
|
| 157 |
date_updated, date_created, date_linked_to_occurrence, content_url, url)
|
157 |
date_updated, date_created, date_linked_to_occurrence, content_url, url)
|
| 158 |
SELECT id_image, ce_observation, ce_utilisateur, prenom_utilisateur,
|
158 |
SELECT id_image, ce_observation, ce_utilisateur, prenom_utilisateur,
|
| 159 |
courriel_utilisateur, date_prise_de_vue, nom_original,'' , date_modification,
|
159 |
courriel_utilisateur, date_prise_de_vue, nom_original,'' , date_modification,
|
| 160 |
date_creation, date_liaison, '', concat('http://api.tela-botanica.org/img:000', '', `id_image`,
|
160 |
date_creation, date_liaison, '', concat('https://api.tela-botanica.org/img:',
|
| 161 |
'O.jpg')
|
161 |
lpad(`id_image`, 9, '0'), 'O')
|
| 162 |
FROM ".$this->bd_cel.".cel_images";
|
162 |
FROM ".$this->bd_cel.".cel_images";
|
| 163 |
$this->bdd->requeter($requete);
|
163 |
$this->bdd->requeter($requete);
|
| - |
|
164 |
$requete_jpg = 'UPDATE `photo` SET `mime_type` = "image/jpeg", `content_url`= concat('.Config::get('nettoyage.chemin_photo').
|
| - |
|
165 |
',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`))))
|
| - |
|
166 |
WHERE `original_name` like "%.jp%" and content_url = ""';
|
| - |
|
167 |
$this->bdd->requeter($requete_jpg);
|
| - |
|
168 |
$requete_png = 'UPDATE `photo` SET `mime_type` = "image/png", `content_url`= concat('.Config::get('nettoyage.chemin_photo').
|
| - |
|
169 |
',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`))))
|
| - |
|
170 |
WHERE `original_name` like "%.png" and content_url = ""';
|
| - |
|
171 |
$this->bdd->requeter($requete_png);
|
| 164 |
}
|
172 |
}
|
| Line 165... |
Line 173... |
| 165 |
|
173 |
|
| 166 |
private function migrerMotsClesImages() {
|
174 |
private function migrerMotsClesImages() {
|
| 167 |
$requete = "INSERT INTO ".$this->bd_new_cel.".photo_tag
|
175 |
$requete = "INSERT INTO ".$this->bd_new_cel.".photo_tag
|