@extends('layouts.app')
@section('title', 'Trial Balance')

@section('content')

<!-- Content Header (Page header) -->
<section class="content-header">
    <h1>Trial Balance
    </h1>
    <!-- <ol class="breadcrumb">
        <li><a href="#"><i class="fa fa-dashboard"></i> Level</a></li>
        <li class="active">Here</li>
    </ol> -->
</section>

<!-- Main content -->
<section class="content">
    <div class="box">
    <div class="box-header">
            <form method="get" action="{{route('account.trial-balance.view')}}">
                <div class="row">
                    <div class="col-md-3 col-xs-6">
                        <select name="location_id" class="form-control">
                            <option value=" " selected>All</option>
                            @foreach(App\BusinessLocation::get() as $all_location)
                            <option value="{{$all_location['id']}}" {{ request()->get('location_id') &&  $all_location['id'] == request()->get('location_id') ? 'selected' : '' }}>{{$all_location['name']}}</option>
                            @endforeach
                        </select>
                    </div>
                    <div class="col-md-3 col-xs-6">
                        <div class="input-group">
                            <span class="input-group-addon">
                                <i class="fa fa-calendar"></i>
                            </span>
                            {!! Form::text('filter_date', request()->get('date') ? @format_date(request()->get('date')) : @format_date('now'), ['class' => 'form-control', 'readonly', 'required', 'id' => 'filter_date']); !!}
                        </div>
                    </div>
                    <div class="col-md-3 col-xs-6">
                        <button type="submit" class="btb btn-primary">Filter</button>
                    </div>    
                </div>
            </form>
        </div>
        <div class="box-body">
            @can('account.trial-balance.view')
            <table class="table table-bordered">
                <thead>
                    <tr class="bg-gray">
                        <th scope="col">Details</th>
                        <th scope="col" class="text-center">Debit</th>
                        <th scope="col" class="text-center">Credit</th>
                    </tr>
                </thead>
                <tbody>
                    <tr>
                        <th scope="col">Cash</th>
                        <td scope="col" class="text-right">{{ $final_stats['cash'] > 0  ? @num_format($final_stats['cash'])  : '0.00'}}</td>
                        <td scope="col" class="text-right">{{ $final_stats['cash'] < 0  ? @num_format(abs($final_stats['cash']))  : ''}}</td>
                    </tr>
                    <tr>
                        <th scope="col">Bank</th>
                        <td scope="col" class="text-right">{{ $final_stats['bank'] > 0 ? @num_format($final_stats['bank'])  : '0.00'}}</td>
                        <td scope="col" class="text-right">{{ $final_stats['bank'] < 0 ? @num_format(abs($final_stats['bank']))  : ''}}</td>
                    </tr>
                    <!-- @foreach($banks as $bank)
                    <tr>
                        <th scope="col"  class="text-center">{{ $bank->name }}</th>
                        <td scope="col"></td>
                        <td scope="col" class="text-right">{{ @num_format($bank->current_balance) }}</td>
                    </tr>
                    @endforeach -->
                    <tr>
                        <th scope="col">Suplier Due</th>
                        <td scope="col" class="text-right"></td>
                        <td scope="col" class="text-right">{{ $final_stats['purchase_due'] !== 0 ? @num_format($final_stats['purchase_due'])  : '0.00'}}</td>
                    </tr>
                    <tr>
                        <th scope="col">Expense Due</th>
                        <td scope="col" class="text-right"></td>
                        <td scope="col" class="text-right">{{ $final_stats['expense_due'] !== 0 ? @num_format($final_stats['expense_due'])  : '0.00'}}</td>
                    </tr>
                    <tr>
                        <th scope="col">Customer Due</th>
                        <td scope="col" class="text-right">{{ $final_stats['invoice_due'] !== 0 ? @num_format($final_stats['invoice_due'])  : '0.00'}}</td>
                        <td scope="col" class="text-right"></td>
                    </tr>
                    <tr>
                        <th scope="col">Closing Stock</th>
                        <td scope="col" class="text-right">{{ $final_stats['stock'] !== 0 ? @num_format($final_stats['stock'])  : '0.00'}}</td>
                        <td scope="col" class="text-right"></td>
                    </tr>
                </tbody>
                <tfoot>
                    <tr class="bg-gray">
                        <td scope="col">Total</td>
                        <td scope="col" class="text-right">{{ $final_stats['debit'] !== 0 ? @num_format($final_stats['debit'])  : '0.00'}}</td>
                        <td scope="col" class="text-right">{{ $final_stats['credit'] !== 0 ? @num_format($final_stats['credit'])  : '0.00'}}</td>
                    </tr>
                </tfoot>    
            </table> 
            @endcan
        </div>
        <br>
        <div class="row">
            <div class="col-sm-12">
                <div class="box box-solid">
                    <div class="box-body">
                        <h3 class="text-muted">
                            {{ 'Retained Earnings' }}: 
                            <span class="net_profit">
                                {{ $final_stats['net_profit'] !== 0 ? @num_format($final_stats['net_profit'])  : '0.00'}}
                            </span>
                        </h3>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <div class="modal fade bank_modal" tabindex="-1" role="dialog" 
    	aria-labelledby="gridSystemModalLabel">
    </div>

</section>
<!-- /.content -->

@endsection
@section('javascript')
    <script type="text/javascript">
  
  $('#filter_date').datepicker({
		autoclose: true,
		format: datepicker_date_format
	});
    
    </script>
@endsection