Remove ProjectAnalytic class

2 files changed, 263 insertions, 0 deletions

diff --git a/app/Analytic/AverageLeadCycleTimeAnalytic.php b/app/Analytic/AverageLeadCycleTimeAnalytic.php
new file mode 100644
index 00000000..96c803cc
--- /dev/null
+++ b/app/Analytic/AverageLeadCycleTimeAnalytic.php
@@ -0,0 +1,112 @@
+<?php
+
+namespace Kanboard\Analytic;
+
+use Kanboard\Core\Base;
+use Kanboard\Model\Task;
+
+/**
+ * Average Lead and Cycle Time
+ *
+ * @package  analytic
+ * @author   Frederic Guillot
+ */
+class AverageLeadCycleTimeAnalytic extends Base
+{
+    /**
+     * Build report
+     *
+     * @access public
+     * @param  integer   $project_id    Project id
+     * @return array
+     */
+    public function build($project_id)
+    {
+        $stats = array(
+            'count' => 0,
+            'total_lead_time' => 0,
+            'total_cycle_time' => 0,
+            'avg_lead_time' => 0,
+            'avg_cycle_time' => 0,
+        );
+
+        foreach ($this->getTasks($project_id) as &$task) {
+            $stats['count']++;
+            $stats['total_lead_time'] += $this->calculateLeadTime($task);
+            $stats['total_cycle_time'] += $this->calculateCycleTime($task);
+        }
+
+        $stats['avg_lead_time'] = $this->calculateAverage($stats, 'total_lead_time');
+        $stats['avg_cycle_time'] = $this->calculateAverage($stats, 'total_cycle_time');
+
+        return $stats;
+    }
+
+    /**
+     * Calculate average
+     *
+     * @access private
+     * @param  array  &$stats
+     * @param  string $field
+     * @return float
+     */
+    private function calculateAverage(array &$stats, $field)
+    {
+        if ($stats['count'] > 0) {
+            return (int) ($stats[$field] / $stats['count']);
+        }
+
+        return 0;
+    }
+
+    /**
+     * Calculate lead time
+     *
+     * @access private
+     * @param  array  &$task
+     * @return integer
+     */
+    private function calculateLeadTime(array &$task)
+    {
+        $end = $task['date_completed'] ?: time();
+        $start = $task['date_creation'];
+
+        return $end - $start;
+    }
+
+    /**
+     * Calculate cycle time
+     *
+     * @access private
+     * @param  array  &$task
+     * @return integer
+     */
+    private function calculateCycleTime(array &$task)
+    {
+        if (empty($task['date_started'])) {
+            return 0;
+        }
+
+        $end = $task['date_completed'] ?: time();
+        $start = $task['date_started'];
+
+        return $end - $start;
+    }
+
+    /**
+     * Get the 1000 last created tasks
+     *
+     * @access private
+     * @return array
+     */
+    private function getTasks($project_id)
+    {
+        return $this->db
+            ->table(Task::TABLE)
+            ->columns('date_completed', 'date_creation', 'date_started')
+            ->eq('project_id', $project_id)
+            ->desc('id')
+            ->limit(1000)
+            ->findAll();
+    }
+}
diff --git a/app/Analytic/AverageTimeSpentColumnAnalytic.php b/app/Analytic/AverageTimeSpentColumnAnalytic.php
new file mode 100644
index 00000000..820db801
--- /dev/null
+++ b/app/Analytic/AverageTimeSpentColumnAnalytic.php
@@ -0,0 +1,151 @@
+<?php
+
+namespace Kanboard\Analytic;
+
+use Kanboard\Core\Base;
+use Kanboard\Model\Task;
+
+/**
+ * Average Time Spent by Column
+ *
+ * @package  analytic
+ * @author   Frederic Guillot
+ */
+class AverageTimeSpentColumnAnalytic extends Base
+{
+    /**
+     * Build report
+     *
+     * @access public
+     * @param  integer   $project_id    Project id
+     * @return array
+     */
+    public function build($project_id)
+    {
+        $stats = $this->initialize($project_id);
+
+        $this->processTasks($stats, $project_id);
+        $this->calculateAverage($stats);
+
+        return $stats;
+    }
+
+    /**
+     * Initialize default values for each column
+     *
+     * @access private
+     * @param  integer $project_id
+     * @return array
+     */
+    private function initialize($project_id)
+    {
+        $stats = array();
+        $columns = $this->board->getColumnsList($project_id);
+
+        foreach ($columns as $column_id => $column_title) {
+            $stats[$column_id] = array(
+                'count' => 0,
+                'time_spent' => 0,
+                'average' => 0,
+                'title' => $column_title,
+            );
+        }
+
+        return $stats;
+    }
+
+    /**
+     * Calculate time spent for each tasks for each columns
+     *
+     * @access private
+     * @param  array   $stats
+     * @param  integer $project_id
+     */
+    private function processTasks(array &$stats, $project_id)
+    {
+        foreach ($this->getTasks($project_id) as &$task) {
+            foreach ($this->getTaskTimeByColumns($task) as $column_id => $time_spent) {
+                if (isset($stats[$column_id])) {
+                    $stats[$column_id]['count']++;
+                    $stats[$column_id]['time_spent'] += $time_spent;
+                }
+            }
+        }
+    }
+
+    /**
+     * Calculate averages
+     *
+     * @access private
+     * @param  array   $stats
+     */
+    private function calculateAverage(array &$stats)
+    {
+        foreach ($stats as &$column) {
+            $this->calculateColumnAverage($column);
+        }
+    }
+
+    /**
+     * Calculate column average
+     *
+     * @access private
+     * @param  array   $column
+     */
+    private function calculateColumnAverage(array &$column)
+    {
+        if ($column['count'] > 0) {
+            $column['average'] = (int) ($column['time_spent'] / $column['count']);
+        }
+    }
+
+    /**
+     * Get time spent for each column for a given task
+     *
+     * @access private
+     * @param  array   $task
+     * @return array
+     */
+    private function getTaskTimeByColumns(array &$task)
+    {
+        $columns = $this->transition->getTimeSpentByTask($task['id']);
+
+        if (! isset($columns[$task['column_id']])) {
+            $columns[$task['column_id']] = 0;
+        }
+
+        $columns[$task['column_id']] += $this->getTaskTimeSpentInCurrentColumn($task);
+
+        return $columns;
+    }
+
+    /**
+     * Calculate time spent of a task in the current column
+     *
+     * @access private
+     * @param  array   $task
+     */
+    private function getTaskTimeSpentInCurrentColumn(array &$task)
+    {
+        $end = $task['date_completed'] ?: time();
+        return $end - $task['date_moved'];
+    }
+
+    /**
+     * Fetch the last 1000 tasks
+     *
+     * @access private
+     * @param  integer $project_id
+     * @return array
+     */
+    private function getTasks($project_id)
+    {
+        return $this->db
+            ->table(Task::TABLE)
+            ->columns('id', 'date_completed', 'date_moved', 'column_id')
+            ->eq('project_id', $project_id)
+            ->desc('id')
+            ->limit(1000)
+            ->findAll();
+    }
+}