how to get table Attribute inside laravel model

Question

I want get types only where wef is equal to current table wef. how to achieve this i am not able to get wef attribute with $this->attributes['wef']. Thanks in advance.

class Gst extends Model
    {
        //
        use Traits\UserAutoUpdate;
        protected $connection = 'mysql';
        protected $table = "gst";
        protected $fillable = ['name','wef'];

        public function types(){
           return $this->hasMany(GstType::class,'gst_id','id')->where('wef', $this->attributes['wef']);
        }   


    }

Error : "Undefined index: wef"

I don't think $this->attributes['wef'] will work. You need to pass the value in argument of types() function. — Dev
– Dev, Commented Sep 11, 2018 at 10:42
if you are using eager loading.. to get attributes just $this->wef — ZeroOne
– ZeroOne, Commented Sep 11, 2018 at 11:18
possible duplicate of stackoverflow.com/questions/18520209/… — syam
– syam, Commented Sep 11, 2018 at 11:35

Brian Lee · Accepted Answer · 2018-09-11 11:05:25Z

2

You need a function that defines the relationship between GstType and Gst:

public function gstTypes()
{
     return $builder->hasMany(GstType::class,'gst_id','id');
}

Then make a scoped function:

public function scopeTypes($builder){
    return $builder->whereHas('gstTypes', function ($query) {
       $query->where('wef', $this->getAttribute('wef'));
   });
}

And use it like:

 $types = GstType::types();

answered Sep 11, 2018 at 11:05

Brian Lee

18.3k3 gold badges45 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Devon Bessemer Over a year ago

The scope won't really work. In most query contexts, you won't have any attributes available, you'd have to fetch a model then query again on that model. Doesn't really seem like the right way to do it.

Devon Bessemer Over a year ago

Right, but where is the attribute 'wef' supposed to come from?

Collectives™ on Stack Overflow

how to get table Attribute inside laravel model

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related