Subversion Repositories eFlore/Applications.cel

Rev

Rev 898 | Rev 996 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 898 Rev 974
Line 49... Line 49...
49 
		{
 49 
		{
50 
			foreach($ids_observations_liste as $observation)
 50 
			foreach($ids_observations_liste as $observation)
51 
			{
 51 
			{
52 
				$requete_creation_lien = 'INSERT INTO cel_obs_images (id_image, id_utilisateur, id_observation, date_liaison) '.
 52 
				$requete_creation_lien = 'INSERT INTO cel_obs_images (id_image, id_utilisateur, id_observation, date_liaison) '.
53 
					   	 'VALUES '.
53 
					   	 'VALUES '.
54 
						 '("'.$this->proteger($image).'","'.$this->proteger($utilisateur).'","'.$this->proteger($observation).'", NOW()) '.
 54 
						 '('.$this->proteger($image).','.$this->proteger($utilisateur).','.$this->proteger($observation).', NOW()) '.
55 
						 'ON DUPLICATE KEY UPDATE id_image = id_image' ;
 55 
						 'ON DUPLICATE KEY UPDATE id_image = id_image' ;
Line 56... Line 56...
56
56
- 
 
 57 
				$resultat_creation_lien = $this->executer($requete_creation_lien);
57 
				$resultat_creation_lien = $this->executer($requete_creation_lien);
 58
58 
				if ($resultat_creation_lien) {
 59 
				if ($resultat_creation_lien) {
59 
					$retour = "OK";
 60 
					$retour = "OK";
60 
				}
 61 
				}
61 
			}
 62 
			}
Line 78... Line 79...
78 
		$this->controleUtilisateur($uid[0]);
 79 
		$this->controleUtilisateur($uid[0]);
Line 79... Line 80...
79 
 
 80 
 
Line 80... Line 81...
80 
		if($uid) {
 81 
		if($uid) {
81 
 
 - 
 
Line 82... Line 82...
82 
			$param = $uid[1] ;
 82 
 
Line 83... Line 83...
83 
			$param = ltrim($param,'&') ;
 83 
			$param = $uid[1] ;
84 
 
 84 
 
Line 90... Line 90...
90 
			$requete_selection_liaison = "" ;
 90 
			$requete_selection_liaison = "" ;
Line 91... Line 91...
91 
 
 91 
 
92 
			if ($field == 'id_observation')
 92 
			if ($field == 'id_observation')
93 
			{
 93 
			{
94 
				$column = 'id_image' ;
 94 
				$column = 'id_image' ;
- 
 
 95 
				$requete_selection_liaison = 'SELECT id_image, hauteur , largeur '.
- 
 
 96 
						 'FROM cel_images '.
- 
 
 97 
						 'WHERE id_image IN ( '.
95 
				$requete_selection_liaison = 'SELECT cel_obs_images.id_image, hauteur , largeur '.
 98 
						 	'SELECT id_image '.
96 
						 'FROM cel_obs_images, cel_images '.
 99 
							'FROM cel_obs_images '.
97 
						 'WHERE cel_obs_images.id_image = cel_images.id_image '.
 100 
							'WHERE id_observation = '.$this->proteger($value).' '.
- 
 
 101 
							'AND id_utilisateur = '.$this->proteger($uid[0]).' '.
98 
						 'AND id_observation = '.$this->proteger($value).' AND id_utilisateur = '.$this->proteger($uid[0]) ;
 102 
						 ')';
99 
			}
 103 
			}
100 
			else
 104 
			else
101 
			{
 105 
			{
102 
				$column = 'id_observation' ;
 - 
 
103 
				$requete_selection_liaison = 'SELECT nom_sel, nom_sel_nn, nom_ret, nom_ret_nn, nt, famille, zone_geo, ordre, date_observation, lieudit,' .
 106 
				$column = 'id_observation' ;
104 
 				'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]).' "' ;
 107 
				$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]).' ' ;
Line 105... Line 108...
105 
			}
 108 
			}
Line 106... Line 109...
106 
 
 109 
 
Line 107... Line 110...
107 
		}
 110 
		}
108 
 
 111 
 
109 
		$resultat_selection_liaison = $this->executer($requete_selection_liaison);
 112 
		$resultat_selection_liaison = $this->requeter($requete_selection_liaison);
110
113
Line 111... Line 114...
111 
		$liaisons = array();
 114 
		$liaisons = array();
112 
        if (is_array($resultat_selection_liaison) && count($resultat_selection_liaison) > 0) {
 115 
        if (is_array($resultat_selection_liaison) && count($resultat_selection_liaison) > 0) {
113 
			$liaisons = $resultat_selection_liaison;
 116 
			$liaisons = $resultat_selection_liaison;
114 
        }
 117 
        }
115 
 
 118 
 
Line 116... Line 119...
116 
		$retour_encode = json_encode($liaisons) ;
 119 
		$retour_encode = json_encode($liaisons) ;