public function showFellowSelect($city_id) { $fellowName = "Propel Fellow"; $home = new HomeController(); $year = $home->get_year(); $fellows = Group::where('name', '=', $fellowName)->first()->fellow()->distinct()->where('city_id', '=', $city_id)->where('year', '=', $year)->where('status', '=', '1')->where('user_type', '=', 'volunteer')->get(); //return $fellows; return View::make('city.select-fellow')->with('fellows', $fellows); }
@section('navbar-links') <!--<li><a href="{{URL::to('/')}}/calendar">Calendar</a></li> <li><a href="{{URL::to('/')}}/attendance">Attendance</a></li> <li><a href="{{URL::to('/')}}/wingman-journal">Wingman Journal</a></li>--> @if(!empty($_SESSION['original_id']) && $_SESSION['user_id'] != $_SESSION['original_id']) <li class=""><a href="{{URL::to('/city-change/back-to-national')}}">Back to National</a></li> @endif <li class=""><a> <?php $i = 0; $id = $_SESSION['user_id']; $home = new HomeController(); $name = DB::table('User')->select('name')->where('id', $id)->first(); echo $name->name . ' ('; $groups = DB::table('UserGroup')->join('Group', 'Group.id', '=', 'UserGroup.group_id')->select('Group.name')->where('user_id', $id)->where('year', $home->get_year())->get(); $result = array(); foreach ($groups as $group) { $result[$i] = $group->name; $i++; } $value = join(',', $result); echo $value . ')'; ?> </a> </li> <li class=""><a href="{{URL::to('/logout')}}">Logout</a></li> @show