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