Could you point how to correctly use Laravel's paginate method at this code?
Hi Experts
Could you point how to correctly use Laravel's paginate method at this code?
Produces this error:
![img001]()
Thanks in advance.
Could you point how to correctly use Laravel's paginate method at this code?
$vitrinesX = Vitrine
::with('user_vitrine')
->ativa()
->aprovada()
->global(Auth::user()->tipoparticipante_id)
->orderBy('id','desc')
->withCount([
'user_vitrine as qtdeCurtiu' => function (Builder $query) { $query->where('curtiu', 1); },
//'user_vitrine as naocurtiu' => function (Builder $query) { $query->where('curtiu', 0); }
])
->get()->paginate(5)
->each(function($vitrine) {
$vitrine->liked_by= $vitrine->user_vitrine->pluck('id');
});
Produces this error:
Thanks in advance.
Hey Eduardo,
I can't test at the moment, but I think you need to re-order your methods slightly:
I can't test at the moment, but I think you need to re-order your methods slightly:
$vitrinesX = Vitrine
::with('user_vitrine')
->ativa()
->aprovada()
->global(Auth::user()->tipoparticipante_id)
->orderBy('id','desc')
->withCount([
'user_vitrine as qtdeCurtiu' => function (Builder $query) { $query->where('curtiu', 1); },
//'user_vitrine as naocurtiu' => function (Builder $query) { $query->where('curtiu', 0); }
])
->paginate(5)
->get()
->each(function($vitrine) {
$vitrine->liked_by= $vitrine->user_vitrine->pluck('id');
});
OK.
Just had a quick look. We'll need to move some code around. The each() part of your Query Builder will need to be moved into the view. Change your Query Builder to the following:
Just had a quick look. We'll need to move some code around. The each() part of your Query Builder will need to be moved into the view. Change your Query Builder to the following:
$vitrinesX = Vitrine
::with('user_vitrine')
->ativa()
->aprovada()
->global(Auth::user()->tipoparticipante_id)
->orderBy('id','desc')
->withCount([
'user_vitrine as qtdeCurtiu' => function (Builder $query) { $query->where('curtiu', 1); },
//'user_vitrine as naocurtiu' => function (Builder $query) { $query->where('curtiu', 0); }
])
->paginate(5);
@foreach ($vitrinesX as $vitrine)
@php
$vitrine->liked_by= $vitrine->user_vitrine->pluck('id');
$allowVote = ...
@endphp
So I adapted the existent code to:
And that runs!!!
Just another issue.
The First, Previous, Next, Last bar isn't presented... could you point what's also needed ?
<section class="row">
@foreach($vitrinesX->chunk(3) as $row)
@foreach($row as $vitrine)
<div class="col-sm-12 col-md-4">
@php
// Added ------------------------------------------------
$vitrine->liked_by= $vitrine->user_vitrine->pluck('id');
//--------------------------------------------------------
$currentUserId = auth()->user()->id;
$hasUserVoted = $vitrine->liked_by->contains($currentUserId);
@endphp
<div class="box-noticias">
<a href="javascript:void(0);" onclick='hotsite.vitrine.abrirVitrine({{$vitrine->id}});' >
<img src="{{ $vitrine->url }}">
</a>
</div>
<p id="like" class="likes" @if (!$hasUserVoted ) onclick="hotsite.vitrine.salvarEscolha({{ $vitrine->id }}, 1, this)" @endif>
<i class="fa fa-thumbs-up"></i> <span id="qtdeCurtiu_{{ $vitrine->id }}">{{ $vitrine->qtdeCurtiu }}</span>
</p>
</div>
@endforeach
@endforeach
</section>
And that runs!!!
Just another issue.
The First, Previous, Next, Last bar isn't presented... could you point what's also needed ?
Hi Eduardo,
To show the pagination bar, you need to echo out the links() method:
To show the pagination bar, you need to echo out the links() method:
<section class="row">
...
</section>
{{ $vitrinesX->links() }}
Excellent,
No - by default, you won't get a First Page and Last Page, but if you really want them, you can customise the View used to display the pagination. Have a read through the docs - https://laravel.com/docs/6
No - by default, you won't get a First Page and Last Page, but if you really want them, you can customise the View used to display the pagination. Have a read through the docs - https://laravel.com/docs/6
Premium Content
You need an Expert Office subscription to comment.Start Free Trial