Subversion Repositories eFlore/Applications.del

Rev

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

Rev 1168 Rev 1171
Line 178... Line 178...
178 
		$champs = array('dob.id_observation as id_observation', 'nom_ret', 'nom_ret_nn', 'nt', 'famille', 'ce_zone_geo', 'zone_geo',
178 
		$champs = array('dob.id_observation as id_observation', 'nom_ret', 'nom_ret_nn', 'nt', 'famille', 'ce_zone_geo', 'zone_geo',
179 
						'lieudit', 'station', 'milieu', 'date_observation', 'dob.mots_cles_texte as mots_cles_texte', 'dob.commentaire as commentaire',
179 
						'lieudit', 'station', 'milieu', 'date_observation', 'dob.mots_cles_texte as mots_cles_texte', 'dob.commentaire as commentaire',
180 
						'di.mots_cles_texte as mots_cles_texte_image ', 'date_transmission', 'di.id_image as id_image', 'di.ce_utilisateur as ce_utilisateur',
180 
						'di.mots_cles_texte as mots_cles_texte_image ', 'date_transmission', 'di.id_image as id_image', 'di.ce_utilisateur as ce_utilisateur',
181 
						'prenom', 'nom', 'courriel', 'nom_original');
 181 
						'prenom', 'nom', 'courriel', 'nom_original');
Line 182... Line 182...
182
182
183 
		$requeteLiaisons = 'SELECT DISTINCT SQL_CALC_FOUND_ROWS '.implode(', ',$champs).', '.
 183 
		$requeteLiaisons = 'SELECT SQL_CALC_FOUND_ROWS '.implode(', ',$champs).', '.
184 
						   'AVG(dvote.valeur) as moyenne_votes '.
 184 
						   'AVG(dvote.valeur) as moyenne_votes '.
185 
						   'FROM '.$this->gestionBdd->formaterTable('del_obs_image', 'doi').
 185 
						   'FROM '.$this->gestionBdd->formaterTable('del_obs_image', 'doi').
186 
						   'INNER JOIN del_image di '.
 186 
						   'INNER JOIN del_image di '.
187 
						   'ON doi.id_image = di.id_image '.
 187 
						   'ON doi.id_image = di.id_image '.