From b3f059ad04fc0f54282aea98c5c2af8d7e46867a Mon Sep 17 00:00:00 2001
From: Igor Scheller <igor.scheller@igorshp.de>
Date: Fri, 21 Dec 2018 20:09:15 +0100
Subject: metrics: Added vouchers and tshirts

---
 src/Controllers/Metrics/Stats.php | 35 ++++++++++++++++++++++++++++++++++-
 1 file changed, 34 insertions(+), 1 deletion(-)

(limited to 'src/Controllers/Metrics/Stats.php')

diff --git a/src/Controllers/Metrics/Stats.php b/src/Controllers/Metrics/Stats.php
index 838411d1..11643e46 100644
--- a/src/Controllers/Metrics/Stats.php
+++ b/src/Controllers/Metrics/Stats.php
@@ -96,6 +96,40 @@ class Stats
         return $query->count();
     }
 
+    /**
+     * @return int
+     */
+    public function vouchers(): int
+    {
+        return $this
+            ->getQuery('users_state')
+            ->sum('got_voucher');
+    }
+
+    /**
+     * @return int
+     */
+    public function tshirts(): int
+    {
+        return $this
+            ->getQuery('users_state')
+            ->where('got_shirt', '=', true)
+            ->count();
+    }
+
+    /**
+     * @return \Illuminate\Support\Collection
+     */
+    public function tshirtSizes()
+    {
+        return $this
+            ->getQuery('users_personal_data')
+            ->select(['shirt_size', $this->raw('COUNT(shirt_size) AS count')])
+            ->whereNotNull('shirt_size')
+            ->groupBy('shirt_size')
+            ->get();
+    }
+
     /**
      * @param string $vehicle
      * @return int
@@ -267,7 +301,6 @@ class Stats
     /**
      * @param mixed $value
      * @return QueryExpression
-     * @codeCoverageIgnore
      */
     protected function raw($value)
     {
-- 
cgit v1.2.3-54-g00ecf