@php
    use App\Models\Invoice;
    use App\Models\InvoiceDetail;
@endphp

@php
    $invoice = Invoice::join('invoice_detail', 'invoice_detail.id_invoice', 'invoice.id_invoice')
        ->where('invoice.id_unit_instalasi','!=',1)
        ->where('invoice.gross_amount', 'LIKE', '%001')
        ->where('status_invoice', '!=', 'settlement')
        ->whereNull('invoice_detail.deleted_at')
        ->get();
@endphp


@foreach ($invoice as $inv)
    {{ $inv->id_unit_instalasi }} {{ $inv->no_invoice }} {{ $inv->status_invoice }} <br>
    Item Detail Price : {{ number($inv->item_details_price) }} <br>
    Tax : {{ number($inv->tax) }} <br>
    Gross Amount : {{ number($inv->gross_amount) }} | Check :
    {{ number($total_gross_amount = $inv->item_details_price + $inv->tax) }} |

    @if ($inv->gross_amount == $total_gross_amount)
        <span style="color: green">Valid</span>
    @else
        <span style="color: red">Not</span>
        @endif

    <br><br>

    Sub Total Detail : {{ number($inv->harga_detail) }} <br>
    Tax Detail : {{ number($inv->pajak_detail) }} <br>
    Amount Detail : {{ number($inv->sub_total_detail) }} | Check :
    {{ number($total_sub_total_detail = $inv->harga_detail + $inv->pajak_detail) }} |
    @if ($inv->sub_total_detail == $total_sub_total_detail)
        <span style="color: green">Valid</span>
    @else
        <span style="color: red">Not</span>
    @endif
    <br><br>
    Invoice Check :
    @if ($total_gross_amount == $total_sub_total_detail)
        @php

            /*
            $invoice_detail = Invoice::where('id_invoice', $inv->id_invoice)->update([
                'item_details_price' => $inv->item_details_price - 1,
                'gross_amount' => $inv->gross_amount - 1,
            ]);
            $invoice_detail = InvoiceDetail::where('id_invoice_detail', $inv->id_invoice_detail)->update([
                'harga_detail' => $inv->harga_detail - 1,
                'sub_total_detail' => $inv->sub_total_detail - 1,
            ]);
            */
        @endphp

        <span style="color: green">Valid</span>
    @else
        @php
            /*
            $invoice_detail = InvoiceDetail::where('id_invoice_detail',$inv->id_invoice_detail)->update([
                'harga_detail' => $inv->harga_detail-1,
                'sub_total_detail' => $inv->sub_total_detail-1
            ]);
            */
        @endphp
        <span style="color: red">Not</span>
    @endif



    <hr>
    <br>
@endforeach