@php
    use App\Models\Invoice;
    use App\Models\Produk;
    use App\Models\InvoiceDetail;
    use App\Models\UnitInstalasi;



    $invoice = Invoice::where('status_invoice','settlement')
        ->where('id_unit_instalasi',20)
        ->where('tgl_invoice', '2025-03-01')
        ->whereMonth('tgl_pembayaran', date('m'))
        ->whereYear('tgl_pembayaran', date('Y'))
        ->get();

@endphp

@foreach ($invoice as $inv)

{{ $inv->no_invoice }} - {{ $inv->tgl_invoice }} - {{ $inv->tgl_pembayaran }}


@php
    $unit_instalasi = UnitInstalasi::where('id_unit_instalasi',$inv->id_unit_instalasi)->first();

    $data = [
            'tgl_invoice' => '2025-05-01',
            'tgl_overdue' => "2025-05-".$unit_instalasi->overdue_invoice_at,
];


    $update= Invoice::where('no_invoice',$inv->no_invoice)->update($data);
    $delete= Invoice::where('id_instalasi',$inv->id_instalasi)->where('tgl_invoice','2025-05-01')->delete();
@endphp
<br>

@endforeach