/** * Show the form for creating a new resource. * * @return \Illuminate\Http\Response */ public function create() { $data['title'] = 'Fee Schedule'; $data['fee_schedules_menu'] = 1; //create array to hole school session starting 10 yrs from current date $sessions = ['Select Session']; for ($i = intval(date('Y')) - 10; $i < intval(date('Y')) + 15; $i++) { $session = $i . '-' . ($i + 1); $sessions[$session] = $session; } $data['sessions'] = $sessions; $data['terms'] = ['Select Term', 1, 2, 3]; $data['classes'] = studentClass::lists('name', 'id')->prepend('Select Class'); $data['fee_elements'] = FeeElement::where('status_id', 1)->get(); return view('billing.fee_schedules.create', $data); }
/** * Run the database seeds. * * @return void */ public function run() { // DB::table('classes')->truncate(); $faker = Faker\Factory::create(); studentClass::create(['name' => 'SSS 3A', 'staff_id' => $faker->numberBetween($min = 2, $max = 10), 'max_students' => 30]); studentClass::create(['name' => 'SSS 3B', 'staff_id' => $faker->numberBetween($min = 2, $max = 10), 'max_students' => 30]); studentClass::create(['name' => 'SSS 3C', 'staff_id' => $faker->numberBetween($min = 2, $max = 10), 'max_students' => 30]); studentClass::create(['name' => 'SSS 2A', 'staff_id' => $faker->numberBetween($min = 2, $max = 10), 'max_students' => 30]); studentClass::create(['name' => 'SSS 2B', 'staff_id' => $faker->numberBetween($min = 2, $max = 10), 'max_students' => 30]); studentClass::create(['name' => 'SSS 2C', 'staff_id' => $faker->numberBetween($min = 2, $max = 10), 'max_students' => 30]); studentClass::create(['name' => 'SSS 1A', 'staff_id' => $faker->numberBetween($min = 2, $max = 10), 'max_students' => 30]); studentClass::create(['name' => 'SSS 1B', 'staff_id' => $faker->numberBetween($min = 2, $max = 10), 'max_students' => 30]); studentClass::create(['name' => 'SSS 1C', 'staff_id' => $faker->numberBetween($min = 2, $max = 10), 'max_students' => 30]); studentClass::create(['name' => 'JSS 3A', 'staff_id' => $faker->numberBetween($min = 2, $max = 10), 'max_students' => 30]); studentClass::create(['name' => 'JSS 3B', 'staff_id' => $faker->numberBetween($min = 2, $max = 10), 'max_students' => 30]); studentClass::create(['name' => 'JSS 3C', 'staff_id' => $faker->numberBetween($min = 2, $max = 10), 'max_students' => 30]); }
public function promote($class_id) { $table = 'class_positions_' . \Session::get('current_session') . '_' . \Session::get('current_term'); $promotion_class_id = studentClass::where('id', $class_id)->first()->promotion_class_id; $pass_avg = 50.0; $students = Student::where('class_id', $class_id)->get(); foreach ($students as $student) { $student_avg = \DB::table($table)->where(['student_id' => $student->id, 'class_id' => $class_id])->first()->average; if ($student_avg >= $pass_avg) { $std = new Student(); $std->class_id = $promotion_class_id; $std->save(); } } }
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'); } }