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'));
}
/**
* Display the specified branch.
*
* @param int $id
* @return Response
*/
public function show($id)
{
$payroll = Payroll::findOrFail($id);
return View::make('payroll.show', compact('payroll'));
}
