Subversion Repositories Applications.annuaire

Rev

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

Rev 124 Rev 142
Line 36... Line 36...
36 
		return $annuaires;
 36 
		return $annuaires;
37 
	}
 37 
	}
Line 38... Line 38...
38
38
Line 39... Line 39...
39 
	/*public function migrer() {
 39 
	/*public function migrer() {
Line 40... Line 40...
40
40
Line 41... Line 41...
41 
		$requete = 'SELECT U_COUNTRY, U_ID FROM tela_prod.annuaire_tela';
 41 
		$requete = 'SELECT * FROM tela_prod.annuaire_tela';
42
42
Line 85... Line 85...
85 
	public function obtenirChampsMappageAnnuaire($id_annuaire) {
 85 
	public function obtenirChampsMappageAnnuaire($id_annuaire) {
Line 86... Line 86...
86 
 
 86 
 
Line 87... Line 87...
87 
		$tableau_mappage = array();
 87 
		$tableau_mappage = array();
88 
 
 88 
 
Line 89... Line 89...
89 
		$requete_champs_mappage = 'SELECT * FROM annu_triples WHERE at_ce_annuaire = '.$this->proteger($id_annuaire).' '.
 89 
		$requete_champs_mappage = 'SELECT * FROM annu_triples WHERE at_ce_annuaire = '.$this->proteger($id_annuaire).' '.
Line 90... Line 90...
90 
		"AND at_action IN ('champ_id', 'champ_mail', 'champ_nom', 'champ_prenom', 'champ_pass', 'champ_lettre','champ_pays', 'champ_code_postal', 'champ_ville', 'champ_date_inscription')";
 90 
		"AND at_action IN ('champ_id', 'champ_mail', 'champ_nom', 'champ_prenom', 'champ_pass', 'champ_lettre','champ_pays', 'champ_code_postal', 'champ_ville', 'champ_adresse', 'champ_adresse_comp', 'champ_date_inscription')";