$table_advanced->data[1][0] = print_input_hidden('email_notify', 1, true);
}
$parent_name = $id_parent ? __('Ticket') . ' #' . $id_parent : __('None');
if ($has_im) {
$table_advanced->data[3][0] = print_input_text('search_parent', $parent_name, '', 10, 100, true, __('Parent ticket'), $blocked_incident);
$table_advanced->data[3][0] .= print_input_hidden('id_parent', $id_parent, true);
if (!$blocked_incident) {
$table_advanced->data[3][0] .= print_image("images/cross.png", true, array("onclick" => "clean_parent_field()", "style" => "cursor: pointer"));
}
}
// Show link to go parent incident
if ($id_parent) {
$table_advanced->data[3][0] .= ' <a target="_blank" href="index.php?sec=incidents&sec2=operation/incidents/incident_dashboard_detail&id=' . $id_parent . '"><img src="images/go.png" /></a>';
}
// Task
$table_advanced->data[3][1] = combo_task_user_participant($config["id_user"], 0, $id_task, true, __("Task"), false, true, false, '', false, $blocked_incident);
if ($id_task > 0) {
$table_advanced->data[3][1] .= " <a id='task_link' title='" . __('Open this task') . "' target='_blank'\n\t\t\t\t\t\t\thref='index.php?sec=projects&sec2=operation/projects/task_detail&operation=view&id_task={$id_task}'>";
$table_advanced->data[3][1] .= "<img src='images/task.png'></a>";
} else {
$table_advanced->data[3][1] .= " <a id='task_link' title='" . __('Open this task') . "' target='_blank' href='javascript:;'></a>";
}
$table_advanced->data[1][1] = print_input_text('email_copy', $email_copy, "", 70, 500, true, __("Additional email addresses"), $blocked_incident);
if (!$blocked_incident) {
$table_advanced->data[1][1] .= " <a href='javascript: incident_show_contact_search();'>" . print_image('images/add.png', true, array('title' => __('Add'))) . "</a>";
}
if ($create_incident) {
$id_inventory = (int) get_parameter('id_inventory');
$inventories = array();
if ($id_inventory) {
if (!give_acl($config['id_user'], $id_inventory, "VR")) {
$table->data[1][0] = combo_roles (true, 'id_profile', __('Role'), true, true, $id_profile);
//$table->data[0][1] = combo_roles_people_task ($id_task, $config['id_user'], __('Role'));
}
else {
$table->colspan[1][0] = 3;
$table->data[1][0] = combo_user_task_profile ($id_task, 'id_profile',
$id_profile, false, true);
}
// Show task combo if none was given.
if (! $id_task) {
$table->data[0][1] = combo_task_user_participant ($wu_user,
true, 0, true, __('Task'));
}
else {
$table->data[0][1] = combo_task_user_participant ($wu_user,
true, $id_task, true, __('Task'));
}
// Time used
$table->data[2][0] = print_input_text ('duration', $duration, '', 7, 7,
true, __('Time used'));
if (dame_admin ($config['id_user'])) {
$table->colspan[2][1] = 3;
$params = array();
$params['input_id'] = 'text-id_username';
$params['input_name'] = 'id_username';
$params['input_value'] = $wu_user;
$params['title'] = 'Username';
$params['return'] = true;
function form_search_incident($return = false, $filter = false)
{
include_once "functions_user.php";
global $config;
$output = '';
if (!$filter) {
$search_string = (string) get_parameter('search_string');
$status = (int) get_parameter('search_status', -10);
$priority = (int) get_parameter('search_priority', -1);
$resolution = (int) get_parameter('search_resolution', -1);
$id_group = (int) get_parameter('search_id_group');
$id_inventory = (int) get_parameter('search_id_inventory');
$id_company = (int) get_parameter('search_id_company');
$search_id_user = (string) get_parameter('search_id_user');
$search_id_incident_type = (int) get_parameter('search_id_incident_type');
$date_from = (int) get_parameter("search_from_date");
$date_start = (string) get_parameter("search_first_date");
$date_end = (string) get_parameter("search_last_date");
$search_creator = (string) get_parameter('search_id_creator');
$search_editor = (string) get_parameter('search_editor');
$search_closed_by = (string) get_parameter('search_id_creator');
$group_by_project = (bool) get_parameter('search_group_by_project');
$sla_state = (int) get_parameter('search_sla_state', 0);
$id_task = (int) get_parameter('search_id_task', 0);
$left_sla = (int) get_parameter('search_left_sla', 0);
$right_sla = (int) get_parameter('search_right_sla', 0);
$show_hierarchy = (bool) get_parameter('show_hierarchy');
$type_fields = incidents_get_type_fields($search_id_incident_type);
$search_type_field = array();
foreach ($type_fields as $key => $type_field) {
$search_type_field[$type_field['id']] = (string) get_parameter('search_type_field_' . $type_field['id']);
}
} else {
$search_string = (string) $filter['string'];
$priority = (int) $filter['priority'];
$id_group = (int) $filter['id_group'];
$status = (int) $filter['status'];
$resolution = (int) $filter['resolution'];
$id_company = (int) $filter['id_company'];
$id_inventory = (int) $filter['id_inventory'];
$search_id_incident_type = (int) $filter['id_incident_type'];
$search_id_user = (string) $filter['id_user'];
$date_from = (int) $filter['from_date'];
$date_start = (string) $filter['first_date'];
$date_end = (string) $filter['last_date'];
$search_creator = (string) $filter['id_creator'];
$search_editor = (string) $filter['editor'];
$search_closed_by = (string) $filter['closed_by'];
$group_by_project = (bool) $filter['group_by_project'];
$sla_state = (int) $filter['sla_state'];
$id_task = (int) $filter['id_task'];
$left_sla = (int) $filter['left_sla'];
$right_sla = (int) $filter['right_sla'];
$show_hierarchy = (bool) $filter['show_hierarchy'];
$type_fields = incidents_get_type_fields($search_id_incident_type);
$search_type_field = array();
if ($type_fields) {
foreach ($type_fields as $key => $type_field) {
$search_type_field[$type_field['id']] = (string) $filter['type_field_' . $type_field['id']];
}
}
}
/* No action is set, so the form will be sent to the current page */
$table = new stdclass();
$table->width = "99%";
$table->class = "search-table-button";
$table->cellspacing = 2;
$table->cellpadding = 2;
$table->data = array();
$table->size = array();
$table->style = array();
$table->style[0] = 'width: 25%';
$table->style[1] = 'width: 25%';
$table->style[2] = 'width: 25%; vertical-align:text-top;';
$table->style[3] = 'width: 25%';
$table->rowstyle = array();
$table->rowstyle[1] = 'display: none';
$table->rowstyle[2] = 'display: none';
$table->rowstyle[3] = 'display: none';
$table->rowstyle[4] = 'display: none';
$table->rowstyle[5] = 'display: none';
$table->rowstyle[6] = 'text-align: right';
$table->colspan = array();
$table->colspan[0][0] = 2;
$table->colspan[6][0] = 4;
$table->colspan[7][1] = 3;
$table->rowspan = array();
$table->rowspan[2][2] = 2;
$table->data[0][0] = print_input_text('search_string', $search_string, '', 50, 100, true, __('Search string'));
$available_status = get_indicent_status();
$available_status[-10] = __("Not closed");
$table->data[0][1] = print_select($available_status, 'search_status', $status, '', __('Any'), 0, true, false, true, __('Status'));
$groups = users_get_groups_for_select($config['id_user'], "IW", true, true);
$table->data[0][2] = print_select($groups, 'search_id_group', $id_group, '', '', '', true, false, false, __('Group'));
$table->data[0][3] = print_checkbox_extended('search_show_hierarchy', 1, $show_hierarchy, false, '', '', true, __('Show hierarchy'));
$params_owner = array();
$params_owner['input_id'] = 'text-search_id_user';
$params_owner['input_name'] = 'search_id_user';
$params_owner['input_value'] = $search_id_user;
$params_owner['title'] = __('Owner');
$params_owner['return'] = true;
$table->data[1][0] = user_print_autocomplete_input($params_owner);
$params_editor = array();
$params_editor['input_id'] = 'text-search_editor';
$params_editor['input_name'] = 'search_editor';
$params_editor['input_value'] = $search_editor;
$params_editor['title'] = __('Editor');
$params_editor['return'] = true;
$table->data[1][1] = user_print_autocomplete_input($params_editor);
$params_closed_by = array();
$params_closed_by['input_id'] = 'text-search_closed_by';
$params_closed_by['input_name'] = 'search_closed_by';
$params_closed_by['input_value'] = $search_closed_by;
$params_closed_by['title'] = __('Closed by');
$params_closed_by['return'] = true;
$table->data[1][2] = user_print_autocomplete_input($params_closed_by);
$params_creator = array();
$params_creator['input_id'] = 'text-search_id_creator';
$params_creator['input_name'] = 'search_id_creator';
$params_creator['input_value'] = $search_creator;
$params_creator['title'] = __('Creator');
$params_creator['return'] = true;
$table->data[1][3] = user_print_autocomplete_input($params_creator);
$table->data[2][0] = print_select(get_priorities(), 'search_priority', $priority, '', __('Any'), -1, true, false, false, __('Priority'), false);
$table->data[2][1] = print_select(get_incident_resolutions(), 'search_resolution', $resolution, '', __('Any'), -1, true, false, false, __('Resolution'), false);
$table->data[2][2] = get_last_date_control($date_from, 'search_from_date', __('Date'), $date_start, 'search_first_date', __('Created from'), $date_end, 'search_last_date', __('Created to'));
$name = $id_inventory ? get_inventory_name($id_inventory) : '';
$table->data[2][3] = print_input_text('inventory_name', $name, '', 7, 0, true, __('Inventory'), false);
$table->data[2][3] .= " <a href='javascript: show_search_inventory(\"\",\"\",\"\",\"\",\"\",\"\");'>" . print_image('images/zoom.png', true, array('title' => __('Search inventory'))) . "</a>";
$table->data[2][3] .= print_input_hidden('id_inventory', $id_inventory, true);
if (!get_external_user($config["id_user"])) {
$table->data[4][0] = print_select(get_companies(), 'search_id_company', $id_company, '', __('All'), 0, true, false, false, __('Company'));
}
$table->data[4][1] = print_select(get_incident_types(), 'search_id_incident_type', $search_id_incident_type, 'javascript:change_type_fields_table();', __('All'), 0, true, false, false, __('Ticket type'));
$table->data[4][3] = print_checkbox_extended('search_group_by_project', 1, $group_by_project, false, '', '', true, __('Group by project/task'));
$sla_states = array();
$sla_states[1] = __('SLA is fired');
$sla_states[2] = __('SLA is not fired');
$table->data[5][0] = print_select($sla_states, 'search_sla_state', $sla_state, '', __('All'), 0, true, false, false, __('SLA'));
$table->data[5][1] = combo_task_user_participant($config["id_user"], 0, $id_task, true, __("Task"), 'search_id_task');
$table->data[5][2] = print_input_text('search_left_sla', $left_sla, '', 7, 0, true, __('SLA > (%)'), false);
$table->data[5][3] = print_input_text('search_right_sla', $right_sla, '', 7, 0, true, __('SLA < (%)'), false);
$table_type_fields = new stdclass();
$table_type_fields->width = "100%";
$table_type_fields->class = "search-table";
$table_type_fields->data = array();
//Print custom field data
$column = 0;
$row = 0;
if ($type_fields) {
foreach ($type_fields as $key => $type_field) {
$data = $search_type_field[$type_field['id']];
if ($type_field['type'] == "text" || $type_field['type'] == "textarea") {
$input = print_input_text('search_type_field_' . $type_field['id'], $data, '', 30, 30, true, $type_field['label']);
} else {
if ($type_field['type'] == "combo") {
$combo_values = explode(",", $type_field['combo_value']);
$values = array();
foreach ($combo_values as $value) {
$values[$value] = $value;
}
$input = print_select($values, 'search_type_field_' . $type_field['id'], $data, '', __('Any'), '', true, false, false, $type_field['label']);
} else {
if ($type_field['type'] == "linked") {
$linked_values = explode(",", $type_field['linked_value']);
$values = array();
foreach ($linked_values as $value) {
$value_without_parent = preg_replace("/^.*\\|/", "", $value);
$values[$value_without_parent] = $value_without_parent;
$has_childs = get_db_all_rows_sql("SELECT * FROM tincident_type_field WHERE parent=" . $type_field['id']);
if ($has_childs) {
$i = 0;
foreach ($has_childs as $child) {
if ($i == 0) {
$childs = $child['id'];
} else {
$childs .= ',' . $child['id'];
}
$i++;
}
$childs = "'" . $childs . "'";
$script = 'javascript:change_linked_type_fields_table(' . $childs . ',' . $type_field['id'] . ');';
} else {
$script = '';
}
}
$input = print_select($values, 'search_type_field_' . $type_field['id'], $data, $script, __('Any'), '', true, false, false, $type_field['label']);
}
}
}
$table_type_fields->data[$row][$column] = $input;
if ($column >= 3) {
$column = 0;
$row++;
} else {
$column++;
}
}
}
if ($table_type_fields->data) {
$table_type_fields_html = print_table($table_type_fields, true);
}
$table->data[6][0] = "<div id='table_type_fields'>" . $table_type_fields_html . "</div>";
$table->data[7][0] = '<div style="width: 100%; text-align: left; height: 20px;"><a class="show_advanced_search" id="show_advanced_search" href="javascript:show_ad_search();">' . __('Advanced search') . '></a></div>';
//Store serialize filter
serialize_in_temp($filter, $config["id_user"]);
$table->data[7][2] = print_submit_button(__('Search'), 'search', false, 'class="sub search"', true);
$table->data[7][2] .= print_button(__('Export to CSV'), '', false, 'window.open(\'' . 'include/export_csv.php?export_csv_tickets=1' . '\')', 'class="sub csv"', true);
$table->colspan[7][2] = 4;
$output .= '<form id="search_incident_form" method="post" action="index.php?sec=incidents&sec2=operation/incidents/incident_search">';
$output .= print_table($table, true);
$output .= '</form>';
echo "<div class= 'dialog ui-dialog-content' id='search_inventory_window'></div>";
if ($return) {
return $output;
}
echo $output;
}
$table_advanced->data[3][0] = print_input_text ('search_parent', $parent_name, '', 10, 100, true, __('Parent ticket'), $blocked_incident);
$table_advanced->data[3][0] .= print_input_hidden ('id_parent', $id_parent, true);
if (!$blocked_incident) {
$table_advanced->data[3][0] .= " <a href='javascript: parent_search_form(\"\", $id)'>" . print_image('images/add.png', true, array('title' => __('Add'))) . "</a>";
$table_advanced->data[3][0] .= print_image("images/cross.png", true, array("onclick" => "clean_parent_field()", "style" => "cursor: pointer"));
}
}
// Show link to go parent incident
if ($id_parent)
$table_advanced->data[3][0] .= ' <a target="_blank" href="index.php?sec=incidents&sec2=operation/incidents/incident_dashboard_detail&id='.$id_parent.'"><img src="images/go.png" /></a>';
// Task
$table_advanced->data[3][1] = combo_task_user_participant ($config["id_user"], 0, $id_task, true, __("Task").print_help_tip (__("Task of proyect relation with this ticket"), true), false, true, false, '', false, $blocked_incident);
if ($id_task > 0){
$table_advanced->data[3][1] .= " <a id='task_link' title='".__('Open this task')."' target='_blank'
href='index.php?sec=projects&sec2=operation/projects/task_detail&operation=view&id_task=$id_task'>";
$table_advanced->data[3][1] .= "<img src='images/task.png'></a>";
} else {
$table_advanced->data[3][1] .= " <a id='task_link' title='".__('Open this task')."' target='_blank' href='javascript:;'></a>";
}
$table_advanced->data[1][1] = print_input_text ('email_copy', $email_copy,"",70,500, true, __("Additional email addresses") . print_help_tip(__("If you will put two or more e-mail adresses, can you put this adresses separated with comma"),true), $blocked_incident);
if (!$blocked_incident) {
$table_advanced->data[1][1] .= " <a href='javascript: incident_show_contact_search();'>" . print_image('images/add.png', true, array('title' => __('Add'))) . "</a>";
}
$table->colspan = array ();
// Profile or role
if (dame_admin ($config['id_user'])) {
$table->data[0][0] = combo_roles (false, 'id_profile', __('Role'), true, true, '', true);
}
else {
$table->data[0][0] = combo_user_task_profile ($id_task, 'id_profile', $id_profile, false, true, true);
}
// Show task combo if none was given.
if (! $id_task) {
$table->data[0][1] = combo_task_user_participant ($config['id_user'], true, 0, true, __('Task'), false, false, false, '', true);
}
else {
$table->data[0][1] = combo_task_user_participant ($config['id_user'], true, $id_task, true, __('Task'), false, false, false, true);
}
// Various checkboxes
$have_cost = 0;
$keep_cost = 0;
$public = 0;
$keep_public = 0;
$table->data[2][0] = print_checkbox ('have_cost', 1, $have_cost, true, __('Have cost'));
$table->data[2][1] = print_checkbox ('keep_cost', 1, $keep_cost, true, __('Keep cost'));
$table->data[3][0] = print_checkbox ('public', 1, $public, true, __('Public'));
$table->data[3][1] = print_checkbox ('keep_public', 1, $keep_public, true, __('Keep public'));
$table->data[2][1] .= print_input_hidden ("assigned_user", $assigned_user, true);
} else {
$params['input_id'] = 'text-user';
$params['input_name'] = 'assigned_user';
$params['input_size'] = 30;
$params['input_maxlength'] = 100;
$params['input_value'] = $assigned_user;
$params['title'] = 'Assigned user';
$params['return'] = true;
$params['return_help'] = true;
$table->data[2][1] = user_print_autocomplete_input($params);
}
$table->data[3][0] = combo_task_user_participant ($config["id_user"], false, $id_task, true, __('Task'));
if ($id_task) {
$table->data[3][0] .= " <a id='task_link' title='".__('Open this task')."' target='_blank'href='
index.php?sec=projects&sec2=operation/projects/task_detail&operation=view&id_task=$id_task'>";
$table->data[3][0] .= "<img src='images/task.png'></a>";
} else {
$table->data[3][0] .= " <a id='task_link' title='".__('Open this task')."' target='_blank' href='javascript:;'></a>";
}
// Remove validated user if current user is not the creator OR this doesnt need to be validated
if (($creator != $config["id_user"]) OR ($need_external_validation == 0))
$wo_status_values = wo_status_array (1);
else
$wo_status_values = wo_status_array (0);
function form_search_incident($return = false, $filter = false, $ajax = 0)
{
include_once "functions_user.php";
global $config;
$output = '';
if (!$filter) {
$inverse_filter = (bool) get_parameter('search_inverse_filter');
$search_string = (string) get_parameter('search_string');
$status = (int) get_parameter('search_status', -10);
$priority = (int) get_parameter('search_priority', -1);
$resolution = (int) get_parameter('search_resolution', -1);
$id_group = (int) get_parameter('search_id_group');
$id_inventory = (int) get_parameter('search_id_inventory');
$id_company = (int) get_parameter('search_id_company');
$search_id_user = (string) get_parameter('search_id_user');
$search_id_incident_type = (int) get_parameter('search_id_incident_type');
$date_from = (int) get_parameter("search_from_date");
$date_start = (string) get_parameter("search_first_date");
$date_end = (string) get_parameter("search_last_date");
$search_creator = (string) get_parameter('search_id_creator');
$search_editor = (string) get_parameter('search_editor');
$search_closed_by = (string) get_parameter('search_closed_by');
$group_by_project = (bool) get_parameter('search_group_by_project');
$sla_state = (int) get_parameter('search_sla_state', 0);
$id_task = (int) get_parameter('search_id_task', 0);
$left_sla = (int) get_parameter('search_left_sla', 0);
$right_sla = (int) get_parameter('search_right_sla', 0);
$show_hierarchy = (bool) get_parameter('search_show_hierarchy');
$search_medal = get_parameter('search_medals');
$name = get_parameter('parent_name');
$type_fields = incidents_get_type_fields($search_id_incident_type);
$search_type_field = array();
foreach ($type_fields as $key => $type_field) {
$search_type_field[$type_field['id']] = (string) get_parameter('search_type_field_' . $type_field['id']);
}
} else {
$inverse_filter = (bool) $filter['inverse_filter'];
$search_string = (string) $filter['string'];
$priority = (int) $filter['priority'];
$id_group = (int) $filter['id_group'];
$status = (int) $filter['status'];
$resolution = (int) $filter['resolution'];
$id_company = (int) $filter['id_company'];
$id_inventory = (int) $filter['id_inventory'];
$search_id_incident_type = (int) $filter['id_incident_type'];
$search_id_user = (string) $filter['id_user'];
$date_from = (int) $filter['from_date'];
$date_start = (string) $filter['first_date'];
$date_end = (string) $filter['last_date'];
$search_creator = (string) $filter['id_creator'];
$search_editor = (string) $filter['editor'];
$search_closed_by = (string) $filter['closed_by'];
$group_by_project = (bool) $filter['group_by_project'];
$sla_state = (int) $filter['sla_state'];
$id_task = (int) $filter['id_task'];
$left_sla = (int) $filter['left_sla'];
$right_sla = (int) $filter['right_sla'];
$show_hierarchy = (bool) $filter['show_hierarchy'];
$search_medal = (int) $filter['medals'];
$name = (string) $filter['parent_name'];
//This is inventory obj name value !!!
$type_fields = incidents_get_type_fields($search_id_incident_type);
$search_type_field = array();
if ($type_fields) {
foreach ($type_fields as $key => $type_field) {
$search_type_field[$type_field['id']] = (string) $filter['type_field_' . $type_field['id']];
}
}
}
/* No action is set, so the form will be sent to the current page */
$table = new stdclass();
$table->width = "100%";
$table->class = "search-table-button";
$table->data = array();
// Filter text
$table->data[0][0] = print_input_text('search_string', $search_string, '', 30, 100, true, __('Text filter'));
// Status
$available_status = get_indicent_status();
$available_status[-10] = __("Not closed");
$table->data[0][1] = print_select($available_status, 'search_status', $status, '', __('Any'), 0, true, false, true, __('Status'));
// Groups
$groups = users_get_groups_for_select($config['id_user'], "IW", true, true);
$table->data[0][2] = print_select($groups, 'search_id_group', $id_group, '', '', '', true, false, false, __('Group'));
// Check Box
$table->data[0][3] = print_checkbox_extended('search_show_hierarchy', 1, $show_hierarchy, false, '', '', true, __('Show hierarchy'));
$table_advanced = new stdclass();
$table_advanced->width = "100%";
$table_advanced->class = "search-table-button";
$params_owner = array();
$params_owner['input_id'] = 'text-search_id_user';
$params_owner['input_name'] = 'search_id_user';
$params_owner['input_value'] = $search_id_user;
$params_owner['title'] = __('Owner');
$params_owner['attributes'] = 'style="width: 210px;"';
$params_owner['return'] = true;
$table_advanced->data[1][0] = user_print_autocomplete_input($params_owner);
$params_editor = array();
$params_editor['input_id'] = 'text-search_editor';
$params_editor['input_name'] = 'search_editor';
$params_editor['input_value'] = $search_editor;
$params_editor['title'] = __('Editor');
$params_editor['attributes'] = 'style="width: 210px;"';
$params_editor['return'] = true;
$table_advanced->data[1][1] = user_print_autocomplete_input($params_editor);
$params_closed_by = array();
$params_closed_by['input_id'] = 'text-search_closed_by';
$params_closed_by['input_name'] = 'search_closed_by';
$params_closed_by['input_value'] = $search_closed_by;
$params_closed_by['title'] = __('Closed by');
$params_closed_by['attributes'] = 'style="width: 210px;"';
$params_closed_by['return'] = true;
$table_advanced->data[1][2] = user_print_autocomplete_input($params_closed_by);
$params_creator = array();
$params_creator['input_id'] = 'text-search_id_creator';
$params_creator['input_name'] = 'search_id_creator';
$params_creator['input_value'] = $search_creator;
$params_creator['title'] = __('Creator');
$params_creator['attributes'] = 'style="width: 210px;"';
$params_creator['return'] = true;
$table_advanced->data[1][3] = user_print_autocomplete_input($params_creator);
$table_advanced->data[2][0] = print_select(get_priorities(), 'search_priority', $priority, '', __('Any'), -1, true, false, false, __('Priority'), false);
$table_advanced->data[2][1] = print_select(get_incident_resolutions(), 'search_resolution', $resolution, '', __('Any'), -1, true, false, false, __('Resolution'), false);
//$name = $id_inventory ? get_inventory_name ($id_inventory) : '';
//Parent name
$table_advanced->data[2][2] = print_input_text_extended("parent_name", $name, "text-parent_name", '', 20, 0, false, "", "class='inventory_obj_search' style='width:165px !important;'", true, false, __('Inventory object'), false, true);
$table_advanced->data[2][2] .= " " . print_image("images/add.png", true, array("onclick" => "show_inventory_search('','','','','','','','','','', '', '')", "style" => "cursor: pointer"));
$table_advanced->data[2][2] .= " " . print_image("images/cross.png", true, array("onclick" => "cleanParentInventory()", "style" => "cursor: pointer"));
$table_advanced->data[2][2] .= print_input_hidden('id_parent', $id_inventory, true);
$table_advanced->data[2][3] = get_last_date_control($date_from, 'search_from_date', __('Date'), $date_start, 'search_first_date', __('Created from'), $date_end, 'search_last_date', __('Created to'));
$table_advanced->rowspan[2][3] = 2;
$table_advanced->cellstyle[2][3] = "vertical-align:top;";
if (!get_standalone_user($config["id_user"])) {
$table_advanced->data[4][0] = print_select(get_companies(), 'search_id_company', $id_company, '', __('Any'), 0, true, false, false, __('Company'));
}
$table_advanced->data[4][1] = print_select(get_incident_types(), 'search_id_incident_type', $search_id_incident_type, 'javascript:change_type_fields_table(\'' . __('Custom field') . '\');', __('Any'), 0, true, false, false, __('Ticket type'));
$table_advanced->data[4][3] = print_checkbox_extended('search_group_by_project', 1, $group_by_project, false, '', '', true, __('Group by project/task'));
$sla_states = array();
$sla_states[1] = __('SLA is fired');
$sla_states[2] = __('SLA is not fired');
$table_advanced->data[5][0] = print_select($sla_states, 'search_sla_state', $sla_state, '', __('Any'), 0, true, false, false, __('SLA'));
$table_advanced->data[5][1] = combo_task_user_participant($config["id_user"], 0, $id_task, true, __("Task"), 'search_id_task');
$table_advanced->data[5][2] = "<div>";
$table_advanced->data[5][2] .= "<div style='display: inline-block;'>" . print_input_text('search_left_sla', $left_sla, '', 8, 0, true, __('SLA > (%)'), false) . "</div>";
$table_advanced->data[5][2] .= " <div style='display: inline-block;'>" . print_input_text('search_right_sla', $right_sla, '', 8, 0, true, __('SLA < (%)'), false) . "</div>";
$table_advanced->data[5][2] .= "</div>";
$medals = array();
$medals[1] = __('Gold medals');
$medals[2] = __('Black medals');
$table_advanced->data[5][3] = print_select($medals, 'search_medals', $search_medal, '', __('Any'), 0, true, false, false, __('Medals'));
$table_type_fields = new StdClass();
$table_type_fields->width = "100%";
$table_type_fields->class = "search-table";
$table_type_fields->data = array();
$table_type_fields->align[0] = 'left';
//Print custom field data
$column = 0;
$row = 0;
if ($type_fields) {
foreach ($type_fields as $key => $type_field) {
$data = $search_type_field[$type_field['id']];
switch ($type_field['type']) {
case "text":
$input = print_input_text('search_type_field_' . $type_field['id'], $data, '', 30, 30, true, $type_field['label']);
break;
case "combo":
$combo_values = explode(",", $type_field['combo_value']);
$values = array();
foreach ($combo_values as $value) {
$values[$value] = $value;
}
$input = print_select($values, 'search_type_field_' . $type_field['id'], $data, '', __('Any'), '', true, false, false, $type_field['label']);
break;
case "linked":
$linked_values = explode(",", $type_field['linked_value']);
$values = array();
foreach ($linked_values as $value) {
$value_without_parent = preg_replace("/^.*\\|/", "", $value);
$values[$value_without_parent] = $value_without_parent;
$has_childs = get_db_all_rows_sql("SELECT * FROM tincident_type_field WHERE parent=" . $type_field['id']);
if ($has_childs) {
$i = 0;
foreach ($has_childs as $child) {
if ($i == 0) {
$childs = $child['id'];
} else {
$childs .= ',' . $child['id'];
}
$i++;
}
$childs = "'" . $childs . "'";
$script = 'javascript:change_linked_type_fields_table(' . $childs . ',' . $type_field['id'] . ');';
} else {
$script = '';
}
}
$input = print_select($values, 'search_type_field_' . $type_field['id'], $data, $script, __('Any'), '', true, false, false, $type_field['label']);
break;
case "numeric":
$input = print_input_number('search_type_field_' . $type_field['id'], $data, 1, 1000000, '', true, $type_field['label']);
break;
case "date":
$input = print_input_date('search_type_field_' . $type_field['id'], $data, '', '', '', true, $type_field['label']);
break;
case "textarea":
$input = print_input_text('search_type_field_' . $type_field['id'], $data, '', 30, 30, true, $type_field['label']);
break;
}
$table_type_fields->data[$row][$column] = $input;
if ($column >= 3) {
$column = 0;
$row++;
} else {
$column++;
}
}
}
$table_advanced->colspan[6][0] = 4;
if ($table_type_fields->data) {
$table_type_fields_html = print_table($table_type_fields, true);
}
if (!isset($table_type_fields_html)) {
$table_type_fields_html = '';
}
$table_advanced->data[6][0] = "<div id='table_type_fields'>" . $table_type_fields_html . "</div>";
$table->colspan['row_advanced'][0] = 5;
$table->data['row_advanced'][0] = print_container_div('advanced_parameters_incidents_search', __('Advanced filter'), print_table($table_advanced, true), 'closed', true, true);
//Store serialize filter
serialize_in_temp($filter, $config["id_user"]);
$table->colspan['button'][0] = 2;
$table->colspan['button'][2] = 2;
$table->data['button'][0] = '</br>';
$table->data['button'][2] = print_submit_button(__('Filter'), 'search', false, 'class="sub search"', true);
$table->data['button'][2] .= print_input_hidden('search_inverse_filter', (int) $inverse_filter, true);
$table->data['button'][2] .= print_submit_button(__('Inverse filter'), 'submit_inverse_filter', false, 'class="sub search"', true);
$table->data['button'][2] .= print_button(__('Export to CSV'), '', false, 'window.open(\'' . 'include/export_csv.php?export_csv_tickets=1' . '\')', 'class="sub"', true);
// Inverse filter info
$output .= '<div id="inverse_filter_info" style="display: ' . ($inverse_filter ? 'block' : 'none') . ';">';
$output .= ui_print_message(__('Inverse filter enabled'), 'suc', 'style="display:inline;padding-top: 15px;padding-bottom: 15px;"', true, 'h3', false);
$output .= print_help_tip(__('The result will be the items which doesn\'t match the filters') . '. ' . __('The select controls with \'Any\' or \'All\' selected will be ignored'), true);
$output .= '<br /><br />';
$output .= '</div>';
if ($ajax) {
$output .= '<form id="search_incident_form" method="post">';
} else {
$output .= '<form id="search_incident_form" method="post" onsubmit="incidents_gift();return false">';
}
//~ $output .= '<form id="search_incident_form" method="post">';
$output .= '<div class="divresult_incidents">' . print_table($table, true) . '</div>';
$output .= '</form>';
echo "<div class= 'dialog ui-dialog-content' id='search_inventory_window'></div>";
// WARNING: Important for the inverse filter feature
// Change the search_inverse_filter value when the form is submitted using the submit_inverse_filter or the search buttons
// Show or hide the inverse filter info
$output .= '<script type="text/javascript">';
$output .= '$(document).ready(function () {';
$output .= 'var inverseFilterInfo = document.getElementById("inverse_filter_info");';
$output .= 'var filterForm = document.getElementById("search_incident_form");';
$output .= 'var filterBtn = filterForm.elements["search"];';
$output .= 'var inverseFilterBtn = filterForm.elements["submit_inverse_filter"];';
$output .= 'var inverseFilter = filterForm.elements["search_inverse_filter"];';
$output .= '$(filterBtn).click(function (e) {';
$output .= 'inverseFilter.value = 0;';
$output .= '$(inverseFilterInfo).hide();';
$output .= '});';
$output .= '$(inverseFilterBtn).click(function (e) {';
$output .= 'inverseFilter.value = 1;';
$output .= '$(inverseFilterInfo).show();';
$output .= '});';
$output .= '});';
$output .= '</script>';
if ($return) {
return $output;
}
echo $output;
}
function workunits_print_table_massive_edition($id_task = 0, $id_profile = 0)
{
global $config;
echo '<br><h2>' . __('Massive operations over selected items') . '</h2>';
$table = new StdClass();
$table->class = 'search-table-button';
$table->width = '99%';
$table->data = array();
$table->colspan = array();
// Profile or role
if (dame_admin($config['id_user'])) {
$table->data[0][0] = combo_roles(false, 'id_profile', __('Role'), true, true, '', true);
} else {
$table->data[0][0] = combo_user_task_profile($id_task, 'id_profile', $id_profile, false, true, true);
}
// Show task combo if none was given.
if (!$id_task) {
$table->data[0][1] = combo_task_user_participant($config['id_user'], true, 0, true, __('Task'), false, false, false, '', true);
} else {
$table->data[0][1] = combo_task_user_participant($config['id_user'], true, $id_task, true, __('Task'), false, false, false, true);
}
// Various checkboxes
$table->data[2][0] = print_checkbox('have_cost', 1, '', true, __('Have cost'));
$table->data[2][1] = print_checkbox('keep_cost', 1, '', true, __('Keep cost'));
$table->data[3][0] = print_checkbox('public', 1, '', true, __('Public'));
$table->data[3][1] = print_checkbox('keep_public', 1, '', true, __('Keep public'));
$table->colspan[5][0] = 2;
$table->data[5][0] = print_submit_button(__('Update'), 'update_btn', false, 'class="sub upd"', true);
$table->data[5][0] .= print_submit_button(__('Delete'), 'delete_btn', false, 'class="sub delete"', true);
print_table($table);
}
