feat: create PostCategoryFactory for generating post category data feat: create PostFactory for generating post data feat: add retry_requested_at column to services table feat: add vcenter provisioning fields to products table feat: add module_host_id to os table feat: create email_notification_templates table for email templates feat: add scenario and format fields to template table feat: add admin fields to transactions table fix: update ticket table columns and types feat: add uuid to ticket table and backfill existing records fix: make ticket_reply user_id nullable feat: create notifications table for user notifications fix: make ticket uuid nullable feat: create post_categories table for blog categories feat: create posts table for blog posts feat: add invoice email template for PDF generation
386 lines
17 KiB
PHP
386 lines
17 KiB
PHP
<?php
|
|
|
|
namespace App\Services;
|
|
|
|
use App\Models\EmailNotificationTemplate;
|
|
use App\Models\Invoice;
|
|
|
|
class EmailNotificationTemplateRenderer
|
|
{
|
|
public function render(EmailNotificationTemplate $tpl, Invoice $invoice, string $companyName = ''): string
|
|
{
|
|
$blocks = collect($tpl->blocks)
|
|
->filter(fn($b) => $b['enabled'] ?? false)
|
|
->sortBy('order')
|
|
->values();
|
|
|
|
$bodyHtml = '';
|
|
foreach ($blocks as $block) {
|
|
$bodyHtml .= $this->renderBlock($block, $invoice, $companyName);
|
|
}
|
|
|
|
$color = htmlspecialchars($tpl->header_color ?? '#1a56db');
|
|
$title = htmlspecialchars($tpl->header_title ?? 'Thông báo hóa đơn');
|
|
|
|
return $this->wrapLayout($title, $color, $bodyHtml, $companyName);
|
|
}
|
|
|
|
/**
|
|
* Render a vm_credentials template using the emailData array from SendVmCredentialsEmailJob.
|
|
* $emailData keys: company_name, client_name, product_name, product_billing, product_price,
|
|
* service_host, service_username, service_port, service_password, os_name, service_due_exp
|
|
*/
|
|
public function renderVmCredentials(EmailNotificationTemplate $tpl, array $emailData, ?Invoice $invoice = null): string
|
|
{
|
|
$blocks = collect($tpl->blocks)
|
|
->filter(fn($b) => $b['enabled'] ?? false)
|
|
->sortBy('order')
|
|
->values();
|
|
|
|
$companyName = $emailData['company_name'] ?? '';
|
|
$bodyHtml = '';
|
|
|
|
foreach ($blocks as $block) {
|
|
$bodyHtml .= match ($block['type'] ?? '') {
|
|
'greeting' => $this->renderGreetingFromData($emailData),
|
|
'vm_credentials' => $this->renderVmBlock($emailData, $block['config'] ?? []),
|
|
'product_info' => $this->renderProductInfoBlock($emailData, $block['config'] ?? []),
|
|
'invoice_info' => $invoice ? $this->renderInvoiceInfo($invoice, $block['config'] ?? []) : '',
|
|
'order_items' => $invoice ? $this->renderOrderItems($invoice) : '',
|
|
'attachments' => $invoice ? $this->renderAttachments($invoice) : '',
|
|
'custom_text' => $this->renderCustomText($block['config'] ?? []),
|
|
'footer' => $this->renderFooterBlock($companyName),
|
|
default => '',
|
|
};
|
|
}
|
|
|
|
$color = htmlspecialchars($tpl->header_color ?? '#1a56db');
|
|
$title = htmlspecialchars($tpl->header_title ?? 'Thông tin truy cập VPS');
|
|
|
|
return $this->wrapLayout($title, $color, $bodyHtml, $companyName);
|
|
}
|
|
|
|
public function renderPreview(EmailNotificationTemplate $tpl): string
|
|
{
|
|
if ($tpl->type === 'vm_credentials') {
|
|
return $this->renderVmCredentials($tpl, $this->sampleVmData(), null);
|
|
}
|
|
|
|
$invoice = $this->sampleInvoice();
|
|
return $this->render($tpl, $invoice, 'Công ty Demo');
|
|
}
|
|
|
|
// ─── Block renderers ──────────────────────────────────────────────────────
|
|
|
|
private function renderBlock(array $block, Invoice $invoice, string $companyName): string
|
|
{
|
|
return match ($block['type'] ?? '') {
|
|
'greeting' => $this->renderGreeting($invoice),
|
|
'invoice_info' => $this->renderInvoiceInfo($invoice, $block['config'] ?? []),
|
|
'customer_info'=> $this->renderCustomerInfo($invoice, $block['config'] ?? []),
|
|
'order_items' => $this->renderOrderItems($invoice),
|
|
'attachments' => $this->renderAttachments($invoice),
|
|
'custom_text' => $this->renderCustomText($block['config'] ?? []),
|
|
'footer' => $this->renderFooterBlock($companyName),
|
|
default => '',
|
|
};
|
|
}
|
|
|
|
private function renderGreeting(Invoice $invoice): string
|
|
{
|
|
$name = htmlspecialchars($invoice->customer?->fullname ?? 'Quý khách');
|
|
return "<p>Xin chào <strong>{$name}</strong>,</p>\n";
|
|
}
|
|
|
|
private function renderGreetingFromData(array $data): string
|
|
{
|
|
$name = htmlspecialchars($data['client_name'] ?? 'Quý khách');
|
|
return "<p>Xin chào <strong>{$name}</strong>,</p>\n";
|
|
}
|
|
|
|
private function renderVmBlock(array $data, array $config): string
|
|
{
|
|
$fields = $config['fields'] ?? ['service_host', 'service_username', 'service_port', 'service_password', 'os_name'];
|
|
|
|
$fieldMap = [
|
|
'service_host' => ['Địa chỉ IP', $data['service_host'] ?? '—'],
|
|
'service_username' => ['Username', $data['service_username'] ?? '—'],
|
|
'service_port' => ['Port', (string)($data['service_port'] ?? '—')],
|
|
'service_password' => ['Mật khẩu', $data['service_password'] ?? '—'],
|
|
'os_name' => ['Hệ điều hành', $data['os_name'] ?? '—'],
|
|
];
|
|
|
|
$rows = '';
|
|
foreach ($fields as $key) {
|
|
if (!isset($fieldMap[$key])) continue;
|
|
[$label, $raw] = $fieldMap[$key];
|
|
$value = htmlspecialchars($raw);
|
|
// Highlight password with monospace
|
|
$display = $key === 'service_password'
|
|
? "<code style=\"background:#f3f4f6;padding:2px 6px;border-radius:4px;font-size:13px\">{$value}</code>"
|
|
: $value;
|
|
$rows .= "<tr><td style=\"padding:7px 0;font-size:14px;color:#6b7280;width:160px\">{$label}</td>"
|
|
. "<td style=\"padding:7px 0;font-size:14px;font-weight:600;color:#111827\">{$display}</td></tr>\n";
|
|
}
|
|
|
|
return <<<HTML
|
|
<div style="background:#f0f9ff;border:1px solid #bae6fd;border-radius:8px;padding:20px 24px;margin:20px 0">
|
|
<p style="margin:0 0 12px;font-size:13px;font-weight:700;color:#0369a1;text-transform:uppercase;letter-spacing:.05em">🖥️ Thông tin truy cập VPS</p>
|
|
<table style="width:100%;border-collapse:collapse">{$rows}</table>
|
|
</div>
|
|
HTML;
|
|
}
|
|
|
|
private function renderProductInfoBlock(array $data, array $config): string
|
|
{
|
|
$fields = $config['fields'] ?? ['product_name', 'product_billing', 'product_price', 'service_due_exp'];
|
|
|
|
$fieldMap = [
|
|
'product_name' => ['Tên dịch vụ', $data['product_name'] ?? '—'],
|
|
'product_billing' => ['Chu kỳ thanh toán', $data['product_billing'] ?? '—'],
|
|
'product_price' => ['Giá dịch vụ', ($data['product_price'] ?? '0') . ' VNĐ'],
|
|
'service_due_exp' => ['Ngày hết hạn', $data['service_due_exp'] ?? '—'],
|
|
];
|
|
|
|
$rows = '';
|
|
foreach ($fields as $key) {
|
|
if (!isset($fieldMap[$key])) continue;
|
|
[$label, $value] = $fieldMap[$key];
|
|
$value = htmlspecialchars($value);
|
|
$rows .= "<tr><td style=\"padding:6px 0;font-size:14px;color:#6b7280;width:160px\">{$label}</td>"
|
|
. "<td style=\"padding:6px 0;font-size:14px;font-weight:600;color:#111827\">{$value}</td></tr>\n";
|
|
}
|
|
|
|
return <<<HTML
|
|
<div style="background:#f9fafb;border:1px solid #e5e7eb;border-radius:6px;padding:20px 24px;margin:20px 0">
|
|
<p style="margin:0 0 12px;font-size:13px;font-weight:600;color:#6b7280;text-transform:uppercase;letter-spacing:.05em">Thông tin dịch vụ</p>
|
|
<table style="width:100%;border-collapse:collapse">{$rows}</table>
|
|
</div>
|
|
HTML;
|
|
}
|
|
|
|
private function renderInvoiceInfo(Invoice $invoice, array $config): string
|
|
{
|
|
$fields = $config['fields'] ?? ['invoice_number', 'created_at', 'due_date', 'total', 'status'];
|
|
|
|
$rows = '';
|
|
foreach ($fields as $field) {
|
|
$rows .= $this->invoiceRow($field, $invoice);
|
|
}
|
|
|
|
return <<<HTML
|
|
<div style="background:#f9fafb;border:1px solid #e5e7eb;border-radius:6px;padding:20px 24px;margin:20px 0">
|
|
<table style="width:100%;border-collapse:collapse">
|
|
{$rows}
|
|
</table>
|
|
</div>
|
|
HTML;
|
|
}
|
|
|
|
private function invoiceRow(string $field, Invoice $invoice): string
|
|
{
|
|
[$label, $value] = match ($field) {
|
|
'invoice_number' => ['Số hóa đơn', '#' . ($invoice->invoice_number ?? '—')],
|
|
'created_at' => ['Ngày tạo', $invoice->created_at ? $invoice->created_at->format('d/m/Y') : '—'],
|
|
'due_date' => ['Hạn thanh toán', $invoice->due_date ? date('d/m/Y', strtotime($invoice->due_date)) : '—'],
|
|
'total' => ['Tổng tiền', number_format((float)$invoice->total) . ' VNĐ'],
|
|
'sub_total' => ['Tiền dịch vụ', number_format((float)$invoice->sub_total) . ' VNĐ'],
|
|
'tax' => ['Thuế', number_format((float)$invoice->tax) . ' VNĐ'],
|
|
'status' => ['Trạng thái', $this->statusBadge((int)$invoice->status)],
|
|
'payment_method' => ['Phương thức TT', htmlspecialchars($invoice->payment_method ?? '—')],
|
|
default => [$field, '—'],
|
|
};
|
|
|
|
return "<tr><td style=\"padding:6px 0;font-size:14px;color:#6b7280;width:160px\">{$label}</td>"
|
|
. "<td style=\"padding:6px 0;font-size:14px;font-weight:600;color:#111827\">{$value}</td></tr>\n";
|
|
}
|
|
|
|
private function statusBadge(int $status): string
|
|
{
|
|
return match ($status) {
|
|
2 => '<span style="color:#059669">Đã thanh toán</span>',
|
|
1 => '<span style="color:#dc2626">Chưa thanh toán</span>',
|
|
default => '<span style="color:#9ca3af">Đã hủy</span>',
|
|
};
|
|
}
|
|
|
|
private function renderCustomerInfo(Invoice $invoice, array $config): string
|
|
{
|
|
$fields = $config['fields'] ?? ['name', 'email'];
|
|
$customer = $invoice->customer;
|
|
if (!$customer) return '';
|
|
|
|
$rows = '';
|
|
foreach ($fields as $field) {
|
|
[$label, $value] = match ($field) {
|
|
'name' => ['Tên khách hàng', htmlspecialchars($customer->fullname ?? '—')],
|
|
'email' => ['Email', htmlspecialchars($customer->email ?? '—')],
|
|
'address' => ['Địa chỉ', htmlspecialchars($customer->address ?? '—')],
|
|
default => [$field, '—'],
|
|
};
|
|
$rows .= "<tr><td style=\"padding:4px 0;font-size:14px;color:#6b7280;width:140px\">{$label}</td>"
|
|
. "<td style=\"padding:4px 0;font-size:14px;color:#111827\">{$value}</td></tr>\n";
|
|
}
|
|
|
|
return <<<HTML
|
|
<div style="background:#f9fafb;border:1px solid #e5e7eb;border-radius:6px;padding:16px 24px;margin:16px 0">
|
|
<p style="margin:0 0 10px;font-size:13px;font-weight:600;color:#6b7280;text-transform:uppercase;letter-spacing:.05em">Thông tin khách hàng</p>
|
|
<table style="width:100%;border-collapse:collapse">{$rows}</table>
|
|
</div>
|
|
HTML;
|
|
}
|
|
|
|
private function renderOrderItems(Invoice $invoice): string
|
|
{
|
|
$order = $invoice->order;
|
|
if (!$order) return '';
|
|
|
|
$order->loadMissing('orderItems.product');
|
|
$items = $order->orderItems;
|
|
if ($items->isEmpty()) return '';
|
|
|
|
$cycleMap = [
|
|
'monthly' => 'Hàng tháng', 'quarterly' => 'Hàng quý',
|
|
'semi_annually' => '6 tháng', 'annually' => 'Hàng năm', 'biennially' => '2 năm',
|
|
];
|
|
|
|
$rows = '';
|
|
foreach ($items as $item) {
|
|
$name = htmlspecialchars($item->product?->name ?? '—');
|
|
$server = htmlspecialchars($item->server_name ?? '—');
|
|
$cycle = htmlspecialchars($cycleMap[$item->billing_cycle] ?? ($item->billing_cycle ?? '—'));
|
|
$price = number_format((float) $item->price) . ' VNĐ';
|
|
|
|
$rows .= "<tr style=\"border-top:1px solid #e5e7eb\">"
|
|
. "<td style=\"padding:10px 12px;font-size:13px;font-weight:600;color:#111827\">{$name}</td>"
|
|
. "<td style=\"padding:10px 12px;font-size:13px;color:#6b7280\">{$server}</td>"
|
|
. "<td style=\"padding:10px 12px;font-size:13px;color:#6b7280\">{$cycle}</td>"
|
|
. "<td style=\"padding:10px 12px;font-size:13px;font-weight:600;text-align:right\">{$price}</td>"
|
|
. "</tr>\n";
|
|
}
|
|
|
|
return <<<HTML
|
|
<div style="margin:20px 0;border:1px solid #e5e7eb;border-radius:6px;overflow:hidden">
|
|
<table style="width:100%;border-collapse:collapse">
|
|
<thead>
|
|
<tr style="background:#f3f4f6">
|
|
<th style="padding:10px 12px;text-align:left;font-size:12px;color:#6b7280;font-weight:600;text-transform:uppercase">Sản phẩm</th>
|
|
<th style="padding:10px 12px;text-align:left;font-size:12px;color:#6b7280;font-weight:600;text-transform:uppercase">Server</th>
|
|
<th style="padding:10px 12px;text-align:left;font-size:12px;color:#6b7280;font-weight:600;text-transform:uppercase">Chu kỳ</th>
|
|
<th style="padding:10px 12px;text-align:right;font-size:12px;color:#6b7280;font-weight:600;text-transform:uppercase">Giá</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody>{$rows}</tbody>
|
|
</table>
|
|
</div>
|
|
HTML;
|
|
}
|
|
|
|
private function renderAttachments(Invoice $invoice): string
|
|
{
|
|
$invoice->loadMissing('attachments');
|
|
if ($invoice->attachments->isEmpty()) return '';
|
|
|
|
$items = '';
|
|
foreach ($invoice->attachments as $file) {
|
|
$name = htmlspecialchars($file->filename);
|
|
$url = htmlspecialchars($file->url ?? '#');
|
|
$items .= "<li style=\"margin-bottom:6px;font-size:14px\"><a href=\"{$url}\" style=\"color:#1a56db;text-decoration:none\">{$name}</a></li>\n";
|
|
}
|
|
|
|
return <<<HTML
|
|
<div style="margin:20px 0">
|
|
<p style="font-size:14px;font-weight:600;margin:0 0 8px;color:#374151">File đính kèm</p>
|
|
<ul style="padding-left:16px;margin:0">{$items}</ul>
|
|
</div>
|
|
HTML;
|
|
}
|
|
|
|
private function renderCustomText(array $config): string
|
|
{
|
|
$content = $config['content'] ?? '';
|
|
if (!$content) return '';
|
|
|
|
// If plain text (no HTML tags), wrap in <p>
|
|
$html = strip_tags($content) === $content
|
|
? '<p>' . htmlspecialchars($content) . '</p>'
|
|
: $content;
|
|
|
|
return "<div style=\"margin:16px 0;font-size:14px;line-height:1.7;color:#374151\">{$html}</div>\n";
|
|
}
|
|
|
|
private function renderFooterBlock(string $companyName): string
|
|
{
|
|
$company = htmlspecialchars($companyName ?: config('app.name', 'Công ty'));
|
|
$year = date('Y');
|
|
return "<p style=\"margin:20px 0 0\">Trân trọng,<br><strong>{$company}</strong></p>\n";
|
|
}
|
|
|
|
// ─── Layout wrapper ───────────────────────────────────────────────────────
|
|
|
|
private function wrapLayout(string $title, string $color, string $body, string $companyName): string
|
|
{
|
|
$company = htmlspecialchars($companyName ?: config('app.name', 'Công ty'));
|
|
$year = date('Y');
|
|
|
|
return <<<HTML
|
|
<!DOCTYPE html>
|
|
<html lang="vi">
|
|
<head>
|
|
<meta charset="UTF-8">
|
|
<meta name="viewport" content="width=device-width,initial-scale=1.0">
|
|
<title>{$title}</title>
|
|
</head>
|
|
<body style="font-family:Arial,sans-serif;background:#f4f4f4;margin:0;padding:0">
|
|
<div style="max-width:640px;margin:30px auto;background:#fff;border-radius:8px;overflow:hidden;box-shadow:0 2px 8px rgba(0,0,0,.08)">
|
|
<div style="background:{$color};padding:24px 32px">
|
|
<h1 style="color:#fff;margin:0;font-size:22px">{$title}</h1>
|
|
</div>
|
|
<div style="padding:32px;color:#374151">
|
|
{$body}
|
|
</div>
|
|
<div style="background:#f9fafb;border-top:1px solid #e5e7eb;padding:20px 32px;text-align:center;font-size:13px;color:#9ca3af">
|
|
© {$year} {$company}. Đây là email tự động, vui lòng không trả lời.
|
|
</div>
|
|
</div>
|
|
</body>
|
|
</html>
|
|
HTML;
|
|
}
|
|
|
|
// ─── Sample data for preview ──────────────────────────────────────────────
|
|
|
|
private function sampleVmData(): array
|
|
{
|
|
return [
|
|
'company_name' => 'Công ty Demo',
|
|
'company_logo' => '',
|
|
'client_name' => 'Nguyễn Văn A',
|
|
'product_name' => 'VPS Starter',
|
|
'product_billing' => 'Hàng tháng',
|
|
'product_price' => '420.000',
|
|
'service_host' => '203.113.x.x',
|
|
'service_username' => 'root',
|
|
'service_port' => '22',
|
|
'service_password' => 'P@ssw0rd!2026',
|
|
'os_name' => 'Ubuntu 22.04 LTS',
|
|
'service_due_exp' => date('d/m/Y', strtotime('+1 month')),
|
|
];
|
|
}
|
|
|
|
private function sampleInvoice(): Invoice
|
|
{
|
|
$invoice = new Invoice([
|
|
'invoice_number' => 'INV-20260521-00001',
|
|
'sub_total' => 420000,
|
|
'tax' => 0,
|
|
'total' => 420000,
|
|
'status' => 2,
|
|
'payment_method' => 'credit',
|
|
]);
|
|
$invoice->created_at = now();
|
|
$invoice->due_date = now()->addDays(7)->toDateString();
|
|
return $invoice;
|
|
}
|
|
}
|