<?php

namespace App\Models\Legal;

use App\Models\BaseModel;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\SoftDeletes;

/**
 * Class Song
 * @package App\Models\Legal
 */
class Song extends BaseModel
{
    use HasFactory,SoftDeletes;

    protected static $file_only = [1,2,4,11,12];

    /**
     * @return \Illuminate\Database\Eloquent\Relations\BelongsToMany
     */
    public function contractDetail()
    {
        return $this->belongsToMany(ContractDetail::class, 'contract_song', 'song_id', 'contract_detail_id');
    }

    /**
     * @return \Illuminate\Database\Eloquent\Relations\HasOne
     */
    public function coverResource()
    {
        return $this->hasOne(SongFile::class, 'song_id')->where('type', 4);
    }

    /**
     * @return \Illuminate\Database\Eloquent\Relations\BelongsToMany
     */
    public function contracts()
    {
        return $this->belongsToMany(Contract::class, 'contract_song', 'song_id', 'contract_id');
    }

    public function subject()
    {
        return $this->belongsTo(Subject::class, 'subject_no', 'no')->select('no', 'name');
    }

    public function tags()
    {
        return $this->belongsTo(SongTag::class, 'tag_id', 'id');
    }

    public function files()
    {
        return $this->hasMany(SongFile::class, 'song_no', 'song_id')
            ->whereIn('type', static::$file_only)
            ->orderBy('id')
            ->select(['id', 'song_id', 'song_no', 'type', 'url']);
    }
}