@extends('admin.layouts.app')

@section('title', 'Reporting')

@section('content_header')
    <h1>Reporting</h1>
@stop

@section('content')
    @component('components.card', ['title' => 'Snooker Reporting'])
    <form method="POST" action="{{ route('admin.reporting.customer') }}">
        @csrf
        <div class="align-items-end row">
            <div class="col-md-2">
                <label>Select Year</label>
                <select id="month_selector" class="form-control" name="year">
                    @foreach ($years as $year)
                    <option value="{{ $year }}" {{ (isset($y) && $year == (int)$y) ? 'selected' : '' }}>{{ $year }}</option>
                    @endforeach
                </select>
            </div>
            <div class="col-md-2">
                <label>Select Month</label>
                <select id="month_selector" class="form-control" name="month">
                    @foreach ($months as $name => $mth_num)
                    <option value="{{ $mth_num }}" {{ (isset($m) && $mth_num == (int)$m) ? 'selected' : '' }}>{{ $name }}</option>
                    @endforeach
                </select>
            </div>
            <div class="col-md-3">
                <label>Select Customer</label>
                <select id="month_selector" class="form-control select2" name="customer_id">
                    <option value="">---All---</option>
                    @foreach ($customers as $customer)
                    <option value="{{ $customer->id }}" {{ (isset($c) && $customer->id == $c) ? 'selected' : '' }}>{{ $customer->name }}</option>
                    @endforeach
                </select>
            </div>
            <div class="col-md-2">
                <button type="submit" class="btn btn-primary mt-4">Filter</button>
            </div>
        </div>
    </form>

    <div>
        <canvas id="attendance_chart"></canvas>
    </div>

    <div class="d-flex justify-content-around my-4">
        <div class="card">
            <div class="card-body" id="tot_prev_cr_amount">
            </div>
          </div>
        <div class="card">
            <div class="card-body" id="tot_cr_paid">
            </div>
          </div>
        <div class="card">
            <div class="card-body" id="tot_new_cr">
            </div>
          </div>
        <div class="card">
            <div class="card-body" id="tot_remaining_cr">
            </div>
          </div>
    </div>

    <table class="table datatable">
        <h5 class="text-center my-3">Cr. Customer(s) of Month({{ $mth_name }})</h5>
        <thead>
            <tr>
                <th width="5%">Sn</th>
                <th width="15%">Customer</th>
                <th width="20%">Previous Cr. Amount</th>
                <th width="15%">Previous Cr. Amount Paid</th>
                <th width="20%">Todays Cr. Amount</th>
                <th width="25%">Remaining Cr. Amount</th>
            </tr>
        </thead>
        <tbody>
            @php
                $is_record_empty = true;
                $remaining_credit_amount = $tot_prev_cr_amount = $tot_dr_paid = $tot_new_cr_amount = 0;
            @endphp
            @foreach ($_customers as $k => $customer)
                @if ($customer->balances->isNotEmpty() && $customer->created_at->lte(now()->parse($y . '-' . $m . '-01')->endOfMonth()))
                    @php
                        $is_record_empty = false;
                    @endphp
                    <tr>
                        <td>{{ ++$k }}</td>
                        <td>{{ $customer->name }}</td>
                        @php
                                // public const PAYMENT_TYPE_NOT_INITIATED = 0;
                                // public const PAYMENT_TYPE_CASH = 1;
                                // public const PAYMENT_TYPE_CREDIT = 2;
                            $customer_balances = $customer->balances;
                            $customer_transactions = $customer->transactions;
                            $day_before_today_customer_balance = $customer_balances->where('created_at', '<', now()->today())->where('type',App\Models\CustomerBalance::TYPE_CREDIT)->first()?->balance ?? 0; //amt to be paid
                            $day_before_today_balance_cleared = $customer_balances->where('created_at', '<', now()->today())->where('type',App\Models\CustomerBalance::TYPE_DEBIT)->sum('amount');

                            $todays_balances = $customer_balances->whereBetween('created_at', [now()->startOfDay(), now()->endOfDay()]);
                            $today_balances_credit = $todays_balances->where('type', App\Models\CustomerBalance::TYPE_CREDIT)->sum('amount');

                            $todays_discount = $customer_transactions->where('payment_type', 2)->whereBetween('created_at', [now()->startOfDay(), now()->endOfDay()])->sum('discount');
                            $todays_transaction = empty($todays_discount) ? $today_balances_credit : "$today_balances_credit (discount(Nrs $todays_discount))";

                            $today_balances_cleared = $todays_balances->where('type', App\Models\CustomerBalance::TYPE_DEBIT)->sum('amount');

                        @endphp
                        <td>Nrs {{ $day_before_today_customer_balance }}</td>
                        <td>Nrs {{ $day_before_today_balance_cleared }}</td>
                        <td>Nrs {{ $todays_transaction }}</td>
                        <td>Nrs {{ $customer_balances->first()->balance }}</td>
                    </tr>

                    @php
                        /* $customer_balances = $customer_balances->first();
                        $dr_amount_paid = $new_cr_amount = 0;
                        if(empty($customer_balances)){
                            $prev_cr_amount = 0;

                        }elseif ($customer_balances->type == 2) {
                            $prev_cr_amount = $customer_balances->amount + $customer_balances->balance;
                            $dr_amount_paid = $customer_balances->amount;
                        }elseif($customer_balances->type == 1){
                            $prev_cr_amount = $customer_balances->amount + $customer_balances->balance;
                            $new_cr_amount = $customer_balances->amount;
                        } */
                        $tot_prev_cr_amount += $customer_balances->first()->balance;
                        $tot_dr_paid += $customer_balances->where('type',2)->sum('amount');
                        $tot_new_cr_amount += $today_balances_credit;
                    @endphp
                @endif
            @endforeach
            @if ($is_record_empty)
                <tr>
                    <td colspan="6" class="text-center">No Customer Found</td>
                </tr>
            @endif
        </tbody>
{{--         <caption>
            <div>
                Total Credit Remaining : <span>Nrs {{ $remaining_credit_amount }}</span>
            </div>
        </caption> --}}
    </table>
    @endcomponent
