public function circuit($society) { $data['soc'] = $society; $data['pagetitle'] = Helpers::getSetting('circuit_name') . " Circuit"; $cministers = Minister::with('individual')->get(); if (Helpers::is_online() and Helpers::getSetting('circuit_calendar') != "") { $privatecal = new GoogleCalendar(); $data['cals'] = $privatecal->getTen(Helpers::getSetting('circuit_calendar'), 8); } foreach ($cministers as $cm) { $dum['name'] = "<strong>" . $cm->individual->title . " " . $cm->individual->firstname . " " . $cm->individual->surname . "</strong>"; $dum['contact'] = $cm->individual->cellphone; if ($cm->individual->id == Helpers::getSetting('superintendent')) { $dum['contact'] = "(Superintendent Minister)<br>" . $dum['contact']; } $dum['sort'] = $cm->individual->surname . $cm->individual->firstname; $dum['bio'] = $cm->individual->notes; $dum['photo'] = $cm->individual->photo; $dum['slug'] = $cm->individual->slug; $socs = Society::wherein('id', explode(',', $cm->societies))->get(); $societies = ""; foreach ($socs as $soc) { $societies .= "<a href=\"" . Helpers::makeUrl(strtolower($soc->society), '') . "\">" . $soc->society . "</a>, "; } $dum['societies'] = substr($societies, 0, -2); $data['ministers'][$dum['sort']] = $dum; } ksort($data['ministers']); $data['allsocieties'] = Society::orderBy('society')->get(); if (count($data['allsocieties'])) { foreach ($data['allsocieties'] as $obj) { $dum1[0] = $obj->society; $dum1[1] = $obj->latitude; $dum1[2] = $obj->longitude; $dum1[3] = Helpers::makeUrl(strtolower($obj->society), ''); $fin[] = $dum1; } $data['fin'] = json_encode($fin); } else { $data['fin'] = ""; } $data['stewards'] = Individual::wherein('id', explode(',', Helpers::getSetting('circuit_stewards')))->get(); $data['secretary'] = Individual::find(Helpers::getSetting('circuit_secretary')); $data['treasurer'] = Individual::find(Helpers::getSetting('treasurer')); return view('societies.circuit', $data); }
/** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function show($society, $slug = "all") { $socid = Society::where('society', '=', $society)->first()->id; if ($slug == "all" or strlen($slug) == 4 and is_numeric($slug)) { $syears = array(); $data['series'] = Series::with('sermon')->where('society_id', '=', $socid)->orderBy('created_at', 'DESC')->get(); foreach ($data['series'] as $serie) { if (!in_array(substr($serie->created_at, 0, 4), $syears)) { $syears[] = substr($serie->created_at, 0, 4); } } asort($syears); $data['syears'] = $syears; $data['slug'] = $slug; if ($slug != "all") { $series = Series::with('sermon')->where('society_id', '=', $socid)->orderBy('created_at', 'DESC')->get(); $data['series'] = array(); foreach ($series as $serie) { if (substr($serie->created_at, 0, 4) == $slug) { $data['series'][] = $serie; } } if (!isset($data['series'])) { $data['series'] = array(); } } } else { $data['series'] = Series::with('sermon')->where('society_id', '=', $socid)->where('slug', '=', $slug)->get(); $data['slug'] = $data['series'][0]->series; } $data['pagetitle'] = $society . " sermons"; $data['soc'] = $society; $others = Series::has('sermon')->where('society_id', '<>', $socid)->groupBy('society_id')->lists('society_id')->toArray(); $data['othersocieties'] = Society::wherein('id', $others)->orderBy('society')->get(); return view('series.show', $data); }