Subversion Repositories eFlore/Applications.cel

Compare Revisions

Ignore whitespace Rev 1766 → Rev 1767

/trunk/jrest/services/InventoryImageLink.php
6,7 → 6,8
* @category PHP
* @package jrest
* @author Aurélien Peronnet <aurelien@tela-botanica.org>
* @copyright 2010 Tela-Botanica
* @author Raphaël Droz <raphael@tela-botanica.org>
* @copyright 2010,2013 Tela-Botanica
* @license http://www.cecill.info/licences/Licence_CeCILL_V2-fr.txt Licence CECILL
* @version SVN: <svn_id>
* @link /doc/jrest/
32,38 → 33,35
$this->controleUtilisateur($pairs['ce_utilisateur']);
if(!isset($pairs['id_image'])) exit;
 
$ids_images = $pairs['id_image'] ;
$ids_images = rtrim($ids_images,',') ;
$utilisateur = $pairs['ce_utilisateur'] ;
 
$ids_images_liste = explode(",",$ids_images) ;
// filtrage des entiers
$ids_observations = self::filterInt($pairs['id_observation']);
$ids_images = self::filterInt($pairs['id_image']);
if(empty($ids_images) || empty($ids_observations)) die('err');
 
$utilisateur = $pairs['ce_utilisateur'] ;
// filtrage des entiers à partir des ids existant réellement en DB
$ids_observations = array_map(array(__CLASS__, 'getRequeteVal'),
Cel::db()->requeter(sprintf("SELECT id_observation FROM cel_obs WHERE id_observation IN (%s) AND ce_utilisateur = %d",
implode(',', $ids_observations),
$utilisateur)));
$ids_images = array_map(array(__CLASS__, 'getRequeteVal'),
Cel::db()->requeter(sprintf("SELECT id_image FROM cel_images WHERE id_image IN (%s) AND ce_utilisateur = %d",
implode(',', $ids_images),
$utilisateur)));
 
$ids_observations = $pairs['id_observation'] ;
$ids_observations = rtrim($ids_observations,',') ;
$ids_observations_liste = explode(",",$ids_observations) ;
$retour = false;
if(empty($ids_images) || empty($ids_observations)) die('err');
 
foreach($ids_images_liste as $image)
{
foreach($ids_observations_liste as $observation)
{
$requete_creation_lien = 'INSERT INTO cel_obs_images (id_image, id_observation, date_liaison) '.
'VALUES '.
'('.Cel::db()->proteger($image).','.Cel::db()->proteger($observation).', NOW()) '.
'ON DUPLICATE KEY UPDATE id_image = id_image' ;
$resultat_creation_lien = Cel::db()->executer($requete_creation_lien);
if ($resultat_creation_lien) {
$retour = "OK";
}
$requete_creation_lien = 'INSERT INTO cel_obs_images (id_image, id_observation, date_liaison) VALUES %s ON DUPLICATE KEY UPDATE id_image = id_image' . ' -- ' . __FILE__ . ':' . __LINE__;
$update = Array();
foreach($ids_images as $image) {
foreach($ids_observations as $observation) {
$update[] = "($image, $observation, NOW())";
}
}
 
echo $retour ;
exit ;
$resultat_creation_lien = Cel::db()->executer(sprintf($requete_creation_lien, implode(',', $update)));
if ($resultat_creation_lien) die("OK");
exit; // peut-être qu'aucune mise à jour n'a eu lieu (ON DUPLICATE KEY)
}
 
/**
135,32 → 133,46
* uid[2] : identifiant(s) observations
*
*/
function deleteElement($uid)
{
function deleteElement($uid) {
// Controle detournement utilisateur
$this->controleUtilisateur($uid[0]);
$id = $uid[0];
 
$id_img = $uid[1] ;
$id_obs = Cel::db()->proteger($uid[2]) ;
$ids_images = self::filterInt($uid[1]);
$ids_observations = self::filterInt($uid[2]);
 
$id = $uid[0] ;
if(empty($ids_images) || empty($ids_observations) || ! $id) die('err');
 
if (isset($id)) {
$requete_suppression_lien = "DELETE FROM cel_obs_images ".
"WHERE id_image IN (".$id_img.") ".
"AND id_observation IN (".$id_obs.") " ;
}
 
$resultat_suppression_lien = Cel::db()->executer($requete_suppression_lien);
$ids_images = array_map(array(__CLASS__, 'getRequeteVal'),
Cel::db()->requeter(sprintf("SELECT id_image FROM cel_images WHERE id_image IN (%s) AND ce_utilisateur = %d",
implode(',', $ids_images),
$id)));
$ids_observations = array_map(array(__CLASS__, 'getRequeteVal'),
Cel::db()->requeter(sprintf("SELECT id_observation FROM cel_obs WHERE id_observation IN (%s) AND ce_utilisateur = %d",
implode(',', $ids_observations),
$id)));
 
$retour = false;
if ($resultat_suppression_lien) {
$retour = "OK";
}
if(empty($ids_images) || empty($ids_observations)) die('err');
 
echo $retour;
exit() ;
 
$resultat_suppression_lien = Cel::db()->executer(sprintf("DELETE FROM cel_obs_images WHERE id_image IN (%s) AND id_observation IN (%s)",
implode(',', $ids_images),
implode(',', $ids_observations)));
if ($resultat_suppression_lien) die('OK');
die;
}
 
static function filterInt($str_liste) {
return array_filter(array_map('intval', explode(',', $str_liste)));
}
 
// extrait la première valeur d'un tableau, utile pour renvoyer un tableau de simple valeur
// à partir d'une requête effectuée sur un seul champ.
static function getRequeteVal($arr) {
return array_shift($arr);
}
 
}
?>