{"iTotalDisplayRecords":"0","query":"\n    SELECT SQL_CALC_FOUND_ROWS `hr_attendance_id`, `hr_attendance_date`, `hr_attendance_employee`, `hr_attendance_shift`, `hr_attendance_in_time`, `hr_attendance_out_time`, `hr_attendance_actual_in_time`, `hr_attendance_actual_out_time`, `hr_attendance_work_duration`, `hr_attendance_ot_duration`, `hr_attendance_total_duration`, `hr_attendance_type`, `hr_attendance_status`, `hr_attendance_entered_by`, `hr_attendance_date_time`, `user_shift_id`, `shift_start_time`, `shift_end_time`, `max_allowed_login_duration`, `user_name`, `hr_employee_name`, `hr_employee_code`, `hr_employee_status`, `hr_employee_week_off`, `hr_attendance_type_name`, `hr_attendance_type_short_code`, `hr_employee_department`\n    FROM hr_attendance_view\n    WHERE Date(hr_attendance_date) > '2020-02-29' AND hr_employee_status = '1' AND hr_attendance_date >= hr_employee_employment_date\n    ORDER BY hr_attendance_date ASC\n    \n    ","aaData":[],"totalPresent":0,"totalAbsent":0,"totalHalfDay":0,"totalWeekOffDay":0,"totalPublicHoliday":0,"totalCompOff":0,"totalEarnedLeave":0,"totalSickLeave":0,"totalPayable":0}