<?php

namespace App\Models\Jobfair;

use App\Models\Company;
use App\Models\Subsite;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;

class JobfairCompany extends Model
{
    use SoftDeletes;
    protected $guarded = [''];

    protected $table = 'jobfair_companys';


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

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

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


    public function jobfairCompanySinged()
    {
        return $this->hasOne(JobfairCompanySigned::class, 'company_id', 'company_id');
    }
//    public function jobfairPutJobs()
//    {
//        return $this->hasMany(JobfairPutJob::class, 'company_id', 'company_id');
//    }

    public function jobfairPutJob()
    {
        return $this->hasMany(JobfairPutJob::class, 'exid', 'id');
    }

    public function jobfairFloorPlanStands()
    {
        return $this->belongsTo(FloorplanStand::class, 'position_id');
    }

    public function subsites()
    {
        return $this->belongsToMany(Subsite::class, 'subsite_jobfairs', 'jobfair_id', 'subsite_id', 'jobfair_id');
    }
    
    public function jobfairBlackList()
    {
        return $this->belongsTo(JobfairBlacklist::class, 'company_id', 'company_id');
    }

    /**
     * @param \Illuminate\Database\Eloquent\Builder $query
     * @return \Illuminate\Database\Eloquent\Builder
     */
    public function scopeJoinFloorplanStand($query)
    {
        return $query->join('jobfair_floorplan_stands', 'position_id', '=', 'jobfair_floorplan_stands.id');
    }

    public function scopeWebJoinFloorplanStand($query)
    {
        return $query->join('jobfair_floorplan_stands', 'jobfair_companys.position_id', '=', 'jobfair_floorplan_stands.id');
    }

    static function getTableName()
    {
        $company = new JobfairCompany();
        return $company->getTable();
    }

}