public function getIndex(Request $r)
{
if (!isset($r->offset) || !isset($r->limit)) {
$sql = RumputLaut::orderBy('id', 'desc')->first();
if ($sql) {
// Jika sudah ada data
// limit = Tanggal terbaru
// offset = Limit - 3 bulan
$limit1 = date_format(date_create($sql->created_at), "Y-m-d");
$limit = strtotime("{$limit1} +1 day");
$limit = date("Y-m-d", $limit);
$offset = strtotime("{$limit1} -3 months");
$offset = date("Y-m-d", $offset);
} else {
// Jika belum ada data offset = tgl skrang, limit = offset + 3 bulan
$offset = date('Y-m-d');
$limit = strtotime("{$offset} +3 months");
$limit = date("Y-m-d", $limit);
}
return redirect('/app/rumputlaut?offset=' . $offset . '&limit=' . $limit);
}
$limit = 10;
$data['rumputlaut'] = RumputLaut::whereBetween('created_at', [$r->offset, $r->limit])->paginate($limit);
return view('app.laporan-produksi.rumputlaut.index', $data)->with('limit', $limit);
}