Add task analytics

2 files changed, 90 insertions, 0 deletions

diff --git a/app/Model/TaskAnalytic.php b/app/Model/TaskAnalytic.php
new file mode 100644
index 00000000..41579c7d
--- /dev/null
+++ b/app/Model/TaskAnalytic.php
@@ -0,0 +1,74 @@
+<?php
+
+namespace Model;
+
+/**
+ * Task Analytic
+ *
+ * @package  model
+ * @author   Frederic Guillot
+ */
+class TaskAnalytic extends Base
+{
+    /**
+     * Get the time between date_creation and date_completed or now if empty
+     *
+     * @access public
+     * @param  array   $task
+     * @return integer
+     */
+    public function getLeadTime(array $task)
+    {
+        return ($task['date_completed'] ?: time()) - $task['date_creation'];
+    }
+
+    /**
+     * Get the time between date_started and date_completed or now if empty
+     *
+     * @access public
+     * @param  array   $task
+     * @return integer
+     */
+    public function getCycleTime(array $task)
+    {
+        if (empty($task['date_started'])) {
+            return 0;
+        }
+
+        return ($task['date_completed'] ?: time()) - $task['date_started'];
+    }
+
+    /**
+     * Get the average time spent in each column
+     *
+     * @access public
+     * @param  array   $task
+     * @return array
+     */
+    public function getAverageTimeByColumn(array $task)
+    {
+        $result = array();
+        $columns = $this->board->getColumnsList($task['project_id']);
+        $averages = $this->transition->getAverageTimeSpentByTask($task['id']);
+
+        foreach ($columns as $column_id => $column_title) {
+
+            $time_spent = 0;
+
+            if (empty($averages) && $task['column_id'] == $column_id) {
+                $time_spent = time() - $task['date_creation'];
+            }
+            else {
+                $time_spent = isset($averages[$column_id]) ? $averages[$column_id] : 0;
+            }
+
+            $result[] = array(
+                'id' => $column_id,
+                'title' => $column_title,
+                'time_spent' => $time_spent,
+            );
+        }
+
+        return $result;
+    }
+}
diff --git a/app/Model/Transition.php b/app/Model/Transition.php
index cb759e4a..959b6aca 100644
--- a/app/Model/Transition.php
+++ b/app/Model/Transition.php
@@ -39,6 +39,22 @@ class Transition extends Base
     }
 
     /**
+     * Get average time spent by task for each column
+     *
+     * @access public
+     * @param  integer  $task_id
+     * @return array
+     */
+    public function getAverageTimeSpentByTask($task_id)
+    {
+        return $this->db
+                    ->hashtable(self::TABLE)
+                    ->groupBy('src_column_id')
+                    ->eq('task_id', $task_id)
+                    ->getAll('src_column_id', 'SUM(time_spent) AS time_spent');
+    }
+
+    /**
      * Get all transitions by task
      *
      * @access public