public function create() { $menu = 'finance'; $employees = Employee::where('location_id', '=', Auth::user()->location_id)->get(); $classifications = Classification::where('category', '=', 'Operational')->get(); return View::make('spendings.create', compact('employees', 'classifications', 'menu')); }
public function edit($id) { $income = Income::find($id); $classifications = Classification::where('category', '=', 'Income')->get(); $menu = 'employee'; return View::make('incomes.edit', compact('income', 'classifications', 'menu')); }
public function edit($id) { $deduction = Deduction::find($id); $classifications = Classification::where('category', '=', 'Deduction')->get(); $menu = 'employee'; return View::make('deductions.edit', compact('deduction', 'classifications', 'menu')); }
public function edit($id) { $resign = Resign::find($id); $classifications = Classification::where('category', '=', 'Resign')->get(); $menu = 'student'; return View::make('resigns.edit', compact('resign', 'classifications', 'menu')); }
public function create() { $classifications = Classification::where('category', '=', 'Course')->get(); $programs = Program::where('project_id', '=', Auth::user()->curr_project_id)->get(); $majors = Major::all(); $generations = Generation::all(); $menu = 'project'; return View::make('courses.create', compact('classifications', 'programs', 'generations', 'majors', 'menu')); }
public function edit($id) { $registration = Registration::find($id); $locations = Location::all(); $employees = Employee::where('location_id', '=', 18)->get(); $classifications = Classification::where('category', '=', 'Registration')->get(); $menu = 'registration'; return View::make('registrations.edit', compact('registration', 'menu', 'locations', 'employees', 'classifications')); }
public function recapCirculationGeneration() { $registrations = Classification::where('category', '=', 'Registration')->get(); $resigns = Classification::where('category', '=', 'Resign')->get(); $generations = Generation::all(); $comes = array(); $leaves = array(); foreach ($registrations as $registration) { $statistics = array(); foreach ($generations as $generation) { $count = Registration::with(array('issue'))->join('issues', 'issues.registration_id', '=', 'registrations.id')->where('registrations.project_id', '=', Auth::user()->curr_project_id)->where('registrations.location_id', '=', Auth::user()->location_id)->where('registrations.classification_id', '=', $registration->id)->where('issues.generation_id', '=', $generation->id)->count(); $statistics[] = array('count' => $count); } $comes[] = array('name' => $registration->name, 'statistics' => $statistics); } foreach ($resigns as $resign) { $statistics = array(); foreach ($generations as $generation) { $count = Resign::with(array('issue'))->join('issues', 'issues.id', '=', 'resigns.issue_id')->where('resigns.project_id', '=', Auth::user()->curr_project_id)->where('resigns.location_id', '=', Auth::user()->location_id)->where('resigns.classification_id', '=', $resign->id)->where('issues.generation_id', '=', $generation->id)->count(); $statistics[] = array('count' => $count); } $leaves[] = array('name' => $resign->name, 'statistics' => $statistics); } $menu = 'report'; return View::make('reports.recapcirculationgeneration', compact('comes', 'leaves', 'generations', 'menu')); }