EmailTemplate.php

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

/**
 * DB-backed email template with hardcoded fallbacks.
 *
 * Slugs in use:
 *   project-created, project-activated,
 *   order-placed, order-paid, order-status-changed,
 *   subscription-activated, report-released, report-approved
 *
 * Shortcodes: {{user_name}}, {{site_name}}, {{project_title}},
 *             {{plan_name}}, {{amount}}, {{date}}
 */
class EmailTemplate extends Model
{
    protected $fillable = ['slug', 'subject', 'body', 'is_active'];

    protected $casts = ['is_active' => 'boolean'];

    /**
     * Hardcoded fallback templates used when a slug is not found in the DB.
     * Structure: ['slug' => ['subject' => '...', 'body' => '...']]
     */
    protected static array $defaults = [
        'project-created'       => [/* subject and body with shortcodes */],
        'order-placed'          => [/* ... */],
        'order-paid'            => [/* ... */],
        'subscription-activated'=> [/* ... */],
        'report-released'       => [/* ... */],
        'report-approved'       => [/* ... */],
    ];

    public static function getBySlug(string $slug): ?array
    {
        // DB lookup first; fall back to self::$defaults[$slug] if not found
        // Returns ['subject' => string, 'body' => string] or null
        // ...
    }
}