public function driverGuest($email)
{
$guest = \App\Models\Guest::where('email', $email)->first();
if (!$guest) {
$guest = \App\Models\Guest::create(compact('email'));
}
return $guest;
}
/**
* Show the form for creating a new resource.
*
* @return \Illuminate\Http\Response
*/
public function create($society, $series)
{
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::where('active', '=', 1)->orderBy('surname')->orderBy('firstname')->get();
return view('sermons.create', $data);
} else {
return view('shared.unauthorised');
}
}
public function plusOneOf()
{
return Guest::where('plus_one', '=', $this->id);
}
/**
* 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);
}
}
public function get_guestaccept($id)
{
if (Auth::user()->type == 'admin') {
$faker = Faker\Factory::create();
$teacher = Guest::where(['id' => $id])->first();
$success = User::create(['memberid' => $faker->unique()->md5, 'name' => $teacher->name, 'email' => $teacher->email, 'password' => bcrypt($teacher->password), 'type' => 'teacher']);
if ($success) {
TeacherInfo::create(['memberid' => $success->memberid, 'package' => $teacher->package]);
$success = Guest::where(['id' => $id])->delete();
if ($success) {
return response()->json(['stat' => 'success', 'message' => 'Successfully Accepted Guest']);
} else {
Guest::where(['id' => $id])->delete();
return response()->json(['stat' => 'success', 'message' => 'Successfully Accepted Guest']);
}
} else {
return response()->json(['stat' => 'failed', 'message' => 'Could not accept Guest']);
}
}
}
public function getTablePopulationAttribute()
{
return Guest::where('table_id', '=', $this->id)->count();
}
/**
* 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);
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
Guest::find($id)->Festival()->detach();
$guest = Guest::find($id);
$a = Guest::where('id', $id)->delete();
$response = [];
$response["name"] = $guest->name;
if ($a > trashed()) {
$statusCode = 200;
$response['result'] = "deleted";
} else {
$statusCode = 422;
$response['result'] = "Cannot delete.";
}
return Response::json($response, $statusCode);
}
