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);
 }
Exemple #2
0
                @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