public static function getDaysTaken($employee, $leavetype)
{
$leavestaken = DB::table('leaveapplications')->where('employee_id', '=', $employee->id)->where('leavetype_id', '=', $leavetype->id)->where('status', '=', 'approved')->get();
$daystaken = 0;
foreach ($leavestaken as $leavetaken) {
$taken = Leaveapplication::getLeaveDays($leavetaken->approved_start_date, $leavetaken->approved_end_date);
$daystaken = $daystaken + $taken;
}
return $daystaken;
}
