/**
* Bind data to the view.
*
* @param View $view
* @return void
*/
public function compose(View $view)
{
$society = $view->getData()['soc'];
$data['services'] = Society::with('service')->where('society', '=', $society)->first();
foreach ($data['services']->service as $service) {
if ($service['language'] == "English" and $service['description'] == "") {
$service->description = "Our " . $service->servicetime . " service is led in English by a minister or local preacher and a team of musicians. Everyone is welcome!";
} elseif ($service['language'] == "isiZulu" and $service['description'] == "") {
$service->description = "Our " . $service->servicetime . " service is led in isiZulu by a minister or local preacher and uses the liturgy and music of the Methodist Hymn Book. Everyone is welcome!";
}
$data['allservices'][] = $service;
}
if (!count($data['services'])) {
return View::make('errors.404');
}
if (isset($view->getData()['pagetitle'])) {
$data['pagetitle'] = $view->getData()['pagetitle'];
} else {
$data['pagetitle'] = $society;
}
$socid = Society::where('society', '=', $society)->select('id')->first()->id;
if (Helpers::is_online() and $data['services']->society_calendar != "") {
$privatecal = new GoogleCalendar();
$data['cals'] = $privatecal->getTen($data['services']->society_calendar, 8);
}
$data['sermon'] = Sermon::with(['series' => function ($query) use($socid) {
$query->where('society_id', '=', $socid);
}])->orderBy('servicedate', 'DESC')->first();
if (!$data['sermon'] or !$data['sermon']->series) {
$data['sermon'] = "None";
} else {
if ($data['sermon']->preachable_type == 'App\\Models\\Minister') {
$data['preacher'] = Minister::find($data['sermon']->preachable_id);
} elseif ($data['sermon']->preachable_type == 'App\\Models\\Guest') {
$data['preacher'] = Guest::find($data['sermon']->preachable_id);
} else {
$data['preacher'] = Preacher::find($data['sermon']->preachable_id);
}
}
$data['welcome_page'] = "together a transforming discipleship movement";
$data['welcome_page_pic'] = "/public/images/715.jpg";
if ($data['services']->roster) {
$data['roster'] = $data['services']->roster;
}
$data['society'] = Society::where('society', '=', $society)->first();
if ($data['society']->roster) {
$data['roster'] = $data['society']->roster;
}
$webpage = Webpage::where('society_id', '=', $data['society']->id)->get();
foreach ($webpage as $pg) {
$data[$pg->fieldname] = $pg->fieldvalue;
$data[$pg->fieldname . '_pic'] = $pg->pageimage;
}
$data['route'] = Route::getCurrentRoute()->getPath();
if ($data['route'] != "{society}" and $data['route'] != "/") {
$linkadd = Helpers::makeUrl(strtolower($society), '');
} else {
$linkadd = "";
}
$menu['link'] = $linkadd . "#sundays";
$menu['label'] = "Sundays";
$menu['longlabel'] = "Sunday services";
$data['menu'][] = $menu;
$data['youth'] = Mission::where('society_id', '=', $data['society']->id)->where('category', '=', 'youth')->orderBy('created_at')->take(5)->get();
if (count($data['youth'])) {
$menu['link'] = $linkadd . "#youth";
$menu['label'] = "Youth";
$menu['longlabel'] = "Children and Youth";
$data['menu'][] = $menu;
}
$data['groups'] = Group::where('society_id', '=', $data['society']->id)->where('publish', '=', 1)->get();
if (count($data['groups'])) {
foreach ($data['groups'] as $obj) {
$dum[0] = $obj->groupname;
$dum[1] = $obj->latitude;
$dum[2] = $obj->longitude;
$dum[3] = Helpers::makeUrl(strtolower($data['services']->society), 'groups/' . $obj->slug);
$fin[] = $dum;
}
$data['fin'] = json_encode($fin);
$menu['link'] = "#groups";
$menu['label'] = "Groups";
$menu['longlabel'] = "Small groups";
$data['menu'][] = $menu;
} else {
$data['fin'] = "";
}
$data['missions'] = Mission::where('society_id', '=', $data['society']->id)->where('category', '=', 'project')->take(5)->get();
if (count($data['missions'])) {
$menu['link'] = $linkadd . "#projects";
$menu['label'] = "Projects";
$menu['longlabel'] = "Mission projects";
$data['menu'][] = $menu;
}
$blogs = Blog::with('individual')->orderBy('created_at', 'desc')->take(10)->get();
if (count($blogs)) {
$first = true;
foreach ($blogs as $blog) {
$societies = explode(',', $blog->societies);
if (in_array($data['society']->id, $societies)) {
if ($first) {
$data['firstblog'] = $blog;
$first = false;
} else {
$data['blogs'][] = $blog;
}
}
}
if (isset($data['firstblog'])) {
$menu['link'] = $linkadd . "#blog";
$menu['label'] = "Blog";
$menu['longlabel'] = "Latest blogs";
$data['menu'][] = $menu;
}
}
$menu['link'] = $linkadd . "#contact";
$menu['label'] = "Contact";
$menu['longlabel'] = "Contact us";
$data['menu'][] = $menu;
$data['counter'] = 1;
$view->with('data', $data);
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($society, $series, $id)
{
if (Helpers::perm('admin', $society) or Helpers::perm('edit', $society)) {
$data['society'] = $society;
$data['allseries'] = Series::where('society_id', '=', $society)->lists('series', 'id')->toArray();
$data['series'] = $series;
$data['seriesname'] = Series::find($series)->series;
$data['ministers'] = Minister::has('individual')->get();
$data['preachers'] = Preacher::has('individual')->get();
$data['guests'] = Guest::orderBy('surname')->orderBy('firstname')->get();
$data['sermon'] = Sermon::find($id);
return view('sermons.edit', $data);
} else {
return view('shared.unauthorised');
}
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$preacher = Preacher::find($id);
$preacher->delete();
return Redirect::route('preachers.index')->with('okmessage', 'Preacher has been deleted');
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($yy, $qq, $aa)
{
$fin = array();
$fm = Helpers::getSetting('first_month');
$m1 = $qq * 3 - 3 + $fm;
$y1 = $yy;
$m2 = $qq * 3 - 2 + $fm;
$y2 = $yy;
$m3 = $qq * 3 - 1 + $fm;
$y3 = $yy;
if ($m2 > 12) {
$m2 = $m2 - 12;
$y2 = $y2 + 1;
}
if ($m3 > 12) {
$m3 = $m3 - 12;
$y3 = $y3 + 1;
}
if ($aa == "edit") {
$perms = Permission::where('user_id', '=', Auth::user()->id)->get();
foreach ($perms as $perm) {
if ($perm->preaching or $perm->admin) {
$data['authsoc'][] = $perm['society_id'];
}
}
if (!isset($data['authsoc'])) {
$aa = "view";
}
}
$firstDateTime = mktime(0, 0, 0, $m1, 1, $y1);
$firstDay = date("N", $firstDateTime);
$firstSunday = date("d M Y", mktime(0, 0, 0, $m1, 8 - $firstDay, $y1));
$lastSunday = strtotime($firstSunday);
$lastDay = mktime(23, 59, 59, $m3, cal_days_in_month(CAL_GREGORIAN, $m3, $y3), $y3);
$extras = Weekday::where('servicedate', '>=', $firstDateTime)->where('servicedate', '<=', $lastDay)->orderBy('servicedate')->get()->toArray();
$data['meetings'] = Meeting::where('meetingdatetime', '<', $lastDay)->where('meetingdatetime', '>', $firstDateTime)->orderBy('meetingdatetime')->get();
$dum['dt'] = $lastSunday;
$dum['yy'] = intval(date("Y", $lastSunday));
$dum['mm'] = intval(date("n", $lastSunday));
$dum['dd'] = intval(date("j", $lastSunday));
$sundays[] = $dum;
$data['societies'] = Society::orderBy('society')->with('service')->get();
$data['ministers'] = Minister::has('individual')->get();
$data['preachers'] = Preacher::has('individual')->get();
$data['guests'] = Guest::where('active', '=', 1)->get();
while (date($lastSunday + 604800 <= $lastDay)) {
$lastSunday = $lastSunday + 604800;
$dum['dt'] = $lastSunday;
$dum['yy'] = intval(date("Y", $lastSunday));
$dum['mm'] = intval(date("n", $lastSunday));
$dum['dd'] = intval(date("j", $lastSunday));
$sundays[] = $dum;
}
if (count($extras)) {
$xco = 0;
for ($q = 0; $q < count($sundays); $q++) {
if ($xco < count($extras) and $extras[$xco]['servicedate'] < $sundays[$q]['dt']) {
$dum['dt'] = $extras[$xco]['servicedate'];
$dum['yy'] = intval(date("Y", $extras[$xco]['servicedate']));
$dum['mm'] = intval(date("n", $extras[$xco]['servicedate']));
$dum['dd'] = intval(date("j", $extras[$xco]['servicedate']));
$data['sundays'][] = $dum;
$xco++;
$q = $q - 1;
} else {
$data['sundays'][] = $sundays[$q];
}
}
} else {
$data['sundays'] = $sundays;
}
$pm1 = Plan::where('planyear', '=', $y1)->where('planmonth', '=', $m1)->get();
foreach ($pm1 as $p1) {
$soc = Society::find($p1->society_id)->society;
$ser = Service::find($p1->service_id)->servicetime;
if ($p1->preachable) {
@($data['fin'][$soc][$p1->planyear][$p1->planmonth][$p1->planday][$ser]['preacher'] = substr($p1->preachable_type, 11, 1) . "_" . $p1->preachable->id);
if ($p1->preachable_type == "App\\Models\\Guest") {
@($data['fin'][$soc][$p1->planyear][$p1->planmonth][$p1->planday][$ser]['pname'] = substr($p1->preachable->firstname, 0, 1) . " " . $p1->preachable->surname);
} else {
@($data['fin'][$soc][$p1->planyear][$p1->planmonth][$p1->planday][$ser]['pname'] = substr($p1->preachable->individual->firstname, 0, 1) . " " . $p1->preachable->individual->surname);
}
} else {
@($data['fin'][$soc][$p1->planyear][$p1->planmonth][$p1->planday][$ser]['preacher'] = "");
}
if ($p1->tag_id) {
@($data['fin'][$soc][$p1->planyear][$p1->planmonth][$p1->planday][$ser]['tag'] = $p1->tag_id);
@($data['fin'][$soc][$p1->planyear][$p1->planmonth][$p1->planday][$ser]['tname'] = Tag::find($p1->tag_id)->abbr);
} else {
@($data['fin'][$soc][$p1->planyear][$p1->planmonth][$p1->planday][$ser]['tag'] = "");
}
}
$pm2 = Plan::where('planyear', '=', $y2)->where('planmonth', '=', $m2)->get();
foreach ($pm2 as $p2) {
$soc = Society::find($p2->society_id)->society;
$ser = Service::find($p2->service_id)->servicetime;
if ($p2->preachable) {
@($data['fin'][$soc][$p2->planyear][$p2->planmonth][$p2->planday][$ser]['preacher'] = substr($p2->preachable_type, 11, 1) . "_" . $p2->preachable->id);
if ($p2->preachable_type == "App\\Models\\Guest") {
@($data['fin'][$soc][$p2->planyear][$p2->planmonth][$p2->planday][$ser]['pname'] = substr($p2->preachable->firstname, 0, 1) . " " . $p2->preachable->surname);
} else {
@($data['fin'][$soc][$p2->planyear][$p2->planmonth][$p2->planday][$ser]['pname'] = substr($p2->preachable->individual->firstname, 0, 1) . " " . $p2->preachable->individual->surname);
}
} else {
@($data['fin'][$soc][$p2->planyear][$p2->planmonth][$p2->planday][$ser]['preacher'] = "");
}
if ($p2->tag_id) {
@($data['fin'][$soc][$p2->planyear][$p2->planmonth][$p2->planday][$ser]['tag'] = $p2->tag_id);
@($data['fin'][$soc][$p2->planyear][$p2->planmonth][$p2->planday][$ser]['tname'] = Tag::find($p2->tag_id)->abbr);
} else {
@($data['fin'][$soc][$p2->planyear][$p2->planmonth][$p2->planday][$ser]['tag'] = "");
}
}
$pm3 = Plan::where('planyear', '=', $y3)->where('planmonth', '=', $m3)->get();
foreach ($pm3 as $p3) {
$soc = Society::find($p3->society_id)->society;
$ser = Service::find($p3->service_id)->servicetime;
if ($p3->preachable) {
@($data['fin'][$soc][$p3->planyear][$p3->planmonth][$p3->planday][$ser]['preacher'] = substr($p3->preachable_type, 11, 1) . "_" . $p3->preachable->id);
if ($p3->preachable_type == "App\\Models\\Guest") {
@($data['fin'][$soc][$p3->planyear][$p3->planmonth][$p3->planday][$ser]['pname'] = substr($p3->preachable->firstname, 0, 1) . " " . $p3->preachable->surname);
} else {
@($data['fin'][$soc][$p3->planyear][$p3->planmonth][$p3->planday][$ser]['pname'] = substr($p3->preachable->individual->firstname, 0, 1) . " " . $p3->preachable->individual->surname);
}
} else {
@($data['fin'][$soc][$p3->planyear][$p3->planmonth][$p3->planday][$ser]['preacher'] = "");
}
if ($p3->tag_id) {
@($data['fin'][$soc][$p3->planyear][$p3->planmonth][$p3->planday][$ser]['tag'] = $p3->tag_id);
@($data['fin'][$soc][$p3->planyear][$p3->planmonth][$p3->planday][$ser]['tname'] = Tag::find($p3->tag_id)->abbr);
} else {
@($data['fin'][$soc][$p3->planyear][$p3->planmonth][$p3->planday][$ser]['tag'] = "");
}
}
$data['tags'] = Tag::orderBy('abbr')->get();
if ($qq == 1) {
$data['prev'] = "plan/" . strval($yy - 1) . "/4";
} else {
$data['prev'] = "plan/{$yy}/" . strval($qq - 1);
}
if ($qq == 4) {
$data['next'] = "plan/" . strval($yy + 1) . "/1";
} else {
$data['next'] = "plan/{$yy}/" . strval($qq + 1);
}
if ($aa == "edit") {
return View::make('plans.edit', $data);
} else {
$data['pb'] = Helpers::getSetting('presiding_bishop');
if (!$data['pb']) {
return view('errors.errors')->with('errormessage', 'Before you can view the plan, please enter the name of the Presiding Bishop');
}
$data['gs'] = Helpers::getSetting('general_secretary');
if (!$data['gs']) {
return view('errors.errors')->with('errormessage', 'Before you can view the plan, please enter the name of the General Secretary');
}
$data['db'] = Helpers::getSetting('district_bishop');
if (!$data['db']) {
return view('errors.errors')->with('errormessage', 'Before you can view the plan, please enter the name of the District Bishop');
}
$data['super'] = Individual::find(Helpers::getSetting('superintendent'));
if (!$data['super']) {
return view('errors.errors')->with('errormessage', 'Before you can view the plan, please specify who the Circuit Superintendent is');
}
$this->report($data);
}
}
/**
* 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);
}
