Scopes in join

@sinnbeck sir have read this https://laravel.com/api/5.2/Illuminate/Database/Query/JoinClause.html

@vandan Thanks. I know of the api. The issue is that I have this scope

public function scopeActive($query)
    {
        $query->where($this->getTable() . '.type', '>', 1);
    }

That I wish to use like this (sample code for demonstration only)

Project::join('groups', function($join) {
    $join->on('groups.project_id', 'project.id')->active(); //the active scope function does not work
})->get();

@sinnbeck not much idea but i found on google references like

https://ducktypelabs.com/using-scope-with-associations/

maybe its help you sir

@vandan Thanks, but I am trying to do this in laravel using laravel scopes :) The article is regarding ActiveRecord.

https://laravel.com/docs/6.x/eloquent#local-scopes

Not really what you are looking for probably but can't you "solve" this with a work around to combine your join + where clause into a separate scope? Like this:

public function scopeJoinActiveGroups($query) 
{
      $query->join(/* */);
      $query->where($this->getTable() . '.type', '>', 1);
}

Project::joinActiveGroups()->get();

That is actually not a bad idea! :) I will look into implementing that as a quick test :)

@sinnbeck did you solve your problem with the proposed solution? Or did you find a better solution?

I'm also looking for a clean way to use the logic from a scope in a query join...

Has anyone found a way to do this? I'm working with a system with pretty advanced logic behind scopes and I really need to be able to use them against joined tables.