| Line 73... |
Line 73... |
| 73 |
public function obtenirChampsMappageAnnuaire($id_annuaire) {
|
73 |
public function obtenirChampsMappageAnnuaire($id_annuaire) {
|
| Line 74... |
Line 74... |
| 74 |
|
74 |
|
| Line 75... |
Line 75... |
| 75 |
$tableau_mappage = array();
|
75 |
$tableau_mappage = array();
|
| 76 |
|
76 |
|
| Line 77... |
Line 77... |
| 77 |
$requete_champs_mappage = 'SELECT * FROM annu_triples WHERE at_ce_annuaire = '.$this->proteger($id_annuaire).' '.
|
77 |
$requete_champs_mappage = 'SELECT * FROM annu_triples WHERE at_ce_annuaire = '.$this->proteger($id_annuaire).' '.
|
| Line 78... |
Line 78... |
| 78 |
"AND at_action IN ('champ_id', 'champ_mail', 'champ_nom', 'champ_prenom', 'champ_pass', 'champ_lettre','champ_pays', 'champ_code_postal', 'champ_ville')";
|
78 |
"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')";
|
| Line 88... |
Line 88... |
| 88 |
foreach ($resultat_champs_mappage as $champ) {
|
88 |
foreach ($resultat_champs_mappage as $champ) {
|
| 89 |
$tableau_mappage[0][$champ['at_action']] = $champ['at_ressource'];
|
89 |
$tableau_mappage[0][$champ['at_action']] = $champ['at_ressource'];
|
| 90 |
$tableau_mappage[1][$champ['at_action']] = $champ['at_valeur'];
|
90 |
$tableau_mappage[1][$champ['at_action']] = $champ['at_valeur'];
|
| 91 |
}
|
91 |
}
|
| Line 92... |
Line -... |
| 92 |
|
- |
|
| 93 |
//echo Debug::printr($tableau_mappage);
|
- |
|
| 94 |
|
92 |
|
| Line 95... |
Line 93... |
| 95 |
// TODO faire une interface de gestion des champs de mappage
|
93 |
// TODO faire une interface de gestion des champs de mappage
|
| 96 |
|
94 |
|
| Line 995... |
Line 993... |
| 995 |
if(isset($champs_date['champ_date_desinscription'])) {
|
993 |
if(isset($champs_date['champ_date_desinscription'])) {
|
| 996 |
$valeurs_mappees[$champs_date['champ_date_desinscription']] = 'NOW()';
|
994 |
$valeurs_mappees[$champs_date['champ_date_desinscription']] = 'NOW()';
|
| 997 |
}*/
|
995 |
}*/
|
| Line 998... |
Line 996... |
| 998 |
|
996 |
|
| 999 |
//if($supprimer_donnees) {
|
997 |
//if($supprimer_donnees) {
|
| 1000 |
$requete_suppression_utilisateur = 'DELETE FROM '.$resultat_infos_annuaire['aa_bdd'].'.'.$resultat_infos_annuaire['aa_table'].' '.
|
998 |
$requete_suppression_utilisateur = 'DELETE FROM '.$resultat_infos_annuaire['aa_bdd'].'.'.$resultat_infos_annuaire['aa_table'].' '.
|
| Line 1001... |
Line 999... |
| 1001 |
'WHERE '.$champs_mappage[0]['champ_id'].' = '.$this->proteger($id_utilisateur);
|
999 |
'WHERE '.$champs_mappage[0]['champ_id'].' = '.$this->proteger($id_utilisateur);
|
| Line 1002... |
Line 1000... |
| 1002 |
|
1000 |
|