public function createHistorique($historique) {
$query = $this -> pdo -> prepare(
- 'INSERT INTO historiques (installation) VALUES (:installation)'
+ 'INSERT INTO historiques (installation, alertes) VALUES (NOW(), :alertes)'
);
- $query -> bindValue(':installation', $historique -> getInstallation());
+ $query -> bindValue(':alertes', implode("|", $historique -> getAlertes()));
$query -> execute();
- $query -> closeCursor();
-
+ $query -> closeCursor();
}
public function updateHistorique($historique) {
$query = $this -> pdo -> prepare(
- 'UPDATE historiques SET installation = :installation WHERE id = :id'
+ 'UPDATE historiques SET installation = :installation, alertes = :alertes WHERE id = :id'
);
$query -> bindValue(':id', $historique -> getId());
$query -> bindValue(':installation', $historique -> getInstallation());
+ $query -> bindValue(':alertes', implode("|", $historique -> getAlertes()));
$query -> execute();
-
+ $query -> closeCursor();
}
public function getHistorique($id) {
$query -> execute();
$result = $query -> fetch(PDO::FETCH_ASSOC);
- $historique = new Historique($result['id'], $result['installation']);
+ $historique = new Historique($result['id'], $result['installation'], explode("|", $result['alertes']));
+
+ $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']));
$query->closeCursor();
$results = $query -> fetchAll(PDO::FETCH_ASSOC);
$historiques = array();
foreach ($results as $result) {
- $historiques[] = new Historique($result['id'], $result['installation']);
+ $historiques[] = new Historique($result['id'], $result['installation'], explode("|", $result['alertes']));
}
$query->closeCursor();