bigsnowfr/larastats

This package allow you to fetch stats as a graph or as an integer from one of your model and get a simple value or an array with a pair value of date and count.

Larastats

A simple Laravel package allowing you to fetch stats from any of your models created between two dates passed in parameters., _(*1)

Installation

With Composer

composer require bigsnowfr/larastats

Examples

Controller

Date format : 2018-01-23, _(*2)

<?php

use Bigsnowfr\Larastats\LarastatsFacade; 

public function index(Request $request)
    {
        $datas = [
          'userCount'      => [User::class, 'count'],
          'votesCount'     => [Vote::class, 'count'],
          'userStatsDatas' => [User::class, 'graph']
        ];


        foreach ($datas as $key => $data) {
            $$key = LarastatsFacade::getStatByDate($data[0], $request->input('start'), $request->input('end'),
              $data[1]);
        }

        return view('admin.pages.dashboard',
          compact(['userCount', 'votesCount', 'userStatsDatas']));
    }

View using 'count' as a parameter

<div class="col-md-4">
    {{-- $userCount return an integer, 53 for example --}}
    <p>{{ $userCount }}</p>
    <p>Total Users</p>
</div>

View using 'graph' as a parameter using Morris.js

<div class="card-box">
    <div id="stats-container"></div>
</div>
<script>
    // Date Range user graph
    const url_string = window.location.href,
      url = new URL(url_string),
      start = url.searchParams.get('start') ? moment(url.searchParams.get('start')) : moment().subtract(7, 'days'),
      end = url.searchParams.get('end') ? moment(url.searchParams.get('end')) : moment();

    function cb(start, end) {
      $('#reportrange span').html(start.format('MMMM D, YYYY') + ' - ' + end.format('MMMM D, YYYY'));
    }

    $('input[name="users-daterange"]').daterangepicker({
      'locale': {
        'format': 'MM/DD/YYYY',
        'separator': ' - ',
        'applyLabel': 'Confirm',
        'cancelLabel': 'Cancel',
        'fromLabel': 'From',
        'toLabel': 'to',
        'customRangeLabel': 'Custom',
        'weekLabel': 'S',
        'daysOfWeek': [
          'Sun',
          'Mon',
          'Tue',
          'Wed',
          'Thu',
          'Fri',
          'Sat'
        ],
        'monthNames': [
          'January',
          'February',
          'March',
          'April',
          'May',
          'June',
          'July',
          'August',
          'September',
          'October',
          'November',
          'December'
        ],
        'firstDay': 0
      },
      startDate: start,
      endDate: end,
    }, cb);

    cb(start, end);

    $('input[name="users-daterange"]').on('apply.daterangepicker', function (ev, picker) {
      document.location.href = `{{ config('url') }}/dashboard?start=${picker.startDate.format('YYYY-MM-DD')}&end=${picker.endDate.format('YYYY-MM-DD')}`;
    });

    // User graphic evolution
    var data = {!! $userStatsDatas !!};
    new Morris.Line({
      // ID of the element in which to draw the chart.
      element: 'stats-container',
      data: data,
      xkey: 'x',
      ykeys: ['y'],
      xLabel: 'Jours',
      yLabelFormat: function (y) {return y != Math.round(y) ? '' : y;},
      xLabelFormat: function (d) {
        return d.getDate() + '/' + (d.getMonth() + 1) + '/' + d.getFullYear();
      },
      labels: ['Users'],
      lineWidth: 2,
      dateFormat: function (date) {
        d = new Date(date);
        return d.getDate() + '/' + (d.getMonth() + 1) + '/' + d.getFullYear();
      },
    });
</script>