public function getIndex(Request $r)
{
if (!isset($r->offset) || !isset($r->limit)) {
$sql = User::where('profesi', 'Pengolah')->orderBy('id', 'desc')->first();
if ($sql) {
// Jika sudah ada pengolah
// 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 pengolah 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/pengolah?offset=' . $offset . '&limit=' . $limit);
}
$pengolah = User::where('profesi', 'Pengolah')->whereBetween('created_at', [$r->offset, $r->limit])->orderBy('id', 'desc');
$limit = 10;
$data['pengolah'] = $pengolah->paginate($limit);
$data['kelompok'] = JenisUsaha::where('kelompok_bidang', 'Pengolah')->first()->kelompok;
$data['jabatan'] = Jabatan::paginate($limit);
$data['legalitas'] = Legalitas::all();
return view('app.pengolah.index', $data)->with('limit', $limit);
}
public function getTambah(Request $request)
{
$data['jabatan'] = Jabatan::paginate(10);
$dt = new Jabatan();
$dt->nama = $request->nama;
$dt->save();
return redirect()->route('jabatan', $data);
}
public function getUpdate(Request $request)
{
$data = Jabatan::find($request->id);
$data->nama = $request->nama;
$data->save();
$data['jabatan'] = Jabatan::paginate(1);
return redirect()->route('jabatan', $data)->with(session()->flash('success', 'Data Berhasil diupdate !!'));
}
