From 62827e6cf470449c117624058fb36ad94804bcc0 Mon Sep 17 00:00:00 2001
From: emkael <emkael@tlen.pl>
Date: Tue, 5 May 2020 14:25:42 +0200
Subject: Time tracking related plugins

---
 .../Controller/AnalyticsTimesController.php        | 150 +++++++++++++++++++++
 1 file changed, 150 insertions(+)
 create mode 100644 plugins/TimeMachine/Controller/AnalyticsTimesController.php

(limited to 'plugins/TimeMachine/Controller/AnalyticsTimesController.php')

diff --git a/plugins/TimeMachine/Controller/AnalyticsTimesController.php b/plugins/TimeMachine/Controller/AnalyticsTimesController.php
new file mode 100644
index 00000000..081d3be0
--- /dev/null
+++ b/plugins/TimeMachine/Controller/AnalyticsTimesController.php
@@ -0,0 +1,150 @@
+<?php
+
+namespace Kanboard\Plugin\TimeMachine\Controller;
+
+use Kanboard\Controller\BaseController;
+use Kanboard\Filter\TaskProjectFilter;
+use Kanboard\Model\TaskModel;
+
+
+/**
+ * @plugin TimeMachine
+ *
+ * @package Kanboard\Plugin\TimeMachine\Controller
+ * @author  yvalentin
+ */
+class AnalyticsTimesController extends BaseController {
+
+    /**
+     * Show comparison between actual and estimated hours chart by Swimlane
+     *
+     * @access public
+     */
+    public function timeComparisonBySwimlane()
+    {
+        $project = $this->getProject();
+        $paginator = $this->getPaginator('timeComparisonBySwimlane', $project);
+
+        list($metrics, $swimlanes) = $this->helper->analyticsTimes->buildBySwimlane($project['id']);
+        $this->response->html(
+            $this->helper->layout->analytic('TimeMachine:analytic/time_comparison_by_swimlane',
+                array(
+                    'project'   => $project,
+                    'swimlanes' => $swimlanes,
+                    'paginator' => $paginator,
+                    'metrics'   => $metrics,
+                    'title'     => t('Estimated vs actual time / Swimlanes'),
+                )
+            )
+        );
+    }
+
+    /**
+     * Show comparison between actual and estimated hours chart by Categories
+     *
+     * @access public
+     */
+    public function timeComparisonByCategories()
+    {
+        $project = $this->getProject();
+        $paginator = $this->getPaginator('timeComparisonByCategories', $project);
+
+        list($metrics, $categories) = $this->helper->analyticsTimes->buildByCategories($project['id']);
+        $this->response->html(
+            $this->helper->layout->analytic('TimeMachine:analytic/time_comparison_by_categories',
+                array(
+                    'project'       => $project,
+                    'categories'    => $categories,
+                    'paginator'     => $paginator,
+                    'metrics'       => $metrics,
+                    'title'         => t('Estimated vs actual time / Categories'),
+                )
+            )
+        );
+    }
+
+    public function timeComparisonByDates()
+    {
+        $project = $this->getProject();
+        list($from, $to) = $this->getDates();
+        $paginatorParams = [
+            'from' => $from->format('Y-m-d'),
+            'to' => $to->format('Y-m-d')
+        ];
+        $paginator = $this->getPaginator('timeComparisonByDates', $project, $paginatorParams);
+
+        list($metrics, $categories, $swimlanes) = $this->helper->analyticsTimes->buildByDates($project['id'], $from, $to);
+
+        $this->response->html(
+            $this->helper->layout->analytic('TimeMachine:analytic/spent_time_by_dates',
+                array(
+                    'project'       => $project,
+                    'categories'    => $categories,
+                    'swimlanes'     => $swimlanes,
+                    'from'          => $from,
+                    'to'            => $to,
+                    'userFormat'    => $this->dateParser->getUserDateFormat(),
+                    'paginator'     => $paginator,
+                    'metrics'       => $metrics,
+                    'title'         => t('Spent time / Dates'),
+                )
+            )
+        );
+
+    }
+
+    /**
+     * Get dates from/to from form request
+     *
+     * @return array
+     */
+    private function getDates()
+    {
+        $values = $this->request->getValues();
+
+        $from   = $this->request->getStringParam('from', date('Y-m-d', strtotime('first day of this month')));
+        $to     = $this->request->getStringParam('to', date('Y-m-d', strtotime('last day of this month')));
+
+        if (! empty($values)) {
+            $from = $this->dateParser->getIsoDate($values['from']);
+            $to = $this->dateParser->getIsoDate($values['to']);
+        }
+
+        // Return \DateTime
+        $from = (new \DateTime($from));
+        $to = (new \DateTime($to));
+        $to->setTime('23', '59', '59');
+
+        return array($from, $to);
+    }
+
+    /**
+     * @param $action
+     * @param $project
+     * @param array $params
+     *
+     * @return \Kanboard\Core\Paginator
+     */
+    private function getPaginator($action, $project, array $params = [])
+    {
+        $urlParams = array('plugin' => 'TimeMachine', 'project_id' => $project['id']);
+        if(!empty($params)) {
+            foreach ($params as $key => $param) {
+                $urlParams[$key] = $param;
+            }
+        }
+        return $this->paginator
+            ->setUrl(
+                'AnalyticsTimesController',
+                $action,
+                $urlParams
+            )
+            ->setMax(30)
+            ->setOrder(TaskModel::TABLE.'.id')
+            ->setQuery($this->taskQuery
+                ->withFilter(new TaskProjectFilter($project['id']))
+                ->getQuery()
+            )
+            ->calculate();
+    }
+}
-- 
cgit v1.2.3