@extends('layouts.admin')

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