jedrzej / withable Goto Github PK

class User extends Authenticatable
{
    use PimpableTrait;

    public function profiles()
    {
        return $this->morphMany(Profile::class, 'relation');
    }
}

class Profile extends BaseModel
{
    use PimpableTrait;

    public function relation()
    {
        return $this->morphTo();
    }

    public function scopeDefault()
    {
        return $this->where('default', 1);
    }
}

Query:

/users/1?with=profiles:default

SQL Query being created:

SELECT * 
FROM   `profiles` 
WHERE  `profiles`.`relation_id` IN ( '1' ) 
       AND `profiles`.`relation_type` = 'App\\User' 

Should be:

SELECT * 
FROM   `profiles` 
WHERE  `profiles`.`default` = 1 
       AND `profiles`.`relation_id` IN ( '1' ) 
       AND `profiles`.`relation_type` = 'App\\User' 

It would be great to have support for scopes on related models.

Something like with=projects:closed

The character used to separate scope by the relationship conflicts with Laravel's mechanism to select only specific columns from the relationships.

For example:
"with=projects:closed" don't allow to select only id, title, description from that relationship like "with=projects:id,title,description"

A quick fix is maybe to change the separator character for relationships scopes.

"projects:id,title,description#closed"

This example will still work with specific columns selection and scope calling.

Do you have any better idea?

How can we integrate it woth Fractral Transformers? I'm working with Dingo for response API requests.