laravel sidebar jscroll query

2019-09-03 11:24发布

问题:

I have similar query like here.I want paginate query but it already has get my query is

$left_data = $this->getConversationSorted();
protected function getConversationSorted()
{
    $con = Conversation::leftjoin('messages', function ($join) {
        $join->on('conversations.id', '=', 'messages.conversation_id');
    })->where(function ($q) {
        $q->where('conversations.from_user', '=', $this->user->id)
            ->orWhere('conversations.to_user', '=', $this->user->id);
    })->where('conversations.type','>','0')->groupby('conversations.id')
        ->orderby('messages.created_at', SORT_DESC)
        ->get(['conversations.*','messages.conversation_id']);

    return $con;
}

my view

<div class="tab-content col-xs-12 chat_head_list">
<div class="search_container">
    <div class="right-inner-addon">
        {!! Form::open() !!}
        <i class="glyphicon glyphicon-search"></i>
        {!! Form::text('id_search','',array('class' => 'form-control id_search' , 'placeholder' => 'Search...')) !!}
        {!! Form::close() !!}
        <div class="form-group" style="margin-top: 5px;">
            <select name="interaction_type" id="interaction_type" class="form-control">
                <option value="0" selected>All Conversations</option>
                <option value="1">Profile Evaluation</option>
                <option value="2">Recruiter Watchlist</option>
                <option value="3">Direct Messages</option>
                <option value="4">Messages</option>
            </select>
        </div>
    </div>
</div>
<ul class="nav nav-stacked chat_head_block">
    @foreach($left_data as $left)
       <div class="leftside">
        @if($left->from_user  !== NULL && $left->to_user !== NULL)
            <li class="@if($con_id == $left->conversation_id)active_convo @endif {{ $left->type }}" >
                <div class="media">
                    <div class="media-left media-top">
                        {{--@if((!empty($left->messages))) @foreach($left->messages as $l) @if($l->messages->seen == '0') style="background-color: #F5F5F5" @endif @endforeach @endif--}}
                        <a class="article_list_img" href="{{ route('profileevaluation.conversation',array('id' => $left->id)) }}" >
                            @if($user->id == $left->to_user)
                                @if(!empty($left->fromUser->getavatar->avatar))
                                    <img src="{{ asset('/img/no-image.jpg') }}" class="lazy" data-src="{{ asset('/img/frontend/useravatar/'.$left->fromUser->getavatar->avatar) }}">
                                @else
                                    @if($left->fromUser->providers->isEmpty())
                                        <img src="{{ asset('/img/no-image.jpg') }}" class="lazy"  data-src="{{ asset('/img/no-image.jpg') }}" >
                                    @else
                                        <img src="{{ asset('/img/no-image.jpg') }}">
                                    @endif
                                @endif
                            @else
                                @if(!empty($left->toUser->getavatar->avatar))
                                    <img src="{{ asset('/img/no-image.jpg') }}" class="lazy" data-src="{{ asset('/img/frontend/useravatar/'.$left->toUser->getavatar->avatar) }}">
                                @else
                                    @if($left->toUser->providers->isEmpty())
                                        <img src="{{ asset('/img/no-image.jpg') }}" class="lazy" data-src="{{ asset('/img/no-image.jpg') }}">
                                    @else
                                        <img src="{{ asset('/img/no-image.jpg') }}" class="lazy" data-src="{{ $left->toUser->providers[0]->avatar }}">
                                    @endif
                                @endif
                            @endif
                        </a>
                    </div>
                    <div class="media-body">
                        <div class="body_title">
                            <a href="{{ route('profileevaluation.conversation',array('id' => $left->id)) }}" style="text-decoration: none">
                                @if($left->type == 1)
                                    Admissions Counselling from
                                @elseif($left->type == 2)
                                    Recruiter Interaction from
                                @elseif($left->type == 3)
                                    Direct message from
                                @elseif($left->type == 4)
                                    Message
                                @endif
                                <br>
                                @if($left->from_user != $user->id)
                                    @if(!empty($left->fromUser->name))
                                        {!! $left->fromUser->name !!}
                                    @endif
                                @else
                                    @if(!empty($left->toUser->name))
                                        {!! $left->toUser->name !!}
                                    @endif
                                @endif
                            </a>
                        </div>
                        <div class="body-count">
                            @if($left->messages->count() != '0')
                                <span style="font-weight: bold">{{ $left->messages->count() }} messages</span>
                            @endif
                        </div>
                    </div>
                </div>
            </li>
        @endif
    @endforeach
       </div>
</ul>

I want jscroll div.media part I want laravel query where both pagination and get can be used, using laravel 5.1.