{"iTotalDisplayRecords":"2","query":"\r\n    SELECT SQL_CALC_FOUND_ROWS `shift_id`, `shift_name`, `shift_nick_name`, `shift_start_time`, `shift_end_time`, `shift_start_day`, `shift_end_day`, `shift_status`, `shift_start_latitude`, `shift_start_longitude`, `shift_end_latitude`, `shift_end_longitude`, `shift_max_allowed_radius`, `max_allowed_login_duration`, `max_allowed_logout_duration`, `added_by`, `added_on`, `added_by_usere_name`\r\n    FROM employee_shift_view\r\n    \r\n    ORDER BY shift_start_time ASC\r\n    \r\n    ","aaData":[{"shift_id":"2","shift_name":"GS","shift_nick_name":"GS","shift_start_time":"09:30:00","shift_end_time":"18:00:00","shift_start_day":"1","shift_end_day":"1","shift_status":"Active","shift_start_latitude":"","shift_start_longitude":"","shift_end_latitude":"","shift_end_longitude":"","shift_max_allowed_radius":"0","max_allowed_login_duration":"0","max_allowed_logout_duration":"15","added_by":"143620071466608200","added_on":"2023-10-11 11:26:59","added_by_usere_name":"Admin","duration":"8.5 Hours30 Minutes"},{"shift_id":"6","shift_name":"FS","shift_nick_name":"FS","shift_start_time":"09:30:00","shift_end_time":"18:00:00","shift_start_day":"1","shift_end_day":"1","shift_status":"Active","shift_start_latitude":"","shift_start_longitude":"","shift_end_latitude":"","shift_end_longitude":"","shift_max_allowed_radius":"0","max_allowed_login_duration":"0","max_allowed_logout_duration":"15","added_by":"143620071466608200","added_on":"2023-10-28 15:27:05","added_by_usere_name":"Admin","duration":"8.5 Hours30 Minutes"}]}