<?php

namespace Modules\CallLogs\Entities;

use Illuminate\Database\Eloquent\Model;
use Modules\Contacts\Entities\Contact;
use Modules\Leads\Entities\Lead;
use Modules\Platform\User\Entities\User;

class CallLog extends Model
{
    protected $table = 'call_logs';

    protected $fillable = [
        'linkedid',
        'phone_number',
        'gln',
        'direction',
        'call_date',
        'duration',
        'talktime',
        'ringtime',
        'subject',
        'outcome',
        'status',
        'source',
        'queue',
        'notes',
        'follow_up_date',
        'follow_up_note',
        'lead_id',
        'contact_id',
        'user_id',
        'custom_data',
        'survey',
    ];

    protected $casts = [
        'call_date'      => 'datetime',
        'follow_up_date' => 'date',
        'duration'       => 'integer',
        'talktime'       => 'integer',
        'ringtime'       => 'integer',
        'user_id'        => 'integer',
        'lead_id'        => 'integer',
        'contact_id'     => 'integer',
        'custom_data'    => 'array',
        'survey'         => 'array',
    ];

    // ── Relationships ─────────────────────────────────────────────────────────

    public function user()
    {
        return $this->belongsTo(User::class);
    }

    public function lead()
    {
        return $this->belongsTo(Lead::class);
    }

    public function contact()
    {
        return $this->belongsTo(Contact::class);
    }

    // ── Scopes ────────────────────────────────────────────────────────────────

    public function scopeForLinkedid($query, string $linkedid)
    {
        return $query->where('linkedid', $linkedid);
    }

    public function scopeWithFollowUp($query)
    {
        return $query->whereNotNull('follow_up_date');
    }

    public function scopeDueFollowUps($query)
    {
        return $query->whereNotNull('follow_up_date')
            ->whereDate('follow_up_date', '<=', now()->toDateString());
    }

    // ── Helpers ───────────────────────────────────────────────────────────────

    /** Human-readable call duration (e.g. "03:12") */
    public function formattedDuration(): string
    {
        $secs = $this->duration ?? 0;
        return sprintf('%02d:%02d', intdiv($secs, 60), $secs % 60);
    }

    /** Returns true when a follow-up is scheduled and not yet past due. */
    public function hasPendingFollowUp(): bool
    {
        return $this->follow_up_date && $this->follow_up_date->isFuture();
    }
}