function fill_new_sla_table() { echo "Filling the table 'tincident_sla_graph_data'...\n"; $last_values = array(); $sql = "SELECT id_incident, utimestamp, value\n\t\t\tFROM tincident_sla_graph\n\t\t\tORDER BY utimestamp ASC"; $new = true; while ($data = get_db_all_row_by_steps_sql($new, $result_sla, $sql)) { $new = false; $id_incident = $data["id_incident"]; $value = $data["value"]; $utimestamp = $data["utimestamp"]; if (!isset($last_values[$id_incident]) || isset($last_values[$id_incident]) && $last_values[$id_incident] != $value) { $last_values[$id_incident] = $value; $values = array("id_incident" => $id_incident, "utimestamp" => $utimestamp, "value" => $value); process_sql_insert("tincident_sla_graph_data", $values); } } echo "Filling the table 'tincident_sla_graph_data'... DONE\n"; }
function combo_task_user_manager($id_user, $actual = 0, $return = false, $label = false, $name = false, $nothing = true, $multiple = false, $id_project = false, $id_task_out = false) { $output = ''; $values = array(); if ($id_project) { $where = "AND id={$id_project}"; } else { $where = ""; } if ($id_task_out) { $task_out = "AND id<>{$id_task_out}"; } else { $task_out = ""; } $sql = "select tp.* from tproject tp, ttask tt, trole_people_project tpp \n\t\t\twhere tp.id=tt.id_project and tpp.id_project=tp.id and disabled = 0 \n\t\t\tand tpp.id_user="******"'" . $id_user . "'" . " ORDER BY name;"; $new = true; while ($project = get_db_all_row_by_steps_sql($new, $result_project, $sql)) { $sql = "SELECT *\n\t\t\t\tFROM ttask\n\t\t\t\tWHERE id_project=" . $project['id'] . "\n\t\t\t\t\tAND id_project IN(SELECT id\n\t\t\t\t\t\t\t\t\t FROM tproject\n\t\t\t\t\t\t\t\t\t WHERE disabled=0)\n\t\t\t\t\t{$task_out}\n\t\t\t\tORDER BY name"; $new = true; $project_access = get_project_access($id_user, $project['id']); // ACL - To continue, the user should have read access if ($project_access['read']) { while ($task = get_db_all_row_by_steps_sql($new, $result_task, $sql)) { $new = false; $task_access = get_project_access($id_user, $project['id'], $task['id'], false, true); // ACL - To show the task, the user should have manage access if ($task_access['manage']) { $values[$task['id']] = array('optgroup' => $project['name'], 'name' => ' ' . $task['name']); } } } else { $new = false; } } if (!$name) { $name = 'id_task'; } if ($nothing && $nothing !== true) { $nothing = $nothing; } elseif ($nothing) { $nothing = __('N/A'); } else { $nothing = ''; } $output .= print_select($values, $name, $actual, '', $nothing, '0', true, $multiple, false, $label); if ($return) { return $output; } echo $output; }
$table->head[3] = __('Updated'); $table->head[4] = ''; $table->data = array (); $where_clause = ""; if ($search_text != "") { $where_clause .= sprintf (" AND (tproject.name LIKE '%%%s%%' OR tproject.description LIKE '%%%s%%')", $search_text, $search_text); } if ($search_id_project_group != 0) { $where_clause .= sprintf (" AND tproject.id_project_group=$search_id_project_group "); } $sql = get_projects_query ($config['id_user'], $where_clause, $view_disabled); $new = true; while ($project = get_db_all_row_by_steps_sql ($new, $result, $sql)) { $new = false; $project_permission = get_project_access ($config['id_user'], $project['id']); if (!$project_permission['read']) { continue; } $data = array (); // Project name $data[0] = '<a href="index.php?sec=projects&sec2=operation/projects/project_detail&id_project='.$project['id'].'">'.$project['name'].'</a>'; $data[1] = $project["id_owner"]; if ($project["start"] == $project["end"]) { $data[2] = __('Unlimited');
function show_task_tree(&$table, $id_project, $level, $id_parent_task, $users) { global $config; $sql = sprintf('SELECT * FROM ttask WHERE id_project = %d AND id_parent_task = %d ORDER BY name', $id_project, $id_parent_task); $new = true; while ($task = get_db_all_row_by_steps_sql($new, $result, $sql)) { $new = false; //If user belong to task then create a new row in the table $task_access = get_project_access($config['id_user'], $id_project, $task['id'], false, true); if ($task_access['manage']) { //Each tr has the task id as the html id object! //Check completion for tr background color if ($task['completion'] < 40) { $color = "#FFFFFF"; } else { if ($task['completion'] < 90) { $color = "#FFE599"; } else { if ($task['completion'] < 100) { $color = "#A4BCFA"; } else { if ($task['completion'] == 100) { $color = "#B6D7A8"; } } } } echo "<tr id=" . $task['id'] . " bgcolor='{$color}'>"; show_task_row($table, $id_project, $task, $level, $users); echo "</tr>"; } show_task_tree($table, $id_project, $level + 1, $task['id'], $users); } }
public function getWorkUnitsList($href = "", $delete_button = true, $delete_href = "", $ajax = false) { $system = System::getInstance(); $ui = Ui::getInstance(); if ($href == "") { $href = "index.php?page=workunit"; } if (!$ajax) { $html = "<ul id='listview' class='ui-itemlistview' data-role='listview' data-count-theme='e'>"; } if ($this->getCountWorkUnits() > 0) { $sql = $this->getWorkUnitsQuery(); $new = true; while ($workunit = get_db_all_row_by_steps_sql($new, $result_query, $sql)) { $new = false; $html .= "<li>"; $html .= "<a href='{$href}&id_workunit=" . $workunit['id'] . "' class='ui-link-inherit' data-ajax='false'>"; $date = strtotime($workunit['timestamp']); $html .= "<h3 class='ui-li-heading'>" . date("Y-m-d", $date) . "</h3>"; $html .= "<p class='ui-li-desc'><strong>" . $workunit['id_user'] . "</strong></p>"; $html .= "<p class='ui-li-desc'>" . $workunit['description'] . "</p>"; $html .= "<span class=\"ui-li-count\">" . $workunit['duration'] . " " . __('hours') . "</span>"; $html .= "</a>"; if ($delete_button) { if ($delete_href == "") { $delete_href = 'index.php?page=workunits&operation=delete_workunit'; } $options = array('popup_id' => 'delete_popup_' . $workunit['id'], 'delete_href' => $delete_href . '&id_workunit=' . $workunit['id']); $html .= $ui->getDeletePopupHTML($options); $html .= "<a data-icon=\"delete\" data-rel=\"popup\" href=\"#delete_popup_" . $workunit['id'] . "\"></a>"; } $html .= "</li>"; } } else { $html .= "<li>"; $html .= "<h3 class='error'>" . __('There is no workunits') . "</h3>"; $html .= "</li>"; } if (!$ajax) { $html .= "</ul>"; } return $html; }
/** * This function deletes incidents data with more than X days and closed. * Also deletes the data related to the deleted incidents. */ function delete_old_incidents() { global $config; //$config['months_to_delete_incidents'] DELETE FROM OTHER PLACES $DELETE_DAYS = (int) $config["max_days_incidents"]; if ($DELETE_DAYS > 0) { $limit = date("Y/m/d H:i:s", strtotime("now") - $DELETE_DAYS * 86400); $sql_select = "SELECT id_incidencia\n\t\t\t\t\t FROM tincidencia\n\t\t\t\t\t WHERE cierre < '{$limit}'\n\t\t\t\t\t\t AND cierre > '0000-00-00 00:00:00'\n\t\t\t\t\t\t AND estado = 7"; $new = true; while ($incident = get_db_all_row_by_steps_sql($new, $result, $sql_select)) { $new = false; $error = false; // tincident_contact_reporters $sql_delete = "DELETE FROM tincident_contact_reporters\n\t\t\t\t\t\t WHERE id_incident = " . $incident["id_incidencia"]; $res = process_sql($sql_delete); if ($res === false) { $error = true; } // tincident_field_data $res = $sql_delete = "DELETE FROM tincident_field_data\n\t\t\t\t\t\t WHERE id_incident = " . $incident["id_incidencia"]; $res = process_sql($sql_delete); if ($res === false) { $error = true; } // tincident_inventory $sql_delete = "DELETE FROM tincident_inventory\n\t\t\t\t\t\t WHERE id_incident = " . $incident["id_incidencia"]; $res = process_sql($sql_delete); if ($res === false) { $error = true; } // tincident_sla_graph_data $sql_delete = "DELETE FROM tincident_sla_graph_data\n\t\t\t\t\t\t WHERE id_incident = " . $incident["id_incidencia"]; $res = process_sql($sql_delete); if ($res === false) { $error = true; } // tincident_stats $sql_delete = "DELETE FROM tincident_stats\n\t\t\t\t\t\t WHERE id_incident = " . $incident["id_incidencia"]; $res = process_sql($sql_delete); if ($res === false) { $error = true; } // tincident_track $sql_delete = "DELETE FROM tincident_track\n\t\t\t\t\t\t WHERE id_incident = " . $incident["id_incidencia"]; $res = process_sql($sql_delete); if ($res === false) { $error = true; } // tworkunit $sql_delete = "DELETE FROM tworkunit\n\t\t\t\t\t\t WHERE id = ANY(SELECT id_workunit\n\t\t\t\t\t\t\t\t\t\t FROM tworkunit_incident\n\t\t\t\t\t\t\t\t\t\t WHERE id_incident = " . $incident["id_incidencia"] . ")"; $res = process_sql($sql_delete); if ($res === false) { $error = true; } // tattachment $sql_delete = "DELETE FROM tattachment\n\t\t\t\t\t\t WHERE id_incidencia = " . $incident["id_incidencia"]; $res = process_sql($sql_delete); if ($res === false) { $error = true; } if (!$error) { // tincidencia $sql_delete = "DELETE FROM tincidencia\n\t\t\t\t\t\t\t WHERE id_incidencia = " . $incident["id_incidencia"]; process_sql($sql_delete); } } } }
public function getIncidentsList ($href = "", $ajax = false) { $system = System::getInstance(); $ui = Ui::getInstance(); if ($href == "") { $href = "index.php?page=incident"; } $html = ""; if (! $ajax) { $html .= "<ul id='listview' class='ui-itemlistview' data-role='listview'>"; } if ($this->getCountIncidents() > 0) { $sql = $this->getIncidentsQuery(); $new = true; while ( $incident = get_db_all_row_by_steps_sql($new, $result_query, $sql) ) { $new = false; // Background color if ($incident["estado"] < 3) { $background_color = "light-red-background"; } elseif ($incident["estado"] < 7) { $background_color = "light-yellow-background"; } elseif ($incident["estado"] == 7) { $background_color = "light-green-background"; } else { $background_color = ""; } $html .= "<li class=\"$background_color\">"; $html .= "<a href='$href&id_incident=".$incident['id_incidencia']."' class='ui-link-inherit' data-ajax='false'>"; //$html .= $ui->getPriorityFlagImage($incident['prioridad']); $html .= print_priority_flag_image ($incident['prioridad'], true, "../", "priority-list ui-li-icon"); $html .= "<h3 class='ui-li-heading'>#".$incident['id_incidencia']; $html .= " - ".$incident['titulo']."</h3>"; $html .= "<p class='ui-li-desc'>".__('Owner').": ".$incident['id_usuario']; if ( include_once ($system->getConfig('homedir')."/include/functions_calendar.php") ) { $html .= " - ".human_time_comparation($incident["actualizacion"])." ".__('since the last update')."</p>"; } else { $html .= " - ".__('Last update').": ".$incident['actualizacion']."</p>"; } $html .= "</a>"; //~ $options = array( //~ 'popup_id' => 'delete_popup_'.$incident['id_incidencia'], //~ 'delete_href' => 'index.php?page=incidents&operation=delete&id_incident='.$incident['id_incidencia'] //~ ); //~ $html .= $ui->getDeletePopupHTML($options); //~ $html .= "<a data-icon=\"delete\" data-rel=\"popup\" href=\"#delete_popup_".$incident['id_incidencia']."\"></a>"; $html .= "</li>"; } } else { $html .= "<li>"; $html .= "<h3 class='error'>".__('There is no tickets')."</h3>"; $html .= "</li>"; } if (! $ajax) { $html .= "</ul>"; } else { ob_clean(); } return $html; }
function incidents_get_incident_sla_graph_seconds($id_incident) { $seconds = array(); $seconds["OK"] = 0; $seconds["FAIL"] = 0; $last_value = -1; $last_timestamp = array(); $last_timestamp["OK"] = 0; $last_timestamp["FAIL"] = 0; $sql = sprintf("SELECT utimestamp, value\n\t\t\t\t\tFROM tincident_sla_graph_data\n\t\t\t\t\tWHERE id_incident = %s\n\t\t\t\t\tORDER BY utimestamp ASC", $id_incident); $data = get_db_all_row_by_steps_sql(true, $result_sla, $sql); if ($data) { if ($data["value"] == 1) { $last_timestamp["OK"] = $data["utimestamp"]; } else { $last_timestamp["FAIL"] = $data["utimestamp"]; } $last_value = $data["value"]; } while ($data = get_db_all_row_by_steps_sql(false, $result_sla, $sql)) { if ($data["value"] != $last_value) { if ($data["value"] == 1) { $seconds["FAIL"] += $data["utimestamp"] - $last_timestamp["FAIL"]; $last_timestamp["OK"] = $data["utimestamp"]; } else { $seconds["OK"] += $data["utimestamp"] - $last_timestamp["OK"]; $last_timestamp["FAIL"] = $data["utimestamp"]; } $last_value = $data["value"]; } } if ($last_value == 1) { $seconds["OK"] += time() - $last_timestamp["OK"]; } elseif ($last_value == 0) { $seconds["FAIL"] += time() - $last_timestamp["FAIL"]; } return $seconds; }
public function getWorkOrdersList($href = "", $delete_button = true, $delete_href = "", $ajax = false) { $system = System::getInstance(); $ui = Ui::getInstance(); if ($href == "") { $href = "index.php?page=workorder&operation=view"; } if (!$ajax) { $html = "<ul id='listview' class='ui-itemlistview' data-role='listview'>"; } if ($this->getCountWorkorders() > 0) { $sql = $this->getWorkOrdersQuery(); $new = true; while ($workorder = get_db_all_row_by_steps_sql($new, $result_query, $sql)) { $new = false; $html .= "<li>"; $html .= "<a href='{$href}&id_workorder=" . $workorder['id'] . "' class='ui-link-inherit' data-ajax='false'>"; //$html .= $ui->getPriorityFlagImage($workorder['priority']); $html .= print_priority_flag_image($workorder['priority'], true, "../", "priority-list ui-li-icon"); $html .= "<h3 class='ui-li-heading'>" . $workorder['name'] . "</h3>"; $html .= "<p class='ui-li-desc'>" . __('Owner') . ": " . $workorder['assigned_user']; $html .= " - " . __('Creator') . ": " . $workorder['created_by_user'] . "</p>"; $html .= "</a>"; if ($delete_button) { if ($delete_href == "") { $delete_href = "index.php?page=workorders&operation=delete&filter_status=0&filter_owner=" . $system->getConfig('id_user'); } $options = array('popup_id' => 'delete_popup_' . $workorder['id'], 'delete_href' => "{$delete_href}&id_workorder=" . $workorder['id']); $html .= $ui->getDeletePopupHTML($options); $html .= "<a data-icon=\"delete\" data-rel=\"popup\" href=\"#delete_popup_" . $workorder['id'] . "\"></a>"; } $html .= "</li>"; } } else { $html .= "<li>"; $html .= "<h3 class='error'>" . __('There is no workorders') . "</h3>"; $html .= "</li>"; } if (!$ajax) { $html .= "</ul>"; } return $html; }
echo "<span style='vertical-align:middle; display: inline-block;'>".$wo_icon."</span>"; echo "<span style='margin-left: 4px; vertical-align:middle; display: inline-block;'>".$priority."</span>"; echo "<span style='margin-left: 5px; min-width: 400px; vertical-align:middle; display: inline-block;'>".$name."</span>"; echo "<span style='margin-left: 5px; min-width: 140px; vertical-align:middle; display: inline-block;'><small>" .__('Owner').":</small> <b>".$owner."</b></span>"; echo "<span style='margin-left: 5px; min-width: 140px; vertical-align:middle; display: inline-block;'><small>" .__('Time used ').":</small> <b>".$wo['duration']."</b></span>"; echo "</span>"; echo "</li>"; } // INCIDENTS $new = true; $count = 0; while ($incident = get_db_all_row_by_steps_sql($new, $result, $sql_incidents)) { $new = false; $count++; echo "<li style='margin: 0; padding: 0;'>"; echo "<span style='display: inline-block;'>"; foreach ($branches as $branch) { if ($branch) { print_image ("images/tree/branch.png", false, array ("style" => 'vertical-align: middle;')); } else { print_image ("images/tree/no_branch.png", false, array ("style" => 'vertical-align: middle;')); } } if ($count < $countIncidents) {
function tasks_print_tree($id_project, $sql_search = '') { global $config; global $pdf_output; if ($pdf_output) { $graph_ttl = 2; } else { $graph_ttl = 1; } echo "<table class='blank' style='width:98%'>"; echo "<tr><td style='width:60%' valign='top'>"; $sql = "SELECT t.*\n\t\t\tFROM ttask t\n\t\t\tWHERE t.id_parent_task=0\n\t\t\t\tAND t.id>0\n\t\t\t\tAND t.id_project={$id_project}\n\t\t\t\t{$sql_search}\n\t\t\tORDER BY t.name"; //$sql_search = base64_encode($sql_search); $sql_count = "SELECT COUNT(*) AS num\n\t\t\tFROM ttask t\n\t\t\tWHERE t.id_parent_task=0\n\t\t\t\tAND t.id>0\n\t\t\t\tAND t.id_project={$id_project}\n\t\t\t\t{$sql_search}"; $countRows = process_sql($sql_count); if ($countRows === false) { $countRows = 0; } else { $countRows = (int) $countRows[0]['num']; } if ($countRows == 0) { echo '<h3 class="error">' . __('No tasks found') . '</h3>'; return; } $new = true; $count = 0; echo "<ul style='margin: 0; margin-top: 20px; padding: 0;'>\n"; $first = true; while ($task = get_db_all_row_by_steps_sql($new, $result, $sql)) { $new = false; $count++; echo "<li style='margin: 0; padding: 0;'>"; echo "<span style='display: inline-block;'>"; $branches = array(); if ($first) { if ($count != $countRows) { $branches[] = true; $img = print_image("images/tree/first_closed.png", true, array("style" => 'vertical-align: middle;', "id" => "tree_image" . $task['id'] . "_task_" . $task['id'], "pos_tree" => "0")); $first = false; } else { $branches[] = false; $img = print_image("images/tree/one_closed.png", true, array("style" => 'vertical-align: middle;', "id" => "tree_image" . $task['id'] . "_task_" . $task['id'], "pos_tree" => "1")); } } else { if ($count != $countRows) { $branches[] = true; $img = print_image("images/tree/closed.png", true, array("style" => 'vertical-align: middle;', "id" => "tree_image" . $task['id'] . "_task_" . $task['id'], "pos_tree" => "2")); } else { $branches[] = false; $img = print_image("images/tree/last_closed.png", true, array("style" => 'vertical-align: middle;', "id" => "tree_image" . $task['id'] . "_task_" . $task['id'], "pos_tree" => "3")); } } $task_access = get_project_access($config["id_user"], $id_project, $task["id"], false, true); if ($task_access["read"]) { // Background color if ($task["completion"] < 40) { $background_color = "background: #FFFFFF;"; } else { if ($task["completion"] < 90) { $background_color = "background: #FFE599;"; } else { if ($task["completion"] < 100) { $background_color = "background: #A4BCFA;"; } else { if ($task["completion"] == 100) { $background_color = "background: #B6D7A8;"; } else { $background_color = ""; } } } } // Priority $priority = print_priority_flag_image($task['priority'], true); // Task name $name = safe_output($task['name']); if (strlen($name) > 30) { $name = substr($name, 0, 30) . "..."; $name = "<a title='" . safe_output($task['name']) . "' href='index.php?sec=projects&sec2=operation/projects/task_detail\n\t\t\t\t\t&id_project=" . $task['id_project'] . "&id_task=" . $task['id'] . "&operation=view'>" . $name . "</a>"; } else { $name = "<a href='index.php?sec=projects&sec2=operation/projects/task_detail\n\t\t\t\t\t&id_project=" . $task['id_project'] . "&id_task=" . $task['id'] . "&operation=view'>" . $name . "</a>"; } if ($task["completion"] == 100) { $name = "<s>{$name}</s>"; } // Completion $progress = progress_bar($task['completion'], 70, 20, $graph_ttl); // Estimation $imghelp = "Estimated hours = " . $task['hours']; $taskhours = get_task_workunit_hours($task['id']); $imghelp .= ", Worked hours = {$taskhours}"; $a = round($task["hours"]); $b = round($taskhours); $mode = 2; if ($a > 0) { $estimation = histogram_2values($a, $b, __("Planned"), __("Real"), $mode, 60, 18, $imghelp, $graph_ttl); } else { $estimation = "--"; } // Time used on all child tasks + this task $recursive_timeused = task_duration_recursive($task["id"]); $time_used = _('Time used') . ": "; if ($taskhours == 0) { $time_used .= "--"; } elseif ($taskhours == $recursive_timeused) { $time_used .= $taskhours; } else { $time_used .= $taskhours . "<span title='Subtasks WU/HR'> (" . $recursive_timeused . ")</span>"; } $wu_incidents = get_incident_task_workunit_hours($task["id"]); if ($wu_incidents > 0) { $time_used .= "<span title='" . __("Time spent in related tickets") . "'> ({$wu_incidents})</span>"; } // People $people = combo_users_task($task['id'], 1, true); $people .= ' '; $people .= get_db_value('COUNT(DISTINCT(id_user))', 'trole_people_task', 'id_task', $task['id']); // Branches $branches_json = json_encode($branches); // New WO / Incident $wo_icon = print_image("images/paste_plain.png", true, array("style" => 'vertical-align: middle;', "id" => "wo_icon", "title" => __('Work order'))); $incident_icon = print_image("images/incident.png", true, array("style" => 'vertical-align: middle; height:19px; width:20px;', "id" => "incident_icon", "title" => __('Ticket'))); $wo_icon = "<a href='index.php?sec=projects&sec2=operation/workorders/wo&operation=create&id_task=" . $task['id'] . "'>{$wo_icon}</a>"; $incident_icon = "<a href='index.php?sec=incidents&sec2=operation/incidents/incident_detail&id_task=" . $task['id'] . "'>{$incident_icon}</a>"; $launch_icons = $wo_icon . " " . $incident_icon; echo "<a onfocus='JavaScript: this.blur()' href='javascript: loadTasksSubTree(" . $task['id_project'] . "," . $task['id'] . ",\"" . $branches_json . "\", " . $task['id'] . ",\"" . $sql_search . "\")'>"; echo "<script type=\"text/javascript\">\n\t\t\t\t\t \$(document).ready (function () {\n\t\t\t\t\t\t loadTasksSubTree(" . $task['id_project'] . "," . $task['id'] . ",\"" . $branches_json . "\", " . $task['id'] . ",\"" . $sql_search . "\");\n\t\t\t\t\t });\n\t\t\t\t </script>"; echo $img; echo "</a>"; echo "<span style='" . $background_color . " padding: 4px;'>"; echo "<span style='vertical-align:middle; display: inline-block;'>" . $priority . "</span>"; echo "<span style='margin-left: 5px; min-width: 250px; vertical-align:middle; display: inline-block;'>" . $name . "</span>"; echo "<span title='" . __('Progress') . "' style='margin-left: 15px; vertical-align:middle; display: inline-block;'>" . $progress . "</span>"; echo "<span style='margin-left: 15px; min-width: 70px; vertical-align:middle; display: inline-block;'>" . $estimation . "</span>"; echo "<span style='margin-left: 15px; vertical-align:middle; display: inline-block;'>" . $people . "</span>"; echo "<span style='margin-left: 15px; min-width: 200px; display: inline-block;'>" . $time_used . "</span>"; echo "<span style='margin-left: 15px; vertical-align:middle; display: inline-block;'>" . __('New') . ": " . $launch_icons . "</span>"; echo "</span>"; } else { // Task name $name = safe_output($task['name']); if (strlen($name) > 60) { $name = substr($name, 0, 60) . "..."; $name = "<div title='" . safe_output($task['name']) . "'>" . $name . "</a>"; } if ($task["completion"] == 100) { $name = "<s>{$name}</s>"; } // Priority $priority = print_priority_flag_image($task['priority'], true); // Branches $branches_json = json_encode($branches); echo "<a onfocus='JavaScript: this.blur()' href='javascript: loadTasksSubTree(" . $task['id_project'] . "," . $task['id'] . ",\"" . $branches_json . "\", " . $task['id'] . ",\"" . $sql_search . "\")'>"; echo "<script type=\"text/javascript\">\n\t\t\t\t\t \$(document).ready (function () {\n\t\t\t\t\t\t loadTasksSubTree(" . $task['id_project'] . "," . $task['id'] . ",\"" . $branches_json . "\", " . $task['id'] . ",\"" . $sql_search . "\");\n\t\t\t\t\t });\n\t\t\t\t </script>"; echo $img; echo "</a>"; echo "<span title='" . __('You are not assigned to this task') . "' style='padding: 4px;'>"; echo "<span style='vertical-align:middle; display: inline-block;'>" . $priority . "</span>"; echo "<span style='color: #D8D8D8; margin-left: 5px; display: inline-block;'>" . $name . "</span>"; echo "</span>"; } echo "<div hiddenDiv='1' loadDiv='0' style='display: none; margin: 0px; padding: 0px;' class='tree_view tree_div_" . $task['id'] . "' id='tree_div" . $task['id'] . "_task_" . $task['id'] . "'></div>"; echo "</li>"; } echo "</ul>"; echo "</td></tr>"; echo "</table>"; return; }
function print_groups_table($groups) { enterprise_include("include/functions_groups.php"); $return = enterprise_hook('print_groups_table_extra', array($groups)); if ($return === ENTERPRISE_NOT_HOOK) { echo "<div class='divresult'>"; echo '<table width="99%" class="listing" id="table1">'; echo '<thead>'; echo '<tr>'; echo '<th class="header c0" scope="col">' . __('Users') . '</th>'; echo '<th class="header c1" scope="col">' . __('Icon') . '</th>'; echo '<th class="header c2" scope="col">' . __('Name') . '</th>'; echo '<th class="header c3" scope="col">' . __('Parent') . '</th>'; echo '<th class="header c4" scope="col">' . __('Delete') . '</th>'; echo '</tr>'; echo '</thead>'; $count = 0; if ($groups === false) { $groups = array(); } if (!empty($groups)) { foreach ($groups as $group) { $data = array(); $num_users = get_db_value("COUNT(id_usuario)", "tusuario_perfil", "id_grupo", $group["id_grupo"]); if ($num_users > 0) { $users_icon = '<a href="javascript:"><img src="images/group.png" title="' . __('Show and hide the user list') . '" /></a>'; } else { $users_icon = ''; } $icon = ''; if ($group['icon'] != '') { $icon = '<img src="images/groups_small/' . $group['icon'] . '" />'; } if ($group["id_grupo"] != 1) { $group_name = '<a href="index.php?sec=users&sec2=godmode/grupos/configurar_grupo&id=' . $group['id_grupo'] . '">' . $group['nombre'] . '</a>'; } else { $group_name = $group["nombre"]; } $parent = dame_nombre_grupo($group["parent"]); //Group "all" is special not delete and no update if ($group["id_grupo"] != 1) { $delete_button = '<a href="index.php?sec=users& sec2=godmode/grupos/lista_grupos& id_grupo=' . $group["id_grupo"] . '& delete_group=1&id=' . $group["id_grupo"] . '" onClick="if (!confirm(\'' . __('Are you sure?') . '\')) return false;"> <img src="images/cross.png"></a>'; } else { $delete_button = ""; } echo '<tr id="table1-' . $count . '" style="border:1px solid #505050;" class="datos2">'; echo '<td id="table1-' . $count . '-0" style="text-align:center; width:40px;" class="datos2">' . $users_icon . '</td>'; echo '<td id="table1-' . $count . '-1" style="width:40px;" class="datos2">' . $icon . '</td>'; echo '<td id="table1-' . $count . '-2" style=" font-weight: bold;" class="datos2">' . $group_name . '</td>'; echo '<td id="table1-' . $count . '-3" style="" class="datos2">' . $parent . '</td>'; echo '<td id="table1-' . $count . '-4" style=" text-align:center; width:40px;" class="datos2">' . $delete_button . '</td>'; echo '</tr>'; echo '<tr id="table1-' . $count . '-users" style="display:none;">'; echo '<td colspan="5" style="text-align:center; background-color:#e6e6e6;">'; echo '<table width="99%" cellpadding="0" cellspacing="0" border="0px" id="table_users_' . $count . '">'; echo '<tr style="text-align:center;">'; if ($num_users > 0) { $users_sql = "SELECT * FROM tusuario_perfil WHERE id_grupo =" . $group["id_grupo"] . " ORDER BY id_usuario"; $count_users = 0; $new = true; while ($user = get_db_all_row_by_steps_sql($new, $result_users, $users_sql)) { $new = false; if ($count_users >= 4) { $count_users = 0; echo '</tr>'; echo '<tr style="text-align:center;">'; } $user_name = "<a href=\"index.php?sec=users&sec2=godmode/usuarios/configurar_usuarios&update_user="******"\"><strong>" . $user['id_usuario'] . "</strong></a>"; $user_real_name = get_db_value("nombre_real", "tusuario", "id_usuario", $user['id_usuario']); $delete_icon = '<a href="index.php?sec=users&sec2=godmode/grupos/lista_grupos&delete_user=1&id_user_delete=' . $user['id_usuario'] . '" onClick="if (!confirm(\'' . __('Are you sure?') . '\')) return false;"><img src="images/cross.png"></a>'; $user_name = "{$user_name} ({$user_real_name}) " . $delete_icon; echo '<td style="background-color:#e6e6e6;"">' . $user_name . '</td>'; $count_users++; } } else { echo '<td style="background-color:#e6e6e6;"">' . __('There are no users') . '</td>'; } echo '</tr>'; echo '</table>'; echo '</td>'; echo '</tr>'; echo "<script type=\"text/javascript\">\n\t\t\t\t\t \$(document).ready (function () {\n\t\t\t\t\t\t \$(\"#table1-{$count}-0\").click(function() {\n\t\t\t\t\t\t\t \$(\"#table1-{$count}-users\").toggle();\n\t\t\t\t\t\t });\n\t\t\t\t\t });\n\t\t\t\t\t </script>"; $count++; } } echo '</table>'; if (empty($groups)) { echo ui_print_error_message(__("No groups"), '', true, 'h3', true); } echo '</div>'; } }
echo "<th>" . __("WU/Tsk"); echo "<th align='center'>" . __("Delete") . "</th>"; $sql = get_projects_query($id_user, "", 0, true); $new = true; $color = 1; while ($project = get_db_all_row_by_steps_sql($new, $result_project, $sql)) { $sql = get_tasks_query($id_user, $project['id'], "", 0, true); $new = true; $project_access = get_project_access($config['id_user'], $project['id']); // ACL - To see the project, you should have read access if (!$project_access['read']) { $new = false; continue; // Does not show this project tasks } while ($task = get_db_all_row_by_steps_sql($new, $result_task, $sql)) { $new = false; $belong_task = user_belong_task($id_user, $task['id'], true); $task_access = get_project_access($config['id_user'], $project['id'], $task['id'], false, true); // ACL - To see the task, you should have read access if (!$task_access['read']) { continue; // Does not show this task } $role = get_db_sql("SELECT name\n\t\t\t\t\t\t\t FROM trole\n\t\t\t\t\t\t\t WHERE id IN(SELECT id_role\n\t\t\t\t\t\t\t\t\t\t FROM trole_people_task\n\t\t\t\t\t\t\t\t\t\t WHERE id_user='******'\n\t\t\t\t\t\t\t\t\t\t\tAND id_task=" . $task['id'] . ")"); echo "<tr>"; echo "<td>"; echo "<a href='index.php?sec=projects&sec2=operation/projects/project_detail&id_project=" . $project['id'] . "'>" . $project['name'] . "</a>"; echo "<td><b><a href='index.php?sec=projects&sec2=operation/projects/task_detail&id_project=" . $project['id'] . "&id_task=" . $task['id'] . "&operation=view'>" . $task['name'] . "</a></b>"; echo "<td>" . $role; if ($belong_task) {
private function getFilesList($href = "", $delete_button = false, $delete_href = "") { $system = System::getInstance(); $ui = Ui::getInstance(); if ($href == "") { $href = "index.php?page=incident&tab=file&id_incident=" . $this->id_incident; } session_start(); $_SESSION["id_usuario"] = $system->getConfig('id_user'); session_write_close(); $html = "<ul class='ui-itemlistview' data-role='listview' data-count-theme='e'>"; if ($this->getCountFiles() > 0) { $sql = $this->getFilesQuery(); $new = true; while ($file = get_db_all_row_by_steps_sql($new, $result_query, $sql)) { $new = false; $html .= "<li>"; $html .= "<a data-ajax='false' target='_blank' href='../operation/common/download_file.php?type=incident&id_attachment=" . $file['id_attachment'] . "' class='ui-link-inherit' target='_blank'>"; $html .= "<h3 class='ui-li-heading'><img src='../images/attach.png'> " . $file['filename'] . "</img></h3>"; $html .= "<p class='ui-li-desc'>" . $file['description'] . "</p>"; $html .= "<span class=\"ui-li-aside\">" . round($file['size'] / 1024, 2) . " KB</span>"; $html .= "</a>"; if ($delete_button) { if ($delete_href == "") { $delete_href = "index.php?page=incident&tab=files&operation=delete_file"; $delete_href .= "&id_incident=" . $this->id_incident; } $options = array('popup_id' => 'delete_popup_' . $file['id_attachment'], 'delete_href' => $delete_href . "&id_file=" . $file['id_attachment']); $html .= $ui->getDeletePopupHTML($options); $html .= "<a data-icon=\"delete\" data-rel=\"popup\" href=\"#delete_popup_" . $file['id_attachment'] . "\"></a>"; } $html .= "</li>"; } } else { $html .= "<li>"; $html .= "<h3 class='error'>" . __('There is no files') . "</h3>"; $html .= "</li>"; } $html .= "</ul>"; return $html; }
/** * Get the number of readable tasks of a project for an user * * @param id_user User ID * @param id_project Project Id * @param id_parent Only count the tasks with that parent * * @return int Count of tasks */ function get_accesible_task_count($id_user, $id_project, $id_parent = false) { if ($id_parent !== false) { $parent = "id_parent_task={$id_parent}"; } else { $parent = "1=1"; } $sql = "SELECT id\n\t\t\tFROM ttask\n\t\t\tWHERE {$parent}\n\t\t\t\tAND id_project={$id_project}"; $count = 0; $new = true; while ($task = get_db_all_row_by_steps_sql($new, $result_project, $sql)) { $new = false; $task_access = get_project_access($id_user, $id_project, $task['id'], false, true); if ($task_access['read']) { $count++; } } return $count; }