Laravel comparing model table date with relation table date

I'm trying to filter out the data in my relation by comparing the created_at of the model and the created_at of the relation.

This is what i tried: ?` public function entry_goods() { return $this->hasMany('App\EntryAccessionGood', 'norm_id', 'norm_id') ->whereRaw('entry_accession_goods.created_at <= exit_accession_goods.created_at'); } ?owever I am unable to access the exit_accession_goods table at all (this relation is in the ExitAccessionGood model). Is there a way to get access to the table of the model in which the function is located at?

E.g. rows in exit_accession_goods created today should look at rows in entry_accession_goods that were made today or before it. ?` ->whereRaw('entry_accession_goods.created_at <= exit_accession_goods.created_at');

prasadchinwal5

6 years ago

Level 35

@jawe031 I believe you would have to extract the where clause to a method.

public function entry_goods() {
 return $this->hasMany('App\EntryAccessionGood', 'norm_id', 'norm_id'); 
}

and then another method which would be like

public function myfilter()
{
    return $this->entry_goods()->whereRaw('entry_accession_goods.created_at <= exit_accession_goods.created_at');
}

Then you can get your results like

$model = Mymodel::find(1);
$model->myfilter()->get();

Please or to participate in this conversation.