@extends('app.master')
@section('title',$title)
@section('breadcrumb')       
    @include('app.layouts.rent.breadcrumb',[
        'pageTitle' => $title,
        'lists' => [
            [
                'link'  => '#',
                'name'  => 'Rent Reports',
            ],
            [
                'link'  => 'rent.reports.payment',
                'name'  => 'Payment Report',
            ]
        ]
    ])
@endsection
@php
    $total = $arrear = $paid = $due = 0
@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.payment') }}" 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>Date</th>
                                <th>Name</th>
                                <th>House</th>
                                <th>Total</th>
                                <th>Paid</th>
                                <th>Due</th>
                                <th>Arrear</th>
                                <th>Cash/Bank</th>
                                <th>Status</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach($payments as $payment)
                            @php 
                                $total += $payment->houseRents->sum('amount');
                                $arrear += $payment->arrear;
                                $paid += $payment->amount;
                                $due += $payment->houseRents->sum('amount') - $payment->amount;
                            @endphp
                            <tr>
                                <td>{{ $loop->index+1 }}</td>
                                <td>{{ $payment->date }}</td>
                                <td>{{ $payment->tenant->name }}</td>
                                <td>{{ $payment->tenantHouse->unit->floor->house->name.' | '
                                    .$payment->tenantHouse->unit->floor->name.' | '.$payment->tenantHouse->unit->name }}</td>
                                <td>{!! numberFormat($payment->houseRents->sum('amount')) !!}</td>
                                <td>{!! numberFormat($payment->amount) !!}</td>
                                <td>{!! numberFormat($payment->houseRents->sum('amount') - $payment->amount) !!}</td>
                                <td>{!! numberFormat($payment->arrear) !!}</td>
                                <td>{{ $paymentTypes[$payment->type] }}</td>
                                <td>
                                    @if($payment->status == 0)
                                        <span class="badge badge-danger">{{ $paymentStatuses[$payment->status] }}</span>
                                    @elseif($payment->status == 1)
                                        <span class="badge badge-success">{{ $paymentStatuses[$payment->status] }}</span>
                                    @elseif($payment->status == 2)
                                        <span class="badge badge-warning">{{ $paymentStatuses[$payment->status] }}</span>
                                    @else
                                        <span class="badge badge-info">{{ $paymentStatuses[$payment->status] }}</span>
                                    @endif
                                </td>
                            </tr>
                            @endforeach
                        </tbody>
                        <tfoot>
                            <tr>
                                <th>Sl.</th>
                                <th>Date</th>
                                <th>Name</th>
                                <th>House</th>
                                <th>{!! numberFormat($total) !!}</th>
                                <th>{!! numberFormat($paid) !!}</th>
                                <th>{!! numberFormat($due) !!}</th>
                                <th>{!! numberFormat($arrear) !!}</th>
                                <th>Cash/Bank</th>
                                <th>Status</th>
                            </tr>
                        </tfoot>
                    </table>
                </div>
            </div>
        </div>
        <div class="card-footer bd-t tx-right">
            {!! poweredBy() !!}
        </div>
    </div>
</div>
@endsection