@php use App\Models\Customer; use App\Models\Instalasi; use App\Models\Invoice; $customer = Customer::join('instalasi', 'instalasi.id_customer', 'customer.id_customer') ->where('instalasi.status_instalasi', 'Uninstall') ->where('id_unit_instalasi', 6) ->get(); @endphp @foreach ($customer as $row) @php $invoice_deleted = Invoice::where('id_instalasi', $row->id_instalasi) ->where('tgl_invoice', '2025-08-01') ->where('status_invoice','!=','settlement') ->delete(); @endphp @endforeach