@extends('dashboard.components.main')
@section('content')
<!-- ============================================================== -->
<!-- Start right Content here -->
<!-- ============================================================== -->
<div class="main-content">
<div class="page-content">
<!-- start page title -->
<div class="row">
<div class="col-12">
<div class="page-title-box d-flex align-items-center justify-content-between">
<h4 class="page-title mb-0 font-size-18">@lang('reports.Customer_Indebtness_by_Duration_Detail')</h4>

<div class="page-title-right">
    <ol class="breadcrumb m-0">
        <li class="breadcrumb-item active"> @lang('dashboard_clients.welcome_platform')</li>
    </ol>
</div>
</div>
</div>
</div>
<!-- end page title -->
<!-- Totals Card -->
<div class="card">
    <div class="card-body">
        <div class="row">
            <p class="text-uppercase font-weight-bold col-lg-4 font-size-18">
                @lang('reports.customer_indebt_detail_sum')</p>
            <p class="col-lg-2  text-center text-dark font-size-20" id="totalBalanceDue">$1200</p>
        </div>
    </div>
</div>

<!-- Filter card-->
<form action="{{ route('dashboard.reports.client.customer_indebtness_duration_detail') }}" method="GET">
    
    <div class="card">
        <div class="card-body">
           <h4 class="card-title mb-4">@lang('reports.filter') </h4>
            <div class="row">



                <div class="col-lg-3">
                    <div class="form-group">
                    
                        <label class="control-label">@lang('reports.Choose_a_customer')</label>

                        <select name="client" id="" class="select2" style="width: 100%">
                            <option selected value="{{ null }}">@lang('dashboard_invoices.all_clients')</option>
                            @foreach ($selectClients as $client)
                                
                            <option value="{{ $client->id }}" @if(request()->get('client') == $client->id) selected @endif>{{ $client->name }}</option>
                            @endforeach
                            
                        </select>
                        
                    </div>
                </div>

                <div class="col-lg-3">
                    <div class="form-group">
                    
                        <label class="control-label">@lang('reports.Choose_a_Duration')</label>
                        <select  name="duration" id="" class="select2 mx-2" style="width: 100%">
                            <option selected disabled value="{{ null }}">@lang('reports.Choose_a_Duration')</option>
                            <option value="0,30" @if(request()->get('duration') == '0,30') selected @endif>1:30</option>
                            <option value="31,40" @if(request()->get('duration') == '31,40') selected @endif>31:40</option>
                            <option value="41,50" @if(request()->get('duration') == '41,50') selected @endif>41:50</option>
                            <option value="51,60" @if(request()->get('duration') == '51,60') selected @endif>51:60</option>
                            <option value="61,70" @if(request()->get('duration') == '61,70') selected @endif>61:70</option>
                            <option value="71,80"@if(request()->get('duration') == '71,80') selected @endif >71:80</option>
                            <option value="81,90"@if(request()->get('duration') == '81,90') selected @endif>81:90</option>
                            <option value="91,100000000000000000"@if(request()->get('duration') == '91,100000000000000000') selected @endif>@lang('reports.91_and_above')</option>
                        </select>
                        
                    </div>
                </div>
                <div class="col-lg-12">
                    <div class="text-right">
                        <button type="submit" class="btn btn-primary">@lang('reports.excute')</button>
                    </div>
                </div>
            </div>
        </div>
    </div>

</form>


