@extends('admin.layout.master')
@section('custom_style')
    <style>
        .labels {
            font-size: 16px;
            font-weight: bold;
        }

        input {
            padding: 18px !important;
            box-shadow: none !important;
        }

    input[type=text],
    input[type=file],
    input[type=date],
    input[type=number] {
        height: 35px !important;
    }
    button[type=button] {
        height: 35px !important;
    }
    .select2-container .select2-selection--single{
        height: 35px !important;
    }

</style>
@endsection

@section('content')
    @include('flash-message')
    <div class="col-12">
        @if ($errors->any())
            <div class="alert alert-danger" id="hide-alert">
                <ul>
                    @foreach ($errors->all() as $error)
                        <li>{{ $error }}</li>
                    @endforeach
                </ul>
            </div>
        @endif
    </div>

    <div class="card ">
        <div class="card-header d-flex justify-content-between align-items-center text-white bg-dark">
            <div>
                <h5 class="font-weight-bold mb-0">Night Audit User Amount Handover 
                </h5>
            </div>
            <div>
            </div>
        </div>
        <div class="card-body">
            <div class="col-md-8 offset-2">
                {{ Form::open(['route' => ['frontdesk.receipt.user.amount.transfer'], 'method' => 'post', 'class' => 'form-horizontal', 'enctype' => 'multipart/form-data']) }}

                <div class="card">
                    <div class="card-header text-center text-white bg-secondary ">
                        <h4 class="font-weight-bold mb-0">Cash Collections</h4>

                    </div>
                    <div class="card-body">
                        <div class="table-responsive" id="">
                           
                            <table class="table table-bordered table-hover" id="">
                                <thead>
                                    <tr>
                                        <th>SL</th>
                                        <th>Payment Method</th>
                                        <th>Received</th>
                                        <th>Collection</th>
                                        <th>Total</th>
                                    </tr>
                                </thead>
                                @php
                                    $total_c=0;
                                    $total_h=0;
                                @endphp
                                @forelse (getCashBank()->where('type','<>',2) as $k=>$payment)
                                    <tbody>
                                        @php
                                                $collections = $collection_group_by_ledger->where('ledger_id',$payment->account_id);                                              
                                                $refundMoneyReffernce =$refund_collection  ? $refund_collection->pluck('reff_no')->toArray() : [];
                                                $from_refund = $collections->whereIn('fd_invoice_id',$refundMoneyReffernce);
                                                
                                                if(count($from_refund) >0){                          
                                                    $refund_amount = $refund_collection->whereIn('reff_no',$from_refund->pluck('fd_invoice_id'))->sum('amount');
                                                }else{
                                                    $refund_amount = 0;  
                                                }
                                                $c_amount=$collection_group_by_ledger->where('ledger_id',$payment->account_id)->sum('amount') - $refund_amount;

                                               
                                                $h_amount=$handover_group_by_ledger->where('ledger_id',$payment->account_id)->sum('amount');
                                                $total_c+=($c_amount);
                                                $total_h+=($h_amount);
                                                $total_cash_amount = $h_amount + $c_amount;
                                            @endphp
                                            @if($total_cash_amount > 0)
                                            <tr>
                                                <td>{{$k+1}}</td>
                                                <td>{{$payment->name_eng}}({{$payment->account_id}})</td>
                                                
                                                {{-- <td class="text-right">{{implode(",", $ids)}}</td> --}}
                                                <td class="text-right">{{$h_amount}}</td>
                                                <td class="text-right">{{$c_amount}}</td>
                                                <td class="text-right">
                                                <input type="number" name="amount[{{$payment->account_id}}]" class="form-control text-right" value="{{$total_cash_amount}}" readonly>
                                                </td>
                                            </tr>
                                            @endif
                                    </tbody>
                                @empty
                                    
                                @endforelse
                                
                                <tbody>
                                    <tr>
                                        <th class="text-right" colspan="2">Total</th>
                                        <th class="text-right">{{$total_h}}</th>
                                        <th class="text-right">{{$total_c}}</th>
                                        <th class="text-right">
                                          <input type="number" name="" id="total_amount" class="form-control text-right" value="{{$total_c+$total_h}}" readonly>
                                        </th>
                                    </tr>
                                   
                                </tbody>

                                <thead class="mt-3">
                                    <tr>
                                        <th colspan="2" style="vertical-align: middle"> Hand Over To  User</th>
                                        <th colspan="3">
                                            <div class="form-group col-md-12">
                                                {{-- @dd($users->first()->cashier) --}}
                                                <select id="" name="user_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>
                                                @error('user_id')
                                                    <span class="help-block text-center text-danger">
                                                        <strong>{{ $message }}</strong>
                                                    </span>
                                                @enderror
                                            </div>
                                        </th>
                                    <tr>
                                        <tr>
                                            <th colspan="5" style="vertical-align: middle">
                                            <div class="form-group col-md-12">
                                                {{ Form::textarea('note', null, ['class' => 'form-control', 'id' => 'note', 'rows' => 1, 'placeholder' => 'Remarks']) }}

                                                @error('note')
                                                    <span class="help-block text-center text-danger">
                                                        <strong>{{ $message }}</strong>
                                                    </span>
                                                @enderror
                                            </div>
                                        </th>
                                    </tr>
                                </thead>
                            </table>
                        </div>
                    </div>

                    <div class="form-group col-12 text-center">
                        <button id="submit_button" type="submit" class="btn btn-info"> <i class="fa fa-save mr-1"></i>
                            Handover To User </button>
                    </div>

                    {{ Form::close() }}
                    <div class="form-group col-12 text-center">
                        <button id="expand_details" type="button" class="btn btn-warning"> <i class="fa fa-save mr-1"></i> Details</button>
                    </div>
                </div>
            </div>

            <div class="card" id="collection_detail_div" style="display: none" >
                <div class="card-header text-center text-white bg-primary ">
                    <h4 class="font-weight-bold text-center m-0">Collection Details</h4>
                </div>
                {{ Form::open(['route' => ['frontdesk.receipt.user.amount.transfer'], 'method' => 'post', 'class' => 'form-horizontal', 'enctype' => 'multipart/form-data']) }}

                <div class="card-body ">
                    <div class="d-flex flex-wrap">
                        <div class="table-responsive" id="print">
                            <table class="table table-bordered table-hover text-center"  id="datatable_apply">
                                <thead class="mt-3">
                                    <tr>
                                        <th>#SL</th>
                                        <th>Reservation No</th>
                                        <th>Checkin No</th>
                                        <th>Party Name</th>
                                        <th>Received</th>
                                        <th>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);
                                     @endphp
                                    <tr>
                                        <td>{{ $i++}}</td>
                                        <td>{{ $data->first()->reservation->resv_code }}</td>
                                        <td>{{ $data->first()->reservation->checkin_code }}</td>
                                        <td>{{ $data->first()->reservation->get_agent_info->name_eng }}</td>

                                        <td> {{$received}}</td>
                                        <td> {{$refund}}</td>
                                        {{-- <td>
                                            <input type="checkbox" id="vehicle1" name="vehicle1" value="Bike">
                                        </td> --}}
                                     </tr>
                                    @endforeach
                                    <thead>
                                        <tr>
                                            @php
                                                $total_received = $user_collection_details->collapse()->sum('amount');
                                                $total_refund = $user_collection_details->collapse()->where('voucher_type',5)->sum('amount');
                                                $balance = $total_received - $total_refund;
                                            @endphp
                                            <th colspan="4" class="text-right">Total Balance: &nbsp;{{ $balance}}</th>
                                            <th>
                                                {{$total_received}}
                                                <input type="hidden" name="" class="form-control text-right" value="{{$user_collection_details->collapse()->sum('amount')}}">
                                            </th>
                                            <th >{{$total_refund}}</th>
                                        
                                    </thead>

                                
                              @endif
                                </tbody>
                            </table>
                            
                        </div>
        
                    </div>
                </div>
                {{ Form::close() }}
            </div>

           
            <div class="card-body">
                <div class="col-md-8 offset-2">
                    {{ Form::open(['route' => ['frontdesk.receipt.user.transfer_to_accounts'], 'method' => 'post', 'class' => 'form-horizontal', 'enctype' => 'multipart/form-data']) }}
    
                    <div class="card">
                        <div class="card-header text-center text-white bg-secondary ">
                            <h4 class="font-weight-bold mb-0">Bank Received</h4>
    
                        </div>
                        <div class="card-body">
                            <div class="table-responsive" id="">
                                <table class="table table-bordered table-hover" id="">
                                    <thead>
                                        <tr>
                                            <th>SL</th>
                                            <th>Payment Method</th>
                                            <th>Received</th>
                                            <th>Total</th>
                                        </tr>
                                    </thead>
                                    @php
                                        $total_c=0;
                                        $total_h=0;
                                    @endphp
                                    @forelse (getCashBank()->where('type',2) as $k=>$payment)
                                        <tbody>
                                            <tr>
                                                <td>{{$k+1}}</td>
                                                <td>{{$payment->name_eng}}({{$payment->account_id}})</td>
                                                @php
                                                    $collections = $bank_collection_group_by_ledger->where('ledger_id',$payment->account_id);                                              
                                                    
                                                    $c_amount=$bank_collection_group_by_ledger->where('ledger_id',$payment->account_id)->sum('amount');
                                                   
                                                    $total_c+=($c_amount);
                                                @endphp
                                                {{-- <td class="text-right">{{implode(",", $ids)}}</td> --}}
                                                <td class="text-right">{{$c_amount}}</td>
                                                <td class="text-right">
                                                <input type="number" name="amount[{{$payment->account_id}}]" class="form-control text-right" value="{{$c_amount}}" readonly>
                                                </td>
                                            </tr>
                                        </tbody>
                                    @empty
                                        
                                    @endforelse
                                    
                                    <tbody>
                                        <tr>
                                            <th class="text-right" colspan="2">Total</th>
                                            <th class="text-right">{{$total_c}}</th>
                                            <th class="text-right">
                                              <input type="number" name="total_amount" id="total_amount" class="form-control text-right" value="{{$total_c+$total_h}}" readonly>
                                            </th>
                                        </tr>
                                       
                                    </tbody>
    
                                </table>
                            </div>
                        </div>
    
                        <div class="form-group col-12 text-center">
                            <button id="submit_button" type="submit" class="btn btn-info"> <i class="fa fa-save mr-1"></i>
                                Transfer To Accounts </button>
                        </div>
                        {{ Form::close() }}
    
                    </div>
                </div>


        </div>
    </div>

    <div class="card">
        <div class="card-header text-center text-white bg-secondary ">
            <h4 class="font-weight-bold mb-0">Send Request List Of Date: {{ date('d-m-Y') /*carbon()->parse()->format('d-m-Y')*/ }}</h4>

        </div>
        <div class="card-body">
            <div class="table-responsive" id="">
                <table class="table table-bordered table-hover text-center" id="">
                    <thead class="mt-3">
                        <tr>
                            <th>Sender	</th>
                            <th>Amount</th>
                            <th>Date</th>
                            <th>Action</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach ($handover_list as $invoice=>$request_list )
                        
                        @php 
                         
                         $reff = App\Models\Frontdesk\FdInvoiceDetails::where('fd_invoice_id',$invoice);
                         $data = $reff->pluck('id')->toArray();
                        //  $refund = App\Models\Frontdesk\FdInvoiceDetails::whereIn('reference_id',$data)->where('voucher_type',5)->where('type',0)->sum('amount');
                        
                         $senderName = $reff ->where('type',1)->first();
                      
                        @endphp
                        <tr>
                            <td>
                                @if($request_list->first()->type ==1)
                               
                                @else
                                {{user_name($request_list->first()->created_by)}}
                                @endif
                                
                            </td>
                            <td>{{$request_list->sum('amount')}}</td>
                            <td>{{ date('d-m-Y h:m:i A', strtotime($request_list->first()->date)) /*carbon()->parse($request_list->first()->date)->format("d-m-Y h:m:i A") */}}</td>
                            <td>
                                <a style="padding: 8px; font-size:13px"  target="_blank" href="{{route('frontdesk.cashier.handover_details',[$invoice])}}" class="badge badge-primary">Details</a>   ||                        

                                @if($request_list->first()->type ==1)
                                <a style="padding: 8px; font-size:13px"  href="#" class="badge badge-warning">Pending</a>   ||                        

                                @else
                                <a style="padding: 8px; font-size:13px" onclick="return updateConfirmation('Are You Sure to Accept This');" href="{{route('frontdesk.receipt.accept_hanover',$invoice)}}" class="badge badge-warning">{{$request_list->first()->status == 2 ? "Accept" :null }}</a>                  
                                @endif
                                {{-- <a style="padding: 8px; font-size:13px" onclick="return updateConfirmation('Are You Sure to Reject This');" href="{{route('frontdesk.receipt.reject_hanover',$invoice)}}" class="badge badge-danger">{{"Reject"}}</a>                            --}}

                            </td>
                           
                        </tr>
                        @endforeach
                      
                    </tbody>
                </table>
            </div>
        </div>
    </div>
@endsection


@section('script')
    <script>

    $( document ).ready(function() {
        $('#expand_details').click(function() {
              $('#collection_detail_div').toggle(1000);
        });

      var total_amount  = $("#total_amount").val();
      if(total_amount <= 0){
        $("#submit_button").hide();
      }
    });
    
    function updateConfirmation(msg) {
            if(!confirm(msg))
            event.preventDefault();
        }

    </script>
@endsection