/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($society, $id)
{
if (Helpers::perm('admin', $society) or Helpers::perm('edit', $society)) {
$data['society'] = $society;
$data['skill'] = Skill::with(array('individual' => function ($query) {
$query->orderBy('surname', 'asc');
}))->find($id);
$data['members'] = Individual::socindiv($society)->get();
$data['contact'] = Individual::find($data['skill']->contact);
return View::make('skills.show', $data);
} else {
return view('shared.unauthorised');
}
}
/**
* Show the form for creating a new resource.
* GET /projects/create
*
* @return Response
*/
public function create($society)
{
if (Helpers::perm('admin', $society) or Helpers::perm('edit', $society)) {
$data['society'] = $society;
$data['portfolios'] = Portfolio::orderBy('portfolio')->lists('portfolio', 'id');
if (count($data['portfolios'])) {
$data['individuals'] = Individual::socindiv($society)->orderBy('surname')->get();
return View::make('projects.create', $data);
} else {
$data['individuals'] = Individual::socindiv($society)->orderBy('surname')->get();
Session::set('okmessage', 'Please set up a portfolio before creating a project');
return View::make('portfolios.create', $data);
}
} else {
return view('shared.unauthorised');
}
}
public function dashboard($society)
{
$data['total_indivs'] = Individual::socindiv($society)->count();
$data['total_households'] = Household::where('society_id', '=', $society)->count();
$data['missing_gps'] = Household::where('society_id', '=', $society)->where('latitude', '=', null)->count();
$data['missing_hc'] = Household::where('society_id', '=', $society)->where('householdcell', '=', '')->count();
$data['missing_pa'] = Household::where('society_id', '=', $society)->where('addr1', '=', '')->count();
$data['members'] = Individual::socindiv($society)->members()->count();
$data['children'] = Individual::socindiv($society)->children()->count();
$totaged = Individual::socindiv($society)->members()->get();
$totnum = 0;
$totyr = 0;
foreach ($totaged as $thisa) {
if ($thisa->age) {
$totyr = $totyr + $thisa->age;
$totnum++;
}
}
$data['missing_bd'] = Individual::socindiv($society)->members()->where('birthdate', '<', '1901-01-01')->count();
if ($totnum) {
$data['avg_age'] = round($totyr / $totnum, 1);
}
$data['fellowship'] = Individual::socindiv($society)->members()->whereHas('group', function ($query) {
$query->where('grouptype', '=', 'fellowship');
})->count();
$data['service'] = Individual::socindiv($society)->members()->whereHas('group', function ($query) {
$query->where('grouptype', '=', 'service');
})->count();
$data['worship'] = Individual::socindiv($society)->members()->whereHas('group', function ($query) {
$query->where('grouptype', '=', 'worship');
})->count();
$data['learning'] = Individual::socindiv($society)->members()->whereHas('group', function ($query) {
$query->where('grouptype', '=', 'learning');
})->count();
$data['groups'] = Group::where('society_id', '=', $society)->where('statistics', '=', 'yes')->orderBy('groupname')->get();
$data['society'] = $society;
//$data['analyticsData'] = LaravelAnalytics::getVisitorsAndPageViews(7);
return view('statistics.dashboard', $data);
}
public function leadership($society)
{
$soc = Society::where('society', '=', $society)->first();
$data['soc'] = $soc->society;
$data['pagetitle'] = "Our leaders @ " . $soc->society;
$data['leaders'] = Individual::socindiv($soc->id)->where('publish', '=', 1)->where('leadership', '<>', '')->orderBy('surname')->orderBy('firstname')->get();
foreach (Minister::all() as $minister) {
if (in_array($soc->id, explode(',', $minister->societies))) {
$data['ministers'][] = $minister;
$data['minids'][] = $minister->individual_id;
}
}
if (isset($data['ministers']) and count($data['ministers']) > 1) {
$data['addm'] = "s";
} else {
$data['addm'] = "";
}
return view('individuals.leaders', $data);
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function edit($society, $id)
{
if (Helpers::perm('admin', $society) or Helpers::perm('edit', $society)) {
$data['group'] = Group::with(array('individual' => function ($query) {
$query->wherePivot('deleted_at', null)->orderBy('surname', 'asc');
}))->find($id);
$data['individuals'] = Individual::socindiv($society)->get();
$data['society'] = $society;
$coords = Society::find($society);
if ($data['group']->latitude == "0") {
$data['deflat'] = $coords->latitude;
$data['deflon'] = $coords->longitude;
}
$data['history'] = Group::with('individual')->find($id);
$data['members'] = Individual::socindiv($society)->get();
$data['contact'] = Individual::find($data['group']->contact);
$daysofweek = array('Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday', 'Sunday');
$data['meeting'] = $daysofweek[-1 + $data['group']->meeting];
return View::make('groups.edit', $data);
} else {
return View::make("shared.unauthorised");
}
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
if (Helpers::perm('admin', $id)) {
$data['page_title'] = "Edit society";
$data['page_description'] = Helpers::getSetting('circuit_name') . " Circuit";
$data['society'] = Society::with('service')->find($id);
$data['latitude'] = $data['society']->latitude;
$data['longitude'] = $data['society']->longitude;
$data['indivs'] = Individual::socindiv($data['society']->id)->get();
$data['groups'] = Group::where('society_id', '=', $data['society']->id)->orderBy('groupname')->get();
$data['rosters'] = Roster::where('society_id', '=', $data['society']->id)->orderBy('rostername')->get();
$data['provideropts'] = array('none' => '', 'bulksms' => 'Bulk SMS', 'smsfactory' => 'SMS Factory');
return View::make('societies.edit', $data);
} else {
return view('shared.unauthorised');
}
}
