Example #1
0
 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();
 }