diff options
| author | Andrew Dolgov <fox@fakecake.org> | 2025-07-30 19:57:56 +0300 |
|---|---|---|
| committer | Andrew Dolgov <fox@fakecake.org> | 2025-07-30 19:57:56 +0300 |
| commit | aeb0d42f89bf449810d6dc0f110b27431d55b4cb (patch) | |
| tree | 6fbf3ba487a983dae1014aae6885ca2f503e5933 /classes | |
| parent | bc312b1205612f5bd124bd6bf9f173a9b6d98792 (diff) | |
add missing count_published to get_cats() and fix some misleading indenting
Diffstat (limited to 'classes')
| -rw-r--r-- | classes/Counters.php | 22 |
1 files changed, 12 insertions, 10 deletions
diff --git a/classes/Counters.php b/classes/Counters.php index ec6e49b70..37e6c239b 100644 --- a/classes/Counters.php +++ b/classes/Counters.php @@ -77,8 +77,9 @@ class Counters { $sth = $pdo->prepare("SELECT fc.id, SUM(CASE WHEN unread THEN 1 ELSE 0 END) AS count, - SUM(CASE WHEN marked THEN 1 ELSE 0 END) AS count_marked, - (SELECT COUNT(id) FROM ttrss_feed_categories fcc + SUM(CASE WHEN marked THEN 1 ELSE 0 END) AS count_marked, + SUM(CASE WHEN published THEN 1 ELSE 0 END) AS count_published, + (SELECT COUNT(id) FROM ttrss_feed_categories fcc WHERE fcc.parent_cat = fc.id) AS num_children FROM ttrss_feed_categories fc LEFT JOIN ttrss_feeds f ON (f.cat_id = fc.id) @@ -88,8 +89,9 @@ class Counters { UNION SELECT 0, SUM(CASE WHEN unread THEN 1 ELSE 0 END) AS count, - SUM(CASE WHEN marked THEN 1 ELSE 0 END) AS count_marked, - 0 + SUM(CASE WHEN marked THEN 1 ELSE 0 END) AS count_marked, + SUM(CASE WHEN published THEN 1 ELSE 0 END) AS count_published, + 0 FROM ttrss_feeds f, ttrss_user_entries ue WHERE f.cat_id IS NULL AND ue.feed_id = f.id AND @@ -100,9 +102,9 @@ class Counters { } else { $sth = $pdo->prepare("SELECT fc.id, SUM(CASE WHEN unread THEN 1 ELSE 0 END) AS count, - SUM(CASE WHEN marked THEN 1 ELSE 0 END) AS count_marked, - SUM(CASE WHEN published THEN 1 ELSE 0 END) AS count_published, - (SELECT COUNT(id) FROM ttrss_feed_categories fcc + SUM(CASE WHEN marked THEN 1 ELSE 0 END) AS count_marked, + SUM(CASE WHEN published THEN 1 ELSE 0 END) AS count_published, + (SELECT COUNT(id) FROM ttrss_feed_categories fcc WHERE fcc.parent_cat = fc.id) AS num_children FROM ttrss_feed_categories fc LEFT JOIN ttrss_feeds f ON (f.cat_id = fc.id) @@ -112,9 +114,9 @@ class Counters { UNION SELECT 0, SUM(CASE WHEN unread THEN 1 ELSE 0 END) AS count, - SUM(CASE WHEN marked THEN 1 ELSE 0 END) AS count_marked, - SUM(CASE WHEN published THEN 1 ELSE 0 END) AS count_published, - 0 + SUM(CASE WHEN marked THEN 1 ELSE 0 END) AS count_marked, + SUM(CASE WHEN published THEN 1 ELSE 0 END) AS count_published, + 0 FROM ttrss_feeds f, ttrss_user_entries ue WHERE f.cat_id IS NULL AND ue.feed_id = f.id AND |