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