@extends('layouts.admin')

@section('content')
    <div class="row">
        <div class="col-lg-12">
            <h1 class="page-header">Level <span class="pull-right"><small><a class="btn btn-primary btn-circle" title="click to add level" href="{{ url('levels/create') }}"><i class="fa fa-plus"></i></a></small></span></h1>
        </div>
    </div>
    <div class="row">
        <div class="col-lg-12">
            @if (count($levels) > 0)
                <div class="table-responsive">
                    <table class="table table-hover">
                        <thead>
                            <th>Code</th>
                            <th>Description</th>
                            <th>Active</th>
                            <th>User</th>
                            <th>Action</th>
                        </thead>
                        <tbody>
                            @foreach ($levels as $level)
                                <tr>
                                    <td><a href="{{ url('/levels/' . $level->id) }}">{{ $level->code }}</a></td>
                                    <td>{{ $level->description }}</td>
                                    <td>{{ $level->is_active==1 ? 'Yes' : 'No' }}</td>
                                    <td>{{ DB::table('users')->join('positions', 'users.position_id', '=', 'positions.id')->where('users.is_active', 1)->where('positions.level_id', $level->id)->count() }}</td>
                                    <td><a href="{{ url('/levels/' . $level->id . '/edit') }}" class="btn btn-default btn-xs"><i class="fa fa-pencil"></i></a></td>
                                </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>
                {{ $levels->links() }}
            @else
                <p>No records found.</p>
            @endif
        </div>
    </div>
@endsection