jucai/app/Models/Jobfairout/JobfairoutPutJob.php

<?php
/**
 * Created by PhpStorm.
 * User: ZhangHao
 * Date: 2019/6/17
 * Time: 15:00
 */

namespace App\Models\Jobfairout;

use App\Models\Company;
use App\Models\Jobfair\JobfairJob;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;
class JobfairoutPutJob extends Model
{
    use SoftDeletes;
    protected $table = 'jobfairout_put_jobs';
    public $guarded=[];

    /**
     * @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();
    }

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

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

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

    public function companys()
    {
        return $this->belongsTo(Company::class, 'company_id','id');
    }
}