public function filter($date)
{
$curr_date = $date;
$teaches = Teach::where('project_id', '=', Auth::user()->curr_project_id)->where('location_id', '=', Auth::user()->location_id)->where('course_date', '=', $curr_date)->get();
$menu = 'employee';
return View::make('presences.index', compact('teaches', 'curr_date', 'menu'));
}
public function teached($course_id, $subject_id, $course_date, $hour_id)
{
$countMe = Teach::where('course_id', '=', $course_id)->where('course_date', '=', $course_date)->where('hour_id', '=', $hour_id)->count();
if ($countMe > 0) {
return true;
} else {
return false;
}
}
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'));
}
