@extends('admin.layout.master')
@section('content')

    <style>
        select {
            box-shadow: inset -1px 4px 10px 0px rgb(212 212 212);
            height: 28px !important;
            font-size: 14px !important;
        }
    </style>

    <div class="row" style="">
        <div class="col-12">
            <div class="card sina-card">
                <div class="card-header">
                    <h4>CheckIn Wise User Collection Report</h4>
                </div>
                <div class="card-body">
                    <div class="row justify-content-center">
                        <div class="col-12">
                            <form action="{{route('frontdesk.cashier.check_in_wise_user_collection_report')}}" method="get">
                                <div class="row">
                                    <div class="col-4">
                                        <div class="form-group">
                                            <label for="">Select Holtel</label>
                                            <select id="" name="ware_id" class="form-control select2" placeholder="Select" required>
                                                <option class="" value="">Select Hotel</option>
                                              
                                                @foreach ($warehouses as $hotel)
                                                    <option value="{{ $hotel->id }}" class="">
                                                        {{ $hotel->name_eng }}
                                                    </option>
                                              
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-4">
                                        <div class="form-group">
                                            <label for="">User</label>
                                            <select id="" name="cashier_id" class="form-control select2" placeholder="Select" required>
                                                <option class="" value="">Select User</option>
                                              
                                                @foreach ($users as $user)
                                                    <option value="{{ $user->id }}" class="">
                                                        {{ $user->name }}
                                                    </option>
                                              
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>

                                    <div class="col-3 text-center mt-3">
                                        <button type="submit" class="btn btn-info btn-sm">Search</button>
                                    </div>
                                </div>
                            </form>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>


    <div class="card ">
        <div class="card-body">
            <h4 class="font-weight-bold text-center">User Collection Details - ({{$user_name}})</h4>
               
            <div class="d-flex flex-wrap">
                <div class="table-responsive" id="print">
                    <table class="table table-bordered table-hover"  id="datatable_apply">
                        <thead class="mt-3">
                            <tr>
                                <th>#SL</th>
                                <th>Reservation No</th>
                                <th>Checkin No</th>
                                <th>Checkin Date</th>
                                <th>Total Bill</th>
                                <th>Pre. Received</th>
                                <th>User Received</th>
                                <th>Refund</th>
                                {{-- <th>Dues</th> --}}
                            </tr>
                        </thead>
                        <tbody>
                            @php
                                $i=1;
                            @endphp
                            @if (!empty($user_collections))
                                @foreach ($user_collections as $data)
                                    <tr>
                                        <td>{{ $i++}}</td>
                                        <td>{{ $data['resv_code'] }}</td>
                                        <td>{{ $data['checkin_code'] }}</td>
                                        <td>{{ $data['check_in_date'] }}</td>
                                        <td>{{ $data['bill_after_discount'] }}</td>
                                        <td>{{ $data['previous_received'] }}</td>
                                        <td>{{ $data['user_received'] }}</td>
                                        <td>{{ $data['refund'] }}</td>
                                        {{-- <td>{{ $data['dues'] }}</td> --}}
                                    </tr>
                                @endforeach
                                <tr>
                                    <td colspan="4">Total</td>
                                    <td >{{$user_collections->sum('bill_after_discount')}}</td>
                                    
                                    <td >{{$user_collections->sum('previous_received')}}</td>
                                    <td >{{$user_collections->sum('user_received')}}</td>
                                    <td >{{$user_collections->sum('refund')}}</td>
                                    {{-- <td >{{$user_collections->sum('dues')}}</td> --}}
                                </tr>
                            @endif
                        </tbody>
                    </table>
                </div>

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

@endsection