public function filter($month, $year) { $curr_month = $month; $curr_year = $year; $deductions = Deduction::where('location_id', '=', Auth::user()->location_id)->where(DB::raw('year(release_date)'), '=', $curr_year)->where(DB::raw('month(release_date)'), '=', $curr_month)->get(); $menu = 'employee'; return View::make('deductions.index', compact('deductions', 'curr_year', 'curr_month', 'menu')); }
public function show($id) { $payroll = Payroll::findOrFail($id); $curr_month = (int) date('m', strtotime($payroll->release_date)); $curr_year = (int) date('Y', strtotime($payroll->release_date)); $curr_month = $curr_month - 1; if ($curr_month == 0) { $curr_month = 12; $curr_year = $curr_year - 1; } $employee = Employee::find($payroll->employee_id); $incomes = Income::where('employee_id', '=', $employee->id)->where(DB::raw('year(release_date)'), '=', $curr_year)->where(DB::raw('month(release_date)'), '=', $curr_month)->get(); $deductions = Deduction::where('employee_id', '=', $employee->id)->where(DB::raw('year(release_date)'), '=', $curr_year)->where(DB::raw('month(release_date)'), '=', $curr_month)->get(); $teaches = Teach::where('employee_id', '=', $employee->id)->where(DB::raw('year(course_date)'), '=', $curr_year)->where(DB::raw('month(course_date)'), '=', $curr_month)->count(); $menu = 'employee'; return View::make('payrolls.show', compact('payroll', 'employee', 'incomes', 'deductions', 'teaches', 'curr_year', 'curr_month', 'menu')); }