<?php

namespace App\Models;

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

#[Fillable([
    'user_id', 'platform', 'external_campaign_id', 'local_campaign_id',
    'local_google_ads_campaign_id', 'stat_date', 'spend', 'impressions', 'clicks',
    'ctr', 'cpc', 'conversions', 'conversion_value', 'payout', 'platform_status',
    'delivery_status', 'platform_payload', 'fetched_at', 'last_error',
])]
class CampaignPerformanceStat extends Model
{
    protected function casts(): array
    {
        return [
            'stat_date' => 'date',
            'spend' => 'decimal:2',
            'ctr' => 'decimal:4',
            'cpc' => 'decimal:4',
            'conversion_value' => 'decimal:2',
            'payout' => 'decimal:2',
            'platform_payload' => 'array',
            'fetched_at' => 'datetime',
        ];
    }

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

    public function localCampaign(): BelongsTo
    {
        return $this->belongsTo(Campaign::class, 'local_campaign_id');
    }

    public function localGoogleAdsCampaign(): BelongsTo
    {
        return $this->belongsTo(GoogleAdsCampaign::class, 'local_google_ads_campaign_id');
    }
}