51,10 → 51,11 |
{ |
$requete_creation_lien = 'INSERT INTO cel_obs_images (id_image, id_utilisateur, id_observation, date_liaison) '. |
'VALUES '. |
'("'.$this->proteger($image).'","'.$this->proteger($utilisateur).'","'.$this->proteger($observation).'", NOW()) '. |
'('.$this->proteger($image).','.$this->proteger($utilisateur).','.$this->proteger($observation).', NOW()) '. |
'ON DUPLICATE KEY UPDATE id_image = id_image' ; |
|
$resultat_creation_lien = $this->executer($requete_creation_lien); |
|
if ($resultat_creation_lien) { |
$retour = "OK"; |
} |
80,7 → 81,6 |
if($uid) { |
|
$param = $uid[1] ; |
$param = ltrim($param,'&') ; |
|
$tab_param = split('=',$param) ; |
|
92,21 → 92,24 |
if ($field == 'id_observation') |
{ |
$column = 'id_image' ; |
$requete_selection_liaison = 'SELECT cel_obs_images.id_image, hauteur , largeur '. |
'FROM cel_obs_images, cel_images '. |
'WHERE cel_obs_images.id_image = cel_images.id_image '. |
'AND id_observation = '.$this->proteger($value).' AND id_utilisateur = '.$this->proteger($uid[0]) ; |
$requete_selection_liaison = 'SELECT id_image, hauteur , largeur '. |
'FROM cel_images '. |
'WHERE id_image IN ( '. |
'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 nom_sel, nom_sel_nn, nom_ret, nom_ret_nn, nt, famille, zone_geo, ordre, date_observation, lieudit,' . |
'station, milieu, commentaire, transmission, ce_zone_geo 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).') AND ce_utilisateur = '.$this->proteger($uid[0]).' ' ; |
} |
|
} |
|
$resultat_selection_liaison = $this->executer($requete_selection_liaison); |
$resultat_selection_liaison = $this->requeter($requete_selection_liaison); |
|
$liaisons = array(); |
if (is_array($resultat_selection_liaison) && count($resultat_selection_liaison) > 0) { |
114,7 → 117,7 |
} |
|
$retour_encode = json_encode($liaisons) ; |
header("content-type: text/json") ; |
header("content-type: application/json") ; |
print $retour_encode ; |
exit() ; |
} |