$permission = give_acl($config["id_user"], 0, "IM");
if (!$permission) {
exit;
}
$where_clause = clean_output(get_parameter('where_clause'));
$date = get_parameter('date');
$filename = clean_output('audit_export') . '-' . date("YmdHi");
$sql = sprintf('SELECT * FROM tsesion %s ORDER by utimestamp DESC', $where_clause);
$rows = get_db_all_rows_sql($sql);
if ($rows === false) {
return;
}
}
if ($export_csv_tickets) {
$filter = unserialize_in_temp($config["id_user"]);
$rows = incidents_search_result($filter, false, true, false, false, true, false, true);
if ($rows === false) {
return;
}
$filename = clean_output('tickets_export') . '-' . date("YmdHi");
}
if (empty($rows)) {
die(__('Empty data'));
}
$csv_lines = array();
$search = array();
// Delete \r !!!
$search[] = "
";
$search[] = "\r";
// Delete \n !!!
$search[] = "
";
$filter['sla_fired'] = (bool) get_parameter('search_sla_fired');
$filter['id_incident_type'] = (int) get_parameter('search_id_incident_type');
$filter['id_user'] = (string) get_parameter('search_id_user', '');
$filter['id_incident_type'] = (int) get_parameter('search_id_incident_type');
$filter['id_user'] = (string) get_parameter('search_id_user', '');
$filter['first_date'] = (string) get_parameter('search_first_date');
$filter['last_date'] = (string) get_parameter('search_last_date');
$filter['sla_state'] = (string) get_parameter('search_sla_state');
$filter['id_task'] = (int) get_parameter('search_id_task');
$filter['left_sla'] = (int) get_parameter('search_left_sla');
$filter['right_sla'] = (int) get_parameter('search_right_left');
$ajax = get_parameter("ajax");
$filter_form = false;
form_search_incident(false, $filter_form);
$no_parents = true;
incidents_search_result($filter, $ajax, false, false, $no_parents, false, false, false, $id_ticket);
}
if ($get_user_search) {
$filter = array();
$filter['offset'] = get_parameter("offset", 0);
$filter['search_text'] = get_parameter("search_text", "");
$filter['disabled_user'] = get_parameter("disabled_user", -1);
$filter['level'] = get_parameter("level", -10);
$filter['group'] = get_parameter("group", 0);
$ajax = get_parameter("ajax");
$filter_form = false;
form_search_users(false, $filter_form);
user_search_result($filter, $ajax, $size_page = $config["block_size"], $offset = $filter['offset'], $clickin);
}
if ($get_incident_name) {
$id = get_parameter("id");
$filter['resolution'] = (int) get_parameter('search_resolution', -1);
$filter["offset"] = (int) get_parameter('offset');
$filter['group_by_project'] = (bool) get_parameter('search_group_by_project');
$filter['sla_state'] = (string) get_parameter('search_sla_state');
$filter['id_task'] = (int) get_parameter('search_id_task');
$filter['left_sla'] = (int) get_parameter('search_left_sla');
$filter['right_sla'] = (int) get_parameter('search_right_left');
$filter['show_hierarchy'] = (bool) get_parameter('search_show_hierarchy');
$filter['parent_name'] = get_parameter('parent_name');
$filter['serial_number'] = (string) get_parameter('search_serial_number');
$filter['search_from_date'] = (int) get_parameter("search_from_date");
//$filter['id_product'] = (int) get_parameter ('search_id_product');
$filter['medals'] = (int) get_parameter('search_medals');
//custom fields
$type_fields = incidents_get_type_fields($filter['id_incident_type']);
foreach ($type_fields as $key => $type_field) {
$filter['type_field_' . $type_field['id']] = (string) get_parameter('search_type_field_' . $type_field['id']);
}
//Store serialize filter
serialize_in_temp($filter, $config["id_user"]);
$ajax = get_parameter("ajax", "");
if ($ajax) {
$filter_form = false;
echo "<div style='float:right; width:99%'>";
form_search_incident(false, $filter_form, $ajax);
echo "</div>";
}
incidents_search_result($filter, $ajax, false, true);
//incidents_search_result($filter, $ajax, false, false, $no_parents, false, false, false, $id_ticket);
return;
}
$filter['sla_fired'] = (bool) get_parameter('search_sla_fired');
$filter['id_incident_type'] = (int) get_parameter('search_id_incident_type');
$filter['id_user'] = (string) get_parameter('search_id_user', '');
$filter['id_incident_type'] = (int) get_parameter('search_id_incident_type');
$filter['id_user'] = (string) get_parameter('search_id_user', '');
$filter['first_date'] = (string) get_parameter('search_first_date');
$filter['last_date'] = (string) get_parameter('search_last_date');
$filter['sla_state'] = (string) get_parameter('search_sla_state');
$filter['id_task'] = (int) get_parameter('search_id_task');
$filter['left_sla'] = (int) get_parameter('search_left_sla');
$filter['right_sla'] = (int) get_parameter('search_right_left');
$ajax = get_parameter("ajax");
$filter_form = false;
form_search_incident(false, $filter_form);
$no_parents = true;
incidents_search_result($filter, $ajax, false, false, $no_parents);
}
if ($get_incident_name) {
$id = get_parameter("id");
$name = get_db_value("titulo", "tincidencia", "id_incidencia", $id);
echo $name;
}
if ($get_contact_search) {
include_once "include/functions_crm.php";
$read = enterprise_hook('crm_check_user_profile', array($config['id_user'], 'cr'));
if ($read !== ENTERPRISE_NOT_HOOK) {
$enterprise = true;
}
if (!$read) {
include "general/noaccess.php";
exit;
