WebSVN – Applications.gtt – Diff – /trunk/bibliotheque/metier/AbsenceMotif.class.php


<?php
// +------------------------------------------------------------------------------------------------------+
// | PHP version 5.1.1                                                                                    |
// +------------------------------------------------------------------------------------------------------+
// | Copyright (C) 2006 Tela Botanica (accueil@tela-botanica.org)                                         |
// +------------------------------------------------------------------------------------------------------+
// | This file is part of eFlore.                                                                         |
// |                                                                                                      |
// | Foobar is free software; you can redistribute it and/or modify                                       |
// | it under the terms of the GNU General Public License as published by                                 |
// | the Free Software Foundation; either version 2 of the License, or                                    |
// | (at your option) any later version.                                                                  |
// |                                                                                                      |
// | Foobar is distributed in the hope that it will be useful,                                            |
// | but WITHOUT ANY WARRANTY; without even the implied warranty of                                       |
// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the                                        |
// | GNU General Public License for more details.                                                         |
// |                                                                                                      |
// | You should have received a copy of the GNU General Public License                                    |
// | along with Foobar; if not, write to the Free Software                                                |
// | Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA                            |
// +------------------------------------------------------------------------------------------------------+
// CVS : $Id$
/**
* Classe AbsenceMotif
*
* Description
*
*@package eFlore
*@subpackage modele
//Auteur original :
*@version 3
*@author        Shaheen ABDOOL RAHEEM <shaheenar50@hotmail.com>
//Autres auteurs :
*@version 4
*@author        Jean-Pascal MILCENT <jpm@clapas.org>
*@author        aucun
*@copyright     Tela-Botanica 2000-2006
*@version       $Revision$ $Date$
// +------------------------------------------------------------------------------------------------------+
*/
 
/**
* class AbsenceMotif : est à la fois le DAO et le conteneur de la table gestion_utilisateur.
* classe métier
*/
class AbsenceMotif extends aGttSql {
	/*** Constantes : */
	const GAM_TOUS = 'ABSENCEMOTIF_TOUS';
	const GAM_ID = 'ABSENCEMOTIF_ID';
	const GAM_ID_MAX = 'ABSENCEMOTIF_ID_MAX';
	const GAM_LIBELLE = 'ABSENCEMOTIF_LIBELLE';
 
	/*** Attributs : */
	private $id_absence_motif;
	private $libelle;
	private $mark_cp_diminuer;
	private $mark_hs_augmenter;
	private $mark_hs_diminuer;
	
	/*** Aggregations : */
 
	/*** Constructeur : */
	public function __construct($cmd = null, $parametres = null)
	{
		$this->dao_table_nom = 'gestion_absence_motif';
		$this->dao_correspondance = array(
			'gam_id_absence_motif'	=> 'id_absence_motif',
			'gam_libelle'	=> 'libelle',
			'gam_mark_cp_diminuer'	=> 'mark_cp_diminuer',
			'gam_mark_hs_augmenter'	=> 'mark_hs_augmenter',
			'gam_mark_hs_diminuer'	=> 'mark_hs_diminuer');
 
		// Si l'on veut remplir l'objet à la création on lance la requete correspondante
		if (!is_null($cmd)) {
			$this->consulter($cmd, $parametres, true);
		}
	}
 
	/*** Accesseurs : */
	// Id Absence Motif
	public function getIdAbsenceMotif()
	{
		return $this->id_absence_motif;
	}
	public function setIdAbsenceMotif( $iam )
	{
		$this->id_absence_motif = $iam;
	}
 
	// Libelle
	public function getLibelle()
	{
		return $this->libelle;
	}
	public function setLibelle( $l )
	{
		$this->libelle = $l;
	}
 
	// CP Diminuer
	public function getMarkCpDiminuer()
	{
		return $this->mark_cp_diminuer;
	}
	public function setMarkCpDiminuer( $cd )
	{
		$this->mark_cp_diminuer = $cd;
	}
 
	// HS Augmenter
	public function getMarkHsAugmenter()
	{
		return $this->mark_hs_augmenter;
	}
	public function setMarkHsAugmenter( $ha )
	{
		$this->mark_hs_augmenter = $ha;
	}
 
	// HS Diminuer
	public function getMarkHsDiminuer()
	{
		return $this->mark_hs_diminuer;
	}
	public function setMarkHsDiminuer( $hd )
	{
		$this->mark_hs_diminuer = $hd;
	}
 
