@php use App\Models\Instalasi; $instalasi = Instalasi::join('customer','customer.id_customer','=','instalasi.id_customer') ->join('users','users.id_users','instalasi.id_marketing') ->where('customer.id_unit_instalasi',4) ->where('customer.nama','like','%F.sks)%') ->select('instalasi.*','customer.nama as nama_customer','users.nama as nama_marketing') ->get(); @endphp @foreach ($instalasi as $row)
Instalasi ID: {{ $row->id_instalasi }}
Nama Customer: {{ $row->nama_customer }}
Nama Marketing: {{ $row->nama_marketing }}