Nama Komoditas
Nama Varietas
Tanggal Lapor Terakhir
Luasan (Hektar)
Satuan
@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) ->first(); $jumlah = DB::table('varietas_sebar') ->select('regencies_id', DB::raw('SUM(luas_sebar) as total_luas_sebar')) ->where('varietas_id', $data->varietas_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) ->groupBy('regencies_id'); }) ->groupBy('regencies_id') ->get(); @endphp
{{ $data->komoditas->nama }}
{{ $data->varietas->nama_varietas }}
{{ $results ? $results->max : 'N/A' }}
{{ $jumlah->sum('total_luas_sebar') }}
Hektar
@endforeach