[
'name' => 'Newsletter',
'subject' => 'Your monthly newsletter from {company_name}',
'method' => 'newsletter',
],
'6f8b1d4a-1c2e-4f3a-9a01-000000000002' => [
'name' => 'Announcement',
'subject' => 'Big news from {company_name}',
'method' => 'announcement',
],
'6f8b1d4a-1c2e-4f3a-9a01-000000000003' => [
'name' => 'Promotion',
'subject' => 'A special offer just for you',
'method' => 'promotion',
],
'6f8b1d4a-1c2e-4f3a-9a01-000000000004' => [
'name' => 'Welcome',
'subject' => 'Welcome to {company_name}, {first_name}',
'method' => 'welcome',
],
'6f8b1d4a-1c2e-4f3a-9a01-000000000005' => [
'name' => 'Re-engagement',
'subject' => 'We miss you, {first_name}',
'method' => 'reengagement',
],
];
public function up()
{
$table = config('laravel-crm.db_table_prefix').'email_templates';
$now = now();
foreach (self::TEMPLATES as $externalId => $template) {
$exists = DB::table($table)
->where('external_id', $externalId)
->exists();
if ($exists) {
continue;
}
DB::table($table)->insert([
'external_id' => $externalId,
'name' => $template['name'],
'subject' => $template['subject'],
'body' => $this->{$template['method']}(),
'is_system' => true,
'created_at' => $now,
'updated_at' => $now,
]);
}
}
public function down()
{
DB::table(config('laravel-crm.db_table_prefix').'email_templates')
->whereIn('external_id', array_keys(self::TEMPLATES))
->delete();
}
private function newsletter(): string
{
return <<Newsletter
Hi {first_name},
Here is a quick recap of what's been happening this month.
Highlights
- Highlight one — short description.
- Highlight two — short description.
- Highlight three — short description.
Read more — [add your link here]
Thanks for reading.
HTML;
}
private function announcement(): string
{
return <<We have news
Hi {first_name},
We have something exciting to share — a quick announcement we wanted you to hear first.
Replace this paragraph with the details of your announcement. Keep it short, clear, and link to anywhere your readers can learn more.
Learn more — [add your link here]
HTML;
}
private function promotion(): string
{
return <<A special offer
Hi {first_name},
Save 20% this week only.
For a limited time, enjoy a special discount as a thank-you for being part of our community.
Shop the sale — [add your link here]
Offer ends Sunday.
HTML;
}
private function welcome(): string
{
return <<Welcome
Hi {first_name},
Welcome aboard — we're glad you're here.
Getting started
- Step one — set up your profile.
- Step two — explore the basics.
- Step three — reach out if you need a hand.
Get started — [add your link here]
HTML;
}
private function reengagement(): string
{
return <<We miss you
Hi {first_name},
It has been a while — we wanted to check back in.
Here's a small token of appreciation for sticking with us. Click below to come back and see what's new.
Come back — [add your link here]
HTML;
}
}