<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\Storage;
use Illuminate\Database\Eloquent\SoftDeletes;
use Carbon\Carbon;

class CryptoNewsModel extends Model
{
    use SoftDeletes;
    /**
     * Table name
     */
    protected $table = 'crypto_news';

    /**
     * Mass-assignable attributes
     */
    protected $fillable = [
        'author_id',
        'author_name',
        'user_id',
        'is_gabbar',
        'is_featured',
        'channel_id',
        'is_home',
        'title',
        'alias',
        'interlink_id',
        'h1_title',
        'h2_title',
        'short_desc',
        'description',
        'url',
        'image',
        'img_alt_title',
        'is_thumb',
        'urlToImage',
        'word_file',
        'key_takeaways_json',
        'lang',
        'tags',
        'status',
        'is_active',
        'coin_id',
        'unique_name',
        'is_rss_feed',
        'is_news_blog',
        'is_paid',
        'is_organic',
        'is_cryptotax',
        'is_seo_check',
        'publishedAt',
        'focus_keyword',
        'seo_title',
        'meta_keywords',
        'meta_description',
        'likes_counts',
        'other_status',
        'article',
        'breadcrumbs',
        'course_info',
        'data_set',
        'discussion_forum',
        'events',
        'faq',
        'image_metadata',
        'project_name',
        'project_website',
        'new_article',
        'paywalled_content',
        'product',
        'profile',
        'organization',
        'review_snippets',
        'sitelinks',
        'video',
        'dynamic_rss_feed',
        'dataset_level',
        'dataset_json',
        'update_status',
        'faqs',
        'prompt_instructions'
    ];

    /**
     * Relationships
     */
    public function postAuthor()
    {
        return $this->hasOne(\App\Models\Authormodel::class, 'id', 'author_id')
            ->select('id', 'user_id', 'slug', 'dispaly_name', 'about_us');
    }

    public function users()
    {
        return $this->hasOne(\App\Models\User::class, 'id', 'user_id');
    }

    public function createdBy()
    {
        return $this->hasOne(\App\Models\User::class, 'id', 'created_by');
    }

    /**
     * Accessor for image URL (S3 or fallback)
     */
    // public function getImageAttribute($value)
    // {
    //     if (!$value) {
    //         return asset('default-game.png');
    //     }

    //     // If already a full URL (not stored path), just return
    //     if (str_starts_with($value, 'http')) {
    //         return $value;
    //     }

    //     return Storage::disk('s3')->url($value);
    // }

    public function getImageAttribute($path)
    {
        $path = str_replace('public/', '', $path);
        $path2 = config('filesystems.custom.bucket_url') . '/' . $path;

        if ($path2 != '') {
            return $path2;
        } elseif (filter_var($path, FILTER_VALIDATE_URL)) {
            return $path;
        }

        return asset('webadmin/' . self::STORAGE_PREFIX . Storage::url($path));
    }

    /**
     * Accessor for formatted published date
     */
    public function getPublishedAtFormattedAttribute()
    {
        $ts = $this->publishedAt;

        if (!$ts) {
            return null;
        }

        $ts = (int) $ts;

        // handle timestamps in milliseconds
        if (strlen((string) $ts) > 10) {
            $ts = intdiv($ts, 1000);
        }

        return Carbon::createFromTimestamp($ts)->format('d M Y');
    }
}
