public static function attendanceCount($employeeID)
{
// Calculating Attendance
$date = date('d');
$month = date('m');
$year = date('Y');
$firstDay = $year . '-' . $month . '-' . $date;
$presentCount = Attendance::countPresentDays($month, $year, $employeeID);
$totalDays = date('t', strtotime($firstDay));
$holiday_count = count(DB::select(DB::raw("select * from holidays where MONTH(date)=" . $month)));
$workingDays = $totalDays - $holiday_count;
return "{$presentCount}/{$workingDays}";
}
