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