public function getDetailDesa($id)
{
$data['desa'] = Desa::find($id);
$data['airtawar'] = AirTawar::where('desa', $id)->get();
$data['rumputlaut'] = RumputLaut::where('desa', $id)->get();
$data['tambak'] = Tambak::where('desa', $id)->get();
$data['mangrovemilik'] = MangroveMilik::where('desa', $id)->get();
$data['mangroverehabilitasi'] = MangroveRehabilitasi::where('desa', $id)->get();
$data['terumbumilik'] = TerumbuMilik::where('desa', $id)->get();
$data['terumburehabilitasi'] = TerumbuRehabilitasi::where('desa', $id)->get();
return view('app.statistik.detail-desa', $data);
}
public function getExportExcel(Request $r)
{
$data['terumburehabilitasi'] = TerumbuRehabilitasi::whereBetween('created_at', [$r->offset, $r->limit])->orderBy('desa', 'asc')->get();
Excel::create('Data terumbu karang yang direhabilitasi');
Excel::create('Data terumbu karang yang direhabilitasi', function ($excel) use($data) {
$excel->sheet('New sheet', function ($sheet) use($data) {
$sheet->loadView('app.terumbu.rehabilitasi.export-excel', $data);
});
})->download('xlsx');
}
