@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'  => $title,
            ]
        ]
    ])
@endsection
@php
    $totals = $arrears = [];
    $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']);
@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 == $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="statement{{ $unique }}" data-cols-width="5,20,30,20,15,15 @foreach($collections as $head=>$name){!! ',15' !!} @if(in_array($head, $hasArrear)) {!! ',20' !!} @endif @endforeach ,15 @foreach($deductions as $head=>$name){!! ',15' !!} @if(in_array($head, $hasArrear)) {!! ',20' !!} @endif @endforeach ,15,15">
                        <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">Name</th>
                                <th data-f-bold="true">House</th>
                                <th data-f-bold="true">Contract Period</th>
                                <th data-f-bold="true">Area (S.F)</th>
                                <th data-f-bold="true">Rent Per S.F</th>
                                @foreach($collections as $head => $name)
                                @php 
                                    $totals[$head] = $arrears[$head] = 0;
                                @endphp
                                <th data-f-bold="true">{{ $name }}</th>
                                @if(in_array($head, $hasArrear))
                                <th data-f-bold="true">Arrear of {{ $name }}</th>
                                @endif
                                @endforeach
                                <th data-f-bold="true">Gross</th>
                                @foreach($deductions as $head => $name)
                                @php 
                                    $totals[$head] = $arrears[$head] = 0;
                                @endphp
                                <th data-f-bold="true">{{ $name }}</th>
                                @if(in_array($head, $hasArrear))
                                <th data-f-bold="true">Arrear of {{ $name }}</th>
                                @endif
                                @endforeach
                                <th data-f-bold="true">Total Deduction</th>
                                <th data-f-bold="true">Net Payable</th>
                            </tr>
                        </thead>
                        <tbody>
                            @php 
                                $totalGross = 0;
                                $totalDeduction = 0;
                            @endphp
                            @foreach($rents as $rent)
                            @php 
                                $gross = $deduction = 0;
                            @endphp
                            <tr>
                                <td data-t="n">{{ $loop->index+1 }}</td>
                                <td>{{ $rent->tenant_name }}</td>
                                <td>{{ $rent->house }}</td>
                                <td data-a-wrap="true">{{ $rent->contract_start }} To <br> {{ $rent->contract_end }}</td>
                                <td data-t="n" data-num-fmt="0.00" data-a-h="right">{{ $rent->sf }}</td>
                                <td data-t="n" data-num-fmt="0.00" data-a-h="right">{{ $rent->ppsf }}</td>
                                @foreach($collections as $head => $name)
                                @php 
                                    $gross += isset($rent->heads->$head) ? $rent->heads->$head->total : 0;
                                    $totalGross += isset($rent->heads->$head) ? $rent->heads->$head->total : 0;

                                    $totals[$head] += isset($rent->heads->$head) ? $rent->heads->$head->amount : 0;
                                    $arrears[$head] += isset($rent->heads->$head) ? $rent->heads->$head->arrear : 0;
                                @endphp
                                <td data-t="n" data-num-fmt="0.00" data-a-h="right">{!! numberFormat(isset($rent->heads->$head) ? $rent->heads->$head->amount : 0) !!}</td>
                                @if(in_array($head, $hasArrear))
                                <td data-t="n" data-num-fmt="0.00" data-a-h="right">{!! numberFormat(isset($rent->heads->$head) ? $rent->heads->$head->arrear : 0) !!}</td>
                                @endif
                                @endforeach
                                <td data-t="n" data-num-fmt="0.00" data-a-h="right">{!! numberFormat($gross) !!}</td>
                                @foreach($deductions as $head => $name)
                                @php 
                                    $deduction += isset($rent->heads->$head) ? $rent->heads->$head->total : 0;
                                    $gross -= isset($rent->heads->$head) ? $rent->heads->$head->total : 0;
                                    $totalDeduction += isset($rent->heads->$head) ? $rent->heads->$head->total : 0;

                                    $totals[$head] += isset($rent->heads->$head) ? $rent->heads->$head->amount : 0;
                                    $arrears[$head] += isset($rent->heads->$head) ? $rent->heads->$head->arrear : 0;
                                @endphp
                                <td data-t="n" data-num-fmt="0.00" data-a-h="right">{!! numberFormat(isset($rent->heads->$head) ? $rent->heads->$head->amount : 0) !!}</td>
                                @if(in_array($head, $hasArrear))
                                <td data-t="n" data-num-fmt="0.00" data-a-h="right">{!! numberFormat(isset($rent->heads->$head) ? $rent->heads->$head->arrear : 0) !!}</td>
                                @endif
                                @endforeach
                                <td data-t="n" data-num-fmt="0.00" data-a-h="right">{!! numberFormat($deduction) !!}</td>
                                <td data-t="n" data-num-fmt="0.00" data-a-h="right">{!! numberFormat($gross) !!}</td>
                            </tr>
                            @endforeach
                        </tbody>
                        <tfoot>
                            <tr>
                                <td data-f-bold="true" data-a-h="right" colspan="6" align="right"><b>{!! text("Total") !!}</b></td>
                                @foreach($collections as $head => $name)
                                <th data-f-bold="true" data-t="n" data-num-fmt="0.00" data-a-h="right">{!! numberFormat($totals[$head]) !!}</th>
                                @if(in_array($head, $hasArrear))
                                <th data-f-bold="true" data-t="n" data-num-fmt="0.00" data-a-h="right">{!! numberFormat($arrears[$head]) !!}</th>
                                @endif
                                @endforeach
                                <th data-f-bold="true" data-t="n" data-num-fmt="0.00" data-a-h="right">{!! numberFormat($totalGross) !!}</th>
                                @foreach($deductions as $head => $name)
                                <th data-f-bold="true" data-t="n" data-num-fmt="0.00" data-a-h="right">{!! numberFormat($totals[$head]) !!}</th>
                                @if(in_array($head, $hasArrear))
                                <th data-f-bold="true" data-t="n" data-num-fmt="0.00" data-a-h="right">{!! numberFormat($arrears[$head]) !!}</th>
                                @endif
                                @endforeach
                                <th data-f-bold="true" data-t="n" data-num-fmt="0.00" data-a-h="right">{!! numberFormat($totalDeduction) !!}</th>
                                <th data-f-bold="true" data-t="n" data-num-fmt="0.00" data-a-h="right">{!! numberFormat($totalGross - $totalDeduction) !!}</th>
                            </tr>
                        </tfoot>
                    </table>
                </div>
            </div>
            <a class="btn btn-primary" onclick="exportToExcel('statement{{ $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