round_backlog_days.php

<?php
$relPath = "./../pinc/";
include_once($relPath.'base.inc');
include_once($relPath.'graph_data.inc');
include_once($relPath.'slim_header.inc');

// This image shows how many days it would take to complete all pages in
// the current round at the current rate. The current rate is calculated
// as the average number of pages completed in that round over the previous
// 7 days. Because this graph uses trend information, the graph can change
// day-to-day based on pages completed in each round.
//
// see also: http://www.pgdp.net/wiki/Round_backlog_graphs

$width = 300;
$height = 200;

function _get_round_backlog_days_data()
{
    // Pull all interested phases, primarily all the rounds and PP
    $interested_phases = Rounds::get_ids();

    // Pull the stats data out of the database
    $stats = get_round_backlog_stats($interested_phases);

    // Get page saveAsDone trend information
    $holder_id = 1;
    $today = getdate();
    foreach ($stats as $phase => $pages) {
        $tallyboard = new TallyBoard($phase, 'S');

        $pages_last_week = $tallyboard->get_delta_sum(
            $holder_id,
            mktime(0, 0, 0, $today['mon'], $today['mday'] - 7, $today['year']),
            mktime(0, 0, 0, $today['mon'], $today['mday'], $today['year'])
        );

        $avg_pages_per_day[$phase] = $pages_last_week / 7;

        // calculate the number of days to complete at the current rate
        if ($avg_pages_per_day[$phase]) {
            $stats[$phase] = $pages / $avg_pages_per_day[$phase];
        } else {
            $stats[$phase] = 0;
        }
    }

    return $stats;
}

// cache backlog data for 1 day
$stats = query_graph_cache("_get_round_backlog_days_data", [], 60 * 60 * 24);

// get the total of all phases
$stats_total = array_sum($stats);

// calculate the goal percent as 100 / number_of_phases
$goal_percent = ceil(100 / max(1, count($stats)));

// colors
$barColors = [];
$barColorDefault = "graph-normal-series";
$barColorAboveGoal = "graph-above-goal";

$days_total = array_sum($stats);
if ($days_total == 0) {
    $days_total = 1;
}

// calculate the percentage of work remaining in each round
// and the color for each bar
foreach ($stats as $phase => $num_days) {
    $stats_percentage[$phase] = ceil(($num_days / $days_total) * 100);
    if ($stats_percentage[$phase] > $goal_percent) {
        $barColors[] = $barColorAboveGoal;
    } else {
        $barColors[] = $barColorDefault;
    }
}

// Some graph variables
$datax = array_keys($stats);
$datay = array_values($stats);
$title = _("Days to finish all pages in Rounds");
// TRANSLATORS: This string is the title of a graph with very little room.
//              Try to keep the translation the same length as the English text.
$x_title = _("Help is most needed in the red rounds");

// If this is a new system there won't be any stats so don't divide by zero
if ($stats_total == 0) {
    $title = _("No pages found.");
}

$graphs = [
    ["barLineGraph", "round_backlog_days", [
        "title" => $title,
        "downloadLabel" => _("Download Chart"),
        "barColors" => $barColors,
        "data" => [
            $x_title => [
                "x" => $datax,
                "y" => $datay,
            ],
        ],
        "width" => $width,
        "height" => $height,
        "bottomLegend" => $x_title,
        "yAxisTickCount" => 5,
    ]],
];

slim_header($title, [
    "body_attributes" => "style='margin: 0;overflow: hidden'",
    "js_files" => get_graph_js_files(),
    "js_data" => build_svg_graph_inits($graphs),

]);

echo "<div id='round_backlog_days' style='width:" . $width . "px;height:" . $height . "px;'></div>";