getManagedUsers(); $managed_uids = []; foreach ($managed_users as $u) { $managed_uids[] = $u->getUID(); } // There needs to be at least one entry otherwise the SQL query craps itself if (count($managed_uids) < 1) { $managed_uids = [-1]; } $tasks = $database->select('tasks', [ '[>]assigned_tasks' => [ 'taskid' => 'taskid' ] ], [ 'tasks.taskid', 'tasktitle (title)', 'taskdesc (desc)', 'taskassignedon (assigned)', 'taskdueby (due)', 'userid', 'statusid', 'starttime', 'endtime' ], [ "AND" => [ "OR" => [ 'tasks.taskcreatoruid' => $_SESSION['uid'], 'assigned_tasks.userid' => $managed_uids ], "tasks.deleted" => 0 ] ] ); if (count($tasks) > 0) { $usercache = []; foreach ($tasks as $task) { if (isset($_GET['alone']) || (isset($pageid) && $pageid != "home")) { echo "
"; } $colorclass = "default"; switch ($task['statusid']) { case 2: $colorclass = "success"; break; case 4: $colorclass = "warning"; break; } ?>
"; break; case 1: echo ""; break; case 2: echo ""; break; case 3: echo ""; break; case 4: echo ""; break; } echo " " . $task['title']; // Check if the task is assigned to someone and show status if it is if (!is_null($task['userid'])) { echo ""; if (!isset($usercache[$task['userid']])) { $usercache[$task['userid']] = (new User($task['userid'])); } echo " " . $usercache[$task['userid']]->getName(); echo ""; } ?>
build("assigned on", ["date" => ($task['assigned'] > 0 ? date("M j, g:i a", strtotime($task['assigned'])) : $Strings->get("no assigned date", false))]) ?>
build("due by", ["date" => ($task['due'] > 0 ? date("M j, g:i a", strtotime($task['due'])) : $Strings->get("no due date", false))]) ?>
0) { ?>
build("started on", ["date" => date("M j, g:i a", strtotime($task['starttime']))]) ?>
build("finished on", ["date" => date("M j, g:i a", strtotime($task['endtime']))]) ?>
' />
' />
"; } } } else { if (isset($_GET['alone']) || (isset($pageid) && $pageid != "home")) { echo "
"; } echo "
" . $Strings->get("no tasks", false) . "
"; if (isset($_GET['alone']) || (isset($pageid) && $pageid != "home")) { echo "
"; } } //var_dump($tasks); ?>