@foreach ($lapsebaranvar as $data) @php $results = DB::table('varietas_sebar') ->select(DB::raw('MAX(tanggal_lapor_sebar) as max')) ->where([['varietas_id', $data->varietas_id],['provinces_id',$data->provinces_id]]) ->first(); $jumlah = DB::table('varietas_sebar') ->select('regencies_id', DB::raw('SUM(luas_sebar) as total_luas_sebar')) ->where([['varietas_id', $data->varietas_id],['provinces_id',$data->provinces_id]]) ->whereIn('tanggal_lapor_sebar', function ($query) use ($data) { $query->select(DB::raw('MAX(tanggal_lapor_sebar) as max_tanggal')) ->from('varietas_sebar') ->where([['varietas_id', $data->varietas_id],['provinces_id',$data->provinces_id]]) ->groupBy('regencies_id'); }) ->groupBy('regencies_id') ->get(); @endphp @endforeach

Nama Provinsi	Nama Komoditas	Nama Varietas	Tanggal Lapor Terakhir	Luasan (Hektar)	Satuan
{{ $data->provinces->name }}	{{ $data->komoditas->nama }}	{{ $data->varietas->nama_varietas }}	{{ $results ? $results->max : 'N/A' }}	{{ $jumlah->sum('total_luas_sebar') }}	Hektar