top.window.location = '../../index.php'"; exit; } else { $numero = noHtml($_GET['numero']); $id = $_GET['id']; $id = str_replace(" ", "+", $id); $id = noHtml($id); if (asEquals($id, getGlobalTicketId($conn, $numero))) { $GLOBALACCESS = true; } else { echo ""; exit(); } } } if (!$GLOBALACCESS) { $auth = new AuthNew($_SESSION['s_logado'], $_SESSION['s_nivel'], 3, 1); } $isAdmin = (isset($_SESSION['s_nivel']) && $_SESSION['s_nivel'] == 1) ? true : false; ?> <?= APP_NAME; ?> <?= VERSAO; ?> $value) { $customFields[$key]['field_id'] = (string)$value['field_id']; } } $sql = $QRY["ocorrencias_full_ini"] . " WHERE numero = '" . (int)$_GET['numero'] . "' ORDER BY numero"; try { $res = $conn->query($sql); } catch (Exception $e) { echo $e->getMessage(); exit(); } $row = $res->fetch(); $isRequester = $row['aberto_por_cod'] == (isset($_SESSION['s_uid']) ? $_SESSION['s_uid'] : 0); if ($GLOBALACCESS) { $isRequester = true; } $isAreaAdmin = false; if (isset($_SESSION['s_uid'])) { $managebleAreas = getManagedAreasByUser($conn, $_SESSION['s_uid']); $managebleAreas = array_column($managebleAreas, 'sis_id'); $isAreaAdmin = in_array($row['aberto_por_area'], $managebleAreas); } /* Controle para evitar acesso ao chamado por usuarios operadores que não fazem parte da area do chamado */ if (!$isAdmin && !$isRequester && !$isAreaAdmin) { $uareas = explode(',', $_SESSION['s_uareas']); if (!in_array($row['area_cod'], $uareas)) { ?>

