public function postLacRequestStatusApproveBRF()
{
$validator = Validator::make(Input::all(), ['brf_id' => 'required', 'lac_status' => 'required']);
if ($validator->fails()) {
return redirect('/lac/requeststatus')->withInput()->withErrors($validator)->with('globalalertmessage', 'Failed to Aprove. Try Again')->with('globalalertclass', 'error');
}
$brf_model_instance = BasicRequisitionForm::find(Input::get('brf_id'));
$brf_model_instance->lac_status = Input::get('lac_status');
$brf_model_instance->remarks = Input::get('remarks');
$brf_model_instance->save();
if (Input::get('lac_status') == "denied") {
# code...
$brf_model_user_instance = User::find($brf_model_instance->laravel_user_id);
Mail::send('emails.deniedbylac', ['brf_model_instance' => $brf_model_instance, 'brf_model_user_instance' => $brf_model_user_instance], function ($m) use($brf_model_instance, $brf_model_user_instance) {
$m->from('*****@*****.**', 'Library Portal Team');
$m->to($brf_model_user_instance->email, $brf_model_user_instance->name)->subject('[Library] Request Denied for Book');
// $m->to("*****@*****.**", $brf_model_user_instance->name)->subject('[Library] Request Denied for Book');
});
}
return redirect('lac/requeststatus')->with('globalalertmessage', 'Request Successfully updated.')->with('globalalertclass', 'success');
}
public function getAdminRequestStatusExportExcel()
{
$admin_user_brfs = DB::table('brfs')->where('lac_status', "approved")->where('librarian_status', "approved")->where('download_status', null)->orderBy('id', 'desc')->get();
// dd($admin_user_brfs);
if (!empty($admin_user_brfs)) {
foreach ($admin_user_brfs as $key => $admin_user_brf) {
$brf_model_instance = BasicRequisitionForm::find($admin_user_brf->id);
$brf_model_instance->download_status = "downloaded";
$brf_model_instance->remarks = "The procurement process has been initiated.";
$brf_model_instance->save();
$brf_model_user_instance = User::find($brf_model_instance->laravel_user_id);
Mail::send('emails.acceptedbylibrarian', ['brf_model_instance' => $brf_model_instance, 'brf_model_user_instance' => $brf_model_user_instance], function ($m) use($brf_model_instance, $brf_model_user_instance) {
$m->from('*****@*****.**', 'Library Portal Team');
$m->to($brf_model_user_instance->email, $brf_model_user_instance->name)->subject('[Library] Request Approved for Book');
// $m->to("*****@*****.**", $brf_model_user_instance->name)->subject('[Library] Request Approved for Book');
// No commented test for CC here.
});
$brf_array_row = (array) $admin_user_brf;
$brf_array[] = $brf_array_row;
}
$data = (array) $brf_array;
$date = Carbon::now();
$currentDateTime = $date->toDateTimeString();
Excel::create($currentDateTime, function ($excel) use($data) {
$excel->sheet('Sheetname', function ($sheet) use($data) {
$sheet->fromArray($data);
});
})->export('xls');
return "Excel Exported";
} else {
return redirect('admin/requeststatus')->with('globalalertmessage', 'No requests found to be exported')->with('globalalertclass', 'error');
}
}
