WebSVN – Applications.annuaire – Diff – /trunk/modeles/GestionAnnuaireModele.php


<?php
// declare(encoding='UTF-8');
/**
 * Modèle d'accès à la base de données des listes
 * d'ontologies
 *
 * PHP Version 5
 *
 * @package   Framework
 * @category  Class
 * @author	aurelien <aurelien@tela-botanica.org>
 * @copyright 2009 Tela-Botanica
 * @license   http://www.cecill.info/licences/Licence_CeCILL_V2-fr.txt Licence CECILL
 * @license   http://www.gnu.org/licenses/gpl.html Licence GNU-GPL
 * @version   SVN: $$Id: ListeAdmin.php 128 2009-09-02 12:20:55Z aurelien $$
 * @link	  /doc/framework/
 *
 */
class GestionAnnuaireModele extends Modele {
	
	public function verifierPresenceTable($bdd, $nom_table) {
		
		if(!$bdd || !$nom_table) {
			return false;
		}
		
		$requete_presence_table = 'SELECT * FROM information_schema.tables
		WHERE TABLE_SCHEMA = '.$this->proteger($bdd).' AND TABLE_NAME = '.$this->proteger($nom_table);
		
		$presence_table = $this->requeteUn($requete_presence_table);
		
		return $presence_table;
	}
	
	public function verifierPresenceChamps($bdd, $nom_table, $champs_a_verifier) {
		
		$tableau_champs_table = $this->obtenirListeNomsChampsAnnuaireParBddNomTable($bdd, $nom_table);
 
		foreach($champs_a_verifier as $champ) {
			if(!in_array($champ, $tableau_champs_table)) {
				return false;
			}
		}
		
		return $resultat;
	}
	
	public function obtenirListeNomsChampsAnnuaireParBddNomTable($bdd, $nom_table) {
		
		if(!$bdd || !$nom_table) {
			return false;
		}
 
		$requete = 'DESCRIBE '.$bdd.'.'.$nom_table;
		
		$resultat = $this->requeteTous($requete);
		
		if(!$resultat) {
			return false;
		}
		
		$tableau_champs_table = array();;
		
		foreach($resultat as $champ_table) {
			$tableau_champs_table[] = $champ_table['Field'];
		}
		
		return $tableau_champs_table;
	}
	
	public function obtenirListeNomsChampsAnnuaireParIdAnnuaire($id_annuaire) {
		
		
		$requete_selection_bdd_table =  'SELECT aa_bdd, aa_table FROM annu_annuaire '.
					' WHERE aa_id_annuaire = '.$this->proteger($id_annuaire);
		
		$resultat_selection_bdd_table = $this->requeteUn($requete_selection_bdd_table);
			
		if(!$resultat_selection_bdd_table) {
			return array();
		}
		
		return $this->obtenirListeNomsChampsAnnuaireParBddNomTable($resultat_selection_bdd_table['aa_bdd'], $resultat_selection_bdd_table['aa_table']);
	}
	
	public function ajouterAnnuaire($informations) {
		
		if(!$informations) {
			return false;
		}
								
		$valeurs_prot = array_map(array($this,'proteger'),$informations);
		
		$valeurs = implode(',',$valeurs_prot);
		$champs = implode(',',array_keys($informations));
 
		$requete_insertion_annuaire =  'INSERT INTO annu_annuaire '.
					'('.$champs.') '.
					'VALUES ('.$valeurs.')';
		
		$resultat_insertion_annuaire = $this->requete($requete_insertion_annuaire);
		
		$id_annuaire = false;
		
		if($resultat_insertion_annuaire) {
			
			$requete_selection_annuaire =  'SELECT aa_id_annuaire FROM annu_annuaire '.
					' WHERE aa_code = '.$this->proteger($informations['aa_code']);
			
			$resultat_selection_annuaire = $this->requeteUn($requete_selection_annuaire);
			
			if($resultat_selection_annuaire) {
				$id_annuaire = $resultat_selection_annuaire['aa_id_annuaire'];
			}
		}
		
		return $id_annuaire;
	}
	
