@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_Summary')</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_summary_sum')
            </p>
            <p class="col-lg-2  text-center text-dark font-size-20" id="ToalClientsBalance">$1200</p>
        </div>
    </div>
</div>


            <!-- Filter Card -->

            <form action="{{ route('dashboard.reports.client.customer_indebtness_duration_summary') }}">
            <div class="row">
                <div class="col-12">
                    <div class="card">
                        <div class="card-body">
                            <h4 class="card-title mb-4">@lang('reports.filter') </h4>
                                <div class="mt-2">
                                    <label class="control-label">@lang('reports.Choose_a_customer')</label>
                                    
                                    <select name="client" id="" class="select2" style="width: 200px">
                                        <option selected disabled value="{{ null }}">@lang('reports.Choose_a_customer')</option>
                                        @foreach ($clientSelect as $client)
                                        
                                        <option value="{{ $client->id }}" @if(request()->get('client') == $client->id) selected @endif>{{ $client->name }}</option>
                                        @endforeach    
                                        
                                    </select>
                                </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>
                </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_Summary')</h4>
                            <p class="card-title-desc mb-2">@lang('reports.customer_indebtness_by_duration_summary')</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_Name')</th>
                                        <th data-priority="1">@lang('reports.Current')</th>
                                        <th data-priority="1">1:30</th>
                                        <th data-priority="1">31:40</th>
                                        <th data-priority="1">41:50</th>
                                        <th data-priority="1">51:60</th>
                                        <th data-priority="1">61:70</th>
                                        <th data-priority="1">71:80</th>
                                        <th data-priority="1">81:90</th>
                                        <th data-priority="1">@lang('reports.91_and_above')</th>
                                    </tr>
                                </thead>
                                @php 
                                    $totalClientBalance = 0;
                                @endphp
                                <tbody>
                                    @foreach ($clients as $client)
                                    @php 
                                    $currentTotal = 0;
                                    $first_to_thirtytTotal = 0;
                                    $thirty_to_fourthTotal = 0;
                                    $fourth_to_fifthTotal = 0;
                                    $fifth_to_sixthTotal = 0;
                                    $sixth_to_seventhTotal = 0;
                                    $eighth_to_ninthTotal = 0;
                                    $seventh_to_eighthTotal = 0;
                                    $ninth_to_aboveTotal = 0;
                                    
                                    
                                    
                                    @endphp
                                    <tr>
                                        <td>
                                                
                                            <button class="btn btn-info" style="min-width: 100px" type="button" data-toggle="collapse" data-target="#subAccounts{{ $client->id }}" aria-expanded="false" aria-controls="collapseExample">
                                                {{ $client->name }} <!-- Client Name Main Account -->
                                            </button>
                                            
                                            <div class="collapse mt-3 ml-4" style="width: 100px" id="subAccounts{{ $client->id }}">
                                                <div class="d-flex flex-column">
                                                    @foreach ($client->branches as $branch)
                                                    <p class="ml-2" style="display: inline-block;width: 100%;white-space: nowrap;overflow: hidden !important;text-overflow: ellipsis;">
                                                        {{ $branch->name }} <!-- Client sub account 1 -->
                                                    </p>
                                                    
                                                    @endforeach
                                                    <p class="ml-2" style="display: inline-block;width: 100%;white-space: nowrap;overflow: hidden !important;text-overflow: ellipsis;">
                                                        <b>@lang('reports.Total')</b> <!-- Main Account Total -->
                                                    </p>
                                                </div>
                                            </div>
                                        </td>
                                        <td>
                                            <p style="height: 40px" class="btn mb-0" type="button">
                                                {{ $client->balance }}
                                                @php $currentTotal += $client->balance; 
                                                $totalClientBalance += $client->balance;
                                                @endphp
                                            </p>
                                            <div class="collapse mt-3" style="width: 100px" id="subAccounts{{ $client->id }}">
                                                <div class="d-flex flex-column">
                                                    @foreach ($client->branches as $branch)
                                                    <p class="ml-2" style="display: inline-block;width: 100%;white-space: nowrap;overflow: hidden !important;text-overflow: ellipsis;">
                                                        {{ $branch->balance }} <!-- Client sub account 1 -->
                                                        @php $currentTotal += $branch->balance;
                                                        $totalClientBalance += $branch->balance;
                                                        
                                                        @endphp
                                                    </p>
                                                    
                                                    @endforeach
                                                    <p class="ml-3">
                                                       <b>${{ $currentTotal }}</b>
                                                    </p>
                                                </div>
                                          </div>
                                        </td>
                                        <td>
                                            <p style="height: 40px" class="btn mb-0" type="button">
                                                ${{ $client->first_to_thirty }}
                                                @php $first_to_thirtytTotal += $client->first_to_thirty; @endphp

                                            </p>
                                            <div class="collapse mt-3" style="width: 100px" id="subAccounts{{ $client->id }}">
                                                <div class="d-flex flex-column">
                                                    @foreach ($client->branches as $branch)
                                                        
                                                    <p class="ml-3">
                                                        ${{ $branch->first_to_thirty }} <!-- sub account 1 sub total -->
                                                        @php $first_to_thirtytTotal += $branch->first_to_thirty; @endphp
                                                    </p>
                                                    @endforeach
                                                    
                                                    <p class="ml-3">
                                                       <b>${{ $first_to_thirtytTotal }}</b>
                                                    </p>
                                                </div>
                                          </div>
                                        </td>
                                        <td>
                                            <p style="height: 40px" class="btn mb-0" type="button">
                                                ${{ $client->thirty_to_fourth }}
                                                @php $thirty_to_fourthTotal += $client->thirty_to_fourth; @endphp

                                            </p>
                                            <div class="collapse mt-3" style="width: 100px" id="subAccounts{{ $client->id }}">
                                                <div class="d-flex flex-column">
                                                    @foreach ($client->branches as $branch)
                                                        
                                                    <p class="ml-3">
                                                        ${{ $branch->thirty_to_fourth }} <!-- sub account 1 sub total -->
                                                        @php $thirty_to_fourthTotal += $branch->thirty_to_fourth; @endphp
                                                    </p>
                                                    @endforeach
                                                    
                                                    <p class="ml-3">
                                                       <b>${{ $thirty_to_fourthTotal }}</b>
                                                    </p>
                                                </div>
                                          </div>
                                        </td>
                                        <td>
                                            <p style="height: 40px" class="btn mb-0" type="button">
                                                ${{ $client->fourth_to_fifth }}
                                                @php $fourth_to_fifthTotal += $client->fourth_to_fifth; @endphp

                                            </p>
                                            <div class="collapse mt-3" style="width: 100px" id="subAccounts{{ $client->id }}">
                                                <div class="d-flex flex-column">
                                                    @foreach ($client->branches as $branch)
                                                        
                                                    <p class="ml-3">
                                                        ${{ $branch->fourth_to_fifth }} <!-- sub account 1 sub total -->
                                                        @php $fourth_to_fifthTotal += $branch->fourth_to_fifth; @endphp
                                                    </p>
                                                    @endforeach
                                                    
                                                    <p class="ml-3">
                                                       <b>${{ $fourth_to_fifthTotal }}</b>
                                                    </p>
                                                </div>
                                          </div>
                                        </td>
                                        <td>
                                            <p style="height: 40px" class="btn mb-0" type="button">
                                                ${{ $client->fifth_to_sixth }}
                                                @php $fifth_to_sixthTotal += $client->fifth_to_sixth; @endphp

                                            </p>
                                            <div class="collapse mt-3" style="width: 100px" id="subAccounts{{ $client->id }}">
                                                <div class="d-flex flex-column">
                                                    @foreach ($client->branches as $branch)
                                                        
                                                    <p class="ml-3">
                                                        ${{ $branch->fifth_to_sixth }} <!-- sub account 1 sub total -->
                                                        @php $fifth_to_sixthTotal += $branch->fifth_to_sixth; @endphp
                                                    </p>
                                                    @endforeach
                                                    
                                                    <p class="ml-3">
                                                       <b>${{ $fifth_to_sixthTotal }}</b>
                                                    </p>
                                                </div>
                                          </div>
                                        </td>
                                        <td>
                                            <p style="height: 40px" class="btn mb-0" type="button">
                                                ${{ $client->seventh_to_eighth }}
                                                @php $seventh_to_eighthTotal += $client->seventh_to_eighth; @endphp

                                            </p>
                                            <div class="collapse mt-3" style="width: 100px" id="subAccounts{{ $client->id }}">
                                                <div class="d-flex flex-column">
                                                    @foreach ($client->branches as $branch)
                                                        
                                                    <p class="ml-3">
                                                        ${{ $branch->seventh_to_eighth }} <!-- sub account 1 sub total -->
                                                        @php $seventh_to_eighthTotal += $branch->seventh_to_eighth; @endphp
                                                    </p>
                                                    @endforeach
                                                    
                                                    <p class="ml-3">
                                                       <b>${{ $seventh_to_eighthTotal }}</b>
                                                    </p>
                                                </div>
                                          </div>
                                        </td>
                                        <td>
                                            <p style="height: 40px" class="btn mb-0" type="button">
                                                ${{ $client->seventh_to_eighth }}
                                                @php $seventh_to_eighthTotal += $client->seventh_to_eighth; @endphp

                                            </p>
                                            <div class="collapse mt-3" style="width: 100px" id="subAccounts{{ $client->id }}">
                                                <div class="d-flex flex-column">
                                                    @foreach ($client->branches as $branch)
                                                        
                                                    <p class="ml-3">
                                                        ${{ $branch->seventh_to_eighth }} <!-- sub account 1 sub  -->
                                                        @php $seventh_to_eighthTotal += $branch->seventh_to_eighth; @endphp
                                                    </p>
                                                    @endforeach
                                                    
                                                    <p class="ml-3">
                                                       <b>${{ $seventh_to_eighthTotal }}</b>
                                                    </p>
                                                </div>
                                          </div>
                                        </td>
                                        <td>
                                            <p style="height: 40px" class="btn mb-0" type="button">
                                                ${{ $client->eighth_to_ninth }}
                                                @php $eighth_to_ninthTotal += $client->eighth_to_ninth; @endphp

                                            </p>
                                            <div class="collapse mt-3" style="width: 100px" id="subAccounts{{ $client->id }}">
                                                <div class="d-flex flex-column">
                                                    @foreach ($client->branches as $branch)
                                                        
                                                    <p class="ml-3">
                                                        ${{ $branch->eighth_to_ninth }} <!-- sub account 1 sub  -->
                                                        @php $eighth_to_ninthTotal += $branch->eighth_to_ninth; @endphp
                                                    </p>
                                                    @endforeach
                                                    
                                                    <p class="ml-3">
                                                       <b>${{ $eighth_to_ninthTotal }}</b>
                                                    </p>
                                                </div>
                                          </div>
                                        </td>
                                        <td>
                                            <p style="height: 40px" class="btn mb-0" type="button">
                                                ${{ $client->ninth_to_above }}
                                                @php $ninth_to_aboveTotal += $client->ninth_to_above; @endphp

                                            </p>
                                            <div class="collapse mt-3" style="width: 100px" id="subAccounts{{ $client->id }}">
                                                <div class="d-flex flex-column">
                                                    @foreach ($client->branches as $branch)
                                                        
                                                    <p class="ml-3">
                                                        ${{ $branch->ninth_to_above }} <!-- sub account 1 sub  -->
                                                        @php $ninth_to_aboveTotal += $branch->ninth_to_above; @endphp
                                                    </p>
                                                    @endforeach
                                                    
                                                    <p class="ml-3">
                                                       <b>${{ $ninth_to_aboveTotal }}</b>
                                                    </p>
                                                </div>
                                          </div>
                                        </td>

                                    </tr>
                                    @endforeach

                                    
                                    
                                </tbody>
                                
                            </table>
                            <input type="hidden" value="{{ $totalClientBalance }}" name="total_clients_balance" id="TotalCalculatedBalance">
                        </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_summary') }}" 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>

                        <input type="hidden" name="client" value="{{ request()->get('client') }}">
                        <input type="hidden" name="total" value="{{ $totalClientBalance }}">
                        <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>

                        <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>

$('#ToalClientsBalance').html('$'+$('#TotalCalculatedBalance').val());
        </script>
@endsection