@php
    use App\Models\Instalasi;

    $instalasi = Instalasi::join('customer', 'customer.id_customer', 'instalasi.id_customer')
        ->join('produk', 'produk.id_produk', 'instalasi.id_produk')
        ->where('instalasi.id_marketing', 333)
        ->whereDate('customer.created_at', '2025-06-17')
        ->orderBy('customer.nik', 'asc')
        ->get();

@endphp

<table border="1" cellpadding="5" cellspacing="0" width="100%">
    @foreach ($instalasi as $row)
        <tr>
            <td>{{ $row->id_unit_instalasi }}</td>
            <td>{{ $row->nik }}</td>
            <td>{{ $row->nama }}</td>
            <td>{{ $row->alamat_instalasi }}</td>
            <td>{{ $row->handphone }}</td>
            <td>{{ $row->nama_produk }} | {{ number($row->harga_produk) }}</td>
        </tr>

    @php
        //$delete_customer = \App\Models\Customer::where('id_customer', $row->id_customer)->delete();
        //$delete_instalasi = \App\Models\Instalasi::where('id_customer', $row->id_customer)->delete();
    @endphp
    @endforeach
</table>