	/*** Méthodes : */
 
	/**
	* Consulter la table gestion_absence_motif.
	* @return mixed un tableau d'objets AbsenceMotif s'il y en a plusieurs, l'objet AbsenceMotif s'il y en a 1 seul sinon false.
	*/
	public function consulter($cmd = '', $parametres = array(), $instancier = false)
	{
 
 
 
		switch ($cmd) {
			case AbsenceMotif::GAM_TOUS:
				$requete = 	'SELECT * '.
							'FROM gestion_absence_motif ';
				break;
			case AbsenceMotif::GAM_ID:
				$requete = 	'SELECT * '.
							'FROM gestion_absence_motif '.
							'WHERE gam_id_absence_motif = #0 ';
				break;
			case AbsenceMotif::GAM_ID_MAX:
				$requete =	'SELECT MAX(gam_id_absence_motif) as gam_id_absence_motif '.
							'FROM gestion_absence_motif ';
				break;
			case AbsenceMotif::GAM_LIBELLE:
				$requete =	'SELECT * '.
							'FROM gestion_absence_motif '.
							'WHERE gam_libelle = "#0" ';
				break;
			default :
				$message = 'Commande '.$cmd.'inconnue!';
				$e = GestionnaireErreur::formaterMessageErreur(__FILE__, __LINE__, $message);
    			trigger_error($e, E_USER_ERROR);
		}
 
 
 
 
 
		return parent::consulter($requete, $parametres, $instancier);
 
 
 
 
 
 
 
 
 
 
	}
 
	/** Afficher l'objet AbsenceMotif */
	function afficherAbsenceMotif()
	{
		echo '<pre>'.print_r($this, true).'</pre>';
	}
}
 
/* +--Fin du code ----------------------------------------------------------------------------------------+
*
* $Log$
*
* +-- Fin du code ----------------------------------------------------------------------------------------+
*/
?>

