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/toplevel.php | 103 +++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 103 insertions(+)
 create mode 100644 scripts/toplevel.php

(limited to 'scripts/toplevel.php')

diff --git a/scripts/toplevel.php b/scripts/toplevel.php
new file mode 100644
index 0000000..f370cde
--- /dev/null
+++ b/scripts/toplevel.php
@@ -0,0 +1,103 @@
+<?php
+/***********************************\
+| Top level project overview        |
+\***********************************/
+
+if (!defined('IN_FS')) {
+  die('Do not access this file directly.');
+}
+
+if ($proj->id && $user->can_select_project($proj->prefs)) {
+  $projects = array(
+    0 => array(
+      'project_id' => $proj->id,
+      'project_title' => $proj->prefs['project_title'],
+      'project_is_active' => $proj->prefs['project_is_active']
+    )
+  );
+} else {
+  $projects = $fs->projects;
+  # anon users should not see details of a restricted project but anon tasks creation allowed
+  # but in /index.php we filter now by 'can_select_project', not 'can_view_project' anymore.
+  $projects= array_filter($projects, array($user, 'can_select_project'));
+}
+
+if(count($projects)>0){
+
+  $most_wanted = array();
+  $stats = array();
+  $assigned_to_myself = array();
+  $projprefs = array();
+
+  # Most wanted tasks for each project
+  foreach ($projects as $project) {
+    # means 'can view tasks' ..
+    if($user->can_view_project($project['project_id'])){
+      $sql = $db->query('SELECT v.task_id, count(*) AS num_votes
+        FROM {votes} v
+        LEFT JOIN {tasks} t ON v.task_id = t.task_id AND t.project_id = ?
+        WHERE t.is_closed = 0
+        GROUP BY v.task_id
+        ORDER BY num_votes DESC',
+        array($project['project_id']), 5
+      );
+
+      if ($db->countRows($sql)) {
+        $most_wanted[$project['project_id']] = $db->fetchAllArray($sql);
+      }
+    }
+  }
+
+  # Project stats
+  foreach ($projects as $project) {
+    $sql = $db->query('SELECT count(*) FROM {tasks} WHERE project_id = ?', array($project['project_id']));
+    $stats[$project['project_id']]['all'] = $db->fetchOne($sql);
+
+    $sql = $db->query('SELECT count(*) FROM {tasks} WHERE project_id = ? AND is_closed = 0', array($project['project_id']));
+    $stats[$project['project_id']]['open'] = $db->fetchOne($sql);
+
+    $sql = $db->query('SELECT avg(percent_complete) FROM {tasks} WHERE project_id = ? AND is_closed = 0', array($project['project_id']));
+    $stats[$project['project_id']]['average_done'] = round($db->fetchOne($sql), 0);
+
+    if ($proj->id) {
+      $prefs = $proj->prefs;
+    } else {
+      $currentproj = new Project($project['project_id']);
+      $prefs = $currentproj->prefs;
+    }
+
+    $projprefs[$project['project_id']] = $prefs;
+  
+    if($user->perms('view_estimated_effort', $project['project_id']) ){
+      if ($prefs['use_effort_tracking']) {
+        $sql = $db->query('
+          SELECT t.task_id, t.estimated_effort
+          FROM {tasks} t
+          WHERE project_id = ? AND is_closed = 0',
+          array($project['project_id'])
+        );
+        $stats[$project['project_id']]['tasks'] = $db->fetchAllArray($sql);
+      }
+    }
+  }
+
+  # Assigned to myself
+  foreach ($projects as $project) {
+    $sql = $db->query('
+      SELECT a.task_id
+      FROM {assigned} a
+      LEFT JOIN {tasks} t ON a.task_id = t.task_id AND t.project_id = ?
+      WHERE t.is_closed = 0 and a.user_id = ?',
+      array($project['project_id'], $user->id), 5
+    );
+    if ($db->countRows($sql)) {
+      $assigned_to_myself[$project['project_id']] = $db->fetchAllArray($sql);
+    }
+  }
+  $page->uses('most_wanted', 'stats', 'projects', 'assigned_to_myself', 'projprefs');
+  $page->setTitle($fs->prefs['page_title'] . $proj->prefs['project_title'] . ': ' . L('toplevel'));
+  $page->pushTpl('toplevel.tpl');
+} else{
+  # mmh what we want to show anon users with only the 'create anon task' permission enabled?...
+}
+?>
-- 
cgit v1.2.3-70-g09d2