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