php - Laravel: paginating a fluent query -
i'm trying paginate page in view this:
@foreach($tasks $task) {{ $task->user_id }} {{ $task->client_id }} {{ $task->description }} {{ $task->duration }} {{ link_to_route('clients.show', 'view client', array($task->client_id), array('class' => 'btn btn-primary')) }} @endforeach {{ $tasks->links() }}
using following query in controller:
$tasks = db::table('tasks') ->join('users', 'tasks.user_id', '=', 'users.id') ->join('clients', 'tasks.client_id', '=', 'clients.id') ->select(array('tasks.description', 'tasks.duration', 'tasks.client_id', 'tasks.user_id', 'users.email', 'clients.name')) ->where('tasks.group_id', '=', $usergroup) ->orderby('tasks.created_at', 'desc') ->paginate(20); return view::make('tasks.index', compact('tasks'));
it shows tasks fine there's no pagination link showing can't head on next batch of 20 results.
any ideas on how can make work?
i've tried @foreach($tasks->result $task) in view suggested in http://forums.laravel.io/viewtopic.php?id=4092 gives me error "undefined property: illuminate\pagination\paginator::$result"
for playing @ home - discovered answer this:
the compact function converting object array. change return view method to:
return view::make('tasks.index')->with('tasks', $tasks);
and you're in clear!
another point - if you're using bootstrap 3 rc1 me you'll find pagination breaks because of way bs3 styles pagination - if have issue head on here solution: https://github.com/laravel/laravel/issues/2215
:)
Comments
Post a Comment