Subversion Repositories Applications.annuaire

Rev

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

Rev 5 Rev 7
Line 65... Line 65...
65 
		return $annuaire;
 65 
		return $annuaire;
66 
	}
 66 
	}
Line 67... Line 67...
67 
 
 67 
 
68 
	/**
 68 
	/**
- 
 
 69 
	 * Charge les inscrits d'une table annuaire mappée, en ne conservant que les champs de mappage indiqués
69 
	 * Charge les inscrits d'une table annuaire mappée, en ne conservant que les champs de mappage indiqués
 70 
	 *
70 
	 */
 71 
	 */
Line 71... Line 72...
71 
   	public function chargerAnnuaireListeInscrits($identifiant, $champs_mappage, $page, $taille_page = 50) {
 72 
   	public function chargerAnnuaireListeInscrits($identifiant, $champs_mappage, $numero_page, $taille_page = 50) {
72 
 
 73 
 
73 
		$requete = 	'SELECT * '.
 74 
		$requete = 	'SELECT * '.
74 
					'FROM  annu_annuaire '.
 75 
					'FROM  annu_annuaire '.
Line 81... Line 82...
81 
 
 82 
 
Line 82... Line 83...
82 
		$annuaire['colonnes'] = $champs_mappage;
 83 
		$annuaire['colonnes'] = $champs_mappage;
Line -... Line 84...
- 
 
 84 
 
83 
 
 85 
		$string_champs_mappage = implode(",", $champs_mappage);
- 
 
 86 
 
- 
 
 87 
		$requete = 'SELECT '.$string_champs_mappage.
Line 84... Line 88...
84 
		$string_champs_mappage = implode(",", $champs_mappage);
 88 
				' FROM '.$annuaire['informations']['aa_bdd'].'.'.$annuaire['informations']['aa_table'].
85 
 
 89 
				' ORDER BY '.$champs_mappage['champ_id'].
86 
		$requete = 'SELECT '.$string_champs_mappage.' FROM '.$annuaire['informations']['aa_bdd'].'.'.$annuaire['informations']['aa_table'].' LIMIT '.($page-1).','.($page*$taille_page);
 90 
				' LIMIT '.(($numero_page-1)*$taille_page).','.($taille_page);
87 
 
 91