top.window.location = '../../index.php'"; exit; } require_once __DIR__ . "/" . "../../includes/include_basics_only.php"; require_once __DIR__ . "/" . "../../includes/classes/ConnectPDO.php"; use OcomonApi\Support\Email; use includes\classes\ConnectPDO; $conn = ConnectPDO::getInstance(); $auth = new AuthNew($_SESSION['s_logado'], $_SESSION['s_nivel'], 3, 1); $config = getConfig($conn); $rowconfmail = getMailConfig($conn); $data['success'] = true; $isRequester = false; $arrayStatusToMonitor = []; $textStatusToMonitor = ""; $statusToMonitor = $config['stats_to_close_by_inactivity']; $statusOutInactivity = $config['stat_out_inactivity']; if (!empty($statusToMonitor)) { $arrayStatusToMonitor = explode(',', (string)$statusToMonitor); $textStatusToMonitor = implode(', ', $arrayStatusToMonitor); } if (isset($_POST['onlyOpen']) && $_POST['onlyOpen'] == 1) { $ticketInfo = getTicketData($conn, (int)$_POST['numero']); if ($_SESSION['s_uid'] == $ticketInfo['aberto_por']) { $isRequester = true; } $exception = ""; $mailNotification = ""; $numero = (int)$_POST['numero']; $data = []; $data['numero'] = $numero; $comment = (isset($_POST['add_comment']) ? noHtml($_POST['add_comment']) : ""); if (empty($comment)) { $data['success'] = false; $data['field_id'] = "add_comment"; $data['message'] = message('warning', 'Ooops!', TRANS('MSG_EMPTY_DATA'), ''); echo json_encode($data); return false; // $_SESSION['flash'] = message('warning', 'Ooops!', TRANS('MSG_EMPTY_DATA'), ''); // return false; } $sql = "INSERT INTO assentamentos ( ocorrencia, assentamento, created_at, responsavel, asset_privated, tipo_assentamento ) values ( :numero, :comment, :created_at, :responsavel, 0, 8 )"; try { $res = $conn->prepare($sql); $now = date("Y-m-d H:i:s"); $res->bindParam(':numero', $numero, PDO::PARAM_INT); $res->bindParam(':comment', $comment, PDO::PARAM_STR); $res->bindParam(':created_at', $now, PDO::PARAM_STR); $res->bindParam(':responsavel', $_SESSION['s_uid'], PDO::PARAM_INT); $res->execute(); $notice_id = $conn->lastInsertId(); // if ($_SESSION['s_uid'] != $data['aberto_por']) { setUserTicketNotice($conn, 'assentamentos', $notice_id); // } $data['message'] = TRANS('TICKET_ENTRY_SUCCESS_ADDED'); /** * Se for o solicitante e o status do chamado for um dos status monitorados quanto a inatividade, * então será necessário atualizar o status do chamado */ if ($isRequester && !empty($arrayStatusToMonitor) && in_array($ticketInfo['status'], $arrayStatusToMonitor)) { /* Atualizar o status do chamado */ $sql = "UPDATE ocorrencias SET `status` = :status WHERE numero = :numero"; try { $exec = $conn->prepare($sql); $exec->bindParam(':status', $statusOutInactivity); $exec->bindParam(':numero', $numero); $exec->execute(); /* Atualiza o tickets_stages */ $stopTimeStage = insert_ticket_stage($conn, $numero, 'stop', $statusOutInactivity); $startTimeStage = insert_ticket_stage($conn, $numero, 'start', $statusOutInactivity); /* Array para a funcao recordLog - estágio anterior à modificação */ $arrayBeforePost = []; $arrayBeforePost['status_cod'] = $ticketInfo['status']; /* Array para a função recordLog - estágio posterior à modificação */ $afterPost = []; $afterPost['status'] = $statusOutInactivity; $operationType = 21; /* OPT_OPERATION_REQUESTER_IS_ALIVE */ /* Função que grava o registro de alterações do chamado */ $recordLog = recordLog($conn, $numero, $arrayBeforePost, $afterPost, $operationType); } catch (Exception $e) { $exception .= "
" . $e->getMessage(); $data['success'] = false; // $data['sql'] = $sql; $exception .= "
" . $e->getMessage() . "
" . $sql; $data['message'] = TRANS('MSG_SOMETHING_GOT_WRONG') . $exception; $_SESSION['flash'] = message('warning', 'Ooops!', $data['message'], ''); echo json_encode($data); return false; } } } catch (Exception $e) { $exception .= "
" . $e->getMessage(); $data['message'] = TRANS('MSG_SOMETHING_GOT_WRONG') . $exception; } /* Checagens para upload de arquivos - vale para todos os actions */ $totalFiles = ($_FILES ? count($_FILES['anexo']['name']) : 0); $filesClean = []; if ($totalFiles > $config['conf_qtd_max_anexos']) { $data['success'] = false; $data['message'] .= '
Too many files'; echo json_encode($data); $_SESSION['flash'] = message('warning', 'Ooops!', $data['message'], ''); return false; } $uploadMessage = ""; $emptyFiles = 0; /* Testa os arquivos enviados para montar os índices do recordFile*/ if ($totalFiles) { foreach ($_FILES as $anexo) { $file = array(); for ($i = 0; $i < $totalFiles; $i++) { /* fazer o que precisar com cada arquivo */ /* acessa: $anexo['name'][$i] $anexo['type'][$i] $anexo['tmp_name'][$i] $anexo['size'][$i]*/ if (!empty($anexo['name'][$i])) { $file['name'] = $anexo['name'][$i]; $file['type'] = $anexo['type'][$i]; $file['tmp_name'] = $anexo['tmp_name'][$i]; $file['error'] = $anexo['error'][$i]; $file['size'] = $anexo['size'][$i]; $upld = upload('anexo', $config, $config['conf_upld_file_types'], $file); if ($upld == "OK") { $recordFile[$i] = true; $filesClean[] = $file; } else { $recordFile[$i] = false; $uploadMessage .= $upld; } } else { $emptyFiles++; } } } $totalFiles -= $emptyFiles; if (strlen((string)$uploadMessage) > 0) { $data['success'] = false; $data['field_id'] = "idInputFile"; $data['message'] = message('warning', 'Ooops!', $uploadMessage, ''); echo json_encode($data); $_SESSION['flash'] = $data['message']; return false; } } /* Upload de arquivos - Todos os actions */ foreach ($filesClean as $attach) { $fileinput = $attach['tmp_name']; $tamanho = getimagesize($fileinput); $tamanho2 = filesize($fileinput); if (!$tamanho) { /* Nâo é imagem */ unset ($tamanho); $tamanho = []; $tamanho[0] = ""; $tamanho[1] = ""; } if (chop($fileinput) != "") { // $fileinput should point to a temp file on the server // which contains the uploaded file. so we will prepare // the file for upload with addslashes and form an sql // statement to do the load into the database. // $file = addslashes(fread(fopen($fileinput, "r"), 10000000)); $file = addslashes(fread(fopen($fileinput, "r"), $config['conf_upld_size'])); $sqlFile = "INSERT INTO imagens (img_nome, img_oco, img_tipo, img_bin, img_largura, img_altura, img_size) values " . "('" . noSpace($attach['name']) . "'," . $data['numero'] . ", '" . $attach['type'] . "', " . "'" . $file . "', " . dbField($tamanho[0]) . ", " . dbField($tamanho[1]) . ", " . dbField($tamanho2) . ")"; // now we can delete the temp file unlink($fileinput); } try { $exec = $conn->exec($sqlFile); } catch (Exception $e) { $data['message'] = $data['message'] . "
" . TRANS('MSG_ERR_NOT_ATTACH_FILE'); $exception .= "
" . $e->getMessage(); } } /* Final do upload de arquivos */ /* Checa se o chamado possui um ID de mensagem, quando aberto por e-mail */ $references_info = getTicketEmailReferences($conn, $data['numero']); /* Variáveis de ambiente para envio de e-mail: todos os actions */ $VARS = getEnvVarsValues($conn, $data['numero']); $mailSendMethod = 'send'; if ($rowconfmail['mail_queue']) { $mailSendMethod = 'queue'; } $event = 'edita-para-usuario'; $to = $VARS['%contato_email%']; if ($isRequester) { $event = 'edita-para-area'; $to = $VARS['%area_email%']; } $eventTemplate = getEventMailConfig($conn, $event); /* Disparo do e-mail (ou fila no banco) para a área de atendimento */ $mail = (new Email())->bootstrap( transvars($eventTemplate['msg_subject'], $VARS), transvars($eventTemplate['msg_body'], $VARS), $to, $eventTemplate['msg_fromname'], $data['numero'] ); if (!$mail->{$mailSendMethod}()) { $mailNotification .= "
" . TRANS('EMAIL_NOT_SENT') . "
" . $mail->message()->getText(); } $_SESSION['flash'] = message('success', '', TRANS('TICKET_ENTRY_SUCCESS_ADDED') . $mailNotification, ''); return false; // echo TRANS('TICKET_ENTRY_SUCCESS_ADDED'); // echo message('success', 'Pronto!', TRANS('TICKET_ENTRY_SUCCESS_ADDED'), ''); }