<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;
use App\Models\WebsitesArchiveRequest;

class Website extends Model
{
    use HasFactory, SoftDeletes;

    protected $fillable = ['user_id', 'title', 'path', 'is_temp','stripe_subscription_id','cancelled_stripe_subscription_id','next_payment_date','is_cancellation_requested','server_meta','meta','usage','last_payment_date','cancels_at'];

    public function user()
    {
        return $this->belongsTo(User::class);
    }
    public function plan()
    {
        return $this->belongsTo(PricingPlan::class,'active_plan_id');
    }
    public function websiteArchiveRequestsCount($website_id)
    {
        $count = WebsitesArchiveRequest::where("website_id", $website_id)->count();

        return $count;
    }
    public function latestCompleteWebsiteArchiveRequest($website_id)
    {
        $request = WebsitesArchiveRequest::where("website_id", $website_id)->where("status","completed")->orderBy("id","desc")->first();

        return $request;
    }
    public function latestWebsiteArchiveRequest($website_id)
    {
        $request = WebsitesArchiveRequest::where("website_id", $website_id)->orderBy("id","desc")->first();

        return $request;
    }
}