@stop

@section('css')

@stop

@section('js')
<script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
<script>
    $(() => {

        const ctx = document.getElementById('attendance_chart');

        const tot_prev_cr_amount = document.getElementById('tot_prev_cr_amount');
        const tot_cr_paid = document.getElementById('tot_cr_paid');
        const tot_new_cr = document.getElementById('tot_new_cr');
        const tot_remaining_cr = document.getElementById('tot_remaining_cr');

        tot_prev_cr_amount.innerHTML = 'Total Cr. : Nrs {{ $tot_prev_cr_amount }}';
        tot_cr_paid.innerHTML = 'Total Dr. Paid : Nrs {{ $tot_dr_paid }}';
        tot_new_cr.innerHTML = 'Total new Cr. : Nrs {{ $tot_new_cr_amount }}';
        tot_remaining_cr.innerHTML = 'Total remaining : Nrs {{ $tot_prev_cr_amount - $tot_dr_paid }}';

        const label = ['{{ $mth_name }}'];
        const y_max = parseInt('{{ $customers->count() }}')
        // const y_max = 100;

        const new_customers = '{{ $new_customers }}';
        const cr_customers_Y_m = '{{ $cr_customers_Y_m }}';

        const dataset = [
            {"label":"New Customers","data":[new_customers],"borderColor":"#abebc6","backgroundColor":"#abebc6"},
            {"label":"Total Cr. Customers","data":[cr_customers_Y_m],"borderColor":"#f5b7b1","backgroundColor":"#f5b7b1"},
        ];
        const workTrendsChart = new Chart(ctx, {
          type: 'bar',
          data: {
            labels: label,
            datasets: dataset
          },
          options: {
            responsive: true,
            maintainAspectRatio: false,
            scales: {
              y: {
                beginAtZero: true,
                max:y_max
              }
            },
            plugins: {
              legend: {
                position: 'top'
              },
              tooltip: {
                mode: 'index',
                intersect: false
              }
            }
          }
        });
        var table = $('.datatable').DataTable();
    });

</script>
@stop