<th>Department</th> @foreach($events as $event) <th>{{ $event-> name}}</th> @endforeach <th>Total Points</th> </tr> </thead> <tbody> @foreach ($members as $member) <tr> <td><a href="{{ action('MembersController@show', [$member->id]) }}">{{$member->last_name}}, {{ $member->first_name }}</a></td> <td>{{ $member->department }}</td> @foreach ($events as $event) <?php $member_point = App\Point::where('event_id', $event->id)->where('member_id', $member->id)->first(); ?> @if (is_null($member_point)) <td>0</td> @else <td>{{ $member_point->point }}</td> @endif @endforeach <td>{{ $member->total_points }}</td> <td><a href="{{ action ('PointsController@create', [$member->id]) }}">Add Points</a></td> </tr> @endforeach </tbody> </table> @stop