<?php

namespace App;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;

class AgencyApplication extends Model
{
    use SoftDeletes;

    protected $table = 'agency_application';

    protected $fillable = ['application_id','agreement_number','name','merchant_name','agency_id','feedback','amount','deleted_at'];

    public function applications(){
        return $this->hasMany('App\ConsumerApplication','id','application_id')->whereNull('is_deleted');
    }

    public function agency_name(){
        return $this->hasOne('App\User','id','agency_id')->whereNull('deleted_at')->select('id','name');
    }

}
