Subversion Repositories Applications.annuaire

Rev

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

Rev 215 Rev 247
Line 30... Line 30...
30
30
31 
		$requete_derniers_evenements = 'SELECT at_ressource as id_utilisateur, at_action as evenement, at_valeur as date_evenement '.
 31 
		$requete_derniers_evenements = 'SELECT at_ressource as id_utilisateur, at_action as evenement, at_valeur as date_evenement '.
32 
											'FROM annu_triples '.
 32 
											'FROM annu_triples '.
33 
											'WHERE at_ce_annuaire = '.$this->proteger($id_annuaire).' '.
 33 
											'WHERE at_ce_annuaire = '.$this->proteger($id_annuaire).' '.
34 
											'AND at_action = '.$this->proteger($type).' '.
 34 
											'AND at_action = '.$this->proteger($type).' '.
- 
 
 35 
											'ORDER BY at_valeur DESC ';
- 
 
 36
35 
											'ORDER BY at_valeur DESC '.
 37 
		if($limite != 0) {
- 
 
 38 
			$requete_derniers_evenements .= 'LIMIT 0,'.$limite;
- 
 
 39 
		}
Line 36... Line 40...
36 
											'LIMIT 0,'.$limite;
 40 
 
Line 37... Line 41...
37
41
38 
		$resultat_derniers_evenements = $this->requeteTous($requete_derniers_evenements);
 42 
		$resultat_derniers_evenements = $this->requeteTous($requete_derniers_evenements);
Line -... Line 43...
- 
 
 43
- 
 
 44 
		return $resultat_derniers_evenements;
- 
 
 45 
	}
- 
 
 46
- 
 
 47 
	public function obtenirEvenementsDansIntervalle($id_annuaire, $type, $date_debut, $date_fin) {
- 
 
 48
- 
 
 49 
		$requete_nb_modif_intervalle = 'SELECT COUNT(*) as nb '.
- 
 
 50 
										'FROM annu_triples '.
- 
 
 51 
										'WHERE at_ce_annuaire = '.$this->proteger($id_annuaire).' '.
- 
 
 52 
										'AND at_action = '.$this->proteger($type).' '.
- 
 
 53 
										'AND at_valeur >= "'.date('Y-m-d H:i:s', $date_debut).'" '.
- 
 
 54 
										'AND at_valeur < "'.date('Y-m-d H:i:s', $date_fin).'" ';
- 
 
 55
- 
 
 56 
		//echo $requete_nb_modif_intervalle;
- 
 
 57 
		//exit;
- 
 
 58
- 
 
 59 
		$resultat_nb_modif_intervalle = $this->requeteUn($requete_nb_modif_intervalle);
- 
 
 60
- 
 
 61 
		if(!$resultat_nb_modif_intervalle) {
- 
 
 62 
			return 0;
- 
 
 63 
		}
39
64 
 
Line 40... Line 65...
40 
		return $resultat_derniers_evenements;
 65 
		return $resultat_nb_modif_intervalle['nb'];
Line 41... Line 66...
41 
	}
 66 
	}