/trunk/jrest/services/InventoryImportExcel.php |
---|
363,7 → 363,7 |
// creation lien image |
foreach ($info_image as $pic) { |
$requete_liaison = 'INSERT INTO cel_obs_images (id_image, id_utilisateur, id_observation ) VALUES ('.$this->proteger($pic['id_image']).','.$this->proteger($utilisateur).', '.$id_obs.') ON DUPLICATE KEY UPDATE id_image = id_image '; |
$requete_liaison = 'INSERT INTO cel_obs_images (id_image, id_observation ) VALUES ('.$this->proteger($pic['id_image']).', '.$id_obs.') ON DUPLICATE KEY UPDATE id_image = id_image '; |
$liaison = $this->executer($requete_liaison); |
if ($liaison !== false) { |
$this->cpt_images_liees++; |
380,7 → 380,7 |
$info_image=$this->traiterImage($line[IMAGE][$i],$utilisateur); // Image separee par des / + utilisateur |
// creation lien image |
foreach ($info_image as $pic) { |
$requete = 'INSERT INTO cel_obs_images (id_image, id_utilisateur, id_observation) VALUES ('.$this->proteger($pic['id_image']).','.$this->proteger($utilisateur).', '.$this->proteger($id_obs).') ON DUPLICATE KEY UPDATE id_image = id_image' ; |
$requete = 'INSERT INTO cel_obs_images (id_image, id_observation) VALUES ('.$this->proteger($pic['id_image']).', '.$this->proteger($id_obs).') ON DUPLICATE KEY UPDATE id_image = id_image' ; |
$resultat_liaison = $this->executer($requete); |
if ($resultat_liaison !== false) { |
$this->cpt_images_liees++; |
504,6 → 504,7 |
$liste_images = explode("/",$images) ; |
$row =array(); |
foreach($liste_images as $image) { |
$image = remove_accent(fix_latin($image)); |
$requete = "SELECT * FROM cel_images WHERE ce_utilisateur = ".$this->proteger($utilisateur)." AND nom_original= ".$this->proteger($image); |
$ligne = $this->requeter($requete); |
if(is_array($ligne) && !empty($ligne)) { |
/trunk/jrest/services/InventoryImageLink.php |
---|
48,9 → 48,9 |
{ |
foreach($ids_observations_liste as $observation) |
{ |
$requete_creation_lien = 'INSERT INTO cel_obs_images (id_image, id_utilisateur, id_observation, date_liaison) '. |
$requete_creation_lien = 'INSERT INTO cel_obs_images (id_image, id_observation, date_liaison) '. |
'VALUES '. |
'('.$this->proteger($image).','.$this->proteger($utilisateur).','.$this->proteger($observation).', NOW()) '. |
'('.$this->proteger($image).','.$this->proteger($observation).', NOW()) '. |
'ON DUPLICATE KEY UPDATE id_image = id_image' ; |
$resultat_creation_lien = $this->executer($requete_creation_lien); |
96,13 → 96,12 |
'SELECT id_image '. |
'FROM cel_obs_images '. |
'WHERE id_observation = '.$this->proteger($value).' '. |
'AND id_utilisateur = '.$this->proteger($uid[0]).' '. |
')'; |
} |
else |
{ |
$column = 'id_observation' ; |
$requete_selection_liaison = 'SELECT * from cel_obs WHERE id_observation IN (SELECT '.$column.' FROM cel_obs_images WHERE '.$field.' = '.$this->proteger($value).') AND ce_utilisateur = '.$this->proteger($uid[0]).' ' ; |
$requete_selection_liaison = 'SELECT * from cel_obs WHERE id_observation IN (SELECT '.$column.' FROM cel_obs_images WHERE '.$field.' = '.$this->proteger($value).') ' ; |
} |
} |
143,7 → 142,7 |
if (isset($id)) { |
$requete_suppression_lien = "DELETE FROM cel_obs_images ". |
"WHERE id_image IN (".$id_img.") ". |
"AND id_observation IN (".$id_obs.") AND id_utilisateur = '".$id."'" ; |
"AND id_observation IN (".$id_obs.") " ; |
} |
$resultat_suppression_lien = $this->executer($requete_suppression_lien); |
/trunk/jrest/lib/LiaisonMotsCles.php |
---|
162,7 → 162,7 |
$requete = 'UPDATE '.(($this->mode == 'obs') ? 'cel_obs' : 'cel_images').' '. |
'SET mots_cles_texte = '.$this->proteger($mots_cles_texte_chaine).' '. |
'WHERE '.(($this->mode == 'obs') ? 'id_observation' : 'id_image').' = '.$this->proteger($id_image_ou_obs). |
' AND ce_utilisateur = '.$this->proteger($identifiant_utilisateur); |
' AND id_utilisateur = '.$this->proteger($identifiant_utilisateur); |
return $this->executer($requete); |
} |
175,7 → 175,7 |
'FROM cel_'.$this->mode.'_mots_cles '. |
'WHERE '.(($this->mode == 'obs') ? 'id_observation' : 'id_image').' = '.$this->proteger($id_image_ou_obs). |
')'. |
' AND ce_utilisateur = '.$this->proteger($identifiant_utilisateur); |
' AND id_utilisateur = '.$this->proteger($identifiant_utilisateur); |
$resultats = $this->requeter($requete); |
return $resultats; |
} |
/trunk/jrest/lib/RechercheImage.php |
---|
77,7 → 77,7 |
$requete_recherche_images .= $sous_requete_recherche; |
$nb_images = 0; |
$resultat_requete_nombre_images = $this->requeter($requete_recherche_images); |
if($resultat_requete_nombre_images && is_array($resultat_requete_nombre_images) && count($resultat_requete_nombre_images) > 0) { |
96,9 → 96,9 |
$requete_jointure_observations = 'FROM cel_obs_images coi '. |
'INNER JOIN cel_obs co '. |
'ON coi.id_observation = co.id_observation AND coi.id_utilisateur = co.ce_utilisateur '. |
'ON coi.id_observation = co.id_observation '. |
'INNER JOIN cel_images ci '. |
'ON coi.id_image = ci.id_image AND coi.id_utilisateur = ci.ce_utilisateur '. |
'ON coi.id_image = ci.id_image '. |
'WHERE co.ce_utilisateur = ci.ce_utilisateur '; |
return $requete_jointure_observations; |