File size: 1,283 Bytes
e4f4821 |
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 |
<?php
namespace Kanboard\Analytic;
use Kanboard\Core\Base;
use Kanboard\Model\TaskModel;
/**
* Estimated vs actual time per column
*
* @package analytic
* @author Frederic Guillot
*/
class EstimatedActualColumnAnalytic extends Base
{
/**
* Build report
*
* @access public
* @param integer $project_id Project id
* @return array
*/
public function build($project_id)
{
$rows = $this->db->table(TaskModel::TABLE)
->columns('SUM(time_estimated) AS hours_estimated', 'SUM(time_spent) AS hours_spent', 'column_id')
->eq('project_id', $project_id)
->groupBy('column_id')
->findAll();
$columns = $this->columnModel->getList($project_id);
$metrics = [];
foreach ($columns as $column_id => $column_title) {
$metrics[$column_id] = array(
'hours_spent' => 0,
'hours_estimated' => 0,
'title' => $column_title,
);
}
foreach ($rows as $row) {
$metrics[$row['column_id']]['hours_spent'] = (float) $row['hours_spent'];
$metrics[$row['column_id']]['hours_estimated'] = (float) $row['hours_estimated'];
}
return $metrics;
}
}
|