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();
$auth = new AuthNew($_SESSION['s_logado'], $_SESSION['s_nivel'], 2, 1);
$exception = "";
$data = [];
$data['success'] = true;
$mailConfig = getMailConfig($conn);
$data['sendEmailToAuthorizer'] = true;
$post = $_POST;
$info_id = "";
$data['csrf_session_key'] = (isset($post['csrf_session_key']) ? $post['csrf_session_key'] : "");
$data['main_asset_id'] = (isset($post['main_asset_id']) && !empty($post['main_asset_id']) ? (int)$post['main_asset_id'] : []);
$data['asset_tags'] = (isset($post['assetTag']) && !empty($post['assetTag']) ? array_map('noHtml', $post['assetTag']) : []);
$data['asset_units'] = (isset($post['asset_unit']) && !empty($post['asset_unit']) ? array_map('intval', $post['asset_unit']) : []);
$data['carrier'] = (isset($post['carrier']) && !empty($post['carrier']) ? noHtml($post['carrier']) : "");
$data['destination'] = (isset($post['destination']) && !empty($post['destination']) ? noHtml($post['destination']) : "");
$data['authorized_by'] = (isset($post['authorized_by']) && !empty($post['authorized_by']) ? (int)$post['authorized_by'] : "");
$data['responsible_area'] = (isset($post['responsible_area']) && !empty($post['responsible_area']) ? (int)$post['responsible_area'] : "");
$data['reason'] = (isset($post['reason']) && !empty($post['reason']) ? noHtml($post['reason']) : "");
$data['author'] = $_SESSION['s_uid'];
$data['term_id'] = (isset($post['term_id']) && !empty($post['term_id']) ? (int)$post['term_id'] : "");
if (count($data['asset_tags']) != count($data['asset_units'])) {
$data['success'] = false;
$data['message'] = message('warning', 'Ooops!', TRANS('CHECK_FILLED_DATA'),'');
echo json_encode($data);
return false;
}
if (empty($data['main_asset_id']) && empty($data['asset_units'])) {
$data['success'] = false;
$data['message'] = message('warning', 'Ooops!', TRANS('AT_LEAST_ONE_ASSET_IS_REQUIRED'),'');
echo json_encode($data);
return false;
}
function arrayHasDuplicates($array) {
return count($array) !== count(array_unique($array));
}
/* Tratamento dos ativos */
$assets_new = [];
$i = 0;
foreach ($data['asset_tags'] as $key => $tag) {
$assets_new[$i][] = $tag;
$assets_new[$i][] = $data['asset_units'][$i];
$i++;
}
$new_asset_ids = [];
foreach ($assets_new as $key => $asset) {
$new_asset_ids[] = getAssetIdFromTag($conn, $asset[1], $asset[0]);
}
/* Remove valores nulos */
$new_asset_ids = array_filter($new_asset_ids, static function($var){return $var !== null;});
$new_asset_ids = array_merge($new_asset_ids, [$data['main_asset_id']]);
if (arrayHasDuplicates($new_asset_ids)) {
$data['success'] = false;
$data['message'] = message('warning', 'Ooops!', TRANS('MSG_DUPLICATE_RECORD'),'');
echo json_encode($data);
return false;
}
$textNewAssetIds = implode(',', $new_asset_ids);
if (empty($data['carrier'])) {
$data['success'] = false;
$data['field_id'] = 'carrier';
$data['message'] = message('warning', 'Ooops!', TRANS('MSG_EMPTY_DATA'),'');
echo json_encode($data);
return false;
} elseif (empty($data['destination'])) {
$data['success'] = false;
$data['field_id'] = 'destination';
$data['message'] = message('warning', 'Ooops!', TRANS('MSG_EMPTY_DATA'),'');
echo json_encode($data);
return false;
} elseif (empty($data['authorized_by'])) {
$data['success'] = false;
$data['field_id'] = 'authorized_by';
$data['message'] = message('warning', 'Ooops!', TRANS('MSG_EMPTY_DATA'),'');
echo json_encode($data);
return false;
} elseif (empty($data['responsible_area'])) {
$data['success'] = false;
$data['field_id'] = 'responsible_area';
$data['message'] = message('warning', 'Ooops!', TRANS('MSG_EMPTY_DATA'),'');
echo json_encode($data);
return false;
} elseif (empty($data['reason'])) {
$data['success'] = false;
$data['field_id'] = 'reason';
$data['message'] = message('warning', 'Ooops!', TRANS('MSG_EMPTY_DATA'),'');
echo json_encode($data);
return false;
}
$authorInfo = getUserInfo($conn, $_SESSION['s_uid']);
if (empty($authorInfo)) {
$data['success'] = false;
$data['message'] = message('warning', 'Ooops!', TRANS('SOME_ERROR_DONT_PROCEED') . $exception,'');
echo json_encode($data);
return false;
}
$authorizerInfo = getUserInfo($conn, $data['authorized_by']);
if (empty($authorizerInfo)) {
$data['success'] = false;
$data['message'] = message('warning', 'Ooops!', TRANS('SOME_ERROR_DONT_PROCEED') . $exception,'');
echo json_encode($data);
return false;
}
$areaInfo = getAreaInfo($conn, $data['responsible_area']);
if (empty($areaInfo)) {
$data['success'] = false;
$data['message'] = message('warning', 'Ooops!', TRANS('SOME_ERROR_DONT_PROCEED') . $exception,'');
echo json_encode($data);
return false;
}
// var_dump([
// 'post' => $post,
// 'data' => $data,
// 'new_asset_ids' => $new_asset_ids,
// 'textNewAssetIds' => $textNewAssetIds
// ]); exit;
if (!csrf_verify($post, $data['csrf_session_key'])) {
$data['success'] = false;
$data['message'] = message('warning', 'Ooops!', TRANS('FORM_ALREADY_SENT'),'');
echo json_encode($data);
return false;
}
/**
* Primeira parte: inserção das informações complementares em assets_traffic_info
*/
$sql = "INSERT
INTO
assets_traffic_info
(
carrier,
reason,
destination,
user_authorizer,
responsible_area,
author_id
)
VALUES
(
:carrier,
:reason,
:destination,
:user_authorizer,
:responsible_area,
:author_id
)
";
try {
$res = $conn->prepare($sql);
$res->bindParam(':carrier', $data['carrier'], PDO::PARAM_STR);
$res->bindParam(':reason', $data['reason'], PDO::PARAM_STR);
$res->bindParam(':destination', $data['destination'], PDO::PARAM_STR);
$res->bindParam(':user_authorizer', $data['authorized_by'], PDO::PARAM_INT);
$res->bindParam(':responsible_area', $data['responsible_area'], PDO::PARAM_INT);
$res->bindParam(':author_id', $data['author'], PDO::PARAM_INT);
$res->execute();
$info_id = $conn->lastInsertId();
} catch (\PDOException $e) {
$data['success'] = false;
$exception .= "
" .$e->getMessage();
$data['message'] = message('warning', 'Ooops!', TRANS('SOME_ERROR_DONT_PROCEED') . $exception,'');
echo json_encode($data);
return false;
}
/**
* Segunda parte, inserção em assets_x_traffic
*/
foreach ($new_asset_ids as $asset_id) {
$sql = "INSERT INTO assets_x_traffic
(
info_id,
asset_id
)
VALUES
(
:info_id,
:asset_id
)";
try {
$res = $conn->prepare($sql);
$res->bindParam(':info_id', $info_id);
$res->bindParam(':asset_id', $asset_id);
$res->execute();
} catch (\PDOException $e) {
$data['success'] = false;
$exception .= "
" .$e->getMessage();
$data['message'] = message('warning', 'Ooops!', TRANS('SOME_ERROR_DONT_PROCEED') . $exception,'');
echo json_encode($data);
return false;
}
}
/**
* Terceira parte: identificação e carregamento do modelo de formulário de trânsito
*/
if (!empty($data['term_id'])) {
$models = getCommitmentModels($conn, $data['term_id'], null, null, null);
} else {
$models = getCommitmentModels($conn, null, null, null, 2);
}
$trafficTermInfo = (!empty($models) ? $models[0] : []);
/**
* Quarta parte: Processo para transpor as variáveis de ambiente
*
* %tabela_de_ativos%
* %portador%
* %autor%
* %area_responsavel%
* %destino%
* %autorizado_por%
* %justificativa%
* %data_e_hora%
* %data%
*
*/
$assetVars = []; // variáveis dinâmicas relacionadas aos ativos presentes no formulário de trânsito
foreach ($new_asset_ids as $asset) {
$assets_info[] = getAssetBasicInfo($conn, $asset);
}
$assets_info = arraySortByColumn($assets_info, 'tipo_nome', SORT_ASC);
/**
* Formatação para a geração do PDF
*/
$htmlTable = <<< EOT
EOT;
$htmlTable .= '';
$htmlTable .= '';
$htmlTable .= '';
$htmlTable .= '| ' . TRANS('ASSET_TYPE') . ' | ';
$htmlTable .= '' . TRANS('SERIAL_NUMBER') . ' | ';
$htmlTable .= '' . TRANS('ASSET_TAG_TAG') . ' | ';
$htmlTable .= '' . TRANS('COL_UNIT') . ' | ';
$htmlTable .= '' . TRANS('CLIENT') . ' | ';
$htmlTable .= '' . TRANS('DEPARTMENT') . ' | ';
$htmlTable .= '
';
$htmlTable .= '';
/**
* Formatação exclusiva para os emails - Cabeçalhos
*/
$mailTableTdStyle = 'align="center" bgcolor="#dcdcdc" width="600" 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_sn'] . ' | ';
$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['%portador%'] = $data['carrier'];
$singleVars['%area_responsavel%'] = $areaInfo['area_name'];
$singleVars['%destino%'] = $data['destination'];
$singleVars['%autorizado_por%'] = $authorizerInfo['nome'];
$singleVars['%justificativa%'] = $data['reason'];
$singleVars['%autor%'] = $authorInfo['nome'];
$singleVars['%data_e_hora%'] = date("d/m/Y H:i:s");
$singleVars['%data%'] = date("d/m/Y");
$vars = array_merge($tableVar, $singleVars);
$trafficTermInfo['html_content'] = transvars($trafficTermInfo['html_content'], $vars);
/**
* Quinta parte: geração do arquivo pdf com base no modelo de formulário de trânsito
*/
$dompdf = new Dompdf();
$dompdf->loadHtml($trafficTermInfo['html_content']);
$dompdf->setPaper('A4', 'portrait');
// Render the HTML as PDF
$dompdf->render();
$output = $dompdf->output();
$dateString = date("ymdHis");
$db_filename = generate_slug(TRANS('TRAFFIC_FORM')) . '_' . $dateString . '.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);
$file_size = filesize($tmp_path_and_name);
$mime_type = "application/pdf";
/* Removendo o arquivo temporário */
unlink($tmp_path_and_name);
/**
* Sexta parte: Gravar o arquivo no banco de dados
*/
$sql = "INSERT
INTO
traffic_files
(
info_id,
file,
file_name,
mime_type,
file_size
)
VALUES
(
:info_id,
:file,
:file_name,
:mime_type,
:file_size
)
";
try {
$res = $conn->prepare($sql);
$res->bindParam(':info_id', $info_id);
$res->bindParam(':file', $output);
$res->bindParam(':file_name', $db_filename);
$res->bindParam(':mime_type', $mime_type);
$res->bindParam(':file_size', $file_size);
$res->execute();
} catch (\PDOException $e) {
$data['success'] = false;
$exception .= "
" .$e->getMessage();
$data['message'] = message('warning', 'Ooops!', TRANS('SOME_ERROR_DONT_PROCEED') . $exception,'');
echo json_encode($data);
return false;
}
/**
* Sexta parte: Enviar email para o usuário autorizador
*/
$vars['%tabela_de_ativos%'] = $mailTable;
$mailSendMethod = 'send';
if ($mailConfig['mail_queue']) {
$mailSendMethod = 'queue';
}
if ($data['sendEmailToAuthorizer']) {
$event = "traffic-term-to-authorizer";
$eventTemplate = getEventMailConfig($conn, $event);
$recipient = $authorizerInfo['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();
}
}
$data['success'] = true;
$data['message'] = TRANS('MSG_SUCCESSFULLY_GENERATED_TERM');
$_SESSION['flash'] = message('success', '', $data['message'] . $exception, '');
echo json_encode($data);
// dump($return);
return true;