<?php

namespace App\Models;

use Database\Factories\CampaignPerformanceHourStatFactory;
use Illuminate\Database\Eloquent\Attributes\Fillable;
use Illuminate\Database\Eloquent\Factories\HasFactory;
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_hour', 'spend', 'impressions', 'clicks',
    'ctr', 'cpc', 'platform_status', 'delivery_status', 'platform_payload',
    'fetched_at', 'last_error',
])]
class CampaignPerformanceHourStat extends Model
{
    /** @use HasFactory<CampaignPerformanceHourStatFactory> */
    use HasFactory;

    protected function casts(): array
    {
        return [
            'stat_hour' => 'datetime',
            'spend' => 'decimal:2',
            'ctr' => 'decimal:4',
            'cpc' => 'decimal:4',
            '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');
    }
}