/** * Retourne tous les assignment enregistrés. * * @return array[Assignment] Tous les objets dans un tableau. */ public static function findAll() { $mesAssignments = array(); $data = BaseSingleton::select('SELECT id, module_id, label, description, ' . 'date_creation, date_passage, affiche, prixRattrapage, rattrapage ' . 'FROM assignment '); foreach ($data as $row) { $assignment = new Assignment(); $assignment->hydrate($row); $mesAssignments[] = $assignment; } return $mesAssignments; }
/** * Retourne tous les assign avec rattrapage à . * * @return Assignment Tous les objets dans un tableau. */ public static function findAllRattrapageAssign($moduleId) { $data = BaseSingleton::select('SELECT assignment.id, assignment.module_id, ' . 'assignment.label, ' . 'assignment.description, assignment.date_creation, ' . 'assignment.date_passage, assignment.affiche, ' . 'assignment.prixRattrapage, assignment.rattrapage ' . 'FROM module, assignment, exam ' . 'WHERE module.id = assignment.module_id AND module.id = exam.module_id ' . ' AND assignment.rattrapage = 1' . ' AND module.id = ? ' . 'GROUP BY module.id', array('i', &$moduleId)); $rattrapageAssign = new Assignment(); if (sizeof($data) <= 0) { return false; } else { $rattrapageAssign->hydrate($data[0]); } return $rattrapageAssign; }