/** * @param string $json_column_array * @param string $json_argument_array * @param string $css_page_id * @param string $css_row_sort_id * @param string $entries_per_page * @param string $page * @param string $sortvalue * @param string $sortmethod * @return string * @throws ProjectIDMissingException */ public static function list_project_tasks($json_column_array, $json_argument_array, $css_page_id, $css_row_sort_id, $entries_per_page, $page, $sortvalue, $sortmethod) { $argument_array = json_decode($json_argument_array); $project_id = $argument_array[1]; if (is_numeric($project_id)) { $list_request = new ListRequest_IO(); $list_request->set_column_array($json_column_array); if (!is_numeric($entries_per_page) or $entries_per_page < 1) { $entries_per_page = 20; } $list_array = Project_Wrapper::list_project_tasks($project_id, $sortvalue, $sortmethod, $page * $entries_per_page - $entries_per_page, $page * $entries_per_page); if (is_array($list_array) and count($list_array) >= 1) { foreach ($list_array as $key => $value) { $start_date = new DatetimeHandler($list_array[$key]['start_date']); $end_date = new DatetimeHandler($list_array[$key]['end_date'] . " " . $list_array[$key]['end_time']); $list_array[$key]['start_date'] = $start_date->get_date(); $list_array[$key]['end_date'] = $end_date->get_date(); $list_array[$key]['end_time'] = $end_date->get_time(); if ($list_array[$key]['whole_day'] == "t") { $list_array[$key]['end_time'] = "whole day"; } if ($list_array[$key]['is_status_process'] or $list_array[$key]['is_process']) { $project_task = new ProjectTask($list_array[$key]['id']); } if ($list_array[$key]['is_status_process']) { $list_array[$key]['type'] = "Status Rel. Task"; $list_array[$key]['name'] = $project_task->get_name(); } if ($list_array[$key]['is_process']) { $list_array[$key]['type'] = "Task"; } if ($list_array[$key]['is_milestone']) { $list_array[$key]['type'] = "Milestone"; } else { $list_array[$key]['progress'] = "<img src='core/images/status_bar.php?length=100&height=15&linecolor=A0A0A0&color=" . $project_task->get_color() . "&value=" . $project_task->get_progress() . "' />"; } $paramquery = array(); $paramquery['session_id'] = $_GET['session_id']; $paramquery['username'] = $_GET['username']; $paramquery['nav'] = "project"; $paramquery['run'] = "task_detail"; $paramquery['id'] = $list_array[$key]['id']; $params = http_build_query($paramquery, '', '&'); $tmp_name = $list_array[$key]['name']; unset($list_array[$key]['name']); $list_array[$key]['name']['content'] = $tmp_name; $list_array[$key]['name']['link'] = $params; } } else { $list_request->empty_message("<span class='italic'>No Project tasks found!</span>"); } $list_request->set_array($list_array); return $list_request->get_page($page); } else { throw new ProjectIDMissingException(); } }
/** * @see ProjectTaskInterface::list_upcoming_tasks() * @return array * @todo tasks ending today * @todo tasks ending this week * @todo tasks ending next 30 days */ public static function list_upcoming_tasks() { global $user; $upcoming_task_array = array(); $over_time_task_array = Project_Wrapper_Access::list_not_finished_over_time_project_tasks_by_user_id($user->get_user_id(), date("Y-m-d H:i:s")); if (is_array($over_time_task_array) and count($over_time_task_array) >= 1) { foreach ($over_time_task_array as $key => $value) { $project_task = new ProjectTask($value); $project = new Project($project_task->get_project_id()); if ($project_task->get_uf_end_time() == -1) { $end_task_datetime = new DatetimeHandler($project_task->get_end_date() . " 23:59:59"); } else { $end_task_datetime = new DatetimeHandler($project_task->get_end_date() . " " . $project_task->get_uf_end_time()); } if ($project_task->get_over_time() == true) { $temp_array = array(); $temp_array['project_id'] = $project_task->get_project_id(); $temp_array['project_name'] = $project->get_name(); $temp_array['task_name'] = $project_task->get_name(); $temp_array['end_date'] = $end_task_datetime->get_formatted_string("d/m/Y"); $temp_array['status'] = 1; array_push($upcoming_task_array, $temp_array); unset($temp_array); } else { if ($project_task->get_progress() < 100) { $temp_array = array(); $temp_array['project_id'] = $project_task->get_project_id(); $temp_array['project_name'] = $project->get_name(); $temp_array['task_name'] = $project_task->get_name(); $temp_array['end_date'] = $end_task_datetime->get_formatted_string("d/m/Y"); $temp_array['status'] = 1; array_push($upcoming_task_array, $temp_array); unset($temp_array); $project_task->set_over_time(true); } else { $project_task->set_finished(true); } } } } return $upcoming_task_array; }
/** * @throws ProjectIDMissingException * @throws ProjectSecuriyAccessDeniedException */ public static function gantt_view() { global $project_security; if ($_GET['project_id']) { if ($project_security->is_access(1, false) == true) { $project_task_array = ProjectTask::list_tasks($_GET['project_id']); $left_limit = 0; $right_limit = 0; if (is_array($project_task_array) and count($project_task_array) >= 1) { foreach ($project_task_array as $key => $value) { $project_task = new ProjectTask($value); if ($project_task->get_start_date()) { $begin_timestamp = $project_task->get_start_date() . " 00:00:00"; if ($project_task->get_uf_end_time() != "-1") { $end_timestamp = $project_task->get_end_date() . " " . $project_task->get_end_time(); } else { $end_timestamp = $project_task->get_end_date() . " 00:00:00"; } $begin_datetime_handler = new DatetimeHandler($begin_timestamp); $end_datetime_handler = new DatetimeHandler($end_timestamp); $begin_mktime = $begin_datetime_handler->get_mktime(); $end_mktime = $end_datetime_handler->get_mktime(); if ($left_limit == 0 or $left_limit > $begin_mktime) { $left_limit = $begin_mktime; } if ($right_limit == 0 or $right_limit < $end_mktime) { $right_limit = $end_mktime; } } } $left_limit_handler = new DatetimeHandler($left_limit); $right_limit_handler = new DatetimeHandler($right_limit); $day_distance = $left_limit_handler->day_distance($right_limit_handler); $date_range = $right_limit - $left_limit; if ($day_distance < 30) { if ($day_distance < 15) { if ($day_distance < 7) { $date_range_addition = ceil($date_range / ($day_distance * 4)); $date_mktime = $left_limit; $number_of_rows = $day_distance * 4 + 4; } else { $date_range_addition = ceil($date_range / ($day_distance * 2)); $date_mktime = $left_limit; $number_of_rows = $day_distance * 2 + 2; } } else { $date_range_addition = ceil($date_range / $day_distance); $date_mktime = $left_limit; $number_of_rows = $day_distance + 1; } } else { $date_range_addition = ceil($date_range / 29); $date_mktime = $left_limit; $number_of_rows = 30; } $width_of_row = 705 / $number_of_rows; $gantt_array = array(); for ($i = 0; $i <= $number_of_rows - 1; $i++) { $day = date("d", $date_mktime); $month = date("M", $date_mktime); $gantt_array[$i]['title'] = $day . "<br />" . $month; $gantt_array[$i]['mktime'] = $date_mktime; $date_mktime = $date_mktime + $date_range_addition; } $template = new HTMLTemplate("project/tasks/gantt_view.html"); $table_view_paramquery = $_GET; $table_view_paramquery['show'] = "table"; $table_view_params = http_build_query($table_view_paramquery, '', '&'); $template->set_var("table_view_params", $table_view_params); $gantt_view_paramquery = $_GET; $gantt_view_paramquery['show'] = "gantt"; $gantt_view_params = http_build_query($gantt_view_paramquery, '', '&'); $template->set_var("gantt_view_params", $gantt_view_params); $cal_view_paramquery = $_GET; $cal_view_paramquery['show'] = "cal"; $cal_view_params = http_build_query($cal_view_paramquery, '', '&'); $template->set_var("cal_view_params", $cal_view_params); $table = "<table class='ProjectTaskGanttTable'>"; $table .= "<tr>"; foreach ($gantt_array as $key => $value) { $table .= "<th width='" . $width_of_row . "px'>" . $value['title'] . "</th>"; } $table .= "</tr>"; foreach ($project_task_array as $key => $value) { $project_task = new ProjectTask($value); $begin_timestamp = $project_task->get_start_date() . " 00:00:00"; if ($project_task->get_uf_end_time() != "-1") { $end_timestamp = $project_task->get_end_date() . " " . $project_task->get_end_time(); } else { $end_timestamp = $project_task->get_end_date() . " 23:59:59"; } $begin_datetime_handler = new DatetimeHandler($begin_timestamp); $end_datetime_handler = new DatetimeHandler($end_timestamp); $begin_mktime = $begin_datetime_handler->get_mktime(); $end_mktime = $end_datetime_handler->get_mktime(); $table .= "<tr>"; $paramquery = $_GET; $paramquery['run'] = "task_detail"; $paramquery['id'] = $value; $params = http_build_query($paramquery, '', '&'); $table .= "<td colspan='30'><span class='smallText'><a href='index.php?" . $params . "'>" . $project_task->get_name() . " (" . $begin_datetime_handler->get_formatted_string("j/n/Y") . " - " . $end_datetime_handler->get_formatted_string("j/n/Y") . ")</a></span></td>"; $table .= "</tr><tr class='ProjectTaskGanttBlockEnd'>"; $begin_key = -1; $end_key = -1; foreach ($gantt_array as $fe_key => $fe_value) { if ($fe_value['mktime'] >= $begin_mktime) { if ($begin_key == -1) { $begin_key = $fe_key; } } if ($begin_key != -1 and $fe_value['mktime'] <= $end_mktime) { $end_key = $fe_key; } } $key_range = $end_key - $begin_key + 1; $in_task = false; for ($i = 0; $i <= $number_of_rows - 1; $i++) { if ($i == $begin_key) { $in_task = true; $width = $key_range * ($width_of_row + 1); if ($project_task->get_type() == 3) { $table .= "<td colspan='" . $key_range . "' style='text-align: center;'><img src='images/icons/milestone.png' alt='' /></td>"; } else { $table .= "<td colspan='" . $key_range . "'><img src='core/images/status_bar.php?length=" . $width . "&height=15&linecolor=A0A0A0&bgcolor=EAEAEA&color=" . $project_task->get_color() . "&value=" . $project_task->get_progress() . "' /></td>"; } } if ($in_task == false) { $table .= "<td></td>"; } if ($i == $end_key) { $in_task = false; } } $table .= "</tr>"; } $table .= "</table>"; $template->set_var("table", $table); $template->output(); } else { $template = new HTMLTemplate("project/tasks/gantt_view.html"); $table_view_paramquery = $_GET; $table_view_paramquery['show'] = "table"; $table_view_params = http_build_query($table_view_paramquery, '', '&'); $template->set_var("table_view_params", $table_view_params); $gantt_view_paramquery = $_GET; $gantt_view_paramquery['show'] = "gantt"; $gantt_view_params = http_build_query($gantt_view_paramquery, '', '&'); $template->set_var("gantt_view_params", $gantt_view_params); $cal_view_paramquery = $_GET; $cal_view_paramquery['show'] = "cal"; $cal_view_params = http_build_query($cal_view_paramquery, '', '&'); $template->set_var("cal_view_params", $cal_view_params); $template->set_var("table", "<span class='italic'>No Entries Found</span>"); $template->output(); } } else { throw new ProjectSecuriyAccessDeniedException(); } } else { throw new ProjectIDMissingException(); } }