@extends('layouts.admin')

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