@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=radio] {
        transform: scale(1.7);
    }
    input[type=number],
    input[type=file],
    select,.select2-selection--single {
        height: 38px !important;
        box-shadow: none !important;
    }

    .sm-pd-t th {
        padding: 0.5rem;

    }

    .sm-pd-t td {
        padding: 0.1rem;
        padding-right: 0.35rem;
        padding-left: 0.35rem;
    } */


    </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 sina-card">
        <div class="card-header d-flex justify-content-between align-items-center"> 
            <h5 class="font-weight-bold mb-0">{{__('obs.advance_voucher')}}</h5> 
            <a href="{{route('frontdesk.advance_voucher.create')}}" class="btn btn-sm btn-light">{{__('obs.add_advance_voucher')}}</a>
         </div>
        <div class="card-body" style="">
            @if (count($errors) > 0)
                <div class="alert alert-danger">
                    <ul>
                        @foreach ($errors->all() as $error)
                            <li>{{ $error }}</li>
                        @endforeach
                    </ul>
                </div>
            @endif
            <form action="{{ route('frontdesk.advance_voucher') }}" method="get" class="form-horizontal">

            <div class='row'>
                <div class='col-md-3'>
                    <div class="form-group">
                        <h6 class="">{{__('obs.camelcase_customer')}} {{__('obs.list')}}</h6>
                        <select id="party_id" name="party_id" class="form-control fd_agent_search">
                            @if(request()->party_id !=null)
                            <option value="{{request()->party_id}}">
                                {{\App\Models\Parties::find(request()->party_id)->name_eng}}
                            </option>
                            @endif
                        </select>
                    </div>
                </div>

                <div class='col-md-2'>
                    <div class="form-group">
                        <h5 class="">{{__('obs.invoice')}} {{__('obs.no')}}</h5>
                        <select id="invoice_no" name="invoice_no" class="form-control fd_invoice_no_search">
                        </select>
                       {{-- <input type="text" name="invoice_no" class="form-control fd_invoice_no_search" id="invoice_no"> --}}
                    </div>
                </div>
                <div class='col-md-2'>
                    <div class="form-group">
                        <h6 class="">{{__('obs.from')}}</h6>
                        <input type="text" value="{{ request()->start_date ? date('d-m-Y', strtotime(request()->start_date)) : date('d-m-Y') }}" class="form-control date_picker" id="start_date" name="start_date">
                    </div>
                </div>
                <div class='col-md-2'>
                    <div class="form-group">
                        <h6 class="">{{__('obs.to')}}</h6>
                        <input type="text" value="{{ request()->end_date ? date('d-m-Y', strtotime(request()->end_date)) : date('d-m-Y') }}" class="form-control date_picker" id="end_date" name="end_date" required>
                    </div>
                </div>
                <div class='col-md-3 '>
                    <div class="form-group">
                        <label class="w-100">&nbsp;</label>
                        <button style="" name="search_button" class='btn btn-md btn-primary'>{{__('obs.search')}}</button>

                        {{-- <button style="margin-top:5px" class='btn btn-sm btn-danger'>Search</button> --}}

                    </div>
                </div>

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

    </div>


    <div class="card ">

        <div class="card-body">

            <h4 class="font-weight-bold text-center">{{__('obs.advance_voucher')}}</h4>

            <div class="">
                <div class="table-responsive" id="print" style="max-height:500px;">
                    <table class="cl-table table table-bordered table-hover"  id="">
                        <thead class="mt-3">
                            <tr>
                                <th>{{__('obs.sl')}}</th>
                                <th>{{__('obs.invoice')}}</th>
                                <th>{{__('obs.agent')}}</th>
                                <th>{{__('obs.hotel')}}</th>
                                <th>{{__('obs.reservation_no')}}</th>
                                <th>{{__('obs.date')}}</th>
                                <th>{{__('obs.method')}}</th>
                                <th>{{__('obs.amount')}}</th>
                                <th>{{__('obs.refund')}}</th>
                                <th>{{__('obs.adjusted_amount')}}</th>
                                <th>{{__('obs.remaining_amount')}}</th>
                                <th>{{__('obs.by')}}</th>
                                <th>{{__('obs.action')}}</th>

                            </tr>
                        </thead>
                        <tbody>
                            @if (!empty($advance_vouchers))
                            @php $i =1 @endphp
                                @foreach ($advance_vouchers as $advance_voucher)
                                @php

                             
                                $advance_history = resevationHistory_multi_warehouse(null,null,$advance_voucher->fd_invoice_id,null);
                                $advance_refund = $advance_history['advance_refund'];
                                $advance_deduct = $advance_history['advance_deduct'];
                                $advance_refund_amount = $advance_refund->sum('amount');
                                $advance_adjust_amount = $advance_deduct->where('warehouse_id',current_store())->sum('amount');
                                $after_refund_advance =  $advance_voucher->amount -  $advance_refund_amount;
                                // $advance_deduct = resevationHistory(null,null,$advance_voucher->fd_invoice_id)['advance_deduct'];
                              
                              
                                $remaining_amount =  $after_refund_advance - $advance_adjust_amount;

                                @endphp
                                @if($advance_voucher->amount > 0)
                             
                                <tr>
                                    <td>{{$i++}}</td>

                                    <td>{{$advance_voucher->fd_invoice->invoice_no}}</td>
                                    <td>{{$advance_voucher->get_agent_info->name_eng}}</td>
                                    <td>{{$advance_voucher->warehouse_info->name_eng}}</td>
                                    
                                   
                                    <td>{{$advance_voucher->reservation ? ($advance_voucher->reservation->resv_code  ? $advance_voucher->reservation->resv_code : $advance_voucher->reservation->checkin_code) : null }}</td>
                                    <td>{{$advance_voucher->created_at ? $advance_voucher->created_at->format("d-m-Y") : null}}</td>
                                    <td>{{cash_bank_name($advance_voucher->child_invoice->where('type',0)->first()->ledger_id)}}</td>
                                    <td>{{ $advance_voucher->amount }}</td>
                                    <td>{{ $advance_refund->sum('amount') }}</td>
                                    <td>{{$advance_adjust_amount}}</td>
                                    <td>{{ $remaining_amount}}</td>
                                    <td>{{$advance_voucher->user->name}}</td>
                                    <td>
                                        <a href="{{route('frontdesk.advance_voucher.edit', $advance_voucher->fd_invoice_id)}}"
                                            class='btn  btn-sm'><i class="fas fa-edit"></i></a>

                                       
                                        <a href="{{route('frontdesk.report.advance_print',['invoice'=>$advance_voucher->id])}}" class="btn btn-sm btn-primary"><i class="fa fa-print" aria-hidden="true"></i></a>
                                        {{-- <a href="{{route('frontdesk.report.receipt_print',['invoice'=>$advance_voucher->fd_invoice_id])}}" class="btn btn-sm btn-warning"><i class="fa fa-print" aria-hidden="true"></i></a> --}}
                                        
                                        @if($advance_adjust_amount > 0)
                                        <a href="{{route('frontdesk.receipt.advance_adjust_details',$advance_voucher->fd_invoice_id)}}" target="_blank" class="btn btn-sm btn-info" title="Adjust Details"><i class="fa fa-eye" aria-hidden="true"></i></a>
                                        @endif
                                       
                                    </td>
                                </tr>
                                @endif
                                @endforeach
                            @endif
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
@endsection

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

    <script>
   $(document).ready(function() {
        $('#datatable_apply').dataTable({
            // "paging": false,
            // "ordering": false,
            // dom: 'Bfrtip',
            // buttons: [
            //     'print', 'excel'
            // ]


        });
    });
    </script>
@endsection