@php
    use App\Models\Invoice;


    $invoice = Invoice::select('invoice.*', \DB::raw('COUNT(*) as total_invoices'))
        ->where('id_unit_instalasi', 7)
        ->whereDate('tgl_invoice', '2025-03-01')
        ->where('status_invoice', '!=', 'settlement')
        ->groupBy('id_instalasi')
        ->get();

@endphp

@foreach ($invoice as $row)


@if ($row->total_invoices == 2)

{{ $row->no_invoice }}  {{ $row->status_invoice }} ({{$row->total_invoices}}) <br>

@php
    //$update = Invoice::where('id_invoice', $row->id_invoice)->update(['deleted_at' => '2024-03-01 00:00:00']);
@endphp
@endif





@endforeach