public function verify(Request $request)
{
//$member_id = (Request::has('memberid')) ? $request->input('memberid') : '';
if (Input::has('memberid')) {
$member_id = $request->input('memberid');
if (Members::where('Member_Reg_No', [$member_id])->exists()) {
return View::make("Verification.memberProfile")->with('member', DB::table('tbl_partial_reg')->where('Member_Reg_No', $member_id)->first())->with('memberpic', new VerificationsController())->with('dependants', DB::table('tbl_dependants')->where('Member_ID_Primary', [$member_id])->get())->with('account', DB::table('tbl_account_entries')->where('Member_ID', $member_id)->first());
} else {
return View::make("Verification.index")->with('verificationMessage', 'An invalid member id was provided, please ensure that the correct id is provided.');
}
} else {
return View::make("Verification.index")->with('verificationMessage', 'Please provide the Membership ID in the textbox below.');
}
}
public function get_soc_mem_details($type, $id)
{
if (\Auth::check()) {
$user = User::where('email', Session::get('email'))->first();
if ($user->priviliges == 1) {
$soc = User::where('id', $id)->get()->first();
$members = Members::where('soc_id', $soc['email'])->where('type', $type)->get();
$members = $members->toArray();
foreach ($members as $key => $field) {
if ($members[$key]['events'] != '' && $members[$key]['events'] != null && $members[$key]['events'] != 'null') {
$x = EventDetails::where('event_id', $members[$key]['events'])->first();
if ($x != '') {
$members[$key]['events'] = EventDetails::where('event_id', $members[$key]['events'])->first()->event_name;
} else {
$members[$key]['events'] = '';
}
}
}
$disp_events = Events::where('society_email', $soc->email)->get()->pluck('event_id');
$disp_event_details = array();
foreach ($disp_events as $disp) {
$disp_event_details[] = EventDetails::where('event_id', $disp)->first();
}
return \View::make('team_table', array('members' => $members, 'type' => $type, 'disp_events' => $disp_event_details));
}
}
return Route::back();
}
public function delete_mem_details($id)
{
if (\Auth::check()) {
$user = User::where('email', Session::get('email'))->first();
$member = Members::where('id', $id);
// dd($member->first());
if ($member->first()->soc_id == Session::get('email')) {
if ($member->delete()) {
return Redirect::back();
}
}
}
return Redirect::back();
}
