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 63... Line 63...
63 
	/*** Aggregations : */
 63 
	/*** Aggregations : */
Line 64... Line 64...
64 
 
 64 
 
65 
	/*** Constructeur : */
 65 
	/*** Constructeur : */
66 
	public function __construct($cmd = null, $parametres = null)
 66 
	public function __construct($cmd = null, $parametres = null)
67 
	{
 67 
	{
68 
		$this->dao_table_nom = 'gestion_absence';
 68 
		$this->dao_table_nom = GTT_BDD_PREFIXE . 'gestion_absence';
69 
		$this->dao_correspondance = array(
 69 
		$this->dao_correspondance = array(
70 
			'ga_id_utilisateur'	=> 'id_utilisateur',
 70 
			'ga_id_utilisateur'	=> 'id_utilisateur',
71 
			'ga_id_absence_motif'	=> 'id_absence_motif',
 71 
			'ga_id_absence_motif'	=> 'id_absence_motif',
72 
			'ga_id_date_absence'	=> 'id_date_absence',
 72 
			'ga_id_date_absence'	=> 'id_date_absence',
Line 128... Line 128...
128 
	public function consulter($cmd = '', $parametres = array(), $instancier = false)
 128 
	public function consulter($cmd = '', $parametres = array(), $instancier = false)
129 
	{
 129 
	{
130 
		switch ($cmd) {
 130 
		switch ($cmd) {
131 
			case Absence::GA_ID:
 131 
			case Absence::GA_ID:
132 
				$requete = 	'SELECT * '.
 132 
				$requete = 	'SELECT * '.
133 
							'FROM gestion_absence '.
 133 
							'FROM ' . GTT_BDD_PREFIXE . 'gestion_absence '.
134 
							'WHERE ga_id_utilisateur = #0 '.
 134 
							'WHERE ga_id_utilisateur = #0 '.
135 
							'	AND ga_id_absence_motif = #1 '.
 135 
							'	AND ga_id_absence_motif = #1 '.
136 
							'	AND ga_id_date_absence = #2 ';
 136 
							'	AND ga_id_date_absence = #2 ';
137 
				break;
 137 
				break;
138 
			case Absence::GA_ID_ABSENCE_MOTIF:
 138 
			case Absence::GA_ID_ABSENCE_MOTIF:
139 
				$requete = 	'SELECT * '.
 139 
				$requete = 	'SELECT * '.
140 
							'FROM gestion_absence '.
 140 
							'FROM ' . GTT_BDD_PREFIXE . 'gestion_absence '.
141 
							'WHERE ga_id_absence_motif = #0 ';
 141 
							'WHERE ga_id_absence_motif = #0 ';
142 
				break;
 142 
				break;
143 
			case Absence::GA_ID_UTILISATEUR:
 143 
			case Absence::GA_ID_UTILISATEUR:
144 
				$requete = 	'SELECT * '.
 144 
				$requete = 	'SELECT * '.
145 
							'FROM gestion_absence '.
 145 
							'FROM ' . GTT_BDD_PREFIXE . 'gestion_absence '.
146 
							'WHERE ga_id_utilisateur = #0 ';
 146 
							'WHERE ga_id_utilisateur = #0 ';
147 
				break;
 147 
				break;
148 
			case Absence::GA_ID_UTILISATEUR_DATE_DEB_FIN:
 148 
			case Absence::GA_ID_UTILISATEUR_DATE_DEB_FIN:
149 
				$requete = 	'SELECT * '.
 149 
				$requete = 	'SELECT * '.
150 
							'FROM gestion_absence '.
 150 
							'FROM ' . GTT_BDD_PREFIXE . 'gestion_absence '.
151 
							'WHERE ga_id_utilisateur = #0 '.
 151 
							'WHERE ga_id_utilisateur = #0 '.
152 
							'	AND ga_id_date_absence >= "#1" '.
 152 
							'	AND ga_id_date_absence >= "#1" '.
153 
							'	AND ga_id_date_absence <= "#2" ';
 153 
							'	AND ga_id_date_absence <= "#2" ';
154 
				break;
 154 
				break;
155 
			case Absence::GA_ID_MAX_UTILISATEUR:
 155 
			case Absence::GA_ID_MAX_UTILISATEUR:
156 
				$requete =	'SELECT MAX(ga_id_utilisateur) '.
 156 
				$requete =	'SELECT MAX(ga_id_utilisateur) '.
157 
							'FROM gestion_absence ';
 157 
							'FROM ' . GTT_BDD_PREFIXE . 'gestion_absence ';
158 
				break;
 158 
				break;
159 
			case Absence::GA_ID_MAX_ABSENCE_MOTIF:
 159 
			case Absence::GA_ID_MAX_ABSENCE_MOTIF:
160 
				$requete =	'SELECT MAX(ga_id_absence_motif) '.
 160 
				$requete =	'SELECT MAX(ga_id_absence_motif) '.
161 
							'FROM gestion_absence ';
 161 
							'FROM ' . GTT_BDD_PREFIXE . 'gestion_absence ';
162 
				break;
 162 
				break;
163 
			case Absence::GA_ID_MAX_DATE_ABSENCE:
 163 
			case Absence::GA_ID_MAX_DATE_ABSENCE:
164 
				$requete =	'SELECT MAX(ga_id_date_absence) '.
 164 
				$requete =	'SELECT MAX(ga_id_date_absence) '.
165 
							'FROM gestion_absence ';
 165 
							'FROM ' . GTT_BDD_PREFIXE . 'gestion_absence ';
166 
				break;
 166 
				break;
167 
			default :
 167 
			default :
168 
				$message = 'Commande '.$cmd.'inconnue!';
 168 
				$message = 'Commande '.$cmd.'inconnue!';
169 
				$e = GestionnaireErreur::formaterMessageErreur(__FILE__, __LINE__, $message);
 169 
				$e = GestionnaireErreur::formaterMessageErreur(__FILE__, __LINE__, $message);
170 
    			trigger_error($e, E_USER_ERROR);
 170 
    			trigger_error($e, E_USER_ERROR);