@extends('admin.layout.master')
@section('title', 'Agent Advance List')
@section('custom_style')
<style>
    /* .labels {
        font-size: 16px;
        font-weight: bold;
    }

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

    input[type=checkbox] {
        transform: scale(1.2);
    }

    input[type=text],
    input[type=number],
    input[type=file],
    .select2-selection--single {
        height: 38px !important;
        box-shadow: none !important;
    } */

</style>
@endsection

@section('content')
@include('flash-message')
<div class="card">
    <div class="card-header d-flex justify-content-between align-items-center ">
        <h5 class="font-weight-bold mb-0">{{__('obs.agent_advance_list')}}</h5>
        <div class="col-6 d-flex justify-content-end">

        </div>
    </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.receipt.agent_advance_list') }}" method="get" class="form-horizontal" enctype="multipart/form-data">

        <div class='row'>
            <div class='col-md-3'>
                <div class="form-group">
                    <label class="">{{__('obs.customer')}}</label>
                    <select id="party_id" name="party_id" class="form-control fd_agent_search">

                    </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">
                    <label>{{ __('obs.from') }}</label>
                    <input type="text" name="start_date" id="start_date" class="form-control date_picker" value="{{ request()->start_date ? date('d-m-Y', strtotime(request()->start_date)) : date('d-m-Y') }}">
                </div>
            </div>
            <div class='col-md-2'>
                <div class="form-group">
                    <label>{{ __('obs.to') }}</label>
                    <input type="text" name="end_date" id="end_date" class="form-control date_picker" value="{{ request()->end_date ? date('d-m-Y', strtotime(request()->end_date)) : date('d-m-Y') }}">
                </div>
            </div>
            

            <div class='col-md-2' style="">
                <div class="form-group">
                    <label class="w-100">&nbsp;</label>
                    <button style="" name="search_button" class='btn btn-md btn-primary'>{{__('obs.search')}}</button>
                </div>
            </div>
        </div>
        </form>
    </div>
</div>

@if ($agent_advance_lists)
    @if (count($agent_advance_lists) > 0)
        <div class="card ">

            <div class="card-body">

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

                    <div class="">
                        <div class="table-responsive" id="print">
                            <table class="table table-bordered table-hover" id="datatable_apply">
                                <thead class="mt-3">
                                    <tr>
                                        <th>{{__('obs.sl')}}</th>
                                        <th>{{__('obs.agent')}}</th>
                                        <th>{{__('obs.received_by')}}</th>
                                        <th>{{__('obs.voucher_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.details')}}</th>
                                    </tr>
                                </thead>
                                <tbody>
                                        @php 
                                            $i = 1;
                                            $total_amount = 0;
                                            $total_refund = 0;
                                            $total_advance_adjusted = 0;
                                            $total_remaining_amount= 0;
                                        @endphp

                                        @foreach ($agent_advance_lists as $list)
                                        {{-- @dd(resevationHistory(null,null,$list->id)['advance_deduct']->sum('amount')) --}}
                                        @php
                                            $advance_history = resevationHistory_multi_warehouse(null,null,$list->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->sum('amount');
                                            $after_refund_advance =  $list->amount -  $advance_refund_amount;
                                            $remaining_amount =  $after_refund_advance - $advance_adjust_amount;

                                         
                                            $total_amount += $list->amount;
                                            $total_refund += $advance_refund_amount;
                                            $total_advance_adjusted += $advance_adjust_amount;
                                            $total_remaining_amount +=  $remaining_amount;
                                       @endphp
                                            <tr>
                                                <td> {{$i++}}</td>
                                                <td>{{party_name($list->party_id)}}</td>
                                                <td>{{user_name($list->created_by)}}</td>
                                                <td>{{$list->fd_invoice->invoice_no}}</td>
                                                <td>{{$list->date}}</td>
                                                <td>{{cash_bank_name($list->ledger_id)}}</td>
                                                <td class="text-end">{{$list->amount}}</td>
                                                <td class="text-end">{{$advance_refund_amount}}</td>
                                                <td class="text-end">{{$advance_adjust_amount}}</td>
                                                <td class="text-end">{{$remaining_amount}}</td>

                                                <td>
                                                    <a href="{{route('frontdesk.report.advance_print',['invoice'=>$list->id])}}" class="btn btn-sm btn-primary" target="_blank"><i class="fa fa-print" aria-hidden="true"></i></a>
                                                    <a href="{{route('frontdesk.receipt.print_receipt_details',['invoice'=>$list->fd_invoice->invoice_no])}}" class="btn btn-sm btn-warning" target="_blank" title="Partial Details"><i class="fa fa-list" aria-hidden="true"></i></a>
                                    

                                                    @if($advance_adjust_amount > 0)
                                                    <a href="{{route('frontdesk.receipt.advance_adjust_details',$list->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>
                                        @endforeach
                                        <tr>
                                            <td class="text-center" colspan="6"><b>{{__('obs.total')}}</b></td>
                                            <td class="text-end"><b>{{$total_amount}}</b></td>
                                            <td class="text-end"><b>{{$total_refund}}</b></td>
                                            <td class="text-end"><b>{{$total_advance_adjusted}}</b></td>
                                            <td class="text-end"><b>{{$total_remaining_amount}}</b></td>
                                            <td></td>
                                        </tr>

                                </tbody>
                            </table>
                        </div> 
                    </div>
            </div>
        </div>
    @else
        <h4 class=" text-center">{{__('obs.no_data')}}</h4>
    @endif
@endif


@endsection


@section('script')

<script>
    $('.select2').select2();
    partySearch('customer', 2);
</script>
@endsection