/** * Display the specified resource. * * @param int $id * @return Response */ public function show($society, $slug) { $data['soc'] = $society; $data['individual'] = Individual::where('slug', '=', $slug)->first(); if ($data['individual'] and $data['individual']->social) { $socials = explode(',', $data['individual']->social); foreach ($socials as $social) { if (strpos($social, 'twitter')) { $data['socials']['twitter'] = $social; } elseif (strpos($social, 'facebook')) { $data['socials']['facebook'] = $social; } elseif (strpos($social, 'instagram')) { $data['socials']['instagram'] = $social; } elseif (strpos($social, 'youtube')) { $data['socials']['youtube'] = $social; } } } if ($data['individual']) { $id = $data['individual']->id; if (count(Preacher::where('individual_id', '=', $id)->get()) > 0) { $data['preacher'] = Preacher::with(array('sermons' => function ($query) { $query->orderBy('created_at', 'DESC'); }))->where('individual_id', '=', $id)->first(); } elseif (count(Minister::with('sermons')->where('individual_id', '=', $id)->get()) > 0) { $data['preacher'] = Minister::where('individual_id', '=', $id)->first(); } $data['pagetitle'] = $data['individual']->firstname . " " . $data['individual']->surname; } else { $data['preacher'] = Guest::where('slug', '=', $slug)->first(); $data['pagetitle'] = $data['preacher']->firstname . " " . $data['preacher']->surname; $id = 0; } if (isset($data['preacher'])) { $sermons = $data['preacher']->sermons->lists('id')->all(); $data['sermons'] = Sermon::wherein('id', $sermons)->orderBy('servicedate', 'DESC')->paginate(5); } $data['blogs'] = Blog::where('individual_id', '=', $id)->orderBy('created_at', 'DESC')->limit(9)->get(); return View::make('individuals.show', $data); }