public function fetchSheet(Request $request)
{
// dd($request->class);
$class_id = $request->class;
$data['title'] = 'Scoresheet';
$data['results_menu'] = 1;
//data for selecting class
$staff = Staff::find(\Session::get('user')->staff_id);
if (\Sentinel::getUser()->inRole('principal') or \Sentinel::getUser()->inRole('coder')) {
$data['classes'] = studentClass::lists('name', 'id')->prepend('Select a class');
} else {
$classes = array('Please select a class');
foreach ($staff->classes as $class) {
$classes[$class->id] = $class->name;
}
$data['classes'] = $classes;
}
// dd($request);
if ($class_id == 0) {
session()->flash('flash_message', 'Select a class');
// session()->flash('flash_message_important', true);
return \Redirect::to('academics/results');
}
$class = studentClass::where(['id' => $class_id])->first();
$subjects = \DB::table('class_subject')->where(['class_id' => $class_id])->get();
$students = Student::where(['class_id' => $class_id])->get();
//add students to class results table with initial values of zero
foreach ($students as $student) {
foreach ($class->subjects as $subject) {
//ensure that at least a session variable has been set. If there is at least on session variable set, the system will run well else it'll throw an error
if (CurrentTerm::all() !== null) {
$table = 'class_results_' . \Session::get('current_session') . '_' . \Session::get('current_term');
$positions_table = 'class_positions_' . \Session::get('current_session') . '_' . \Session::get('current_term');
$subject_exemption_table = 'subject_ex_' . \Session::get('current_session') . '_' . \Session::get('current_term');
//initialize class results table
try {
\DB::table($table)->insert(['class_id' => $class->id, 'student_id' => $student->id, 'subject_id' => $subject->id, 'created_at' => date('Y-m-d H:i:s'), 'updated_at' => date('Y-m-d H:i:s')]);
} catch (\Illuminate\Database\QueryException $e) {
$errorCode = $e->errorInfo[1];
// if($errorCode == 1062){
// session()->flash('flash_message', 'Session and Term variables have alreaddy been created.');
// return \Redirect::back()->withInput($request->except('element_id', 'amount'));
// }
}
//initialize class positions table
try {
\DB::table($positions_table)->insert(['class_id' => $class->id, 'student_id' => $student->id]);
} catch (\Illuminate\Database\QueryException $e) {
$errorCode = $e->errorInfo[1];
// if($errorCode == 1050){
// session()->flash('flash_message', 'Result table for chosen session and term already exists.');
// return \Redirect::back()->withInput();
// }
}
//initialize subject exemption table
try {
\DB::table($subject_exemption_table)->insert(['class_id' => $class->id, 'student_id' => $student->id, 'subject_id' => $subject->id]);
} catch (\Illuminate\Database\QueryException $e) {
$errorCode = $e->errorInfo[1];
if ($errorCode == 1050) {
session()->flash('flash_message', 'Result table for chosen session and term already exists.');
return \Redirect::back()->withInput();
}
}
} else {
session()->flash('flash_message', 'Please set session variables. Go to Settings>school settings');
return redirect()->back()->withInput();
}
}
}
$data['class'] = $class;
$data['subjects'] = $subjects;
$data['students'] = $students;
$data['selected_class'] = 1;
return view('academics.results.index', $data);
}
public function pay_invoice(Request $request)
{
// dd($request->all());
$data['title'] = 'Pay School Fees';
$data['fees'] = 1;
$class_id = $request->class_id;
$student_id = $request->student_id;
$fee_schedule_code = strval($class_id) . session()->get('current_session') . strval(session()->get('current_term'));
$session = session()->get('current_session');
$term = session()->get('current_term');
$data['transaction_modes'] = TransactionMode::lists('transaction_mode', 'id')->prepend('Please Select');
//current session invoice table
$table = 'invoices_' . $session . '_' . $term;
$data['student_fee_elements'] = [];
//==============get previous sessions fees not yet paid+++++++++++++
$sessions = CurrentTerm::orderBy('created_at', 'desc')->where('session', '!=', session()->get('current_session'))->orWhere('term', '!=', session()->get('current_term'))->take(9)->groupby('session')->get();
// dd($sessions);
$outstandings = [];
$invoices_amt = 0;
$payment_amt = 0;
// foreach ($sessions as $session) {
$invoices = Invoice::where('session', '!=', session()->get('current_session'))->orWhere('term', '!=', session()->get('current_term'))->get();
// dd($invoices);
//get all payments associated with an invoice
foreach ($invoices as $invoice) {
$payment_amt = 0;
$student_invoice = DB::table($invoice->table_name)->where(['student_id' => $student_id])->first();
//for every invoice, get payment associated with that invoice
if ($student_invoice !== null) {
$sch_fee_payment = SchoolFeesPayment::where(['session' => $invoice->session, 'term' => $invoice->term])->first();
$paid_amt = DB::table($sch_fee_payment->table_name)->where(['student_id' => $student_id])->sum('amount');
//get class id from fee schedule code
$outstanding_class_id = substr($student_invoice->fee_schedule_code, 0, 1);
//get oustanding amount
$outstanding_balance = $student_invoice->total - $paid_amt;
//if outstanding amt is not greater than zero then student has paid fully for that invoice therefore dont show on page
if ($outstanding_balance > 0) {
$session_fees = ['session' => $invoice->session, 'term' => $invoice->term, 'outstanding_balance' => $outstanding_balance, 'sch_fee_payment_table_name' => $sch_fee_payment->table_name, 'outstanding_fee_schedule_code' => $student_invoice->fee_schedule_code, 'outstanding_class_id' => $outstanding_class_id];
array_push($outstandings, $session_fees);
}
}
}
// }
if ($outstandings == []) {
$outstandings = null;
}
$data['outstandings'] = $outstandings;
//===========GET THIS SESSIONS FEES++++++++++++++++++
//get fee schedule elements for current session
$fee_sch_table = 'fee_sch_' . session()->get('current_session') . '_' . session()->get('current_term');
//get student invoice including exmepted fee elements
$data['student_invoice'] = \DB::table($table)->where(['student_id' => $student_id, 'fee_schedule_code' => $fee_schedule_code])->first();
// dd($data['student_invoice'] );
//
//check if invoice has been generated for this student
if ($data['student_invoice'] !== null) {
$already_paid = [];
$paid_amount = 0;
$data['exempted_elements'] = json_decode($data['student_invoice']->exempted_fee_elements);
if ($data['exempted_elements'] == null) {
$data['exempted_elements'] = [];
}
$sch_fee_payment = SchoolFeesPayment::where(['session' => session()->get('current_session'), 'term' => session()->get('current_term')])->first();
$payment_histories = DB::table($sch_fee_payment->table_name)->where(['student_id' => $student_id])->get();
// dd($payment_histories);
foreach ($payment_histories as $payment_history) {
$already_paid[] = json_decode($payment_history->elements_paid_for);
$paid_amount += $payment_history->amount;
}
$already_paid = array_flatten($already_paid);
// dd($already_paid);
if ($already_paid !== null) {
$data['already_paid'] = $already_paid;
} else {
$data['already_paid'] = [];
}
//get oustanding amount
$outstanding_balance = $data['student_invoice']->total - $paid_amount;
if ($outstanding_balance > 0) {
$data['student_fee_elements'] = DB::table($fee_sch_table)->where(['fee_schedule_code' => $fee_schedule_code])->join('fee_elements', 'fee_elements.id', '=', $fee_sch_table . '.fee_element_id')->get();
}
} else {
session()->flash('flash_message', 'An invoice has not been generated for this term for this student.');
}
if ($data['outstandings'] !== null || $data['student_invoice'] !== null) {
$sch_fee_payments = SchoolFeesPayment::all();
foreach ($sch_fee_payments as $sch_fee_payment) {
$term_payments = DB::table($sch_fee_payment->table_name)->where('student_id', $student_id)->orderBy('created_at', 'desc')->get();
$payments[] = $term_payments;
}
// dd(array_flatten($payments));
$data['payments'] = array_flatten($payments);
$data['student_info'] = Student::find($student_id);
$data['classes'] = studentClass::lists('name', 'id')->prepend('Please Select');
$data['students'] = Student::all();
return view('payments.payments', $data);
} else {
session()->flash('flash_message', 'An invoice has not been generated for this student.');
return redirect()->route('accounts.payments.index');
}
}
