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

1 files changed, 16 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';