	public function creerTableAnnuaire($informations_table, $informations_champs) {
				
		$nom_bdd = $informations_table['aa_bdd'];
		$nom_table = $informations_table['aa_table'];
		
		$champ_id = $informations_champs['aa_champ_id'];
		$champ_nom = $informations_champs['aa_champ_nom'];
		$champ_mail = $informations_champs['aa_champ_mail'];
		$champ_mot_de_passe = $informations_champs['aa_champ_pass'];
 
 
 
 
 
 
 
 
		
		$requete_creation_table = 'CREATE TABLE '.$nom_bdd.'.'.$nom_table.' '.
									'('.$champ_id.' INT NOT NULL AUTO_INCREMENT PRIMARY KEY,'. 
									$champ_nom.' VARCHAR(255) NOT NULL, '. 
									$champ_mail.' VARCHAR(255) NOT NULL, '. 
 
 
 
 
									$champ_mot_de_passe.' VARCHAR(255) NOT NULL)';
		
		return $this->requete($requete_creation_table);
		
	}
	
	/**
	 * Charge la liste complète des champs d'un annuaire
	 * @param int $identifiant l'identifiant de l'annuaire demandé
	 * @param boolean $charger_liste_champs indique si l'on doit ou non charger la liste des noms des champs
	 * @return array un tableau contenant des objets d'informations sur les annuaires
	 */
   	public function chargerAnnuaire($identifiant, $charger_liste_champs = true) {
 
		$requete = 	'SELECT * '.
					'FROM  annu_annuaire '.
					'WHERE aa_id_annuaire = '.$identifiant.' ';
		$resultat = $this->requeteTous($requete);
		$annuaire = array();
		foreach ($resultat as $ligne) {
			$annuaire['informations'] = $ligne;
		}
 
		if($charger_liste_champs) {
			$requete = 'DESCRIBE '.$annuaire['informations']['aa_bdd'].'.'.$annuaire['informations']['aa_table'];
			$resultat = $this->requeteTous($requete);
			foreach ($resultat as $colonne) {
				$annuaire['colonnes'][] = $colonne;
			}
		}
 
		return $annuaire;
	}
}

