jucai/app/Models/Jobfair/JobfairPutJob.php

<?php

namespace App\Models\Jobfair;

use App\Models\Subsite;
use App\Models\Jobfair\JobfairCompany;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;

class JobfairPutJob extends Model
{
    use SoftDeletes;
    protected $table = 'jobfair_put_jobs';
    public $guarded=[];


    public function jobfairs()
    {
        return $this->belongsTo(Jobfair::class, 'jobfair_id');
    }

    public function jobfair_company()
    {
        return $this->hasOne(JobfairCompany::class, 'id','exid');
    }

    public function jobs()
    {
        return $this->belongsTo(JobfairJob::class, 'job_id','id');
    }

    /**
     * @param \Illuminate\Database\Eloquent\Builder $query
     * @return \Illuminate\Database\Eloquent\Builder
     */
    public function scopeJoinJobfairJob($query)
    {
        return $query->join('jobfair_jobs', 'job_id', '=', 'jobfair_jobs.id')
            ->select();
    }
}