| 366,7 → 366,7 |
|---|
| * @param boolean $modele indique si l'on veut recherche la valeur exacte ou non |
| * @return array un tableau contenant la liste des inscrits dans l'annuaire donné, correspondants à ce critère |
| */ |
| public function rechercherInscritDansAnnuaireMappeParChamp($id_annuaire, $champ_critere, $valeur, $modele = false) { |
| public function rechercherInscritDansAnnuaireMappeParChamp($id_annuaire, $champ_critere, $valeur, $modele = false, $numero_page = 1, $taille_page = 50) { |
| |
| $sep = ''; |
| |
| 376,7 → 376,7 |
|---|
| |
| $valeurs = array($champ_critere => $valeur.$sep); |
| |
| return $this->rechercherInscritDansAnnuaireMappe($id_annuaire, $valeurs, array(), true); |
| return $this->rechercherInscritDansAnnuaireMappe($id_annuaire, $valeurs, array(), true, $numero_page, $taille_page); |
| } |
| |
| /** |
| 402,7 → 402,7 |
|---|
| |
| $string_champs_mappage = implode(",", $champs_mappage); |
| |
| $requete = 'SELECT '.$string_champs_mappage. |
| $requete = 'SELECT '.$champs_mappage['champ_id']. |
| ' FROM '.$annuaire['informations']['aa_bdd'].'.'.$annuaire['informations']['aa_table']. |
| ' ORDER BY '.$champs_mappage['champ_id']. |
| ' LIMIT '.(($numero_page-1)*$taille_page).','.($taille_page); |
| 1131,13 → 1131,13 |
|---|
| 'WHERE aa_id_annuaire = '.$id_annuaire.' '; |
| |
| $resultat_informations_annuaire = $this->requeteUn($requete_informations_annuaire); |
| |
| $champs_mappage = $this->obtenirChampsMappageAnnuaire($id_annuaire); |
| |
| $requete_recherche_inscrits = 'SELECT * '. |
| $requete_recherche_inscrits = 'SELECT '.$champs_mappage[0]['champ_id']. |
| ' FROM '.$resultat_informations_annuaire['aa_bdd'].'.'.$resultat_informations_annuaire['aa_table']. |
| ' WHERE '; |
| |
| $champs_mappage = $this->obtenirChampsMappageAnnuaire($id_annuaire); |
| |
| $requete_conditions_inscrits = ''; |
| |
| if($exclusive) { |
| 1170,14 → 1170,13 |
|---|
| $requete_conditions_inscrits = rtrim($requete_conditions_inscrits, $separateur); |
| |
| $requete_recherche_inscrits .= $requete_conditions_inscrits; |
| |
| $requete_nb_inscrits = 'SELECT COUNT( * ) as nb '.' FROM '.$resultat_informations_annuaire['aa_bdd'].'.'.$resultat_informations_annuaire['aa_table']; |
| |
| if(trim($requete_conditions_inscrits) == '') { |
| |
| if(trim($requete_conditions_inscrits) != '') { |
| $requete_nb_inscrits .= ' WHERE '.$requete_conditions_inscrits; |
| } |
| |
| $requete_nb_inscrits = 'SELECT COUNT( * ) as nb '.' FROM '.$resultat_informations_annuaire['aa_bdd'].'.'.$resultat_informations_annuaire['aa_table']. |
| ' WHERE '.$requete_conditions_inscrits; |
| |
| $resultat_nb_inscrits = $this->requeteUn($requete_nb_inscrits); |
| |
| $nb_inscrits = 0; |