getstats.php

<?php
# Copyright (c) 2012, Łukasz Kieś <kiesiu@pld-linux.org>
# All rights reserved.
#
# Licensed under BSD 2-Clause license. Please refer to LICENSE.md

function getData($query, $vars) {
    try {
        $dbh = new PDO('sqlite:pldstats.db');
        $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        $dbh->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
        $stmt = $dbh->prepare($query);
        $stmt->execute($vars);
        return $stmt->fetchAll();
    }
    catch (PDOExcetion $e) {
        die($e->getMessage());
    }
}

function makeGraph($title, $xlabels=array(), $ldefs=array(), $rdefs=array()) {
    $graph = array(
        'bg_colour' => '#ffffff',
        'title' => array(
            'text' => $title
        ),
        'x_axis' => array(
            'labels' => array(
                'labels' => $xlabels,
                'rotate' => 'vertical'
            )
        ),
        'legend' => array(
            'visible' => true
        ),
        'elements' => array()
    );
    if (count($ldefs) == 4) {
        $graph['elements'][] = array(
            'type' => $ldefs[0],
            'text' => $ldefs[1],
            'width' => 2,
            'colour' => $ldefs[2],
            'values' => $ldefs[3]
        );
        $graph['y_axis'] = array(
            'colour' => $ldefs[2],
            'min' => 0,
            'max' => ceil(max($ldefs[3]) * 1.1),
            'steps' => round(max($ldefs[3]) / 10)
        );
    }
    if (count($rdefs) == 4) {
        $graph['elements'][] = array(
            'type' => $rdefs[0],
            'text' => $rdefs[1],
            'width' => 2,
            'colour' => $rdefs[2],
            'values' => $rdefs[3],
            'axis' => 'right'
        );
        $graph['y_axis_right'] = array(
            'colour' => $rdefs[2],
            'min' => 0,
            'max' => ceil(max($rdefs[3]) * 1.1),
            'steps' => round(max($rdefs[3]) / 10)
        );
    }
    echo json_encode($graph);
}

function getAuthors() {
    $result = getData('SELECT name, authors FROM data LIMIT 30', array());
    $values = array();
    $labels = array();
    foreach($result as $e) {
        $labels[] = $e['name'];
        $values[] = (int)$e['authors'];
    }
    makeGraph('Commiters weekly (last 30 weeks)', $labels,
        array('line', 'authors', '#a4c639', $values));
}

function getCommits() {
    $result = getData('SELECT name, commits, changes FROM data LIMIT 30', array());
    $values = array(array(), array());
    $labels = array();
    foreach($result as $e) {
        $labels[] = $e['name'];
        $values[0][] = (int)$e['commits'];
        $values[1][] = (int)$e['changes'];
    }
    makeGraph('Commits weekly (last 30 weeks)', $labels,
        array('line', 'commits', '#1034a6', $values[0]),
        array('line', 'lines changed', '#e87600', $values[1]));
}

function getTopEver() {
    $result = getData('SELECT author, COUNT(author) AS c, SUM(changes) AS l FROM commits GROUP BY author ORDER BY c DESC LIMIT 30', array());
    $values = array(array(), array());
    $labels = array();
    foreach($result as $e) {
        $labels[] = $e['author'];
        $values[0][] = (int)$e['c'];
        $values[1][] = (int)$e['l'];
    }
    makeGraph('Top 30 commiters ever', $labels,
        array('bar', 'commits', '#800080', $values[0]),
        array('bar', 'lines changed', '#ed1c24', $values[1]));
}

function getTopWeek() {
    $result = getData('SELECT name FROM data ORDER BY name DESC LIMIT 1', array());
    $result = getData('SELECT author, COUNT(author) AS c, SUM(changes) AS l FROM commits WHERE id=? GROUP BY author ORDER BY c DESC LIMIT 10', array($result[0]['name']));
    $values = array(array(), array());
    $labels = array();
    foreach($result as $e) {
        $labels[] = $e['author'];
        $values[0][] = (int)$e['c'];
        $values[1][] = (int)$e['l'];
    }
    makeGraph('Top 10 commiters last week', $labels,
        array('bar', 'commits', '#1f75fe', $values[0]),
        array('bar', 'lines changed', '#800000', $values[1]));
}

if ($_GET['d'] == 'authors') {
    getAuthors();
}
elseif ($_GET['d'] == 'commits') {
    getCommits();
}
elseif ($_GET['d'] == 'topweek') {
    getTopWeek();
}
elseif ($_GET['d'] == 'topever') {
    getTopEver();
}
?>