/**
* Return all open tasklists associated to a given milestones
*
* @param int $milestone Milestone ID
* @return array $lists Details of the tasklists
*/
private function getMilestoneTasklists($milestone)
{
global $conn;
$milestone = (int) $milestone;
$objtasklist = new tasklist();
$sel = $conn->query("SELECT ID FROM tasklist WHERE milestone = {$milestone} AND status = 1 ORDER BY ID ASC");
$lists = array();
if ($milestone) {
while ($listId = $sel->fetch()) {
array_push($lists, $objtasklist->getTasklist($listId["ID"]));
}
}
if (!empty($lists)) {
return $lists;
} else {
return false;
}
}
$errtxt = $langfile["notyourproject"];
$noperm = $langfile["accessdenied"];
$template->assign("errortext", "{$errtxt}<br>{$noperm}");
$template->display("error.tpl");
die;
}
$myproject = new project();
$pro = $myproject->getProject($id);
$projectname = $pro["name"];
$title = $langfile['task'];
$mytask = new task();
$task = $mytask->getTask($tid);
$members = $myproject->getProjectMembers($id, $myproject->countMembers($id));
$tasklist = new tasklist();
$tasklists = $tasklist->getProjectTasklists($id);
$tl = $tasklist->getTasklist($task['liste']);
$task['listid'] = $tl['ID'];
$task['listname'] = $tl['name'];
$tmp = $mytask->getUsers($task['ID']);
if ($tmp) {
foreach ($tmp as $value) {
$task['users'][] = $value[0];
}
}
$user = $mytask->getUser($task['ID']);
$task['username'] = $user[1];
$task['userid'] = $user[0];
$template->assign("members", $members);
$template->assign("tasklists", $tasklists);
$template->assign("tl", $tl);
$template->assign("pid", $id);
