@extends('layouts.'.env('THEME'))

@section('moreStyle')
    @include('staff.schedule.style')
@endsection

@section('content')

<div class="container mb-5" id="main-container">

    <x-section_heading title="Billing report" subtitle="" rowclass="mt-5"/>

    <div class="row my-3" style="text-align: center;">
        @foreach($info_count as $key => $tc)
        <div class="col-3">
            <span style="font-size: 1.1rem;">{{ $key }}<br />
            <span>{{ $tc }}</span>
        </div>
        @endforeach
        <div class="col-3">
            <span style="font-size: 1.1rem;">Est over due<br />
            <span id="over_due_est"></span>
        </div>
    </div>

    @php
        $hide_toggels[] = [
            'title' => 'Hide active billing',
            'name' => 'billing_active',
            'id' => 'hide_ab',
            'for' => 'btncheck1',
        ];
        $hide_toggels[] = [
            'title' => 'Hide installed but offline',
            'name' => 'installed_offline',
            'id' => 'hide_io',
            'for' => 'btncheck6',
        ];
        $hide_toggels[] = [
            'title' => 'Hide canceled vouchers',
            'name' => 'voucher_canceled',
            'id' => 'hide_cv',
            'for' => 'btncheck7',
        ];
        $hide_toggels[] = [
            'title' => 'Hide in trial',
            'name' => 'trialing',
            'id' => 'hide_t',
            'for' => 'btncheck5',
        ];
        $hide_toggels[] = [
            'title' => 'Hide billing exempt',
            'name' => 'billing_exempt',
            'id' => 'hide_be',
            'for' => 'btncheck2',
        ];
        $hide_toggels[] = [
            'title' => 'Hide service canceled',
            'name' => 'service_ended',
            'id' => 'hide_se',
            'for' => 'btncheck3',
        ];
        $hide_toggels[] = [
            'title' => 'Hide subscriptions',
            'name' => 'lead_subs',
            'id' => 'hide_ls',
            'for' => 'btncheck4',
        ];
    @endphp

    @foreach($hide_toggels as $toggel)
    <div class="row">
        <div class="col-12">
            <label class="btn btn-outline-primary" for="{{ $toggel['for'] }}">
                <input type="checkbox" class="btn-check hideToggle" id="{{ $toggel['id'] }}"
                    name="{{ $toggel['name'] }}" value="1" autocomplete="off"
                    @if(!isset($_GET[$toggel['name']]))
                    checked="true"
                    @endif
                    >
                {{ $toggel['title'] }}
            </label>
        </div>
    </div>
    @endforeach

    <table class="table-lines mb-3">
        <tr>
            <th>UPRN</th>
            <th>ID</th>
            <th>Name</th>
            <th>Stripe ID</th>
            <th>Billing state</th>
            <th>Install state</th>
            <th>Install date</th>
            <th>Last paid inv</th>
            <th>Months installed</th>
            <th>Est over due</th>
            <th>Est total service fee</th>
        </tr>

    @foreach($results as $uprn => $uprn_results)
        @foreach($uprn_results as $r)
            @php
                $uprn_style = '';
                if(sizeof($uprn_results) > 1) $uprn_style = 'style="background-color: #4FC3F7;"';

                $display_classes = '';
                if($r['lead']->billing_state() == 1){
                    $display_classes .= 'billing_active ';
                }
                if($r['lead']->install_state == 3){
                    $display_classes .= 'installed_offline ';
                }
                if($r['lead']->voucher_state == 7){
                    $display_classes .= 'voucher_canceled ';
                }
                if(!empty($r['lead']->activeSubscription())
                    && $r['lead']->activeSubscription()->state() == 7){
                    $display_classes .= 'trialing ';
                }
                if($r['lead']->billingExempt()){
                    $display_classes .= 'billing_exempt ';
                }
                if(!empty($r['lead']->service_end_date)){
                    $display_classes .= 'service_ended ';
                }
            @endphp
        <tr class="{{ $display_classes }}">
            <td {{ $uprn_style }}>
                {{ $uprn }}
            </td>
            <td>
                <a href="/customer/{{ $r['lead']->id }}" target="blank">
                    <strong>{{ $r['lead']->id }}</strong>
                </a>
            </td>
            <td>
                <a href="/customer/{{ $r['lead']->id }}" target="blank">
                    <strong>{{ $r['lead']->fullname ?? ''}}</strong>
                </a>
            </td>
            <td>
                <a href="https://dashboard.stripe.com/customers/{{ $r['lead']->stripe_id }}" target="blank">
                    {{ $r['lead']->stripe_id }}
                </a>
            </td>
            <td>
                @if($r['lead']->billing_state() == 1)
                    <span class="badge badge-success">
                        Active
                    </span>
                @else
                    {{ $r['lead']->billing_state_text() }}<br />
                    {{ $r['lead']->billing_exempt }}<br />
                    @if(!empty($r['lead']->exempt_expire_date))
                        {{ $r['lead']->exempt_expire_date }}
                    @endif
                @endif
            </td>
            <td>
                @php
                    $badge = 'warning';
                    if($r['lead']->install_state == 2){
                        $badge = 'success';
                    }else if($r['lead']->install_state == 3){
                        $badge = 'info';
                    }
                @endphp
                <span class="badge badge-{{ $badge }}">
                    {{ config('enum.install_states')[$r['lead']->install_state] }}
                </span>
            </td>
            <td>
                @if(!empty($r['lead']->install_date))
                    {{ $r['lead']->install_date->format('d-m-Y')  }}
                @endif
            </td>
            <td>
                @php
                    if($r['lead']->billing_state() == 1){
                        echo('Up to date');
                    }else{
                        $last_paid = $r['lead']->getLastPaidInvoice();
                        if(!empty($last_paid)){
                            echo( \Carbon\Carbon::parse($last_paid->period_end)->format('d-m-Y')
                                .'<br />
                                <span style="0.7rem">'.\Carbon\Carbon::parse($last_paid->period_end)->diffInMonths(\Carbon\Carbon::now()).' months ago</span>
                                <br />
                                <a style="font-size: 0.6rem;" href="https://dashboard.stripe.com/invoices/'.$last_paid->id.'" target="blank">
                                    '.$last_paid->id.'
                                </a>'
                            );
                        }
                    }
                @endphp
            </td>
            <td>
                @if(!empty($r['lead']->install_date))
                    {{ $r['lead']->install_date->diffInMonths(\Carbon\Carbon::now()) }}
                @endif
            </td>
            <td class="over_due_est">
                {{ number_format((float)$r['over_due_est'], 2, '.', '') }}
            </td>
            <td>
                &pound;{{ number_format((float)$r['lead']->estimatedServicFeeTotal(), 2, '.', '') }}
            </td>
        </tr>
            @foreach($r['lead']->subscriptions as $sub)
                <tr class="{{ $display_classes }} lead_subs" style="background-color: #E1BEE7;">
                    <td></td>
                    <td>
                        Subscription
                        @if(!empty($sub->stripe_id))
                        <a style="font-size: 0.6rem" href="https://dashboard.stripe.com/subscriptions/{!! $sub->stripe_id !!}">
                            {!! $sub->stripe_id !!}
                        </a>
                        @endif
                    </td>
                    <td colspan="2">
                        {!! \Carbon\Carbon::parse($sub->start)->format('d-m-Y') !!}
                        to
                        {!! \Carbon\Carbon::parse($sub->end)->format('d-m-Y') !!}
                    </td>
                    <td>
                        @if(!empty($sub->discount_amount))
                            Discount:
                            &pound;{!! $sub->discount_amount !!}
                            @if(!empty($sub->discount_months))
                                for {!! $sub->discount_months !!} months
                            @endif
                        @else
                            No discount
                        @endif
                    </td>
                    <td>
                        {!! $sub->stateLong() !!}
                    </td>
                    <td>
                        @if(!empty($sub->getStripeSub()->ended_at))
                            <div style="#FF7043">
                            Payments ended:
                            &pound;{!! $sub->overDueCost() !!} overdue
                            </div>
                        @endif
                    </td>
                </tr>
            @endforeach
        @endforeach
    @endforeach
    </table>

    <h4>Stripe customers not matched to local customer</h4>
    <table class="table-lines mb-3">
        <tr>
            <th>Stripe ID</th>
            <th>Stripe UUID</th>
            <th>Name</th>
            <th>Email</th>
        </tr>
        @foreach($stripe_customers_not_local as $sc)
            <tr>
                <td>
                    <a href="https://dashboard.stripe.com/subscriptions/{{ $sc['stripe_customer']->id }}" target="blank">
                        {{ $sc['stripe_customer']->id }}
                    </a>
                </td>
                <td>
                    @if(!empty($sc['stripe_customer']->metadata->uuid))
                    <a href="/customer/{{ $sc['stripe_customer']->metadata->uuid }}" target="blank">
                        {{ $sc['stripe_customer']->metadata->uuid }}
                    </a>
                    @endif
                </td>
                <td>{{ $sc['stripe_customer']->name }}</td>
                <td>{{ $sc['stripe_customer']->email }}</td>
            </tr>
        @endforeach
    </table>

    <h4>Stripe subscriptions not matched to local subscription</h4>
    <table class="table-lines mb-3">
        <tr>
            <th>Subscription ID</th>
            <th>Customer ID</th>
            <th>Name</th>
            <th>Email</th>
        </tr>
        @foreach($stripe_subs_not_local_no_lead as $sr)
            <tr>
                <td>
                    <a href="https://dashboard.stripe.com/subscriptions/{{ $sr['stripe_sub']->id }}" target="blank">
                        {{ $sr['stripe_sub']->id }}
                    </a>
                </td>
                <td>
                    <a href="https://dashboard.stripe.com/customers/{{ $sr['stripe_customer']->id }}" target="blank">
                        {{ $sr['stripe_customer']->id }}
                    </a>
                </td>
                <td>{{ $sr['stripe_customer']->name }}</td>
                <td>{{ $sr['stripe_customer']->email }}</td>
            </tr>
        @endforeach
    </table>
</div>

@endsection

@section('script')
<script>
$(document).ready(function() {
    $('body').on('click', '.hideToggle', function() {
        var str = '.' + $(this).attr("name");
        hide_toggle(str);
        calculateOverDueEst();
    });

    @foreach($hide_toggels as $toggel)
        hide_toggle('.{{ $toggel['name'] }}');
    @endforeach
    calculateOverDueEst();
});

function hide_toggle(class_str){
    var toggleClass = $(class_str);
    if(toggleClass.is(":visible")){
        toggleClass.hide();
    }else{
        toggleClass.show();
    }
}

function calculateOverDueEst(){
    var total = 0;
    var count = 0;
    $('.over_due_est').each((index, element) => {
        if($(element).parent().is(":visible")){
            count++;
            total = total + parseFloat($(element).text());
        }
    });
    $('#over_due_est').html(total);
}


</script>
@endsection