aboutsummaryrefslogtreecommitdiff
path: root/resources/views/stats.blade.php
blob: 0326309bbf114cafaa359888a0aaea96c7b61301 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
<!DOCTYPE html>
<!--
HebrewParseTrainer - practice Hebrew verbs
Copyright (C) 2015  Camil Staps <info@camilstaps.nl>

This program is free software: you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program.  If not, see <http://www.gnu.org/licenses/>.
 -->
<html lang="en">
<head>
    <meta charset="utf-8">
    <title>HebrewParseTrainer statistics</title>
    <link rel="stylesheet" href="{{ url("/vendor/twbs/bootstrap/dist/css/bootstrap.min.css") }}">
    <link rel="stylesheet" href="{{ url("/vendor/twbs/bootstrap/dist/css/bootstrap-theme.min.css") }}">
    <link rel="stylesheet" href="{{ url("/public/css/hebrewparsetrainer.css") }}">
</head>
<body role="application">
<div class="container" role="main">
    <div class="page-header">
        <h1>HebrewParseTrainer statistics</h1>
    </div>

    <div class="row">
        <div class="col-md-12">
            <div id="statistics" style="height:400px;"></div>
        </div>
    </div>
</div>

<?php
use \HebrewParseTrainer\RandomLog;

$db_stats = RandomLog
    ::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 = "[" . implode(",", $stats) . "]";
?>

<script src="{{ url("/vendor/components/jquery/jquery.min.js") }}"></script>
<script src="{{ url("/vendor/twbs/bootstrap/dist/js/bootstrap.min.js") }}"></script>
<script src="//code.highcharts.com/highcharts.js"></script>
<script src="{{ url("/public/js/hebrewparsetrainer.js") }}"></script>

<script type="text/javascript">
    $('#statistics').highcharts({
        chart: { type: 'column', zoomType: 'x' },
        title: { text: 'Requests per day' },
        xAxis: { type: 'datetime' },
        yAxis: {
            min: 0,
            title: { text: 'Requests' }
        },
        plotOptions: { column: {
            pointPadding: 0,
            groupPadding: 0
        } },
        tooltip: { pointFormat: '<b>{point.y}</b> requests' },
        series: [
            {
                name: 'Requests',
                data: {{ $stats }}
            }
        ]
    });
</script>
</body>
</html>