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/components/dompdf/vendor/autoload.php";
use OcomonApi\Support\Email;
use includes\classes\ConnectPDO;
use Dompdf\Dompdf;
$conn = ConnectPDO::getInstance();
$post = $_POST;
$now = date('Y-m-d H:i:s');
$hasTerm = true;
$isTermUpdated = true;
$isTermSigned = false;
$signedAt = null;
$exception = "";
$data = [];
$data['success'] = true;
$data['message'] = "";
$data['sendEmailToUser'] = true;
$data['action'] = (isset($post['action']) && !empty($post['action']) ? $post['action'] : "");
$data['user_id'] = (isset($post['user_id']) ? (int)$post['user_id'] : "");
if ($data['action'] == "sign" || $data['action'] == "update_html_doc") {
$data['user_id'] = $_SESSION['s_uid'];
$data['sendEmailToUser'] = false;
}
$termInfo = [];
$uploaded_at = $now;
if ($data['action'] == "update_html_doc" || $data['action'] == "sign") {
$termInfo = getUserLastCommitmentTermInfo($conn, $data['user_id']);
if (!empty($termInfo) && !empty($termInfo['uploaded_at'])) {
$uploaded_at = $termInfo['uploaded_at'];
}
}
$successMsgIdx = ($data['action'] == "sign" ? "SUCCESS_SIGNING_TERM_OF_COMMITMENT" : "SUCCESS_GENERATING_TERM_OF_COMMITMENT");
if (empty($data['user_id'])) {
$data['success'] = false;
echo json_encode([]);
return false;
}
$userInfo = getUserInfo($conn, $data['user_id']);
if (empty($userInfo)) {
$data['success'] = false;
echo json_encode([]);
return false;
}
$termSigned = false;
$termUpdated = false;
if ($data['action'] == "sign") {
$signature_info = getUserSignatureFileInfo($conn, $data['user_id']);
if (empty($signature_info)) {
$data['success'] = false;
$data['message'] = TRANS('YOU_NEED_TO_DEFINE_SIGNATURE_FIRST');
$data['message'] = message('warning', 'Ooops!', $data['message'], '');
echo json_encode($data);
return false;
}
/* Checa se o termo mais recente já está assinado */
$termSigned = isLastUserTermSigned($conn, $data['user_id']);
if ($termSigned) {
$data['success'] = false;
$data['message'] = TRANS('TERM_IS_ALREADY_SIGNED');
$data['message'] = message('warning', 'Ooops!', $data['message'], '');
echo json_encode($data);
return false;
}
$isTermSigned = true;
$signedAt = $now;
}
$mailConfig = getMailConfig($conn);
/* Se o termo já estiver atualizado, não é necessário gerar novamente */
$termUpdated = isUserTermUpdated($conn, $data['user_id']);
if (!$termUpdated || !$termSigned || $data['action'] == "update_html_doc") {
$commitmentTermInfo = [];
if (!empty($userInfo['term_unit'])) {
$models = getCommitmentModels($conn, null, $userInfo['term_unit'], null, 1);
$commitmentTermInfo = (!empty($models) ? $models[0] : []);
} elseif (!empty($userInfo['user_client'])) {
$models = getCommitmentModels($conn, null, null, $userInfo['user_client'], 1);
$commitmentTermInfo = (!empty($models) ? $models[0] : []);
} else {
/* Termo de compromisso padrão: código 1 */
$models = getCommitmentModels($conn, 1, null, null);
$commitmentTermInfo = (!empty($models) ? $models[0] : []);
}
if (empty($commitmentTermInfo)) {
/* Caso não exista cadastro de termo específico para o cliente do usuário - Termo de compromisso padrão: código 1 */
$commitmentTermInfo = getCommitmentModels($conn, 1, null, null)[0];
}
/**
* Processo para transpor as variáveis de ambiente
*
* %tabela_de_ativos%
* %usuario_reponsavel%
* %data_e_hora%
* %data%
*
*/
$assetVars = []; // variáveis dinâmicas relacionadas aos ativos vinculados ao usuário
$user_assets = getAssetsFromUser($conn, $data['user_id']);
$assets_info = [];
if (!empty($user_assets)) {
foreach ($user_assets as $asset) {
$assets_info[] = getAssetBasicInfo($conn, $asset['asset_id']);
}
}
$assets_info = arraySortByColumn($assets_info, 'tipo_nome', SORT_ASC);
/** Formatação para o PDF */
$htmlTable = <<< EOT
EOT;
$htmlTable .= '
';
$htmlTable .= '';
$htmlTable .= '';
$htmlTable .= '| ' . TRANS('ASSET_TYPE') . ' | ';
$htmlTable .= '' . TRANS('ASSET_TAG_TAG') . ' | ';
$htmlTable .= '' . TRANS('COL_UNIT') . ' | ';
$htmlTable .= '' . TRANS('CLIENT') . ' | ';
$htmlTable .= '' . TRANS('DEPARTMENT') . ' | ';
$htmlTable .= '
';
/**
* Formatação exclusiva para os emails - Cabeçalhos
*/
$mailTableTdStyle = 'align="center" bgcolor="#dcdcdc" width="300" height="35" style="font-family:Arial;"
';
$mailTable = "";
$mailTable .= '';
$mailTable .= '';
$mailTable .= '';
$mailTable .= '| ' . TRANS('ASSET_TYPE') . ' | ';
$mailTable .= '' . TRANS('ASSET_TAG_TAG') . ' | ';
$mailTable .= '' . TRANS('COL_UNIT') . ' | ';
$mailTable .= '' . TRANS('CLIENT') . ' | ';
$mailTable .= '' . TRANS('DEPARTMENT') . ' | ';
$mailTable .= '
';
$mailTable .= '';
foreach ($assets_info as $asset) {
$asset_description = $asset['tipo_nome'] . ' ' . $asset['fab_nome'] . ' ' . $asset['marc_nome'];
/** Formatação para o PDF */
$htmlTable .= '';
$htmlTable .= '| ' . $asset_description . ' | ';
$htmlTable .= '' . $asset['comp_inv'] . ' | ';
$htmlTable .= '' . $asset['inst_nome'] . ' | ';
$htmlTable .= '' . $asset['cliente'] . ' | ';
$htmlTable .= '' . $asset['local'] . ' | ';
$htmlTable .= '
';
/** Formatação para o email */
$mailTable .= '';
$mailTable .= '| ' . $asset_description . ' | ';
$mailTable .= '' . $asset['comp_inv'] . ' | ';
$mailTable .= '' . $asset['inst_nome'] . ' | ';
$mailTable .= '' . $asset['cliente'] . ' | ';
$mailTable .= '' . $asset['local'] . ' | ';
$mailTable .= '
';
}
$htmlTable .= '
';
$mailTable .= '
';
$tableVar['%tabela_de_ativos%'] = $htmlTable;
$singleVars = [];
$singleVars['%usuario_responsavel%'] = $userInfo['nome'];
// $singleVars['%data_e_hora%'] = date("d/m/Y H:i:s");
$singleVars['%data_e_hora%'] = dateScreen($uploaded_at);
// $singleVars['%data%'] = date("d/m/Y");
$singleVars['%data%'] = dateScreen($uploaded_at, null, 'd/m/Y');
$signed_at = null;
if ($data['action'] == 'sign') {
$signed_at = date("Y-m-d H:i:s");
$singleVars['%data_assinatura%'] = date("d/m/Y H:i");
$singleVars['%assinatura%'] = '
';
}
$vars = array_merge($tableVar, $singleVars);
$commitmentTermInfo['html_content'] = transvars($commitmentTermInfo['html_content'], $vars);
if (empty($data['action']) || $data['action'] == 'sign') {
$dompdf = new Dompdf();
$dompdf->loadHtml($commitmentTermInfo['html_content']);
$dompdf->setPaper('A4', 'portrait');
// Render the HTML as PDF
$dompdf->render();
$output = $dompdf->output();
// Output the generated PDF to Browser
// $dompdf->stream();
// $dompdf->stream('documento.pdf',['Attachment'=>false] );
// $dompdf->stream('documento.pdf');
$slugUserName = generate_slug($userInfo['nome']);
$db_filename = generate_slug(TRANS('COMMITMENT_TERM')) . '_' . $slugUserName . '.pdf';
$tmp_file_prefix = 'oc_';
$tmp_dir = sys_get_temp_dir();
$tmp_path_and_name = tempnam($tmp_dir, $tmp_file_prefix);
file_put_contents($tmp_path_and_name, $output);
/* Trabalhando diretamente sobre o buffer : finfo::buffer */
// $finfo = new finfo(FILEINFO_MIME);
// $finfo = new finfo(FILEINFO_EXTENSION);
// $finfo = new finfo();
// echo $finfo->buffer($output);
// exit;
$file_size = filesize($tmp_path_and_name);
// $mime_type = mime_content_type("{$tmp_path_and_name}");
$mime_type = "application/pdf";
/* Removendo o arquivo temporário */
unlink($tmp_path_and_name);
$sql = "INSERT INTO users_x_files
(
user_id,
file_type,
html_doc,
file,
file_name,
mime_type,
file_size,
uploaded_at,
signed_at
)
VALUES
(
{$data['user_id']},
1,
:html_doc,
:file,
:file_name,
:mime,
:file_size,
:uploaded_at,
:signed_at
)
";
try {
$res = $conn->prepare($sql);
$res->bindParam(':html_doc', $commitmentTermInfo['html_content']);
$res->bindParam(':file', $output);
$res->bindParam(':file_name', $db_filename);
$res->bindParam(':mime', $mime_type);
$res->bindParam(':file_size', $file_size);
$res->bindParam(':uploaded_at', $uploaded_at);
$res->bindParam(':signed_at', $signed_at);
$res->execute();
$data['success'] = true;
$data['message'] = TRANS($successMsgIdx);
$data['message'] = message('success', '', $data['message'], '');
$_SESSION['flash'] = message('success', '', TRANS($successMsgIdx), '', '');
} catch (\PDOException $e) {
$data['success'] = false;
$data['message'] = message('warning', 'Ooops!', $e->getMessage() . '
' . $sql,'');
echo json_encode($data);
return false;
}
} elseif ($data['action'] == 'update_html_doc') {
/* Apenas atualizar a coluna html_doc */
if (!empty($termInfo) && empty($termInfo['html_doc'])) {
$sql = "UPDATE users_x_files
SET
html_doc = :html_doc
WHERE
id = :id
";
try {
$res = $conn->prepare($sql);
$res->bindParam(':html_doc', $commitmentTermInfo['html_content']);
$res->bindParam(':id', $termInfo['id']);
$res->execute();
$data['success'] = true;
$data['message'] = TRANS('HTML_DOC_UPDATED');
echo json_encode($data);
return false;
} catch (\PDOException $e) {
$data['success'] = false;
$data['message'] = message('warning', 'Ooops!', $e->getMessage() . '
' . $sql,'');
echo json_encode($data);
return false;
}
}
}
if (empty($data['action'])) {
/**
* Enviar email para o usuário responsável pelos ativos registrados
*/
$vars['%tabela_de_ativos%'] = $mailTable;
$mailSendMethod = 'send';
if ($mailConfig['mail_queue']) {
$mailSendMethod = 'queue';
}
if ($data['sendEmailToUser']) {
$event = "term-to-user";
$eventTemplate = getEventMailConfig($conn, $event);
$recipient = $userInfo['email'];
/* Disparo do e-mail (ou fila no banco) para o usuário */
$mail = (new Email())->bootstrap(
transvars($eventTemplate['msg_subject'], $vars),
transvars($eventTemplate['msg_body'], $vars),
$recipient,
$eventTemplate['msg_fromname']
);
if (!$mail->{$mailSendMethod}()) {
$mailNotification .= "
" . TRANS('EMAIL_NOT_SENT') . "
" . $mail->message()->getText();
}
}
}
/**
* Atualização da tabela pivot
* Bool $hasTerm
* Bool $isTermUpdated
* Bool $isTermSigned
* String $signedAt
*/
$updatePivotTable = insertOrUpdateUsersTermsPivotTable($conn, $data['user_id'], $isTermUpdated, $isTermSigned, $signedAt);
echo json_encode($data);
return true;
}
$data['success'] = false;
$data['message'] = TRANS('TERM_IS_ALREADY_UPDATED');
$data['message'] = message('success', '', $data['message'], '');
echo json_encode($data);
return true;