}
$data[3] = '<a href="' . $config["base_url"] . '/index.php?sec=incidents&sec2=operation/incidents/incident_dashboard_detail&id=' . $incident['id_incidencia'] . '">' . $incident['titulo'] . '</a>';
$data[4] = get_db_value("nombre", "tgrupo", "id_grupo", $incident['id_grupo']);
if ($config["show_creator_incident"] == 1) {
$id_creator_company = get_db_value("id_company", "tusuario", "id_usuario", $incident["id_creator"]);
if ($id_creator_company != 0) {
$company_name = (string) get_db_value('name', 'tcompany', 'id', $id_creator_company);
$data[4] .= "<br><span style='font-style:italic'>{$company_name}</span>";
}
}
$resolution = isset($resolutions[$incident['resolution']]) ? $resolutions[$incident['resolution']] : __('None');
$data[5] = '<strong>' . $statuses[$incident['estado']] . '</strong><br /><em>' . $resolution . '</em>';
$data[6] = print_priority_flag_image($incident['prioridad'], true);
$data[7] = human_time_comparation($incident["actualizacion"]);
$data[7] .= '<br /><em>';
$data[7] .= human_time_comparation($incident["inicio"]);
$data[7] .= '</em>';
$data[8] = $incident['id_usuario'];
array_push($table->data, $data);
}
print_table($table);
}
}
echo "<div class= 'dialog ui-dialog-content' title='" . __("Warning") . "' id='custom_search'></div>";
?>
<script type="text/javascript" src="include/js/jquery.ui.datepicker.js"></script>
<script type="text/javascript" src="include/languages/date_<?php
echo $config['language_code'];
?>
.js"></script>
<script type="text/javascript" src="include/js/integria_date.js"></script>
} else {
$data[3] = "";
}
$sum_leads = get_db_sql("SELECT COUNT(id) FROM tlead WHERE progress < 100 AND id_company = " . $company["id"]);
if ($sum_leads > 0) {
$leads_data = " ({$sum_leads}) ";
$leads_data .= get_db_sql("SELECT SUM(estimated_sale) FROM tlead WHERE progress < 100 AND id_company = " . $company["id"]);
$data[4] = "<a title='{$leads_data}' href='index.php?sec=customers&sec2=operation/companies/company_detail&op=leads&id=" . $company["id"] . "'><img src='images/icon_lead.png'></a>";
} else {
$data[4] = "";
}
$data[5] = $company["manager"];
$data[6] = $company["country"];
// get last activity date for this company record
$last_activity = get_db_sql("SELECT MAX(date) FROM tcompany_activity WHERE id_company = " . $company["id"]);
$data[7] = human_time_comparation($last_activity);
if (!$company["billing"]) {
$company["billing"] = '0.00';
}
$data[8] = $company["billing"];
// . " " . $config["currency"];
$manage_permission = check_crm_acl('company', 'cm', $config['id_user'], $company['id']);
if ($manage_permission) {
$data[9] = "<a href='#' onClick='javascript: show_validation_delete(\"delete_company\"," . $company['id'] . ",0," . $offset . ",\"" . $search_params . "\");'><img src='images/cross.png'></a>";
} else {
$data[9] = '';
}
array_push($table->data, $data);
}
print_table($table);
}
}
if ($wo["id_wo_category"]){
$category = get_db_row ("two_category", "id", $wo["id_wo_category"]);
$data[7] = "<img src='images/wo_category/".$category["icon"]."' title='".$category["name"]."'>";
} else {
$data[7] = "";
}
if ($wo["end_date"] != "0000-00-00 00:00:00")
$data[8] = "<span style='font-size: 9px'>".substr($wo["end_date"],0,10). "</span>";
else
$data[8] = "--";
$data[9] = "<span style='font-size: 9px'>". human_time_comparation($wo["start_date"]) . "<br>". human_time_comparation($wo["last_update"]). "</span>";
$data[10] = "";
if ($wo['assigned_user'] == $config["id_user"]){
if ($wo["progress"] == 0){
$data[10] .= "<a href='index.php?sec=projects&sec2=operation/workorders/wo$params&id=". $wo['id']."&set_progress=1'><img src='images/ack.png' title='".__("Set as finished")."'></a>";
}
}
if (($wo["progress"] < 2) AND ($wo["created_by_user"] == $config["id_user"]) AND ($wo["need_external_validation"] == 1) ){
$data[10] = "<a href='index.php?sec=projects&sec2=operation/workorders/wo$params&id="
. $wo['id']."&set_progress=2&offset=$offset'><img src='images/rosette.png' title='".__("Validate")."'></a>";
}
// Evaluate different conditions to allow WO deletion
$can_delete = dame_admin($config["id_user"]);
$incidents = get_incidents($filter);
if (empty($incidents)) {
$table->colspan[0][0] = 9;
$table->data[0][0] = __('Nothing was found');
$incidents = array();
}
$row = 0;
foreach ($incidents as $incident) {
$table->data[$row][0] = '#' . $incident['id_incidencia'];
$table->data[$row][1] = '<a href="index.php?sec=incidents&sec2=operation/incidents_simple/incident&id=' . $incident['id_incidencia'] . '">' . $incident['titulo'] . '</a>';
$resolution = isset($resolutions[$incident['resolution']]) ? $resolutions[$incident['resolution']] : __('None');
$table->data[$row][2] = '<strong>' . $statuses[$incident['estado']] . '</strong><br /><em>' . $resolution . '</em>';
$table->data[$row][3] = print_priority_flag_image($incident['prioridad'], true);
$table->data[$row][4] = human_time_comparation($incident["actualizacion"]);
$table->data[$row][4] .= '<br /><em>';
$table->data[$row][4] .= human_time_comparation($incident["inicio"]);
$table->data[$row][4] .= '</em>';
if ($config["show_owner_incident"] == 1) {
$table->data[$row][5] = $incident['id_usuario'];
}
if ($incident["estado"] < 3) {
$table->rowclass[$row] = 'red';
} elseif ($incident["estado"] < 6) {
$table->rowclass[$row] = 'yellow';
} else {
$table->rowclass[$row] = 'green';
}
$table->rowstyle[$row] = 'border-bottom: 1px solid rgb(204, 204, 204);';
$row++;
}
print_table($table);
$row["id_type"] = -1;
}
$data[3] = get_download_type_icon($row["id_type"]);
if (give_acl($config["id_user"], 0, "FRW")) {
// Downloads
$data[4] = get_db_sql("SELECT COUNT(*) FROM tdownload_tracking where id_download = " . $row["id"]);
// Public URL
if ($row["public"]) {
$url = $config["base_url"] . "/operation/common/download_file.php?type=external_release&id_attachment=" . $row["external_id"];
$data[5] = "<a href='{$url}'><img src='images/world.png'></a>";
} else {
$data[5] = "";
}
}
// Timestamp
$data[6] = human_time_comparation($row["date"]);
if (give_acl($config["id_user"], 0, "FRW")) {
// Edit
$data[7] = "<a href='index.php?sec=download&sec2=operation/download/browse&update=" . $row["id"] . "'><img border='0' src='images/wrench.png'></a>";
$data[7] .= " ";
// Delete
$data[7] .= "<a href='index.php?sec=download&sec2=operation/download/browse&delete_data=" . $row["id"] . "' onClick='if (!confirm(\\' " . __('Are you sure?') . "\\')) return false;'><img border='0' src='images/cross.png'></a>";
}
array_push($table->data, $data);
}
print_table($table);
}
}
}
//external_id hidden
echo '<div id="external_id_hidden" style="display:none;">';
function user_search_result($filter, $ajax, $size_page, $offset, $clickin, $search_text, $disabled_user, $level, $group, $from_tickets = false)
{
global $config;
if ($filter != 0) {
$offset = $filter['offset'];
$search_text = $filter['search_text'];
$disabled_user = $filter['disabled_user'];
$level = $filter['level'];
$group = $filter['group'];
}
$search = "WHERE 1=1 ";
if ($search_text != "") {
$search .= " AND (id_usuario LIKE '%{$search_text}%' OR comentarios LIKE '%{$search_text}%' OR nombre_real LIKE '%{$search_text}%' OR direccion LIKE '%{$search_text}%')";
}
if ($disabled_user > -1) {
$search .= " AND disabled = {$disabled_user}";
}
if ($level > -10) {
$search .= " AND nivel = {$level}";
}
if ($group == -1) {
$search .= " AND tusuario.id_usuario NOT IN (select id_usuario from tusuario_perfil)";
} else {
if ($group > 0) {
$search .= " AND tusuario.id_usuario = ANY (SELECT id_usuario FROM tusuario_perfil WHERE id_grupo = {$group})";
}
}
$query1 = "SELECT * FROM tusuario {$search} ORDER BY id_usuario";
if ($from_tickets) {
$query1 = users_get_allowed_users_query($config['id_user'], $filter);
}
$count = get_db_sql("SELECT COUNT(id_usuario) FROM tusuario {$search} ");
$sql1 = "{$query1} LIMIT {$offset}, " . $size_page;
echo "<div class='divresult'>";
pagination($count, "index.php?sec=users&sec2=godmode/usuarios/lista_usuarios&search_text=" . $search_text . "&disabled_user="******"&level=" . $level . "&group=" . $group, $offset, true);
$resq1 = process_sql($sql1);
if (!$resq1) {
echo ui_print_error_message(__("No users"), '', true, 'h3', true);
} else {
echo '<table width="100%" class="listing">';
if ($filter == 0) {
echo '<th>' . print_checkbox('all_user_checkbox', 1, false, true);
echo '<th title="' . __('Enabled/Disabled') . '">' . __('E/D');
echo '<th title="' . __('Enabled login') . '">' . __('Enabled login');
}
echo '<th>' . __('User ID');
echo '<th>' . __('Name');
echo '<th>' . __('Company');
echo '<th>' . __('Last contact');
echo '<th>' . __('Profile');
if ($filter == 0) {
echo '<th>' . __('Delete');
}
// Init vars
$nombre = "";
$nivel = "";
$comentarios = "";
$fecha_registro = "";
if ($resq1) {
foreach ($resq1 as $rowdup) {
$nombre = $rowdup["id_usuario"];
$nivel = $rowdup["nivel"];
$realname = $rowdup["nombre_real"];
$fecha_registro = $rowdup["fecha_registro"];
$avatar = $rowdup["avatar"];
if ($rowdup["nivel"] == 0) {
$nivel = "<img src='images/group.png' title='" . __("Grouped user") . "'>";
} elseif ($rowdup["nivel"] == 1) {
$nivel = "<img src='images/integria_mini_logo.png' title='" . __("Administrator") . "'>";
} else {
$nivel = "<img src='images/user_gray.png' title='" . __("Standalone user") . "'>";
}
$disabled = $rowdup["disabled"];
$id_company = $rowdup["id_company"];
$enabled_login = $rowdup["enable_login"];
echo "<tr>";
if ($filter == 0) {
echo "<td>";
echo print_checkbox_extended("user-" . $rowdup["id_usuario"], $rowdup["id_usuario"], false, false, "", "class='user_checkbox'", true);
echo "<td>";
if ($disabled == 1) {
echo "<img src='images/lightbulb_off.png' title='" . __("Disabled") . "'> ";
}
echo "<td>";
if ($enabled_login == 1) {
echo "<img src='images/accept.png' title='" . __("Enabled login") . "'> ";
} else {
echo "<img src='images/fail.png' title='" . __("Disabled login") . "'> ";
}
}
echo "<td>";
if ($filter == 0) {
echo "<a href='index.php?sec=users&sec2=godmode/usuarios/configurar_usuarios&update_user="******"'>" . ucfirst($nombre) . "</a>";
} else {
$url = "javascript:loadContactUser(\"" . $nombre . "\",\"" . $clickin . "\");";
echo "<a href='" . $url . "'>" . ucfirst($nombre) . "</a>";
}
echo "<td style=''>" . $realname;
$company_name = (string) get_db_value('name', 'tcompany', 'id', $id_company);
echo "<td>" . $company_name . "</td>";
echo "<td style=''>" . human_time_comparation($fecha_registro);
echo "<td>";
print_user_avatar($nombre, true);
echo " ";
if ($config["enteprise"] == 1) {
$sql1 = 'SELECT * FROM tusuario_perfil WHERE id_usuario = "' . $nombre . '"';
$result = mysql_query($sql1);
echo "<a href='#' class='tip'> <span>";
if (mysql_num_rows($result)) {
while ($row = mysql_fetch_array($result)) {
echo dame_perfil($row["id_perfil"]) . "/ ";
echo dame_grupo($row["id_grupo"]) . "<br>";
}
} else {
echo __('This user doesn\'t have any assigned profile/group');
}
echo "</span></a>";
}
echo $nivel;
if ($filter == 0) {
echo '<td align="center">';
echo '<a href="index.php?sec=users&sec2=godmode/usuarios/lista_usuarios&borrar_usuario=' . $nombre . '" onClick="if (!confirm(\'' . __('Are you sure?') . '\')) return false;"><img src="images/cross.png"></a>';
echo '</td>';
}
}
}
echo "</table>";
}
echo "</div>";
}
function print_file_types_table($return = false)
{
$condition = get_filter_by_fr_category_accessibility();
$types = process_sql("SELECT tdownload_type.id AS id,\n\t\t\t\t\t\t\t\ttdownload_type.name AS name,\n\t\t\t\t\t\t\t\ttdownload_type.description AS description,\n\t\t\t\t\t\t\t\ttdownload_type.icon AS icon,\n\t\t\t\t\t\t\t\tCOUNT(tdownload.id) AS num_files,\n\t\t\t\t\t\t\t\tMAX(tdownload.date) AS last_update\n\t\t\t\t\t\tFROM tdownload, tdownload_type, tdownload_type_file\n\t\t\t\t\t\tWHERE tdownload.id = tdownload_type_file.id_download\n\t\t\t\t\t\t\tAND tdownload_type.id = tdownload_type_file.id_type\n\t\t\t\t\t\t\t{$condition}\n\t\t\t\t\t\tGROUP BY name\n\t\t\t\t\t\tORDER BY last_update DESC");
if (!$types) {
$types = array();
}
$without_type = process_sql("SELECT -1 AS id,\n\t\t\t\t\t\t\t\t\t\t'' AS name,\n\t\t\t\t\t\t\t\t\t\t'' AS description,\n\t\t\t\t\t\t\t\t\t\t'default.png' AS icon,\n\t\t\t\t\t\t\t\t\t\tCOUNT(id) AS num_files,\n\t\t\t\t\t\t\t\t\t\tMAX(date) AS last_update\n\t\t\t\t\t\t\t\tFROM tdownload\n\t\t\t\t\t\t\t\tWHERE id NOT IN (SELECT id_download FROM tdownload_type_file)\n\t\t\t\t\t\t\t\t\t{$condition}\n\t\t\t\t\t\t\t\tORDER BY last_update DESC");
if ($without_type) {
$without_type = $without_type[0];
$without_type["name"] = __('Without type');
if (!$types) {
$types[0] = $without_type;
} elseif ($types[0]["last_update"] < $without_type["last_update"]) {
array_unshift($types, $without_type);
} elseif ($types[count($types) - 1]["last_update"] > $without_type["last_update"]) {
array_push($types, $without_type);
} else {
$types_aux = array();
for ($i = 0; $i < count($types); $i++) {
$types_aux[] = $types[$i];
if (isset($types[$i]["last_update"]) && isset($types[$i + 1]["last_update"])) {
if ($types[$i]["last_update"] > $without_type["last_update"] && $types[$i + 1]["last_update"] < $without_type["last_update"]) {
$types_aux[] = $without_type;
}
}
}
$types = $types_aux;
$types_aux = null;
}
}
$table = new stdClass();
$table->width = '100%';
$table->class = 'blank';
$table->style = array();
$table->style[0] = "min-width:50%; width:50%; max-width:50%";
$table->style[1] = "min-width:50%; width:50%; max-width:50%";
$table->valign = array();
$table->valign[0] = "top";
$table->valign[1] = "top";
$table->data = array();
$column_num = 2;
$column_count = 0;
$column = 0;
foreach ($types as $type) {
$table_type = new stdClass();
$table_type->width = '100%';
$table_type->class = 'search-table-white';
$table_type->style = array();
$table_type->style[0] = "vertical-align:top; min-width:25px; width:25px; max-width:25px";
$table_type->data = array();
if ((int) $type["num_files"] > 0) {
$file_releases = get_file_releases(0, $type["id"], 10, true);
$fr_names = __('Last updated file releases') . ":";
foreach ($file_releases as $fr) {
$fr_names .= "\n" . $fr;
}
} else {
$fr_names = "";
}
$table_type->data[0][0] = print_image("images/download_type/" . $type["icon"], true);
$table_type->data[0][1] = "<a style='font-weight: bold;' href='index.php?sec=download&sec2=operation/download/browse&id_type=" . $type["id"] . "'>" . $type["name"] . "</a>";
$table_type->data[0][1] .= " <div style='display:inline;' title='{$fr_names}'>(" . (int) $type["num_files"] . ")</div>";
$table_type->data[0][1] .= "<br>";
$table_type->data[0][1] .= "<div>" . $type["description"] . "</div>";
$table_type->data[0][1] .= "<div style='color: #FF9933;'><i>" . __('Last update') . ": " . human_time_comparation($type["last_update"]) . "</i></div>";
$table->data[0][$column] .= print_table($table_type, true);
$column_count += 1;
$column += 1;
if ($column_count >= $column_num) {
$column_count = 0;
$column = 0;
}
}
print_table($table, $return);
}
function incident_details_list($id_incident, $return = false)
{
$output = '';
$incident = get_incident($id_incident);
$output .= '<ul id="incident-details-list" class="sidemenu">';
$output .= ' <strong>' . __('Open at') . '</strong>: ' . human_time_comparation($incident['inicio']);
if ($incident['estado'] == 7) {
$output .= '<br /> <strong>' . __('Closed at') . '</strong>: ' . human_time_comparation($incident['cierre']);
}
if ($incident['actualizacion'] != $incident['inicio']) {
$output .= '<br /> <strong>' . __('Last update') . '</strong>: ' . human_time_comparation($incident['actualizacion']);
}
/* Show workunits if there are some */
$workunit_count = get_incident_count_workunits($id_incident);
if ($workunit_count) {
$work_hours = get_incident_workunit_hours($id_incident);
$workunits = get_incident_workunits($id_incident);
$workunit_data = get_workunit_data($workunits[0]['id_workunit']);
$output .= '<br /> <strong>' . __('Last work at') . '</strong>: ' . human_time_comparation($workunit_data['timestamp']);
$output .= '<br /> <strong>' . __('Workunits') . '</strong>: ' . $workunit_count;
$output .= '<br /> <strong>' . __('Time used') . '</strong>: ' . $work_hours;
$output .= '<br /> <strong>' . _('Done by') . '</strong>: <em>' . $workunit_data['id_user'] . '</em>';
}
$output .= '</ul>';
if ($return) {
return $output;
}
echo $output;
}
echo "<td class=f9>";
$product_name = get_db_sql ("SELECT name FROM tkb_product WHERE id = ".$row["id_product"]);
$product_img = get_db_sql ("SELECT icon FROM tkb_product WHERE id = ".$row["id_product"]);
if (!$product_img) {
echo "";
}
else {
echo "<img title='$product_name' src='images/products/". $product_img . "'>";
}
// Language
echo "<td class=f9>";
echo $row["id_language"];
// Timestamp
echo "<td class='f9' valign='top'>";
echo human_time_comparation($row["timestamp"]);
if (give_acl($config["id_user"], 0, "KW")) {
// Delete
echo "<td class='f9' align='center' >";
echo "<a href='index.php?sec=kb&sec2=operation/kb/manage_data&update=".$row['id']."'><img border=0 title='".__('Edit')."' src='images/application_edit.png'></a>";
echo " ";
echo '<a href="index.php?sec=kb&sec2=operation/kb/browse&delete_data='.$row["id"].'" onClick="if (!confirm(\''.__('Are you sure?').'\')) return false;"><img src="images/cross.png"></a>';
}
}
echo "</table>";
} else {
$downloads = array();
echo ui_print_error_message (__('No items found'), '', true, 'h3', true);
}
$table->width = "95%";
$table->class = "listing";
$table->data = array ();
$table->size = array ();
$table->style = array ();
$table->style[0] = 'font-weight: bold';
$table->head = array ();
$table->head[0] = __("Description");
$table->head[1] = __("Timestamp");
$table->head[2] = __("User ID");
foreach ($activities as $activity) {
$data = array ();
$timestamp = $activity["timestamp"];
$nota = $activity["description"];
$id_usuario_nota = $activity["id_user"];
$data[0] = $nota;
$data[1] = human_time_comparation ($timestamp);
$data[2] = $id_usuario_nota;
array_push ($table->data, $data);
}
print_table ($table);
}
}
?>
$data[4] = "<a href='index.php?sec=customers&sec2=operation/companies/company_detail&id=".$lead['id_company']."'>".get_db_value ('name', 'tcompany', 'id', $lead['id_company'])."</a>";
if ($lead["owner"] != "")
$data[4] .= "<br><i>" . $lead["owner"] . "</i>";
$data[5] = translate_lead_progress ($lead['progress']) . " <i>(".$lead['progress']. "%)</i>";
if ($lead['estimated_sale'] != 0)
$data[6] = format_numeric($lead['estimated_sale']);
else
$data[6] = "--";
$data[7] = "<img src='images/lang/".$lead["id_language"].".png'>";
$data[8] = ucfirst(strtolower($lead['country']));
$data[9] = "<span style='font-size: 9px' title='". $lead['creation'] . "'>" . human_time_comparation ($lead['creation']) . "</span>";
$data[9] .= "<br><span style='font-size: 9px'>". human_time_comparation ($lead['modification']). "</span>";
if ($lead['progress'] < 100 && $lead['owner'] == "")
$data[10] = "<a href='index.php?sec=customers&sec2=operation/leads/lead&tab=search&id=".
$lead['id']."&make_owner=1&offset=$offset'><img src='images/award_star_silver_1.png' title='".__("Take ownership of this lead")."'></a> ";
else
$data[10] = "";
// Close that lead
if ($lead['progress'] < 100 && ((($config["id_user"] == $lead["owner"] && ($section_write_permission || $section_manage_permission)) || dame_admin($config["id_user"])))) {
$data[10] .= "<a href='index.php?sec=customers&sec2=operation/leads/lead&tab=search&id=".
$lead['id']."&close=1&offset=$offset'><img src='images/lock.png' title='".__('Close this lead')."'></a>";
}
// Show delete control if its owned by the user
$owner = $l['owner'];
$details = ui_print_truncate_text($owner, $char_truncate, false, true);
$lead_list .= "<div class='pipeline-list-owner'>".$owner."</div>";
}
if (!empty($l['estimated_close_date']) && $l['estimated_close_date'] != '0000-00-00 00:00:00') {
$estimated_close_date = date('Y-m-d', strtotime($l['estimated_close_date']));
$lead_list .= "<div title= '".__('Estimated close date')."' class='pipeline-list-estimated_close_date'>".$estimated_close_date."</div>";
}
// Detect if the lead is pretty old
if (calendar_time_diff ($l["modification"]) > $lead_warning_time) {
$human_time_lead = human_time_comparation ($l['modification']);
$time_title = sprintf (__("Updated %s ago"), $human_time_lead);
$lead_list .= "<img class='pipeline-warning-icon' src='images/header_warning.png' title='".$time_title."' alt='".$time_title."'>";
}
// Detect if the lead have specific changes in the last 7 days
$sql = sprintf("SELECT id_lead, id_user, description, UNIX_TIMESTAMP(timestamp) AS datetime
FROM tlead_history
WHERE id_lead = %d
AND UNIX_TIMESTAMP(timestamp) >= %d
ORDER BY datetime DESC", $l['id'], time() - SECONDS_1WEEK);
$lead_history = process_sql($sql);
if ($lead_history !== false) {
$incidents_home = '';
if ($incidents > 0) {
$sql_2 = "SELECT * FROM tincidencia WHERE (id_creator = '" . $config["id_user"] . "' OR id_usuario = '" . $config["id_user"] . "') AND estado IN (1,2,3,4,5) ORDER BY actualizacion DESC limit 5";
$result_2 = mysql_query($sql_2);
if ($result_2) {
$incidents_home .= "<table width=100% class='landing_incidents listing'>";
$incidents_home .= "<tr><th>" . _("Status") . "</th><th>" . __("Priority") . "</th><th>" . __("Updated") . "</th><th>" . __("Ticket") . "</th><th>" . __("Last WU") . "</th></tr>";
}
while ($row_2 = mysql_fetch_array($result_2)) {
$idi = $row_2["id_incidencia"];
$incidents_home .= "<tr><td>";
$incidents_home .= render_status($row_2["estado"]);
$incidents_home .= "<td>";
$incidents_home .= print_priority_flag_image($row_2['prioridad'], true);
$incidents_home .= "<td>";
$incidents_home .= human_time_comparation($row_2["actualizacion"]);
$incidents_home .= "<td>";
$incidents_home .= "<a href='index.php?sec=incidents&sec2=operation/incidents/incident_dashboard_detail&id={$idi}'>";
$incidents_home .= $row_2["titulo"];
$incidents_home .= "</b></a>";
$incidents_home .= "</td>";
$incidents_home .= "<td style='font-size: 10px'>";
$last_wu = get_incident_lastworkunit($idi);
$incidents_home .= $last_wu["id_user"];
$incidents_home .= "</td></tr>";
}
if (isset($row_2)) {
$incidents_home .= "</table>";
}
} else {
$incidents_home .= "<div class='landing_empty'>";
$table->head[3] = __("Priority");
$table->head[4] = __("Updated");
$table->data = array();
foreach ($incidents as $inc) {
$data = array();
if (give_acl($config["id_user"], 0, "IR")) {
$link_start = '<a href="index.php?sec=incidents&sec2=operation/incidents/incident_dashboard_detail&id='.$inc["id_incidencia"].'">';
$link_end = '</a>';
} else {
$link_start = "";
$link_end = "";
}
$data[0] = $link_start."#".$inc["id_incidencia"].$link_end;
$data[1] = $link_start.$inc["titulo"].$link_end;
$status = get_db_value("name", "tincident_status", "id", $inc["estado"]);
$data[2] = $status;
$data[3] = print_priority_flag_image ($inc['prioridad'], true);
$data[4] = human_time_comparation ($inc["actualizacion"]);
array_push($table->data, $data);
}
print_table($table);
}
?>
function incidents_search_result_group_by_project($filter, $ajax = false, $return_incidents = false, $print_result_count = false)
{
global $config;
// ----------------------------------------
// Here we print the result of the search
// ----------------------------------------
echo '<table width="99%" cellpadding="0" cellspacing="0" border="0px" class="result_table listing" id="incident_search_result_table">';
echo '<thead>';
echo "<tr>";
echo "<th>";
echo print_checkbox('incidentcb-all', "", false, true);
echo "</th>";
echo "<th>";
echo __('ID');
echo "</th>";
echo "<th>";
echo __('SLA');
echo "</th>";
echo "<th>";
echo __('Ticket');
echo "</th>";
echo "<th>";
echo __('Group') . "<br><i>" . __('Company') . "</i>";
echo "</th>";
echo "<th>";
echo __('Status') . "<br><i>" . __('Resolution') . "</i>";
echo "</th>";
echo "<th>";
echo __('Priority');
echo "</th>";
echo "<th style='width: 70px;'>";
echo __('Updated') . "<br><i>" . __('Started') . "</i>";
echo "</th>";
if ($config["show_creator_incident"] == 1) {
echo "<th>";
}
echo __('Creator');
echo "</th>";
if ($config["show_owner_incident"] == 1) {
echo "<th>";
}
echo __('Owner');
echo "</th>";
echo "</tr>";
echo '</thead>';
echo "<tbody>";
$tasks_in_tickets = incidents_get_filter_tickets_tree($filter, 'tasks');
if ($tasks_in_tickets === false) {
$tasks_in_tickets = array();
}
$i = 0;
$tickets_str = '';
$add_no_project = false;
foreach ($tasks_in_tickets as $task_ticket) {
if ($i == 0) {
$tickets_str = $task_ticket['id_task'];
} else {
$tickets_str .= ',' . $task_ticket['id_task'];
}
if ($task_ticket['id_task'] == 0) {
$add_no_project = true;
}
$i++;
}
if (!empty($tasks_in_tickets)) {
$sql = "SELECT t1.name as n_task, t2.name as n_project, t1.id as id_task FROM ttask t1, tproject t2\n\t\t\tWHERE t1.id_project=t2.id AND t1.id IN ({$tickets_str})\n\t\t\tORDER BY t2.name";
$tickets = get_db_all_rows_sql($sql);
} else {
$tickets = false;
}
if ($tickets === false) {
$tickets = array();
}
if ($add_no_project) {
$tickets[$i]['id_task'] = 0;
$tickets[$i]['n_project'] = __('No associated project');
}
foreach ($tickets as $task_ticket) {
$task = get_db_row('ttask', 'id', $task_ticket['id_task']);
$img = print_image("images/input_create.png", true, array("style" => 'vertical-align: middle;', "id" => $img_id));
$img_task = print_image("images/task.png", true, array("style" => 'vertical-align: middle;'));
//tickets in task
$filter['id_task'] = $task_ticket['id_task'];
$tickets_in_task = incidents_get_filter_tickets_tree($filter, 'tickets');
$count_tickets = count($tickets_in_task);
//print ticket with task
if ($task_ticket['id_task'] != 0) {
$project_name = $task_ticket['n_project'] . ' - ' . $task_ticket['n_task'];
} else {
$project_name = $task_ticket['n_project'];
}
//print project-task
echo '<tr><td colspan="10" valign="top">';
echo "\n\t\t<a onfocus='JavaScript: this.blur()' href='javascript: check_rows(\"" . $task_ticket['id_task'] . "\")'>" . $img . " " . $img_task . " " . safe_output($project_name) . " " . "({$count_tickets})" . "</a>" . " ";
echo '</td></tr>';
foreach ($tickets_in_task as $incident) {
$class = $task_ticket['id_task'] . "-task";
$tr_status = 'class="' . $class . '"';
if ($incident["estado"] < 3) {
$tr_status = 'class="red_row ' . $class . '"';
} elseif ($incident["estado"] < 6) {
$tr_status = 'class="yellow_row ' . $class . '"';
} else {
$tr_status = 'class="green_row ' . $class . '"';
}
echo '<tr ' . $tr_status . ' id="incident-' . $incident['id_incidencia'] . '"';
echo " style='border-bottom: 1px solid #ccc;' >";
echo '<td>';
print_checkbox_extended('incidentcb-' . $incident['id_incidencia'], $incident['id_incidencia'], false, '', '', 'class="cb_incident"');
echo '</td>';
//Print incident link if not ajax, if ajax link to js funtion to replace parent
$link = "index.php?sec=incidents&sec2=operation/incidents/incident_dashboard_detail&id=" . $incident["id_incidencia"];
if ($ajax) {
$link = "javascript:update_parent('" . $incident["id_incidencia"] . "')";
}
echo '<td>';
echo '<strong><a href="' . $link . '">#' . $incident['id_incidencia'] . '</a></strong></td>';
// SLA Fired ??
if ($incident["affected_sla_id"] != 0) {
echo '<td width="25"><img src="images/exclamation.png" /></td>';
} else {
echo '<td></td>';
}
echo '<td>';
echo '<strong><a href="' . $link . '">' . $incident['titulo'] . '</a></strong><br>';
echo "<span style='font-size:11px;font-style:italic'>";
echo incidents_get_incident_type_text($incident["id_incidencia"]);
// Added by slerena 26Ago2013
$sql = sprintf("SELECT *\n\t\t\t\t\t\t\tFROM tincident_type_field\n\t\t\t\t\t\t\tWHERE id_incident_type = %d", $incident["id_incident_type"]);
$config['mysql_result_type'] = MYSQL_ASSOC;
$type_fields = get_db_all_rows_sql($sql);
$type_fields_values_text = "";
if ($type_fields) {
foreach ($type_fields as $type_field) {
if ($type_field["show_in_list"]) {
$field_data = get_db_value_filter("data", "tincident_field_data", array("id_incident" => $incident["id_incidencia"], "id_incident_field" => $type_field["id"]));
if ($field_data) {
if ($type_field["type"] == "textarea") {
$field_data = "<div style='display: inline-block;' title='{$field_data}'>" . substr($field_data, 0, 15) . "...</div>";
}
$type_fields_values_text .= " <div title='" . $type_field["label"] . "' style='display: inline-block;'>[{$field_data}]</div>";
}
}
}
}
echo " {$type_fields_values_text}";
echo '</span></td>';
echo '<td>' . get_db_value("nombre", "tgrupo", "id_grupo", $incident['id_grupo']);
if ($config["show_creator_incident"] == 1) {
$id_creator_company = get_db_value("id_company", "tusuario", "id_usuario", $incident["id_creator"]);
if ($id_creator_company != 0) {
$company_name = (string) get_db_value('name', 'tcompany', 'id', $id_creator_company);
echo "<br><span style='font-size:11px;font-style:italic'>{$company_name}</span>";
}
}
echo '</td>';
$resolution = isset($resolutions[$incident['resolution']]) ? $resolutions[$incident['resolution']] : __('None');
echo '<td class="f9"><strong>' . $statuses[$incident['estado']] . '</strong><br /><em>' . $resolution . '</em></td>';
// priority
echo '<td>';
print_priority_flag_image($incident['prioridad']);
$last_wu = get_incident_lastworkunit($incident["id_incidencia"]);
if ($last_wu["id_user"] == $incident["id_creator"]) {
echo "<br><img src='images/comment.gif' title='" . $last_wu["id_user"] . "'>";
}
echo '</td>';
echo '<td style="font-size:11px;">' . human_time_comparation($incident["actualizacion"]);
// Show only if it's different
if ($incident["inicio"] != $incident["actualizacion"]) {
echo "<br><em>[" . human_time_comparation($incident["inicio"]);
echo "]</em>";
}
echo "<br>";
echo '<span style="font-size:9px;">';
if (isset($config["show_user_name"]) && $config["show_user_name"]) {
$updated_by = get_db_value('nombre_real', 'tusuario', 'id_usuario', $last_wu["id_user"]);
} else {
$updated_by = $last_wu["id_user"];
}
//~ echo $last_wu["id_user"];
echo $updated_by;
echo "</span>";
echo '</td>';
if ($config["show_creator_incident"] == 1) {
echo "<td class='f9'>";
$incident_creator = $incident["id_creator"];
echo substr($incident_creator, 0, 12);
echo "</td>";
}
if ($config["show_owner_incident"] == 1) {
echo "<td class='f9'>";
$incident_owner = $incident["id_usuario"];
echo substr($incident_owner, 0, 12);
echo "</td>";
}
echo '</tr>';
}
}
echo '</tbody>';
echo '</table>';
}
} else {
$completion = format_numeric (calculate_project_progress ($project['id']));
$data[2] = progress_bar($completion, 90, 20);
}
// Last update time
$sql = sprintf ('SELECT tworkunit.timestamp
FROM ttask, tworkunit_task, tworkunit
WHERE ttask.id_project = %d
AND ttask.id = tworkunit_task.id_task
AND tworkunit_task.id_workunit = tworkunit.id
ORDER BY tworkunit.timestamp DESC LIMIT 1',
$project['id']);
$timestamp = get_db_sql ($sql);
if ($timestamp != "")
$data[3] = "<span style='font-size: 10px'>".human_time_comparation ($timestamp)."</span>";
else
$data[3] = __('Never');
$offset = 0;
$data[4] = '';
// Disable or delete
if ($project['id'] != -1 && $project_permission['manage']) {
$table->head[4] = __('Delete/Unarchive');
$data[4] = "<a href='#' onClick='javascript: show_validation_delete_general(\"delete_project\",".$project['id'].",0,".$offset.",\"".$search_params."\");'><img src='images/icons/icono_papelera.png' title='".__('Delete')."'></a>";
$data[4] .= '<a href="index.php?sec=projects&sec2=operation/projects/project&view_disabled=1&activate_project=1&id='.$project['id'].'">
<img src="images/upload.png" /></a>';
}
array_push ($table->data, $data);
}
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;
}
$incident_detail .= "<td style='text-align:right;'>".give_human_time($stats[INCIDENT_METRIC_TOTAL_TIME_NO_THIRD],true,true,true)."</td>";
$incident_detail .= "</tr>";
//$incident_detail .= "</table>";
echo print_container('incident_tracking_detail', __('General statistics'), $incident_detail, 'open', true, '20px', '', '', 1, 'less_widht');
echo "</td>";
echo "<td style='vertical-align:top; width: 33%;'>";
$workunit_count = get_incident_count_workunits ($id);
//$workunit_detail = "<table class='details_table alternate'>";
if ($workunit_count) {
$work_hours = get_incident_workunit_hours ($id);
$workunits = get_incident_workunits ($id);
$workunit_data = get_workunit_data ($workunits[0]['id_workunit']);
$workunit_detail = "<tr>";
$workunit_detail .= "<td><strong>".__("Last work at")."</strong>:</td>";
$workunit_detail .= "<td style='text-align:right;'>".human_time_comparation ($workunit_data['timestamp'])."</td>";
$workunit_detail .= "</tr>";
$workunit_detail .= "<tr>";
$workunit_detail .= "<td><strong>".__("Workunits")."</strong>:</td>";
$workunit_detail .= "<td style='text-align:right;'>".$workunit_count."</td>";
$workunit_detail .= "</tr>";
$workunit_detail .= "<tr>";
$workunit_detail .= "<td><strong>".__("Time used")."</strong>:</td>";
$workunit_detail .= "<td style='text-align:right;'>".give_human_time($work_hours*SECONDS_1HOUR,true,true,true)."</td>";
$workunit_detail .= "</tr>";
$workunit_detail .= "<tr>";
$workunit_detail .= "<td><strong>".__("Reported by")."</strong>:</td>";
$name = get_db_value ('nombre_real', 'tusuario', 'id_usuario', $workunit_data['id_user']);
$workunit_detail .= "<td style='text-align:right;'>".$name."</td>";
$workunit_detail .= "</tr>";
} else {
$nivel = "<img src='images/user_gray.png' title='" . __("External user") . "'>";
}
$disabled = $rowdup["disabled"];
$id_company = $rowdup["id_company"];
echo "<tr><td>";
echo print_checkbox_extended("user-" . $rowdup["id_usuario"], $rowdup["id_usuario"], false, false, "", "class='user_checkbox'", true);
echo "<td>";
if ($disabled == 1) {
echo "<img src='images/lightbulb_off.png' title='" . __("Disabled") . "'> ";
}
echo "<td>";
echo "<a href='index.php?sec=users&sec2=godmode/usuarios/configurar_usuarios&update_user="******"'>" . ucfirst($nombre) . "</a>";
echo "<td style='font-size:9px'>" . $realname;
$company_name = (string) get_db_value('name', 'tcompany', 'id', $id_company);
echo "<td>" . $company_name . "</td>";
echo "<td style='font-size:9px'>" . human_time_comparation($fecha_registro);
echo "<td>";
print_user_avatar($nombre, true);
echo " ";
if ($config["enteprise"] == 1) {
$sql1 = 'SELECT * FROM tusuario_perfil WHERE id_usuario = "' . $nombre . '"';
$result = mysql_query($sql1);
echo "<a href='#' class='tip'> <span>";
if (mysql_num_rows($result)) {
while ($row = mysql_fetch_array($result)) {
echo dame_perfil($row["id_perfil"]) . "/ ";
echo dame_grupo($row["id_grupo"]) . "<br>";
}
} else {
echo __('This user doesn\'t have any assigned profile/group');
}