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/classes/worktime/Worktime.php"; include_once __DIR__ . "/" . "../../includes/functions/getWorktimeProfile.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'], 2, 1); $projectID = (isset($_GET['project_id']) && !empty($_GET['project_id']) ? (int)$_GET['project_id'] : ''); if (!$projectID) { echo message('danger', '', TRANS('MSG_PROJECT_ID_NOT_PROVIDED'), '', '', true); return false; } $projectDefinitions = getProjectDefinition($conn, $projectID); if (empty($projectDefinitions)) { echo message('danger', '', TRANS('MSG_PROJECT_ID_NOT_FOUND'), '', '', true); return false; } $allTickets = getTicketsFromProject($conn, $projectID); if (empty($allTickets)) { echo message('danger', '', TRANS('MSG_NO_TICKETS_FOUND_TO_PROJECT'), '', '', true); return false; } $authorizationTypes = [ 0 => TRANS('WITHOUT_DEFINITION'), 1 => TRANS('STATUS_WAITING_AUTHORIZATION'), 2 => TRANS('STATUS_AUTHORIZED'), 3 => TRANS('STATUS_REFUSED'), ]; $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'), ]; $config = getConfig($conn); $imgsPath = "../../includes/imgs/"; $iconFrozen = ""; $iconOutOfWorktime = ""; $iconTicketClosed = ""; $percLimit = $config['conf_sla_tolerance']; $solverAreas = []; $areasSumTimes = []; $status = []; $ledSlaResposta = []; $textSlaResposta = []; $ledSlaSolucao = []; $textSlaSolucao = []; $issuesTypes = []; $authorization_status = []; $clients = []; $responseSeconds = []; $solutionSeconds = []; $resourcesFull = []; $ticketsCosts = []; $ticketsCostsSum = 0; $ticketsResult = []; $stringAllTickets = implode(', ', $allTickets); $isAdmin = $_SESSION['s_nivel'] == 1; $uareas = noHtml($_SESSION['s_uareas']); $termsControl = ""; /* Usuários admininstradores não possuem restrições para acessar quaisquer chamados */ if (!$isAdmin) { // $termsControl = " AND o.sistema IN ({$uareas})"; $termsControl = " AND (o.sistema IN ({$uareas}) OR o.registration_operator = '{$_SESSION['s_uid']}')"; } $sql = $QRY["ocorrencias_full_ini"] . " WHERE o.numero IN ({$stringAllTickets}) {$termsControl} ORDER BY numero"; $sqlResult = $conn->query($sql); $total = $sqlResult->rowCount(); if (!$total) { echo message('danger', '', TRANS('MSG_NO_TICKETS_FOUND_TO_PROJECT_BY_LIMITED_AREAS'), '', '', true); return false; } foreach ($sqlResult->fetchAll() as $row) { $ticketsResult[$row['numero']] = $row; $clients[] = $row['nickname'] ?? "N/A"; $solverAreas[] = $row['area'] ?? "N/A"; $status[] = $row['chamado_status'] ?? "N/A"; $issuesTypes[] = $row['problema'] ?? "N/A"; $authorization_status[] = $authorizationTypes[$row['authorization_status']] ?? "N/A"; /* Custo dos chamados */ $has_cost = false; $cost_field_info = []; $tickets_cost_field = (!empty($config['tickets_cost_field']) ? $config['tickets_cost_field'] : ""); if (!empty($tickets_cost_field)) { $cost_field_info = getTicketCustomFields($conn, $row['numero'], $tickets_cost_field); if (!empty($cost_field_info['field_value']) && priceDB($cost_field_info['field_value']) > 0) { $has_cost = true; } } if ($has_cost) { $ticketsCosts[$row['numero']] = $cost_field_info['field_value']; $ticketsCostsSum += priceDB($cost_field_info['field_value']); } /* Fim do bloco de custo dos chamados */ // Recursos do chamado $resources = getResourcesFromTicket($conn, $row['numero']); $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'); $resourcesFull[] = $resources_info; } /* Final do bloco de recursos dos chamados */ /** ************************************************************ *** Processos para os cálculos de tempos de cada chamado ****** * *************************************************************/ $referenceDate = (!empty($row['oco_real_open_date']) ? $row['oco_real_open_date'] : $row['data_abertura']); $dataAtendimento = $row['data_atendimento']; //data da primeira resposta ao chamado $dataFechamento = $row['data_fechamento']; $holidays = getHolidays($conn); $profileCod = getProfileCod($conn, $_SESSION['s_wt_areas'], $row['numero']); $worktimeProfile = getWorktimeProfile($conn, $profileCod); /* Objeto para o cálculo de Tempo válido de SOLUÇÃO - baseado no perfil de jornada de trabalho e nas etapas em cada status */ $newWT = new WorkTime( $worktimeProfile, $holidays ); /* Objeto para o cálculo de Tempo válido de RESPOSTA baseado no perfil de jornada de trabalho e nas etapas em cada status */ $newWTResponse = new WorkTime( $worktimeProfile, $holidays ); /* Objeto para checagem se o momento atual está coberto pelo perfil de jornada associado */ $objWT = new Worktime( $worktimeProfile, $holidays ); /* Realiza todas as checagens necessárias para retornar os tempos de resposta e solução para o chamado */ $ticketTimeInfo = getTicketTimeInfo($conn, $newWT, $newWTResponse, $row['numero'], $referenceDate, $dataAtendimento, $dataFechamento, $row['status_cod'], $objWT); /* Retorna os leds indicativos (bolinhas) para os tempos de resposta e solução */ $ledSlaResposta[$row['numero']] = showLedSLA($ticketTimeInfo['response']['seconds'], $percLimit, $row['sla_resposta_tempo']); $ledSlaSolucao[$row['numero']] = showLedSLA($ticketTimeInfo['solution']['seconds'], $percLimit, $row['sla_solucao_tempo']); /* Texto sobre os SLAs - para serem imprimíveis */ $textSlaResposta[$row['numero']] = $textSlaColumn[$ledSlaResposta[$row['numero']]]; $textSlaSolucao[$row['numero']] = $textSlaColumn[$ledSlaSolucao[$row['numero']]]; $isRunning = $ticketTimeInfo['running']; $colTVNew = $ticketTimeInfo['solution']['time']; if ($row['status_cod'] == 4) { $colTVNew = $iconTicketClosed . " " . $colTVNew; } elseif (isTicketFrozen($conn, $row['numero'])) { $colTVNew = $iconFrozen . " " . $colTVNew; } elseif (!$isRunning) { $colTVNew = $iconOutOfWorktime . " " . $colTVNew; } $responseResult = getSlaResult($ticketTimeInfo['response']['seconds'], $percLimit, $row['sla_resposta_tempo']); $solutionResult = getSlaResult($ticketTimeInfo['solution']['seconds'], $percLimit, $row['sla_solucao_tempo']); $absoluteTime[$row['numero']] = absoluteTime($referenceDate, (!empty($dataFechamento) ? $dataFechamento : date('Y-m-d H:i:s')))['inTime']; $absServiceTime[$row['numero']] = absoluteTime((!empty($dataAtendimento) ? $dataAtendimento : $referenceDate), (!empty($dataFechamento) ? $dataFechamento : date('Y-m-d H:i:s')))['inTime']; $solution_from_response_seconds[$row['numero']] = $ticketTimeInfo['solution']['seconds'] - $ticketTimeInfo['response']['seconds']; if ($solution_from_response_seconds[$row['numero']] != 0) { $solution_from_response_time[$row['numero']] = secToTime($solution_from_response_seconds[$row['numero']])['verbose']; } else { $solution_from_response_time[$row['numero']] = $ticketTimeInfo['solution']['time']; } $responseSeconds[$row['numero']] = $ticketTimeInfo['response']['seconds']; $solutionSeconds[$row['numero']] = $ticketTimeInfo['solution']['seconds']; $filteredSolutionTime[$row['numero']] = $ticketTimeInfo['solution']['time']; $filteredResponseTime[$row['numero']] = $ticketTimeInfo['response']['time']; /** Final dos processos para checagens de tempos do chamado */ /* Soma os tempos de solução para cada área - Sempre se considera que o chamado mantém a mesma área para todo o tempo */ if (!empty($row['area'])) { if (array_key_exists($row['area'], $areasSumTimes)) { $areasSumTimes[$row['area']] += $ticketTimeInfo['solution']['seconds']; } else { $areasSumTimes[$row['area']] = (int)$ticketTimeInfo['solution']['seconds']; } } } // Final da iteração sobre os chamados $jsonTicketsResult = json_encode($ticketsResult); /* Primeiro e último chamados */ $firstTicket = min(array_keys($ticketsResult)); $lastTicket = max(array_keys($ticketsResult)); $clients = array_count_values($clients); $solverAreas = array_count_values($solverAreas); $status = array_count_values($status); $issuesTypes = array_count_values($issuesTypes); $authorization_status = array_count_values($authorization_status); /* Recursos consolidados */ $resourcesSum = []; foreach ($resourcesFull as $key => $value) { foreach ($value as $key2 => $value2) { // var_dump($value2); $resourcesSum[$value2['model_id']]['modelo_full'] = $value2['modelo_full']; $resourcesSum[$value2['model_id']]['categoria'] = $value2['categoria']; $resourcesSum[$value2['model_id']]['amount'] = (isset($resourcesSum[$value2['model_id']]['amount']) ? $resourcesSum[$value2['model_id']]['amount'] + $value2['amount'] : $value2['amount']); $resourcesSum[$value2['model_id']]['unitary_price'] = $value2['unitary_price']; $resourcesSum[$value2['model_id']]['total_price'] = $value2['unitary_price'] * $resourcesSum[$value2['model_id']]['amount']; } } $resourcesSum = arraySortByColumn($resourcesSum, 'modelo_full'); /** Não esquecer de listar todos os arquivos anexos aos chamados do projeto */ $sqlFiles = "SELECT * FROM imagens WHERE img_oco IN (" . $stringAllTickets . ") "; $resultFiles = $conn->query($sqlFiles); $hasFiles = $resultFiles->rowCount(); /* Definições das colunas */ $colLabel = "col-sm-3 text-md-right font-weight-bold p-2"; $colsDefault = "small text-break border-bottom rounded p-2 bg-white"; /* border-secondary */ $colContent = $colsDefault . " col-sm-3 col-md-3"; $colContentLine = $colsDefault . " col-sm-9"; $colContentLineFile = " text-break border-bottom rounded p-2 bg-white col-sm-9"; ?>
| = TRANS('COL_TYPE'); ?> | = TRANS('COL_AMOUNT'); ?> | = TRANS('UNITARY_PRICE'); ?> | = TRANS('TOTAL_CURRENCY'); ?> |
|---|---|---|---|
| = $resource['modelo_full']; ?> | = $resource['amount']; ?> | = priceScreen($resource['unitary_price']); ?> | = priceScreen($row_price); ?> |
| = priceScreen($summary); ?> | |||
| = TRANS('TICKET_NUMBER'); ?> | = TRANS('AREA'); ?> | = TRANS('ISSUE_TYPE'); ?> | = TRANS('CONTACT') . " " . TRANS('COL_PHONE'); ?> |
= TRANS('DEPARTMENT') . " " . TRANS('DESCRIPTION'); ?> |
= TRANS('COST'); ?> | = TRANS('AUTHORIZATION_STATUS') . " " . TRANS('COL_STATUS'); ?> |
= TRANS('COL_SLAS'); ?> |
|---|---|---|---|---|---|---|---|
| = $rowDetail['numero']; ?> | = $rowDetail['area']; ?> | = $rowDetail['problema']; ?> | = $renderContactPhone; ?> | = $renderDepartment; ?> | = $renderTicketCost; ?> | = $renderStatus; ?> | = " |
| = TRANS('TICKET_NUMBER'); ?> | = TRANS('COL_TYPE'); ?> | = TRANS('SIZE'); ?> | = TRANS('FILE'); ?> |
|---|---|---|---|
| = $rowFiles['img_oco']; ?> | = $rowFiles['img_tipo']; ?> | = $size; ?>k | = $rowFiles['img_nome']; ?>= $viewImage; ?> |