duplicate result in pagination

protonemedia / laravel-cross-eloquent-search

Laravel package to search through multiple Eloquent models. Supports sorting, pagination, scoped queries, eager load relationships and searching through single or multiple columns.

MIT License

1.1k stars 80 forks source link

hi,

if i call the paginate or simplePaginate method some results seem to appear again and again on different pages. Currently I cannot find the cause of the problem. Does anyone else have this problem?

Or am i doing something wrong?

My function at my data repository

 public function testCasesSearch(string $result = null, Carbon $from = null, Carbon $to = null): Searcher
    {
        $query = $result ? $this->testCases()->where('result', $result) : $this->testCases();
        return Search::add($query, ['first_name', 'last_name', 'result', 'email', 'phone']);
    }

The Controller

public function testCases(
        CompanyCollection $company,
        Request $request
    ): JsonResponse
    {

        return response()->json(
            $company->testCasesSearch($request->get('result'))
                ->paginate(15, 'page', $request->get('page'))
                ->get($request->get('term'))
        );
    }

protonemedia / laravel-cross-eloquent-search

duplicate result in pagination #55