@extends('app.master')
@section('title',$title)
@section('breadcrumb')       
    @include('app.layouts.rent.breadcrumb',[
        'pageTitle' => $title,
        'lists' => [
            [
                'link'  => '#',
                'name'  => 'Rent Reports',
            ],
            [
                'link'  => 'rent.reports.statement',
                'name'  => 'Statement',
            ]
        ]
    ])
@endsection
@php
    $totals = $arrears = []
@endphp
@section('content')
<div class="col-md-12">
    <div class="card">
        <div class="card-header tx-medium bd-0 tx-white bg-indigo">@yield('title')</div>

        <div class="card-body">
            <form action="{{ route('rent.reports.statement') }}" method="GET">
                <div class="row">
                    <div class="col-lg-3">
                        <div class="input-group mb-3">
                            <div class="input-group-prepend">
                                <span class="input-group-text">Year</span>
                                </div>
                            <div class="input-group-prepend">
                                <select class="form-control select2" name="year">
                                    <option label="Choose one"></option>
                                    @foreach($years as $key => $value)
                                    <option value="{{ $key }}" {{ $key == 0 ? 'disabled selected' : '' }} {{ $key == request()->year ? 'selected' : '' }}>{{ $value }}</option>
                                    @endforeach
                                </select>
                            </div>                          
                        </div><!-- input-group -->
                        
                    </div><!-- col-4 -->  
                    
                    <div class="col-lg-3">
                        <div class="input-group mb-3">
                            <div class="input-group-prepend">
                                <span class="input-group-text">Month</span>
                                </div>
                            <div class="input-group-prepend">
                                <select class="form-control select2" name="month">
                                    @foreach($months as $key => $value)
                                    <option value="{{ $key }}" {{ $key == 0 ? 'disabled selected' : '' }} {{ $key == request()->month ? 'selected' : '' }}>{{ $value }}</option>
                                    @endforeach
                                </select>
                            </div>
                        </div>
                    </div><!-- col-4 --> 
                    <div class="col-lg-3">
                        <div class="input-group mb-3">
                            <div class="input-group-prepend">
                                <span class="input-group-text">Tenants</span>
                                </div>
                            <div class="input-group-prepend">
                                <select class="form-control select2" name="tenant_id">
                                    @foreach($tenants as $key => $value)
                                    <option value="{{ $key }}" {{ $key == 0 ? 'selected' : '' }} {{ $key == request()->tenant_id ? 'selected' : '' }}>{{ $value }}</option>
                                    @endforeach
                                </select>
                            </div>
                        </div>
                    </div><!-- col-4 --> 
                    <div class="col-lg-12">
                        <button type="submit" class="btn btn-primary right">
                            {{ __('Search') }}
                        </button>
                    </div>
                </div>
            </form>
            <div class="row">
                <div class="col-md-12">
                    <h3 class="text-center mt-5">@yield('title')</h3>
                    <h5 class="text-center mb-5">{{ $company['company.name'] }}</h5>
                    <table class="table table-stripped table-bordered" width="100%">
                        <thead>
                            <tr>
                                <th>Sl.</th>
                                <th>Name</th>
                                <th>House</th>
                                <th>Contract</th>
                                <th>Area (S.F)</th>
                                <th>Rent Per S.F</th>
                                @foreach($collections as $head => $name)
                                @php 
                                    $totals[$head] = $arrears[$head] = 0;
                                @endphp
                                <th>{{ $name }}</th>
                                @if(in_array($head, $hasArrear))
                                <th>Arrear of {{ $name }}</th>
                                @endif
                                @endforeach
                                <th>Gross</th>
                                @foreach($deductions as $head => $name)
                                @php 
                                    $totals[$head] = $arrears[$head] = 0;
                                @endphp
                                <th>{{ $name }}</th>
                                @if(in_array($head, $hasArrear))
                                <th>Arrear of {{ $name }}</th>
                                @endif
                                @endforeach
                                <th>Total Deduction</th>
                                <th>Net Payable</th>
                            </tr>
                        </thead>
                        <tbody>
                            @php 
                                $totalGross = 0;
                                $totalDeduction = 0;
                            @endphp
                            @foreach($rents as $rent)
                            @php 
                                $gross = $deduction = 0;
                            @endphp
                            <tr>
                                <td>{{ $loop->index+1 }}</td>
                                <td>{{ $rent->tenant_name }}</td>
                                <td>{{ $rent->house }}</td>
                                <td>{{ $rent->contract_start }} | {{ $rent->contract_end }}</td>
                                <td>{{ $rent->sf }}</td>
                                <td>{{ $rent->ppsf }}</td>
                                @foreach($collections as $head => $name)
                                @php 
                                    $gross += $rent->heads->$head->total;
                                    $totalGross += $rent->heads->$head->total;

                                    $totals[$head] += $rent->heads->$head->amount;
                                    $arrears[$head] += $rent->heads->$head->arrear;
                                @endphp
                                <td>{{ $rent->heads->$head->amount }}</td>
                                @if(in_array($head, $hasArrear))
                                <td>{{ $rent->heads->$head->arrear }}</td>
                                @endif
                                @endforeach
                                <td>{{ number_format($gross,2) }}</td>
                                @foreach($deductions as $head => $name)
                                @php 
                                    $deduction += $rent->heads->$head->total;
                                    $gross -= $rent->heads->$head->total;
                                    $totalDeduction += $rent->heads->$head->total;

                                    $totals[$head] += $rent->heads->$head->amount;
                                    $arrears[$head] += $rent->heads->$head->arrear;
                                @endphp
                                <td>{{ $rent->heads->$head->amount }}</td>
                                @if(in_array($head, $hasArrear))
                                <td>{{ $rent->heads->$head->arrear }}</td>
                                @endif
                                @endforeach
                                <td>{{ number_format($deduction,2) }}</td>
                                <td>{{ number_format($gross,2) }}</td>
                            </tr>
                            @endforeach
                        </tbody>
                        <tfoot>
                            <tr>
                                <th>Sl.</th>
                                <th>Name</th>
                                <th>House</th>
                                <th>Contract</th>
                                <th>Area (S.F)</th>
                                <th>Rent Per S.F</th>
                                @foreach($collections as $head => $name)
                                <th>{{ number_format($totals[$head],2) }}</th>
                                @if(in_array($head, $hasArrear))
                                <th>{{ number_format($arrears[$head],2) }}</th>
                                @endif
                                @endforeach
                                <th>{{ number_format($totalGross,2) }}</th>
                                @foreach($deductions as $head => $name)
                                <th>{{ number_format($totals[$head],2) }}</th>
                                @if(in_array($head, $hasArrear))
                                <th>{{ number_format($arrears[$head],2) }}</th>
                                @endif
                                @endforeach
                                <th>{{ number_format($totalDeduction,2) }}</th>
                                <th>{{ number_format($totalGross - $totalDeduction,2) }}</th>
                            </tr>
                        </tfoot>
                    </table>
                </div>
            </div>
        </div>
        <div class="card-footer bd-t tx-right">
            {!! poweredBy() !!}
        </div>
    </div>
</div>
@endsection