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; |