@extends('layouts.master')

@section('title', 'Customer Aging Details')

@section('content')

    <style>
        .ledger_caption {
            text-align: center;
            background: rgb(145, 159, 182);
            color: #ffffff;
            padding: 8px;
            font-weight: bold;
        }
    </style>
    <div class="content-header">
        <div class="container-fluid">
            <div class="row mb-2">
                <div class="col-sm-6">
                    <h1 class="m-0">Customer Aging Details</h1>
                </div>
                <div class="col-sm-6">
                    <ol class="breadcrumb float-sm-right">
                        <li class="breadcrumb-item"><a href="customer-aging-report">Customer Aging Report</a></li>
                        <li class="breadcrumb-item active">Customer Aging Details</li>
                    </ol>
                </div>
            </div>
        </div>
    </div>


    <div class="content">
        <div class="container-fluid">

            <div class="row">
                <div class="col-lg-12">

                    <div class="row mt-2">
                        <div class="col-lg-3">
                            <label>Date</label>
                            <input type="date" class="form-control" id="caging_date" name="caging_date">
                        </div>
                        <div class="col-lg-3">
                            <label>Ledger</label>
                            <select class="select2 form-control" id="customer" name="customer"
                                onchange="getCaging()">
                                <option value="-1">All Customers</option>
                                @foreach ($customer as $value)
                                    <option value="{{ $value->id }}">
                                        {{ $value->first_name . '-' . $value->last_name }}</option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-lg-3">
                            <label>&nbsp;</label><br>
                            <input type="button" value="Search" class="btn btn-info" onclick="getCaging()">
                            <div class="btn-group">
                                <button type="button" class="btn btn-info">Export To </button>
                                <button type="button" class="btn btn-info dropdown-toggle dropdown-icon" data-toggle="dropdown">
                                    <span class="sr-only">Toggle Dropdown</span>
                                </button>
                                <div class="dropdown-menu" role="menu">
                                    <a class="dropdown-item" href="#" onclick="exportExcel()">Excel</a>
                                </div>
                            </div>
                        </div>
                    </div>
                    <br>

                </div>
            </div>


                <div class="row">
                    <hr>
                    <div class="col-lg-12">
                        <div class="card card-primary card-outline card-outline-tabs">
                            <table class="table table-striped">
                                <tr>
                                    <th>Sales.Inv</th>
                                    <th style="text-align: right">Inv.Amt({{ $currencyCode }})</th>
                                    <th style="text-align: right">Rtn.Amt({{ $currencyCode }})</th>
                                    <th style="text-align: right">Paid.Amt({{ $currencyCode }})</th>
                                    <th style="text-align: right">Bal.Amt({{ $currencyCode }})</th>
                                    <th style="text-align: right">Current({{ $currencyCode }})</th>
                                    <th style="text-align: right">0-30</th>
                                    <th style="text-align: right">31-60</th>
                                    <th style="text-align: right">61-90</th>
                                    <th style="text-align: right">91-120</th>
                                    <th style="text-align: right">121-150</th>
                                    <th style="text-align: right">150+</th>
                                </tr>

                                @php

                                    $sum_net_total = 0;
                                    $sum_sales_return_amount = 0;
                                    $sum_paidamont = 0;
                                    $sum_due_amount = 0;
                                    $sum_val1 = 0;
                                    $sum_val2 = 0;
                                    $sum_val3 = 0;
                                    $sum_val4 = 0;
                                    $sum_val5 = 0;
                                    $sum_val6 = 0;
                                    $sum_val7 = 0;

                                @endphp

                                @foreach ($customerAginDet as $value)
                                    <!-- if($value->due_amount != 0) -->
                                        <tr>
                                        <td>{{$value->sales_invoice_no}}</td>
                                        <td style="text-align: right">{{number_format($value->net_total,2,'.',',')}}</td>
                                        <td style="text-align: right">{{number_format($value->sales_return_amount,2,'.',',')}}</td>
                                        <td style="text-align: right">{{number_format($value->paidamont,2,'.',',')}}</td>
                                        <td style="text-align: right">{{number_format($value->due_amount,2,'.',',')}}</td>
                                        <td style="text-align: right">{{number_format($value->val1,2,'.',',')}}</td>
                                        <td style="text-align: right">{{number_format($value->val2,2,'.',',')}}</td>
                                        <td style="text-align: right">{{number_format($value->val3,2,'.',',')}}</td>
                                        <td style="text-align: right">{{number_format($value->val4,2,'.',',')}}</td>
                                        <td style="text-align: right">{{number_format($value->val5,2,'.',',')}}</td>
                                        <td style="text-align: right">{{number_format($value->val6,2,'.',',')}}</td>
                                        <td style="text-align: right">{{number_format($value->val7,2,'.',',')}}</td>
                                        </tr>
                                    <!-- endif -->
                                    @php

                                        $sum_net_total += $value->net_total;
                                        $sum_sales_return_amount += $value->sales_return_amount;
                                        $sum_paidamont += $value->paidamont;
                                        $sum_due_amount += $value->due_amount;
                                        $sum_val1 += $value->val1;
                                        $sum_val2 += $value->val2;
                                        $sum_val3 += $value->val3;
                                        $sum_val4 += $value->val4;
                                        $sum_val5 += $value->val5;
                                        $sum_val6 += $value->val6;
                                        $sum_val7 += $value->val7;

                                    @endphp
                                @endforeach

                                <tr>
                                    <td></td>
                                    <td style="text-align: right"><b>{{ number_format($sum_net_total, 2, '.', ',') }}</b></td>
                                    <td style="text-align: right"><b>{{ number_format($sum_sales_return_amount, 2, '.', ',') }}</b></td>
                                    <td style="text-align: right"><b>{{ number_format($sum_paidamont, 2, '.', ',') }}</b></td>
                                    <td style="text-align: right"><b>{{ number_format($sum_due_amount, 2, '.', ',') }}</b></td>
                                    <td style="text-align: right"><b>{{ number_format($sum_val1, 2, '.', ',') }}</b></td>
                                    <td style="text-align: right"><b>{{ number_format($sum_val2, 2, '.', ',') }}</b></td>
                                    <td style="text-align: right"><b>{{ number_format($sum_val3, 2, '.', ',') }}</b></td>
                                    <td style="text-align: right"><b>{{ number_format($sum_val4, 2, '.', ',') }}</b></td>
                                    <td style="text-align: right"><b>{{ number_format($sum_val5, 2, '.', ',') }}</b></td>
                                    <td style="text-align: right"><b>{{ number_format($sum_val6, 2, '.', ',') }}</b></td>
                                    <td style="text-align: right"><b>{{ number_format($sum_val7, 2, '.', ',') }}</b></td>
                                </tr>
                            </table>
                        </div>
                    </div>
                </div>
                <br /><br />
        </div>
    </div>
    <script>
        function getCaging() {
            var csrf_token = $('meta[name="csrf-token"]').attr('content');
            var date = $("#caging_date").val();
            var customer = $("#customer").val();
            $.ajax({
                type: 'get',
                url: '{{ url('/customer-aging-detail-report-by-date') }}',
                data: {
                    _token: csrf_token,
                    date: date,
                    customer: customer
                },
                async: true,
                success: function(data) {
                    document.open();
                    document.write(data);
                    document.close();
                    $("#caging_date").val(date);
                    $("#customer").val(customer);
                },
                error: function(data) {
                    swlToster('error', "Something went wrong");
                }
            });
        }

        function exportExcel()
        {
            var query = {
                date: $('#caging_date').val(),
                customer: $('#customer').val()
            }
            var url = "{{URL::to('/export-excel-customer-aging-details-report')}}?" + $.param(query)
            window.location = url;
        }

    </script>
@endsection