Subversion Repositories Applications.gtt

Rev

Rev 104 | Show entire file | Regard whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 104 Rev 170
Line 60... Line 60...
60 
	/*** Aggregations : */
 60 
	/*** Aggregations : */
Line 61... Line 61...
61 
 
 61 
 
62 
	/*** Constructeur : */
 62 
	/*** Constructeur : */
63 
	public function __construct($cmd = null, $parametres = null)
 63 
	public function __construct($cmd = null, $parametres = null)
64 
	{
 64 
	{
65 
		$this->dao_table_nom = 'gestion_absence_motif';
 65 
		$this->dao_table_nom = GTT_BDD_PREFIXE . 'gestion_absence_motif';
66 
		$this->dao_correspondance = array(
 66 
		$this->dao_correspondance = array(
67 
			'gam_id_absence_motif'	=> 'id_absence_motif',
 67 
			'gam_id_absence_motif'	=> 'id_absence_motif',
68 
			'gam_libelle'	=> 'libelle',
 68 
			'gam_libelle'	=> 'libelle',
69 
			'gam_mark_cp_diminuer'	=> 'mark_cp_diminuer',
 69 
			'gam_mark_cp_diminuer'	=> 'mark_cp_diminuer',
Line 125... Line 125...
125 
	public function consulter($cmd = '', $parametres = array(), $instancier = false)
 125 
	public function consulter($cmd = '', $parametres = array(), $instancier = false)
126 
	{
 126 
	{
127 
		switch ($cmd) {
 127 
		switch ($cmd) {
128 
			case AbsenceMotif::GAM_TOUS:
 128 
			case AbsenceMotif::GAM_TOUS:
129 
				$requete = 	'SELECT * '.
 129 
				$requete = 	'SELECT * '.
130 
							'FROM gestion_absence_motif ';
 130 
							'FROM ' . GTT_BDD_PREFIXE . 'gestion_absence_motif ';
131 
				break;
 131 
				break;
132 
			case AbsenceMotif::GAM_ID:
 132 
			case AbsenceMotif::GAM_ID:
133 
				$requete = 	'SELECT * '.
 133 
				$requete = 	'SELECT * '.
134 
							'FROM gestion_absence_motif '.
 134 
							'FROM ' . GTT_BDD_PREFIXE . 'gestion_absence_motif '.
135 
							'WHERE gam_id_absence_motif = #0 ';
 135 
							'WHERE gam_id_absence_motif = #0 ';
136 
				break;
 136 
				break;
137 
			case AbsenceMotif::GAM_ID_MAX:
 137 
			case AbsenceMotif::GAM_ID_MAX:
138 
				$requete =	'SELECT MAX(gam_id_absence_motif) AS gam_id_absence_motif '.
 138 
				$requete =	'SELECT MAX(gam_id_absence_motif) AS gam_id_absence_motif '.
139 
							'FROM gestion_absence_motif ';
 139 
							'FROM ' . GTT_BDD_PREFIXE . 'gestion_absence_motif ';
140 
				break;
 140 
				break;
141 
			case AbsenceMotif::GAM_LIBELLE:
 141 
			case AbsenceMotif::GAM_LIBELLE:
142 
				$requete =	'SELECT * '.
 142 
				$requete =	'SELECT * '.
143 
							'FROM gestion_absence_motif '.
 143 
							'FROM ' . GTT_BDD_PREFIXE . 'gestion_absence_motif '.
144 
							'WHERE gam_libelle = "#0" ';
 144 
							'WHERE gam_libelle = "#0" ';
145 
				break;
 145 
				break;
146 
			default :
 146 
			default :
147 
				$message = 'Commande '.$cmd.'inconnue!';
 147 
				$message = 'Commande '.$cmd.'inconnue!';
148 
				$e = GestionnaireErreur::formaterMessageErreur(__FILE__, __LINE__, $message);
 148 
				$e = GestionnaireErreur::formaterMessageErreur(__FILE__, __LINE__, $message);