@extends(backpack_view('blank'))

@section('content')
    <div class="row justify-content-center mt-5">
        @php
            $invoiceAmount = 0;
            
            $invoiceAgreementsIds = \App\Models\InvoiceAgreement::where('invoice_id', $invoice->id)
                ->where('invoice_item_id', $invoiceItem->id)
                ->pluck('agreement_id')
                ->toArray();
            
            //find by last agreement approved /accepted
            $agreementGST = \App\Models\Agreement::whereIn('id', $invoiceAgreementsIds)
                ->whereIn('status', ['approved', 'accepted'])
                ->latest()
                ->first();
            $agreementGST = $agreementGST ? $agreementGST->gst : 0;
        @endphp
        <div class="col-md-12">
            <div class="card">
                <div class="card-header">
                    <h4 class="card-title mt-1 mb-0">Invoice Revision ({{ $invoiceItem->revision }})</h4>
                </div>
                <div class="card-body pb-1">
                    <b class="text-uppercase">Agreement:</b>
                    @forelse($invoiceAgreements as $invoiceAgreement)
                        @php
                            $agreementAmount = 0;
                            $agreementItem = \App\Models\AgreementItem::where('agreement_id', $invoiceAgreement->agreement->id)
                                ->where('revision', 'like', '%REV%')
                                ->orWhere('revision', 'like', '%EDIT%')
                                ->orderBy('created_at', 'desc')
                                ->first();
                            if ($agreementItem) {
                                $agreementItemLists = \App\Models\AgreementItemList::where('agreement_id', $invoiceAgreement->agreement->id)
                                    ->where('agreement_item_id', $agreementItem->id)
                                    ->orderBy('created_at', 'asc')
                                    ->get();
                                if ($agreementItemLists->count() > 0) {
                                    foreach ($agreementItemLists as $agreementItemList) {
                                        if ($agreementItemList->tier_level == 1) {
                                            $agreementAmount += $agreementItemList->amount;
                                        }
                                    }
                                }
                            }
                        @endphp
                        <div class="bg-light py-3 px-3 mb-3 rounded">
                            <div class="row">
                                <div class="col-6">
                                    <a href="{{ backpack_url('agreement/' . $invoiceAgreement->agreement->id . '/show') }}"
                                        target="_blank" class="mr-2">{{ $invoiceAgreement->agreement->running_no }} </a>
                                    @if (!empty($invoiceAgreement->agreement->discount) && $invoiceAgreement->agreement->discount > 0.0)
                                        Goodwill Discount : <b>${{ $invoiceAgreement->agreement->discount }}</b>
                                    @endif
                                </div>
                                <div class="col-6 text-right">
                                    @if ($invoiceAgreement->status == 'requested')
                                        <div class="text-uppercase text-white bg-info d-inline px-2 rounded">
                                            {{ $invoiceAgreement->status }}</div>
                                    @elseif ($invoiceAgreement->status == 'accepted' || $invoiceAgreement->status == 'approved')
                                        <div class="text-uppercase text-white bg-success d-inline px-2 rounded">
                                            {{ $invoiceAgreement->status }}
                                        </div>
                                    @elseif ($invoiceAgreement->status == 'void')
                                        <div class="text-uppercase text-white bg-danger d-inline px-2 rounded">
                                            {{ $invoiceAgreement->status }}</div>
                                    @else
                                        <div class="text-uppercase text-white bg-danger d-inline px-2 rounded">
                                            {{ $invoiceAgreement->status }}
                                        </div>
                                    @endif
                                </div>
                            </div>
                            <hr class="my-1">
                            Amount:
                            @if (!empty($invoiceAgreement->agreement->discount) && $invoiceAgreement->agreement->discount > 0.0)
                                <del>${{ number_format($agreementAmount, 2) }}</del>
                                @php
                                    $agreementAmount = $agreementAmount - $invoiceAgreement->agreement->discount;
                                @endphp
                            @endif

                            <b>${{ number_format($agreementAmount, 2) }}</b>
                            @if ($invoiceAgreement->status !== 'approved' && $invoiceAgreement->status !== 'accepted')
                                <div class="alert alert-warning mb-0 mt-2 py-1 px-2">
                                    Note: not Approved / Accepted status will not be calculated in total amount Invoice
                                </div>
                            @else
                                @php
                                    
                                    $agreementGSTAmount = $agreementAmount * ($agreementGST / 100);
                                @endphp
                                <hr />
                                <table>
                                    <tr>
                                        <td>Sub Total</td>
                                        <td>: <b>$ {{ number_format($agreementAmount, 2) }}</b></td>
                                    </tr>
                                    @php
                                        //add gst
                                        $agreementAmount += $agreementGSTAmount;
                                        $invoiceAmount += $agreementAmount;
                                    @endphp
                                    <tr class="pl-3">
                                        <td>GST {{ $agreementGST }}%</td>
                                        <td>: <b>$ {{ number_format($agreementGSTAmount, 2) }}</b></td>
                                    </tr>
                                    <tr class="pl-3">
                                        <td>Total</td>
                                        <td>: <b> ${{ number_format($agreementAmount, 2) }}</b></td>
                                    </tr>
                                </table>
                            @endif
                        </div>
                    @empty
                        <div class="alert alert-warning mb-0">
                            <h4 class="alert-heading border-bottom pb-2">Agreement Not Found!</h4>
                            On this revision, No Agrement entered
                        </div>
                    @endforelse
                    <hr />
                    <b class="d-block text-uppercase mb-2">Variation Order:</b>
                    @forelse($invoiceVariationOrders as $invoiceVariationOrder)
                        @php
                            $variationOrderAmount = 0;
                            $variationOrderItem = \App\Models\VariationOrderItem::where('variation_order_id', $invoiceVariationOrder->variationOrder->id)
                                ->where('revision', 'like', '%REV%')
                                ->orderBy('created_at', 'desc')
                                ->first();
                            $variationOrderItemLists = \App\Models\VariationOrderItemList::where('variation_order_id', $invoiceVariationOrder->variationOrder->id)
                                ->where('variation_order_item_id', $variationOrderItem->id)
                                ->orderBy('created_at', 'asc')
                                ->get();
                            if ($variationOrderItemLists->count() > 0) {
                                foreach ($variationOrderItemLists as $variationOrderItemList) {
                                    if ($variationOrderItemList->tier_level == 1) {
                                        $variationOrderAmount += $variationOrderItemList->amount;
                                    }
                                }
                            }
                        @endphp
                        <div class="bg-light py-3 px-3 mb-3 rounded">
                            <div class="row">
                                <div class="col-6">
                                    <a href="{{ backpack_url('variation-order/' . $invoiceVariationOrder->variationOrder->id . '/show') }}"
                                        target="_blank"
                                        class="mr-2">{{ $invoiceVariationOrder->variationOrder->running_no }} </a>
                                    @if (!empty($invoiceVariationOrder->variationOrder->discount) && $invoiceVariationOrder->variationOrder->discount > 0.0)
                                        Goodwill Discount : <b>${{ $invoiceVariationOrder->variationOrder->discount }}</b>
                                    @endif
                                </div>
                                <div class="col-6 text-right">
                                    @if ($invoiceVariationOrder->status == 'requested')
                                        <div class="text-uppercase text-white bg-info d-inline px-2 rounded">
                                            {{ $invoiceVariationOrder->status }}</div>
                                    @elseif ($invoiceVariationOrder->status == 'accepted' || $invoiceVariationOrder->status == 'approved')
                                        <div class="text-uppercase text-white bg-success d-inline px-2 rounded">
                                            {{ $invoiceVariationOrder->status }}
                                        </div>
                                    @elseif ($invoiceVariationOrder->status == 'void')
                                        <div class="text-uppercase text-white bg-danger d-inline px-2 rounded">
                                            {{ $invoiceVariationOrder->status }}</div>
                                    @else
                                        <div class="text-uppercase text-white bg-danger d-inline px-2 rounded">
                                            {{ $invoiceVariationOrder->status }}</div>
                                    @endif
                                </div>
                            </div>
                            <hr class="my-1">
                            Amount:
                            @if (!empty($invoiceVariationOrder->variationOrder->discount) && $invoiceVariationOrder->variationOrder->discount > 0.0)
                                <del>${{ number_format($variationOrderAmount, 2) }}</del>
                                @php
                                    $variationOrderAmount = $variationOrderAmount - $invoiceVariationOrder->variationOrder->discount;
                                @endphp
                            @endif
                            <b>${{ number_format($variationOrderAmount, 2) }}</b>
                            @if ($invoiceVariationOrder->status !== 'approved' && $invoiceVariationOrder->status !== 'accepted')
                                <div class="alert alert-warning mb-0 mt-2 py-1 px-2">
                                    Note: not Approved / Accepted status will not be calculated in total amount Invoice
                                </div>
                            @else
                                @php
                                    
                                    $agreementGSTAmount = $variationOrderAmount * ($agreementGST / 100);
                                @endphp
                                <hr />
                                <table>
                                    @php
                                        //add gst
                                        $variationOrderAmount += $agreementGSTAmount;
                                        $invoiceAmount += $variationOrderAmount;
                                    @endphp
                                    <tr class="pl-3">
                                        <td>GST {{ $agreementGST }}%</td>
                                        <td>: <b>$ {{ number_format($agreementGSTAmount, 2) }}</b></td>
                                    </tr>
                                    <tr class="pl-3">
                                        <td>Total</td>
                                        <td>: <b> ${{ number_format($variationOrderAmount, 2) }}</b></td>
                                    </tr>
                                </table>
                            @endif
                        </div>
                    @empty
                        <div class="alert alert-warning mb-0">
                            <h4 class="alert-heading border-bottom pb-2">Variation Not Found!</h4>
                            On this revision, No Variation entered
                        </div>
                    @endforelse
                </div>
                <div class="card-footer">
                    <p><b class="text-uppercase">Total Invoice : ${{ number_format($invoiceAmount, 2) }}</b></p>
                </div>
            </div>
            <div class="mb-2">
                <a href="{{ route('invoice.revision.index', ['id' => $id]) }}" class="btn btn-default"><span
                        class="la la-arrow-left"></span> Back</a>
            </div>
        </div>
    </div>
