| 740,8 → 740,7 |
|---|
| $infosImage['user_pseudo'] = $this->userIntitule; |
| $infosImage['content_url'] = $cheminImage; |
| $infosImage['mime_type'] = mime_content_type($cheminImage); |
| $infosImage['url'] = "concat('https://api.tela-botanica.org/img:', |
| lpad(`id`, 9, '0'), 'O')"; |
| $infosImage['url'] = ''; |
| // $infosImage['md5'] = md5_file($cheminImage); |
| $infosImage['date_created'] = 'NOW()'; |
| $infosImage['date_updated'] = 'NOW()'; |
| 750,7 → 749,7 |
|---|
| $requete = $this->construireRequeteInsertionImage($infosImage); |
| $resultat = Cel::db()->executer($requete); |
| if ($resultat !== false) { |
| $idImage = $this->obtenirIdImagePourIdentifiantEtNomOriginal($nomFichierImage); |
| $idImage = $this->traiterEtRecupererIdImage($nomFichierImage); |
| if ($idImage !== false) { |
| $manipulateurImage = new ImageRecreation($this->config); |
| // Stocke le fichier en conservant les fichiers temporaires, ce qui permet de réessayer |
| 798,7 → 797,7 |
|---|
| return $ok; |
| } |
| |
| private function obtenirIdImagePourIdentifiantEtNomOriginal($original_name) { |
| private function traiterEtRecupererIdImage($original_name) { |
| $id_utilisateur = Cel::db()->proteger($this->userId); |
| $email_utilisateur = Cel::db()->proteger($this->userEmail); |
| $original_name = Cel::db()->proteger($original_name); |
| 808,7 → 807,17 |
|---|
| "WHERE (user_id = $id_utilisateur OR user_email = $email_utilisateur)". |
| " AND original_name = $original_name "; |
| $resultat = Cel::db()->requeter($requete); |
| $id_image = (count($resultat) > 0) ? $resultat[0]['id'] : false; |
| $id_image = $resultat[0]['id'] ?? false; |
| |
| if ($id_image) { |
| $full_id_image = str_pad($id_image, 9, '0', STR_PAD_LEFT) . 'O'; |
| $image_url = sprintf(config::get('celImgUrlTpl'), $full_id_image); |
| $requete = 'UPDATE photo'. |
| ' SET url = ' . Cel::db()->proteger($image_url) |
| ' WHERE id = ' Cel::db()->proteger($id_image); |
| $resultat = Cel::db()->requeter($requete); |
| } |
| |
| return $id_image; |
| |
| } |