<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Job extends Model
{
    protected $table = 'jobs';

    protected $appends = ['progressedLink', 'totalLink'];

    protected $fillable = ['id', 'name', 'slug', 'command', 'site', 'schedule', 'status', 'created_at', 'updated_at'];

    public function link()
    {
        return $this->hasMany(Link::class, 'job_id', 'id');
    }

    public function progressed()
    {
        return $this->hasMany(Link::class, 'job_id', 'id')->where('status', 2);
    }

    public function getTotalLinkAttribute() {
        return $this->link()->count();
    }

    public function getProgressedLinkAttribute() {
        return $this->progressed()->count();
    }
}