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; |
|
} |