aboutsummaryrefslogtreecommitdiff
path: root/app/models/Entry.php
diff options
context:
space:
mode:
authorGravatar Alexandre Alapetite <alexandre@alapetite.fr> 2013-11-13 21:32:50 +0100
committerGravatar Alexandre Alapetite <alexandre@alapetite.fr> 2013-11-13 21:32:50 +0100
commitd654b34fa7c1f5a09ec8c9bf2b82b43bf5efaa7d (patch)
treeda616f2de6ca7a6c5524ac43ada7b1b300454f96 /app/models/Entry.php
parent5bd52cdcb64cdb53aded1dd0bcd6044ca7e98eb4 (diff)
Affichage du nombre total d'article sur la page de configuration
https://github.com/marienfressinaud/FreshRSS/issues/263 Style à améliorer éventuellement
Diffstat (limited to 'app/models/Entry.php')
-rwxr-xr-xapp/models/Entry.php14
1 files changed, 10 insertions, 4 deletions
diff --git a/app/models/Entry.php b/app/models/Entry.php
index e40cb5992..c6715a431 100755
--- a/app/models/Entry.php
+++ b/app/models/Entry.php
@@ -456,15 +456,21 @@ class EntryDAO extends Model_pdo {
$res = $stm->fetchAll (PDO::FETCH_COLUMN, 0);
return array('total' => $res[0], 'unread' => $res[1], 'read' => $res[0] - $res[1]);
}
- public function count () {
- $sql = 'SELECT COUNT(e.id) AS count FROM ' . $this->prefix . 'entry e INNER JOIN ' . $this->prefix . 'feed f ON e.id_feed = f.id WHERE priority > 0';
+ public function count ($minPriority = null) {
+ $sql = 'SELECT COUNT(e.id) AS count FROM ' . $this->prefix . 'entry e INNER JOIN ' . $this->prefix . 'feed f ON e.id_feed = f.id';
+ if ($minPriority !== null) {
+ $sql = ' WHERE priority > ' . intval($minPriority);
+ }
$stm = $this->bd->prepare ($sql);
$stm->execute ();
$res = $stm->fetchAll (PDO::FETCH_COLUMN, 0);
return $res[0];
}
- public function countNotRead () {
- $sql = 'SELECT COUNT(e.id) AS count FROM ' . $this->prefix . 'entry e INNER JOIN ' . $this->prefix . 'feed f ON e.id_feed = f.id WHERE priority > 0 AND is_read = 0';
+ public function countNotRead ($minPriority = null) {
+ $sql = 'SELECT COUNT(e.id) AS count FROM ' . $this->prefix . 'entry e INNER JOIN ' . $this->prefix . 'feed f ON e.id_feed = f.id WHERE is_read = 0';
+ if ($minPriority !== null) {
+ $sql = ' AND priority > ' . intval($minPriority);
+ }
$stm = $this->bd->prepare ($sql);
$stm->execute ();
$res = $stm->fetchAll (PDO::FETCH_COLUMN, 0);