+++ /dev/null
-<?php
-
- require_once('protected/required.php');
-
- class PdoHistoriqueManager extends AbstractPdoManager {
-
- public function createHistorique($historique) {
-
- $query = $this -> pdo -> prepare(
- 'INSERT INTO historiques (installation, alertes, versions) VALUES (NOW(), :alertes, :versions)'
- );
- $query -> bindValue(':alertes', implode("|", $historique -> getAlertes()));
- $query -> bindValue(':versions', implode("|", $historique -> getVersions()));
- $query -> execute();
- $query -> closeCursor();
- }
-
- public function updateHistorique($historique) {
-
- $query = $this -> pdo -> prepare(
- 'UPDATE historiques SET
- installation = :installation,
- alertes = :alertes,
- versions = :versions
- WHERE id = :id'
- );
- $query -> bindValue(':id', $historique -> getId());
- $query -> bindValue(':installation', $historique -> getInstallation());
- $query -> bindValue(':alertes', implode("|", $historique -> getAlertes()));
- $query -> bindValue(':versions', implode("|", $historique -> getVersions()));
- $query -> execute();
- $query -> closeCursor();
- }
-
- public function getHistorique($id) {
-
- $query = $this -> pdo -> prepare('SELECT * FROM historiques WHERE id = :id');
- $query -> bindValue(':id', $id);
- $query -> execute();
-
- $result = $query -> fetch(PDO::FETCH_ASSOC);
- $historique = new Historique($result['id'], $result['installation'], explode("|", $result['alertes']), explode("|", $result['versions']));
-
- $query->closeCursor();
-
- return $historique;
- }
-
- public function getLastHistorique() {
-
- $query = $this -> pdo -> prepare('SELECT * FROM historiques WHERE id = LAST_INSERT_ID()');
- $query -> execute();
-
- $result = $query -> fetch(PDO::FETCH_ASSOC);
- $historique = new Historique($result['id'], $result['installation'], explode("|", $result['alertes']), explode("|", $result['versions']));
-
- $query->closeCursor();
-
- return $historique;
- }
-
- public function getHistoriques() {
-
- $query = $this -> pdo -> prepare('SELECT * FROM historiques');
- $query -> execute();
-
- $results = $query -> fetchAll(PDO::FETCH_ASSOC);
- $historiques = array();
- foreach ($results as $result) {
- $historiques[] = new Historique($result['id'], $result['installation'], explode("|", $result['alertes']), explode("|", $result['versions']));
- }
-
- $query->closeCursor();
-
- return $historiques;
- }
-
- public function removeHistorique($historique) {
-
- $query = $this -> pdo -> prepare('DELETE FROM historique WHERE id = :id');
- $query -> bindValue('id', $historique -> getId());
- $query -> execute();
-
- }
-
- }
-
-?>