<div class="row">
<div class="col-12">
<div class="card">
<div class="card-body">

    {{-- <h4 class="card-title">@lang('reports.Customer_Indebtness_by_Duration_Detail')</h4>
    <p class="card-title-desc mb-2">@lang('reports.customer_indebtness_by_duration_detail')</p>


    <p class="text-center font-size-16" style="width: 100%">
        @lang('reports.as_of_date') <b class="">2020-12-04</b>
    </p> --}}

    <table id="datatable-buttons" class="table table-striped table-bordered dt-responsive nowrap"
        style="border-collapse: collapse; border-spacing: 0; width: 100%;">
        <thead>
            <tr>
                <th data-priority="1">@lang('reports.Customer')</th>
                <th data-priority="1">@lang('reports.Date')</th>
                <th data-priority="1">@lang('reports.Transaction_Type')</th>
                <th data-priority="1">@lang('reports.reports_No')</th>
                <th data-priority="1">@lang('reports.Due_Date')</th>
                <th data-priority="1">@lang('reports.Amount')</th>
                <th data-priority="1">@lang('dashboard_sales_expenses.total_before_tax')</th>
                <th data-priority="1">@lang('dashboard_taxes.tax')</th>

            </tr>
        </thead>
        <tbody>
            @php
             $totalBalanceDue = 0;   
            @endphp
            @foreach ($clients as $client)
                @foreach ($client->accounts as $account)
                    
                <tr>
                    <td>
                        <a href="{{ route('dashboard.clients.show',$client) }}">
                            {{ $client->name }}
                        </a>
                    
                </td>
                    <td>{{ $account->invoice_date ?? $account->notice_date }}</td>
                    <td>{{ str_replace('_',' ',$account->movement_type) }}</td>
                    <td>
                        <a href="{{ route('dashboard.invoices.show.products',[$account->id,$account->movement_type]) }}">
                            {{ $account->number }}
                        </a>
                    </td>
                    <td>{{ @optional($account)->due_date ?? null }}</td>
                    <td>{{ $account->invoice_total ?? $account->notice_total }}</td>
                    <td>{{ $account->balance_before_tax ?? $account->balance_before_tax }}</td>
                    <td>{{ $account->taxes_total ?? $account->taxes_total }}</td>
                    @php
                    $totalBalanceDue += $client->total;   
                   @endphp
                </tr>
                @endforeach
            @endforeach
        </tbody>

    </table>
    <input type="hidden" id="totalCalculatedBalanceDue" name="balanceDue" value="{{ $totalBalanceDue }}">
</div>
</div>
</div>
<!-- end col -->
</div>
<!-- end row -->


<div class="row">
<div class="col-lg-12">
<div class="card">
<div class="card-body">
    <div class="d-flex flex-row justify-content-center">
        <button class="btn btn-success mx-2" onclick="printReportPage()">@lang('reports.Preview_and_Print')</button>
        <a class="btn btn-success mx-2 popup-form" href="#sendReport">@lang('reports.Email')</a>
    </div>
</div>
</div>
</div>

<!-- Send popup -->

<div class="card mfp-hide mfp-popup-form mx-auto" style="max-width: 700px" id="sendReport">
<div class="card-body">
<h4 class="mt-0 mb-2">@lang('reports.Send_report')</h4>
<p class="card-title-desc">@lang('reports.Send_a_report_to_a_prefered_email')</p>

<form action="{{ route('dashboard.reports.client.customer_indebtness_duration_detail') }}" method="GET">
<div class="row d-flex flex-row align-items-center ml-4 my-2 justify-content-center">
    <h5 class="control-label col-lg-2">@lang('reports.To')</h5>
    <input required type="text" placeholder="@lang('reports.enter_email')" name="to" class="form-control col-lg-8">
</div>

<div class="row d-flex flex-row align-items-center ml-4 my-2 justify-content-center">
    <h5 class="control-label col-lg-2">@lang('reports.CC')</h5>
    <input type="text" placeholder="@lang('reports.enter_email')" name="cc" class="form-control col-lg-8">
</div>

<div class="row d-flex flex-row align-items-center ml-4 my-2 justify-content-center">
    <h5 class="control-label col-lg-2">@lang('reports.Subject')</h5>
    <input required type="text" placeholder="@lang('reports.enter_subject')" name="subject" class="form-control col-lg-8">
</div>

<div class="row d-flex flex-row align-items-center ml-4 my-2 justify-content-center">
    <h5 class="control-label col-lg-2">@lang('reports.Body')</h5>
    <textarea class="form-control col-lg-8" name="body" cols="30" rows="3" style="resize: none"></textarea>
</div>
<input type="hidden" name="total" value="{{ $totalBalanceDue }}">
<input type="hidden" name="duration" value="{{ request()->get('duration') }}">
<input type="hidden" name="client" value="{{ request()->get('client') }}">

<div class="row">
    <div class="col-lg-12  my-2 d-flex justify-content-end">
        <div class="text-right">
            <button type="submit"
                class="btn btn-success"> @lang('reports.Send')</button>
        </div>
    </div>
</div>
</form>
</div>
</div>
</div>

</div>
@endsection

@section('custom_script')
    <script>
$('#totalBalanceDue').html('$'+$('#totalCalculatedBalanceDue').val());

        </script>
@endsection