@endsection


@section('after_styles')
    <link rel="stylesheet"
        href="{{ asset('packages/backpack/crud/css/crud.css') . '?v=' . config('backpack.base.cachebusting_string') }}">
    <link rel="stylesheet"
        href="{{ asset('packages/backpack/crud/css/show.css') . '?v=' . config('backpack.base.cachebusting_string') }}">
    <style type="text/css">
        body {
            counter-reset: esum;
        }

        .numbered {
            position: relative;
            counter-increment: esum;
            padding: 15px;
        }

        .numbered:before {
            position: absolute;
            margin-left: 15px;
            content: counter(esum)".";
            font-size: 20px;
        }

        .numbered .amount {
            display: inline-block;
            float: right;
        }

        .numbered .area {
            display: inline-block;
            font-size: 18px;
            font-family: 'Source Sans Pro';
        }

        .sow {
            display: inline-block !important;
            font-size: 22px !important;
        }
    </style>
    <style type="text/css">
        .box-item {
            border: 1px solid rgb(221, 221, 221);
            background: rgb(238, 238, 238);
            margin-bottom: 5px;
            padding: 5px;
            border-radius: 5px;
        }

        .requirement-table section:last-child {
            margin-bottom: 20px;
        }

        .grow-wrap {
            display: grid;
        }

        .grow-wrap::after {
            content: attr(data-replicated-value) " ";
            white-space: pre-wrap;
            visibility: hidden;
        }

        .grow-wrap>textarea {
            resize: none;
            overflow: hidden;
        }

        .grow-wrap>textarea,
        .grow-wrap::after {
            padding: 0.5rem;
            font: inherit;
            grid-area: 1 / 1 / 2 / 2;
        }

        .label-children {
            font-weight: 400 !important;
        }

        .input-tier-1 {
            font-weight: bold !important;
            font-size: 16px !important;
            color: #000000;
        }

        .input-tier-2 {
            font-size: 16px !important;
            color: #000000;
        }

        .input-tier-3 {
            color: grey;
            font-size: 14px !important;
        }

        .input-tier-area {
            font-weight: bold !important;
            font-size: 15px !important;
            color: #000000;
        }

        .margin-tier-1 {}

        .margin-tier-2 {
            margin-left: 25px !important;
        }

        .margin-tier-3 {
            margin-left: 50px !important;
        }

        .margin-tier-area {
            margin-left: 25px !important;
        }

        .font-size-13px {
            font-size: 13px !important;
        }

        hr {
            margin-top: 0.7em;
            margin-bottom: 0.7rem;
        }
    </style>
@endsection

@section('after_scripts')
    <script src="{{ asset('packages/backpack/crud/js/crud.js') . '?v=' . config('backpack.base.cachebusting_string') }}">
    </script>
    <script src="{{ asset('packages/backpack/crud/js/show.js') . '?v=' . config('backpack.base.cachebusting_string') }}">
    </script>
@endsection