/**
* Export students (query in session) to excel
*
* @return mixed
*/
public function export()
{
$students = session()->has('students') ? session('students')->get() : Student::get();
return \Excel::create('Students', function ($excel) use($students) {
$excel->sheet('students', function ($sheet) use($students) {
$sheet->fromArray($students->toArray());
});
})->download('xls');
}
/**
* Export students (query in session) to excel
*
* @return mixed
*/
public function export()
{
$students = $this->search->createQuery(session('students')) ? $this->search->createQuery(session('students'))->get() : Student::get();
return \Excel::create('Students', function ($excel) use($students) {
$excel->sheet('students', function ($sheet) use($students) {
$sheet->fromArray($students->toArray());
});
})->download('xls');
}
public function index()
{
$tglSekarang = time();
$students = Student::get();
foreach ($students as $student) {
$dateDiff = $tglSekarang - $student['registered_at'];
$durasi = floor($dateDiff / (60 * 60 * 24));
$periode = Periode::first();
if ($durasi > $periode['days']) {
$student->update(['status' => 0]);
} else {
$student->update(['status' => 1]);
}
}
return view('lms.index');
}
public function update($id, PeriodeRequest $request)
{
$periode = Periode::findOrFail($id);
$input = $request->all();
$periode->update($input);
//process
$tglSekarang = time();
$students = Student::get();
foreach ($students as $student) {
$dateDiff = $tglSekarang - $student['registered_at'];
$durasi = floor($dateDiff / (60 * 60 * 24));
$periodes = Periode::first();
if ($durasi > $periodes['days']) {
$student->update(['status' => 0]);
} else {
$student->update(['status' => 1]);
}
}
session()->flash('flash_message', 'You have been updated periode!');
return redirect()->route('settings.periode');
}
public function index()
{
$students = Student::get();
return view('lms.settings.student.student', compact('students'));
}
