PiFinder\Services\Statistics

Complexity

Total Complexity

8

Size/Duplication

Total Lines	92
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	2

Test Coverage

Coverage

94.44%

Importance

Changes	5
Bugs	1	Features	2

6 Methods

Rating	Name	Duplication	Size	Complexity
A	totalPokes()	0	6	1
A	allPokes()	0	8	1
A	totalDevices()	0	4	1
B	networkDistribution()	0	28	2
A	createSqliteRegexpFunction()	0	4	1
A	addColors()	0	11	2

<?php

namespace PiFinder\Services;

use DB;
use PiFinder\Poke;

class Statistics
{
    /**
     * Returns the count of all pokes.
     *
     * @return mixed
     */
    public function totalPokes()
    {
        $base = 189771;

        return Poke::count() + $base;
    }

    /**
     * Returns the the count of all devices.
     *
     * @return mixed
     */
    public function totalDevices()
    {
        return Poke::distinct()->count('mac');
    }

    /**
     * Returns all pokes.
     *
     * @return mixed
     */
    public function allPokes()
    {
        return Poke::select(
            DB::raw('count(*) as pokes, date(created_at) as date')
        )
            ->groupBy('date')
            ->get();
    }

    /**
     * Returns a collection of all networks and it's count.
     *
     * @return mixed
     */
    public function networkDistribution()
    {
        $regex = '^172\.(1[6-9]|2[0-9]|3[01])\.';

        if((new Poke)->getConnection()->getConfig('driver') == 'sqlite') {
            $regex = "/$regex/";
            $this->createSqliteRegexpFunction();
        }

        $data = Poke::select(
            DB::raw("
                CASE
                    WHEN ip LIKE '192.168.%'
                        THEN '192.168.0.0/16'
                    WHEN (ip REGEXP '$regex')
                        THEN '172.16.0.0/12'
                    WHEN ip LIKE '10.%'
                        THEN '10.0.0.0/8'
                    ELSE 'Internet'
                END
		AS label, count(*) as value")
        )
            ->groupBy('label')
            ->orderBy('label')
            ->get();

        return $this->addColors($data);
    }

    /**
     * Creates the Regexp function for the SQLITE database.
     */
    protected function createSqliteRegexpFunction()
    {
        DB::connection()->getPdo()->sqliteCreateFunction('REGEXP', 'preg_match', 2);
    }

    private function addColors($data)
    {
        $colors = ['rgb(23,103,153)', 'rgb(47,135,176)', 'rgb(66,164,187)', 'rgb(91,192,196)'];
        $highlight_colors = ['#8BB3CC', '#97C3D7', '#ADDFE1', '#BBEAE3'];
        foreach ($data as $i => $network) {
            $network['color'] = $colors[$i];
            $network['highlight'] = $highlight_colors[$i];
        }

        return $data;
    }
}