/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DB::table('fee_elements')->truncate();
$tuition = FeeElement::create(array('code' => 'TUI', 'name' => 'Tuition', 'description' => 'Payment for Tuition', 'status_id' => 1));
//get the last radix number
$last_radix_no = ChartOfAccount::where(['id_parent' => 52])->max('radix_no');
$this_radix_no = $last_radix_no + 1;
ChartOfAccount::create(['item_title' => 'Tuition', 'account_code' => $tuition->id, 'radix_no' => $this_radix_no, 'parent_radix_id' => 52, 'item_level' => 2, 'id_parent' => 52]);
$medical = FeeElement::create(array('code' => 'MED', 'name' => 'Medical', 'description' => 'Payment for medical expenses', 'status_id' => 1));
//get the last radix number
$last_radix_no = ChartOfAccount::where(['id_parent' => 52])->max('radix_no');
$this_radix_no = $last_radix_no + 1;
ChartOfAccount::create(['item_title' => 'Medical', 'account_code' => $medical->id, 'radix_no' => $this_radix_no, 'parent_radix_id' => 52, 'item_level' => 2, 'id_parent' => 52]);
$food = FeeElement::create(array('code' => 'Food', 'name' => 'Food', 'description' => 'Payment for all meals in school', 'status_id' => 1));
//get the last radix number
$last_radix_no = ChartOfAccount::where(['id_parent' => 52])->max('radix_no');
$this_radix_no = $last_radix_no + 1;
ChartOfAccount::create(['item_title' => 'Food', 'account_code' => $food->id, 'radix_no' => $this_radix_no, 'parent_radix_id' => 52, 'item_level' => 2, 'id_parent' => 52]);
$devLev = FeeElement::create(array('code' => 'DevLEV', 'name' => 'Development Levy', 'description' => 'Payment for all school development projects', 'status_id' => 1));
//get the last radix number
$last_radix_no = ChartOfAccount::where(['id_parent' => 52])->max('radix_no');
$this_radix_no = $last_radix_no + 1;
ChartOfAccount::create(['item_title' => 'Development Levy', 'account_code' => $devLev->id, 'radix_no' => $this_radix_no, 'parent_radix_id' => 52, 'item_level' => 2, 'id_parent' => 52]);
$sch_bus = FeeElement::create(array('code' => 'SchBUS', 'name' => 'School Bus', 'description' => 'Payment for us of the School Bus', 'status_id' => 1));
//get the last radix number
$last_radix_no = ChartOfAccount::where(['id_parent' => 52])->max('radix_no');
$this_radix_no = $last_radix_no + 1;
ChartOfAccount::create(['item_title' => 'School Bus', 'account_code' => $sch_bus->id, 'radix_no' => $this_radix_no, 'parent_radix_id' => 52, 'item_level' => 2, 'id_parent' => 52]);
$comp_ict = FeeElement::create(array('code' => 'CompICT', 'name' => 'Computer & ICT', 'description' => 'Payment for use of all Computers and ICT infrastructure', 'status_id' => 1));
//get the last radix number
$last_radix_no = ChartOfAccount::where(['id_parent' => 52])->max('radix_no');
$this_radix_no = $last_radix_no + 1;
ChartOfAccount::create(['item_title' => 'Computer & ICT', 'account_code' => $comp_ict->id, 'radix_no' => $this_radix_no, 'parent_radix_id' => 52, 'item_level' => 2, 'id_parent' => 52]);
$pta = FeeElement::create(array('code' => 'PTA', 'name' => 'PTA', 'description' => 'Payment for PTA', 'status_id' => 1));
//get the last radix number
$last_radix_no = ChartOfAccount::where(['id_parent' => 52])->max('radix_no');
$this_radix_no = $last_radix_no + 1;
ChartOfAccount::create(['item_title' => 'PTA', 'account_code' => $pta->id, 'radix_no' => $this_radix_no, 'parent_radix_id' => 52, 'item_level' => 2, 'id_parent' => 52]);
$excursion = FeeElement::create(array('code' => 'ECURSION', 'name' => 'Excursion', 'description' => 'Payment for Excursion', 'status_id' => 1));
//get the last radix number
$last_radix_no = ChartOfAccount::where(['id_parent' => 52])->max('radix_no');
$this_radix_no = $last_radix_no + 1;
ChartOfAccount::create(['item_title' => 'Excursion', 'account_code' => $excursion->id, 'radix_no' => $this_radix_no, 'parent_radix_id' => 52, 'item_level' => 2, 'id_parent' => 52]);
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($fee_schedule_code)
{
$data['title'] = 'Fee Schedule';
$data['fee_schedules_menu'] = 1;
$table = 'fee_sch_' . session()->get('current_session') . '_' . session()->get('current_term');
$data['fee_schedules'] = DB::table($table)->where('fee_schedule_code', $fee_schedule_code)->first();
$data['fee_elements'] = FeeElement::where('status_id', 1)->get();
$data['current_elements'] = DB::table($table)->where('fee_schedule_code', $fee_schedule_code)->lists('amount', 'fee_element_id');
return view('billing.fee_schedules.edit', $data);
}
public function reports_search(Request $request)
{
// dd($request);
$fee_element_id = $request->fee_element_id;
$search_by = $request->search_by;
$data['title'] = 'Reports';
$data['accounts_menu'] = 1;
$data['coa_elements'] = ChartOfAccount::where(['id_parent' => 52])->lists('item_title', 'account_code');
$data['search_dates'] = ['0' => 'Select Search Date', '1' => 'Last Week', '2' => 'Last Month', '3' => '3 Months Ago', '4' => '6 Months Ago', '5' => '1 Year Ago'];
$data['result'] = 1;
$data['total'] = Helper::reports_total_on_item($fee_element_id, $search_by);
$data['search_item'] = FeeElement::find($fee_element_id)->first()->name;
return view('accounts.reports.index', $data);
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function class_invoices(Request $request)
{
// dd($request->all());
//ensure a class as selected
if (0 == $request->class_id) {
session()->flash('flash_message', 'Select Class');
return \Redirect::back()->withInput();
}
//ensure a session as selected
if (0 == $request->session) {
session()->flash('flash_message', 'Select Session');
return \Redirect::back()->withInput();
}
//ensure a term as selected
if (0 == $request->term_id) {
session()->flash('flash_message', 'Select Term');
return \Redirect::back()->withInput();
}
//ensure at least on element was selected
$data['title'] = 'Invoices';
$data['invoice_menu'] = 1;
// {class_id}{session}{term_id}
$fee_schedule_code = strval($request->class_id) . $request->session . strval($request->term_id);
$data['session'] = $request->session;
$data['class'] = StudentClass::findOrFail($request->class_id)->name;
$data['term'] = $request->term_id;
//get invoices
$data['invoices'] = \DB::table('invoices_' . \Session::get('current_session') . '_' . \Session::get('current_term'))->where('fee_schedule_code', $fee_schedule_code)->get();
// dd($data['invoices']);
//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.invoices.class_invoices', $data);
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit_staff_policy($id = 2)
{
$data['discount_policy'] = DiscountPolicy::find($id);
$data['fee_elements'] = FeeElement::lists('name', 'id');
$data['discount_durations'] = DiscountDuration::lists('duration', 'id')->prepend('Please select');
return view('billing.discount_policies.edit_staff_policy', $data);
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function deactivate($id)
{
$fee_element = FeeElement::find($id);
$fee_element->status_id = 2;
$fee_element->save();
return redirect('billing/fee_elements');
}
