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"; use includes\classes\ConnectPDO; $conn = ConnectPDO::getInstance(); $auth = new AuthNew($_SESSION['s_logado'], $_SESSION['s_nivel'], 3, 1); if (!isset($_POST['numero'])) { exit(); } $ticket = (int)$_POST['numero']; /* $sqlStatusNow = "SELECT s.stat_id, s.status FROM ocorrencias o, status s WHERE o.numero = {$ticket} AND o.status = s.stat_id "; $resultStatusNow = $conn->query($sqlStatusNow); $rowStatusNow = $resultStatusNow->fetch(); $statusNow = $rowStatusNow['status']; $idStatusNow = $rowStatusNow['stat_id']; */ /* MÉTODOS PARA O CÁLCULO DE TEMPO VÁLIDO DE RESPOSTA E SOLUÇÃO */ $holidays = getHolidays($conn); $profileCod = getProfileCod($conn, $_SESSION['s_wt_areas'], $ticket); $worktimeProfile = getWorktimeProfile($conn, $profileCod); // $sql = $QRY["ocorrencias_full_ini"]. "WHERE o.numero = {$ticket}"; // $sql = "SELECT ts.* , s.* FROM tickets_stages ts, status s WHERE ts.ticket = " . $ticket . " AND ts.status_id = s.stat_id ORDER BY ts.id"; $sql = "SELECT * FROM tickets_stages WHERE ticket = " . $ticket . " ORDER BY id"; try { $resultSQL = $conn->query($sql); } catch (Exception $e) { // echo 'Erro: ', $e->getMessage(), "
"; $erro = true; return false; } $data = array(); if ($resultSQL->rowCount()) { foreach ($resultSQL->fetchAll() as $row) { $filteredTime = TRANS('IS_PAUSE_STATUS'); /* Objeto para cálculo do tempo válido */ $objWT = new WorkTime( $worktimeProfile, $holidays ); $status = 'Indeterminado'; $freeze = 0; if ($row['status_id'] != 0) { /* Status Zero reservado para os casos de chamados existentes antes do ticket_stage */ $sqlInner = "SELECT status, stat_time_freeze FROM status WHERE stat_id = " . $row['status_id'] . " "; $resultInner = $conn->query($sqlInner); $rowInner = $resultInner->fetch(); $status = $rowInner['status']; $freeze = $rowInner['stat_time_freeze']; } /* Pegando as datas em cada stage */ $date1 = $row['date_start']; $date2 = $row['date_stop'] ?? date('Y-m-d H:i:s'); /* Se não for status de parada então é realizado o cálculo de tempo filtrado */ if (!$freeze) { $objWT->startTimer($date1); $objWT->stopTimer($date2); $filteredTime = $objWT->getTime(); } /* Tempo absoluto em cada stage */ $loopData = array(); $loopData['date_start'] = dateScreen($row['date_start']); $loopData['date_stop'] = dateScreen($row['date_stop']); $loopData['filtered_time'] = $filteredTime; $loopData['absolute_time'] = absoluteTime($date1, $date2)['inTime']; // $loopData['status'] = $row['status']; $loopData['status'] = $status; $loopData['freeze'] = transbool($freeze); $data['stages'][] = $loopData; } } else { /* Nesse caso, o chamado é anterior a implementação do ticket_stages - não tenho as informações */ $loopData['date_start'] = ''; $loopData['date_stop'] = ''; $loopData['status'] = 'Indisponível'; $loopData['freeze'] = ''; $data['stages'][] = $loopData; } /* Dados sobre os operadores envolvidos no atendimento - apenas para os casos de fila direta */ /* Válidos apenas para novos chamados após a implementação do controle de operadores no ticket_stages */ /* Operadores envolvidos */ $ticketTreaters = getTicketTreaters($conn, $ticket); $ticketTreatersStages = []; foreach ($ticketTreaters as $treater) { $data['treaters'][] = $treater; $ticketTreatersStages[$treater['user_id']] = getStagesFromTicket($conn, $ticket, ['treater' => $treater['user_id'], 'panel' => '1']); } $arrayObj = []; $treaterAbsoluteSecondsSliced = []; foreach ($ticketTreatersStages as $key => $arrayValues) { // $key = treater id // $arrayValues = array de stages $arrayObj[$key] = new WorkTime( $worktimeProfile, $holidays ); foreach ($arrayValues as $row) { $arrayObj[$key]->startTimer($row['date_start']); $arrayObj[$key]->stopTimer($row['date_stop'] ?? date('Y-m-d H:i:s')); $treaterAbsoluteSecondsSliced[$key][] = absoluteTime($row['date_start'], $row['date_stop'] ?? date('Y-m-d H:i:s'))['inSeconds']; } $totalAbsSecondsSliced[$key] = array_sum($treaterAbsoluteSecondsSliced[$key]); $totalAbsTimeSliced[$key] = secToTime($totalAbsSecondsSliced[$key])['verbose']; $data[$key]['fulltime'] = $arrayObj[$key]->getTime() ?? '0'; $data[$key]['absolutetime'] = $totalAbsTimeSliced[$key]; } echo json_encode($data);