API return proper newestItemTimestampUsec (#2854)

* API return proper newestItemTimestampUsec

#fix https://github.com/FreshRSS/FreshRSS/issues/2853

* Minor naming

* Add newestItemTimestampUsec for labels

* Do not use t.name after all

2 files changed, 35 insertions, 0 deletions

diff --git a/app/Models/FeedDAO.php b/app/Models/FeedDAO.php
index 01f0b10f6..11db5e3d4 100644
--- a/app/Models/FeedDAO.php
+++ b/app/Models/FeedDAO.php
@@ -302,6 +302,22 @@ class FreshRSS_FeedDAO extends Minz_ModelPdo implements FreshRSS_Searchable {
 		return self::daoToFeed($stm->fetchAll(PDO::FETCH_ASSOC));
 	}
 
+	public function listFeedsNewestItemUsec($id_feed = null) {
+		$sql = 'SELECT id_feed, MAX(id) as newest_item_us FROM `_entry` ';
+		if ($id_feed === null) {
+			$sql .= 'GROUP BY id_feed';
+		} else {
+			$sql .= 'WHERE id_feed=' . intval($id_feed);
+		}
+		$stm = $this->pdo->query($sql);
+		$res = $stm->fetchAll(PDO::FETCH_ASSOC);
+		$newestItemUsec = [];
+		foreach ($res as $line) {
+			$newestItemUsec['f_' . $line['id_feed']] = $line['newest_item_us'];
+		}
+		return $newestItemUsec;
+	}
+
 	public function arrayFeedCategoryNames() {	//For API
 		$sql = 'SELECT f.id, f.name, c.name as c_name FROM `_feed` f '
 		     . 'INNER JOIN `_category` c ON c.id = f.category';
diff --git a/app/Models/TagDAO.php b/app/Models/TagDAO.php
index 09397c6a1..05a88b182 100644
--- a/app/Models/TagDAO.php
+++ b/app/Models/TagDAO.php
@@ -193,6 +193,25 @@ class FreshRSS_TagDAO extends Minz_ModelPdo implements FreshRSS_Searchable {
 		}
 	}
 
+	public function listTagsNewestItemUsec($id_tag = null) {
+		$sql = 'SELECT t.id AS id_tag, MAX(e.id) AS newest_item_us '
+			 . 'FROM `_tag` t '
+			 . 'LEFT OUTER JOIN `_entrytag` et ON et.id_tag = t.id '
+			 . 'LEFT OUTER JOIN `_entry` e ON et.id_entry = e.id ';
+		if ($id_tag === null) {
+			$sql .= 'GROUP BY t.id';
+		} else {
+			$sql .= 'WHERE t.id=' . intval($id_tag);
+		}
+		$stm = $this->pdo->query($sql);
+		$res = $stm->fetchAll(PDO::FETCH_ASSOC);
+		$newestItemUsec = [];
+		foreach ($res as $line) {
+			$newestItemUsec['t_' . $line['id_tag']] = $line['newest_item_us'];
+		}
+		return $newestItemUsec;
+	}
+
 	public function count() {
 		$sql = 'SELECT COUNT(*) AS count FROM `_tag`';
 		$stm = $this->pdo->query($sql);