From bc312b1205612f5bd124bd6bf9f173a9b6d98792 Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@fakecake.org>
Date: Wed, 30 Jul 2025 19:24:53 +0300
Subject: implement special counter display when viewing by published, similar
 to marked

---
 classes/Feeds.php | 25 +++++++++++++++++++++++++
 1 file changed, 25 insertions(+)

(limited to 'classes/Feeds.php')

diff --git a/classes/Feeds.php b/classes/Feeds.php
index e76044060..7781d748f 100644
--- a/classes/Feeds.php
+++ b/classes/Feeds.php
@@ -1248,6 +1248,31 @@ class Feeds extends Handler_Protected {
 		return 0;
 	}
 
+	// only real cats
+	static function _get_cat_published(int $cat, int $owner_uid = 0): int {
+
+			if (!$owner_uid) $owner_uid = $_SESSION["uid"];
+
+			$pdo = Db::pdo();
+
+			if ($cat >= 0) {
+
+				$sth = $pdo->prepare("SELECT SUM(CASE WHEN published THEN 1 ELSE 0 END) AS marked
+					FROM ttrss_user_entries
+					WHERE feed_id IN (SELECT id FROM ttrss_feeds
+							  WHERE (cat_id = :cat OR (:cat IS NULL AND cat_id IS NULL))
+						AND owner_uid = :uid)
+					AND owner_uid = :uid");
+
+				$sth->execute(["cat" => $cat ? $cat : null, "uid" => $owner_uid]);
+
+				if ($row = $sth->fetch()) {
+					return (int) $row["marked"];
+				}
+			}
+			return 0;
+		}
+
 	static function _get_cat_unread(int $cat, int $owner_uid = 0): int {
 
 		if (!$owner_uid) $owner_uid = $_SESSION["uid"];
-- 
cgit v1.2.3-54-g00ecf