| 32,14 → 32,39 |
|---|
| 'FROM annu_triples '. |
| 'WHERE at_ce_annuaire = '.$this->proteger($id_annuaire).' '. |
| 'AND at_action = '.$this->proteger($type).' '. |
| 'ORDER BY at_valeur DESC '. |
| 'LIMIT 0,'.$limite; |
| 'ORDER BY at_valeur DESC '; |
| |
| if($limite != 0) { |
| $requete_derniers_evenements .= 'LIMIT 0,'.$limite; |
| } |
| |
| |
| $resultat_derniers_evenements = $this->requeteTous($requete_derniers_evenements); |
| |
| return $resultat_derniers_evenements; |
| } |
| |
| public function obtenirEvenementsDansIntervalle($id_annuaire, $type, $date_debut, $date_fin) { |
| |
| $requete_nb_modif_intervalle = 'SELECT COUNT(*) as nb '. |
| 'FROM annu_triples '. |
| 'WHERE at_ce_annuaire = '.$this->proteger($id_annuaire).' '. |
| 'AND at_action = '.$this->proteger($type).' '. |
| 'AND at_valeur >= "'.date('Y-m-d H:i:s', $date_debut).'" '. |
| 'AND at_valeur < "'.date('Y-m-d H:i:s', $date_fin).'" '; |
| |
| //echo $requete_nb_modif_intervalle; |
| //exit; |
| |
| $resultat_nb_modif_intervalle = $this->requeteUn($requete_nb_modif_intervalle); |
| |
| if(!$resultat_nb_modif_intervalle) { |
| return 0; |
| } |
| |
| return $resultat_nb_modif_intervalle['nb']; |
| } |
| |
| public function ajouterEvenementStatistique($id_annuaire, $id_utilisateur, $type) { |
| |
| $date_courante = AppControleur::genererDateCouranteFormatMySql(); |