@extends('layouts.app')

@section('title', 'Dashboard')

@section('content')
<div id="content" class="container">
    <div class="row">
        <div>
            <div class="panel panel-default">
                <div class="panel-heading"><h2>Dashboard</h2></div>

                <div class="panel-body">
				<h2>Users</h2>
				Total # of users: {{ $users->count() }}<br />
                Total # of users that have completed all modules: {{ $usersCompletedAll->count() }}<br />
				Newest user is: <a href="{{ route('users.show', $newest_user) }}">{{ $newest_user->email }}</a>, registered on {{ $newest_user->created_at }}<br />
				Most recently logged in user is: <a href="{{ route('users.show', $recent_user) }}">{{ $recent_user->email }}</a>, last logged in at {{ $recent_user->last_login }}<br />

                <br />
               <h4>Top 10 Agencies</h4>
                <table class="table table-hover">
                    <thead>
                      <tr>
                        <th>Agency</th>
                        <th># of users from this agency</th>
                      </tr>
                    </thead>
                    <tbody>
                    @foreach($top_agencies as $agency)
                    <tr>
                        <td>{{ $agency["agency"] }}</td>
                        <td>{{ $agency["count"] }}</td>
                    </tr>
                    @endforeach
                    </tbody>
                </table>

                <hr />
                
				<h2>Modules</h2>
					@foreach($groups as $group)
                       <h3>{{ $group->group }}</h3>
                        <table class="table table-hover">
                            <thead>
                              <tr>
                                <th>Assessment</th>
                                <th>Total attempts (including incomplete attempts)</th>
                                <th>Total completed attempts</th>
                                <th># of times completed (with failing score)</th>
                                <th># of times completed (with passing score)</th>
                                <th>Fail %</th>
                                <th>Pass %</th>
                                <th>Average Score</th>
                                <th>Passing Score</th>
                              </tr>
                            </thead>
                            <tbody>
                        @foreach($assessments as $assessment)
                            @if ($assessment->group == $group->group)
                                <tr>
                                <td><a href="{{ route('assessments.edit', $assessment->name) }}">{{ $assessment->name }}</a></td>
                                <td>
                                   {{ $totalAttempts = $assessment->attempts->count() }}
                                </td>
                                <td>
                                   {{ $totalCompleteAttempts = $assessment->attempts->where('complete', '=', 1)->count() }}
                                </td>
                                <td>
                                   {{ $failAttempts = $assessment->attempts->where('complete', '=', 1)->where('passed', '=', 0)->count() }}
                                </td>
                                <td> 
                                	{{ $passAttempts = $assessment->attempts->where('complete', '=', 1)->where('passed', '=', 1)->count() }}
                                </td>
                                <td>
                                	@if ( $failAttempts > 0)
                                	{{ round(($failAttempts / $totalCompleteAttempts) * 100, 2) }}
                                	@else
                                	0
                                	@endif
                                </td>
                                <td>
                                	@if ( $passAttempts > 0)
                                	{{ round(($passAttempts / $totalCompleteAttempts) * 100, 2) }}
                                	@else
                                	0
                                	@endif
                                </td>
                                <td> 
                                	{{ round($assessment->attempts->where('complete', '=', 1)->avg('score'), 2) }}
                                </td>
                                <td> 
                                	{{ $assessment->pass_score }}
                                </td>
                              </tr>
                            @endif
                        @endforeach
                        </tbody>
                      </table>
                    @endforeach


            	</div>

        </div>
    </div>
</div>
@endsection