andersao/l5-repository

complicated relationship - pagination / general help

Open

#300 opened on Oct 21, 2016

View on GitHub
 (1 comment) (0 reactions) (0 assignees)PHP (4,119 stars) (868 forks)batch import
help wanted

Description

I have a seller, to get his buyers.. I am currently doing in the Seller Model:

    public function Clients($id=null)
    {
        $query = "
            SELECT o.user_id FROM orders o
            INNER JOIN order_items oi 
            ON oi.order_id = o.id
            INNER JOIN products p
            ON p.id = oi.product_id
            WHERE p.user_id = " . $this->id;

        if ( $id )
            $query .= " AND o.user_id = " . $id;

        $results = \DB::select($query);

        $collection = collect([]);

        foreach ($results as $user) {
            $collection->push( \App\Entities\User::find($user->user_id) );
        }

        return $collection;
    }

Now I have an endpoint where I need to display sellers' buyers.. so right now I do something like:

\Auth::user()->id->clients()... which is working

But as i am using this awesome library, i would like to be able to convert this to use pagination? & then view transformed results...

i cannot think how i can do this? i cant have a repository

Any hints would be appreciated.

Contributor guide

Tech stack
phplaravel
Domain
backenddatabase
Issue type
research
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-3 hours
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
stale
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
mostly clear
Prerequisites
Laravel basicsEloquent ORMRepository pattern
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
40
Research direction
The user wants to paginate results from a custom 'clients' method in a Seller model. The method currently uses raw SQL to fetch buyer IDs and then loads each User model individually. To leverage the l5 repository library, the user should refactor the relationship to use Eloquent relationships (e.g., belongsToMany) or the query builder, then apply pagination via the repository's paginate method. The issue is old and has minimal discussion; the user may benefit from reviewing the library's documentation on pagination and custom repository methods.
complicated relationship - pagination / general help · andersao/l5-repository#300 | Good First Issue