/**
* 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;
}
