@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'  => 'Utility Statement Summary',
            ]
        ]
    ])
@endsection
@php
    $unique = uniqid();
    $period = date('d F, Y',strtotime($from)).' To '.date('d F, Y',strtotime($to));
    $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.utilities.summary') }}" method="GET">
                <div class="row">
                    <div class="col-lg-4">
                        <div class="input-group mb-3">
                            <div class="input-group-prepend">
                                <span class="input-group-text">From</span>
                                </div>
                            <div class="input-group-prepend">
                                <input type="text" name="from" value="{{ $from }}" id="from" class="form-control">
                            </div>                          
                        </div><!-- input-group -->
                    </div>
                    
                    <div class="col-lg-4">
                        <div class="input-group mb-3">
                            <div class="input-group-prepend">
                                <span class="input-group-text">To</span>
                                </div>
                            <div class="input-group-prepend">
                                <input type="text" name="to" value="{{ $to }}" id="to" class="form-control">
                            </div>
                        </div><!-- input-group -->
                    </div>
                    <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="utilitysummary{{ $unique }}">
                        <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" data-a-h="center" data-a-v="middle" rowspan="2" style="vertical-align:middle;">Month</th>
                                <th data-f-bold="true" data-a-h="center" data-a-v="middle" rowspan="2" style="vertical-align:middle;">Year</th>
                                @foreach($utilityHeads as $head => $name)
                                <th data-f-bold="true" data-a-h="center" class="text-center" colspan="2">{{ $name }}</th>
                                @endforeach
                            </tr>
                            <tr>
                                @foreach($utilityHeads as $head => $name)
                                @php 
                                    $totals[$head]['amount'] = $totals[$head]['arrear'] = 0;
                                @endphp
                                <th data-f-bold="true" data-a-h="center" class="text-center">Amount</th>
                                <th data-f-bold="true" data-a-h="center" class="text-center">Arrear</th>
                                @endforeach
                            </tr>
                        </thead>
                        <tbody>
                            @foreach($utilities as $month => $utility)
                            <tr>
                                <td>{{ $months[$month] }}</td>
                                <td data-t="n">{{ $utility['year'] }}</td>
                                @foreach($utilityHeads as $head => $name)
                                @php 
                                    $totals[$head]['amount'] += isset($utility['heads'][$head]) ? $utility['heads'][$head]['amount'] : 0;
                                    $totals[$head]['arrear'] += isset($utility['heads'][$head]) ? $utility['heads'][$head]['arrear'] : 0;
                                @endphp
                                <td data-t="n" data-num-fmt="0.00" data-a-h="right">{!! isset($utility['heads'][$head]) ? numberFormat($utility['heads'][$head]['amount']) : numberFormat(0) !!}</td>
                                <td data-t="n" data-num-fmt="0.00" data-a-h="right">{!! isset($utility['heads'][$head]) ? numberFormat($utility['heads'][$head]['arrear']) : numberFormat(0) !!}</td>
                                @endforeach
                            </tr>
                            @endforeach
                        </tbody>
                        <tfoot>
                            <td data-f-bold="true" data-a-h="right" colspan="2" align="right"><b>{!! text('Total') !!}</b></td>
                            @foreach($utilityHeads as $head => $name)
                            <th data-t="n" data-num-fmt="0.00" data-f-bold="true" data-a-h="right" class="text-right">{!! numberFormat($totals[$head]['amount']) !!}</th>
                            <th data-t="n" data-num-fmt="0.00" data-f-bold="true" data-a-h="right" class="text-right">{!! numberFormat($totals[$head]['arrear']) !!}</th>
                            @endforeach
                        </tfoot>
                    </table>
                </div>
            </div>
            <a class="btn btn-primary" onclick="exportToExcel('utilitysummary{{ $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
@section('script')
<script>
    // AmazeUI Datetimepicker
    $('#from').datetimepicker({
      format: 'yyyy-mm-dd',
      pickTime: false,
      autoclose: true,
      minView:2,
    });
    // AmazeUI Datetimepicker
    $('#to').datetimepicker({
      format: 'yyyy-mm-dd',
      pickTime: false,
      autoclose: true,
      minView:2,
    });
</script>
@endsection