Subversion Repositories eFlore/Applications.cel

Rev

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

Rev 757 Rev 848
Line 1... Line 1...
1
<?php
1
<?php
-
 
2
// ATTENTION ! Classe compatible uniquement avec nouveau format de bdd du cel //
Line 2... Line 3...
2
 
3
 
3
// in : utf8
4
// in : utf8
Line 4... Line 5...
4
// out : utf8
5
// out : utf8
Line 24... Line 25...
24
		 	
25
		 	
Line 25... Line 26...
25
			$condition_requete = $this->traiterParametresEtConstruireRequete($uid);
26
			$condition_requete = $this->traiterParametresEtConstruireRequete($uid);
26
		
27
		
27
		   	$requete_liste_dates = 'SELECT DISTINCT '.
28
		   	$requete_liste_dates = 'SELECT DISTINCT '.
28
	    			'date_observation AS id '.
29
	    			'date_observation AS id '.
Line 29... Line 30...
29
	           		'FROM cel_inventory WHERE '.$condition_requete.' '.
30
	           		'FROM cel_obs WHERE '.$condition_requete.' '.
Line 30... Line 31...
30
	           		'ORDER BY date_observation'; 		
31
	           		'ORDER BY date_observation'; 		
Line 57... Line 58...
57
        return $liste_dates;
58
        return $liste_dates;
58
	}
59
	}
Line 59... Line 60...
59
	
60
	
Line 60... Line 61...
60
	private function traiterParametresEtConstruireRequete($params) {
61
	private function traiterParametresEtConstruireRequete($params) {
Line 61... Line 62...
61
		
62
		
62
		$requete_condition = ' identifiant = '.$this->proteger($params[0]);
63
		$requete_condition = ' ce_utilisateur = '.$this->proteger($params[0]);
63
		
64
		
64
		$taille_tableau_parametres = count($params);
65
		$taille_tableau_parametres = count($params);