mercredi 9 mars 2016

How to add laravel pagination with custom array?

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'));



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire