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

@php
    $invoice = Invoice::where('invoice.id_unit_instalasi', '!=', 1)
        ->join('unit_instalasi', 'unit_instalasi.id_unit_instalasi', 'invoice.id_unit_instalasi')
        ->where('tgl_invoice', '2025-03-01')
        ->whereMonth('tgl_pembayaran', '05')
        ->whereYear('tgl_pembayaran', '2025')
        ->orderBy('invoice.id_unit_instalasi', 'asc')
        ->get();
@endphp

@foreach ($invoice as $row)

    @php
        $count = Invoice::where('id_unit_instalasi', $row->id_unit_instalasi)
            ->where('tgl_invoice', '2025-03-01')
            ->where('id_instalasi', $row->id_instalasi)
            ->count('id_invoice');
    @endphp


    @if ($count > 1)
    {{ $count }}
    <br>

    {{ $row->nama_ui }} <br>

   {{ $row->id_unit_instalasi }} | {{ $row->no_invoice }} - {{ $row->first_name }} - {{ $row->status_invoice }} <br>


    @php
        $invoice_mei = Invoice::where('tgl_invoice', '2025-05-01')->where('id_instalasi', $row->id_instalasi)->where('status_invoice','!=','settlement')->first();
    @endphp
    {{ $invoice_mei->id_unit_instalasi }} | {{ $invoice_mei->no_invoice }} - {{ $invoice_mei->first_name }} - {{ $invoice_mei->status_invoice }}

    @php

        $update_pindah_bulan = Invoice::where('id_invoice', $row->id_invoice)->update([
            'tgl_invoice' => $invoice_mei->tgl_invoice,
            'tgl_overdue' => $invoice_mei->tgl_overdue,
        ]);

        $delete = Invoice::where('id_invoice', $invoice_mei->id_invoice)->delete();

    @endphp

    <hr>
    @endif


@endforeach