diff options
author | Igor Scheller <igor.scheller@igorshp.de> | 2018-12-21 20:09:15 +0100 |
---|---|---|
committer | msquare <msquare@notrademark.de> | 2018-12-22 11:31:33 +0100 |
commit | b3f059ad04fc0f54282aea98c5c2af8d7e46867a (patch) | |
tree | 9a69e1bfb482fc5abb35d7c6f42355b290c21024 /src/Controllers/Metrics/Stats.php | |
parent | 482721eb1ba0ee21a3f75a8465fcf53ae08a1603 (diff) |
metrics: Added vouchers and tshirts
Diffstat (limited to 'src/Controllers/Metrics/Stats.php')
-rw-r--r-- | src/Controllers/Metrics/Stats.php | 35 |
1 files changed, 34 insertions, 1 deletions
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 @@ -97,6 +97,40 @@ class Stats } /** + * @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 * @codeCoverageIgnore @@ -267,7 +301,6 @@ class Stats /** * @param mixed $value * @return QueryExpression - * @codeCoverageIgnore */ protected function raw($value) { |