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