@extends('admin.layout')

@section('content')

    <div class="wrapper-md">
        <div class="panel panel-default">
            <div class="panel-heading">
                <div class="row">
                    <div class="col-md-10">
                        <p class="m-n font-thin h3">Report(Income)</p>
                    </div>
                    <div class="col-md-2 text-right">

                    </div>
                </div>
            </div>


                <div class="panel-body">
                <div class="card">
                    <div class="card-body">

                  <form method="GET" action="{{ url('/report-rental') }}" accept-charset="UTF-8"   autocomplete="off" class="form-inline my-2 my-lg-0 float-right" role="search">
                      <div class="input-group">
                          <label>Flat Number</label>
                          <input type="text" class="form-control" name="flat_no"  value="{{ request('flat_no') }}">
                      </div>
                          {{--  <div class="input-group">
                                <label>Utility</label>
                                <select class="form-control selectpicker" name="searchByUtility[]" multiple   data-selected-text-format="count"  data-size="5" data-actions-box="true"  data-live-search="true"  >
                                    <option value="">--Search By Utility--</option>
                                    @foreach($utility_setups as $key=>$item)
                                    <option value="{{$item->ref_code}}"  @if(  @in_array($item->ref_code, request('searchByUtility'))) selected @endif>{{ $item->title }}</option>
                                        @endforeach
                                </select>

                            </div>--}}

                      <div class="form-group {{ $errors->has('date') ? 'has-error' : ''}}  " >
                          <label for="date" >{{ 'Date From' }}</label><br>
                          <input class="form-control" name="date_from" type="text"   value="{{  request('date_from') }}" data-provide="datepicker"
                                 data-date-format="dd/mm/yyyy">
                          {!! $errors->first('date', '<p class="help-block">:message</p>') !!}
                      </div>

                      <div class="form-group {{ $errors->has('date') ? 'has-error' : ''}}  "  >
                          <label for="date"  >{{ 'Date To' }}</label><br>
                          <input class="form-control" name="date_to" type="text"   value="{{  request('date_to') }}" data-provide="datepicker"
                                 data-date-format="dd/mm/yyyy">
                          {!! $errors->first('date', '<p class="help-block">:message</p>') !!}
                      </div>


                      <div class="input-group pt-4"><br>
                                    <button class="btn btn-secondary" type="submit">
                                        <i class="fa fa-search"></i> Search
                                    </button>
                      </div>
                        </form>

                        <br/>
                        <br/>
                        <div class="table-responsive">
                            <table class="table table-bordered table-primary   dataTable table-hover">
                                <thead>
                                    <tr>
                                        <th>Date</th><th>Flat</th>
                                        @foreach($utility_setups as $item)
                                        <th>{{ $item->title ?? '' }} ({{ $item->ref_code ?? '' }})</th>
                                        @endforeach

                                    </tr>
                                </thead>
                                <tbody>
                                @php $total = array(); @endphp
                                @foreach($result as $item)
                                    <tr>
                                        <td>{{ !empty($item->created_at)? date('d/m/Y',  strtotime($item->created_at)) : '' }}</td>
                                        <td>{{ $item->flat_no ?? '' }}</td>
                                        @foreach($utility_setups as $utility) @php $found = 0 @endphp
                                            @foreach($item->rent_invoice_detail as $utility_item)
                                                @if($utility_item->utility_ref_code == $utility->ref_code)
                                                  <td class="text-right">{{ $utility_item->amount }} </td>
                                                @php  $total[$utility->ref_code][] = $utility_item->amount ;  $found = 1 @endphp
                                                @endif
                                        @endforeach
                                        @if($found == 0)
                                            <td class="text-right"> --- </td>
                                            @php  $total[$utility->ref_code][] =0; $found = 1 @endphp
                                        @endif
                                        @endforeach
                                    </tr>
                                @endforeach
                                </tbody>
                                <tfoot>
                                <tr>
                                    <th colspan="2">Total=</th>
                                    @foreach($utility_setups as $utility) @php $found = 0 @endphp

                                        <th class="text-right">{{ array_sum($total[$utility->ref_code]) ?? '0' }} </th>

                                    @endforeach
                                </tr>
                                </tfoot>
                            </table>

                        </div>

                    </div>
                </div>
            </div>
        </div>
    </div>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>

    <script src="https://cdn.datatables.net/buttons/1.5.6/js/buttons.html5.min.js"></script>

    <script src="https://cdn.datatables.net/buttons/1.5.6/js/buttons.print.min.js"></script>
    <script src=" https://cdn.datatables.net/buttons/1.5.6/js/buttons.colVis.min.js"></script>


    <link rel="stylesheet" href="//cdn.datatables.net/1.10.16/css/jquery.dataTables.min.css">
    <script src="//cdn.datatables.net/1.10.16/js/jquery.dataTables.min.js"></script>

     <style>
         .dataTables_wrapper .dataTables_paginate .paginate_button{
             padding: 0 !important;
         }
     </style>

    <link rel="stylesheet" href="https://cdn.datatables.net/buttons/1.4.1/css/buttons.dataTables.min.css">
    <script type="text/javascript" language="javascript" src="https://cdn.datatables.net/buttons/1.4.1/js/dataTables.buttons.min.js"></script>
    <script type="text/javascript" language="javascript" src="https://cdn.datatables.net/buttons/1.4.1/js/buttons.flash.min.js"></script>
    <script type="text/javascript" language="javascript" src="https://cdn.datatables.net/buttons/1.4.1/js/buttons.html5.min.js"></script>
    <script type="text/javascript" language="javascript" src="https://cdn.datatables.net/buttons/1.4.1/js/buttons.print.min.js"></script>
    <script type="text/javascript">
        $(document).ready(function () {
            ////////////////////////////////////////////////////////////////////////////////////////
            $(".dataTable3").dataTable();
            $('.dataTable').dataTable({
                "bPaginate": true,
                "bLengthChange": false,
                "bFilter": true,
                "bSort": false,
                "bInfo": true,
                "bAutoWidth": false,
                dom: 'Bfrtip',
                select: true,
                fixedHeader: true,
                colReorder: true,
                "scrollY": 500,
                buttons: [
                    'csv','pdf', 'excel', 'print'
                ],
                "lengthMenu": [[ 20, 25, 50,100, -1], [20, 25, 50,100, "All"]],


                "bPaginate": true,
                "sPaginationType": "full_numbers",
            });
        });
    </script>
@endsection