From a3cb1110b35339f441c343c2cdbee676ffa6144b Mon Sep 17 00:00:00 2001
From: Camil Staps
Date: Wed, 3 Aug 2016 13:58:11 +0200
Subject: stats: move to highstock
---
resources/views/stats.blade.php | 101 ++++++++++++++++++++++++----------------
1 file changed, 62 insertions(+), 39 deletions(-)
(limited to 'resources')
diff --git a/resources/views/stats.blade.php b/resources/views/stats.blade.php
index 0326309..26a6503 100644
--- a/resources/views/stats.blade.php
+++ b/resources/views/stats.blade.php
@@ -18,67 +18,90 @@ along with this program. If not, see .
-->
-
- HebrewParseTrainer statistics
-
-
-
+
+ HebrewParseTrainer statistics
+
+
+
groupBy(DB::raw('DAY(created_at)'))
- ->orderBy('created_at')
- ->get();
+ ::select(DB::raw('COUNT(*) as count'), 'created_at')
+ ->groupBy(DB::raw('DAY(created_at)'))
+ ->orderBy('created_at')
+ ->get();
$stats = [];
foreach ($db_stats as $stat) {
- $stats[] = "[Date.UTC" . date("(Y,n-1,d)", strtotime($stat->created_at)) . "," . $stat->count . "]";
+ $stats[] = "[Date.UTC" . date("(Y,n-1,d)", strtotime($stat->created_at)) . "," . $stat->count . "]";
}
$stats = "[" . implode(",", $stats) . "]";
?>
-
+
--
cgit v1.2.3