<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\BelongsTo;

class MailUser extends Model
{
    protected $fillable = [
        'domain_id', 'localpart', 'email', 'display_name', 'password_hash',
        'is_active', 'quota_mb', 'is_system'
    ];

    protected $hidden = ['password_hash'];

    protected $casts = [
        'is_active' => 'bool',
        'is_system' => 'bool',
        'quota_mb' => 'int',
        'last_login_at' => 'datetime',
    ];

    public function domain(): BelongsTo
    {
        return $this->belongsTo(Domain::class);
    }

    // optional: virtueller Setter
    public function setPasswordAttribute(string $plain): void
    {
        $this->attributes['password_hash'] = password_hash($plain, PASSWORD_BCRYPT);
    }

    /**
     * KORREKT: DB-Wert hat Vorrang; falls leer → Fallback localpart@domain.domain
     */
    public function getEmailAttribute($value): ?string
    {
        if (!empty($value)) {
            return $value;
        }
        $local = (string)($this->attributes['localpart'] ?? $this->localpart ?? '');
        $dom = $this->relationLoaded('domain')
            ? (string)($this->domain->domain ?? '')
            : (string)($this->attributes['domain'] ?? '');

        if ($local !== '' && $dom !== '') {
            return "{$local}@{$dom}";
        }
        // nichts zusammenfummeln → nicht "@"
        return null;
    }

    /**
     * Adresse ohne Accessor/DB-Fallback erzwingen (z.B. in Queries vor-joined)
     */
    public function getAddressAttribute(): string
    {
        $raw = (string)($this->attributes['email'] ?? '');
        if ($raw !== '') return $raw;

        $local = (string)($this->attributes['localpart'] ?? $this->localpart ?? '');
        $dom = $this->relationLoaded('domain')
            ? (string)($this->domain->domain ?? '')
            : (string)($this->attributes['domain'] ?? '');

        return ($local !== '' && $dom !== '') ? "{$local}@{$dom}" : '';
    }

    // Scopes
    public function scopeActive($q)
    {
        return $q->where('is_active', true);
    }

    public function scopeSystem($q)
    {
        return $q->where('is_system', true);
    }

    public function scopeByEmail($q, string $email)
    {
        return $q->where('email', $email);
    }
}


//class MailUser extends Model
//{
////    protected $table = 'mail_users';
//
//    protected $fillable = [
//        'domain_id','localpart','email','display_name','password_hash',
//        'is_active','quota_mb','is_system'
//    ];
//
//    protected $hidden = ['password_hash'];
//    protected $casts  = [
//        'is_active'=>'bool',
//        'is_system' => 'boolean',
//        'quota_mb'=>'int',
//        'last_login_at'=>'datetime',
//    ];
//
//    public function domain(): BelongsTo {
//        return $this->belongsTo(Domain::class);
//    }
//
//    public function setPasswordAttribute(string $plain): void {
//        // optional: allow 'password' virtual attribute
//        $this->attributes['password_hash'] = password_hash($plain, PASSWORD_BCRYPT);
//    }
//
//    // Ausgabe: vollständige Adresse
//    public function getEmailAttribute(): string {
//        return "{$this->local_part}@{$this->domain->name}";
//    }
//
//    public function getAddressAttribute(): string
//    {
//        $local = (string)($this->attributes['localpart'] ?? $this->localpart ?? '');
//        // bevorzugt den in Queries selektierten Alias `dom`, sonst Relation, sonst Roh-Attribut
//        $dom   = (string)(
//            $this->attributes['dom']
//            ?? ($this->relationLoaded('domain') ? ($this->domain->domain ?? '') : '')
//            ?? ($this->attributes['domain'] ?? '')
//        );
//
//        if ($local !== '' && $dom !== '') return "{$local}@{$dom}";
//        if (($this->attributes['email'] ?? null) !== null) return (string)$this->attributes['email'];
//        return $dom !== '' ? "@{$dom}" : '';
//    }
//
//    // Scopes
//    public function scopeActive($q) { return $q->where('is_active', true); }
//
//    public function scopeSystem($q) { return $q->where('is_system', true); }
//
//    public function scopeByEmail($q, string $email) { return $q->where('email', $email); }
//
//}