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

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


@endsection

@section('content')
<style>
    .wide-input {
        width: 300px;
    }
</style>

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

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

    {!! Form::open(['route' => 'admin.billing_reportv2', 'method' => 'get']) !!}
    <div class="row my-3">
        <div class="col-12">
            From: {!! Form::datetimeLocal('from', $from, ['id' => 'from_input']) !!}
            To: {!! Form::datetimeLocal('to', $to, ['id' => 'to_input']) !!}
        </div>
    </div>
    <div class="row my-3" style="text-align: center;">
        <div class="col-12">
            Types (comma separated): {!! Form::text('types', implode(',', $types), ['id' => 'types_input', 'class' => 'wide-input']) !!}
            <div class="more-details">
                adjustment, advance, advance_funding, anticipation_repayment, application_fee, application_fee_refund, charge, climate_order_purchase, climate_order_refund, connect_collection_transfer, contribution, issuing_authorization_hold, issuing_authorization_release, issuing_dispute, issuing_transaction, obligation_outbound, obligation_reversal_inbound, payment, payment_failure_refund, payment_network_reserve_hold, payment_network_reserve_release, payment_refund, payment_reversal, payment_unreconciled, payout, payout_cancel, payout_failure, payout_minimum_balance_hold, payout_minimum_balance_release, refund, refund_failure, reserve_transaction, reserved_funds, stripe_fee, stripe_fx_fee, stripe_balance_payment_debit, stripe_balance_payment_debit_reversal, tax_fee, topup, topup_reversal, transfer, transfer_cancel, transfer_failure, or transfer_refund
            </div>
            <span class="see-more">
                <strong>available types</strong> <i class="fa fa-chevron-down" aria-hidden="true"></i>
            </span>
        </div>
    </div>
    <div class="row my-3" style="text-align: center;">
        <div class="col-12">
            States (comma separated): {!! Form::text('types', implode(',', $states), ['id' => 'states_input', 'class' => 'wide-input']) !!}
            <div class="more-details">
                available, pending
            </div>
            <span class="see-more">
                <strong>available states</strong> <i class="fa fa-chevron-down" aria-hidden="true"></i>
            </span>
        </div>
    </div>
    <div class="row my-3" style="text-align: center;">
        <div class="col-12">
           Description match: {!! Form::text('match_desc', $match_desc, ['id' => 'match_desc_input', 'class' => 'wide-input']) !!}
            <div class="more-details">
                Show all, Subscription update, Subscription creation, Yealink Handset, Number port
            </div>
            <span class="see-more">
                <strong>Common descriptions</strong> <i class="fa fa-chevron-down" aria-hidden="true"></i>
            </span>
        </div>
    </div>
    <div class="row mb-2">
         <div class="col-12" style="text-align: center;">
            <button class="ml-3 btn btn-primary" type="submit">
                Filter
            </button>
        </div>
    </div>
    {!! Form::close() !!}

    <h4>Transactions from Stripe</h4>
    <table class="table-lines mb-3">
        <tr>
            <th>#</th>
            <th>Created</th>
            <th>State</th>
            <th>Type</th>
            <th>Description</th>
            <th>Customer</th>
            <th>Amount</th>
            <th>Fee</th>
            <th>Net</th>
        </tr>
        @php
            $count = 0;
            $totals = [
                'amount' => 0,
                'fee' => 0,
                'net' => 0,
            ];
        @endphp

        @foreach($stripe_transactions as $txn)
            @php
                $count++;
                $totals['amount'] +=  $txn->amount;
                $totals['fee'] +=  $txn->fee;
                $totals['net'] +=  $txn->net;
                $style = $txn->status === 'pending' ? 'background-color: #FBC02D;' : '';
            @endphp
            <tr style="{{ $style }}">
                <td>{{ $count }}</td>
                <td>{{ \Carbon\Carbon::parse($txn->created)->format('d/m/Y') }}</td>
                <td>{{ $txn->status }}</td>
                <td>{{ $txn->type }}</td>
                <td>{{ $txn->description }}</td>
                <td>
                    @if($txn->related_customer)
                        <a target="_blank" style="font-size: 0.6rem;" href="https://dashboard.stripe.com/customers/{{ $txn->related_customer }}">
                            {{ $txn->related_customer }}
                        </a>
                    @endif
                </td>
                <td>{{ number_format((float)$txn->amount / 100, 2, '.', '') }}</td>
                <td>{{ number_format((float)$txn->fee / 100, 2, '.', '') }}</td>
                <td>{{ number_format((float)$txn->net / 100, 2, '.', '') }}</td>
            </tr>
        @endforeach

        <tr>
            <th colspan="6">Totals:</th>
            <th>{{ number_format((float)$totals['amount'] / 100, 2, '.', '') }}</th>
            <th>{{ number_format((float)$totals['fee'] / 100, 2, '.', '') }}</th>
            <th>{{ number_format((float)$totals['net'] / 100, 2, '.', '') }}</th>
        </tr>
        </table>

    <div class="row my-3">
        <div class="col-12">
            <h4>Internal record of paying customers</h4>
            Customers we expect payment from.
            <div class="more-details">
                <strong>Filters applied:</strong>
                <u>Install State Check</u>
                <ul>
                    <li>Only include leads where install_state is installed_live.</li>
                </ul>
                <u>Service End Date Check</u>
                Only include leads where the service hasn&rsquo;t ended, meaning:
                <ul>
                    <li>The service_end_date is missing (null),</li>
                    <li>or the service_end_date is in the future (after {{ \Carbon\Carbon::parse($from)->format('d/m/Y') }}).</li>
                </ul>
                <u>Billing Exemption Check</u>
                Only include leads where either:
                <ul>
                    <li>There is an exempt_expire_date and it has passed (before {{ \Carbon\Carbon::parse($to)->format('d/m/Y') }}),</li>
                    <li>or the lead has no billing exemption (billing_exempt is null).</li>
                </ul>
                <u>Package start date check</u>
                <ul>
                    <li>Return leads where package_start is either not set (null),</li>
                    <li>Or it is set to a date before {{ \Carbon\Carbon::parse($to)->format('d/m/Y') }}.</li>
                </ul>
            </div>
            <span class="see-more">
                <strong>filter details</strong> <i class="fa fa-chevron-down" aria-hidden="true"></i>
            </span>
        </div>
    </div>

    <table class="table-lines mb-3">
        <tr>
            <th>#</th>
            <th>ID</th>
            <th>Name</th>
            <th>Stripe ID</th>
            <th>Sub</th>
            <th>Discount</th>
            <th>Net</th>
        </tr>
        @php
            $count = 0;
            $flagged = 0;
            $totals = [
                'sub' => 0,
                'discount' => 0,
                'net' => 0,
            ];
        @endphp

        @foreach($leads as $lead)
            @php
                $count++;
                $net = $lead->package->price - $lead->discount_applied;
                $totals['sub'] += $lead->package->price;
                $totals['discount'] += $lead->discount_applied;
                $totals['net'] += $net;
                $style = '';
                if(empty($lead->stripe_id)){
                    $style = 'background-color: #ffbfbf;';
                    $flagged++;
                }
                if($lead->missing_transaction){
                    $style = 'background-color: #ffbfbf;';
                    $flagged++;
                }
            @endphp
            <tr style="{{ $style }}">
                <td style="{{ $style }}">{{ $count }}</td>
                <td style="{{ $style }}">{{ $lead->lead_id }}</td>
                <td style="{{ $style }}">
                    <a target="_blank" style="color: #000;" href="/customer/{{ $lead->lead_id }}">
                        {{ $lead->fullname }}
                    </a>
                </td>
                <td style="{{ $style }}">
                    @if($lead->cus_stripe_id)
                        <a target="_blank" style="font-size: 0.9rem" href="https://dashboard.stripe.com/customers/{{ $lead->cus_stripe_id }}">
                            {{ $lead->cus_stripe_id }}
                        </a>
                    @endif
                </td>
                <td style="{{ $style }}">{{ $lead->package->price }}</td>
                <td style="{{ $style }}">{{ $lead->discount_applied }}</td>
                <td style="{{ $style }}">{{ $net }}</td>

            </tr>
        @endforeach

        <tr>
            <th colspan="4">Totals:</th>
            <th>{{ number_format((float)$totals['sub'], 2, '.', '') }}</th>
            <th>{{ number_format((float)$totals['discount'], 2, '.', '') }}</th>
            <th>{{ number_format((float)$totals['net'], 2, '.', '') }}</th>
        </tr>
        <tr>
            <td style="background-color: #ffbfbf;"><strong>Flagged:</strong></td>
            <td style="background-color: #ffbfbf;" colspan="5">{{ $flagged }}</td>
        </tr>
    </table>

</div>

@endsection

@section('script')
<script>


</script>
@endsection