Rev 162	Rev 167
1	`<?php`	1	`<?php`
2	`// declare(encoding='UTF-8');`	2	`// declare(encoding='UTF-8');`
3	`/**`	3	`/**`
4	`* Modèle d'accès à la base de données des listes`	4	`* Modèle d'accès à la base de données des listes`
5	`* d'ontologies`	5	`* d'ontologies`
6	`*`	6	`*`
7	`* PHP Version 5`	7	`* PHP Version 5`
8	`*`	8	`*`
9	`* @package Framework`	9	`* @package Framework`
10	`* @category Class`	10	`* @category Class`
11	`* @author aurelien <aurelien@tela-botanica.org>`	11	`* @author aurelien <aurelien@tela-botanica.org>`
12	`* @copyright 2009 Tela-Botanica`	12	`* @copyright 2009 Tela-Botanica`
13	`* @license http://www.cecill.info/licences/Licence_CeCILL_V2-fr.txt Licence CECILL`	13	`* @license http://www.cecill.info/licences/Licence_CeCILL_V2-fr.txt Licence CECILL`
14	`* @license http://www.gnu.org/licenses/gpl.html Licence GNU-GPL`	14	`* @license http://www.gnu.org/licenses/gpl.html Licence GNU-GPL`
15	`* @version SVN: $$Id: ListeAdmin.php 128 2009-09-02 12:20:55Z aurelien $$`	15	`* @version SVN: $$Id: ListeAdmin.php 128 2009-09-02 12:20:55Z aurelien $$`
16	`* @link /doc/framework/`	16	`* @link /doc/framework/`
17	`*`	17	`*`
18	`*/`	18	`*/`
19	`class GestionAnnuaireModele extends Modele {`	19	`class GestionAnnuaireModele extends Modele {`
20		20
21	`public function verifierPresenceTable($bdd, $nom_table) {`	21	`public function verifierPresenceTable($bdd, $nom_table) {`
22		22
23	`if(!$bdd \|\| !$nom_table) {`	23	`if(!$bdd \|\| !$nom_table) {`
24	`return false;`	24	`return false;`
25	`}`	25	`}`
26		26
-		27	`$requete_presence_table = 'SELECT * FROM information_schema.tables`
27	`$requete = 'DESCRIBE '.$bdd.'.'.$nom_table;`	28	`WHERE TABLE_SCHEMA = '.$this->proteger($bdd).' AND TABLE_NAME = '.$this->proteger($nom_table);`
28		29
29	`$resultat = $this->requeteUn($requete);`	30	`$presence_table = $this->requeteUn($requete_presence_table);`
30		31
31	`return $resultat;`	32	`return $presence_table;`
32	`}`	33	`}`
33		34
34	`public function verifierPresenceChamps($bdd, $nom_table, $champs_a_verifier) {`	35	`public function verifierPresenceChamps($bdd, $nom_table, $champs_a_verifier) {`
35		36
36	`$tableau_champs_table = $this->obtenirListeNomsChampsAnnuaireParBddNomTable($bdd, $nom_table);`	37	`$tableau_champs_table = $this->obtenirListeNomsChampsAnnuaireParBddNomTable($bdd, $nom_table);`
37		38
38	`foreach($champs_a_verifier as $champ) {`	39	`foreach($champs_a_verifier as $champ) {`
39	`if(!in_array($champ, $tableau_champs_table)) {`	40	`if(!in_array($champ, $tableau_champs_table)) {`
40	`return false;`	41	`return false;`
41	`}`	42	`}`
42	`}`	43	`}`
43		44
44	`return $resultat;`	45	`return $resultat;`
45	`}`	46	`}`
46		47
47	`public function obtenirListeNomsChampsAnnuaireParBddNomTable($bdd, $nom_table) {`	48	`public function obtenirListeNomsChampsAnnuaireParBddNomTable($bdd, $nom_table) {`
48		49
49	`if(!$bdd \|\| !$nom_table) {`	50	`if(!$bdd \|\| !$nom_table) {`
50	`return false;`	51	`return false;`
51	`}`	52	`}`
52		53
53	`$requete = 'DESCRIBE '.$bdd.'.'.$nom_table;`	54	`$requete = 'DESCRIBE '.$bdd.'.'.$nom_table;`
54		55
55	`$resultat = $this->requeteTous($requete);`	56	`$resultat = $this->requeteTous($requete);`
56		57
57	`if(!$resultat) {`	58	`if(!$resultat) {`
58	`return false;`	59	`return false;`
59	`}`	60	`}`
60		61
61	`$tableau_champs_table = array();;`	62	`$tableau_champs_table = array();;`
62		63
63	`foreach($resultat as $champ_table) {`	64	`foreach($resultat as $champ_table) {`
64	`$tableau_champs_table[] = $champ_table['Field'];`	65	`$tableau_champs_table[] = $champ_table['Field'];`
65	`}`	66	`}`
66		67
67	`return $tableau_champs_table;`	68	`return $tableau_champs_table;`
68	`}`	69	`}`
69		70
70	`public function obtenirListeNomsChampsAnnuaireParIdAnnuaire($id_annuaire) {`	71	`public function obtenirListeNomsChampsAnnuaireParIdAnnuaire($id_annuaire) {`
71		72
72		73
73	`$requete_selection_bdd_table = 'SELECT aa_bdd, aa_table FROM annu_annuaire '.`	74	`$requete_selection_bdd_table = 'SELECT aa_bdd, aa_table FROM annu_annuaire '.`
74	`' WHERE aa_id_annuaire = '.$this->proteger($id_annuaire);`	75	`' WHERE aa_id_annuaire = '.$this->proteger($id_annuaire);`
75		76
76	`$resultat_selection_bdd_table = $this->requeteUn($requete_selection_bdd_table);`	77	`$resultat_selection_bdd_table = $this->requeteUn($requete_selection_bdd_table);`
77		78
78	`if(!$resultat_selection_bdd_table) {`	79	`if(!$resultat_selection_bdd_table) {`
79	`return array();`	80	`return array();`
80	`}`	81	`}`
81		82
82	`return $this->obtenirListeNomsChampsAnnuaireParBddNomTable($resultat_selection_bdd_table['aa_bdd'], $resultat_selection_bdd_table['aa_table']);`	83	`return $this->obtenirListeNomsChampsAnnuaireParBddNomTable($resultat_selection_bdd_table['aa_bdd'], $resultat_selection_bdd_table['aa_table']);`
83	`}`	84	`}`
84		85
85	`public function ajouterAnnuaire($informations) {`	86	`public function ajouterAnnuaire($informations) {`
86		87
87	`if(!$informations) {`	88	`if(!$informations) {`
88	`return false;`	89	`return false;`
89	`}`	90	`}`
90		91
91	`$valeurs_prot = array_map(array($this,'proteger'),$informations);`	92	`$valeurs_prot = array_map(array($this,'proteger'),$informations);`
92		93
93	`$valeurs = implode(',',$valeurs_prot);`	94	`$valeurs = implode(',',$valeurs_prot);`
94	`$champs = implode(',',array_keys($informations));`	95	`$champs = implode(',',array_keys($informations));`
95		96
96	`$requete_insertion_annuaire = 'INSERT INTO annu_annuaire '.`	97	`$requete_insertion_annuaire = 'INSERT INTO annu_annuaire '.`
97	`'('.$champs.') '.`	98	`'('.$champs.') '.`
98	`'VALUES ('.$valeurs.')';`	99	`'VALUES ('.$valeurs.')';`
99		100
100	`$resultat_insertion_annuaire = $this->requete($requete_insertion_annuaire);`	101	`$resultat_insertion_annuaire = $this->requete($requete_insertion_annuaire);`
101		102
102	`$id_annuaire = false;`	103	`$id_annuaire = false;`
103		104
104	`if($resultat_insertion_annuaire) {`	105	`if($resultat_insertion_annuaire) {`
105		106
106	`$requete_selection_annuaire = 'SELECT aa_id_annuaire FROM annu_annuaire '.`	107	`$requete_selection_annuaire = 'SELECT aa_id_annuaire FROM annu_annuaire '.`
107	`' WHERE aa_code = '.$this->proteger($informations['aa_code']);`	108	`' WHERE aa_code = '.$this->proteger($informations['aa_code']);`
108		109
109	`$resultat_selection_annuaire = $this->requeteUn($requete_selection_annuaire);`	110	`$resultat_selection_annuaire = $this->requeteUn($requete_selection_annuaire);`
110		111
111	`if($resultat_selection_annuaire) {`	112	`if($resultat_selection_annuaire) {`
112	`$id_annuaire = $resultat_selection_annuaire['aa_id_annuaire'];`	113	`$id_annuaire = $resultat_selection_annuaire['aa_id_annuaire'];`
113	`}`	114	`}`
114	`}`	115	`}`
115		116
116	`return $id_annuaire;`	117	`return $id_annuaire;`
117	`}`	118	`}`
118		119
119	`public function creerTableAnnuaire($informations_table, $informations_champs) {`	120	`public function creerTableAnnuaire($informations_table, $informations_champs) {`
-		121
-		122	`$nom_bdd = $informations_table['aa_bdd'];`
-		123	`$nom_table = $informations_table['aa_table'];`
-		124
-		125	`$champ_id = $informations_champs['aa_champ_id'];`
-		126	`$champ_nom = $informations_champs['aa_champ_nom'];`
-		127	`$champ_mail = $informations_champs['aa_champ_mail'];`
-		128	`$champ_mot_de_passe = $informations_champs['aa_champ_pass'];`
120		-
121	`$nom_bdd = $this->proteger($informations_table['nom_bdd']);`	-
122	`$nom_table = $this->proteger($informations_table['nom_table']);`	-
123		-
124	`$champ_id = $this->proteger($informations_champs['champ_id']);`	-
125	`$champ_nom = $this->proteger($informations_champs['champ_id']);`	-
126	`$champ_mail = $this->proteger($informations_champs['champ_id']);`	-
127	`$champ_mot_de_passe = $this->proteger($informations_champs['champ_id']);`	-
128		129
129	`$requete_creation_table = 'CREATE TABLE '.$bdd.'.'.$nom_table.' '.`	130	`$requete_creation_table = 'CREATE TABLE '.$nom_bdd.'.'.$nom_table.' '.`
130	`'('.$champ_id.' INT NOT NULL AUTO_INCREMENT PRIMARY KEY,'.`	131	`'('.$champ_id.' INT NOT NULL AUTO_INCREMENT PRIMARY KEY,'.`
131	`$champ_nom.' TEXT NOT NULL,'.`	132	`$champ_nom.' VARCHAR(255) NOT NULL, '.`
132	`$champ_mail.' TEXT NOT NULL)'.`	133	`$champ_mail.' VARCHAR(255) NOT NULL, '.`
133	`$champ_mot_de_passe.' TEXT NOT NULL)';`	-
134	`//'ENGINE = MyISAM' ;`	-
135		-
136	`echo $requete_creation_table;`	-
137	`exit;`	134	`$champ_mot_de_passe.' VARCHAR(255) NOT NULL)';`
138		135
139	`return $this->requete($requete_creation_table);`	136	`return $this->requete($requete_creation_table);`
140		137
141	`}`	138	`}`
142		139
143	`/**`	140	`/**`
144	`* Charge la liste complète des champs d'un annuaire`	141	`* Charge la liste complète des champs d'un annuaire`
145	`* @param int $identifiant l'identifiant de l'annuaire demandé`	142	`* @param int $identifiant l'identifiant de l'annuaire demandé`
146	`* @param boolean $charger_liste_champs indique si l'on doit ou non charger la liste des noms des champs`	143	`* @param boolean $charger_liste_champs indique si l'on doit ou non charger la liste des noms des champs`
147	`* @return array un tableau contenant des objets d'informations sur les annuaires`	144	`* @return array un tableau contenant des objets d'informations sur les annuaires`
148	`*/`	145	`*/`
149	`public function chargerAnnuaire($identifiant, $charger_liste_champs = true) {`	146	`public function chargerAnnuaire($identifiant, $charger_liste_champs = true) {`
150		147
151	`$requete = 'SELECT * '.`	148	`$requete = 'SELECT * '.`
152	`'FROM annu_annuaire '.`	149	`'FROM annu_annuaire '.`
153	`'WHERE aa_id_annuaire = '.$identifiant.' ';`	150	`'WHERE aa_id_annuaire = '.$identifiant.' ';`
154	`$resultat = $this->requeteTous($requete);`	151	`$resultat = $this->requeteTous($requete);`
155	`$annuaire = array();`	152	`$annuaire = array();`
156	`foreach ($resultat as $ligne) {`	153	`foreach ($resultat as $ligne) {`
157	`$annuaire['informations'] = $ligne;`	154	`$annuaire['informations'] = $ligne;`
158	`}`	155	`}`
159		156
160	`if($charger_liste_champs) {`	157	`if($charger_liste_champs) {`
161	`$requete = 'DESCRIBE '.$annuaire['informations']['aa_bdd'].'.'.$annuaire['informations']['aa_table'];`	158	`$requete = 'DESCRIBE '.$annuaire['informations']['aa_bdd'].'.'.$annuaire['informations']['aa_table'];`
162	`$resultat = $this->requeteTous($requete);`	159	`$resultat = $this->requeteTous($requete);`
163	`foreach ($resultat as $colonne) {`	160	`foreach ($resultat as $colonne) {`
164	`$annuaire['colonnes'][] = $colonne;`	161	`$annuaire['colonnes'][] = $colonne;`
165	`}`	162	`}`
166	`}`	163	`}`
167		164
168	`return $annuaire;`	165	`return $annuaire;`
169	`}`	166	`}`
170	`}`	167	`}`

Subversion Repositories Applications.annuaire

(root)/trunk/modeles/GestionAnnuaireModele.php @ 616 – Rev 162 → 167