public function test_matiereFindById()
{
$db = DB::Connect();
$result = $db->query("SELECT libelle_matiere as nom FROM MATIERES WHERE id_matiere = 3");
$result->setFetchMode(PDO::FETCH_OBJ);
$result = $result->fetch();
$attendu = $result->nom;
$matiere = MatieresModel::findById(3);
$this->message["mat_findById_mess"] = "Attendu : " . $attendu . " - Trouver : " . $matiere->name;
return count($matiere) === 1 && $attendu === $matiere->name;
}
/**
* Affiche les notes d'un etudiant
*/
public function mynotes()
{
$this->authorization();
$user = $this->_session->user;
$vars['title'] = 'Espace Perso';
$vars['view'] = "Utilisateurs/notes";
$vars['is_logged'] = $this->_session->is_logged();
$vars['enseignant'] = $user->isEnseignant();
$vars['etudiant'] = $user->isEtudiant();
$vars['admin'] = $user->isAdmin();
$vars["user"] = $user;
$cours = MatieresModel::findByFormation($user->getiddernierFormations());
$vars["matiere"] = $cours;
$this->load->view('template', $vars);
}
/**
* Fonction permettant de modifier une matiere dans la base de données
*
* @param MatieresModel $m la matière à mettre à jour
*/
public static function update(MatieresModel $m)
{
$db = DB::Connect();
$query = $db->prepare("UPDATE " . self::TABLE . " SET " . self::NOM_COL . " = :nom " . " WHERE " . self::ID_COL . " = :id ");
try {
$query->bindValue(":nom", $m->getName(), PDO::PARAM_STR);
$query->bindValue(":id", $m->getId(), PDO::PARAM_INT);
$db->beginTransaction();
$query->execute();
$db->commit();
} catch (PDOException $e) {
$db->rollback();
DB::setError($e->getMessage());
return false;
}
return self::findById($m->getId());
}
