Fix issue #44 : affichage du nombre d'entrées non lues dans la sidebar

1 files changed, 13 insertions, 0 deletions

diff --git a/app/models/Feed.php b/app/models/Feed.php
index 8e3168e3b..159b6e767 100644
--- a/app/models/Feed.php
+++ b/app/models/Feed.php
@@ -58,6 +58,10 @@ class Feed extends Model {
 		$feedDAO = new FeedDAO ();
 		return $feedDAO->countEntries ($this->id ());
 	}
+	public function nbNotRead () {
+		$feedDAO = new FeedDAO ();
+		return $feedDAO->countNotRead ($this->id ());
+	}
 
 	public function _id ($value) {
 		$this->id = $value;
@@ -313,6 +317,15 @@ class FeedDAO extends Model_pdo {
 
 		return $res[0]['count'];
 	}
+	public function countNotRead ($id) {
+		$sql = 'SELECT COUNT(*) AS count FROM entry WHERE is_read=0 AND id_feed=?';
+		$stm = $this->bd->prepare ($sql);
+		$values = array ($id);
+		$stm->execute ($values);
+		$res = $stm->fetchAll (PDO::FETCH_ASSOC);
+
+		return $res[0]['count'];
+	}
 }
 
 class HelperFeed {