@extends('layouts.adminapp')
@section('content')

{{-- Day Book --}}
<x-app-flash/>
    <!-- DataTales Example -->
    <div class="card shadow mb-4">
        <div class="card-header py-3 d-flex flex-row align-items-center justify-content-between">
            <h6 class="m-0 font-weight-bold text-primary">{{__('lng.HouseReport')}}</h6>
            
            <div class="input-group w-25 input-search">
                <input type="text" id="SearchHouse" value="{{$SerachValue}}" oninput="Search(this.value)" class="form-control bg-light border" placeholder="{{__('lng.SearchHouse')}}" aria-label="Search" aria-describedby="basic-addon2">
                <div class="input-group-append">
                  <button class="btn btn-primary" type="button">
                      <i class="fas fa-search fa-sm"></i>
                  </button>
                </div> 
              </div>
        </div>
        <div class="card-header">
            <div class="row">
                <div class="col-sm-3 form-group">
                    <label for="RentHouse">{{__('lng.RentHouse')}}</label>
                    <select class="form-control" onchange="SearchAll()" id="RentHouse" name="RentHouse">
                        <option value="">{{__('lng.All')}}</option>
                        <option value="0">{{__('lng.RentHouse')}}</option>
                        <option value="1">{{__('lng.NotRentHouse')}}</option>
                    </select>  
                </div>

                <div class="col-sm-3 form-group">
                    <label for="Water">{{__('lng.Water')}}</label>
                        <select onchange="SearchAll()" class="form-control" id="Water" name="Water">
                            <option value="">{{__('lng.All')}}</option>
                            @foreach(PBCon::WATER as $Water)
                                <option value="{{$Water}}">{{$Water}}</option>
                            @endforeach
                        </select> 
                </div>

                <div class="col-sm-3 form-group">
                    <label for="ElectricityHouse">{{__('lng.Electricity')}}</label>
                    <select class="form-control" onchange="SearchAll()" id="ElectricityHouse" name="ElectricityHouse">
                        <option value="">{{__('lng.All')}}</option>
                        <option value="1">{{__('lng.Electricity')}}</option>
                        <option value="0">{{__('lng.NoElectricity')}}</option>
                    </select> 
                </div>

                <div class="col-sm-3 form-group">
                    <label for="SearchArea">{{__('lng.SearchArea')}}</label>
                        <input type="text" id="SearchArea" oninput="SearchAll()" class="form-control bg-light border" placeholder="{{__('lng.SearchArea')}}" aria-label="Search" aria-describedby="basic-addon2">
                          
                </div>
            </div>

        </div>
        <div id="result-tbl">
            @if ($SearchResult)
                @php echo $SearchResult @endphp
            @else
        <div class="card-body">
            <div class="table-responsive" >
                <table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
                    <thead>
                        <tr>
                            <th>{{__('lng.SiNo')}}</th>
                            <th>{{__('lng.HouseName')}}</th>
                            <th>{{__('lng.RegisterNumber')}}</th>
                            @if (\PBFunc::settings('reference'))
                                <th>{{__('lng.Reference')}}</th>
                            @endif
                            <th>{{__('lng.Author')}}</th>
                            @if (\PBFunc::settings('author_relation'))
                                <th>{{__('lng.Relation')}}</th>
                            @endif
                            {{-- <th>{{__('lng.Place')}}</th> --}}
                            <th>{{__('lng.Area/Ward')}}</th>
                            {{-- <th>{{__('lng.Water')}}</th> --}}
                            {{-- <th>{{__('lng.District')}}</th> --}}
                            <th>{{__('lng.Action')}}</th>
                        </tr>
                    </thead>
                    <tbody >
                        @php $i=0;@endphp
                        @foreach ($Houses as $House)
                            <tr>
                                <td>{{++$i}}</td>
                                <td>{{$House->name}}</td>
                                <td>{{$House->registernumber}}</td>
                                @if (\PBFunc::settings('reference'))
                                    <td>{{$House->reference}}</td>
                                @endif
                                @foreach($House->members as $Member)
                                    @if($Member->member_relation_id == App\Extra\General\DBFixedValues::AUTHORITY)
                                        <td> {{$Member->name}}</td>
                                        @if (\PBFunc::settings('author_relation'))
                                            <td>{{$Member->relation_type}} ({{$Member->relation}})</td>
                                        @endif
                                    @endif
                                @endforeach
                                {{-- <td>{{$House->place}}</td> --}}
                                <td>{{$House->area}}</td>
                                {{-- <td>{{$House->water}}</td> --}}
                                {{-- <td>{{$House->district}}</td> --}}
                                <td>
                                    <div class="d-flex flex-row align-items-center">
                                        <a href="{{ route('ViewHouseReport',$House->id) }}" class="btn btn-primary btn-circle btn-sm" data-bs-toggle="tooltip" data-bs-placement="bottom" title="{{__('lng.ViewDetails')}}">
                                            <i class="fas fa-eye"></i>
                                        </a>
                                    </div>
                                </td>
                            </tr>
                        @endforeach
                    </tbody>
                </table>
                <p class="mb-0">{{$Houses->count()}} {{__('lng.Items')}}</p>
            </div>
            <div class="table-responsive m-2" id="card-footer">
                {{$Houses->links()}}
            </div>
        </div>
        @endif
    </div>
        <div class="card-footer">
            <div class="d-flex  justify-content-end p-2 btn-list">
                <form method="POST" action="{{ route('ReportExcel') }}">
                    @csrf
                    
                    <input type="hidden" name="subhead" value="{{__('lng.HouseReport')}}">
                     <input type="hidden" name="Search[]" value="">
                        
                    @php $no=0; @endphp
                    @foreach ($ExcelHouses as $ExcelHouse)
                    <input type="hidden" name="arr[id][]" value="{{++$no}}">
                    <input type="hidden" name="arr[HouseName][]" value="{{$ExcelHouse->name}}">
                    <input type="hidden" name="arr[RegisterNumber][]" value="{{$ExcelHouse->registernumber}}">
                    @if (\PBFunc::settings('reference'))
                    <input type="hidden" name="arr[Reference][]" value="{{$Member->relation_type}} ({{$Member->relation}})">
                    @endif
                    @foreach($ExcelHouse->members as $Member)
                        @if($Member->member_relation_id == App\Extra\General\DBFixedValues::AUTHORITY)
                        <input type="hidden" name="arr[Author][]" value="{{$Member->name}}">
                            @if (\PBFunc::settings('author_relation'))
                            <input type="hidden" name="arr[Relation][]" value="{{$Member->contact}}">
                            @endif
                        @endif
                    @endforeach
                    {{-- <input type="hidden" name="arr[Place][]" value="{{$ExcelHouse->place}}"> --}}
                    <input type="hidden" name="arr[Area/Ward][]" value="{{$ExcelHouse->area}}">
                    {{-- <input type="hidden" name="arr[Water][]" value="{{$ExcelHouse->water}}"> --}}
                    {{-- <input type="hidden" name="arr[District][]" value="{{$ExcelHouse->district}}"> --}}
                    @endforeach
   
                    <button 
                    @if (!$ExcelHouses->count())
                        disabled
                    @endif
                     type="submit" class="btn btn-success btn-icon-split  mt-2">
                        <span class="icon text-white-50">
                            <i class="fas fa-file-export"></i>
                        </span>
                        <span class="text">{{ __('lng.AllExportData') }}</span>
                    </button>
                </form>

         <form method="POST" action="{{ route('PrintHouseReport') }}" enctype='multipart/form-data'>
            @csrf
            <input type="hidden" id="getWater" name="getWater" value="">
            <input type="hidden" id="getRent" name="getRent" value="">
            <input type="hidden" id="getElectricity" name="getElectricity" value="">
            <input type="hidden" id="getArea" name="getArea" value="">
            <div class="d-flex  justify-content-end p-2">
               <button onclick="getPrint()" type="submit" class="btn btn-info btn-icon-split">
                  <span class="icon text-white-50">
                     <i class="fas fa-print"></i>
                  </span>
                  <span class="text">{{ __('lng.Print') }}</span>
               </button>
            </div>
         </form>
        </div>
        </div>
    </div>

<script>
    function Search(Value) {
            document.getElementById('card-footer').style.display="none";
        $.ajax({
            url: '{{ route('SearchHouseReport') }}',
            method: "get",
            data: {_token: '{{ csrf_token() }}',Value:Value},
            success: function (response){  
            // alert(response);
                document.getElementById('result-tbl').innerHTML=response; 
            }
        }); 
    }

    function SearchAll() {
            document.getElementById('card-footer').style.display="none";
            var Rent=document.getElementById('RentHouse').value;
            var Electricity=document.getElementById('ElectricityHouse').value;
            var Water=document.getElementById('Water').value;
            var Area=document.getElementById('SearchArea').value;
            document.getElementById('getRent').value=Rent;
            document.getElementById('getElectricity').value=Electricity;
            document.getElementById('getWater').value=Water;
            document.getElementById('getArea').value=Area;


        $.ajax({
            url: '{{ route('SearchHouseAllReport') }}',
            method: "get",
            data: {_token: '{{ csrf_token() }}',
            Rent:Rent,
            Electricity:Electricity,
            Water:Water,
            Area:Area,
        },
            success: function (response){  
            // alert(response);
                document.getElementById('result-tbl').innerHTML=response; 
            }
        }); 
    }
</script>

@endsection