Subversion Repositories eFlore/Applications.cel

Rev

Rev 2060 | Go to most recent revision | Show entire file | Regard whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 2060 Rev 2143
Line 59... Line 59...
59 
		$requete_recherche_images .= $sous_requete_recherche;
 59 
		$requete_recherche_images .= $sous_requete_recherche;
Line 60... Line 60...
60
60 
 
Line 61... Line 61...
61 
		$requete_recherche_images .= ' ORDER BY '.$ordre.' '.$direction.' LIMIT '.$debut.','.$limite ;
 61 
		$requete_recherche_images .= ' ORDER BY '.$ordre.' '.$direction.' LIMIT '.$debut.','.$limite ;
62 
 
 62 
 
Line 63... Line 63...
63 
		$resultats_images = array();
 63 
		$resultats_images = array();
64 
		$resultats_images = Cel::db()->executerRequete($requete_recherche_images);
 64 
		$resultats_images = Cel::db()->requeter($requete_recherche_images);
Line 65... Line 65...
65
65 
 
Line 87... Line 87...
87 
		$sous_requete_recherche = $this->fabriquerSousRequeteRecherche($id_utilisateur, $criteres);
 87 
		$sous_requete_recherche = $this->fabriquerSousRequeteRecherche($id_utilisateur, $criteres);
Line 88... Line 88...
88
88 
 
89 
		$requete_recherche_images .= $sous_requete_recherche;
 89 
		$requete_recherche_images .= $sous_requete_recherche;
Line 90... Line 90...
90 
		$nb_images = 0;
 90 
		$nb_images = 0;
Line 91... Line 91...
91 
 
 91 
 
92 
		$resultat_requete_nombre_images = Cel::db()->executerRequete($requete_recherche_images);
 92 
		$resultat_requete_nombre_images = Cel::db()->requeter($requete_recherche_images);
93
93 
 
Line 117... Line 117...
117
117 
 
Line 118... Line 118...
118 
	public function obtenirInformationsObservationsAssociees($id_utilisateur, $id_image) {
 118 
	public function obtenirInformationsObservationsAssociees($id_utilisateur, $id_image) {
Line 119... Line 119...
119
119 
 
Line 120... Line 120...
120 
		$requete_table_liaison = 'SELECT id_observation FROM cel_obs_images WHERE id_image = '.$id_image;
 120 
		$requete_table_liaison = 'SELECT id_observation FROM cel_obs_images WHERE id_image = '.$id_image;
Line 121... Line 121...
121
121 
 
122 
		$resultats_liaisons_images = Cel::db()->executerRequete($requete_table_liaison);
 122 
		$resultats_liaisons_images = Cel::db()->requeter($requete_table_liaison);
Line 129... Line 129...
129 
		$ids_obs = rtrim($ids_obs,',');
129 
		$ids_obs = rtrim($ids_obs,',');
130 
		$infos_obs = '';
 130 
		$infos_obs = '';
Line 131... Line 131...
131 
 
 131 
 
132 
		if(trim($ids_obs) != '') {
 132 
		if(trim($ids_obs) != '') {
133 
			$requete_obs_liees = 'SELECT * FROM cel_obs WHERE id_observation IN  ('.$ids_obs.') AND ce_utilisateur ="'.$id_utilisateur.'"';
 133 
			$requete_obs_liees = 'SELECT * FROM cel_obs WHERE id_observation IN  ('.$ids_obs.') AND ce_utilisateur ="'.$id_utilisateur.'"';
Line 134... Line 134...
134 
			$resultat_obs_liees = Cel::db()->executerRequete($requete_obs_liees);
 134 
			$resultat_obs_liees = Cel::db()->requeter($requete_obs_liees);
135 
 
 135 
 
136 
			foreach($resultat_obs_liees as $obs_liee)
 136 
			foreach($resultat_obs_liees as $obs_liee)
137 
			{
 137 
			{
Line 328... Line 328...
328
328 
 
329 
    public function obtenirCourrielUtilisateurPourIdImage($id_image) {
 329 
    public function obtenirCourrielUtilisateurPourIdImage($id_image) {
330 
	    $requete = 'SELECT courriel_utilisateur FROM cel_images WHERE '.
 330 
	    $requete = 'SELECT courriel_utilisateur FROM cel_images WHERE '.
Line 331... Line 331...
331 
	    			         'id_image = '.Cel::db()->proteger($id_image);
331 
	    			         'id_image = '.Cel::db()->proteger($id_image);
Line 332... Line 332...
332
332 
 
333 
	    $utilisateur_courriel = Cel::db()->executerRequete($requete);
 333 
	    $utilisateur_courriel = Cel::db()->requeter($requete);
334
334 
 
335 
	    $retour = false;
 335 
	    $retour = false;
Line 343... Line 343...
343
343 
 
344 
    	$requete_selection_mots_cles = 'SELECT DISTINCT id_mot_cle '.
 344 
    	$requete_selection_mots_cles = 'SELECT DISTINCT id_mot_cle '.
345 
    									   'FROM cel_mots_cles_images_liaison '.
 345 
    									   'FROM cel_mots_cles_images_liaison '.
Line 346... Line 346...
346 
    									   'WHERE id_element_lie = '.$id_image;
346 
    									   'WHERE id_element_lie = '.$id_image;
347
347 
 
Line 348... Line 348...
348 
    	return Cel::db()->executerRequete($requete_selection_mots_cles);
 348 
    	return Cel::db()->requeter($requete_selection_mots_cles);
349 
    }
 349 
    }