'.TRANS('MSG_TICKET_NOT_ALLOWED_TO_BE_VIEWED'), '', '', true); exit; } } /* Tratamento para excluir os campos que não devem ser exibidos para o usuário final */ $hiddenCustomFields = []; $profile_id = $row['profile_id']; if ((isset($_SESSION['s_nivel']) && $_SESSION['s_nivel'] == 3) || $GLOBALACCESS) { /* Checagem se há campos que devem ser ocultos para usuários nível somente abertura */ $hiddenCustomFields = ($profile_id ? explode(',',(string)getScreenInfo($conn, $profile_id)['cfields_user_hidden']) : []); } if (!empty($customFields['field_id'])) { foreach ($customFields as $key => $field) { if (!empty($hiddenCustomFields) && in_array($field['field_id'], $hiddenCustomFields)) { unset($customFields[$key]); } } } $sqlPriorityDesc = "SELECT * FROM prior_atend WHERE pr_cod = '" . $row['oco_prior'] . "'"; $resPriority = $conn->query($sqlPriorityDesc); $rowPriority = $resPriority->fetch(); $categories = ""; $issueDetails = (!empty($row['prob_cod'] && $row['prob_cod'] != '-1') ? getIssueDetailed($conn, $row['prob_cod'])[0] : []); if ($issueDetails) { $catKeys = ["probt1_desc", "probt2_desc", "probt3_desc", "probt4_desc", "probt5_desc", "probt6_desc"]; foreach ($catKeys as $catKey) { if (!empty($categories) && !empty($issueDetails[$catKey])) { $categories .= " | "; } $categories .= $issueDetails[$catKey]; } } // Recursos do chamado $resources = getResourcesFromTicket($conn, $row['numero']); $resourcesList = ''; $resources_info = []; if (!empty($resources)) { foreach ($resources as $resource) { $modelInfo = getAssetsModels($conn, $resource['model_id'], null, null, 1, ['t.tipo_nome']); $resources_info[$resource['model_id']]['model_id'][] = $resource['model_id']; $resources_info[$resource['model_id']]['modelo_full'][] = $modelInfo['tipo'] . ' ' . $modelInfo['fabricante'] . ' ' . $modelInfo['modelo']; $resources_info[$resource['model_id']]['categoria'][] = $modelInfo['cat_name']; $resources_info[$resource['model_id']]['amount'][] = $resource['amount']; $resources_info[$resource['model_id']]['unitary_price'][] = $resource['unitary_price']; } foreach ($resources_info as $key => $value) { $resources_info[$key]['model_id'] = implode(', ', $resources_info[$key]['model_id']); $resources_info[$key]['modelo_full'] = implode(', ', $resources_info[$key]['modelo_full']); $resources_info[$key]['categoria'] = implode(', ', $resources_info[$key]['categoria']); $resources_info[$key]['amount'] = implode(', ', $resources_info[$key]['amount']); $resources_info[$key]['unitary_price'] = implode(', ', $resources_info[$key]['unitary_price']); } $resources_info = arraySortByColumn($resources_info, 'modelo_full'); /* Recursos do chamado em lista */ if (!empty($resources_info)) { foreach ($resources_info as $resInfo) { $resourcesList .= '
  • ' . $resInfo['modelo_full'] . ' (' . $resInfo['amount'] . ')
  • '; } } } $defaultFields = []; $defaultFields[0]['field_id'] = '1'; $defaultFields[0]['field_label'] = TRANS('OPENED_BY'); $defaultFields[0]['field_value'] = $row['aberto_por']; $defaultFields[1]['field_id'] = '2'; $defaultFields[1]['field_label'] = TRANS('CONTACT'); $defaultFields[1]['field_value'] = $row['contato']; $defaultFields[2]['field_id'] = '3'; $defaultFields[2]['field_label'] = TRANS('COL_PHONE'); $defaultFields[2]['field_value'] = $row['telefone']; $defaultFields[3]['field_id'] = '4'; $defaultFields[3]['field_label'] = TRANS('DEPARTMENT'); $defaultFields[3]['field_value'] = $row['setor']; $defaultFields[4]['field_id'] = '5'; $defaultFields[4]['field_label'] = TRANS('OCO_PRIORITY'); $defaultFields[4]['field_value'] = $rowPriority['pr_desc']; $defaultFields[5]['field_id'] = '6'; $defaultFields[5]['field_label'] = TRANS('OPENING_DATE'); $defaultFields[5]['field_value'] = dateScreen($row['data_abertura']); $defaultFields[6]['field_id'] = '7'; $defaultFields[6]['field_label'] = TRANS('ISSUE_TYPE'); $defaultFields[6]['field_value'] = $row['problema']; $defaultFields[7]['field_id'] = '8'; $defaultFields[7]['field_label'] = TRANS('COL_CAT_PROB'); $defaultFields[7]['field_value'] = $categories; $defaultFields[8]['field_id'] = '9'; $defaultFields[8]['field_label'] = TRANS('COL_UNIT'); $defaultFields[8]['field_value'] = $row['unidade']; $defaultFields[9]['field_id'] = '10'; $defaultFields[9]['field_label'] = TRANS('FIELD_TAG_EQUIP'); $defaultFields[9]['field_value'] = $row['etiqueta']; $defaultFields[10]['field_id'] = '11'; $defaultFields[10]['field_label'] = TRANS('IDX_AGENDAMENTO'); // $defaultFields[10]['field_value'] = dateScreen($row['oco_scheduled_to']); $defaultFields[10]['field_value'] = dateScreen(getLastScheduledDate($conn, (int)$_GET['numero'])); $defaultFields[11]['field_id'] = '12'; $defaultFields[11]['field_label'] = TRANS('RESOURCES'); $defaultFields[11]['field_value'] = $resourcesList; $sqlAssentamentos = "SELECT a.*, u.* FROM assentamentos a, usuarios u WHERE a.responsavel = u.user_id AND a.ocorrencia='" . (int)$_GET['numero'] . "' AND a.asset_privated = 0 ORDER BY numero"; $resAssentamentos = $conn->query($sqlAssentamentos); $countAssentamentos = $resAssentamentos->rowCount(); ?>
     

    : 
    : 
    : 
    : 
    : 
    : 
    : 
    fetchall() as $rowEntries) { ?>