public function get_events_by_category($cat) { if ($cat > 6) { abort(404); } $status = Status::first(); if ($status->add_winners == 0) { return EventDetails::where('grp', $cat)->select('event_name', 'event_description')->get()->toArray(); } else { return EventDetails::where('grp', $cat)->get()->toArray(); } }
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 del_soc($id) { if (\Auth::check()) { $user = User::where('email', Session::get('email'))->first(); if ($user->priviliges == 1) { $soc = User::where('id', $id)->first(); $events = Events::where('society_email', $soc->email)->get(); if ($events) { foreach ($events as $eve) { $event_details = EventDetails::where('event_id', $eve->event_id)->delete(); $eve->delete(); } } } if ($soc->delete()) { return Redirect::route('admin_panel'); } } return Redirect::route('admin_panel'); }