From dd3e0698a71ca2746166f006135aeace83dfeb20 Mon Sep 17 00:00:00 2001
From: Christian Weiske <cweiske@cweiske.de>
Date: Thu, 24 Nov 2016 23:11:52 +0100
Subject: show subscriptions on status page

---
 src/phinde/Subscriptions.php | 22 ++++++++++++++++++++++
 1 file changed, 22 insertions(+)

(limited to 'src/phinde')

diff --git a/src/phinde/Subscriptions.php b/src/phinde/Subscriptions.php
index 4d00ab8..5aac9b2 100644
--- a/src/phinde/Subscriptions.php
+++ b/src/phinde/Subscriptions.php
@@ -37,6 +37,28 @@ class Subscriptions
         return $stmt->fetchObject();
     }
 
+    /**
+     * Count number of subscriptions
+     *
+     * @return array Array of keys with different status, number as value
+     */
+    public function count()
+    {
+        $stmt = $this->db->prepare(
+            'SELECT COUNT(*) as count, sub_status FROM subscriptions'
+            . ' GROUP BY sub_status'
+            . ' ORDER BY sub_status'
+        );
+        $stmt->execute();
+
+        $res = [];
+        foreach ($stmt as $row) {
+            $res[$row['sub_status']] = $row['count'];
+        }
+
+        return $res;
+    }
+
     /**
      * Create a new subscription entry in database.
      * Automatically generates secret, capkey and lease seconds.
-- 
cgit v1.2.3