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++;
}
?>
= TRANS('IDX_TICKET_LOGS'); ?> N.º = $_GET['numero']; ?>
$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 "" . ($k == 'IDX_DATA' ? $valor : '') . " ";
if ($k != 'IDX_DATA')
print "" . TRANS($k) . " " . $valor . " ";
?>