Laravel - pagination links not appearing

Question

For some reason {{ $items->links() }} doesn't do anything.

Direct cause of this problem is that $items->getLastPage() returns 0. Same $items->getTotal().

I can change page parameter in the url and it works fine - it goes to correct page. however $items->getCurrentPage() returns 1 on each page.

Pagination works perfectly for me with other models just this one gives me problems.

Also it seems to be working fine when I create the paginator manually but I want to be able access some methods from the model so I want to use Eloquent models and not raw array.

Edited: Code:

$records = EventLog::byObject($model, $id)->paginate(10);

 static public function byObject($model, $id)
       {

           $records = DB::select([query], [params]);
           return self::getHistory($records, $model);
       }

 static public function getHistory($records, $model = '')
       {
           $ids = array();
            foreach ($records as $record) {
                array_push($ids, (int)$record->id);
            }

            $history = array();                

            if (count($ids)) {

                $history = EventLog::whereRaw('id IN (' . implode(',', array_fill(0, count($ids), '?')) . ')', $ids)
                ->with('creator')
                        ->with(array('eventfields' => function($query)
                        {
                            $query->whereRaw('field NOT LIKE \'%_id\'');
                        }))
                        ->orderBy('event_logs.created_at')
                        ->orderByRaw('(CASE WHEN eventable_type=? THEN 0 ELSE 1 END)', array($model))
                        ->orderByRaw('(CASE WHEN parent_type=? THEN 0 ELSE 1 END)', array($model));

            }
            return $history;
       }

The returned $history has the right type, is displayed correctly but the pagination is not working for some reason.

I am trying to display links using

{{ $records->links(); }}

Thanks

We need your code to help you. Please post the code where you setup pagination. — chris342423
– chris342423, Commented Jan 18, 2014 at 20:36

Felice Ostuni · Accepted Answer · 2014-03-30 18:02:23Z

1

I've same problem here, laravel 4.1 and a query scope with fulltext search. In my case the problem was the orderByRaw (a normal orderby doesn't broke pagination links).

So my "poor" solution is to keep orderByRaw off when I need a pagination and use:

->orderBy(DB::raw('my raw orderby'));

that works

edited Mar 30, 2014 at 18:02

answered Mar 30, 2014 at 17:31

Felice Ostuni

1,0801 gold badge12 silver badges21 bronze badges

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

1 Comment

GrumpyHat Over a year ago

I actually figured that out myself and forgot to add here, thanks very much!

Collectives™ on Stack Overflow

Laravel - pagination links not appearing

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related