@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 }}


@php //$update = Instalasi::where('id_instalasi', $row->id_instalasi)->update(['id_marketing' => 501]); @endphp @endforeach