Subversion Repositories eFlore/Applications.cel

Compare Revisions

Ignore whitespace Rev 1019 → Rev 1020

/trunk/jrest/lib/GestionImage.php
212,7 → 212,7
return $requete_maj_champs;
}
public function supprimerImage($id_utilisateur, $ordre_image_ou_tableau) {
public function supprimerImageParOrdre($id_utilisateur, $ordre_image_ou_tableau) {
if(is_array($ordre_image_ou_tableau)) {
$id_image_ou_tableau = array_map(array($this,'proteger'),$ordre_image_ou_tableau);
222,18 → 222,31
}
$requete_selection_ids_images = 'SELECT id_image FROM cel_images WHERE '.
'ce_utilisateur = '.$this->proteger($id_utilisateur).' '.
'AND ordre IN ('.$ids_images.') ';
$tableau_ids_images = $this->requeter($requete_selection_ids_images);
'ce_utilisateur = '.$this->proteger($id_utilisateur).' '.
'AND ordre IN ('.$ids_images.') ';
$tableau_ids_images = $this->requeter($requete_selection_ids_images);
$chaine_ids_images = '';
foreach($tableau_ids_images as $id_image) {
$chaine_ids_images .= $id_image['id_image'];
}
}
$chaine_ids_images = rtrim($chaine_ids_images,',');
return $this->supprimerImage($id_utilisateur, $ordre_image_ou_tableau);
}
public function supprimerImage($id_utilisateur, $id_image_ou_tableau) {
if(is_array($id_image_ou_tableau)) {
$id_image_ou_tableau = array_map(array($this,'proteger'),$id_image_ou_tableau);
$chaine_ids_images = implode(',',$id_image_ou_tableau);
} else {
$chaine_ids_images = $this->proteger($id_image_ou_tableau);
}
$requete_suppression_images = "DELETE FROM cel_images WHERE id_image in (".$chaine_ids_images.")";
$requete_suppression_lien_images_obs = "DELETE FROM cel_obs_images WHERE id_image in (".$chaine_ids_images.")";
$requete_suppression_lien_images_mots_cles = "DELETE FROM cel_images_mots_cles WHERE id_image in (".$chaine_ids_images.")";