From 6854cb3f4d8219cf1829e32122eb2502a916eae9 Mon Sep 17 00:00:00 2001
From: Andreas Baumann <mail@andreasbaumann.cc>
Date: Sat, 1 Feb 2020 09:05:48 +0100
Subject: initial checkin

---
 scripts/roadmap.php | 84 +++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 84 insertions(+)
 create mode 100644 scripts/roadmap.php

(limited to 'scripts/roadmap.php')

diff --git a/scripts/roadmap.php b/scripts/roadmap.php
new file mode 100644
index 0000000..709a0a5
--- /dev/null
+++ b/scripts/roadmap.php
@@ -0,0 +1,84 @@
+<?php
+/*********************************************************\
+| Show the roadmap                                        |
+| ~~~~~~~~~~~~~~~~~~~                                     |
+\*********************************************************/
+
+if (!defined('IN_FS')) {
+    die('Do not access this file directly.');
+}
+
+if (!$proj->id) {
+    Flyspray::show_error(25);
+}
+
+if ((!$user->isAnon() && !$user->perms('view_roadmap')) || ($user->isAnon() && $proj->prefs['others_viewroadmap'] !=1)) {
+	# better set redirect to false to avoid endless loops
+	Flyspray::show_error(28, false);
+} else{
+
+	if($proj->prefs['use_effort_tracking']){
+	    require_once(BASEDIR . '/includes/class.effort.php');
+	}
+
+
+	$page->setTitle($fs->prefs['page_title'] . L('roadmap'));
+
+	// Get milestones
+	$milestones = $db->query('SELECT   version_id, version_name
+                          FROM     {list_version}
+                          WHERE    (project_id = ? OR project_id=0) AND version_tense = 3
+                          ORDER BY list_position ASC', 
+		array($proj->id));
+
+	$data = array();
+
+while ($row = $db->fetchRow($milestones)) {
+    // Get all tasks related to a milestone
+    $all_tasks = $db->query('SELECT  percent_complete, is_closed
+                             FROM    {tasks}
+                             WHERE   closedby_version = ? AND project_id = ?',
+        array($row['version_id'], $proj->id));
+    $all_tasks = $db->fetchAllArray($all_tasks);
+
+    $percent_complete = 0;
+    foreach($all_tasks as $task) {
+        if($task['is_closed']) {
+            $percent_complete += 100;
+        } else {
+            $percent_complete += $task['percent_complete'];
+        }
+    }
+    $percent_complete = round($percent_complete/max(count($all_tasks), 1));
+
+    $tasks = $db->query('SELECT task_id, item_summary, detailed_desc, item_status, task_severity, task_priority, task_type, mark_private, opened_by, content, task_token, t.project_id,estimated_effort
+                           FROM {tasks} t
+                      LEFT JOIN {cache} ca ON (t.task_id = ca.topic AND ca.type = \'rota\' AND t.last_edited_time <= ca.last_updated)
+                          WHERE closedby_version = ? AND t.project_id = ? AND is_closed = 0',
+        array($row['version_id'], $proj->id));
+    $tasks = $db->fetchAllArray($tasks);
+
+    $count = count($tasks);
+    for ($i = 0; $i < $count; $i++) {
+        if (!$user->can_view_task($tasks[$i])) {
+            unset($tasks[$i]);
+        }
+    }
+
+    $data[] = array('id' => $row['version_id'], 'open_tasks' => $tasks, 'percent_complete' => $percent_complete,
+        'all_tasks' => $all_tasks, 'name' => $row['version_name']);
+} # end while
+
+	if (Get::val('txt')) {
+	    $page = new FSTpl;
+	    header('Content-Type: text/plain; charset=UTF-8');
+	    $page->uses('data', 'page');
+	    $page->display('roadmap.text.tpl');
+	    exit();
+	} else {
+	    $page->uses('data', 'page');
+	    $page->pushTpl('roadmap.tpl');
+	}
+
+} # end if allowed roadmap view
+?>
-- 
cgit v1.2.3-70-g09d2