How to add laravel pagination with custom array?

Question

I want to add pagination in my custom laravel query. Here is my code.

$jobseekers = Jobseeker::where('employer_id', Auth::employer()->get()->id)->get()->toArray();

$jobs = Job::select('id')->where('employer_id', (Auth::employer()->get()->id))->get()->toArray();

$apps = DB::table('applications')
            ->leftJoin('jobseekers', 'applications.jobseeker_id', '=', 'jobseekers.id')
            ->groupby('jobseekers.id')
            ->whereIn('applications.job_id', $jobs)
            ->get();

     $apps_array = array();
     for ($i = 0; $i < count($apps); $i++) {
        $apps_array[$i] = (array) $apps[$i];
     }

     $jobseeker = array_merge($jobseekers, $apps_array);

     return view('frontend.manageCV', compact('jobseeker', 'assignJS'));

Were is the $apps variable coming from.

oseintow
– oseintow

2016-03-09 11:10:35 +00:00
Commented Mar 9, 2016 at 11:10 — oseintow
– oseintow, Commented Mar 9, 2016 at 11:10
i just define at 3rd line

vipul sorathiya
– vipul sorathiya

2016-03-09 11:17:12 +00:00
Commented Mar 9, 2016 at 11:17 — vipul sorathiya
– vipul sorathiya, Commented Mar 9, 2016 at 11:17

oseintow · Accepted Answer · 2016-03-09 12:12:36Z

1

Try this and let see how it goes

// I have changed the get to paginate
$jobseekers = Jobseeker::where('employer_id', Auth::employer()->get()->id)->paginate();

$jobs = Job::select('id')->where('employer_id', (Auth::employer()->get()->id))->get()->toArray();

$apps = DB::table('applications')
        ->leftJoin('jobseekers', 'applications.jobseeker_id', '=', 'jobseekers.id')
        ->groupby('jobseekers.id')
        ->whereIn('applications.job_id', $jobs)
        ->get();

 $apps_array = array();
 for ($i = 0; $i < count($apps); $i++) {
    $apps_array[$i] = (array) $apps[$i];
 }

 // I am merging to the $jobseekers->data in $jobseekers array
 $jobseekers->data = (object)array_merge((array)$jobseekers->data, $apps_array);

 return view('frontend.manageCV', compact('jobseekers', 'assignJS'));

edited Mar 9, 2016 at 12:12

answered Mar 9, 2016 at 11:54

oseintow

7,4213 gold badges28 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

vipul sorathiya Over a year ago

but it will give error in template : Call to a member function render() on a non-object

oseintow Over a year ago

If you are using it in a view then you dont have to call the toArray on the Collection. Updating my answer.

vipul sorathiya Over a year ago

Also in total it count only $jobseekers data. Cant consider $apps_array record

oseintow Over a year ago

Wish i can see your models and the final results after the merging.

vipul sorathiya Over a year ago

its give error at merge line : Undefined property: Illuminate\Pagination\LengthAwarePaginator::$data

|

Collectives™ on Stack Overflow

How to add laravel pagination with custom array?

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related