/**
* GET /backlog
* GET /backlog/@filter
* GET /backlog/@filter/@groupid
*
* @param \Base $f3
* @param array $params
*/
public function index($f3, $params)
{
if (empty($params["filter"])) {
$params["filter"] = "groups";
}
if (empty($params["groupid"])) {
$params["groupid"] = "";
}
// Get list of all users in the user's groups
if ($params["filter"] == "groups") {
$group_model = new \Model\User\Group();
if (!empty($params["groupid"]) && is_numeric($params["groupid"])) {
//Get users list from a specific Group
$users_result = $group_model->find(array("group_id = ?", $params["groupid"]));
} else {
//Get users list from all groups that you are in
$groups_result = $group_model->find(array("user_id = ?", $this->_userId));
$filter_users = array($this->_userId);
foreach ($groups_result as $g) {
$filter_users[] = $g["group_id"];
}
$groups = implode(",", $filter_users);
$users_result = $group_model->find("group_id IN ({$groups})");
}
foreach ($users_result as $u) {
$filter_users[] = $u["user_id"];
}
} elseif ($params["filter"] == "me") {
//Just get your own id
$filter_users = array($this->_userId);
}
$filter_string = empty($filter_users) ? "" : "AND owner_id IN (" . implode(",", $filter_users) . ")";
$f3->set("filter", $params["filter"]);
$sprint_model = new \Model\Sprint();
$sprints = $sprint_model->find(array("end_date >= ?", $this->now(false)), array("order" => "start_date ASC"));
$issue = new \Model\Issue\Detail();
$sprint_details = array();
foreach ($sprints as $sprint) {
$projects = $issue->find(array("deleted_date IS NULL AND sprint_id = ? AND type_id = ? {$filter_string}", $sprint->id, $f3->get("issue_type.project")), array('order' => 'priority DESC, due_date'));
$sprint_details[] = $sprint->cast() + array("projects" => $projects);
}
$large_projects = $f3->get("db.instance")->exec("SELECT parent_id FROM issue WHERE parent_id IS NOT NULL AND type_id = ?", $f3->get("issue_type.project"));
$large_project_ids = array();
foreach ($large_projects as $p) {
$large_project_ids[] = $p["parent_id"];
}
// Load backlog
if (!empty($large_project_ids)) {
$large_project_ids = implode(",", $large_project_ids);
$unset_projects = $issue->find(array("deleted_date IS NULL AND sprint_id IS NULL AND type_id = ? AND status_closed = '0' AND id NOT IN ({$large_project_ids}) {$filter_string}", $f3->get("issue_type.project")), array('order' => 'priority DESC, due_date'));
} else {
$unset_projects = $issue->find(array("deleted_date IS NULL AND sprint_id IS NULL AND type_id = ? AND status_closed = '0' {$filter_string}", $f3->get("issue_type.project")), array('order' => 'priority DESC, due_date'));
}
// Filter projects into sorted and unsorted arrays if filtering by group
if (!empty($params["groupid"])) {
// Add sorted projects
$backlog = array();
$sortModel = new \Model\Issue\Backlog();
$sortModel->load(array("user_id = ?", $params["groupid"]));
$sortArray = array();
if ($sortModel->id) {
$sortArray = json_decode($sortModel->issues);
foreach ($sortArray as $id) {
foreach ($unset_projects as $p) {
if ($p->id == $id) {
$backlog[] = $p;
}
}
}
}
// Add remaining projects
$unsorted = array();
foreach ($unset_projects as $p) {
if (!in_array($p->id, $sortArray)) {
$unsorted[] = $p;
}
}
} else {
$backlog = $unset_projects;
}
$groups = new \Model\User();
$f3->set("groups", $groups->getAllGroups());
$f3->set("groupid", $params["groupid"]);
$f3->set("sprints", $sprint_details);
$f3->set("backlog", $backlog);
$f3->set("unsorted", $unsorted);
$f3->set("title", $f3->get("dict.backlog"));
$f3->set("menuitem", "backlog");
$this->_render("backlog/index.html");
}
/**
* View a taskboard
*
* @param \Base $f3
* @param array $params
*/
public function index($f3, $params)
{
$sprint = new \Model\Sprint();
// Load current sprint if no sprint ID is given
if (!intval($params["id"])) {
$localDate = date('Y-m-d', \Helper\View::instance()->utc2local());
$sprint->load(array("? BETWEEN start_date AND end_date", $localDate));
if (!$sprint->id) {
$f3->error(404);
return;
}
}
// Default to showing group tasks
if (empty($params["filter"])) {
$params["filter"] = "groups";
}
// Load the requested sprint
if (!$sprint->id) {
$sprint->load($params["id"]);
if (!$sprint->id) {
$f3->error(404);
return;
}
}
$f3->set("sprint", $sprint);
$f3->set("title", $sprint->name . " " . date('n/j', strtotime($sprint->start_date)) . "-" . date('n/j', strtotime($sprint->end_date)));
$f3->set("menuitem", "backlog");
// Get list of all users in the user's groups
$filter_users = $this->_filterUsers($params);
// Load issue statuses
$status = new \Model\Issue\Status();
$statuses = $status->find(array('taskboard > 0'), array('order' => 'taskboard_sort ASC'));
$mapped_statuses = array();
$visible_status_ids = array();
$column_count = 0;
foreach ($statuses as $s) {
$visible_status_ids[] = $s->id;
$mapped_statuses[$s->id] = $s;
$column_count += $s->taskboard;
}
$visible_status_ids = implode(",", $visible_status_ids);
$f3->set("statuses", $mapped_statuses);
$f3->set("column_count", $column_count);
// Load issue priorities
$priority = new \Model\Issue\Priority();
$f3->set("priorities", $priority->find(null, array("order" => "value DESC"), $f3->get("cache_expire.db")));
// Load project list
$issue = new \Model\Issue\Detail();
// Find all visible tasks
$tasks = $issue->find(array("sprint_id = ? AND type_id != ? AND deleted_date IS NULL AND status IN ({$visible_status_ids})" . (empty($filter_users) ? "" : " AND owner_id IN (" . implode(",", $filter_users) . ")"), $sprint->id, $f3->get("issue_type.project")), array("order" => "priority DESC"));
$task_ids = array();
$parent_ids = array(0);
foreach ($tasks as $task) {
$task_ids[] = $task->id;
if ($task->parent_id) {
$parent_ids[] = $task->parent_id;
}
}
$task_ids_str = implode(",", $task_ids);
$parent_ids_str = implode(",", $parent_ids);
$f3->set("tasks", $task_ids_str);
// Find all visible projects or parent tasks
$projects = $issue->find(array("id IN ({$parent_ids_str}) OR (sprint_id = ? AND type_id = ? AND deleted_date IS NULL" . (empty($filter_users) ? ")" : " AND owner_id IN (" . implode(",", $filter_users) . "))"), $sprint->id, $f3->get("issue_type.project")), array("order" => "owner_id ASC, priority DESC"));
// Sort projects if a filter is given
if (!empty($params["filter"]) && is_numeric($params["filter"])) {
$sortModel = new \Model\Issue\Backlog();
$sortModel->load(array("user_id = ? AND sprint_id = ?", $params["filter"], $sprint->id));
$sortArray = array();
if ($sortModel->id) {
$sortArray = json_decode($sortModel->issues);
usort($projects, function (\Model\Issue $a, \Model\Issue $b) use($sortArray) {
$ka = array_search($a->id, $sortArray);
$kb = array_search($b->id, $sortArray);
if ($ka === false && $kb !== false) {
return -1;
}
if ($ka !== false && $kb === false) {
return 1;
}
if ($ka === $kb) {
return 0;
}
if ($ka > $kb) {
return 1;
}
if ($ka < $kb) {
return -1;
}
});
}
}
// Build multidimensional array of all tasks and projects
$taskboard = array();
foreach ($projects as $project) {
// Build array of statuses to put tasks under
$columns = array();
foreach ($statuses as $status) {
$columns[$status["id"]] = array();
}
// Add current project's tasks
foreach ($tasks as $task) {
if ($task->parent_id == $project->id || $project->id == 0 && (!$task->parent_id || !in_array($task->parent_id, $parent_ids))) {
$columns[$task->status][] = $task;
}
}
// Add hierarchical structure to taskboard array
$taskboard[] = array("project" => $project, "columns" => $columns);
}
$f3->set("taskboard", array_values($taskboard));
$f3->set("filter", $params["filter"]);
// Get user list for select
$users = new \Model\User();
$f3->set("users", $users->getAll());
$f3->set("groups", $users->getAllGroups());
$this->_render("taskboard/index.html");
}
/**
* View a taskboard
*/
public function index($f3, $params)
{
// Require a valid numeric sprint ID
if (!intval($params["id"])) {
$f3->error(404);
return;
}
// Default to showing group tasks
if (empty($params["filter"])) {
$params["filter"] = "groups";
}
// Load the requested sprint
$sprint = new \Model\Sprint();
$sprint->load($params["id"]);
if (!$sprint->id) {
$f3->error(404);
return;
}
$f3->set("sprint", $sprint);
$f3->set("title", $sprint->name . " " . date('n/j', strtotime($sprint->start_date)) . "-" . date('n/j', strtotime($sprint->end_date)));
$f3->set("menuitem", "backlog");
// Get list of all users in the user's groups
$filter_users = $this->_filterUsers($params);
// Load issue statuses
$status = new \Model\Issue\Status();
$statuses = $status->find(array('taskboard > 0'), null, $f3->get("cache_expire.db"));
$mapped_statuses = array();
$visible_status_ids = array();
$column_count = 0;
foreach ($statuses as $s) {
$visible_status_ids[] = $s->id;
$mapped_statuses[$s->id] = $s;
$column_count += $s->taskboard;
}
$visible_status_ids = implode(",", $visible_status_ids);
$f3->set("statuses", $mapped_statuses);
$f3->set("column_count", $column_count);
// Load issue priorities
$priority = new \Model\Issue\Priority();
$f3->set("priorities", $priority->find(null, array("order" => "value DESC"), $f3->get("cache_expire.db")));
// Load project list
$issue = new \Model\Issue\Detail();
// Find all visible tasks
$tasks = $issue->find(array("sprint_id = ? AND type_id != ? AND deleted_date IS NULL AND status IN ({$visible_status_ids})" . (empty($filter_users) ? "" : " AND owner_id IN (" . implode(",", $filter_users) . ")"), $sprint->id, $f3->get("issue_type.project")), array("order" => "priority DESC"));
$task_ids = array();
$parent_ids = array(0);
foreach ($tasks as $task) {
$task_ids[] = $task->id;
if ($task->parent_id) {
$parent_ids[] = $task->parent_id;
}
}
$task_ids_str = implode(",", $task_ids);
$parent_ids_str = implode(",", $parent_ids);
$f3->set("tasks", $task_ids_str);
// Find all visible projects or parent tasks
$projects = $issue->find(array("id IN ({$parent_ids_str}) OR (sprint_id = ? AND type_id = ? AND deleted_date IS NULL" . (empty($filter_users) ? ")" : " AND owner_id IN (" . implode(",", $filter_users) . "))"), $sprint->id, $f3->get("issue_type.project")), array("order" => "owner_id ASC"));
// Build multidimensional array of all tasks and projects
$taskboard = array();
foreach ($projects as $project) {
// Build array of statuses to put tasks under
$columns = array();
foreach ($statuses as $status) {
$columns[$status["id"]] = array();
}
// Add current project's tasks
foreach ($tasks as $task) {
if ($task->parent_id == $project->id || $project->id == 0 && (!$task->parent_id || !in_array($task->parent_id, $parent_ids))) {
$columns[$task->status][] = $task;
}
}
// Add hierarchical structure to taskboard array
$taskboard[] = array("project" => $project, "columns" => $columns);
}
$f3->set("taskboard", array_values($taskboard));
$f3->set("filter", $params["filter"]);
// Get user list for select
$users = new \Model\User();
$f3->set("users", $users->getAll());
$f3->set("groups", $users->getAllGroups());
$this->_render("taskboard/index.html");
}
/**
* GET /issues
* Display a sortable, filterable issue list
*
* @param \Base $f3
*/
public function index($f3)
{
$issues = new \Model\Issue\Detail();
// Get filter
$args = $f3->get("GET");
list($filter, $filter_str) = $this->_buildFilter();
// Load type if a type_id was passed
$type = new \Model\Issue\Type();
if (!empty($args["type_id"])) {
$type->load($args["type_id"]);
if ($type->id) {
$f3->set("title", $f3->get("dict.issues") . " - " . $f3->get("dict.by_type") . ": " . $type->name);
$f3->set("type", $type);
}
} else {
$f3->set("title", $f3->get("dict.issues"));
}
$status = new \Model\Issue\Status();
$f3->set("statuses", $status->find(null, null, $f3->get("cache_expire.db")));
$priority = new \Model\Issue\Priority();
$f3->set("priorities", $priority->find(null, array("order" => "value DESC"), $f3->get("cache_expire.db")));
$f3->set("types", $type->find(null, null, $f3->get("cache_expire.db")));
$sprint = new \Model\Sprint();
$f3->set("sprints", $sprint->find(array("end_date >= ?", date("Y-m-d")), array("order" => "start_date ASC")));
$f3->set("old_sprints", $sprint->find(array("end_date < ?", date("Y-m-d")), array("order" => "start_date ASC")));
$users = new \Model\User();
$f3->set("users", $users->getAll());
$f3->set("deleted_users", $users->getAllDeleted());
$f3->set("groups", $users->getAllGroups());
if (empty($args["page"])) {
$args["page"] = 0;
}
$issue_page = $issues->paginate($args["page"], 50, $filter_str);
$f3->set("issues", $issue_page);
// Pass filter string for pagination
$filter_get = http_build_query($filter);
if (!empty($orderby)) {
$filter_get .= "&orderby=" . $orderby;
}
if ($issue_page["count"] > 7) {
if ($issue_page["pos"] <= 3) {
$min = 0;
} else {
$min = $issue_page["pos"] - 3;
}
if ($issue_page["pos"] < $issue_page["count"] - 3) {
$max = $issue_page["pos"] + 3;
} else {
$max = $issue_page["count"] - 1;
}
} else {
$min = 0;
$max = $issue_page["count"] - 1;
}
$f3->set("pages", range($min, $max));
$f3->set("filter_get", $filter_get);
$f3->set("menuitem", "browse");
$f3->set("heading_links_enabled", true);
$f3->set("show_filters", true);
$f3->set("show_export", true);
$this->_render("issues/index.html");
}
