1 files changed, 178 insertions, 0 deletions
diff --git a/app/Controller/AnalyticController.php b/app/Controller/AnalyticController.php
new file mode 100644
index 00000000..cf3ba034
--- /dev/null
+++ b/app/Controller/AnalyticController.php
@@ -0,0 +1,178 @@
+<?php
+
+namespace Kanboard\Controller;
+
+use Kanboard\Filter\TaskProjectFilter;
+use Kanboard\Model\TaskModel;
+
+/**
+ * Project Analytic Controller
+ *
+ * @package  Kanboard\Controller
+ * @author   Frederic Guillot
+ */
+class AnalyticController extends BaseController
+{
+    /**
+     * Show average Lead and Cycle time
+     *
+     * @access public
+     */
+    public function leadAndCycleTime()
+    {
+        $project = $this->getProject();
+        list($from, $to) = $this->getDates();
+
+        $this->response->html($this->helper->layout->analytic('analytic/lead_cycle_time', array(
+            'values' => array(
+                'from' => $from,
+                'to' => $to,
+            ),
+            'project' => $project,
+            'average' => $this->averageLeadCycleTimeAnalytic->build($project['id']),
+            'metrics' => $this->projectDailyStatsModel->getRawMetrics($project['id'], $from, $to),
+            'date_format' => $this->configModel->get('application_date_format'),
+            'date_formats' => $this->dateParser->getAvailableFormats($this->dateParser->getDateFormats()),
+            'title' => t('Lead and Cycle time for "%s"', $project['name']),
+        )));
+    }
+
+    /**
+     * Show comparison between actual and estimated hours chart
+     *
+     * @access public
+     */
+    public function compareHours()
+    {
+        $project = $this->getProject();
+
+        $paginator = $this->paginator
+            ->setUrl('AnalyticController', 'compareHours', array('project_id' => $project['id']))
+            ->setMax(30)
+            ->setOrder(TaskModel::TABLE.'.id')
+            ->setQuery($this->taskQuery
+                ->withFilter(new TaskProjectFilter($project['id']))
+                ->getQuery()
+            )
+            ->calculate();
+
+        $this->response->html($this->helper->layout->analytic('analytic/compare_hours', array(
+            'project' => $project,
+            'paginator' => $paginator,
+            'metrics' => $this->estimatedTimeComparisonAnalytic->build($project['id']),
+            'title' => t('Compare hours for "%s"', $project['name']),
+        )));
+    }
+
+    /**
+     * Show average time spent by column
+     *
+     * @access public
+     */
+    public function averageTimeByColumn()
+    {
+        $project = $this->getProject();
+
+        $this->response->html($this->helper->layout->analytic('analytic/avg_time_columns', array(
+            'project' => $project,
+            'metrics' => $this->averageTimeSpentColumnAnalytic->build($project['id']),
+            'title' => t('Average time spent into each column for "%s"', $project['name']),
+        )));
+    }
+
+    /**
+     * Show tasks distribution graph
+     *
+     * @access public
+     */
+    public function tasks()
+    {
+        $project = $this->getProject();
+
+        $this->response->html($this->helper->layout->analytic('analytic/tasks', array(
+            'project' => $project,
+            'metrics' => $this->taskDistributionAnalytic->build($project['id']),
+            'title' => t('Task repartition for "%s"', $project['name']),
+        )));
+    }
+
+    /**
+     * Show users repartition
+     *
+     * @access public
+     */
+    public function users()
+    {
+        $project = $this->getProject();
+
+        $this->response->html($this->helper->layout->analytic('analytic/users', array(
+            'project' => $project,
+            'metrics' => $this->userDistributionAnalytic->build($project['id']),
+            'title' => t('User repartition for "%s"', $project['name']),
+        )));
+    }
+
+    /**
+     * Show cumulative flow diagram
+     *
+     * @access public
+     */
+    public function cfd()
+    {
+        $this->commonAggregateMetrics('analytic/cfd', 'total', 'Cumulative flow diagram for "%s"');
+    }
+
+    /**
+     * Show burndown chart
+     *
+     * @access public
+     */
+    public function burndown()
+    {
+        $this->commonAggregateMetrics('analytic/burndown', 'score', 'Burndown chart for "%s"');
+    }
+
+    /**
+     * Common method for CFD and Burdown chart
+     *
+     * @access private
+     * @param string $template
+     * @param string $column
+     * @param string $title
+     */
+    private function commonAggregateMetrics($template, $column, $title)
+    {
+        $project = $this->getProject();
+        list($from, $to) = $this->getDates();
+
+        $display_graph = $this->projectDailyColumnStatsModel->countDays($project['id'], $from, $to) >= 2;
+
+        $this->response->html($this->helper->layout->analytic($template, array(
+            'values' => array(
+                'from' => $from,
+                'to' => $to,
+            ),
+            'display_graph' => $display_graph,
+            'metrics' => $display_graph ? $this->projectDailyColumnStatsModel->getAggregatedMetrics($project['id'], $from, $to, $column) : array(),
+            'project' => $project,
+            'date_format' => $this->configModel->get('application_date_format'),
+            'date_formats' => $this->dateParser->getAvailableFormats($this->dateParser->getDateFormats()),
+            'title' => t($title, $project['name']),
+        )));
+    }
+
+    private function getDates()
+    {
+        $values = $this->request->getValues();
+
+        $from = $this->request->getStringParam('from', date('Y-m-d', strtotime('-1week')));
+        $to = $this->request->getStringParam('to', date('Y-m-d'));
+
+        if (! empty($values)) {
+            $from = $values['from'];
+            $to = $values['to'];
+        }
+
+        return array($from, $to);
+    }
+}