Rev 82	Rev 87
1	`<?php`	1	`<?php`
2	`// +------------------------------------------------------------------------------------------------------+`	2	`// +------------------------------------------------------------------------------------------------------+`
3	`// \| PHP version 5.1.1 \|`	3	`// \| PHP version 5.1.1 \|`
4	`// +------------------------------------------------------------------------------------------------------+`	4	`// +------------------------------------------------------------------------------------------------------+`
5	`// \| Copyright (C) 2006 Tela Botanica (accueil@tela-botanica.org) \|`	5	`// \| Copyright (C) 2006 Tela Botanica (accueil@tela-botanica.org) \|`
6	`// +------------------------------------------------------------------------------------------------------+`	6	`// +------------------------------------------------------------------------------------------------------+`
7	`// \| This file is part of eFlore. \|`	7	`// \| This file is part of eFlore. \|`
8	`// \| \|`	8	`// \| \|`
9	`// \| Foobar is free software; you can redistribute it and/or modify \|`	9	`// \| Foobar is free software; you can redistribute it and/or modify \|`
10	`// \| it under the terms of the GNU General Public License as published by \|`	10	`// \| it under the terms of the GNU General Public License as published by \|`
11	`// \| the Free Software Foundation; either version 2 of the License, or \|`	11	`// \| the Free Software Foundation; either version 2 of the License, or \|`
12	`// \| (at your option) any later version. \|`	12	`// \| (at your option) any later version. \|`
13	`// \| \|`	13	`// \| \|`
14	`// \| Foobar is distributed in the hope that it will be useful, \|`	14	`// \| Foobar is distributed in the hope that it will be useful, \|`
15	`// \| but WITHOUT ANY WARRANTY; without even the implied warranty of \|`	15	`// \| but WITHOUT ANY WARRANTY; without even the implied warranty of \|`
16	`// \| MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the \|`	16	`// \| MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the \|`
17	`// \| GNU General Public License for more details. \|`	17	`// \| GNU General Public License for more details. \|`
18	`// \| \|`	18	`// \| \|`
19	`// \| You should have received a copy of the GNU General Public License \|`	19	`// \| You should have received a copy of the GNU General Public License \|`
20	`// \| along with Foobar; if not, write to the Free Software \|`	20	`// \| along with Foobar; if not, write to the Free Software \|`
21	`// \| Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA \|`	21	`// \| Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA \|`
22	`// +------------------------------------------------------------------------------------------------------+`	22	`// +------------------------------------------------------------------------------------------------------+`
23	`// CVS : $Id$`	23	`// CVS : $Id$`
24	`/**`	24	`/**`
25	`* Classe AbsenceMotif`	25	`* Classe AbsenceMotif`
26	`*`	26	`*`
27	`* Description`	27	`* Description`
28	`*`	28	`*`
29	`*@package eFlore`	29	`*@package eFlore`
30	`*@subpackage modele`	30	`*@subpackage modele`
31	`//Auteur original :`	31	`//Auteur original :`
32	`*@version 3`	32	`*@version 3`
33	`*@author Shaheen ABDOOL RAHEEM <shaheenar50@hotmail.com>`	33	`*@author Shaheen ABDOOL RAHEEM <shaheenar50@hotmail.com>`
34	`//Autres auteurs :`	34	`//Autres auteurs :`
35	`*@version 4`	35	`*@version 4`
36	`*@author Jean-Pascal MILCENT <jpm@clapas.org>`	36	`*@author Jean-Pascal MILCENT <jpm@clapas.org>`
37	`*@author aucun`	37	`*@author aucun`
38	`*@copyright Tela-Botanica 2000-2006`	38	`*@copyright Tela-Botanica 2000-2006`
39	`*@version $Revision$ $Date$`	39	`*@version $Revision$ $Date$`
40	`// +------------------------------------------------------------------------------------------------------+`	40	`// +------------------------------------------------------------------------------------------------------+`
41	`*/`	41	`*/`
42		42
43	`/**`	43	`/**`
44	`* class AbsenceMotif : est à la fois le DAO et le conteneur de la table gestion_utilisateur.`	44	`* class AbsenceMotif : est à la fois le DAO et le conteneur de la table gestion_utilisateur.`
45	`* classe métier`	45	`* classe métier`
46	`*/`	46	`*/`
47	`class AbsenceMotif extends aGttSql {`	47	`class AbsenceMotif extends aGttSql {`
48	`/*** Constantes : */`	48	`/*** Constantes : */`
49	`const GAM_TOUS = 'ABSENCEMOTIF_TOUS';`	49	`const GAM_TOUS = 'ABSENCEMOTIF_TOUS';`
50	`const GAM_ID = 'ABSENCEMOTIF_ID';`	50	`const GAM_ID = 'ABSENCEMOTIF_ID';`
51	`const GAM_ID_MAX = 'ABSENCEMOTIF_ID_MAX';`	51	`const GAM_ID_MAX = 'ABSENCEMOTIF_ID_MAX';`
52	`const GAM_LIBELLE = 'ABSENCEMOTIF_LIBELLE';`	52	`const GAM_LIBELLE = 'ABSENCEMOTIF_LIBELLE';`
53		53
54	`/*** Attributs : */`	54	`/*** Attributs : */`
55	`private $id_absence_motif;`	55	`private $id_absence_motif;`
56	`private $libelle;`	56	`private $libelle;`
57	`private $cp_diminuer;`	57	`private $mark_cp_diminuer;`
58	`private $hs_augmenter;`	58	`private $mark_hs_augmenter;`
59	`private $hs_diminuer;`	59	`private $mark_hs_diminuer;`
60		60
61	`/*** Aggregations : */`	61	`/*** Aggregations : */`
62		62
63	`/*** Constructeur : */`	63	`/*** Constructeur : */`
64	`public function __construct($cmd = null, $parametres = null)`	64	`public function __construct($cmd = null, $parametres = null)`
65	`{`	65	`{`
66	`$this->dao_table_nom = 'gestion_absence_motif';`	66	`$this->dao_table_nom = 'gestion_absence_motif';`
67	`$this->dao_correspondance = array(`	67	`$this->dao_correspondance = array(`
68	`'gam_id_absence_motif' => 'id_absence_motif',`	68	`'gam_id_absence_motif' => 'id_absence_motif',`
69	`'gam_libelle' => 'libelle',`	69	`'gam_libelle' => 'libelle',`
70	`'gam_cp_diminuer' => 'cp_diminuer',`	70	`'gam_mark_cp_diminuer' => 'mark_cp_diminuer',`
71	`'gam_hs_augmenter' => 'hs_augmenter',`	71	`'gam_mark_hs_augmenter' => 'mark_hs_augmenter',`
72	`'gam_hs_diminuer' => 'hs_diminuer');`	72	`'gam_mark_hs_diminuer' => 'mark_hs_diminuer');`
73		73
74	`// Si l'on veut remplir l'objet à la création on lance la requete correspondante`	74	`// Si l'on veut remplir l'objet à la création on lance la requete correspondante`
75	`if (!is_null($cmd)) {`	75	`if (!is_null($cmd)) {`
76	`$this->consulter($cmd, $parametres, true);`	76	`$this->consulter($cmd, $parametres, true);`
77	`}`	77	`}`
78	`}`	78	`}`
79		79
80	`/*** Accesseurs : */`	80	`/*** Accesseurs : */`
81	`// Id Absence Motif`	81	`// Id Absence Motif`
82	`public function getIdAbsenceMotif()`	82	`public function getIdAbsenceMotif()`
83	`{`	83	`{`
84	`return $this->id_absence_motif;`	84	`return $this->id_absence_motif;`
85	`}`	85	`}`
86	`public function setIdAbsenceMotif( $iam )`	86	`public function setIdAbsenceMotif( $iam )`
87	`{`	87	`{`
88	`$this->id_absence_motif = $iam;`	88	`$this->id_absence_motif = $iam;`
89	`}`	89	`}`
90		90
91	`// Libelle`	91	`// Libelle`
92	`public function getLibelle()`	92	`public function getLibelle()`
93	`{`	93	`{`
94	`return $this->libelle;`	94	`return $this->libelle;`
95	`}`	95	`}`
96	`public function setLibelle( $l )`	96	`public function setLibelle( $l )`
97	`{`	97	`{`
98	`$this->libelle = $l;`	98	`$this->libelle = $l;`
99	`}`	99	`}`
100		100
101	`// CP Diminuer`	101	`// CP Diminuer`
102	`public function getCpDiminuer()`	102	`public function getMarkCpDiminuer()`
103	`{`	103	`{`
104	`return $this->cp_diminuer;`	104	`return $this->mark_cp_diminuer;`
105	`}`	105	`}`
106	`public function setCpDiminuer( $cd )`	106	`public function setMarkCpDiminuer( $cd )`
107	`{`	107	`{`
108	`$this->cp_diminuer = $cd;`	108	`$this->mark_cp_diminuer = $cd;`
109	`}`	109	`}`
110		110
111	`// HS Augmenter`	111	`// HS Augmenter`
112	`public function getHsAugmenter()`	112	`public function getMarkHsAugmenter()`
113	`{`	113	`{`
114	`return $this->hs_augmenter;`	114	`return $this->mark_hs_augmenter;`
115	`}`	115	`}`
116	`public function setHsAugmenter( $ha )`	116	`public function setMarkHsAugmenter( $ha )`
117	`{`	117	`{`
118	`$this->hs_augmenter = $ha;`	118	`$this->mark_hs_augmenter = $ha;`
119	`}`	119	`}`
120		120
121	`// HS Diminuer`	121	`// HS Diminuer`
122	`public function getHsDiminuer()`	122	`public function getMarkHsDiminuer()`
123	`{`	123	`{`
124	`return $this->hs_diminuer;`	124	`return $this->mark_hs_diminuer;`
125	`}`	125	`}`
126	`public function setHsDiminuer( $hd )`	126	`public function setMarkHsDiminuer( $hd )`
127	`{`	127	`{`
128	`$this->hs_diminuer = $hd;`	128	`$this->mark_hs_diminuer = $hd;`
129	`}`	129	`}`
130		130
131	`/*** Méthodes : */`	131	`/*** Méthodes : */`
132		132
133	`/**`	133	`/**`
134	`* Consulter la table gestion_absence_motif.`	134	`* Consulter la table gestion_absence_motif.`
135	`* @return mixed un tableau d'objets AbsenceMotif s'il y en a plusieurs, l'objet AbsenceMotif s'il y en a 1 seul sinon false.`	135	`* @return mixed un tableau d'objets AbsenceMotif s'il y en a plusieurs, l'objet AbsenceMotif s'il y en a 1 seul sinon false.`
136	`*/`	136	`*/`
137	`public function consulter($cmd = '', $parametres = array(), $instancier = false)`	137	`public function consulter($cmd = '', $parametres = array(), $instancier = false)`
138	`{`	138	`{`
139	`if (!is_array($parametres)) {`	-
140	`$parametres[0] = $parametres;`	-
141	`}`	-
142	`switch ($cmd) {`	139	`switch ($cmd) {`
143	`case AbsenceMotif::GAM_TOUS:`	140	`case AbsenceMotif::GAM_TOUS:`
144	`$requete = 'SELECT * '.`	141	`$requete = 'SELECT * '.`
145	`'FROM gestion_absence_motif ';`	142	`'FROM gestion_absence_motif ';`
146	`break;`	143	`break;`
147	`case AbsenceMotif::GAM_ID:`	144	`case AbsenceMotif::GAM_ID:`
148	`$requete = 'SELECT * '.`	145	`$requete = 'SELECT * '.`
149	`'FROM gestion_absence_motif '.`	146	`'FROM gestion_absence_motif '.`
150	`'WHERE gam_id_absence_motif = '.$parametres[0].' ';`	147	`'WHERE gam_id_absence_motif = #0 ';`
151	`break;`	148	`break;`
152	`case AbsenceMotif::GAM_ID_MAX:`	149	`case AbsenceMotif::GAM_ID_MAX:`
153	`$requete = 'SELECT MAX(gam_id_absence_motif) as gam_id_absence_motif '.`	150	`$requete = 'SELECT MAX(gam_id_absence_motif) as gam_id_absence_motif '.`
154	`'FROM gestion_absence_motif ';`	151	`'FROM gestion_absence_motif ';`
155	`break;`	152	`break;`
156	`case AbsenceMotif::GAM_LIBELLE:`	153	`case AbsenceMotif::GAM_LIBELLE:`
157	`$requete = 'SELECT * '.`	154	`$requete = 'SELECT * '.`
158	`'FROM gestion_absence_motif '.`	155	`'FROM gestion_absence_motif '.`
159	`'WHERE gam_libelle = "'.$parametres[0].'" ';`	156	`'WHERE gam_libelle = "#0" ';`
160	`break;`	157	`break;`
161	`default :`	158	`default :`
162	`$message = 'Commande '.$cmd.'inconnue!';`	159	`$message = 'Commande '.$cmd.'inconnue!';`
163	`$e = GestionnaireErreur::formaterMessageErreur(__FILE__, __LINE__, $message);`	160	`$e = GestionnaireErreur::formaterMessageErreur(__FILE__, __LINE__, $message);`
164	`trigger_error($e, E_USER_ERROR);`	161	`trigger_error($e, E_USER_ERROR);`
165	`}`	162	`}`
166		-
167	`$resultat = $GLOBALS['db']->query($requete);`	-
168	`(DB::isError($resultat)) ? die (GestionnaireErreur::retournerErreurSql(__FILE__, __LINE__, $resultat->getMessage(), $requete)) : '' ;`	-
169	`$tab_resultat = array();`	-
170	`while ($donnees =& $resultat->fetchRow(DB_FETCHMODE_ASSOC)) {`	-
171	`$tab_resultat[] = $this->basculerEnregistrementObjet($donnees, $instancier);`	163	`return parent::consulter($requete, $parametres, $instancier);`
172	`}`	-
173		-
174	`$resultat_nbre = count($tab_resultat);`	-
175	`if ($resultat_nbre > 1) {`	-
176	`return $tab_resultat;`	-
177	`} else if ($resultat_nbre == 1) {`	-
178	`return $tab_resultat[0];`	-
179	`} else if ($resultat_nbre == 0) {`	-
180	`return false;`	-
181	`}`	-
182	`}`	164	`}`
183		165
184	`/** Afficher l'objet AbsenceMotif */`	166	`/** Afficher l'objet AbsenceMotif */`
185	`function afficherAbsenceMotif()`	167	`function afficherAbsenceMotif()`
186	`{`	168	`{`
187	`echo '<pre>'.print_r($this, true).'</pre>';`	169	`echo '<pre>'.print_r($this, true).'</pre>';`
188	`}`	170	`}`
189	`}`	171	`}`
190		172
191	`/* +--Fin du code ----------------------------------------------------------------------------------------+`	173	`/* +--Fin du code ----------------------------------------------------------------------------------------+`
192	`*`	174	`*`
193	`* $Log$`	175	`* $Log$`
194	`*`	176	`*`
195	`* +-- Fin du code ----------------------------------------------------------------------------------------+`	177	`* +-- Fin du code ----------------------------------------------------------------------------------------+`
196	`*/`	178	`*/`
197	`?>`	179	`?>`

Subversion Repositories Applications.gtt

(root)/trunk/bibliotheque/metier/AbsenceMotif.class.php – Rev 82 → 87