/** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function mail_invoice($student_id, $fee_schedule_code) { $table = 'fee_sch_' . session()->get('current_session') . '_' . session()->get('current_term'); $data['fee_elements'] = DB::table($table)->where('fee_schedule_code', $fee_schedule_code)->get(); $data['fee_schedule'] = DB::table($table)->where('fee_schedule_code', $fee_schedule_code)->first(); $data['invoice'] = \DB::table('invoices_' . \Session::get('current_session') . '_' . \Session::get('current_term'))->where(['student_id' => $student_id, 'fee_schedule_code' => $fee_schedule_code])->first(); // dd($data['fee_schedule']); $student = Student::findOrFail($student_id); $data['student'] = $student; $data['school'] = School::findOrFail(1); //get this students parent $data['parent_email'] = $data['student']->studentParent->email; $send_mail = Helper::sendStudentInvoice($data, $student); // dd($send_mail); return redirect()->back(); }