I cant paginate search result

[sergeymarshennikov]

I like to use elasticquent
It is my pleasure to use elasticquent
this is my code

$orders = Order::searchByQuery(
    [
     'query' => [
      'bool' => [
       'filter' => [
        [
         'term' => [
          'price' => $query
         ]
        ]
       ]
      ]
     ]
    ]
   )->sortByDesc('id')->paginate(15);

As you can see, I want to see 15 data per page. But, I can see 10 result per page but not 15
And when I click page 2 on result page, it goes page=2 but this page=2 is not elastic search result
How can I integrate pagination with elasticquent
if you help me, it will be appreciated

[cambricorp]

class ElasticquentResultCollection extends \Illuminate\Database\Eloquent\Collection
{
    /**
     * Paginate Collection
     *
     * @param int $pageLimit
     *
     * @return Paginator
     */
    public function paginate($pageLimit = 25)
    {
        $page = Paginator::resolveCurrentPage() ?: 1;
        //$sliced_items = array_slice($this->items, ($page - 1) * $pageLimit, $pageLimit);

        return new Paginator($this->items, $this->hits, $this->totalHits(), $pageLimit, $page, ['path' => Paginator::resolveCurrentPath()]);
    }
}

This should get your pagination going! I have submitted pull request for this issue.

[timgws]

@cambri can you please link me to the PR?

Edit: never mind, found the PR, it has already been merged.

@sergeymarshennikov, please do a composer update on dev-master, this should fix your issue.

[sergeymarshennikov]

@timgws
Thanks
I updated composer on dev-master

But, it does not work correctly
this is my code

// controller side

$query = Input::get('query');
if($query) {
$posts= Post::searchByQuery(
[
'multi_match' => [
'query' => $query,
'fields' => ['firstname', 'lastname']
]
]
)->sortBy('id', 0, true)->paginate(10);
$posts->appends(Input::only('query'))->render();
}else{
$posts= Post::orderBy('id', 'DESC')->paginate(10);
}
return view(testSearch')->with(['posts' => $posts]);

// view side : testSearch.blade
.....
{!! $orders->render() !!}

as a search result, total 31 pages links rendered in the bottom of view for pagination

in this case, url is : http://localhost:8000/testSearch?query=xxx+yyy

when I click page 2 link, url is http://localhost:8000/testSearch?query=xxx+yyy?page=2

But posts on page2 are all the same as on page 1

when I click page 3 link, the same result as on page 1 rendered.

How can I fix this

I need to see result on page 2 unlike page 1

please help me

[cambricorp]

It has been a little while since I crossed this bridge, the issue is likely from not coordinating your elasticsearch result size and from value to your application result limit, from, to value.

[sergeymarshennikov]

Sorry I did not understand correctly

Would you explain again?

[cambricorp]

Search for "paginating elasticsearch result", I believe the problem is that you are not telling elasticsearch to return the next result set.

[sergeymarshennikov]

can you teach me detailed code?

[cambricorp]

$q = \Request::input('q');
$page = \Request::input('page');

if($page==null){$page=1;}

$offset = ($page - 1) * 15;

$items = $this->model->searchByQuery([
  "query" => [
    "bool" => [
      "must" => [
        ["match" => ["name" => 
          [
            "query" => $q
          ]
        ]]],
      "should" => [
        ["match" => ["url" => 
          [
          "query" => $q,
          "boost" => 2
          ]
        ]]]
    ]
  ]
], null, null, 15, $offset, null)->paginate(15);

[sergeymarshennikov]

I will check soon

Thanks

[Kharestani]

this code will work for the first page but it has a flaw for next pages you need to add a code like this to make it work fully:

        $items->appends(['q' => $q]);

[ronydebnath]

Those who are facing similar problem, here is an example that works

in Controller:

        $number_per_page = 20;
        if ($request->input('page') == null) {
            $page = "1";
        } else {
            $page = $request->input('page');
        }
        
        if($request->has('search') && $request->search != null){
            
            $searchTerm = $request->search;
            
            $totalresults = Tour::complexSearch(array(
                'body' => array(
                    'multi_match' => [
                        'query' => array(
                        'match' => array(
                            'title' => $request->get('search')
                        )
                    ),
                ],
                'from' => ($page-1) * $number_per_page,
                'size' => $number_per_page
                )
            ));
            $results = $totalresults->paginate(20);

in view paginate like this:

{{ $results->appends(Request::only('search'))->render() }}