top.window.location = '../../index.php'";
exit;
}
require_once __DIR__ . "/" . "../../includes/include_basics_only.php";
require_once __DIR__ . "/" . "../../includes/classes/ConnectPDO.php";
require_once __DIR__ . "/" . "../../includes/classes/worktime/Worktime.php";
include_once __DIR__ . "/" . "../../includes/functions/getWorktimeProfile.php";
require_once __DIR__ . "/" . "../../includes/components/html2text-master/vendor/autoload.php";
$auth = new AuthNew($_SESSION['s_logado'], $_SESSION['s_nivel'], 2, 1);
use includes\classes\ConnectPDO;
$conn = ConnectPDO::getInstance();
$isAdmin = $_SESSION['s_nivel'] == 1;
$imgsPath = "../../includes/imgs/";
$iconFrozen = "";
$iconOutOfWorktime = "";
$iconTicketClosed = "";
$config = getConfig($conn);
$percLimit = $config['conf_sla_tolerance'];
$costField = $config['tickets_cost_field'];
$doneStatus = $config['conf_status_done'];
$daysToApprove = $config['conf_time_to_close_after_done'];
$onlyBusinessDays = ($config['conf_only_weekdays_to_count_after_done'] ? true : false);
$hoje_start = date('Y-m-d 00:00:00');
$hoje_end = date('Y-m-d 23:59:59');
$mes_start = date('Y-m-01 00:00:00');
$hoje = date('Y-m-d H:i:s');
$post = $_POST;
$hasParam = false;
$ignoreStatus = true;
$dashboardTerms = [];
// $render_custom_fields = 1;
$render_custom_fields = (isset($post['render_custom_fields']) ? $post['render_custom_fields']: 1);
// $hidden_columns = json_encode(explode(",", filter_input(INPUT_COOKIE, "oc_sf_hidden_columns")));
// $hidden_columns_text = filter_input(INPUT_COOKIE, "oc_sf_hidden_columns");
foreach ($post as $key => $value) {
if ($value != '') {
$hasParam = true;
}
}
if (!$hasParam) {
echo message('warning', '', TRANS('CHOOSE_AT_LEAST_ONE_CRITERIA'), '', '' , 1);
exit;
}
$terms = "";
$criteria = array();
$criterText = "";
$badgeClass = "badge badge-info p-2 mb-1";
$badgeClassEmptySearch = "badge badge-danger p-2 mb-1";
$rateLabels = ratingLabels();
$rateClasses = ratingClasses();
$slaIndicatorLabel = [];
$slaIndicatorLabel[1] = TRANS('SMART_NOT_IDENTIFIED');
$slaIndicatorLabel[2] = TRANS('SMART_IN_SLA');
$slaIndicatorLabel[3] = TRANS('SMART_IN_SLA_TOLERANCE');
$slaIndicatorLabel[4] = TRANS('SMART_OUT_SLA');
$textSlaColumn = [
'gray-circle.svg' => TRANS('SMART_NOT_IDENTIFIED'),
'green-circle.svg' => TRANS('SMART_IN_SLA'),
'yellow-circle.svg' => TRANS('SMART_IN_SLA_TOLERANCE'),
'red-circle.svg' => TRANS('SMART_OUT_SLA'),
];
$authorizationTypes = [
0 => '',
1 => TRANS('STATUS_WAITING_AUTHORIZATION'),
2 => TRANS('STATUS_AUTHORIZED'),
3 => TRANS('STATUS_REFUSED')
];
$fromDashboard = (isset($post['app_from']) && $post['app_from'] == "dashboard" ? true : false);
$fromTicketInfo = (isset($post['app_from']) && $post['app_from'] == "ticket_info" ? true : false);
$aliasAreasFilter = (isset($post['is_requester_area']) && $post['is_requester_area'] ? "ua.AREA" : "o.sistema");
if ($fromDashboard) {
$render_custom_fields = (isset($post['render_custom_fields']) && !empty($post['render_custom_fields']) ? $post['render_custom_fields'] : "");
$filter_areas = "";
$areas_names = "";
$dashAreasFilter = (isset($post['areas_filter']) && !empty($post['areas_filter']) ? $post['areas_filter'] : "");
$dashAreasFilterArray = explode(",", $dashAreasFilter);
$dashAreasFilterArray = array_map('intval', $dashAreasFilterArray);
$dashAreasFilterArray = array_map('trim', $dashAreasFilterArray);
$dashAreasFilterArray = array_filter($dashAreasFilterArray);
$dashAreasFilter = implode(",", $dashAreasFilterArray);
// $u_areas = (isset($post['areas_filter']) && !empty($post['areas_filter']) ? noHtml($post['areas_filter']) : $_SESSION['s_uareas']);
$u_areas = (!empty($dashAreasFilter) ? $dashAreasFilter : $_SESSION['s_uareas']);
$array_areas_names = getUserAreasNames($conn, $u_areas);
foreach ($array_areas_names as $area_name) {
if (strlen((string)$areas_names))
$areas_names .= ", ";
$areas_names .= $area_name;
}
$clients_names = "";
$filter_clients = (isset($post['clients_filter']) && !empty($post['clients_filter']) ? $post['clients_filter'] : "");
$filter_clientes_array = explode(",", $filter_clients);
$filter_clientes_array = array_map('intval', $filter_clientes_array);
$filter_clientes_array = array_map('trim', $filter_clientes_array);
$filter_clientes_array = array_filter($filter_clientes_array);
$filter_clients = implode(",", $filter_clientes_array);
if (!empty($filter_clients)) {
$array_clients_names = getClientsNamesByIds($conn, $filter_clients, true);
foreach ($array_clients_names as $client_name) {
if (strlen((string)$clients_names))
$clients_names .= ", ";
$clients_names .= $client_name;
}
}
} else {
$filter_clients = "";
$filter_areas = "";
$areas_names = "";
if (isAreasIsolated($conn) && $_SESSION['s_nivel'] != 1) {
/* Visibilidade isolada entre áreas para usuários não admin */
$u_areas = $_SESSION['s_uareas'];
$filter_areas = "1";
$array_areas_names = getUserAreasNames($conn, $u_areas);
foreach ($array_areas_names as $area_name) {
if (strlen((string)$areas_names))
$areas_names .= ", ";
$areas_names .= $area_name;
}
}
}
// dump($post);
if (isset($post['simpleSearch']) && $post['simpleSearch'] == 1 && empty($post['ticket'])) {
$_SESSION['flash'] = message('warning', '', TRANS('MSG_FILL_AT_LEAST_ONE_TICKET_NUMBER'), '');
print "";
exit;
}
/* Para os casos da consulta simples por número do chamado */
if (isset($post['ticket']) && !empty($post['ticket'])) {
$ignoreStatus = false;
$maxNumberOfTickets = 30; /* número máximo de ocorrências para a consulta */
$tmp = explode(',', (string)$post['ticket']);
$treatValues = array_map('intval', $tmp);
$ticketIN = "";
$i = 0;
foreach ($treatValues as $ticketNumber) {
if ($i < $maxNumberOfTickets) { /* Limitando a quantidade de chamados da consulta */
if (strlen((string)$ticketIN)) $ticketIN .= ", ";
$ticketIN .= $ticketNumber;
}
$i++;
}
$terms .= " AND o.numero IN ({$ticketIN}) ";
$criterText = TRANS('TICKET_NUMBER') . ": {$ticketIN}
";
$criteria[] = "{$criterText}";
}
if (isset($post['current_month']) && !empty($post['current_month'])) {
$date_no_time = date('01/m/Y');
$data_abertura_from = date('Y-m-01') . " 00:00:00";
$terms .= " AND o.oco_real_open_date >= '" . $data_abertura_from . "' ";
$criterText = TRANS('SMART_MIN_DATE_OPENING') . ": " . $date_no_time . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['data_abertura_from']) && !empty($post['data_abertura_from'])) {
$data_abertura_from = noHtml($post['data_abertura_from']);
if (!isValidDate($data_abertura_from, 'd/m/Y')) {
$errorFieldMessage = TRANS('MSG_ERROR_WRONG_FORMATTED') . ": " . TRANS('SMART_MIN_DATE_OPENING');
echo message('warning', '', $errorFieldMessage, '', '' , 1);
exit;
}
$data_abertura_from = $data_abertura_from . " 00:00:00";
$data_abertura_from = dateDB($data_abertura_from);
$terms .= " AND o.oco_real_open_date >= '" . $data_abertura_from . "' ";
$criterText = TRANS('SMART_MIN_DATE_OPENING') . ": " . dateScreen($data_abertura_from, 1) . "
";
$criteria[] = "{$criterText}";
}
if (isset($post['data_abertura_to']) && !empty($post['data_abertura_to'])) {
$data_abertura_to = noHtml($post['data_abertura_to']);
if (!isValidDate($data_abertura_to, 'd/m/Y')) {
$errorFieldMessage = TRANS('MSG_ERROR_WRONG_FORMATTED') . ": " . TRANS('SMART_MAX_DATE_OPENING');
echo message('warning', '', $errorFieldMessage, '', '' , 1);
exit;
}
$data_abertura_to = $data_abertura_to . " 23:59:59";
$data_abertura_to = dateDB($data_abertura_to);
$terms .= " AND o.oco_real_open_date <= '" . $data_abertura_to . "' ";
$criterText = TRANS('SMART_MAX_DATE_OPENING') . ": " . dateScreen($data_abertura_to,1) . "
";
$criteria[] = "{$criterText}";
}
if (isset($post['no_empty_response']) && $post['no_empty_response'] == 1) {
$terms .= " AND o.data_atendimento IS NOT null ";
$criterText = TRANS('SMART_HAS_FIRST_RESPONSE') ."
";
$criteria[] = "{$criterText}";
} elseif (isset($post['empty_response']) && $post['empty_response'] == 1) {
$terms .= " AND o.data_atendimento IS null AND s.stat_painel <> 3 ";
$criterText = TRANS('SMART_HASNT_FIRST_RESPONSE') ."
";
$criteria[] = "{$criterText}";
} elseif (isset($post['data_atendimento_from']) && !empty($post['data_atendimento_from'])) {
$data_atendimento_from = noHtml($post['data_atendimento_from']);
if (!isValidDate($data_atendimento_from, 'd/m/Y')) {
$errorFieldMessage = TRANS('MSG_ERROR_WRONG_FORMATTED') . ": " . TRANS('SMART_MIN_DATE_FIRST_RESPONSE');
echo message('warning', '', $errorFieldMessage, '', '' , 1);
exit;
}
$data_atendimento_from = $data_atendimento_from . " 00:00:00";
$data_atendimento_from = dateDB($data_atendimento_from);
$terms .= " AND o.data_atendimento >= '" . $data_atendimento_from . "' ";
$criterText = TRANS('SMART_MIN_DATE_FIRST_RESPONSE') . ": " . dateScreen($data_atendimento_from, 1) . "
";
$criteria[] = "{$criterText}";
}
if (isset($post['data_atendimento_to']) && !empty($post['data_atendimento_to'])) {
$data_atendimento_to = noHtml($post['data_atendimento_to']);
if (!isValidDate($data_atendimento_to, 'd/m/Y')) {
$errorFieldMessage = TRANS('MSG_ERROR_WRONG_FORMATTED') . ": " . TRANS('SMART_MAX_DATE_FIRST_RESPONSE');
echo message('warning', '', $errorFieldMessage, '', '' , 1);
exit;
}
$data_atendimento_to = $data_atendimento_to . " 23:59:59";
$data_atendimento_to = dateDB($data_atendimento_to);
$terms .= " AND o.data_atendimento <= '" . $data_atendimento_to . "' ";
$criterText = TRANS('SMART_MAX_DATE_FIRST_RESPONSE') . ": " . dateScreen($data_atendimento_to, 1) . "
";
$criteria[] = "{$criterText}";
}
/* Filtro exclusivo para listar chamados em progresso - Dashboard */
if (isset($post['em_progresso']) && !empty($post['em_progresso'])) {
$terms .= " AND o.status NOT IN (1, 4, 12) AND s.stat_painel in (1) AND o.oco_scheduled = 0 ";
$criterText = TRANS('CARDS_IN_PROGRESS') . "
";
$criteria[] = "{$criterText}";
}
/* Filtro exclusivo para listar chamados encerrados no mês corrente - Dashboard */
if (isset($post['closed_current_month']) && !empty($post['closed_current_month'])) {
$terms .= " AND o.data_fechamento >= '{$mes_start}' AND o.data_fechamento <= '{$hoje_end}' ";
$criterText = TRANS('CLOSED_CURRENT_MONTH') . "
";
$criteria[] = "{$criterText}";
}
/* Filtro exclusivo para listar a fila aberta de chamados - Dashboard */
if (isset($post['open_queue']) && !empty($post['open_queue'])) {
$terms .= " AND s.stat_painel in (2) AND o.oco_scheduled = 0 ";
$criterText = TRANS('QUEUE_OPEN_FOR_TREAT') . "
";
$criteria[] = "{$criterText}";
}
/* Filtro exclusivo para listar chamados agendados - Dashboard */
if (isset($post['scheduled']) && !empty($post['scheduled'])) {
$terms .= " AND oco_scheduled = 1 ";
$criterText = TRANS('QUEUE_SCHEDULED') . "
";
$criteria[] = "{$criterText}";
}
/* Filtro exclusivo para listar chamados que estão aguardando avaliação - Dashboard */
if (isset($post['waitingRate']) && !empty($post['waitingRate'])) {
$dashboardTerms[] = $post['waitingRate'];
$terms .= " AND tr.ticket IS NOT NULL AND tr.rate IS NULL ";
$criterText = TRANS('WAITING_RATE') . "
";
$criteria[] = "{$criterText}";
}
if (isset($post['closed']) && $post['closed'] == 1) {
$terms .= " AND o.data_fechamento IS NOT null ";
$criterText = TRANS('CARDS_CLOSED') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['not_closed']) && $post['not_closed'] == 1) {
$terms .= " AND s.stat_painel NOT IN (3) AND o.data_fechamento IS null ";
$criterText = TRANS('CARDS_NOT_CLOSED') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['data_fechamento_from']) && !empty($post['data_fechamento_from'])) {
$data_fechamento_from = noHtml($post['data_fechamento_from']);
if (!isValidDate($data_fechamento_from, 'd/m/Y')) {
$errorFieldMessage = TRANS('MSG_ERROR_WRONG_FORMATTED') . ": " . TRANS('SMART_MIN_DATE_CLOSURE');
echo message('warning', '', $errorFieldMessage, '', '' , 1);
exit;
}
$data_fechamento_from = $data_fechamento_from . " 00:00:00";
$data_fechamento_from = dateDB($data_fechamento_from);
$terms .= " AND o.data_fechamento >= '" . $data_fechamento_from . "' ";
$criterText = TRANS('SMART_MIN_DATE_CLOSURE') . ": " . dateScreen($data_fechamento_from, 1) . "
";
$criteria[] = "{$criterText}";
}
$data_fechamento_to = "";
if (isset($post['data_fechamento_to']) && !empty($post['data_fechamento_to'])) {
$data_fechamento_to = noHtml($post['data_fechamento_to']);
if (!isValidDate($data_fechamento_to, 'd/m/Y')) {
$errorFieldMessage = TRANS('MSG_ERROR_WRONG_FORMATTED') . ": " . TRANS('SMART_MAX_DATE_CLOSURE');
echo message('warning', '', $errorFieldMessage, '', '' , 1);
exit;
}
$data_fechamento_to = $data_fechamento_to . " 23:59:59";
$data_fechamento_to = dateDB($data_fechamento_to);
$terms .= " AND o.data_fechamento <= '" . $data_fechamento_to . "' ";
$criterText = TRANS('SMART_MAX_DATE_CLOSURE') . ": " . dateScreen($data_fechamento_to, 1) . "
";
$criteria[] = "{$criterText}";
}
if (isset($post['auto_close_due_inacticity']) && $post['auto_close_due_inacticity'] == 1) {
$terms .= " AND te.auto_closed = 1 ";
$criterText = TRANS('ONLY_CLOSED_DUE_INACTIVITY') . "
";
$criteria[] = "{$criterText}";
}
if (isset($post['no_empty_contact_email']) && $post['no_empty_contact_email'] == 1) {
$terms .= " AND ( o.contato_email != '' AND o.contato_email IS NOT NULL ) ";
$criterText = TRANS('CONTACT_EMAIL') . ": " . TRANS('SMART_NOT_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['no_contact_email']) && $post['no_contact_email'] == 1) {
$terms .= " AND ( o.contato_email = '' OR o.contato_email IS NULL ) ";
$criterText = TRANS('CONTACT_EMAIL') . ": " . TRANS('SMART_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['contact_email']) && !empty($post['contact_email'])) {
$terms .= " AND o.contato_email = '" . noHtml($post['contact_email']) . "' ";
$criterText = TRANS('CONTACT_EMAIL') . ": " . noHtml($post['contact_email']) . "
";
$criteria[] = "{$criterText}";
}
if ($fromDashboard) {
if (!empty($filter_clients)) {
$terms .= " AND o.client in ({$filter_clients}) ";
$criterText = $clients_names;
$clientLabel = TRANS('CLIENT');
$criterText = $clientLabel . ": " . $criterText ."
";
$criteria[] = "{$criterText}";
}
$criterText = "";
if (empty($post['areas_filter'])) {
if ($isAdmin) {
$criterText = TRANS("OCO_SEL_ANY");
} else {
// $terms .= " AND (" . $aliasAreasFilter . " IN ({$u_areas}) OR ".$aliasAreasFilter." = '-1')";
$terms .= " AND " . $aliasAreasFilter . " IN ({$u_areas}, -1) ";
$sqlCriter = "SELECT sistema FROM sistemas WHERE sis_id in ({$u_areas}) ORDER BY sistema";
$resCriter = $conn->query($sqlCriter);
foreach ($resCriter->fetchAll() as $rowCriter) {
if (strlen((string)$criterText)) $criterText .= ", ";
$criterText .= $rowCriter['sistema'];
}
$criterText .= ", " . TRANS('SMART_EMPTY');
}
} else {
if (!$isAdmin) {
$terms .= " AND " . $aliasAreasFilter . " IN ({$u_areas}) ";
} else {
$areasFilter = (isset($post['areas_filter']) && !empty($post['areas_filter']) ? $post['areas_filter'] : "");
$areasFilterArray = explode(",", $areasFilter);
$areasFilterArray = array_map('intval', $areasFilterArray);
$areasFilterArray = array_map('trim', $areasFilterArray);
$areasFilterArray = array_filter($areasFilterArray);
$areasFilter = implode(",", $areasFilterArray);
$terms .= " AND " . $aliasAreasFilter . " IN ({$areasFilter}) ";
}
$sqlCriter = "SELECT sistema FROM sistemas WHERE sis_id in ({$u_areas}) ORDER BY sistema";
$resCriter = $conn->query($sqlCriter);
foreach ($resCriter->fetchAll() as $rowCriter) {
if (strlen((string)$criterText)) $criterText .= ", ";
$criterText .= $rowCriter['sistema'];
}
}
// $areaLabel = ($_SESSION['s_filter_is_requester_area'] ? TRANS('REQUESTER_AREA') : TRANS('SERVICE_AREA'));
$areaLabel = ($post['is_requester_area'] ? TRANS('REQUESTER_AREA') : TRANS('SERVICE_AREA'));
$criterText = $areaLabel . ": " . $criterText ."
";
$criteria[] = "{$criterText}";
} else {
/* Se o isolamento de visibilidade entre áreas estiver habilitado */
if (!empty($filter_areas)) {
if (isset($post['no_empty_area']) && $post['no_empty_area'] == 1) {
$terms .= " AND ( o.sistema IN ({$u_areas}) ) ";
// $terms .= " AND ( a.sis_id IN ({$u_areas}) ) ";
$criterText = TRANS('SERVICE_AREA') . ": " . $areas_names . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['no_area']) && $post['no_area'] == 1) {
// $terms .= " AND ( o.sistema = '-1' OR o.sistema = '0') ";
$terms .= " AND o.sistema IN (-1, 0) ";
$criterText = TRANS('SERVICE_AREA') . ": " . TRANS('SMART_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['area']) && !empty($post['area']) && !empty($post['area'][0])) {
$areaIN = "";
foreach ($post['area'] as $area) {
if (strlen((string)$areaIN)) $areaIN .= ",";
$areaIN .= (int)$area;
}
$terms .= " AND o.sistema IN ({$areaIN}) ";
// $terms .= " AND a.sis_id IN ({$areaIN}) ";
$criterText = "";
$sqlCriter = "SELECT sistema FROM sistemas WHERE sis_id in ({$areaIN}) ORDER BY sistema";
$resCriter = $conn->query($sqlCriter);
foreach ($resCriter->fetchAll() as $rowCriter) {
if (strlen((string)$criterText)) $criterText .= ", ";
$criterText .= $rowCriter['sistema'];
}
$criterText = TRANS('SERVICE_AREA') . ": " . $criterText ."
";
$criteria[] = "{$criterText}";
} else {
/* Se nada for informado para a área, então considera apenas as áreas do usuário e chamados sem área definida*/
$terms .= " AND o.sistema IN ({$u_areas}, -1, 0) ";
// $terms .= " AND a.sis_id IN ({$u_areas}, -1, 0) ";
$criterText = TRANS('SERVICE_AREA') . ": " . $areas_names . " " . TRANS('OPERATOR_OR') . " " . TRANS('SMART_EMPTY') . "
";
$criteria[] = "{$criterText}";
}
} else
if (isset($post['no_empty_area']) && $post['no_empty_area'] == 1) {
// $terms .= " AND ( o.sistema != '-1' AND o.sistema != '0' ) ";
$terms .= " AND o.sistema not in (-1, 0) ";
// $terms .= " AND a.sis_id not in (-1, 0) ";
$criterText = TRANS('SERVICE_AREA') . ": " . TRANS('SMART_NOT_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['no_area']) && $post['no_area'] == 1) {
// $terms .= " AND ( o.sistema = '-1' OR o.sistema = '0') ";
$terms .= " AND o.sistema in (-1, 0) ";
// $terms .= " AND a.sis_id in (-1, 0) ";
$criterText = TRANS('SERVICE_AREA') . ": " . TRANS('SMART_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['area']) && !empty($post['area']) && !empty($post['area'][0])) {
$areaIN = "";
foreach ($post['area'] as $area) {
if (strlen((string)$areaIN)) $areaIN .= ",";
$areaIN .= (int)$area;
}
$terms .= " AND o.sistema IN ({$areaIN}) ";
// $terms .= " AND a.sis_id IN ({$areaIN}) ";
$criterText = "";
$sqlCriter = "SELECT sistema FROM sistemas WHERE sis_id in ({$areaIN}) ORDER BY sistema";
$resCriter = $conn->query($sqlCriter);
foreach ($resCriter->fetchAll() as $rowCriter) {
if (strlen((string)$criterText)) $criterText .= ", ";
$criterText .= $rowCriter['sistema'];
}
$criterText = TRANS('SERVICE_AREA') . ": " . $criterText ."
";
$criteria[] = "{$criterText}";
}
}
/* Filtro por Área Solicitante */
if (isset($post['requester_area']) && !empty($post['requester_area'])) {
$criterText = "";
$requesterArea = array_map('intval', $post['requester_area']);
$requesterAreaIN = implode(",", $requesterArea);
$terms .= " AND asol.sis_id IN ({$requesterAreaIN}) ";
$requestAreas = getAreas($conn, 0, 1, null, $requesterArea);
$arrayCriterRequestAreasNames = [];
foreach ($requestAreas as $requestArea) {
$arrayCriterRequestAreasNames[] = $requestArea['sistema'];
}
$criterText = TRANS('REQUESTER_AREA') . ": " . implode(", ", $arrayCriterRequestAreasNames) ."
";
$criteria[] = "{$criterText}";
}
/* Filtro por Cliente */
if (isset($post['no_empty_client']) && $post['no_empty_client'] == 1) {
$terms .= " AND ( o.client IS NOT NULL ) ";
$criterText = TRANS('CLIENT') . ": " . TRANS('SMART_NOT_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['no_client']) && $post['no_client'] == 1) {
$terms .= " AND ( o.client IS NULL) ";
$criterText = TRANS('CLIENT') . ": " . TRANS('SMART_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['client']) && !empty($post['client'])) {
$clientIN = "";
foreach ($post['client'] as $client) {
if (strlen((string)$clientIN)) $clientIN .= ",";
$clientIN .= (int)$client;
}
$terms .= " AND o.client IN ({$clientIN}) ";
$criterText = "";
$sqlCriter = "SELECT nickname FROM clients WHERE id in ({$clientIN}) ORDER BY nickname";
$resCriter = $conn->query($sqlCriter);
foreach ($resCriter->fetchAll() as $rowCriter) {
if (strlen((string)$criterText)) $criterText .= ", ";
$criterText .= $rowCriter['nickname'];
}
$criterText = TRANS('CLIENT') . ": " . $criterText ."
";
$criteria[] = "{$criterText}";
}
/* Filtro por tipo de solicitação */
if (isset($post['no_empty_problema']) && $post['no_empty_problema'] == 1) {
$terms .= " AND ( o.problema != '-1' AND o.problema != '0' ) ";
$criterText = TRANS('ISSUE_TYPE') . ": " . TRANS('SMART_NOT_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['no_problema']) && $post['no_problema'] == 1) {
$terms .= " AND ( o.problema = '-1' OR o.problema = '0') ";
$criterText = TRANS('ISSUE_TYPE') . ": " . TRANS('SMART_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['problema']) && !empty($post['problema'])) {
$probIN = "";
foreach ($post['problema'] as $problema) {
if (strlen((string)$probIN)) $probIN .= ",";
$probIN .= (int)$problema;
}
$terms .= " AND o.problema IN ({$probIN}) ";
$criterText = "";
$sqlCriter = "SELECT problema FROM problemas WHERE prob_id in ({$probIN}) ORDER BY problema";
$resCriter = $conn->query($sqlCriter);
foreach ($resCriter->fetchAll() as $rowCriter) {
if (strlen((string)$criterText)) $criterText .= ", ";
$criterText .= $rowCriter['problema'];
}
$criterText = TRANS('ISSUE_TYPE') . ": " . $criterText ."
";
$criteria[] = "{$criterText}";
}
/* Unidades */
if (isset($post['no_empty_unidade']) && $post['no_empty_unidade'] == 1) {
$terms .= " AND ( o.instituicao != '-1' AND o.instituicao != '0' AND o.instituicao IS NOT NULL ) ";
$criterText = TRANS('COL_UNIT') . ": " . TRANS('SMART_NOT_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['no_unidade']) && $post['no_unidade'] == 1) {
$terms .= " AND ( o.instituicao = '-1' OR o.instituicao = '0' OR o.instituicao IS NULL ) ";
$criterText = TRANS('COL_UNIT') . ": " . TRANS('SMART_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['unidade']) && !empty($post['unidade'])) {
$unitIN = "";
if (is_array($post['unidade'])) {
foreach ($post['unidade'] as $unidade) {
if (strlen((string)$unitIN)) $unitIN .= ",";
$unitIN .= (int)$unidade;
}
} else {
$unitIN = $post['unidade'];
}
$terms .= " AND o.instituicao IN ({$unitIN}) ";
$criterText = "";
$sqlCriter = "SELECT inst_nome FROM instituicao WHERE inst_cod in ({$unitIN}) ORDER BY inst_nome";
$resCriter = $conn->query($sqlCriter);
foreach ($resCriter->fetchAll() as $rowCriter) {
if (strlen((string)$criterText)) $criterText .= ", ";
$criterText .= $rowCriter['inst_nome'];
}
$criterText = TRANS('COL_UNIT') . ": " . $criterText ."
";
$criteria[] = "{$criterText}";
}
if (isset($post['no_empty_etiqueta']) && $post['no_empty_etiqueta'] == 1) {
$terms .= " AND ( o.equipamento != '-1' AND o.equipamento != '0' AND o.equipamento IS NOT NULL AND o.equipamento != '' ) ";
$criterText = TRANS('ASSET_TAG') . ": " . TRANS('SMART_NOT_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['no_etiqueta']) && $post['no_etiqueta'] == 1) {
$terms .= " AND ( o.equipamento = '-1' OR o.equipamento = '0' OR o.equipamento IS NULL OR o.equipamento = '' ) ";
$criterText = TRANS('ASSET_TAG') . ": " . TRANS('SMART_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['etiqueta']) && !empty($post['etiqueta'])) {
$tmp = explode(',', (string)$post['etiqueta']);
// $treatValues = array_map('intval', $tmp);
$treatValues = array_map('noHtml', $tmp);
$tagIN = "";
foreach ($treatValues as $tag) {
if (strlen((string)$tagIN)) $tagIN .= ", ";
$tag = trim($tag);
$tagIN .= "'{$tag}'";
}
$terms .= " AND o.equipamento IN ({$tagIN}) ";
$criterText = TRANS('ASSET_TAG') . ": {$tagIN}
";
$criteria[] = "{$criterText}";
}
if (isset($post['no_empty_departamento']) && $post['no_empty_departamento'] == 1) {
$terms .= " AND ( o.local != '-1' AND o.local != '0' AND o.local IS NOT NULL AND o.local != '') ";
$criterText = TRANS('DEPARTMENT') . ": " . TRANS('SMART_NOT_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['no_departamento']) && $post['no_departamento'] == 1) {
$terms .= " AND ( o.local = '-1' OR o.local = '0' OR o.local IS NULL OR o.local = '' ) ";
$criterText = TRANS('DEPARTMENT') . ": " . TRANS('SMART_EMPTY') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['departamento']) && !empty($post['departamento'])) {
$localIN = "";
foreach ($post['departamento'] as $departamento) {
if (strlen((string)$localIN)) $localIN .= ",";
$localIN .= (int)$departamento;
}
$terms .= " AND o.local IN ({$localIN}) ";
$criterText = "";
$sqlCriter = "SELECT local FROM localizacao WHERE loc_id in ({$localIN}) ORDER BY local";
$resCriter = $conn->query($sqlCriter);
foreach ($resCriter->fetchAll() as $rowCriter) {
if (strlen((string)$criterText)) $criterText .= ", ";
$criterText .= $rowCriter['local'];
}
$criterText = TRANS('DEPARTMENT') . ": " . $criterText ."
";
$criteria[] = "{$criterText}";
}
if (isset($post['end_user_only']) && $post['end_user_only'] == 1) {
$terms .= " AND ua.nivel = '3' ";
$criterText = TRANS('SMART_OPENING_USER_TYPE') . ": " . TRANS('SMART_ONLY_BY_ENDUSER') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['no_end_user']) && $post['no_end_user'] == 1) {
$terms .= " AND ua.nivel in (1,2) ";
$criterText = TRANS('SMART_OPENING_USER_TYPE') . ": " . TRANS('SMART_ONLY_BY_TECHNITIANS') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['aberto_por']) && !empty($post['aberto_por'])) {
$abertoPorIN = "";
foreach ($post['aberto_por'] as $aberto_por) {
if (strlen((string)$abertoPorIN)) $abertoPorIN .= ",";
$abertoPorIN .= (int)$aberto_por;
}
$terms .= " AND o.aberto_por IN ({$abertoPorIN}) ";
$criterText = "";
$sqlCriter = "SELECT nome FROM usuarios WHERE user_id in ({$abertoPorIN}) ORDER BY nome";
$resCriter = $conn->query($sqlCriter);
foreach ($resCriter->fetchAll() as $rowCriter) {
if (strlen((string)$criterText)) $criterText .= ", ";
$criterText .= $rowCriter['nome'];
}
$criterText = TRANS('REQUESTER') . ": " . $criterText ."
";
$criteria[] = "{$criterText}";
}
if (isset($post['operator']) && !empty($post['operator'])) {
$dashboardTerms[] = $post['operator'];
$operatorIN = "";
foreach ($post['operator'] as $operator) {
if (strlen((string)$operatorIN)) $operatorIN .= ",";
$operatorIN .= (int)$operator;
}
// $terms .= " AND o.operador IN ({$operatorIN}) ";
$criterText = "";
$sqlCriter = "SELECT nome FROM usuarios WHERE user_id in ({$operatorIN}) ORDER BY nome";
$resCriter = $conn->query($sqlCriter);
foreach ($resCriter->fetchAll() as $rowCriter) {
if (strlen((string)$criterText)) $criterText .= ", ";
$criterText .= $rowCriter['nome'];
}
$criterText = TRANS('SMART_OPERATOR') . ": " . $criterText ."
";
$criteria[] = "{$criterText}";
}
if (isset($post['prioridade']) && !empty($post['prioridade'])) {
$prioridadeIN = "";
foreach ($post['prioridade'] as $prioridade) {
if (strlen((string)$prioridadeIN)) $prioridadeIN .= ",";
$prioridadeIN .= (int)$prioridade;
}
$terms .= " AND o.oco_prior IN ({$prioridadeIN}) ";
$criterText = "";
$sqlCriter = "SELECT pr_desc FROM prior_atend WHERE pr_cod in ({$prioridadeIN}) ORDER BY pr_desc";
$resCriter = $conn->query($sqlCriter);
foreach ($resCriter->fetchAll() as $rowCriter) {
if (strlen((string)$criterText)) $criterText .= ", ";
$criterText .= $rowCriter['pr_desc'];
}
$criterText = TRANS('COL_PRIORITY') . ": " . $criterText ."
";
$criteria[] = "{$criterText}";
}
/* Status do chamado */
if (isset($post['time_freeze_status_only']) && $post['time_freeze_status_only'] == 1) {
$terms .= " AND s.stat_time_freeze = 1 AND s.stat_id NOT IN (4,12) "; /* desconsidera os status fixos de encerramento e cancelamento */
$criterText = TRANS('SMART_NOT_CLOSED_PAUSED_STATUS') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['no_time_freeze_status']) && $post['no_time_freeze_status'] == 1) {
$terms .= " AND s.stat_time_freeze = 0 AND s.stat_id NOT IN (4,12) ";
$criterText = TRANS('SMART_NOT_CLOSED_RUNNING_STATUS') . "
";
$criteria[] = "{$criterText}";
} elseif (isset($post['status']) && !empty($post['status'])) {
$ignoreStatus = false;
$statusIN = "";
foreach ($post['status'] as $status) {
if (strlen((string)$statusIN)) $statusIN .= ",";
$statusIN .= (int)$status;
}
$terms .= " AND o.status IN ({$statusIN}) ";
$criterText = "";
$sqlCriter = "SELECT status FROM status WHERE stat_id in ({$statusIN}) ORDER BY status";
$resCriter = $conn->query($sqlCriter);
foreach ($resCriter->fetchAll() as $rowCriter) {
if (strlen((string)$criterText)) $criterText .= ", ";
$criterText .= $rowCriter['status'];
}
// $criterText = TRANS('COL_STATUS') . "Status: " . $criterText ."
";
$criterText = TRANS('COL_STATUS') . ": " . $criterText ."
";
$criteria[] = "{$criterText}";
}
$limitToHavingCost = false;
/* Filtro por status de autorização do atendimento */
if (isset($post['totalCostNotRejected']) && $post['totalCostNotRejected'] == 1) {
$terms .= " AND ( o.authorization_status <> 3 OR o.authorization_status IS NULL ) ";
$criterText = TRANS('AUTHORIZATION_STATUS') . ": " . TRANS('WITHOUT_AUTHORIZATION_REFUSE') . "
";
$criteria[] = "{$criterText}";
$limitToHavingCost = true;
} elseif (isset($post['totalCostRejected']) && $post['totalCostRejected'] == 1) {
$terms .= " AND o.authorization_status = 3 ";
$criterText = TRANS('AUTHORIZATION_STATUS') . ": " . TRANS('WITH_AUTHORIZATION_REFUSED') . "
";
$criteria[] = "{$criterText}";
$limitToHavingCost = true;
} elseif (isset($post['no_empty_authorization_status']) && $post['no_empty_authorization_status'] == 1) {
$terms .= " AND ( o.authorization_status IS NOT NULL ) ";
$criterText = TRANS('AUTHORIZATION_STATUS') . ": " . TRANS('SMART_NOT_EMPTY') . "
";
$criteria[] = "{$criterText}";
$limitToHavingCost = true;
} elseif (isset($post['no_authorization_status']) && $post['no_authorization_status'] == 1) {
$terms .= " AND ( o.authorization_status IS NULL) ";
$criterText = TRANS('AUTHORIZATION_STATUS') . ": " . TRANS('SMART_EMPTY') . "
";
$criteria[] = "{$criterText}";
$limitToHavingCost = true;
} elseif (isset($post['authorization_status']) && !empty($post['authorization_status'])) {
$criterText = "";
$treatedAuthorizationStatus = array_map('intval', $post['authorization_status']);
$authorizationIn = "";
foreach ($treatedAuthorizationStatus as $authorization_status) {
if (strlen((string)$authorizationIn)) $authorizationIn .= ",";
$authorizationIn .= $authorization_status;
if (strlen((string)$criterText)) $criterText .= ", ";
$criterText .= $authorizationTypes[$authorization_status];
}
$terms .= " AND o.authorization_status IN ({$authorizationIn}) ";
$criterText = TRANS('AUTHORIZATION_STATUS') . ": " . $criterText ."
";
$criteria[] = "{$criterText}";
$limitToHavingCost = true;
}
if ($limitToHavingCost && $fromDashboard) {
/* Se a consulta for a partir do dashboard, Limitará os resultados a apenas chamados que tenham custo definido */
$costFieldInfo = getCustomFields($conn, $costField);
$post['no_empty_' . $costFieldInfo['field_name']] = 1;
}
/* Exibição dos critérios para Avaliação do chamado */
if (isset($post['no_empty_rate']) && !empty($post['no_empty_rate'])) {
$criterText = TRANS('SMART_ONLY_RATED') . "
";
$criteria[] = "{$criterText}";
$terms .= " ";
} elseif (isset($post['no_rate']) && !empty($post['no_rate'])) {
$criterText = TRANS('SMART_ONLY_NOT_RATED') . "
";
$criteria[] = "{$criterText}";
$terms .= " ";
} elseif (isset($post['rate']) && !empty($post['rate'])) {
$criterText = "";
foreach ($post['rate'] as $res) {
if (array_key_exists($res, $rateLabels)) {
if (strlen((string)$criterText)) $criterText .= ", ";
$criterText .= $rateLabels[$res];
}
}
$criterText = TRANS('SERVICE_RATE') . ": " . $criterText ."
";
$criteria[] = "{$criterText}";
$terms .= " ";
}
/* Exibição dos critérios sobre filtro de recursos */
if (isset($post['no_empty_resources']) && !empty($post['no_empty_resources'])) {
$criterText = TRANS('SMART_ONLY_WITH_RESOURCES') . "
";
$criteria[] = "{$criterText}";
$terms .= " ";
} elseif (isset($post['no_resources']) && !empty($post['no_resources'])) {
$criterText = TRANS('SMART_ONLY_WITHOUT_RESOURCES') . "
";
$criteria[] = "{$criterText}";
$terms .= " ";
} elseif (isset($post['resources']) && !empty($post['resources'])) {
$criterText = "";
$treatedPostResources = array_map('intval', $post['resources']);
foreach ($treatedPostResources as $res) {
if (strlen((string)$criterText)) $criterText .= ", ";
$modelInfo = getAssetsModels($conn, $res);
$modelText = $modelInfo['tipo'] . ' ' . $modelInfo['fabricante'] . ' ' . $modelInfo['modelo'];
$criterText .= $modelText;
}
$criterText = TRANS('RESOURCES') . ": " . $criterText ."
";
$criteria[] = "{$criterText}";
$terms .= " ";
}
if (isset($post['response_sla']) && !empty($post['response_sla'])) {
$criterText = "";
$treatedPostResponseSla = array_map('intval', $post['response_sla']);
foreach ($treatedPostResponseSla as $res) {
if (array_key_exists($res, $slaIndicatorLabel)) {
if (strlen((string)$criterText)) $criterText .= ", ";
$criterText .= $slaIndicatorLabel[$res];
}
}
$criterText = TRANS('RESPONSE_SLA') . ": " . $criterText ."
";
$criteria[] = "{$criterText}";
$terms .= " ";
}
if (isset($post['solution_sla']) && !empty($post['solution_sla'])) {
$criterText = "";
$treatedPostSolutionSla = array_map('intval', $post['solution_sla']);
foreach ($treatedPostSolutionSla as $res) {
if (array_key_exists($res, $slaIndicatorLabel)) {
if (strlen((string)$criterText)) $criterText .= ", ";
$criterText .= $slaIndicatorLabel[$res];
}
}
$criterText = TRANS('SOLUTION_SLA') . ": " . $criterText ."
";
$criteria[] = "{$criterText}";
$terms .= " ";
}
/* Canais de solicitação - Opening Channels */
if (isset($post['open_channels_only']) && !empty($post['open_channels_only'])) {
$channels = getChannels($conn, null, 'open');
$channelIN = "";
foreach ($channels as $channel) {
if (strlen((string)$channelIN)) $channelIN .= ",";
$channelIN .= $channel['id'];
}
$terms .= " AND o.oco_channel IN ({$channelIN}) ";
$criterText = TRANS('SMART_ONLY_OPEN_CHANNELS');
$criterText = TRANS('OPENING_CHANNEL') . ": " . $criterText ."
";
$criteria[] = "{$criterText}";
} elseif (isset($post['system_channels_only']) && !empty($post['system_channels_only'])) {
$channels = getChannels($conn, null, 'restrict');
$channelIN = "";
foreach ($channels as $channel) {
if (strlen((string)$channelIN)) $channelIN .= ",";
$channelIN .= $channel['id'];
}
$terms .= " AND o.oco_channel IN ({$channelIN}) ";
$criterText = TRANS('SMART_ONLY_SYSTEM_CHANNELS');
$criterText = TRANS('OPENING_CHANNEL') . ": " . $criterText ."
";
$criteria[] = "{$criterText}";
} elseif (isset($post['channel']) && !empty($post['channel'])) {
$channelIN = "";
$treatedPostChannels = array_map('intval', $post['channel']);
foreach ($treatedPostChannels as $channel) {
if (strlen((string)$channelIN)) $channelIN .= ",";
$channelIN .= $channel;
}
$terms .= " AND o.oco_channel IN ({$channelIN}) ";
$criterText = "";
$sqlCriter = "SELECT name FROM channels WHERE id in ({$channelIN}) ORDER BY name";
$resCriter = $conn->query($sqlCriter);
foreach ($resCriter->fetchAll() as $rowCriter) {
if (strlen((string)$criterText)) $criterText .= ", ";
$criterText .= $rowCriter['name'];
}
$criterText = TRANS('OPENING_CHANNEL') . ": " . $criterText ."
";
$criteria[] = "{$criterText}";
}
$tagTerms = "";
/* Tags obrigatórias */
if (isset($post['has_tags']) && !empty($post['has_tags'])) {
$input_tagsIN = "";
$criterText = "";
$mustHave = '';
$mustHaveText = '('. TRANS('AT_LEAST_TAGS') .')';
if (isset($post['must_have_tags']) && !empty($post['must_have_tags'])) {
$mustHave = '+';
$mustHaveText = '('. TRANS('MUST_HAVE_TAGS') .')';
}
if (!is_array($post['has_tags'])) {
$singleTag = noHtml($post['has_tags']);
$input_tagsIN .= "+\"$singleTag\"";
$criterText .= $singleTag;
} else {
$treatedPostHastags = array_map('noHtml', $post['has_tags']);
foreach ($treatedPostHastags as $input_tag) {
if (strlen((string)$input_tagsIN)) $input_tagsIN .= " ";
$input_tagsIN .= "{$mustHave}\"$input_tag\"";
if (strlen((string)$criterText)) $criterText .= ", ";
$criterText .= $input_tag;
}
}
$tagTerms .= $input_tagsIN;
$criterText = TRANS('INPUT_TAGS') . " {$mustHaveText}: " . $criterText ."
";
$criteria[] = "{$criterText}";
/* Tags de exclusão - Só será aplicada se existir o filtro de tag obrigatória*/
if (isset($post['exclude_tags']) && !empty($post['exclude_tags'])) {
$input_tagsIN = "";
$criterText = "";
$treatedPostExcludetags = array_map('noHtml', $post['exclude_tags']);
foreach ($treatedPostExcludetags as $input_tag) {
if (strlen((string)$input_tagsIN)) $input_tagsIN .= " ";
$input_tagsIN .= "-\"$input_tag\"";
if (strlen((string)$criterText)) $criterText .= ", ";
$criterText .= $input_tag;
}
$tagTerms .= " " . $input_tagsIN;
$criterText = TRANS('INPUT_TAGS_EXCLUDED') . ": " . $criterText ."
";
$criteria[] = "{$criterText}";
}
}
if (strlen((string)$tagTerms)) {
$terms .= " AND MATCH(oco_tag) AGAINST('{$tagTerms}' IN BOOLEAN MODE)";
if ($fromTicketInfo) {
/* Se for a partir de um chamado, mostrar Apenas dos últimos 6 meses */
$criteria[] = "". TRANS('LAST_6_MONTHS') ."";
$terms .= " AND o.data_abertura >= DATE_SUB('{$hoje}', INTERVAL 6 MONTH) ";
}
}
if (isset($post['only_relatives']) && !empty($post['only_relatives'])) {
$criterText = TRANS('SMART_ONLY_WITH_TICKETS_REFERENCED') . "
";
$criteria[] = "{$criterText}";
$terms .= " ";
} elseif (isset($post['no_relatives']) && !empty($post['no_relatives'])) {
$criterText = TRANS('SMART_ONLY_WITHOUT_TICKETS_REFERENCED') . "
";
$criteria[] = "{$criterText}";
$terms .= " ";
}
if (isset($post['never_rejected']) && !empty($post['never_rejected'])) {
$criterText = TRANS('NEVER_REJECTED') . "
";
$criteria[] = "{$criterText}";
$terms .= " ";
} elseif (isset($post['has_been_rejected']) && !empty($post['has_been_rejected'])) {
$criterText = TRANS('HAS_BEEN_REJECTED') . "
";
$criteria[] = "{$criterText}";
$terms .= " ";
}
if (isset($post['only_attachments']) && !empty($post['only_attachments'])) {
$criterText = TRANS('ONLY_TICKETS_WITH_ATTACHMENTS') . "
";
$criteria[] = "{$criterText}";
$terms .= " ";
} elseif (isset($post['no_attachments']) && !empty($post['no_attachments'])) {
$criterText = TRANS('ONLY_TICKETS_WITHOUT_ATTACHMENTS') . "
";
$criteria[] = "{$criterText}";
$terms .= " ";
}
/* Controle para evitar consultas sem critérios relevantes fora do dashboard */
if (empty(trim($terms)) && empty($dashboardTerms)) {
$criterText = TRANS('SMART_WITHOUT_SEARCH_CRITERIA') . "
";
$criteria[] = "{$criterText}";
/* Não permito a busca de ocorrencias sem ao menos um critério dentro dos campos oficiais */
echo message('warning', '', TRANS('CHOOSE_AT_LEAST_ONE_CRITERIA'), '', '' , 1);
exit;
}
/**
* Consulta no banco a partir de todos os critérios diretos
*/
if ($ignoreStatus) {
$sql = $QRY["ocorrencias_full_ini"] . " WHERE stat_ignored <> 1 {$terms} ORDER BY numero";
} else {
$sql = $QRY["ocorrencias_full_ini"] . " WHERE 1 = 1 {$terms} ORDER BY numero";
}
$sqlResult = $conn->query($sql);
$totalFiltered = $sqlResult->rowCount();
/**
* Campos personalizados
* Tipos de campos possíveis:
* ["date", "datetime", "select", "select_multi", "number", "text", "textarea", "checkbox"]
*
* Até o momento esses são os campos permitidos e tratados:
* ["date", "datetime", "select", "select_multi", "number", "text", "textarea", "checkbox"]
*/
$custom_fields = [];
$custom_fields_full = [];
if ($render_custom_fields) {
$types = ["date", "datetime", "select", "select_multi", "number", "text", "textarea", "checkbox"];
$custom_fields = getCustomFields($conn, null, 'ocorrencias', $types); /* Apenas campos customizados ativos e que podem ser pesquisados */
$custom_fields_full = getCustomFields($conn, null, 'ocorrencias'); /* Para montar a tabela de exibição, todos os campos ativos sao utilizados */
}
/* Montagem dos Critérios dos campos personalizados preenchidos */
$emptyPrefix = "no_";
$notEmptyPrefix = "no_empty_";
$minDatePrefix = "min_";
$maxDatePrefix = "max_";
$minNumberPrefix = "minNum_";
$maxNumberPrefix = "maxNum_";
$noRenderPrefix = "norender_";
$dontRender = [];
/** Armazenarei aqui os valores a serem checados por cada chamado */
$customTerms = [];
/* Bloco para identificação dos critérios de pesquisa sobre campos customizados */
foreach ($custom_fields as $cfield) {
$criterText = "";
/* Ver os campos que não devem ser renderizados */
if (isset($post[$noRenderPrefix . $cfield['field_name']]) && $post[$noRenderPrefix . $cfield['field_name']] == 1) {
$dontRender[] = $cfield['id'];
}
if (isset($post[$notEmptyPrefix . $cfield['field_name']]) && $post[$notEmptyPrefix . $cfield['field_name']] == 1) {
/* Qualquer valor não vazio */
$criterText = $cfield['field_label'] . ": " . TRANS('SMART_NOT_EMPTY') . "
";
$criteria[] = "{$criterText}";
/* id - operador - valor de comparacao */
$customTerms[$cfield['id']]['!='][] = '';
} elseif (isset($post[$emptyPrefix . $cfield['field_name']]) && $post[$emptyPrefix . $cfield['field_name']] == 1) {
/* Valor obrigatiamente vazio */
$criterText = $cfield['field_label'] . ": " . TRANS('SMART_EMPTY') . "
";
$criteria[] = "{$criterText}";
/* id - operador - valor de comparacao */
$customTerms[$cfield['id']]['=='][] = '';
} elseif (isset($post[$cfield['field_name']]) && !empty($post[$cfield['field_name']])) {
/* Valor informado */
if ($cfield['field_type'] == 'select' || $cfield['field_type'] == 'select_multi') {
$fieldIN = [];
foreach ($post[$cfield['field_name']] as $fieldValue) {
$fieldValue = noHtml($fieldValue);
$fieldIN[] = getCustomFieldValue($conn, $fieldValue);
/* id - operador - valor de comparacao */
$customTerms[$cfield['id']]['IN'][] = $fieldValue;
}
} else {
/* Ver tratamento para cada tipo de campo - Datas não entram nesse laço */
$fieldIN = noHtml($post[$cfield['field_name']]);
/* id - operador - valor de comparacao */
// $customTerms[$cfield['id']]['=='][] = $fieldIN;
/* Operador de comparação direta '===' */
$customTerms[$cfield['id']]['==='][] = $fieldIN;
}
$criterText = (is_array($fieldIN) ? implode(", ", $fieldIN) : $fieldIN);
$criterText = $cfield['field_label'] . ": " . $criterText ."
";
$criteria[] = "{$criterText}";
} elseif (isset($post[$minDatePrefix . $cfield['field_name']]) && !empty($post[$minDatePrefix . $cfield['field_name']])) {
/* Se tiver data mínima selecionada - Campos do tipo date ou datetime' */
$criterText = noHtml($post[$minDatePrefix . $cfield['field_name']]);
$criterText = $cfield['field_label'] . " (" . TRANS('MIN_DATE') . "): " . $criterText ."
";
$criterText2 = "";
/* id - operador - valor de comparacao */
$customTerms[$cfield['id']]['<='][] = noHtml($post[$minDatePrefix . $cfield['field_name']]);
/* Tem data final? */
if (isset($post[$maxDatePrefix . $cfield['field_name']]) && !empty($post[$maxDatePrefix . $cfield['field_name']])) {
$criterText2 = noHtml($post[$maxDatePrefix . $cfield['field_name']]);
$criterText2 = $cfield['field_label'] . " (" . TRANS('MAX_DATE') . "): " . $criterText2 ."
";
/* id - operador - valor de comparacao */
$customTerms[$cfield['id']]['>='][] = noHtml($post[$maxDatePrefix . $cfield['field_name']]);
}
$criteria[] = "{$criterText}";
$criteria[] = "{$criterText2}";
} elseif (isset($post[$maxDatePrefix . $cfield['field_name']]) && !empty($post[$maxDatePrefix . $cfield['field_name']])) {
/* Se tiver data máxima selecionada mas não tiver data mínima */
$criterText = noHtml($post[$maxDatePrefix . $cfield['field_name']]);
$criterText = $cfield['field_label'] . " (" . TRANS('MAX_DATE') . "): " . $criterText ."
";
$criterText2 = "";
$criteria[] = "{$criterText}";
/* id - operador - valor de comparacao */
$customTerms[$cfield['id']]['>='][] = noHtml($post[$maxDatePrefix . $cfield['field_name']]);
} elseif (isset($post[$minNumberPrefix . $cfield['field_name']]) && !empty($post[$minNumberPrefix . $cfield['field_name']])) {
/* Se tiver data mínima selecionada - Campos do tipo date ou datetime' */
$criterText = noHtml($post[$minNumberPrefix . $cfield['field_name']]);
$criterText = $cfield['field_label'] . " (" . TRANS('MIN_VALUE') . "): " . $criterText ."
";
$criterText2 = "";
/* id - operador - valor de comparacao */
$customTerms[$cfield['id']]['<='][] = noHtml($post[$minNumberPrefix . $cfield['field_name']]);
/* Tem limite final? */
if (isset($post[$maxNumberPrefix . $cfield['field_name']]) && !empty($post[$maxNumberPrefix . $cfield['field_name']])) {
$criterText2 = noHtml($post[$maxNumberPrefix . $cfield['field_name']]);
$criterText2 = $cfield['field_label'] . " (" . TRANS('MAX_VALUE') . "): " . $criterText2 ."
";
/* id - operador - valor de comparacao */
$customTerms[$cfield['id']]['>='][] = noHtml($post[$maxNumberPrefix . $cfield['field_name']]);
}
$criteria[] = "{$criterText}";
$criteria[] = "{$criterText2}";
} elseif (isset($post[$maxNumberPrefix . $cfield['field_name']]) && !empty($post[$maxNumberPrefix . $cfield['field_name']])) {
/* Se tiver data máxima selecionada mas não tiver data mínima */
$criterText = noHtml($post[$maxNumberPrefix . $cfield['field_name']]);
$criterText = $cfield['field_label'] . " (" . TRANS('MAX_VALUE') . "): " . $criterText ."
";
$criterText2 = "";
$criteria[] = "{$criterText}";
/* id - operador - valor de comparacao */
$customTerms[$cfield['id']]['>='][] = noHtml($post[$maxNumberPrefix . $cfield['field_name']]);
}
}
/* Final da montagem dos critérios sobre os campos personalizados preenchidos */
$criterios = "";
?>