| 49,6 → 49,7 |
|---|
| 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; |
| 99,6 → 100,9 |
|---|
| */ |
| public function consulter($cmd = '', $parametres = array(), $instancier = false) |
| { |
| if (!is_array($parametres)) { |
| $parametres[0] = $parametres; |
| } |
| switch ($cmd) { |
| case AbsenceMotif::GAM_TOUS: |
| $requete = 'SELECT * '. |
| 110,8 → 114,13 |
|---|
| 'WHERE gam_id_absence_motif = '.$parametres[0].' '; |
| break; |
| case AbsenceMotif::GAM_ID_MAX: |
| $requete = 'SELECT MAX(gam_id_absence_motif) '. |
| $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 = "'.$parametres[0].'" '; |
| break; |
| default : |
| $message = 'Commande '.$cmd.'inconnue!'; |