@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'  => $title,
            ]
        ]
    ])
@endsection
@php
    $total = $arrear = $paid = $due = 0;
    $year = request()->year ?? date('Y');
    $month = request()->month ?? (int)date('m');
    $period = date('F',strtotime($month)).' '.$year;
    $fileName = str_replace(' ','_',$title).'_'.str_replace(' ','_',$period);
    $companyLogo = asset($company['company.logo']);
    $companyFooterLogo = getBase64($company['company.footerLogo']);
    $status = '0D0DCAF0';
@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 == $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 == $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%" id="payment{{ $unique }}" data-cols-width="5,15,20,35 @for($j = 5; $j<10; $j++){!! ',10' !!}@endfor">
                        <thead>
                            @if(!in_array($company['company.logo'],['','undefined']))
                            <tr style="display:none;">
                                <th class="text-center mt-5" colspan="9">
                                    <img width="180px" class="img img-responsive" src="" >
                                </th>
                            </tr>
                            @endif
                            <tr style="display:none;">
                                <th data-f-bold="true" class="text-left mt-5" colspan="9" 
                                data-a-h="left"
                                ><b>Company: {{ $company['company.name'] }}</b></th>
                            </tr>
                            <tr style="display:none;">
                                <th data-f-bold="true" class="text-left mt-5" colspan="9"
                                data-a-h="left"
                                ><b>Report: {{ $title }}</b></th>
                            </tr>
                            <tr style="display:none;">
                              <th data-f-bold="true" class="text-left mt-5" data-a-h="left"
                              colspan="9"><b>Period: {{ $period }} </b></th>
                            </tr>
                            <tr>
                                <th data-f-bold="true">Sl.</th>
                                <th data-f-bold="true">Date</th>
                                <th data-f-bold="true">Name</th>
                                <th data-f-bold="true">House</th>
                                <th data-f-bold="true">Total</th>
                                <th data-f-bold="true">Paid</th>
                                <th data-f-bold="true">Due</th>
                                <th data-f-bold="true">Arrear</th>
                                <th data-f-bold="true">Cash/Bank</th>
                                <th data-f-bold="true">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;
                                if($payment->status == 0){
                                $status = 'DCDC3545'; 
                                }
                                elseif($payment->status == 1){
                                $status = '3B3BB001';
                                }
                                elseif($payment->status == 2){
                                $status = 'FFFFC107';
                                }
                                else{
                                $status = '0D0DCAF0';
                                }
                            @endphp
                            <tr>
                                <td data-t="n">{{ $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 data-t="n" data-num-fmt="0.00" data-a-h="right">{!! numberFormat($payment->houseRents->sum('amount')) !!}</td>
                                <td data-t="n" data-num-fmt="0.00" data-a-h="right">{!! numberFormat($payment->amount) !!}</td>
                                <td data-t="n" data-num-fmt="0.00" data-a-h="right">{!! numberFormat($payment->houseRents->sum('amount') - $payment->amount) !!}</td>
                                <td data-t="n" data-num-fmt="0.00" data-a-h="right">{!! numberFormat($payment->arrear) !!}</td>
                                <td>{{ $paymentMethods[$payment->type] }}</td>
                                <td data-f-color="{{ $status }}">
                                    @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>
                                <td data-f-bold="true" data-a-h="right" colspan="4" align="right"><b>{!! text("Total") !!}</b></td>
                                <th data-t="n" data-num-fmt="0.00" data-f-bold="true" data-a-h="right">{!! numberFormat($total) !!}</th>
                                <th data-t="n" data-num-fmt="0.00" data-f-bold="true" data-a-h="right">{!! numberFormat($paid) !!}</th>
                                <th data-t="n" data-num-fmt="0.00" data-f-bold="true" data-a-h="right">{!! numberFormat($due) !!}</th>
                                <th data-t="n" data-num-fmt="0.00" data-f-bold="true" data-a-h="right">{!! numberFormat($arrear) !!}</th>
                                <th colspan="2"></th>
                            </tr>
                        </tfoot>
                    </table>
                </div>
            </div>
            <a class="btn btn-primary" onclick="exportToExcel('payment{{ $unique }}','{{ $fileName }}','{{ $title }}')" type="button" href="javascript:;">Export to Excel</a>
        </div>
        <div class="card-footer bd-t tx-right">
            {!! poweredBy() !!}
        </div>
    </div>
</div>
@endsection