@extends('admin.layout.master')
@section('custom_style')
    <style>
    .card-body-container {
        overflow-y: scroll;
        max-height: 83vh;
    }

     #collection_detail_div .table thead th {
        background-color: #f2f2f2;
        position: sticky;
        top: 0;
        z-index: 1;
    }

    </style>
@endsection

@section('content')
    @include('flash-message')
   

    <div class="card sina-card">
        <div class="card-header d-flex justify-content-between"> 
            <h5 class="font-weight-bold mb-0">{{__('obs.user')}} {{__('obs.collection')}}</h5> 
            <button class="btn btn-warning" type="button" name="button" onclick="PrintDiv()">
                <i class="fa fa-print"></i>
            </button>
        </div>
        <div class="card-body card-body-container">

            <form action="{{route('frontdesk.receipt.user_collection')}}" method="GET" class="form-horizontal" enctype="multipart/form-data">
                <div class="row">
                   
                    <div class="form-group col-2">
                        <label for="sender_id" class="">{{__('obs.user')}}</label>
                        <select id="user_id" name="user_id" class="form-control select_2" >
                            <option class="" value="">{{__('obs.select')}}  {{__('obs.user')}}</option>
                            @foreach ($users as $user)
                            <option value="{{ $user->id }}" class="">
                                {{ $user->name }}
                            </option>
                            @endforeach
                        </select>
                    </div>
                 
                    <div class="form-group col-2">
                        <label class="">{{__('obs.start_date')}}</label>
                        <input type="text" value="{{request()->start_date}}" class="form-control date_picker" id="start_date" name="start_date">
    
                        @error('start_date')
                            <span class="help-block text-center text-danger">
                                <strong>{{ $message }}</strong>
                            </span>
                        @enderror
                    </div>
        
                    <div class="form-group col-2">
                        <label class="">{{__('obs.end_date')}} </label>
                        <input type="text" value="{{request()->end_date}}" class="form-control date_picker" id="end_date" name="end_date">
    
                        @error('end_date')
                            <span class="help-block text-center text-danger">
                                <strong>{{ $message }}</strong>
                            </span>
                        @enderror
                    </div>
                  
                    <div class="form-group col-1 mt-4">
                        <label class=""></label>
                        <button type="submit" value="search_button" class="btn btn-primary btn-sm" name="search_button" id="search_button" >{{__('obs.filter')}}</button>
                    </div>
                </div>
               
            </form>
                

            <div class="card sina-card my-2" id="divTableDataHolder">
                @include("frontdesk.report.report_header")


                <div class="card-header text-center">
                    <h4 class="font-weight-bold text-center m-0">{{ __('obs.collection_details') }}</h4>
                </div>

                <div class="card-body ">
                    <div class="">
                        <div class="" id="print">
                            <table class="table table-bordered table-hover text-center" style="width: 100%"  id="datatable_apply">
                                <thead class="mt-3">
                                    <tr>
                                        <th>#{{ __('obs.sl') }}</th>
                                        <th>{{ __('obs.collect_by') }}</th>
                                        <th>{{ __('obs.date') }}</th>
                                        <th>{{ __('obs.reservation_no') }}</th>
                                        <th>{{ __('obs.checkin_no') }}</th>
                                        <th>{{ __('obs.party') }}</th>
                                        <th>{{ __('obs.received') }}</th>
                                        <th>{{ __('obs.refund') }}</th>
                                        {{-- <th>Check Box &nbsp;
                                            <input type="checkbox" id="vehicle1" name="vehicle1" value="Bike">
                                        </th> --}}
                                    </tr>
                                </thead>
                                <tbody>
                                    @if (!empty($user_collection_details))
                                        @php
                                            $i = 1;
                                        @endphp
                                        @foreach ($user_collection_details as $reservaion_id => $data)
                                            @php
                                                $received = round($data->whereIn('voucher_type', [1, 4])->sum('amount'), 2);
                                                $refund = round($data->whereIn('voucher_type', [5])->sum('amount'), 2);
                                                $discount = $data->whereIn('ledger_id',[getInitDataWithKeyWord('discount')->ledger_id,getInitDataWithKeyWord('commission')->ledger_id])->sum('amount');
                                            @endphp
                                            <tr>
                                                <td>{{ $i++ }}</td>
                                                <td>{{ $data->first() ? $data->first()->user ? $data->first()->user->name : null : null}}</td>
                                                <td>{{ $data->first() ? date("d-m-Y",strtotime($data->first()->date)) : null}}</td>
                                                <td>{{ $data->first() ? $data->first()->reservation ? $data->first()->reservation->resv_code : null : null}}</td>
                                                <td>{{ $data->first() ? $data->first()->reservation ? $data->first()->reservation->checkin_code : null : null}}</td>
                                                <td>{{ $data->first() ? $data->first()->reservation ? $data->first()->reservation->get_agent_info->name_eng  : null: null}}</td>

                                                <td>  {{ $received - $discount}}</td>
                                                <td> {{ $refund }}</td>
                                                {{-- <td>
                                            <input type="checkbox" id="vehicle1" name="vehicle1" value="Bike">
                                        </td> --}}
                                            </tr>
                                        @endforeach
                                        <thead>
                                            <tr>
                                                
                                                <th colspan="6" class="text-end">{{ __('obs.total_balance') }}:
                                                    &nbsp;{{ $balance }}</th>
                                                <th>
                                                    {{ $total_received }}
                                                    <input type="hidden" name="" class="form-control text-end"
                                                        value="{{ $user_collection_details->collapse()->sum('amount') }}">
                                                </th>
                                                <th>{{ $total_refund }}</th>

                                        </thead>
                                    @endif
                                </tbody>
                            </table>

                        </div>

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

    </div>
    @endsection


    @section('script')
    <script type="text/javascript" src="{{ asset('inventory/blade_js/common.js') }}"></script>

        <script>
            $(document).ready(function() {
              
             
            });

         
        </script>
    @endsection