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);
}
public function search()
{
$input = Input::all();
$data['q'] = $input['q'];
$perms = array_flatten(Permission::where('user_id', '=', Auth::user()->id)->select('society_id')->get()->toArray());
$individuals = Individual::where('surname', 'like', '%' . $input['q'] . '%')->orWhere('firstname', 'like', '%' . $input['q'] . '%')->whereNull('deleted_at')->orderBy('surname')->get();
foreach ($individuals as $indiv) {
if ($indiv->household) {
if (in_array($indiv->household->society_id, $perms)) {
$ids[] = $indiv->id;
}
}
}
$data['individuals'] = Individual::wherein('id', $ids)->get();
$data['groups'] = Group::where('groupname', 'like', '%' . $input['q'] . '%')->whereIn('society_id', $perms)->whereNull('deleted_at')->get();
$data['projects'] = Project::where('project', 'like', '%' . $input['q'] . '%')->whereNull('deleted_at')->get();
return view('home', $data);
}
