@php
        use App\Models\Invoice;

$id_unit_instalasi = 65;
$tgl_invoice = '2025-09-01';

        $invoice=Invoice::join('unit_instalasi','unit_instalasi.id_unit_instalasi','=','invoice.id_unit_instalasi')
        ->where('status_invoice','!=','settlement')
        ->where('invoice.id_unit_instalasi',$id_unit_instalasi)
        ->where('tgl_invoice', $tgl_invoice)
        ->orderBy('invoice.id_unit_instalasi')
        ->get();

@endphp

@foreach ($invoice as $inv)


{{ $inv->id_unit_instalasi }} - {{ $inv->nama_ui }} - {{ $inv->no_invoice }} - {{ $inv->first_name }} - {{ $inv->tgl_invoice }} - {{ $inv->status_invoice }}
<br>

@php
    //$inv->delete();
@endphp



@endforeach