top.window.location = '../../index.php'"; exit; } require_once __DIR__ . "/" . "../../includes/include_geral_new.inc.php"; require_once __DIR__ . "/" . "../../includes/classes/ConnectPDO.php"; require_once __DIR__ . "/" . "../../includes/components/html2text-master/vendor/autoload.php"; use includes\classes\ConnectPDO; $conn = ConnectPDO::getInstance(); $auth = new AuthNew($_SESSION['s_logado'], $_SESSION['s_nivel'], 3, 1); $isAdmin = $_SESSION['s_nivel'] == 1; ?> <?= APP_NAME; ?> <?= VERSAO; ?>

'.TRANS('MSG_TICKET_NOT_ALLOWED_TO_BE_VIEWED'), '', '', true); exit; } } //CHECA SE O PRIMEIRO REGISTRO DE LOG JA EXISTE - SE NAO EXISTIR GRAVA O ESTADO ATUAL $firstLog = firstLog($conn, $_GET['numero'], 'NULL', 1); $sql_log = "SELECT * FROM ocorrencias_log WHERE log_numero = '" . (int)$_GET['numero'] . "' ORDER BY log_id"; $commit_log = $conn->query($sql_log); $existe_log = $commit_log->rowCount(); $tipoAtendimento = array(); $log = array(); $i = 0; if ($existe_log) { foreach ($commit_log->fetchall() as $row_log) { $log[$i]['IDX_DATA'] = dateScreen($row_log['log_data']); $sql = "SELECT nome FROM usuarios WHERE user_id = '" . $row_log['log_quem'] . "'"; $commit = $conn->query($sql); $row = $commit->fetch(); $log[$i]['IDX_QUEM'] = $row['nome'] ?? TRANS('AUTOMATIC_PROCESS'); $log[$i]['FLAGGED'] = 0; if ($row_log['log_requester'] != "") { $requester = getUserInfo($conn, $row_log['log_requester']); $log[$i]['IDX_REQUESTER'] = $requester['nome']; $log[$i]['FLAGGED'] = 1; } if ($row_log['log_cliente'] != "" && $row_log['log_cliente'] != "0" && $row_log['log_cliente'] != "-1") { $client = getClients($conn, $row_log['log_cliente'])['nickname']; $log[$i]['IDX_CLIENTE'] = $client; $log[$i]['FLAGGED'] = 1; } if ($row_log['log_descricao'] != "") { $description = trim($row_log['log_descricao']); $description = toHtml(nl2br($description)); $description = (new \Html2Text\Html2Text(safeStrip($description)))->getText(); $log[$i]['IDX_DESCRICAO'] = $description; $log[$i]['FLAGGED'] = 1; } if ($row_log['log_prioridade'] != "" && $row_log['log_prioridade'] != "0" && $row_log['log_prioridade'] != "-1") { $sql = "SELECT pr_desc FROM prior_atend WHERE pr_cod = '" . $row_log['log_prioridade'] . "'"; $commit = $conn->query($sql); $row = $commit->fetch(); $log[$i]['IDX_PRIORIDADE'] = $row['pr_desc']; $log[$i]['FLAGGED'] = 1; } if ($row_log['log_area'] != "" && $row_log['log_area'] != "0" && $row_log['log_area'] != "-1") { $sql = "SELECT sistema FROM sistemas WHERE sis_id = '" . $row_log['log_area'] . "'"; $commit = $conn->query($sql); $row = $commit->fetch(); $log[$i]['IDX_AREA'] = $row['sistema']; $log[$i]['FLAGGED'] = 1; } if ($row_log['log_problema'] != "" && $row_log['log_problema'] != "0" && $row_log['log_problema'] != "-1") { $sql = "SELECT problema FROM problemas WHERE prob_id = '" . $row_log['log_problema'] . "'"; $commit = $conn->query($sql); $row = $commit->fetch(); //$log[$i]['SOLICITACAO'] = $row['problema']; $log[$i]['IDX_PROB'] = $row['problema']; $log[$i]['FLAGGED'] = 1; } if ($row_log['log_unidade'] != "" && $row_log['log_unidade'] != "0" && $row_log['log_unidade'] != "-1") { $sql = "SELECT inst_nome FROM instituicao WHERE inst_cod = '" . $row_log['log_unidade'] . "'"; $commit = $conn->query($sql); $row = $commit->fetch(); $log[$i]['IDX_UNIDADE'] = $row['inst_nome']; $log[$i]['FLAGGED'] = 1; } if ($row_log['log_etiqueta'] != "") { $log[$i]['IDX_ETIQUETA'] = $row_log['log_etiqueta']; $log[$i]['FLAGGED'] = 1; } if ($row_log['log_contato'] != "") { $log[$i]['IDX_CONTATO'] = $row_log['log_contato']; $log[$i]['FLAGGED'] = 1; } if ($row_log['log_contato_email'] != "") { $log[$i]['IDX_CONTATO_EMAIL'] = $row_log['log_contato_email']; $log[$i]['FLAGGED'] = 1; } if ($row_log['log_telefone'] != "") { $log[$i]['IDX_TELEFONE'] = $row_log['log_telefone']; $log[$i]['FLAGGED'] = 1; } if ($row_log['log_departamento'] != "" && $row_log['log_departamento'] != "0" && $row_log['log_departamento'] != "-1") { $sql = "SELECT local FROM localizacao WHERE loc_id = '" . $row_log['log_departamento'] . "'"; $commit = $conn->query($sql); $row = $commit->fetch(); $log[$i]['IDX_DEPARTMENT'] = $row['local']; $log[$i]['FLAGGED'] = 1; } if ($row_log['log_responsavel'] != "") { $sql = "SELECT nome FROM usuarios WHERE user_id = '" . $row_log['log_responsavel'] . "'"; $commit = $conn->query($sql); $row = $commit->fetch(); $log[$i]['IDX_RESPONSAVEL'] = $row['nome']; $log[$i]['FLAGGED'] = 1; } if ($row_log['log_data_agendamento'] != "") { $log[$i]['IDX_AGENDAMENTO'] = dateScreen($row_log['log_data_agendamento']); $log[$i]['FLAGGED'] = 1; } if ($row_log['log_status'] != "") { $sql = "SELECT `status` FROM status WHERE stat_id = '" . $row_log['log_status'] . "'"; $commit = $conn->query($sql); $row = $commit->fetch(); $log[$i]['IDX_STATUS'] = $row['status']; $log[$i]['FLAGGED'] = 1; } if ($row_log['log_authorization_status'] != "" && $row_log['log_authorization_status'] != "-1") { $authorizationTypes = [ 0 => TRANS('WITHOUT_DEFINITION'), 1 => TRANS('STATUS_WAITING_AUTHORIZATION'), 2 => TRANS('STATUS_AUTHORIZED'), 3 => TRANS('STATUS_REFUSED') ]; $log[$i]['IDX_AUTHORIZATION_STATUS'] = $authorizationTypes[$row_log['log_authorization_status']]; $log[$i]['FLAGGED'] = 1; } if ($row_log['log_tipo_edicao'] != "") { // if ($row_log['log_tipo_edicao'] == 0) $operation_type = TRANS('OPT_OPERATION_TYPE_OPEN'); // elseif ($row_log['log_tipo_edicao'] == 1) $operation_type = TRANS('OPT_OPERATION_TYPE_EDIT'); // elseif ($row_log['log_tipo_edicao'] == 2) $operation_type = TRANS('OPT_OPERATION_TYPE_ATTEND'); // elseif ($row_log['log_tipo_edicao'] == 3) $operation_type = TRANS('OPT_OPERATION_TYPE_REOPEN'); // elseif ($row_log['log_tipo_edicao'] == 4) $operation_type = TRANS('OPT_OPERATION_TYPE_CLOSE'); // elseif ($row_log['log_tipo_edicao'] == 5) $operation_type = TRANS('OPT_OPERATION_TYPE_ATTRIB'); // elseif ($row_log['log_tipo_edicao'] == 6) $operation_type = TRANS('OPT_OPERATION_SCHEDULE'); // else // $operation_type = TRANS('OPT_OPERATION_NOT_LABELED'); // $log[$i]['IDX_OPERACAO'] = $operation_type; $log[$i]['IDX_OPERACAO'] = getOperationType($row_log['log_tipo_edicao']); $log[$i]['FLAGGED'] = 1; } $i++; } ?>
  N.º
$valor) { $CONT = count($l) - 1; //MENOS A QUANTIDADE DE INDICES QUE ESTOU OMITINDO - NO CASO, O INDICE = 'FLAGGED' if ($l['FLAGGED'] == 1) { if ($k != "FLAGGED") { ?>

" . TRANS('IDX_EDIT') . " " . $x . "

"; print ""; if ($k != 'IDX_DATA') print ""; ?>
" . ($k == 'IDX_DATA' ? $valor : '') . "
" . TRANS($k) . "" . $valor . "