summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorGravatar Marien Fressinaud <dev@marienfressinaud.fr> 2013-09-14 19:26:01 +0200
committerGravatar Marien Fressinaud <dev@marienfressinaud.fr> 2013-09-14 19:26:01 +0200
commit73fe0eabbe4461ba8c6d24692ca05de0ac93de11 (patch)
tree0d562aca69c9a8f85e3afb86dd2a76802afdf6b2
parentff8531fb64ce0bf7c5d0dd01ab672e1a6584f246 (diff)
Fix issue #151 : marquer lus les articles du futur
On peut désormais marquer comme lu les articles parus dans le futur
-rwxr-xr-xapp/controllers/entryController.php2
-rwxr-xr-xapp/models/Entry.php39
2 files changed, 28 insertions, 13 deletions
diff --git a/app/controllers/entryController.php b/app/controllers/entryController.php
index 679a4201f..4c9eb9d1b 100755
--- a/app/controllers/entryController.php
+++ b/app/controllers/entryController.php
@@ -36,7 +36,7 @@ class entryController extends ActionController {
$is_read = Request::param ('is_read');
$get = Request::param ('get');
$nextGet = Request::param ('nextGet', $get);
- $dateMax = Request::param ('dateMax', time ());
+ $dateMax = Request::param ('dateMax', 0);
$is_read = !!$is_read;
diff --git a/app/models/Entry.php b/app/models/Entry.php
index d5a150bb1..647555ae9 100755
--- a/app/models/Entry.php
+++ b/app/models/Entry.php
@@ -251,11 +251,16 @@ class EntryDAO extends Model_pdo {
}
}
- public function markReadEntries ($read, $dateMax) {
- $sql = 'UPDATE ' . $this->prefix . 'entry e INNER JOIN ' . $this->prefix . 'feed f ON e.id_feed = f.id SET is_read = ? WHERE date < ? AND priority > 0';
- $stm = $this->bd->prepare ($sql);
+ public function markReadEntries ($read, $dateMax = 0) {
+ $sql = 'UPDATE ' . $this->prefix . 'entry e INNER JOIN ' . $this->prefix . 'feed f ON e.id_feed = f.id SET is_read = ? WHERE priority > 0';
+
+ $values = array ($read);
+ if ($dateMax > 0) {
+ $sql .= ' AND date < ?';
+ $values[] = $dateMax;
+ }
- $values = array ($read, $dateMax);
+ $stm = $this->bd->prepare ($sql);
if ($stm && $stm->execute ($values)) {
return true;
@@ -265,11 +270,16 @@ class EntryDAO extends Model_pdo {
return false;
}
}
- public function markReadCat ($id, $read, $dateMax) {
- $sql = 'UPDATE ' . $this->prefix . 'entry e INNER JOIN ' . $this->prefix . 'feed f ON e.id_feed = f.id SET is_read = ? WHERE category = ? AND date < ?';
- $stm = $this->bd->prepare ($sql);
+ public function markReadCat ($id, $read, $dateMax = 0) {
+ $sql = 'UPDATE ' . $this->prefix . 'entry e INNER JOIN ' . $this->prefix . 'feed f ON e.id_feed = f.id SET is_read = ? WHERE category = ?';
+
+ $values = array ($read, $id);
+ if ($dateMax > 0) {
+ $sql .= ' AND date < ?';
+ $values[] = $dateMax;
+ }
- $values = array ($read, $id, $dateMax);
+ $stm = $this->bd->prepare ($sql);
if ($stm && $stm->execute ($values)) {
return true;
@@ -279,11 +289,16 @@ class EntryDAO extends Model_pdo {
return false;
}
}
- public function markReadFeed ($id, $read, $dateMax) {
- $sql = 'UPDATE ' . $this->prefix . 'entry SET is_read = ? WHERE id_feed = ? AND date < ?';
- $stm = $this->bd->prepare ($sql);
+ public function markReadFeed ($id, $read, $dateMax = 0) {
+ $sql = 'UPDATE ' . $this->prefix . 'entry SET is_read = ? WHERE id_feed = ?';
- $values = array ($read, $id, $dateMax);
+ $values = array ($read, $id);
+ if ($dateMax > 0) {
+ $sql .= ' AND date < ?';
+ $values[] = $dateMax;
+ }
+
+ $stm = $this->bd->prepare ($sql);
if ($stm && $stm->execute ($values)) {
return true;