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); }